Solve using solver on spreadsheet with step by step solution. In the summer, the
ID: 442854 • Letter: S
Question
Solve using solver on spreadsheet with step by step solution.
In the summer, the city of Almond Beach staffs lifeguard stations 10 hours per day, seven days a week. Regulations require that lifeguards work four days a week and be given three consecutive days off. Insurance requirements mandate that Almond Beach provide at least one lifeguard per 8000 average daily attendance on any given day. The table below gives the average daily attendance figures and the minimum number of lifeguards required during the summer months, at Almond Beach Determine a schedule that will employ as few lifeguards as possible.
Day
Average Attendance
Lifeguards Required
Sunday
58,000
8
Monday
42,000
6
Tuesday
35,000
5
Wednesday
25,000
4
Thursday
44,000
6
Friday
51,000
7
Saturday
68,000
9
Day
Average Attendance
Lifeguards Required
Sunday
58,000
8
Monday
42,000
6
Tuesday
35,000
5
Wednesday
25,000
4
Thursday
44,000
6
Friday
51,000
7
Saturday
68,000
9
Explanation / Answer
Maximum life guard required on a particular day=9 (on Saturday)
Also one Life guard=4 Man day
Total no of Man day required=8+6+5+4+6+7+9=45
Minimum no of life guard required= Total no of Man day required/1 life guard effort in a week=45/41=11.25
Since we can’t hire 0.25 lifeguard
Minimum no of life guard required=12
Let “A” denote the day off for a particular life guard and “P” denote the working day of a particular lifeguard.
Lifeguard schedule:
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Life guards required
8
6
5
4
6
7
9
Lifegurad 1
P
A
A
A
P
P
P
Lifegurad 2
P
A
A
A
P
P
P
Lifegurad 3
P
A
A
A
P
P
P
Lifegurad 4
P
A
A
A
P
P
P
Lifegurad 5
P
A
A
A
P
P
P
Lifegurad 6
P
P
A
A
A
P
P
Lifegurad 7
P
P
P
A
A
A
P
Lifegurad 8
P
P
P
A
A
A
P
Lifegurad 9
A
A
A
P
P
P
P
Lifegurad 10
P
P
P
P
A
A
A
Lifegurad 11
P
P
P
P
A
A
A
Lifegurad 12
P
P
P
P
A
A
A
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Life guards required
8
6
5
4
6
7
9
Lifegurad 1
P
A
A
A
P
P
P
Lifegurad 2
P
A
A
A
P
P
P
Lifegurad 3
P
A
A
A
P
P
P
Lifegurad 4
P
A
A
A
P
P
P
Lifegurad 5
P
A
A
A
P
P
P
Lifegurad 6
P
P
A
A
A
P
P
Lifegurad 7
P
P
P
A
A
A
P
Lifegurad 8
P
P
P
A
A
A
P
Lifegurad 9
A
A
A
P
P
P
P
Lifegurad 10
P
P
P
P
A
A
A
Lifegurad 11
P
P
P
P
A
A
A
Lifegurad 12
P
P
P
P
A
A
A