انتقل إلى المحتوى الرئيسي

BOM Calculations - Business Concept

Overview​

BOM (Bill of Materials) Calculations are used to determine the total cost of manufacturing a finished product by adding up all the costs of its components, labor, and overhead. This is essential for pricing decisions, profitability analysis, and understanding product costs.

What is a BOM Calculation?​

When you manufacture a product, you need to know:

  • How much does it cost to make?
  • What should I sell it for to make a profit?
  • Which components contribute the most to the cost?

A BOM calculation answers these questions by "rolling up" costs from the bottom (raw materials and purchased parts) to the top (finished product).

Key Concepts​

1. Calculation Groups​

What They Are: Calculation groups are templates that control HOW costs are calculated for different types of items. Think of them as "calculation rules" you assign to items.

Why They Matter:

  • Different items may get their costs from different places
  • Some items might be purchased (use purchase prices), others manufactured (calculate from components)
  • You want consistent calculations for similar items

Example:

  • MANF (Manufactured): For items you make - calculate cost from BOM components and operations
  • PURCH (Purchased): For items you buy - use purchase price or trade agreements
  • SUBCONTRACT: For outsourced manufacturing - use vendor quotes

2. Cost Price Models​

What They Are: Rules that tell the system WHERE to get component costs from during calculation.

Options:

  1. Item Cost Price: Use the item's standard cost from the product master
  2. Item Purchase Price: Use the purchase price defined for the item
  3. Trade Agreements: Use negotiated prices with specific vendors
  4. Inventory Price: Use the current average cost based on inventory value

Real-World Example: You're calculating the cost of a bicycle. For the frame (manufactured component), you might use "Item Cost Price" from a previous calculation. For tires (purchased component), you might use "Trade Agreements" to get the best negotiated price from your tire supplier.

3. Sales Price Models​

What They Are: Rules for calculating suggested selling prices.

Options:

  1. Cost Group: Add markup percentages by cost category (materials 30%, labor 50%, etc.)
  2. Item Sales Price: Use the pre-defined sales price from the product master

Example: If your manufactured bicycle costs $200:

  • Material costs: $120 (markup 30% = $36)
  • Labor costs: $50 (markup 50% = $25)
  • Overhead: $30 (markup 20% = $6)
  • Suggested Sales Price = $200 + $67 markup = $267

4. Cost Groups​

What They Are: Categories that group costs by type (Material, Labor, Overhead, Subcontract, etc.)

Why They Matter:

  • Helps you see WHERE costs come from
  • Enables targeted cost reduction (if overhead is high, look at overhead costs)
  • Supports different markup strategies by cost type

Example Breakdown:

Product: Custom Cabinet
Total Cost: $450
  - Material (lumber, hardware): $200
  - Labor (cutting, assembly): $180
  - Overhead (utilities, rent): $50
  - Finishing (painting): $20

The Calculation Process​

Step 1: Define Your Product Structure​

  • Create a BOM listing all components
  • Create a route listing all manufacturing operations
  • Assign quantities needed

Step 2: Run the Calculation​

The system:

  1. Starts at the lowest level (purchased raw materials)
  2. Gets costs based on the Cost Price Model
  3. Adds labor and overhead from the route
  4. Rolls up to the next level
  5. Continues until reaching the finished product

Step 3: Review Results​

You get:

  • Total cost per unit
  • Cost breakdown by cost group
  • Suggested sales price (if configured)
  • Multi-level breakdown showing cost buildup

Calculation Types​

1. Standard Calculation​

Used for regular cost updates to the costing version. Results are saved and can be activated to update standard costs.

2. Sales Quotation Calculation​

When quoting a price to a customer, calculate the cost on-the-fly to ensure profitability. Results are attached to the quote but don't update standard costs.

3. Sales Order Calculation​

Similar to quotation but for actual orders. Helps confirm the order is profitable before accepting it.

4. Production Order Calculation​

Calculates expected costs for a specific production batch, considering actual quantities and current prices.

Warning Conditions​

Calculation groups can be configured to warn you about potential issues:

  • No BOM Warning: Item is manufactured but has no BOM defined
  • No Route Warning: Item should have manufacturing steps but route is missing
  • No Cost Price Warning: Component has no cost defined (can't calculate)
  • No Resource Warning: Operation is missing equipment/labor resource
  • Cost Price Age: Cost data is outdated (e.g., more than 60 days old)
  • Minimum Margin: Calculated profit margin is below acceptable threshold

Real-World Scenario​

Scenario: ABC Furniture manufactures custom bookcases

Setup:

  1. Create calculation group "FURNITURE" with:

    • Cost Price Model = Item Cost Price (use standard costs)
    • Sales Price Model = Cost Group (markup by cost type)
    • Warnings enabled for missing BOMs and old costs

  2. Define cost groups with markup:

    • Materials: 25% markup
    • Labor: 60% markup
    • Overhead: 15% markup

Calculation:

Component Costs (from BOM):
  - Oak panels (20 bd ft @ $8/ft): $160
  - Hardware kit: $15
  - Finish materials: $25
  Total Materials: $200

Route Costs:
  - Cutting operation (2 hrs @ $30/hr): $60
  - Assembly operation (3 hrs @ $25/hr): $75
  - Finishing operation (1.5 hrs @ $20/hr): $30
  Total Labor: $165

Overhead (allocated):
  - 30% of labor: $49.50

TOTAL COST: $414.50

Suggested Sales Price with Markup:
  - Materials ($200 * 1.25): $250
  - Labor ($165 * 1.60): $264
  - Overhead ($49.50 * 1.15): $56.93
  TOTAL SALES PRICE: $570.93 (rounded to $571)

Gross Margin: $571 - $414.50 = $156.50 (27% margin)

Benefits​

  1. Accurate Pricing: Know your true costs before setting prices
  2. Profitability Analysis: See if products are profitable
  3. Cost Control: Identify high-cost components for negotiation
  4. What-If Analysis: Calculate costs for different scenarios (new vendor, process changes)
  5. Quotation Speed: Quickly generate accurate quotes
  6. Informed Decisions: Data-driven make-vs-buy decisions

Common Use Cases​

  • New Product Development: Calculate expected costs before production starts
  • Price Updates: Recalculate when material or labor costs change
  • Cost Reduction: Identify expensive components to substitute or renegotiate
  • Bid Preparation: Generate accurate quotes for custom orders
  • Profitability Review: Analyze product line profitability
  • Budgeting: Forecast production costs for financial planning

Best Practices​

  1. Keep Cost Data Current: Outdated costs lead to poor decisions
  2. Use Calculation Groups Consistently: Similar items should use the same rules
  3. Review Warnings: Don't ignore calculation warnings - fix the underlying issues
  4. Validate Results: Spot-check calculations against actual costs
  5. Update Regularly: Recalculate when significant cost changes occur
  6. Document Assumptions: Note which price models and markups you're using
  7. Test New Products: Run calculations before committing to manufacture

Integration with Other Modules​

  • Inventory Management: Gets item master data and current costs
  • Production Management: Uses BOM and route definitions
  • Purchasing: Can use trade agreements for component costs
  • Sales: Calculation results can be used in quotations
  • Cost Accounting: Feeds into costing versions and standard costs
  • Financial Dimensions: Costs can be analyzed by department, product line, etc.