An order guide is the list of everything a restaurant buys, grouped by supplier, with one number beside each item: its par. Par is how much you want on the shelf just after a delivery. Ordering then takes no judgment: count what's on hand, and order par minus on hand, rounded up to whole cases. The skill is all in setting the par, and that's a sum too: what you use a day, times the days the order has to last, plus a safety share. A guide like that lets anyone place the order, which is the reason to have one. Below are the sums, a guide for a made-up restaurant, and a file that works out pars and orders from what you type.
The short version
- One row an item, in the unit you order it by, grouped by supplier.
- Par = used a day × days to cover × (1 + safety).
- Order = par − on hand, rounded up, never less than zero.
- Days to cover is the gap until the delivery after this one.
- Recheck pars each season and before holidays.
- TaroStack builds the order from real usage and what's on the shelf. More below.
A guide
A made-up restaurant. Safety share: 25%.
| Item | Supplier | Ordered by | Used a day | Days to cover | Par | On hand | Order | Price | Total |
|---|---|---|---|---|---|---|---|---|---|
| Chicken thighs | Broadline | 40 lb case | 0.8 | 4 | 4 | 1.5 | 3 | $92.00 | $276.00 |
| Ground beef 80/20 | Broadline | 10 lb chub | 2.5 | 4 | 13 | 4 | 9 | $41.00 | $369.00 |
| Canola oil | Broadline | 35 lb jug | 0.4 | 4 | 2 | 3 | 0 | $38.00 | |
| All-purpose flour | Broadline | 50 lb bag | 0.3 | 4 | 2 | 1 | 1 | $21.50 | $21.50 |
| Romaine | Produce | case of 24 | 0.6 | 3 | 3 | 0.5 | 3 | $34.00 | $102.00 |
| Yellow onions | Produce | 50 lb sack | 0.25 | 3 | 1 | 1.5 | 0 | $26.00 | |
| Whole milk | Dairy | gallon | 3 | 3 | 12 | 4 | 8 | $4.10 | $32.80 |
| Heavy cream | Dairy | quart | 2 | 3 | 8 | 9 | 0 | $5.40 | |
| Burger buns | Bakery | dozen | 6 | 2 | 15 | 5 | 10 | $5.75 | $57.50 |
This order comes to $858.80.
Setting a par
Take the ground beef.
| Used a day | 2.5 chubs |
| Days the order has to cover | 4 |
| Needed | 10 chubs |
| Plus 25% safety | 12.5 |
| Par, rounded up | 13 |
Used a day comes from your own records: a month's purchases divided by the days you were open, or better, a count at the start and end of a week. Not from memory.
Days to cover is the trap. It isn't the time until the next delivery. It's the time until the delivery after this one arrives, because this order has to last until then. The broadline truck comes Tuesday and Friday, so a Friday order has to cover Friday night to Tuesday morning: four days.
Safety covers a busy night, a short delivery and a dropped case. Twenty-five percent is this kitchen's figure. Fresh fish wants less safety and more frequent orders. Flour can carry more.
Reading the order
Over par is information. Heavy cream: par 8, on hand 9, order 0. One over is nothing. Twenty over means the par is wrong, somebody double-ordered, or a menu item stopped selling.
Half a case. Romaine shows 0.5 on hand and an order of 3: par 3 less 0.5 is 2.5, rounded up. Count open cases as fractions. Rounding the count down to zero orders too much every week.
Zero is an answer. Three rows order nothing. A guide that orders something on every line every time has pars set by habit.
Keeping pars honest
| When | Do |
|---|---|
| A new menu | Reset the pars for everything it touches |
| A season changes | Patio weather moves burger buns, not flour |
| Before a holiday | Change days to cover: the truck may skip a day |
| Something keeps running out | Raise its par, and find out why |
| Something keeps going in the bin | Lower its par, or order it more often in smaller amounts |
Review all of it four times a year. Pars drift because sales do. The reasoning behind safety stock is in how much inventory to keep on hand, and what the orders should add up to as a share of sales in what is a good food cost percentage.
Walk order
List the items in the order you walk the kitchen: dry storage, walk-in, freezer, line. The count that feeds the guide is then one lap with a clipboard. A shelf map for the storeroom is in dry storage inventory template, and the daily sheet that turns stock into prep in prep list template.
Get the template
Download the restaurant order guide template. Two sheets and a read-me: the order guide, where par, order and line total work themselves out, and a Limits sheet for your safety share. Type used a day, days to cover and on hand. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The guide's weak point is "used a day". It's typed in once and believed for ever. Meanwhile the burger special ends, the chicken sandwich takes off, and the par for ground beef is still set for a menu from the spring. The sheet does its arithmetic perfectly on a number that stopped being true in June.
How TaroStack does it
TaroStack works the usage out from what actually happened.
Usage comes from the records. Receiving puts stock on. Batches and counts take it off. What an item really used last week isn't an estimate.
Reorder points suggested from how stock moves. TaroStack suggests each item's reorder point from its real usage and its supplier's lead time, so the suggestion changes when sales do.
A reorder list in days of cover. What will run out before the next delivery, by supplier, ready to turn into purchase orders.
Suppliers with lead times and minimums. The broadline's Tuesday and Friday, the bakery's daily, the case minimums: on the supplier, not in someone's head.
Purchase orders with approval, and receiving against them, so a short delivery is seen at the door.
| The job | Order guide | In TaroStack |
|---|---|---|
| Used a day | Typed once | From receiving, batches and counts |
| Par | A sum on a stale number | A reorder point suggested from real usage |
| The order | Par less on hand, by hand | The reorder list, by supplier |
| A short delivery | Found at service | Seen at receiving |
Stock, counting, the reorder list and purchase orders are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
