Medical Supplies Distributor with a Commercial Printer Subsidiary — Des Moines, Iowa · Project 3 of 3 (2003)
Client Challenge
No activity-level profitability visibility across markets, buying groups, customers, product lines, and vendors — 60M monthly transactions
JDE’s Enterprise Profitability Solutions proved inoperable
Client Solution
Executive Approval: Secured on market research including in-person interviews with Owens & Minor executives, the ABC pioneers
ABC Application: Designed and developed a rate-based ABC application mirroring EPS with surpassed functionality — integrated with Sales Orders, Inventory, Manufacturing, Purchasing, A/R, A/P, and GL
Middleware: Designed and directed development of middleware exporting JDE and ABC data to the Sylvon data warehouse and performance-management reporting
Analysis: Whale Curve profitability analysis by market, buying group, customer, product line, product, and vendor
Client Impact Results
Over $5M in cost recovery identified — a top product unprofitable due to sales commissions and a distribution channel unprofitable due to SG&A
Whale Curve analysis drove executive action
Client Technologies
Rate-based ABC application — RPG on AS/400-DB2, integrated with co-existent JDE OneWorld XE and World
Sylvon data warehouse middleware (60M monthly transactions)
Whale Curve analysis
