In: Operations Management
For a telephone survey, a marketing research group needs to contact at least 100 national private companies, 85 international private companies, 60 national public companies, and 30 international public companies. It costs $1.5 to make a daytime call and (because of higher labor costs) $2.5 to make an evening call. The following Table lists the results. Based on the results of a LP model, what is the most efficient way of completing the survey?
Company |
Percent of |
Percent of |
Responding |
Daytime Calls |
Evening Calls |
national private companies |
10 |
30 |
international private companies |
20 |
30 |
national public companies |
40 |
20 |
international private companies |
20 |
15 |
none | 10 | 5 |
Let the total no. of daytime calls be “x” and total no. of evening calls be “y”. These are the decision variables.
Objective function = Total cost = 1.5x+2.5y. This has to be minimized.
Constraints:
(1) 0.1x+0.3y>=100 (at least 100 national private companies)
(2) 0.2x+0.3y>=85 (85 international private companies)
(3) 0.4x+0.2y>=60 (60 national public companies)
(4) 0.2x+0.15y>=30 (30 international public companies)
(5) x,y>=0 (non negativity).
(6) x,y = integers (as no. of calls cannot be negative)
Solving in excel, using the solver function, we get:
Total no. of daytime calls | 1.00 | |||
Total no. of evening calls | 333.00 | |||
Formula | ||||
Objective function | 834.00 | 1.5x+2.5y | ||
Constraints | ||||
1 | 100.00 | >= | 100.00 | 0.1x+0.3y>=100 |
2 | 100.10 | >= | 85.00 | 0.2x+0.3y>=85 |
3 | 67.00 | >= | 60.00 | 0.4x+0.2y>=60 |
4 | 50.15 | >= | 30.00 | 0.2x+0.15y>=30 |
Thus no. of daytime calls = 1 and no. of nighttime calls = 333.
Minimized cost = $834. All constraints are satisfied.