+351 214 866 440 geral@timelink.pt

CTimeXL Construction Business Inteligence

CTime is an application that is developed by TimeLink to function as a Business Intelligence tool that brings together data from Candy and from the company’s ERP or Accounting system.

Overview

  • Projects can be consolidated and analysed by characteristic, for example: by geographical regions, by contracts manager, by job type, etc.
  • Projects can be controlled to the required level of detail: Job Location, Task, Group, Ledger and Resource
  • Costs, Income and Profit Margins can be controlled.
  • 360º control of Amounts, Quantities and Rates.
  • Data for elapsed periods is stored for analysis and is displayed with the projections for remaining periods. Data can be analysed by period or cumulative amounts.
  • Alerts can be configured by defining the maximum permissible variation amounts, and any values that exceed these limits will be automatically highlighted, allowing the users to speedily identify difficulties.
  • The last month’s data can be rapidly incorporated into the analysis and the future forecasts are automatically updated based on the latest revision of the production budget. Using Candy, the production budget is updated dynamically on the fly.
  • Quick review of previous periods’ data.
  • Unlimited reporting with pre-defined by editable Excel Pivot Tables and Pivot Charts.
  • Create reports in Word or PDF format automatically.
  • Automatically send reports through Outlook.
CTime Export
CTimeXL project control

The Dashboard sheet:

The summary dashboard provides a quick and extensive overview, in amounts and percentages, of the current position of the company, the project(s), the costs, the income and the profit margins.

CTimeXL Dashboard

The Cumulative and Period Amounts Sheets:

These two sheets are similar, but the one shows cumulative values and the other shows period values. Note that the period values that are shown are derived from the differences in the previously recorded cumulative amounts, and this data cannot be changed.

Analyse and compare planned, forecast, actual and projected amounts.

The PPI (Production Performance Indicator), is an indicator of the production that has been achieved against the planned production.

The CPI (Cost Performance Indicator), is an indicator of the actual costs against the expected costs for the production that has been achieved.

CTimeXL The Cumulative and Period Amounts Sheets

The Final Amounts Sheet:

Comparison of the Tender Bid Budget against the Production Budget (initial and current).

Follow the development over time of the Projected Final Amounts (dynamically updated via the Current Production Budget) against the Production Budget, at the required level of detail.

CTimeXL Final Amounts

 The Financial Sheet:

Follow the development of the payments or income amounts over time, at the required level of detail:

CTimeXL Financial sheet

 The Rates sheet:

Comparison of the average production budget rates versus the actual average rates (from the accounts) and the projected rates for works remaining (from the current production budget). Immediately establish what the impact of the resource rate variations (in amounts and %) is on the current cumulative variation for the project(s). Projection of the future impact of the variations.

CTimeXL The Rates sheet

 The Quantities Sheet:

Comparison between the initially budgeted quantities, the currently budgeted quantities and the projected quantities (for completed and outstanding works). Monthly forecast for the projected quantities (for the outstanding works). Immediately establish what the impact of the resource quantity variations (in amounts and %) is on the current cumulative variation for the project(s). Leverage purchasing power and manage future resource purchasing requirements by consolidating like resources across the company’s projects for greater profits.

CTimeXL The Quantities Sheet

The Amounts over Time Sheet:

Graphical and numerical analysis of the factual past and the projected probable future of the project(s).

CTimeXL Values over time

The Adjustments Sheet:

Scrutinise the evolution of the adjustments that have been made (against cost and income).

Analyse the impact of the adjustments on the individual projects or on consolidated projects.

CTimeXL The Adjustments Sheet

The Margins and Degree of Completion Sheet:

Assessment of the margins: tender bid budget, the initial production budget, the current production budget and the projected final.

Scrutinise the evolution of the degree of completion of the individual projects or consolidated projects.

Compare the profit declared with the result considering the degree of completion.

CTimeXL The Margins and Degree of Completion Sheet

The Cost / Income Ratio Sheet:

Assessment of the Cost/income Ratios for the production (the production budget), the real (the actual) and the projection for each individual project or combined projects.

Item Description Source
Budget Cost vs forecast income (from the CPB -Current Production Budget) ratio Candy
Real Cost vs real income. Includes adjustments, if they exist. ERP
Final Proj. Cost vs projected income (from the CPB revised resource and production rates) ERP & Candy
CTimeXL The Cost Income Ratio Sheet

The Economic Fluxes Sheet:

Shows histograms for economic fluxes taking into account the previous cumulative amounts and projected amounts, for individual project (or consolidated groups of projects).

CTimeXL The Economic Fluxes Sheet

The Over/Under Invoicing Sheet:

Assessment of the development of amounts over time of the under/over invoicing for each project, and analysis of the items that originate the under/over invoicing.

Scrutinize the monthly financial impact on the project (or consolidated groups of projects).

CTimeXL The Over Under Invoicing Sheet

The Subcontracts Sheet:

Note that the data here should not include Labour Only subcontracts.

Track the amounts that have been awarded, the amounts that are due and the amounts paid.

Evaluate the under/over paid amounts for the subcontractor by project or group of projects.

Compare the amount due to the subcontractors for work done with the amount that is being claimed from the client, for the corresponding works.

Monthly assessment of the value of awarded subcontract work outstanding, against the value of the projected subcontract work remaining.

CTimeXL The Subcontracts Sheet:

The Items Status (Open / Close) Sheet:

Follow the progress of “closing” the “open” items in each project, and the resulting reduction in the degree of uncertainty of the projected final margin that having “open” items implies.

Identify the activities / items (and their amounts) which remain “open”.

CTimeXL The Items Status Open Close Sheet

The Loss Items Sheet:

Assess the items, which have negative margin (the loss items), for the remaining works that are still to be produced and/or invoiced,

CTimeXL The Loss Items Sheet

The VO’s Awaiting Approval Sheet:

Track the costs, income and margins amounts of the variation orders for which approval is outstanding, as well as the periods in which they arose to establish how long the approvals have been outstanding.

Assess the theoretical cost and income of the additional works completed for which approval was not given, as well as the period in which they were produced.

Analysis of the impacts of the above-mentioned amounts, by project or by projects.

The VO’s Awaiting Approval Sheet

Find out more.....

Would you like to find out more about Candy Estimating and how it would work in your business?

Get a taster for our software and see for yourself what Candy Estimating can do for your business.