This spreadsheet formulates the linear program we discussed in class for computing capacity when cycle-time equals 4 days. Suppose Shouldice is considering a further reduction in cycle-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

excel file has below data

Solver Schedule
FT=4
	Sun	Mon	Tues	Wed	Thurs	Fri	Sat		Total	Avg
# Admittances	23	23	29	29	25	0	0		129		>=137
# Departures	29	25	0	0	23	23	29		129
# Surgeries	0	23	29	29	0	25	0	<=	37	106
# Beds occupied overnight	48	46	75	104	106	83	54	<=	103	73.7	(78.29 if Throughput=137)
# Reg. beds required	25	23	46	75	81	83	54	<=	89