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 "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) 4. Using the actual sales data provided in Figure 1, calculate your own forecast for each product family for 2020 Q1 using a 3-quarter simple moving average forecast model. SHOW YOUR WORK, ROUND ANSWERS TO NEAREST WHOLE NUMBER ( 6pts ) 5. Using the actual sales data provide in Figure 1, calculate your own forecast for each product family for 2020 Q1 using a 3-quarter weighted moving average forecast model where W1 is 50%, w2 is 30% and w3 is 20%. SHGW YOUR WORK, ROUND ANSWERS TO NEAREST WHOLE NUMBER ( 6pts )