06 A B xfx 64000 C D E F G Roll up the individual product forecasts and compare them with the family data. Use the family forecasts to revise the individual forecasts (both dollars & units). PART A Product Family Forecast Family $ Rolled-Up $ Rolled-Down $ Family Forecast Forecast Sales Goal 1 50,000 46.000 60,000 2 50,000 64.000 50,000 3 75,000 65,000 90,000 Total 175,000 175,000 200,000 , Use the FAMILY forecast to revise the individual item forecasts (in both dollars & units) 1 2 ROLL UP Unit 3 Product Forecast Dollars/Unit Dollar Forecast (goal) ROLL DOWN Dollar Forecast Unit Forecast (goal) A 10 $ 1,000.00 $ 10,000.00 5 B 15 $ 1,200.00 $ 18,000.00 6 C 20 $ 900.00 $ 18,000.00 17 TOTAL $ 46,000.00 18 5 $ 5,000.00 $ 25,000.00 19 E 3 $ 7,000.00 $ 21,000.00 20 F 2 $ 9,000.00 $ 18,000.00 xxXX XXXX 21 TOTAL $ 64,000.00 22 G 100 $ 250.00 $ 25,000.00 xxxxxXXXXXXXXXXXXXXXX 23 H 24 I 180 $ 220 $ 100.00 $ 18,000.00 xx 100.00 $ 22,000.00 25 TOTAL XXXXXXXXXXXX XXXXXXXXXXXX XXXX XXXXXXXXXXXX $ 65,000.00 xxxxxxXXXXXXXXXXXXXXXX 26 27 28 29 H J K L M N O Calculate the rolled up dollar forecast in the table to the left and then enter the total family dollar forecast in the table above. Next, roll down the forecast using the family forecast. then calculate the unit forecast.
06 A B xfx 64000 C D E F G Roll up the individual product forecasts and compare them with the family data. Use the family forecasts to revise the individual forecasts (both dollars & units). PART A Product Family Forecast Family $ Rolled-Up $ Rolled-Down $ Family Forecast Forecast Sales Goal 1 50,000 46.000 60,000 2 50,000 64.000 50,000 3 75,000 65,000 90,000 Total 175,000 175,000 200,000 , Use the FAMILY forecast to revise the individual item forecasts (in both dollars & units) 1 2 ROLL UP Unit 3 Product Forecast Dollars/Unit Dollar Forecast (goal) ROLL DOWN Dollar Forecast Unit Forecast (goal) A 10 $ 1,000.00 $ 10,000.00 5 B 15 $ 1,200.00 $ 18,000.00 6 C 20 $ 900.00 $ 18,000.00 17 TOTAL $ 46,000.00 18 5 $ 5,000.00 $ 25,000.00 19 E 3 $ 7,000.00 $ 21,000.00 20 F 2 $ 9,000.00 $ 18,000.00 xxXX XXXX 21 TOTAL $ 64,000.00 22 G 100 $ 250.00 $ 25,000.00 xxxxxXXXXXXXXXXXXXXXX 23 H 24 I 180 $ 220 $ 100.00 $ 18,000.00 xx 100.00 $ 22,000.00 25 TOTAL XXXXXXXXXXXX XXXXXXXXXXXX XXXX XXXXXXXXXXXX $ 65,000.00 xxxxxxXXXXXXXXXXXXXXXX 26 27 28 29 H J K L M N O Calculate the rolled up dollar forecast in the table to the left and then enter the total family dollar forecast in the table above. Next, roll down the forecast using the family forecast. then calculate the unit forecast.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 28P: The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing