Parts manufacturer · Second-tier supplier of injection-molded parts
Spreadsheet automation for a manufacturer: every client’s production plan in one format
At a parts manufacturer, three people spent 8 hours a day copying clients’ production plan files into spreadsheets. AI now converts them into the company’s own format. The format conversion matched the answer files 100%, and the parts breakdown matched 95.5% across 11 vehicle models.
Before
Every client sent production plan files in a different format. Three people spent 8 hours a day breaking them down in spreadsheets and copying them into the company’s plan. Codes changed often, so they matched them by hand each time, and they also made separate purchase orders for each subcontractor.
What we did
- Converts every client’s production plan file into one company format.
- Reads the spec sheet for new codes and breaks them down into a bill of materials (BOM).
- Splits purchase orders by subcontractor, and builds the injection production plan for each machine.
In their words
“Like I said, three people work on this for a full 8 hours. They do only this every day, so they can’t get other work done, and they always end up leaving late.”
— Staff member at the manufacturer, at the first meeting (translated from Korean)
How it went
- AI read the production plan emails and spreadsheets from clients, and moved code, vehicle model, color, quantity, and date into the company’s plan format.
- Existing codes were matched right away. For new codes, AI read the spec sheet and broke them down into a bill of materials.
- Subcontracted work was split by subcontractor, with a purchase order for each.
- AI handles matching codes and formats. Quantity and date calculations are left to spreadsheet formula rules.
What we measured
The plan format conversion matched the answer files 100%. The parts breakdown matched 95.5% across 11 vehicle models.
What AI does not do
The person in charge checks the final quantities and dates.
Where it stands
The production management team confirmed that entering a client’s plan produces the company plan, the parts breakdown, the subcontractor purchase orders, and the production plan for each machine in one go. Three people used to spend 8 hours a day on this work.