Formula To calculate sales projection for the coming months

**Climaxgp** · 05-29-2009, 08:09 AM

Hi Guys

I was just wondering if there is any formula to calculate sales projections for a coming month based on performance for the last couple of months?

I have attached a spreadsheet of the info..

**DonkeyOte** · 05-29-2009, 09:14 AM

I'm afraid this stuff is not my strong point by any means but do you mean something like:

B14: =FORECAST(G6,B3:F3,B6:F6)

Or are you looking to get a lot more sophisticated than that ?

**Climaxgp** · 05-29-2009, 09:27 AM

Hey DonkeyOte

Thanks for the reply!

Your replies are always welcomed!!

I was using the formula you provided, I would love to go more in depth in this and i'm sure there is more to this but i just don't know how to.. Once again, thanks for your response!! I really appreciate it!

**DonkeyOte** · 05-29-2009, 09:28 AM

Someone will come up with something more sophisticated I'm sure (or at least explain if not possible) - I'm afraid I know little... shg may be around later.

**Climaxgp** · 05-29-2009, 09:43 AM

Thanks buddy!

Appreciate it!

**shg** · 05-29-2009, 11:36 AM

Maybe as attached.

**DonkeyOte** · 05-29-2009, 11:42 AM

I don't understand it but thanks as usual shg for your input -- I will study now!

**Climaxgp** · 06-01-2009, 03:03 AM

Thank you shg!!!!

I really appreaciate it!!!

The stuff you did seems like rocket science to me... so i have a few questions that i would like to ask you, if you don't mind.. I have added comments on the attached document

Also, we rely on the data quality being above 50% to achieve our sales targets, how do i incorporate the data quality to form part of the sales projection?

**Climaxgp** · 06-01-2009, 05:22 AM

Hey..

Just thought of something else...

I need to incorporate data used as well to give a prediction of sales as well.

With our line of business this goes hand in hand with the sales achieved at the end of the month. Hope i'm making sense..

What i'm trying to say is if a person uses X amount of Data we expect X amount of sales from that