Summary Section

The Summary section of the Cost Variance Analysis page includes the work order information, Cost Category subtab, Component subtab, and Conversion Costs subtab. You can sort the column values in any subtab.

You'll be directed to the Summary section if you've picked a work order in the Filters section. Else, click the work order number in the Work Order Summary section to get there.

Note:

The following points are applicable to the Cost Category, Component, and Conversion Costs subtabs:

Only the variance and variance percentage with value other than zero are highlighted.
Positive variance is highlighted in red.
Negative variance is highlighted in green.

The table below explains the work order information fields.

Field	Description
Subsidiary	Subsidiary name of the work order.
Bill of Materials	Bill of Materials of the work order.
Bill of Materials Revision	Revision version of the bill of materials.
Manufacturing Routing	Manufacturing routing associated with the work order.
Actual Start Date	Actual production start date of the work order.
Actual End Date	Actual production end date of the work order.
Planned Build Quantity	Quantity to be built for the work order. If the planned build quantity is zero, the planned cost per unit is empty.
Actual Built Quantity	Build quantity of the selected work order. If the actual built quantity is zero, the are empty.
Build Quantity Variance	Difference between the planned build quantity and the actual build quantity of the work order.
Work Order Status	Status of the work order.
Planned Cost	Planned cost for completing the work order. If the planned cost is zero and the actual cost is non-zero, the cost variance percentage is 100%.
Actual Cost	Actual cost for completing the work order. If the planned cost is zero and the actual cost is non-zero, the cost variance percentage is 100%.
Cost Variance	Cost difference between actual cost and planned cost of the work order.
Cost Variance (%)	Percentage of cost variance per planned cost of the work order.
Planned Cost per Unit	Planned cost per unit for completing the work order.
Actual Cost per Unit	Actual cost per unit for completing the work order
Cost Variance per Unit	Cost difference between actual cost per unit and planned cost per unit.

Field

Description

Subsidiary

Subsidiary name of the work order.

Bill of Materials

Bill of Materials of the work order.

Bill of Materials Revision

Revision version of the bill of materials.

Manufacturing Routing

Manufacturing routing associated with the work order.

Actual Start Date

Actual production start date of the work order.

Actual End Date

Actual production end date of the work order.

Planned Build Quantity

Quantity to be built for the work order. If the planned build quantity is zero, the planned cost per unit is empty.

Actual Built Quantity

Build quantity of the selected work order. If the actual built quantity is zero, the are empty.

Build Quantity Variance

Difference between the planned build quantity and the actual build quantity of the work order.

Work Order Status

Status of the work order.

Planned Cost

Planned cost for completing the work order. If the planned cost is zero and the actual cost is non-zero, the cost variance percentage is 100%.

Actual Cost

Actual cost for completing the work order. If the planned cost is zero and the actual cost is non-zero, the cost variance percentage is 100%.

Cost Variance

Cost difference between actual cost and planned cost of the work order.

Cost Variance (%)

Percentage of cost variance per planned cost of the work order.

Planned Cost per Unit

Planned cost per unit for completing the work order.

Actual Cost per Unit

Actual cost per unit for completing the work order

Cost Variance per Unit

Cost difference between actual cost per unit and planned cost per unit.

Note:

The following points are applicable to number of records that you can see in the cost variance analysis summary report:

The SuiteApp supports a maximum of 5000 work order completions in a single work order.
If you have multiple manufacturing operations, the SuiteApp supports up to 1500 work order completions with 100 manufacturing routing operations in a single work order.
You can only display up to 150,000 records with the combination of work order completions and manufacturing routings in the cost variance analysis summary report. For example, if you have 1500 completions and 100 routing operations in one work order, you'll see 150,000 records (1500*100).
The SuiteApp supports a maximum of 1000 different work orders in the work order summary report.

If the data exceeds the above-mentioned limits, the SuiteApp will show zero value in the Conversion Costs subtab for further routing operations. Also, the actual cost and actual cost per unit will be zero in the cost variance analysis Summary section.

Related Topics