Home > Sales Management > Sales Tracking and Forecasting

How To Make Sales Forecast

Rajwant6109 - Member Since: Jul 2011
Subject - How To Make Sales Forecast
Hi All,

Can anybody Explain me how to Make Sales Forecast by using Regression Analysis ?
Mickypapneja Full member - Member Since: Jun 2011
Subject - Re: How To Make Sales Forecast
Hi Rajwan,

While searching online for regression analysis, I find it this link http://www.duke.edu/~rnau/regex.htm. Please check whether it works or not?
Rajwant6109 - Member Since: Jul 2011
Subject - Re: How To Make Sales Forecast
Hi Mickypapneja,

Thanks for Sending a Valuable Links.
Again I am sending you State Wise Sales For F.Y. - 2010-2011. Now i want to make Sales Forecast for FY-2011-2012. Please Let me know how to do it ?


Regards,
Rajwant

Attached Files
File Type: xls Data.xls (91.0 KB, 306 views)
Rajwant6109 - Member Since: Jul 2011
Subject - Re: How To Make Sales Forecast
sorry, Wrong File was attached.

Please assist me for making forecast by Using regression Analysis.

However, Attached file is having State Wise Sale for FY.-2010-2011 on which basis I want to prepare Forecast for FY.-2011-2012.



Regards,
Rajwant

Attached Files
File Type: xls Sale.xls (23.0 KB, 225 views)
Mickypapneja Full member - Member Since: Jun 2011
Subject - Re: How To Make Sales Forecast
Hi Rajwant,

I don't have the deep knowledge of regression analysis. It may effect your result. So,its better to contact a Statistics head or analyst.
vjmohammedyounus - Member Since: Aug 2011
Subject - Re: How To Make Sales Forecast
Sales for Retail Day to Day Sales is enclosed but file to be opened in Open Office.org as in exel the column wigth changes and the file size is more

Attached Files
File Type: zip Sales Report 2011 one.zip (105.4 KB, 203 views)
Rajwant6109 - Member Since: Jul 2011
Subject - Re: How To Make Sales Forecast
Please can you send it in MS Office Excel Format.
vjmohammedyounus - Member Since: Aug 2011
Subject - Re: How To Make Sales Forecast
Please Download open office which is free to use
jaimik.soni1989 - Member Since: Oct 2011
Subject - Re: How To Make Sales Forecast
Hey mohammed this file is password protected can u plz assist me how to open this valuable file..?
vjmohammedyounus - Member Since: Aug 2011
Subject - Re: How To Make Sales Forecast
Hi you need no password just type the establishment name next go to other sheet or click the month which you want to enter the sales and this will automatically give the graph and the average and the percentage of growth. If you cant enter the old or the past month full sale at least enter the total sales of that month in the first day so it can give the proper growth in the present month


CiteSales is a community knowledgebase that let's you put your office or work related issues in front of a large group of peers and sales and marketing practitioners.


Contact Us - CiteSales Sales & Marketing Management Index - Privacy Statement - Top - RSS -

Privacy Policy | Disclaimer | Terms Of Service