01
Instructions Sheet
Step-by-step guide on how to use each tab. Start here. You'll be entering your own data within 10 minutes, no Excel skills needed.
Free Food Cost Calculator for Indian Restaurants (2025-26)
Recipe costing, menu pricing with target margins, and a daily food cost dashboard. Built for Indian kitchens with 20 pre-loaded staple ingredients and 5 sample dishes.
- Recipe-level costing for dishes like Butter Chicken, Dal Makhani, and Veg Biryani with real ingredient prices
- Auto-calculated food cost %, gross margin, and suggested selling price for a 30% cost target
- 31-day daily dashboard with colour-coded alerts: green (under 28%), amber (32-38%), red (above 38%)
No spam. Instant download link to your email.
Petpooja presents
Food Cost Calculator
For Indian Restaurants
5
Sheets · Excel workbook
2025-26
What's Inside
Five sheets covering every part of your food cost.
02
Ingredient Master (20 Staples)
Pre-loaded with 20 Indian kitchen staples: onions, tomatoes, paneer, chicken, basmati rice, cooking oil, and more. Add your vendor names and current purchase prices.
03
Recipe Costing (5 Sample Dishes)
Butter Chicken, Dal Makhani, Paneer Tikka, Veg Biryani, and Tandoori Roti, fully costed per portion. Swap in your own recipes and the formulas do the rest.
04
Menu Pricing Sheet
Auto-calculates food cost percentage, gross margin, and a suggested selling price based on a 30% food cost target. Adjust the target and watch prices update instantly.
05
Daily Food Cost Dashboard
Track actual vs ideal food cost for every day of the month. Colour-coded cells flag trouble: green means you're under 28%, amber is 32-38%, and red means above 38%.
06
Built-In Formulas & Benchmarks
Every formula is pre-built and labelled. Benchmarks reference the 28-32% food cost range typical for Indian full-service restaurants. No manual calculation required.
Why This Matters
Why Food Cost Tracking Matters for Every Indian Restaurant
Most restaurant owners in India know their revenue. Fewer know their actual food cost percentage. That gap is where profit disappears.
For a full-service Indian restaurant, food cost typically sits between 28% and 32% of revenue. That's the healthy range. Go above 35% and you're probably losing money on every plate, even if the dining room is full. The NRAI India Food Services Report consistently highlights food cost reduction as one of the top challenges for restaurant profitability in India.
The problem isn't that owners don't care. It's that tracking food cost at the recipe level takes effort. Ingredient prices change weekly. Onion prices in Mumbai can double in a single monsoon month. Chicken rates vary between Pune and Hyderabad. Without a system to track these shifts and recalculate dish costs, most kitchens rely on rough estimates.
Rough estimates are dangerous. A Butter Chicken that costs ₹120 to make and sells for ₹350 looks profitable at first glance. But if your actual ingredient cost crept up to ₹140 because paneer and cream prices rose, your food cost just jumped from 34% to 40%. That 6-percentage-point shift, across 100 plates a day, adds up to lakhs over a year.
This calculator gives you a structured way to track ingredient costs, cost out each recipe, set menu prices with real margins, and monitor daily food cost against your target. It's built specifically for Indian kitchens, with Indian ingredients and Indian price points.
Businesses using Petpooja POSS and Petpooja Purchase get this kind of tracking built into their daily operations, with live ingredient costs synced from purchase invoices. This Excel calculator gives you the same discipline, manually.
Sample Preview
5 rows from the calculator.
Here's a preview of what you'll find inside the workbook:
Ingredient Master: Basmati Rice, 1 kg, ₹85/kg, vendor: local mandi. Last updated price and purchase date tracked per ingredient
Recipe Costing: Butter Chicken (1 portion), 8 ingredients, total ingredient cost ₹118, food cost % auto-calculated against selling price
Menu Pricing: Dal Makhani, ingredient cost ₹52, suggested price ₹175 at 30% target, actual food cost 29.7%, gross margin 70.3%
Daily Dashboard: Day 14, actual food cost 31.2%, ideal food cost 29%, variance +2.2%, amber alert triggered
Colour Alerts: Green = below 28% (excellent), Amber = 32-38% (needs attention), Red = above 38% (investigate immediately)
... plus 20 pre-loaded ingredients, 5 fully costed recipes, and a 31-day tracking dashboard in the full Excel workbook.
Key Stats
The numbers behind food cost in Indian restaurants.
28-32%
Healthy food cost range for Indian full-service restaurants. Above 35% typically means the kitchen is losing money on most dishes.
Source: NRAI India Food Services Report; industry benchmarks for full-service restaurants₹5.5L cr
Estimated size of India's food services market in FY 2024-25. Competition is intense, and margins separate survivors from closures.
Source: NRAI India Food Services Report 20253-5%
Typical net profit margin for Indian restaurants after rent, labour, and overheads. A 2% food cost overrun can wipe out the entire margin.
Source: NRAI India Food Services Report; restaurant industry analysis
Common Mistakes
8 food cost mistakes Indian restaurant owners keep making.
01
Not costing recipes at the per-portion level
Knowing that "chicken costs ₹220/kg" isn't enough. You need to know exactly how many grams go into one plate of Butter Chicken, and what that costs after adding cream, butter, spices, and gas.
02
Using last month's ingredient prices for this month's menu
Onion prices in Indian mandis can shift 30-40% in a single week during monsoon season. If your recipe costing sheet still shows last month's rates, your food cost percentage is fiction.
03
Setting menu prices based on "feel" instead of data
Pricing a dish at ₹299 because competitors charge ₹320 sounds logical. But if your ingredient cost for that dish is ₹130, your food cost is 43%. That's a loss on every order.
04
Ignoring wastage in food cost calculations
A 1 kg bag of spinach doesn't yield 1 kg of usable spinach. Trimming, cleaning, and cooking shrinkage mean your actual usable quantity is lower. Not accounting for this inflates your real cost. Read more about tackling restaurant waste management effectively.
05
Tracking food cost monthly instead of daily
By the time you realise food cost was 38% for the month, the month is already over. Daily tracking catches problems on Day 3, not Day 31.
06
Not separating food cost by dish category
Your overall food cost might be 30%, but tandoor items could be at 22% while gravies sit at 40%. Blended averages hide the dishes that are actually bleeding money.
07
Forgetting to include GST when calculating selling prices
Restaurants with air conditioning pay 5% GST without input tax credit (ITC). If you set a ₹300 menu price and forgot GST, your effective revenue per plate is lower than you think.
08
Treating delivery orders the same as dine-in for food cost
Aggregator commissions of 15-30% effectively raise your food cost on delivery orders. A dish with 30% food cost in the restaurant becomes 45-60% total cost on Swiggy or Zomato.
Comparison
Manual tracking vs this calculator.
| Aspect | Manual / Guesswork | With This Calculator |
|---|---|---|
| Recipe costing | Rough estimates, rarely updated | Per-portion costing with ingredient-level detail for every dish |
| Ingredient price tracking | Prices remembered from last purchase | 20 staples pre-loaded with vendor name, rate, and last-updated date |
| Menu pricing | Based on competitor pricing or gut feel | Auto-suggested price based on your actual cost and target margin |
| Food cost % visibility | Calculated once a month, if at all | Daily tracking for 31 days with colour-coded variance alerts |
| Spotting problem dishes | Discovered too late, usually after a bad month | Each dish shows food cost %, so high-cost items are visible immediately |
| Time to update | Hours of manual math on paper or phone calculator | Update ingredient prices once. All recipe costs and margins refresh automatically |
| Benchmarking | No reference point for "good" vs "bad" | Built-in 28-32% benchmark with green/amber/red alerts |
Stop guessing your food cost.
Download the free calculator and know your numbers by tonight.
FAQ
Frequently asked questions.
What's a good food cost percentage for an Indian restaurant?
For full-service Indian restaurants, 28-32% is considered healthy. QSRs and cloud kitchens often target 25-30%. If you're consistently above 35%, your menu pricing or portion sizes likely need a rework. Use this alongside our restaurant P&L template to see how food cost impacts your bottom line.
Can I add my own recipes and ingredients to this calculator?
Yes. The 20 ingredients and 5 recipes are samples to get you started. All input cells are unlocked, so you can add your full menu. The formulas will auto-calculate food cost % and suggested pricing for any dish you enter.
Does this calculator account for GST on menu prices?
The menu pricing sheet focuses on food cost as a percentage of your selling price (pre-GST). You should factor in the applicable GST rate (5% for restaurants) separately when setting your final customer-facing price. The calculator notes this in the Instructions sheet.
How often should I update ingredient prices in the calculator?
Weekly is ideal, especially for volatile items like onions, tomatoes, chicken, and cooking oil. At minimum, update prices every time you receive a new vendor invoice. The Ingredient Master sheet has a "Last Updated" column to help you stay on track.
Is this calculator useful for cloud kitchens and QSRs, or only dine-in restaurants?
It works for any format. Cloud kitchens, QSRs, cafes, bakeries, dhabas. The recipe costing and menu pricing logic is the same. Cloud kitchen operators should also factor in aggregator commissions (15-30%) separately, which effectively raise your total cost per order.
About Petpooja
Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.
Automate food cost tracking with Petpooja POSS + Purchase
Restaurants using Petpooja POSS and Petpooja Purchase track food cost in real time. Purchase invoices sync directly to your POS, so ingredient costs update automatically and your P&L stays live. No manual data entry, no end-of-month surprises.
Book a Free Demo
Call: +91-9104369797