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 companys 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:

1. Gary:Hows it going, Mary?

2. Mary:Fine, Gary. Hows it going with you?

3. Gary:Great! I just got the preliminary profit figures for the division for last year and we are within $200,000 of making the years target profits. All we have to do is pull a few strings, and well be over the top!

4. Mary:What do you mean?

5. Gary:Well, one thing that would be easy to change is your estimate of the percentage completion of your ending work in process inventories.

6. Mary:I dont 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.

7. 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 Marys production facility began the year with no work in process inventory. 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. Tom Winthrop estimated that the units in ending work in process inventory in the final processing department were 30% complete with respect to the conversion costs of the final processing department.

Required: 1. Prepare a spreadsheet in good form (use appropriate formatting, heading, description & formulas) to calculate the cost of goods sold for the year using Toms estimate. Your spreadsheet should show all calculations so it could be used for later sensitivity analysis.

2. Prepare another spreadsheet to determine what percentage completion would result in increased reported net income by $200,000 over the amount calculated in #1 (which used a 30% completion.

3. Assume the role of Mary James, and prepare a 1 page memo response to Garys request that she change the percentage completion. The response should be clear as to what action Mary will be taking and it should be supported using quantitative and qualitative information.