A firm must plan production for the next six months. Each unit
costs $480 to produce and it has an inventory holding cost of $20
per unit per month based on ending inventory levels. The cost to
hire a worker is $330, and the cost to fire a worker is $660 per
worker. Each worker produces 10 units per month. There are 25
persons on the payroll at the beginning of the first month. The
company currently has 200 units of inventory in stock, and it wants
to keep at least this many units as safety stock at the end of
every month. Assume hiring and layoff/firing, if necessary, occur
at the beginning of the month.
Month | 1 | 2 | 3 | 4 | 5 | 6 |
Demand | 420 | 420 | 420 | 420 | 470 | 550 |
a. From the information given above, what level production rate will meet demand for the next six months? Using that rate, complete the level plan below. (Leave no cells blank - be certain to enter "0" wherever required.)
Level Plan | ||||||
Month | Demand |
Regular Production |
Ending Inventory |
Number of Workers |
Hire | Fire |
1 | 420 | |||||
2 | 420 | |||||
3 | 420 | |||||
4 | 420 | |||||
5 | 420 | |||||
6 | 420 | |||||
Total | 2700 |
b-1. At that production rate, what is the maximum end-of-period inventory experienced at some time during the six months?
Maximum end-of-period inventory | Units |
b-2. What would be the cost of a level production plan?
Total Cost |
c-1. From the information given above, Develop a chase (Hire and Fire only) Production Plan? (Leave no cells blank - be certain to enter "0" wherever required.)
Level Plan | ||||||
Month | Demand |
Regular Production |
Ending Inventory |
Number of Workers |
Hire | Fire |
1 | 420 | |||||
2 | 420 | |||||
3 | 420 | |||||
4 | 420 | |||||
5 | 420 | |||||
6 | 420 | |||||
Total | 2700 |
c-2. What is the total cost of a chase (hire and fire only) production plan?
Total Cost |
a.
Level Plan | ||||||
Month | Demand | Regular | Ending | Number of | Hire | Fire |
Production | Inventory | Workers | ||||
1 | 420 | 450 | 230 | 45 | 20 | 0 |
2 | 420 | 450 | 260 | 45 | 0 | 0 |
3 | 420 | 450 | 290 | 45 | 0 | 0 |
4 | 420 | 450 | 320 | 45 | 0 | 0 |
5 | 470 | 450 | 300 | 45 | 0 | 0 |
6 | 550 | 450 | 200 | 45 | 0 | 0 |
Total | 2700 | 2700 | 1600 | 20 | 0 |
b-1.
Maximum end-of-period inventory = 320 units
b-2.
Total cost = regular production cost + inventory holding cost + hire cost + fire cost
= 2700*480+1600*20+20*330+0*660 = 1334600
c-1.
Hire and Fire | ||||||
Month | Demand | Regular | Ending | Number of | Hire | Fire |
Production | Inventory | Workers | ||||
1 | 420 | 420 | 200 | 42 | 17 | 0 |
2 | 420 | 420 | 200 | 42 | 0 | 0 |
3 | 420 | 420 | 200 | 42 | 0 | 0 |
4 | 420 | 420 | 200 | 42 | 0 | 0 |
5 | 470 | 470 | 200 | 47 | 5 | 0 |
6 | 550 | 550 | 200 | 55 | 8 | 0 |
Total | 2700 | 2700 | 1200 | 30 | 0 |
C-2
Total cost = regular production cost + inventory holding cost +
hire cost + fire cost
= 2700*480+1200*20+30*330+0*660 = 1329900
A firm must plan production for the next six months. Each unit costs $480 to produce...
A firm must plan production for the next six months. Each unit costs $370 to produce and it has an inventory holding cost of $23 per unit per month based on ending inventory levels. The cost to hire a worker is $220, and the cost to fire a worker is $440 per worker. Each worker produces 10 units per month There are 20 persons on the payroll at the beginning of the first month. The company currently has 150 units...
A firm must plan production for the next six months. Each unit costs $430 to produce and it has an inventory holding cost of $15 per unit per month based on ending inventory levels. The cost to hire a worker is $280, and the cost to fire a worker is $560 per worker. Each worker produces 10 units per month. There are 20 persons on the payroll at the beginning of the first month. The company currently has 150 units...
The current aggregate demand requirements for a firm are shown below for the next six months: Month May June July Aug Sept Oct Demand 270 250 250 250 280 300 The firm always plans to meet all demand. The firm currently has 270 workers capable of producing 270 units in a month (1 unit/worker). The workforce can be increased (at a cost of $700 per worker) or decreased (at a cost of $1,400 per worker). Inventory holding cost is $175...
Check The current aggregate demand requirements for a firm are shown below for the next six months: Month May June July Aug Sept Oct 230 Demand 210 210 210 240 260 Click here for the Excel Data File The firm always plans to meet all demand. The firm currently has 230 workers capable of producing 230 units in a month (1 unit/worker). The workforce can be increased (at a cost of $500 per worker) or decreased (at a cost of...
Check my wa will have 400 mowers in inventory at the beginning of the month and desires to maintain at least that number at the end of each month. Assume hiring and layoff/firing, if necessary, occur at the beginning of the quarter. Below is other critical data: Production cost per unit = $230 Inventory carrying cost per month per unit = $50 (based on ending month inventory) Hiring cost per worker = $420 Firing cost per worker = $540 Beginning...
The current aggregate demand requirements for a firm are shown below for the next six months: Month May June July Aug Sept Oct Demand 230 210 210 210 240 260 PpictureClick here for the Excel Data File ped The firm always plans to meet all demand. The firm currently has 230 workers capable of producing 230 units in a month (1 unit/worker). The workforce can be increased (at a cost of $500 per worker) or decreased (at a cost of...
Problem 13-4 The current aggregate demand requirements for a firm are shown below for the next six months MonthMay June July Aug Sept Oct Demand 260 240 240 240 270 290 The firm always plans to meet all demand. The firm currently has 260 workers capable of producing 260 units in a month (1 unit/worker). The workforce can be increased (at a cost of $650 (at a cost of $1,300 per worker). Inventory holding cost is $150 per unit per...
Togo makes riding lawn mowers and tractors. The company’s expected quarterly demand is given below in the chart. The company will have 300 mowers in inventory at the beginning of the month and desires to maintain at least that number at the end of each month. Below is other critical data: Production cost per unit = $325 Inventory carrying cost per month per unit = $60 (based on ending month inventory) Hiring cost per worker = $450 Firing cost per...
Plan production for the next year. The demand forecast is: spring, 19,500; summer, 9,400; fall, 15,000; winter, 18,800. At the beginning of spring, you have 66 workers and 990 units in inventory. The union contract specifies that you may lay off workers only once a year, at the beginning of summer. Also, you may hire new workers only at the end of summer to begin regular work in the fall. The number of workers laid off at the beginning of...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...