Using the Cost Rollup Process to Calculate Product Costs

The Cost Rollup process calculates the standard cost for an item based on:

Field or Control

Description

Bill of Materials (BOM)

The BOM contains the component materials for the end item. These component material costs can be purchased components and subassemblies (both manufactured and subcontracted). The Cost Rollup process includes the cost of purchased items, the lower-level costs of manufactured subassemblies, and the cost of subcontracted assemblies. For configured items, the component list from the production order is used instead of the BOM.

Routing

(Optional) The routing contains information about the operations and work centers required for producing the item. Associated with the routings are the labor, machine, subcontracting, and overhead rates that the system uses for the cost rollup of a particular cost type and version. The Cost Rollup process uses the costing rate type for labor and machine setup, run, fixed run, and postproduction times or rates. For configured items, the system uses the operation list from the production order instead of the routing.

This diagram illustrates the calculation of the cost of manufactured items. The Cost Rollup process calculates the standard cost based on the BOM and routing of the item. The cost type and cost version combination determine the rates and additional costs used to calculate the cost:

Calculating the cost of a manufactured item

The Cost Rollup process uses several elements to compute the frozen standard costs, including:

Field or Control

Description

Cost Type

Define different cost types, such as current, revised, and forecasted costs, to create a working space for cost calculations. You perform cost rollups based on cost types. For example, you can set up a cost type of CUR for the current production costs.

Cost Version

Cost versions are a subset of cost types that enable you to have different versions or simulations of the costs. For example, for the cost type CUR (current production costs), you could have a current production version (PRD1) and an engineering version (ENG1) for cost calculations.

Cost Element

Cost elements categorize the different components of an item's cost, such as, material, labor, and machine costs. They are used on reports and inquiries of the rolled up costs of a manufactured item. They can also be used to post accounting entries for inventory transactions. You could create the cost elements, for example, 300 for recording labor setup costs, 301 for recording labor run, and 501 for overhead - machine based costs.

Production Conversion Codes

Production conversion codes define labor, machine, and other conversion costs in the manufacturing process. Use conversion codes to define conversion rates associated with work centers or tasks. For example, you could create the conversion code 4403 (painter) for conversion costs related to painting.

Production Overhead Codes (conversion overhead codes)

Production overhead codes define the different types of overhead costs that are used in the manufacturing process. Use conversion overhead codes to define conversion overhead rates associated with work centers or tasks. For example, you could create the production overhead codes of 6504 for depreciation and 6507 for electricity usage.

Costing Conversion Rates

Define the rates to use for labor and machine costs in the production process. You can create a variety of costing scenarios using different cost types, cost versions, and production conversion codes. For example, you can set the labor setup rate to 8 per hour for the CUR cost type, PRD1 cost version, 4403 (painter) conversion code, and store the results in the cost element 300 (labor setup). Then you can create a different labor run rate of 9 per hour for the CUR cost type, PRD1 cost version, 4403 (painter) conversion code, and store the results in the cost element 301 (labor setup).

Costing Conversion Overhead Rates

Establish the rates to use for overhead costs based on the units produced, labor or machine hours, or labor or machine costs. You can establish several different rates based on business unit, cost type, cost version, conversion overhead code, and cost element. For example, you can set up the depreciation costs as 5 /machine hour for the CUR cost type, PRD1 cost version, 6504 (depreciation) conversion overhead code, and store the results in the cost element 501 (overhead - machine based).

Work Centers and Tasks

Once you have set up the cost foundation, use the production conversion codes and the production overhead codes to define the labor and machine cost for the work centers or tasks. You can specify up to four production overhead codes for the work center or task. For example, for the work center, PAINT01, you can add the conversion code 4403 (painter) for conversion costs related to painting. You can also add the conversion overhead code of 6504 for depreciation on the paint machines.

Item Routing

You then define the item's routing to include these work centers and tasks within the operation sequences. The routing also defines the operation time for any operation sequence. For example, for the operation sequence 50, you could record that is takes 2 hours of labor setup, 4 hours of labor run, and 1 hour of machine time.

Item

The item definition for a manufactured item includes the item routing to be used and the BOMs. This information is recorded on the Define Business Unit Item - Manufacturing page. For example, for the item SR1001 (touring bike) this page defines where to get the item routing and BOM.

Cost Rollup Process

