Question 1 Part A
The following table shows the best forecast for a time series representing the number of people (in thousands) who have two or more jobs in the United States
| Date | Jobs | Forecast |
|---|---|---|
| May 2013 | 6,487 | 6,788 |
| June 2013 | 6,284 | 6,523 |
| July 2013 | 6,253 | 6,279 |
| August 2013 | 6,840 | 6,336 |
Calculate the MAD (mean absolute deviation) forecasting accuracy measurement. Take all calculations to three decimal places.
Part B
Based on the actual and forecasted returns shown below, calculate the mean absolute deviation (MAD)
| Month | Monthly Return | Forecast (%) |
|---|---|---|
| July | 2.20 | 1.95 |
| August | 2.25 | 2.21 |
| September | 1.8 | 2.35 |
| October | 1.4 | 2.15 |
| November | 1.1 | 1.6 |
| December | 1.9 | 1.2 |
|
0.249 |
||
|
1.531 |
||
|
0.507 |
||
|
None of these. |
||
|
2.344 |
Part C
To calculate an exponential smoothing forecast of demand, what values are required?
|
alpha, last forecast, last actual value |
||
|
alpha, last forecast, number of periods |
||
|
last forecast, number of periods, averaging period |
||
|
alpha, last forecast |
||
|
alpha, number of periods, last actual demand |
Part a:
Mean absolute deviation =
Part b:
Mean absolute deviation =
The answer is none of the above
Part c:
Alpha, last forecast and last actual value
The formula for exponential smoothing forecast is
Yt+1 = Yt + alpha (At-Yt)
where, Yt is the forecasted value of the previous period, alpha is the correction term and At is the actual value of the previous period.
Question 1 Part A The following table shows the best forecast for a time series representing...
Complete PART (b) ONLY. Please use answer from Part
(a). Please complete this using EXCEL; SHow the steps/ excel
calculations.
Month
Actual Demand
1
62
2
65
3
67
4
68
5
71
6
73
7
76
8
78
9
78
10
80
11
84
12
85
part (a)
MY answer to Part (a):
Part (b)
(b) Now calculate all the measures of
forecasting accuracy listed below for the single exponential
smoothing forecast completed in part (a)
-i) MAPE (Mean...
Please help with questions 7 - 10.
PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...
The following table shows the actual demand observed over the last 4 years: ...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 27 2 29 3 33 4 41 5 44 6 43 7 44 8 46 9 47 10 41 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 27. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 27 2 27 3 27.6 4 29.22 5 32.75 6...
Please solve for the standard deviation step by
step.
Calculating Forecast Error Measures The following table shows the actual sales of upholstered chairs for a furniture manufacturer and the forecasts made for each of the last 8 months. Calculate CFE, MSE, a, MAD, and MAPE for this product Month, Demand, D Forecast Error E Error, Squared, E Absolute Error, Absolute Percent Error, (END(100) 200 225 -25 625 25 12.5% 2 240 220 20 400 20 8.3 3 300 285 15...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 29 3 32 4 33 5 35 6 32 7 35 8 42 9 44 10 45 a. Calculate the single exponential smoothing forecast for these data using an α of 0.10 and an initial forecast (F1) of 33. (Round your answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.10, a...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6 37 7 42 8 44 9 41 10 42 a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...
Examples 1,2,3
1. Beyond Tea Inc. wants to forecast sales of its menthol green
tea. The company is considering either using a simple mean or a
three-period moving average to forecast monthly sales. Given sales
data for the past 10 months use both forecasting methods to
forecast periods 7 to 10 and then evaluate each. Which method
should they use? Use the selected method to make a forecast for
month 11. (Show all calculations .... Please read Examples1, 2, 3...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...