Question: Please upload an Excel spreadsheet. Make sure you explicitly answer all the questions. The Mr. Meadows Cookie Company can obtain accurate forecasts for 12 months

 Please upload an Excel spreadsheet. Make sure you explicitly answer all

Please upload an Excel spreadsheet. Make sure you explicitly answer all the questions. The Mr. Meadows Cookie Company can obtain accurate forecasts for 12 months based on firm orders. These forecasts and the number of workdays per month are as follows. 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 1 and zero starting inventory. a. Find the minimum constant workforce needed to meet monthly demand. Assume that stock-outs are not allowed. b. Assume clI=$0.10 per cookie per month, cH=$100, and cF=$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. Please upload an Excel spreadsheet. Make sure you explicitly answer all the questions. The Mr. Meadows Cookie Company can obtain accurate forecasts for 12 months based on firm orders. These forecasts and the number of workdays per month are as follows. 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 1 and zero starting inventory. a. Find the minimum constant workforce needed to meet monthly demand. Assume that stock-outs are not allowed. b. Assume clI=$0.10 per cookie per month, cH=$100, and cF=$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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!