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
Image of page 1
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
Image of page 2
190 195 200
Image of page 3
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
Image of page 4
$42 $44 $46 $48 $50 $52
Image of page 5
Image of page 6
00%
Image of page 7
$54 $56 $58 $60 $62 $64
Image of page 8
Image of page 9
$66 $68 $70 $72 $74 $76
Image of page 10
Image of page 11
$78 $80
Image of page 12
Image of page 13
Unit prices of specifc products (along top) at a chain's stores (along side) 32" TV Laptop 19" monitor DVD recorder Altoona $519
Image of page 14
Image of page 15

You've reached the end of your free preview.

Want to read all 15 pages?

  • Spring '13
  • KATOK,ELENA

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture