projections
 

We recieve income from 50+ vendors. Most of our $$ comes from the top 10
vendors.

Generally speaking we get around the say amount of money around the same
time of month from each vendor.

I'm looking for a way to setup a chart or table to show a projected amount
of $$ we should be expecting for a given week.

I'm somewhat at a loss as where to start and was hoping someone could at
least head me in the right direction. I dont know if this is something I
would need to build from scratch or if there is an Excel tool that already
does this type of thing.

Any help will be appreciated.

Jordan

projections
 

In B1 enter the income received from Oct 1 thru Oct 7
In B2 enter the income received from Oct 8 thru Oct 14
In B3 enter the income received from Oct 15 thru Oct 21
In B4 enter the income received from Oct 22 thru end of Oct

In C1 thru C4 do the same for Sept.

Continue going backwards in time until column K is filled.

Finally in A1 enter:
=AVERAGE(B1:K1) and copy down thru A4.

If data is missing in cols B thru K, leave the cell blank rather than enter
a zero.


--
Gary''s Student - gsnu200908


"Jordan" wrote:

We recieve income from 50+ vendors. Most of our $$ comes from the top 10
vendors.

Generally speaking we get around the say amount of money around the same
time of month from each vendor.

I'm looking for a way to setup a chart or table to show a projected amount
of $$ we should be expecting for a given week.

I'm somewhat at a loss as where to start and was hoping someone could at
least head me in the right direction. I dont know if this is something I
would need to build from scratch or if there is an Excel tool that already
does this type of thing.

Any help will be appreciated.

Jordan