Results 1 to 3 of 3

Assistance with understanding the forecast function

Threaded View

  1. #1
    Registered User
    Join Date
    05-01-2008
    Posts
    46

    Assistance with understanding the forecast function

    Please could someone tell me advantages of using Forecast function, and also what you would recommend as the best function in excel for forecasting sales affected by seasonal factors. For example I had 3 years sales where year 2 grew by 30 percent, year 3 grew by 32 percent but the forecast function only grew by 23percent in year 4 (x) why would that be? I am using about 5 products and I smoothed out seasonality by predicting year 4 in Jan, Feb etc

    Looking for the best way of predicting but appreciate not an exact science.

    Thanks
    Last edited by Kolacube; 11-29-2013 at 06:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Forecasting
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-16-2013, 02:34 PM
  2. Excel 2007 : Forecasting
    By donald.bryant in forum Excel General
    Replies: 1
    Last Post: 12-31-2011, 11:54 AM
  3. Forecasting
    By praetorianprefect in forum Excel General
    Replies: 3
    Last Post: 08-06-2011, 12:41 AM
  4. Please help with forecasting
    By danstar25 in forum Excel General
    Replies: 0
    Last Post: 08-26-2009, 01:45 PM
  5. Forecasting
    By november678x in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-10-2006, 05:30 PM

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