QUESTION 2 PLEASE

Problem 1 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. 3.5 A 1.7 12 3.6 SE R E LN 3.4 C 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. ts) b. Implement your model in a spreadsheet and solve it. (1 c. What is the optimal solution/decision? Problem 2 A company wants to determine the optimal replacement policy for its photocopier. The company does not keep photocopiers longer than 4 years. The company has estimated the annual costs for photocopiers during each of the 4 years and developed the following network representation of the problem. +0 +0 2 Yr 2 & 3: 50.000 4 Yr 1.26 0007 Yr 2: 25,00 Y 3 28,00 Yr 4 17 000 Yr 1&2 50 00 3 Yr 3 & 4: 40.000 +0 a. Formulate a network model for this problem. ( b. Implement your model in a spreadsheet and solve it. (1 c. What is the optimal replacement policy? 2 Problem 1 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. 3.5 A 1.7 12 3.6 SE R E LN 3.4 C 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. ts) b. Implement your model in a spreadsheet and solve it. (1 c. What is the optimal solution/decision? Problem 2 A company wants to determine the optimal replacement policy for its photocopier. The company does not keep photocopiers longer than 4 years. The company has estimated the annual costs for photocopiers during each of the 4 years and developed the following network representation of the problem. +0 +0 2 Yr 2 & 3: 50.000 4 Yr 1.26 0007 Yr 2: 25,00 Y 3 28,00 Yr 4 17 000 Yr 1&2 50 00 3 Yr 3 & 4: 40.000 +0 a. Formulate a network model for this problem. ( b. Implement your model in a spreadsheet and solve it. (1 c. What is the optimal replacement policy? 2