Recipe Cost Calculator in Excel: Scale a Recipe for More Guests and Find the Cost per Plate

By Ravindra Bagale · Last updated: 17 October 2026

Download the template: recipe-cost-scaling-calculator-template.xlsx: example data with real formulas. Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and everything recalculates.

Made-up data: every name, amount, shop and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The example

Veg pulao for 4, scaled to 25 (scale factor 6.25), made-up prices:

All 8 ingredients cost ₹256.50 for 4 and ₹1,603.13 for 25. With 8% for gas and extras, the cost per plate is ₹69.26 either way, because the recipe scales evenly. But the shop bill is ₹2,120, since you buy whole packs and some is left over for the kitchen. Paneer is the costliest ingredient.

2. Build it step by step

Step 1. Servings

1. In B3 type how many the recipe serves (4) and in B4 how many you want to serve (25).
2. In B5 type =B4/B3: 6.25. In B6 type the gas and extras % (8%).

Step 2. Ingredients

1. In A8:I8 type the headers. For each ingredient type the unit, pack size, pack price and the amount the recipe uses (yellow).
2. Select B9:B100 > Data Validation > List: g,kg,ml,l,pcs (drop-down lists). Keep pack size and recipe amount in the same unit.

Step 3. Cost for the original recipe

1. In F9 type =E9/C9*D9: 400 g of a 1,000 g pack at ₹140 = ₹56.
2. Copy down. In F17 type =SUM(F9:F16): ₹256.50.

Step 4. Scale up

1. In G9 type =E9*$B$5: 2,500 g of rice.
2. In H9 type =ROUNDUP(G9/C9,0): 3 packs (ROUNDUP).
3. In I9 type =G9/C9*D9: ₹350. Copy G9:I9 down; I17 =SUM(I9:I16): ₹1,603.13.

Step 5. Cost per plate and shop bill

1. In F18 type =F17*(1+$B$6) and in F19 =F18/B3: ₹69.26 per plate. Same in column I with B4.
2. In I20 type =SUMPRODUCT(H9:H16,D9:D16): packs × pack price = ₹2,120 to pay at the shop (SUMPRODUCT).
3. In I21 type =INDEX(A9:A16,MATCH(MAX(I9:I16),I9:I16,0)): Paneer.

Step 6. Data bars

1. Select I9:I16 > Conditional Formatting > Data Bars to see which ingredients drive the cost (data bars).

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in the file.

4. Common mistakes

1. Mixing units. A 1 kg pack typed as 1 with a recipe of 400 g gives a cost 1,000 times too high. Type the pack as 1000 g.
2. Forgetting $ on the scale factor. =E9*B5 moves down to B6, B7 … when copied. Use $B$5.
3. Cost per plate from the shop bill. The shop bill includes leftovers. Cost per plate should use what the recipe actually uses (I17).
4. ROUND for packs. 2.19 packs of vegetables means buying 3; ROUND would give 2.
5. Scaling spices exactly. Salt and strong spices often need a little less than straight scaling. Taste and adjust; the cost difference is tiny.

5. More real examples

Example 1: Tiffin pricing. If the cost per plate is ₹69.26, a selling price can be set with a margin, for example =I19*1.5.

Example 2: Festival sweets. Scale a laddoo recipe from 20 pieces to 150 and see how much ghee and sugar to buy.

Example 3: Halving a recipe. Type 2 in B4: the scale factor becomes 0.5 and every quantity halves.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

How do I scale a recipe in Excel?

Scale factor = servings wanted ÷ recipe servings; multiply each quantity by it with $B$5.

How do I calculate ingredient cost?

Amount used ÷ pack size × pack price: =E9/C9*D9.

How do I find the cost per plate?

Total ingredient cost × (1 + extras %) ÷ servings.

Why is the shop bill higher than the recipe cost?

You buy whole packs; ROUNDUP and SUMPRODUCT give the real bill, and the rest stays in the kitchen.

Can I use it for any recipe?

Yes. Replace the ingredients and pack prices; keep units consistent.

7. Quick quiz

Ten questions on this page. Sign in to save your score.