Daily Sold-Out and Leftover Tracker
Takes your end-of-day numbers (what you prepped, what was left, what sold out and when) and turns them into a sell-through report and a suggested prep list for tomorrow.
Before and after
Quailview Taco Truck, Thursday, 7880 Oakview St, Deerhollow, 11 to 2
Today's results
- Carnitas: prepped 60, left 0, sold 60, sell-through 100%. SOLD OUT at 1:15 (45 minutes before close)
- Chicken tinga: prepped 50, left 10, sold 40, sell-through 80%, 20% left over. On track
- Roasted poblano veggie: prepped 30, left 14, sold 16, sell-through 53%, 47% left over. LEFTOVERS FLAGGED (over your 30% limit)
- Horchata cups: prepped 38, left 3, sold 35, sell-through 92%, 8% left over. On track
- Chips and salsa cups: prepped 80, left 20, sold 60, sell-through 75%, 25% left over. On track
Summary: 1 sold out, 1 flagged for leftovers, 3 on track (5 items total).
Tomorrow's prep (Friday, same stop and hours)
- Carnitas: 60 sold + 20% bump = 72, rounded up to 75. Up 15 from today
- Chicken tinga: 40 sold + 10% = 44, rounded up to 45. Down 5 from today
- Roasted poblano veggie: 16 sold + 10% = 17.6, rounded up to 20. Down 10 from today
- Horchata cups: 35 sold + 10% = 38.5, rounded up to 40. Up 2 from today
- Chips and salsa cups: 60 sold + 10% = 66, rounded up to 70. Down 10 from today
Notes: Carnitas sold out with 45 minutes of service left, so true demand is unknown and we recommend having Heidi keep a tally tomorrow of anyone who asks for carnitas after it runs out. Roasted poblano veggie had the most left over and is flagged over your 30% limit.
Questions for the owner
- How many people did Heidi see walk away when carnitas sold out?
- What happened to the 14 leftover roasted poblano portions and the other leftovers? Please follow your health department's rules and confirm them locally.
- Is there anything about tomorrow (weather, an event nearby) that could change how busy you will be?
What it does
Takes your end-of-day numbers (what you prepped, what was left, what sold out and when) and turns them into a sell-through report and a suggested prep list for tomorrow. It flags items that ran out early and items that left too much behind.
Use it when: Use when a food truck owner wants to log what sold out, what was left over, and what was sold today, then get a prep list for tomorrow, such as: what should I prep tomorrow, we sold out of tacos again, too much was left over, end of day numbers, or adjust my prep.