read the attached problem and build a new model using LP for this problem in a spreadsheet and run the solver program to answer the question.

3% 18 4 Minimum Print Media Required Increase 31 2 4 $2 million Increase in Sales per Unit of Advertising Planning an Advertising Campaign The Profit & Gambit Co. produces cleaning products for home use. This is a highly com- petitive market, and the company continually struggles to increase its small market share, Management has decided to undertake a major new advertising campaign that will focus on the following three key products: A spray prewash stain remover. A liquid laundry detergent. A powder laundry detergent. This campaign will use both television and the print media. A commercial has been developed to run on national television that will feature the liquid detergent. The advertisement for the print media will promote all three products and will include cents-off coupons that consumers can use to purchase the products at reduced prices. The general goal is to increase the sales of each of these products (but especially the liquid detergent) over the next year by a significant percentage over the past year. Specifically, management has set the following goals for the campaign: Sales of the stain remover should increase by at least 3 percent Sales of the liquid detergent should increase by at least 18 percent. Sales of the powder detergent should increase by at least 4 percent. Table shows the estimated increase in sales for each unit of advertising in the respective outlets." (A unit is a standard block of advertising that Profit & Gambit commonly purchases, but other amounts also are allowed.) The reason for -- 1 percent for the powder detergent in the Television column is that the TV commercial featuring the new liquid detergent will take wway some sales from the powder detergent. The bottom row of the table shows the cost per unit of advertising for each of the two outlets Management's objective is to determine how much to advertise in each medium to meet the sales goals at a minimum total cost Television 8 $1 million Stain remover Product Powder detergent Liquid detergent Unit COS The Profit & Gambit Co. . . Management has decided to undertake a major advertising campaign that will focus on the following three key products: A spray prewash stain remover. A liquid laundry detergent. A powder laundry detergent. The campaign will use both television and print media The general goal is to increase sales of these products. Management has set the following goals for the campaign: Sales of the stain remover should increase by at least 3%. Sales of the liquid detergent should increase by at least 18%. Sales of the powder detergent should increase by at least 4%. Question: how much should they advertise in each medium to meet the sales goals at a minimum total cost