This is a case study question. You need to solve ths by using Microsoft Excel.

As there is a lot of demand for Shouldice's particular offering, Shouldice administrators are interested in expanding their capacity to allow more patients inside, but are worried about quality problems. They want to maintain the same experience for the patients, a typical procedure described in the below chart. They are considering two main approaches: improve physical plant capacity (beds, surgery resources) or expand work schedule (they currently operate from Sunday to Friday with the Saturday off). For each option: - Calculate the optimal schedule - What is the annual throughput (\# patients) that can be treated)? - What is the capacity utilization? - What is the annual cost? - What is the annual profit? Each admitted patients brings in about $2,100 in revenues. Total annual cost of the hospital is currently around $12m ( $8.5 for hospital operations and $3.5 for clinic operations). We know that a 50% expansion in bed capacity by adding a new plant is about $4m. Feel free to make assumptions about the costs of your proposed expansion options (and clearly annotate them and briefly argue for their validity)