How do I solve this problem in excel? I started working on it, but I'm a bit stuck. Please show me how to do it, your help is greatly appreciated. Thumbs up guaranteed for best answer :)

The Slick Copy Advertising Company employs linear programming in allocating its clients' resources among various advertising medias. One particular client is particularly interested in the advertising reach-ing an audience having the following characteristics. Female, aged 25-35, married College graduate Family income > $70,000 Own home Slick Copy has isolated four possible advertising vehicles, with characteristics shown in the table. Additionally, the client has specified that the relative importance of the reader traits should be weighted as shown. The client has $100,000 to spend at this point in time. Formulate the linear programming model to maximize the effective exposure level. Women's magazine Weight Radio TelevisionNewspaper 65% 42% Characteristic Female age 25-35 Married (%) College Graduate (%) Family Income >$70,000 (%) Own home (%) 90% 30% 55% 20% 25% 38% 6% 10% 21% 5% 27% 1396 30% 23% Cost per advertisement ($) $1,000 $1,500 250,000 750,000 105 $3,500 1,500,000 $500 800,000 Potential Audience Size Minimum Number of advertisements required 15 The Slick Copy Advertising Company employs linear programming in allocating its clients' resources among various advertising medias. One particular client is particularly interested in the advertising reach-ing an audience having the following characteristics. Female, aged 25-35, married College graduate Family income > $70,000 Own home Slick Copy has isolated four possible advertising vehicles, with characteristics shown in the table. Additionally, the client has specified that the relative importance of the reader traits should be weighted as shown. The client has $100,000 to spend at this point in time. Formulate the linear programming model to maximize the effective exposure level. Women's magazine Weight Radio TelevisionNewspaper 65% 42% Characteristic Female age 25-35 Married (%) College Graduate (%) Family Income >$70,000 (%) Own home (%) 90% 30% 55% 20% 25% 38% 6% 10% 21% 5% 27% 1396 30% 23% Cost per advertisement ($) $1,000 $1,500 250,000 750,000 105 $3,500 1,500,000 $500 800,000 Potential Audience Size Minimum Number of advertisements required 15