Sales by Location and Day: Finding the Best Spot
This lesson is part of the course
In this lesson
You average a month of services by location with AVERAGEIF and AVERAGEIFS, work out the average ticket per spot and let a formula name the best spot.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Menu Costing and Food Cost % Locked
- Sales by Location and Day: Finding the Best Spot Locked
- Throughput: Orders per Half Hour at the Window vs the Queue Locked
- Event Fees: Flat vs % of Sales, and Which Events Pay Locked
- Commissary, Permits, Fuel and Generator: the Monthly Cost Base Locked
- Labour per Shift: Paid Hours, Labour Cost and Labour % Locked
- Weather and Seasonality Scenarios Locked
- Break-even Meals per Day and Truck Payback Locked