16. The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each alternator 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 production period, and Electrotech wants to maximize profit. a. Formulate an LP model for this problem. b. Sketch the feasible region for this problem. c. Determine the optimal solution to this problem using level curves ElectroTech ElectroTech Corporation Corporation Let X1 = numbers of generators X2 = numbers of alternators Generators Alternators Number to produce 130 0 Profit per Unit $250 $150 2 1 3 2 Resources Required Wiring Testing Total Profit $32,500 LINDO code MAX ST Used 260 130 Available 260 140 250X1 + 150X2 2X1 + 3X2 <= 260 X1 + 2X2 <= 140 END X1, X2 >= 0 Maximize: F4 Maximize: F4 By Changing: C4:D4 By Changing: C4:D4 Subject To: E8:E9<=F8:F9 Subject To: E8:E9<=F8:F9 C4:D4>=0 C4:D4>=0 Microsoft Excel 12.0 Answer Report Worksheet: [HW 3 Excel Spreadsheet.xlsx]Q1 - Pro 2_13 Report Created: 11/5/2012 5:13:41 PM Target Cell (Max) Cell Name $F$4 Number to produce Total Profit Original Value Final Value $0 $32,500 Adjustable Cells Cell Name $C$4 Number to produce Generators $D$4 Number to produce Alternators Original Value Final Value 0 130 0 0 Constraints Cell $E$8 Wiring Used $E$9 Testing Used Name Cell Value Formula Status 260 $E$8<=$F$8 Binding 130 $E$9<=$F$9 Not Binding Slack 0 10 Microsoft Excel 12.0 Sensitivity Report Worksheet: [HW 3 Excel Spreadsheet.xlsx]Q1 - Pro 2_13 Report Created: 11/5/2012 5:13:41 PM Adjustable Cells Cell Name $C$4 Number to produce Generators $D$4 Number to produce Alternators Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 130 0 250 1.000E+030 150 0 -225 150 225 1.000E+030 Constraints Cell $E$8 Wiring Used $E$9 Testing Used Name Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 260 125 260 20 260 130 0 140 1.000E+030 10 Microsoft Excel 12.0 Limits Report Worksheet: [HW 3 Excel Spreadsheet.xlsx]Limits Report 1 Report Created: 11/5/2012 5:13:41 PM Target Cell Name $F$4 Number to produce Total Profit Value $32,500 Adjustable Cell Name $C$4 Number to produce Generators $D$4 Number to produce Alternators Value 130 0 Lower Target Limit Result 0 0 0 32500 Upper Limit 130 0 Target Result 32500 32500