Need help with a inventory sales prediciting spreadsheet
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
Valued Forum Contributor
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:
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By duatiga in forum Excel General
Last Post: 04-14-2014, 10:06 PM
By elpopo in forum Excel General
Last Post: 11-26-2013, 11:05 AM
By lorne17 in forum Excel Formulas & Functions
Last Post: 06-27-2013, 05:53 PM
By yusufrelation in forum Excel General
Last Post: 05-01-2013, 01:36 PM
By Willuknight in forum Excel Formulas & Functions
Last Post: 07-31-2011, 08:48 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1