Question: Please solve using excel and solver and solver (show all formulas and excel). Thank you :) The Spurling Group is considering using magazine outlets to

Please solve using excel and solver and solver (show all formulas and excel). Thank you :)
The Spurling Group is considering using magazine outlets to advertise their online Web site. The company has identified seven publishers. Each publisher breaks down its subscriber base into a number of groups based on demographics and location. These data are shown in the following table: The company has set a budget of $25,000 for advertising and wants to maximize the number of subscribers exposed to their ads. However, publishers B and D are competitors and only one of these may be chosen. A similar situation exists with publishers C and G. Formulate and solve an integer optimization model to determine which publishers to select and how many groups to purchase for each publisher. The Spurling Group is considering using magazine outlets to advertise their online Web site. The company has identified seven publishers. Each publisher breaks down its subscriber base into a number of groups based on demographics and location. These data are shown in the following table: The company has set a budget of $25,000 for advertising and wants to maximize the number of subscribers exposed to their ads. However, publishers B and D are competitors and only one of these may be chosen. A similar situation exists with publishers C and G. Formulate and solve an integer optimization model to determine which publishers to select and how many groups to purchase for each publisher
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
