Print Page   |   Contact Us   |   Sign In   |   Register
News & Press: 2017 News Items

Get your Excel-based Cash Flow Simulator now

Thursday, 19 October 2017  
Posted by: Bert vd Heever
Share |

Get your Excel-based Cash Flow Simulator now

Enhance your cost-reporting with our new cash flow simulator. It compares the current expenditure on a project with theoretical expenditure based on a standard s-curve.

It was designed by Mr Ian van Zyl, winner of our competition to find someone who could do magic with Excel.

We believe that the 2017 cash flow simulator will find wide use on government- and other projects as a simple tool that graphically indicates actual- against projected cash flows and also uses linear regression analysis to predicts the actual completion date based on current progress.

Max Wideman defines an s-curve as: "...a display of cumulative costs, labour hours or other quantities plotted against time. The name derives from the S-like shape of the curve, flatter at the beginning and end and steeper in the middle, which is typical of most projects. The beginning represents a slow, deliberate but accelerating start, while the end represents a deceleration as the work runs out."

Why use an s-curve? It's an important project management tool that allows the progress of a project to be tracked visually over time. To find out more uses of the s-curve watch the video on this page. By watching the video you will also learn about more sophisticated uses of the s-curve such as "banana" curves based on the early- and late dates of the schedule and how this is used to keep tabs on project progress.

The new Cash Flow Simulator 2017 edition is a basic tool which is especially useful in circumstances where the contractor cannot produce a proper schedule indicating the critical path of the project. It is available from the Sundries section of the Members Only CUG. Members can use it freely and firms are allowed to co-brand it by inserting their logo's along with that of the ASAQS on the simulation page.

Please note that the simulator may not function as intended on older versions of Excel. The Excel workbook was zipped in order to load the .xlsm file into the file library and members will have to unzip the file before use. We also strongly recommend that you read the instructions before inputting your own data into the simulator.

We look forward to hearing from you after using the simulator and will be guided by your suggestions in future enhancements and improvements to the simulator.