Question: How can i solve this using solver in excel? Instructions The Flamingo Grill is an upscale restaurant located in St . Petersburg, Florida. To help

How can i solve this using solver in excel?
Instructions
The Flamingo Grill is an upscale restaurant located in St. Petersburg, Florida. To help plan an advertising campaign for the coming season, Flamingo's management team hired the advertising firm of Haskell & Johnson (HJ). The management team requested HJ's recommendation concerning how the advertising budget should be distributed across television, radio, and online. The budget has been set at $279,000.
In a meeting with Flamingo's management team, HJ consultants provided the following information about the industry exposure effectiveness rating per ad, their estimate of the number of potential new customers reached per ad, and the cost for each ad:
\table[[Advertising Media,\table[[Exposure],[Rating per Ad]],\table[[New Customers],[per Ad]],\table[[Cost],[per Ad]]],[Television,90,4000,$10,000
How can i solve this using solver in excel?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!