Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve on excel, please and please do not copy other answers The Royal Seas Company runs a three-night cruise to the Caribbean from Port Canaveral.

image text in transcribedsolve on excel, please and please do not copy other answers

The Royal Seas Company runs a three-night cruise to the Caribbean from Port Canaveral. The company wants to run TV ads promoting its cruises to high-income men, high-income women, and retirees. The company has decided to consider airing ads during prime-time, afternoon soap operas, and during the evening news. The number of exposures (in millions) expected to be generated by each type of ad in each of the company's target audiences is summarized in the following table: Prime Time Soap Operas Evening News 6 6 High-income men High-income women Retirees 3 4 3 4. 4. 7 3 Ads during prime-time, the afternoon soaps, and the news hour cost $120,000, $85,000, and $100,000, respectively. Royal Seas wants to achieve the following goals: . . Goal 1: Spend approximately $900,000 on TV advertising. Goal 2: Generate approximately 45 million exposures among high-income men. Goal 3: Generate approximately 60 million exposures among high-income women. Goal 4: Generate approximately 50 million exposures among retirees. Formulate a GP model for this problem. Assume overachievement of the first goal is equally as undesirable as underachievement of the remaining goals on a percentage deviation basis. . Implement your model in a spreadsheet and solve it. What is the optimal solution

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To solve this problem using a Goal Programming GP model in Excel follow these steps Step 1 Define De... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance For Non-Finance People

Authors: Sandeep Goel

2nd Edition

0367185083, 9780367185084

More Books

Students also viewed these Accounting questions

Question

=+1. Who is responsible for CSRfirms or their stakeholders? Why?

Answered: 1 week ago