Assume that the administrators at Shouldice want to minimize inventory requireme
ID: 433496 • Letter: A
Question
Assume that the administrators at Shouldice want to minimize inventory requirements. Calculate the net requirements and planned order releases (planned ordered cleanings) for operating rooms, beds, and medical kits. Assume lot-for-lot lot sizing is used.
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Demand
28
28
29
29
30
0
0
28
30
27
28
27
0
0
Hernia Repair Product Structure
Resource/component
Quantity per Operation
Lead Time (Days)
Quantity On hand
Operating room
1
1
0
Bed
1
1
0
Medical Kit
2
3
10
Hernia Master Schedule
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Quantity
Operating Room requirements
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Gross requirements
Scheduled cleanings
Projected Available Balance
Net requirements
Planned ordered cleanings
Bed requirements
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Gross requirements
Scheduled cleanings
Projected Available Balance
Net requirements
Planned ordered cleanings
Medical Kit requirements
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Gross requirements
Scheduled receipts
Projected Available Balance
Net requirements
Planned order release
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Demand
28
28
29
29
30
0
0
28
30
27
28
27
0
0
Hernia Repair Product Structure
Resource/component
Quantity per Operation
Lead Time (Days)
Quantity On hand
Operating room
1
1
0
Bed
1
1
0
Medical Kit
2
3
10
Hernia Master Schedule
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Quantity
Operating Room requirements
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Gross requirements
Scheduled cleanings
Projected Available Balance
Net requirements
Planned ordered cleanings
Bed requirements
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Gross requirements
Scheduled cleanings
Projected Available Balance
Net requirements
Planned ordered cleanings
Medical Kit requirements
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Day of Week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Gross requirements
Scheduled receipts
Projected Available Balance
Net requirements
Planned order release
Explanation / Answer
Hernia Master Schedule Day -2 -1 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Day of week Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Quantity 28 28 29 29 30 0 0 28 30 27 28 27 0 0 Operating room Day -2 -1 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Day of week Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Gross requirements 28 28 29 29 30 0 0 28 30 27 28 27 0 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Projected Avl. Bal. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Net requirement 28 28 29 29 30 0 0 28 30 27 28 27 0 0 Planned order cleaning 28 28 29 29 30 0 0 28 30 27 28 27 0 0 0 Bed Day -2 -1 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Day of week Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Gross requirements 28 28 29 29 30 0 0 28 30 27 28 27 0 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Projected Avl. Bal. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Net requirement 28 28 29 29 30 0 0 28 30 27 28 27 0 0 Planned order cleaning 28 28 29 29 30 0 0 28 30 27 28 27 0 0 0 Medical Kit Day -2 -1 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Day of week Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Gross requirements 56 56 58 58 60 0 0 56 60 54 56 54 0 0 Scheduled receipts 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Projected Avl. Bal. 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Net requirement 46 56 58 58 60 0 0 56 60 54 56 54 0 0 Planned order cleaning 46 56 58 58 60 0 0 56 60 54 56 54 0 0 0 0 0