An electronics company produces transistors, resistors, and computer chips. Each transistor requires four units of copper, one unit of zinc, and two units of glass. Each resistor requires three, three, and one units of the three materials, respectively, and each computer chip requires two, one, and three units of these materials, respectively. Putting this information into table form, we get:

Supplies of these materials vary from week to week, so the company needs to determine a different production run each week. For example, one week the total amounts of materials available are 960 units of copper, 510 units of zinc, and 610 units of glass. Set up the system of equation modeling the production run and use Excel and information from this chapter about solving linear algebraic equation in Excel to solve for the number of transistors, resistors, and computer chips to be manufactured thisweek.

Glass Component Zinc Copper 2 Transistors Resistors Compuler chips 3. 2 3