Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Excel-multi-level-BOM-template-and-example

VIEWS: 326 PAGES: 20

									                        Excel BOM template courtesy of Arena
                        Visit us at http://www.arenasolutions.com
BOM Level   Part Number Part Name                            Revision
om
                                      Unit of
     Phase   Description   Quantity   Measure
Procurement   Reference
    Type      Designators   BOM Notes
Revision Summary of Changes Made   Approval Date
                        Excel BOM example courtesy of Arena
                        Visit us at http://www.arenasolutions.com
BOM Level   Part Number Part Name                                       Revision




    0         20-0001   EveryRoad GPS, Shippable, US Model 300             B




    1         20-0002   EveryRoad GPS Car Navigation Unit - Model 300      B

    2         20-0003   EveryRoad, Front Bezel Assembly                    A
    3         40-0011   LCD                                                A


    3         50-0012   EveryRoad, Front Bezel                             B
    3         50-0080   Gasket, Screen, 3.5in                              A

    2         20-0004   EveryRoad, Rear Assembly                           B


    3         20-0015   EveryRoad, PCBA, Model 300                         B
    4         40-0035   EveryRoad, Circuit Board                           A
    4         40-0038   GPS Micro controller                               A


    4         40-0039   USB Connector                                      A

    4         40-0041   0.1uF Ceramic Chip Capacitor                       A

    4         40-0042   10k Resistor                                       A

    4         40-0043   1k Resistor                                        A
    4         40-0044   1.0uF Ceramic Capacitor, 1206                      A

    4         40-0045   Low-dropout 5.0V 100mA Voltage Regulator           A

    4         40-0046   100ohm Resistor                                    A

    4         40-0047   51k Resistor                                       A

    4         40-0048   470k Resistor                                      A
4   40-0049   500mW NPN Transistor                       A
4   40-0050   Small-signal PNP Transistor                A

4   40-0051   470 ohm Resistor                           A

4   40-0052   Tantalum Capacitor 10uF@16V,B pkg          A

4   40-0053   Tantalum Capacitor 4.7uF@4V,A pkg          A
4   40-0054   Voltage Detector CMOS 4.3V SOT23           A

4   40-0055   220k Resistor                              A

4   40-0056   1M Resistor                                A

4   40-0057   0.01uF Ceramic Chip Capacitor, 0603        A

4   40-0058   47 ohm Resistor                            A
4   40-0059   Small-single NPN Transistor                A

4   40-0061   N-Chn Enhan-Md MOSFET                      A

4   40-0062   3k Resistor                                A
4   40-0063   Exclusive Or Gate single                   A
4   40-0064   Speaker w/drive circuit 3-15volts          A
4   40-0066   Signal Diode                               A

4   40-0067   2M Resistor                                A

4   40-0068   P-Chan MOSFET SOT-223                      A
4   40-0069   HE 2 Channel solid state relay (B form)    A
4   40-0070   Schottky Diode, 320mV@1mA                  A

4   40-0071   Millmax 0666 Socket for 0.020 pins         A

4   40-0072   2.7k Resistor                              A
4   40-0073   4.0 MHz Fixed oscillator                   A

4   40-0074   Miniature Pushbutton Switch, Right Angle   A
4   40-0075   Single Logic Level P-Channel FET           A
4   40-0076   Red/Green SM LED                           A

4   40-0077   Molex 4-pin 0.079 RA Header                A
4   40-0078   IR 40Khz Integrated Receiver Siemen        A


3   50-0016   EveryRoad, Rear Panel                      B
3   50-0089   Screw, M2 x 5, ST, PH, Torx                         A

2   50-0010   Screw, M3 x 6, ST, PH, Torx                         A


2   50-0018   EveryRoad Model 300 Safety Label                    A
1   20-0005   Package Documentation                               A

2   90-0006   Manual - Model 300/500                              B
2   90-0007   Warranty Card                                       A


1   30-0085   Packaging                                           A

2   50-0087   EveryRoad Model 300 US Boxed Product Label          A


2   50-0088   Box with EveryRoad Logo, 5 in x 5 in x 5 in         B


1   40-0009   Power Supply, US                                    A
1   40-0081   USB A/A Cable, Black                                A

1   40-0084   USB to Car Power Adapter                            A

1   50-0083   Hook & Loop (Velcro), Black, 2" wide                A

              Excel BOM template compliments of Arena Solutions
              www.arenasolutions.com
                                                                                        Unit of
   Phase        Description                                                  Quantity   Measure

                Packaged EveryRoad GPS Car Navigation System Product -
                US Model 300 Includes: Base Product - Model 300 US Charge
In Production   Adapter Packaging & documentation                                        each

                Product Assembly for EveryRoad GPS Car Navigation System
                Assembly - Model 300 Includes base product only, no
In Production   packaging or localized components like charging adapters.       1        each
                EveryRoad GPS Car Navigation System Front Bezel Assy
In Production   Includes: Bezel, LCD, gasket and screws                         1        each
In Production                                                                   1        each
                Injection molded plastic front cover for EveryRoad GPS Car
                Navigation System Model 300 Texture: MoldTech MT-11030 -
In Production   0.002" depth, 3degs draft                                       1        each
In Production                                                                   1        each
                EveryRoad GPS Car Navigation System Model 300, Rear
In Production   Panel Assembly                                                  1        each
                Board Assembly. This is the primary PCB assembly that sits
                at the back of the EveryRoad GPS Car Navigation System
In Production   Model 300                                                       1        each
In Production   Circuit board for the EveryRoad product                         1        each
In Production   IC CTRLR BASEBAND 32BIT 64-TQFP                                 1        each

                4 CONTACT(S), FEMALE, RIGHT ANGLE TELECOM AND
In Production   DATACOM CONNECTOR, SURFACE MOUNT, RECEPTACLE                    1        each
                CAPACITOR, CERAMIC, MULTILAYER, 16 V, X7R, 0.1 uF,
In Production   SURFACE MOUNT, 0603                                             5        each
                RESISTOR, METAL GLAZE/THICK FILM, 0.0625 W, 5 %, 250
In Production   ppm, 10000 ohm, SURFACE MOUNT                                   8        each
                RESISTOR, METAL GLAZE/THICK FILM, 0.0625 W, 5 %, 250
In Production   ppm, 1000 ohm, SURFACE MOUNT                                    4        each
In Production   1.0uF Ceramic Capacitor, 1206                                   1        each
                5 V FIXED POSITIVE LDO REGULATOR, 0.6 V DROPOUT,
In Production   PDSO8                                                           1        each
                RESISTOR, METAL GLAZE/THICK FILM, 0.1 W, 5 %, 200 ppm,
In Production   100 ohm, SURFACE MOUNT, 0603                                    1        each
                RESISTOR, METAL GLAZE/THICK FILM, 0.1 W, 5 %, 200 ppm,
In Production   51000 ohm, SURFACE MOUNT, 0603                                  1        each
                RESISTOR, METAL GLAZE/THICK FILM, 0.1 W, 5 %, 200 ppm,
In Production   470000 ohm, SURFACE MOUNT, 0603                                 2        each
In Production   1000 mA, 60 V, NPN, Si, SMALL SIGNAL TRANSISTOR             2   each
In Production   200 mA, 40 V, PNP, Si, SMALL SIGNAL TRANSISTOR              2   each
                RESISTOR, METAL GLAZE/THICK FILM, 0.1 W, 5 %, 200 ppm,
In Production   47 ohm, SURFACE MOUNT, 0603                                 1   each
                CAPACITOR, TANTALUM, SOLID, POLARIZED, 16 V, 10 uF,
In Production   SURFACE MOUNT, 1411                                         1   each
                CAPACITOR, TANTALUM, SOLID, POLARIZED, 10 V, 4.7 uF,
In Production   SURFACE MOUNT, 1411                                         3   each
In Production   1-CHANNEL POWER SUPPLY SUPPORT CKT, PDSO3                   1   each
                RESISTOR, METAL GLAZE/THICK FILM, 0.1 W, 5 %, 200 ppm,
