Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started