Professor Taylor’s Primary Gasoline Demand Raw Data

Students needing a project, you must complete the remaining calculations for each of the 39 months, then the accumulated monthly total, then do the calculations to fill in the blanks between each month.

 (This will substitute for the data collection for the project )

2012 Toyota Prius

Purchased car:  May 1, 2012 Odometer 00004  full tank

Month One: May 2012

1st fill-up: Hess-Orange Park 5/10/12
9.2 gallons  $3.629 $33.25  odometer: 00389.4  42.7 mpg

2nd fillup: Gate-Dunn  5/17/12
8.6_gallons  $3.49   $29.80  odometer: 772

3rd fillup-Shell @ Emerson  5/24/12
9.3 gallons  $3.48  $32.25  Odometer  1142  371 miles  39.9 mpg

Gate-Dunn 5/29/12 fillup
2.66 gall0ons  $3.389  $9.01 Odometer 1248 

Gate-Dunn  5/31/12 fillup
3.25gallons  ( $3.389) Odometer 1401   $11.00

BP-Ocala Return from Tampa  6/3/12 (not fil-up)
3.0 gallons  $3.47  Odometer 1820 $10.00

Marathon-Ocala 6/3/12 (fillup)
6.7 gallons  $3.239  $21.75  Odometer  1829

Total  42.7 gallons 1829 miles = 42.7 mpg

Total Spent $147.06 to date or 8.04 cents/mile

 

Crown Vic equivalence for 1st month:

1829 miles divided by 20 =  91.49 gallons @ 3.44/gallon = $314.40

Saved $167.33 in month of May

 

Month Two: June 2012

Gate-Dunn 6/4/12
3.3 gallons $3.319   $10.90  1974 miles

Gate-Dunn  6/11/12
8.4 gallons $3.269  $27.51  2350 miles

Shell-Hodges  6/17/12
8.2 gallons $3.289  $27.00  2714

Gate-Dunn 6/26/12
8.9 gallons  $3.179  $28.25  3107.5 miles

Gate-Dunn 7/2/12
3.2   Gallons  $3.139  $10.00

Shell-Hodges 7/3/12
8.55 gallons  $3.159  $27.01  3626.5   Total Spent Month 2: $_______

June Total:  _____ gallons ________ miles = ______ mpg

2 Month Total  ____ gallons 3625.5 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Three: July 2012

Gate-Dunn 7/10/12
8.13 gallons  $3.229 $26.25  3980.6

Shell-Hodges 7/17/12 lost ticket found 3/14
9.051 Gallons $3.259  $29.50  4364

Kangaroo Express  7/24/12
8.81 gallons  $3.349  $29.58 4755

Gate-Dunn 7/26/12
3.07 gallons  $3.339  $10.25  4867

Gate-Dunn  8/6/12
5.45 gallons $3.489  $19.02  5113f  Total Spent Month 3: $_______

July Total:  _____ gallons ________ miles = ______ mpg

3 Month Total  ____ gallons 5113 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Four: August 2012

Shell-Emerson 8/12/12
8.891 gallons $3.599  $32.00 5500f

Shell-Hodges 8/25/12
8.205 gallons $3.639 $29.86 5844

Shell/Gate ?????   6210 Lost Ticket Total Spent Month 4: $_______

August Total:  _____ gallons ________ miles = ______ mpg

4 Month Total  ____ gallons xxxx miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Five: September 2012

Kangaroo 9/08/12
2.668 gallons  $3.749  $10.00  6583 not fill

Shell-Emerson  9/12/12
9.059 gallons  $3.699 $33.51 6688f

Gate-Dunn 9/17/12
3.973 Gallons $3.779 $15.01  7087 nf

Gate-Dunn 9/18/12
8.528 gallons $3.729 $31.80  7218 f

Gate-Dunn 9/21/12
6.157 gallons $3.679  $22.65 7478f

Kangaroo 9/29/12
4.415 gallons $3.629 $16.02

Sam’s Club 9/29/12
5.271 gallons $3.559 $18.81  7899 f
Total Spent Month 5: $_______

August Total:  _____ gallons ________ miles = ______ mpg

5 Month Total  ____ gallons 7899 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Six: October 2012

Shell-Hodges  10/06/12
8.254 gallons  $3.579  $29.54  8267 fr

Gate-Dunn 10/15/12
9.072 Gallons  $3.639 $33.01 8657f

