Answered step by step
Verified Expert Solution
Question
1 Approved Answer
for each product. 1 'HI'I'IUW} Family Product Forecast 10 15 20 5 3 2 5/ Unit 1,000 1,200 900 01000 zooo 1000 Family 5 Sales
for each product. 1 'HI'I'IUW} Family Product Forecast 10 15 20 5 3 2 5/ Unit 1,000 1,200 900 01000 zooo 1000 Family 5 Sales 1 50,000 2 50,000 3 75,000 4 75,000 3 Family Product G H I J K L Problem 16: The Gonzales Electric Company's 12 products are further grouped into four product families. Products A, B, and C compose family I; D, E, and F compose family 2; G, H, and | compose fam ily 3; and products J, K, and L make up family 4. Dick Gonzales has the following exponential smoothing forecasts of monthly demand Forecast S/Unit 100 250 180 100 220 100 2 1(L000 4 2000 3 aooo Gonzales's sales force has also come up with the monthly forecasts of sales for each product family. Roll up the individual product forecasts and compare them with the family data. Use the family forecasts to revise the individual forecasts (both dollars 8: units\" Use the family forecast to revise the individual item forecasts (in both dollars 8: units) __ Unit Dollars I Dollar Dollar Unit Forecast Unit Forecast Forecast Forecast Verify n n n_ _ Product Family Forecast Rolled-Up Family $ $ Product Forecast Forecast Family 1 2 1 a _ 4 _ 2 Note: Forecasts are all monthly _ 3 _ 4 $ 75,000-00
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