A post office requires sufficient full and part time people to satisfy
A post
office requires sufficient full and part time people to satisfy the
following daily needs for employee hours:
Day
M
T
W
R
F
Sa
Su
Hrs. Needed
136
104
120
152
112
128
88
A full time
employee works 8 hours a day for five straight days. A part time employee works
4 hours a day for five straight days. Full or part time employees can be hired
to begin their five straight days on any day that the post office chooses. Full time employees earn $20/ hour while part
time employees earn $15/hour. A union
agreement limits the number of part time employees to no more than 25% of the
total number of employees. Determine how many full and part time workers should
begin their work on each day of the week to satisfy the manpower requirements
at minimum cost. Ignore lunch and other breaks.
Produce a two
way SolverTable to show the minimum cost as the part time wage varies from
$10/hour to $20/ hour in increments of $5/hour while the full time wage varies
from $15/hour to $25/hour in increments of $5/hour.
The following problem
is a coverage problem like the TV ads problem (Ex 4.1) with the exception
that, unlike TV ads, each mailing list is either purchased or not. There
are no multiple buys. In the same
way that ad buys can be constrained to be integer, they may be constrained
to be binary (0,1). The solver
dialog box for constraints abbreviates binary to “bin”.
A political candidate
wants to make a mass mailing to counteract some nasty remarks made recently by
her opponent. Our candidate has identified five mailing lists that contain
names and addresses of voters she might like to reach. Each list can be
purchased for a price. Partial lists are not for sale. The number of names on each list in each of
four professional categories are listed below along with the desired number of
names to reach in each category and the price of each list. Find the subset of
lists that will give the required coverage at minimum cost.
List
Law
HealthCare
Bus. Execs.
Academe
Price
1
28
4
7
2
$41,000
2
9
29
11
3
$52,000
3
6
3
34
18
$61,000
4
2
4
6
20
$32,000
5
8
9
12
14
43,000
Desired coverage
20
18
22
20
