+ Reply to Thread
Results 1 to 2 of 2

Need help with a inventory sales prediciting spreadsheet

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Need help with a inventory sales prediciting spreadsheet

    Hi all,

    I'm trying to make a excel program for work. Basically what I want to be able to do is; enter promotional history for an item, specifically the price of the sale item, units sold, temperature during the sale, total sales and number of like items also on promotion. Then I want to run a multiple regression to forecast the sales for the item the next time it goes on promotion. I'd also like to have some charts to track sales of the item.

    I've been able to do this to some degree (the bare basics) however it's not very easy to read or maintain. I really need something that's able to handle 200-400 products, along with at least 12 different historical promotions. What I'd really like to do is something similar to this http://youtu.be/vur4yH3Aoec with the drop down boxes where I can pick the data i.e product, price, temp, forecasted total sales and number of like items on promotion. Then click forecast and it will run the regression for the imputed variables and give me the forecast.

    I would also like an area where I can easily input the recent promotional history, so the forecast can stay up to date.

    Now what I want to know is what I need to learn to be able to make this? What excel functions I need to know to be able to make this. Because i really am lost as to where to begin my learning. I'm reading through a lot of the threads on here along with watching youtube demos but i just want my efforts to be more streamlined and to the point.

    Thanks in advance for any help people and can provide


  2. #2
    Valued Forum Contributor
    Join Date
    Melbourne, Australia
    MS-Off Ver
    Office 2016

    Re: Need help with a inventory sales prediciting spreadsheet

    Please attach a copy of your workbook so we can test solutions using your own data. Remember to remove/replace sensitive info before uploading.
    Trish in Oz
    A problem well defined is a puzzle half solved

    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:

+ 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. Replies: 0
    Last Post: 04-14-2014, 10:06 PM
  2. Replies: 6
    Last Post: 11-26-2013, 11:05 AM
  3. Need help revamping Inventory & Sales spreadsheet
    By lorne17 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-27-2013, 05:53 PM
  4. sales sheet and inventory
    By yusufrelation in forum Excel General
    Replies: 1
    Last Post: 05-01-2013, 01:36 PM
  5. Inventory Spreadsheet, Sales decrease values
    By Willuknight in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2011, 08:48 PM

Tags for this Thread


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