+ Reply to Thread
Results 1 to 2 of 2

What-if Analysis for multiple months Fuel Spend

  1. #1
    Registered User
    Join Date
    Charlotte, North Carolina
    MS-Off Ver
    Excel 2010

    What-if Analysis for multiple months Fuel Spend


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


    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


    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

    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)
    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


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