Using the sales data for Lowe’s in the attached Excel file, calculate these three quantitative forecasts in Excel: simple moving average, weighted moving average, and exponential smoothing with trend.
- Compare and contrast each of the three quantitative forecasts above
- Choose the one forecast you determine would be the best for Lowe’s and explain why
- Evaluate the impact this forecast would have on on Lowes from a financial metrics standpoint
In Word, write a 700-word report in which you describe your forecasting project including details on all the assignment steps.
Book used: Jacobs, F. R., & Chase, R. B. (2014). Operations and supply chain management. New York: McGraw Hill.
Cite ANY references