Given the following weekly demand and forecast figures: Week Demand Forecast 1 27 20 2 21 25 3 39 35 The mean square error is: a) 5 b) 7 c) 10 d) 17 e) none of the above
Mean Square error = 1/n*(X-Xi)2
= 1/3 *((27-20)2
+(25-21)2+(39-35)2) = 1/3*81 = 27
Option e none of these
Please Discuss in case of Doubt
Best of Luck. God Bless
Please Rate Well
Given the following weekly demand and forecast figures: Week Demand Forecast 1 27 20 2 21...
Given the following weekly demand figures, what is the MAD at the end of week 5? Week Demand Forecast 1 100 120 2 120 130 3 110 120 4 130 125 5 160 145
The following data represent the demand for antifreeze in thousands of gallons for an 8-week period during the Fall 2017 in the New York metropolitan area. Week Demand 1 10 2 15 3 17 4 12 5 15 6 18 7 20 8 25 a) Calculate a 3-week moving average for the demand data. What will be the forecast for Week 9? b) Calculate an exponential smoothed average for the demand data using a= 0.30 and seed S0= 10. What...
Ch8-A For data of weekly returns (in %) of Google stock given here, forecast the return for the week of March 5, 2017 as follows. [Note: Express your forecasts in % rounded to to 2 decimal places (eg, 3.23%), and express the MSE's and MAE rounded to 5 decimal places (e.g., 0.00073).] (a) Use a 3-week moving average and find the MSE and MAE. (b) Use exponential smoothing with alpha value 0.3 and compute the error measures (c) Now using...
[18-22The following table shows monthly actual and forecast air passenger demand on Stockton Airlines ACTUAL FORECAST ERROR RSFE MAD 180 TIME PERIOD Jan Feb Mar Apr 2 7 210 130 190 NA 2 30 2 2 NA TRACKING SIGNAL -10 2 ? NA 2 2 NA NA Using exponential smoothing (0.5) what will be the air passenger demand in April? O A 16725 8.171.25 c. 17425 0.17625 QUESTION 19 25 points In March, what is the running sum of the...
Forecast expected demand using the data given for lead-times of 1, 2, 6, and 12 along with a 90% confidence interval using each the following techniques. Experiment with any required forecasting parameters. a. Moving average b. Simple exponential smoothing c. Holt’s model d. Winter’s model e. Which method is preferred? Month Demand 1 2000 2 3000 3 3000 4 3000 5 4000 6 6000 7 7000 8 6000 9 10000 10 12000 11 14000 12 8000 13 3000 14 4000...
1.Which of the following are common causes for stockouts? a. Poor forecast accuracy; i.e., underestimate demand b. Shipping issues that delay product arrival c. Parts shortages that limit production d. Excess warehouse capacity e. All of the above f. Only a, b, and c 2.Which of the following is a cost associated with overstock situations? a. Opportunity costs b. Holding costs c. Markdown costs d. Disposal costs e. All of the above f. Only a, b, and c 3.If your...
The weekly sales figures for the previous year for a new board game are given below. Assuming a weighting of 3, 2, 1, determine the three-period weighted moving average forecast for the second week in July. WEEK June 1 2 3 4 July 1 2 3 4 5 Aug 1 2 3 4 SALES 4 6 4 5 10 8 7 9 12 14 16
Simulate the following inventory replenishment problem for 20 weeks. You will have to use the Excel program to simulate. Demand is uniformly distributed between 20 and 30 units. Additional Data are given below. Inventory Cost/Week = $ 1.00 Shortage Cost/Week = $ 2.00 Lead Time = 2 weeks Beginning Stock on Hand (SOH) = 0 Supply in Week 1 = 21 units Supply in Week 2 = 22 units What is the total shortage cost at the end of 20...
Weekly sales of the Weber Dicamatic food processor for the past ten weeks have been: Week Sales Week Sales 1 980 6 990 2 1040 7 1030 3 1120 8 1260 4 1050 9 1240 5 960 10 1100 Determine, on the basis of minimizing the mean square error, whether a three-period or four-period simple moving average model gives a better forecast for this problem.
Given forecast errors of 8, 10, and 9, what is the mean absolute deviation? O A. 2/3 B. 1/3 C.:a. D. O QUESTION 5 Given forecast errors of 3, 6, and 9, what is the mean square error? A. 5 B. 6 c.7 D. 8 We were unable to transcribe this imageTime-series data may exhibit which of the following behaviors? O A. Trend B. Seasonality C. Cycles D. All of the above QUESTION 9 In business, forecasts are the basis...