Custom Plastic Molding Job Shop
Client Challenge
A CPQ solution was needed for growing demand and complexity of custom products
The client believed no commonality existed across historical jobs — every quote built from scratch
Client Solution
Hypothesis Testing: Established the alternative hypothesis (≤10 production profiles) against the client’s null
Data Mining: Applied clustering, neural networks, decision trees, and basket analysis across millions of historical records in Microsoft Analysis Services
Design: Future-state Quote-to-Cash and PLM processes; PDM best-practice documentation; recommended Master Planner and PDM Manager roles
Client Impact Results
Result: Null hypothesis rejected — 5 core profiles generated by ML now anchor the proposed CPQ application
Adoption: Future-state QTC and PLM approved by C-level and departmental leadership
Client Technologies
Microsoft SQL Server Analysis Services (clustering, neural networks, decision trees, basket analysis)
S2K ERP
Data mining methodology
