Question

This year Cairo Company sold 29,000 units of its only product for $19.20 per unit. Manufacturing and selling the product required $114,000 of fixed manufacturing costs and $174,000 of fixed selling and administrative costs. Its per unit variable costs follow.

   

Material		$	3.40
Direct labor (paid on the basis of completed units)			2.40
Variable overhead costs			0.34
Variable selling and administrative costs			0.14

Next year the company will use new material, which will reduce material costs by 70% and direct labor costs by 30% and will not affect product quality or marketability. Management is considering an increase in the unit sales price to reduce the number of units sold because the factory’s output is nearing its annual output capacity of 34,000 units. Two plans are being considered. Under plan 1, the company will keep the price at the current level and sell the same volume as last year. This plan will increase income because of the reduced costs from using the new material. Under plan 2, the company will increase price by 30%. This plan will decrease unit sales volume by 15%. Under both plans 1 and 2, the total fixed costs and the variable costs per unit for overhead and for selling and administrative costs will remain the same.

4.

value:
20.00 points

Required information

Required:
1.	Compute the break-even point in dollar sales for both (a) plan 1 and (b) plan 2. (Round your intermediate calculations to 2 decimal places and final answers to the nearest dollar amount. Omit the "$" sign in your response.)

   

Plan 1	$
Plan 2	$

References

WorksheetLearning Objective: 22-A1 Compute the contribution margin and describe what it reveals about a company’s cost structure.

Difficulty: 3 HardLearning Objective: 22-P2 Compute the break-even point for a single product company.

Check my work

5.

value:
20.00 points

Required information

2.

Prepare a forecasted contribution margin income statement with two columns showing the expected results of plan 1 and plan 2. The statements should report sales, total variable costs, contribution margin, total fixed costs, income before taxes, profit taxes (30% rate), and net profit. (Input all amounts as positive values. Round your contribution margin ratio to 2 decimal place, other intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount. Omit the "$" sign in your response.)

  

CAIRO CO. Forecasted Contribution Margin Income Statement
	Plan 1	Plan 2
(Click to select)Rent on factoryTaxes on factoryFactory maintenanceSales commissionsSales	$	$
(Click to select)Office equipment leaseRent on factorySales commissionsVariable costsFactory maintenance
(Click to select)Gross profitContribution margin
(Click to select)Office equipment leaseFactory maintenanceRent on factoryFixed costsSales commissions
(Click to select)Rent on factoryOffice equipment leaseFactory maintenanceSales commissionsIncome before taxes
(Click to select)Sales commissionsOffice equipment leaseFactory maintenanceRent on factoryIncome taxes
(Click to select)Net lossNet income	$	$

References

Answer 1

Solution:

Part 1 --- Break Even Point in dollar sales

Calculation of CM Ratio under both Plan	Plan 1	Plan 2
Unit Selling Price	$19.20	$24.96
Unit Variable Cost
Direct Materials per unit ($3.40*30%)	$1.02	$1.02
Direct Labor Cost per unit ($2.40*70%)	$1.68	$1.68
Variable Overhead costs per unit	$0.34	$0.34
Variable selling and administrative costs per unit	$0.14	$0.14
Unit Variable Cost	$3.18	$3.18
Contribution Margin Per Unit (Unit Selling Price - Unit Variable Cost)	$16.02	$21.78
CM Ratio (Contribution Margin / Selling Price x 100)	83.44%	87.26%
Break Even Point in dollar sales	Plan 1	Plan 2
Total Fixed Costs ($114,000 + 174,000)	$288,000	$288,000
CM Ratio	83.44%	87.26%
Break Even Point in dollar sales (Total Fixed Costs / CM Ratio)	$345,158	$330,048

Part 2 – Forecasted Contribution Margin Income Statement

CAIRO CO. Forecasted Contribution Margin Income Statement
	Plan 1 (29,000 Units)	Plan 2 (24,650 Units)
Sales Revenue	$556,800 (29,000*19.20)	$615,264 (24,650*24.96)
Less: Variable Costs	$92,220 (24,000*3.18)	$78,387 (24,650*3.18)
Contribution Margin	$464,580	$536,877
Total Fixed Costs	$288,000	$288,000
Income before taxes	$176,580	$248,877
Less: Taxes @ 30%	$52,974	$74,663
Net Profit	$123,606	$174,214

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you