You are working for Dire Wolf Industries (DWI), helping them run their Sales & Operations Planning (S&OP) program for a line of make to stock items. Specifically, you are running the aggregate planning model to help assist the Chief Operating Officer (COO) and the Vice President of Sales to agree upon the next 12 months plan. The aggregate model is attached here. The model provided here is offered without any input data. That data is provided below, and you must enter it by hand into the spreadsheet. When solving this model, while the number of workers must be an integer, the amounts of money, hours and items do not have to be integers. The solver settings can be seen here. Part 1 0.0/2.0 points (graded) The model provided above is offered without any of the input data. The demand data for the model is provided below, and you must enter it into the spreadsheet. The aggregate monthly demand of the item is as follows: January February March April 11068 10012 9076 6932 May June July August 4036 2092 1172 2932 September October November December 5108 6044 7948 12268 The remaining data for the model is provided below, and you must enter it into the spreadsheet. Please enter the input values with all the decimal values given below. Material cost ($/unit): 16.7875 Inventory holding costs ($/unit/month): 3.6125 Cost of stockouts ($/unit/month): 6.5875 Cost for hiring and training new worker: 2125.0 Cost for laying off an employee: 4250.0 Labor hours required per item produced: 0.84 Regular worker cost ($/month): 2040.0 Overtime cost ($/hour): 14.4196 Outsourcing cost ($/item): 38.4625 Hours worked by employee per month: 175.84 Max overtime (hours/month/employee): 12.32 Starting inventory: 2000.0 Ending inventory (min): 2000.0 Starting backlog: 0.0 Allowable ending backlog (max): 0.0 Starting workforce: 24.0 Ending workforce (min): 24.0 Ending workforce (max): 24.0 Base price ($/item): 44.8375 You want to develop an initial aggregate plan for the next 12 months. Use the initial data provided above and assume that there are no planned promotions or discounts over the next 12 months. Find the optimal plan over the next 12 months. Based on this optimal solution, answer the following questions. What is the total annual profit? Enter your answer in dollars, without currency symbol or thousands of delimiters. For example, if your answer is $1,234 then type 1234 in the space. Part 2 Using the status quo (Part 1) as starting point, the senior team has asked you to assess the impact of running a three-month promotion during the Summer with a 15% discount in June (month 6), a 25% discount in July (month 7), and a 15% discount in August (month 8). Use an elasticity value of 5 and solve optimally. Will the total annual profit increase in this scenario, compared to the profit in Part 1? Select an option Yes, it will increase No, it will remain the same No, it will decrease It cannot be determined Solving optimally, what is the total annual profit with this promotion? Enter your answer in dollars, without currency symbol or thousands of delimiters. Part 3 There are some concerns about the sustainability of the operations at the subcontractors. Using the status quo (Part 1) as starting point, the senior team has asked you to assess the impact of a policy that would eliminate all outsourcing of production. Solve optimally. How will the total annual profit under this policy compare to the profit of the status quo (Part 1)? Select an option It will decrease more than 5% It will decrease about 3% It will decrease less than 1% It will increase It cannot be determined Solving optimally, what is the total annual profit under this policy? Enter your answer in dollars, without currency symbol or thousands of delimiters. Part 4 There is some new technology coming into the market that may allow Dire Wolf to produce the items faster than before. Using the status quo (Part 1) as starting point, you have been asked to assess the impact that such a technology could have if it could reduce the labor hours required per item produced by one third. (Hint: This means that the hours required to produce an item using the new technology would be two thirds of the hours required to produce an item in the status quo). Solve optimally. Which of the following statements would be true considering the faster production scenario, compared to the status quo (Part 1)? Select all correct answers Outsourced production decreases by two thirds Firing employees is no longer done Total annual profit increases Outsourced production is no longer used Number of employees fired decreases by one third Solving optimally, what is the total annual profit in this scenario? Enter your answer in dollars, without currency symbol or thousands of delimiters. For example, if your answer is $1,234 then type 1234 in the space. Part 5 There are some concerns about the limitations of Dire Wolf's warehousing capacity. Using the status quo (Part 1) as starting point, the senior team has asked you to assess the impact of limiting inventory to a maximum of 4000 items. (Hint: This means that at no point can the inventory levels exceed this limit). Solve optimally. What is the total annual profit? Enter your answer in dollars, without currency symbol or thousands delimiters. For example, if your answer is $1,234 then type 1234 in the space