Report this item to Etsy

Food Truck COGS & Menu Pricing Calculator | Recipe Costing, Profit Margin (Google Sheets, Excel)

Price:$14.99

Salar

By Salar

ProFormaGRID ·

United States

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Party decor for gatherings and celebrations
  • Digital download
  • Digital file type(s): 2 PDF, 1 other file

Q: Does this work in Google Sheets* and Excel*, and how do I get it?
A: Yes, both. After purchase you download 3 files: (1) a PDF with a one-click link that copies the template into your own Google Drive*, (2) the Excel* (.xlsx) version, and (3) a step-by-step INSTRUCTIONS PDF. Use either version or both.

Q: If my supplier raises a price, do I have to fix every recipe?
A: No. Every ingredient is entered once in the Master Ingredient Database. Change the price there and every recipe, menu price and profit figure updates automatically. There is also a cost shock box: type +10% to see how a 10% ingredient price rise changes every dish.

Q: Does it handle trim, peeling and waste?
A: Yes. Each recipe line has a Waste / Trim % (potato peel, meat trim, cooking shrink). The sheet adds the extra you must buy so your COGS per portion is realistic. It converts grams, kg, oz, lb, ml, L, fl oz, cups, gallons and "each" for you.

Q: Will I accidentally break the formulas?
A: The template is not locked, so you can always edit freely. Type only in the cream cells with dark borders; ice-blue cells are formulas. Warning banners, a color legend, status messages (like "Unit type mismatch") and the instructions PDF explain how to resize cells safely and undo mistakes.

Q: What does it NOT do?
A: It does not sync with your POS, bank or suppliers, it is not a mobile app, and it is a static spreadsheet: you type in your own prices and sales. It holds 200 ingredients, 25 recipes with 250 ingredient lines, and 60 logged events or shifts.

Know your true cost per plate, price every item for profit, and see exactly what each event earns. Built for food trucks, pop-up chefs, caterers, farmers-market vendors and home-based food businesses.

WHAT'S INSIDE (5 connected tabs, a Charts tab and instructions)
- Master Ingredient Database: unit cost to 4 decimals (per gram, ml or each)
- Recipe & Menu Costing: batch cost, yield and exact COGS per portion, plus the price-change simulator
- Menu Pricing & Profit Matrix: suggested prices at 25%, 30% and 35% food cost, gross profit, margin, green / amber / red health check, and side-by-side regular, delivery-app and pop-up / event pricing
- Daily Sales & Event Expense Dashboard: sales, booth fees, commission, fuel, generator gas, propane, permits and labor, with net profit per shift
- Charts tab: four charts that draw themselves from your numbers (food cost %, cost vs price, profit per event, sales vs expenses)
- Instructions & Legend tab with a color-coding guide

WHAT YOU RECEIVE
- 1-GOOGLE-SHEETS-LINK PDF (one-click copy to your Google Drive*)
- 2-EXCEL spreadsheet (.xlsx)
- 3-INSTRUCTIONS PDF
- The template comes empty, ready for your own numbers (pictures show sample numbers only)

HOW IT WORKS
1. Download your files and open in Google Sheets* or Excel*.
2. Enter your ingredients and prices once, then build each recipe from dropdowns.
3. Set your target food cost, type your menu prices and log every shift.

DISCLAIMER
Educational planning tool only. Results depend on the numbers you enter and are not tax, legal or financial advice. Not affiliated with Google* or Microsoft*.

More templates and help: ProFormaGRID.com

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Restaurant Food Cost Spreadsheet

Food Truck Spreadsheet

Food Truck Tracker

Food Truck Business Spreadsheet

Food Cost Calculator Spreadsheet

Restaurant Food Cost Calculator

Listed on Sep 24, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates