Question

Integrated Manufacturing Inc. uses CVP tools to analyze overall costs. Total costs for the period were...

Integrated Manufacturing Inc. uses CVP tools to analyze overall costs. Total costs for the period were $100,000. Total sales for the period were $105,000, and the variable cost per unit was $60. Integrated sold 700 units this period. (Write on the Excel)

a.What is Integrated's break-even point in Sales Dollars?

b. If Intergrated wants to generate a 10% return on Sales after taxes, and the tax rate is 30%, how many units must the company sell?

Homework Answers

Answer #1

Requirement a:

Fixed costs
Total costs $100,000
Variable costs [700 units x $ 60] ($42,000)
Fixed costs $58,000
Contribution margin
Sales $105,000
Variable costs ($42,000)
contribution margin $63,000

Contribution margin ratio = Contribution margin ÷ Sales = $63,000 ÷ $105,000 = 60%

Break-even point in Sales in dollars = Fixed costs ÷ Contribution margin ratio = $58,000 ÷ 60% = $96,667

Requirement b:

Required profit = $105,000 x 10% = $10,500

Income before income taxes = $10,500 x (100/70) = $15,000

Contribution margin per unit = ($105,000/700 units) - $60 = $150 - $60 = $90

Sales = (Income before income taxes + Fixed costs) ÷ Contribution margin per unit

= ($15,000 + $58,000) ÷ $90 = 811 units

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Mastery Problem: CVP Analysis - Constructing a Cost-Volume-Profit Chart CVP Analysis and the Contribution Margin Income...
Mastery Problem: CVP Analysis - Constructing a Cost-Volume-Profit Chart CVP Analysis and the Contribution Margin Income Statement For planning and control purposes, managers have a powerful tool known as cost-volume-profit (CVP) analysis. CVP analysis shows how revenues, expenses, and profits behave as volume changes, which helps identify problems and create solutions. In CVP analysis, costs are classified according to behavior: variable or fixed, rather than by category: product (which includes both variable and fixed) or period (which includes both variable...
Mastery Problem: CVP Analysis - Constructing a Cost-Volume-Profit Chart CVP Analysis and the Contribution Margin Income...
Mastery Problem: CVP Analysis - Constructing a Cost-Volume-Profit Chart CVP Analysis and the Contribution Margin Income Statement For planning and control purposes, managers have a powerful tool known as cost-volume-profit (CVP) analysis. CVP analysis shows how revenues, expenses, and profits behave as volume changes, which helps identify problems and create solutions. In CVP analysis, costs are classified according to behavior: variable or fixed, rather than by category: product (which includes both variable and fixed) or period (which includes both variable...
Mastery Problem: CVP and the Contribution Margin Income Statement For planning and control purposes, managers have...
Mastery Problem: CVP and the Contribution Margin Income Statement For planning and control purposes, managers have a powerful tool known as cost-volume-profit (CVP) analysis. CVP shows how revenues, expenses, and profits behave as volume changes. In CVP analysis, costs are classified according to behavior: variable or fixed. Costs are classified by behavior on the income statement in CVP analysis to arrive at operating income. This format is known as the contribution margin income statement. Complete the following table to illustrate...
Crane Corporation has collected the following information after its first year of sales. Sales were $1,600,000...
Crane Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 100,000 units, selling expenses $240,000 (40% variable and 60% fixed), direct materials $514,000, direct labor $270,800, administrative expenses $280,000 (20% variable and 80% fixed), and manufacturing overhead $376,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Break-Even in Units, After-Tax Target Income, CVP Assumptions Campbell Company manufactures and sells adjustable canopies that...
Break-Even in Units, After-Tax Target Income, CVP Assumptions Campbell Company manufactures and sells adjustable canopies that attach to motor homes and trailers. The market covers both new unit purchases as well as replacement canopies. Campbell developed its business plan for the year based on the assumption that canopies would sell at a price of $400 each. The variable costs for each canopy were projected at $200, and the annual fixed costs were budgeted at $120,000. Campbell’s after-tax profit objective was...
4. A company that makes optical computer input devices has calculated their revenue and costs as...
4. A company that makes optical computer input devices has calculated their revenue and costs as follows for the most recent fiscal period: Sales ​$522 000 Costs: ​Fixed Costs​ $145 000 ​Variable Costs ​208 800 Total Costs ​353 800 Net Income ​$168 200 ​What is the break-even point in sales dollars? 5. A company that makes environmental measuring devices has calculated their revenue and costs as follows for the most recent fiscal period: Sales ​$750 000 Costs: ​Fixed Costs​ $200...
Sandy Bank, Inc., makes one model of wooden canoe. and, the information for it follows: Number...
Sandy Bank, Inc., makes one model of wooden canoe. and, the information for it follows: Number of canoes produced and sold 500 700 850 Total costs Variable costs $ 90,000 $ 126,000 $ 153,000 Fixed costs $ 119,000 $ 119,000 $ 119,000 Total costs $ 209,000 $ 245,000 $ 272,000 Cost per unit Variable cost per unit $ 180.00 $ 180.00 $ 180.00 Fixed cost per unit 238.00 170.00 140.00 Total cost per unit $ 418.00 $ 350.00 $ 320.00...
Break-Even in Units, After-Tax Target Income, CVP Assumptions Campbell Company manufactures and sells adjustable canopies that...
Break-Even in Units, After-Tax Target Income, CVP Assumptions Campbell Company manufactures and sells adjustable canopies that attach to motor homes and trailers. The market covers both new unit purchases as well as replacement canopies. Campbell developed its business plan for the year based on the assumption that canopies would sell at a price of $400 each. The variable costs for each canopy were projected at $200, and the annual fixed costs were budgeted at $120,000. Campbell’s after-tax profit objective was...
In CVP analysis, the unit contribution margin is: Sales price per unit less cost of goods...
In CVP analysis, the unit contribution margin is: Sales price per unit less cost of goods sold per unit Sales price per unit less FC per unit Sales price per unit less total VC per unit Same as the CM Maroon Company’s CM ratio of 24%.  Total FC are $84,000.  What is Maroon’s B/E point in sales dollars? $20,160 $110,536 $240,000 $350,000       If a firm’s forecasted sales are $250,000 and its B/E sales are $190,000, the margin of safety in dollars is:...
Number of canoes produced and sold 550 750 900 total costs variable costs 104,500 142,500 171,000...
Number of canoes produced and sold 550 750 900 total costs variable costs 104,500 142,500 171,000 fixed costs 198,000 198,000 198,000 total costs 302,500 340,500 369,000 cost per unit variable cost per unit 190.00 190.00 190.00 fixed cost per unit 360.00 264.00 220.00 total cost per unit 550.00 454.00 410.00 Sandy Bank sells its canoes for $500 each. Required: 1. Suppose that Sandy Bank raises its selling price to $500 per canoe. Calculate its new break-even point in units and...