Last quarter, a procurement manager at an industrial equipment manufacturer in Pune forwarded me a spreadsheet. She was sourcing components for a new hydraulic press assembly. The BOM had 342 line items. Forty-seven different suppliers needed to quote on various subsets of those items. She’d been working on the sourcing package for three weeks and still hadn’t sent the first RFQ because she couldn’t get the data into a format that suppliers could actually quote against.

The engineering team had sent the BOM in a format that made sense to engineers. Part numbers, revision codes, tolerance specifications, material grades. All useful information. None of it organised in a way that a steel fastener supplier in Ludhiana could look at and say “yes, I can quote on these 28 line items.” She had to manually split the master BOM into supplier-specific packages, reformat each one, add commercial terms, and track which version she’d sent to whom. That’s not procurement. That’s data entry with a purchasing title.

What Is BOM Sourcing?

A Bill of Materials is a list of every part, component, and raw material needed to build a product. If you’re manufacturing a hydraulic press, the BOM might include steel plates, hydraulic cylinders, seals, fasteners, electrical components, paint, and packaging materials. Could be 50 items. Could be 500. Depends on the complexity of what you’re building.

BOM sourcing is the process of taking that list and turning it into purchase orders. Which suppliers can provide which items? At what price? With what lead time? And how do you compare quotes across dozens of suppliers when each one is quoting on a different subset of the BOM in a different format? That’s the job. It’s used in manufacturing, construction, electronics, automotive, and basically any industry where the finished product is assembled from a long list of purchased components.

Why BOM Sourcing Feels Harder Than It Should

The BOM itself isn’t the problem. It’s a list. Lists are simple. The problem starts the moment you try to do something with it. Engineering hands you a master BOM with 300+ items. Some of those items are standard catalogue parts. Some are custom fabrications. Some need to come from certified suppliers. Some are available from anyone. You can’t send the entire BOM to every supplier because most of them only supply a fraction of what’s on it.

So you split it. You pull out the fasteners and send that package to your fastener suppliers. You pull out the machined components and send those to your machine shops. You pull out the electrical items and send those to your electrical distributors. Now you’ve got 12 separate RFQ packages going to 47 suppliers, and every one of them needs to come back in a format you can compare. Except they won’t. One supplier quotes per piece. Another quotes per kilogram. A third sends a PDF with handwritten corrections. And you’re supposed to build a comparison from that.

That’s before version control enters the picture. Engineering revises the BOM mid-sourcing because a spec changed. Now half your quotes are based on the old version and the other half are based on the new one. Which quotes are still valid? Nobody’s entirely sure.

The Specific Things That Go Wrong

Data errors that nobody catches until it’s too late
A procurement analyst copies 342 line items from an engineering BOM into a sourcing spreadsheet. She transposes two digits on a part number. The supplier quotes on the wrong item. Nobody catches it until the material arrives at the factory and the production team says “this isn’t what we ordered.” At that point, you’re three weeks into a lead time you have to restart from scratch. One typo. Three weeks lost.
Version chaos
Which version of the BOM is current? The one in the shared drive? The one the QS emailed last Tuesday? The one engineering updated on Friday but forgot to tell procurement about? On a complex product with an evolving design, the BOM can go through ten or fifteen revisions during the sourcing phase. If your team is working from a version that’s even one revision behind, the quotes are wrong. And quoting against the wrong revision is worse than not quoting at all because it creates false confidence in numbers that don’t reflect what’s actually being built.
Comparisons that take longer than the evaluation
Supplier A quoted in INR per unit. Supplier B quoted in USD per kilogram. Supplier C sent a PDF with pricing embedded in a table that your spreadsheet can’t parse. Before you can evaluate anything, somebody has to reformat all of it into a common structure. That reformatting work is boring, error-prone, and takes days. I’ve seen procurement teams spend more time preparing the comparison than actually making the sourcing decision.
Nobody can see what’s happening
The procurement lead knows the status of the sourcing event because she’s running it. The project manager doesn’t. The finance controller doesn’t. The production planner who needs to know when materials will arrive definitely doesn’t. On spreadsheet-based BOM sourcing, visibility is limited to whoever has the latest version of the file. Everyone else is sending emails asking “where are we on the BOM?”

Manage Complex BOMs Without the Spreadsheet Chaos

ProcureKey gives procurement teams structured sourcing, supplier collaboration, and real-time visibility on every BOM package.

How to Speed the Whole Thing Up

Standardise the BOM format before sourcing begins

Don’t start sourcing from an engineering BOM that was designed for engineers. Convert it into a procurement-ready format first. That means adding commercial fields like unit of measure, target price, delivery requirement, and supplier allocation. It takes half a day upfront. It saves a week downstream.

Build supplier-specific templates once and reuse them

If you source from the same 50 suppliers on every project, you already know which categories each one covers. Build RFQ templates by supplier category so that splitting the BOM into packages takes minutes instead of hours. Think of it as a routing table: part type X goes to supplier group Y. Once the routing exists, every new BOM follows the same path.

Source Your Next BOM in Days, Not Weeks

ProcureKey gives procurement teams structured RFQs, automated comparison, and real-time visibility across every line item.
Share it :
Download The Complete PDF

    This will close in 0 seconds

    Watch Webinar


      This will close in 0 seconds

      Book a meeting at CPO Summit

      This will close in 0 seconds

      This will close in 0 seconds