HW_04_Solution_Q2___Q3.xlsx - Development cost Shows per week Number of weeks Daily cost to open theatre Ticket price Concession profit per ticket

# HW_04_Solution_Q2___Q3.xlsx - Development cost Shows per...

This preview shows page 1 - 15 out of 15 pages.

Development cost \$ 5,000,000 Shows per week 8 Number of weeks 100 Daily cost to open theatre \$1,000 Ticket price \$50 Concession profit per ticket \$1.50 Capacity 800 Percentage of seats full 80% Days per week running show 6 Numer of shows 800 Number of days open 600 Theatre goers per night 640 Theatre goers total 512,000 Total fixed costs \$5,000,000 Total variable costs \$600,000 Total ticket revenue \$25,600,000 Total concession revenue \$768,000 26368000 Profit \$20,768,000 Part B Percent full \$20,768,000 0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 50% 55% 60% 65% 70% 75% 80% 0% 10% \$0 \$2 \$4 \$6 \$8 \$10 \$12 Proft
85% 90% 95% 100% Part C 2 way data table: Ticket price along top, and number of weeks along side \$20,768,000 \$34 \$36 \$38 \$40 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 100 105 110 115 120 125 130 135 140 145 150 155 160 165 170 175 180 185
190 195 200
For part a , use goal seek to set the profit equal to 5000000 by changing the number of weeks % 20% 30% 40% 50% 60% 70% 80% 90% 1 Percent full
\$42 \$44 \$46 \$48 \$50 \$52
00%
\$54 \$56 \$58 \$60 \$62 \$64
\$66 \$68 \$70 \$72 \$74 \$76
\$78 \$80
Unit prices of specifc products (along top) at a chain's stores (along side) 32" TV Laptop 19" monitor DVD recorder Altoona \$519

#### You've reached the end of your free preview.

Want to read all 15 pages?

• Spring '13
• KATOK,ELENA