# Report on Raw Materials / Supporting Materials

### **Report Module Guide: Report on Raw Materials / Supporting Materials Used**

#### **Module Location**

#### PPIC > Reports > Report on Raw Materials / Supporting Materials Used

#### **Module Objective**

#### The **Report on Raw Materials / Supporting Materials Used** module is used to generate a detailed report regarding the **actual usage** of raw materials and supporting materials in the production process. This report compares the quantity actually used with the **standard quantity** that should have been used (based on the BOM), making it crucial for analyzing material usage efficiency and calculating variance.

### **1. Report Parameters (Filter)**

#### The main page of this module is a form containing various parameters to customize the report that will be generated.

#### Here is an explanation for each parameter:

- #### **View**: Select the report display basis, whether **Per JO (Per Job Order/Work Order)** or **Per Item**.
- #### **Finished Good**: Filter the report to analyze raw material usage only for the production of a specific **Finished Good**, or select **All**.
- #### **Date**: Specify the production date range in the **From** and **To** fields.
- #### **Warehouse**: Select the warehouse from which the raw materials were taken.

### **2. Steps to Generate the Report**

#### **Step 1: Set Report Parameters**

#### Define the parameters you need, especially the **Period** and the **Finished Good** (if you want to focus on a specific product).

#### **Step 2: Generate the Report**

#### After all parameters are set, click one of the two buttons at the bottom:

- #### **\[Display Report\]**: To preview the report directly on your screen.
- #### **\[Export to MS Excel\]**: To download the report data in an Excel file format.

### **3. Reading the Report (Report Content)**

#### The generated report is a comparative analysis of raw material usage.

#### **Key Column Explanation**

#### The report is grouped by **Raw Material / Supporting Material**. For each material:

- #### **Standard Quantity**: The quantity of material that should have been used according to the recipe/BOM to produce a certain amount of finished goods.
- #### **Quantity Used**: The actual quantity of material issued from the warehouse and consumed during the production process.
- #### **Remainder (%)**: The percentage of the variance between standard and actual usage. A positive number indicates more efficient usage (less than standard), a negative number indicates waste (more than standard).

### **Tips & Important Notes**

- #### This report is a crucial **material efficiency analysis tool** for **Production Managers and Cost Accountants**.
- #### Use the **Remainder (%)** column to identify which raw materials have the most inefficient usage and require further investigation.
- #### This report's data is pulled from a comparison between **BOM data (standard)** and the **actual goods issue data** from the warehouse to production.