Project Forecast Options Tab

Use the options to set time frame and calculation options for the report.

Time Frame Options

Field	Description
Start Date	Select the start date for the data on the report: Specific Date: The report displays data starting with the date that you specify in the calendar below this field. Relative Date: The report displays data starting with the option you specify in the drop-down list below this field: Today, This Month, or Next Month.
Scale	Select one of the following period scales for the hours or amounts on the report: Daily Weekly Bi-weekly: A two-week period. Semi-Monthly: One semi-monthly period runs from the first to the fifteenth of the month. The second semi-monthly period runs from the sixteenth to the end of the month. Monthly Quarterly Yearly Periods: The fiscal periods. The number of periods is determined by the report's selected Start Date and Duration. When you select a project, a warning message displays if there are gaps or overlapping dates for the existing fiscal periods included in the project's revenue forecast date range or if there are not enough established fiscal periods to support the project's revenue forecast date range. If there are gaps or overlaps, the revenue forecast periods are displayed using months. If there are missing fiscal periods, Vantagepoint automatically adjusts the column heading for those affected dates depending on the value set for the Periods Per Year field in Utilities > Period > Period Setup: If Periods Per Year is 12 or is not 13, any missing fiscal periods display in months. If Periods Per Year is 13, any missing fiscal periods display as 4 week (28 day) periods. If the first or last fiscal period dates do not coincide with their corresponding month start/end dates, partial periods display in those calendar columns.
Fiscal Year	This field is only enabled if the Scale option is set to Quarterly or Yearly. Use this field to identify the start and end month of your fiscal year. For example, select Fiscal Year October - September and the Year Determined by End Month. That means that October 2019 - September 2020 is FY 2020. The first quarter of FY 2020 would be October 2019 - December 2019 and the second quarter would be January 2020 - March 2020.
Year Determined By	This option is enabled if the Scale option is set to Quarterly or Yearly. Use this option to specify whether the year of the start month or the year of the end month is used to determine the year of the fiscal year. For example, let's say that you set Fiscal Year to October - September. If you set Year Determined By to Start Month, then the fiscal year for October 2019 - September 2020 is 2019. If you set Year Determined By to End Month, then the fiscal year for October 2019 - September 2020 is 2020.
Duration	Select the number of reporting periods to display. The related Scale option determines the type of period. For example, if the scale is monthly and you enter 6 here, the report displays data for six monthly periods.
Column Width	Enter the width for the data columns in inches or millimeters, based on which one you selected in the Unit of Measure field on the Layout tab. Enter inches and millimeters with decimals. For example, enter one and a half inches as 1.5.
Show Timescale Chart	Select this option to display the Report chart graph at the end of the report. The chart displays the revenue forecast shown in the columnar data. The data points on the graph are based on the first grouping that you specify on the Columns & Groups tab. If you do not specify a grouping, the graph is based on project name.
Column Height	This field displays if Show Timescale Chart is selected. Enter the height for the chart columns in inches or millimeters, based on which one you selected in the Unit of Measure field on the Layout tab.
Column Width	This field displays if Show Timescale Chart is selected. Enter the width for the chart columns in inches or millimeters, based on which one you selected in the Unit of Measure field on the Layout tab.

Calculation Options

