1. EX.01.09.EXCEL.ALGO 2. EX.01.15.EXCEL.ALGO 3. PR.01.02A cummy company Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows: Inventories Materials Work in process Finished goods Direct labor Materials purchased during March Factory overhead incurred during March: Indirect labor Machinery depreciation Heat, light, and power Supplies Property taxes Miscellaneous costs. Open spreadsheet 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. Direct materials: Factory overhead: a. Prepare a cost of goods manufactured statement for March. Round your answers to the nearest dollar. Total factory overhead Total manufacturing costs incurred during March Total manufacturing costs Johnstone Manufacturing Company Statement of Cost of Goods Manufactured For the Month Ended March 31 Cost of goods manufactured March 1 $184,800 383,590 515,860 $ March 31 $169,920 449,130 541,970 $ $3,080,000 2,346,250 $ 281,600 184,800 154,000 30,710 26,400 40,220 $ $ b. Determine the cost of goods sold for March. Round your answer to the nearest dollar.

Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows: 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. Oonen sarnativent 3. Freste s cost of goods manufactured statement for seaveh. Aound your answers to the nesrent dellar. b. vetermine the cost or gooas soin ror marcn. kouna your answer to the nearest dollar