1. 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.

2. Solve each problem by Excel. Make sure to pay attention on the problem representation and layout. You also need to follow the color scheme of this class (data-green, decision variable-blue, objective function-red, formula-black).

3. Please submit two files. All LP formulations should be in a Word or PDF file. All Excel solutions should be in one Excel file, with each problem on a separate sheet, clearly labeled. You do not need to include the sensitivity sheet.

Problem 5. 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 M.D. LL.D. D.D. S. Business Brick Plumbers Cost List Executive Layers $5000 $4000 $6000 $4750 14 5 16 17 zzzzz $5500 N N N Y N N ly N N Y IN N N N IN Y $3000 N $5750 $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