Budget Overview

This function displays all the data held in the Budget Entity, Budget Resource Allocation and Budget Payment Delivery tables. It is an overview per entity, per baseline and per budget id of the budget system's data. The first tab allows the user to view data at entity level. The second tab displays the data at budget id level per entity type (if selected) per baseline (Many baselines can be viewed for a specific budget id). The third tab displays the data per baseline for one specific budget type only (Many baselines can be viewed for many budget id's of the same type).

Budget Entity Id

ACTUAL ADVANCE PAYMENTS

ACTUAL SALES (FINAL)

ACTUAL SALES (PROGRESS)

ACTUAL SALES (RETENTION)

ACTUAL SALES (ESCALLATION)

ACTUAL ADDITIONAL COST SALES (FINAL)

ACTUAL ADDITIONAL COST SALES (PROGRESS)

ACTUAL ADDITIONAL COST SALES (RETENTION)

ACTUAL ADDITIONAL COST SALES (ESCALLATION)

ACTUAL CREDIT SALES (FINAL) (Negative values)

ACTUAL CREDIT SALES (PROGRESS) (Negative values)

ACTUAL CREDIT SALES (RETENTION) (Negative values)

ACTUAL CREDIT SALES (ESCALLATION) (Negative values)

-------------------------------------------------------------------------

TOTAL ACTUAL SALES

===========================================================

BUDGETED ADVANCE PAYMENTS

BUDGETED SALES (FINAL)

BUDGETED SALES (PROGRESS)

BUDGETED SALES (RETENTION)

BUDGETED SALES (ESCALLATION)

BUDGETED ADDITIONAL COST SALES (FINAL)

BUDGETED ADDITIONAL COST SALES (PROGRESS)

BUDGETED ADDITIONAL COST SALES (RETENTION)

BUDGETED ADDITIONAL COST SALES (ESCALLATION)

BUDGETED CREDIT SALES (FINAL) (Negative values)

BUDGETED CREDIT SALES (PROGRESS) (Negative values)

BUDGETED CREDIT SALES (RETENTION) (Negative values)

BUDGETED CREDIT SALES (ESCALLATION) (Negative values)

-------------------------------------------------------------------------

TOTAL BUDGETED SALES

===========================================================

ACTUAL PREPAYMENTS

ACTUAL PURCHASES (FINAL)

ACTUAL PURCHASES (PROGRESS)

ACTUAL PURCHASES (RETENTION)

ACTUAL PURCHASES (ESCALLATION)

ACTUAL ADDITIONAL COST PURCHASES (FINAL)

ACTUAL ADDITIONAL COST PURCHASES (PROGRESS)

ACTUAL ADDITIONAL COST PURCHASES (RETENTION)

ACTUAL ADDITIONAL COST PURCHASES (ESCALLATION)

ACTUAL CREDIT PURCHASES (FINAL) (Negative values)

ACTUAL CREDIT PURCHASES (PROGRESS) (Negative values)

ACTUAL CREDIT PURCHASES (RETENTION) (Negative values)

ACTUAL CREDIT PURCHASES (ESCALLATION) (Negative values)

-------------------------------------------------------------------------

TOTAL ACTUAL PURCHASES

===========================================================

BUDGETED PREPAYMENTS

BUDGETED PURCHASES (FINAL)

BUDGETED PURCHASES (PROGRESS)

BUDGETED PURCHASES (RETENTION)

BUDGETED PURCHASES (ESCALLATION)

BUDGETED ADDITIONAL COST PURCHASES (FINAL)

BUDGETED ADDITIONAL COST PURCHASES (PROGRESS)

BUDGETED ADDITIONAL COST PURCHASES (RETENTION)

BUDGETED ADDITIONAL COST PURCHASES (ESCALLATION)

BUDGETED CREDIT PURCHASES (FINAL) (Negative values)

BUDGETED CREDIT PURCHASES (PROGRESS) (Negative values)

BUDGETED CREDIT PURCHASES (RETENTION) (Negative values)

BUDGETED CREDIT PURCHASES (ESCALLATION) (Negative values)

-------------------------------------------------------------------------

TOTAL BUDGET PURCHASES

===========================================================

ACTUAL (LABOUR)

ACTUAL (MATERIAL)

-------------------------------------------------------------------------

TOTAL ACTUAL COST

===========================================================

BUDGET (LABOUR)

BUDGET (MATERIAL)

-------------------------------------------------------------------------

TOTAL BUDGET COST

===========================================================

PLANNED COMM (LABOUR)

PLANNED COMM (MATERIAL)

RELEASED COMM (LABOUR)

RELEASED COMM (MATERIAL)

-------------------------------------------------------------------------

TOTAL COMMITMENT COST

===========================================================

next Budget Entity Id etc

GRAND TOTAL ACTUAL ADVANCE PAYMENTS

GRAND TOTAL ACTUAL SALES

