Applying the Concepts The staff of controller of McCourt Company added the variable pounds moved to the ten-month data set: Month Material Handling Cost Number of Moves Pounds Moved January $5,600 475 12,000 February 3,090 125 15,000 March 2,780 175 7,800 April 8,000 600 29,000 May 1,990 200 600 June 5,300 300 23,000 July 4,300 250 17,000 August 6,300 400 25,000 September 2,000 100 6,000 October 6,240 425 22.400 Required: 1. Using the data on material handling, use regression software such as Microsoft Excel to complete the missing data in the table below (round regression parameters to the nearest cent and other answers to three decimal places): Mart 1. Using the data on material Handling, use regression software such as Microsoft Excel to complete the missing data in the table below (round regression parameters to the rearest cent and other answts to three decimal places): McCourt Company SUMMARY OUTPUT Regression Statistics Maider 0.999 Sore 0.997 0.997 119.600 Gris ANOVA ef SS NS 37.758,070 55 18.104,035 1.320.166 100.129.14 14.34 37,38,300.00 Significance 2.50629-30 Coeficients Standard Error Stat het P-value lije 2 006 2/2/2023 110 PM 5 7 LANG 8 R. 9 insert orts backspace F G H Coefficients Standard Error Stat P-value intercept 590.65 86.068 6.863 0.000239 X Variable ! 7.51 0.340 0.340 9.81E-08 X Variable 2 0.11 0.006 17.446 SE-07 2. Using the cout equation from Requirement 1, calculate the total expected material handling cost for November if 350 moves are expected and 17,000 pounds of material will be moved (round final answer to the nearest dollar). Expected material handling cost: 3,221 x 3. For the coming year, McCourt expects 3,940 moves involving a total of 204,000 pounds. Calculate the following: Toolspeed costs (round to the nearest dolary: 59.117 X obal materialtanding cost add each component in the equation and then round to the nearest dort): Purisconnect more che