Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. The Gonzales Electric Company's 12 products are further grouped into four products families. Products A,B, and C compose family 1; D,E and F compose
2. The Gonzales Electric Company's 12 products are further grouped into four products families. Products A,B, and C compose family 1; D,E and F compose family 2; G,H and I compose family 3; and products J,K and L make up family 4. Dick Gonzales has the following exponential smoothing forecasts of monthly demand for each product. Family Product Forecast $/unit 1 A 10 1000 B 15 1200 C 20 900 2 D 5 5000 E 3 7000 F 2 9000 3 G 100 250 H 180 100 I 220 100 4 J 2 10000 K 4 9000 L 3 8000 Gonazale's sales force has also come up with the monthly forecasts of sales for each product family. Family $ Sales 1 50000 2 50000 3 75000 4 75000 a. Top management has independently set a $300,000 overall monthly sales goal for the company. Roll up the individual product forecasts and compare them with the family data. b. Roll up the family forecasts to the top level, compare these to overall forecasts, and roll the forecasts back down to families to individual unit forecasts
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started