EXERCISE 5-12 Multiproduct Break-Even Analysis LO5-9
Olongapo Sports Corporation distributes two premium golf balls—Flight Dynamic and Sure Shot. Monthly sales and the contribution margin ratios for the two products follow:
Fixed expenses total $183,750 per month.
Required:
- Prepare a contribution format income statement for the company as a whole. Carry computations to one decimal place.
- What is the company's break-even point in dollar sales based on the current sales mix?
- If sales increase by $100,000 a month, by how much would you expect the monthly net operating income to increase? What are your assumptions?
Break-even analysis: It is an analysis of sales revenue or unit where a company is neither earning profits nor incurring any loss.
The preparation of contribution format income statement and break-even analysis.
Answer to Problem 12E
Solution:
1) Contribution formal income statement for the company as a whole. Carry computations to one decimal place is shown below:-
Product | |||
Fight Dynamic | Sure Shot | Total | |
Sales | $150,000 | $250,000 | $400,000 |
CM ratio | 80% | 36% | 52.5% |
Olongapo Sports Corporation’s Contribution format income statement | |
Total | |
Sales | $400,000 |
Variable expenses | $190,000 |
Contribution Margin | $210,000 |
Fixed expenses | $183,750 |
Net operating income | $26,250 |
2) The Break-even point in dollar sales based on the current sales mix is $ 350,000
3) The contribution format income statement with increase in sales by $ 100,000 is shown below:-
Olongapo Sports Corporation’s Contribution format income statement | |
Total | |
Sales | $500,000 |
Variable expenses | $237,500 |
Contribution Margin | $262,500 |
Fixed expenses | $183,750 |
Net operating income | $78,750 |
It is assume that when sales increase by $100,000, the variable expense increase by 25% and the net operating income increases by 200%.
Explanation of Solution
Given:
Product | |||
Fight Dynamic | Sure Shot | Total | |
Sales | $150,000 | $250,000 | $400,000 |
CM ratio | 80% | 36% | ? |
Fixed expenses total $183,750 per month.
Hence it is concluded that the Mauro Products will neither earn profit nor incur loss at $350,000sales revenue. But if the company earns beyond this point, it will make profit and if it falls below the point, the company will suffer loss. A break-even point is technique used the companies to predict the outcome of a decision based on the analysis. It shows the exact point where a company will neither make profit nor suffer loss.
Want to see more full solutions like this?
Chapter 5 Solutions
Managerial Accounting
- Problem II. Omega Enterprises sells two products, Model E100 and F900. Monthly sales and the contribution margin ratios for the two products, follow: Product E100 F900 Total Sales P 700,000 P 300,000 P 1,000,000 Contribution margin ratio 60% 70% The Company’s fixed expenses total P598,500 per month. What is the company’s total contribution margin ratio? What is the company’s total net operating income? The break-even point for the company based on the current sales mix is ______.arrow_forwardOwe Subject: acountingarrow_forwardAnswer full question please.arrow_forward
- Exercise 5-12 (Static) Multiproduct Break-Even Analysis [LO5-9] Olongapo Sports Corporation distributes two premium golf balls-Flight Dynamic and Sure Shot. Monthly sales and the contribution margin ratios for the two products follow: Sales CM ratio Product Flight Dynamic $ 150,000 Total Sure Shot $ 250,000 80% 36% $ 400,000 ? Fixed expenses total $183,750 per month. Required: 1. Prepare a contribution format income statement for the company as a whole. 2. What is the company's break-even point in dollar sales based on the current sales mix? 3. If sales increase by $100,000 a month, by how much would you expect the monthly net operating income to increase? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare a contribution format income statement for the company as a whole. (Round your percentage answers to 2 decimal places (i.e. .1234 should be entered as 12.34).)arrow_forwardSh7arrow_forwardQ3 Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total $486,000 Per Unit $30 12 194,400 Sales Variable expenses Contribution margin Fixed expenses Operating income Required: 1. What is the monthly break-even point in unit sales and in dollar sales? (Do not round intermediate calculations.) Break-even point in unit sales Break-even point in sales dollars Total contribution margin 2. Without resorting to computations, what is the total contribution margin at the break-even point? Units sold 3-a. How many units would have to be sold each month to earn a target profit of $97,200? Use the formula method. 291,600 $18 233,280 $ 58,320 units Menlo Company Contribution Income Statement. Total 3-b. Verify your answer by preparing a contribution format income statement at the target sales level. Unit sales required units units Per unit 4. Refer to part 3 and now assume that the tax rate is 30%. How many units would need to be sold each month…arrow_forward
- Chapter 6, Part 2arrow_forward3arrow_forwardQuestion 4.4 The following is Silver Corporation's contribution format income statement for last month: Sales $1,400,000 Less: variable expenses 800,000 Contribution margin 600,000 Less: fixed expenses 400,000 Operating income $200,000 The company has no beginning or ending inventories and produced and sold 20,000 units during the month. Required: What is the company's contribution margin ratio? What is the company's break-even in units? If sales increase by 100 units, by how much should operating income increase? How many units would the company have to sell to attain target operating income of $225,000? What is the company's margin of safety in dollars? What is the company's degree of operating leverage?arrow_forward
- PROBLEM 7 Tito Company sells several products. Information of average revenue and costs are as follows: Selling price per unitPhp20.00 Variable costs per unit: Direct materialsPhp4.00 Direct manufacturing labor Php1.60 Manufacturing overhead Php0.40 Selling costsPhp2.00 Annual fixed costs Php96,000 26. Calculate the contribution margin per unit. 27. Calculate the number of units Tito's must sell each year to break even. 28. Determine the breakeven point in peso. 29. Calculate the number of units Tito's must sell to yield a profit of Php144,000. PROBLEMarrow_forwardQuestion 6arrow_forwardOmega Enterprise sells two products, Model E100 and F900. Monthly sales and the contribution margin ratios for the two products, follow : Product.. Model E100 Model F900 Total Sales P700,000 P300,000 1,000,000 Contribution margin ratio The company's fixed expenses total P598, 500 per month. 60% 70% ? 3. What is the company's total contribution margin ratio? (2-43) a. 60% c. 70% b. 63% d. 65% 4. What is the company's total net operating income? (2-44) a. P630,000 b. P 31,500 5. The break-even point for the company based on the current sales mix is (2-44) a. P900,000 b. P950,000 P210,000 P420,000 C. d. P1,000,000 P1,050,000 c. d.arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College