Question
Extel Industries produces integrated circuit components for use in the next generation of automobiles. In particular, it can make the AT50 unit that can control
Extel Industries produces integrated circuit components for use in the next generation of automobiles. In particular, it can make the AT50 unit that can control the air temperature in the car, the V35 unit that monitors vibration and makes adjustments accordingly, and the GM30 that regulates the engine so that the car provides maximum efficiency. The unit profits on these units are $84, $112, and $126, respectively. Each of these units uses different quantities of three computer chips (as shown below), which Extel purchases from a Taiwanese distributor.
chips: (the materials)
C101 H122 P043
circuit: (the product) AT50 1 1 1
V35 1 1 2
GM30 1 2 1
Each week Extel receives 350 C101's, 300 H122's, and 400 P043's. Formulate a linear programming model and use excel solver to help Extel decide how many units of each product to produce weekly to maximize profit. (Decision variables, Objective function and constraints.)
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