Southern New Hampshire Univer X Home x B 1-2 Problem Set: Module One - A X CengageNOWv2 | Online teachin x Course Hero X + X C v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false Problem Set: Module 1 eBook Show Me How Office 365 1. EX.01.15.EXCEL.ALGO 2. PR.01.02A Open spreadsheet 3. EX.01.09.EXCEL.ALGO 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 388,570 Direct materials: Materials inventory, March 1 - V 187,200 V Purchases 2,376,720 Cost of materials available for use 2,563,920 Materials inventory, March 31 -172,130 Cost of direct materials used in production - $ 4,955,710 X Direct labor V 3,120,000 Factory overhead: Indirect labor 285,250 Machinery depreciation 187,200 V Heat, light, and power 156,000 Supplies . V 31,110 Property taxes 26,740 Miscellaneous costs 40,740 Total factory overhead 727,040 Total manufacturing costs incurred during March 8,802,750 X Total manufacturing costs $ 9,191,320 X Work in process inventory, March 31 - -454,970 Cost of goods manufactured $ 8,736,350 X b. Determine the cost of goods sold for March. Round your answer to the nearest dollar. Progress: 1/3 items Check My Work Next Assignment Score: 28.28% All work saved. Email Instructor Save and Exit Submit Assignment for Grading M 31 7 2:26