CASE/07 / Manufacturing
IndiaPigment manufacturing off Excel
Shared product and client identifiers connect pricing, margins and procurement.
01 / THE ASK
The decision behind the brief.
Move pricing, composition and procurement work out of disconnected spreadsheets.
02 / WHAT WE FOUND
What the work revealed.
Departments worked with separate Excel workflows. Pricing and margin decisions needed consistent product and client identifiers, with access controls around proprietary formulations.
03 / WHAT WE BUILT
One product record across departments.
One set of identifiers
Operations moved to a database with unique product and client identifiers shared across departments.
Pricing linked to the client
A custom web application ties product margin calculations to client identifiers for consistent pricing and faster product enquiry handling.
Procurement and controlled access
Procurement analytics show raw material costs. Authentication restricts access to proprietary formulations.
Placeholder for an approved, masked view of the delivered work.
04 / THE RESULT
Shared product and client identifiers connect pricing, margins and procurement.
A shared database and web application connect product pricing, margin calculations and procurement information. Formulation access is controlled.
[CONFIRM: product enquiry turnaround baseline, measurement period and final figure]
SCOPED, NOT DELIVERED
Next phase
Machine learning exploration on formulations.
05 / ENGINEERING DETAILUnder the hood
- Excel workflows
- Database with shared identifiers
- Pricing application and procurement analytics
The confirmed design links client identifiers to product margin calculations and uses authentication around formulation access. [CONFIRM: database, application framework and access model]
Workflow sketch. Unconfirmed components are marked explicitly.
- [CONFIRM: stack]
A GOOD PLACE TO START