+ Reply to Thread
Results 1 to 3 of 3

Inventory forecasting

  1. #1
    Registered User
    Join Date
    10-17-2014
    Location
    Birmingham, England
    MS-Off Ver
    7
    Posts
    2

    Question Inventory forecasting

    Hello

    Im a new poster, a non techy and a fairly basic level Excel user who is trying to learn more! I'm needing to produce a stock forecast and I want to learn how to use the Excel "Forecast" function. I'm using historical monthly demand figures, but I also want to be able to create an uplifted forecast for particular months to allow a seasonal winter adjustment. Is anyone able to help me by explaining more simply the best way of using this function (Im finding the Excel help terminology quite complicated at my level). Or does anyone have a simple example they would be willing to share with me to show me how?
    Many thanks for any help - I would be very grateful!

    Cheers

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Inventory forecasting

    http://www.exceluser.com/excel_dashb...lity-sales.htm

    http://people.duke.edu/~rnau/411outbd.htm

    http://www.youtube.com/watch?v=uWvSnJ6rbsc


    Google is your friend.

    Google Seasonal Forecasting Excel Example possibly?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    10-17-2014
    Location
    Birmingham, England
    MS-Off Ver
    7
    Posts
    2

    Smile Re: Inventory forecasting

    Wow - thanks so much for these - really appreciate the pointer - I will work through and have a go.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Want to set Week End Inventory #s to load in Opening Inventory
    By tkeat1692 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2013, 08:58 PM
  2. [SOLVED] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 AM
  3. Inventory Forecasting
    By ashkolnad in forum Excel General
    Replies: 0
    Last Post: 06-12-2012, 06:39 AM
  4. Forecasting and Inventory
    By jjenkins79 in forum Excel General
    Replies: 0
    Last Post: 05-18-2012, 10:20 AM
  5. Excel 2007 : Inventory and Forecasting Help - Min/Max
    By tippytoe in forum Excel General
    Replies: 2
    Last Post: 05-10-2012, 10:03 AM

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