Work Order Plus Advanced Feature Manual 7

Value Added from Routing Report

Application Overview

The Value Added from Routing Report prints the hours and costs from the routings of each manufactured item.  These values are calculated based on the current setup of each routing.  You can review these values before posting to cost master.

 

You can select items by item number, product category, buyer/analyst code, etc. and print each operation in the selected routings.

Entry Descriptions

(Figure 38) Value Add From Routing Report Selection Screen

 

Name

Type and Description

Starting Item No

15 alphanumeric characters.

Enter the starting item number for a range of cost masters to update.  Press the F7 Keyto search for an item by item number or press the F8 Key to search for an item by item description.

Defaults to All.

Ending Item No

15 alphanumeric characters.

Enter the ending item number for a range of cost masters to update.  Press the F7 Keyto search for an item by item number or press the F8 Key to search for an item by item description.

Defaults to the starting item number.

Starting Product Cat

3 alphanumeric characters.

Enter the starting product category for a range of cost masters to update.  Press the F7 Key to search for an existing product category.  Press the F1 Key to select items that have no product category only.

Defaults to All.

Ending Product Cat

3 alphanumeric characters.

Enter the ending product category for a range of cost masters to update.  Press the F7 Key to search for an existing product category.  Press the F1 Key to select items that have no product category only.

Defaults to the starting product category.

Buyer Code

2 alphanumeric characters.

Enter the buyer/analyst code for a range of cost masters to update.  Press the F7 Key to search for an existing product category.  Press the F1 Key to select items that have no buyer code only.

Defaults to All.

Material Cost Type

2 alphanumeric characters.

Enter the material cost type for a range of cost masters to update.  Press the F7 Key to search for an existing material cost type.  Press the F1 Key to select items that have no material cost type only.

Defaults to All.

Print Obsolete Cost Master?

Y or N.

Enter Y to include obsolete items.

Defaults to N.

Print Default Routing Only?

Y or N.

Enter Y to print the default routing of each item only.  Enter N to print every routing of each item.

Defaults to Y.

Print Summary or Detail?

1 alphanumeric character

Valid entries are:

S      - Summary.  One routing per line.

D      - Detail.  Print every operation of each routing.

Enter the detail level for this report.

Defaults to S.

Compare To Current?

Y or N.

Enter Y to compare the selected routing to current values in the cost master.  Select Yand you will be able to select routings by variance percentage.

Defaults to N.

Select V/A Total Var Pct

1 alphanumeric entry and 2 variance percentage entries.  The variance percentage entries have 3 digits and 2 decimals.

Valid entries are:

N      - No selection

O      - Only positive variance

U      - Only negative variance

B      - Both positive and negative variance

Enter whether to select records based on the value added cost variance percentage.  If O, U or B is selected, a percentage range, from 0 to 999.99, is required.

Defaults to N.


 



(Figure 39) Value Add From Routing Report

 

 

Cost Explosion Report

Application Overview

The Cost Explosion Report prints a number of cost levels for each selected parent item, breaking it down into component amounts and value added amounts from routings for each level.

 

You can select items by item number, product category, buyer/analyst code, etc. and print current value or standard value.  The value added cost or total cost can be printed in single level or multi-levels as well.  It offers the option of blowing through phantom items (non-stocked, non-controlled component items) to print the components of the phantom item in place of the phantom item itself.

Entry Descriptions

(Figure 40) Cost Explosion Report Selection Screen

 

Name

Type and Description

Starting Item No

15 alphanumeric characters.

Enter the starting item number for a range of cost masters to update.  Press the F7 Keyto search for an item by item number or press the F8 Key to search for an item by item description.

Defaults to All.

Ending Item No

15 alphanumeric characters.

Enter the ending item number for a range of cost masters to update.  Press the F7 Keyto search for an item by item number or press the F8 Key to search for an item by item description.

Defaults to the starting item number.


 

Starting Product Cat

3 alphanumeric characters.

Enter the starting product category for a range of cost masters to update.  Press the F7 Key to search for an existing product category.  Press the F1 Key to select items that have no product category only.

Defaults to All.

Ending Product Cat

3 alphanumeric characters.

Enter the ending product category for a range of cost masters to update.  Press the F7 Key to search for an existing product category.  Press the F1 Key to select items that have no product category only.

Defaults to the starting product category.

Buyer Code

2 alphanumeric characters.

Enter the buyer/analyst code for a range of cost masters to update.  Press the F7 Key to search for an existing product category.  Press the F1 Key to select items that have no buyer code only.

Defaults to All.

Material Cost Type

2 alphanumeric characters.

Enter the material cost type for a range of cost masters to update.  Press the F7 Key to search for an existing material cost type.  Press the F1 Key to select items that have no material cost type only.

Defaults to All.

Manufacture or Purchase

1 alphanumeric character.

Valid entries are:

M      – Manufactured item only

P      – Purchased item only

B      – Both

Defaults to B.

Print Obsolete Cost Master?

Y or N.

Enter Y to include obsolete items.

Defaults to N.

Current or Standard Cost?

1 alphanumeric character

Valid entries are:

C      - Current value

S      - Standard value from last roll-up

Defaults to C.


 

Print Total Cost or Value Add?

1 alphanumeric character.

Valid entries are:

T      - Total Cost

V      - Value Add Cost

Enter T to print the total cost of each component.  Enter V to print the value added cost of each component.

Defaults to T.

Single/Indented(Multi-Level)?

1 alphanumeric character.

Valid entries are:

S      - Single level for components.

I       - Indented multi-levels for components.

If printing total cost, defaults to S.  If printing value added, defaults to I.

Blow Through Phantom Item?

Y or N.

Component items, which are neither stocked nor controlled, 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.  This option is only available if printing multi-levels.  Otherwise, “N/A” will be displayed.

Defaults to N.

Page Break for Each Parent Item?

Y or N.

Enter Y to start a new page for each parent item.

Defaults to Y.

 

 


(Figure 41) Cost Explosion Report


Feedback and Knowledge Base