Show the contribution margin income statement

Assignment Help Managerial Accounting
Reference no: EM131273301 , Length:

Problem A:

EasyBake Company is able to produce two toy products, a Little Oven and a Big Oven, with the same machine in its factory. NOTE that only ONE Oven can be manufactured at a time using this machine. The Company currently makes both ovens, but management is concerned that this strategy is not providing maximum benefit. They are thinking of adding a second shift and have asked you to figure out their best course of action. The following information is available:

EasyBake Data:


Little Oven Big Oven
Selling price per unit 110 150
Variable costs per unit 30 80
Contribution margin per unit 80 70
Machine hours to produce ONE unit 0.4 hours 1.0 hours
Maximum customer demand for each Oven per month (max they can sell) 550 units 200 units

The company presently operates the machine for a single eight-hour shift for 22 working days each month. Management is thinking about operating the machine for two shifts, which will increase its productivity by another eight hours per day for 22 days per month. This change would require $15,000 additional fixed costs per month.

Required (NOTE--show all calculations for full credit):

1 Determine the contribution margin per machine hour that each product generates.

2 How many units of the Little Oven and the Big Oven should the company produce if it continues to operate with only one shift? Assume all ovens produced are sold.

3 How much total contribution margin does this sales mix produce each month?

4 If the company adds another shift, how many units of the Little Oven and the Big Oven should it produce?

5 How much total contribution margin would this mix produce each month?

6 Should the company add the new shift?

7 Suppose that, based on market research, the company determines that it can increase the Little Oven's maximum sales to 650 units per month by spending $12,000 per month in marketing efforts, which is a fixed cost. Should the company pursue this strategy and the double shift? Provide support for your answer.

Problem B:

Weather-Tight sells windows and doors. The following data applies to the company's operating activities:


 Windows  Doors  Total
Current sales mix in units percentage 80.00% 20.00% 100.00%
Selling Price per Unit $200 $500
Variable Cost per Unit $125 $350
Fixed Costs $580,000 $320,000 $900,000
Current Unit Volume 64,000 16,000 80,000

Use the space provided below for organized calculations (including things like Current Unit Volume, Wtd CM, Wtd Average CM, Sales Mix, etc. See the narrated lectures for guidance. The detailed questions you are required to answer start on line 40 of this worksheet and are also listed briefly in the SOLUTION space provided starting in Column J of this worksheet:

Required:

1 What is the current break-even point in units for both products combined?

2 What is the number of units of each product that need to be sold at the current break-even point?

3 What is the current break-even point in sales dollars for both products combined?

4 How much, in sales dollars, of each product does the company currently need to sell at the break-even point?

5 Show the Current Contribution Margin Income Statement at Break-Even.

6 Show the Contribution Margin Income Statement at the Current Sales Level.

7 What is the Margin of Safety at the Current Sales Level?

The Company is working on budgets for next year and plans a 10% increase in Target Pretax Income; a 10% increase in both Selling Price and Variable Cost; and a 20% increase in Fixed Costs, keeping the Current Sales Mix in Dollars constant.

8 Show the Contribution Margin Income Statement at the Target Pretax Income Level. HINT--you need to start at the bottom of the Contribution Margin Income Statement and work your way up to the top to figure this out.

9 What is the Sales Unit Volume of each product needed to achieve the Target Level of Pretax Income?

10 What is the Margin of Safety at the Target Sales Level?

Attachment:- worksheet.xlsx

Verified Expert

The given solution provides answers two problems relating to cost-volume profit analysis. Problem A is in relation to calculation of Contribution margin, break even sales, optimal production mix and decision making as to expansion for EasyBake Company. Problem B was in relation to Weather Tight which produces Windows and Doors. The calculations for break-even sales, margin of safety, target profits, etc. were made.

Reference no: EM131273301

Questions Cloud

Client-server model : How does client-server model differ from a SaaS model as a method for accessing an ehr application?
Most likely to affect demand for lines of washburn guiters : Can someone please explain to me in details. 1. What factors are most likely to affect the demand for the lines of Washburn guitars (a) bought by a first-time guitar buyer and (b) bought by a sophisticated musician who wants a signature model.
Risk response strategy paper : Write a 1-2 page paper, based on researching resource articles, on the analysis and evaluation of the risk response strategies listed below. Analyze and evaluate the project risk response strategies for negative (threats) and positive (opportunitie..
What physiological origin of the child recurrent infections : A 71-year-old male patient with a history of myocardial infarction and peripheral vascular disease has been advised by his nurse practitioner to begin taking 81 mg aspirin once daily. Which of the following statements best captures an aspect of th..
Show the contribution margin income statement : MFE 6100 - Determine the contribution margin per machine hour that each product generates and What is the current break-even point in units for both products combined?
Behavior and attitudes of organizational members : Explain the concept of organizational effectiveness, as it relates to the interactions of members. Describe methods used to assess the behaviors and attitudes of organizational members, and apply 1 model in an analysis of your organization.
What should schools do to prevent the potential risk : What should schools (colleges or universities) do to prevent and manage the potential risk of sexual harassment conduct by a coach towards an athlete or sexual harassment conduct by one athlete towards another athlete?
Consistent with the products stage in its life cycle : What type of deodorant do you use? What stage of the product life cycle is it in? Is the deodorant manufacturer’s marketing strategy—its four Ps—consistent with the product’s stage in its life cycle? Explain.
Comprehensive natural gas strategy : What threats in the external environment could cause this comprehensive natural gas strategy to fail? What can managers do to help ensure that the plan is executed successfully?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd