This workbook provides the following information on a released material cost estimate with quantity structure:

• Fixed and variable costs as proportion of total cost
• Overall costs incurred in the lower levels as a proportion of the costs incurred in the last production level and of the total cost
• The cost component split is displayed sorted by cost component, while the cost components are sorted by cost component group

This combination enables all possible analyses of a cost estimate based on the available information. The following workbooks are available for analyses of standard prices across time:

The navigation blocks in the first two queries are hidden because it would not have been appropriate to change the drilldowns. In the third query, the drilldown by cost components can be removed.

Due to the restrictions that had to be made in the queries, only certain cost estimates are displayed in this workbook. If you want to display other cost estimates, see the documentation on the individual queries for more information.

This workbook contains the following queries: