Title Bill Of Materials
Navigation Content With this file, you easily create
By tracking the unit cost, you c
Inventory Master List Easily print the finished BOM in
Analysis of Inventory Master
Bill of Materials
Customization difficulty (1-3) 1
Explanation of sheets Inventory Master List: A BOM consists of multiple com
Very important: If you decide to
Analysis of Inventory Master: Once you have updated the "In
Bill of Materials: On this sheet, you can update
How to customize 1) Update the Inventory Master L
2) Using the "Bill of Materials" she
3) If you want to have multiple BO
6) If needed, check out the video
Related To Online Templates Our templates is compatible wi
Here is some hints that replace
Referesh / Update Data Some of our templates include
Full Screen Some of our templates have Fu
Other Macros / Buttons Other macros is applied on les
Open in Desktop App To open online template using
All content is Copyright materia
http://www.simplesheets.co
© 2020 Simple Sheets LLC
All rights reserved. The conten
No part of this publication may
Bill Of Materials
With this file, you easily create a BOM to keep track of the individual components needed to manufacture a product.
By tracking the unit cost, you can also quickly identify the raw material costs you will be incurring in the course of production.
Easily print the finished BOM in landscape mode.
A BOM consists of multiple components and sub-components. Enter all relevant information on this sheet, the prepopulated data will ser
Very important: If you decide to change the name of the headers, you need to change the names on the "Bill of Materials" sheet as well!
Once you have updated the "Inventory Master List" sheet, refresh the Pivot table and get an understanding of the total production costs
On this sheet, you can update columns B:B and E:E with the respective information coming from the "Inventory Master List". All grey cel
Update the Inventory Master List. If you decide to change the name of the headers, ensure that they match the headers on the "Bill of M
Using the "Bill of Materials" sheet, you can put together individual BOMs based on your "Inventory Master List". Ensure that you only pop
f you want to have multiple BOMs in this file, simply copy-paste the "Bill of Materials" sheet.
f needed, check out the video in which I walk you through each and every step!
Our templates is compatible with online service but some templates that including macros feature is still not supported with Excel Online
Here is some hints that replace our macros in case of using Online Template
Some of our templates include Referesh/Update data macro button that can be replaced with Referesh All tool in Excel Online ribbon
Some of our templates have Full Screen macro button that can be replaced with the itself web browser full screen tool
Other macros is applied on less than ~15% of our templats can be overcome by transferring to Desktop App "Open in Desktop App" b
To open online template using Desktop App be sure that you signed in to your Microsoft account / Onedrive account
All content is Copyright material of Simple Sheets LLC.
http://www.simplesheets.co
© 2020 Simple Sheets LLC
All rights reserved. The contents of this publication, including but not limited to all written material, content layout, images, formulas, and
No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted without prior written permission of the p
ure a product.
course of production.
eet, the prepopulated data will serve as a guidance for you.
e "Bill of Materials" sheet as well! The formulas won't work unless there is an exact match between the both sheets.
ding of the total production costs per component.
nventory Master List". All grey cells will update automatically.
atch the headers on the "Bill of Materials" sheet.
ster List". Ensure that you only populate the cells in green, everything else will update automatically.
ll not supported with Excel Online
h All tool in Excel Online ribbon
r full screen tool
p App "Open in Desktop App" button
drive account
tent layout, images, formulas, and code, are protected under international copyright and trademark laws.
ut prior written permission of the publisher, except in the case of certain noncommercial uses permitted by copyright law.
e both sheets.
d by copyright law.
Final Output SKU Category UoM Name
Monitor 12348 LED Panel Pieces Placeholder1
Monitor 87946 Screws Pieces Placeholder2
Monitor 74854 Stand Pieces Placeholder3
Monitor 85468 Power Supply Pieces Placeholder4
Monitor 54231 Cables Pieces Placeholder5
Monitor 65412 Cables Pieces Placeholder6
Monitor 46853 LCD Display Pieces Placeholder7
PC 96828 Motherboard Pieces Placeholder8
PC 60091 Power Supply Pieces Placeholder9
PC 73842 CPU Pieces Placeholder10
PC 45112 RAM 8 GB Pieces Placeholder11
PC 43626 RAM 16 GB Pieces Placeholder12
PC 81662 RAM 32 GB Pieces Placeholder13
PC 89091 Hard Disk Drive 512 GB Pieces Placeholder14
PC 68113 Solid State Drive 256 GB Pieces Placeholder15
PC 76919 Solid State Drive 512 GB Pieces Placeholder16
PC 96024 Graphics card Pieces Placeholder17
PC 45614 Case Pieces Placeholder18
PC 78342 Screws Pieces Placeholder19
Unit Cost FO
$ 17.00 Monitor
$ 2.50 Monitor
$ 3.00 Monitor
$ 4.50 Monitor
$ 1.70 Monitor
$ 3.20 Monitor
$ 13.00 Monitor
$ 34.00 PC
$ 12.00 PC
$ 120.00 PC
$ 12.00 PC
$ 24.00 PC
$ 48.00 PC
$ 45.00 PC
$ 90.00 PC
$ 180.00 PC
$ 170.00 PC
$ 23.00 PC
$ 0.30 PC
Final Output Category Name
Monitor
Cables
Placeholder5
Placeholder6
LCD Display
Placeholder7
LED Panel
Placeholder1
Power Supply
Placeholder4
Screws
Placeholder2
Stand
Placeholder3
PC
Case
Placeholder18
CPU
Placeholder10
Graphics card
Placeholder17
Hard Disk Drive 512 GB
Placeholder14
Motherboard
Placeholder8
Power Supply
Placeholder9
RAM 16 GB
Placeholder12
RAM 32 GB
Placeholder13
RAM 8 GB
Placeholder11
Screws
Placeholder19
Solid State Drive 256 GB
Placeholder15
Solid State Drive 512 GB
Placeholder16
Total Result
Sum of Unit Cost
$ 44.90
$ 4.90
$ 1.70
$ 3.20
$ 13.00
$ 13.00
$ 17.00
$ 17.00
$ 4.50
$ 4.50
$ 2.50
$ 2.50
$ 3.00
$ 3.00
$ 758.30
$ 23.00
$ 23.00
$ 120.00
$ 120.00
$ 170.00
$ 170.00
$ 45.00
$ 45.00
$ 34.00
$ 34.00
$ 12.00
$ 12.00
$ 24.00
$ 24.00
$ 48.00
$ 48.00
$ 12.00
$ 12.00
$ 0.30
$ 0.30
$ 90.00
$ 90.00
$ 180.00
$ 180.00
$ 803.20
Bill of Materials
Finished Product Computer Setup
Total number of pieces 52.0
Total Price $ 961.80
Final Output SKU Category Name Quantity UoM Unit Cost Cost
Monitor 12348 LED Panel Placeholder1 2 Pieces $ 17.00 $ 34.00
Monitor 87946 Screws Placeholder2 12 Pieces $ 2.50 $ 30.00
Monitor 74854 Stand Placeholder3 1 Pieces $ 3.00 $ 3.00
Monitor 85468 Power Supply Placeholder4 1 Pieces $ 4.50 $ 4.50
Monitor 54231 Cables Placeholder5 12 Pieces $ 1.70 $ 20.40
Monitor 65412 Cables Placeholder6 13 Pieces $ 3.20 $ 41.60
Monitor 46853 LCD Display Placeholder7 1 Pieces $ 13.00 $ 13.00
PC 96828 Motherboard Placeholder8 1 Pieces $ 34.00 $ 34.00
PC 60091 Power Supply Placeholder9 1 Pieces $ 12.00 $ 12.00
PC 73842 CPU Placeholder10 1 Pieces $ 120.00 $ 120.00
PC 81662 RAM 32 GB Placeholder13 2 Pieces $ 48.00 $ 96.00
PC 76919 Solid State Drive 512 GB Placeholder16 2 Pieces $ 180.00 $ 360.00
PC 96024 Graphics card Placeholder17 1 Pieces $ 170.00 $ 170.00
PC 45614 Case Placeholder18 1 Pieces $ 23.00 $ 23.00
PC 78342 Screws Placeholder19 1 Pieces $ 0.30 $ 0.30
Total 52 $ 961.80
