please help

EC V 0 l Bv2.cengagenow.com (3' [B + 33 u Course Hero 12 Problem Set: Module One - ACC-ZOZR3958 M... 3 how to screenshot on mac - Google Search Problem Set: Module 1 eBook Show Me How Ofce 365 ' Statement of cost of goods manufactured for a manufacturing company 1. PR.01.02A " Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows: 2- EX-01'15'EXCELALGO ' Inventorles March 1 March 31 Materials $230,400 $211,850 3' EX'O1'09'EXCEL'ALGO I Work in process 478,240 559,960 Finished goods 543,150 575,710 Direct labor $3,840,000 Materials purchased during March 2,925,200 Factory overhead incurred during March: Indirect labor 351,080 0 Machinery depreciation 230,400 Heat, light, and power 192,000 Supplies 38,280 Property taxes 32,910 Miscellaneous costs 50,140 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 . Previous Next ) Progress: 2/3 Items \"k My Work ( Assignment Score: 59.97% Submit Assignment for Grading v2.cengagenow.com + 88 *Course Hero B 1-2 Problem Set: Module One - ACC-202-R3958 M... x CengageNOWv2 | Online teaching and learning reso... G how to screenshot on mac - Google Search Problem Set: Module 1 eBook Show Me How Office 365 Johnstone Manufacturing Company ? 1. PR.01.02A Statement of Cost of Goods Manufactured For the Month Ended March 31 2. EX.01.15.EXCEL.ALGO Work in process inventory, March 1 3. EX.01.09.EXCEL.ALGO Direct materials: Materials inventory, March 1 Purchases Cost of materials available for use Materials inventory, March 31 Cost of direct materials used in production Direct labor ry 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 $ b. Determine the cost of goods sold for March. Round your answer to the nearest dollar. Progress: 2/3 items Check My Work Previous Next Assignment Score: 59.97% Email Instructor Save and Exit Submit Assignment for Gradingv2.cengagenow.com + 88 *Course Hero B 1-2 Problem Set: Module One - ACC-202-R3958 M... x CengageNOWv2 | Online teaching and learning reso... G how to screenshot on mac - Google Search Problem Set: Module 1 eBook Show Me How Office 365 Materials inventory, March 31 ? 1. PR.01.02A Cost of direct materials used in production Direct labor 2. EX.01.15.EXCEL.ALGO Factory overhead: 3. EX.01.09.EXCEL.ALGO 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 $ b. Determine the cost of goods sold for March. Round your answer to the nearest dollar. Feedback Check My Work a. Add the beginning materials and purchases and subtract the ending materials. Add direct labor and factory overhead. This will give total manufacturing costs. Then, add the total manufacturing costs to the beginning work in process and subtract the ending work in process. b. Add the cost of goods manufactured from (a) to the beginning finished goods. Subtract the ending finished goods. Progress: 2/3 items Check My Work Previous Assignment Score: 59.97% Email Instructor Save and Exit Submit Assignment for Grading