In Production   220000 ohm, SURFACE MOUNT, 0603                             1   each
                RESISTOR, METAL GLAZE/THICK FILM, 0.0625 W, 5 %, 250
In Production   ppm, 1000000 ohm, SURFACE MOUNT                             2   each
                CAPACITOR, CERAMIC, MULTILAYER, 50 V, X7R, 0.01 uF,
In Production   SURFACE MOUNT, 0603                                         2   each
                RESISTOR, METAL GLAZE/THICK FILM, 0.1 W, 5 %, 200 ppm,
In Production   47 ohm, SURFACE MOUNT, 0603                                 2   each
In Production   100 mA, 45 V, NPN, Si, SMALL SIGNAL TRANSISTOR              2   each

In Production   200 mA, 50 V, N-CHANNEL, Si, SMALL SIGNAL, MOSFET           1   each
                RESISTOR, METAL GLAZE/THICK FILM, 0.0625 W, 5 %, 200
In Production   ppm, 3000 ohm, SURFACE MOUNT                                1   each
In Production   HC/UH SERIES, 2-INPUT XOR GATE, PDSO5                       1   each
In Production   Speaker w/drive circuit 3-15volts                           1   each
In Production   0.2 A, 75 V, SILICON, SIGNAL DIODE                          2   each
                RESISTOR, METAL GLAZE/THICK FILM, 0.0625 W, 5 %, 400
In Production   ppm, 2000000 ohm, SURFACE MOUNT                             2   each

In Production   7.5 A, 30 V, 0.03 ohm, P-CHANNEL, Si, POWER, MOSFET         1   each
In Production   HE 2 Channel solid state relay (B form)                     1   each
In Production   0.2 A, 30 V, SILICON, SIGNAL DIODE, TO-236AB                2   each
                BERYLLIUM COPPER, TIN LEAD (100) OVER NICKEL FINISH,
In Production   PCB TERMINAL                                                2   each
                RESISTOR, METAL GLAZE/THICK FILM, 0.0625 W, 5 %, 250
In Production   ppm, 2700 ohm, SURFACE MOUNT                                2   each
In Production   4.0 MHz Fixed oscillator                                    1   each

In Production   SWITCH, SPST, MOMENTARY, 0.02A, 50VDC, RIGHT ANGLE          1   each
In Production   2.3 A, 30 V, 0.2 ohm, P-CHANNEL, Si, POWER, MOSFET          1   each
In Production   DUAL COLOR LED, RED/GREEN, 2.5 mm                           1   each
                4 CONTACT(S), MALE, RIGHT ANGLE TWO PART BOARD
In Production   CONNECTOR, SOLDER                                           1   each
In Production   LOGIC OUTPUT PHOTO DETECTOR                                 2   each
                Injection molded plastic rear panel for EveryRoad GPS Car
                Navigation System Model 300 Texture: MoldTech MT-11030 -
In Production   0.002˝ depth, 3˚ draft                                    1   each
                Screw M2 x 5 stainless steel self tapping pan head with Torx
In Production   drive                                                          4   each
                M3 x 6 Stainless Steel Pan Head Self Tapping Screw with
In Production   Torx Drive style                                               4   each

                UL approved white adhesive backed label material, marked
In Production   with regulatory safety certifications and serial number        1   each
In Production                                                                  1   each
                Quickstart guide for both EveryRoad GPS Model 300 and
In Production   Model 500                                                      1   each
In Production                                                                  1   each

                5" x 5" x 5" white box packaging with images & labels
In Production   attached. See files tab for artwork to be adhered to box.      1   each
                EveryRoad Model 300 US Boxed Product Label White
In Production   polyester adhesive label with black print                      1   each

                5" x 5" x 5" white box packaging with large EveryRoad logo
In Production   on top of box. See files tab for artwork to be put on box.     1   each

                Input: 110-250 VAC 50/60HZ. output: 5 VDC + 5%. max: 450
In Production   mA. Min: 150 mA LEDs: Power. Charge time aprox. 1 hour.        1   each
In Production                                                                  1   each
                Input: 12V-24V DC. Output: 5 VDC + 5%. Max: 1Amp . Min:
In Production   150 mA. LEDs: Power. Charge time aprox. 1 hour                 1   each

In Production   Hook & Loop (Velcro), Black, 2" wide Adhesive backed           2   inch
Procurement   Reference
    Type      Designators          BOM Notes




   MTS




   MTS

   OTS
   OTS


   MTS
   MTS

   MTS


   MTS
   MTS
   OTS        U2


   OTS        J4

   OTS        C15,C6,C10-12
              R1,R5,R11,R12,R14
   OTS        ,R16,R23,R24

   OTS        R25, R38, R31, R32
   OTS        C3

   OTS        VR1

   OTS        R44

   OTS        R4

   OTS        R8,R13
OTS   Q5,Q9
OTS   Q2,Q4

OTS   R15

OTS   C9

OTS   C1,C4,C8
OTS   VD1

OTS   R40

OTS   R2,R9

OTS   C5,C7

OTS   R3,R17
OTS   Q1,Q8

OTS   Q6

OTS   R29
OTS   U1
OTS   P1
OTS   D8,D10

OTS   R7,R30

OTS   Q12
OTS   RY1
OTS   D1,D2

OTS   J1,J3

OTS   R41, R42
OTS   X1

OTS   SW1
OTS   Q3
OTS   LD1

OTS   J2
OTS   IR1,IR3


MTS
OTS   Torx Drive Screw

OTS


MTS   Label has US and EU safety marks
OTS

MTS
OTS


MTS

MTS   Barcode label


MTS   Box logo


OTS
OTS

OTS   To be included in both the EU and US models

OTS   To be applied to GPS by customer
Revision   Summary of Changes Made                                              Approval Date
  01       Initial Release to Design                                              3-Mar-10
  02       Release to Prototype - complete design, no draft on plastic parts.    10-Mar-10
   A       Production Release                                                    25-Mar-10
   B       Changed Phillips screws to Torx head screws                            24-Jul-10
Column Name


Multi-Level BOM
Example
BOM Level

Part Number
Part Name
Revision

Phase

Description

Quantity


Unit of Measure

Procurement Type
Reference
Designators
BOM Notes
Excel BOM template and example courtesy of Arena
Visit us at http://www.arenasolutions.com
Content Description
This example shows a multi-level BOM for a GPS product. Each subassembly is listed along with the
components that make up that subassembly. Ann individual part may be listed in the BOM multiple times
if it is included in more than one subassembly.
BOM Level shows the hierarchy of the parts and assemblies in the BOM. Level 0 (zero) is the top assembly
being described.

Part number lists the unique company part number. Do not place manufacturers part numbers here.
Part Name is the unique part name.
Revision is the revision of the part used in this assembly.
Phase describes where this part is in the lifecycle. For products in production, this will generally be 'In
Production', however for new parts which have not been approved these may be listed as 'Unreleased' or
'In Design'.
A detailed description of the part.

Commonly, the number of parts needed in the assembly or subassembly. However, when used with the
unit of measure, it can describe the amount of something needed- like 2 inches or 3 pints.
Unit of measure describes how you use or buy the part. Most commonly UOM is each, but it can also be
standard measures like feet, inches, pints, drops, box…

Describes how the part is bought/made. OTS - Off-the-Shelf or MTS - Made-to-Specification

Used with PCBAs, this lists the location on the board of the part on the BOM.
This is an open note field to describe part information which is specific to this BOM.
             These templates are brought to you by Arena - www.arenasolutions.com


Arena is cloud-based BOM management software.
With on-demand BOM and change management software from Arena, you quickly and affordably gain confidence in your
product data, knowing that your entire team is always working with complete, accurate and up-to-date information. With
Arena you can:

  - Centralize your BOMs
  - Reduce ECO cycle times by up to 70%
  - Get all your key stakeholders on the same page
  - Get your products to market faster


                           Start your free 10 day trial of Arena now >


Contact us
Email us at questions@arenasolutions.com
Call us at 650.513.3538 or 866.937.1438
Visit us on the web at http://www.arenasolutions.com

								
To top