Results 1 to 5 of 5

Help with forecasting budget vs actuals

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2023
    Location
    London
    MS-Off Ver
    Mac 16.79.1
    Posts
    3

    Help with forecasting budget vs actuals

    Hi all.

    I’d really appreciate a little bit of help if possible, please, as I'm stuck!

    See my example spreadsheet attached.

    I’m doing a yearly product sales forecast where for each month of the year I have a budget set and then an actual total achieved.

    I’d like to populate the small simple table cells on row 28 so that I can create a chart, but for each month state if it should calculate the budget total or the actual Toal (both shown in row 27 against each month) - I hope that make sense.

    So you can see April to November I’d like to use Actual totals, but for December to March use the Budget totals.

    Is there a way to do this please?

    I then have a second question - is it possible that the cells in row 27 automatically change based on the month we’re in. So November and all before will show Actual, but December onwards will show Budget. When 1st December then starts, the cell for December changes from Budget to Actual.

    Many thanks, really appreciate the help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Budget vs Actuals pivot table with granular details
    By Anatreneur in forum Excel General
    Replies: 1
    Last Post: 11-06-2023, 10:05 AM
  2. show actuals AND comparison to budget
    By ammartino44 in forum Excel General
    Replies: 3
    Last Post: 06-24-2015, 02:05 PM
  3. analysis of budget versus actuals
    By connect1 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-22-2014, 03:40 PM
  4. Comparing Actuals V Budget
    By Clarice in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-29-2014, 03:22 AM
  5. Replies: 3
    Last Post: 04-22-2014, 09:13 AM
  6. goal seeker or solver for forecasting vs. actuals
    By amartino44 in forum Excel General
    Replies: 3
    Last Post: 02-12-2013, 04:09 PM
  7. Dashboard budget vs actuals (green, yellow or red)
    By ChrisNor in forum Excel General
    Replies: 8
    Last Post: 12-10-2011, 06:01 AM

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