Understanding Sales Forecasts

This chapter discusses:

Click to jump to parent topicForecasts

In PeopleSoft Enterprise Sales, forecasts are estimates of future sales revenues based on current opportunities, their projected revenue estimates, closing dates, and other factors. If your access profile permits, you can edit forecast data and add rows to make adjustments to forecasts. You might combine the forecasts of 10 team members to produce one roll-up forecast for the team. You can view forecasts at a summary level and then filter and sort summaries for analysis.

You can generate forecast subtotals, and you can create charts to view forecasts graphically. You can also use the Combined Forecasts page and the standard download feature to export forecast data to financial modeling programs outside the database.

PeopleSoft Enterprise Sales enables you to configure forecasting to your organization's business processes and reporting period needs. Sales representatives can generate and view their own forecasts and submit them to management at the appropriate reporting times. Managers can generate forecasts for sales representatives that are visible to them on the territory tree. Senior managers can view an overall forecast of all their groups by generating one high-level roll-up forecast that provides an overview of the organization's outlook.

In PeopleSoft Enterprise Sales, sales representatives, managers, and financial analysts work with sets of data determined by their user access profiles and territory tree visibility. In this way, managers in one division have access to their staff's data but not to the data of another division.

PeopleSoft Enterprise Sales forecasts are based on:

Click to jump to parent topicRevenue and Shadow Forecasts

PeopleSoft Enterprise Sales provides two forecast variants, each with a different focus:

The following table shows three ways that you might assign revenue and shadow allocations to two representatives, SREP1 and SREP2, who are working on an opportunity. The table shows how those allocations affect corresponding forecasts:

 

Opportunity 1

Opportunity 2

Opportunity 3

Customer

Lakeview Community College

Grandma's Foods

MMA Property Management

Product Group

Air Conditioners

Freezers

Refrigerators

Forecast Amount

100,000 USD

600,000 USD

1,000,000 USD

Close Date

March 31, 2001

March 31, 2001

March 31, 2001

Revenue Allocation

SREP1 = 100 percent

  • SREP1 = 50 percent

  • SREP2 = 50 percent

  • SREP1 = 100 percent

  • SREP2 = 0 percent

Shadow Allocation

SREP1 = 100 percent

  • SREP1 = 50 percent

  • SREP2 = 50 percent

  • SREP1 = 100 percent

  • SREP2 = 25 percent

Scenario and Forecast Results

One representative handles the deal and receives all of the credit:

  • 100,000 USD appears on SREP1's Revenue forecast.

  • 100,000 USD appears on SREP1's Shadow forecast.

Two representatives handle the deal and split the amount equally:

  • 300,000 USD appears on SREP1's Revenue forecast.

  • 300,000 USD appears on SREP2's Revenue forecast.

  • 300,000 USD appears on SREP1's Shadow forecast.

  • 300,000 USD appears on SREP2's Shadow forecast.

SREP1 owns the deal. SREP2 assists and receives partial shadow credit:

  • 1,000,000 USD appears on SREP1's Revenue forecast.

  • 0 USD appears on SREP2's Revenue forecast.

  • 1,000,000 USD appears on SREP1's Shadow forecast.

    SREP1 receives full credit toward the representative's quota.

  • 250,000 USD appears on SREP2's Shadow forecast.

    SREP2 receives partial credit toward the representative's quota for assisting with the deal.