Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please solve with excel and take a picture of all

please solve with excel and take a picture of all formulas and steps in excel...

70.2K

Verified Solution

Question

Finance

imageplease 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!
Become a Member

Other questions asked by students

Geometry
1.2K views

Suppose you want to draw a quadrilateral whose sides measure 6 cm, 4 cm, 2...

Biology
1.2K views

Compare calcium chloride transformation, electroporation and transfection. State the benefits and drawbacks of each method and describe...

Physics
1.2K views

In the absence of electric field possible path of free electrons inside a conductor between...

Geometry
1.2K views

1 point C CE B E D ED Circle B as shown above has two...

Accounting
1.2K views

Fill in the blank cells Do not enter dollar signs or commas in the input...

Accounting
1.2K views

Question 4 Entries for Stock Dividends Vienna Corporation has 36,000 shares of $80...

Accounting
1.2K views

Points 9 Submitting an external tool Attempts 1 US Hemp System Announcements ES Problem 17-01A...

Accounting
1.2K views

Question 15 1 points SAVE ANSWER Peter operates a tyre retail business as a sole...

Accounting
1.2K views

Q1:which term listed below describes costs incurred when the company fails to detect poor quality...

Accounting
1.2K views

Q1: At the most recent balance sheet date, how much debt does Netflix have to...

Accounting
1.2K views

Perit Industries has $140,000 to invest. The company is trying to decide between two alternative...

Finance
1.2K views

Cherry Corporation ile ilgili aadaki bilgiler gz nne alndnda, ltfen finansal bilgileri takip eden talep...