Question: could you solve it on excel step by step thank you 4. Mr. Meadows Cookie Company makes a variety of chocolate chip cookies in the

could you solve it on excel step by step thank you
4. Mr. Meadows Cookie Company makes a variety of chocolate chip cookies in the plant in Albion, Michigan. Based on orders received and forecasts of buying habits, it is estimated that the demand for the next four months is 850, 1260, 510 and 980, expressed in thousands of cookies. During a 46-day period when there were 120 workers, the company produced 1.7 million cookies. 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? (No backlog is allowed - Level Strategy) (b) Apply Chase Strategy to find the number of workers for each month. (c) Assume that cj = 10 cents per cookie per month, cu = $100, and cp = $200. Evaluate the cost of the plan derived in part (a) and (b). Which one do you recommend? CHStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
