Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cloud Computing A Security And Privacy Guide

Authors: Ben Halpert

1st Edition

0470874740, 978-0470874745

More Books

Students also viewed these Accounting questions