Contract Profitability sourced measures and KPIs

This table shows the Contract Profitability measures that are sourced directly in Data Warehouse.

Available aggregations for the measures are Avg, Max, Min, and Sum.

Measure	Description
Cost – Material	The cost of materials in the division currency
Cost – Misc	The cost of miscellaneous items in the division currency
Cost – Subc	The cost of subcontracts in the division currency
Cost – Time	The cost of machine or labor time in the division currency
Fixed Amt – Material	The fixed amount from materials in the division currency
Fixed Amt – Misc	The fixed amount from miscellaneous items in the division currency
Fixed Amt – Subc	The fixed amount from subcontracts in the division currency
Fixed Amt – Time	The fixed amount from either machine or labor time in the division currency
Line Amt – Material	The line amount from material in the division currency
Line Amt – Material Charge	The line amount from material handling charges in the division currency
Line Amt – Misc	The line amount from miscellaneous items in the division currency
Line Amt – Subc	The line amount from subcontracts in the division currency
Line Amt – Subc Charge	The line amount from subcontracting handling charges in the division currency
Line Amt – Time	The line amount from either machine or labor time in the division currency
Margin – Material	The total material revenue minus the cost from material transactions
Margin – Misc	The revenue from miscellaneous items minus the cost from miscellaneous items
Margin – Subc	The total revenue from subcontracts minus the cost from subcontracts
Margin – Time	The total time revenue minus the cost of machine or labor time
Revenue – Material	The sum of the revenue and fixed amounts from materials and material handling charges
Revenue – Misc	The sum of the revenue and fixed amounts from miscellaneous items
Revenue – Subc	The sum of the revenue and fixed amounts from subcontracts and subcontracting handling charges
Revenue – Time	The sum of the revenue and fixed amounts from machine and labor time
Total Cost	The sum of cost from time, materials, subcontracts, and miscellaneous items
Total Fixed Amt	The total fixed amount from time, materials, subcontracts, and miscellaneous items
Total Line Amt	The sum of the line amounts from time, materials, subcontracts, handling charges, and miscellaneous items
Total Margin	The total revenue minus the total cost
Total Revenue	The sum of the line and fixed amounts from time, materials, subcontracts, handling charges, and miscellaneous items