Start with an inventory count at each wrapping bench. Use one unit throughout the worksheet, such as sheets or sleeves. Count the stock that staff can actually use, including opened packs if the remaining pieces can be counted. Leave damaged pieces and stock reserved for a named job out of that count. Use the same planning period for all locations.
Allocate the net shortfall first
For each location, subtract usable stock from expected use plus its local reserve. If the result is below zero, the location has no shortfall for this purchase. Confirm whether the supplier sells by pack or by carton, then round the combined shortfall to that sales unit.
Suppose shop A needs 85 sheets including reserve and has 20 usable sheets. Shop B needs 45 and has 10. The shortfalls are 65 and 35, or 100 sheets in total. If the confirmed unit is 25 sheets per pack, order four packs. If the warehouse can open packs, it can dispatch 65 and 35 sheets. If shops receive only sealed packs, one practical split is three packs for A and one for B. The sheet should show the resulting 10-sheet surplus at A and 10-sheet gap at B, with an agreed transfer or extra pack.
Reconcile the actual delivery
Give every transfer a SKU, finish, pack count, equivalent piece count and destination. Record how many usable units each location received, who counted them and whether some stock stays at the warehouse. If the order arrives short, protect confirmed customer commitments first, then redistribute the rest against the updated shortfalls.
Should each store round up separately?
Round by the smallest unit you can distribute. If you can split packs centrally, round at order level and allocate in pieces. If the shops require sealed packs, show each location’s pack requirement before ordering and record who owns any extra stock.
Seasonal stock planning · Packaging storage · Request a wholesale quote