Krown Caterings Sales Performance Dashboard
Excel dashboard analyzing menu performance, event types, and seasonal demand patterns
🎯 Challenge
Krown Caterings, a growing catering company serving corporate events, weddings, and private functions, struggled with understanding which menu items drove the most revenue, which event types were most profitable, and how seasonal demand fluctuated throughout the year. Without clear visibility into these metrics, they couldn't optimize their menu offerings or allocate resources effectively.
💡 Solution
Built a comprehensive Excel dashboard using advanced pivot tables, slicers, and conditional formatting to track:
- Revenue breakdown by menu item (appetizers, entrees, desserts, beverages)
- Performance analysis by event type (corporate, wedding, private)
- Seasonal demand patterns across quarters
- Profit margin analysis by menu category
- Customer satisfaction scores correlated with menu choices