Tuesday, October 20, 2009

BIM Projection Spreadsheet

So I've been a little further behind than I anticipated...anyways to expand on what we were discussing earlier, I have been digging a little deeper lately into more of the project management end of what it means to be a BIM Manager.

To that end I have posted here a spreadsheet in Google Docs that shows how we are linking our weekly time sheets to our monthly projections / expenses. While some of it looks like it got lost in the translation, I think you'll get the general concept.

Probably one of the biggest hurdles we've had in our current implementation is billing against project budgets that are slim to nonexistent. The course of action I've taken to resolve it, is to get involved earlier in the process of estimating/bidding or establishing the GMP on negotiated work to make sure that we have a justifiable and accurate budget in the job so we aren't making PM's unhappy campers.

Currently we are using this type of spreadsheet (though in Oracle) to track our cost histories for each phase of a project to validate future BIM enabled construction projects. While I know a number of companies bill their BIM Department to General Ledger, I've found you still need to know just how much a certain size of project will cost in the overall project framework which ultimately affects that bottom line.

I've made it a point to start discussing with the PM's at the beginning of each month exactly how many total hours we anticipate billing towards their projects. Although at first some of them love to kick and scream a little bit after a while they really appreciate the communication and more importantly the value add to their job.

Some more posts coming soon!

1 comment:

Boyd Johnson said...

Responding to an almost 5 year old post. (BIM Projection Spreadsheet). I appreciate your effort and would like to hear more or know if you developed your spreadsheet to a greater level of detail. Thanks for the post and the spreadsheet.