Show TOC

 Price versus Cost Estimate Locate this document in the navigation structure

Use

Before you update the standard price with the cost estimate values calculated in a costing run, you can use the report variant Price versus Cost Estimate of the report Summarized Analysis: Costing Run to check the amount of the variance between the cost estimate and the standard price, and to see what the effect of releasing the cost estimate for all materials with price control S would be on the value of the total inventory.

This report variant compares the value of the cost estimate with a material master price you selected (such as the standard price). In addition to the variance between the material master price and the cost estimate price, the system calculates the anticipated revaluation of the inventories of all materials whose price control indicator is set to S that would result if the cost estimate were released. However, since materials whose price control indicator is set to V are not affected when the standard cost estimate is released, you should set the relevant filter to the Price control field for these materials if you are interested in the effects of the revaluation. This filters the materials in question out of the report display.

You can define exceptions to emphasize critical variances for individual materials. When you use these exceptions, materials will be highlighted with traffic lights symbols if the calculated variance or the anticipated revaluation exceeds predefined threshold values.

Example Example

You generate a list of materials costed in the costing run, in which you can compare the cost estimate value with the current standard price. The system calculates the variances between the two prices. The system also calculates the value associated with the anticipated inventory revaluation upon release of the cost estimate. You have decided that all materials whose costing result varies from the standard price by more than 10% should be flagged with red traffic lights, and have defined exceptions accordingly.

End of the example.

Features

The report offers you a range of preselected data. You can modify this structure to suit your own requirements by creating your own custom layout .

Material master price field

You can enter a price from the material master (such as tax-based prices or planned prices) in the selection screen. After you run the report, the selected price is available as a visible field and can be used to compare this price with the calculated price of the material. You can display variances between the price chosen by you and the cost estimate value in the report display via the Costing/MM key figure.

Example Example

You can use the report variant Costing Run Result to gain an overview of the materials costed without errors and their costing values.

In the selection screen of the report, enter value 1 ( = standard price) in the material master price field and execute the report. In the report display, select the fields Standard Price and Costing/MM from the function current display variant . This displays the standard price for each material costed. The difference between the standard price and the costing result is shown in the Costing/MM field.

End of the example.

Activities

Enter the necessary selection criteria in the selection screen. You can limit the selection of costed materials. This way you can have only those materials displayed in the report whose costing results deviated from the standard price by at least 10%, for example.

The field material master price controls which price is compared with the costing result. In the standard system, this field is not visible and the cost estimate is compared with the standard price to simulate the revaluation of the inventories that would take place if the standard cost estimates were released. You could also compare the costs with Tax Price 1, for example, to see the variances between these two prices. Display the field with All selections .

Exceptions

You can define exceptions if necessary.

Exceptions are used to highlight particularly important materials in the report display with traffic light symbols (red/yellow/green). These traffic light symbols are used when certain values exceed a predefined threshold (for example, when the variance between the costing result and the standard price exceeds 10%). You specify the reference for the threshold values. The percentage and absolute threshold values you specify tell the system by how much this reference value must be exceeded before it displays a traffic light symbol on the material.

The following figures are available for exceptions in the field Comparison value :

  • Variance between cost estimate and material master price

(the reference fields of exceptions are the key figures Costing/MM and % Costing/MM )

  • Anticipated revaluation

(reference field of exceptions is the key figure revaluation )

With exceptions, you can specify for example for the variance between the cost estimate and the material master price that:

  • A red light is displayed for all materials with variances between the cost estimate value and the material master price exceeding 10%

  • A yellow light is set for all materials with variances between the cost estimate value and the material master price of 10% to 5%

  • A green light is displayed at all materials with variances between the cost estimate value and the material master price of less than 5%

If you set exceptions for the anticipated revaluation, you can specify for example that:

  • A red light is displayed for all materials whose probable revaluation of the inventories is greater than $2000.

  • A yellow light is displayed for all materials whose probable revaluation of the inventories is between $2000 and $1000.

  • A green light is displayed for all materials whose probable revaluation of the inventories is less than $1000.

You can specify whether only the exceptions are displayed (red and yellow), or all costed materials. If your costing runs contain a large number of materials, it is recommended that you only display the exceptions.

You can also specify whether positive and negative variances are displayed.

If you don’t want to see any exceptions, either set the comparison value to 00 <no comparison value> or don’t enter any threshold values.

Integration

From the report, you can display the cost estimate for each material and call up the following reports:

  • BOMs

  • Cost components

  • Cost elements

  • Partner cost component split