The Cost Rollup process uses the item routing, cost type, and cost version to determine the labor, machine, subcontracting, and overhead costs. For example, if the cost rollup process uses the cost type of CUR and the cost version of PRD1, with the item ID SR1001, then the conversion costs for the operation sequence 50 would be:

  • Labor setup costs: 8 per hour * 2 hours = 16 categorized by cost element 300 and conversion code 4403.

  • Labor run costs: 9 per hour *4 hours = 36 categorized by cost element 301 and conversion code 4403.

  • Overhead costs: 5 per machine hour *1 hour = 5 for machine depreciation categorized by cost element 501 and conversion overhead code 6504.

    The Cost Rollup process uses the item's BOM to calculate materials costs. Select the method for calculating the cost of purchased components on the Cost Type page. You can add additional costs to the Cost Rollup process using the Additional Item Costs page.

The Cost Rollup process must calculate the cost at each level of the product structure, as well as the final cost. For example, if an item has a BOM or component list like the one in this diagram, the cost rollup must calculate the cost of item 2002 before it can calculate the cost of item 1001.

This diagram illustrates the cost rollup of a multi-level product structure:

Example of a cost rollup

In this example, the costs associated with items 2004 and 2005 would be lower-level or component-level costs for item 2002. The cost of 2002, when you add it to items 2001 and 2003, becomes the lower-level or component costs for item 1001. The labor, machine, and overhead costs associated with manufacturing item 2002 are this-level or assembly-level costs for 2002. However, they would become lower-level or component-level costs when associated with item 1001. Item 1001 would have its own set of this-level or assembly-level costs, associated with putting items 2001, 2002, and 2003 together.

You can use the Cost Rollup process to determine the standard cost for makeable items, configured items, engineering items, purchased items, and simulations. Only cost rollups of manufactured, purchased, and configured items can be used to update production costs (the CM_PRODCOST table). The system calculates engineering and simulation costs for reporting and comparison purposes.

The Cost Rollup process performs in basically the same way for the different types of items. The only difference is where the cost calculation obtains the information to determine the material and labor costs for the item.

Type of Item in Rollup

Material Costs From

Labor, Machine, Subcontracting, Overhead Costs From

Can Update Std Costs?

Manufactured

Primary manufacturing BOM code 1.

Primary production routing code 1 or the reference item routing, if one is specified for the item.

Yes

Configured

Component list.

Operation list.

Yes

Engineering

Any manufacturing BOM or engineering BOM. BOM code 1 is used for all lower levels.

Any production routing or engineering routing. Routing code 1 is used for all lower levels.

No

Simulation

Any manufacturing BOM code. BOM code 1 is used for all lower levels.

Any production routing. Routing code 1 is used for all lower levels.

No

Rolling Up Configured Items

There are two options for calculating standard cost for a configured item using the Cost Rollup process:

Field or Control

Description

Costing

The Cost Rollup process calculates the item's cost based on its BOM and routing. The standard cost is stored by item ID. One item could have multiple configuration codes but all configurations of the same item use the same standard cost.

Configuration Costing

The Cost Rollup process calculates the item's cost based on the component list and operation list from the latest production ID. The system stores the standard cost according to the combination of item ID and configuration code. Choose configuration costing by selecting the check box on the Define Item - Configuration page.

The roll up of a configured item using configuration costing does not include co-products, by-products, or yield by-operation details. However, the system maintains detailed costs for configured items according to component ID and operation sequence. It stores these detailed costs in the CE_ITEMCOST_DET and CM_PRODCOST_DET tables. It also summarizes these costs according to cost element and stores them in the CE_ITEMCOST and CM_PRODCOST tables.

If the output of a production run is more than one item, then the cost is allocated. Multiple outputs include:

  • Co-products.

  • By-products.

Costing Co-Products

If a single manufacturing process generates multiple items, you can allocate the batch cost across the primary and co-products to determine the per unit cost of each end item. When it explodes a co-product for a multiple output BOM during Cost Rollup process, the system uses the Associated Primary BOM to determine the correct lower-level structure. An associated primary must therefore exist in this case for the rollup to occur. The BOM and routing code combination that the system used to explode the co-product must also exist.

Note: The system calculates a co-product's cost by multiplying the total cost of the batch (including the recycle and waste by-product costs) by the cost percentage for the co-product (as specified on the BOM Maintenance - Outputs page), then dividing by the expected output quantity of the co-product.

