Template for Revenue Forecast

[jzylla]

I am trying to set up a Database to help with revenue forecasting.
Basically, it is for a construction company.

I have contracted amounts, hours, and various phases of construction that I
would like to spread over time, based on the start and end date of each phase
of construction.

Does anyone have a template that may work, or be close for this scenario?

Thanks.

 

[Fred]

I noticed that nobody answered.

For your particular need, 90% of the brainwork is determining a way to
forecast revenue for your particular situation (which you know and we don't)
and then the other 10% is how to use Access to implement that "how to" that
was determined.

 

[jzylla]

Thanks Fred. I actually have the forecast information basically, but I
wanted to be able to present it better.

I have the total contract amount, and the timeframe in which it should be
earned in the future but it is in a range of dates(ie: 3/24/09-4/13/09), and
the total revenue for that period. I am having trouble putting a query and
report togther that will show the revenue broken down per month. The revenue
is earned over time, so I can't just use the start or end date for my calcs.

This is where I am lost. Any ideas?