Food Truck Business Planner Spreadsheet, Excel and Google Sheets, Menu Costing Calculator, Food Cost, Event Calendar, Sales Tracker

Seller's description

Food Truck Business Planner Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Cost every plate, log every service and see which spots, events and menu items really make you money. Perfect for food truck and food trailer owners.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/xbJNodmZYrQ

✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers).

★ WHAT'S INCLUDED ★
• 17 tabs with a clickable Start Here page and a How To Use guide with FAQ
• Dashboard: 16 KPI tiles (net sales, profit, average per service, average ticket, food cost %, goal progress, bookings in the next 30 days, renewals to act on and more), month by month table, next bookings, permit alerts, top locations, top menu items and 5 charts
• Menu Costing (40 items): plate cost from your recipes plus packaging, food cost %, a suggested price for your target food cost, profit per plate, price check flags, plates sold, revenue, gross profit and a menu class (Star, Plowhorse, Puzzle, Dog)
• Recipes (400 lines) with a pick-an-item recipe card, and Ingredients & Stock (120 items): pack cost, true cost per unit after yield, par level, on hand, reorder flags and packs to order
• Sales Log (1,000 services): location or event, hours, orders, gross sales, discounts, card sales, tips and weather, with net sales, average ticket, sales per hour and card fees worked out
• Item Sales (6,000 rows): plates sold per item per service, with revenue, plate cost and gross profit
• Events & Bookings (300 rows): flat, % of sales or flat + % fees, expected vs actual sales, status and heads-up alerts, plus a monthly Calendar view with fees on each day
• Supplier Orders (1,500 rows) with price creep flags, and Expenses (800 rows) with a by-category summary
• Permits & Renewals (30 items): health permit, licenses, inspections, food handler cards and insurance with days left, renew-by dates and Expired / Renew now / Coming up status
• Profit & Loss: monthly P&L, expenses by category and month, and a 53-week weekly P&L, with 2 charts
• Insights: best locations ranked by net sales per service, best days of the week, event types, weather vs sales, top 10 menu items, with 2 charts
• Break-Even Calculator: break-even sales per month, per service, per hour and orders needed, plus a what-if table and chart
• Sample data from a busy taco truck so you can see how it works

★ PERFECT FOR ★
✓ Food truck and food trailer owners
✓ Pop-up, farmers market and festival food vendors
✓ Caterers and coffee or dessert carts
✓ Anyone planning to start a food truck

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download the files right after purchase.
2. On Setup, add your fees, food cost target, sales goal and locations.
3. Add ingredients and recipes to cost your menu.
4. Log each service, booking, order and expense. The dashboard updates itself.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• Permit and license rules vary by city and county. This is a business planning tool, not tax or legal advice.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.