Costing By-Products

By-products can be of two types: recycle and waste. The system calculates cost relief for recycled by-products by multiplying the quantity and the cost of the recycle by-product. This cost relief is subtracted from the lower-level costs. The system treats recycled by-products as a negative cost, because they can be used as an input to another process. The cost used is determined by the purchase cost as specified for the cost type that you selected on the Cost Rollup page.

Note: A recycled by-product must have the same cost element (with a cost category of material) as another component or waste by-product; otherwise, the item is not costed. This reduces the chance of a material element producing a negative value. If the cost element becomes negative, due to a recycle by-product cost relief, the system does not cost the item and an error message is printed on the Cost Rollup Audit page.

The system treats waste by-products as positive or zero cost. They either add to the cost of the product, such as the cost of disposing it, or have no associated cost. The system determines the cost used for waste by-products by multiplying the quantity and the cost of the waste by-product. It adds this cost to the material costs.

This diagram illustrates an example of a cost rollup with multiple outputs.

Example of a cost rollup with multiple outputs

In this example for orange juice processing, you have these outputs: primary (orange juice), co-product (orange concentrate), recycle by-products (orange rinds and orange pulp), and waste by-product (orange pits). The components are oranges, sugar, and water.

Calculate the material costs by multiplying the quantity of each component by the standard cost:

Oranges: (5lb * 0.50) = 2.50

Sugar: (1lb * 0.80) = 0.80

Water: (10Gal * 0.10) = 1.00

Total Material Costs = 4.30

Calculate the by-product costs as:

Orange Rinds: (2lb * 0.01) = -0.02 (Cost is negative, because the recycled by-products are viewed as a cost benefit.)

Orange Pulp: (1lb * 0.02) = - 0.02

Orange Pits: (2lb * 0.005) = 0.01 (Cost is positive, because it is a disposal cost.)

Total By-Product costs = - 0.03

Total Costs = Material Costs + By-Products Costs = 4.30 + (-0.03) = 4.27

To determine the primary and co-product costs, multiply the total costs by the cost percentage.

Orange Concentrate = 40% * 4.27 = 1.71

Orange Juice = 4.27 − 1.71 − 2.56

Calculate the standard cost of the primary and co-product by dividing the apportioned costs by the output quantity of each item.

For yield by operation transactions, the Cost Rollup process calculates the yield loss for each operation sequence where the operation yield is less than 100 percent.

The Cost Rollup process performs these steps to calculate yield by operation transactions:

  1. Calculates and inserts costs into the temporary tables CE_ITMCSTDT_TMP and CE_ITMCSTD2_TMP by applying the operation yield at the operation sequence where they are first introduced.

    Each subsequent operation sequence uses the results of the previous operation sequence. Subsequent costs take the form (cost (from original OpSeq) / operation yield percent) - cost from original OpSeq.

    All components with an invalid or zero operation sequence are applied to the first operation sequence that you defined for the routing code specified. All by-products with an invalid or zero operation sequence are applied to the last operation sequence for the routing code. For by-products, the process uses the operation yield of this last operation sequence.

    This example demonstrates how subsequent costs are created as existing costs from earlier OpSeqs move through subsequent OpSeqs where Operation Yield<100 percent.

    1. The first operation sequence (OpSeq 10) has an operation yield of 100 percent. The cost is 10. Processing begins at the second OpSeq, because the first OpSeq processing is already complete.

    2. The second operation sequence (OpSeq 20) has an operation yield of 96 percent. Using the formula (Cost (from original OpSeq) / Operation Yield Percent) - Cost (from original OpSeq), then the additional cost for the cost originally introduced in OpSeq 10 would be 10/96% - 10 = 10.4167-10=0.4167.

    3. The third operation sequence (OpSeq 30) has an operation yield of 98 percent. The additional cost for the cost originally introduced in OpSeq 10 would be ((10/96%)/98%) – 10/96%) = (10.6293-10.4167)=0.2126.

    4. Therefore, the total cost is 10 + 0.4167 + 0.2126 = 10.6293 (which is the same as 10 * expected completions at OpSeq 30 = 10 / (.96*.98) = 10.6293.

  2. Once the system processes all the specified operation sequences, it moves the cost data into the CE_ITEMCOST_DET table.