04.001 - master data - work centers, codes, departments - rev 1

Master Data –Work Cycle Centers, Codes, Departments and more

Revised: June 2013

ScopeThis guide will explain how to create and manage the lookup tables for Work Cycles. These include Work Centers, Work Codes, Departments, Machine Codes, Human Resources and the effective cost lists. Refer to 00.001 – Data Dependencies for a visual of how the tables relate to each other and how they will be used in the Work Cycle.

Manage Tables

All of the lookup tables are accessed thru the Manage Tables function.

Go to the Design MenuThen click on the Manage masters data MenuDouble Click on Manage tables

Under Manage tables select Edit tables

Enter the Table code that you wish to manage.

document.docx of 10Property of Turbocoating Corp. Company Confidential


Revised: June 2013

M0 – Work CentersThis table lists areas where work can be performed on the shop floor. It can also relate a work center to a cost center, however we are currently not using cost centers in ERP. This list has a 1-to-1 relationship with the cost centers provided by the accounting department. It also defines how much to calculate for WIP when the WIP is calculated by a percentage of sales. This is the Work Center button in Work Cycles.

Enter in the Center code and the Description

Choose if the department is Internal or External

If applicable, choose a Cost Center by clicking on the Search button

The WIP Sequence determines the order in which the work centers will be displayed in the WIP Report.

Enter in a Brief WIP description

Enter in the WIP evaluation % by sales price for this work center.



Revised: June 2013

M3 – Works CodesThis table lists the generic type of work that can be performed on the work phase. It also controls the G/L account, determines the cost type for the phase and defines the Quality Control Operation Code that will be required on the phase.It also determines if this step commits the materials or makes the end item available. Enter a Work code and Work description. The description should be a general process description.Page 1Choose if the work is Internal or ExternalIf applicable, chose a G/L Account by clicking on the Search buttonThe Scraps control phase (prod700) allows a scrap quantity to be recorded at this step; moves the scraped quantity to the scraped blades warehouse. This should to 0 for No, unless this is the last work code in a work cycle.The Phase with automatic closing when subsequent phase starts should be set to 0 for No.The Work for final test (prod700) should be set to 0 for No.The next field determines if the work code is active (0) or Inactive (1) and should be 0The Work cost type defines how the activity will be costed:

1. Human and machine work Labour cost = 0: Actual Cost based on time recorded by an operator. This is for all hands on-time operations and operations where the operator is using the machine, such as APS Coating. This will also be used for Heat Treating

2. “COST BY ITEM”: Fixed Cost per Piece. This should be used for External Operations where we are charged a standard cost.

3. “SETUP COST”: This is not used in Italy. Without labor cost. Takes the works effective costs list only.

4. “SETUP COST”: Fixed Machine Cost per Piece that doesn’t depend on time or quantity. This should be used for setup operations, such as APS Setup.



Revised: June 2013

Page 2 This page can be skipped, as none of this information is required.

Page 3The Efficiency type is used to determine how the work will be costed. If the work cost type field is 1, then this value should be 1 for quantity per hour. If the work cost type field is 2 or 4, then this field should be 3 for fixed time. The value of 2 is used for costing based on a ‘production lot’ of items and therefore should not be used.

The Phase with materials commitment start should be set to 0 for No, unless this is the first work phase of a work cycle. Then it should be set to 1 for Yes.

The Phase with end item availability should be set to 0 for No, unless this is the last work phase of a work cycle. Then it should be set to 1 for Yes.

The Quality Control Op Code must be set to a quality control operation that relates to the work center. This will be used during the production detecting to determine what types of quality control rules will be applied.

Click on Ok when finished.



Revised: June 2013

M1 – Human ResourcesThis table defines the departments available to perform the work, along with the Work Center of affiliation. These codes will be based on the cost centers provided by accounting.

Enter a Human Resources code and ID description. The description should be a general area of production.Page 1Choose a Work Center of affiliation. This value is from the M0 (Work Centers) Table.Choose if the work is Internal or ExternalThe Department of affiliation is not used and can be left blank.Enter the ID standard hourly cost is not used and be left as 0Enter 100000 for the Branch/Plant of affiliationThe ID type field should be set to S




Revised: June 2013

M2 – Machine CodesThis table defines the machines available to perform the work, along with the Work Center and department of affiliation.

Enter a Machine code and Machine description. The description should be a specific machine.Page 1Choose a Work Center of affiliation. This value is from the M0 (Work Centers) Table.Choose if the work is Internal or ExternalThe Department of affiliation is not used and can be left blank.Enter 100000 for the Branch/Plant of affiliationEnter the Activity start date and Activity end date. The activity end date should be in the distant future, for example 12/31/2040 unless we know when a machine will be removed from service.




Revised: June 2013

M4 – DepartmentsThis table lists departments, and can be used in the Machine Codes / Work Center table (M2). Currently we are NOT using this table in ERP.

Enter in the Department Code and the Department DescriptionChoose if the department is Internal or ExternalEnter in 100000 for the Branch/plant code of affiliationClick on Ok when finished



Revised: June 2013

Effective CostsThis function defines the costs for the Human Resources (M1), Machine Codes (M2) and Works Codes (M3).

Go to the Production MenuThen click on the Manage cost list MenuDouble Click on Manage effective costs for resources and works

Under Functions select General list

Select the list that you wish to manage.

Enter in 100000 the Branch/Plant field



Revised: June 2013

1. ID numbers’ cost listThis assigns a cost to a Human Resource (M1).

Select the Human Resource (M1) by clicking on the Serial no box or pressing F2The Cost type will be Hourly cost.Enter the cost in the New price field.When finished making changes, click on Ok

2. Machines’ cost listThis assigns a cost to a Machine Code (M2).

Select the Machine Code (M2) by clicking on the Serial no box or pressing F2The Cost type will be Hourly cost.Enter the cost in the New price field.When finished making changes, click on Ok



Revised: June 2013

2. Works’ cost listThis assigns a cost to a Works Code (M3).

Select the Works Code (M3) by clicking on the Serial no box or pressing F2The Cost type will be the cost type defined in the Works Code table .Enter the cost in the New price field.When finished making changes, click on Ok


04.001 - master data - work centers, codes, departments - rev 1

Documents