Question

In: Math

Your manager is trying to determine what forecasting method to use. Based upon the following historical...

Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize.


MONTH ACTUAL DEMAND
1 59
2 62
3 64
4 65
5 73
6 75
7 75
8 78
9 78
10 81
11 82
12 85


a. Calculate the simple three-month moving average forecast for periods 4–12. (Round your answers to 3 decimal places.)


Month Three-Month
Moving Average
4
5
6
7
8
9
10
11
12


b. Calculate the weighted three-month moving average for periods 4–12 using weights of 0.40 (for the period t−1); 0.50 (for the period t−2), and 0.10 (for the period t−3). (Do not round intermediate calculations. Round your answers to 1 decimal place.)


Month Three-Month Weighted
Moving Average
4
5
6
7
8
9
10
11
12


c. Calculate the single exponential smoothing forecast for periods 2–12 using an initial forecast (F1) of 58 and an α of 0.40. (Do not round intermediate calculations. Round your answers to 3 decimal places.)


Month Single Exponential
Smoothing Forecast
2
3
4
5
6
7
8
9
10
11
12


d. Calculate the exponential smoothing with trend component forecast for periods 2–12 using an initial trend forecast (T1) of 1.50, an initial exponential smoothing forecast (F1) of 57, an α of 0.40, and a δ of 0.40. (Do not round intermediate calculations. Round your answers to 3 decimal places.)


Month Exponential Smoothing
with Trend
2
3
4
5
6
7
8
9
10
11
12


e-1. Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in periods 4–12. (Do not round intermediate calculations. Round your answers to 3 decimal places.)


Mean Absolute
Deviation
Three-month moving average
Three-month weighted moving average
Single exponential smoothing forecast
Exponential smoothing with trend


e-2. Which forecasting method is best?

Single exponential smoothing forecast
Three-month weighted moving average
Three-month moving average
Exponential smoothing with trend forecast

Solutions

Expert Solution

a)

3 Moving Average = (Sum of Previous 3 Months Value)/3

b)

c)

Exponential Smoothing = αAt + (1-α) Ft

d)

E1)

Three Moving Average

MAD = Average of Absolute Deviation = 4.630

Weighted Three Moving Average

MAD = Average of Absolute Deviation = 3.911

Exponential Smoothing

MAD = Average of Absolute Deviation = 5.619

Exponential smoothing with trend component

MAD = Average of Absolute Deviation = 2.064

E2)

Exponential smoothing with trend forecast is the best as MAD is least.


Related Solutions

Your manager is trying to determine what forecasting method to use. Based on the following historical...
Your manager is trying to determine what forecasting method to use. Based on the following historical data, calculate the following forecast and specify what procedure you would utilize. 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 1. Calculate the exponential smoothing with trend component forecast for periods 2–12 using an initial trend forecast (T1) of 1.8, an initial exponential smoothing forecast...
Your manager is trying to determine what forecasting method to use. Based on the following historical...
Your manager is trying to determine what forecasting method to use. Based on the following historical data, calculate the following forecasts and specify what procedure you would utilize. MONTH ACTUAL DEMAND 1 53 2 56 3 58 4 65 5 74 6 75 7 76 8 77 9 77 10 79 11 81 12 82 c. Calculate the single exponential smoothing forecast for periods 2–12 using an initial forecast (F1) of 61 and an α of 0.30. d. Calculate the...
If your manager asked you the differences between time series forecasting models and regression-based forecasting models,...
If your manager asked you the differences between time series forecasting models and regression-based forecasting models, what would you tell him/her?
Why should someone use driver based forecasting instead of account based forecasting
Why should someone use driver based forecasting instead of account based forecasting
Given: trying to determine if grading practices are consistent with the rest of their department. Historical...
Given: trying to determine if grading practices are consistent with the rest of their department. Historical data indicated the department's overall grade distribution for the course this instructor teaches is the following: A/A-: 54% B+/B/B-: 28% C+/C/C-: 11% D+/D/D-: 3% F: 2% other: 2% following the semester final grades are shown below for the course: A/A-: 53 B+/B/B-" 36 C+/C/C-: 12 D+/D/D-: 5 F:1 other: 3 total: 110 to test this consistency, the instructor will use a chi-square goodness-of-fit test...
1. Based on historical data, your manager believes that 31% of the company's orders come from...
1. Based on historical data, your manager believes that 31% of the company's orders come from first-time customers. A random sample of 82 orders will be used to estimate the proportion of first-time-customers. What is the probability that the sample proportion is less than 0.28? Answer =  (Enter your answer as a number accurate to 4 decimal places.) 2. In a recent year, the Better Business Bureau settled 75% of complaints they received. (Source: USA Today, March 2, 2009) You have...
1. Based on historical data, your manager believes that 31% of the company's orders come from...
1. Based on historical data, your manager believes that 31% of the company's orders come from first-time customers. A random sample of 146 orders will be used to estimate the proportion of first-time-customers. What is the probability that the sample proportion is greater than than 0.22? Note: You should carefully round any z-values you calculate to 4 decimal places to match wamap's approach and calculations. 2. Business Weekly conducted a survey of graduates from 30 top MBA programs. On the...
Pick one of the following: •   Technical Forecasting •   Fundamental Forecasting •   Market Based Forecasting Why...
Pick one of the following: •   Technical Forecasting •   Fundamental Forecasting •   Market Based Forecasting Why might forecasting be used by a multinational corporation? Clearly define the forecasting technique you have chosen. Explain in detail what is involved with the forecasting technique you have chosen. Explain what is meant by market efficiency. Then explain the implications of market efficiency on your chosen technique.
Pick one of the following: • Technical Forecasting • Fundamental Forecasting • Market Based Forecasting Why...
Pick one of the following: • Technical Forecasting • Fundamental Forecasting • Market Based Forecasting Why might forecasting be used by a multinational corporation? Clearly define the forecasting technique you have chosen. Explain in detail what is involved with the forecasting technique you have chosen. Explain what is meant by market efficiency. Then explain the implications of market efficiency on your chosen technique.
14. Which of the following assumptions is motivational interviewing as a behavioral change method based upon?...
14. Which of the following assumptions is motivational interviewing as a behavioral change method based upon? A. People do not possess the capacity and desire for self-actualization B. Ambivalence is not a normal part of change that can become a motivational obstacle in the process of change C. The power to change is within each client D. Both A and B
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT