A meal prep business knows something most kitchens don't: exactly how many of each meal it will cook, days ahead, because the orders are in. So its inventory list does a different job. It still has a row for each ingredient and each kind of packaging, with what's on hand, what it cost and a level to reorder at. But the useful sum is orders × recipe = what this cook needs, set against what's in the walk-in. That turns the list into a shopping list with no guessing in it. The other thing it carries is dates: raw chicken delivered Saturday has days, not weeks. Below is a list for a made-up kitchen that cooks 300 meals a week, Monday's needs worked out, and the file.
The short version
- One row for each ingredient and each container, in the unit you buy.
- Needs = meals ordered × what the recipe uses, raw weight.
- Compare needs with on hand before you order, not after.
- Every delivery of protein gets a use-by date.
- Containers and labels stop a cook as surely as chicken does.
- Reorder levels are one cook day's use.
- TaroStack says how many meals the stock on hand allows. More below.
An example list
Counted on a Sunday night.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Chicken breast | lb | 80 | 60 | $3.20 | $256.00 | OK |
| Ground turkey | lb | 30 | 40 | $3.90 | $117.00 | REORDER |
| Salmon fillet | lb | 18 | 15 | $9.50 | $171.00 | OK |
| Brown rice | lb | 50 | 25 | $0.90 | $45.00 | OK |
| Broccoli | lb | 36 | 30 | $1.50 | $54.00 | OK |
| Meal containers, 3 compartment | each | 420 | 500 | $0.31 | $130.20 | REORDER |
Ten rows in all, $960.20 on hand, with two to reorder: ground turkey and containers.
What Monday needs
Monday's orders: 70 chicken teriyaki bowls, 50 turkey and sweet potato bowls, 40 salmon and quinoa bowls.
| Ingredient | In one meal, raw | Monday needs | On hand | Left after |
|---|---|---|---|---|
| Chicken breast | 0.42 lb in 70 meals | 29.4 lb | 80 lb | 50.6 lb |
| Ground turkey | 0.40 lb in 50 meals | 20.0 lb | 30 lb | 10.0 lb |
| Salmon fillet | 0.38 lb in 40 meals | 15.2 lb | 18 lb | 2.8 lb |
| Brown rice, dry | 3 oz in 70 meals | 13.1 lb | 50 lb | 36.9 lb |
| Broccoli | 0.20 to 0.25 lb in all 160 | 35.5 lb | 36 lb | 0.5 lb |
| Meal containers | 1 in 160 meals | 160 | 420 | 260 |
Three things come out of this table that the inventory list alone doesn't show.
Broccoli. The list says OK: 36 pounds against a reorder level of 30. Monday uses 35.5. There's half a pound to spare, and Thursday's 140 meals need about 30 more. It has to be on Tuesday's order, whatever the status column says.
Raw weight. A cooked 5 oz portion of chicken starts as about 6.7 oz raw in this kitchen. The recipe and the order sum are both in raw weight, because that's what's bought. A list in cooked portions will always come up short.
Containers. After Monday there are 260. Thursday takes 140. That leaves 120 for the week after, which needs 300. The reorder flag is right, and the supplier takes a week.
Dates
| Received | Item | Lot or invoice | Quantity | Use by | Note |
|---|---|---|---|---|---|
| Nov 12 | Ground turkey | Case lot 26316 | 30 lb | Nov 19 | Use first: Monday's turkey bowls |
| Nov 14 | Chicken breast | Case lot 26318 | 80 lb | Nov 21 | Monday and Thursday |
| Nov 14 | Salmon fillet | Inv. 8841 | 18 lb | Nov 17 | Cook Monday |
| Nov 14 | Broccoli | Inv. 5520 | 36 lb | Nov 20 |
The dates are this kitchen's own use-by for each delivery. Salmon that arrives Saturday is cooked Monday. If Thursday's menu has salmon, it's a Wednesday delivery.
Write the case's lot number down when it comes in. If the meat distributor recalls a lot, the question is which meals it went into and who has them, and the answer starts here. How long cooked meals keep is in meal prep shelf life, and dating food in the walk-in in date marking under the Food Code.
Pricing the meals is in how to price meal prep, and the cook day's task list in prep list template.
Get the list
Download the meal prep inventory list. Four sheets: inventory with value and REORDER, deliveries with days left, 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 needs table is three menu items. A real week has eight, with two sauces and a rotating vegetable, and the orders close at noon on Saturday. Working out eight recipes times their order counts, by ingredient, and subtracting what's on hand is an hour with a calculator, every week, done by the one person who also has to do the shopping.
How TaroStack does it
TaroStack does the multiplication.
Each meal is a recipe by weight, with sauces as sub-recipes. Units convert, so chicken bought by the case and portioned by the ounce is one item.
"What could I make right now" says how many of each meal the stock on hand allows, and which ingredient runs out first.
Record the cook and its ingredients come off stock. Each batch notes the lots it used, automatically.
Each delivery is a lot with its use-by, the oldest goes out first by default, and an alert comes before a date arrives.
A reorder list in days of cover, with each supplier's lead time.
| The job | List and a calculator | In TaroStack |
|---|---|---|
| Enough broccoli for Monday and Thursday | A sum for each recipe | What could I make right now |
| Take chicken off after the cook | A recount | Recorded with the batch |
| Which meals used a recalled case | Unknown | The lots on each batch |
| Containers before they run out | When the shelf looks low | The reorder list |
TaroStack doesn't take the meal orders or plan delivery routes. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes, with allergen tracking). 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.
