Cost of direct materials used in production for a manufacturing company Walker Manufacturing Company reported the following materials data for the month ending June 30: Materiais purchased $666,300 Materiais Inventory, June 1 187,900 Materials inventory, June 30 150,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the question below. HUHT Open spreadsheet Determine the cost of direct materials used in production by Walker during the month ended Jane 30. Round your answer to the nearest dollar. Cost of direct materials used in production for a manufacturing company 2 3 Walker Manufacturing Company reported the following materials data for the month ending June 30: 5 DATA 5 Materials purchased $666,300 Materials inventory, June 1 187,900 3 Materials inventory, June 30 150,000 2 Using formulas and cell references, perform the required analysis, and input your answer into the Amount 0 column. Transfer the numeric result for the green entry cell (D13) into the appropriate field in CNOWV2 for rodinn 1 2 Amount Formula 3 Cost of direct materials used in production 4