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 each of the subtabs.

You will be navigated to the Summary section directly only if you have selected a work order in the Filters section. Else, you can go to this section by clicking on the work order number in the Work Order Summary section.

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 will be highlighted.
Positive variance is highlighted in red.
Negative variance is highlighted in green.

The following table provides details about 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 will be empty.
Actual Built Quantity	Build quantity of the selected work order. If the actual built quantity is zero, the actual cost per unit and cost variance per unit will be 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 will be 100%.
Actual Cost	Actual cost when completing the work order. If the planned cost is zero and the actual cost is non-zero, the cost variance percentage will be 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 will be empty.

Actual Built Quantity

Build quantity of the selected work order. If the actual built quantity is zero, the actual cost per unit and cost variance per unit will be 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 will be 100%.

Actual Cost

Actual cost when completing the work order. If the planned cost is zero and the actual cost is non-zero, the cost variance percentage will be 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 can be displayed in the cost variance analysis summary report:

The SuiteApp supports a maximum of 5000 work order completions in a single work order.
If there are multiple manufacturing operations involved, the SuiteApp can support up to 1500 work order completions with 100 manufacturing routing operations in a single work order.
Only 150000 records can be displayed with the combination of work order completions and manufacturing routings in the cost variance analysis summary report. For example, if we have 1500 work order completions with 100 manufacturing routing operations in a single work order, 150000 records (1500*100) will be displayed.
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