Results 1 to 1 of 1

Thread: Demand Forecasting

  1. #1
    Oct 2012

    Demand Forecasting


    I'm in the middle of a project, and I'm stuck. It is about demand forecasting, and more specifically Croston's method (a more sophisticated form of exponential smoothing).

    Croston's.xlsx download - 2shared -- the blue button.

    I have a couple of questions (the Excel sheet can be downloaded from the link above; don't worry, no viruses):

    1) How am I supposed to actually FORECAST using Zt when I need to use the demand for the current period /(Yt - Zt-1)/?

    2) In order to see how accurate my forecast is, I use MAD and MSE. Should I use any other measures (besides MAPE as I have a lot of null values)?

    3) Are the results of MAD and MSE good in this specific example?

    4) I obtain best results for MSE and MAD when I use an alpha value of 1. Is this normal and should I do it, or should I stick to 0,1-0,2?

    Thank you for your time and patience
    Last edited by luftkastel; Nov 12th 2012 at 10:24 AM.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Agent Performance and Forecasting Question
    Posted in the Business Math Forum
    Replies: 0
    Last Post: Aug 30th 2012, 03:58 PM
  2. forecasting problem
    Posted in the Advanced Math Topics Forum
    Replies: 1
    Last Post: Jul 29th 2011, 02:23 AM
  3. demand??
    Posted in the Pre-Calculus Forum
    Replies: 0
    Last Post: Dec 14th 2009, 11:09 AM
  4. demand
    Posted in the Calculus Forum
    Replies: 1
    Last Post: Feb 28th 2008, 04:56 PM
  5. Seasonal Index - Statistics(Forecasting)
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: Jun 28th 2006, 04:18 AM

Search Tags

/mathhelpforum @mathhelpforum