Pro 2-41 - Cap 2, [Render, B., Balakrishnan, N. & Stair, R.M. (2013). 3rd ed].

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:

CAPACITY (HOURS) PRODUCT EC221 EC496 NC455 NC791 Wiring 0.5 1.5 1.5 1.0 0.3 1.0 2.0 3.0 Drilling Assembly Inspection 15,000 17,000 10,000 12,000 0.2 4.0 1.0 2.0 0.5 1.0 0.5 0.5 $9 $15 $11 Unit profit Minimum needed $12 100 150 300 400 Formulate this problem and solve it by using Excel. Your solution should honor all constraints and maximize the profit