Ingevulde oefeningen supply chain management les 12

Dire Wolf Industries Annual Costs by Category
Total Annual Cost $ 5,001,800 $ 1,036,800 Regular Labor Cost
$ - Overtime Labor cost
Avg Cost ($/unit) $ 229.44 $ - Cost of Hiring
$ - Cost of Firing
$ 150,000 Cost of Inventory
$ - Cost of Stockouts
$ - Cost of Materials
$ 3,815,000 Cost of Outsourcing

Inputs:
$ 75 Material cost ($/unit) 160
$ 25 Inventory holding costs ($/unit/month) 10
$ 50 Cost of stockouts ($/unit/month) 500
$ 1,200 Cost for hiring and training new worker 500
$ 3,600 Cost for laying off an employee 0
4 Labor hours required per item produced 0
$ 2,400 Regular worker cost ($/month) 36
$ 25 Overtime cost ($/hour) 30
$ 175 Outsourcing cost ($/item) 36




Employees Overtime
Time Period Inventory (#) Workforce Employees Hired Fired (hrs)
1 500 36 0 0 0
2 500 36 0 0 0
3 500 36 0 0 0
4 500 36 0 0 0
5 500 36 0 0 0
6 500 36 0 0 0
7 500 36 0 0 0
8 500 36 0 0 0
9 500 36 0 0 0
10 500 36 0 0 0
11 500 36 0 0 0
12 500 36 0 0 0

Annual Sum 6,000 432 0 0 0

, Hours worked By employee per month
Max overtime (hours/month/employee)
Starting inventory
Ending inventory (min)
Starting backlog
Allowable ending backlog (max)
Starting workforce
Ending workforce (min)
Ending workforce (max)


Monthly
Internal Outsourced Demand Maximum
Backlogged Production Production Forecast Production
(units) (units) (units) Available (units) (units)
0 0 2,800 3,300 ≥ 2,800 1,440
0 0 2,800 3,300 ≥ 2,800 1,440
0 0 1,000 1,500 ≥ 1,000 1,440
0 0 920 1,420 ≥ 920 1,440
0 0 780 1,280 ≥ 780 1,440
0 0 950 1,450 ≥ 950 1,440
0 0 1,050 1,550 ≥ 1,050 1,440
0 0 1,200 1,700 ≥ 1,200 1,440
0 0 2,000 2,500 ≥ 2,000 1,440
0 0 2,500 3,000 ≥ 2,500 1,440
0 0 3,000 3,500 ≥ 3,000 1,440
0 0 2,800 3,300 ≥ 2,800 1,440

0 0 21,800 21,800