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 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_forwardWest Island distributes a single product. The companys sales and expenses for the month of June are shown. Using the information presented, answer these questions: A. What is the break-even point in units sold and dollar sales? B. What is the total contribution margin at the break-even point? C. If West Island wants to earn a profit of $21,000, how many units would they have to sell? D. Prepare a contribution margin income statement that reflects sales necessary to achieve the target profit.arrow_forwardQuestion 4 Auto Tires, Inc. sells tires to service stations for an average of $145 each. The variable costs of each tire is $85 and monthly fixed manufacturing costs total $45,000. Other monthly fixed costs of the company total $15,000. Note: No need to enter comma between number Required: 1. What is the break-even level in tires? 2. What is the margin of safety, assuming sales total $190,000? 3. What is the break-even level in tires, assuming variable costs increase by 20 percent and selling price increase by 17 per unit ? 4. What is the break-even level in tires, assuming the selling price goes up by 20 percent, fixed manufacturing costs decline by 10 percent and other fixed costs decline by $1500and variable cost decrease by 1 per unit ?arrow_forward
- Net Income Planning Midvale Corporation sells a single product for $100 per unit, of which $40 is contribution margin. Fixed costs total $180, 000 and net income before income tax is $48, 000. Determine the following a. The present sales volume in dollars. $Answer 570, 000 b. The break - even point in units. Answer 4, 500 units c. The sales volume in units necessary to attain a net income before income tax of $60, 000 Answer 6, 000 units d. The sales volume in units necessary to attain a net income before income tax equal to 10% of sales revenue. Answer 5, 925 units e. The sales volume in units necessary to attain an after - tax net income of $54, 000 if the tax rate is 40% Answer 6,750 units.arrow_forward01:09:21 ook nt nces Lucido Products markets two computer games: Claimjumper and Makeover. A contribution format income statement for a recent month for the two games appears below: Sales Variable expenses Contribution margin Fixed expenses Net operating income Required 1 Required 2 Claimjumper $ 63,900 42,600 $ 21,300 Sales Variable expenses Contribution margin Required: 1. What is the overall contribution margin (CM) ratio for the company? 2. What is the company's overall break-even point in dollar sales? 3. Prepare a contribution format income statement at the company's break-even point that shows the appropriate levels of sales for the two products. Fixed expenses Net operating income (loss) Complete this question by entering your answers in the tabs below. Required 3 Makeover $21,300,000 106,500 42,600 $ Prepare a contribution format income statement at the company's break-even point that sh for the two products. (Do not round intermediate calculations. Round your answers to the r…arrow_forwardMultiproduct breakeven analysis and target profit, taxes Pursuit Company produces two products: Bric and Brac. The following table summarizes the products' details and planned unit sales for the upcoming period: Bric BrAc Sellingpriceperunt...........$S25$30 Variablecostperunit ... $14$17 Planned unit sales volume . . . . . . 800, 000 400,000 Pursuit Company has total fixed costs of $10 million and faces a tax rate of 30%. Required (a)What is Pursuit Company's expected profit at the planned level of sales? (b)Assuming a constant sales mix, what are the unit sales of Bric and Brac required for Pursuit Company to break even? (c) Assuming a constant sales mix, what are the unit sales of Bric and Brac required for Pursuit Company to earn an after-tax income of $910, 000 ?arrow_forward
- Exercise 5-12 (Algo) 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: Product Total Sales CM ratio Flight Dynamic $ 730,000 Sure Shot $ 270,000 $ 1,000,000 63% 77% ? Fixed expenses total $584,500 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 $55,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. 0.1234 should be entered as 12.34).) Flight Dynamic Sure Shot Total Company Amount % Amount % Amount %arrow_forwardMultiproduct Break-Even Analysis Lucido Products markets two computer games: Claimjumper and Makeover. A contribution format income statement for a recent month for the two games appears below: Required: 1. What is the overall contribution margin (CM) ratio for the company? 2. What is the company’s overall break-even point in dollar sales? 3. Verify the overall break-even point for the company by constructing a contribution format income statement showing the appropriate levels of sales for the two products.arrow_forwardQuestion No. 3 CVP – Applied: Revising Sales Incentives Data concerning Wislocki Corporation's single product appear below: Per Unit Percent of Sales Selling price $ 180 100 % Variable expenses 45 25 % Contribution margin $ 135 75 % Fixed expenses are $1,048,000 per month. The company is currently selling 9400 units per month. The marketing manager would like to introduce sales commissions as an incentive for the sales staff. The marketing manager has proposed a commission of $12 per unit. In exchange, the sales staff would accept an overall decrease in their salaries of $106,000 per month. The marketing manager predicts that introducing this sales incentive would increase monthly sales by 440 units. Required: What should be the overall effect on the company's monthly net operating income of this change?arrow_forward
- 1 02:57:48 Menlo Company distributes a single product. The company's sales and expenses for last month follow: Sales Variable expenses Contribution margin Fixed expenses Net operating income Req 1 Total $ 632,000 442,400 Req 2 189,600 154,800 $ 34,800 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each month to attain a target profit of $52,800? 3-b. Verify your answer by preparing a contribution format income statement at the target sales level. 4. Refer to the original data. Compute the company's margin of safety in dollar and percentage terms. 5. What is the company's CM ratio? If the company can sell more units, thereby increasing sales by $55,000 per month, and there is no change in fixed expenses, by how much would you expect monthly net operating income to increase? Complete this question by entering…arrow_forwardExercise 6-12 (Algo) Multiproduct Break-Even Analysis [LO6-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: Product Flight Dynamic Sales CM ratio $ 660,000 Sure Shot $340,000 68% 76% Total $1,000,000 ? Fixed expenses total $567,000 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 $57,000 a month, by how much would you expect the monthly net operating income to increase?arrow_forwardExercise 6-12 (Algo) Multiproduct Break-Even Analysis [LO6-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: Product Flight Dynamic Sales CM ratio $ 740,000 Sure Shot $260,000 Total $1,000,000 63% 77% ? Fixed expenses total $587,000 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 $59,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. 0.1234 should be entered as 12.34).) Flight Dynamic mount Sure Shot % Amount % Total Company Amount %arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College