Shell-Emerson 10/19/12
7.288 gallons  $3.499  $25.50 8977f

Shell-Emerson  10/24/12
7.590 gallons $3.399  $25.80 9311f

Hess-University  10/29/12
4.818 gallons  $3.229  $15.56 9515f Total Spent Month 6: $_______

October Total:  _____ gallons ________ miles = ______ mpg

6 Month Total  ____ gallons 9515 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Seven: November 2012

10,000 mile Service Coggan Toyota
11/2 Oil Change Pennzoil 0-20W Synthetic Tires Rotated

Sam’s Club 11/09/12
9.382 gallons $3.199 $30.01 10,244 f

Shell-Hodges 11/15/12
7.869 gallons $3.179 $25.02  10,590f

11/26/12 Gate-Dunn No f
4.590 gallons  $3.269  $15.00  10,982 nf

11/29/12  Gate-Dunn f
9.401 gallons  $3.249  $30.54  11208f Total Spent Month 7: $_______

NovemberTotal:  _____ gallons ________ miles = ______ mpg

7 Month  Total  ____ gallons 11208 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Eight December 2012

12/3/12 Gate Dunn F
7.725 gallons $3.239  $25.02  11541

12/06/12 Shell-University F
6.601 gallons  $3.249  $21.45  11840f

12/11/12 Gate Dunn f
9.415 gallons  $3.189  $30.02   12261

12/15/12 Sam’s Club-Beach f
6.921 gallons  $3.109  $21.52  12,572

12/30/12 Shell-West Palm Cruise almost F
9.013 gallons  $3.439  $31.00 12,951

12/31/12 Sam’s Club Beach f
8.933 gallons  $3.359  $30.01  13,282 Total Spent Month 8: $_______

December Total:  _____ gallons ________ miles = ______ mpg

8 Month  Total  ____ gallons 13282 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Nine January 2013

1/17/13 Sam’s Club Beach f
7.570 gallons  $3.369  $25.50  13,633

1/20/13  7-11 Pasco f (Trip to Jenny-return)
8.586 gallons  $3.319  $28.50  14,012

1/21/13 Shell-Emerson f (return from trip)
5.663 gallons  $3.399  $19.25 debit 14,247

1/31/13  Shell-Kent not fillup
4.289 gallons  $3.499  $15.01  14,667

2/3/13  Shell-Kent fill-up (AMX Miki)
8.294 gallons  $3.499  $29.02  14,943 Total Spent Month 9: $_______

January Total:  _____ gallons ________ miles = ______ mpg

9 Month  Total  ____ gallons 14943 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Ten February 2013

2/13/13 Shell-University  Almost fill
4.445 gallons  $3.599  $16.00 15,079

2/17/13  Shell-Wesley Chapel no fill
3.004 gallons $3.789 $11.38 Debit xxxxx

2/19/13 Shell-US19 Palm harbor no fill
4.052 gallons $3.779 $15.31 Debit xxxxx

2/19/13 Shell-US19 Palm Harbor fillup
6.516 gallons  $3.779  $24.25 Amx 16,xxx

2/22/13  BJ-Atlantic fillup
8.489 gallons $3.769 $32.00 16,054 debit fill-up

3/2/13Shell-Atlantic fill-up
7.146 gallons $3.779 $27.00 16,390 debit Total Spent Month 10: $_______

February Total:  _____ gallons ________ miles = ______ mpg

10 Month  Total  ____ gallons 16390 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Eleven March 2013

3/8/13 Shell-University fill-up
5.573 gallons $3.699 $20.61 16,634 debit

3/11/13 Hess StRd54 fill-up
5.745 gallons $3.489 $20.04  16,894 debit

3/15/13 Gate-Dunn fill-up
8.773 gallons $3.649 $32.01 17292 debit

3/26/13 Shell-Costco Not fillup
5.510 gallons  $3.629 $20.00 XXXXXX(not recorded)

3/28/13 Shell-Hodges Fillup
5.621 gallons $3.559 $20.01 17,797 debit Total Spent Month 11: $_______

 

MarchTotal:  _____ gallons ________ miles = ______ mpg

11 Month  Total  ____ gallons 17797 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month Twelve April 2013

4/10/13 Gateway-Dunn Fill-up
9.414 gallons $3.479 $32,75 18232 debit

4/18/13 Gateway-Dunn fill-up
7.861 gallons  $3.409  $26.80  18583 Credit? Com First

