New Spreadsheet For Cabinetry/woodwork Bidding - Finish Carpentry - Contractor Talk

New Spreadsheet For Cabinetry/woodwork Bidding

 
Thread Tools Search this Thread Display Modes
Old 12-18-2012, 06:32 PM   #1
Member
 
Jason Abbott's Avatar
 
Trade: General Contractor/Cabinet Maker
Join Date: Feb 2011
Location: Napa, CA
Posts: 65
Rewards Points: 87

New Spreadsheet For Cabinetry/woodwork Bidding


I decided to overhaul my bidding process and spreadsheet for cabinetry and woodworking projects. I created a new spreadsheet that works off the total of number of parts. I have inputs for standard parts, specialty operations, parts that need special jigs, oversized parts, etc. I have assigned a number of minutes of labor to each of these part types, which I can change easily. It also has inputs for delivery, scribes, and installation. The sheet adds up the minutes, divides it out to labor hours, adds in my company overhead on a per hour basis, allows for changing the number of staff working on the project (which affects the total number of project overhead hours), allows for on-the-fly profit margin changes, allows me to input material costs, and spits out a nice number for me to bid with. All I have to do is count parts, boxes, and materials costs and put them in. The thinking behind this is that we are often called upon to make stuff that is not standard and is often not even cabinet related. But everything we build is made up of parts. So now I just count them. The best part is that I have a lot of jobs that I can go back and count the parts for and compare the labor hours we spent in order to get semi-accurate per part minute counts. Does anybody else out there count parts and bid this way? I just put a rough bid together for three large walk-in closets worth of face frame cabinetry, with drawer banks, cabinet doors, and matching molding and it took me about 15 minutes to count the parts-468 total. Since no system is perfect I am sure this one is not, but I am happy so far. I would share the spread sheet but it has all my numbers in it. Anyone with any experience using Excel could easily come up with something similar. Any thoughts?
Jason Abbott is offline  

Warning: The topics covered on this site include activities in which there exists the potential for serious injury or death. ContractorTalk.com DOES NOT guarantee the accuracy or completeness of any information contained on this site. Always use proper safety precaution and reference reliable outside sources before attempting any construction or remodeling task!

   

Advertisement

 

Old 12-18-2012, 06:51 PM   #2
Pro
 
hdavis's Avatar
 
Trade: remodeling
Join Date: Feb 2012
Location: CoastalME
Posts: 23,367
Rewards Points: 2,900

Re: New Spreadsheet For Cabinetry/woodwork Bidding


It seems pretty reasonable, I'd be interested in how it turns out. Sine you have your historical data, it should give you a good calibration and you can see where it may be off. I'm all for it, good idea!

Advertisement

hdavis is offline  
Old 12-18-2012, 09:07 PM   #3
Pro
 
Texas Wax's Avatar
 
Trade: Executor of special operations
Join Date: Jan 2012
Location: DFW
Posts: 3,868
Rewards Points: 1,662

Re: New Spreadsheet For Cabinetry/woodwork Bidding


Created and used one for P-Lam cabs. Simply do a count of similar cabinets. Enter width height depth, number of doors hinges per door, number of shelves... calculates edge band, sheet goods sqft & relative sheets the whole nut.
Basically has three types of cabs - Base/upper, drawer Base, all drawer base. Can enter for tops bottoms sides laminated and it'll calculate all hardware ect... creates line item sub total counts that get multiplied by cost added up and stuck into a proforma P/L per job.
Really has some very complex formulas and mind bend to get set up...but it works and is very accurate.

Tip my hat to y'all, spread sheets can be powerful tools.
Texas Wax is offline  


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Made in USA product list J.C. General Discussion 378 04-23-2019 05:16 AM
Im bidding for a commercial painting job. any advice? BaranG Painting & Finish Work 13 02-25-2014 01:54 AM
Common Rafter Length - SpreadSheet Texas Wax Framing 11 12-25-2012 01:01 AM
Commercial Construction Spreadsheet Help?? SBI Commercial Construction 16 12-17-2010 11:17 AM
Cost Based Bidding Vs Spreadsheet sitegrader Excavation & Site Work 1 02-04-2009 10:44 PM

Join Now... It's Fast and FREE!

I am a professional contractor
I am a DIY Homeowner
Drywall Talk is for
PROFESSIONAL CONTRACTORS ONLY!

At DrywallTalk.com we cater exlusivly to professional contractors who make their living as a contractor. Knowing that many homeowners and DIYers are looking for a community to call home, we've created www.DIYChatroom.com DIY Chatroom is full of helpful advices and perfect for DIY homeowners.

Redirecing in 10 seconds
No Thanks
terms of service

Already Have an Account?