Why use an S-Curve
S-Curves are very important project management tool; they allow the progress of a project to be tracked visually over time and form a historical record of what has happened to date. Analysis of S-Curves allow project managers to quickly identify project growth or accomplishment, slippage or delays, and potential problems that could adversely impact the project if no remedial action is taken.
S-Curves can be based on days-duration, man-hrs, or costs expended over time for the duration of the project.
S-Curve in construction project management industry is a display of cummulative costs, manhours or other quantities plotted against time. The name derives from the S- like shape of the curve, flatter at the beginning and at 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.
How to Make an S-Curve
First make a schedule of your project using the MS Project Software. In tutorial we use just simple project data with few activities, important thing is you will learn the idea how to make an s-curve for monitoring of a construction project.
Copy the the start and finish dates of the activities from MS-Project and paste in MS-Excel. Now we have to distribute the required progress for each date in excel. For example, the each weekly progress from 0 in first week to 100% on the activity’s completion date.
See the following video for further demonstration on how to make an S-Curve.