Skip to content
Let's Talk

Manufacturing IT & DevelopmentCase 03 of 10

Replacing spreadsheets with an ERP in a growing component factory

An auto-component manufacturer

  • RegionPune
  • ScopeTwo plants, 180 users
  • Timeline8 months
  • MarketsIndia
Download the PDF Discuss a similar project
01

Industry overview

What is shaping manufacturing

Manufacturers sell to distributors, OEMs and industrial buyers, and compete on quality, delivery and service as much as price. Many are also digitising plants, sales and finance processes.

  • Distributor networks remain central to reach
  • Buyers expect consistent quality and on-time delivery
  • Digitisation of operations and reporting is accelerating
02

Client background

An auto-component manufacturer, working in Pune. Client identity is withheld to protect confidentiality.

Organisation
An auto-component manufacturer
Sector
Manufacturing
Team engaged
IT & Development
Services
ERP development, API development & integration, Software testing & QA
03

Client challenge

Orders, production planning and inventory were tracked in spreadsheets. Stock discrepancies caused missed deliveries, and month-end closing took three weeks.

04

Research objectives

  • Deliver on the brief: replacing spreadsheets with an ERP in a growing component factory.
  • Design around the real needs of users.
  • Define requirements and success criteria the solution would be tested against.
  • Deliver a reliable, secure solution the team can run and extend.
05

Target audience

The work focused on 180 users.

  • users180

Audiences we typically reach in manufacturing

Procurement and plant headsDistributors and dealersOEM buyersService engineersFinance and operations teams

06

Geographic coverage

Coverage: Pune. Market: India.

  • India
07

Research methodology

An iterative delivery approach: discovery, design, build and test in short cycles, with the client reviewing each step.

  1. 1Brief
  2. 2Process mapping
  3. 3Phased implementation
  4. 4User training
  5. 5Insight

We mapped processes with each department, implemented finance and inventory first with barcode scanning in stores, then added sales orders, dispatch and production planning. Key users in each team were trained deeply and supported colleagues.

ERP developmentAPI development & integrationSoftware testing & QA

08

Sampling strategy

users
180
  • Users and stakeholders from every affected team took part in discovery workshops and acceptance testing.
09

Data collection

Discovery Plan & design Build / execute Test & refine Launch & handover Indicative split of the 8-month timeline.
  • Requirements were gathered through workshops, process walk-throughs and a review of existing systems and data.
10

Data quality & validation

  • Peer code review on every change
  • Automated and manual testing
  • User-acceptance testing with the client
  • Release checklist and rollback plan
11

Data analysis

  • Usage and performance monitoring after launch
  • Defect and support-ticket trends
  • Process time before and after
12

Key findings

  • Stock accuracy improved, on-time delivery rose, and month-end closing became much faster.
Phasing the rollout built confidence and avoided disrupting production.
13

Recommendations

  • Build on the core insight: phasing the rollout built confidence and avoided disrupting production.
  • Track adoption and support tickets, and plan the next release from real usage.
14

Business impact

  • Management could see margins by product for the first time.

Impact is described qualitatively.

15

Deliverables & next steps

  • Deployed solution with documentation and handover
  • Support and maintenance plan
  • Repeat the measure after changes are in place to track progress.
  • A natural follow-on question: where do customers feel service falls short?

Client identity is withheld to protect confidentiality.

More manufacturing case studies

  1. 01caseHow plant heads choose industrial equipment suppliersAn industrial pump manufacturer
  2. 02caseA distributor satisfaction programme for an electrical products makerAn electrical products manufacturer
  3. 04caseTurning a manufacturer’s website into a source of export enquiriesA precision engineering company
All manufacturing case studies

Want results like these?

Tell us about your objectives. We'll recommend an approach and confirm feasibility within one working day.

Request a QuoteTalk to an Expert