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 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

$

100,640

$

100,640

  1. a) Calculate the contribution Margin ration and Compute the break-even point in dollar sales for each product.

b) Assume that the company expects sales of each product to decline to 41,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 32% tax rate). Also, assume that any loss before taxes yields a 32% tax benefit.(Round "per unit" answers to 2 decimal places.)

c) Assume that the company expects sales of each product to increase to 72,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 32% tax rate). (Round "per unit" answers to 2 decimal places.)

Solutions

Expert Solution

a) Calculation of Contribution Margin Ratio and Break Even Point in Dollar

Product T Product O
i) Contribution Margin 194,880 779,520
ii) Sales 974,400 974,400
iii) Contribution Margin Ratio [(i/ii)*100] 20% 80%
iv) Fixed costs 46,880 631,520
v) Break Even Point in Dollars (iv/iii) 234,400 789,400

b) Calculation of Selling price, variable cost and contribution margin per unit (Amounts in $)

Product T Product O
Selling Price per unit 16.80 (974,400/58,000 units) 16.80 (974,400/58,000 units)
Variable cost per unit 13.44 (779,520/58,000 units) 3.36 (194,880/58,000 units)
Contribution margin per unit 3.36 (194,880/58,000 units) 13.44 (779,520/58,000 units)

Forecasted Income Statement based on 41,000 units (Amounts in $)

Product T Product O
Sales 688,800 (41,000*16.80) 688,800 (41,000*16.80)
Less: Variable costs 551,040 (41,000*13.44) 137,760 (41,000*3.36)
Contribution Margin 137,760 551,040
Less: Fixed Costs 46,880 631,520
Income/(Loss) before taxes 90,880 (80,480)
Income Taxes (32% rate) (29,082) 25,754
Net Income/(Loss) 61,798 (54,726)

c) Forecasted Income Statement based on 72,000 units (Amounts in $)

Product T Product O
Sales 1,209,600 (72,000*16.80) 1,209,600 (72,000*16.80)
Less: Variable costs 967,680 (72,000*13.44) 241,920 (72,000*3.36)
Contribution Margin 241,920 967,680
Less: Fixed Costs 46,880 631,520
Income/(Loss) before taxes 195,040 336,160
Income Taxes (32% rate) (62,413) (107,571)
Net Income/(Loss) 132,627 228,589

Related Solutions

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 $...
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 $...
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