Planned Material Costs

The following material calculations are cross-referenced to fields on the Job Cost Report (JA520A).  Material costs are based on component requirement (CR) records.  They are collapsed into one cost record on the Material Cost File for each job/part.

For all calculations, if the Inventory Accounting module is not installed, the standard cost is used instead of the accounting standard cost.

Requirements Covered by Job Purchase Orders

Quantity

If the sum of the purchase order line quantities is less than the quantity required (component requirement quantity less any manufacturing order quantities) then:

QUANTITY = Sum of PO Line Quantities.

Otherwise,

QUANTITY = Quantity Required.

Total Cost

If the planned material costing option on Reference File category D52 is S (standard) then:

TOTAL COST is calculated by the Job Cost Report Program using the accounting standard cost from the Part Master File.

If the planned material costing option is P (purchase order) and if more was purchased than required (overbuy), then:

TOTAL COST = (Quantity Required / PO Order Quantity) * PO Total Cost.

Otherwise,

TOTAL COST = PO Total Cost.

Uncovered Requirements

Quantity

QUANTITY = CR Required Quantity minus MO Required Quantity minus Requirements Covered by Job POs

Total Cost

TOTAL COST is calculated by the Job Cost Report Program using the accounting standard cost from the Part Master File.