Consumption Of Material
Consumption Of Material Report - User Guide
1. Introduction βοΈπ§ͺ
In precision manufacturing, measuring what should have been consumed versus what was actually issued from the warehouse is critical for operational efficiency and cost control. The Consumption Of Material Report performs multi-level Bill of Materials (BOM) explosions against actual shop floor output or sales dispatches to calculate theoretical material requirements, track process yield loss, and evaluate supply chain lead times.
βΉοΈ
Core Objectives:
- Efficiency & Variance Auditing: Compares actual physical material issues (via IIRS) against theoretical requirements defined in engineering BOM recipes.
- Yield Loss Identification: Pinpoints exact components and operations suffering excessive shop floor scrap or wastage.
- Cost of Goods Sold (COGS): Evaluates the true material cost embodied in dispatched customer shipments.
- Supply Chain Lead Time: Measures delivery cycles from initial purchase indent to physical gate receipt (GRN).
Typically, this report is used by Plant Heads, PPC Managers, Cost Accountants, and Supply Chain Leads.
2. Accessing the Report π
Navigate to Manufacturing > Reports > Consumption Of Material.
3. Report Modes (“Compute Consumption as per BOQ For”) β¨
The generation dialog presents three strategic computation modes:
A. Actual Production Qty (Actual_Consumption_Report.xlsx)
- Engineering Standard vs Reality: Scans all finished goods recorded in daily production logs within the date range, explodes their BOM recipes, and computes the exact theoretical raw materials that should have been consumed.
- Variance Tracking: Contrasted against actual store issue quantities to reveal shop floor wastage, unauthorized scrap, or tooling wear.
B. Dispatched Qty (Dispatch_Consumption_Report.xlsx)
- Revenue Matching: Computes gross raw material consumption based on finished products actually invoiced and dispatched to customers.
- Financial P&L Alignment: Provides cost accountants with precise material COGS corresponding to monthly sales revenue.
C. IIRS Consumption / Lead Time (IIRS_Consumption_LeadTime.xlsx)
- Physical Store Issues: Analyzes actual internal store transfers recorded through Issue / Receipt Slips (IIRS).
- Procurement Lead Time: Analyzes the turnaround time (in days) between material indenting and physical receipt at the warehouse, identifying vendor and inspection bottlenecks.
4. Operational Controls & Processing Logic π οΈ
- Scan BOM of Sub Assemblies: Recursively explodes nested sub-assemblies (up to 5 levels) to trace basic raw materials.
- Special Logic: This toggle is enabled for Actual Production Qty and Dispatched Qty, but is automatically disabled when running IIRS Consumption / Lead Time, since IIRS slips already record physical, transaction-level material transfers.
- Background Processing Queue: Due to the intensive computational demand of multi-level BOM explosions across large date ranges, jobs requiring extended processing are routed to the system’s background report queue, freeing the user interface while generating the file.
5. Key Analytical Columns π
- Theoretical Consumption (BOQ): The engineering standard quantity required per the BOM.
- Actual Issue (IIRS): The physical quantity issued to the production lines.
- Variance: The operational difference (
Actual Issue - Theoretical Consumption). Positive variance highlights material loss or scrap. - BOQ Valuation: Financial valuation of theoretical consumption based on moving average or standard purchase rates.
- Procurement Lead Time (Days): Total elapsed duration from purchase requisition to accepted GRN stock.
6. Best Practices / Tips π‘
- Enable Sub-Assembly Scanning for Capital Goods: For complex multi-tiered machinery, always enable “Scan BOM of Sub Assemblies” to ensure internal sub-components, fasteners, and hardware are fully accounted for.
- Monthly Variance Reviews: Review the Actual Consumption report at each month-end close. Any component showing recurring negative yield or excessive variance should be investigated for process deviations or outdated BOM scrap allowances.
- Monitor Increasing Lead Times: Use the IIRS Consumption / Lead Time output to detect creeping supplier delays before they cause factory line halts.