Question

41. One rather unrealistic assumption in the flight- scheduling model is that a given plane can fly two con- secutive flights

B D E Figure 5.36 Flight Arcs Flight capacity Flight net revenue 25 30 39 24 24 35 29 29 Flight flow 1 1 1 0 1 1 1 1 1 1 1 1

problem 41 of chapter 5 in practical management science 6th edition.
please show me how to apply the constraint on downtime.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

With the network structure as it is, if a plane arrives, say, at WashDC at time 14 and there is a flight out of WashDC at time 14, then there is nothing from preventing the same plane flying both flights. To ensure a 1-hour downtime for any flight, the easiest fix is to increase the arrival times for all flights by an hour. I didn't change these arrival times in the data area to the left, but I changed the flight destinations the range B37:B59. No other changes are required. The optimal solution changes considerably. Now only 11 of the 23 flights are flown.

Flight scheduling model
Input data
Planes owned 4
Fixed cost per plane 15
Overnight cost 5
Flight information
Flight Number Origin Destination Departs Arrives Net Revenue
1357 Boston NY 8 9 25
8322 Boston NY 9.5 10.5 30
5903 Boston WashDC 12.5 14 39
1207 Boston WashDC 13.5 15 24
1671 Boston NY 13.5 14.5 24
5671 Boston WashDC 16 17.5 35
7133 Boston NY 16.5 17.5 29
4166 NY Boston 9.5 11 28
3842 NY Boston 12 13.5 13
1537 NY WashDC 13 14.5 18
9320 NY Boston 14 16 22
3042 NY Boston 16.5 18 28
3752 NY Boston 18 19.5 34
9677 NY WashDC 18 20 39
6212 NY Boston 18.5 20 15
6811 WashDC NY 9 11 12
9195 WashDC NY 12.5 14 28
8350 WashDC NY 13 15 13
9480 WashDC Boston 13.5 15.5 18
7555 WashDC NY 14 15.5 33
9041 WashDC Boston 14 15.5 28
7539 WashDC Boston 14.5 16.5 19
2710 WashDC Boston 16 17.5 15
Network formulation Flow balance constraints
Flight arcs
Flight origin Flight destination Flight net revenue Flight flow Flight capacity Node Net outflow Required
Boston8 NY10 25 1 <= 1 Boston8 0 = 0
Boston9.5 NY11.5 30 1 <= 1 Boston8.5 0 = 0
Boston12.5 WashDC15 39 0 <= 1 Boston9 0 = 0
Boston13.5 WashDC16 24 0 <= 1 Boston9.5 0 = 0
Boston13.5 NY15.5 24 1 <= 1 Boston10 0 = 0
Boston16 WashDC18.5 35 1 <= 1 Boston10.5 0 = 0
Boston16.5 NY18.5 29 1 <= 1 Boston11 0 = 0
NY9.5 Boston12 28 1 <= 1 Boston11.5 0 = 0
NY12 Boston14.5 13 1 <= 1 Boston12 0 = 0
NY13 WashDC15.5 18 1 <= 1 Boston12.5 0 = 0
NY14 Boston17 22 0 <= 1 Boston13 0 = 0
NY16.5 Boston19 28 1 <= 1 Boston13.5 0 = 0
NY18 Boston20.5 34 0 <= 1 Boston14 0 = 0
NY18 WashDC21 39 0 <= 1 Boston14.5 0 = 0
NY18.5 Boston21 15 0 <= 1 Boston15 0 = 0
WashDC9 NY12 12 0 <= 1 Boston15.5 0 = 0
WashDC12.5 NY15 28 0 <= 1 Boston16 0 = 0
WashDC13 NY16 13 0 <= 1 Boston16.5 0 = 0
WashDC13.5 Boston16.5 18 0 <= 1 Boston17 0 = 0
WashDC14 NY16.5 33 0 <= 1 Boston17.5 0 = 0
WashDC14 Boston16.5 28 1 <= 1 Boston18 0 = 0
WashDC14.5 Boston17.5 19 0 <= 1 Boston18.5 0 = 0
WashDC16 Boston18.5 15 1 <= 1 Boston19 0 = 0
Boston19.5 0 = 0
Ground arcs Boston20 0 = 0
Ground origin Ground destination Ground cost Ground flow NY8 0 = 0
Boston8 Boston8.5 0 1 NY8.5 0 = 0
Boston8.5 Boston9 0 1 NY9 0 = 0
Boston9 Boston9.5 0 1 NY9.5 0 = 0
Boston9.5 Boston10 0 0 NY10 0 = 0
Boston10 Boston10.5 0 0 NY10.5 0 = 0
Boston10.5 Boston11 0 0 NY11 0 = 0
Boston11 Boston11.5 0 0 NY11.5 0 = 0
Boston11.5 Boston12 0 0 NY12 0 = 0
Boston12 Boston12.5 0 1 NY12.5 0 = 0
Boston12.5 Boston13 0 1 NY13 0 = 0
Boston13 Boston13.5 0 1 NY13.5 0 = 0
Boston13.5 Boston14 0 0 NY14 0 = 0
Boston14 Boston14.5 0 0 NY14.5 0 = 0
Boston14.5 Boston15 0 1 NY15 0 = 0
Boston15 Boston15.5 0 1 NY15.5 0 = 0
Boston15.5 Boston16 0 1 NY16 0 = 0
Boston16 Boston16.5 0 0 NY16.5 0 = 0
Boston16.5 Boston17 0 0 NY17 0 = 0
Boston17 Boston17.5 0 0 NY17.5 0 = 0
Boston17.5 Boston18 0 0 NY18 0 = 0
Boston18 Boston18.5 0 0 NY18.5 0 = 0
Boston18.5 Boston19 0 1 NY19 0 = 0
Boston19 Boston19.5 0 2 NY19.5 0 = 0
Boston19.5 Boston20 0 2 NY20 0 = 0
NY8 NY8.5 0 1 WashDC8 0 = 0
NY8.5 NY9 0 1 WashDC8.5 0 = 0
NY9 NY9.5 0 1 WashDC9 0 = 0
NY9.5 NY10 0 0 WashDC9.5 0 = 0
NY10 NY10.5 0 1 WashDC10 0 = 0
NY10.5 NY11 0 1 WashDC10.5 0 = 0
NY11 NY11.5 0 1 WashDC11 0 = 0
NY11.5 NY12 0 2 WashDC11.5 0 = 0
NY12 NY12.5 0 1 WashDC12 0 = 0
NY12.5 NY13 0 1 WashDC12.5 0 = 0
NY13 NY13.5 0 0 WashDC13 0 = 0
NY13.5 NY14 0 0 WashDC13.5 0 = 0
NY14 NY14.5 0 0 WashDC14 0 = 0
NY14.5 NY15 0 0 WashDC14.5 0 = 0
NY15 NY15.5 0 0 WashDC15 0 = 0
NY15.5 NY16 0 1 WashDC15.5 0 = 0
NY16 NY16.5 0 1 WashDC16 0 = 0
NY16.5 NY17 0 0 WashDC16.5 0 = 0
NY17 NY17.5 0 0 WashDC17 0 = 0
NY17.5 NY18 0 0 WashDC17.5 0 = 0
NY18 NY18.5 0 0 WashDC18 0 = 0
NY18.5 NY19 0 1 WashDC18.5 0 = 0
NY19 NY19.5 0 1 WashDC19 0 = 0
NY19.5 NY20 0 1 WashDC19.5 0 = 0
WashDC8 WashDC8.5 0 1 WashDC20 0 = 0
WashDC8.5 WashDC9 0 1
WashDC9 WashDC9.5 0 1
WashDC9.5 WashDC10 0 1
WashDC10 WashDC10.5 0 1
WashDC10.5 WashDC11 0 1
WashDC11 WashDC11.5 0 1
WashDC11.5 WashDC12 0 1
WashDC12 WashDC12.5 0 1
WashDC12.5 WashDC13 0 1
WashDC13 WashDC13.5 0 1
WashDC13.5 WashDC14 0 1
WashDC14 WashDC14.5 0 0
WashDC14.5 WashDC15 0 0
WashDC15 WashDC15.5 0 0
WashDC15.5 WashDC16 0 1
WashDC16 WashDC16.5 0 0
WashDC16.5 WashDC17 0 0
WashDC17 WashDC17.5 0 0
WashDC17.5 WashDC18 0 0
WashDC18 WashDC18.5 0 0
WashDC18.5 WashDC19 0 1
WashDC19 WashDC19.5 0 1
WashDC19.5 WashDC20 0 1
Overnight arcs
Overnight origin Overnight destination Fixed cost Overnight cost Overnight flow
Boston20 Boston8 15 0 2
Boston20 NY8 15 5 0
Boston20 WashDC8 15 5 0
NY20 Boston8 15 5 0
NY20 NY8 15 0 1
NY20 WashDC8 15 5 0
WashDC20 Boston8 15 5 0
WashDC20 NY8 15 5 0
WashDC20 WashDC8 15 0 1
Constraint on planes
Number used Number owned
4 <= 4
Monetary values
Net revenues 273
Fixed costs 60
Overnight costs 0
Net profit 213
Flights flown 11
Add a comment
Know the answer?
Add Answer to:
problem 41 of chapter 5 in practical management science 6th edition. please show me how to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Can somone show me how to do the 1st problem? Need to find the LS and...

    Can somone show me how to do the 1st problem? Need to find the LS and SS for the fit and the LH and SH for the hole. Fits are all SHAFT BASIS METRIC but the shaft and hole diameters can not be used right out of the table. This is because the 3mm shaft tolerance does not match. You will need to lookup the "Fit" from the table, and then use the LS (Largest Shaft) and SS (Smallest Shaft)...

  • Please show me how to use R to solve this problem. For data CIR, regress involact on race and int...

    Please show me how to use R to solve this problem. For data CIR, regress involact on race and interpret the coefficient. Test the hypothesis to determine the claim that homeowners in zip codes with high percent minority are being denied insurance at higher rate than other zip codes. What can regression analysis tell you about the insurance companies claim that the discrepancy is due to greater risks in some zip codes?zip race fire theft age volact involact income 60626...

  • This is a MATLAB question need details step by step Class15_voltage.txt 2070.106649    1959.461152 1854.729565 1755.595796...

    This is a MATLAB question need details step by step Class15_voltage.txt 2070.106649    1959.461152 1854.729565 1755.595796 1661.760645 1572.940905 1488.868508 1409.289711 1333.964335 1262.665039 1195.176631 1131.295423 1070.828614 1013.593705 959.4179554 908.137855 859.5986337 813.6537939 770.1646679 729 690.0355497 653.1537172 618.2431883 585.1985985 553.9202148 524.313635 496.2895026 469.7632369 444.6547784 420.8883462 398.3922104 377.0984745 356.9428712 337.8645684 319.8059851 302.7126183 286.5328779 271.2179313 256.721556 243 230.0118499 217.7179057 206.0810628 195.0661995 184.6400716 174.7712117 165.4298342 156.5877456 148.2182595 140.2961154 132.7974035 125.6994915 118.9809571 112.6215228 106.601995 100.9042061 95.5109593 90.4059771 85.57385199 81 76.67061663 72.57263525 68.69368759 65.0220665 61.54669054 58.25707056 55.14327806 52.19591521...

  • Please show me the formulas as well, and not only the answer. Thank you. More information if you ...

    Please show me the formulas as well, and not only the answer. Thank you. More information if you need: G25 0 Statement of Cash Flows For the Year Ended December 31, 20x2 Additional information for 20X2 1. Assumethat all increases and decreases in long term assets, long term liabilities, and common stock are as a result of cash transactions 2. Land costing $46,500 was sold, resulting in again of $6,500. No other Cash Flows from Operating Activities: Net Income Adjustmentsto...

  • Please show how to solve PRETAX COST OF DEBT using the YIELD FORMULA. That is the...

    Please show how to solve PRETAX COST OF DEBT using the YIELD FORMULA. That is the only thing I need. thank you Task 2: Weighted Average Cost of Capital (WACC) 01/01/00 01/21/00 50.000 8.5% 1.000 20 1.040 1 Input 2 Debt 3 Settlement date 4 Maturity date 5 Bonds outstanding 6 Annual coupon rate 7 Face value (5) 8 Coupons per year 0 Years to maturity 10 Bond price ($) 11 Common stock 12 Shares outstanding 13 Beta 14 Share...

  • Please Show all work . Use attached Data and graph to answer questions Titration of Acetic...

    Please Show all work . Use attached Data and graph to answer questions Titration of Acetic Acid: 0. IM 1) Check to make sure that the volume on If it does not read 0.00 mL, adjust it to do so before you proceed any further. your sodium hydroxide buret reads 0.00 mL 2) Use the buret that is located near the acetic acid container to dispense 25.00 mL of acetic acid solution into a clean dry 100 mL beaker. Record...

  • 28, 36, 38, 40, 41 15.1 Graphs and Level Curves 927 (a) Figure 15.18 SECTION 15.1...

    28, 36, 38, 40, 41 15.1 Graphs and Level Curves 927 (a) Figure 15.18 SECTION 15.1 EXERCISES 10. Katie and Zeke are standing on the surface above D(1,0). Katie hikes on the surface above the level curve containing D(1,0) o B(2.1) and Zeke walks cast along the surface to E(2. 0). What can Getting Started y-y dentify the independent 1. A function is defined by and dependent variables. be said about the elevations of Katie and Zeke during their hikes?...

  • please complete all 4 required parts Problem 5-10 (Algo) Solving for unknowns; installment notes (LO5-9) 10...

    please complete all 4 required parts Problem 5-10 (Algo) Solving for unknowns; installment notes (LO5-9) 10 points Lowlife Company defaulted on a $300,000 loan that was due on December 31, 2021. The bank has agreed to allow Lowlife to repay the $300,000 by making a series of equal annual payments beginning on December 31, 2022 (FV of $1. PV of $1. EVA of $1. PVA of $1. EVAD of 51 and PVAD OTS1) (Use appropriate factor(s) from the tables provided.)...

  • Hi, please help me with my homework and please do not answer if you intend to...

    Hi, please help me with my homework and please do not answer if you intend to answers all the questions. Thank you The Central Nervous System, endocrine system B. Figure 1 Use the diagram above to answer the following question 1) Which letter indicates the primary visual cortex, which receives information from neurons in the retina of the eye? A) A B) B C) C D) D E) E Figure 2 Use the diagram above to answer the following questions....

  • Using data from the Southwest case, create a chart that plots the relationship between each airline’s...

    Using data from the Southwest case, create a chart that plots the relationship between each airline’s market share, in terms of revenue or airline seat miles flown, and its profitability for two periods: 1995-2000 and 2001-2005. Does your analysis suggest that market share is correlated with profitability in this industry? If you exclude Southwest Airlines and Jet Blue airlines from the analysis (companies that use “point-to-point” route structure rather than a “hub and spoke” route structure), how well does market...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT