Material Consumption & Production Efficiency Report

Material Consumption & Production Efficiency - User Guide

1. Introduction ⚙️🧪

In precision manufacturing, knowing what you should have used versus what you actually used is the difference between profit and loss. The Consumption of Material Report is an advanced auditing tool that performs a multi-level “BOM Explosion” to calculate the theoretical material cost of your physical daily production.

This report is essential for Production Heads, Cost Accountants, and Supply Chain Managers.

2. Report Modes 🚀

A. Actual Production Quantity

• The Recipe Check: For every finished item recorded in your daily production logs, the system scans the BOM (including all sub-assembly levels) and calculates the exact amount of raw materials (Steel, Resin, Components, etc.) that should be consumed.
• Wastage Detection: Use this to see if your shop floor is consuming more material than the engineering standard allows.

B. Dispatched Quantity

• Revenue vs. Cost: Calculates consumption based on what you have actually shipped to customers. This is the ultimate tool for matching your inventory consumption with your sales revenue for monthly P&L statements.

C. IIRS Consumption / Lead Time

• Requisition to Reality: Tracks internal material requests (Internal Inventory Requisition Slip).
• Lead Time Analysis: Measures the “Lag” in your supply chain. It calculates the average days taken to fulfill a production requirement, highlighting bottlenecks in your procurement process.

3. High-Engineering Features 🛠️

• Multi-Level BOM Explosion: The report doesn’t just look at the top item. It can scan up to 5 levels deep into your sub-assemblies to find the “basic” raw materials, ensuring 100% accuracy in consumption tracking.
• Weighted Average Valuation: The system combines your opening stock rates with your latest purchase rates to provide a realistic monetary value (BOM Amount vs Actual Amount) for your material usage.
• Internal Supply Chain Audit: Compares “IIRS Quantity” (Actual Issue) vs “Consumption Quantity” (Theoretical). Any significant gap represents unauthorized scrap, material theft, or process failure.

4. Understanding Data Columns 📊

• Theoretical Consumption: The “Standard” quantity required as per the engineering BOM.
• IIRS Consumption: The “Actual” quantity physically issued from the stores.
• Variance: The difference between Actual and Theoretical (highlighting inefficiency).
• Lead Time (Days): The speed of your supply chain (Indent to GRN).
• BOM Amount: The theoretical cost of production.
• IIRS Amount: The actual cost of material used.

5. Source Transactions 🔄

The reporting engine synthesizes data from:

1. Engineering Masters: Bill of Materials (BOM) and Sub-Assembly structures.
2. Production Logs: Daily Production (MIRS) and Invoice Dispatches.
3. Inventory Logs: Internal Requisitions (IIRS) and Goods Receipts (GRN).

6. Best Practices / Tips 💡