Material Cost Report#
Overview#
The Material Cost dashboard displays a step-by-step cost forecast of the material production process, showing projected quantities, yields, cycle times, and accumulated costs at each step.
Warning
Enterprise Data Platform (EDP) does not yet support ODS, so this report will not work properly if you are using EDP. For more information, see EDP Tutorial ⧉.
Folder#
Costing.
Database#
- DWH (queried via OData).
Data#
- In/Out Quantity
- Resource, Step, BOM and Labor Cost
- Step Yield
- Step Total Cycle Time
- Initial Material Cost
- Material Total Cost
Example#
Data Breakdown#
For each Step, the following data and forecasts are displayed:
| Data | Description | Formula | Datasource |
|---|---|---|---|
| In Quantity | The Material quantity entering the Step. | 1st Step: Material Primary Quantity + Sub Materials Primary Quantity Subsequent Steps: Out Quantity (previous step) × Unit Conversion Factors | MaterialCostInfo table in DWH |
| Out Quantity | The Material quantity leaving the Step after accounting for the Step's yield. | In Quantity × Step Yield | CostResolutions table in DWH |
| Units | The unit of measure for the quantities at the Step. | Defined per Step in the product flow configuration. | CostResolutions table in DWH |
| Total Step Cost | The full cost of running the Step, combining a fixed charge, a per-unit charge on the input quantity, and an hourly charge over the Step's total cycle time. | Step Fixed Cost + (Step Cost per Unit × In Quantity) + (Step Cost per Hour × Step Total Cycle Time) | CostResolutions and StepCostInfo table in DWH |
| Total Resource Cost | The full cost of the resources used in the Step. | Resource Fixed Cost + (Resource Cost per Unit × In Quantity) + (Resource Cost per Hour × Step Total Cycle Time) | CostResolutions and StepCostInfo table in DWH |
| Total Labor Cost | The cost of labor for the Step, calculated purely on an hourly basis. | Labor Cost per Hour × Step Total Cycle Time | CostResolutions and StepCostInfo table in DWH |
| Total BOM Cost | The total cost of all BOM items consumed in the Step. | SUM(BOM Item Total Cost) | CostResolutions table in DWH |
| Step Yield (%) | The fraction of input quantity that successfully passes through the Step. Defined in the Step's product yield and cycle time configuration. | Configured yield value for the step (value from Step Product Yield and Cycle Time Context). | CostResolutions and StepCostInfo table in DWH |
| Step Total Cycle Time | The total time the Step takes to process the input quantity, combining a fixed duration with a variable duration that scales with quantity. | Fixed Cycle Time + (Variable Cycle Time × In Quantity) | CostResolutions and StepCostInfo table in DWH |
| Initial Material Cost | The accumulated cost of the Material at the start of the Step, before that Step's costs are added. | Material Cost + Step Cost (up to but not including this step) | CostResolutions and MaterialCostInfo table in DWH |
| Material Total Cost | The accumulated cost of the Material after the Step's costs have been added. This becomes the Initial Material Cost for the next Step. | Initial Material Cost + Step Total Cost | CostResolutions and MaterialCostInfo table in DWH |
Entity Filters#
In this dashboard, it is only possible to select what Material the report will concern.