8. Exercise 5.8 Bell Greenhouses has estimated its monthly demand for potting soil to be the following: N=400+9XN=400+9X
Posted: Sun Jul 03, 2022 1:14 pm
- 8 Exercise 5 8 Bell Greenhouses Has Estimated Its Monthly Demand For Potting Soil To Be The Following N 400 9xn 400 9x 1 (80.5 KiB) Viewed 12 times
8. Exercise 5.8 Bell Greenhouses has estimated its monthly demand for potting soil to be the following: N=400+9XN=400+9X where N is the monthly demand for bags of potting soil and X is the time period in months (March 2016 = 0). 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: Complete the following table by forecasting Bell Greenhouses' demand for potting soil in March, June, August, and December 2017. Adjustment Factor (%) Forecast Month March June August December -12 The following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years. 2015 301 2014 193 2013 85 +2 Year Forecast Actual 2017 517 2016 409 ⠀ +15 538 442 310 207 87 What seasonal adjustment factor would you recommend be used to forecast in April 2018? 1.8% +10 5.0% 2.6%