month decat Applying the Concepts The staff of controller of McCourt Company added the variable pounds moved to the Month Material Handling Cost Number of Moves Pounds Moved $5.600 12.000 February 3.090 15.000 March 2.780 175 7.000 8.000 1.990 00 June 23,000 4.300 17,000 August 25.000 September 2.000 6.000 April May 3.300 6300 o the data in the table below (round regres October 425 22.400 Required 1. Using the data on material handling, we regression software such as Microsoft Excel t parameters to the nearest cent and other answers to three decimal places) McCourt Company SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA 2 1.320.168 9.50629E-10 Regression Residual Total 37.768.070.16 1 00.129.84 37,068.200.00 15.884,035 14,304.26 7 9 Coefficients Intercept Standard Error 86.068 0.340 0.006 Star 6.863 0.340 17.46 P-value 0.000239 .81-08 SE-07 X Variable 1 x Variable 2 350 moves are expected and 17 2. Using the cost equation from Requirement 1, calculate the total expected material handing cost for November pounds of material will be moved (round final answer to the nearest dollar). Expected material handling costs 3. For the coming year, McCourt expects 3,940 moves involving a total of 204,000 pounds. Calculate the following Total expected feed costs (round to the nearest dollar): Total material handling cost (add each component in the equation and then round to the nearest dollar)