This worksheet calculates actual pack purchases for a stated planning period. It replaces the old scored estimator: headcount or a maintenance-friction score does not establish how many units are in stock, how many packs to buy or the price of that order.
OPERATIONS HANDBOOK / WORKSHEET
Office consumables pack and order cost
Plan one combined order from observed consumption, current stock and actual pack prices. Keep units consistent within each item and one currency across all prices.
At 120 units needed, zero stock and 50-unit packs, buy 3 packs and retain 30 units. Values below are editable examples.
Enter the worksheet inputs.
Use anonymous labels and your own observations. Entries remain in this open page, with no account, upload, automatic storage or messaging. Export or print before closing if you need a copy.
One row is one supply item
Enter an anonymous item label, observed units consumed per week, current usable stock, units in one purchasable pack and the actual price of that pack. Keep each item’s unit consistent. If a pack contains sheets, demand and stock must also be in sheets; if it contains liters, use liters throughout that row.
Required units are weekly use × planning weeks. Net new units needed are max(0, required units − current stock). The number of packs is the ceiling of net needed units divided by units per pack. Stock is subtracted once, before pack rounding.
For the editable example, 30 units per week for four weeks requires 120 units. With zero current stock and 50-unit packs, three packs supply 150 units, leaving 30 at the end of the period. At a hypothetical 12 per pack, merchandise cost is 36 and the pack’s unit price is 0.24. These are not retailer quotes or office measurements.
Read the leftovers and the delivery assumption
End stock is current stock plus purchased units minus planned consumption. When current stock already covers the period, no new pack is required. The worksheet keeps any unused stock in the end balance; it does not charge for it again.
The one entered delivery charge applies once to the combined order, and only if at least one item needs a pack. This does not model multiple merchants, separate shipments, taxes, free-delivery thresholds, minimum order values, damaged units or substitution. Use separate scenarios when the ordering arrangement differs.
Cost is separate from a reorder policy
A four-week supply estimate does not establish a safe lead time, safety stock or service level. Review observed demand, supplier lead time, demand variation and the consequences of running out separately. For shipping-label purchases, the label-printer comparison explains stock compatibility; the cost worksheet cannot decide which roll fits your printer.
Method and limits
The arithmetic is original reader-input order planning, not a product or accounting-system test. Up to 50 item rows share one planning duration and one currency; no exchange-rate conversion or item database is supplied. Compare the result with actual purchase and stock records before placing an order. This tool does not submit an order, open a merchant account or upload inventory data.