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