Mastering COGS Calculation in Manufacturing with Dynamics Business Central

Why COGS Matters in Business Central

COGS represents all direct costs to produce and deliver sold items. For manufacturers, this includes:

• Raw materials

• Direct labor

• Machine/workshop overhead

• Subcontracting fees

In Business Central, COGS isn’t a manual estimate. It’s dynamically calculated based on:

• Your costing method (FIFO, Standard, Average)

• Real-time production transactions

• Automated adjustments for purchases, returns, or revaluations

Missteps here distort gross margins. Let’s fix that.

Core COGS Components in Manufacturing

1. Material Costs

• Source: Components in your Production BOM (Bill of Materials).

• Tracking: When items are consumed via Production Journals, costs flow from inventory to WIP.

• Pro Tip: Use Item Charges for freight, import duties, or auxiliary material costs.

2. Labor & Capacity Costs

• Work Centers/Machine Centers: Define hourly rates for resources. Includes:

  • Direct labor ($/hour)

  • Indirect costs (e.g., 10% for benefits)

  • Overhead (fixed fees like electricity)

• Routing Setup: Link operations to Machine Centers so run-time automatically accrues costs.

3. Overhead & Indirect Costs

• Factory Overhead: Rent, utilities, depreciation of production equipment.

• Allocation Methods:

  • Apply as a % of labor/machine time

  • Use lot sizes to distribute setup costs (e.g., $500 setup ÷ 100 units = $5/unit)

Choosing Your Costing Method in Business Central

Business Central supports five methods. Key manufacturing-fit options:

Table: Costing Method Comparison

The Role of Production BOMs & Routings

Your Production BOM and routing dictate how costs accumulate:

• BOMs define material components and quantities.

• Routings specify operations (e.g., cutting, welding) tied to Machine/Work Centers.

When a Production Order is released:

1. Material costs are reserved from inventory.
2. Capacity costs accrue based on routing time.
3. Subcontracting costs (e.g., external plating) post via purchase invoices linked to operations.

Step-by-Step: How COGS Calculates on Production Sales

Phase 1: Track Costs During Manufacturing

• Consumption Journals: Record actual material usage (updates WIP).

• Capacity Journals: Log labor/machine hours (converts to $ via center rates).

• Output Journals: Post finished goods to inventory at calculated cost.

Phase 2: Posting the Sale

When you sell a manufactured item:

But where’s the cost breakdown?

Phase 3: Break Down COGS with Cost Shares

Business Central’s Cost Shares Breakdown report decomposes COGS into:

• Material

• Capacity (labor/machine)

• Capacity overhead

• Manufacturing overhead

• Subcontracted costs

Table: Sample COGS Breakdown for a Bicycle

Troubleshooting Common COGS Challenges

1. Purchase Returns & Cost Adjustments

If you return materials bought at $10 but credit at $8:

• Business Central auto-posts a $2 adjustment to COGS via Direct Cost Applied.

2. Work in Progress (WIP)

WIP accounts temporarily hold costs during production. Reconcile periodically to avoid COGS leaks.

3. Variances in Standard Costing

Track variances like:

• Material Usage: Over-consumption of components

• Capacity Variance: Machine downtime vs. planned 

Pro Tips for Accurate COGS

1. Enable Exact Cost Reversing: Ensures sales/purchase returns match original transaction costs.
2. Reconcile Inventory Regularly: Use Adjust Cost – Item Entries to forward cost changes.
3. Leverage Power BI: Visualize COGS trends by product line or operation.

Conclusion: COGS as Your Profit Compass

In Business Central, COGS isn’t a black box. From Production Orders to Capacity Planning, every cost pulse is tracked. Remember:

“Accurate COGS starts with disciplined setup—costing methods, BOMs, routings, and regular adjustments.”

Manufacturing profitability isn’t accidental. With Business Central, you turn cost visibility into margin control.