Purchasing Department cost drivers, multiple regression analysis (continuation of 10-40) (chapter appendix) Barry Lee decides that the simple regression analysis used in Problem 10-40 could be extended to a multiple regression analysis. He finds the following results for two multiple regression analyses:

The coefficients of correlation between combinations of pairs of the variables are as follows:

Required:1. Evaluate regression 4 using the criteria of economic plausibility, goodness of fit, significance of independent variables and specification analysis. Compare regression 4 with regressions 2 and 3 in Problem 10-40. Which one of these models would you recommend that Lee use? Why?2. Compare regression 5 with regression 4. Which one of these models would you recommend that Lee use? Why?3. Lee estimates the following data for the Baltimore store for next year: dollar value of merchandise purchased, $78,000,000; number of purchase orders, 4,000; number of suppliers, 95. How much should Lee budget for purchasing department costs for the Baltimore store for next year?4. What difficulties do not arise in simple regression analysis that may arise in multiple regression analysis? Is there evidence of such difficulties in either of the multiple regressions presented in this problem? Explain.5. Give two examples of decisions in which the regression results reported here (and in Problem 10-40) could beinformative.

Transcribed Image Text:

Regression 4: PDC = a+ (b, x No. of POs) + (b, x No. of Ss) t-Value Variable Coefficient Standard Error Constant $484,522 S 126.66 $ 2,903 $256,684 1.89 Independent variable 1: No. of POs Independent variable 2: No. of Ss ?= 0.64; Durbin-Watson statistic = 1.91 2.19 57.80 S 1,459 1.99 Regression 5: PDC = a+ (b, x No. of POs) + (b, x No. of Ss) + (b, x MPS) Standard Error Variable Coefficient t-Value Constant $483,560 $312,554 1.55 Independent variable 1: No. of POs Independent variable 2: No. of Ss Independent variable 3: MPS ? = 0.64; Durbin-Watson statistic = 1.91 126.58 63.75 1.99 S 2,901 S 1,622 1.79 0.00002 0.0029 0.01