Skip to content

Store-to-Store Inventory Transfer ROI Calculator

Estimate the profit from moving stock between stores. Compare expected sales at both locations and see whether the move earns enough to cover its cost.

Your inputs

View results

Enter uncommitted units available at the store that would send stock.

Enter uncommitted units available at the store that needs stock.

Estimate unit sales if the item is available throughout the planning period.

Estimate unit sales during the same period, accounting for local promotions.

Use expected selling price after discounts minus product cost.

Use the price customers are likely to pay at this store, minus product cost.

The estimate uses up to the sending store’s sellable units.

Include the transport, packing, and handling expenses this move adds.

Example results

Estimated incremental profit
$192

Gross profit gained minus gross profit displaced and the cost of moving stock.

Units transferred
6 units

The proposed quantity up to the sending store’s available units.

Added sales at receiving store
6 units

Expected sales the store can make with the transferred stock.

Displaced sales at sending store
0 units

Expected sales the sending store would miss because of the move.

Return on transfer cost
1,066.67%

Estimated incremental profit as a percentage of the transfer cost.

At these inputs, the transfer adds profit after covering the cost of the move.

Use one SKU and a shared planning period. The estimate assumes the stock reaches the receiving store in time to cover the demand entered.

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.