The Weinberger Electronics Corporation manufactures four highly technical produc
ID: 3220746 • Letter: T
Question
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:
The production available in each department each month and the minimum monthly production requirement to fulfill contracts are as follows:
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.
Show every single step in excel and if you're not able to insert the file Please take a screenshot of it.
Department product wiring drilling assembly inspection unit profit ($) XJ201 0.6 0.2 0.5 0.6 13 XM897 0.7 1.2 4.8 1.2 15 TR29 1.6 2.7 1.2 0.5 16 BR788 1.2 3.6 2.2 0.8 11Explanation / Answer
Product XJ201 XM897 TR29 BR788 Profit Per Unit 13 15 16 11 Wiring Time 0.6 0.7 1.6 1.2 Drilling Time 0.2 1.2 2.7 3.6 Assembly Time 0.5 4.8 1.2 2.2 Inspection Time 0.6 1.2 0.5 0.8 Time Available Time required Wiring Time 20000 0 Drilling Time 20800 0 Assembly Time 28650 0 Inspection Time 18000 0 Minimum Required XJ201 240 XM897 320 TR29 420 BR788 540 Variables XJ201 XM897 TR29 BR788 Units to Produce 1.29E+10 1.49E+10 1.59E+10 1.09E+10 Objective Function 7.64E+11
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.