Results 1 to 4 of 4

Thread: Best Way to Forecast with this Data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2017
    Location
    PA
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Best Way to Forecast with this Data

    Hi -

    I need help determining the best way to forecast for the following year end forecast value.

    The 'Xs' represent the data I have available to me to leverage. Ideas??? Thanks!!!

    Months: 1 2 3 4 5 6 7 8 9 10 11 12 Total
    2018 x x x x *FORECAST*
    2017 x x x x x x x x x x x x x
    2016 x x x x x x x x x x x x x
    2015 x x x x x x x x x x x x x

  2. #2
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,258
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Best Way to Forecast with this Data - HELP!

    Maybe this link on forecasting will help.
    With you only showing X for data its hard to give any ideas - is there a trend, is the data seasonal, are the past years representative of this year, etc?

    http://highered.mheducation.com/site...01_ch03qxd.pdf

  3. #3
    New Member
    Join Date
    Dec 2017
    Location
    PA
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Best Way to Forecast with this Data - HELP!

    Hi AhoyNC -

    The past years would be representative of this year, but with a greater weight on the most recent months/years.

    Regarding trend, there should be some.

    The above table would be for one Expense Account. I have this table x 100 Expense Accounts. So I'm trying forecast for each account, which would then supply my TOTAL forecast of all accounts.

  4. #4
    New Member
    Join Date
    May 2017
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Best Way to Forecast with this Data - HELP!

    I am guessing you have the data in monthly numbers, right, and want the results in monthly as well? This is a good tool for forecasting, but it breaks it out into weekly and daily numbers so probably wouldn't work for you???

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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