41 An electronics corporation manufactures four highly technical products that it supplies to aerospace firms. Each of the products must pass through the following departments before being shipped:

wiring, drilling, assembly, and inspection. The time requirement (in hours) for each unit produced, the available time in each department each month, minimum production levels for each product, and unit profits for each product are summarized in the following table:

PRODUCT EC221 EC496 NC455 NC791 CAPACITY

(hours)

Wiring 0.5 1.5 1.5 1.0 15,000 Drilling 0.3 1.0 2.0 3.0 17,000 Assembly 0.2 4.0 1.0 2.0 10,000 Inspection 0.5 1.0 0.5 0.5 12,000 Unit profit $9 $12 $15 $11 Minimum needed 150 100 300 400 Formulate this problem and solve it by using Excel.

Your solution should honor all constraints and maximize the profit.