Southern New Hampshire Univer X Home * @ 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 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: 2. PR.01.02A Inventories March 1 March 31 3. EX.01.09.EXCEL.ALGO Materials $187,200 $172,130 Work in process 388,570 454,970 Finished goods 522,560 549,020 Direct labor $3,120,000 Materials purchased during March 2,376,720 Factory overhead incurred during March: Indirect labor 285,250 Machinery depreciation 187,200 Heat, light, and power 156,000 Supplies 31,110 Property taxes 26,740 Miscellaneous costs 40,740 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 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 Direct materials: Check My Work Progress: 1/3 items Next Assignment Score: 0.0% Email Instructor Save and Exit Submit Assignment for Grading O O M 7 1 7:46Southern New Hampshire Univer X Home * @ 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 1 eBook Show Me How Office 365 X 1. EX.01.15.EXCEL.ALGO Open spreadsheet 2. PR.01.02A a. Prepare a cost of goods manufactured statement for March. Round your answers to the nearest dollar. 3. EX.01.09.EXCEL.ALGO Johnstone Manufacturing Company Statement of Cost of Goods Manufactured For the Month Ended March 31 Direct materials: Factory overhead: Total factory overhead Total manufacturing costs incurred during March Total manufacturing costs Cost of goods manufactured b. Determine the cost of goods sold for March. Round your answer to the nearest dollar. $ Check My Work Progress: 1/3 items Next Assignment Score: 0.0% Email Instructor Save and Exit Submit Assignment for Grading 9 M 1 9 7:46