Array Home Array

3.06 Reportgenerator "ReportMaker" (continued 5)

Key Figures

Definition:

Key figures are consolidated values, which are calculated using algorithms from the document data or other key figures, and which describe a document. An ID as a unique identification is assigned for each key figure. Projectile supports key figures for the forms contact, project, jobs and employee.

The use of key figures in Projectile allows the user to create total values, values for any point in time and values for any time period. The values which are created by key figures are marked with a creation date, so that they can be stored and reused without a re-calculation. Furthermore, each key figure can be assigned to a document, and can be integrated by key figures in the screen views and in reports.

Usage:
After a project, a job or an employee has been chosen by using the search function in Projectile, clicking on “Report” opens the Report-Designer. Here are the key figures in the column “column content”, where they are identified by an asterisk. After one or several key figures have been selected, it is necessary to select '(periods)' in the same column. Then, a time interval should be defined for the key figures. Select the “time interval” in the drop down box, for example “current month”, and then select a period, for example, “weekly”. Additionally, the creation of new key figures for a defined period of time can be blocked by using the “Max figures age”.

Afterwards an aggregate type for forming sums for the key figures. In the row of the key figure, in the drop down box “Periodic”, select either “Total” = the entire static value including the non-visible values, “periodic” = the timed limit of the total value, “sum” = the sum of the visible values and “accumulated” = the sum of the periodical determined values.

After clicking save, go back to the dialog field, and also click save, an output format is selected and “Show Reports” is clicked. The report with the key figures is generated and is available for further usage.

Reference:

Customer Form:

Name	Description	Type	SubTyp	ID	Standard yes/no
Incoming Invoice	Incoming invoice amount of the contact, the sum of the contact, sum of the incoming invoice positions, which refer to the contact, Limit: date of the incoming invoice	FLOAT	IncomingInvoice_Tracked_Customer	yes
Offer Tracked	The basis of these key figures is the data of the offer. The net amounts of the offer values of all projects of the customer with the status “offer included” are calculated here. When limited, the date of offer is used.	FLOAT	MONEY	Offer_Tracked_Customer	yes
Order Value	The order value of the supplier, sum of the order positions which refer to the supplier (gross amount), Limit: date of order	FLOAT	OrderValue_Tracked_Customer	yes
Order Confirmation Tracked	The basis of these key figures is the data of the order confirmation. The net amounts of the orders of all projects of the customer with the status “offer confirmation included” are calculated here. When limited, the date of the order is used.	FLOAT	MONEY	OrderConfirmation_Tracked_Customer	yes
Profitability Tracked	Profitability = (revenue - costs) / revenue, revenue is the actual revenue and is estimated for fixed price projects based on the degree of completion. Basis of this calculation should not be the “pure” recorded time, but should be calculated in percentage - in relation to the daily working times of 8 hours. In the evaluation of fixed-price projects with the aid of the degree of completion, the true revenue is considered only with the final bill (fixed price or amount of payment invoices = 100%). For all other states (complete <100%), the fixed price (orders, if filled - otherwise offer value when filled - otherwise plan revenue after adding surcharges) is used and this value is multiplied with the degree of completion / 100.	FLOAT	Profitability_Tracked_Customer	yes
Estimated Sales	Order value in the sales pipeline multiplied with the probability	FLOAT	MONEY	Sales_Estimated_Customer	yes
Planned Sales	Planned order value, order value in the sales pipeline	FLOAT	MONEY	Sales_Planned_Customer	yes
Supplier Budget	Sum of the budgets of the order positions, which belong to the order of the suppliers. Budgets have no fixed date, but margin, overlapping charge	FLOAT	SupplierBudget_Tracked_Customer	yes
Supplier Turnover	Sum of the incoming invoice positions, which refer to the project and are included into the outgoing invoices.	FLOAT	SupplierTurnover_Tracked_Customer	yes
Time Billed	Billed effort/time from included job times, the time limit is based on the date entries of the billed time entries	FLOAT	MONEY	Time_Billed_Customer	yes
Turnover Tracked	The basis of these key figures is the data of the invoice. The net amounts of the invoice amounts of all projects of the customer with the status “offer confirmation included” are calculated here. When limited (if existent), the time span of the service, otherwise the date of the invoice is used.	FLOAT	MONEY	Turnover_Tracked_Customer	yes

