4. Big BOOM Explosives Company produces customized blasting compounds for use in

Question

4. Big BOOM Explosives Company produces customized blasting compounds for use in the mining industry. The two ingredients for these explosives are agent A and agent B. Big Bang just received an order for 1400 pounds of explosive. Agent A costs $5 per pound and agent B costs $6 per pound. The customer's mixture must contain at least 20% agent A and at least 50% agent B. The company wants to provide the least expensive mixture which will satisfy the customers’ requirements.

a) Create an EXCEL spreadsheet of LP model showing attention to both accuracy and presentation

b) Use Analytic Solver Platform to verify graphical solution (c). Explain comparison—anything different?

Create Answer report [use report to answer following questions]

d)Which constraints are binding?

e) Which constraints show slack?

   Create a Sensitivity Report; perform an analysis by answering questions below.

Is the optimal solution degenerate? Explain why or why not.

Is the optimal solution unique? If not, identify an alternate optimal solution for the problem.

What is the highest value the objective function coefficient X1 can assume without changing the optimal solution?

Will the current solution remain optimal if a binding constraint is increased by 5 percent? Identify and analyze the chosen constraint and Explain.

Explanation / Answer

Sensitivity report:

A B Cost in $/pound 5 6 Percentage mix 0.2 0.5 Changing Cells Decision Variables A B Quntity in pounds 1 1 Constraints Total quantity in pounds 2 <= 1400 A 1 >= 280 B 1 >= 700 Obj. Function Total cost in $ 11

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

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