The following tabulations are actual sales of units for six months and a startin
ID: 2980576 • Letter: T
Question
The following tabulations are actual sales of units for six months and a starting forecast in January. ACTUAL FORECAST January 102 78.00 February 92 March 110 April 82 May 72 June 92 Required: (a) Calculate forecasts for the remaining five months using simple exponential smoothing with ? = .2. (Round your answers to 2 decimal places.) Forecasts February March April May June (b) Calculate mean absolute deviation for the forecasts. (Round your answer to 2 decimal places.) Mean Absolute Deviation Harlen Industries has a simple forecasting model: Take the actual demand for the same month last year and divide that by the number of fractional weeks in that month. This gives the average weekly demand for that month. This weekly average is used as the weekly forecast for the same month this year. This technique was used to forecast eight weeks for this year, which are shown below along with the actual demand that occurred. The following eight weeks show the forecast (based on last year) and the demand that actually occurred: WEEK FORECAST DEMAND ACTUAL DEMAND WEEK FORECAST DEMAND ACTUAL DEMAND 1 190 187 5 190 230 2 173 183 6 200 220 3 173 200 7 200 235 4 190 210 8 200 255 Required: (a) Compute the Mean absolute deviation of forecast errors and using the RSFE compute the tracking signal. (Round your Mean Absolute Deviation and Tracking Signal to 2 decimal places. Negative answers should be indicated by a minus sign.) Month Forecast Actual Deviation RSFE Absolute deviation Sum of absolute deviations Mean absolute deviation Tracking signal 1 190 187 2 173 183 3 173 200 4 190 210 5 190 230 6 200 220 7 200 235 8 200 255 (b) Based on your answers to (a) comment on Harlen's method of forecasting.Explanation / Answer
the table is not clear. give the ink of the table as a comment or upload a pic. i'm here to solve :)
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.