Results 1 to 3 of 3

Forecasting for price

Threaded View

  1. #1
    Registered User
    Join Date
    09-04-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Forecasting for price

    I am doing price forecasting analysis.
    The problem that I faced:

    When I compare the forecast price and the actual price, I realize that the forecast price for the month is showed months after in the actual price instead of its current month.
    For example:
    The forecast price for Jan is RM4.50 and the actual price is RM3.90. Yet, the forecast price in Jan is actually get more nearer to the actual price in November which is 2 moths forward.

    I need to move the trend forward instead of backward.

    The attachment file can show a better understanding on what i referring to.
    Appreciate on all the helps.
    Attached Files Attached Files
    Last edited by feixiiin; 09-05-2012 at 07:42 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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