Please answer question #15 on excel and show the steps so I can learn. one pyramid for both the roll up forecast and another pyramid for the forced-down forecast.

level? 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). b. If top management agrees to a total corporation- wide sales forecast volume of $9,000, what is the sales forecast at the item level? 15. The general sales manager at Knox Products Corporation has just received next year's sales forecast (in units) for two of the firm's major products (Less Knox and More Knox) from sales managers of the Eastern and Western sales regions: 16. The Gonzales Electric Company's 12 products are further grouped into four product families. Products A, B, and C compose family 1; D, E, and F are in family 2; G, H, and I compose family 3; and products J, K, and L make up family 4. Ernesto Gonzales has the following exponential smoothing forecasts of monthly demand for each product. Eastern Region Forecast Less Knox More Knox 150 300 Western Region Forecast Less Knox More Knox 300 450 Family Family Product Forecast A 10 Product Forecast G 100 1 3 B 15 H 180 20 S/Unit 1,000 1,200 900 5,000 7,000 9,000 1 220 S/Unit 250 100 100 10,000 9,000 8,000 2 D 5 4 J 2 E K 4 3 2 a. F 3 Less Knox sells for $4.50 per unit and More Knox sells for $8.50 per unit. The corporate economist has forecast a total corporation-wide sales volume for these two products of $11,000 for next year. What is the disparity between the two forecasts at the item Gonzales's sales force has also come up with the monthly forecasts of sales for each product family. level? 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). b. If top management agrees to a total corporation- wide sales forecast volume of $9,000, what is the sales forecast at the item level? 15. The general sales manager at Knox Products Corporation has just received next year's sales forecast (in units) for two of the firm's major products (Less Knox and More Knox) from sales managers of the Eastern and Western sales regions: 16. The Gonzales Electric Company's 12 products are further grouped into four product families. Products A, B, and C compose family 1; D, E, and F are in family 2; G, H, and I compose family 3; and products J, K, and L make up family 4. Ernesto Gonzales has the following exponential smoothing forecasts of monthly demand for each product. Eastern Region Forecast Less Knox More Knox 150 300 Western Region Forecast Less Knox More Knox 300 450 Family Family Product Forecast A 10 Product Forecast G 100 1 3 B 15 H 180 20 S/Unit 1,000 1,200 900 5,000 7,000 9,000 1 220 S/Unit 250 100 100 10,000 9,000 8,000 2 D 5 4 J 2 E K 4 3 2 a. F 3 Less Knox sells for $4.50 per unit and More Knox sells for $8.50 per unit. The corporate economist has forecast a total corporation-wide sales volume for these two products of $11,000 for next year. What is the disparity between the two forecasts at the item Gonzales's sales force has also come up with the monthly forecasts of sales for each product family