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?
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Question
3
Transcribed Image Text: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.60OA + .35B <= 15
Sales Contract A >=
14
Non-negativity A, B >= 0 AND INTEGER
Solve the problem in Excel. What is the optimal solution?
A=17.222, B=13.333
A=13.333, B=17.222
Transcribed Image Text:Solve the problem in Excel. What is the optimal solution?
A=17.222, B=13.333
A=13.333, B=17.222
O A=18, B=12
O A=12, B=18
What is the total profit?
930
730
936.111
736
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 4 images
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
