(Solved): I don't need excel solver. Can you please solve at the paper?Thank you A. Forecasting Wallace Garden ...

A. Forecasting Wallace Garden Supply wants to forecast demand for its Storage Shed. Please find below the actual demands for 8 weeks. Week Demand 190 125 144 2 3 6 156 185 145 114 187 7 8 1. Find the forecast for week 7 by using moving average methodology. The company use a three- week moving average (n = 3). 2. Find the forecast for week 5 by using weighted moving average methodology. The company use a four-week weighted moving average (n = 4). Weight application is as follows: Weight Application Period 4 3 Last week 2 weeks ago 3 weeks ago 4 weeks ago 2 1 3. Find the forecast for week 8 by using exponential smoothing methodology. Please accept a=0.1 and Forecast for Week 1=170 4. Use the values of actual demands and the values of forecasted demands obtained by using exponential smoothing for all weeks and find MAD (mean absolute deviation),