I have a shipment that needs to go to 5 Stops. I am evaluating alternatives of shipping it all together, all seperately or in various groupings, regardless I must cover all stops. Here are my alternatives:

Alt1 TL Consolidation to Destination with All Stops $2,500.00
Alt2 TL to Stop #1 only $700.00
Alt3 TL to Stop #2 only $850.00
Alt4 TL to Stop #3 only $550.00
Alt5 TL to Stop #4 only $1,250.00
Alt6 TL to Destination only $1,000.00
Alt7 TL Consolidation to Destination and Stop #1 $1,500.00
Alt8 TL Consolidation to Destination and Stop #2 $1,200.00
Alt9 TL Consolidation to Destination and Stop #3 $1,400.00
Alt10 TL Consolidation to Destination and Stop #4 $1,100.00
Alt11 TL Consolidation to Destination and Stops #1, #2 $1,350.00
Alt12 TL Consolidation to Destination and Stops #1, #3 $1,600.00
Alt13 TL Consolidation to Destination and Stops #1, #4 $1,850.00
Alt14 TL Consolidation to Destination and Stops #2, #3 $1,850.00
Alt15 TL Consolidation to Destination and Stops #2, #4 $1,250.00
Alt16 TL Consolidation to Destination and Stops #3, #4 $1,650.00
Alt17 TL Consolidation to Destination and Stops #1, #2, #3 $2,200.00
Alt18 TL Consolidation to Destination and Stops #1, #2, #4 $2,000.00
Alt19 TL Consolidation to Destination and Stops #1, #3, #4 $1,875.00
Alt20 TL Consolidation to Destination and Stops #2, #3, #4 $1,900.00


I want to make sure I look at every alternative to determine the lowest cost. I have been writing formulas to add the various alternatives together, but feel like there is a better way to do this.

Here are some examples:
Alt2 + Alt20 =$2600
Alt2 + Alt3 + Alt16 = $3200
Alt3 + Alt19 = $2725

I am either not thinking of a better way to do this with a single set of formulas or there just isn't a better way. Again, the alternatives must consider all stops.

Thanks in advance for any help you can provide.