Answered step by step
Verified Expert Solution
Question
1 Approved Answer
let xx = 1 6 ( a ) Using level strategy, find the minimum constant workforce plan for the six months, and the total cost
let xx
a Using level strategy, find the minimum constant workforce plan for the six months, and the total cost of the plan. Shortages are not permitted at any time. The plan should show the production and subcontracting levels, workforce levels, number hired, number fired, and ending inventory for each month. You may hire or fire workers only at the start of Jan, and no overtime production is allowed. Calculate the cost of this plan
b Determine the zero inventory chase plan that hires and fires workers each month to match demand as closely as possible, and the cost of that plan. No stockouts or overtime is allowed.
points
c Find an aggregate production plan that uses a constant workforce, and where backorders are allowed only in the months of January, February and March. You may hire or fire workers only at the start of Jan, and no overtime production is allowed. Calculate the cost of this plan. points
d Determine a constant workforce plan that uses only workers employed at the start of January. Use overtime hours to increase production levels when necessary to meet demand. What is the cost of this plan? points
F Formulate a mathematical model using Excel solver to generate the aggregate optimal production plan for the constant workforce strategy in part a The Excel sheet should be able to calculate the decision variables, as well as the total cost, which can be checked by comparing it to the results obtained in part a points
E Formulate a mathematical model using Excel solver to generate the aggregate optimal production plan, allowing all options in all months. Compare the total cost of this aggregate production plan with the total costs of the strategies used in parts ab and c points
g By changing the values of cost parameters such hiringfiring inventory, variable production, and overtime, realize the potential tradeoffs between decision variables and explain how the observed results will validate the model behavior mathematically.
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