Question
I need this ASAP! ITS DUE AT 9 PM 11/9/2013!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Based upon the following data taken from the records of Bruce Inc., prepare a contribution
I need this ASAP! ITS DUE AT 9 PM 11/9/2013!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Based upon the following data taken from the records of Bruce Inc., prepare a contribution margin analysis report for the year ended December 31, 2012. For Year Ended December 31, 2012 Actual Planned Difference Increase (Decrease) Sales $312,000 $325,000 $(13,000) Less: Variable cost of goods sold $169,200 $182,000 $(12,800) Variable selling and administrative expenses 32,400 39,000 (6,600) Total $201,600 $221,000 $(19,400) Contribution margin $110,400 $104,000 $ 6,400 Number of units sold 120,000 130,000 (10,000) Per unit: Sales price $2.60 $2.50 .10 Variable cost of goods sold 1.41 1.40 .01 Variable selling and administrative expenses .27 .30 (.03)
Based upon the following data taken from the records of Bruce Inc., prepare a contribution margin analysis report for the year ended December 31, 2012. For Year Ended December 31, 2012 Sales Less: Variable cost of goods sold Variable selling and administrative expenses Total Contribution margin Number of units sold Per unit: Sales price Variable cost of goods sold Variable selling and administrative expenses Actual $312,000 $169,200 32,400 $201,600 $110,400 120,000 $2.60 1.41 .27 Planned $325,000 $182,000 39,000 $221,000 $104,000 130,000 $2.50 1.40 .30 Difference Increase (Decrease) $(13,000) $(12,800) (6,600) $(19,400) $ 6,400 (10,000) .10 .01 (.03) Based upon the following data taken from the records of Bruce Inc., prepare a contribution margin analysis report for the year ended December 31, 2012. Contribution Margin Analysis for the year ended 31st Dec.2012 Particulars Planned contribution Margin Effect of change in sales Sales Quantity factor(120000-130000)*2.50 Unit price factor (2.60-2.50)*120000 Total effect of change in sales Effect of changes in Variable cost of goods sold Variable cost Quantity factor(130000-120000)*1.40 Unit Cost factor (1.40-1.41)*120000 Total effect of change invariable cost of goods sold Effect of changes in Variable & adminstrative expenses Variable Cost Quantity factor(130000-120000)*.30 Unit Cost factor (.30-.270)*120000 Total effect of change in variable & adminstrative expenses Actual contribution Margin Details $ Amount $ 104,000 (25,000) 12,000 (13,000) 14,000 (1,200) 12,800 3,000 3,600 6,600 110,400Step 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