BOM (Bill of Materials)

From Stock -> Items -> An item's details or Production planning -> BOM it is possible to add a bill of materials (BOM) to your products.

A Bill of Materials lays the foundation for

  • material planning for production,
  • planning material purchases,
  • estimation of material costs when quoting.

Jump to:

  1. About BOMs:
    1. What is a Bill of Materials (BOM)? How is it used?
    2. How is a Bill of Materials used during the production scheduling process?
  2. Creating BOMs:
    1. Add a new Bill of Materials.
    2. Multi-level BOM.
    3. Disassembly BOM.
    4. Phantom BOM.
    5. Packaging materials.
    6. Fixed quantities of parts.
    7. Additional products.
    8. Scrap and wastage.
    9. Connect a BOM and a routing.
    10. BOM with parameters, matrix BOM.
    11. Import BOMs.
  3. Updating BOMs:
    1. Bulk edit BOMs.
    2. Update BOMs via CSV import.
    3. Update the BOM of already planned Manufacturing Orders.
    4. Track changes to a Bill of Materials (revisions).
  4. BOM costs:
    1. BOM cost estimation.
    2. Actual cost of materials in a product.
  5. Find the BOMs where an item is used in ("Where used" / "Engagement" report).

What is a Bill of Materials?

In MRPeasy, a Bill of Materials (BOM) is the list of materials that are needed to create one unit of product. In other words:

  • for discrete manufacturing, like electronics, industrial equipment, etc., it's the list of parts;
  • for process manufacturing, like food, pharmaceutics, etc., it is the formula or recipe that lists the quantities of ingredients per unit of product.

When a manufacturing order is created, the BOM is multiplied by the order quantity to calculate the total material requirements.

The bill of materials usually consists of several parts, and it could also include other consumables that don't make up the product (e.g. gloves, water, fasteners, etc.).

Read more about the Bill of Materials.

Single- and multi-level BOMs:

For example, a Bill of Materials of a table:
Part code Part description Quantity Unit of measurement
A-00001 Tabletop 1 pcs
A-00002 Table Leg 4 pcs
A-00003 Varnish 0.5 l

An "engineering BOM" is not always the same as the "manufacturing BOM" or "MRP BOM":

  • The engineering BOM states exact quantities of parts or ingredients inside the product, including the detailed assembly structure of the product. 
    - Often does not reflect everything that is actually consumed during production.
    - This kind of bill of materials is a typical output of a CAD program and is used by the engineering department as the technical specification.
  • The manufacturing BOM or MRP BOM takes into account wastage and other consumables used in production; considers the material requirements planning goals, and corresponds to the process of how the product is actually manufactured.
    - Some structures and parts might even not be included. For example, when materials planning for some material is not necessary, or that level of detail, each sub-assembly planning separately, is not necessary.
    - The assembly structure is often simplified, if possible, even to a single level.
    - This kind of bill of materials is used for production planning in an MRP system, where it's necessary to know the gross number of all materials for planning purposes and inventory picking.
  • The main difference? 
    - For example, while the engineering BOM states that a 1-meter stick contains 1-meter of a stick, the manufacturing BOM will say that making of a 1-meter stick consumes 1.2 meters of a stick (incl. 0.2m of scrap).
    For example, when the engineering BOM states that Part A will be used, the manufacturing BOM will say that Part A alternative will be used, because, in reality, the shop-floor uses another material.
    - For example, when the engineering BOM defines each sub-assembly separately, the manufacturing BOM will not define the sub-assemblies separately, but only includes the total material requirements for making the sub-assemblies.

How is a Bill of Materials used for production scheduling?

  1. The software will multiply the materials in the BOM with the requested number of products.
  2. The availability of materials in checked.
  3. If some materials are not available, their lead times are used to calculate estimated availability dates.

Adding Bills of Materials (BOM)

Creating a Bill of Materials

For adding a Bill of Materials:

  1. Go to Stock -> Items -> An item's details or Production planning -> BOM 
  2. Click on Create a BOM Add to add a BOM.

Or import the Bills of Materials from a CSV file at Production planning -> BOM -> Import from CSV.

Creating a multi-level Bill of Materials

Creating a multi-level BOM for a product:

  1. Create separate articles for the sub-assemblies and the product.
  2. Add BOMs to the sub-assemblies.
  3. Add the sub-assembly articles to the BOM of the product.

Demo video

Phantom assembly, phantom Bill of Materials (phantom BOM), phantom item, kit of parts

If an item

  • has a BOM,
  • has no Routing,
  • and is not configured as a procured item ("This is a procured item: No"),

