(11 points total) 4. The data below provides weekly sales for 15 weeks (weeks 1-15). (3 pts.) 4.1. Using a three period weighted moving average with weights of 0.6,0.3 and 0.1 , what is the forecast for week 16 sales? a) 2887.4 b) 2913.3 c) 2998.9 d) 5311 e) 5503 f) none of the above (5 pts.) 4.2. For this data, what is the linear regression equation for forecasting, and what is the associated R2 value? Equation: R2 (3 pts.) 43. What is the linear regression forecast for week 18 ? Consider a twelve-month sales and operations planning problem with the monthly demand for January - December shown in the table below. Suppose that: - Each employee makes 5 units per month. - Each employee hired costs $2500 and each employee fired (laid off) costs $1000. - The inventory holding cost is $100 for each unit held at the end of a month. - The plan must start and end with 8 employees. - The plan must start with 40 units of inventory at the beginning of January. - The plan must end with at least 40 units of inventory at the end of December. - Backordering (negative inventory) is not allowed in any month. Find the lowest cost S\&OP plan where all hiring and firing must be in integers (no fractions). Report the total cost of your plan in part (a), and fill in the table below in part (b) to show the number of employees hired and fired at the beginning of each month, the production each month and the inventory at the end of each month. a) Total cost for the plan b) Fill in the table