Shop Floor Control - Cost Variance Analysis Report

 

Function

Use this report to analyze the difference between standard and actual costs in operations, materials, and subcontracts. It is useful in adjusting standard labor hours, tracking the performance of shop labor and production management, and in analyzing the sources of labor variances. A minimum variance can be selected and displayed and you have the option to only include those items that involved a cost overrun. 

 

=>To access this menu...

Select Cost Variance Analysis Report from the Reports menu

 

Cost Variance Analysis Report

 

About the Fields

 

From the Report Sequence dropdown...

  • Work Order (W) to sort the report by work order number.

  • Work Order Type (T) to sort by work order type.

  • Bill Number to sort by bill number.

  • Customer ID to sort by customer number.

In the Beginning/Ending Work Order Number field...

This field is active when the Report Sequence Work Order (W) has been selected.

  • Enter the first/last number/code with which to begin the report.

  • Press [Tab] or [Return] to use the first/last number available .

  • Click Find Field Records button to select from a list of all valid work order numbers.

The requested information differs depending on what you entered in the Selected Report Sequence field. For Work Order, enter the lowest work order number that is to appear on the report. For Work Order Type, enter the lowest work order type code that is to appear on the report. For Customer ID, enter the lowest customer number that is to appear on the report. For Bill  Number, enter the lowest item code that is to appear on the report. Numbers sort before letters.

 

In the Beginning/Ending Work Order Type field...

This field is active when the Report Sequence Work Order Type (T) has been selected.

  • Enter the first/last work order type code to begin the report.

  • Press [Tab] or [Return] to use the first/last work order type.

  • Click Find Field Records button to select from a list of all valid work order types.

In the Warehouse ID field...

This field is active when the Report Sequence Bill Number has been selected.

  • Enter the warehouse ID for the report.

  • Click Find Field Records button to select from a list of all valid warehouse IDs.

In the Beginning/Ending Bill of Materials Number field...

This field is active when the Report Sequence Bill Number has been selected.

  • Enter the first/last bill of materials number to begin the report.

  • Select the [Tab] or [Return]  keys to use the first/last bill of materials record.

  • Click Find Field Records button to select from a list of all valid bill of material numbers.

In the Beginning/Ending Customer ID field...

This field is active when the Report Sequence Customer ID has been selected.

  • Enter the first/last customer ID to begin the report.

  • Select the [Tab] or [Return]  keys to use the first/last customer ID record.

  • Click Find Field Records button to select from a list of all valid customer ID records.

In the As of Date field...

  • Enter the closing date to calculate cost variances.

  • Clear the field to include all dates.

  • Click Calendar button to use the tool to select the date.

  The report will calculate the variance in the work orders as of the date entered at this prompt.

 

Checkboxes…

Select any combination of the following:

  • Mark Open? to create a report for open work orders.

  • Mark Closed? to create a report for closed work orders.

In the Minimum Variance % field...

  • Enter the minimum variance percent to report. The percentage entered represents the amount over or under cost allowed. Anything outside of these criteria will be included in the report.

Include Cost Overrun Only checkbox…

  • Mark the box to select only positive variances.

  • Unmark the box to select positive and negative variances.

When finished making entries to the fields…

  • Click Save button to save the selections.

  • Click Clear Form button to clear the form and begin again.

  • Click Run Process button to run the report.

Sample Cost Variance Analysis Report

 

See Output Options.



______________________________________________________________________________________

Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.