then it is considered as a collection (kit) of parts, a phantom BOM.

If it is included in the BOM of another part, and a Multi-level Manufacturing Order is made for that product, then:

  • All the parts of the kit will be included in the MO.
  • No operations will be required to assemble the kit.
  • If the kit contains other manufactured items, then operations and materials may be included to manufacture these items.

Take note that if a MO is made for such a kit item separately, to pre-assemble it, then it is treated identically to a kit (bundle) of products for selling. No multi-level MO will be made then, and it will be auto-assembled when all parts arrive in stock.

Connecting Bills of Materials and routings

BOMs and Routings are associated:

  • It is possible to associate a particular BOM with a particular Routing that goes together.
  • For production planning, a product must have both a BOM and a Routing. And both must be connected with each other.

Estimating the cost of a BOM

When a BOM is saved, MRPeasy tries to estimate its cost by totaling the costs of materials used in it.

The cost of a BOM is estimated as follows:

  • If the material is in stock, the cost is approximated by using the weighted average cost of the item.
  • If the material is not in stock, the estimated cost of the material is used.

On the BOMs details page, the link on the "Average cost" number (Edit mode = Yes) leads to a page with an exact calculation of the item’s cost.

The cost cannot be estimated if:

  • the cost of some raw material is unknown (no lots at stock and it neither has no vendors);
  • the Matrix BOM functionality is enabled and the BOM includes a relation or some parameter changes the number of raw materials.

The actual cost of the product is only available after the Manufacturing Order finishes, then based on reporting, the manufacturing costs are added up, and materials have been used from particular stock lots (what is a stock lot?).

Multi-level BOM, indented BOM estimated cost

When you open the indented BOM PDF, the following should be kept in mind:

  1. Component quantities are shown per 1 sub-assembly. I.e. the sub-assembly BOM is shown.
  2. The cost is found for each line separately. Some items may be in stock, others not.
  3. The cost of a sub-assembly might not equal the estimated cost of its BOM.
    - If the sub-assembly is in stock, then, for it, the average cost from stock is shown. But the cost of components is found separately.

Example:

# Part Quantity Average cost Comments
1 A 1 $2.00  
2 B 2 $6.00 Not in stock, the cost is estimated.
= 2 x (B1 + B2) = 2 x ($1.50 + $1.50)
2.1 B1 4 $1.50  
2.2 B2 4 $1.50  
3 C 1 $4.00 In stock, the average cost from stock is used, which is more than its estimated materials cost would be.
3.1 C1 1 $1.00  
3.2 C2 1 $1.00  
Total:     $12.00 The estimated cost of the BOM
= A + B + C = $2.00 + $6.00 + $4.00

 

Calculating the actual material cost for a product

In general, a manufactured item's cost comprises three components:

  1. The cost of materials.
  2. Manufacturing overhead.
  3. The cost of labor.

The final cost of materials is calculated when a product has been manufactured via a Manufacturing Order:

  1. When a Manufacturing Order is created, materials are automatically booked to it (default by FIFO; or by FEFO, for perishable goods) from specific stock lots, based on the items BOM.
  2. If some materials were not available, these must be booked later to the MO.
  3. Each item has its own actual cost, which it was purchased or manufactured with, saved in the stock lot details.
  4. When booked materials are reported consumed and the manufacturing order is finished, the actual cost of materials is added up and divided by the number of products.

The material cost of a product is:

  • The cost of materials = Cost of consumed materials in the MO / Number of products on the order

Updating the BOM of already scheduled Manufacturing Orders

If the BOM is saved and there are current manufacturing orders (MO) that are based on this BOM, then the software asks if you wish to update MOs. It will show a list of MOs and give options to update them.

For automatically updating the materials in existing MOs according to an updated BOM:

  1. Change the BOM.
  2. Save.
  3. Proceed to update MOs.
  4. a. Click Update all.
    b. Or choose which MOs you wish to recalculate, and confirm the new schedule for these MOs.
  5. If MO with a new BOM does not take a longer time than originally, then it is left in the schedule without any changes.

Limitations:

  1. It is only possible to automatically update MOs which are not started yet. For other MOs, the materials must be updated manually.
  2. It is not possible to automatically update MOs where serial numbers are reported. Serial numbers must be removed first, or the materials must be updated manually.
  3. It is not possible to automatically update MOs where POs for subcontracted operations are created. Purchase Orders must be deleted first, or the materials must be updated manually.

It is possible to manually update the materials of MOs in every status, see: How to book, add, or release materials of a Manufacturing Order.

 

We use cookies to enhance your experience on our website. If you continue using this website, we assume that you agree with these. Agree Learn more Ok