Project Form:

Name	Description	Type	SubTyp	ID	Standard yes/no
Budget External Tracked	Total ext. amounts of all budgets of the project, Span: fully or partially overlapping	FLOAT	BudgetExternal_Tracked_Project	yes
BudgetInternalTracked	Total internal amounts of all budgets of the project, Span: fully or partially overlapping	FLOAT	BudgetInternal_Tracked_Project	yes
Planned Material Costs	Total ext. amounts material cost-Budget of the project	FLOAT	BudgetMaterial_Tracked_Project	no
Remaining Cost	Remaining budget on the basis of the difference of actual time and target time, also external hourly rate	FLOAT	MONEY	RemainingCost_Calculated_Project	no
Budget Third Party	Total ext. amounts FL-Budgets of a project	FLOAT	BudgetThirdParty_Tracked_Project	no
Planned Travel Cost	Total ext. amounts travel cost budgets of the project	FLOAT	BudgetTravel_Tracked_Project	no
Completion Calculated	Degree of completion by calculation, not based on estimates, but purely on the basis of plan and actual. The basis of this key figure is the quotient of actual and planned time or (if available) the final employee estimate less the thereafter recorded services. This data is determined for each job and summarized for the projects. When defining the time span, either the plan and actual time or the estimates of the jobs are used on a daily basis.	FLOAT	Completion_Calculated_Project	yes
Completion Employee Estimated	Key Figure: Degree of completion by employee estimate, i.e. estimates from TT. The basis of this figure is the tracking and recording system TimeTracker and the estimate completion dialog. Here, the remaining time and/or degree of completion for jobs are entered by the employee and, if necessary, corrected by the project manager in the dialog “estimate completion”. When defining the time span, the estimates are used per day.	FLOAT	Completion_EmployeeEstimated_Project	yes
Completion Manager Estimated	Key Figure: Degree of completion through the manager's estimate, i.e. from the states documents, which depends directly on the project. The basis of this key figure is the degree of completion of the project. When defining the time span, the estimates per deadline are used.	FLOAT	Completion_ManagerEstimated_Project	yes
Cost Normalized	This key figure calculates analogue to the key figure Work Cost Tracked* (project form), which multiplies the recorded actual time with the internal hourly rate of the employee. Basis of the calculation is not the “pure” recorded time, but the calculation of costs are in percentage - in relation to the daily working times of 8 hours. The time span is the date entries of the time recording.	FLOAT	MONEY	Cost_Normalized_Project	yes
Cost Material Tracked	Total ext. amount of the costs	FLOAT	CostMaterial_Tracked_Project	no
Misc Cost Tracked	Total ext. other amounts of the costs	FLOAT	CostOther_Tracked_Project	no
Cost Performance Estimated	The CPI (Cost Performance Index) is the cost-related performance key figure of Earned Value Analysis. It is formed from the ratio of earned value and actual time. This means that with a CPI of greater than 1.00 (100%) the project results are rendered at a lower cost than originally planned, while a value of less than 1.00 (100%) exceeds the project's budget. Calculation: Planned time * degree of completion / actual time spent	FLOAT	CostPerformance_Estimated_Project	yes
Planned Cost Total	Total planned costs on the basis of jobs and budgets, internal costs	FLOAT	MONEY	Cost_Planned_Project	yes
Cost Tracked	Internal job costs + costs from cost documents, such as receipts, driving, travel ... The basis of this key figure is the tracking and recording entries (Time Tracker) and the cost recording (drive, receipt, travel, foreign costs and foreign invoices). Here, the work cost tracked* and all internal costs (net amounts) of the entries for driving, receipts, travel, foreign costs and foreign invoices are totaled. When defining a time span, the recorded time and cost receipts are used per day.	FLOAT	MONEY	Cost_Tracked_Project	yes
Cost Third Party Tracked	Total ext. amounts of the costs	FLOAT	CostThirdParty_Tracked_Project	no
Travel Cost Tracked	Total ext. amounts of the costs	FLOAT	CostTravel_Tracked_Project	no
End Tracked	Key figure: end of time tracking, last time at which something has been recorded for a project, whether time, receipts, travel, travel, etc.	DATE	End_Tracked_Project	no
Incoming Invoice	Incoming invoice of the project, the total of the incoming invoice position items that reference the project, Time span: the date of the incoming invoice	FLOAT	IncomingInvoice_Tracked_Project	yes
Incoming Invoice Net	Incoming invoice of the project, the total of the invoice position items, which reference the project (net), Time span: Date of incoming invoice	FLOAT	IncomingInvoiceNet_Tracked_Project	yes
Turnover Chargeable	All billable times multiplied by the hourly rates, i.e., job times which can be billed in invoices. The basis of this key figure is the key figure “Chargeable Time*”. This key figure is multiplied with the external hourly rate of the job (see pricing). When defining the time span, the the time recording are used per day.	FLOAT	MONEY	Turnover_Chargeable_Project	yes
Job Turnover Tracked	The basis of this key figure is the data of the invoice. Here the net amounts of the position items are calculated based on jobs of the project with the status “Invoice included”. If the time span is defined, the performance period is used, otherwise the invoice date is used.	FLOAT	MONEY	JobTurnover_Tracked_Project	yes
Misc Cost Tracked	All costs except work costs: item sales, trips, travel, receipts, Time span: Date entris of the cost documents	FLOAT	MONEY	MiscCost_Tracked_Project	yes
Offer Value	The basis of this key figure is the data of the offer. Here, the net amounts of the offer value of the project with status “Offer included” are calculated. When defining the time span, the date of the offer is used.	FLOAT	MONEY	Offer_Tracked_Project	yes
Order Confirmation Value	The basis of this figure is the data of the order confirmation. Here the net amounts of the orders of the project with status “Order Confirmation included” is calculated. When defining the time span, the date of the order is used.	FLOAT	MONEY	OrderConfirmation_Tracked_Project	yes
Order Value net	Sum of order positions that reference the project, Time boundary: order date	FLOAT	OrderValueNet_Tracked_Project	yes
Order Value	Sum of order items that reference the project (gross), Time boundary: order date	FLOAT	OrderValue_Tracked_Project	yes
Planned Working Days Project Passed	These are the elapsed days between the planned beginning and planned end. Weekends are not counted, but public holidays are, Time span: planned start and planned end of the project	FLOAT	PassedWorkingDays_Planned_Project	yes
Profitability Tracked	Profitability = ( turnover - costs ) / turnover, Turnover is the actual turnover and is estimated for fixed-price projects based on the degree of completion. The basis of this calculation should not be the “pure” recorded time, but should be in percentage - with relation to the daily working time of 8 hours. \ \ In the evaluation of fixed-price projects using the degree of completion, the true turnover is only considered with the final bill (fixed price or total amount of advance payment invoices = 100%). For all other states (complete <100%) the fixed price (order value if filled - otherwise offer value when filled - otherwise planned turnover after surcharges) is used and this value is multiplied with the degree of completion / 100.	FLOAT	Profitability_Tracked_Project	yes
Planned Project Position	Project position amount, where documents of type project position be attached to a project)	FLOAT	ProjectPosition_Planned_Project	no
Remaining Cost Employee Estimated	The key figure is calculated from the employee estimates of the remaining time in the Time Tracker and the internal hourly rate	FLOAT	MONEY	RemainingCost_EmployeeEstimated_Project	yes
Remaining Time Employee Estimated	The basis of this key figure is tracking and recording entry (TimeTracker) and the estimate completion dialog. Here the remaining time and/or degree of completion of jobs are entered by the employee and, if necessary corrected by the project manager in the dialog “Estimate completion”. When defining the time span, the estimates are used per day.	FLOAT	DURATION	RemainingTime_EmployeeEstimated_Project	yes
Start Tracked	Start time recording, first time recording for the project, whether time, receipts, driving, travel, etc.	DATE	Start_Tracked_Project	yes
Supplier Budget	Sum of the budgets, which reference the order positions in the project. Budgets have no fixed date, but a margin, charge overlapping	FLOAT	SupplierBudget_Tracked_Project	yes
Supplier Turnover	Sum of the incoming invoice items, which reference the project and is included in the outgoing bills, Time Boundary: Invoice Date	FLOAT	SupplierTurnover_Tracked_Project	yes
Billed Effort	Sum of the jobs, the boundary is based on date entries of the billed time entries	FLOAT	DURATION	Time_Billed_Project	yes
Chargeable Effort	The basis of this key figure is tracking and recording entry (TimeTracker) and the evaluation of chargeable services. Here, the billable time of individual jobs is charged at the project level. In defining the time span, the time entries per day are used.	FLOAT	DURATION	Time_Chargeable_Project	yes
Time Performance Estimated Project	Formula for calculation: (planned period (Total) * degree of completion) / Plan period (at the reporting date). The SPI (Schedule Performance Index) is the time-related performance key figure of earned value analysis. It is formed from the ratio of earned value and planned time/effort. This means that with an SPI greater than 1.00 (100%) the project results were delivered faster than originally planned, while a value of less than 1.00 (100%), the project is progressing too slowly. Calculation: the product of overall planned duration and degree of completion divided by the planned duration to the reporting period (to the project respectively)	FLOAT	TimePerformance_Estimated_Project	yes
Planned Time	The basis of this key figure is the project planning. Here, the planned time of the individual jobs are charged at the project level. When defining a time span, the planned time of the jobs under the assumption of uniform distribution are calculated on a daily basis.	FLOAT	DURATION	Time_Planned_Project	yes
Planned Time Active	The basis of this key figure is the project planning. Here, the planned time of the individual jobs are charged at the project level. When defining a time span, the planned time of the jobs under the assumption of uniform distribution are calculated on a daily basis.	FLOAT	DURATION	Time_PlannedActive_Project	yes
Target Time	The basis of this key figure is the project planning. Here, the target time/effort of the individual jobs is calculated at the project level. When defining a time span, the target time/effort of the jobs under the assumption of uniform distribution are calculated on a daily basis.	FLOAT	DURATION	Time_Target_Project	yes
Time Purchased	Time from incoming invoices, time purchased ext. employee sum of hours from the incoming invoice positions, which is assigned a job. Boundary: Date of incoming invoice	FLOAT	DURATION	Time_Purchased_Project	yes
Actual Time Spent	The basis of this key figure is the tracking and recording entry (TimeTracker). Here, the recorded times of the employee of the job is summarized at the project level. When defining a time span, the recorded times per day are used.	FLOAT	DURATION	Time_Tracked_Project	yes
Travel Cost Tracked	The basis of this key figure is the travel expense entry (travel). Here, the net amounts of travel expense entry for each project are summarized. In defining the scheduled cost per day are used. When defining a time span, the recorded costs per day are used.	FLOAT	MONEY	TravelCost_Tracked_Project	yes
Travel Cost Tracked Gros	The basis of this key figure is the travel expense entry (travel). Here are the gross amounts from the travel expense entry per project is summarized. When defining a time span, the recorded costs per day are used.	FLOAT	MONEY	TravelCostGros_Tracked_Project	yes
Turnover Chargeable	All billable times multiplied by external hourly rate, i.e. which job times can be billed on the invoices	FLOAT	MONEY	Turnover_Chargeable_Project	yes
Turnover External Chargeable	Calculating the costs based on the jobs of external employees in incoming invoice positions	FLOAT	MONEY	TurnoverExternal_Chargeable_Project	yes
Turnover Planned	The basis of this key figure is project planning and order administration. If the order value is stored (order confirmation or manually) the planned turnover = order value (net), if the order value is not set, but the offer value is then planned turnover = offer value (net), otherwise the project turnover (project + surcharges) is used.	FLOAT	MONEY	Turnover_Planned_Project	yes
Invoice Value	The basis of this key figure is the data of the invoice. Here, the net amount of the invoice amounts of the project with status “Invoice included” will be charged. If a time span is defined, the performance period is used, otherwise the invoice date is used.	FLOAT	MONEY	Turnover_Tracked_Project	yes
Work Cost Tracked	The basis of this key figure is the tracking and recording entry (TimeTracker) and the internal hourly rate of the employee. Here, the recorded time (actual time) is multiplied with the internal hourly rates of the employee of the job (if existance from the employee contract, otherwise from the master data of the employee). When defining a time span, the recorded time per day are used.	FLOAT	MONEY	WorkCost_Tracked_Project	yes
Work Cost External Tracked	Actual work effort external (for external staff). The costs are calculate based on the jobs in the incoming invoice positions	FLOAT	MONEY	WorkCostExternal_Tracked_Project	yes
Planned Working Days Project	These are the days between the planned start and planned end. Weekends are not counted, but public holidays are	FLOAT	WorkingDays_Planned_Project	yes
Tracked Working Days Project	These are the days between the first and the last time recording. Weekends are not counted, but public holidays are	FLOAT	WorkingDays_Tracked_Project	yes

