Documentation >
MAC-PAC Technical Library >
Financial >
Job Costing >
Programs >
Job Cost Report - Purpose >
Job Cost Report - Calculations
Job Cost Report - Calculations
JA520E
A. Housekeeping
1. Parameters are set up for error processing.
2. Key lists are defined for files used by the program.
3. Work fields are defined and initialized.
4. Reference File categories are initialized.
5. The following information is retrieved from the Reference file:
a. Installation parameters (category 012).
b. CPF file access status codes (category 015).
c. Job costing options (category D52).
d. System options (category 133).
B. Mainline
1. The Job Cost Report file (JA320AP1) is read.
2. All requests are processed until the end of file is reached.
a. The type of request is determined.
(1) Process All Jobs requests are driven by the Job Master file (JC100ML4). All jobs are reported.
(2) Process All Jobs for Project Manager requests are driven by the selection criteria from the Request file (JA320AP1) and the Job Master file (JC100ML4). All jobs associated with the requested project manager are printed.
(3) Process All Jobs for Group requests are driven by the selection criteria from the Request file (JA320AP1) and the Job Master file (JC100ML5). All jobs associated with the requested group are reported.
(4) Process Single Job requests are driven by the selection criteria from the Request file (JA320AP1) and the Job Master file (JC100M). All costs are reported for the requested job.
b. Fields are initialized and the header is formatted.
c. Material costs are reported (JA110ML1).
(1) Job-controlled material: Quantity, unit cost, and total cost are reported.
Planned costs consist of requirements covered by job purchases and uncovered requirements.
Actual costs consist of job purchase, net transfers to/from inventory, issues from group inventory, and issues from excess inventory. If the Inventory Accounting module is installed, the accounting cost (PMACST) from the Part Master file is used or if the part is configuration costed, the accounting cost (CCASCT) from the Configuration Code file (EC140M) is used. If the Inventory Accounting module is not installed, then the standard cost from the Part Master file is used. If the part is configuration costed, the standard cost from the Configuration Code file (EC140M) is used. For requirements covered by job purchases, if total cost is passed, unit cost is calculated (total divided by quantity); if total cost is not passed, the accounting, standard, configured accounting cost, or configured standard cost is used (depending on whether the Inventory Accounting module is installed and if the part is configuration costed) and total cost is calculated (quantity times unit cost). If the part is configuration costed the total cost per configuration code is calculated as well.
Projected total cost is calculated (depending on whether projected quantity is greater than the actual quantity) and unit cost is determined (total divided by quantity).
For actual and projected totals, both a quantity and total cost variance is calculated (actual or reported less planned).
(2) Non job-controlled material: Planned, actual, and projected costs are reported.
Planned and actual costs are calculated at standard. Projected total cost is calculated (depending on whether projected quantity is greater than actual quantity) and unit cost is determined. For actual and projected, a variance is calculated as described above.
d. Labor costs are reported (JA115M) if the Shop Floor Control module is installed. Planned cost is calculated using accounting labor rate (WARATE) from the Workcenter file. Actual cost is calculated depending on the actual labor costing option (Reference File category D52). If standard, the accounting rate is used (WARATE); if employee, the total cost is given and unit cost is calculated. In both cases, if IA is not installed, then the standard rates will be used. Projected total cost is calculated (depending on whether projected quantity or actual quantity) and unit cost is determined. For actual and potential, a variance is calculated as described in 2c.
e. Overhead costs are reported (JA115M) if the Shop Floor Control module is installed. Planned and actual costs are determined using the accounting burden written for these labor records. If IA is not installed, the standard burden rate is used.
f. If overflow occurred when calculating material costs, labor costs, overhead costs, and the total costs, a warning message is printed on the report. This indicates that the amounts printed on the report may have been truncated due to overflow.
3. Summary report is processed if requested (JA320AP1). Planned, actual, and projected costs and both actual and projected variances are reported for the following costs: material, labor, overhead, miscellaneous costs, and additional job charges. A percentage complete is printed if Shop Floor Control is installed.
4. End of request is processed (a message is printed and the request is deleted) and the page is initialized for the next request.