Job Cost Generation - Mainline and Labor - Calculations

A.   Housekeeping

1.   Parameters, key lists, and fields are set up.

2.   Data is retrieved from the System Control and Reference files.

3.   Work fields are defined and initialized.

4.   Priming read of Job Cost Generation Request file is performed.

B.   Mainline

1.   All requests are processed until end-of-file.

a.   The type of request determines which job logical is read.  The types of requests include:

(1)  Job Number

(2)  Job Group

(3)  Project Manager

(4)  All Jobs

b.   Jobs that have been final costed (status = Z) are not processed by the program.

c.   In a multiple currency environment, all costs are carried in the base currency of the plant or warehouse that incurred the expense.

d.   Any exceptions that occur are captured and printed on the Job Cost Generation Exception report (JA110A).

2.   The Labor Requirements file (IC125M) and the Job Labor Cost file (JA115M) are read in synchronization so that the Job Labor Cost file represents what is in the Labor Requirements file.

a.   Job labor cost records that do not correspond to labor requirements records are deleted.  The keys of both files are job, plant, part, and workcenter.

b.   Job labor cost records are added for new labor requirements.

c.   Labor records that have job labor cost records are costed and the corresponding job labor cost records are updated.

d.   Each labor requirement record is costed and accumulated until the job, plant, part, workcenter changes.  One job labor cost record is written for each of these labor records.

3.   Labor and Overhead Calculations - Planned and Earned

a.   Planned labor hours, planned overhead hours, and earned hours are calculated.  See the Job Costing User Manual for details.

b.   No planned costs are calculated in this program.  The Job Cost Report program (JA520E) calculates costs.

4.   Labor and Overhead Calculations - Actual

a.   Actual labor hours and actual overhead hours are calculated See the Job Costing User Manual for details.

b.   This program does not calculate actual labor costs when the actual labor costing option is S - Standard on Reference File category D52.  This calculation is done in the Job Cost Report program.

c.   This program calculates actual labor cost when the actual labor costing option is E - employee on Reference File category D52.  See the Job Costing User Manual for details.

5.   Labor and Overhead Calculations - Projected

a.   Projected labor and overhead hours are calculated.  See the Job Costing User Manual for details.

b.   No projected costs are calculated in this program.  The Job Cost Report program (JA520E) calculates projected costs.

6.   Miscellaneous Cost Calculations

a.   The workcenter rate code on the Workcenter file (ME100M) is checked to determine the type of miscellaneous cost.  Memo charges are not processed.  The following is a list of rate codes:

b.   Planned, actual, and projected quantities are calculated.  These calculations are based on whether the miscellaneous cost is fixed or variable.  See the Job Costing User Manual for details.

c.   If either the planned or actual miscellaneous costing options on Reference File category D52 is P - P.O., then phantom purchase orders are accumulated.  The P.O. Release file (PO180L13) is read for the M.O./operation/line.  The ordered and received quantities are accumulated and costed.  P.O. amounts are converted to the company/warehouse base currency if the system is configured as a multi-currency environment.

d.   If either the planned or actual miscellaneous costing option on the Reference File category D52 is S - standard, the cost is based on workcenter miscellaneous cost.  See the Job Costing User Manual for details.

e.   Projected total costs are formatted using the greater of the planned or actual costs from above unless the M.O. is closed, accounting closed, or the L.R. quantity complete is more than the M.O. quantity.

JA110E Program Menu

• Purpose
• Calculations
• Files
• Reports