Field descriptions: Work in progress inquiry

This page describes the fields for the Work in progress inquiry page. The fields in each section are listed in alphabetical order.

Criteria block

Field Description
As of date The work in progress inquiry date. The current date is the default date. You can select an earlier date or a later date.
Site The production site name.

Results grid

Field Description
Work in progress total

The cumulative total of the tracked production costs (material costs and process costs) for the work orders in the Results grid at the selected As of date.

Field Description

Actual machine cost

Actual labour cost

Actual tool cost

The work order actual cost total for the individual resource type.

This is the total of the actual setup time cost for the resource type plus the total of the actual run time cost for the resource type.

Actual material cost

The sum of the tracked consumed component costs (from the work order component Actual cost fields).

Actual process cost

The sum of the tracked operation costs (from the work order operation Actual cost fields).

This is the total of the Actual machine cost plus the Actual labour cost plus the Actual tool cost.

You can view the total work order Actual Process cost in the work order Planned versus actual block.

Closing variance

The difference between the actual and planned work order production costs total on the work in progress inquiry date. The variance can be a positive or a negative amount and is displayed to 2 decimal places. It is only displayed after the work order is closed.

Item ID

The released item code.

Item name

The work order released item name.

The released item is defined as a bill of material.

Machine cost variance %

Labour cost variance %

Tool cost variance %

The difference between the actual and planned work order resource cost totals for the resource type, as a percentage. The percentage is displayed to 2 decimal places.

Machine cost variance

Labour cost variance

Tool cost variance

The difference between the actual and planned work order resource cost totals for the individual resource type.

The variance is the Actual machine/labour/tool cost minus the Planned machine/labour/tool cost.

Material cost variance

The difference between the actual and planned work order component costs.

The variance is the Actual material cost minus the Planned material cost.

Material cost variance %

The difference between the actual and planned work order component costs, as a percentage. The percentage is displayed to 2 decimal places.

Planned machine cost

Planned labour cost

Planned tool cost

The work order planned cost total for the individual resource type.

This is the total of the expected setup time cost for the resource type plus the total of the expected run time cost for the resource type.

Planned material cost

The sum of the planned component costs (from the work order component Planned cost fields).

Planned process cost

The sum of the planned operation costs (from the work order operation Planned cost fields).

This is the total of the Planned machine cost plus the Planned labour cost plus the Planned tool cost.

You can view the total work order Planned Process cost in the work order Planned versus actual block.

Process cost variance

The difference between the actual and planned total work order operation costs.

The variance is the Actual process cost minus the Planned process cost.

Process cost variance % The difference between the actual and planned work order operation cost totals, as a percentage. The percentage is displayed to 2 decimal places.
Status The current work order status or progress of the work order.
Status

The current work order status or progress of the work order.

Pending: The work order is awaiting tracking.

In progress: One or more components, operations or released items are tracked for the work order. If the work order has been created directly from the bill of material, you might need to progress the related tracking documents that are not yet posted. You can view the list of related tracking documents and their posted status in the Trackings grid.

Completed: The work order is complete. All components, operations and released items are tracked in full. You can still edit the work order.

Closed: The work order is complete. Production has ceased and the work order is closed.

Total actual cost

The current tracked production costs total.

This is the total of the Actual material cost plus the Actual process cost.

You can view the work order Total Cost in the work order Planned versus actual block.

Total planned cost

The planned production costs total.

This is the total of the Planned material cost plus the Planned process cost.

You can view the work order Total Cost in the work order Planned versus actual block.

Total variance

The difference between the actual and planned work order production costs total.

The variance is the Total planned cost minus the Total actual cost.

Work in progress total

The total of the tracked production costs (material costs and process costs) for the work order.

Work order

The work order reference and link to open the work order.