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

Bill of Material / Work Order Plus

  1. BM0000 Bill of Material Package Overview
  2. What Is Work Order Plus And Where Can I Find The Documentation
  3. Work Order Plus Questions and Answers
  4. How to Reverse Plus Work Order Production Entries
  5. Planning Lead Time by Calendar Days or Work Days?
  6. How to See Cost in BOMP Plus Work Order Production History Report
  7. How to Close Plus Work Order
  8. Why I Received "Nothing In Range" with Plus Work Order Printing
  9. Receive "Trx Not Complete" on BOMP Production Edit List/Journal
  10. Feature - Trap Bad Date/Timestamp on Time Clock
  11. Feature - Enhanced Production Routing File Bill of Material Screen
  12. Print Plus Work Order Menu Option Is Missing
  13. Feature - Item Last Received Date to Include BOMP Production Activity
  14. BM01S1 Bill of Material Audit Trail Report
  15. BM23S1 Bill of Material Set Component Activity Flags
  16. BM24S1 Bill of Material Resequence Component Items
  17. BM26S1A Bill of Material Copy COP Orders into BOMP
  18. BM27S1 Bill of Material Purge Complete Production Orders
  19. BM29S1 Bill of Material Post Engineering Changes
  20. BM30S1 Bill of Material Engineering Change History Report
  21. BM32S1 Bill of Material Job Distribution History Report
  22. BM33S1 Bill of Material Option Item Where-Used Report
  23. BM0100 Bill of Material Product Structure File Maintenance
  24. BM0200 Bill of Material Single Level Bill of Material Inquiry
  25. BM0300 Bill of Material Indented Bill of Material Inquiry
  26. BM0400 Bill of Material Single Level Where-Used Inquiry
  27. BM0500 Bill of Material Single Level Bill of Material
  28. BM0600 Bill of Material Indented Bill of Material Report
  29. BM0700 Bill of Material Single Level Where-Used Report
  30. Feature - BOMP Integrity Check Utility
  31. BM0800 Bill of Material End Item Where-Used Report
  32. BM0900 Bill of Material Summarized Bill of Material Report
  33. BM1000 Bill of Material Print Costed Bill of Material
  34. BM1100 Bill of Material Gross Requirements Report
  35. BM1200 Bill of Material Print Picking List by Bill
  36. BM1300 Bill of Material BOMP Setup
  37. BM1400S1 Bill of Material Reset Low Level Codes
  38. BM1501 Bill of Material Feature/Option Configuration Maintenance
  39. BM1601 Bill of Material Feature/Option Configuration Inquiry
  40. BM1700 Bill of Material Production Order Entry
  41. BM1800 Bill of Material Production Transaction Processing
  42. BM1900 Bill of Material Post Production Transactions
  43. BM2000 Bill of Material Print Production Work Orders
  44. BM2101 Bill of Material Job Code File Maintenance
  45. BM2201 Bill of Material Issue Serial/Lot Component Item
  46. BM2801 Bill of Material Engineering Change Processing
  47. BM3100 Bill of Material Production Transaction History Report
  48. BMDPTMNT Bill of Material Department Maintenance
  49. BMDISCN Bill of Material B/M Distribution Report
  50. BMDPTIME Bill of Material Department Time Clock
  51. BMINQMNU Bill of Material Work Order Inquiry
  52. BMITMVRS Bill of Material Production Cost Variance Report
  53. BMLABMNT Bill of Material Labor Grade
  54. BMOIDMNT Bill of Material Operation ID
  55. BMPRDANL Bill of Material Labor Performance Report
  56. BMRTGMNU Bill of Material Production Routing
  57. BMSCHSCN Bill of Material Production Schedule Report
  58. BMSPCMNT Bill of Material Special Operation
  59. BMWCMNT Bill of Material Work Center Maintenance
  60. BMWCTIME Bill of Material Work Center Time Clock
  61. BMWIPSCN Bill of Material WIP Report
  62. BMWOPROD Bill of Material Work Order Production
  63. BMWORSCN Bill of Material Production History Report for WO+
  64. Feature - Option to Control if Item Last Received Date Is Updated from BOMP
  65. I Can Not Delete Some BOMP Work Orders
  66. Feature - BOMP Work Order Entry - F3=Copy COP Ord Function Improvement
  67. Feature - BOMP Plus WO Inquiry Detail Screen to Display Avg Dir Labor Time in HH:MM:SS Format
  68. Feature - Gross Requirements Report Item/Qty CSV Import
  69. Feature - Gross Requirements Report COP Order Import
  70. Feature - Component Qty Calculation Options In F3 Copy Function in BOMP WO Entry
  71. Plus Work Order Transaction Can't Post
  72. Feature - Production Routing File Maintenance - Show Material Cost for Std, Avg, and Last Cost
  73. Some Users Do Not Have Right for F3=Detail or F5=Order Prod Option in Plus Work Order Inquiry
  74. Feature - Print Kit Parent on Work Order
  75. Feature - Transfer Batch on Material Work Order Inquiry Screen
  76. Feature - Print User Name and Transfer Batch Status on Work Order
  77. Feature - Show “Active” Operators in Operator File Inquiry
  78. Feature - Transfer Batch on Plus Work Order Inquiry Screen
  79. Feature - Ability to Start a Material Work Order
  80. Feature - Drill Down to Where Used from Stock Status Inquiry Screen
  81. Feature - Allow User to Choose Time Format on Plus Work Order Traveler (BM20P3T)
  82. Feature - Material Work Order Copy Product Structure
  83. Feature - Plus Work Order Copy Product Structure
  84. Freezing When Printing Costed Bill of Materials
  85. Feature - Create Material Shortage Tracking with Plus Work Order
  86. Close Work Order With Quantity That Is Not Fully Reported
  87. Feature - Disable Print Costed Bill of Material to Update Parent Cost
  88. Feature - Item Selection in Cost Master Maintenance
  89. Feature - Plus WO Operation Number Default Increment
  90. Feature - Print Totals on Material Production History Report
  91. Feature - Print Total Quantity Order/Completed on the Production Schedule Report
  92. Feature - Add Default for Material Pick List, "Print By Pick Sequence"
  93. Feature - Allow Password to be Required to Update Parent Cost in Inventory
  94. Feature - Production Time Not Captured Report
  95. Feature - Add "Related Quotes" Option to Where-Used Inquiry
  96. Feature - Allow Export to CSV File for End Item Where-Used Report
  97. Feature - Allow End Item Where-Used to Select Items Based on CSV File

Feedback and Knowledge Base