X hits on this document

175 views

0 shares

0 downloads

0 comments

16 / 62

14-22 (Cont'd.)

14-22 Excel Application

Revenues, Sales Variances, and

Customer Profitability Analysis

Detroit Penguins

Original Data

Lower-Tier

Upper-Tier

  Tickets

  Tickets

Selling price

     $35

    $14

Downtown arena fee

       10

        6

Reservation network fee

         5

        3

Contribution margin per ticket

     $20

    $  5

Budgeted

Actual

Seats Sold

Seats Sold

Lower-Tier

 4,000

 3,300

Upper-Tier

 6,000

 7,700

Total

10,000

11,000

Problem 1

Sales Volume Variance calculations

Lower-tier tickets

$(14,000)

U

Upper-tier tickets

$   8,500

F

All tickets

$  (5,500)

U

Problem 2  

Sales - mix percentages

Budgeted

Actual

Lower-tier

0.4

0.3

Upper-tier

0.6

0.7

Sales-quantity variance calculations

Lower-tier tickets

$  8,000

F

Upper-tier tickets

$  3,000

F

All tickets

$11,000

F

Sales-mix variance calculations

Lower-tier tickets

$(22,000)

U

Upper-tier tickets

$   5,500

F

All tickets

$(16,500)

U

Document info
Document views175
Page views175
Page last viewedThu Dec 08 15:11:23 UTC 2016
Pages62
Paragraphs2332
Words13486

Comments