Work Order Plus Advanced Feature Manual 1

Work Order Plus provides several utilities to calculate standard cost, export routing from Standard Product Routing and recover order transaction level statistics.

Print Costed Bill of Material

Application Overview

Print Costed Bill Of Material prints a selected range of parent items and "rolls up" the costs from the costs of their components. There is an option to print the variance between the parent item cost on file and the cost calculated from the components. You can select to print active items, obsolete items and forecasted items.

As the costs are calculated from the bill of material, the sub-assembly costs are calculated if they are flagged as manufactured. It will not calculate, or explode through, any purchased inventory items, regardless of whether the items are flagged as stocked or non-stocked. Flagging a sub-assembly as a purchased item is an error in the product structure and may be corrected using the Product Structure File Maintenance application.

In Elliott 7.5, the report can include costs from routing, like labor cost, overhead and outside processes. It will calculate based on the default routing in the item master file. If the item does not have a default routing or the default routing does not exist, it will roll up bill of material only.

An important feature of this application is the ability to update the cost in the Inventory Item File for the range of parent items selected. If the update cost option is chosen, the number of levels to explode will automatically be set to 11. Only parent items' sub-assemblies within the item range defined in fields #1 and #2 will have their costs updated. To avoid excluding any sub-assemblies, set the item range to All.

It also offers the option to include components' scrap factor in the calculated cost for each.

Run Instructions

Select Print Costed Bill Of Material from the pull down BOMP Processing window. The following screen will be displayed:

Image: https://elliott.uservoice.com/assets/192493939/WO%2011.jpg

(Figure 1) Print Costed Bill of Material Selection Screen

The following options are available:

* Select the desired mode from the Print Costed Bill Of Material menu bar

* Enter the data requested on the screen

To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

Entry Field Descriptions

Name	Type and Description
1. Starting Parent Item No	15 alphanumeric characters. Enter the item number of the parent item for which you wish to print a Costed Bill Of Material. Default is All.
2. Ending Parent Item No	15 alphanumeric characters. Enter the item number of the last parent item for which you wish to print a Costed Bill Of Material. Default is the starting parent item number.
3. Reset Low Level Code First?	Y or N. Enter Y to run the “Reset Low Level Code” program to make sure the update sequence is correct before the roll-up. This field defaults to Y if all parent items are selected.
4. Include Routing?	Y or N Enter Y to include routing cost if the selected items have default routing. This field defaults to Y if routing records exist.
5. Print Active Items?	Y or N. Enter Y to print active items This field defaults to Y.
6. Print Forecasted Items?	Y or N. Enter Y to print forecasted items. This field defaults to N.
7. Print Obsolete Items?	Y or N. Enter Y to print obsolete items. This field defaults to N.
8. Print Purchase or Mfg. Items ?	M or B. Enter M to print manufacture item only. Enter B to print both manufacture item and purchase item. This field defaults to N.
9. Blow Through Phantom Items?	Y or N. Component items and subassemblies which are neither stocked nor controlled but are manufactured are known as phantom items. Answering Y to this question allows you to blow through phantom items to the real component items, which are down one level. Default is N.
10. Show Component Cost Variance?	Y or N. Answer Y to print the variance between the calculated cost of the parent item and the cost in the Item File. Default is N.
11. Number Of Levels To Explode?	2 numeric digits The number of levels to explode must be 11 to obtain correct cost. Default is 11.
12. Effectivity Date	A date in the standard date format. Enter the effectivity date to use for printing items. This date will be used to include or exclude items. Leave this field blank to include all items. You will not be prompted to enter this field unless both active and forecasted items have been selected for printing. Default is blank.
13. Reflect Scrap Factor In Cost?	Y or N. Enter Y to include each component's scrap factor in the calculation of the extended cost. Enter N to calculate the extended cost based solely on the quantity required per parent. Defaults to N.
14. Update Parent Cost In Inventory?	Y or N. Answer Y to update the cost in the Inventory Item File for the parent item using the total cost of components for the parent.. Selecting Y will set the number of levels to explode in field #11 to 11. Note: If you set this field to Y but do not select All parent items in field #1, the costs of all sub-assemblies may not be updated. If the costs of all sub-assemblies should be updated, set the parent item range to All. Default is N.
If the costing method defined in I/M Setup is LIFO or FIFO, parent costs may not be updated and field #14 will appear as follows:
14. Cost Type To Display?	Only A, S, or R is allowed. Enter the item cost to use in printing the Costed Bill of Material. A = Average Cost S = Standard Cost R = Last Cost Entry is required. There is no default value.

Image: https://elliott.uservoice.com/assets/192494212/WO%2012.jpg

(Figure 2) Print Costed Bill of Material Selection Screen

Image: https://elliott.uservoice.com/assets/192494368/Costed%20Bill%20of%20Material.png

(Figure 3) Print Costed Bill of Material Report

Work Order Plus Advanced Feature Manual 1

Chapter 1: Utilities