17. The analysts at Gonzales were kept busy performing “what-if ” analyses of the data in problem 16.

a. Suppose a top-management meeting produces a decision that the family forecast for product family 3 (products G, H, and I) in problem 16 can’t be increased. At the same meeting, the company’s overall forecast ($300,000) is maintained. Roll the forecasts up and down to determine the dollar and unit forecasts.

b. Suppose the family forecast data in problem 16 are assumed to be correct, except in any case where the sum of the exponential smoothing forecast data for items exceeds the family forecast.

In these cases, the sum of the item forecasts will be used instead of the family forecast.

Roll up the resultant overall forecast and roll down the resultant item forecasts.