Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

CLA 1 Comprehensive Learning Assessment – CLO 1, CLO 2, CLO 5, CLO 7 For this assignment, develop a 4-to-6-page response containing written narrative, figures, and charts. Milano Co. manufactures and...

1 answer below »

CLA 1 Comprehensive Learning Assessment – CLO 1, CLO 2, CLO 5, CLO 7
For this assignment, develop a 4-to-6-page response containing written na
ative, figures, and charts.
Milano Co. manufactures and sells three products: product 1, product 2, and product 3. Their unit selling prices are product 1, $40; product 2, $30; and product 3, $20. The per unit variable costs to manufacture and sell these products are product 1, $30; product 2, $15; and product 3, $8. Their sales mix is reflected in a ratio of 6:4:2. Annual fixed costs shared by all three products are $270,000. One type of raw material has been used to manufacture products 1 and 2. The company has developed a new material of equal quality for less cost. The new material would reduce variable costs per unit as follows: product 1 by $10 and product 2 by $5. However, the new material requires new equipment, which will increase annual fixed costs by $50,000.
· If the company continues to use the old material, determine its
eak-even point in both sales units and sales dollars of each individual product. 
· If the company uses the new material, determine its new
eak-even point in both sales units and sales dollars of each individual product. (Round to the next whole unit.) 
· What insight does this analysis offer management for long-term planning?
ALL the Reference should be after XXXXXXXXXXwe should be citation inside paper. we should have separate reference page.
APA Format
The teacher requirement is very high quality and clear. Thank you!
Additional information about APA format
APA Reference:
Answered 1 days After Mar 25, 2022

Solution

Shruti answered on Mar 26 2022
100 Votes
Break-even analysis for Milano Co.
Part 1: Use of Old Material
The analysis is about  Milano Co., which is in the business of manufacturing and selling three products all of which are sold at different prices, and the cost to manufacture these products are also different. The sales mix of the company is represented at 6 units of product 1, followed by 4 units of product 2, and 2 units of product 3. These three products are sold as a composite unit in the ratio of 6:4:2. The company has a fixed cost which is to the tune of $270,000 and this is spread over all these three products. 
The company is interested in knowing what is its
eakeven sales both in units and sales dollars for all these three products which are sold as composite units.
Breakeven analysis is the identification of the
eak-even point for the company which represents the point at which the company makes no profit no loss (Ali, 2022). At
eakeven, the total revenue generated by the company is equal to the total cost of the company (Mitchell, 2022).  At the
eakeven point, the number of units sold by the company is just sufficient for the company to recover its cost, and the company thus makes no profit and no loss.
For Milano company, its 3 products are sold in the sales mix of 6:4:2, and therefore, it is important to first compute the weighted average contribution margin for the company which will then be used to compute the
eakeven in composite units. The weighted average contribution margin for the company is computed as under:
     
    Product 1
    Product 2
    Product 3
    Selling Price per unit
    $40
    $30
    $20
    Less: Variable Costs per unit
    $30
    $15
    $8
    Thus, Contribution per unit
    $10
    $15
    $12
    Sales mix
    6
    4
    2
    Weighted average Contribution margin
    $60
    $60
    $24
    
    $144
We know that the total fixed cost of the company is $270,000 and thus, using the weighted average contribution margin and the total fixed cost, we compute the
eakeven in composite units as under:
Break Even units     = Total Fixed costs / Weighted average Contribution margin
                = $270,000 / $144
                = 1875 units (rounded off)
Now, that we have the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here