Question: 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

 Please solve this nonlinear programing problem and show answer in Excel

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

spreadsheet? with? formulas? A B C D E G H K M

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

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 Mathematics Questions!