in excel

Problem 1 There are four websites GGC can advertise on-MSN, Yahoo, Facebook, and Atlanta Chronicle. The cost and reach of the each ad on these websites are given below: Website Reach Cost MSN 10000 $300 Yahoo 12000 $4000 Facebook 10000 S2000 Atlanta Chronicle 5000 $1000 GGC wants to reach 500000 potential students through these websites while keeping the cost to the minimum. GGC wants to have at least 10 ads on each website and not more than 20 ads on Facebook. Using Linear programming find out an advertising strategy for GGC. Radiant Transportation company provides three types of boats -Boat A Boat B, and Boat C. Each Boat A can carry 15 passengers, 10 vehicles, and 40 tons of goods. Each Boat B can carry 15 passengers, 30 vehicles, and 30 tons of goods. Each Boat C can carry 12 passengers, 13 vehicles, and 35 tons of goods. You are planning to hire boats from Radiant as you have to ship 200 passengers, 200 vehicles, and 200 tons of Goods. If each Boat A costs $2000, each Boat B costs $3000, and each Boat C costs $1200 then how many of each one you should hire to minimize cost while you ship the required number of passengers, vehicles, and goods. Keep in mind the following: * At least 2 of each type of boat need to be hired. There are only 10 of each type of boat available. The number of Boat A hired cannot be more than 50% of the total hired boats