This report provides management with an overall view of projected network revenue based on pending proposals (and their booking probability.) The percentage assigned as booking probability is used to forecast the revenue using pending proposals. For example, if a proposal with a total dollar value of $100,000 has a booking probability of 75%, the value applied within this report is $75,000.

Using this module, the following three reports can be generated: Actual Revenue Report, Previous Year Revenue Comparison Report, and Budget Comparison Revenue Report.

Current Year Revenue Forecasting Report

The Current Year Revenue Forecasting Report provides management with a monthly breakdown by rep of what is currently on the books. Pending proposals are prorated based upon the probability percentage assigned within the proposal. Revenue categories have been added to the revenue forecaster to provide management with a more accurate picture of where the revenue is coming from.

Steps to Generate report:

•    These steps can be applied to produce any of the above mentioned reports:

•    Enter the desired forecast year

•    Click on Compare to None

•    Select  ‘DO REPORT’

Revenue Forecasting Previous Year Comparison Report

The previous year revenue comparison report compares the actual revenue (as reported in the actual revenue report) with actual revenue as entered by management into SDS Sales reporting module.

Steps to Generate report:

These steps can be applied to produce any of the above-mentioned reports:

•    Enter the desired forecast year

•    Click on Compare to Previous Year’s actuals

•    Click on the ‘Enter Actuals’ button

•    Enter the actual revenue by month for the previous year

•    Select  ‘DO REPORT’

Revenue Forecasting Budget Comparison Report

The Budget Comparison Revenue Report compares the actual revenue (as reported in the actual revenue report) with budgeted values, as entered by management into the SDS Sales reporting module. Categories for segmentation of revenue have been added to provide management with a more accurate view of the revenue when compared to the budgeted values. 

Steps to Generate reports:

These steps can be applied to produce any of the above-mentioned reports:

•    Enter the desired forecast year

•    Select 'Compare To Budget' option

•    Click on the ‘Enter Budgets’ button

•    Enter the fiscal year desired then assign the budget values by month

•    Select ‘DO REPORT’

NOTE

Actuals and Budgets only need to be entered once for each year.