In: Accounting
Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows:
Inventories | March 1 | March 31 | ||||
Materials | $207,600 | $190,890 | ||||
Work in process | 430,920 | 504,560 | ||||
Finished goods | 579,510 | 608,850 | ||||
Direct labor | $3,460,000 | |||||
Materials purchased during March | 2,635,720 | |||||
Factory overhead incurred during March: | ||||||
Indirect labor | 316,340 | |||||
Machinery depreciation | 207,600 | |||||
Heat, light, and power | 173,000 | |||||
Supplies | 34,500 | |||||
Property taxes | 29,650 | |||||
Miscellaneous costs | 45,180 |
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
Open spreadsheet
Answer :-
Statement of Cost of Goods Manufactured
For the Month ended 31 March | |
Materials | |
Opening Material Inventory | $ 207,600.00 |
Add:- Purchase of Material | $ 2,635,720.00 |
Less:- Closing Material Inventory | $ (190,890.00) |
Material Used in Production ( A ) | $ 2,652,430.00 |
Direct Labour ( B ) | $ 3,460,000.00 |
Factory Overhead ( C ) | |
Indirect labor | $ 316,340.00 |
Machinery depreciation | $ 207,600.00 |
Heat, light, and power | $ 173,000.00 |
Supplies | $ 34,500.00 |
Property taxes | $ 29,650.00 |
Miscellaneous costs | $ 45,180.00 |
Total Manufacturing Cost ( A + B + C ) | $ 6,918,700.00 |
Add:- Opening WIP | $ 430,920.00 |
Less:- Closing WIP | $ (504,560.00) |
Cost of Goods Manufactured for the Month | $ 6,845,060.00 |
Add:- Opening Finished Goods Inventory | $ 579,510.00 |
Less:- Closing Finished Goods Inventory | $ (608,850.00) |
Cost Of Goods Sold | $ 6,815,720.00 |