Skip to content

MRP Spreadsheet Template: What to Buy, and by When

An MRP spreadsheet template for a small maker: batches planned times the recipe, less what's on hand and on order, rounded to packs, with order-by dates.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

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.

  1. 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.
  2. The maple syrup is due tomorrow. Order it today.
  3. 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.

Questions people also ask

What is MRP in simple terms?

Material requirements planning: work out what a production plan needs from the recipes, take away what you have and what's on order, and count back by each supplier's lead time to find when to order.

Can you do MRP in Excel?

Yes, for a few products with one level of recipe. One sheet holds the plan and recipes, another works out what to buy and by when. It gets hard with sub-recipes, several weeks, or stock figures that aren't current.

What's the difference between MRP and a reorder point?

A reorder point reacts when stock falls to a level. MRP looks ahead at what you plan to make and orders for that, so it catches a shortage before the shelf shows it.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.