Problem 3-11
A manager of a store that sells and installs spas wants to
prepare a forecast for January, February, and March of next year.
Her forecasts are a combination of trend and seasonality. She uses
the following equation to estimate the trend component of monthly
demand: Ft = 90 + 2t, where t
= 0 in June of last year. Seasonal relatives are 1.08 for January,
.87 for February, and 1.01 for March. What demands should she
predict? (Round your answers to 2 decimal
places.)
| Month | Forecast |
| January of the next year | |
| February of the next year | |
| March of the next year | |
in June Last year t=0
July,last year t=1
January, this year t=7
January, next year t-19
Feb,next year t=20
Mar, next year t=21
hence forecast for Jan next year=Sesonality component*(90+2*t)
=1.08*(90+2*19)=138.24
Feb Next year=0.87*(90+2*20)= 113.1
March,next year= 1.01*(90+2*21)=133.32
.
.
I have given complete and detailed solution to your problem, in case of any query you can comment and
PLEASE DO GIVE A THUMBS UP
Problem 3-11 A manager of a store that sells and installs spas wants to prepare a...
A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 80 + 3t, where t = 0 in June of last year. Seasonal relatives are .87 for January, 1.05 for February, and 1.05 for March. What demands should she predict? (Round your answers...
A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 90 + 3t where t-O in June of last year. Seasonal relatives are 1.00 for January 96 for February, and .95 for March, what demands should she predict? (Round your answers to 2...
A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 50 + 6t, where t = 0 in June of last year. Seasonal relatives are 1.02 for January, .89 for February, and .99 for March. What demands should she predict? (Round your answers...
A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 90 + 3t, where t = 0 in June of last year. Seasonal relatives are 1.00 for January, .96 for February, and .95 for March. What demands should she predict? (Round your answers...
A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 60 + 4t, where t = 0 in June of last year. Seasonal relatives are .89 for January, .95 for February, and 1.11 for March. What demands should she predict? (Round your answers...
The past sales history for Store 10 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the MAPE value for the better of the two forecasts. That is, if the original trend projection forecast was better according to MAPE, then report that MAPE value. If however, the Re-Seasonalized forecast is better according to MAPE, then report the MAPE value for that forecast. Month Year Period Store 10 January 1 1...
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...
Master Budget Case: ToyWorks Ltd.
ToyWorks Ltd. is a company that manufactures and sells a single
product, which they call a toodle. For planning and control
purposes they utilize a quarterly master budget, which is
usually developed at least six months in advance of the budget
period. Their fiscal year end is December 31.
During the summer of 2018, Chris Leigh, the ToyWorks controller,
spent considerable time with Pat Frazer, the Manager of Marketing,
putting together a sales forecast for...