|
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 to 2 decimal places.) |
| Month | Forecast |
| January of the next year | |
| February of the next year | |
| March of the next year |
A manager of a store that sells and installs spas wants to prepare a forecast for...
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 = 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 = 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...
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...
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...
The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months: Months Demand October 800 November 725 December 630 January 500 February 645 March 690 April 730 May 810 June 1200 July 980 Compute the following: a- MA3 b- MA4 c- WMA3...
2. (37 points) The manager of a travel agency wants to use seasonally adjusted forecast to predict demand for packaged tours. The demand for the last 14 weeks are given below: Week 1 2 3 4 5 6 7 89 10 1112 13 14 Demand 80 95 141 132 104 114 168 152 122 143 198 185 141 158 (10 points) Estimate weekly relatives for the demand using the centered moving average method. (10 points) Estimate weekly relatives for the...
690 The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 12 months: Month Gasoline Demanded (gal.) October 800 November 725 December 630 January 500 February 645 March 730 May 810 June 1,200 980 August 1,000 September 850 e. Compute linear trend line...
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...
The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months: MAT540 Homework Week 4 Page 2 of 5 Month Gasoline Demanded (gal.) October 775 November 835 December 605 January 450 February 600 March 700 April 820 May 925 June July 1500...