013 B D E 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. 1 2 3 4 S 6 7 8 9 DATA Materials purchased $959,000 Materials inventory, June 1 270,400 Materials inventory, June 30 215,900 Using formulas and cell references, perform the required analysis, and input your answer into the Amount column Transfer the numeric result for the green entry cell (D13) into the appropriate field in CNOWV2 for Amount Formula Cost of direct materials used in production 10 11 12 13 14 15 16 17 18 19 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: Materials purchased $959,000 Materials inventory, June 1 270,400 Materials inventory, June 30 215,900 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. Open spreadsheet Determine the cost of direct materials used in production by Walker during the month ended June 30. Round your answer to the nearest dollar. $