Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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
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...
See similar textbooks
icon
Related questions
Question
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.
Transcribed Image Text: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.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
SEE MORE TEXTBOOKS