Statement of cost of goods manufactured for a manufacturing company Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows: Inventories Materials Work in process Finished goods March 1 $202,800 420,950 566,110 March 31 $186,470 492,880 594,760 $3,380,000 2,574,780 Direct labor Materials purchased during March Factory overhead incurred during March: Indirect labor Machinery depreciation Heat, light, and power Supplies Property taxes Miscellaneous costs 309,020 202,800 169,000 33,700 28,970 44,130 B D E 1 Statement of cost of goods manufactured for a manufacturing company 2 3 Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows: 4 5 DATA 6 Inventories March 1 March 31 7 Materials $202,800 $186,470 8 Work in process 420,950 492,880 9 Finished goods 566,110 594,760 10 11 Direct labor $3,380,000 12 Materials purchased during March 2,574,780 13 Factory overhead incurred during March: Indirect labor 309,020 15 Machinery depreciation 202,800 16 Heat, light, and power 169,000 17 Supplies 33,700 18 Property taxes 28,970 19 Miscellaneous costs 44,130 14 20 Select the corresponding accounts in the dropdowns in cells B26, 328:833, B35 B40, B44. Using formulas and coll references, perform the required analysis, and input your answers into the green cells in the C, D, and E columns. Transfer the numeric results for the green entry cols (E26, C28:C31, 032 033, C35 C40, D41, E42E45, C47) into the appropriate fields 21 in CNOWV2 for grading. 22 23 Johnstone Manufacturing Company 24 Statement of Cost of Goods Manufactured 25 For the Month Ended March 31 Form 26. Direct materials Factory overhead 27 28 29 30 31 32 33 34 35 130 37 30 39 40 41 42 43 - Total factory overhead Total manufacturing continourred during March Total manufacturing costs 45 Cost of goods manufactured 46 47. Cost of goods sold for March 8 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, ar $ Open spreadsheet a. Prepare a cost of goods manufactured statement for March. Round your answers to the nearest dollar. Johnstone Manufacturing Company Statement of Cost of Goods Manufactured For the Month Ended March 31 Work in process inventory, March 1 420,950 Direct materials: Materials inventory, March 1 202,800 Purchases Cost of materials available for use Materials inventory, March 31 Cost of direct materials used in production Direct labor Factory overhead: Indirect labor Machinery depreciation Heat, light, and power Supplies Property taxes Miscellaneous costs Total factory overhead Total manufacturing costs incurred during March Total manufacturing costs Work in process inventory, March 31 Cost of goods manufactured La $ $ b. Determine the cost of goods sold for March. Round your answer to the nearest dollar
