Estimated Revenue Tab of the Opportunities Form

Use the Estimated Revenue tab to specify the dates and time periods on which you expect to receive revenue. You can also specify a pre-defined allocation template to apply as the basis when you review the estimated revenue data on an Opportunity Forecast report. This provides an efficient method for analyzing the potential revenue stream for the opportunity.

This tab is available if your enterprise purchased the DPS CRM Plus application and the Enable Service Estimate option is selected on the Service Estimate tab in Settings > Opportunities.

Contents

Much of the information for DPS is entered and displayed in grids on various forms. For information about using grids, see Working with Grids.

Field Description
Allocation Method Select one of the following options to determine how estimated revenue is allocated for the opportunity:
  • Specific Dates — Select this option to allocate the estimated revenue amount to specific dates for each opportunity. This activates the Estimated Revenue Allocation grid. Use this grid to identify the dates on which revenue is expected to be received as well as the amounts. This feature is useful for companies who receive revenue for a project at irregular intervals, rather than monthly or quarterly. For example, a company can submit a fee schedule with a proposal that specifies that an inspection is to occur on a specific date and, upon completion, a payment will be due.
  • Spread Evenly Across Timescale — Select this option to spread revenue in even amounts across the dates between the estimated start date and the estimated completion date. After you select this option, use the Timescale option to specify the timescale for the revenue. This option is selected by default.
  • Allocate All Revenue to Estimated Start Date — Select this option to allocate the estimated revenue amount to the opportunity's start date.
  • Allocate All Revenue to Close Date — Select this option to allocate the estimated revenue amount to the opportunity's date closed.
Time Scale This option displays if you select Spread Evenly Across Timescale as the Allocation Method.

Use this option to specify the time scale used to calculate the revenue for the revenue period. Select one of the following settings:

  • Daily
  • Weekly
  • Biweekly — This is a two-week period, starting on a Monday and ending on a Sunday.
  • Semi-Monthly — This is one semi-monthly period that 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. The number of days in the month does not change how this setting works.
  • Monthly
  • Quarterly
  • Yearly
Refresh/Use Template Select this option to open the Allocation Template dialog box and select a pre-defined template to use as the basis for Estimated Revenue Allocation. You can use these templates to calculate your company's desired revenue date, amount, and percentage. When you select a template, the Estimated Revenue Allocation Grid displays the template's pre-defined information. See the Use a Template for Estimate Revenue Allocation topic for more details.

If you modify template data in this grid, DPS does not overwrite the template's information in Settings > Opportunities .

Estimated Revenue Allocation Grid

This grid activates when the Allocation Method is set to Specific Date. Use this grid to identify the dates when you expect to receive revenue. This is useful for companies who receive revenue for a project at irregular intervals, rather than monthly or quarterly. For example, a company can submit a fee schedule with a proposal that specifies that an inspection occurs on a specific date and, upon completion, a payment is due.

Your system administrator creates templates that populate pre-defined information on this grid. You can use these templates as the basis for your Estimated Revenue Allocation information. See the Use a Template for Estimate Revenue Allocation topic for more details.

Field Description
+ Add Allocation Click this option to add a row to the Allocation grid.
Description Enter a description for the revenue milestone. If you use a template, this field populates with the description from the template.
Revenue Date Enter or select the date on which the revenue will be received. If you use a template, this field populates based on calculations from the Time Frame and Time from Start Date fields on the Allocation Template dialog box.
Revenue Amount Enter the amount of revenue that you expect to receive. If you use a template, this field populates with the revenue from the template.

If you enter a value in the Percent of Total Revenue field, the amount in this field calculates based on the amount entered in the Revenue Amount field on the Summary Pane in the Opportunities Hub. For example, an opportunity has $100,000 revenue and a row in this grid has 20% of total revenue. The revenue amount for the milestone is $20,000.

If an opportunity's revenue amount changes, the amounts on this grid update automatically.

The amount in the Revenue Amount column is totaled at the bottom of the grid.

Percent of Total Revenue Enter a percentage of the total revenue that you expect to receive. You cannot enter a value that is less than 0 or greater than 100. If you use a template, this field may populate with the percentage entered on the template.

The total Percent of Total Revenue must equal 100% when you save the record.

The amounts in the Revenue Amount and Percent of Total Revenue columns are totaled at the bottom of the grid.