---
alias: user-guide-business-intelligence-dashboard-product-cost
tags:
- reports
description: "This report displays a step-by-step product cost forecast, showing projected quantities, yields, cycle times, and accumulated costs at each step."
---

# 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.

{% include-markdown 'includes/pages/report_unavailable_edp_note.md' %}

## 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

![Example of the Product Cost dashboard](../images/product_cost_dashboard.png)

## 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 </br> Subsequent Steps: `Out Quantity (previous step) × Unit Conversion Factors` | [[dataplatform-dataset-costresolutions]]  table in DWH |
| **Out Quantity** | The quantity leaving the Step after accounting for the Step's yield. | `In Quantity × Step Yield` | [[dataplatform-dataset-costresolutions]] table in DWH |
| **Units** | The unit of measure for the quantities at the Step. | Defined per Step in the product flow configuration. | [[dataplatform-dataset-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)` | [[dataplatform-dataset-costresolutions]] and [[dataplatform-dataset-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)` | [[dataplatform-dataset-costresolutions]] and [[dataplatform-dataset-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` | [[dataplatform-dataset-costresolutions]] and [[dataplatform-dataset-stepcostinfo]] table in DWH |
| **Total BOM Cost** | The total cost of all BOM items consumed in the Step. | `SUM(BOM Item Total Cost)` | [[dataplatform-dataset-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) | [[dataplatform-dataset-costresolutions]] and [[dataplatform-dataset-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)` | [[dataplatform-dataset-costresolutions]] and [[dataplatform-dataset-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` | [[dataplatform-dataset-costresolutions]] and [[dataplatform-dataset-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. </br> Subsequent steps: `Product Yield (previous step) × Step Yield` | [[dataplatform-dataset-costresolutions]]  entity set in DWH |

## Entity Filters

You can customize this dashboard through the following single-value filters:

- Product
- Revision
- In Quantity