The Configuration menu item in Business Planning & Forecasting allows you to enter a business plan (Revenue, Cost, Cashflow) for a company or division for comparison to actual and forecast. It contains two tabs: JC Configuration and GL Configuration.

The JC Configuration tab is similar to the JC Configuration screen, except that there are columns for Secured Work and Unsecured Work after the G/L Account column.

JC Configuration Tab

The labels come from General Ledger > Configuration > Account Structure. The columns store a single element for each G/L Account for an appropriate Cost Category and Revenue. Storing blank values is allowed.

The lookups use GL elements for each level. Descriptions for the selected GL elements use the new RO field RO_jcf_GLElementDesc in the JC Configuration table. The new RO field has an input parameter which returns the appropriate value for Secured or Unsecured Work.

If G/L Accounts are missing, then an appropriate element from standard GL accounts in JC Configuration will be used for Secured and Unsecured Work.

The GL Configuration tab allows you to setup mapping GL Budget types for the BPF Business Plan.

GL Configuration Tab

Links in all ETS reports for Secured Work and Opportunities allow redirection to the CVR Enquiry or the Opportunities Forecast Enquiry, respectively.

The Field Set dropdown allows you to select whether the columns in the report will be configured according to the Standard configuration or the Business Plan configuration.

ETS Yearly Analysis

The Standard Field Set includes all existing fields from all forms that the ETS Yearly Analysis Report uses. The Grand Totals Form allows dynamic grand totals calculations.

All existing fields should be copied to appropriate Forms for %WBF3030RSMP and %WBF3031RSMP functions in System/Report Field Sets menu.

All fields referenced must use calculation logic defined in the report generation program.

The Business Plan Field Set is available if BPF Configuration has been defined. It is similar to the Standard Field Set, except that it also includes a Plan column in the report. The Plan column shows information as defined in BPF Configuration.

The Plan column is calculated as the sum of the GL Budget Type specified for each GL Account in BPF Configuration for Secured/Unsecured Work, applying GL Configuration, security and report selection. The Type number in GL Configuration identifies which element for the GL Account will be fixed for retrieving budgets.

GL Configuration

Using the above configuration – the “Plan” is calculated as follows:

Order Intake/Revenue:

Secured Work

GL element 1001. Category is set to 3.

Unsecured Work

Same as Secured Work, but use GL element 1501.

Revenue value is the sum of Secured and Unsecured Work.

Order Intake/Cost:

Uses the same logic as above but uses the GL accounts for each category from BPF Configuration and sums the results.

Secured Contracts/Revenue

GL account 1001. Category is set to 3.

• Find all GL accounts matching the following condition: gl_acct.gla_el3 = “1001”

• Apply GL security and GL report selection

• Retrieve GL budget “BD01*” for each GL account and sum the result

Secured Contracts/Cost:

Uses the same logic as above but uses the GL accounts for each category from the BPF Configuration for Secured Work and sums the results.

Opportunities/Revenue

GL account 1501 Category is set to 3.

• Find all GL accounts matching the following condition: gl_acct.gla_el3 = “1001”

• Apply GL security and GL report selection

• Retrieve GL budget “US01*” for each GL account and sum the result

Opportunities/Cost:

Uses the same logic as above but uses the GL accounts for each category from BPF Configuration for Unsecured Work and sums the results.

WIH

Rows are calculated as = WIH at the end of the previous year + Order Intake - Secured Contracts

WIH at the end of the previous year is calculated by using actuals at the end of the previous year.

Contract Trading

Plan values are calculated by using the existing logic for other columns.

Enterprise Trading Summary Configured Rows

GL rows are calculated using Business Overheads GL budget values for GL accounts defined in the row definition.

ETS Configuration

For Contract-based ETS rows, blank values are shown.

Calculated rows use their formulas to get values.

Full Year - Quarterly Analysis

New columns Qtr1/Qtr2/Qtr3/Qtr4 after the Full Year section show information summarised by each quarter. The following logic is used to divide the financial year into quarters depending on the count of periods in the year:

Forecast values are used for Quarterly Analysis columns.

ETS Yearly Analysis Report

The Budget Plan Report is available in the Enterprise Trading Summary reports menu if BPF Configuration is defined.

Budget Plan Report Selection

The Budget Plan Report excludes contract rows from the ETS Configuration, but calculates values for them to be able to use them in the formula for calculation rows. Values for the columns are retrieved from GL Budgets using the same logic as the Yearly Analysis Report.

ETS Budget Plan Report

The Field Set selector in the Trading Summary Enquiry operates in the same manner as the Field Set selector in the Yearly Analysis Report.

Trading Summary Enquiry

GL Account selection works in the same manner as it does for all ETS Reports.

The Budget Plan tab works similarly to the Enterprise Trading Summary Budget Plan Report , but only shows Contract Trading values.

Budget Plan Tab