Case Study: Batch-wise & Product-wise Costing
Finance-grade batch costing and traceability solution built on SAP for a complex, multi-unit specialty chemical manufacturing environment.
Objective
Achieve precise batch-wise costing for PDMB, NDMB, 2,5-DMA and other products while providing reliable monthly product-wise costing for pricing and margin decisions.
- Achieve precise batch-wise costing for PDMB, NDMB, 2,5-DMA and other products
- Provide reliable monthly product-wise costing for pricing and margin decisions
- Enable full parent–child batch traceability including partial consumption and by-product reuse
- Eliminate dependence on Excel and Google Sheet formulas
- Standardize SAP data entry via SOPs
Business Problem
The warehouse faced operational inefficiencies due to manual processes and limited system intelligence, resulting in delayed store replenishment. Material traceability was a major issue across production units.
- Material traceability was a major issue across multiple production units
- Significant time wasted searching for material and cross-referencing batches
- High manpower engagement for fetching cost data from SAP
- Delivery to stores was impacted and delayed due to costing bottlenecks
Strategic Framework & Solution
Methodology: Agile delivery with MoSCoW prioritization was used due to evolving costing edge cases and the client's emphasis on precision over features.
Discovery & Design
Requirement gathering, process mapping, SAP data understanding, and definition of ERP, logistics, and costing workflows.
Build & Integration
Development of core costing modules, Fleet Tracker integration, and automated SAP-to-system data pipelines.
Pilot & Validation
Controlled rollout, batch-wise costing validation, GPS tracking verification, and finance-led output sign-off.
Scale & Optimization
Full-scale rollout across warehouses and plants, SOP enforcement, monitoring, and continuous optimization.
Solution Overview
A comprehensive batch-wise and product-wise costing solution was implemented to address the complexity of multi-stage manufacturing and cross-unit material flows. The solution treats each production batch as a parent entity, linking all consumed raw materials and in-house intermediates as child batches. It supports partial batch consumption with accurate cost carry-forward, ensuring precise traceability across production stages.
- Automated SAP-to-costing data pipeline — production, material movements, batch records, and cost data extracted nightly from SAP into the costing engine
- Completely eliminates manual query execution, Excel exports, and formula-based calculations
- Finance-friendly costing interface — select product code and date range to generate batch-wise cost and monthly product cost outputs
- Standardized SAP data entry SOP defined and enforced, eliminating duplicate postings and incorrect material issues
Key Features Implemented
Before vs After Comparison
Deployment Impact & Business Value
Batch-wise costing acceptance by finance after SOP and validation
Reduction in manual effort by eliminating SAP queries and Excel handling
Accuracy improvement in pricing and margin decisions using batch costs
Parent–child batch traceability across stages, units, and by-products
Client Portfolio
Leading Indian specialty chemical manufacturer ("Crystal") producing intermediates and specialty products such as 2,5-dimethylaniline. Operations span 4–5 production units across India.
- Industry: Chemical manufacturer
- Operations: 4–5 production units across India
- Products: PDMB, NDMB, 2,5-DMA and other specialty intermediates
Industry Use Cases
Specialty chemical and chemical intermediates manufacturers running SAP, with multi-stage manufacturing, multiple plants and cross-unit batch flows, and significant by-product reuse.
- Plants requiring accurate batch-wise costing for margin and price setting
- Traceability for audits, quality investigations, and regulatory reporting
- Environments where SAP alone is not delivering the required granularity
- Organizations where spreadsheets have become too complex and fragile
SWOT Analysis
Strengths
- Finance-grade accuracy with SAP integration
- Full parent–child batch traceability
- Automated data pipeline eliminating manual effort
- Scalable framework for multi-product environments
Weaknesses
- Initial SAP configuration complexity
- Dependency on consistent master data quality
Opportunities
- Expansion to additional product lines and plants
- Predictive costing with AI/ML models
- Real-time cost dashboards for management
Threats
- Raw material price volatility affecting cost baselines
- Regulatory changes in chemical industry compliance
Conclusion
The batch-wise costing project for the specialty chemical manufacturer successfully bridged the gap between SAP's standard costing capabilities and the client's need for highly granular, traceable cost information in a complex, multi-stage environment. By combining an automated SAP data pipeline, a robust parent–child batch model, and a simple finance-friendly interface, the solution delivered precise batch-wise costing and laid the groundwork for reliable product-wise costing, while significantly reducing manual effort and spreadsheet dependency. The approach and framework used here provide a repeatable blueprint for similar chemical and process industries struggling with costing complexity and ERP limitations.
Want similar results?
Let's talk about how Gemba Connect can deliver measurable outcomes for your operations.