Free Bill of Materials Template

bill of materials template

Looking for a simple bill of materials template? Fishbowl created this template in Excel for that very reason. It's organized in a way to easily and effectively create a bill of materials.

Bill of Materials Overview:

The top section of the template gives a brief overview of all the information that is contained in the lower sections. Some of the cells get automatically updated as you enter information on part costs and quantities into the columns and rows under them. Here is a list of these components, along with their description.

Product Name: This is the name by which the finished goods will be identified when selling it to your customers.

Approved By: The name of the individual within your company who is responsible for signing off on this particular bill of materials.

Date of Approval: The month, day, and year that the bill of materials was approved to go into production.

Part Count: The total number of parts that are included in the bill of materials, derived from all of the numbers in the Quantity column.

Total Cost: The amount of money that you paid to obtain all of the items used in the bill of materials, calculated by adding up all of the numbers in the Amount column.

Additional Notes: This section can be filled with any extra information you would like to include about the product, person who approved it, contact information, instructions, etc.

Picture of Assembly: This is optional, but it may be helpful to include a picture of what the finished good will look like as a reference point.

Bill of Materials Details:

The lower section of the bill of materials gets into the details of what parts are contained in the finished good. Again, here is a list and description of each of the column headers.

Part Number: This internally used number helps you find the appropriate part in your inventory system and distinguish it from every other part you work with.

Part Name: To further identify a part beyond using an abstract number, you can include the part’s name in this column.

Description: This goes beyond the name to describe aspects of the part, such as its dimensions, weight, color, and other features that may come in handy for your workers.

Quantity: The amount or volume of a specific part that will be used in the manufacturing process to assemble the finished good.

UOM: The unit of measure is the way you distinguish identical items from each other. It could be each, package, gallon, foot, pound, or any other means by which the item is measured.

Part Image: Like the Picture of Assembly, the part image lets you and your workers visualize the individual parts that you are looking for and working with.

Unit Cost: The amount of money that you paid to the vendor (including landed cost, if applicable) to obtain a single part.

Amount: This multiplies the Quantity by the Unit Cost to calculate the total cost of all of the copies of a particular part that are being used.

Total Parts: This corresponds to the Part Count on the top left of the bill of materials. It simply adds up the total number of parts being used in the column above it.

Total: This corresponds to the Total Cost, which is also on the top left of the bill of materials.

Watch the Fishbowl Quick Tour Video