Q 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.)

(hint: you should realize this is exactly the same as the jewelry example.)