Project Forecast Templates

The Project Forecast (Embeddable) and Project Forecast (Multi-Plan Process) templates have the field values detailed in the Forecast Template Details table.

Forecast Template Details
Field Value
Data Source Services Forecast Live
Delete Obsolete Plan Data Selected
Output Data Source Services Forecast Plans
Rate Table Fixed Currency Exchange Rates
Template Category "Services Forecasting"

Both templates have the same dimension and measure structure. Your selection while creating the templates using the Feature Console determines the column dimensions used.

Time Period Year and Month

If you selected the "Time period year and month" option in the Feature Console, your templates have the following structure:

  • Column dimensions:

    1. Time Period End Date (Year)
    2. Time Period End Date (Month)
    3. Revenue/Cost
  • Row dimensions:

    1. Project ID
    2. Actuals/Forecast
    3. Source
    4. Level 4 ID
    5. Breakdown
  • Measures:

    • Primary measure: Amount (Record Currency)
    • Secondary measure: Amount (Corporate Currency)
  • Default Unit Dimension: Currency

Time Period Name

If you selected the "Time period name" option in the Feature Console, your templates have the following structure:

  • Column dimensions:

    1. Time Period
    2. Revenue/Cost
  • Row dimensions:

    1. Project ID
    2. Actuals/Forecast
    3. Source
    4. Level 4 ID
    5. Breakdown
  • Measures:

    • Primary measure: Amount (Record Currency)
    • Secondary measure: Amount (Corporate Currency)
  • Default Unit Dimension: Currency

Example

The Project Forecast Example table represents a forecast created using either of the templates and the "Time period year and month" option.

Project Forecast Example
Time Period End Date (Year) 2027
Time Period End Date (Month) 01 02
Revenue/Cost Revenue Cost Revenue Cost
Hierarchy Amount (Record Currency) Amount (Record Currency) Amount (Record Currency) Amount (Record Currency)
 Acme Company - Managed Services-Project Part 1 USD 12,605.00 USD 28,796.12 USD 10,605.00 USD 26,796.12
 Actuals USD 4,755.00 USD 26,007.23 USD 3,755.00 USD 25,007.23
 Deliverable: Timecard USD 4,755.00 USD 26,007.23 USD 3,755.00 USD 25,007.23
 Resource: Jamie Smith USD 0.00 USD 12,320.00 USD 0.00 USD 11,320.00
Pending Recognition USD 0.00 USD 12,320.00 USD 0.00 USD 11,320.00
Recognized to Date   USD 0.00   USD 0.00
 Resource: Taylor Hughes USD 0.00 USD 9,722.23 USD 0.00 USD 9,722.23
Pending Recognition   USD 9,722.23   USD 9,722.23
Recognized to Date   USD 0.00   USD 0.00
 Resource: Billie James USD 0.00 USD 3,965.00 USD 0.00 USD 3,965.00
Pending Recognition   USD 3,965.00   USD 3,965.00
Recognized to Date   USD 0.00   USD 0.00
 Timecards USD 4,755.00 USD 0.00 USD 4,755.00 USD 0.00
Pending Recognition USD 4,755.00   USD 4,755.00  
Recognized to Date USD 0.00   USD 0.00  
 Forecast USD 7,850.00 USD 2,788.89 USD 6,850.00 USD 1,788.89
 Deliverable: Assignment USD 0.00 USD 2,788.89 USD 0.00 USD 1,788.89
 Resource: Jamie Smith USD 0.00 USD 1,750.00 USD 0.00 USD 750.00
Scheduled   USD 1,750.00   USD 750.00
Unscheduled   USD 0.00   USD 0.00
 Resource: Taylor Hughes USD 0.00 USD 388.89 USD 0.00 USD 388.89
Scheduled   USD 388.89   USD 388.89
Unscheduled   USD 0.00   USD 0.00
 Resource: Billie James USD 0.00 USD 650.00 USD 0.00 USD 650.00
Scheduled   USD 650.00   USD 650.00
Unscheduled   USD 0.00   USD 0.00
 Deliverable: EVA USD 7,850.00 USD 0.00 USD 6,850.00 USD 0.00
 Est vs Actuals USD 7,850.00 USD 0.00 USD 6,850.00 USD 0.00
Scheduled USD 7,850.00   USD 6,850.00  
Unscheduled USD 0.00   USD 0.00