Navigation:  Budget > Budget Account Allocation >

Labour Account Alocation Function

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic

This tab requires the CC Account Allocation and DIV Account Allocation profile. The use of this tab also requires that the user be either the div manager, div accountant, the responsible person, cost centre manager or their acting for, to entitle them to update various budgets.

It affects contract, own funded and project labour budgets and affects node and order entities. Three labour recovery records are created per record (existing in the cost allocation budgets i.e.budget resource allocation and budget resource order line nodes tables) selected in the list box for the selected baseline, cost centre (, resource and employee - non mandatory). The total_amounts are calculated by multiplying the units by the hours and then by either the labour, overhead or fixed overhead rates. These are stored in the Budget Resource Requirements table as Labour resources but when summed per account entity they will become the source for the material account entities on the cost centre budgets.

In addition, labour recovery account entities will be created (in the budget resource allocation table) by summing the total_amounts  per baseline and cost centre selected for that Cost Centre and /or Division budget in the budget resource requirements table.

The budget selected is based on the entity. If the entity is a cost centre account - the cost centre budget will be created/updated, if it is a division account, the division budget will be created/updated.

The accounts entities created are determined as follows :

 

Select from budget_resource_order_line_nodes

Where budget_type_id = 'Contract'

And budget_amount_type = 'Budget'

And Budget_resource_type = 'L'

And budget_entity_type = 'Order'

And budget_order_type = 'Cust'

And order line's line type = 'Nstk'

And node > spaces

And node's recovery = 'Y'

And node.accounts = ''

Sum all these records

         Dr WIP_Project_management_account

with (units * hours * lab/oh/fix oh)

Cr Project Management labour/overhead/fixed overhead account _

with (units * hours * lab/oh/fix oh) * -1

 

Select from budget_resource_order_line_nodes

Where budget_type_id = 'Contract'

And budget_amount_type = 'Budget'

And Budget_resource_type = 'L'

And budget_entity_type = 'Order'

And budget_order_type = 'Cust'

And order line's line type = 'Nstk'

And node > spaces

And (node's recovery = 'N'

Or  node.accounts > '')

 

         Dr Node. labour/overhead/fixed overhead accounts

with (units * hours * lab/oh/fix oh)

Cr Project Management labour/overhead/fixed overhead account _

with (units * hours * lab/oh/fix oh) * -1

 

Select from budget_resource_allocation

Where budget_type_id = 'Project' or 'Own funded'

And budget_amount_type = 'Budget'

And Budget_entity_type = 'Node'

And node's recovery = 'N'

         Dr Node. labour/overhead/fixed overhead accounts

with (units * hours * lab/oh/fix oh)

Cr Project Management labour/overhead/fixed overhead account _

with (units * hours * lab/oh/fix oh)  * -1

 

 

Select from budget_resource_allocation

Where budget_type_id = 'Contract'

And budget_amount_type = 'Budget'

And Budget_resource_type = 'L'

And budget_entity_type = 'Order'

And node = spaces

And budget_order_type = 'Cust'

         Dr WIP_ labour/overhead/fixed overhead cust_ord_account

with (units * hours * lab/oh/fix oh)

Cr Production labour/overhead/fixed overhead account _

with (units * hours * lab/oh/fix oh)  * -1

 

 

Select from budget_resource_allocation

Where budget_type_id = 'Contract'

And budget_amount_type = 'Budget'

And Budget_resource_type = 'L'

And budget_entity_type = 'Order'

And budget_order_type <> 'Cust'

And node = spaces

         Dr WIP_ labour/overhead/fixed overhead internal_order_account

with (units * hours * lab/oh/fix oh)

Cr Production labour/overhead/fixed overhead account _

with (units * hours * lab/oh/fix oh)  * -1

 

On this tab the following fields can be viewed:

 

hmtoggle_plus0Apply        

This button enables the resource requirements to be created / updated for each labour budget record (allocation of labour resources) as per the parameters selected. The recovery budgeting will not be possible if the recovery account entities do not exist for the specified cost centre budget and specified baseline.

hmtoggle_plus0Available Resource Allocations Budgets        

This list box displays all labour budgets as per the selected parameters.

hmtoggle_plus0Cost Centre        

This field populates with existing cost centre budgets for the selected baseline. It is enabled and not mandatory.

hmtoggle_plus0Company Specific Baseline        

This field indicates which baselines are required. If the field is checked, only formal company specified baselines will be available for selection. If the field is unchecked,

only non company specific baselines will be available for selection.

hmtoggle_plus0Display        

By clicking on the button, all budgets as per the parameters selected will be displayed in the list box available for selection.

This helps to identify exactly which budgets are to be updated.

hmtoggle_plus0Employee        

This field populates with all employees budgeted for in labour budgets for the specified cost centre. It is enabled and is not mandatory.

hmtoggle_plus0Fin Period From and To        

These default to the financial periods of the applicable start and applicable end dates of the selected cost centre (budget that exists for the baseline). These fields are

enabled and may be changed within the initial range.

They are mandatory.

hmtoggle_plus0Include Budget Type        

The user may select any combination of budget type contract, own funded or project. Once selected (checked)  all budgets of that type will be included.

hmtoggle_plus0Resource        

This field populates with all resources used in labour budgets for the specified cost centre. It is enabled and is not mandatory.

hmtoggle_plus0Selected Resource Allocation Budget        

This list box displays the labour budgets for which resource requirements and labour recovery account (entity) budgets are to be created.