[1]avtorovaThis information is from the FAQ topic, must be reviewed2020/10/2016:01:29+03:00Bills of Material: Cost Calculation

For each bill of material, the system calculates costs for the components included in the bill of material, such as materials, tools, labor, and overhead. In this topic, you will read about material unit costs displayed on the Bill of Material (AM208000) form and the cost calculation by using the cost roll process on the Cost Roll (AM508000) [2]Anna Vtorovawhen rewriting this topic, consider the following comments from Elaine Warren: Labor Cost Calculation Special note should be included in this section to advise that this is at the top level of BOM when using the Calculate BOM Cost function form the Bill of Material screen. Subassemblies have the cost rolled into the subassembly as it is expected they are built in advance and consumed into the finished product. This results in the subassemblies rolling the labor into the subassembly as a total cost which displays as material and not labor since the subassembly was previously built and posted.2023/03/2913:18:32+03:00form.

[3]Brian.Quaninsert2023/05/0822:28:25-04:00

You will also learn about unit costs when they are first added to a bill of material (BOM), unit costs when they are updated as part of a single level or multi-level cost roll, and production order unit costs.

Unit Costs for Materials in a Bill of Material[4]Brian.QuanUnit Costs for Materials in a Bill of Material2023/05/0509:50:04-04:00[5]Brian.Quaninsert2023/05/0509:50:16-04:00Value Used when Material Costs are Added to BOM

The Item Warehouse Details (IN204500) form is the source for the cost when you [6]Brian.Quaninsert2023/05/0421:39:49-04:00first add an inventory item to a bill or production order. The cost used is dependent on the item's valuation method. Unit costs can be manually entered or updated by the cost roll process on the <xref href="AM_50_80_00.dita"/> (AM508000) form.[7]Brian.QuanUnit costs can be manually entered or updated by .. 2023/05/0421:41:20-04:00 When you add a new material t[8]Brian.QuanWhen you add a new material t2023/05/0421:41:25-04:00[9]Brian.Quaninsert2023/05/0421:41:30-04:00The unit cost defaults from the settings of the item–warehouse pair according to the item's valuation method as follows:

  • Average or FIFO: Average cost
    Note: If the average cost is zero, then the last cost is used.
  • Standard: Standard cost
  • Specific: Last cost
<p>For existing materials, the cost roll process can be used to update the unit costs if desired. When production orders are created, the cost roll process obtains the current cost for materials.</p>[10]Brian.Quan<p>For existing materials, the cost roll process .. 2023/05/0421:54:59-04:00
[11]Brian.Quaninsert2023/05/0421:44:24-04:00

Update of Material Costs

Unit costs of materials on BOMs can be updated by the cost roll process when you select the Update Materials check box in the Cost Roll (AM508000) form.

When you select Single in the Level box of the Selection area, the material costs are updated using the item’s valuation method and the unit cost defaults from the settings of the item-warehouse pair.

When you select Multi in the Level box of the Selection area, the system first calculates costs for all subassemblies included in a bill of material, starting from the lowest-level subassemblies, and then uses these costs in calculation of the top-level BOM costs. This means materials that have a BOM will have their cost updated based on the cost roll calculation and is not dependent on the material’s item valuation method.

Calculation Used by the Production Order in the Cost Roll Process

When production orders are created and when the Update Planned Cost action is selected, the cost roll process obtains the current cost for materials via multi-level cost roll.

Cost Calculation by the Cost Roll Process

The formulas the system uses for calculating costs of components included in a bill of material are listed in the following table.[12]Brian.Quaninsert2023/05/0421:56:53-04:00 For more information on options that impact the BOM Cost, see the Cost Roll form.

Table 1. Formulas for calculating costs of BOM components
Component Formula
Labor ((Setup time / Lot size) + Run time converted to hours per piece) * (Work Center Standard Cost)
Materials

If the value of the Batch Size column on the Bill of Material (AM208000) form is 0, the formula is the following: Qty. Required * (1 + Scrap Factor)

If the value of the Batch Size column is not 0, the formula is the following: Qty Required * (1 + Scrap Factor) * (Lot Size / Batch Size)

In the formula, Lot Size is the value of the Lot Size box on the Manufacturing tab of the Item Warehouse Details (IN204500) form. If the lot size is zero then the value of the minimal order quantity is used. If both are zero then a lot size of 1 is used.

Machines (Machine hours converted to hours per piece) * (Machine standard cost)
Tools (Quantity required) * (Unit cost)
Overhead Overhead is calculated dependent on the overhead type.