Consider a modified version of the problem covered in Ch 2: Chemical firm David Inc produces A and B (both in tons). The company needs to determine the number of tons of A and B to produce in order to maximize total profit. Assume A and B are sold in 1-ton containers, so the number of tons of A and B to produce must be whole numbers. The mathematical model is given below: Max 35A + 25B Subject To: Material 1.40A +.50B <= 17 Material 2.15B <= 2 Material 3.60A + .35B <= 15 Sales Contract A >= 14 Non-negativity A, B >= 0 AND INTEGER Solve the problem in Excel. What is the optimal solution?

Consider a modified version of the problem covered in Ch 2: Chemical firm David Inc produces A and B (both in tons). The company needs to determine the number of tons of A and B to produce in order to maximize total profit. Assume A and B are sold in 1-ton containers, so the number of tons of A and B to produce must be whole numbers. The mathematical model is given below: Max 35A + 25B Subject To: Material 1.40A +.50B <= 17 Material 2.15B <= 2 Material 3.60A + .35B <= 15 Sales Contract A >= 14 Non-negativity A, B >= 0 AND INTEGER Solve the problem in Excel. What is the optimal solution?

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter2: Systems Of Linear Equations

Section2.4: Applications

Problem 24EQ: Suppose the coal and steel industries form a closed economy. Every $1 produced by the coal industry...

See similar textbooks