Question

In: Accounting

1. For your first assignment, management has provided the following revenue and cost information: High-end set...

1. For your first assignment, management has provided the following revenue and cost information:

High-end set economical set
Sales price $3,500 price unit $1,000 Per unit
Labor $875 per unit $250 per unit
materials $1,400 per unit $300 per unit
direct fixed costs $25,000 per month $16,500 per month
allocated fixed cost $85,000 per month $85,000 per month


They want a better understanding of their business to make budgeting and sales goals decisions and have asked you to determine their:For this activity, you have been hired as a team of consultants on a multi-year basis for a global washer and dryer manufacturer. They currently offer two core washer and dryer sets: a high-end model and an economic model. You are tasked to complete several calculations and present your findings to the company stakeholders.

  1. Contribution Margins for each product line
  2. Break-even quantities for each product line
  3. Break-even quantities to earn $500,000 per year margin on the high-end line (at the current sales price)
  4. Break-even quantities to earn $300,000 per year margin on the economical line (at the current sales price)

They expect the product lines to fully absorb the costs allocated to them. They have also asked that you show the each step in your calculations so that they can understand your analysis. (Note: you will be graded on your intermediary values.)

Once you have determined these amounts, they have asked that you:

  • present the information
  • describe how you performed your calculations
  • and explain what the results mean

Solutions

Expert Solution

1.

High end set Economical set
Sales price 3500 1000
Less: Variable costs
Labor 875 250
Materials 1400 300
Contribution per unit 1225 450

2. Break even point for high end set = Total fixed costs / Contribution per unit =  (110,000*12)/ 1225 = 1078 units (rouned off)

Break even point for economical set = Total fixed costs / Contribution per unit = (101,500*12)/ 450 = 2707 units (rouned off)

3. Break-even quantities to earn $500,000 per year margin on the high-end line = Desired profit + Fixed costs / Contribution per unit (110,000*12)+ 500,000 / 1225 = 1486 units

Break-even quantities to earn $300,000 per year margin on the high-end line = Desired profit + Fixed costs / Contribution per unit (101,500*12)+ 300,000 / 450 = 3373 units

Conclusion: The economical set is set a lower price and hence the contribution per unit is lower. However the contribution margin from this set is higher at 45% [ 450/1000] when compared to the high end set at 35% [ 1225/3500]. Since the contribution per unit is lower for the economical model but the fixed costs allocated to both models are similar , the break even units required are higher.


Related Solutions

