a)
Week | Unit Sold (A) | 3-week moving avg. | Forecast Error (Actual Value - Forecast) | Absolute deviation (data without negative sign) |
1 | 523 | |||
2 | 587 | |||
3 | 622 | |||
4 | 601 | 577.33 | 23.67 | 23.67 |
5 | 615 | 603.33 | 11.67 | 11.67 |
6 | 578 | 612.67 | -34.67 | 34.67 |
7 | 598.00 | |||
Mean Absolute Deviation (MAD)= Avg. of absolute value of forecast error | 23.33 |
b)
Week | Unit Sold (A) | 2-week weighted moving avg. | Forecast Error (Actual Value - Forecast) | Absolute deviation (data without negative sign) |
1 | 523 | |||
2 | 587 | |||
3 | 622 | 561.40 | 60.60 | 60.60 |
4 | 601 | 608.00 | -7.00 | 7.00 |
5 | 615 | 609.40 | 5.60 | 5.60 |
6 | 578 | 609.40 | -31.40 | 31.40 |
7 | 592.80 | |||
Mean Absolute Deviation (MAD)= Avg. of absolute value of forecast error | 26.15 |
c) Forecast for week 7 is 598 units sold because MAD is lower for 3-week moving average so that forecast is better.
Formulas used in excel calculation:
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two...
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two different forecasting methods (parts a and b below) to determine which method is best. For your measure of "best", recommend to your boss that the company should use the method with the lowest mean absolute deviation (MAD). Then use that method to provide your forecast for week 7 in part c. Week >WN Unit Sold 523 587 622 601...
The details of the hard drive sales for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. You have been told to use 2 period weighted moving average estimation technique to help in forecasting the needs for next week. (k =2 with weights 0.8, 0.2) Week Units sold 88 44 54 65 572 6 85 You are being asked to help forecast for week 7,...
Problem II The following time series shows the sales of a clothing store over a 10-week period. Week Sales ($1,000s) 15 a. Compute a 4-week moving average for the above time series. b. Compute the mean square error (MSE) and mean Absolut deviation (MAD) for the 4. week moving average forecast. c. Use a -0.3 to compute the exponential smoothing values and MSE and MAD for the time series. d. Forecast sales for week 11. e. Which model is the...
In this problem, you are to test the validity of your forecasting model. Here are the forecasts for a model you have been using and the actual demands that occurred: WEEK mtindo FORECAST 840 870 970 970 1,020 ACTUAL 920 1,020 1,070 920 920 1,010 995 a. Use the method stated in the text to compute the MAD and tracking signal for each week. (Negative values should be indicated by a minus sign. Round your "Tracking Signal" to 1 decimal...
nstructions You are responsible for creating the weekly forecast for Products X, Y, and Z for War Eagle Trading Company (WETCO). Create and evaluate forecasts as described in questions 1-10 below. Enter your answers in the table provided at the bottom of the assignment. All forecasts should be reported to the nearest whole number. Use the following in creating all forecasts: a7 W.6 n 3 W 3 Wa1 W 01 Demand for weeks 1-9 for each product is shown below....
You want to compare how two forecasting methods would perform on some historical sales data. You will forecast the sales for months 4 through 19, calculate the mean absolute deviation (MAD) for both methods, and you can claim that the one that has lower MAD performed better, at least for the historical data. a) The first method is known as the moving average method. The forecast for a month will be the average sales of three previous months. So, forecast...
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...
46. Consider the sales for six consecutive weeks for Sam’s Strawberries. The sales are in “flats” sold. Week Sales 1 16 2 18 3 14 4 10 5 20 6 22 I just need the answer of E . E problem a. Using a moving average with AP = 3, forecast the sales for weeks four through six. What is the forecast for week 6? 14.7 b) Use...
Problems (not on scantron-show your work) 1. (12 points) Given the following sales for the past 5 months, determine a forecast for Sept using the following methods. Apr May June luly Aug 320 370 400 440 490 3 period moving average We. Moving Average (wts. 3, 1,1 Exp. Smoothing (a 0.4, Fau 394.4 Trend Adjusted Forecast (a-04, β-ol), use the first four periods to start this forecast (start in July. TAF 440.0) Linear Trend (a-281, b41, Apr is period 1)...
You are doing an internship with Macy’s and are tasked with forecasting sales so that you can make inventory orders. You have weekly sales data for men’s dress shirts in your store from each of the past six weeks. You decide to try both a 3-period moving average and exponential smoothing with λ = 0.7 to see which model is more accurate and then use that one to make forecasts. The sales data is shown below. Week # of Shirts...