Rich
02-27-2004, 10:15 PM
I've put together an estimate sheet that some people may find useful. It's more geared towards a GC estimate - but the principles and formula are the same for any industry. Delete rows or whatever to make it fit with your specific trade. The formulas can remain or change as you like.
I probably need to explain a few things. The grey columns at the top are the ones that you should modify - the rest are calculated. The Item Code and Description can also be changed - they are arbitrary and specific to the current job I am working on. After putting in all the information you can hide columns G through N and use it as a billing tool. To use it for billing all you need to do is enter in the TTD for the first month for each line item. The following month you will copy column S and Paste > Special > Values only into column T. This essentially zeroes out the month for the next months billing cycle. Then update the TTD column again and you're on your way.
You can also use this for a job purchase schedule or buyout schedule. After doing takeoffs and giving your best guesstimate - the sheet will give you an updated total column (Column P) - then when receiving actual bids from subcontractors you can update the Buyout / Budget (Column Q) and it will show you buyout savings or additional money that goes to profit.
One other peculiarity when using it as a billing tool - it can be used one of 2 ways. You can bill with labor and material for each line item (since it's already included there) or just update the Labor TTD on the bottom line. I do method 2 because I have a seperate cost control for labor only and it's easier for me.
Let me know if you have any questions.. there are a couple examples at the top.
I probably need to explain a few things. The grey columns at the top are the ones that you should modify - the rest are calculated. The Item Code and Description can also be changed - they are arbitrary and specific to the current job I am working on. After putting in all the information you can hide columns G through N and use it as a billing tool. To use it for billing all you need to do is enter in the TTD for the first month for each line item. The following month you will copy column S and Paste > Special > Values only into column T. This essentially zeroes out the month for the next months billing cycle. Then update the TTD column again and you're on your way.
You can also use this for a job purchase schedule or buyout schedule. After doing takeoffs and giving your best guesstimate - the sheet will give you an updated total column (Column P) - then when receiving actual bids from subcontractors you can update the Buyout / Budget (Column Q) and it will show you buyout savings or additional money that goes to profit.
One other peculiarity when using it as a billing tool - it can be used one of 2 ways. You can bill with labor and material for each line item (since it's already included there) or just update the Labor TTD on the bottom line. I do method 2 because I have a seperate cost control for labor only and it's easier for me.
Let me know if you have any questions.. there are a couple examples at the top.