please solve with excel and take a picture of all formulas and steps in excel...
70.2K
Verified Solution
Link Copied!
Question
Finance
please solve with excel and take a picture of all formulas and steps in excel please.
3) 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 07 demographics and location. These data are shown in the following table: Publisher Group Subscribers/Group Cost/Gro42 / A 460,000 $ 1,560.00 6 B 10 50,000 $ 290.00 C 4 225,000 $ 1,200.00 D 6 24,000 $ 130.00 E 6 1,120,000 $ 2,500.00 F 20 1,700,000 $ 7,000.00 G 10 406,000 $ 1,700.00 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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
please solve with excel and take a picture of all formulas and steps in excel please. 