# Branch Transfer Planning Worksheet > Source: https://netray.co/tools/branch-transfer-planning-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Decide how much stock to move between branches by comparing what the destination needs with what the source can spare, and see the transfer value. ## Category supply-chain ## Industry Wholesale Distribution ## Audience - Inventory manager - Branch manager - Logistics coordinator ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Item **Key:** sku **Type:** text #### From branch **Key:** from_br **Type:** text #### To branch **Key:** to_br **Type:** text #### On hand at source **Key:** on_from **Type:** number #### Source minimum to keep **Key:** keep_from **Type:** number #### On hand at destination **Key:** on_to **Type:** number #### Destination daily usage **Key:** use_to **Type:** number #### Target days of supply **Key:** tgt_days **Type:** number #### Unit cost **Key:** cost **Type:** number **Format:** currency #### Suggested transfer **Key:** xfer **Type:** number **Expr:** ceil(min(max(use_to * tgt_days - on_to, 0), max(on_from - keep_from, 0))) **Format:** integer #### Transfer value **Key:** xval **Type:** number **Expr:** ceil(min(max(use_to * tgt_days - on_to, 0), max(on_from - keep_from, 0))) * cost **Format:** currency **Rows:** **Sku:** HYD-HOSE-3/8 **From br:** Houston **To br:** Dallas **On from:** 420 **Keep from:** 150 **On to:** 40 **Use to:** 9 **Tgt days:** 30 **Cost:** 6.8 **Sku:** BRG-6205-2RS **From br:** Dallas **To br:** Austin **On from:** 260 **Keep from:** 120 **On to:** 35 **Use to:** 4 **Tgt days:** 30 **Cost:** 3.45 **Sku:** FST-HEX-M10 **From br:** Houston **To br:** San Antonio **On from:** 5200 **Keep from:** 2000 **On to:** 600 **Use to:** 85 **Tgt days:** 21 **Cost:** 0.18 **Sku:** GLV-NIT-L **From br:** Austin **To br:** Dallas **On from:** 80 **Keep from:** 60 **On to:** 15 **Use to:** 6 **Tgt days:** 30 **Cost:** 1.9 **Sku:** PWR-CORD-12AWG **From br:** Dallas **To br:** Houston **On from:** 190 **Keep from:** 100 **On to:** 110 **Use to:** 3 **Tgt days:** 30 **Cost:** 14.25 **Totals:** #### Total units to transfer **Key:** xfer **Agg:** sum **Format:** integer #### Total transfer value **Key:** xval **Agg:** sum **Format:** currency #### Lines planned **Key:** sku **Agg:** count **Format:** integer **Summary:** #### Average value per transfer line **Key:** avg_val **Expr:** sum_xval / max(count, 1) **Format:** currency **Notes:** The suggested transfer is the lesser of what the destination needs to reach its target days of supply and what the source can release above its minimum. Factor in freight cost, vendor pack sizes and special-order allocations before creating the actual transfer orders in your ERP. ## Content **Intro:** Dead stock at one branch and stockouts at another is the classic multi-location distributor problem. Moving stock between branches is often cheaper than buying new, but only if you know how much to move. This worksheet calculates that quantity per item and totals the value so you can approve the plan quickly. **Sections:** #### How to use the worksheet **Body:** For each item, enter the source and destination branch, on-hand quantities, the minimum the source should keep, the destination's daily usage, and the target days of supply you want at the destination. The sheet suggests a transfer quantity and its value. Add rows for every imbalance you find in your inventory by location report, review totals, then export to Excel and use it to create transfer orders in Prophet 21, Eclipse or your own ERP. #### The logic behind the suggestion **Body:** The destination need is daily usage times target days of supply, less what it already has, floored at zero. The source availability is its on-hand less the minimum it must keep, also floored at zero. The suggested transfer is the smaller of the two, rounded up to whole units. This protects the source from being stripped of stock and keeps the destination from receiving more than it will use within the target period. #### When to transfer versus buy **Body:** Compare the freight and handling cost of the transfer with the saved purchase and the cost of a lost sale. Small, cheap items rarely justify a dedicated truck, while high value items usually do. Consider consolidating transfers onto scheduled delivery routes. If a branch regularly needs stock from another, that is a sign the stocking levels at each location need review, rather than a permanent transfer habit. **Bullets:** - Weigh freight and handling against purchase cost - Use existing delivery routes where possible - Check for open orders or allocations on source stock - Review stocking levels if the same item keeps moving #### Common mistakes **Body:** Ignoring open allocations at the source can leave a branch short on stock it has already promised. Transferring to fix a symptom, such as a stockout caused by a wrong order point, keeps repeating the problem. Not accounting for in-transit quantities causes duplicate transfers. Finally, avoid moving slow items just to make a location look cleaner, since you may simply move the dead stock rather than reduce it. **Cta:** If you want transfer suggestions generated daily from live inventory by location, we can build a read-only recommendation view over your ERP data for your inventory team to approve. **Faq:** #### How do I choose target days of supply? **Answer:** Base it on the item's lead time, review cycle and variability. A reasonable starting point is the replenishment cycle plus a safety margin. Fast items might target a few weeks, slow items a month or more, depending on cost to hold. #### Why keep a minimum at the source? **Answer:** Without it, a transfer could strip the source branch and create a stockout there. The minimum should cover the source's own lead time demand and any allocated or reserved quantity. #### Does this create transfer orders? **Answer:** No. It is a planning worksheet that exports to Excel. You still create the transfer orders in your ERP, which will handle in-transit status, costing and receiving. #### Should I include in-transit stock? **Answer:** Yes. Add in-transit quantity to the destination on-hand, or you will plan duplicate transfers. Likewise, subtract allocated or reserved quantities from the source on-hand. ## Search terms branch transfer planning, inter branch transfer worksheet, distribution stock balancing excel, p21 transfer order, eclipse branch transfer, inventory rebalancing template, warehouse stock transfer planner, multi location inventory balancing --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json