Question

PROBLEM: Calculating demand for hot tubs MONTH DEMAND January 4 February 7 March 11 April 7...

PROBLEM: Calculating demand for hot tubs

MONTH

DEMAND

January

4

February

7

March

11

April

7

May

14

June

15

a.       Using a simple three-month moving average, find the July forecast.

b.       Using a weighted moving average with weights of .60, .30, and .10, find the July forecast. (NOTE: In your calculations, apply the highest weight to the most recent month and so forth, middle weight to the middle month, and lowest weight to the farthest month back.)

c.       Using exponential smoothing with ? = .5 and a June FORECAST equal to 13, find the July forecast.

d.       Using simple linear regression analysis, calculate the regression equation and the forecast for July.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Historical demand for a product is as follows: DEMAND   April 58          May 54          June...
Historical demand for a product is as follows: DEMAND   April 58          May 54          June 74          July 58          August 76          September 73        a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.)   Forecast for October    b. Using single exponential smoothing with ? = 0.10 and a September forecast = 61, calculate a forecast for October. (Round your answer to 2 decimal places.)   Forecast for October...
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21...
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September 20 October 20 November 21 December 23 Plot the monthly sales data. Forecast January sales using each of the following: Naive method. A 3-month moving average. A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. Exponential smoothing using...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: 6.Using January through July values, develop a linear trend equation for this time series (to 4 decimals). Please write the equation in the proper form. 7.Using your answer from...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: ques 1 given the information above 1.Use exponential smoothing (a= 0.10) to forecast the sales for August (to 2 decimals). What is the value? 2. Compute the MSE for...
Month 1 2 3 4 5 6 7 Value 25 14 21 13 20 24 16...
Month 1 2 3 4 5 6 7 Value 25 14 21 13 20 24 16 (b) Develop the three-month moving average forecasts for this time series. Month Time Series Value Forecast 1 25 2 14 3 21 4 13 5 20 6 24 7 16 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for month 8? (c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. (Round...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22 11 18 10 17 21 13 A) What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a trend pattern.     The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern. B) Develop the three-month moving average forecasts for this time series. Month Time Series Value Forecast 1...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Create a time series plot. What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation....
1. Weighted Moving Average (1 point) Since the SRU holiday break impacted December & January student...
1. Weighted Moving Average (1 point) Since the SRU holiday break impacted December & January student visits and the Spring Break impacted March student visits, you have assigned a weight on the most recent 3 month values to compensate for the seasonality fluctuations. They weights are: January = 1, February = 4 and March =3. April’s forecast is _________ Actual                          Customers December           178 January 180 February              210 March                   204 April                       ??? 2. Exponential Smoothing (1 point)...
Month 1 2 3 4 5 6 7 Value 22 13 18 12 18 23 14...
Month 1 2 3 4 5 6 7 Value 22 13 18 12 18 23 14 Consider the time series data b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary). Enter negative values as negative number. Month Time Series Value Forecast Forecast Error Squared Forecast Error Totals MSE The forecast for month 8 c. Use a=.2 to compute the exponential smoothing forecasts for the time...