Question: Using the Excel template Aggregate Planning to try to find
Using the Excel template Aggregate Planning to try to find the best production strategy for the Golden Beverages example to minimize the total cost. The chase demand strategy has a total cost of $1,835,050, so you should seek a solution that has a lower cost.
Answer to relevant QuestionsChapman Pharmaceuticals, a large manufacturer of drugs, has this aggregate demand forecast for a liquid cold medicine. 1. Analyze the case data and current schedule, and answer the following “baseline” questions. What’s labor utilization for each thirty-minute period given their current staffing plan? Is the main problem lack of staff ...Eight jobs have arrived in the following order: Find and compare the average flow time, lateness, and tardiness for the following sequencing rules: a. Process in the order they have arrived b. Shortest processing time c. ...A hospital emergency room needs the following numbers of nurses. Each nurse should have two consecutive days off. How many full-time nurses are required and what is a good nurse schedule? Explain how each of the 7 QC Tools would be used in the five phases of the Six Sigma DMAIC problem solving approach. For example, in which phase(s) (Define, Measure, Analyze, Improve, or Control) would you expect to use ...
Post your question