Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve this nonlinear programing problem and show answer in Excel spreadsheet? with? formulas? A B C D E G H K M N P

image text in transcribed

Please solve this nonlinear programing problem and show answer in Excel spreadsheet? with? formulas?

image text in transcribed
A B C D E G H K M N P Q R S 13.7-7. Jim Matthews, Vice President for Marketing of the J. R. Formulate a nonlinear programming model and solve it. What should be the optimal levels of campaigns 1 and 2? What is the best profit you can obtain? Nickel Company, is planning advertising campaigns for two unre- lated products. These two campaigns need to use some of the same resources. Therefore, Jim knows that his decisions on the levels of the two campaigns need to be made jointly after considering these resource constraints. In particular, letting x, and x2 denote the lev- els of campaigns 1 and 2, respectively, these constraints are 4x, + x2 5 20 and x1 + 4x2 - 20. In facing these decisions, Jim is well aware that there is a point of diminishing returns when raising the level of an advertising cam- paign too far. At that point, the cost of additional advertising be- comes larger than the increase in net revenue (excluding advertis- ing costs) generated by the advertising. After careful analysis, he and his staff estimate that the net profit from the first product (in- cluding advertising costs) when conducting the first campaign at level x, would be 3x1 - (x1 - 1) in millions of dollars. The cor- responding estimate for the second product is 3x2 - (x2 - 2)2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

More Books

Students also viewed these Mathematics questions

Question

What are management assertions about financial information?

Answered: 1 week ago