4/23/13 Gateway-Dunn fill-up
6.365 gallons $3.379  $21.51  18,836 Debit-Com 1st

4/28/13 Shell Daytona Beach –not fill-up
5.208 gallons $3.459  $18.81 xxxxx Debit-Com 1st

4/29/13 Gateway-Dunn  fill-up Debit Com 1st
5.092 gallons $3.339  $17.00 19,315 Com First Debit

Total Spent Month 12: $_______

April Total:  _____ gallons ________ miles = ______ mpg

12 Month  Total  ____ gallons _______ miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 13 May 2013

5/10/13 Gate-Bowden Rd- Fill-up
9.042 gallons $3.319 $30.01 19702  debit

5/15/13 Gate-Dunn-Fill-Up
8.854 gallons $3.389  $ 30.01  20,098 debit

5/18/13 Coggin—20,000 mile maintaince

5/22/13 Kangaroo-Miki Drives Home from School & Hospital
4.355 gallons  $3.459  $15.00 no fill up

5/29/13 Gate-Dunn Fill-up
8.748 Gallons  $3.429  $30.00  20, 658 Total Spent Month 13: $_______

May Total:  _____ gallons ________ miles = ______ mpg

13 Month  Total  ____ gallons 20658 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 14 June 2013

6/05/13 Gate-Dunn Fill-up debit
7.483 Gallons  $3.489  $25.51  21,017

6/13/13 Kangaroo-San Pablo –not fillup debit
2.833 Gallons $3.529  $10.00  21473?

6/13/13 Shell-Atlantic –fillup debit
6.907 Gallons $3.499  $24.03  after 21919

Missing ticket

6/30/13  Shell-Atlantic Amx fillup
8.457 Gallons  $3.429  $29.00  22322 Total Spent Month 14: $_______

Jone Total:  _____ gallons ________ miles = ______ mpg

14 Month  Total  ____ gallons _______ miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 15 July 2013

7/5/13 Gate-Dunn  fillup AMX
6.132 Gallons  $3.359  $20.60  22582

7/14/13  Shell-Gate Parkway not fill-up
5.628 Gallons  $3.559  $20.03 xxxx

7/25/13  Gate-Dunn not-fillup
2.674 Gallons 3.839 $10.00 xxxx

7/25/13 Sam’s Club-Beach fill-up
7.879 Gallons  $3.579  $28.20 (23237???)

7/28/13 Shell-Emerson not fill-up
5.408 Gallons $3.699  $20.00 23,630

8/01/13 Gate-Dunn fill-up
9.499 Gallons $3.579  $34.00  23,982

8/02/13 Shell- Cloud Fl Turnpike fill-up
6.271 Gallons $3.509  $22.00   24,243 Total Spent Month 15: $_______

July Total:  _____ gallons ________ miles = ______ mpg

15 Month Total  ____ gallons 24243 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 16 August 2013

8/10/13 Shell-Okeechobee Fl Turnpike not-fill-up
2.719 Gallons $3.679 $10.00 (24578)

8/10/13 Shell-St Cloud Fl Turnpike fill-up
7.014 Gallons  $3.479 $24.40 24623

8/12/13 Shell-University  fill-up
6.375 Gallons  $3.529  $22.50  24910

8/23/13 Gate-Dunn fillup
8.094 Gallons $3.459  $28.00  25264

8/31/13  BJ-Atlantic fill-up
9.230 Gallons $3.499  $32.30  25687 Total Spent Month 16: $_______

August Total:  _____ gallons ________ miles = ______ mpg

16 Month  Total  ____ gallons 25687 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 17 September 2013

9/3/13 Coggin Toyota
25,000 mile service

9/5/13 BJ-Atlantic fill-up
9.344 Gallons $3.489  $32.60 26107

9/13/13 Sam’s Club-Beach-fill-up
8.374 gallons $3.379  $28.30  26463

Missing receipt
8.900 gallons  $3.269 $xxxxx  ???? estimate 27,000

Total Spent Month 17: $_______


September Total:  _____ gallons ________ miles = ______ mpg

17 Month Total  ____ gallons _______ miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 18 October 2013

10/04/13 Gate-Dunn-fill-up
8.798 gallons $3.239  $28.50  27540

10/14/13 Kangaroo-San Pablo fill-up
9.158 gallons $3.199  $29.30  27942

