1. Using the data on material handling, use regression software such as Microsoft Excel to complete...

  

Transcribed Image Text:

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): Multiple R R Square Adjusted R Square Standard Error Observations McCourt Company SUMMARY OUTPUT Regression Statistics Total Regression 2 Residual Intercept X Variable 11 X Variable 2 df 7 SS 37,768,070.16 0.999 0.997 ✔ 0.997 ANOVA 9 37,868,200.00 Coefficients 119.600 100,129.84 14,304.26 10 MS F 18,884,035 1,320.168 Standard Error Significance F t Stat 6.863 0.340 86.068 0.340 0.006 17.446 9.50629E-10 P-value 0.000239 9,81E-08 5E-07 2. Using the cost 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: 42,778 X Month January February March April May June July August September October Materials Handling Cost $5,600 3,090 2,780 8,000 1,990 5,300 4,300 6,300 2,000 6,240 Number of Moves 475 125 175 600 200 300 250 400 100 425 Pounds Moved 12,000 15,000 7,800 29,000 600 23,000 17,000 25,000 6,000 22,400 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): Multiple R R Square Adjusted R Square Standard Error Observations McCourt Company SUMMARY OUTPUT Regression Statistics Total Regression 2 Residual Intercept X Variable 11 X Variable 2 df 7 SS 37,768,070.16 0.999 0.997 ✔ 0.997 ANOVA 9 37,868,200.00 Coefficients 119.600 100,129.84 14,304.26 10 MS F 18,884,035 1,320.168 Standard Error Significance F t Stat 6.863 0.340 86.068 0.340 0.006 17.446 9.50629E-10 P-value 0.000239 9,81E-08 5E-07 2. Using the cost 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: 42,778 X 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): Multiple R R Square Adjusted R Square Standard Error Observations McCourt Company SUMMARY OUTPUT Regression Statistics Total Regression 2 Residual Intercept X Variable 11 X Variable 2 df 7 SS 37,768,070.16 0.999 0.997 ✔ 0.997 ANOVA 9 37,868,200.00 Coefficients 119.600 100,129.84 14,304.26 10 MS F 18,884,035 1,320.168 Standard Error Significance F t Stat 6.863 0.340 86.068 0.340 0.006 17.446 9.50629E-10 P-value 0.000239 9,81E-08 5E-07 2. Using the cost 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: 42,778 X Month January February March April May June July August September October Materials Handling Cost $5,600 3,090 2,780 8,000 1,990 5,300 4,300 6,300 2,000 6,240 Number of Moves 475 125 175 600 200 300 250 400 100 425 Pounds Moved 12,000 15,000 7,800 29,000 600 23,000 17,000 25,000 6,000 22,400 Month January February March April May June July August September October Materials Handling Cost $5,600 3,090 2,780 8,000 1,990 5,300 4,300 6,300 2,000 6,240 Number of Moves 475 125 175 600 200 300 250 400 100 425 Pounds Moved 12,000 15,000 7,800 29,000 600 23,000 17,000 25,000 6,000 22,400

Answer rating: 100% (QA)

The image shows a snapshot of a document with certain statistical data and some calculations that have been attempted The document concerns a companys ... View the full answer