Job Form:

Name	Description	Type	SubTyp	ID	Standard yes/no
Completion Employee Estimated	The basis of this figure is the tracking and recording entry (TimeTracker) and the estimate completion dialog. Here, the remaining time and/or degree of completion for jobs are entered by the employee and, if necessary, corrected by the project manager in the dialog „estimate completion“. When defining the time span, the estimates are used per day.	FLOAT	Completion_EmployeeEstimated_Job	yes
Completion Calculated	The basis of this key figure is the quotient of actual and planned time or (if available) the final employee estimate less the thereafter recorded services. When defining the time span, either the plan and actual time or the estimates of the jobs are used on a daily basis.	FLOAT	Completion_Calculated_Job	yes
Cost Normalized	The cost is based on actual times. These cost are allocate so (normalized), that the recorded time of the planned period corresponds to the day. Therefore, when times have been recorded in hours, there will always be 8.0 (if this was entered into the calendar). These hours are then multiplied by the internal rate	FLOAT	MONEY	Cost_Normalized_Job	yes
Planned Costs	The basis of this key figure is project planning. Here, the key figure “planned time*” and the external hourly rates (see pricing) are multiplied. When defining a time span, the planned time under the assumption of uniform distribution are calculated on a daily basis.	FLOAT	MONEY	Cost_Planned_Job	yes
Cost Tracked	The basis of this key figure is tracking and recording entry (TimeTracker). Here, the key figure “actual time*” and the internal hourly rates (see costing) are multiplied. When defining a time span, the recorded time per day is used.	FLOAT	MONEY	Cost_Tracked_Job	yes
Cost External Tracked	Actual costs external (for external employees). The costs are calculated based on the jobs, using the incoming invoices for the job	FLOAT	MONEY	CostExternal_Tracked_Job	yes
End Tracked	End time recording	DATE	End_Tracked_Job	yes
Planned Working Days Passed	These are the elapsed days between the planned start and planned end. Weekends are not counted, but public holidays are, Time span: planned start and planned end of the job	FLOAT	PassedWorkingDays_Planned_Job	yes
Remaining Cost Calculated	Remaining budget is based on the difference of actual time and target time and external hourly rate	FLOAT	MONEY	RemainingCost_Calculated_Job	no
Remaining Cost Employee Estimated	Remaining costs through employee estimate	FLOAT	MONEY	RemainingCost_EmployeeEstimated_Job	no
Remaining Time Employee Estimated	The basis of this key figure is tracking and recording entry (TimeTracker) and the estimate completion dialog. Here, the remaining time and/or degree of completion of the job is entered by the employee and, if necessary corrected by the project manager in the dialog „Estimate completion“. When defining the time span, the estimates are used per day.	FLOAT	DURATION	RemainingTime_EmployeeEstimated_Job	yes
Start Tracked	Start time recording	DATE	Start_Tracked_Job	yes
Time Billed	Billed Time, in this context, the billable times on the job basis. Here, on the basis of the billed time entries and not on the invoice position basis. The boundary is based on date entries of the billed time entries	FLOAT	MONEY	Time_Billed_Job	yes
Chargeable Time	The basis of this key figure is tracking and recording entry (TimeTracker) and the evaluation of chargeable services. Here, the billable times of individual jobs is charged. In defining the time span, the time entries per day are used	FLOAT	DURATION	Time_Chargeable_Job	yes
Planned Time	The basis of this key figure is the project planning. Here, the planned time of the job is defined. When defining a time span, the planned time under the assumption of uniform distribution are calculated on a daily basis.	FLOAT	DURATION	Time_Planned_Job	yes
Planned Time Active Projects	As “Planned Time”, but only for running (active) projects	FLOAT	DURATION	Time_PlannedActive_Job	yes
Time Purchased	Time from incoming invoices, time purchased ext. employee sum of hours from the incoming invoice positions, which is assigned a job. Boundary: Date of incoming invoice	FLOAT	DURATION	Time_Purchased_Job	yes
Target Time	The basis of this key figure is the project planning. Here, the target time of the job is calculated. When defining a time span, the target time under the assumption of uniform distribution is calculated on a daily basis.	FLOAT	DURATION	Time_Target_Job	yes
Actual Time Spent	The basis of this key figure is the tracking and recording entry (TimeTracker). Here, the recorded times of the employee of the job is used. When defining a time span, the recorded times per day are used.	FLOAT	DURATION	Time_Tracked_Job	yes
Turnover Calculated	Employee turnover. Actually, this number is not a periodical key figure, it is only logical in an overall result sense.	FLOAT	MONEY	Turnover_Calculated_Job	no
Turnover Chargeable	The basis of this key figure is the key figure “Chargeable Time *”. This key figure is multiplied with the external hourly rate of the job (see pricing). When defining a time span, the recorded times per day are used.	FLOAT	MONEY	Turnover_Chargeable_Job	yes
Turnover Chargeable external	Calculating the costs based on the jobs of external employees in incoming invoice positions	FLOAT	MONEY	TurnoverExternal_Chargeable_Job	yes
Planned Time	The basis of this key figure is the project planning. Here, the planned time of the job is multiplied with the external hourly rate (see pricing). When defining a time span, the planned time under the assumption of uniform distribution are calculated on a daily basis.	FLOAT	MONEY	Turnover_Planned_Job	yes
Turnover Tracked	The basis of these key figures is the data of the invoice. The net amounts of the invoice positions based on the job with the status „Invoice included“ are defined here. When limited (if existent), the time span of the service is used, otherwise the date of the invoice is used.	FLOAT	MONEY	Turnover_Tracked_Job	yes
Planned Working Days Project	These are the days between the planned beginning and planned end. Weekends are not counted, but public holidays are	FLOAT	WorkingDays_Planned_Job	yes
Working Days_Tracked Project	These are the days between the first and last time recording. Weekends are not counted, but public holidays are	FLOAT	WorkingDays_Tracked_Job	yes

