Question

In: Accounting

Burntt, Inc. produces and sells two products: phones and tablets. Reinhardt plans to sell 500,000 phones...

Burntt, Inc. produces and sells two products: phones and tablets.

Reinhardt plans to sell 500,000 phones and 100,000 tablets in the coming year. Product price and cost information includes: Phones Tablets Price $850.00 $575.00 Unit Variable Cost $390.00 $250.00 Direct Fixed Cost $335,000 $178,000 Common fixed selling and administrative expenses total $187,600.

Part A What is the sales mix estimated for next year?

Part B Using the sales mix from Part A, determine how many phones and tablets should be sold to break-even.

Part C Prepare a contribution-margin-based income statement for Reinhardt, Inc. based on the unit sales calculated in Part B.

Part D Assume total sales in units are 2,650 in the coming year. What is the margin of safety in units? Explain your answer. Hint: base this on the total number of units, not the breakdown between both products.

Part E Calculate the degree of operating leverage for each product. Assume there are no common fixed expenses. Explain your answer. Hint: if there are no common fixed expenses, the product margin from Part C becomes the operating income.

Solutions

Expert Solution

Part A Sales mix estmated for next year
Budgeted sales revenue for Phones $500,000
Unit selling price $850
Sales quantity 588
Budgeted sales revenue for tablets $100,000
Unit selling price $575
Sales quantity 174
Sales mix
Phones 588 77%
Tablet 174 23%
Total 762
Part B Phone and tablets to be sold to breakeven
Direct Fixed Cost for Phones $335,000
Direct Fixed Cost for Tablets $178,000
Common fixed selling and administrative expenses $187,600
Total Fixed Cost $700,600
Weighted Average selling price per unit
Phones($850 x 77%) $655 $708
Tablets ($575 x 23%) $132 96
Total $787
Weighted Average variable cost per unit
Phones($390 x 77%) $300
Tablets ($250 x 23%) $58
Total $358
Weighted average contribution margin per unit
Weighted Average selling price per unit $787
Weighted Average variable cost per unit $358
Weighted average contribution margin per unit $429
Break even point = $700600/$429 1633
Phones(1633 x 77%) 1258
Tablets (1633 x 23%) 376
Part C Contribution Margin based Income Statement
Phone Tablet Total
Sales Unit 1258 376 1633
Sales Revenue $1,068,989 $216,003 $1,284,991
Variable Cost $490,477 $93,914 $584,391
Contribution Margin $578,512 $122,088 $700,600
Direct Fixed Cost $335,000 $178,000 $513,000
Product Margin $243,512 -$55,912 $187,600
Common fixed selling and administrative expenses $187,600
Net Profit $0
Part D Margin of safety
Margin of safety =(Estimated sales-breakeven sales)/Estimated sales
                                   =(2085550-1284991)/2085550
                                   =38.39%
Margin of safety in dollars = $2085550-$1284991
                                                       = $800559
Estmated sales (2650 x $787)weighted average selling price $    2,085,550
Part E Operating Leverage
Operating Leverage = Contribution Margin/Net operating income
Phone Tablet Total
Sales Unit 1258 376 1633
Sales Revenue $1,068,989 $216,003 $1,284,991
Variable Cost $490,477 $93,914 $584,391
Contribution Margin $578,512 $122,088 $700,600
Direct Fixed Cost $335,000 $178,000 $513,000
Product Margin $243,512 -$55,912 $187,600
Operating leverage 2.38 -2.18 3.73

Related Solutions

