Please use Excel Solver and send copy of the spreadsheet The

Please use Excel Solver and send copy of the spreadsheet The Weinberger Electronics Corporation manufactures four highly technical products that it supplies to aerospace firms that hold NASA contracts. Each of the products must pass through the following departments before they are shipped: wiring, drilling, assembly, and inspection. The time requirement in hours for each unit produced and its corresponding profit value are summarized in the following table DEPARTMENT PRODUCT WIRING DRILLING ASSEMBLY INSPECTION UNIT PROFIT ($) XJ201 0.4 0.2 0.5 0.3 12 XM897 0.7 1.2 3.1 1.2 15 TR29 1.5 2.7 1.2 0.5 16 BR788 1.2 3.6 2.7 0.6 11 The production available in each department each month and the minimum montly production requirement to fulfill contracts are as follows: DEPARTMENT CAPACITY HOURS PRODUCT MINIMUM PRODUCTION LEVEL WIRING 21,200 XJ201 260 DRILLING 20,920 XM897 340 ASSEMBLY INSPECTION 30,770 TR29 440 INSPECTION 14,120 BR788 480 The production manager has the responsibility of specifying production levels for each product for the coming month. Help him by formulating (that is, setting up the constraints and objective function) Weinberger\'s problem using LP. What is the optimal solution? Use Excel Solver to solve the problem.

Solution