BMITMVRS Bill of Material Production Cost Variance Report

Production Cost Variance Report

Application Overview

The Production Cost Variance Report prints the cost variance between planned cost and actual production cost for selected items.  Planned production cost is calculated based on the routing for each work order, while the actual production cost is gathered through reporting.  The report provides the scrap percentage for each selected item. 

 

The report can be sorted by item, product category, customer or job.  When sorted by item, you can print a summary or the order detail of each item.  When sorted by product category, you can print the category summary, item summary or order detail for each selected item.  If work orders were copied from COP and you want to know the production cost variance for each customer, you can sort the report by customer.  If you use job numbers for work orders, you can print cost variance by job number.

 

The report only includes completed production work orders and you can select orders by complete date, location, work order number, parent item number, product category, customer number and job number.

Run Instructions

Main Menu è Distribution è Bill of Material Processor è Reports è Production Analysis Report è Print è Production Cost Variance Report

 

 

Production Cost Variance Selection Screen


Entry Field Descriptions

 

Name

Type and Description

Starting Complete Date

Standard date format.

Enter the starting complete date for a range of production work orders to print on the report.  The complete date of a work order is the last transaction date of the order. 

Defaults to All.

Ending Complete Date

Standard date format.

Enter the ending complete date for a range of production work orders to print on the report.

Defaults to the starting complete date.

Location

2 alphanumeric characters.

Enter the location for a range of production work orders to print on the report. This field supports a wild card format.

Defaults to All.

Starting Order No

6 numeric digits

Enter the starting order number for a range of production work orders to print on the report.

Defaults to All.

Ending Order No

6 numeric digits.

Enter the ending order number for a range of production work orders to print on the report.

Defaults to the starting order number.

Starting Item No

15 alphanumeric characters.

Enter the starting product number for a range of production work orders to print on the report.

Defaults to All.

Ending Item No

15 alphanumeric characters.

Enter the ending product number for a range of production work orders to print on the report.

Defaults to the starting item number.

Starting Product Category

3 alphanumeric characters.

Enter the starting product category for a range of production work orders to print on the report.  Press the F1 Key to select products without a product category.

Defaults to All.

Ending Product Category

3 alphanumeric characters.

Enter the ending product category for a range of production work orders to print on the report. 

Defaults to the starting product category.

Starting Customer

6 alphanumeric characters.

Enter the starting customer number for a range of production work orders copied from COP.  Press the F1 Key to select work orders not copied from COP only.

Defaults to All.

Ending Customer

6 alphanumeric characters.

Enter the ending customer number for a range of production work orders copied form COP.

Defaults to the starting customer number.

Starting Job No

6 alphanumeric characters.

Enter the starting job number for a range of production work orders to print on the report.  Press the F1 Key to select work order without a job number only.

Defaults to All.

Ending Job No

6 alphanumeric characters.

Enter the ending job number for a range of production work orders to print on the report.

Defaults to the starting job number.

Sort By

1 alphanumeric character.

Valid entries are:

I       - By item number.  The sorting sequence is item number and order number.

P      - By product category.  The sorting sequence is category, item number and order number.

C      - By customer number.  The sorting sequence is customer number, category, item number and order number.

J       - By job number.  The sorting sequence is job number, item number and order number.

Enter the sorting sequence for the report.  Based on the sorting sequence, you can choose different print formats.

Defaults to I.

Print Format

1 alphanumeric character.

Valid entries are:

S      - Item/Category/Customer/Job summary, depending on the sort sequence.

C      - Category summary.  Only available when the sort sequence is C.

I       - Item summary.  Only available when the sort sequence is P, C or J.

D      - Order detail.  Print all work orders for selected items.

Enter the print format for the report.  This determines the detail level of the report.

Defaults to S.

Show Estimate Variance?

Y or N.

Enter Y to print the variance, even if the variance is estimated.  By selecting Y, the report will reveal the variance fields available.

Defaults to N.

 

 

 

Production Cost Variance Selection Screen

 

 


 

 

 

 

 

 

Exception Report

Application Overview

The Exception Report prints all exception records.  Exception records are created when the user performs exception handling functions.  These functions can be modifying time clock data, canceling a production, reassigning a job or changing a routing.

 

Each exception record has a severity level ranging from zero, for the least severe, to nine, for the most severe, and is assigned based on the impact to the system.  For example, changing time clock data where the time has already been distributed to a posted production transaction would create a data integrity issue and the system will assign 9, the highest severity level, to this exception record.

Run Instructions

Main Menu è Distribution è Bill of Material Processor è Reports è Production Analysis Report è Print è Exception Report

 

 

Exception Report Selection Screen

 

Entry Field Descriptions

Name

Type and Description

Starting Severity Level

1 numeric digit.

Enter the starting severity level for a range of exception records to print.  The range can be from 0 to 9.  Zero is the least severe and nine is the most severe.

Defaults to 0.

Ending Severity Level

1 numeric digit.

Enter the ending severity level for a range of exception records to print.  The range can be from 0 to 9.  Zero is the least severe and nine is the most severe.

Defaults to 9.

Starting Operator ID

10 alphanumeric characters.

Enter the starting operator ID for a range of exceptions for the selected operators.   Press the F1 Key to select exceptions not assigned to an operator.

Defaults to All.

Ending Operator ID

10 alphanumeric characters.

Enter the ending operator ID for a range of exceptions for the selected operators.

Defaults to the starting operator ID.

Starting Date

Standard date format (MM/DD/YY).

Enter the starting date when the exceptions occurred. 

Defaults to All.

Ending Date

Standard date format (MM/DD/YY).

Enter the ending date when the exceptions occurred.

Defaults to the starting date.

Sort By

1 alphanumeric character.

Valid entries are:

S      - Sort by severity level

T       - Sort by time

Enter the sort method for the report.

Defaults to S.

Print Detail

Y or N.

Enter Y to print additional details for each exception record.

Defaults to N.

 

 


 

Exception Report Selection Screen

 

 

 

Exception Report

Feedback and Knowledge Base