Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Bexter Labs produces three products: A, B, and C. Bexter can sell up to 30 units of product A, up to 20 units of product
Bexter Labs produces three products: A, B, and C. Bexter can sell up to 30 units of product A, up to 20 units of product B, and up to 25 units of product C. Each unit of product C uses 2 units of A and 3 units of B and incurs $5 in processing cost. Products A and B are produced from either raw material 1 or raw material 2. It costs $6 to purchase and process 1 unit of raw material 1. Each processed unit of raw material 1 yields 2 units of A and 3 units of B. It costs $3 to purchase and process a unit of raw material 2. Each processed unit of raw material 2 yields a unit of A and 2 units of B. The unit prices for the products are A, $5; B, $4; C, $25. The quality levels of each product are A, 8; B, 7; C, 6. The average levels of the units sold must be at least 7. a) Formulate a linear programming (LP) model to maximize Bexters profit. Note: Clearly define your notation. b) Model the problem in Excel and solve it using Excel Solver. c) Model and solve the same problem using Gurobi, using the Excel file in b) as the input data file. Write your solution to a new sheet of the same Excel file and rename the sheet as Solution_Gurobi. Properly name your column headers and row labels (if any) and make sure that your solution is readable
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started