I Made a BOM Spreadsheet So You Don’t Have To

This was written for and published on the Propel blog on November 4, 2019


Sorry SaaS products this one isn’t for you.

Regardless of the type of physical product you manufacture, BOMs must include the information that:

  • Engineering and Development teams need to track product so that they can anticipate changes should components change or become obsolete.
  • Finance teams need to plan for costing and Sales forecasts.
  • Operations and Manufacturing teams need to break forecasts down to plan for production, equipment, and warehousing.
  • Product Management teams need to plan for feature roadmaps and integrations.
  • Marketing and Sales teams need to articulate product functionalities and configurations for customers.

Great stuff right? But what is a BOM exactly?

Let’s dive in.

What is a BOM and who works on it?

Think of a BOM as a recipe or ingredient list.

If a cake had a “BOM” it might include flour, butter, eggs, sugar, milk, etc.

The bill of materials as it relates to the product lifecycle, is created by mechanical engineers during the design phase of a product when working in CAD (Computer-Aided Design) and then shared with internal and external teams for contextual collaboration and feedback.

By incorporating other teams earlier in the design process of a product you can speed up production and ensure the right products are in your customer’s hands faster.

How is that possible you might ask?

The sooner you involve more teams, the sooner you can conduct early manufacturing testing and compare alternate suppliers before production thus preventing possible launch delays.

Think of it as stretching before a workout, if you take all the proper precautions and stretch before a run, you’re less likely to suffer an injury or in this case a production hiccup or launch delay.

How do I make a BOM?

One might say that the BOM fountainhead is the spreadsheet.

Bill of Materials Template

This template is a great starting point if you’re looking for a way to manage your multi-level BOMs with an Excel spreadsheet. Because this is a workable and editable template, you can adjust the template to add as many levels as you need.

In this template you can:

1. Add the lifecycle phase of the component.

2. Apply the part category to each piece of the BOM.

3. Apply revision numbers to each component or part of the BOM if necessary.

The template also includes columns to notate quantities, item numbers, redlines and more.

Are you ready to put on your Excel hat?

Download the template today and start managing your BOMs with Propel’s free BOM spreadsheet template.

Hence forth!

I’m a seasoned designer and digital marketer who loves to write. Blog posts created for work and clients live here as well.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store