The Bill of Materials provides a structured breakdown of all components required for the production of an Order. Your Components are the Materials, Machines, and Labors that make up an Assembly. Reviewing the Bill of Materials allows you to validate the estimated usage and costs of each Component. This is where you can identify discrepancies between what CoreBridge is estimating versus what you are actually using in production. This article will guide you through how to find the Bill of Materials, analyze it, verify costs, and update pricing. This ensures your Assemblies are both cost-effective and correct.
Table of Contents
- How to Open the Bill of Materials
- Reading the Bill of Materials
- How to Make Adjustments on the Bill of Materials
- Updating the Bill of Materials
To begin, navigate to Sales / Orders, or Sales / Estimates and select the specific Order or Estimate.
Note: In this article, we will be viewing the Bill of Materials in an Order. The Bill of Materials functions and is accessed the same way in both.
How to Open the Bill of Materials
From an Order
Opening directly from an Order will pull up the Bill of Materials with all the Line Items expanded.
1. Click on the Ellipsis to open an options menu.
2. Click on Bill of Materials.
From an individual Line Item
Opening from an individual Line Item will pull up the Bill of Materials with only that specific Line Item expanded.
1. Open the Line Item within the Order by clicking anywhere on the Line Item.
From here, there are several ways to access the Bill of Materials.
2. Click on the Ellipsis to open up an options menu.
3. Click on Bill of Materials.
Or:
2. Click on the Ellipsis found on the Component line.
3. Click on Bill of Materials.
Or:
2. Click on the Bill of Materials icon.
Reading the Bill of Materials
Reading the Bill of Materials should be done from top to bottom, left to right.
a. These tabs allow you to switch between the Bill of Materials view and an Estimate vs Actual view.
- Bill of Materials - This shows how the cost of individual components in an assembly with the pricing method you have set and the percentage difference between cost and price.
- Estimate vs Actual - This is a breakdown of the cost of an item, compared to the cost of the item used in the Assembly based on quantity.
b.Individual Expansion Arrows on the left or the Expand All arrow at the top allow you to see the details for each Assembly.
c. Clicking on the ellipsis will give you the option to Open in Settings.
d. Child Assemblies have a separate Price and Margin listed.
e. Individual Line Items on the Order are separated by a page break and designated by their Line Item number for reference.
f. Quantity - Beginning with a single line in the Bill of Materials, determine if the quantity of that component is correct.
g. Cost - Determine if the Cost is correct for the quantity listed.
Note: Hovering over the Cost on the line will show you how much the Cost of each unit. See the example below.
h. Price - If the Quantity and Cost are both correct, the Price will be accurate as well.
Note: For more information on the difference between Cost and Price, please see (link to Cost/Price article here)
i. Margin - This column reflects the difference between the Cost to produce the product and the Price at which it is sold, expressed as a percentage. Reviewing the margin helps ensure the product is not underpriced or overpriced relative to its component costs.
Example: In this example, hovering over the Cost of the Roll Stock Prints shows that one costs $12.17. Therefore, the cost of two is $24.34. The Price to the customer is $48.68 which equals a 50% profit Margin.
How to Make Adjustments on the Bill of Materials
Side Panel
Clicking on any of the Component lines will open up a Side Panel that allows you to quickly and easily adjust Quantity, Cost, and Price. This will automatically save. The changes made here will only be reflected on this Line Item for this Order and will not affect pricing on this component when used on other Orders.
Note: Price and Margin will not be listed on individual Components within an Assembly as they are rolled up into the cost of the Assembly. Child Assemblies will have the Price and Margin listed independently.
Making Adjustments in Settings
Discrepancies on the Bill of Materials can be corrected by going into Settings and making the necessary changes.
For an incorrect Quantity:
1. Click on the Ellipsis at the end of the Assembly.
2. Click Open in Settings.
Note: This will take you to Settings / Components / Materials in a separate tab where you can make the necessary adjustments.
3. Click on the Linked Components tab.
4. Click on the Material to open up the side panel.
5. Adjust the formula if the error is apparent. For additional help with the formula, please reach out to support@corebridge.net.
6. Click Save.
Note: For more information on Assemblies, please see Assembly Overview.
For an inaccurate Cost:
1. Click the Ellipsis directly on the line of the Material with the inaccurate Cost.
2. Click Open in Settings.
Note: This will take you to Settings / Components / Materials in a separate tab where you can adjust the cost.
3. Click on the Material Details tab.
4. Adjust the Cost as needed.
Note: The system will automatically save your changes.
For a Pricing issue:
1. Click on the Ellipsis.
2. Click Open in Settings.
Note: This will take you to Settings / Components / Materials in a separate tab where you can make the necessary adjustments.
3. Click on the Pricing tab.
4. Use the dropdown to select the Pricing Method desired.
5. Adjust the Formula if necessary.
6. Under Tables you have the option to adjust the Margin percentage as well as adding a Discount, if desired.
7. Click Save.
Note: For more information on Assembly pricing, please see Assembly Pricing Methods.
Updating the Bill of Materials
After making any changes in Settings, you will need to update the Bill of Materials. This can be done by making any kind of change on the Order, and then immediately changing back.
Example:
Change the quantity to another number, and then immediately change it back. For example, you could change the quantity to 2 and then change it back to 1. When you open the Bill of Materials again, it will then reflect any changes you made previously in Settings.
Note: Values that have been overridden are shown on the Bill of Materials with the following icons.
a. Triangle with exclamation point - This indicates that the value of the Assembly is affected by the manual override on one or more components.
b. Orange flag - This indicates the value that has been manually changed.
Note: Manual overrides can be changed back by opening the side panel and clicking on the orange reverse arrow.
