On the Shouldice case. This spreadsheet formulates the linear program for computing capacity when flow-time

Question: On the Shouldice case. This spreadsheet formulates the linear program for computing capacity when flow-time equals 4 days. Suppose Shouldice is considering a further reduction in flow-time to 3 days while keeping the Monday-to-Friday surgery schedule. Revise the spreadsheet and solve the resulting linear program to find a new weekly capacity in patients perOn the Shouldice case.
This spreadsheet formulates the linear program for computing capacity when flow-time equals 4 days. Suppose Shouldice is considering a further reduction in flow-time to 3 days while keeping the Monday-to-Friday surgery schedule. Revise the spreadsheet and solve the resulting linear program to find a new weekly capacity in patients per week.
The new weekly capacity is _____ patients per week
FT=4 Sun Mon Tues Wed Thurs Fri Sat Total Avg # Admittances 37 37 15 14 37 0 0 140 # Departures 14 37 0 0 37 37 15 140 # Surgeries 0 37 37 15 14 37 0 # Beds occupied overnight 74 74 89 103 103 66 51 80 # Reg. beds required 37 37 74 89 66 66 51 For the abo…View the full answer