14. MacRonald’s Restaurant uses a monthly exponential smoothing forecast for demand of each of its products. MacRonald’s has four product families: burgers, chicken, hoagies, and pizza. MacRonald’s also asks the shift managers to come up with a forecast for each product family. The exponential forecast for each product and the family forecast are given below.

a. Calculate a roll-up of the individual forecasts and compare it to the product family forecast.

b. Roll up the individual product forecast to the top level and compare it to an overall corporate forecast of $65,000. Roll the forecast back down to families and individual forecasts (dollars and units).

Transcribed Image Text:

Family Product Forecast $/Unit Regular 1,200 1.00 Burgers Super 2,700 1.50 Super-Duper 2,100 1.80 Regular 1,800 2.50 Chicken Cajun 2,700 2.75 Italian 2,250 3.50 Hoagies French 1,650 3.00 American 1,350 3.25 Cheese 750 1.75 Pizza Pepperoni 1,200 2.25 Family $ Sales Burgers 10,000.00 Chicken 15,000.00 Hoagies 20,000.00 Pizza 5,000.00