When configuring Solver, please keep the following instructions in mind:

File Preview :tive variable is the Payroll for the Week

The objective variable needs to be minimized

The changing variable cells are the Number of Lifeguards on Each Schedule $($Schedules A$-$G$)$

The Number of Lifeguards on Each Schedule must be greater than or equal to zero

The Number of Lifeguards on Each Schedule must be an Integer

For each day of the week, the Schedule Total must be greater than or equal to the Actual Demand for that day

Use GRG Non$-$Linear as the Solving Method

Once Solver is configured, please run it first for a holiday week $($a Y in B$14).$ Generate an Answer Report and name that worksheet Answer Report Holiday Week. Part of the answer report should look like Figure I$-8$ below:

$14$

Objective Cell $($Min$)$

$15$

$\backslash$table$[[$Cell$,$Name,Original value,Final Value$],[$$B$$17,$Payroll for the Week

Beachtown Lifeguard Scheduling

Your Name Here: Elizabeth

Changing Variable Cells $($Decision Variables$)$

Number of Lifeguards on Each Schedule

Schedule A $($Days off: Sun, Mon$)$

Schedule B $($Days off: Mon, Tue$)$

Schedule C $($Days off: Tue, Wed$)$

Schedule D $($Days off: Wed, Thu$)$

Schedule E $($Days off: Thur, Fri$)$

Schedule F $($Days off: Fri, Sat$)$

Schedule G $($Days off: Sat, Sun$)$

$2.$ User Input

Holiday This Week? $[$Y$]$es$,[$N$]$o

$3.$ Main Results

Payroll for the Week $($Objective$)$

Total Number of Lifeguards Scheduled this Week

$4.$ Constants

Lifeguard Schedules $($Days off$)$

A $($Sunday$,$ Monday$)$

B $($Monday$,$ Tuesday$)$

C $($Tuesday$,$ Wednesday$)$

D $($Wednesday$,$ Thursday$)$

E $($Thursday$,$ Friday$)$

$F($Friday$,$ Saturday$)$

G $($Saturday$,$ Sunday$)$

$\backslash$table$[[$B$]]$

C

D

G

E

$F$

H

A

When configuring Solver, please keep the following instructions in mind:

File Preview :tive variable is the Payroll for the Week

The objective variable needs to be minimized

The changing variable cells are the Number of Lifeguards on Each Schedule $($Schedules A$-$G$)$

The Number of Lifeguards on Each Schedule must be greater than or equal to zero

The Number of Lifeguards on Each Schedule must be an Integer

For each day of the week, the Schedule Total must be greater than or equal to the Actual Demand for that day

Use GRG Non$-$Linear as the Solving Method

Once Solver is configured, please run it first for a holiday week $($a Y in B$14).$ Generate an Answer Report and name that worksheet Answer Report Holiday Week. Part of the answer report should look like Figure I$-8$ below:

$15$

$16$

$17$

$17$

$17$

Objective Cell $($Min$)$

$\backslash$table$[[,$Name,Original Value,Final Value$],[$$ B $$17,$Payroll for the Week $($Objective$)Y,$$$1,400,$$$6,400($objective$)Y,$$$1,400,$$$6,400$