Employee:

Name	Description	Type	SubTyp	ID	Standard yes/no
Cost Tracked	The basis of this key figure is the key figure “work cost tracked*”, plus all recorded travel expenses, receipts, travel and foreign costs) of the employee. When defining a time span, the recorded times per day and the receipt date is used.	FLOAT	MONEY	Cost_Tracked_Employee	yes
Job Turnover Tracked	The basis of this key figure is the data of the invoice. Here the net amounts of the position items are calculated based on jobs of the employee with the status „Invoice included“. If the time span is defined, the performance period is used, otherwise the invoice date is used.	FLOAT	MONEY	JobTurnover_Tracked_Employee	yes
Turnover Tracked	The basis of these key figures is “Job Turnover Tracked*”. The net amounts of all invoice positions based on all jobs of the employee with the status „Invoice included“, plus all billed costs of the employee (drive, receipt and travel) are defined here. When limited (if existent), the time span of the service is used, otherwise the date of the invoice is used.	FLOAT	MONEY	Turnover_Tracked_Employee	yes
Presence Planned	This key figure determines the planned working time of the employee in the interval corresponding to the location (calendar), or (if existent) of the employee contract.	FLOAT	MONEY	Presence_Planned_Employee	yes
Start Tracked	Start time recording, first time recording, also date of entered receipts, driving, travel, etc.	DATE	Start_Tracked_Employee	yes
End Tracked	End time recording, also date of entered receipts, driving, travel, etc.	DATE	End_Tracked_Employee	yes
Flextime Entitlement Begin	Flextime Entitlement Begin	FLOAT	Flextime_EntitlementBegin_Employee	yes
Flextime Entitlement End	Flextime Entitlement End	FLOAT	Flextime_EntitlementEnd_Employee	yes
Incoming Invoice_Tracked	Total of incoming invoice positions, which refer to the employee, Boundary: date of the incoming invoice	FLOAT	IncomingInvoice_Tracked_Employee	yes
Order Value Tracked	Total of the order positions, which refer (gros) to the employee, Boundary: Order date	FLOAT	OrderValue_Tracked_Employee	yes
Supplier Budgets	Sum of the budgets of order positions, which refer to the employee. Budgets have no fixed date, but have a margin, overlapping is calculated	FLOAT	SupplierBudget_Tracked_Employee	yes
Supplier Turnover	Sum of the incoming invoice positions, which refer to the employee and are included into the outgoing invoice, Boundary: invoice date	FLOAT	SupplierTurnover_Tracked_Employee	yes
Billed Time	Billed time from jobs of the employee, The time limit is based on the date entries of the billed time recording	FLOAT	MONEY	Time_Billed_Employee	yes
Chargeable Time	The basis of this key figure is tracking and recording entry (TimeTracker) and the evaluation of chargeable services. Here, the billable time of all jobs of the employee is charged. When defining the time span, the time entries per day are used.	FLOAT	DURATION	Time_Chargeable_Employee	yes
Planned Time	The basis of this key figure is the project planning. Here, the planned time of the jobs of the employee are defined. When defining a time span, the planned time under the assumption of uniform distribution are calculated on a daily basis.	FLOAT	DURATION	Time_Planned_Employee	yes
Time Planned Active	As „Planned Time“, but only for running (active) projects	FLOAT	DURATION	Time_PlannedActive_Employee	yes
Time Tracked	The basis of this key figure is tracking and recording entry (TimeTracker). Here, the recorded time of all jobs of the employee are defined. When defining the time span, the recorded times per day are used.	FLOAT	DURATION	Time_Tracked_Employee	yes
Turnover Calculated	Employee turnover. Actually, this number is not a periodical key figure, it is only logical in an overall result sense.	FLOAT	MONEY	Turnover_Calculated_Employee	no
Turnover Chargeable	The basis of this key figure is the key figure „Chargeable Time*“. This key figure is multiplied with the external hourly rate of all jobs (see pricing). When defining the time span, the the time recording is used per day.	FLOAT	MONEY	Turnover_Chargeable_Employee	yes
Turnover Planned	The basis of this key figure is project planning. Here, the planned time of all jobs of the project are multiplied with the external hourly rate (see pricing). When defining the time span, the planned time under the assumption of uniform distribution is calculated on a daily basis.	FLOAT	MONEY	Turnover_Planned_Employee	yes
Vacation Entitlement Begin	Beginning of vacation entitlement	FLOAT	Vacation_EntitlementBegin_Employee	yes
Vacation Entitlement End	End of vacation entitlement	FLOAT	Vacation_EntitlementEnd_Employee	yes
Vacation Paid Off	Paid off vacation	FLOAT	Vacation_PaidOff_Employee	yes
Cost Planned	The basis of this key figure is the project planning. Here, the planned time of all jobs of the employee are defined. When defining a time span, the planned time under the assumption of uniform distribution are calculated on a daily basis.	FLOAT	MONEY	WorkCost_Planned_Employee	yes
Work Cost Planned	This key figure is identical to “Cost Planned” at the present	MONEY	WorkCost_Planned_Employee	yes
Work Cost Tracked	The basis of this key figure is tracking and recording entry (TimeTracker). Here, the key figure “Actual Time Spent*” is multiplied with the internal hourly rate (see costing). When defining the time span, the the recorded time is used per day.	FLOAT	MONEY	WorkCost_Tracked_Employee	yes
Planned Working Days	Working days, without weekends and without public holidays	FLOAT	WorkingDays_Planned_Employee	yes

... continued page 6