Question: many supply managers use a monthly reported survey result known...
Many supply managers use a monthly reported survey result known as the purchasing managers’ index (PMI) as a leading indicator to forecast future sales for their businesses. Suppose that the PMI and your business sales data for the last 10 months are the following:
A. Develop a regression model that can be used by supply managers in forecasting future sales for businesses. Explain what forecasting model approach you used and why you chose it. Show complete work (cut and paste from Excel if used in the analysis). (10 points)
B. Develop a sales forecast for the 11th and 12th months using the model you developed in part A when PMIs are 52 and 50, respectively. (10 points)
Please show all calculations