Skip to main content

Bill of Materials

The data model encompasses standard and calculated costs for a bill of materials, including material, packaging, setup, labor, overhead, subcontract, and tool costs for both standard items and individual items. It also includes total costs (standard, recent, actual), percentage variation between actual and standard costs, and quantity on hand. Views offer insights on actual vs standard vs most recent costs and variance analysis for the bill of materials.

Benefits of This Data Model​

  • Enhanced Cost Analysis: The data model allows for detailed analysis of standard and calculated costs across various components such as material, labor, setup, and more, providing insights into cost breakdowns at a granular level.
  • Improved Cost Monitoring: Users can easily track total costs, percentage variations, and quantity on hand, enabling better monitoring and management of financial aspects related to the bill of materials.
  • Efficient Variance Identification: By utilizing the views on actual vs standard costs and variance analysis, stakeholders can promptly identify discrepancies and take necessary actions to address any cost variations in the bill of materials.

Key Performance Indicators (KPIs)​

  • Standard Item Cost Material: Cost of materials required for a standard item in the bill of materials.
  • Standard Item Cost Packaging: Cost of packaging materials for a standard item in the bill of materials.
  • Standard Item Cost Setup: Cost of setup activities associated with a standard item in the bill of materials.
  • Standard Item Cost Labor: Cost of labor for producing a standard item in the bill of materials.
  • Standard Item Cost Overhead: Overhead costs related to producing a standard item in the bill of materials.
  • Standard Item Cost Subcontract: Cost of subcontracted services for a standard item in the bill of materials.
  • Standard Item Cost Tool: Cost of tools required for producing a standard item in the bill of materials.
  • Calculated Item Cost Direct Material: Calculated cost of direct materials for an item in the bill of materials.
  • Calculated Item Cost Packaging: Calculated cost of packaging materials for an item in the bill of materials.
  • Calculated Item Cost Setup Labor: Calculated cost of setup labor for an item in the bill of materials.
  • Calculated Item Cost Direct Labor: Calculated cost of direct labor for an item in the bill of materials.
  • Calculated Item Cost Overhead: Calculated overhead cost for an item in the bill of materials.
  • Calculated Item Cost SubContract: Calculated cost of subcontracted services for an item in the bill of materials.
  • Calculated Item Cost Tool: Calculated cost of tools required for an item in the bill of materials.
  • Total BOM Calculated Cost: Total calculated cost for the bill of materials.
  • Total BOM Standard Cost: Total standard cost for the bill of materials.
  • Total BOM Recent Cost: Total recent cost for the bill of materials.
  • Total BOM Actual Cost: Total actual cost for the bill of materials.
  • % Actual Vs Standard Variation: Percentage variation between actual and standard costs in the bill of materials.
  • Qty on Hand: Quantity of items currently in stock.

Available Visualizations​

View NameDescription
BOM Cost (Actual vs Standard vs Most Recent)Offers insights on actual vs standard vs latest cost of Bill of Materials.
BOM Cost (Actual vs Standard)Provides insights on the variance between actual and standard Bill of Materials cost.