B.O.M System
B.O.M System
(OP)
Ok folks, i hope this is the correct forum.
What do you guys use for your B.O.M management? A simple spreadsheet? Access database? or full blown management system. But more importantly why does it work for you?
What do you guys use for your B.O.M management? A simple spreadsheet? Access database? or full blown management system. But more importantly why does it work for you?






RE: B.O.M System
corus
RE: B.O.M System
RE: B.O.M System
Management of the BOM is initially by highlighting changes in the spreadsheet and notating the document with date(s) of modification. Once an assembly drawing is created, it becomes the controlling document and when the drawing is released, it goes under ECO (Engineering Change Order) control.
Regards,
RE: B.O.M System
what do you think the best option is?
RE: B.O.M System
RE: B.O.M System
The site below might be something worth looking at. If nothing else it is short course on what management resource planning (MRP) is all about.
http://pcmrp.com/
Then main parts of a part management system are the item master and the bill of materials database. The item master is primarily a list of part numbers, descriptions, and units of measure. It is like a master index for part numbers where a part is a single piece part, assembly, weldment, bulk material, etc. A well organized item master is handy to search for parts.
Some items are assemblies or weldments and have a list of part associated with the top level number, and this list is called a bill of materials. A useful function is the where used search that gives a list of where items have been used before.
Regards,
-Mike
RE: B.O.M System
Regards,
RE: B.O.M System
My company actually has multiple BOMs for the same product.
We have the assembly BOM. This BOM is created in the CAD system and is only lists the parts, components, and subassemblies used to create an assembly. This is essentiall the basis for the other BOMs. This BOM only exists on the face of each assembly drawing.
We have the production BOM. Our production controllers/planners take the assembly BOM and recreate it in an Excel spreadsheet. I'm ashamed to say this is a totally mismanaged process because each planner creates their own BOM in their own format for the program they are assigned to. Not to mention, the human transfer of data from drawing face to spreadsheet leads to errors. But, this BOM has more information in it than the assembly BOM. It has make/buy fields and also has required quantities, including scrap allowance, for the production run of product (contract deliverable quantity). This BOM gets recreated each time a new fixed-price/fixed-quantity contract is awarded. Purchasing also uses this BOM to get pricing.
Finally, there is the product baseline. It's a product baseline more than a BOM, but resembles a BOM none the less. It contains all the revision information of every part of every component including what materials requirements and/or specifications are called out on the drawing notes, including surface finishes. It captures the as-built condition.
The good news is that we are trying to implement a PDM/PLM system to incorporate these distinctly separate BOMs into one system.
--Scott
http://wertel.eng.pro
RE: B.O.M System
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: B.O.M System
I didn't go very far into the detailling of how it works but that's pretty much it.
Patrick
RE: B.O.M System
Regards,
-Mike
RE: B.O.M System
If you are a custom fabrication shop that rarely manufactures the same product, you could get away with tracking materials used per work order in an excel program.
If your company manufactures a standard product line that has many specific parts that are required for fabrication, you may want a full-blown management system. The company I work for has a full-blown management system that tracks from the time an item is purchased, to the time it is shipped out the door. All parts have a specific part number so when a part is ordered, it automatically checks the quantity of parts on-hand. If material or parts are required, it generates requirements for work orders or material required. When a work order is processed, it automatically removes the used material/parts from our running inventory. This system also tracks manufacturing time and can give you a good estimate on cost based on your shops labour rate.
The system takes a lot of time to get set-up. Once it is set-up, it makes tracking material and parts much easier.
Check out www.cincom.com
You might not need the full System management system but they might have alternate solutions that meet your specific needs.
Regards