Use Solver and Scenario Manager to create a summary report for two possible options to determine the optimum schedule for part-time servers. Complete the following: Be sure you are using a computer resource that has Excel and Solver installed. Open the file MDZ_Raleigh_Staff in Excel. Option 1: you want the objective (Cell D16) to have the minimum (Min) number of hours scheduled by changing the number of employees (D4:D9). Set the first constraint to be sure that you have enough (>=) employees (E11:Q11) to meet expected demand (E13:Q13), and set the second constraint to be sure that only whole numbers are used (because you cannot schedule part of a person to work). This first solution should result in an adjustment of the objective from 96.00 to 97.00 hours, but it has 9 employees scheduled at 10:30 in the morning, which are 7 more than needed. Save this first Solver result as a Scenario named First Pass. Option 2: using the same first two constraints set above, add a constraint that allows no more than two employees to be scheduled for the first shift (D4<=2). This second solution should result in an adjustment of the objective to 100.50; the greatest surplus of staff (7 employees) occurs between 2:00 and 3:00.