Party Tray Pricing Calculator, Home Catering Spreadsheet, Food Cost Calculator Google Sheets, Catering Quote Template, Tray Menu

Stop guessing what to charge for a full tray of pancit. This calculator works out the price of every dish in every tray size from your real ingredient costs, your time, containers and payment-app fees, then helps you quote a whole party and track your weekly orders.

MADE FOR HOME CATERERS

Family-party trays, potluck orders, holiday pans, side hustle sales. If you sell half trays, full trays and party trays, this is built around how you actually cook and sell.

WHAT'S INSIDE

- Quick Price dashboard: pick a dish and size to see the price to charge, cost per tray, profit after fees, how many people it feeds and price per serving. It also shows where the money goes (ingredients, your time, container, fees) and this week's orders with an 8-week chart.

- Tray Prices: every dish in 4 sizes (small, half, full, party) with cost, suggested price, your own price and profit.

- Customer Quote: up to 8 dishes, delivery by the mile, discount, deposit, "feeds about", plus a ready-to-copy message for Messenger or a text.

- Orders log (500 rows): revenue, estimated cost, fees and profit per order, totalled by week.

- Ingredients (150), Recipes (30 dishes) and Recipe Lines (400): change one ingredient price and every tray updates.

- Settings: hourly rate, profit margin, payment fees, round-up rule, delivery fees, deposit %, tray size factors and container costs. Everything is editable.

WHAT YOU GET

- Party-Tray-Pricing-Calculator-BLANK.xlsx (ready for your dishes)

- Party-Tray-Pricing-Calculator-EXAMPLE.xlsx (made-up sample kitchen so you can see it working)

- Party-Tray-Menu-Template.pptx (2-page menu + order info with placeholders; opens in Canva, PowerPoint or Google Slides)

- PDF quick-start guide

WORKS WITH

Google Sheets (free; upload and choose File > Save as Google Sheets) and Microsoft Excel. No macros, no add-ons, no subscription.

PLEASE NOTE

- Digital download only. Nothing is mailed.

- Prices are your own math based on the numbers you enter, not a promise of sales or profit.

- Questions about the file? Message the shop where you bought it (Payhip or Etsy messages).

DISCLAIMER: Check your local cottage-food rules. Selling food made at home is regulated differently by each state, county and city (permits, labels, sales limits, delivery). This calculator only helps with pricing and doesn't tell you what's allowed where you live. Suggested prices are not a promise of sales or profit. Screenshots show made-up sample numbers.

AI DISCLOSURE: Made with AI assistance. The spreadsheet formulas, layout, menu template, guide text and listing images were created with an AI assistant under the direction of S9T Vibes (SupaMarioS9T). Listing images are mockups of the real spreadsheet with made-up sample data; no stock photos.