I just need Part D and E . Thank you

Harvey and Co. is an editorial company that publishes three weekly magazines: Health, Fitness and Wellness (HF\&W), Fashion Weekly (FW) and Parenting Today (PT). They all have a huge success and Harvey has seen their demands increase very rapidly over the last two months. The demand of HF\&W for the next weeks has been estimated to be 6,000 units per week, while the demand of FW is 8,000 and the demand for PT is 4500 . Unfortunately, Harvey hasn't have enough time to adjust it's printing capacity to the new levels of demand and has been forced to print some of the units through an independent printing company. The requirements for each magazine are summarized in the following table. Harvey has 40 hours of printing capacity, 2 tons of paper and 20 liters of ink per week. The costs of printing in house and buying the magazine printed by the independent company can be found in the table below. a. Develop a linear programming model to determine the make-or-buy decision for Harvey that will meet the demand at a minimum total cost. b. Find the optimal solution using EXCEL's Solver. c. Write a report explaining in detail the optimal solution (number of magazines printed, number of magazines purchased, total cost, resources used, ...) d. Modify the model you did in part (a) to add the option of using overtime: Instead of outsourcing some of the printing, Harvey can choose to increase it's printing capacity by a maximum of 20 additional hours working on overtime. The cost of working on overtime is very expensive though, each hour Harvey decides to work on overtime costs $75 (Hint: you will need a new decision variable and some of the constraints will be affected as well as the objective function). e. Add a new tab to the Excel file you created in (b) and find the new optimal solution using EXCEL's Solver. Submit the file in the link provided in Canvas