Problem
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:
Formulate this problem and solve it by using Excel. Your solution should honor all constraints and maximize the profit.