Question

In: Accounting

Henna Co. produces and sells two products, T and O. It manufactures these products in separate...

Henna Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 43,000 units of each product. Sales and costs for each product follow.

Product T Product O
Sales $ 761,100 $ 761,100
Variable costs 608,880 76,110
Contribution margin 152,220 684,990
Fixed costs 33,220 565,990
Income before taxes 119,000 119,000
Income taxes (30% rate) 35,700 35,700
Net income $ 83,300 $ 83,300

Required:
1. Compute the break-even point in dollar sales for each product. (Enter CM ratio as percentage rounded to 2 decimal places.)
2. Assume that the company expects sales of each product to decline to 26,000 units next year with no change in unit selling price. Prepare forecasted financial results for next year following the format of the contribution margin income statement as just shown with columns for each of the two products (assume a 30% tax rate). Also, assume that any loss before taxes yields a 30% tax benefit. (Round "per unit" answers to 2 de

3. Assume that the company expects sales of each product to increase to 57,000 units next year with no change in unit selling price. Prepare forecasted financial results for next year following the format of the contribution margin income statement shown with columns for each of the two products (assume a 30% tax rate). (Round "per unit" answers to 2 decimal places.)cimal places. Enter losses and tax benefits, if any, as negative values.)

Solutions

Expert Solution

Selling price per unit of product T = 761100 / 43000 = 17.7

Variable cost per unit of product T = 608880 / 43000 =

14.16

Contribution margin of product T = 17.7 - 14.16 = 3.54

Selling price per unit of product O = 761100 / 43000 = 17.7

Variable cost per unit of product O = 76110 / 43000 = 1.77

Contribution margin per unit of product O = 17.7 - 1.77 = 15.93

1 break even point in unit = fixed cost / contribution margin per unit

Break even point in sales = break even point in unit × selling price

Contribution margin per unit = selling price per unit - variable cost per unit

Product T break even point in unit = 33220 / 3.54 = 9384

Product T break even point in sales = 9384 × 17.7 = 166100

Product O break even point in unit = 565990 / 15.93 = 35530

Product O break even point in sales = 35530 × 17.7 = 628881

2 sales of each products decline to 26000 units

PRODUCT T PRODUCT O
Sales 460200 460200
Less variable cost 368160 46020
Contribution margin 92040 414180
Fixed 33220 565990
Earnings before taxes 30% 58820 (151810)
Tax benefit and expenses (17646) 45543
Net income or loss 41174 (106267)

There is a tax benefit for product O and net loss for product O

3 sales of each products increase to 57000

PRODUCT T PRODUCT O
SALES 1008900 1008900
Less variable cost 807120 100890
Contribution margin 201780 908010
Fixed cost 33220 565990
Earnings before taxes 30% 168560 342020
Tax expenses 50568 102606
Net income 117992 239414

The above are the detailed calculations and equations


Related Solutions

Letter Co. produces and sells two products, T and O. It manufactures these products in separate...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 48,000 units of each product. Sales and costs for each product follow. Product T Product O   Sales $ 825,600 $ 825,600   Variable costs 577,920 165,120   Contribution margin 247,680 660,480   Fixed costs 113,680 526,480   Profit before taxes 134,000 134,000   Income taxes (32% rate) 42,880 42,880   Net profit $...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 53,000 units of each product. Sales and costs for each product follow. Product T Product O   Sales $ 863,900 $ 863,900   Variable costs 604,730 86,390   Contribution margin 259,170 777,510   Fixed costs 116,170 634,510   Profit before taxes 143,000 143,000   Income taxes (40% rate) 57,200 57,200   Net profit $...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 53,000 units of each product. Sales and costs for each product follow. Product T Product O   Sales $ 863,900 $ 863,900   Variable costs 604,730 86,390   Contribution margin 259,170 777,510   Fixed costs 116,170 634,510   Profit before taxes 143,000 143,000   Income taxes (40% rate) 57,200 57,200   Net profit $...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 48,000 units of each product. Sales and costs for each product follow. Product T Product O   Sales $ 825,600 $ 825,600   Variable costs 577,920 165,120   Contribution margin 247,680 660,480   Fixed costs 113,680 526,480   Profit before taxes 134,000 134,000   Income taxes (32% rate) 42,880 42,880   Net profit $...
Henna Co. produces and sells two products, T and O. It manufactures these products in separate...
Henna Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 58,000 units of each product. Sales and costs for each product follow. Product T Product O Sales $ 974,400 $ 974,400 Variable costs 779,520 194,880 Contribution margin 194,880 779,520 Fixed costs 46,880 631,520 Income before taxes 148,000 148,000 Income taxes (32% rate) 47,360 47,360 Net income $...
Oxford Co. produces and sells two lines of t-shirts, Classic and Mod. Oxford provides the following...
Oxford Co. produces and sells two lines of t-shirts, Classic and Mod. Oxford provides the following data. Compute the sales price and the sales volume variances for each product. Budget Actual Unit sales price – Classic …. $15 $16 Unit sales price–Mod ……. $20 $19 Unit sales–Classic ………… 2,400 2,500 Unit sales–Mod ………….. 2,000 1,900
Mcdale Inc. produces and sells two ... Mcdale Inc. produces and sells two products. Data concerning...
Mcdale Inc. produces and sells two ... Mcdale Inc. produces and sells two products. Data concerning those products for the most recent month appear below: Product I49V Product Z50U Sales $ 42,000 $ 47,000 Variable expenses $ 13,000 $ 28,830 The fixed expenses of the entire company were $38,960. The break-even point for the entire company is closest to: Multiple Choice Top of Form $80,790 $73,509 $38,960 $46,080 A cement manufacturer has supplied the following ... A cement manufacturer has...
The Kaumajet Factory produces two products - table lamps and desk lamps. It has two separate...
The Kaumajet Factory produces two products - table lamps and desk lamps. It has two separate departments - Finishing and Production. The overhead budget for the Finishing Department is $492,298, using 375,800 direct labor hours. The overhead budget for the Production Department is $406,351 using 69,700 direct labor hours. If the budget estimates that a desk lamp will require 5 hours of finishing and 8 hours of production, what is the total amount of factory overhead the Kaumajet Factory will...
Twin Products Company produces and sells two products. Product M sells for $12 and has variable...
Twin Products Company produces and sells two products. Product M sells for $12 and has variable costs of $6. Product W sells for $15 and has variable costs of $10. Twin predicted sales of 25,000 units of M and 20,000 of W. Fixed costs are $60,000 per month. Assume that Twin achieved its sales goal of $600,000 for September, but fell short of its expected operating income of $190,000. Which of the following descriptions best describes the actual results reported...
A & B manufactures and sells two types of products to a number of customers. The...
A & B manufactures and sells two types of products to a number of customers. The resources are as follows: Material Type Product X Product Y Available Material P 8 10 31,250 Material Q 10 5 20,000 Direct Labour 4 5 17,500 Maximum sales(demand) for X is 1000 units and Y 3000 units.Contribution margin X $96 and Y $110 Formulate a linear programme Solve in excel Write a brief report to explain the analysis
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT