One order guide per vendor, with cutoff, delivery days, minimum, pack sizes, prices, and delivery-day pars. The CSV includes example items and a blank order column; calculate quantities manually or use the interactive builder below. Keep par and on-hand counts in the same vendor-pack units.
Vendor header: cutoff time, delivery days, order minimum, how the vendor takes orders
Item and vendor SKU — the vendor’s name for it, so the order reads back without translation
Pack size and $ / pack — you order in vendor packs, and price creep needs a written baseline
Par (early week) and par (weekend) — the same item needs different pars per delivery day
On hand and order — filled in during the walk-in count
How to use it
Make one copy per vendor and fill in the header once.
List items in shelf order — the sequence you walk the walk-in, freezer, and dry storage — not alphabetically.
Set pars in vendor packs, one column per delivery-day gap. The Friday par covers the weekend; it is not the Monday par. (Compute them properly with the par level calculator.)
Subtract on-hand from the chosen par, round positive quantities up to whole packs, and enter zero when stock meets the par. Check open orders before sending so you do not buy the same stock twice.
Update prices from invoices at receiving so creep stays visible.
