MRP stands for material requirements planning, and under the name it's four sums done in order. What do I plan to make? Multiply that by each recipe to get what I need. Take away what I have and what's already on order to get what to buy. Then count back from the day you need it by each supplier's lead time to get when to order. A reorder level waits until a shelf looks low. MRP looks at next week's plan and tells you today that the bags won't arrive in time. For a business with a handful of products and one level of recipe, the whole thing fits on a spreadsheet. Below is one for a made-up granola maker, each sum worked through, and the file.
The short version
- Start from the plan: how many batches of each product, and for which day.
- Needed = batches × the recipe's quantity, added up across products.
- To buy = needed − on hand − on order, never below zero.
- Round up to whole packs: you can't buy 18 lb from a 25 lb case.
- Order by = the day you need it − the supplier's lead time.
- Read the order-by dates against today. Anything already past is the problem to solve first.
- TaroStack works this out from your recipes and stock, on Growth. More below.
Step 1: the plan and the recipes
This maker plans ten batches for the week of November 30. Each batch makes 40 bags.
| Product | Batches | Oats | Sweetener | Nuts | Oil | Bags |
|---|---|---|---|---|---|---|
| Honey Almond, per batch | 20 lb | 6 lb honey | 5 lb almonds | 2 lb | 40 | |
| Maple Pecan, per batch | 20 lb | 5 lb maple syrup | 6 lb pecans | 2 lb | 40 | |
| Honey Almond, planned | 6 | 120 lb | 36 lb | 30 lb | 12 lb | 240 |
| Maple Pecan, planned | 4 | 80 lb | 20 lb | 24 lb | 8 lb | 160 |
Oats, oil and bags are in both products, so their needs add up: 200 lb of oats, 20 lb of oil, 400 bags. A recipe written as a list of materials and quantities is a bill of materials: see bill of materials for food. Making the plan itself is in how to prepare a production plan.
Steps 2 to 4: the material plan
| Material | Needed | On hand | On order | To buy | Pack size | Order | Lead time | Order by |
|---|---|---|---|---|---|---|---|---|
| Rolled oats | 200 lb | 120 | 0 | 80 | 50 | 100 lb | 5 days | Nov 25 |
| Honey | 36 lb | 40 | 0 | 0 | 60 | 0 | 7 days | |
| Almonds, sliced | 30 lb | 12 | 0 | 18 | 25 | 25 lb | 7 days | Nov 23 |
| Maple syrup | 20 lb | 8 | 0 | 12 | 11 | 22 lb | 10 days | Nov 20 |
| Pecan pieces | 24 lb | 30 | 0 | 0 | 30 | 0 | 7 days | |
| Sunflower oil | 20 lb | 25 | 0 | 0 | 35 | 0 | 5 days | |
| Bags, 12 oz | 400 | 250 | 100 | 50 | 500 | 500 | 14 days | Nov 16 |
To buy is needed, less on hand, less anything on order that will arrive in time. Honey, pecans and oil are covered, so they drop out.
Order rounds up to what the supplier sells. Eighteen pounds of almonds becomes a 25 lb case. Twelve pounds of maple syrup becomes two 11 lb jugs. Fifty bags becomes a case of 500.
Order by counts back from November 30. Oats take five days, so they're ordered by the 25th. Bags take fourteen, so they should have been ordered by the 16th.
Reading it
This plan was made on November 19. Three things follow.
- The bags are late. The order-by date passed three days ago. With 250 on hand and 100 arriving, there are bags for 350, which is eight full batches, not ten.
- The maple syrup is due tomorrow. Order it today.
- Oats and almonds have a few days, and can go on one order to the same week's truck.
So the choice is plain while it's still a choice: make eight batches on the 30th, or pay to get bags sooner. Found out on the 27th, it's a line stopped and two batches of oats already toasted with nowhere to go.
That's all MRP is. The lead time sum is in lead time calculation formula, and choosing how much to make at once in lot for lot vs fixed batch size.
What a sheet like this leaves out
- Sub-recipes. If the granola used a house-made caramel, the caramel's ingredients would need their own pass first.
- More than one week. Next week's needs change what's worth ordering now.
- Safety stock. The sheet buys exactly what the plan needs. A cushion is in safety stock formula.
- Yield. A batch that loses 3% in the oven needs 3% more going in.
- Dates. It counts 30 lb of pecans as usable without asking when they expire.
Get the template
Download the MRP spreadsheet template. Two sheets and a read-me: the material plan, which works out what to buy, the order quantity in whole packs and the order-by date, and the recipes and plan it's built from. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The sheet needs three things typed in fresh every time: the plan, what's on hand, and what's on order. On hand is the hard one. If it comes from a count two weeks old, the sums are exact and the answer is wrong. And the first column is typed from the recipes by hand, so a recipe that changed in the kitchen and not in the sheet orders the wrong amount without a sign that anything's off.
How TaroStack does it
TaroStack does these sums from the recipes and stock it already holds.
Planning, on Growth, says what to make and what to buy, and when. Every suggestion is a draft you approve.
Needs come from your recipes, sub-recipes included, by weight and with unit conversion.
On hand is current, because receiving, batches and counts keep it so. Planning is shelf-life aware: stock that will expire before it's used isn't counted on.
Supplier lead times and minimums are on each supplier, so an order-by date is worked out, not remembered.
Exceptions in plain words: what will run short, arrive too late, or expire before it's used.
| The sum | Spreadsheet | In TaroStack |
|---|---|---|
| What the plan needs | Typed from the recipes | From the recipes themselves |
| What's on hand | The last count | Kept current, by lot and date |
| What to order, by when | Read the dates yourself | Drafts to approve, with what's late |
| A recipe with a sub-recipe | A second sheet | Worked through |
Planning is on Growth at $39 a month (50 recipes) and above. Recipes, batches, stock and the reorder list are on every plan, from $9.99 a month (5 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.
