Creating a Multilevel Cost Estimates

Objectives

After completing this lesson, you will be able to:
  • Create a multilevel material cost estimate without quantitystructure
  • Maintain multilevel cost estimates

Multilevel Cost Estimate

A SAP interface screenshot illustrating a Multilevel Unit Cost Estimate, where a costed BOM is integrated into the Special Lift unit's cost estimate, used for calculating costs of new products or conducting what-if analyses.

The prerequisite for creating a multilevel material cost estimate without quantity structure is a material master with costing view.

A diagram showcasing three scenarios in multilevel unit costing: creating a new product, developing a similar product, and implementing product changes, with processes including top-down maintenance for creating a new product, subordinate adjustments for developing a similar product, and complete structural copying and modification for product changes.

Multilevel unit costing is a highly flexible function that allows the hierarchical structure editing of multiple materials. Single-level unit costing only supports the editing of a single material.

Multilevel unit costing can be used in the following scenarios:

  • Scenario 1: New product
    • You want to create new material masters or cost estimates for new materials. As a rule, you create the structure from top to bottom by making further refinements.
  • Scenario 2: Similar product
    • You want to cost a new product that is similar to an existing one. You can copy the subordinate costing structure to the new product and make changes to the new (copied) structure.
  • Scenario 3: Product changes
    • You want to make changes to an existing product. Copy the existing costing structure and make changes to the copy.

Multilevel Material Cost Estimate Without Quantity Structure

A flowchart illustrating the six-step process for conducting a multilevel material cost estimate without quantity structure, covering tasks such as selecting material and plant, creating costing items, inserting material cost from a worklist, entering quantities, costing the entire structure, and saving the cost estimate.

The prerequisite for creating a multilevel material cost estimate without quantity structure is a material master with costing view.

To create a multilevel material cost estimate, choose a costing variant.

When a costing variant is selected, the valuation strategy for costing items is established. For material costing, the costing variant is maintained in customizing. You have to enter the costing lot size to use it as a base.

A cost estimate header is created automatically.

When you insert (through drag and drop) an existing cost estimate from the worklist, you specify if you want to insert the original cost estimate or make a copy. If you choose to copy, any subsequent changes to the copied structure do not affect the original cost estimate.

Enter the missing quantity in the List screen of the unit cost estimate.

If you are going to edit anything from the copied cost estimate, you re-evaluate the whole structure as any change makes it mandatory to create a new cost estimate.

After saving, the system updates the cost estimate in the database.

Costing Results

A layout diagram of the multilevel unit costing interface, illustrating the use of drag-and-drop and context menus to manage costing structures and worklists, with options to toggle the view of costing structure, worklist, and detail list.

The screen for multilevel unit costing is divided into the following three areas:

  • Costing structure:

    The system can simultaneously display and process a costed multilevel BOM, multiple material cost estimates (with and without quantity structure) in the costing structure. The structure enables you to quickly edit a complex hierarchy and provides a clear overview. It also offers the same analytical possibilities as the costed multilevel BOM.

  • Unit cost estimate or cost estimate header:

    For material cost estimates without quantity structure, the system displays the unit cost estimate list screen. You can also alternate between the cost estimate header and the List screen. After you make any changes, the system automatically updates the costing structure.

  • Worklist or detail lists:

    The worklist is designed so that frequently-used structures and resources are available to the cost planner. You can drag and drop substructures and individual costing items from the worklist to the cost estimate in the costing structure and vice versa. You can also use this area to prepare reports for analytical purposes or for displaying error logs​.

Cost Estimate Results: Itemization

A tabular display of cost estimate results for itemization, detailing components like Forklift T-FL30, Process lift, Overhead, Order processing, Lift T-FL700, and Gearbox T-FL200, with corresponding quantities, units, total values, and cost elements.

You can display and save the costing results as an itemization. The itemization list can include the cost element assigned to each item.

The itemization provides detailed data about the resources required to produce a product.

The following data is stored for a material:

  • Material and text
  • Plant
  • Quantity used
  • Price of material

The following data is stored for an internal activity:

  • Cost center and text
  • Quantity used
  • Activity type
  • Price

Cost Estimate Results: Costed Multilevel BOM

This graphic summarizes the cost estimate results for a multilevel bill of materials (BOM), detailing quantities, units, and total values for components and activities related to forklift and gearbox processing.

The costed multilevel BOM report provides a hierarchical overview of the value added for each assembly item.

The display of costs for each component (assemblies and input materials) in the costed multilevel BOM is based on the structure and content of the BOM for the costed material.

You can also display other items such as manufacturing activities and overhead costs.

Cost Estimate Results: Cost Component Split

The graphic displays a cost estimate Results - Cost Component Split.

The cost component split groups cost elements in cost components. When a multilevel structure is costed, the system rolls up the cost component split so that the original identity of the costs from the lower levels is retained for analysis.

For each product, the cost component split provides information about the value of the produced material (upper level) and the costs of subordinate materials in the BOM (lower level).

The cost component split is available for material cost estimates with and without quantity structure.

Costing Structure

The graphic illustrates a costing structure interface with context menu options for creating, changing, displaying, and deleting substructures, along with a note on fast optimization of column widths and details about material cost estimates and base planning objects.

A costing structure displays one or more cost estimates in the form of a multilevel BOM. You can navigate quickly to the detailed information. The costing structure has the same reporting facilities as the costed multilevel BOM.

Multilevel unit costing enables you to edit base planning objects and material cost estimates without a quantity structure.

You can use buttons and context menus to work within the costing structure. The availability of context menus depends on the item or object concerned. If available, you can access the context menu by right-clicking the item you wish to edit.

When you start editing, only cost estimates appear in the costing structure. You can also choose to display all the costing items.

Enhance Efficiency for Costing Structure

The graphic contrasts the Before and After stages of copying and inserting within a costing structure.

The following functions help you to use the costing structure for enhanced efficiency:

  • Copy:

    Select a cost estimate, or part of one, and drag it to the Costing structure icon. The system prompts you to specify the costing variant and costing version with which it produces the cost estimate. The system transfers the resources to the new cost estimate and displays the new cost estimate in the structure.

  • Insertion:

    Select a cost estimate, or part of one, and drag it to the required position. The system asks you if you want to insert the cost estimate as an original or a copy. If you choose copy, the cost estimate will automatically assume the costing variant and costing version that is used in the costing structure you are modifying. If you choose original, the cost estimate retains its current costing variant and costing version. Any changes you make can affect other areas where this cost estimate is in use.

    When you insert a cost estimate, you need to enter the quantity of the material on the unit cost estimate list screen.

  • Deletion:

    The Deletion function deletes an object from the costing structure only. The Deletion function does not delete the cost estimates from the database.

Costing Structure Status and Revaluation

The graphic showcases the costing structure status and revaluation display, indicating changes and errors with color-coded statuses: red for errors, yellow for warnings, and green for information, alongside context menu options for substructure management.

The costing structure has indicators for Changed and Error statuses.

The Changed status enables the cost planner to see if changes in substructures affect the higher level materials of the cost estimate after revaluation. A costing structure is consistent when all status indicators are green.

In the figure, changes have been made to the lowest level. A yellow status in the changes column indicates that changes have been made. At this stage, you are yet to revaluate the higher-level structures. After you make changes to lower-level items, the system automatically sets the red status in the higher-level items to indicate that the system has not incorporated the results of the changes made.

Revaluation can be performed for the entire structure and substructures. A net change is also available, which permits only those higher-level structures that are directly affected by the changes to be revaluated.

After you perform the revaluation, the Changed indicator is set to green for all levels.

The Error status indicates whether there were errors detected during revaluation. If the Error status is red then there is some problem in the costing item that needs to be investigated.

Layouts of Multilevel Unit Costing

The graphic presents four layouts for multilevel unit costing: Basic Layout, List Maintenance, Reporting/List Maintenance, and Reporting/Details, each showing different organizational structures and components within a costing framework.

The figure shows the flexibility in the layout of the multilevel unit costing screen. The default screen has the basic layout, which displays only the costing structure.

You can adapt the layout to your requirements at any time during the work session. For example, when you are making changes to the costing structure you might want to display the worklist. When you have completed setting up the structure you might switch off the worklist and enable the detail list.

Global Functions

The graphic illustrates the process of copying data to the clipboard and pasting data from the clipboard in a table interface.

The Cut, Copy, and Paste functions facilitate the transfer of multiple costing items from a material cost estimate without a quantity structure to another or from one base planning object to another.

To use the global Cut, Copy, and Paste functions, perform the following steps:

  1. Navigate to the cost estimate whose items you want to transfer.

  2. Select the items and choose Cut or Copy.

  3. Navigate in the costing structure to the cost estimate in which you want to insert the items.

  4. On the List screen of the cost estimate, go to the line where you want to insert the items and choose Paste to insert the items from the clipboard.

    Note

    The quantities are transferred on a 1:1 basis. The system does not automatically adjust the quantities based on lot size or other criteria. You have to manually correct the quantities to match the quantity ratio based on the cost estimate lot size.

Global Filters

The graphic demonstrates how to set filters on a table using a filter icon and a context menu.

You can use the List screen filter to reduce the number of items displayed.

To set a filter, perform the following steps:

  1. Select one or more columns on the list screen.

  2. Choose the filter icon.

  3. Enter the filter requirements.

Only the items fulfilling the requirements are displayed on the screen. If you want to see all items again, choose Delete filter.

When a global filter has been set, it remains until it is deleted, even if you navigate to another cost estimate in the costing structure.

Worklists

The design of the worklist is such that frequently used structures and resources are available to the cost planner. You can drag and drop substructures and individual costing items from the worklist to the cost estimate in the costing structure.

Double-click a resource in the worklist to branch to other data, such as the master data.

The system displays the cost estimates that you select in the worklist as multi-level BOMs. You can display a multi-level BOM by double-clicking it.

The contents of worklists are organized in folders. You can create private and global folders in the worklist. Each folder is made up of containers. You can specify whether a container is allowed to have a specific item category only, such as base planning objects, or whether the container can contain multiple item categories. If the container becomes too large, you can either create a new one or convert it to a folder.

Create a Multilevel Cost Estimate

Optional: Modify a Multilevel Cost Estimate

Summary

  • Multilevel unit costing allows hierarchical editing of multiple materials, enhancing flexibility and efficiency in cost estimation.
  • Create multilevel material cost estimates without quantity structure using a material master with costing view.
  • Costing structure displays multilevel BOMs, enabling quick navigation and detailed information access.
  • Use global functions like Cut, Copy, and Paste to transfer costing items between estimates efficiently.
  • Worklists provide easy access to frequently used structures and resources, facilitating cost planning.