Sales Forecast using Previous Year Revenues for a Particular Produ

[Deepak K Gopal]

Dear all,
Have checked most of the sales forecast templates posted on this site. It
was really helpful for most of my queries and I appreciate all the help.

Now, I want to know if anyone have any template for forecasting sales of a
particular product using its previous year revenues from different
organizations/companies.

I have a sample data set, having product revenues from different
organizations along with that Organizations sales turnover values. Basically
I want to relate the revnues to that organizations sales turnover as well as
want to forecast sales, if I get similar kind of organizations as my clients
in future. Because my product sales is depended on a company's capability of
buying.

Please suggest a analysis method and also let me know if anyone have any
templates ready to do this forecasting. I had a moving averages model created
by me, but that model can not eliminate extreme data points.

If you need more details about the sample data please write to me at
deepakgopalk[at]gmail[dot]com

Thank you all and awaiting a reply.

Warm Regards

Deepak

 

[zhengjie]

Dear all,
Have checked most of the sales forecast templates posted on this site. It
was really helpful for most of my queries and I appreciate all the help.

Now, I want to know if anyone have any template for forecasting sales of a
particular product using its previous year revenues from different
organizations/companies.

I have a sample data set, having product revenues from different
organizations along with that Organizations sales turnover values. Basically
I want to relate the revnues to that organizations sales turnover as well as
want to forecast sales, if I get similar kind of organizations as my clients
in future. Because my product sales is depended on a company's capability of
buying.

Please suggest a analysis method and also let me know if anyone have any
templates ready to do this forecasting. I had a moving averages model created
by me, but that model can not eliminate extreme data points.

If you need more details about the sample data please write to me at
deepakgopalk[at]gmail[dot]com

Thank you all and awaiting a reply.

Warm Regards

Deepak