A restaurant should carry enough stock to get from one delivery to the next with a margin, and no more. The way to turn that into a number is days on hand: what's on the shelves, divided by what you use in a day, both at cost. There isn't one right figure for a whole restaurant, because produce that comes three times a week and canned tomatoes that come once aren't the same problem. So set a target for each category from how often it's delivered and how long it keeps, count, and compare. The made-up restaurant below uses $9,800 of food and drink a week, wants about $8,800 on the shelves, and has $11,130: eight days' worth, with $2,300 of cash sitting in the storeroom that doesn't need to be there. Below are the sums and a sheet.
The short version
- Days on hand = stock ÷ a day's use, at cost.
- Set a target for each category, not one for the building.
- Fresh food: the days between deliveries, plus one. Dry and frozen: a week to ten days.
- Count, work out the days, look at what's over.
- Every dollar over target is cash on a shelf, and some of it will spoil.
- TaroStack works out days of cover from real usage and tells you what to order. More below.
The sum
| Food and drink used a week, at cost | $9,800 |
| Used a day (÷ 7) | $1,400 |
| Stock counted | $11,130 |
| Days on hand | 8.0 |
Use what you used, not what you bought. Used is opening stock, plus purchases, less closing stock: the method is in inventory turnover example. At eight days on hand, this restaurant turns its stock about 46 times a year.
By category
| Category | Used a week | Deliveries a week | Target days | Target stock | Counted | Actual days | Over or under |
|---|---|---|---|---|---|---|---|
| Produce | $1,500 | 3 | 3 | $643 | $520 | 2.4 | -$123 |
| Meat and seafood | $3,400 | 2 | 4 | $1,943 | $2,900 | 6.0 | +$957 |
| Dairy and eggs | $900 | 2 | 4 | $514 | $610 | 4.7 | +$96 |
| Dry goods | $1,800 | 1 | 10 | $2,571 | $4,150 | 16.1 | +$1,579 |
| Frozen | $1,200 | 1 | 10 | $1,714 | $1,650 | 9.6 | -$64 |
| Non-alcohol drinks | $1,000 | 1 | 10 | $1,429 | $1,300 | 9.1 | -$129 |
| All | $9,800 | $8,814 | $11,130 | 8.0 | +$2,316 |
The total says "a bit heavy". The rows say where.
Dry goods: sixteen days against a target of ten. A pallet of fryer oil bought on a deal. The deal may have been real, but $1,579 is on the floor until spring. A discount is worth taking when it beats what that cash would have done elsewhere, and when there's room, and when the product keeps.
Meat: six days against four. Two cases of short rib bought for a special that ended. This is the one that matters, because meat is the most expensive thing in the building and has a date. Run the special again or freeze it this week.
Produce: under. 2.4 days against three. With three deliveries a week that's survivable, and it means the Friday order was tight. One busy night from an 86.
Setting the targets
| Kind of stock | Target days on hand | Why |
|---|---|---|
| Delivered several times a week, keeps for days | The gap between deliveries, plus one | Anything more is waste waiting |
| Delivered twice a week, keeps a week or so | Three to five | The longest gap, plus a margin |
| Delivered weekly, keeps for months | Seven to ten | One cycle, plus a few days in case the truck is late |
| Anything with a long lead time or a minimum | Whatever the minimum forces | Note it, so it doesn't look like a mistake |
These are this restaurant's targets. Yours follow from your delivery days. A place an hour from the nearest distributor carries more than one with a truck at the door every morning, and should.
The margin is for a busy night, a short delivery and a dropped case. How to size it is in how much inventory to keep on hand. Turning a target into an order for each item is restaurant order guide template, and the difference between a par and a reorder point in par level vs reorder point.
What too much costs
Cash. $2,316 over target is $2,316 not in the bank. For a restaurant on thin margins, that's a rent payment's worth of slack.
Waste. Food bought ahead of need spoils ahead of need. The meat row is the one to watch.
Portions. A full walk-in makes generous cooks. When there's plenty, portions creep and nobody notices.
Time. More stock is more to count, rotate and move to reach what's behind it.
What too little costs
Items 86'd on a Saturday, a cook sent to the supermarket to buy chicken at retail, emergency delivery fees, and a menu that guests can't rely on. Running lean on produce with three deliveries a week is sensible. Running lean on your signature protein with one delivery isn't.
Doing it every week
Count on the same day each week, before the main delivery, in shelf order. Enter the totals by category. It's six numbers. Read the last column, and ask one question of each row that's over: what's in there that we don't need? The answer is usually two or three items, and they're usually the same ones.
Get the sheet
Download the restaurant days on hand sheet. Type each category's weekly use, target days and counted stock. It works out the target stock, the actual days on hand and what's over or under, and a Total sheet gives days for all stock, cash above target and turns a year. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Six category totals tell you the meat row is $957 over. They don't tell you it's short rib. To find that out you need the count item by item, with each item's own usage, and a spreadsheet with two hundred rows and a usage figure for each is a job nobody keeps up. So the sheet says "over" every week and the same two cases sit there.
How TaroStack does it
TaroStack works out days of cover for each item from what actually moved.
Usage comes from the records. Receiving puts stock on; batches and counts take it off. What an item used last week isn't typed in.
Days of cover, item by item. The reorder list shows what will run out before the next delivery, and by the same sum, what has weeks on the shelf.
Reorder points suggested from how stock moves, with each supplier's lead time and minimum.
Counting on a phone, in walk order, with no signal in the walk-in. The count suggests what to count first.
Expiry alerts, with what the stock is worth, so the short rib is flagged before its date.
Stock value by site and month, for the accountant's question.
| The job | Six totals | In TaroStack |
|---|---|---|
| Days on hand | By category, weekly | By item, from real usage |
| Which item is over | Go and look | The list |
| What to order | Par less count, by hand | The reorder list |
| What's about to expire | Found too late | An alert |
Stock, counting, the reorder list and expiry are on every plan, from $9.99 a month for 50 items; most restaurants want Growth, at $39 a month for 3,000. 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.
