Excel 2010 Project

profilebumo6ref
e08c1theater12.xlsx

December

Percentage of Seats Sold by Weekday for Month
Seating Available Sunday Wednesday Friday Saturday Matinee Saturday Evening Avg Daily %
Orchestra Front 86 99.4% 95.9% 98.3% 97.7% 100.0% 98.3%
Orchestra Middle 116 97.0% 93.5% 96.6% 97.4% 100.0% 96.9%
Orchestra Back 108 96.3% 94.2% 97.7% 98.1% 100.0% 97.3%
Box Seats 16 90.6% 96.9% 90.6% 93.8% 100.0% 94.4%
Mezzanine Level 1 64 94.5% 93.0% 96.9% 97.7% 100.0% 96.4%
Mezzanine Level 2 68 89.3% 89.3% 96.3% 93.4% 100.0% 93.7%
Balcony Level 1 46 95.7% 96.7% 92.4% 96.2% 100.0% 96.2%
Balcony Level 2 44 88.1% 98.9% 95.5% 94.3% 100.0% 95.3%
Avg. Daily Capacity % 548 95.0% 94.3% 96.4% 96.7% 100.0% 96.5%
Total Revenue by Weekday for Month
Seating Seat Price Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals
Orchestra Front $ 168 $ 57,456 $ 55,440 $ 56,784 $ 56,448 $ 57,792 $ 283,920
Orchestra Middle $ 158 71,100 68,572 70,784 71,416 73,312 355,184
Orchestra Back $ 148 61,568 60,236 62,456 62,752 63,936 310,948
Box Seats $ 250 14,500 15,500 14,500 15,000 16,000 75,500
Mezzanine Level 1 $ 155 37,510 36,890 38,440 38,750 39,680 191,270
Mezzanine Level 2 $ 125 30,375 30,375 32,750 31,750 34,000 159,250
Balcony Level 1 $ 95 16,720 16,910 16,150 16,815 17,480 84,075
Balcony Level 2 $ 75 11,625 13,050 12,600 12,450 13,200 62,925
Totals $ 300,854 $ 296,973 $ 304,464 $ 305,381 $ 315,400 $ 1,523,072