GRAND TOTAL ACTUAL PREPAYMENTS

GRAND TOTAL ACTUAL PURCHASES

GRAND TOTAL ACTUAL COST + COMM

===========================================================

GRAND TOTAL ACTUAL GROSS PROFIT (Actual Sales - (Actual Cost + Comm))

===========================================================

GRAND TOTAL BUDGET ADVANCE PAYMENTS

GRAND TOTAL BUDGET SALES

GRAND TOTAL BUDGET PREPAYMENTS

GRAND TOTAL BUDGET PURCHASES

GRAND TOTAL BUDGET COST

===========================================================

GRAND TOTAL BUDGET GROSS PROFIT (Budget Sales - (Budget Cost + Comm))

The total row of all budget amount types is not displayed if the 'All' check boxes (for budget amount types) have been deselected and only a single option (budget amount type) within that set has been selected.

Users with the Budget Manager profile and Budget Header All and who are either the div manager, div accountant, responsible person, entity manager or acting for may have access to tabs 2 and 3 for the entities for which they are responsible. Users with the Budget Manager profile and who are either the div manager, div accountant, responsible person, entity manager or acting for may have access to tabs 2 and 3 for the entities for which they are responsible or users with the Budget Customer Scheduler or Budget Purchases Scheduler profiles may have access to tab 1 for the scheduled lines - i.e. entities with purchases or sales schedules. The latter 2 profiles are not dependant on the position held in the company.

6 Profiles exist that are role independent.

The owner of the Budget Overview Profile Contract may view all Contract budget information on all three tabs.

The owner of the Budget Overview Profile Capital may view all Capital budget information on all three tabs.

The owner of the Budget Overview Profile Cost Centre may view all Cost Centre budget information on all three tabs.

The owner of the Budget Overview Profile Division may view all Division budget information on all three tabs.

The owner of the Budget Overview Profile Project may view all Project budget information on all three tabs.

The owner of the Budget Overview Profile Own Funded may view all Own Funded budget information on all three tabs.

On this tab the following fields can be viewed:

The 'exclude zero rows' does exactly that - a row with zero values in the entire row (for the entire display range) will be excluded from the displayed results. These check box options allow the user to display the various amount types namely, Actual costs, planned commitments, released commitments, budgeted costs - or as all costs;

If 'labour/material split' is checked, each of these costs is seen separately.

Actual sales, actual additional cost sales and actual credit sales - or as all actual sales; Actual purchases, actual additional cost purchases, actual credit purchases - or as all actual purchases;

Budgeted sales, budgeted additional cost Sales, budgeted credit sales - or as all budgeted sales;

budgeted purchases, budgeted additional cost purchases, budgeted credit purchases - or as all budgeted purchases;

If 'payment split' is checked, it displays the amount types per the following : Final, progress, retention and escalation. Prepayments for purchases and Advance for Sales is always separated from the other amount types. The Advance payments (under Actual Sales) includes the advance payment credits.

The Advance payments (under Actual Sales) includes the advance payment credits.

This field populates with valid baselines of the budget id selected and is enabled. Selection of this field is mandatory. The GO TO / F7 jumps to Baseline on the Baseline tab of the Budget Administration function from the Baseline field.

This field populates with budget type of the budget id selected. Selection of this field is mandatory. The GO TO / F7 jumps to Budget type on the Budget Types tab of the Budget maintenance function from the budget type field.

This field populates with the applicable end date of the budget id selected and is disabled.

This field displays all the existing budget ids. It is enabled and mandatory. The GO TO / F7 jumps to Budget id on the Budget header tab of the Budget function from the budget id field.

This field populates with the applicable start date of the budget id selected and is disabled.

Once the entity type has been selected, this field is enabled. The user may select the valid entities populated as per the parameters selected. It is enabled and not mandatory.

Once the baseline has been selected, this field is populated. The user may select the valid entity types as per the budget type selected. Nodes and accounts may be linked to Capital and Own funded budgets. Order and accounts may be linked to Contract budgets. Only accounts may be linked to cost centre and division budgets. Only nodes may be linked to Project budgets. It is enabled and not mandatory.

The GO TO / F7 jumps to Node / Order Master / Accounts functions from the Budget Entity Type field where this is either, node, order or account.

These fields populate with the applicable start and end dates on the budget header for the budget selected, but may be changed. The range is limited by the planned start and end dates of the budget id. These fields are mandatory.

The grid displays the entity key and its description and then proceeds to display the values as per the general parameters selected and as per the amount types selected in the parameters in the rows following. The totals of each amount type are displayed per entity, dependant on the parameters selected - i.e if none of the sales options is selected, no totals for sales will

appear, but the totals for actual purchases, actual prepayments, budget purchases, budget prepayments will be displayed per entity and the grand totals of these will appear at the bottom of the grid.

This button displays the data as per the parameters selected and as per the profiles and role in the company.