Please solve the following three aggregate planning problems from Nahmias' Production and Operations Analysis, 7th edition. The deliverable should be an Excel file with your Linear Programming formulation and your results using Solver. Problem 1 24. Mr. Meadows Cookie Company makes a variety of chocolate chip cookies in the plant in Albion, Michigan. Based on orders received and forecasts of buy- ing habits, it is estimated that the demand for the next four months is 850, 3.5 Solving Aggregate Planning Problems 155 1,260, 510, and 980, expressed in thousands of cookies. During a 46-day period when there were 120 workers, the company produced 1.7 million cook- ies. Assume that the number of workdays over the four months are respectively 26, 24, 20, and 16. There are currently 100 workers employed, and there is no starting inventory of cookies. a. What is the minimum constant workforce required to meet demand over the next four months? b. Assume that ci = 10 cents per cookie per month, CH $100, and cf = $200. Evaluate the cost of the plan derived in part (a). c. Formulate as a linear program. Be sure to define all variables and include the required constraints. d. Solve for the optimal solution