Excel 2010 Project

profilebumo6ref
e08c1theater11.xlsx

November

Percentage of Seats Sold by Weekday for Month
Seating Available Sunday Wednesday Friday Saturday Matinee Saturday Evening Avg Daily %
Orchestra Front 86 93.3% 94.8% 97.7% 99.4% 100.0% 97.0%
Orchestra Middle 116 94.0% 93.3% 98.3% 98.7% 99.8% 96.8%
Orchestra Back 108 95.1% 86.6% 96.8% 94.0% 100.0% 94.5%
Box Seats 16 68.8% 81.3% 85.9% 93.8% 96.9% 85.3%
Mezzanine Level 1 64 91.0% 96.1% 96.5% 99.2% 100.0% 96.6%
Mezzanine Level 2 68 87.9% 95.2% 100.7% 93.8% 98.2% 95.1%
Balcony Level 1 46 89.7% 86.4% 89.7% 95.7% 96.7% 91.6%
Balcony Level 2 44 77.8% 77.8% 86.9% 89.8% 98.3% 86.1%
Avg. Daily Capacity % 0 90.6% 90.6% 96.0% 96.2% 99.2% 94.5%
Total Revenue by Weekday for Month
Seating Seat Price Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals
Orchestra Front $ 168 $ 53,928 $ 54,768 $ 56,448 $ 57,456 $ 57,792 $ 280,560
Orchestra Middle $ 158 68,888 68,414 72,048 72,364 73,154 354,868
Orchestra Back $ 148 60,828 55,352 61,864 60,088 63,936 302,068
Box Seats $ 250 11,000 13,000 13,750 15,000 15,500 68,250
Mezzanine Level 1 $ 155 36,115 38,130 38,285 39,370 39,680 191,580
Mezzanine Level 2 $ 125 29,875 32,375 34,250 31,875 33,375 161,750
Balcony Level 1 $ 95 15,675 15,105 15,675 16,720 16,910 80,085
Balcony Level 2 $ 75 10,275 10,275 11,475 11,850 12,975 56,850
Totals $ 286,584 $ 287,419 $ 303,795 $ 304,723 $ 313,322 ERROR:#REF!