|
楼主 |
发表于 江苏省 2011-11-30 07:32
|
显示全部楼层
建设雅马哈JYM125-2油耗
序号 日期 加油量(L) 价格(L/元) 金额(元) 行程(KM) 油耗(KM/L) 百公里油耗(L/100KM) 总里程(KM)
1 2006-6-18 10.29 4.86 50 527 51.21477162 1.95256167 527
2 2006-8-5 8.18 4.86 49 536 65.52567237 1.526119403 1063
3 2006-9-3 9.27 4.86 45 580 62.56742179 1.598275862 1643
4 2006-10-8 9.26 4.86 45 532 57.45140389 1.740601504 2175
5 2006-12-2 10.29 4.86 50 515 50.04859086 1.998058252 2690
6 2007-1-13 10.3 4.86 50 486 47.18446602 2.119341564 3176
7 2007-3-2 9.63 4.66 45 451 46.83281412 2.135254989 3627
8 2007-4-11 9.63 4.68 45 461 47.87123572 2.088937093 4088
9 2007-5-3 9.84 4.68 46 470 47.76422764 2.093617021 4558
10 2007-5-26 10.7 4.68 50 516 48.22429907 2.073643411 5074
11 2007-6-18 9.62 4.68 45 531 55.1975052 1.811676083 5605
12 2007-6-28 10.69 4.68 50 503 47.05332086 2.125248509 6108
13 2007-7-17 10.7 4.68 50 508 47.47663551 2.106299213 6616
14 2007-7-29 10.69 4.68 50 583 54.53695042 1.833619211 7199
15 2007-8-18 10.7 4.68 50 516 48.22429907 2.073643411 7715
16 2007-9-14 10.7 4.68 50 568 53.08411215 1.883802817 8283
17 2007-10-9 9.62 4.68 45 513 53.32640333 1.875243665 8796
18 2007-11-20 9.82 5.1 50 442 45.0101833 2.221719457 9238
19 2007-12-23 9.81 5.1 50 462 47.09480122 2.123376623 9700
20 2008-2-15 10.21 5.1 52 446 43.68266405 2.289237668 10146
21 2008-3-23 9.61 5.1 49 400 41.62330905 2.4025 10546
22 2008-4-27 10.39 5.1 53 441 42.44465833 2.35600907 10987
23 2008-5-18 9.41 5.1 48 437 46.43995749 2.153318078 11424
24 2008-6-7 9.8 5.1 50 481 49.08163265 2.037422037 11905
25 2008-7-1 10.5 5.97 60 455 43.33333333 2.307692308 12360
2008-8-25 9.21 5.97 55 389 42.23669924 2.367609254 12749
平均 258.87 4.933076923 1282 12749 49.40505263 2.049801084
总油耗 12749/258.87=49.248 (km/l) 百公里总油耗 258.87/12749*100=2.030 (l/100km)
总成本 1282/12749=0.1005 (元/公里)
五羊本田WH125-B
序号 日期 加油量(L) 价格(L/元) 金额(元) 行程(KM) 油耗(KM/L) 百公里油耗(L/100KM) 总里程(KM)
0 2008-9-11 5.02 5.97 30 1293
1 2008-10-4 8.55 5.85 50 333 38.94736842 2.567567568 1626
2 2008-10-19 9.4 5.85 55 380 40.42553191 2.473684211 2006
3 2008-11-1 8.35 5.99 50 376 45.02994012 2.220744681 2382
4 2008-11-22 11.8 5.99 70 440 37.28813559 2.681818182 2822
5 2008-12-7 8.42 5.94 50 293 34.79809976 2.873720137 3115
6 2008-12-26 8.65 4.97 43 286 33.06358382 3.024475524 3401
7 2009-1-18 7.82 4.86 38 244 31.20204604 3.204918033 3645
8 2009-1-31 7.61 4.86 37 298 39.15900131 2.553691275 3943
9 2009-2-14 5.14 4.86 25 169 32.87937743 3.041420118 4112
10 2009-3-14 7.94 4.91 39 276 34.76070529 2.876811594 4388
11 2009-4-3 8.44 5.09 43 301 35.66350711 2.803986711 4689
12 2009-4-7 4.72 5.09 24 202 42.79661017 2.336633663 4891
13 2009-4-8 7.27 5.09 37 265 36.45116919 2.743396226 5156
14 2009-4-13 6.68 5.09 34 276 41.31736527 2.420289855 5432
15 2009-4-19 7.57 5.14 39 282 37.25231176 2.684397163 5714
16 2009-5-2 4.86 5.14 25 187 38.47736626 2.598930481 5901
17 2009-5-17 11.65 5.14 60 478 41.03004292 2.437238494 6379
18 2009-6-11 9.07 5.51 50 440 48.51157663 2.061363636 6819
19 2009-7-5 8.86 5.98 53 301 33.97291196 2.943521595 7120
20 2009-7-8 9.52 5.78 55 406 42.64705882 2.344827586 7526
21 2009-7-17 10.03 5.98 60 403 40.17946162 2.488833747 7929
22 2009-8-15 10 5.8 58 414 41.4 2.415458937 8343
23 2009-9-4 9.11 6.04 55 382 41.93194292 2.384816754 8725
24 2009-9-20 9.65 6.04 58 399 41.34715026 2.418546366 9124
25 2009-10-5 10.83 5.54 60 455 42.01292705 2.38021978 9579
26 2009-10-21 12.5 5.84 73 475 38 2.631578947 10054
27 2009-11-3 10.27 5.84 60 415 40.40895813 2.474698795 10469
28 2009-11-20 10.93 6.22 68 410 37.51143641 2.665853659 10879
29 2009-12-11 11.9 6.22 74 448 37.64705882 2.65625 11327
30 2009-12-30 10.77 6.22 67 417 38.71866295 2.582733813 11744
31 2010-1-17 10.93 6.22 68 418 38.24336688 2.614832536 12162
32 2010-1-31 10.45 6.22 65 424 40.57416268 2.464622642 12586
33 2010-2-19 11.7 6.27 71 426 36.41025641 2.746478873 13012
34 2010-3-8 10.37 6.27 65 418 40.30858245 2.480861244 13430
35 2010-3-31 10.37 6.27 65 422 40.69431051 2.457345972 13852
36 2010-4-17 9.8 6.53 64 402 41.02040816 2.437810945 14254
37 2010-5-1 10.26 6.53 67 459 44.73684211 2.235294118 14713
38 2010-5-15 10.72 6.53 70 449 41.88432836 2.38752784 15162
39 2010-5-30 10.41 6.53 68 450 43.22766571 2.313333333 15612
40 2010-6-15 10.57 6.34 67 438 41.43803217 2.413242009 16050
41 2010-6-60 10.41 6.34 66 428 41.11431316 2.432242991 16478
42 2010-7-11 9.78 6.34 62 420 42.94478528 2.328571429 16898
43 2010-7-25 9.64 6.34 61 430 44.60580913 2.241860465 17328
44 2010-8-9 9.46 6.34 60 447 47.25158562 2.116331096 17775
45 2010-8-19 11.36 6.34 72 449 39.52464789 2.530066815 18224
46 2010-8-28 9.47 6.34 60 445 46.9904963 2.128089888 18669
47 2010-9-21 12.15 6.34 77 451 37.11934156 2.694013304 19120
48 2010-10-3 10.25 6.34 65 433 42.24390244 2.367205543 19553
49 2010-10-18 10.9 6.7 73 427 39.17431193 2.552693208 19980
50 2010-11-7 10.72 6.53 70 480 44.7761194 2.233333333 20460
51 2010-11-28 10.87 6.53 71 503 46.27414903 2.161033797 20963
52 2010-12-26 12.56 6.77 85 572 45.54140127 2.195804196 21535
53 2011-1-15 11.37 6.77 77 493 43.35971856 2.306288032 22028
54 2011-2-2 9.6 6.77 65 459 47.8125 2.091503268 22487
55 2011-2-26 12.62 7.05 89 542 42.94770206 2.328413284 23029
56 2011-3-25 11.63 7.05 82 585 50.30094583 1.988034188 23614
57 2011-4-15 13.42 7.45 100 575 42.84649776 2.333913043 24189
58 2011-5-3 11.81 7.45 88 543 45.97798476 2.174953959 24732
59 2011-5-22 12.48 7.45 93 548 43.91025641 2.277372263 25280
60 2011-6-16 11.41 7.45 85 540 47.32690622 2.112962963 25820
61 2011-7-5 10.74 7.45 80 504 46.9273743 2.130952381 26324
62 2011-7-22 13.15 7.45 98 554 42.12927757 2.373646209 26878
63 2011-8-9 13.46 7.45 100 555 41.2332838 2.425225225 27433
64 2011-8-24 12.08 7.45 90 531 43.95695364 2.274952919 27964
65 2011-9-20 10.74 7.45 80 531 49.44134078 2.02259887 28495
66 2011-10-21 13.89 7.21 100 532 38.30093593 2.610902256 29027
67 2011-11-19 10.96 7.21 79 536 48.90510949 2.044776119 29563
合计/平均 680.82 6.222985075 4308 28270 41.28816289 2.44808236
1293
29563
总油耗 29563/680.82=43.42 (km/l) 百公里总油耗 680.82/29563*100=2.30 (l/100km)
总成本 4308/29563=0.1457(元/公里) |
|