If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Template for Revenue Forecast
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. |
#2
|
|||
|
|||
Template for Revenue Forecast
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. |
#3
|
|||
|
|||
Template for Revenue Forecast
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? "Fred" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|