Work in Progress > Reports > Job Variance

Job Variance

You use this program to generate a list of selected jobs against which variances between the expected and actual material and labor costs are encountered.

Report Options

Field Description
Sequence  
Job Select this to generate the report in job number sequence.
Job classification Select this to generate the report in job classification sequence.
Values by  
Notional part Select this to print the job variances for each notional part.
Co-product Select this to list each co-product together with its job variance value.
Include  
Sub jobs under master jobs Select this to print details for jobs occurring at all levels within a job structure.
[Note]

Sub job totals will be excluded from the report.

On the report, the <mast> field indicates that the job is a master job; the <sub> field indicates that the job is a sub job; and the <int> field indicates an interim job (i.e. a sub job to which is attached other sub jobs).

Completed jobs only Select this to print details for completed jobs only.
Jobs on hold  
Include Select this to include jobs on hold.
Exclude Select this to exclude jobs on hold.
Only Select this to only include jobs on hold.
Expected cost basis  
Original Select this to generate the report using the original job costs. These are the costs according to the bills of materials for the jobs.
Current Select this to generate the report using the current costs of the jobs.

The current cost of a job would typically differ from the original job cost if you maintained the job and changed the material and or labor allocations.

Print manufacturing u/m quantities This applies if you are using Manufacturing unit of measure (WIP Setup - General 2 tab). In addition, you need to have defined a Manufacturing unit of measure for the relevant stock items (Stock Code Maintenance) and used the Manufacturing unit of measure in the Bills of Materials.

Select this to print the manufacturing unit of measure for the quantities on the report.

If you do not select this option, then the stocking unit of measure for the quantities is printed.

Selection criteria

Field Description
Job selection Indicate the job(s) for which you want to generate the report.
Completion date Indicate the completion date(s) for which you want to include jobs in the report.
Job classification Indicate the job classes for which you want to include jobs in the report.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

A positive variance indicates that the actual cost of the job is less than the anticipated costs, and vice versa.

When you use Standard costing, the transaction value to post is always calculated using the standard cost defined against the warehouse. The apportionment of the transaction value between material costs and labor costs is done as follows: All material costs from the bill of material are accumulated to give the total material cost for the item. This total material cost is subtracted from the transaction value (the standard cost defined against the warehouse) and the difference is then the total labour cost. A WIP variance occurs if the actual material and labor costs for the job differs from the standard cost defined against the item. If the variance is negative, then it indicates that the total material cost is greater than the total transaction cost defined against the warehouse.

Refer to WIP costing with Sub Jobs and Master Jobs for an example of cost calculations for sub and master jobs.