A barbecue restaurant buys by the raw pound and sells by the cooked one, and in this page's example more than half the weight disappears in between. That's what makes its inventory different from any other kitchen's. The list is short: a few meats, wood, butcher paper, rub, sauce and buns. But the meat has to be ordered days ahead, it goes on the pit the night before anyone eats it, and a pound on the shelf isn't a pound on the tray. So a BBQ inventory sheet does three jobs: it lists what's on hand at cost, it tracks use-by dates on raw meat, and it carries the restaurant's own yield, so that "how much brisket do we have" can be answered in portions. Below is a sheet for a made-up restaurant, the yield sum, and the file.
The short version
- Count meat raw, by the pound, as it's bought.
- Write each case's use-by date and code, and use the oldest first.
- Weigh one cook from raw to sliced, and keep the yield.
- Order from portions back to raw pounds, using that yield.
- Wood is inventory. Running out stops the pit as surely as running out of meat.
- Count on the same night every week.
- TaroStack keeps meat by lot and date and counts on a phone. More below.
An example sheet
Counted on a Sunday night.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Brisket, whole | lb | 180 | 150 | $4.35 | $783.00 | OK |
| Pork butt, bone-in | lb | 140 | 120 | $2.10 | $294.00 | OK |
| Pork spare ribs | lb | 90 | 100 | $3.40 | $306.00 | REORDER |
| Chicken, whole | lb | 60 | 50 | $1.65 | $99.00 | OK |
| Sausage links | lb | 35 | 30 | $4.90 | $171.50 | OK |
| Wood, hickory splits | bundle | 40 | 60 | $6.50 | $260.00 | REORDER |
Ten rows in all, $2,301.90 at cost, with three to reorder: ribs, wood and buns. The five meats are $1,653.50 of it. The prices are made up: use your own invoices.
The yield sum
One Friday this restaurant weighed a cook from the case to the cutting board.
| Four briskets | Weight |
|---|---|
| Raw, out of the bag | 62.0 lb |
| Trimmed, going on the pit | 51.5 lb |
| Cooked, rested and sliced | 28.4 lb |
| Yield of raw weight | 45.8% |
The trim took 10.5 lb and the cook another 23.1 lb. What reached the board was 45.8% of what was paid for. That number is this restaurant's, from its own trim and its own pit. Yours will differ, which is the reason to weigh a cook of your own.
Three things follow from it.
What a cooked pound costs. The 62 lb cost $269.70 at $4.35 a pound. Divided by 28.4 cooked pounds, that's $9.50 a pound on the board, more than twice the price on the invoice.
What a portion costs. At 6 oz a portion, 28.4 lb is 75 whole portions, at $3.60 each before the bun, the sauce and the paper.
How much to order. A Saturday that sells 100 portions of brisket needs 37.5 cooked pounds, which is 81.9 lb raw at this yield. Ordering 60 lb because "we sell about forty pounds" is how the brisket runs out at one o'clock. The same test for a butcher's cuts is in butcher yield test.
Dates on the meat
| Received | Item | Case code | Quantity | Use by | Note |
|---|---|---|---|---|---|
| Nov 16 | Brisket, whole | 6318 | 160 lb | Nov 30 | |
| Nov 17 | Pork butt, bone-in | 6320 | 120 lb | Dec 1 | |
| Nov 14 | Pork spare ribs | 6316 | 100 lb | Nov 24 | Use first |
The dates are the ones on this restaurant's own cases. Write down what's printed on yours. The ribs are the oldest and the nearest their date, so they go on first, even though the count says ribs are also the item to reorder. Both are true: use what's here, and order more.
A walk-in list by shelf is in walk-in cooler inventory sheet, and a whole kitchen's in food inventory template. The pit's own record is in smokehouse log.
Wood, paper and buns
Wood is the item barbecue places forget to count, because it lives outside. This restaurant burns about twenty bundles a week, its supplier takes two weeks to deliver, and it keeps a week's cushion, so its level is 60: forty is a reorder. Butcher paper and buns are small money and they stop service just the same.
Get the sheet
Download the barbecue restaurant inventory. Four sheets: inventory with value and REORDER, deliveries with case codes and use-by dates, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The sheet says 180 lb of brisket. It doesn't say that 60 lb of it went on the pit at ten last night and is, as of this morning, about 27 lb of something worth three times as much. Raw, on the pit, resting, held, sold: the same meat is in five states in two days, and a list with one row for brisket can only be right about one of them.
How TaroStack does it
TaroStack treats a cook as a batch that turns raw meat into cooked.
Receiving records each case as a lot, with its code, its use-by date and what you paid.
A cook is a batch. Record it and the raw brisket comes off stock, by lot, and cooked brisket goes on. The batch notes which lots it used, automatically.
Actual against standard. The batch shows what the cook really cost beside what the recipe expects.
Oldest first, with an alert before a use-by date arrives.
A reorder list in days of cover, with each supplier's lead time, wood included.
| The question | Spreadsheet | In TaroStack |
|---|---|---|
| How much cooked brisket is there | Not on the sheet | Its own stock |
| What last night's cook cost | Work it out by hand | Actual against standard |
| Which case is nearest its date | Read the labels | An alert |
| When to order wood | When the rack looks thin | Days of cover |
TaroStack doesn't run the till or take temperatures. It connects to Square. Recipes, batches, lots and reordering are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
