Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ember Inc. prepared the budget for 2017 assuming a 20% market share based on total sales in the Midwest region of the United States. (Click
Ember Inc. prepared the budget for 2017 assuming a 20% market share based on total sales in the Midwest region of the United States. (Click the icon to view the budgeted and actual results.) (Click the icon to view the budgeted and actual sales mix and contribution margin information.) (Click the icon to view the sales variances.) Required Calculate the market share and market-size variances for Ember Inc. in 2017. (Calculate all variances in terms of contribution margin.) Comment on the results. Sales variances - X Favou Budgeted and actual results x Actual units sold Budgeted CM per unit 4.60 Sales- volume Static budget units sold ) = variance 132,000 ) = $ 30,360 F 88.000 $ 195,910 U Kostor $ x 138,600 The market was estimated to reach sales of 1.10 million cartons in the region. However, actual total sales volume in the Midwestern region was 1.32 million cartons. Budgeted and actual results for 2017 are as follows: Budget for 2017 Actual for 2017 Selling Variable Cost Cartons Selling Variable Cost Cartons Product Price per Carton Sold Price per Carton Sold Kostor $ 13.00 $ 8.40 132,000 $ 13.40 138,600 Limba $ 18.00 $ 11.15 88,000 $ 19.20 $ 11.15 59,400 Limba $ 6.85 x 59,400 The total sales-volume variance is $ 165,550U $9.05 Budgeted Actual qty all units sold Budgeted qty all units sold ) 220,000 ) sales-mix % x ( ( Budgeted CM per unit 4.60 Sales- quantity variance = $ 60,720 U $ 60,280 U Sales mix and contribution margin -X Kostor 198,000 60 % x $ Limba 198,000 220,000 ) x 40 % x $ 6.85 The total sales-quantity variance is $ 121,000 U Budget for 2017 Sales Volume Sales Mix Contribution Actual Actual Sales-mix Contribution Margin per Unit sales-mix %- qty all units sold 198,000 xl X Budgeted sales-mix % ) 60 %) x $ Budgeted CM per unit 4.60 variance = $ 91,080 F Kostor $ 4.60 in Units (Based on Units) 132,000 60 % 88,000 40 % Margin 607,200 602,800 Kostor 70 % - Limba $ 6.85 Limba 198,000 x 30 40 %) x $ 6.85 $ 135,630 U 220.000 100 % $ 1,210,000 Total The total sales-mix variance is $ 44.550 U Actual for 2017 Done Contribution Margin Sales Volume Print Sales Mix Contribution per Unit Kostor $ 4.35 $ in Units (Based on Units) 138.600 70 % 59,400 30 % 198,000 100 % Margin 602,910 478,170 Choose from any drop-down list and then click Check Answer. Limba $ 8.05 $ 1,081,080 4 parts remaining Total
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started