tema 5 Sarah - 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sarah's Car Purchasing Problem Trade-in Value Purchase Maint. Cost at End of Year Price Year 1 $2,000 $8,500 $12,000 Year 2 $3,000 $6,500 Year 3 $4,500 $4,500 Year 4 $6,500 $3,000 From To On Route Cost Nodes Net Flow Supply/Demand Year 0 Year 1 0 $5,500 Year 0 1 = 1 Year 0 Year 2 1 $10,500 Year 1 0 = 0 Year 0 Year 3 0 $17,000 Year 2 0 = 0 Year 0 Year 4 0 $25,000 Year 3 0 = 0 Year 1 Year 2 0 $5,500 Year 4 -1 = -1 Year 1 Year 3 0 $10,500 Year 1 Year 4 0 $17,000 Year 2 Year 3 0 $5,500 Year 2 Year 4 1 $10,500 Year 3 Year 4 0 $5,500 Total Cost $21,000 A B C D E F G H I J K 1 2 3 4 5
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Range Name Cells Cost E12:E21 From B12:B21 NetFlow H12:H16 Nodes G12:G16 OnRoute D12:D21 OpMaint1 C5 OpMaint2 C6 OpMaint3 C7 OpMaint4 C8 PurchasePrice E5 SupplyDemand J12:J16 To C12:C21 TotalCost D23 TradeIn1 D5 TradeIn2 D6 TradeIn3 D7 TradeIn4 D8 L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23...
View Full Document

This note was uploaded on 08/13/2011 for the course OPRES 206 taught by Professor Nea during the Spring '11 term at De La Salle University.

Page1 / 2

tema 5 Sarah - 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online