+ Reply to Thread
Results 1 to 6 of 6

Budget Variance funct??

  1. #1
    Registered User
    Join Date
    01-31-2007
    Posts
    47

    Budget Variance funct??

    I have operating budget that runs quarterly over 3 yrs. (all in 1 spreadsheet). How can I go about getting the variance to only show spend to-date variance, so I see budget-actual for all quarters to date (e.g. I want the variance to show that we are -200 to date for the 3 quarters passed rather than -47,000 for the entire 3 yr project).

    Thanks in advance for any help!!

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by doowop5000
    I have operating budget that runs quarterly over 3 yrs. (all in 1 spreadsheet). How can I go about getting the variance to only show spend to-date variance, so I see budget-actual for all quarters to date (e.g. I want the variance to show that we are -200 to date for the 3 quarters passed rather than -47,000 for the entire 3 yr project).

    Thanks in advance for any help!!
    you should attach a sample workbook in zip format.

  3. #3
    Registered User
    Join Date
    01-31-2007
    Posts
    47
    Quote Originally Posted by starguy
    you should attach a sample workbook in zip format.
    Hope this works. Cheers!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-31-2007
    Posts
    47
    Quote Originally Posted by doowop5000
    Hope this works. Cheers!
    I'm working on column AB (rightmost) and will probably only have it at subtotal sections (rather than per budget line)

  5. #5
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by doowop5000
    I'm working on column AB (rightmost) and will probably only have it at subtotal sections (rather than per budget line)
    you should make it more clear that what exactly you want in col AB.

  6. #6
    Registered User
    Join Date
    01-31-2007
    Posts
    47
    go about getting the variance to only show spend to-date variance, so I see budget-actual for all quarters to date (e.g. I want the variance to show that we are -200 to date for the 3 quarters passed rather than -47,000 for the entire 3 yr project).

    I want AB to= the sum budgeted - the sum of actual, but only for the quarters that have actually passed.

    Example, if in Q2 still:
    Q1= 1000
    Q1 actual= 500
    Q2= 1000
    Q2 actual= 500
    Q3= 1000
    Q3 Actual=
    Project Variance= (Q1+Q2)-(Q1 actual + Q2 actual) = -1000

    So this would represent project variance to date, rather than total project budgeted - spend to date (which would be -2000 for the above example, even though Q3 wouldn't be relevant yet.

    Possibly a SUMIF if Actual is >0??

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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