Bill of Materials > Reports > Costing Report

Costing Report

You use this program to generate a detailed report of the bill of material or what-if costs for parts against which a structure is defined.

A summary cost listing can be generated using the Costing Summary Report program.

Report Options

Routing selection

Field Description
Use warehouse route Uses the route defined at the Routing field (Warehouse Maintenance) for the parent item when selecting parts for printing.
Route Indicate the specific routing according to which you want to select parts for printing.

The route for the parent is printed on the report.

[Note]

You can only access this field if you enabled the Alternate routings required setup option (Bill of Materials Setup).

Print options

Field Description
List detail breakdown Prints a detailed report of costs for all first level components and operations, including startup and teardown times.
List what-if cost totals Prints what-if totals below the standard total costs for comparison purposes.

The field is greyed out and automatically ticked if you selected to print what-if costs at the Costs to print field.

New page per item Prints details for each parent part on a new page.
Print manufacturing u/m quantities Multiplies component quantities by the manufacturing unit of measure. Otherwise the quantities reflect the quantity per based on the stocking unit of measure of the parent.

Part category selection

Field Description
Made in Prints costs for made-in items.
Bought out Prints costs for bought-out items.
[Note]

This field is selected by default if you have set the Activity based costing required option to Yes (Bill of Materials Setup).

Subcontracted Prints costs for subcontract items.
Phantom part Prints costs for phantom items.
Planning bill Prints costs for planning bill items.
Kit part Prints costs for kit part items.
Co-product Prints costs for co-products.

The notional part's structure and routing with the costs apportioned is printed.

If you only select co-products, then only the structure is printed if the co-product is not being manufactured via a notional part.

By-product Prints costs for by-products.
Notional part Prints costs for notional parts.

Co-product apportionments are printed below the component and operation sections.

Cost to print selection

Field Description
Bill of materials Prints the bill of material costs for parts.
What-if Prints what-if costs for parts.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

If Costing per warehouse is not enabled (Inventory Setup) then the values on the Current BOM costs line reflect the cost held against the stock item. When both Costing per warehouse and Apply warehouse BOM costs are enabled (Inventory Setup), then the values on the Current BOM costs line reflect the cost held against the warehouse.

When Apply warehouse BOM costs is enabled (Inventory Setup) then the warehouse re-order quantity/pallet quantity is used as the EBQ/PAN quantity for calculating costs. In addition, the costing for the warehouse used for each component is included on the report.

When both Costing per warehouse and Apply warehouse BOM costs are enabled (Inventory Setup) then the warehouse costs printed are those from the component Warehouse to use defined against the bill (Structures and Routings). If this is not defined, then the costs from the Component warehouse to use (Warehouse Maintenance) is used. If neither is defined, then the warehouse against the Warehouse to use field (Stock Code Maintenance) is used.

When both Costing per warehouse and Apply warehouse BOM costs are not enabled (Inventory Setup) then the warehouse against the Warehouse to use field (Stock Code Maintenance) is used.

This line is only printed when the BOM cost held against the stock item or the warehouse, differs from the cost calculated by the Costing Report program. You can use the Cost Implosion program to re-cost the stock item(s).

The costs on this report are shown in terms of the (EBQ) Economic Batch Quantity. If this is not defined, then the costs are calculated in terms of one parent part.

If a component is a co-product and the co-product is manufactured via a notional part on the same route, then the cost is picked up on the Inventory master record against the BOM costs fields (these would have been calculated according to the material and labor apportionment of that co-product in the BOM cost implosion).

Co-product details for notional parts are printed on the report. The co-product information follows the same structure as for components, however, the Level is always 00 and the Sequence is always Co-product. Co-products printed using the template are printed in line with the parent part and not indented.

Notes and warnings

Cost value differences

  • To prevent rounding differences in costs between the various costing programs (e.g. Inventory Query cost analysis, Costing Query and Costing Report) you should run the Cost Implosion together with the option: Update unit run times enabled.

  • The what-if values on the Costing Report may differ from the Inventory Query cost analysis because the Costing Report reads through the operation files to establish the costs while the cost analysis simply reads them from the INVWIF file which was updated the last time a what-if costing was imploded.

    Therefore, if changes were made before the Cost Implosion was not run recently, together with the option Update unit run times enabled, then the InvWhatIfCost file may not reflect the same information as used on the report and calculated.