JEDA Food Costing System — Excel Template (Know Your Real Profit Per Plate)
You've been cooking, selling, hustling but do you actually know if you're making profit?
Most food business owners are guessing. They pick prices based on vibes, forget to count gas and packaging, and wonder why the money never adds up at the end of the month.
This template fixes that,the JEDA Food Costing System is an Excel workbook built specifically for food businesses. You put in your ingredients, quantities, and overhead it tells you your exact cost per portion, recommended selling price, and profit margin. No guessing. No surprises.
Here's what's inside:
Recipes Sheet — Add up to 21+ meals with their portions and selling prices. The system assigns each one a recipe ID automatically.
Ingredient Master List — Enter every ingredient you use, the unit cost, volume, and supplier. One place for everything.
Base Recipe & Costing — This is the engine. Pick a meal, select the ingredients from a dropdown, fill in the quantity used the cost calculates itself.
Cost Factor Sheet — Add your gas, packaging, labor, and delivery costs so your true production cost is never underestimated.
Sales Sheet — See your total recipe cost, recommended selling price with 70% markup, and profit per portion side by side.
Production Log — Click "Record" at the end of each production run. Your history builds itself date, menu, portions, selling price, cost, gross profit, and net profit all tracked automatically.
Dashboard — Visual breakdown of your most expensive meals and ingredient cost distribution. Useful when prices go up and you need to decide what to adjust.
Two versions included: one for Office 2016 and below, one for newer versions. Both files are in the download.
This is not a course. There's no upsell. You download it, watch the short how to video linked inside, fill in your own numbers, and you'll know maybe for the first time exactly what each plate actually costs you.
Who this is for: Restaurant owners, caterers, home chefs selling food, small chops vendors, anyone who cooks to sell and wants to stop guessing on pricing.
NOTE: There are two versions of the template in the Zip folder, download the version compatible with your Microsoft office, duplicate it save a copy on your google drive. Please read the instructions on the PDF file before use