Question

In: Accounting

Consider the following information regarding Wayne Manufacturing Company and the following instructions. This is similar to...

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.
Division: North South East West Aggregate Income
Sales $          454,410 $          347,490 $          276,210 $          160,380
Cost of goods sold              267,300              222,750              240,570              133,650
Selling and administrative expenses                53,460                71,280                57,915                62,370
Income (loss) from operations $          133,650 $            53,460 $           (22,275) $           (35,640) $      129,195
Analysis reveals the following percentages of variable costs in each division.
Division: North South East West
Cost of goods sold 70% 80% 75% 90%
Selling and administrative expenses 40% 50% 65% 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 either 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.)

Solutions

Expert Solution

Solution a:

Identification of Variable & Fixed Cost
Particulars North South East West
Cost of Goods Sold:
Total cost of goods sold $267,300.00 $222,750.00 $240,570.00 $133,650.00
% of variable COGS 70% 80% 75% 90%
Variable COGS $187,110.00 $178,200.00 $180,427.50 $120,285.00
Fixed COGS $80,190.00 $44,550.00 $60,142.50 $13,365.00
Selling & Administrative Expense:
Total Selling & Adminstrative Expense $53,460.00 $71,280.00 $57,915.00 $62,370.00
% of Variable Cost 40% 50% 65% 70%
Variable Selling & Administrative Expense $21,384.00 $35,640.00 $37,644.75 $43,659.00
Fixed Selling& Administrative Expense $32,076.00 $35,640.00 $20,270.25 $18,711.00
Computation of Contribution Margin for East & West divison
Particulars East West
Sales $276,210.00 $160,380.00
Variable Cost:
Variable COGS $180,427.50 $120,285.00
Variable Selling & Administrative Expense $37,644.75 $43,659.00
Contribution $58,137.75 -$3,564.00

Solution b:

Incremental Analysis - East Division
Particulars Alt 1 - Continue Alt 2 - Discontinue Difference (Alt2)
Sales $276,210.00 $0.00 -$276,210.00
Variable Cost:
Variable COGS $180,427.50 $0.00 -$180,427.50
Variable Selling & Administrative Expense $37,644.75 $0.00 -$37,644.75
Contribution $58,137.75 $0.00 -$58,137.75
Fixed Cost:
Fixed COGS $60,142.50 $30,071.25 -$30,071.25
Fixed Selling& Administrative Expense $20,270.25 $10,135.13 -$10,135.13
Net Income -$22,275.00 -$40,206.38 -$17,931.38

Discontinue of East divison will result in to additional loss of $17,931.38, hence east divison should not be discontinued.

Incremental Analysis - West Division
Particulars Alt 1 - Continue Alt 2 - Discontinue Difference (Alt2)
Sales $160,380.00 $0.00 -$160,380.00
Variable Cost:
Variable COGS $120,285.00 $0.00 -$120,285.00
Variable Selling & Administrative Expense $43,659.00 $0.00 -$43,659.00
Contribution -$3,564.00 $0.00 $3,564.00
Fixed Cost:
Fixed COGS $13,365.00 $6,682.50 -$6,682.50
Fixed Selling& Administrative Expense $18,711.00 $9,355.50 -$9,355.50
Net Income -$35,640.00 -$16,038.00 $19,602.00

Discontinuance of west divison will result in to addtional savings for $19,602 therefore, this divison must be discontinued.

Solution c:

Income Statement - Wayne Manufacturing
Particulars North South East Total
Sales $454,410.00 $347,490.00 $276,210.00 $1,078,110.00
Variable Cost:
Variable COGS $187,110.00 $178,200.00 $180,427.50 $545,737.50
Variable Selling & Administrative Expense $21,384.00 $35,640.00 $37,644.75 $94,668.75
Contribution $245,916.00 $133,650.00 $58,137.75 $437,703.75
Fixed Cost:
Fixed COGS $80,190.00 $44,550.00 $60,142.50 $184,882.50
Fixed Selling& Administrative Expense $32,076.00 $35,640.00 $20,270.25 $87,986.25
Allocated Fixed Cost of West Divison ($16038/3) $5,346.00 $5,346.00 $5,346.00 $16,038.00
Net Income $128,304.00 $48,114.00 -$27,621.00 $148,797.00

Related Solutions

Consider the following information regarding Wayne Manufacturing Company and the following instructions. This is similar to...
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. Division: North South East West Aggregate Income Sales $          368,072 $          281,467 $          223,730 $          129,908 Cost of goods sold              216,513               180,428               194,862               108,257 Selling and administrative...
Consider the following information regarding Wayne Manufacturing Company and the following instructions. This is similar to...
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. Division: North South East West Aggregate Income Sales $454,410 $347,490 $276,210 $160,380 Cost of goods sold 267,300 222,750 240,570 133,650 Selling and administrative expenses 53,460 71,280 57,915 62,370 Income (loss) from...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of June, 2016 are as follows. Production data Units Percent Complete Work in process units, June 1 2,600 61% Units started into production 6,285 Work in process units, June 30 3,000 38% Cost data Work in process, June 1...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of June, 2016 are as follows. Production data Units Percent Complete Work in process units, June 1 2,600 61% Units started into production 6,285 Work in process units, June 30 3,000 38% Cost data Work in process, June 1...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of June, 2016 are as follows. Production data Units Percent Complete Work in process units, June 1 2,600 61% Units started into production 6,285 Work in process units, June 30 3,000 38% Cost data Work in process, June 1...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of June, 2016 are as follows. Production data Units Percent Complete Work in process units, June 1 2,600 61% Units started into production 6,285 Work in process units, June 30 3,000 38% Cost data Work in process, June 1...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of June, 2016 are as follows. Production data Units Percent Complete Work in process units, June 1 2,600 61% Units started into production 6,285 Work in process units, June 30 3,000 38% Cost data Work in process, June 1...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of June, 2016 are as follows. Production data Units Percent Complete Work in process units, June 1 2,600 61% Units started into production 6,285 Work in process units, June 30 3,000 38% Cost data Work in process, June 1...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of June, 2016 are as follows. Production data Units Percent Complete Work in process units, June 1 2,600 61% Units started into production 6,285 Work in process units, June 30 3,000 38% Cost data Work in process, June 1...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures...
Consider the following information from Manufacturing Inc., then see the instructions that follow. Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of June, 2016 are as follows. Production data Units Percent Complete Work in process units, June 1 2,600 61% Units started into production 6,285 Work in process units, June 30 3,000 38% Cost data Work in process, June 1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT