Requirement #1:
Calculate the following on the COGM worksheet:
1. Computation of Cost per unit: COGM/units produced
2. Calculate the number of units that were sold
3. Calculate the number of units in the finished goods inventory at the end of the year
4. Calculate the cost in ending finished goods inventory at the end of the year.
You should not type any number into a cell on the Schedule of COGM.
If I would change a number in your data field it would automatically change on the statements.
Requirement #2: Prepare 2 doughnut charts. I have a tutorial in the chapter 2 folder in course documents to assist you and developing a chart.
One chart should compare the total product costs to the total period costs, and another chart should compare the three types of product costs.
Insert these charts on separate sheets and comment on your chart results on the comment worksheet.
Requirement #3: Based on the current economic pressures, the company has decided to eliminate the part time janitor and the cost of that position and have the production workers clean up the area. What will be the new COGM?
1. What will be the new COGM?
2. Computation of Cost per unit: COGM/units produced
3. Calculate the cost in ending finished goods inventory at the end of the year.
Attachment:- Project.xls