Question: Please help solver is telling me solution isn't fesable t feasable Solver Parameters Set Objective: $C$17 O Min Value Of: 0 To: Max By Changing

Please help solver is telling me solution isn't fesablePlease help solver is telling me solution isn'tPlease help solver is telling me solution isn'tPlease help solver is telling me solution isn'tt feasable

Solver Parameters Set Objective: $C$17 O Min Value Of: 0 To: Max By Changing Variable Cells: $C$2:$C$14 Subject to the Constraints: $C$2:$C$14 = binary $H$2:$H$9 = $J$2:$J$9 Add Change Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non- smooth. Close Solve Problem 1 25 points total A scheduled flight connecting Seattle (SE) and London (LN) non-stop is about to take off. Based on the weather conditions, the precise route to be taken between SE and LN may vary, and the decision is made right before take-off time. The following network shows the possible routes in consideration. Nodes A, B, C, D, E, and F represent intermediate locations. SE 47 36 E LN It is the wind speed along each route greatly affect the flying time which is proportional to the fuel consumption. Based on current weather reports, the flying times (in hours) for this particular flight are shown next to the routes (arcs). The management team would like to choose a route that minimizes the fuel consumption. a. Formulate an LP model for this problem. (10 points) b. Implement your model in a spreadsheet and solve it. (15 points) c. What is the optimal solution/decision? (5 points) AutoSave OFF AP A2_Problem1_Gonzalez Jose Home Insert Draw Page Layout Formulas Data Review View Analytic Solver Tell me Share 0 Comments 9 Connections Clear Reapply Flash Fill + Data Validation l Group Ungroup 9 Subtotal Analysis Tools Data Analysis 2 Solver Properties Edit Links Stocks Currencies Get External Data Sort Refresh All Geography Filter Text to Columns Advanced Remove Duplicates - Consolidate EN What if Analysis B16 X fx B D E F G H 1 J K L M N 0 P Q R S s T V To On Route Net Flow Supply A 0 1 1 0 0 0 B D D 0 0 0 E D 1 From 2 SE 3 SE 4 SE 5 A 6 6 7 B 8 B 9 B 10 10 C 11 C 14 12 D 13 E 14 f 15 16 17 Nodes SE A B C D E F LN Flying Time 4.6 4.7 4.2 3.5 3.4 3.6 3.2 3.3 3.5 3.4 3.4 3.6 3.8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 E F F 0 0 0 0 E F LN LN LN 0 0 0 Total Flying Time 0 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Sheet1 + Enter + 100%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!