Bell Greenhouses has estimated its monthly demand for potting soil to be the following: Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years: MONTH ADJUSTMENT FACTOR (%) March +2 June +15 August +10 December −12 a. Forecast Bell Greenhouses’ demand for potting soil in March, June, August, and December 2007. Answer b. If the following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years, determine the seasonal adjustment factor to be used in making an April 2008 forecast. YEAR FORECAST ACTUAL 2007 500 515 2006 452 438 2005 404 420 2004 356 380 2003 308 320
Bell Greenhouses has estimated its monthly
Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years:
|
MONTH |
ADJUSTMENT FACTOR (%) |
|
March |
+2 |
|
June |
+15 |
|
August |
+10 |
|
December |
−12 |
- a.
Answer
- b.
If the following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years, determine the seasonal adjustment factor to be used in making an April 2008 forecast.
|
YEAR |
FORECAST |
ACTUAL |
|
2007 |
500 |
515 |
|
2006 |
452 |
438 |
|
2005 |
404 |
420 |
|
2004 |
356 |
380 |
|
2003 |
308 |
320 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
