Post

2 followers Follow
1
Avatar

Creating a Statement of Work

I rehab houses. I have a master list of work items that I do to houses. I use the master list to build a unique list for each house I work on. I'm trying to find a way to implement this in Podio.

For example let's say my master list includes:

remove old flooring
install laminate flooring
install carpet
install tile
remove/install new kitchen cabinets
remove/install kitchen countertops
paint interior walls
paint interior trim

and on my Main st. project I want to do:
remove old flooring
install laminate flooring
remove/install kitchen countertops

On my Elm st project I only want to do:
paint interior trim

In my current spreadsheet system, each one of these is a row in the sheet. Each row contains columns for task description, unit, labor cost, material cost, # units, total cost, estimated time to complete, etc.

e.g.
The following entries are in the master list (along with all of the others)
task unit labor cost Material # Units total cost ETC
install laminate flooring per sq ft $1.50 $2.00 1 day
remove/install kitchen countertops per ln ft $18 1 day

I then copy just the items to the Main St list that will be done on that project and add the # units amounts for that particular house.
So, the Main St list would include:
task unit labor cost Material # Units total cost ETC
install laminate flooring per sq ft $1.50 $2.00 120 420 1 day
remove/install kitchen countertops per ln ft $18 15 270 1 day

Is there an efficient way to implement this with Podio? If there is then I could use some of the cost totals (and maybe schedule) in other related apps.

Bob Yon

Please sign in to leave a comment.