Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 1 Based on the parameter values and forecast shown below, prepare two aggregate plans using Excel. One plan should use a chase strategy, and
QUESTION 1 Based on the parameter values and forecast shown below, prepare two aggregate plans using Excel. One plan should use a chase strategy, and the other plan should use a level strategy. Assume that the planned production prior to month 1 is the same as the planned production in month 1. (This means that you will not hire or fire any workers or incur hiring or firing costs in the first month.) Include the following in each plan: Planned production for each month Ending inventory for each month Inventory holding cost for each month Workforce level (number of workers) for each month Production cost for each month Hiring cost for each month Firing cost for each month Total holding cost for the plan Total hiring cost for the plan Total firing cost for the plan Total production cost for the plan Total cost for the plan, including holding, hiring, firing, and production costs Labor standard (hours/unit) Number of hours per worker per month Hiring cost per unit Firing cost per unit Inventory holding cost per unit per month Production cost per unit Beginning inventory (ending inventory prior to month 1) Ending inventory in month 12 8 4 160 5 6 2 15 0 0 Month Forecast 1 4000 2 1000 3 2000 4 2000 5 4000 6 5000 7 6000 8 6000 9 5000 10 4000 11 2000 12 7000 QUESTION 18 For the LEVEL STRATEGY, what is the workforce level (number of workers) in month 8? Enter a whole number. QUESTION 19 For the LEVEL STRATEGY, what is the production cost in month 8? Enter a whole number without a dollar sign. QUESTION 20 For the LEVEL STRATEGY, what is the hiring cost in month 8? Enter a whole number without a dollar sign. QUESTION 21 For the LEVEL STRATEGY, what is the firing cost in month 8? Enter a whole number without a dollar sign
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