70.2K

Verified Solution

Link Copied!

Solve the financial statements

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: Inventories Materials Work in process Finished goods March 1 $204,000 423,440 569,460 March 31 $187,580 495,810 598,300 Direct labor $3,400,000 Materials purchased during March 2,590,020 Factory overhead incurred during March: Indirect labor 310,850 Machinery depreciation 204,000 Heat, light, and power 170,000 Supplies 33,900 Property taxes 29,140 Miscellaneous costs 44,400 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. 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: DATA Inventories Materials Work in process Finished goods March 1 $204,000 423,440 569,460 March 31 $187.580 495,810 598,300 $3,400,000 2.500,020 Direct labor Materials purchased during March Factory overhead incurred during March: Indirect labor Machinery depreciation Heat, light and power Supplies Property taxes Miscellaneous costs 310.850 204,000 170,000 33.900 29,140 44,400 Select the corresponding accounts in the dropdowns in cells B26, 328:833, B35:340.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:033, C35:C40, D41, E42:E45, C47) into the appropriate fields in CNOWV2 for grading Johnstone Manufacturing Company Statement of Cost of Goods Manufactured For the Month Ended March 31 Formulas Direct materials: Factory overhead: Total factory overhead Total manufacturing costs incurred during March Total manufacturing costs Cost of goods manufactured b. Cost of goods sold for March 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: $ $ $ 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

Answer & Explanation Solved by verified expert

See Answer