Product Cost Report#
Overview#
The Product Cost dashboard displays a step-by-step product cost forecast, 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
- Product Cost
- Product Yield
Example#
Data Breakdown#
For each Step, the following data and forecasts are displayed:
| Data | Description | Formula | Datasource |
|---|---|---|---|
| In Quantity | The quantity entering the Step. | 1st Step: user-defined input Subsequent Steps: Out Quantity (previous step) × Unit Conversion Factors | CostResolutions table in DWH |
| Out Quantity | The 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 |
| Product Cost | The accumulated cost of the product after the Step's costs have been added. | Previous Product Cost + Step Total Cost | CostResolutions and ProductCostInfo tables in DWH |
| Product Yield (%) | The share of the original input quantity that has successfully passed through all Steps up to this point. | 1st step: Equal to the Step yield. Subsequent steps: Product Yield (previous step) × Step Yield | CostResolutions entity set in DWH |
Entity Filters#
You can customize this dashboard through the following single-value filters:
- Product
- Revision
- In Quantity