10/22/13 Gate-Dunn-Fill-up
8.996 gallons $3.279  $29.50  28341

10/26/13 Sunoco-Hwy27-Fill-up (Orlando Trip 10/25-10/27)
8.742 Gallons $3.169  $27.70 28742

10/27/13 Shell-Sanford-Fill-up (Return from Orlando)
4.490 Gallons $3.159  $14.50 28938

10/31/13 Gate-Dunn  fill-up
9.002 Gallons $3.199  $28.80 29337 Total Spent Month 18: $_______

October Total:  _____ gallons ________ miles = ______ mpg

18 Month  Total  ____ gallons 29227 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 19 November 2013

11/06/13 Shell-University
8.257 gallons $3.149 $26.00 29732

11/14/13 Shell-Hodges Not Fill-up
3.164 Gallons  $3.159  $10.00 xxx

11/19/13 Gate-Dunn Not Fill-up
4.986 Gallons $3.229 $16.10  30,262

11/23/13 Shell-Hodges Fillup
9.360 Gallons  $3.319 $31.25  30,488

11/29/13 30,000 k service  Coggins-Avenues

12/3/13 Gate-Dunn Fillup
9.685 gallons  $3.379  $32.56  30,908 Total Spent Month 19: $_______

November Total:  _____ gallons ________ miles = ______ mpg

19 Month  Total  ____ gallons 30908 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 20 December 2013

12/10/13 Shell-Hodges Fill-up
9.322 Gallons  $3.379  $31.50  31,326

Trip to Ft Lauderdale 12/10/13

12/23/13 BJ Fuel-Melbourne (Must Ezstnate)
____Gallons $_____  $20.25 Amx

1/2/14 Shell Oil Hodges Jax
6.001 gallons $3.359  $20.16   32258 Total Spent Month 20: $_______

December Total:  _____ gallons ________ miles = ______ mpg

20 Month  Total  ____ gallons 32258 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 21 January 2014

1/3/14 Shell Oil – Jax (Hodges)
4.763 gallons    $3.359   $16.00 Amx

Trip to Ft Lauderdale

1/11/14 BJ Fuel Ft Lauderdale Amx
8.212 gallons   $3.379  $27.75 32676

1/14/14 Shell-Hodges fill-up
9.688 Gallons $3.319  $32.15 Amx xxx

MB Amx card

Trip to Tampa

1/18/14 Citgo Holiday AMX-no receipt
6.14 gallons  $3.269  $20.06 not fill

1/20/14 Sunoco Busnell  Fillup
5.114 gallons $3.229  $16.51  33562

1/27/14 Gate Dunn  Amx mb
6.100 gallons  $3.279  $20.00  ???

2/5/14 Gate – Dunn Amx-MB
9.004 Gallons $3.249  $29.25   34692 Total Spent Month 21: $_______

December Total:  _____ gallons ________ miles = ______ mpg

21 Month  Total  ____ gallons 34692 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 22 February 2014

2/9/14 Shell Hodges Amx-MB
8.537 Gallons  $3.239  $27.65  34974

2/15/14  Shell Hodges AMX JT
7.187 Gallons  $3.319  $23.85  35530

Trip to Holiday

2/17/14 7-11 Holiday amx JT
5.456 Gallons  $3.299   $18.00

2/18/14 Shell-Hodges Amx-JT
5.047 Gallons    $3.329    $16.80   35775

35,000 Service Toyota - Coggin

 2/26/14 Gate-Dunn Amx
4.143 gallons  $3.379  $14.00 (no fill 36,200 estimate)
Total Spent Month 22: $_______

February Total:  _____ gallons ________ miles = ______ mpg

22 Month  Total  ____ gallons _______ miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 23 March 2014

3/02/14 Shell-Costco AMX
5.147 gallons  $3.419  $17.60 no fill

3/06/14 Gate-Dunn  Amx –fill
9.346 gallons  $3.349  $31,30  36593

3/17/14 BJ Amx
9.132 gallon $3.449 $31.50  37240

Missing ticket Estimate

3//28/14 Toyota Coggin
Recall service

4/2/14 7-11 Dunn amx-no fill
2.844 gallons $3.529  $10.04  xxxx

4/4/14 Shell-Hodges
9.3 Gallons  $3.499  $33.00 fill  38214
Total Spent Month 23: $_______

March Total:  _____ gallons ________ miles = ______ mpg

