Absolutely accurate and completely useless ...

Financial reports in most civil contracting businesses are an exercise in futility. They are produced an considerable cost, to tell the business owner information that is already known, out of date and confusing.

Civil Contracting businesses either spend valuable management time arguing about what the numbers are; or deciding what to do about them. Which are you?

Improving the usefulness of financial statements will have profound effects. The discipline required to produce useful financial statements reaches across your businesses, influencing behaviour, establishing expectations and generating cohesion. The insights provided enable you to focus on the critical issues impacting your business. The actions/decisions you make will guide your business on a more resilient path.

Focus on Outcomes can work with you to improve the usefulness of your financial reporting while reducing the time and effort required.

Contact Us

Does your Job Costing add up?

If you make a profit your a contractor …

If you make a loss your a charity …

Profit is the Revenue Earned from a contract less the Cost Incurred to earn that revenue.

The Total Value of the Contract is known. Where a job extends over more than a single reporting period this should be adjusted to match the costs incurred to date. How this is done will be the subject of another post as we are concentrating on cost.

Measuring Cost Incurred creates the following problems:

  1. Delay. Recording the actual cost against a job is delayed by the time taken for transactions to be recorded. Labour may only be processed fortnightly or even monthly. Subcontractors, plant and materials may have to wait until invoices are received.

  2. Attribution. Is the cost incurred directly attributable to a job or is it an indirect cost that should be part of the indirect costs allocated to the project.

  3. Determination. Significant job costs are calculated (determined) rather than directly the result of a known transaction. Internal Plant & Equipment charges, Labour cost, Project Management Costs, etc.

  4. Measurement. When determining Job Cost during a project it is necessary to measure the what proportion of the required scope has been delivered. The accuracy of this measure is critical to the value of information provided.

So what are the attributes of leading practice Job Costing ?

  • No Delay. Costs incurred determined immediately. It has been done. It should be done.

  • Clarity of direct and indirect costs. Clear determination of cost attributable to a job. These rules should be the same as those used in estimating.

  • Determination. Charges that are determined should be consistently determined. Confusion can arise if rules are not consistently applied, ie who bears the float cost of plant to and from the job. Where a monthly charge is applied, when is is incurred.

  • Accurate measurement. The Work Breakdown Structure is determined to facilitate accurate measurement of work performed.

A Project Manager can only influence what happens next. In order for a job costing system to aid the decision making process it must be timely, accurate and informative. Without such a system, focus is on delivering the required outcome rather than delivering a profit.

Focus on Outcomes specialises in tuning accounting and operational activities to deliver leading practice job costing systems.

Contact us now.

Building better Excel models ...

Excel is one of the most widely used personal productivity tools used in Civil Construction. Excel has been with us since 1987. Excel fulfils a multitude of functions with a construction company from the simple to the extremely complex.

Our focus is on excels use as a modelling tool.

An Excel model has been defined as “a spreadsheet which makes quantitative estimates or forecasts based on a set of assumptions”. Inherent in this definition is that the spreadsheet consists of a inputs, calculations and outputs. More importantly, a simulation model is constructed so that changes to the inputs will derive accurately the required outputs without modification to the logic of the spreadsheet.

Before we can discuss Excel simulation models we need to wrench ourselves away from Excel as a What You See Is What You Get (WYSIWYG) tool. When learning to use Excel we are introduced to the WYSIWYG construct and many never leave it. When you build models within the WYSIWYG construct the formulas becoming much more complex and unwieldy.

So what is the alternative?

Lets breakdown the components of a model within Excel, they are:

  • Inputs, this is quantitative measures that are determined outside your model. What they are is determined by the scope of your model.

  • Reference, these are quantitative measures used within the model that are provided by others. They differ from inputs in that they remain the same when the model is used for different cases, for example, income tax rate schedules, conversion rates from one measure to another,etc.

  • Controls, a specialised form of input, attributes that modify the model to provide insights.

  • Outputs, the results of the model presented (formatted) for the end-users.

  • Calculation, the calculation logic required to arrive at the required outputs.

The extraction of the calculation logic from the other components has a number of advantages.

  1. The calculations can be constructed in the most efficient way possible;

  2. The calculations can be developed and tested in modules, so that you don’t have to wait to the end to test the whole model. And a module can be changed independently of other modules;

  3. Calculations that maybe done more than once can be created as blocks that can be triggered by controls; and

  4. Calculations can be hidden from display so that the logic of the model cannot be disrupted by end users.

The extraction of output from other components means that report formats can be developed for specific purposes without the need to repeat the complex calculations. Where the output of the model is used in other spreadsheets, dedicated formats can be used to simplify the task.

The extraction of controls from other components enables the end user to focus on attributes of the model and their impact on the outputs.

The extraction of the reference items simplifies their update. Often reference items are embedded in the calculations in a model. It can be difficult to identify their use and to test their accuracy.

Extraction of input from other components means that the inputs can be collected using simple cells. There is no need for formulas in the input component of the model.

The use of this construct to produce a model in excel makes the audit of the logic of the model much easier.

Mark has built simulation models for projects in excess of $A 500,000,000 and in excess of 5 years.