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: 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. a. Prepare a cost of goods manufactured statement for March. Round your answers to the nearest dollar. Johnstone Manufacturing Company b. Determine the cost of goods sold for March. Round your answer to the nearest dollar. 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: Select the corresponding accounts in the dropdowns in cells B26,B28:B33,B35:B40,B44. Using formulas and cell into the green cells in the C,D, and E columns. Transfer the numeric results for the green entry cells ( E26,C28:C31 in CNOWV2 for grading. Johnitone Manufacturing Compary Statement of Cost of Coods Marufoctured Fer the Month Ended March 31 fermulns Factory crewhead Tetal factory overhesd Total manulacturing costs incured during March Fotal manulacturieg costs 21 Deed materais Tetal factory evertead Total manufacturing costs incurted thring March Jotal mamulacturing costs Cost of goeds manufactured b. Cost of goods sold for March