due after 2 hours
magic-1
excel_chapter_9.xlsxDocumentation
| Creator: | Exploring Series |
| Date: | 3-Dec-15 |
| Purpose: | Store daily ticket sales by seating group. |
| Calculate daily and weekly revenue. | |
| Calculate monthly seating revenue. | |
| Worksheets: | Week 1 |
| Week 2 | |
| Week 3 | |
| Week 4 | |
| October Summary Worksheet |
Week 1
| Home | Number of Seats Sold per Day | ||||||
| Seating | Available | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | 86 | 88 | 84 | 86 | 86 | 86 | 430 |
| Box Seats | 16 | 16 | 12 | 17 | 16 | 16 | 77 |
| Mezzanine Level 1 | 64 | 50 | 54 | 64 | 64 | 64 | 296 |
| Balcony Level 1 | 46 | 32 | 42 | 44 | 46 | 46 | 210 |
| Totals | $ 186.00 | $ 192.00 | $ 211.00 | $ 212.00 | $ 212.00 | $ 1,013.00 | |
| Revenue per Day | |||||||
| Seating | Seat Price | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | $ 168 | ||||||
| Box Seats | $ 250 | ||||||
| Mezzanine Level 1 | $ 155 | ||||||
| Balcony Level 1 | $ 95 | ||||||
| Totals |
Week 2
| Home | Number of Seats Sold per Day | ||||||
| Seating | Available | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | 86 | 86 | 86 | 86 | 86 | 86 | 430 |
| Box Seats | 16 | 16 | 8 | 16 | 16 | 16 | 72 |
| Mezzanine Level 1 | 64 | 64 | 64 | 64 | 64 | 64 | 320 |
| Balcony Level 1 | 46 | 41 | 41 | 46 | 46 | 46 | 220 |
| Totals | $ 207.00 | $ 199.00 | $ 212.00 | $ 212.00 | $ 212.00 | $ 1,042.00 | |
| Revenue per Day | |||||||
| Seating | Seat Price | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | $ 168 | ||||||
| Box Seats | $ 250 | ||||||
| Mezzanine Level 1 | $ 155 | ||||||
| Balcony Level 1 | $ 95 | ||||||
| Totals |
Week 3
| Home | Number of Seats Sold per Day | ||||||
| Seating | Available | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | 86 | 86 | 72 | 86 | 86 | 86 | 416 |
| Box Seats | 16 | 12 | 8 | 16 | 16 | 16 | 68 |
| Mezzanine Level 1 | 64 | 53 | 64 | 64 | 64 | 64 | 309 |
| Balcony Level 1 | 46 | 40 | 40 | 40 | 40 | 46 | 206 |
| Totals | $ 191.00 | $ 184.00 | $ 206.00 | $ 206.00 | $ 212.00 | $ 999.00 | |
| Revenue per Day | |||||||
| Seating | Seat Price | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | $ 168 | ||||||
| Box Seats | $ 250 | ||||||
| Mezzanine Level 1 | $ 155 | ||||||
| Balcony Level 1 | $ 95 | ||||||
| Totals |
Week 4
| Home | Number of Seats Sold per Day | ||||||
| Seating | Available | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | 86 | 86 | 84 | 86 | 84 | 86 | 426 |
| Box Seats | 16 | 12 | 16 | 16 | 16 | 16 | 76 |
| Mezzanine Level 1 | 64 | 56 | 60 | 64 | 62 | 64 | 306 |
| Balcony Level 1 | 46 | 44 | 46 | 42 | 44 | 46 | 222 |
| Totals | $ 198.00 | $ 206.00 | $ 208.00 | $ 206.00 | $ 212.00 | $ 1,030.00 | |
| Revenue per Day | |||||||
| Seating | Seat Price | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | $ 168 | ||||||
| Box Seats | $ 250 | ||||||
| Mezzanine Level 1 | $ 155 | ||||||
| Balcony Level 1 | $ 95 | ||||||
| Totals |
October
| Home | Percentage of Seats Sold by Weekday for Month | ||||||
| Seating | Available | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Avg Daily % |
| Orchestra Front | 86 | ||||||
| Box Seats | 16 | ||||||
| Mezzanine Level 1 | 64 | ||||||
| Balcony Level 1 | 46 | ||||||
| Total Capacity | 0 | ||||||
| Total Revenue by Weekday for Month | |||||||
| Seating | Seat Price | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | $ 168 | $ - 0 | |||||
| Box Seats | $ 250 | $ - 0 | |||||
| Mezzanine Level 1 | $ 155 | $ - 0 | |||||
| Balcony Level 1 | $ 95 | $ - 0 | |||||
| Totals | 0 | 0 | 0 | 0 | 0 | $ - 0 |
