Problem Set 5.docx - Problem Set 5 1 The ELC Corporation...

This preview shows page 1 - 2 out of 6 pages.

Problem Set 51.The ELC Corporation manufactures two industrial-sized electrical devices: generators andalternators. Both of these products require wiring and testing during the assembly process. Eachgenerator requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Eachalternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit.There are 260 hours of wiring time and 140 hours of testing time available in the next productionperiod and ELC wants to maximize profit.a)Use the graphical approach to solve this LP problem. Use Excel if you’re a pro, do it by handand paste the image, or paste the graph from question 4a and insert lines.b)Formulate a spreadsheet model and use Solver to solve this LP problem. c)Suppose the company can acquire additional wiring time at a very favorable cost. Should itdo so? Why or why not?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture