A B C D E F G H I J K
1 Sarah's Car Purchasing Problem
2
3 Operating & Trade-in Value Purchase
4 Maint. Cost at End of Year Price
5 Year 1 $2,000 $8,500 $12,000
6 Year 2 $3,000 $6,500
7 Year 3 $4,500 $4,500
8 Year 4 $6,500 $3,000
9
10
11 From To On Route Cost Nodes Net Flow Supply/Demand
12 Year 0 Year 1 0 $5,500 Year 0 1 = 1
13 Year 0 Year 2 1 $10,500 Year 1 0 = 0
14 Year 0 Year 3 0 $17,000 Year 2 0 = 0
15 Year 0 Year 4 0 $25,000 Year 3 0 = 0
16 Year 1 Year 2 0 $5,500 Year 4 -1 = -1
17 Year 1 Year 3 0 $10,500
18 Year 1 Year 4 0 $17,000
19 Year 2 Year 3 0 $5,500
20 Year 2 Year 4 1 $10,500
21 Year 3 Year 4 0 $5,500
22
23 Total Cost $21,000
L M
1
2
3 Range Name Cells
4 Cost E12:E21
5 From B12:B21
6 NetFlow H12:H16
7 Nodes G12:G16
8 OnRoute D12:D21
9 OpMaint1 C5
10 OpMaint2 C6
11 OpMaint3 C7
12 OpMaint4 C8
13 PurchasePrice E5
14 SupplyDemand J12:J16
15 To C12:C21
16 TotalCost D23
17 TradeIn1 D5
18 TradeIn2 D6
19 TradeIn3 D7
20 TradeIn4 D8
21
22
23