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 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