Posted by: syanjali April 21, 2009
excel genius
Login in to Rate this Post:     0       ?        










































































































































































































































Gas Station Per Gallon  Distance (miles) Cost of
Operating


Joe’s     1.90 6.5 $44.53


Bill’s   1.70 8 $42.03


Ed’s   1.92 11 $49.45


Sue’s     1.66 9 $42.24


Sally’s    1.56 17 $48.26


Martha’s   1.75 7.2 $42.23


Frank’s     2.00 2 $42.01


Tom’s    1.38 18 $55.96
















Assumption:
In weekend you going to fill in gas and coming home.


Therefore
the operation is to and fro and gas filled in is assumed there is one gallon
of gas.
How much
galllon is added, assumption is there is 1 gallon of gas and will go upto 15
miles.
To
go to Tom's Gas station, fill in gas at Sally's station atlest one gallon to
avoid towing cost. 
Suggested
to go to Frank's Gas Station.











Gas Station Per Gallon  Distance (miles) Cost of Operating

Joe’s     1.90 6.5 $42.07


Bill’s   1.70 8 $38.91


Ed’s   1.92 11 $45.31


Sue’s     1.66 9 $38.70


Sally’s    1.56 17 $41.47


Martha’s   1.75 7.2 $39.44


Frank’s     2.00 2 $41.27


Tom’s    1.38 18 $41.92









Assumptions:
Working days filling gas on the way to work.



It is
cheaper to fill in Sue's gas station.




Read Full Discussion Thread for this article