Question: How do you set this up in excel using solver? The answers are highlighted but how do you get that? Spending on advertising Revenue (

How do you set this up in excel using solver? The answers are highlighted but how do you get that? Spending on advertising Revenue (in $ 1000 s) from advertising x minutes on TV, y minutes on radio is of form -A x^2-B y^2+C x y+D x+E y, where A firm is planning to spend $ 75,000 on advertising. It costs $ 3000 per minute to advertise on television and $ 1000 per minute to advertise on radio. If the firm buys X minutes of television advertising and Y minutes of radio advertising, its revenue in thousands of dollars is given by -0.3 x^2-0.4 y^2+0.8 x y+5 x+10 y. How can the firm maximize its revenue?

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!