Q&H Company advertises on soap operas and football games. Each soap opera ad costs $50,000,...

50.1K

Verified Solution

Question

Accounting

Q&H Company advertises on soap operas and football games. Each soap opera ad costs $50,000, and each football game ad costs $100,000.

Giving all figures in millions of viewers, if S soap opera ads are bought, they will be seen by 5 men and 20 women.

If F football ads are bought, they will be seen by 17 men and 7 women.

Q&H wants at least 40 million men and at least 60 million women to see its ads. Formulate an NLP that will minimize Q&Hs cost of reaching sufficient viewers.

I WANT THE SOLUTION IN EXCEL HOW TO WRITE in excel?????

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