Solve using Solver in Excel

35. The Mr. Meadows Cookie Company can obtain accurate forecasts for 12 months based on lin orders. These forecasts and the number of workdays per month are as follows: Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand Forecast (in thousands of cookies) 850 1,260 510 980 770 850 1,050 1,550 1,350 1,000 970 680 Workdays 26 24 20 18 22 23 14 21 23 24 21 13 During a 46-day period when there were 120 workers, the firm produced 1.700,000 cookies. Assume that there are 100 workers employed at the beginning of month I and zero starting inventory. Find the minimum constant workforce needed to meet monthly demand. 1. Assume - $0.10 per cookie per month, cw $100, and cp - $200. Add columns that give the cumulative on-hand inventory and inventory cost. What is the total cost of the constant workforce plan? c. Solve for the optimal plan using linear programming. Compare your solution to b