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

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

{% 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**
- **Initial Material Cost**
- **Material Total Cost**

## Example

![Example of the Material Cost dashboard](../images/material_cost_dashboard.png)

## 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` </br> Subsequent Steps: `Out Quantity (previous step) × Unit Conversion Factors` | [[dataplatform-dataset-materialcostinfo]] table in DWH |
| **Out Quantity** | The Material 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 |
| **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)` | [[dataplatform-dataset-costresolutions]] and [[dataplatform-dataset-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` | [[dataplatform-dataset-costresolutions]] and [[dataplatform-dataset-materialcostinfo]] table in DWH |

## Entity Filters

In this dashboard, it is only possible to select what **Material** the report will concern.