solution
Gaspe Agricultural Tannery Ltd. in New Richmond, Quebec supplies leather to Antigonish Boot Manufacturing Ltd. in Nova Scotia on a monthly basis for manufacturing western style cowboy boots. Antigonish Boot Manufacturing does not keep a large stock of leather inventory on hand, thus the Gaspe Agricultural Tannery factory must provide sufficient leather to meet their production demand on a timely basis. Furthermore, the quality of the leather must be of the highest grade. The sales demand for cowboy boots is lowest in the late winter, increases during the summer and fall, and reaches its peak during the Christmas (November) season. The production demand for leather follows the same general pattern. Gaspe Agricultural Tannery Ltd. in New Richmond, Quebec has experienced the following monthly demand for the past fourteen months:
|
Month |
Demand (1,000 yd2) |
Month |
Demand (1,000 yd2) |
|
January |
1.3 |
August |
2.0 |
|
February |
1.1 |
September |
2.9 |
|
March |
0.9 |
October |
3.2 |
|
April |
1.6 |
November |
3.7 |
|
May |
1.5 |
December |
2.4 |
|
June |
2.1 |
January |
1.6 |
|
July |
2.4 |
February |
1.0 |
- Develop a forecast for March using: (i) a 3-month moving, and (ii) a 3-month weighted moving average with weights of .60, .30 and .10, for the most recent demand.
b.) Develop an exponentially smoothed forecast with = 0.4.
c.) Develop an adjusted exponentially smoothed forecast with = 0.40 and = 0.50.
d.) Develop a linear trend line forecast.
e.) Compare the accuracy of your moving average, weighted moving average, exponential
smoothing, adjusted exponential smoothing, and linear trend line forecasts using MAD, and
indicate the forecast you would employ.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

