Why use this calculator?
A popular shoe size can run out at one store while it sits on the shelf at another. Moving a few pairs may recover sales faster than a supplier delivery. The value depends on how much more the receiving store can sell, how much demand remains at the sending store, and what it costs to move the stock.
Use this calculator before approving a transfer or committing to a reorder. Start with a single SKU where both stores have reliable inventory counts. Compare smaller and larger shipments to see when adding units stops helping the receiving store or starts creating a shortage at the sending store.
How this calculator works
Enter available units and forecast demand for both stores over the same selling period. The calculator limits transferred units to sellable stock at the sending store. Added sales at the receiving store are the smaller of units moved and the receiving store’s expected shortage. Displaced sales at the sending store are the units moved beyond its expected surplus. A positive move uses the full transfer cost you enter.
Incremental profit = (added sales × receiving gross profit per unit) − (displaced sales × sending gross profit per unit) − transfer cost.
Return on transfer cost is incremental profit divided by transfer cost, multiplied by 100. The rate measures the return on the cost of moving inventory you already own.
In an illustrative example, North Store expects to sell ten pairs of one running shoe size before its next delivery and has four ready to sell. West Store has 16 pairs and expects to sell ten. Sending six pairs lets North cover six extra sales while West keeps enough for its forecast. At $35 gross profit per pair and $18 to move the stock, the business could gain $192 in incremental profit.
The estimate depends on the stock arriving in time. Before dispatching, compare the arrival date with any promotions, new purchase orders, and the sales window for that item. Inventory transfer example in Sqquid’s retail forecasting guide
Who this calculator is for
Store managers and inventory planners can use it to compare transfers for particular sizes, colors, or seasonal products. It helps regional teams explain why one store should send stock and what demand the sending store still needs to cover.
Buyers can use the estimate when deciding whether to move stock, wait for an incoming delivery, or place another order. Ecommerce and fulfillment managers can also use it when store inventory serves online orders or pickup and the transfer would free up stock at a location with more immediate demand.
Frequently asked questions
Which planned sales belong in the estimate?
Use the expected unit demand for the same SKU and planning period at both stores. Include local online orders or pickups if they use that store’s stock. Count each expected sale once, and account for days when the item was previously unavailable.
What counts as sellable stock for a transfer?
Count units that are ready to sell and free to use. Exclude damaged units, customer reservations, and units already assigned to another transfer. Check that the counts are current before you dispatch.
How do I estimate gross profit per unit at each store?
Subtract product cost from the net selling price you expect customers to pay. Use each store’s likely price after promotions and markdowns. Enter a negative amount when the expected selling price is below cost.
What transfer costs should I enter?
Include the additional expense created by the move, such as parcel charges, packaging, and time for picking, packing, or receiving. For a scheduled store delivery, count the cost of any extra handling or transport the transfer adds.
How does the calculator count sales at the sending store?
It compares the sales the sending store can cover before and after the move. If the store was already short by three units and the transfer increases that shortage to five, the estimated displaced sales are two units.
What happens if I request more units than the sending store has?
The calculation caps the move at the sending store’s sellable stock. It uses the total cost you entered for any positive transfer. Revise that cost if the smaller shipment changes the quote or handling time.
What if the stock will take several days to arrive?
Estimate the receiving store’s stock on arrival and use the demand it can still serve from that date through the planning period. Protect sending-store demand from the dispatch date onward. Compare transit and receiving time with local selling deadlines.
Why is return on transfer cost unavailable when the cost is zero?
The percentage uses transfer cost as its divisor, so it is undefined at zero. Estimated incremental profit still shows the difference in gross profit between the two stores. A scenario with zero units moved has zero profit change and zero transfer expense.
Should I approve every transfer with a positive return?
Review the estimated profit in dollars and the confidence in the forecast. A small transfer cost can produce a large percentage even when the dollar gain is modest. Check the sending store’s stock buffer and whether the units can arrive before customers need them.
Can I compare a transfer with placing a purchase order?
Calculate the transfer first, then compare the order option using its landed unit cost, delivery date, and minimum order quantity. For goods with a short selling season, check whether each option can cover the demand in time and how much stock would remain afterward.
Important retail metrics
Track these measures by SKU and store to check whether the transfer still makes sense as sales and delivery dates change.
- Projected sending-store surplus
-
Sellable units at the sending store minus expected demand, with a minimum of zero.
Estimate how many units you can move while covering the store’s forecast. Check any separate safety stock target.
- Projected receiving-store shortage
-
Expected demand at the receiving store minus its sellable units, with a minimum of zero.
Identify the demand a transfer could cover if the stock arrives in time.
- Transfer cost per unit
-
Total incremental transfer expense divided by units moved.
Compare the cost of moving small shipments with the cost of consolidating multiple items.
- Transfer lead time
-
Time from dispatch until the stock is received and available for sale.
Check when units will be ready for customers and account for time spent receiving them.
- Incremental profit per unit moved
-
Estimated incremental profit divided by units transferred.
Compare how much expected profit each unit of handling adds across candidate moves.