Streamline Your Projects with the Plumber Bill Format for R&D

Plumber bill format for R&D

when bidding Plumbing projects you need a spreadsheet that makes it easy and fast to assemble everything required to provide an accurate and consistent estimate the MEP Academy Plumbing estimating spreadsheet allows you to bid small projects to multi-million dollar projects with accuracy and consistency we'll show you how this spreadsheet can save you time and money by providing everything needed to build a successful plumbing company one of the first things to do after notifying all of your subcontractors and vendors is to fill out the estimating spreadsheet by recording all of the plumbing fixtures that need to be labored and quoted here is where the plumbing fixture page of the spreadsheet allows you to list all of the most commonly used plumbing fixtures and their unit of Labor along with three columns to compare vendor pricing all of the most common Plumbing fixtures are already listed along with their Plumbing fixture value that will be used to inform you about the total sales price per fixture and the total material labor cost per fixture parameters that you should use to compare one project against another to determine if the current project is in line with previous similar project the standard of the count from your drawings once you count them you put the count here you put your unit labor value and it gives you your total labor which carries to your summary sheet you put in the cost per fixture and it'll give you the total which will carry forward you can compare the three vendors by putting their pricing in here let's say one was at 300 another was 275 and here was your vendor at 250 you can name these three vendors anything you want and then you had wall hunk water closets they say six of those and say four hours a piece you got 24 hours here's your 300 hundred dollar unit gives you eighteen hundred dollars you can compare pricing by putting them in here and you'll see over here it starts to count your total fixture value which we'll use to calculate the parameters we discussed now we can jump over to the labor sheet and we can see that we have Plumbing field labor and we have plumbing shop labor they're both set up the same you have your categories of General Foreman Foreman journeyman and five years of apprenticeship you can set this up any way you want this is set for like a union contractor you've got straight time time and a half double time you have the base wage and then vacation Health and Welfare union benefits and your base wage with benefits and then all your employer required taxes liability insurance and you get a subtotal and then you can put indirect burden you have a calculator down here that will calculate your different burdens this one over here is for the four men journeyman trucks what's your annual cost your vehicle insurance gas maintenance cost it comes up with a total annual cost and then you put in your total build hours and it'll tell you how much your Burden rate is for that particular category so there's several burdens there's a burden calculation number one which can be for your non-forming non-journament trucks small tools safety training service clothing hats gloves whatever whatever it is that you're trying to recover in indirect burden and that will go on to your labor rate to come up with the total billable rate with burden and then when you're bidding a project you just pick your crew size which is this column here I got one general form and let's say I got one Foreman and you can see the red crew right here is changing it's telling you how many people are in the crew and then let's say I got a one-year apprentice and a five year Apprentice I'm sorry and a one-year apprentice and then I got a four person crew and my crew rate 65.70. now that carries over to the front sheet on your summary sheet and it'll show up here you can see that 65.70 it shows on the summary sheet now we can jump over to the plumbing assemblies you can use any one of these buttons to just jump there quickly and we can see the plumbing assembly sheet is where you normally have all your pipe valves and fittings around a fixture so like a water closet you usually use the almost the same fittings over and over again so this saves you a lot of time if you have it all pre-filled out with the cost per each fitting and item and the labor attached to it and then all you do is ask for how many of those trim items you want if I want two of them it's going to automatically give me the dollar amount and the total labor for two water closets to be trimmed out and you have all types of fixtures in here urinals sinks and you can put all the parts and pieces that you normally use and you can make your own assemblies there's there's blank spaces in here for additional assemblies you click this here to go back to the top you can see we got water closets urinals sinks sap shower tubs and then you can just name any one of these and make whatever you want this just makes estimating fast and quick because these are the typical items that you take off over and over again so there's no reason to be recreating a bill of materials when it's the same bill of materials every time so this will just save you on time and money next we can jump to Plumbing equipment this is just like Plumbing fixtures just put in your plumbing equipment in this case water heaters storage tanks pumps whatever you have lists over here in the description put the quantity of them you have and put how many hours you want to each one and it'll give you a total so in this case 4 times 8 gives you 32 hours and if you require a starting test time there's a category for that these hours carry to the front sheet where it applies to the labor rate and then over here you can list three different vendors and the quotes now the things this spreadsheet will do automatically is select the lowest bidder so if I have three bids and I have one that's lower than the other three it automatically picks it but you can override it if this low guy doesn't have a complete scope you can just override it and pick whatever you want and that'll be the overriding factor what you don't want to do is put a zero in here and it'll give you a red indication because normally it carries whatever the lowest is so if I put 0 there and 1200 here it's going to carry zero because it's looking for the lowest value in these three categories assuming that you owe always want to carry their lowest bidder of your vendors to be the low bidder yourself but you can override that so if you see a red know that that's nothing to do what you want to do is right click and clear the contents and then that won't have any effect on the value now we'll just quickly explain some of the other sheets that support your total bid and that's your subs list all your subs here Plumbing insulation water treatment chlorination miscellaneous excavation and backfill you have some at the bottom here where you can just put whatever you want and then over rentals different rentals scissor lifts welders backhoes you put the quantity of the rental period so over here quantity of scissor list one uh if you're going to rent it for six months put six months and the rental rate it'll give you the total same down here if you have a crane you can put that information in and all this will carry forward to the summary sheet same with General conditions if you're on the site here's your management team project managers how many hours project engineer superintendent quality control whatever you want to list you can change these titles but the hours they're going to be there the duration the hourly rate it'll give you a total and it'll bring all that to your summary sheet in the front same over here this non-recurring cost for your Construction office if you ever have one this is for maybe a construction trailer uh these are non-recurring the recurring one down here will be the construction trailer utilities these are things that reoccur monthly and this over here will be your non-recurring so it's usually a lump sum the cost to mobilize demobilize set up phones whatever and then next we're going to jump over to engineering if you do any design build you can put in your hourly rates for your different design team your CAD designer then over here bid notice you can put you that you're notified which vendors who you talk to are they bidding yes or no and the method by which you sent the documents here's a spec review sheet over here you put the spec section and a description of what you found in the specs this is for a quick reference and then over here there's a risk assessment sheet now this is important if you want to have a different levels of approval in your company to approve going after a bid because bidding projects are expensive so this will rate them design build being the best one and you being the only bidder that's the best scenario the worst scenario is plan infect and multiple GCS your risk is higher because your chance of winning is lower so each one of these will rate it you just put an X as it says here in the category and it'll start to give you points right so you can see design build to owner is only one and if we picked that out we said no it's plan inspect multiple GCS that gives you a 10 points that's a higher risk once you fill all this out general contractor owner engineer liquidated damages and you put that information in there it'll give you a final score and you can change the point values they're over here or whatever you want to point values to be and then at the bottom once again it'll say your total score and then whether it needs approval if it if it runs into a certain range if it gets higher and higher it needs higher and higher levels of approval so to go up to your vice president your president wherever the top is approval person we can jump over to Plumbing summary and this is where all your plumbing labor and Hours come this is where you would put your lineal feet of your domestic water your Saturday waste events storm drain gas piping put the linear feed in here let's say I had 1200 linear feet and let's say it was uh I don't know thirty thousand dollars and I had a hundred hours so let's say 200 hours you can see it's going to measure linear feet per mandate it says you're doing 48 linear feet of mandate which is probably a few up too fast let's say it was 300 hours to get more realistic and you can tell you it'll give you the price of the material per foot it'll give you the price of the labor and material per foot and then over here you can adjust it you say well 32 million feet per mandate is way too fast let's slow that down to 20. it says the difference is 180 hours you need to add 180 hours to the bid you would put that down here it's going to tell you it doesn't match your productivity adjustment which this is over here does not match so if you put the 180 in then it matches it turns green saying what you said that you wanted to adjust the labor to is now equal to what you put in the bid you have to carry this forward because this is just a calculator it doesn't add into the project until you put it down here and then here's where your Specialties carry forward your equipment labor your plumbing assemblies your plumbing fixture of Labor all that carries into here then you add your Material Handling you put it as a percentage it'll give you hours consumables punch list cleanup and then detail it there's a detailing calculator over here that you can use and once again it tells you it doesn't match because you're not matching the percentage if I put the same percentage then it matches 20.7 is what you said you wanted and that's what you get and then down here there's some shop time Shop hours that's your plumbing summary now we can jump over to the main summary and this is where you'll put the project name address so it bids to the delivery method planets back the bid date proposal number if you keep track of your proposals by number you can put the square footage of the building this will be used for parameters that we'll show you on the dashboard and the story in the fixture count you see is coming across automatically from your plumbing fixture sheet and this is where everything totals up you don't normally put much information in here this is just a summary page so all your labor hours are going to carry forward for your plumbing shop your plumbing field Plumbing detailing supervision your plumbing material will carry forward from your plumbing summary sheet any start and test hours you put in we put four hours you can put the rate here and that'll give you your total for start and test any engineering equipment and fixtures will carry forward here you'll get a total equipment and fixture cost your subcontracts your installation chlorination that all lists here it tells you your total subcontracts here's your general conditions your management your non-reoccurring reoccurring costs subsistence and travel Plumbing rentals train rental material and equipment tax permits small tools this stuff you can name on your own and put values in here and then that's going to give you a subtotal and then you can put a contingency you can change the contingency to whatever you want zero if you don't want any contingency and then here's the cost with contingency and then you can put your whatever your typical overhead percentage is and your profit percentage and it automatically calculate those for you and it'll tell you over here what your actual margin is in your margin amount and your actual markup the two being different depending on how you're looking at it and then the total cost per square foot for this project if you like that video please give it a thumbs up and subscribe to our Channel thank you