CalculateWOHoursAndCosts

Minor Business Rule

Object Name: B3100460

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description
This function will calculate the Hours and Costs associated with a Work Order Routing.

1.1Purpose
The purpose of this function is to calculate the current WO Routing Costs and Hours for later
updating to the Work Order Variance file. This is done by doing a cost rollup.

1.2Setup Notes and Prerequisites
- Prior to calling this function the Run Labor, Run Machine and Setup Labor hours has to be
calculated.
- The Genlong pointer to Manufacturing Constants must be obtained using B3000450.

1.3Special Logic

2.Technical Specifications

2.4Processing

A. Get the Work Center Master row (F30006) row using Business Function B3000400 using MCU.
B. Get the Work Center Rates row (F30008) row using Business Function B3000460 for Ledger Type '07'.
C. If the Row is found, do the following.
Assign values to D3000470 parameters VC01B = '1', VC01A = '1', ACQ = 1, TIMB = 1, File RUNL
  = Input RUNL, RUNL = Input RUNL, RUNM = Input RUNM, SETL = Input SETL in D3000470.
1.Calculate Direct Labor Data.
Output Direct Labor Hours = Output Direct Labor Hours + Input RUNL
Call B3000470 using COST = 'B1'.
Output Direct Labor Cost = Output Direct Labor Cost + XSMC from B3000470
2.Calculate Setup Labor Data.
Output Setup Labor Hours = Output Setup Labor Hours + Input SETL
Call B3000470 using COST = 'B2'.
Output Setup Labor Cost = Output Setup Labor Cost + XSMC from B3000470
3.Calculate Direct Machine Data.
Output Direct Machine Hours = Output Direct Machine Hours + Input RUNM
Call B3000470 using COST = 'B3'.
Output Direct Machine Cost = Output Direct Machine Cost + XSMC from B3000470
4.Calculate Labor Efficiency Data.
Call B3000470 using COST = 'B4'.
Output Efficiency Cost = Output Efficiency Cost + XSMC from B3000470
Wk Efficiency  Hours =  (FLH - FEH) from B3000470
5.Calculate Variable Machine Overhead Data.
Call B3000470 using COST = 'C1'.
Output Var Mach Over Cost = Output Var Mach Over Cost + XSMC from B3000470.
6.Calculate Fixed Machine Overhead Data.
Call B3000470 using COST = 'C2'.
Output Fixed Mach Over Cost = Output Fixed Mach Over Cost + XSMC from B3000470.
7.Calculate Variable Labor Overhead Data.
Output Var Labor OH Hours = Output Var Labor OH Hours + Input RUNL (if CVDL = 'Y')
+ Input SETL (if CVSL = 'Y') + Wk Eff Hours (if CVDS = 'Y')
Call B3000470 using COST = 'C3'.
Output Var Labor OH Cost = Output Var Labor OH Cost + XSMC from B3000470
8.Calculate Fixed Labor Overhead Data.
Output Var Labor OH Hours = Output Var Labor OH Hours + Input RUNL (if CVDL = 'Y')
+ Input SETL (if CVSL = 'Y') + Wk Eff Hours (if CVDS = 'Y')
Call B3000470 using COST = 'C4'.
Output Efficiency Cost = Output Efficiency Cost + XSMC from B3000470

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnRunLaborHours	RUNL	MATH_NUMERIC	OPT	NONE
The standard hours of labor that you expect to incur in the normal production of this item. The run labor hours in the Routing Master table (F3003) are the total hours that it takes the specified crew size to complete the operation. The hours are multiplied by the crew size during shop floor release and product costing.
mnRunMachineHours	RUNM	MATH_NUMERIC	NONE	NONE
The standard machine hours that you expect to incur in the normal production of this item.
mnSetupLaborHours	SETL	MATH_NUMERIC	NONE	NONE
The standard setup hours that you expect to incur in the normal completion of this item. This value is not affected by crew size.
idF3009Pointer	GENLNG	ID	NONE	NONE
General purpose ID variable.
szWorkCenter	MCU	char	NONE	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
mnDirectLaborHours	CTS1	MATH_NUMERIC	NONE	NONE
The number of unaccounted direct labor hours associated with a specific operation for a work order.
mnDirectLaborCost	CTS4	MATH_NUMERIC	NONE	NONE
The amount of unaccounted direct labor associated with a specific operation for a work order.
mnDirectSetupHours	CTS2	MATH_NUMERIC	NONE	NONE
The number of unaccounted setup labor hours associated with a specific operation for a work order.
mnDirectSetupCost	CTS5	MATH_NUMERIC	NONE	NONE
The amount of unaccounted setup labor associated with a specific operation for a work order.
mnDirectMachineHours	CTS3	MATH_NUMERIC	NONE	NONE
The number of unaccounted machine hours associated with a specific operation for a work order.
mnDirectMachineCost	CTS6	MATH_NUMERIC	NONE	NONE
The amount of unaccounted machine dollars associated with a specific operation for a work order.
mnEfficiencyCost	CTS4	MATH_NUMERIC	NONE	NONE
The amount of unaccounted direct labor associated with a specific operation for a work order.
mnMachineVarOHCost	CTS5	MATH_NUMERIC	NONE	NONE
The amount of unaccounted setup labor associated with a specific operation for a work order.
mnMachineFixedOHCost	CTS6	MATH_NUMERIC	NONE	NONE
The amount of unaccounted machine dollars associated with a specific operation for a work order.
mnLaborVarOHHours	CTS1	MATH_NUMERIC	NONE	NONE
The number of unaccounted direct labor hours associated with a specific operation for a work order.
mnLaborVarOHCost	CTS4	MATH_NUMERIC	NONE	NONE
The amount of unaccounted direct labor associated with a specific operation for a work order.
mnLaborFixedOHHours	CTS2	MATH_NUMERIC	NONE	NONE
The number of unaccounted setup labor hours associated with a specific operation for a work order.
mnLaborFixedOHCost	CTS5	MATH_NUMERIC	NONE	NONE
The amount of unaccounted setup labor associated with a specific operation for a work order.
szBranch	MMCU	char	NONE	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
cSuppressErrorMessages	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
szWorkcenterBranch	WMCU	char	OPT	NONE
This is the branch/plant to which the work center belongs and must exist in the business unit master (F0006) and branch plant constants file (F41001).

B3000400 Verify And Get Work Center Master
B3000440 Verify And Get MFG Constants
B3000460 Verify And Get W C Rates
B3000470 Calculate Routing Costs

CalculateWOHoursAndCosts