Please use the spreadsheet for the following question: Assume that the administr
ID: 432951 • Letter: P
Question
Please use the spreadsheet for the following 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 29 27 27 26 28 26 29 30 27 27 27 27 26 30 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 releaseExplanation / 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