23 Month Total  ____ gallons _______ miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 24 April  2014

4/17/14Gate-Dunn
2.587 Gallons  $3.x89  $9.00

4/27/14 Shell Hodges
8.2676 gALLON $3.659 $30.25 xxxx

05/04/14 Shell-Hodges
9.258gallons $3.629  $33.60  40376
Total Spent Month 24: $_______

April Total:  _____ gallons ________ miles = ______ mpg

24 Month Total  ____ gallons 40376 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 25 May 2014

05/19/14 Gate-Dunn
9.440 gallons $3.559  $33.60  40756

05/24/14 Shell-Costco
9.031 Gallons  $3.599  $32.50 41152

5/30/14 Gate Dunn
5.794 gallons $3.539  $20.50 41390
Total Spent Month 25: $_______

May Total:  _____ gallons ________ miles = ______ mpg

25 Month Total  ____ gallons 41390 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 26 June 2014

06/01/14 Shell-Sanford missing ticketAMX
_____gallons  $_____ $19.50 41826 ???Estimate

6/12/14 Gate-Dunn
7.292 Gallons  $3.469  $25.30   42326

06/17/14 Shell-Beach Chris 67.00
   Gallons  $3.999  $     xxxxx

6/17/14  7-11 Dunn
3.479 Gallons  $3.449  $12.00 fill 42501

6/25/14  Gate-Dunn
9.466gallons $3.539  $33.50 42865

6/30/14  7-11 Dunn
7.645 Gallons  $3.499  $26.79 fill 43193
Total Spent Month 26: $_______

June Total:  _____ gallons ________ miles = ______ mpg

26 Month Total  ____ gallons 43193 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 27 July 2014

7/7/14 Gate-Dunn
8.222 gallons  $3.479  $28.60 43532

7/15/14  gate-dunn missing ticket AMX
_____gallons $_____  $32.44  xxxxx

7/19/14  Shell-beach/san pablo
6.804 Gallons  $3.439  $23.40 fill 44226

7/24/14 gate-dunn
9.598 gallons  $3.439  $33.01  44642

07/26/14  BJ-Sarasota Missing Tick3et (AMX)
______Gallons $_____ $31.41 XXXXX

07/31/14 Gate-Dunn
9.529 gallons $3.359  $32.01 45457
Total Spent Month 27: $_______

July Total:  _____ gallons ________ miles = ______ mpg

27 Month Total  ____ gallons 45457 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 28 August 2014

08/02/14 Gate Dunn
4.989 Gallons  $3.359  $16.75 xxxxx

08/07/14 Shell Beach
9.496 Galons  $3.319  $31.52 xxxxx

08/09/14 7-11 Dunn
6.070 Gallons  $3.299  $20.02  XXXXX

08/17/14  Shell-Cocoa
_____ GALLONS $_______ $30.00 46688

08/20/14  Shell Beach
9.557 gallons  $3.259 47080

8/24/14 Shell hodges
9.205 gallons  $3.259  $30.00  47473
Total Spent Month 28: $_______

August Total:  _____ gallons ________ miles = ______ mpg

28 Month Total  ____ gallons 47473 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 29 September 2014

9/2/14 Shell-Beach
9.004 Gallons  $3.289  $29.61  47863

9/8/14 Shell-West University
7.571 Gallons  $3.269  $24.75  48186

9/13/14 Shell-Beach
4.670 gallons  $3.209  $14.99  48775

9/14/14 Shell-Beach
6.420 Gallons  $3.209  $20.60  49009

09/18/14 Shell-Beach
9.672 Gallons  $3.169  $30.65 49412

9/21/14 Shell-Hodges
9.121 Gallons  $3.178  $29.00  49820

9/23/14 Shell-Beach
9.503 Gallons  $3.199  $30.40  50213

9/26/14 Gate-Dunn)
9.000 Gallons  $3.189  $28.70 50593
Total Spent Month 29: $_______

September Total:  _____ gallons ________ miles = ______ mpg

29 Month Total  ____ gallons 50593 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

 

Month 30 October 2014

10/01/14 Kangaroo-San Pablo
8.288 Gallons  $3.209  $26.60 50928

10/04/14 ????
 9.596 Gallons  $3.179  $30.51 51333

10/08/14 Kangaroo-San Pablo
8.001 Gallons  $3.209  $25.68 51680

