The Chicago Hawks play in the American Ice Hockey League The

The Chicago Hawks play in the American Ice Hockey League. The Hawks play in the Downtown Arena, which is owned and managed by the City of Chicago. The arena has a capacity of 17,500 seats (6,000 lower-tier seats and 11,500 upper-tier seats). The arena charges the Hawks a per-ticket charge for use of its facility. All tickets are sold by the Reservation Network, which charges the Hawks a reservation fee per ticket. The Hawks\' budgeted contribution margin for each type of ticket in 2013 is computed as follows: EEB Click the icon to view the budgeted contribution margin data.) The budgeted and actual average attendance figures per game in the 2013 season are as follows: EEE Click the icon to view the budgeted and actual average attendance figures.) There was no difference between te budgeted and actual contribution margin for lower-tier or upper tier seats. The manager o the Hawks was unhappy that actual attendance was 4% below budgeted attendance per game, especially given the booming state of the local economy in the past six months. Read the requirements. Requirement 1. Compute the sales-volume variance for each type of ticket and in total for the Chicago Hawks in 2013. (Calculate all variances in terms of contribution margins.) Determine the formula for sales-volume variance, then compute the sales-volume variance for each type of ticket and in total for the Chicago Hawks in 2013. (Calculate all variances in terms of contribution margins.) Label each variance as favorable (F) or unfavorable (U) Data Table variance Data Table Budgeted Seats Sold Actual Seats Sold Lower tier Upper tier Total 5,000 7,500 12,500 4,200 7,800 Lower-Tier Tickets Upper-Tier Tickets 12,000 Selling price Downtown Arena fee Reservation Network fee Contribution margin per ticket 36 15 12 PrintDone Clear All Check Answer

Solution

1 Sales volume variance=(Actual seats sold-Budgeted seats sold)*Budgeted contribution margin per ticket Lower tier tickets: Sales volume variance=(4200-5000)*18=14400 A (Since actual seats sold is less than budgeted seats,It has an adverse variance Upper tier tickets: Sales volume variance=(7800-7500)*8=2400 F (Since actual seats sold is more than budgeted seats,It has a favorable variance) Sales volume variance in total=14400-2400=12000 A 2 Sales quantity variance=(Budgeted seats sold-Seats sold at standard mix)*Budgeted contribution margin per ticket Lower tier tickets: Standard mix ratio for Lower tier ticket=Budgeted sales of lower tier ticket/Total budgeted seats sold=5000/12500=40% Seats sold at standard mix=Total actual seats sold*Standard mix ratio= 12000*40%=4800 seats Sales quantity variance=(5000-4800)*18=3600 A (Since Seats sold at standard mix is less than budgeted seats,It has an adverse variance) Upper tier tickets: Standard mix ratio for Upper tier ticket=Budgeted sales of upper tier ticket/Total budgeted seats sold=7500/12500=60% Seats sold at standard mix=Total actual seats sold*Standard mix ratio= 12000*60%=7200 seats Sales quantity variance=(7500-7200)*8=2400 A (Since Seats sold at standard mix is less than budgeted seats,It has an adverse variance) Sales quantity variance in total=3600+2400=6000 A Sales mix variance=(Actual seats sold-Seats sold at standard mix)*Budgeted contribution margin per ticket Lower tier tickets: Standard mix ratio for Lower tier ticket=Budgeted sales of lower tier ticket/Total budgeted seats sold=5000/12500=40% Seats sold at standard mix=Total actual seats sold*Standard mix ratio= 12000*40%=4800 seats Sales mix variance=(4200-4800)*18=10800 A (Since Seats sold at standard mix is more than actual seats,It has an adverse variance) Upper tier tickets: Standard mix ratio for Upper tier ticket=Budgeted sales of upper tier ticket/Total budgeted seats sold=7500/12500=60% Seats sold at standard mix=Total actual seats sold*Standard mix ratio= 12000*60%=7200 seats Sales mix variance=(7800-7200)*8=4800 F (Since Seats sold at standard mix is less than actual seats,It has a favorable variance) Sales mix variance in total=10800-4800=6000 A 3 Lower tier ticket has adverse variance in above 3 variances.Reaon is that Actual seats sold is less than budgeted seats. Upper tier ticket has favorable variance in above 2 variances.Reaon is that Actual seats sold is more than budgeted seats.