I am working on a homework assignment from the Practical Management Science book

Question

I am working on a homework assignment from the Practical Management Science book 4th additional by Winston / Albright. The problem is on page 144 and is problem #4. It reads like this:

Problem 4: General Flakes

(1) Review Example 4.1 (Purchasing Television Ads) in Section 4.2 (Advertising Models).

(2) Suppose that General Flakes decides that it should not place any more than 10 ads on any given show. Modify the (original) advertising model appropriately to incorporate this constraint, and then reoptimize (with integer constraints on the numbers of ads). Finally, run SolverTable to see how sensitive the optimal solution is to the maximum number of ads per show allowed. You can decide on a reasonable range for the sensitivity analysis.

The solution offered on Chegg.com says that the minimum total cost given that we will not place more tha 10 advertisements on any show and that the number of advertisements must be an integer value is $1,884.00.

My question is this, I cannot for the life of me recreate this solution, the answer I get is $1,890.00. What am I doing wrong?

I would gladly email you the excel spreadsheet if it would help. I am just at a lose as to what I am doing wrong.

I have Excel 2010 and have set my solver options as you see below.

And my solver parameters look like the image below:

Options All Methods GRG Nonlinear Evolutionary Constraint Precision 0.000001 Use Automatic Scaling Show Iteration Results Solving with Integer Constraints Ignore Integer Constraints Integer Optimality (%): 0 Solving Limits Max Time (Seconds) Iterations: Evolutionary and Integer Constraints: Max Subproblems: Max Feasible Solution Cancel

Explanation / Answer

please make sure that you did not tick the checkbox of stating "Assume linear model"

tick the checkbox of stating "Assume non-negative"

If still it wont work. pls ask me in comment box. i will surely help you....

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.