SolverTable, excel, business intelligence. Blending Models

SolverTable, excel, business intelligence. Blending Models

1. (Chapter 4 in Edition 4 – Question 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.

2. (Chapter 4 in Edition 4 – Question 24: Chandler) (1) Review Example 4.4 (Blending At Chandler Oil) in Section 4.5 (Blending Models). (2) In the current blending model, a barrel of any input results in a barrel of output. However, in a real blending problem, there can be losses. Suppose a barrel of input results in only a fraction of a barrel of output. Specifically, each barrel of either crude oil used for gasoline results in only 0.95 barrel of gasoline, and each barrel of either crude used for heating oil results in only 0.97 barrel of heating oil. Modify the model to incorporate these losses, and reoptimize.

3. (Chapter 5 in Edition 4 – Question 11: Machine shop) Modify the machine-to-job assignment model under the assumption that only 3 of the 4 jobs must be completed. In other words, one of the 4 jobs does not have to be assigned to any machine. What is the new optimal solution?

4. (Chapter 5 in Edition 4 – Question 20: Transportation at Redbrand) In the original RedBrand problem, suppose the plants cannot ship to each other and the customers cannot ship to each other. Modify the model appropriately and reoptimize. How much does the total cost increase because of these disallowed routes?

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.

Discount Code: CIPD30

Click ORDER NOW..