Needs to be in Excel format Consider the following information regarding Wayne M

Question

Needs to be in Excel format

Consider the following information regarding Wayne Manufacturing Company and the following instructions. This is similar to Problems 20-5A and 20-5B in our textbook Wayne Manufacturing Company has four operating divisions. During the first quarter of 2016, the company reported the divisional results shown below and aggregate income shown below Aggregate Income Division: North South East West $561,000 $ 341,000 $ 297,000 71,500 (27,500$ 429,000 $ Sales Cost of goods sold Selling and administrative expenses Income (loss) from operations 198,000 165,000 77,000 (44,000) $ 159,500 330,000 66,000 275,000 88,000 66,000 $ $165,000 $ Analysis reveals the following percentages of variable costs in each division Division: North South East West Cost of goods sold Selling and administrative expenses 70% 40% 80% 50% 75% 65% 90% 70% Discontinuance of any division would save 50% of the fixed costs and expenses for that division Top management is very concerned about the unprofitable divisions (East and West). Consensus is that one or both of the divisions should be discontinued Instructions - Your solutions should be clearly labeled on Solutions of this workbook. (a) Compute the contribution margin for the East and West Divisions. (See illustration 20-17 for guidance, if needed.) (b) Prepare an incremental analysis concerning the possible discontinuance of (1) East Division and (2) West Division. What course of action do you recommend for each division? Should elther be closed? (See illustration 20-18 for guidance, if needed.) (c) Prepare a columnar condensed income statement for Wayne Manufacturing, assuming the division(s) that should be eliminated are eliminated. Use the CVP format. Remember: Closed division's unavoidable fixed costs are allocated equally to the continuing divisions.(See Illustrations 20-16 and 20-17 for guidance, if needed.,) Problem &Instructions; Solutions Sheet3 Ready

Explanation / Answer

A)

Contribution margin for east division = Sales - Variable costs

= 341000 - 0.75*297000 - 0.65*71500

= 71775

Contribution margin for west division = Sales - Variable costs

= 198000 - 0.9*165000 - 0.7*77000

= -4400

2. Incremental analysis of east division:

Incremental Contribution margin = 71775

Incremental fixed costs = 0.5*(0.25*297000+0.35*71500)

= 49637.5

So, incremental net income = 71775-49637.5

= 22137.5

Since, the incremental income is positive, it shouldn't be discontinued.

Incremental analysis of west division:

Incremental Contribution margin = -4400

Incremental fixed costs = 0.5*(0.1*165000+0.3*77000)

= 19800

So, incremental net income = -4400-19800

= -24200

Since, the incremental income is negative, it should be discontinued.

3. After the elimination of west division, the fixed costs that will be allocated among other divisions = 19800

The incremental income statement =

Sales = 561000+429000+341000 = 1331000

Variable costs =

Cost of goods sold = 0.7*330000+0.8*275000+0.75*297000

= 673750

Selling and administration Expense = 0.4*66000+0.5*88000+0.75*71500

= 124025

Total variable costs = 673750+124025 = 797775

Contribution margin = 1331000 - 797775 = 533225

Fixed costs:

Cost of goods sold = 0.3*330000+0.2*275000+0.25*297000+0.5*0.1*165000

= 236500

Selling and administration Expense = 0.6*66000+0.5*88000+0.25*71500+0.5*0.3*77000

= 113025

Total fixed costs = 236500+113025 = 349525

Net Income = 533225-349525 = 183700

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.