Please Answer ASAP!

Instructions - Completed Excel workbook must be uploaded highlighting the application of different forecasting methods. For part (d) - please create a separate sheet and provide justification of your claim. Quarterly demand for flowers at a wholesaler is given below. Forecast quarterly demand for year 5 using: a. last value method ( 10 points) b. weighted moving average with weights 0.5,0.3,0.2,0.1 (25 points) c. simple cxponcntial smoothing with =0.3 (25 points) d. Which of these three methods would you recommend for this problem setting? Why? (20 points) Assume the demand to be seasonal! Instructions - Completed Excel workbook must be uploaded highlighting the application of different forecasting methods. For part (d) - please create a separate sheet and provide justification of your claim. Quarterly demand for flowers at a wholesaler is given below. Forecast quarterly demand for year 5 using: a. last value method ( 10 points) b. weighted moving average with weights 0.5,0.3,0.2,0.1 (25 points) c. simple cxponcntial smoothing with =0.3 (25 points) d. Which of these three methods would you recommend for this problem setting? Why? (20 points) Assume the demand to be seasonal