10/9/14 Shell-Hodges
7.081 gallons  $3.179  $22.51  51999

10/13/14 Kangaroo-San Pablo
5.998 Gallons  $3.119  $18.68 52250

10/20/14 Shell-Gulfass  (No receipt)
8.22 Gallons  $2.999  $24.65 52615

10/24/14 Shell-Atlantic Blvd
9.143 Gallons  $3.019  $27.60 53010

10/31/14 Shell-Beach
7.529 Gallons  $2.869  $21.60  xxxxx

11/01/14 Shell-Beach
4.881 Gallons  $2.869  $14.00  53809
Total Spent Month 30: $_______

October Total:  _____ gallons ________ miles = ______ mpg

30 Month Total  ____ gallons 53809 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 31 November 2014

11/02/14 Shell-Beach
8.911 Gallons  $2.839  $25.30 xxxxx

11/07/14 Shell-Beach
7.144 Gallons  $2.779  $19.85 54xxx

11/09/14 Shell-Beach
5.218 Gallons $2.779  $14.50 54XXX

11/19/14 Shell-Beach
6.985 Gallons  $2.649  $18.50   55356

11/19/14 Shell-Hodges
6.170 Gallons  $2.509  $15.10   55625

11/29/14 Shell-Beach
6.489 Gallons  $2.589  $16.80  xxxxx

11/30/14 Shell-Beach(5094)
4.403 gallons  $2.589  $11.40

12/03/14 Shell-Beach
8.499 Gallons  $2.589  $22.00  56466
Total Spent Month 31: $_______

November Total:  _____ gallons ________ miles = ______ mpg

31 Month Total  ____ gallons 56466 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 32 December 2014

12/07/14  Shell Beach
7.033 gallons  $2.559  $18.00  56XXX

12/10/14 Kangaroo-San Pablo
8.536 gallons $2.489  $21.25  57102

12/14/14 Shell-Beach Leave for Ft Lauderdale
5.660 Gallons  $2.429  $13.75  57329

12/24/14 Texico-West Palm
4.369 Gallons  $2.749  $12.01  not fill xxxxx

12/24/14 Shell-Cocoa Beach
8.111 Gallons  $2.379  $19.30  fill xxxxx

12/27/14 Shell-Beach
6.197 Gallons  $2.259  $14.00  58099
Total Spent Month 32: $_______

December Total:  _____ gallons ________ miles = ______ mpg

32 Month Total  ____ gallons 58099 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 33 January 2015

1/7/15Gate-Dunn
9.781 gallons  $2.229 $21.80 

1/13/15 Gate-Dunn Visa Miki
8.____ gallons  $218.9  $___________ xxxxxx

1/15/15 Shell-Beach Visa John
6.362 gallons  $2.099  $13.35  59140

1/19/15  Shell=Brach SamsAMX
4.586 gallons  $2.039  $9.35 59331

1/24/15 Shell-Emerson
8.419 gallons $1.989 $16.75  59695

1/29/15 Gate-Dunn
9.017 gallons  $1.969 $17.75  60083

2/2/15 Shell-Sam Beach
9.009 gallons $1.959  $17.65  60493
Total Spent Month 33: $_______

January  Total:  _____ gallons ________ miles = ______ mpg

33 Month Total  ____ gallons 60493 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 34 February 2015

2/6/15 Gate-Dunn
9.332 gallons  $2.079$19.48  60912

2/11/15  Kangaroo –Dunn
2.660 Gallons  $2.249  $6.00 xxx

2/11/15 Gate-Dunn
6.833 Gallons $2.199  $15.03  61375

2/18/15 Gate-Dunn
5.374 Gallons  $2.239  $12.83  xxxx

2/22/15 Shell-Beach
8.459 Gallons  2.199  $18.60 Visa

2/25/15  7-11 Dunn
5.345  Gallons  $2.199 $11.75  62136
Total Spent Month 34: $_______

February Total:  _____ gallons ________ miles = ______ mpg

34 Month Total  ____ gallons 62136 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 35 March 2015

3/10/15  7-11 Dunn
4.299 Gallons  $2.329  $10.01 xxx

3/12/15  Gate-Belford Rd
4.242 Gallons $2.359  $10.01  xxx

3/16/15 Sans Club
9.362 Gallons  $2.259  $21.15 VISA Fill

3/24/15  Gate Dunn
9.500 Gallon $2.249 $21.37 63666

