Collaborate on Plumbing Work Bill Format for Supervision with Ease Using airSlate SignNow

Plumbing work bill format for Supervision

Okay this is how you build labor rates.You go  in here and you pick the different categories   of labor, for instance you can pick, you've  got General Foreman and Foreman, Journeyman,   and then the different levels of  Apprentice, all the way down to Classified.   And you put your own rates in here, and you got  straight time, time and a half, double time,   and then it comes up with a crew rate. So like  here you got a Foreman and you put a Journeyman,   and let's say you put a an Apprentice,   and then that gives you a three-man  crew with a crew rate of $48.33 So you fill in the rates for your own labor  categories, and then you just build your   crew from there. And you got Sheet Metal  Field labor. You got the Shop Labor. You   got HVAC Piping Field Labor, Piping Shop Labor,  Plumbing Field Labor, and Plumbing Shop Labor. Just pick your crew, and it'll  automatically pick your crew rate,   and that'll be shared throughout the whole  spreadsheet once you pick the crew rate. And then you have your General Conditions  tab. In here you'll find your Management Team.   You have Senior Project Manager, Project  Manager, Project Engineer, Construction Manager,   Superintendent, Quality Control, Scheduler, Safety  Manager, Estimator, Administrator Assistant,   Purchasing Agent. You put whatever you want in  here, whatever your normal management crew looks   like, and then you pick the duration of the how  long you're going to be there. You got this little   calculator for duration over here on the side. You  can put how many months they're going to be on a   job ,and then whether it's full-time or part-time,  how many hours per month they're going to work,   that's a full-time basically. There so that  gives you for six months. It's a 1,002 hours.   So let's say your project manager is going to be  there for a 1,002 hours, and then you're going   to put the rate. What's your rate? Let's just  say $125, so it comes up with $125,000 for a   six month period for your Project Manager. So this  is an easy way to calculate your management team.   And then down here, you've got Non-reoccurring  Costs. Your mobilization/demobilization,   whatever it's going to take to mobilize on the  job site, get your office trailer out there,   get your storage bins out there, whatever that  mobilization and then d-mode when the job is over.   And then you have your Recurring Costs.  These are costs that occur monthly   when you have to maintain a a job site out there.  Whether it's the office trailer, utilities,   office supplies, telephones, whatever occurs  every month to maintain a presence out there   on a job site. Then you got Travel and  Subsistence. Basically this is if you're   working outside the area, and you maybe have  to rent a hotel for your project manager,   or you have to pay you guys extra money to  drive farther, pay their food for the day.   And then after that, you got your Rentals  tab. This is where you put all the Rentals   for the project. Here we got scissor lift, crane,  storage containers, dumpsters, forklifts, backhoe,   welders, groovers, boom lifts. You just list  your normal rentals here, and then you can   just store your typical rental rates in here,  so you don't have to fill it out each time.   So you just do the duration. How long are you  going to have that rental out at the job site?   So you would put in the quantity of months  and whatever the rental rate is for that   particular equipment, and then it'll  automatically calculate your total cost.   So, and then how many scissor lifts,  maybe you have two for six months. And then at the bottom here we have the Crane.   This most likely you'll just get a quote from  your crane rental company, but if you want to,   you can budget it on your own. If you have an  idea of what, what size crane you're going to use.   How long does it take for the travel to the site.  They usually charge you for travel time, and then   to mobilize and demobilize, that is to set  up the crane and to take it down. Let's say,   2 hours. And then rigging time. How long  does it take you to actually do the rig?   4 hours maybe. And then the combined rate. What  is the rate? What do they charge per hour for that   40 ton crane or whatever size the crane is going  to be. And then you're going to have permits,   and traffic control. If you're rigging on a public  street, you're going to have to pay for permits,   or you're within an airport zone,  you're going to have to get a permit. A street closure, same thing if  you have to close the street,   you're going to need guys to do traffic control.  They got long boom fee, counterweight fee,   is it's because they got to bring out extra trucks  to bring the counterweights out. Fuel charge,   miscellaneous. Anyways this is another way  to budget crane, otherwise just get a quote.   Then your next tab will be  your Subcontractors tab.   This is where you'll list all the Subcontractors.  In this case HVAC insulation. This just works   just like a lot of the other sheets.You put in  the name of the company that's bidding the job.   Put into a quote amount and the spreadsheet  will automatically pick the low bidder.   And then list any exclusions, like  excludes inserts. And your other bids.   And bid by Steve. You can put the contact name  just for a quick reference. And then, as you can   see it picks the lowest bid, but you can always  override it. Put anything you want in there, and   whatever you put in the plug or quote, the yellow  box there, will be the number actually carried. And then you just go down. You got  Plumbing Insulation, Air and Water Balance,   Controls, Water treatment. Then you got  categories from miscellaneous and other.   The other category is cumulative, so whatever you  put here, it's not going to pick the lowest bid,   it's just going to add all these up These  are not comparative, these are just extra   subcontractors that you need to add in, so  whatever you put here will add into the total.   And then your next sheet you'll deal with is your  HVAC Equipment. So, basically you're going to go   to the equipment sheet on your drawings,  and you're just going to start filling out   all the, taking off all that equipment, and  filling it out here. Because on here is where   you're going to put the comparative price between  vendors, and where you're going to put the labor.   The unit of labor it takes to each one of  these pieces of equipment, including the start and   test time, and the balance time. So, here you just  list the size of it. This will help you labor it,   when you come back, maybe in labor, you can  labor it now, you can labor it later. But you   got 5 tons, you got five of them. Let's say it  takes 4 hours of Sheet Metal, 4 hours of Pipe.   So you got 40 hours. So, I didn't show  there, but you would also put start and test,   in that, in there too. So, right here you got your  vendors. So, let's say you got ABC vendor, and   he bids $12,500, and you get another quote from  another vendor, and he bids $13,000. You can see   the spreadsheet has picked a low bid, $12,500  between the two. It'll always pick the low, but   once again you can override it.Let's say you got a  third vendor, let's just call it vendor number 3,   and we'll put him in at $12,002, which would make  him low. And as you can see the spreadsheet picked   the low bidder, but once again you can overwrite  it with anything you want, just type it into to   plug or quote yellow box there, and that  will be the number that will be carried   If you don't want to carry the low. Now  a great feature with this spreadsheet   is that it'll calculate parameters for  every one of these quotes that you put in.   You put in the tons you got, 25 tons. It's telling  you you're paying $520 bucks a ton, and then CFM   you're gonna have 10,000 CFM. So you could pay a  $1.30 a CFM based on the number you're carrying,   and then there's five units, so it's $2,600 per  air conditioner. It's just a nice quick parameter   to check your historical data. Is this what we've  paid in the past? Does this look like a fair   number? And if it doesn't, then you can adjust  your plug number or your quote number over there,   take a buyout by putting a  lower number than what was bid.   And basically you just keep going down. You  just keep filling them out, and just keep   filling out those sheets. The next one you'll  get is the Sheet Metal Specialties. Now this is   all the stuff that isn't yourSheet Metal Duct work  and fittings. These are all the specialty items,   duct smoke detector, secondary drain pans,  duct pressure testing, remote damper operators,   roof duct supports, duct id, seismic supports,  cleaning duct and fittings, access panels,   supplemental steel. You just fill all that out.  What you got up here, is you got Sheet Metal Shop   Fabrication. So, you can put material, labor, for  your shop, for each one of these, or you can put   Field Material and Labor, or you could put both  of it applies, like on smoke duct detectors. Here,   let's say it's $125 bucks a piece, and  let's say an 1-1/2 hours to , and you got 5 of them. So,  it'll automatically calculate   and carry that forward on your estimate. So  you just go down and you fill these out.Let's   say, secondary drain pans. Let's say you got 10 of  those, and you're going to make them in the shop.   Let's say it's $75 worth of material, and it's  going to spend an 1-1/2 hours each making them.   And, but in the field you're going to have to  hang it also, so you need some time in the field.   Let's say it's an hour. So you got some shop  material, shop hours, field material, field hours,   all that's going to get carried forward onto your   sheet metal summary sheet. So you fill these out  for the most common things you use. So as you see   that sheet metal specialties. That  came forward. There it is right there,   $625 dollars of material, 17.5 labor  hours, this is for the field portion of it,   you have the Shop below, which we'll show in  a minute. So, your first category here will be   your rectangular duct and fittings. You can put  in linear feet. The more information you put in,   the more you'll get parameters which we'll show  you on the right of the spreadsheet here. So you   got a 100 lineal feet, you put that in, you put  in the amount of hours. This is either coming from   your estimating program or your manual takeoff. if  you've got an Estimating program, great, it works   good, we'll put the pounds in here. So, we can  look at our parameters. What the parameters are.   So if you look over here, it's saying we're doing  20 linear feet per man day. So, you got to get   used to looking at linear feet a man day, or a  linear feet an hour, whichever. I like linear feet   per man day. And if you want to make an adjustment  you can make it here. You say that's too fast,   or too slow, you can slow it down or speed it up.  Here we're going to slow it down. We'll say it's   too fast. That shows that we have a difference of  three point 13.3 hours, that this doesn't carry,   so you got to carry this manually. So you add  it right here to the productivity adjustment.   So, you put the 13.3 hours there, that makes  your adjustment, that slows down your duct.   And then all that like I  say is on the Summary Sheet.   This is your Summary Sheet. So, on that, also  below here, now we've got material handling,   consumables, your punch list, and your  clean up. These are all percentages.   So material handling is what it takes to get all  the material from the truck when it delivered   to the floor where it's going to be installed.  And so eventually you should learn what these   numbers are for your company. Material handling  is usually pretty significant number. Consumables,   that can be like whatever, your corner  pieces, your gasket, your screws,   duct tape, whatever you want your consumables are,  Punch list, that's finishing out the job. There's   always extra time for that, and then clean up.  Cleaning up the job. Some projects make you do   it daily, some weekly, but you'll have clean  up time that's not part of the productivity,   of actually hanging duct. Detailing. We  have a nice Detailing calculator over here.   It's got, you know, items that you're going  to incur to do detailing. So, one is to become   familiar with the project drawing, the floor and  roof plans, doing details and equipment pads,   and wall and floor openings, as well drawings,  field detailing sheets, coordination. So you put   how many hours you guys normally get, takes  to do each one of these. I put some hours   in there. You put it ing to whatever your  project, or whatever your normal project takes.   So, and then that'll calculate a percentage,  and you can carry that percentage over here.   Supervision also is a certain percentage, and  that's a percentage of your labor totals. And   then down below here we have the Sheet Metal  Shop. So, if you have your own fabrication shop,   great, you can put the values in here and you  can check the parameters. Make sure it matches   the parameters of your shop productivity. So, once  again let's say we have 100 feet, we're producing   it in a shop, we have $800 worth of materials. So,  if you look over here on the metric you can see   it's $0.80 cents a pound for just the material,  it's a $1.91 per pound for labor and material,   and it's producing at almost 50 pounds  an hour. So, you would see if that's   ing to what your shop normally does and  make an adjustment if you need to right down here,   productivity adjustment so that, so it matches  your shop productivity. If you're buying all your   material then you won't worry about this, this  is for those who have their own sheet metal shop. And you can put them separately, I like to do  round separate from rectangular which makes a   lot of sense. So maybe even if you're buying your  material you can get some values, at least you can   get the pounds from your fabrication shop, so  you can use that as a parameter. Next you got   your HVAC Piping Specialties. So, similar to the  sheet metal, you just list all your sheet metal   specialty items, you got the shop and the field.  So, you once again, you got material and labor,   and you list all the items that you normally  have for HVAC piping specialties. This is not   your pipe, valves, and fittings, those come from  your estimating takeoff, and then once again,   you're going to have a summary sheet for the  HVAC Piping like you did for the sheet metal,   and you can do the same thing as you would do  for sheet metal duct. You can do that for your   pipe. So you can check on the parameters.  You would put in how many linear feet of,   keep your copper, keep your material separate. So,  here we got copper, let's say we have a 1,000 feet   and $8,400 dollars in material. We got 270 hours.  All this came out of your estimating program or   from your manual takeoff. Over here, you can  check, you can see you got $8.40 for material,   per linear foot, labor material is $60 a foot,  and your productivity is 30 feet of man day. So,   once again, you can adjust this. You could  say, is that too fast, is that too slow.   And then you would make an adjustment  here. Well let's say it's too fast,   so we're going to slow it down a little bit. So,  it's going to, say we need to add 50 hours. So, we   would have to come over here to the productivity  adjustment line item, and add those 50 hours,   and that would get us to where we need to be.  And then once again you've got material handling,   consumables, punch list, cleanup, they're  all percentages of the total labor value.   Detailing once again, and supervision, and  the detailing calculator, just like the   sheet metal calculators, the same thing  it helps you come up with a percentage. And then Plumbing Specialties, same thing you had  Sheet Metal Specialties, HVAC Piping Specialties,   now you have Plumbing Specialties. So, once again  down the left side here is all the specialty   items that are not your normal pipe, valves,  and fittings, that you find in your takeoff.   And again, you have shop fabrication, and  you have field and on the right. I forgot   to mention this is where you can list where this  item is found, whether in spec, or on the drawing.   Now you have Plumbing Fixtures. You have a  separate tab for that. So, this is where you list   all your fixtures. I have the typical ones listed  here, and so you can list whatever you want, you   can rearrange this and list whatever your typical  fittings are. You got roof drains, you got a bunch   more fixtures below. You'll put the quantity  of fixtures, and you'll put the unit of labor   to set that fixture. And then you'll have three  columns to compare three different vendors   on their bids. So let's say one's at $215,  one's $225, one's $230. Off the right there,   you can't see, but you got three bids, and then  you'll pick the lowest one, and you'll carry that   in your fixture cost here. You'll write it  in here, and then that'll be what's carried   in your estimate. So it gives you three columns  to compare three different vendors, and then over   here you have fixture value. So, this will help  you on your parameters, to tell you how much per   fixture it costs to or purchase. So we  have the major fixtures at one, a value of one,   and drain is at a half value. Then you have your  Plumbing Equipment, just like you had your HVAC   equipment. This will keep the two trades separate,  so the plumbing sheet is, equipment sheet is   the same as the HVAC. You go to your plumbing  equipment drawing and you start taking off all   the plumbing equipment listed there. Listed here  in this case we've got a hot water storage tank,   and it's storage tank 1 through 4, and then what  you want to list here is the capacity, the size,   so it gives you an idea when you go to labor it,  how labor intensive it should be. There's a big   difference with a 10 gallon tank and a 400  gallon tank, and so you put the quantity up   there. So it multiplies the labor correctly.  And you say well it takes 8 hours each,   so you got 4 of them. 4 times 8 is 32 hours.  Then once again you list your vendors.   Each vendor and his bid amount, remembering  that it will always carry the low bid, and you can definitely overwrite that, as you see here, carry the low bid of  $28,900. But like I said on all of these,   you can pick whatever number you want and it'll  override the system's picking of the lowest price.   So maybe the guy doesn't have  everything in the specifications   over here. Again, you have the quick  parameter check. There's 4 of them,   so basically you're paying $7,500 bucks  for these large hot water storage tanks,   and you have other parameters. If you had  horsepower, or MBH, you could see how much it   cost per horsepower, or how much it cost per MBH,  or whatever category you can use. You can use the   other there to measure whatever parametric  you want to measure. So, each one of these,   there's a long list here, for you can put as much  equipment as you want and then everything rolls   over into your Plumbing Material Labor Summary  Sheet. It carries over your equipment, you can   see the specialties came over, the equipment  labor came over, and the plumbing fixture   labor came over. There's the three items  that are automatically carried from those   three separate sheets, they carry to the summary  sheet. Now, this is where you'll enter your pipe   takeoff from either your estimating  software program or your manual takeoff. So, just like the sheet metal or the piping,  you list how many linear feet that you had   for each one of these categories. This is domestic  water, so you had 1.800 feet, $34,000 in material,   and then you had 1,450 hours. So, you can check  right away on your parameters. There you see   $18.89 per foot for the material cost, and $71.25  per lineal foot for labor and material, and you   got a productivity of 9.9 linear feet of man day,  basically 10 feet per man day. And if you want   to make an adjustment, you think it's too slow,  then you can speed it up, and it tells you now,   you need to a negative 490. You need to deduct  490 feet, so you minus 400, not feet, hours.   You minus 490 hours because you're speeding it up.  The estimating program, or your original hours was   too slow, so you're taking hours out of the job.  And once again just like the HVAC sheet metal and   piping material labor summary, you've got material  handling, consumables, punch list, cleanup,   detailing, and supervision. And below on all the  sheets you have a shop tab. If you do prefab in   the shop, which is a great idea because it saves  labor, but you have to have the facility to do it.   Now all of this is going to roll over to your Main  Summary Sheet. So all that information, all those   sheets, now roll into this Main Estimate Summary  Sheet. So, this is where you got your project   name at the top, the address, the customer, the  delivery type, plan and spec. And then you start   looking at, you can look at, there's really  nothing to do here, because everything's   rolling forward. This is all information coming  from sheets that you've already filled out,   the only thing you fill out here is the hourly  rate for your detailer and your supervision,   but everything else is already done. The labor  rates for the shop and the field are done,   was done on your crew labor sheet. And then you  put the size of the building, you put your CFM,   and it gives you CFM per square foot, CFM per ton.  How many tons. It tells you how many square foot   per ton, and how many dollars per ton. MBH, 400.  It tells you, I'm going to, BTU per square foot.   Now these are good for when you do budgets, this  will give you information for budgets. So there's   your quantity of fixture value, so you have 12. So  it tells you material cost per fixture was $3,226,   and material ,field labor cost, is $9,098,  now that doesn't include equipment,   so that's just a just a rough parameter. So, that  you can start getting familiar with those values   now, as you go down, you've got your Air and  Water Balance, that's if you're self-performing,   your engineering, and there's your equipment  in fixtures, it rolled forward here. There's   nothing for you to do here, this is coming from  your other sheets. And then your Sub Contracts,   all that also comes from your subcontract sheet,  but this brings it all to the front page so you   can see everything in one place. And your General  Conditions, the top section there in yellow   is coming from your general condition sheet, so  you can see we didn't fill out much on there,   so the only thing we have is material and  equipment tax, that's where your tax is going   to show up, but you got permits, you got whatever  down here, these empty spots here where you can   put additional general conditions in. It gives you  a subtotal, and then you can add a Contingency,   and then cost with contingency, and then you  use your margin. So what margin do you want to   make on the project? So, if I went to 25, you can  see the value increases, sales price increases,   you can see the markup's 33 percent. So, the  markup is a function of the margin. So if you   change the margin back to 20 you can see the  markups 25. So, you should understand how that   relationship works. And then there's just a little  chart in here, it just shows you comparatively   the sheet metal versus the piping, plumbing, the  air and water, the engineering, the equipment,   the subs, and the GC's. Gives you an idea of  where the total cost is going for the project. So that's it. It summarizes everything on this  last page, and this is everything you need,   a small job or a large project, from  thousand dollars to millions of dollars. Okay, so Subscribe to our  channel if you'd like to receive   additional videos for Mechanical, Electrical,  Plumbing Engineering or Contracting.