Roll down the forecast using rolled down sales goal


Problem: Biotech Industries produces 9 products that are further grouped into three product families.  Products A, B, and C comprise family 1; D, E, and F comprise family 2; G, H, and I comprise family 3.  The following exponential smoothing forecast of monthly demand for each product has been rolled up and presented to you as the unit forecast.  The sales force has also estimated monthly forecasts of sales for each product family.  Top level management has set the overall monthly sales goal at $200,000.  Management has also fixed the family 2 sales goal at $50,000.  Your task is to roll down the forecast using the rolled down $ sales goal of $60,000 as the basis for family 1.  You only need to calculate the rolled down goals for family 1 products A and B.  When you are calculating the "unit goal", you must round to a whole number as this is a UNIT forecast for your sales team (you cannot sell a fraction of a product to a customer)

Request for Solution File

Ask an Expert for Answer!!
Other Management: Roll down the forecast using rolled down sales goal
Reference No:- TGS03276289

Expected delivery within 24 Hours