Complete two selected cost-volume-profit analyses for the show illustrated in Exhibit 2, the KFBS Allstars: a) How many tickets must the ALLTEL Pavilion sell to break even? b) How many tickets must ALLTEL sell to earn $30,000 operating income after taxes, assuming a 40 percent tax rate? 3. What should be the average ticket price for the KFBS concert if the fixed-pay fee is $200,000 and the Pavilion expects to sell 7,000 tickets and wants to earn $30,000 after 40 percent in taxes? 4. Negotiating the fee for the KFBS Allstars: fixed-pay or per capita contracts? a) What is the maximum fixed fee that the Pavilion can pay the KFBS Allstars if the Pavilion wants to earn $45,000 after 40 percent tax and expects the show to have an average ticket price of $22.12? Assume the show is expected to draw 6,000 paying ticket holders. b) What is the maximum fixed fee that the Pavilion can pay the KFBS Allstars if the Pavilion wants to earn $45,000 after 40 percent tax and expects the show to have an average ticket price of $22.12? Assume, including 25 percent comp tickets, the show is expected to be a sell-out. c) Independent of (a) and (b), what is the maximum per capita fee that the Pavilion can pay the KFBS Allstars, whose concert is expected to be a sellout, if the Pavilion wants to earn $180,000 after 40 percent tax from an average ticket price of $22.12 per ticket? 5. What role does CVP analysis and operating leverage play in contract negotiations with different types of performers (fixed-fee or per capita)?

Using Excel. Step by step

   

ARTIST NAME EXHIBIT 2 Flash Report for the KFBS Allstars Concert ACTIVITY/EVENT NUMBER EVENT MONTH EVENTDATE Projected Sales (Number of Seats) A Seats B Scats The KFBS Allstars 10310001 7 7/31/04 2,778 2,845 C Seats 1,747 D Seats TOTAL Number of Seats Projected Ticket Price A Seats 881 8,251 $36.29 B Seats $22.22 C' Seats $11.31 D Seats $4.92 PROJECTED NET AFTER TAXADMISSIONS $182,479 AVG TIX PRICE NET OF TAX PER PAYING PATRON $22.12 TALENT% 88.03% GUARANTEE/TALENT COSTS $160,635 NUMBER OF PERFORMANCES DROP COUNT (includes comp tickets) 10,349 Other Ticket-Related Revenue FACILITY CHARGE Per capita SERVICE CHARGE Per capita REVENUE FROM TICKETING Per capita ANCILLARY REVENUES PARKING Per capita FOOD CONCESSION. Per capita $24,010 $2.91 $16,172 $1.96 $222,673 $26.99 $19,767 $1.91 $79,273 $7.66 $36,428 MERCHANDISE Per capita $3.52 RENTALS 50.00 REVENUE FROM ANCILLARIES $135,468 Per capita $13.09 TOTAL REVENUE $358,141 Per capita $34.61 (continued on next page)