Field	Description
Fee Allocation	Select one of the following methods for allocating revenue to periods: Spread Evenly Across Timescale: Vantagepoint allocates estimated revenue evenly from the estimated start date of each project to its estimated completion date. Allocate All Fee to Estimated Start Date: Vantagepoint allocates the total estimated revenue to each project's estimated start date. Allocate All Fee to Estimated Completion Date: Vantagepoint allocates the total estimated revenue to each project's estimated completion date. Allocate All Fee to Close Date: Vantagepoint allocates the total estimated revenue amount to the project's Won/Lost Date. Use Allocation Method of Project: Vantagepoint allocates estimated revenue using the Allocation Method specified for each project in Hubs > Projects > Contract Management. The allocation methods available there are the same as those listed above, with the following two additions. You must select Use Allocation Method of Project for this report to use either of these methods. Choose Use Fee Allocation Grid with Specific Dates to have the Project Forecast report show the dates on which revenue is expected. This allocation method is designed for companies that receive revenue for projects at irregular intervals, rather than monthly, quarterly, and so on. Choose Use Revenue Forecasts to have the Project Forecast report display revenue forecast values for projects with In Pursuit and Won stages.
Calculation Period	If you select Spread Evenly Across Timescale in Fee Allocation, use this option to specify the period for which Vantagepoint calculates the fee. Vantagepoint then uses that unit of revenue to calculate the forecast for the period displayed on the report. Your selection in the Scale field affects which options are available here. For example, if you select Monthly in the Scale field, Monthly is the largest option available here. Select the calculation period from the following options: Daily Weekly Bi-weekly: A bi-weekly period is a two-week period. Semi-Monthly: One semi-monthly period runs from the first day of the month to the fifteenth day of the month. The other semi-monthly period runs from the sixteenth day of the month to the end of the month. Monthly Quarterly Vantagepoint first determines how many of the calculation periods exist for the project. For example, a project has an estimated start date of 1/1/19 and an estimated completion date of 1/1/20. If the calculation period is daily, the project date range has 366 calculation periods. Vantagepoint then calculates how much revenue will be earned during one calculation period of the project. If the estimated revenue for the project is $100,000, the daily revenue amount is $273.224 ($100,000/366 days). Vantagepoint uses the revenue amount for the calculation period to calculate the forecasted revenue for the display period you select for the report. If you specify a start date of 1/1/19, select Monthly in Scale, and enter 3 in Duration, the report displays three columns containing forecasted revenue for January, February, and March. The amount for each month is the number of days in that month multiplied by the daily revenue amount. For example, the forecasted revenue for the project for January would be $8469.94 ($273.224 x 31).
Calculate Pursuit Forecast Using	If you have CRM only, this field is labeled Calculate Forecast By. Select the type of fee that you want Vantagepoint to use as the basis for the forecasts for in pursuit projects: Estimated Fee: The estimated fee is the amount that you expect to earn if you are awarded the project. You specify the project's estimated fee in the Projects hub. Weighted Fee: In the Projects hub, you specify a percentage that represents the probability that you will win the project. Vantagepoint calculates the weighted fee as follows: Estimated fee x Probability / 100. (Example: $100,000 estimated fee x 80% / 100 = $80,000 weighted fee) If you own the Resource Planning module and the Fee Allocation field is set to Use Allocation Method of Project, this selection does not apply to projects for which the Allocation Method option is set to Use Revenue Forecasts on the Estimated Fee tab in Hubs > Projects > Contract Management. In this case, you'll see the project's planned forecast amount from the Revenue Forecast application.
Calculate Awarded Forecast Using	This option is hidden if you only have the CRM module. Select the amount that you want Vantagepoint to use as the basis for the forecasts for won projects: Labor: Amounts are based on the Fee Allocation setting on the Options tab of Project Forecast report: Fee Allocation Setting Result Spread Evenly Across Timescale, Allocate All Fee to Estimated Start Date, Allocate All Fee to Estimated Completion Date, or Allocate All Fee to Close Date Amounts are based on the direct labor compensation amount for the project from the Compensation tab of the Contract Management form. Use Allocation Method of Project If the Allocation Method for the project is set to Use Revenue Forecasts on the Estimated Fee tab in Hubs > Projects > Contract Management, you see the project's planned revenue from the Revenue Forecast application. The global revenue forecast calculation option selected in Settings > Resource Planning > Revenue Forecast Settings defines the type of revenue represented. If the Allocation Method for the project is set to a method other than Use Revenue Forecasts, amounts are based on the direct labor compensation for the project from the Compensation tab of the Contract Management form and are applied using the Allocation Method for the project. Labor + Direct Expense: Amounts are based on the Fee Allocation setting on the Options tab of Project Forecast report: Fee Allocation Setting Result Spread Evenly Across Timescale, Allocate All Fee to Estimated Start Date, Allocate All Fee to Estimated Completion Date, or Allocate All Fee to Close Date Amounts are based on the sum of the direct labor and direct expense compensation amounts for the project from the Compensation tab of the Contract Management form. Use Allocation Method of Project If the Allocation Method for the project is set to Use Revenue Forecasts on the Estimated Fee tab in Hubs > Projects > Contract Management, you see the project's planned revenue from the Revenue Forecast application. The global revenue forecast calculation option selected in Settings > Resource Planning > Revenue Forecast Settings defines the type of revenue represented. If the Allocation Method for the project is set to a method other than Use Revenue Forecasts, amounts are based on the sum of the direct labor and direct expense compensation amounts for the project from the Compensation tab of the Contract Management form and are applied using the Allocation Method for the project. Total Compensation: Amounts are based on the Fee Allocation setting on the Options tab of Project Forecast report: Fee Allocation Setting Result Spread Evenly Across Timescale, Allocate All Fee to Estimated Start Date, Allocate All Fee to Estimated Completion Date, or Allocate All Fee to Close Date Amounts are based on the sum of the direct labor, direct expense, direct consultants, reimbursable expenses, and reimbursable consultants compensation amounts for the project from the Compensation tab of the Contract Management form. Use Allocation Method of Project If the Allocation Method for the project is set to Use Revenue Forecasts on the Estimated Fee tab in Hubs > Projects > Contract Management, you see the project's planned revenue from the Revenue Forecast application. The global revenue forecast calculation option selected in Settings > Resource Planning > Revenue Forecast Settings defines the type of revenue represented. If the Allocation Method for the project is set to a method other than Use Revenue Forecasts, amounts are based on the sum of the direct labor, direct expense, direct consultants, reimbursable expenses, and reimbursable consultants compensation for the project from the Compensation tab of the Contract Management form and are applied using the Allocation Method for the project. Match Revenue Forecast Calculation: <text>: This option is available if you own the Resource Planning module. The amounts that are allocated depend on the Allocation Method setting on the Estimated Fee tab in Hubs > Projects > Contract Management: Allocation Method Setting Result Spread Evenly Across Time Scale, Allocate All Fees to Estimated Start Date, Allocate All Fees to Close Date , Allocate All Fees to Estimated Completion Date , or Use Fee Allocation Grid with Specific Dates The compensation amount that corresponds to the global revenue forecast calculation option selected in Settings > Resource Planning > Revenue Forecast Settings is forecasted according to the project's allocation method. Use Revenue Forecasts For won and in-pursuit projects, the forecasted amount is the project's planned revenue from the Revenue Forecast application. The text that displays in this field depends on the global revenue forecast calculation option selected in Settings > Resource Planning > Revenue Forecast Settings. If Gross Revenue is selected, the text is Labor + (Direct: Expenses + Consultants) + (Reimbursable: Expenses + Consultants). If Net Revenue includes Direct Consultants is selected, the text is Labor + (Direct: Expenses + Consultants). If Net Revenue excludes Direct Consultants is selected, the text is Labor + Direct Expenses. If Labor is selected, the text is Labor. Note that if Use Allocation Method of Project is selected in the Fee Allocation field, any projects set to the Use Revenue Forecasts allocation method will use the Match Revenue Forecast Calculation: <text> setting.

Reporting Amounts

This section displays if you use multiple currencies.

Field	Description
Report In	Select the currency in which to display amounts on the report: Project Currency: Choose this option to use the currency specified in Project Currency on the Overview tab of the Projects form in the Projects hub. Billing Currency: Choose this option to use the currency specified in Billing Currency on the Overview tab of the Projects form in the Projects hub. Presentation Currency: Choose this option to translate all values into the single currency that you specify for the Presentation Currency option.
Presentation Currency	If you set Report In to Presentation Currency, use this option to select the currency in which to display amounts. The list includes only those currencies that are enabled for your enterprise. All amounts on the report are presented in this single currency. Vantagepoint calculates the exchanges between the project currency and the presentation currency based on the date that you specify in Exchange Rate as of.
Exchange Rate as of	Specify the date that Vantagepoint uses to calculate exchanges based on the currency that you selected in Report In. Vantagepoint determines and applies the correct exchange rates in the daily exchange rate table based on this date.