Bill Material and Work Order Processing BMITMVRS Help - Elliott Business Software


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

 

 

(Figure 68) 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.

 

 

 

(Figure 71) 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

 

 

(Figure 73) 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.

 

 

 

(Figure 74) Exception Report Selection Screen

 

 

 

                                   E X C E P T I O N   R E P O R T   B Y   C R E A T E   T I M E

 

Ranges: Severity     0          Thru 9

        All Operators

        All Dates

 

Level Exception-Time Subject                        Reporter   Override   Filename Reference-No                   Exception-No

 

  0   08/17/10 11:51 Force Logoff                   FRANK      FRANK      SYTIMCLK 000000079                      000000081

      08/24/10 16:52 Change Production Detail       SAM        FRANK      BMPRDHDR 000000070                      000000096

  5   05/25/10 13:22 Reassign Production            SAM        FRANK      BMPRDHDR 000000059                      000000039

  6   09/02/10 17:33 Remove Time Clock              SAM        CHRIS      SYTIMDTL 000000015                      000000121

  7   09/01/10 13:08 Cancel Activity                SAM        FRANK      BMACTHDR 000000064                      000000106

  8   09/15/10 16:22 Remove Time Clock              SAM        WILL       SYTIMDTL 000000062                      000000218

 

                     Total           6 Exceptions Printed

 

 

 

(Figure 75) Exception Report Selection Screen



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile