Understanding Sales Forecasts

This chapter discusses:

Click to jump to top of pageClick to jump to parent topicForecasts

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

You can generate forecast subtotals as well as 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 of your database.

PeopleSoft 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 a big picture view of where the organization stands.

In PeopleSoft Sales, sales representatives, managers, and financial analysts work with specific 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 Sales forecasts are based on:

Click to jump to top of pageClick to jump to parent topicRevenue and Shadow Forecasts

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

This table provides three examples that demonstrate some of the ways that you might assign revenue and shadow allocations between two representatives, SREP1 and SREP2, who are working on the opportunity, and 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 works the deal and gets all of the credit:

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

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

Two representatives work the deal and split everything 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 helps out and gets 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 gets full credit towards his or her quota.

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

    SREP2 gets partial credit towards his or her quota for assisting with the deal.