Hello Ryan
I start with a table of standard distributions of progress over varying durations from 3 to 24 months (based on historical data). I then take the primary accounts from the conceptual estimate, apply starts and stops relative to 100% of total construction duration, and then spread the hours for each Prime Account as per the distributions in the table. Sum up the prime accounts, plot the total distribution and there you have it - a quick and dirty BCWS. (This is all done in Excel.)
Why would I do this? From the total distribution of hours I can extrapolate a rough staffing curve. We use this for early manpower shortfall analysis against available manpower in the construction location. This can be applied quickly, while setting up a full blown network schedule and resource loading is a significant effort and requires info usually not available at this point.
I know that establishing preliminary BCWS can be done through quadratic equations-anyone doing it this? I'm curious to know how others are establishing preliminary BCWS (especially when it's early and only conceptual estimates are available) and what kind of software you might be using to facilitate the process. Would love to hear from you.
Thanks
David