Production Cost Breakdown

This report shows detailed production costs breakdown including resource costs, material costs and manufacturing overheads. Component SKUs are not shown. Compare actual costs to planned costs and analyse cost overrun for different locations and work centres.

Note: This report only shows breakdown for costs of production tasks, not assembly tasks. Components are not listed. To show an analysis of costs per component for assembly and production tasks, see Production Cost Analysis.

Users need the Production Reporting permission to access this report.

Prerequisites

Data from this report can be exported in Excel, PDF or RTF format.

Input:

Reporting Period	Allow user to select the reporting period from a list of options or set a custom date range.
Layout	Set to the Default layout. Allows selection of saved layouts, if any.
Save Layout As	Allows saving of a layout for potential future use.
Reset Layout	Resets layout to the default layout or selected saved layout.
Show In	Show Actual time in seconds, minutes, or hours.

Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.

Output:

The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.

Fields
Location	Production location (Shopfloor).
SKU	SKU of the finished product.
Product	Name of the main finished product produced in this Production Order. The reports displays only one main finished product.
Production Order #	Production order number.
Production Run #	Production run number.
Status	Production run status.
Work Centre	Work Centre for production operation.
Year	The year of the assembly completion date.
Quarter	The quarter of the assembly completion date.
Month	The month of the assembly completion date.
Version	Bill of Material version number. Applies only to Production and Make to Order BOM. Default version is marked.
Production Additional Attribute 1-10	Value of additional production attributes.
Data Headers
Actual time	Actual cycle time for operation (when split by work centre)/production run/production order. Suspended time is not included.
Planned Resources Costs	Sum of costs of resources required to produce the Production Run quantity of the finished product, as defined in Production BOM.
Planned Component Costs	Sum of costs of components required to produce the Production Run quantity of the finished product, as defined in Production BOM. For the components which are "variation" or "template" type the average cost is applied.
Actual Resources Costs	Sum of costs of resources consumed during operation (when split by work centre)/production run/production order. Costs are allocated upon operation completion.
Actual Components Costs	Sum of costs of components consumed during operation (when split by work centre)/production run/production order. Costs are allocated upon operation completion.
Overhead	Sum of manual journals allocated for the production run. The amount is distributed proportionally according to the sum of costs of resources and components.
Total Planned Costs	Total planned costs allocated for components and resources.
Total Actual Costs	Total actual costs allocated for components + resources + overhead.
Overrun(+)/Underrun(-)	Difference between actual cost and planned cost for production run completion. Overrun(+)/Underrun(-) is calculated as Actual - Planned. If actual cost > planned cost then Overrun(+)/Underrun(-) is positive, if actual cost < planned cost then the value will be negative.
Overrun%(+)/Underrun%(-)	Difference between actual cost and planned cost for production run completion, displayed as a percentage of planned cost. If actual cost > planned cost then Overrun% is positive, if actual cost < planned cost then Underrun% is will be negative. Deviation% = (Actual - Planned) / Planned x 100%

Production Cost Breakdown

Prerequisites

Input:

Output:

Was this article helpful?