Multi-warehouse inventory allocation optimization (roughly optimized using shipping coefficient)

multi-warehouse allocation / fulfillment split optimizer

Immediately suggests where and how many items to ship from inventory by warehouse x shipping destination zone x shipping cost coefficient. Instead of exact solutions, we quickly create shipping plans using on-site heuristics.

How to use

Since shipping costs vary depending on the contract, here we enter the "coefficient" to roughly compare (the coefficient is a positive value).

?? (order/inventory/shipping coefficient)

3 steps to complete 1 page. First, please enter your order data.

Ship to zone Voucher/Order ID (optional)

TSV/CSV pasting OK (as is from Excel)

SKU	Required number

Constraints (Partition NG/Maximum number of warehouses/Pick cost)

You can set conditions such as NG to split, maximum number of warehouses, and pick cost by warehouse.

TSV/CSV pasting OK (warehouse, SKU, available quantity)

warehouse	SKU	Available quantity

Proposal results (allocation/shortage/estimated cost)

You can check the results by allocation, cost breakdown, alternatives, and export.

mode per piece Fixed per shipment + per piece

If you want to add fixed costs to the warehouse where the shipment occurs, select "Fixed per shipment + per piece".

TSV/CSV pasting OK (warehouse, zone, shipping coefficient, fixed (optional))

warehouse	zone	Shipping coefficient (>0)	Fixed (optional)

Shipping charges vary depending on the contract. Please enter the coefficient as a "positive value" and use it for relative comparison.

Constraints (optional)

Split NG (shipped only from one warehouse) Maximum number of warehouses

Pick fee by warehouse (optional)

warehouse	Pick fixed	Pick variation (1 piece)

Treatment of coefficients relative comparison Multiplier input for yen conversion Yen/Coefficient

Scroll to results

Proposal results

Recommended number of warehouses

Number of divisions

Estimated cost (total coefficient)

shortage

Possibility when division is not successful: -

Allocation results (by SKU)

How to use and think about it (heuristic)

This tool uses fast heuristics that are easy to use in the field, rather than rigorous mathematical optimization, to roughly estimate the "shipping coefficient + pick cost" and propose shipping quantities for each warehouse. Allocates each SKU to a low-cost warehouse while prioritizing constraints such as division failure and maximum number of warehouses. Since contracted freight charges vary by company, please enter the shipping cost as a "coefficient (positive value)" and use it as a relative comparison.

?? ?? ??

Is it perfect optimization (mathematical optimization)?

First, we will make a proposal quickly using realistic heuristics.

I would like to avoid split shipments.

Candidates can be narrowed down using the "??? splitting" constraint. If it is not possible to meet the requirements, the missing SKU/number will be displayed and a plan for allowing splitting will also be presented.

I would also like to include a pick fee for each warehouse.

We have fixed/variable cost columns by warehouse. The details will be displayed separately from the shipping charges.

In order to speed up decision-making regarding inventory allocation, first compare based on the shipping cost coefficient, and use the actual shipping cost as necessary.