Knitline Inc. produces high-end sweaters and jackets in a single factory. The following information was provided...
Knitline Inc. produces high-end sweaters and jackets in a single factory. The following information was provided for the coming year. Sweaters Jackets Sales $ 209,600 $ 449,000 Variable cost of goods sold 145,500 196,600 Direct fixed overhead 25,400 47,800 A sales commission of 6% of sales is paid for each of the two product lines. Direct fixed selling and administrative expense was estimated to be $19,900 for the sweater line and $50,400 for the jacket line. Common fixed overhead for...
1) The Soft Company has provided the following information after year-end adjustments: • Allowance for doubtful...
1) The Soft Company has provided the following information after year-end adjustments: • Allowance for doubtful accounts was $11,000 at the beginning of the year and $30,000 at the end of the year. • Accounts receivable were $80,000 at the beginning of the year and $420,000 at the end of the year. • Accounts written off as uncollectible totaled $20,000. • Net sales totaled $2,700,000. • Sales discounts were $100,000. What was the amount of Soft's bad debt expense for...
The Tanner Company has provided the following information after year-end adjustments:
The Tanner Company has provided the following information after year-end adjustments: Allowance for doubtful accounts increased $26,600.Accounts receivable increased $485,000 during the year.Accounts written off as uncollectible totaled $29,500.Sales totaled $2,690,000.Sales discounts were $119,000. What was the amount of Tanner’s net sales? Multiple Choice$2,056,500.$2,571,000.$2,541,500.$2,600,500.
1-First Choice Trading PJSC has provided the following information : Assets as on 31.12.2018 Dhs 340...
1-First Choice Trading PJSC has provided the following information : Assets as on 31.12.2018 Dhs 340 million , Liabilities Dhs 200 million. As on 31.12.2019 , If the assets increased by Dhs 30 million , Liabilities decreased by DHs 25 million , Equity as on 31.12.2019 should be - 195 200 140 135 2- Which of the following is not an internal users of accounting information ? Employees Vice President sales Managing Director External auditors 3- Which of the following...
1. Which of the following statements is NOT true about the Revenue Management? a. Revenue management...
1. Which of the following statements is NOT true about the Revenue Management? a. Revenue management is based on setting and updating prices. b. Revenue management is originated in the airline industry. c. Through revenue management, the firms can allocate their capacity to different fare classes over time in order to maximize revenue. d. Revenue management focuses on shaping demand via controlling supply under the limited capacity. 2. According to the Littlewood’s Rule, which of the following does NOT generate...
1.Sparacino Corporation has provided the following information: Cost per Unit Cost per Period Direct materials $...
1.Sparacino Corporation has provided the following information: Cost per Unit Cost per Period Direct materials $ 6.90 Direct labor $ 3.90 Variable manufacturing overhead $ 1.70 Fixed manufacturing overhead $ 25,200 Sales commissions $ 1.50 Variable administrative expense $ 0.55 Fixed selling and administrative expense $ 8,100 If 5,000 units are produced, the total amount of manufacturing overhead cost is closest to: 2. Glew Corporation has provided the following information: Cost per Unit Cost per Period Direct materials $ 6.00...
Laci Corporation’s is a wholesaler that sells a single product. Management has provided the following cost...
Laci Corporation’s is a wholesaler that sells a single product. Management has provided the following cost data for two levels of monthly sales volume. The company sells the product for $154.00 per unit.   Sales volume (units)   11,200    12,230      Cost of sales $907,200    $990,630      Selling and administrative costs $674,000    $695,630    The best estimate of the total contribution margin when 11,580 units are sold is: $307,160 $716,190 $226,770 $602,160
Call Corporation is a wholesaler that sells a single product. Management has provided the following cost...
Call Corporation is a wholesaler that sells a single product. Management has provided the following cost data for two levels of monthly sales volume. The company sells the product for $140.50 per unit. Sales volume (units).............................................. 6,000 7,000 Cost of sales.......................................................... $497,400 $580,300 Selling, general, and administrative costs............. $273,600 $294,700         1.    The best estimate of the total monthly fixed cost is: $147,000 $771,000 $823,000 $875,000 2. The best estimate of the total variable cost per unit is: $104.00 $128.50...
Baldwin Company has provided the following information for 2019, the first year of the company’s operations....
Baldwin Company has provided the following information for 2019, the first year of the company’s operations. (i) Purchased raw materials on account for $240,000. (ii) Issued $230,000 in raw materials to production ($32,000 were not traceable to specific jobs). (iii) Incurred $242,000 in direct labour costs (24,120 hours) and $92,500 in supervision costs (paid in cash). (iv) Incurred the following additional manufacturing overhead costs: factory utilities $24,000 (paid in cash); depreciation on equipment $45,000; indirect supplies $17,500 (paid in cash)....
Assignment- Collecting Payments Use the information provided in Chapter 19 "Patient Accounts and Practice Management" of...
Assignment- Collecting Payments Use the information provided in Chapter 19 "Patient Accounts and Practice Management" of the text and/or any other sources you have if necessary. Copy and Paste your assignment on a separate MS word document or compatible file, and submit your completed assignment electronically via Moodle prior to due date. Collecting Payments When insurance companies and patients pay for medical services, the medical biller is responsible for collecting and maintaining all payments. The medical biller must also contact...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT