The emergency room at a hospital estimates the following requirements for registered nurses (RNs) for the late night shift each week. Nurses work four consecutive days, then have off three days. Sunday Monday Tuesday Wednesday Thursday Friday Saturday 3 4 2 2 3 5 4 Using Optimization, how many RNs are required?

Employees Employees Minimum Schedule to Available Employees Time Period (Day) Start on Day During Day(s) Needed M 4 T 2 W 2 TR 3 F 5 SA 4 SU 3 Total Employees: i

n this table format using excel formulas