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 cannot 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.

c. Suppose a major customer order has just been received for 10 units of product J. This order was not expected and is in addition to any other forecasts for product J. The company still wants to plan a total monthly sales volume of $300,000. Use the family forecasts (revised)

to roll the forecasts up and down to get revised individual product forecasts.