How to Make a BOM: Difference between revisions

From Open Source Ecology
Jump to navigation Jump to search
Line 16: Line 16:
##To create a Google Doc from the [[BOM Template]], click the Edit link below the spreadsheet. You will be taken to the actual template.
##To create a Google Doc from the [[BOM Template]], click the Edit link below the spreadsheet. You will be taken to the actual template.
##Go to File->Make a copy... and make a copy of the template.
##Go to File->Make a copy... and make a copy of the template.
##To embed the Google Doc in a wiki page, see [[Embedding Google Docs in the Wiki]].
#If you do not use Google Docs, just use the wiki and create a page with the BOM that includes the spreadsheet by using wiki markup.
#If you do not use Google Docs, just use the wiki and create a page with the BOM that includes the spreadsheet by using wiki markup.
#Embed your google doc in a wiki page of your choice. Name the wiki page _______(module) BOM.
#Embed your google doc in a wiki page of your choice. Name the wiki page _______(module) BOM.

Revision as of 00:31, 2 August 2013

Introduction

A complete Bill of Materials (BOM) specifies parts/materials/resources needed for a build, and specifies where/how to get them. A formal BOM should include the following for each specified purchase item:

  1. Quantity
  2. Item description. Write down unique identifying properties.
  3. Link - direct link that takes one to arrive at description, source, or price (whenever available)
  4. AVL - Approved Vendor List - this defines what vendor the item can be purchased from. If a specific Link is provided above, the AVL must also be filled out. This specifies what may be substituted. If it doesn't matter, write Open/Any. If a specific manufacturer is required, write down that specific manufacturer or distributor. The AVL may also be specified in the negative, such as - do not buy from Manufacturer X.
  5. AVL PN - Approved Vendor List Part Number - specify the manufacturer's or distributor's part number whenever possible.
  6. MOQ - Specify the Minimum Order Quantity
  7. Lead Time - time to doorstep - or required from the placement or order to arrival of product at your doorstep. If shipping is not included, specify instructions for how to ship/pick up/deliver the item.
  8. Price. Critical element for assessing cost to performance ratios of desired products.

Protocol

  1. Create a Google Doc spreadsheet for your BOM - use this BOM Template. Make sure you have included as many of the BOM items in the Introduction above as possible.
    1. To create a Google Doc from the BOM Template, click the Edit link below the spreadsheet. You will be taken to the actual template.
    2. Go to File->Make a copy... and make a copy of the template.
    3. To embed the Google Doc in a wiki page, see Embedding Google Docs in the Wiki.
  2. If you do not use Google Docs, just use the wiki and create a page with the BOM that includes the spreadsheet by using wiki markup.
  3. Embed your google doc in a wiki page of your choice. Name the wiki page _______(module) BOM.
  4. Embed an Editing Link to your Google Doc below the Google Doc on that wiki page.
  5. Copy the link to your BOM wiki page into the Development Template for your module.

Links