Question: please show work Each quarter, the General Manager and the Sales Manager develop the quarterly demand forecasts for each Product Family. They start with the

please show work  please show work Each quarter, the General Manager and the Sales
Manager develop the quarterly demand forecasts for each Product Family. They start

Each quarter, the General Manager and the Sales Manager develop the quarterly demand forecasts for each Product Family. They start with the "Product Family Master" (Figure 1) which provides the actual unit sales history for each Product Family by quarter and year. They create a "Product Family Forecast" (Figure 2) for the expected demand by Product Family for the next quarter based on their knowledge of industry trends, competitive strategies, and sales history. Figure 1: Product Family Master (Product Family Actual Sales in Units) Figure 2: Product Family Forecast Master (Product Family Forecast Sales in Units) 6. Using the actual sales data provided in Figure 1 and the forecast data provided in Figure 2, calculate the forecast for each product family for 2020 Q1 using the Exponential Smoothing forecast model where =0.2 (or 20% ). SHOW YOUR WORK, ROUND ANSWERS TO NEAREST WHOLE NUMBER ( 6 Rts) HINT: Use 2019 Q4 forecast from Figure 2 for F11 7. Using the actual sales data provided in Figure 1 and the forecast data provided Figure 2, calculate the forecast for each product family for 2020 Q1 using the Exponential Smoothing with Trend forecast model where =0.1 and =0.3. SHOW YOUR WORK, ROUND ANSWERS TO NEAREST WHOLE NUMBER ( 12pts ) HINT: Use 2019 Q4 forecast from Figure 2 for FIT 1.1 . PVB T11=17,232 Fire Valve T:1=16

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!