1. A medical device dealer in the local area wants to make an accurate forecast of demand for Super Sonic II Wheelchairs during the next month. Because the manufacturer is in Japan, it is difficult to send wheelchairs back or reorder if the proper number is not ordered a month in advance. From past sales records, the dealer has accumulated the following data on the Super Sonic II Wheelchairs over the past year:

MonthWheelchair SalesJanuary9February7March10April8May7June12July10August11September12October10November14December16

Compute a 3-month moving average forecast of demand for April through January (of the next year).

Compute a 5-month moving average forecast of demand for June through January.

Compare the two forecasts of the 3-month and 5-month using MAD. Which forecast method should the dealer use?

2. The Big City Hospital has experienced the following occupancy rates during the past 9 months:

MonthOccupancy Rate (%)183278375481586685789890986

Compute the exponential smoothing forecast with alpha=.2

Compute the exponential smoothing forecast with alpha=.2 and beta=.3 (you can use the results of first part and just add beta calculation)

Computer linear trend line forecast

Compare three forecasts using MAD and indicate which appears more accurate