Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management Processes And Supply Chains

Authors: Lee Krajewski, Naresh Malhotra, Larry Ritzman

13th Global Edition

9781292409863

Students also viewed these General Management questions