| Use the column based upon this course start date |
| Cost of Goods Manufactured Data | Jan-Feb | | Mar-Apr | | May-Jun | | Jul-Aug | | Sept-Oct | | Nov-Dec |
| Direct labor | 170000 | | 171000 | | 172000 | | 173000 | | 174000 | | 175000 |
| Depreciation | 20200 | | 20400 | | 20600 | | 20800 | | 21000 | | 21200 |
| Purchases of direct material | 350300 | | 350600 | | 350900 | | 351200 | | 351500 | | 351800 |
| Beginning work-in-process | 80175 | | 80350 | | 80525 | | 80700 | | 80875 | | 81050 |
| Ending direct materials | 65200 | | 65400 | | 65600 | | 65800 | | 66000 | | 66200 |
| Indirect materials | 17750 | | 18500 | | 19250 | | 20000 | | 20750 | | 21500 |
| Plant utilities, insurance and Property taxes | 18575 | | 19150 | | 19725 | | 20300 | | 20875 | | 21450 |
| Ending work-in-process | 27100 | | 27200 | | 27300 | | 27400 | | 27500 | | 27600 |
| Beginning direct materials | 70025 | | 70050 | | 70075 | | 70100 | | 70125 | | 70150 |
| Indirect labor | 29500 | | 31000 | | 32500 | | 34000 | | 35500 | | 37000 |
| Manufacturing Income Statement Data |
| Net sales revenue | 1001000 | | 1002000 | | 1003000 | | 1004000 | | 1005000 | | 1006000 |
| Income taxes | 53500 | | 54000 | | 54500 | | 55000 | | 55500 | | 56000 |
| Beginning finished goods | 250 | | 500 | | 750 | | 1000 | | 1250 | | 1500 |
| Supplies expense | 5300 | | 5600 | | 5900 | | 6200 | | 6500 | | 6800 |
| Ending finished goods inventory | 60425 | | 60850 | | 61275 | | 61700 | | 62125 | | 62550 |
| Cost of goods manufactured | 660375 | | 660750 | | 661125 | | 661500 | | 661875 | | 662250 |
| Wage expense | 120125 | | 120250 | | 120375 | | 120500 | | 120625 | | 120750 |
| Depreciation expense | 6750 | | 7500 | | 8250 | | 9000 | | 9750 | | 10500 |
| Rent expense | 100025 | | 100050 | | 100075 | | 100100 | | 100125 | | 100150 |
| Insurance expense | 10075 | | 10150 | | 10225 | | 10300 | | 10375 | | 10450 |
studystudent
ACC206FinalPaperCGS20192.xlsx