3/31/15 Kangaroo SP
9.030 Gallons $2.359 $21.30  64057
Total Spent Month 35: $_______

March Total:  _____ gallons ________ miles = ______ mpg

35 Month Total  ____ gallons 64057 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 36 April 2015

4/4/15 Shell Beach Visa
7.298 Gallons $2.329  $17.00 xxxxx

4/8/15 Kangaroo/SP
6.414 Gallons  $2.279  $14.62 xxxxx

4/14/15 Shell-Beah/SP
8.710 Gallon $2.279  $19.85

4/28/15 Gate Dunn
9.594 Gallons $2.449 $23.50  66518
Total Spent Month 36: $_______

 April Total:  _____ gallons ________ miles = ______ mpg

36 Month Total  ____ gallons 66518 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 37 May 2015

5/5/15 Chevron Dunn-Ran Out Of Gas
4.117 Gallon $2.489 $10.25

5/7/15  Shell Atlantic
5.003 Gallons  $2.599 $13.00

5/13/15 Shell Beach/SP
7.319 Gallons $2.529  $18.51 67207

5/20/15 Kangaroo-Beach/SP cash
7.003 Gallons $2.499  $17.50 cash

5/27/15 Kangaroo San Pablo
8.560 Gallons $2.599  $22.25 xxxx fillup before Rockledge

5/29/15 Shell Beach Debit fillup before Orlando Trip
8.273 Gallons $2.599  $21.50  xxxxx

 

6/3/15  Shell Beach Visa 6767 Drove to Orlando 6/3
8.699 Gallons  $2.759 $24.00  68604
Total Spent Month 37: $_______

 

May Total:  _____ gallons ________ miles = ______ mpg

37 Month Total  ____ gallons 68604 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 38 June 2015

6/3/15 Sams Beach Sams Credit
7.755 Gallons $2.579 $20.00  68917

6/6/15 Shell Beach Debit
9.487 Gallons $2.689  $25.51  69337 Drove to Orlando 6/6

6/14/15 Shell Hodges MC
9.658 Gallons$2.589  $25.00  69722

6/23/15 7/11 Dunn Visa
2.007 Gallons  $2.639  $5.30 no receipt/not fillup

6/25/15 Shell Hodges Visa
9.498 Gallons $2.579 $24.50 70186
Total Spent Month 38: $_______

June Total:  _____ gallons ________ miles = ______ mpg

38 Month Total  ____ gallons 70186 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

 

 

Month 39 July 2015

7/2/15 Shell-Beach
8.177 gallons  $2.569  $21.01  70524

7/6/15  Shell Beach Visa
4.318 gallons  $2.549  $11.01 70690

7/13/15 Shell-Beach VISA – No Ticket
9.204 gallons @ $2.499  $23.00 71052

7/13/15 Shell-Beach VISA
6.333 Gallons $2.449  $15.51 71302 fill

7/25/15 Marathon-San Pablo (Leave for Sarasota) Debit
3.339 Gallons $2.399  $8.01 71xxx fill

7/31/15 Shell-Sarsota-Shell Gift Card
7.247 Gallons $2.559  $18.55 71xxx fill

8/3/15 Shell-Hodges  Shell Gift Card
8.134 Gallons $2.299  $8.70 72133 fill
Total Spent Month 39: $_______

July Total:  _____ gallons ________ miles = ______ mpg

39 Month Total  ____ gallons 72133 miles = _____ mpg

Total Spent $________ to date or _______ cents/mile

 

Month 40 August 2015

8/10/15 Shell-Hodges Gift Card
5.695 Gallons $2.239 $12.75   no fill

8/10/15 Shell-Hodges Visa
1.919 Gallons $2.239 $4.30 fill 72477

8/24/15  Shell Beach/Sp  Visa
4.428 Gallons $2.259  $10.00 no fill

8/26/1 Shell-Hodges Visa
9.585 Gallons $2.139  $20.50  73354 fill

 

Students needing a project, you must set spreadsheet for 39 months as described in the project, then do the projections and calculations described in the project plus do a comparison to my former car 2007 Crown Vic which averaged 20 miles per gallon. complete the remaining calculations of the CO2 levels from new car versus old car.

 

Crown Vic equivalence for 39 month:

72,133 miles divided by 20 =  ________ gallons

@ $____/gallon (average of prices) or (suggest a method)

 Total of $________

Saved $________ in 39 months