Week 7 Homework.xlsx - Scheduling Homework Problem An...

Scheduling Homework Problem
FT PT
8-12 4 2 6
9-1 0 0 0
10-2 0 0 0
11-3 0 7 7
12-4 0 0 0
1-5 0 1 1
4 10
8-9 9-10 10-11 11-12 12-1 1-2 2-3 3-4 4-5
8-12 6 6 6 2 4 4 4 4 4
9-1 0 0 0 0 0 0 0 0 0
10-2 0 0 0 0 0 0 0 0 0
11-3 0 0 0 7 7 7 7 0 0
12-4 0 0 0 0 0 0 0 0 0
1-5 0 0 0 0 0 1 1 1 1
Available 6 6 6 9 11 12 12 5 5
>= >= >= >= >= >= >= >= >=
Min required 6 4 4 9 11 9 6 5 5
Total Employees 14
An office supply store is trying to develop of schedule for a typica
business is not seasonal, and each day's volume is similar, so the
every day they are open. The have determined that the number o
hour they are open are as follows: 8a-9a=6; 9a-10a=4; 10a-11a=
2p=9; 2p-3p=6; 3p-4p=5; 4p-5p=5. Their company policy is that f
take a lunch break at 11:00 for one hour. All other employees mu
part-time shifts then are: 8a-12p, 9a-1p, 10a-2p, 11a-3p, 12p-4p,
not want to hire any more people than is necessary. Determine th
shift need to be hired to minimize the number of employees.
A. Set up and solve the problem to minimize the number of emplo
B. Set up and complete a one-way SolverTable. Change the num
from 8a-9a from 6 to 10 to see the impact on the number of FT em
of employees.