+ Reply to Thread
Results 1 to 2 of 2

What-if Analysis for multiple months Fuel Spend

  1. #1
    Registered User
    Join Date
    02-06-2012
    Location
    Charlotte, North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    3

    What-if Analysis for multiple months Fuel Spend

    Hello!

    I want to create a what if analysis that will calculate fuel spend each month.

    Inputs:

    Fuel Price, which is then converted to a fuel surcharge i.e. $4.00 is a $0.65 cents surcharge
    Routes, number of shipments (Monthly)
    Miles per route (Monthly)

    Math breakdown::

    Routes * Miles per route = Miles driven each month

    Then

    Miles driven each month * fuel surcharge = Fuel Spend

    I would like to have it so, a user can enter a fuel price, routes, and miles per route. Then the output is a fuel spend each month based on what the user inputted.


    Thank you for your ideas

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Re: What-if Analysis for multiple months Fuel Spend

    Is this what you are looking for
    Cell A2: 1 (Routes)
    Cell B2: 10 (Miles)
    Cell C2: 4.00 (Fuel price)
    Cell D2: =0.65 (formula =C2*0.1625) Surcharge
    Cell E2: =6.5 (formula =A2*B2*D2)
    //Ola
    Mark the problem as Solved under the Yellow bar up Top right, under Thread Tools, when you received a solution.
    It saves time, to skip already solved threads.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1