Period Sales 100 124 115 120 110 2 3 4 Forecast sales for period 5 using...
2. (20 points) The following table shows the monthly sales in a local grocery store Month and 120 115 125 119 127 114 114 120 124 116 137 10 a. Suppose that Three-weeks moving average are used to forecast sales. Determine the one-step-ahead forecasts for weeks 4 through 10. b. Suppose that exponential smoothing is used with a smoothing constant α-02. Find the exponential smoothing forecasts weeks 4 through 10. (To get the method started, use 120.00 as the forecast...
Period 2 3 4 5 6 3 Period Moving Average 4 Period Moving Average Observation Forecast Error Error A2 Abs Error Forecast Exponential Smoothing Error Error 2 Abs Error Forecast Error 86 Error A2 Abs Error 85 Assume FAI 80 81 86 89 95 88 91 92 88 96 MSE MSE MSE MAD MAD Alpha 02 8 9 10 11 12 13 MAD According to MSE, what is the best forecasting model to MAD, what is the best forecasting model
please reply fast for a thumbs up????
Question 5 (1 point) The error in the forecast for Period 5 when Three period moving average forecast method is used:(Please round to 2 decimals for your answer which looks like 0.52) Absolute Absolute Percent Squared Error Error Error 1 3-Period MA X(Period) Y(Sales) Forecast Error 3 2 4.0 3 10.0 4 5.4 5 17 6 12 7 Your Answer: Answer
)Enrollment in a particular class for the last four semesters has been 120, 126, 110, and 130 semester moving average was used to forecast enrollment (this is sometimes refered to as a naive Thus, the forecast for the second semester it would be 110. What would the MSE be for this situation? reg 2) Enrollment in a particular class for the last four semesters has been 122.128, 100, and 153 listed from oldest to most recent). The best forecast of...
In Excel, create a forecast for periods 6-13 using the following method: 5 period simple moving average. Using a 5 period simple moving average, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74
Problem 3-2 National Scan, Inc., sells radlo frequency Inventory tags. Monthly sales for a seven-month period were as follows: Sales Month(ee)Units Feb Mar Apr May Jun Jul Aug 2e 23 25 18 28 30 b. Forecast September sales volume using each of the folloWng: (1 A linear trend equation.(Round your Intermedlate calculatlons and final answer to 2 declmal places.) Yt thousands (2) A five-month moVing average. (Round your answer to 2 declmal places.) Moving averagehousands (3) Exponentlal smoothing with a...
1. MAD for the naive forecast = ?? sales (round your
response to two decimal places).
2. MAPE for the forecast developed by the naive approach = ?? %
(round your response to two decimal
places).
b) Using the Naive Method, the forecast for period March through June is (round your response to two decimal places) Month Unit Sales Naive Forecast Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 102 97 95 110 124 119 95...
-Supply 1 Supply 2 $120 $115 $110 $105 $100 $95 $90 -Supply 3 Demand 1 Demand 2 Demand 3 -Price Floor Price Ceiling 0 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 100 105 110 5) From the graph above, the market starts at supply 1 and demand 1, a. If there is a change in technology in the production process which makes it much easier to propose, would...
Quarterly sales for swarthmore cycles are follows:
1997-I 100
1997-II 110
1997-III 115
1997-IV 125
1998-I 130
1998-II 135
1998-III 145
1998-IV 150
a) Plot the sales data and graphically fit a straight
line to the points.
b) In using the data for trend prediction, would the
constant rate of change or the constant percentage change model be
more appropriate. Explain
c) Using the data to estimate the co-efficient of the
equation St = So(1+g)².
d) using a calculator or...
b. Forecast September sales volume using each of the following: (1) (Omitted) (2) A five-month moving average.(3) Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 16(000).(4) The naive approach (5) A weighted average using .60 for August, .10 for July, and .30 for June.