Enter a 3 D formula in cell C3 on the October worksheet that calculates the overall percentage of total Sunday Orchestra Front tickets sold based on the total available Orchestra Front seating. The 3 D formula must perform several internal calculations, avoid raw numbers, and use an appropriate mix of relative and mixed references to derive the correct percentage. Format the result with Percent Style. The result is 100%, based on the sum of the Sunday Orchestra Front tickets sold divided by the total available tickets for all four weeks. Copy the formula to the remaining cells in the range C3:G6.
| Home | Number of Seats Sold per Day | ||||||
| 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 | 212 | ||||||
| Revenue per Day | |||||||
| Seating | Seat Price | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | $ 168 | $ 44,016 | $ 54,768 | $ 57,792 | $ 57,456 | $ 57,792 | $ 271,824 |
| Box Seats | $ 250 | 14,000 | 11,000 | 16,000 | 16,000 | 16,000 | 73,000 |
| Mezzanine Level 1 | $ 155 | 34,565 | 37,510 | 39,680 | 39,370 | 39,680 | 190,805 |
| Balcony Level 1 | $ 95 | 14,915 | 16,055 | 16,340 | 16,720 | 17,480 | 81,510 |
| Totals | $ 107,496 | $ 119,333 | $ 129,812 | $ 129,546 | $ 130,952 | $ 617,139 | |
Economic Debate- Progressive Income Tax For this Economic Debate, we are going to discuss the…
TOPIC: Going Global Discussion Thread 1 (initial post due Wednesday for full credit) Please note:…
Assignment Topic This week will culminate in the creation of a narrated PowerPoint to create…
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted…
you need to post your 2-page information flier to share with your Final Project Group.…
discussion: Discuss the methods used at your company to measure and ensure quality products and…