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.