Pick a category tab and your Outlet, then enter what's on the shelf in On Hand (leave a line blank to skip it; type 0 only if truly empty). The Order column fills in automatically. When done, hit Generate order report → Email order.
Calculation settings
Per-item pars
Leave the Par box blank to use the suggested value (grey). Type a number to override. Adjust Pack to match how your vendor sells it.
Add an item
For well spirits, vermouths, juices/mixers, bitters, NA, or anything not pulled from sales.
Save & share configuration
Your settings, pars, outlet tags and custom items save automatically in this browser. Export a file to back it up or move it to another machine.
How this works
For Erin — the weekly count
- Pick the Outlet you're counting (or leave on All Outlets for a property-wide count). Shared items show up under every outlet.
- Walk the bar / storeroom and type the quantity you have into On Hand. Count in the unit shown (cans, bottles, kegs).
- The Order column fills itself: Par − On Hand, rounded to cases where set.
- Switch category tabs (Beer / Wine / Liquor / Mixers / Garnish) and repeat — a copper number on a tab flags how many lines need ordering there.
- Hit Generate order report → Email order to send it straight to beverage@crossroadshotelkc.com (or Copy / CSV / Print).
For Tyler — the math
Per item: weekly use = sales ÷ window weeks; par = weekly × coverage × (1+safety); spirits get ×(1+uplift). Rounded up, minimum 1 for anything that moves. Anything you type in the Par box overrides the calc.
Defaults: 13-week window, 1.5 weeks coverage, 15% safety, 40% spirit uplift. Floor rules: canned & bottled beer rounds up to multiples of 24 (min 24); kegs sit at a 2 minimum; well spirits round up to multiples of 12 (min 12) and stay out of the slow-mover drawer. Toggle which spirits are well in the per-item table. Everything else carries a 2 minimum — except liquor over $80/bottle and wine over $150/bottle, which may sit at 1. That reads each bottle’s price (the $/btl box on wine & spirit rows, pre-filled from the 5/31 audit cost); edit a price and the floor lifts automatically. By audit cost nothing currently clears those lines, so all spirits floor to 2 today. By-the-glass wines are set to a flat par of 24, ordered in cases of 12. Fever-Tree mixers carry a 48 minimum, ordered in cases of 24; other juices sit at 6. Mixers & garnish are manually set (no sales feed) — adjust their starting pars and add your own. The relative pars are right regardless of the window — only the absolute level moves with it.
To make it sharper, feed me
- Outlet-tagged sales (Toast → by revenue center) so each bar gets its own true pars instead of property-wide.
- Cocktail recipes / build specs so base-spirit, vermouth, liqueur & modifier depletion is exact instead of an uplift estimate.
- Vendor order guides for real pack sizes & par-by-vendor grouping.