In: Operations Management
Dade Industries makes syringes. The demand for the next four quarters and the cost data are given below. Each employee can produce 100 syringes per quarter. Because of union contract no overtime is permissible. The current work force is 18 workers.
Quarter |
1 |
2 |
3 |
4 |
Demand |
1500 |
2000 |
1800 |
2500 |
Hiring costs = $1000/ worker; Layoff costs = $ 700/worker;
Regular time wages = $10000/worker/quarter;
Inventory holding costs = $2.00/unit/quarter
Quarter |
||||
1 |
2 |
3 |
4 |
|
Beginning Inventory |
||||
Production Rate |
||||
Forecasted demand |
1500 |
2000 |
1800 |
2500 |
Ending Inventory |
||||
Planned Workforce |
||||
Planned Hires |
||||
Planned Layoffs |
Below is the screenshot of the formula applied -
Below is the screenshot of the result -