Vandenberg, Inc., produces and sells two products: a ceiling fan and a table fan. Vandenberg plans...
Vandenberg, Inc., produces and sells two products: a ceiling fan and a table fan. Vandenberg plans to sell 20,000 ceiling fans and 50,000 table fans in the coming year. Product price and cost information includes: Ceiling Fan Table Fan Price $50   $12   Unit variable cost $9   $8   Direct fixed cost $22,000   $47,000   Common fixed selling and administrative expenses total $94,000. Required: 1. What is the sales mix estimated for next year (calculated to the lowest whole number for each product)?...
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...
Randy Inc. produces and sells tablets. The company incurred the following costs for the May: Advertising...
Randy Inc. produces and sells tablets. The company incurred the following costs for the May: Advertising cost for monthly television ads $ 5,800 Attachable keyboard 19,800 Insurance for delivery truck 580 Factory supervisor's salary 3,550 Marketing manager's salary 3,250 Assembly worker wages 24,000 Miscellaneous soldering material used to seal case 1,050 Hourly wages for factory security guard 2,200 CEO's salary 7,400 Speakers 5,200 Required: Determine each of the following: Direct material Direct labor Manufacturing overhead Total manufacturing cost Total period...
Lloyd and Harry, Inc. is a manufacturer of briefcases. The company produces and sells two products:...
Lloyd and Harry, Inc. is a manufacturer of briefcases. The company produces and sells two products: Leather and Vinyl. Currently, the company uses a traditional costing system to allocate manufacturing overhead to production based on a predetermined manufacturing overhead rate of $100 per machine hour. Management is considering switching to activity based costing to improve costing accuracy. In their analysis of manufacturing overhead, management has identified two activities and cost pools: Product Inspection and Machining. 80% of the total budgeted...
Brancati Inc. produces and sells two products. Data concerning those products for the most recent month...
Brancati Inc. produces and sells two products. Data concerning those products for the most recent month appear below: Product W07C Product B29Z Sales………………………… $25,000 $27,000 Variable expenses………... $7,000 $8,600 Fixed expenses for the entire company for the month were $32,860. Answer the following questions: 1. Determine the overall break-even point for the company. Show your work! 2. If the sales mix shifts toward Product W07C with no change in total sales, what will happen to the break-even point for the...
TOM, Inc. produces and sells two products, L and V. Revenue and cost information for the...
TOM, Inc. produces and sells two products, L and V. Revenue and cost information for the two products from last month appear below: Product L Product V selling price per unit ........... $15.00 $12.00 variable costs per unit .......... $ 8.00 $ 7.00 For the coming month, Betty would like to use linear programming in order to maximize monthly profits. Each month Betty has 80,000 direct labor hours available and 60,000 machine hours available. Product L requires 5 direct labor...
A Company produces and sells two types of smart phones. The price of Type-1 and Type...
A Company produces and sells two types of smart phones. The price of Type-1 and Type –II smart phone assigned by Hamza is Rs. 120,000 per unit and 135,000 respectively. Variable cost for producing type-I phone is Rs. 150,000 and type –II is Rs. 300,000. Suppose there is Rs. 500,000 fixed cost.1. Formulate revenue and cost function for type-I and type-II smart phone jointly.2. Formulate total profit function3. What will be the total profit if Hamza produces and sells 500...
4. Suppose Chipco produces memory chips for hand-held devices such as tablets and phones. Total costs...
4. Suppose Chipco produces memory chips for hand-held devices such as tablets and phones. Total costs in the short-run can be described with the following formula: TC = 300 + 5Q + 0.1(Q2) where Q is the number of chips produced per week and TC is the total cost of chips. a. With the above cost function in mind, make a table of Q, TC, MC, AVC, and ATC at quantities 0, 10, 20, 30, 40, 50, 60, 70, 80,...
. Smith Inc. produces and sells bicycles. They are expecting to sell 95,000 units this year....
. Smith Inc. produces and sells bicycles. They are expecting to sell 95,000 units this year. Their variable costs are $123 per unit and their fixed costs are $9,205,000. a. If they would like to earn 25% per unit, at what price should they sell the bicycles? b. What price should they set to earn 25% if the fixed costs were $8,000,000? c. What if the fixed costs were $8,000,000 and they want to earn 30% per unit?
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT