Question

In: Accounting

CASE 4–20 Ethics and the Manager, Understanding the Impact of Percentage Completion on Profit—Weighted-Average Method [Course...

CASE 4–20 Ethics and the Manager, Understanding the Impact of Percentage Completion on Profit—Weighted-Average Method [Course Objective B] Gary Stevens and Mary James are production managers in the Consumer Electronics Division of General Electronics Company, which has several dozen plants scattered in locations throughout the world. Mary manages the plant located in Des Moines, Iowa, while Gary manages the plant in El Segundo, California. Production managers are paid a salary and get an additional bonus equal to 5% of their base salary if the entire division meets or exceeds its target profits for the year. The bonus is determined in March after the company’s annual report has been prepared and issued to stockholders.
Shortly after the beginning of the New Year, Mary received a phone call from Gary that went like this:
Gary: How’s it going, Mary?
Mary: Fine, Gary. How’s it going with you?
Gary: Great! I just got the preliminary profit figures for the division for last year and we are within $200,000 of making the year’s target profits. All we have to do is pull a few strings, and we’ll be over the top!
Mary: What do you mean? Gary: Well, one thing that would be easy to change is your estimate of the percentage completion of your ending work in process inventories. Mary: I don’t know if I can do that, Gary. Those percentage completion figures are supplied by Tom
Winthrop, my lead supervisor, who I have always trusted to provide us with good estimates.
Besides, I have already sent the percentage completion figures to corporate headquarters. Gary: You can always tell them there was a mistake. Think about it, Mary. All of us managers are doing as much as we can to pull this bonus out of the hat. You may not want the bonus check, but the rest of us sure could use it.
The final processing department in Mary’s production facility began the year with no work in process inventories. During the year, 210,000 units were transferred in from the prior processing department and 200,000 units were completed and sold. Costs transferred in from the prior department totaled $39,375,000. No materials are added in the final processing department. A total of $20,807,500 of conversion cost was incurred in the final processing department during the year.
Required:
1. Tom Winthrop estimated that the units in ending inventory in the final processing department were 30% complete with respect to the conversion costs of the final processing department. If this estimate of the percentage completion is used, what would be the Cost of Goods Sold for the year? (Note: Since all units completed were sold, the cost of goods transferred out = Cost of Goods Sold.)
2. Gary is recommending that the completion percentage by adjusted by 15 percentage points in order to assist the team in making their bonus.
a. Calculate the cost of goods sold if the ending inventory is 15% complete in regard to conversion costs. Would net income increase or decrease if this option was chosen over the 30% completion percentage? How much is the increase?
b. Calculate the cost of goods sold if the ending inventory is 45% complete in regard to conversion costs. Would net income increase or decrease if this option was chosen over the 30% completion percentage? How much is the increase?
c. Based on your calculations, which percentage is Gary suggesting that Mary use for her ending inventory calculations.
3. Do you think Mary James should go along with the request to alter estimates of the percentage completion? Why or why not?

Deliverables:
1. Submit an Excel spreadsheet that documents the calculations made for steps 1 and 2 above. All items should be clearly labeled, and appropriate formulas should be used to perform your calculations.

Solutions

Expert Solution

1. Cost of goods sold for the year = $58,000,000

2.a. Cost of goods sold = $58,101,485

Net income would decrease by 58,101,485 - 58,000,000 = $101485 since the COGS has increased by that amount.

2. b.Cost of goods sold = $57,899,510

Net income would increase by 58,000,000 - 57,899,510 = $100,490 since the COGS has decreased by that amount.

Please note that all formulas for 2a and 2b are similar to those used in 1 which are uploaded herewith. The only change is in cell no. E14 where the % of completion has been considered as 30%, 20% and 40% for 1, 2a and 2b respectively.

2.c. Gary is suggesting Mary use 40% for her ending inventory calculations which will result in an increase in profits and help them get the bonus.

3. Mary should not alter the estimates as it would result in fradulently inflating the profits and would be against the principle of ethics.


Related Solutions

CASE 4–20 Ethics and the Manager, Understanding the Impact of Percentage Completion on Profit—Weighted-Average Method [Course...
CASE 4–20 Ethics and the Manager, Understanding the Impact of Percentage Completion on Profit—Weighted-Average Method [Course Objective B] Gary Stevens and Mary James are production managers in the Consumer Electronics Division of General Electronics Company, which has several dozen plants scattered in locations throughout the world. Mary manages the plant located in Des Moines, Iowa, while Gary manages the plant in El Segundo, California. Production managers are paid a salary and get an additional bonus equal to 5% of their...
CASE 4–20 Ethics and the Manager, Understanding the Impact of Percentage Completion on Profit—Weighted-Average Method [Course...
CASE 4–20 Ethics and the Manager, Understanding the Impact of Percentage Completion on Profit—Weighted-Average Method [Course Objective B] Gary Stevens and Mary James are production managers in the Consumer Electronics Division of General Electronics Company, which has several dozen plants scattered in locations throughout the world. Mary manages the plant located in Des Moines, Iowa, while Gary manages the plant in El Segundo, California. Production managers are paid a salary and get an additional bonus equal to 5% of their...
Ethics and the Manager, Understanding the Impact of Percentage Completion on Profit—Weighted-Average Method LO4–2, LO4–3, LO4–4...
Ethics and the Manager, Understanding the Impact of Percentage Completion on Profit—Weighted-Average Method LO4–2, LO4–3, LO4–4 Gary Stevens and Mary James are production managers in the Consumer Electronics Division of General Electronics Company, which has several dozen plants scattered in locations throughout the world. Mary manages the plant located in Des Moines, Iowa, while Gary manages the plant in El Segundo, California. Production managers are paid a salary and get an additional bonus equal to 5% of their base salary...
A company uses the percentage-of-completion method to account for a 4-year construction contract. Which of the...
A company uses the percentage-of-completion method to account for a 4-year construction contract. Which of the following should be used in the calculation of the income recognized in the first year? Select one: a. Progress Billings, but not Collections on Progress Billings b. Collections on Progress Billings, but not Progress Billings c. Both Progress Billings and Collections on Progress Billings d. Neither Progress Billings nor Collections on Progress Billings
SV Company uses the weighted-average method of inventory costing [Which means that the stage of completion...
SV Company uses the weighted-average method of inventory costing [Which means that the stage of completion of beginning inventory is not important] Beginning Work in Process inventory for September:     Physical units                                                              5,000 units     % complete for materials                                               70%     % complete for conversion                                 25%     Materials cost from August                                         $7,350     Conversion cost from August                                    $3,125    Production started and completed in September:     Physical units                                                             40,000 units    Ending Work in Process inventory...
Exercise 4-3 Cost Per Equivalent Unit-Weighted-Average Method [LO4-3] Superior Micro Products uses the weighted-average method in...
Exercise 4-3 Cost Per Equivalent Unit-Weighted-Average Method [LO4-3] Superior Micro Products uses the weighted-average method in its process costing system. Data for the Assembly Department for May appear below: Materials Labor Overhead   Work in process, May 1 $ 40,600   $ 68,409   $ 331,872     Cost added during May $ 246,530   $ 45,606   $ 221,248     Equivalent units of production 3,400   3,300   3,200   Required: 1. Compute the cost per equivalent unit for materials, for labor, and for overhead. (Round your answers to 2...
Problem 4-16 Comprehensive Problem-Weighted-Average Method [LO4-2, LO4-3, LO4-4, LO4-5] Builder Products, Inc., uses the weighted-average method...
Problem 4-16 Comprehensive Problem-Weighted-Average Method [LO4-2, LO4-3, LO4-4, LO4-5] Builder Products, Inc., uses the weighted-average method in its process costing system. It manufactures a caulking compound that goes through three processing stages prior to completion. Information on work in the first department, Cooking, is given below for May: Production data: Pounds in process, May 1; materials 100% complete; conversion 90% complete 79,000 Pounds started into production during May 440,000 Pounds completed and transferred out ? Pounds in process, May 31;...
CASE 3–18 Ethics and the Manager [Course Objective B] Terri Ronsin had recently been transferred to...
CASE 3–18 Ethics and the Manager [Course Objective B] Terri Ronsin had recently been transferred to the Home Security Systems Division of National Home Products. Shortly after taking over her new position as divisional controller, she was asked to develop the division’s predetermined overhead rate for the upcoming year. The accuracy of the rate is important because it is used throughout the year and any overapplied or underapplied over- head is closed out to Cost of Goods Sold at the...
Case 4-19 Second Department-Weighted-Average Method [LO4-2, LO4-3, LO4-4] "I think we goofed when we hired that...
Case 4-19 Second Department-Weighted-Average Method [LO4-2, LO4-3, LO4-4] "I think we goofed when we hired that new assistant controller," said Ruth Scarpino, president of Provost Industries. "Just look at this report that he prepared for last month for the Finishing Department. I can’t understand it." Finishing Department costs: Work in process inventory, April 900 units; materials 100% complete; conversion 60% complete $ 8,561 * Costs transferred in during the month from the preceding department, 2,400 units 25,381 Materials cost added...
Case 4-19 Second Department-Weighted-Average Method [LO4-2, LO4-3, LO4-4] "I think we goofed when we hired that...
Case 4-19 Second Department-Weighted-Average Method [LO4-2, LO4-3, LO4-4] "I think we goofed when we hired that new assistant controller," said Ruth Scarpino, president of Provost Industries. "Just look at this report that he prepared for last month for the Finishing Department. I can’t understand it." Finishing Department costs: Work in process inventory, April 1,350 units; materials 100% complete; conversion 60% complete $ 8,714 * Costs transferred in during the month from the preceding department, 2,850 units 32,698 Materials cost added...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT