BOM / BOQ Report

BOM / BOQ Report - User Guide

1. Introduction đŸ› ī¸

The BOM / BOQ Report is the engineering and costing analytical hub of the manufacturing system. It provides a structured breakdown of raw materials, sub-assemblies, stages, and labor required to manufacture any product. Whether used for procurement and pick-listing (BOQ) or financial valuation and price setting (Costed BOM), this report ensures manufacturing standards are technically sound and commercially viable.

â„šī¸

Core Functions of this Report:

  • Technical Blueprinting: Document multi-level product formulations from base raw materials through nested sub-assemblies.
  • Financial Costing: Calculate total product manufacturing cost using real-time inventory purchase rates.
  • Procurement Planning: Generate a Bill of Quantity (BOQ) for raw material planning and warehouse pick lists.
  • Engineering Audit Trail: Track historical revisions and engineering change notices via the BOM Change Log.

Typically, this report is used by Production Managers, Design Engineers, PPC Leads, and Cost Accountants.


2. Accessing the Report 🚀

Navigate to Manufacturing > Reports > BOM.


3. Filter Options & Report Configurations ✨

The BOM export dialog allows users to tailor the report scope:

Product Selection Filters

  • All Products: Generates a consolidated report across all active manufacturing formulations.
  • Product Group: Filter formulations by specific product categories or item families.
  • Product Short Name: Target an individual product or assembly using quick search autocomplete.

Costing Valuation Modes

  • Last Purchase Rate (LPR): Values all input materials using the most recent supplier invoice rate.
  • Weighted Average Rate (WAR): Values input materials using the cumulative moving average rate of current inventory stock.

Presentation Format

  • BOM View: Focuses on operational routing, process steps, input stages, and physical quantities.
  • Cost Sheet View: Adds financial markup layers including Contingency %, Factory Overheads %, and Target Profit Margin % to display final projected selling prices.

4. Generated Report Outputs 📊

The module generates standardized, high-speed Excel workbooks:

1. BOM_Report.xlsx (Bill of Materials)

  • Multi-Level Explosion: Traverses nested sub-assemblies recursively down to raw materials.
  • Costed Breakdowns: Detailed unit rates and extended costs per process and input type (Raw Material, Packing Material, Labour, Sub-Assembly).
  • By-Product Accounting: Details secondary salvage outputs deducted from gross production costs.

2. BOQ_Report.xlsx (Bill of Quantity)

  • Unpriced Formulation: Focuses purely on component specifications, stages, and net consumption quantities.
  • Pick-List Generation: Ideal for issuing pick lists to warehouse staff or verifying gross physical requirements.

3. BOM_Change_Log.xlsx (Revision History)

  • Change Note Audit: Displays line-by-line modifications, showing previous quantities vs updated quantities.
  • Audit Reference: Maps each revision to its mandatory 9-digit Change Note No, modification date, and engineering rationale.

5. Specialized Diagnostic Sheets 🔍

Within the comprehensive workbook exports, the following diagnostic tabs provide actionable insight:

Sheet / AnalysisPurpose & Impact
Missing BOMsIdentifies active products that have been sold via Sales Invoices but lack a defined BOM recipe, preventing uncosted shipments.
BOM SummaryA high-level overview per finished product showing aggregate material costs, labor overheads, and profit margins.
Inactive BOMsAudits obsolete or retired formulations no longer active on the production floor.
Related Sub-AssembliesTraces parent-child relationships between top-level products and shared sub-assemblies.

6. Best Practices / Tips 💡

  • Synchronize UOMs: Ensure the consumption unit in the BOM matches the inventory unit of measure. Mismatches will distort Cost Sheet valuations.
  • Audit Missing BOMs Regularly: Review the Missing BOMs report periodically to ensure no newly introduced finished products are released without approved engineering recipes.
  • Evaluate LPR vs WAR in Volatile Markets: Use LPR to estimate current replacement manufacturing costs during periods of rapid raw material price inflation, and WAR for standard accounting audits.