Question: Instructions: For each problem, please come up with a LP formulation (decision variables, objective function, and constraints) with clearly defined decision variables, an objective function,
Instructions:
- For each problem, please come up with a LP formulation (decision variables, objective function, and constraints) with clearly defined decision variables, an objective function, and constraints.
- Solve each problem by Excel. Make sure to pay attention on the problem representation and layout. You also need to follow the color scheme (data-green, decision variable-blue, objective function-red, formula-black).
Question:
A political organization, Uncommon Result, wants to make a mass mailing to solicit funds. It has identified six audiences which it wishes to reach. There are eight mailing lists which it can purchase in order to get the names of the people in each audience. Each mailing list covers only a portion of the audiences. This coverage is indicated in the table below:
| Mailing List | M.D. | LL.D. | D.D. S. | Business Executive | Brick Layers | Plumbers | Cost |
| 1 | Y | N | N | Y | N | N | $5000 |
| 2 | N | Y | Y | N | N | N | $4000 |
| 3 | N | Y | N | N | N | Y | $6000 |
| 4 | Y | N | N | N | N | Y | $4750 |
| 5 | N | N | N | Y | N | Y | $5500 |
| 6 | N | N | Y | N | N | N | $3000 |
| 7 | N | Y | N | N | Y | N | $5750 |
| 8 | Y | N | N | N | Y | N | $5250 |
A Y indicates that the mailing list contains essentially all the names in the audiences. An N indicates that essentially no names in the audiences are contained in the mailing list. The costs associated with purchasing and processing a mailing list are given in the far right column. No change in total costs is incurred if an audience is contained in the several mailing lists. Which mailing lists should be purchased to minimize the total purchasing cost?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help