Job Variance

Work in Progress > Reports > Job Variance

Job Variance

You use this program to generate a list of jobs with variances between their expected Work in Progress costs and their actual material and labor costs.

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.

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 other sub jobs are attached).

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 prints quantities in the manufacturing unit of measure, providing that this is configured against the relevant stock items and you selected to use this unit of measure in the bill of materials. Otherwise quantities are printed in the stocking unit of measure.

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.