Previous	Next		Contents	Index	Glossary	Library

A full cost rollup first performs a bill of material explosion for assemblies. The rollup process builds the cost of assemblies, starting with the lowest level, and works up the structure to top level assemblies. This method gives you the most current bill of material structure and component costs.

Suggestion: Verify the bill structure before performing a cost rollup to ensure that there are no loops in the bill. See: Checking for Bill Loops.

A single-level rollup only looks at the first level of the bill structure for each assembly in the rollup, and rolls the costs for the items at this level into the parent. This method does not reflect structure or cost changes that have occurred at a level below the first level of your assemblies.

Note: The cost rollup includes the material costs but not the routing costs of phantom assemblies in the cost of higher level assemblies.

Use a single level rollup to assign new standard costs to the top assembly, but not to the lower-level assemblies. A single level rollup allows you to generate costs on new assemblies without changing costs on existing subassemblies.

Part of the cost rollup process includes the option to print a report. If you choose to print a report, you can select either the Consolidated Bills of Material Cost Report or the Indented Bills of Material Cost Report. Both of these reports can also be submitted when reporting item costs.

   To roll up assembly costs:

1. Navigate to the Assembly Cost Rollup window.

2. Enter or select a name of the request to submit:

Cost rollup - No Report: Rolls up costs and commits them to the database; does not print a report.

Cost Rollup - Print Report: Rolls up costs and commits them to the database; prints report.

Temporary Rollup - Print Report: Rolls up costs but does not commit them to the database; prints report.

Attention: To use either of the Cost Rollup options where costs are committed to the database, the Privilege to Maintain Cost security function must be included as part of the responsibility.

Note: By leaving the Privilege to View Cost security function as part of a user's responsibility, but excluding the Privilege to Maintain Cost function, you can allow the user to print reports but not change any stored costs. See: Cost Management Security Functions.

3. In the Parameters window, enter a cost type for which to roll up assembly costs.

4. Select a full or single-level cost rollup option.

5. Select the range of items to roll up: all items, a category, a range of items, a specific item, or zero cost items only.

If you select Zero Cost Items, the rollup includes zero cost items in the current and the default cost types that have their Based on Rollup attribute turned on.

Note: Inactive items are not rolled up unless you enter a Specific Item that is inactive.

6. If you chose to print a report:

• Select a report type:

Consolidated: Prints the Consolidated Bill of Material Cost report, which lists total quantities of each component used in the parent assembly regardless of level.

Detail Indented: Prints the Indented Bill of Material Cost report, which lists detailed cost structure by level.

• Indicate whether to include Material Detail and Material Overhead Detail (material and material overhead sub-elements) on the report.

• Indicate whether to include Routing Detail (resource, outside processing, and overhead sub-elements) on the report. By limiting the amount of sub-element detail, you reduce the size of the report.

• Enter the maximum report number of levels to display on the report. For example, if your assembly had 20 levels and you enter 10 in this field, the costs for levels 1 to 10 would be detailed. The costs for levels 11 to 20 would be summarized as previous level costs. The default is the maximum bill of material levels value. See: Defining Bills of Material Parameters.

7. Enter the effective date and time to determine the structure of the bill of material to use in the cost rollup. You can use this to roll up historical and future bill structures using current rates and component costs. The default is the current date and time.

8. Indicate whether to include unimplemented engineering change orders (ECOs) in the rollup. The default is off. See: ECO Statuses.

9. Enter the alternate bill name for the assembly to roll up the alternate bills for the selected range of items. For example, if you choose All items in the Range field and enter A-001 in this field, all items that have a bill associated with that alternate name are rolled up. The primary bill is not rolled up if you select an alternate bill. See: Primary and Alternate Bills of Material.

10. Enter the alternate routing name for the assembly to roll up the alternate routings for the selected range of items. For example, if you choose All items in the Range field and enter A-001 in this field, all items using routings with that routing name are rolled up. The primary routing is not used if you roll up using an alternate routing. See: Primary and Alternate Routings.

11. Indicate whether to include engineering bills in the cost rollup. If you turn this on, only assemblies with engineering bills are rolled up. The default is off.

12. Specify items to roll up:

• If you selected to roll up a specific item in the Range field, enter the item.

• If you selected to roll up a category in the Range field, enter either a category set or a specific category.

If you enter a category set, item costs are rolled up for items associated with this category set. The default is the category set defined for your costing functional area.

• If you selected to roll up a range of items, enter From and To values to specify the range of items for which to roll up costs.

See Also

Consolidated Bills of Material Cost Report

Indented Bills of Material Cost Report