Cost of Ownership Spreadsheet!

Cost of Ownership Spreadsheet!

This is a discussion on Cost of Ownership Spreadsheet! within the RAM 1500 Diesel General Discussion forums, part of the RAM 1500 EcoDiesel Forum category; It is time for a new truck and i have been trying to justify getting an ecodiesel. I am scared quite frankly having just had ...

Page 1 of 2 12 LastLast
Results 1 to 10 of 13
Like Tree3Likes

Thread: Cost of Ownership Spreadsheet!

  1. #1
    RAM Rookie mr.coon's Avatar
    Join Date
    Aug 2014
    Posts
    7
    Member #
    2050
    Liked
    11 times

    Cost of Ownership Spreadsheet!

    It is time for a new truck and i have been trying to justify getting an ecodiesel. I am scared quite frankly having just had to replace the engine and transmission in my 2009 Ram 1500 with the 4.7 V8. This truck gave me 212,000 trouble free miles. Anyway, i came up with the attached spreadsheet that calculates the cost of owning an ecodiesel vs other trucks. Feel free to check my math and do what you all want with it. The results are quite revealing. Yellow highlighted squares can be changed to whatever you like.

    Cost of Ownership Spreadsheet.zip

  2. #2
    RAM Diamond Member Captainmal's Avatar
    Join Date
    Dec 2013
    Location
    Sundance (Wimauma), Florida
    Posts
    11,602
    Member #
    185
    Vehicle
    '14 Ram 1500 Ecodiesel quad cab 4 x 4
    Liked
    6377 times
    Thought those gass engine things had to change oil like every 5-6,000 miles. Not sure you have valid areas of concern. You figure the twin plugs and hassle of the service on a Hemi? How about paying for the screaming noise of a gas engine verses the sedate pull of a diesel?

    Anyway I took the time to try and figure out what that spreadsheet said. Kept thinking it was going to show the Ecodiesel as more expensive to own and operate. Then read those totals and it is was LESS than the gassers. Nothing but a bunch of brain litter to me as I feel the worse for having tried to figure that out.

    Pretty colors.
    Docmcg likes this.
    If you wrestle with a pig you'll both get dirty and the pig loves it. .

  3. #3
    MAS
    MAS is offline
    RAM Bronze Member MAS's Avatar
    Join Date
    Feb 2016
    Location
    Central Texas
    Posts
    3,377
    Member #
    8120
    Vehicle
    2015 Ram 1500 CC 4x4 3.55's
    Liked
    1368 times
    Looked at it a little. It pretty busy and after most of a day at work it made my eyes hurt to look at it lol

    Does your research shot that the cost of ownership of a pentastar is higher than a hemi? Its a bit confusing without digging really deep into it. I didn't see an allotment for DEF or fuel filter changes.

  4. Remove Advertisements
    Ram1500Diesel.com
    Advertisements
     

  5. #4
    RAM Professional phprof's Avatar
    Join Date
    Jul 2017
    Location
    UP North
    Posts
    558
    Member #
    23562
    Vehicle
    2014 RAM Bighorn
    Liked
    257 times
    It is simple. Only if you are using a vehicle for business purposes such as hauling, delivering, etc., will it make money. All other uses of a vehicle consume money.
    btrotter88 likes this.
    2014 RAM Ecodiesel Bighorn
    2014 Dodge Durango V6 3.6L

  6. #5
    RAM Rookie mr.coon's Avatar
    Join Date
    Aug 2014
    Posts
    7
    Member #
    2050
    Liked
    11 times
    It is an open spreadsheet. You can enter your fuel economy numbers as you wish for any engine. You can also change all of the prices on the sheet to match your area.

    The fuel prices on there are from a station close to my house.

    The oil, filters, and def fluid costs come from AutoZone.

    The sheet automatically adds in the cost of oil, filters, and def fluid for all the miles driven except for the towing specific miles.

    Basically the hemi costs about $5000 more to operate for every 150,000 miles driven not towing.

    Some of the other stuff I put in there I thought would be useful for some folks. One table shows how much your commute to work will cost you for each motor.

    The others can show you how much a trip to the lake or campsite will cost you over time.

    It all makes sense to me because I made it I guess, lol. I can see how it may take some time to digest. I am not an Excel wizard.



    Sent from my SAMSUNG-SM-G890A using Tapatalk

  7. #6
    RAM Rookie mr.coon's Avatar
    Join Date
    Aug 2014
    Posts
    7
    Member #
    2050
    Liked
    11 times
    Quote Originally Posted by MAS View Post
    Looked at it a little. It pretty busy and after most of a day at work it made my eyes hurt to look at it lol

    Does your research shot that the cost of ownership of a pentastar is higher than a hemi? Its a bit confusing without digging really deep into it. I didn't see an allotment for DEF or fuel filter changes.
    Those values are on the left side of the sheet for each engine.

    Sent from my SAMSUNG-SM-G890A using Tapatalk

  8. #7
    RAM Rookie btrotter88's Avatar
    Join Date
    Jun 2015
    Posts
    5
    Member #
    6008
    Liked
    1 times
    Quote Originally Posted by mr.coon View Post
    It is an open spreadsheet. You can enter your fuel economy numbers as you wish for any engine. You can also change all of the prices on the sheet to match your area.

    The fuel prices on there are from a station close to my house.

    The oil, filters, and def fluid costs come from AutoZone.

    The sheet automatically adds in the cost of oil, filters, and def fluid for all the miles driven except for the towing specific miles.

    Basically the hemi costs about $5000 more to operate for every 150,000 miles driven not towing.

    Some of the other stuff I put in there I thought would be useful for some folks. One table shows how much your commute to work will cost you for each motor.

    The others can show you how much a trip to the lake or campsite will cost you over time.

    It all makes sense to me because I made it I guess, lol. I can see how it may take some time to digest. I am not an Excel wizard.



    Sent from my SAMSUNG-SM-G890A using Tapatalk
    I created a similar spreadsheet in 2015 when I purchased(Laramie crew short bed 4x4) and reached virtually the same conclusion on cost of ownership. As much as I wanted the 3.0 I went with the 5.7. As you can see I am still here and still desire the little Eco—one day. I am a long time high mpg diesel fan with my other experience being VW TDI cars.

    I have been happy with my decision and confident I made the correct one cost wise for my driving conditions. I have averaged 15k mi/year as anticipated in my spreadsheet. The biggest deciding factor is my typical drive is 5 miles separated by a fair amount of cool down. I feel this would have been trouble for the emissions systems and thus the engine with the Eco. Yes I would have purchased the GDE tune but still had concerns. The remainder of the miles have been highway by way of various trips so close to 50/50 city/highway. My fairly average is 16 mpg, in-line with expectations. I sitting at roughly 55k miles. I have had zero out of warranty repair cost. I have changed the oil at roughly 10k mi intervals when the EVIC said to. HEMI plugs are still 2/cylinder but change intervals are now 100k mi.

    The HEMI is great fun to drive and the sound is perfect to me. I’ve towed 7000 lb loads and never was left wanting for power/torque and was actually surprised the fuel mileage was not as bad as expected(3.21 rear gear). But this is a rare thing for me and therefore didn’t impact my purchase decision.

    When/if my daily commute changes I will reconsider. I like the sound of the 2020’s for sure!

    BT

  9. #8
    RAM Guru dieseldoya's Avatar
    Join Date
    Oct 2014
    Location
    Ontario Canada
    Posts
    1,177
    Member #
    2815
    Vehicle
    2015 Laramie LTD Crew Cab ED Black of course.
    Liked
    501 times
    Quote Originally Posted by mr.coon View Post
    It is time for a new truck and i have been trying to justify getting an ecodiesel. I am scared quite frankly having just had to replace the engine and transmission in my 2009 Ram 1500 with the 4.7 V8. This truck gave me 212,000 trouble free miles. Anyway, i came up with the attached spreadsheet that calculates the cost of owning an ecodiesel vs other trucks. Feel free to check my math and do what you all want with it. The results are quite revealing. Yellow highlighted squares can be changed to whatever you like.

    Cost of Ownership Spreadsheet.zip
    WOW!
    Yep, lots of entries there and some pretty colours but whew, I need a nap now...
    Are all those entries fuel purchases? For example, you have 11 entries on April 30 for ???
    2015 Laramie ED 1500 Crew 4X4 Loaded. At 42000 kms now
    2003 GMC Duramax 2500 Crew 6.6 litre Diesel 4X4 Loaded
    1993 Chevrolet 1500 2 WD 6.2 litre Diesel Ext Cab Loaded
    1986 GMC 1500 2 WD 6.2 litre Diesel REG CAB Loaded




  10. #9
    RAM Jr Member Bravo2's Avatar
    Join Date
    Nov 2018
    Posts
    45
    Member #
    37896
    Vehicle
    2018 Laramie ED 4x4 CCSB
    Liked
    21 times
    *not downloading random zip file

    But all I compared was cost of 89 Octane vs. Diesel in my area compared to the Hemi vs. Ecodiesel mileage.

    Diesel was cheaper and had way better mileage.

  11. #10
    RAM Professional Dieseldragon's Avatar
    Join Date
    Jun 2018
    Posts
    594
    Member #
    36088
    Liked
    254 times
    Hi: All... The only "Spreadsheet" I take notice of is the one covering my "Mattress". I sleep sound knowing that my EcoD. will pull my Escape 5.0TA with ease. I can still use it to run to the butcher if I run out of steaks.
    Can I find good diesel in NFLD this summer...I sure hope so!!! Don't really care what it costs but how it "Tows".
    Dieseldragon North shore of Lake Erie. Cost of Ownership Spreadsheet!-p1040819.jpg
    lucskoj likes this.

Page 1 of 2 12 LastLast

Sponsored Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •