South X | myst X D21 1-2P X Ceng X Excel X an temp X por temp X Q snhu x 5 1-2P X Free X Q how X + X G about:blank G X template - Saved v Search for tools, help, and more (Alt + Q) File Home Insert Share Page Layout Formulas Data Review View Help Draw Editing v Comments Arial v 11 v BEvavAv ... E ab General v $ v .00 B: v ... A3 X v fx Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows: A B E G H Statement of cost of goods manufactured for a manufacturing company W N P Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows: DATA Inventories March 1 March 31 Materials $205,200 $188,680 Work in process 425,930 498,720 9 Finished goods 572,810 601,800 10 11 Direct labor $3,420,000 12 Materials purchased during March 2,605,250 13 Factory overhead incurred during March: 14 Indirect labor 312,680 15 Machinery depreciation 205,200 16 Heat, light, and power 171,000 17 Supplies 34,100 18 Property taxes 29.310 19 Miscellaneous costs 44.660 20 21 Select the corresponding accounts in the dropdowns in cells B26, B28:B33, B35:B40, B44. Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C, D, and E columns. Transfer the numeric results for the green entry cells (E26, C28:C31, D32:D33, C35:C40, D41, E42:E45, C47) into the appropriate fields in CNOWv2 for grading. E Data + Workbook Statistics Give Feedback to Microsoft 100% + Fi L 6:11 PM Type here to search O 199+) O NEW 46OF 5/11/2024