IntelliBid User Tip: Using IntelliBid to Determine Crew Size

IntelliBid does more than just estimating. It also includes project management functions to help plan the project. One of these functions determines optimum crew size using IntelliBid’s Standard or Short bid template.

  1. Do a quick takeoff of any one item, for example, EMT. In the Audit Trail, change the labor result column to 2000 hours (ignore the Labor Factor for this example).
    Do a quick takeoff of any one item, for example, EMT. In the Audit Trail, change the labor result column to 2000 hours (ignore the Labor Factor for this example)
  2. Go to Bid Recap. If your default template is not the Short or Standard template, create a new bid now using either a Short or Standard template.
  3. Go to the Direct Labor tab. Set the crew to 4 Journeymen and 4 Apprentices for both Regular time and Overtime. This does not affect the cost of the job or your bid since the ratio of Journeymen to Apprentices remains the same.

  4. Go to the Labor Adj tab. Under the Adjusted Labor heading, double-click the Loss Labor Calculator cell for Electrical Labor (Row 32 – Column B).
  5. Click the drop-down arrow for Start Date and select Monday, Feb 20th.
  6. Click the drop-down arrow for Finish Date and select Friday, March 17h for a 4-week project. The Job Duration of 26 calendar days includes weekends.
  7. Click the Calculate button. A message tells you the project cannot be completed in the specified time with the current crew size. IntelliBid has calculated that the current crew would have to work more than 12 hours a day to complete the job with this schedule. Industry studies have shown productivity virtually ceases after 12 hours, so IntelliBid uses this standard.
    A message tells you the project cannot be completed in the specified time with the current crew size
  8. Click the drop-down arrow for the Finish Date once again and change the date to the following Friday, March 24th for a 5-week schedule.
    Click the drop-down arrow for the Finish Date once again and change the date to the following Friday, March 24th for a 5-week schedule
  9. Click the Calculate button again. This calculation is accepted and shows there are 1600 straight time hours and 400 overtime hours. The calculator also shows 160 hours in productivity loss. As we discussed in Tip #45: when the crew starts working more than 8 hours a day, their productivity goes down.
  10. Click the Accept Adjustment radio button and click OK.
  11. Now let’s solve the loss of productivity situation. Go to the Direct Labor tab. The hours for both Straight Time and Overtime have been adjusted. Notice the column labeled Optimum Crew next to the Crew column. IntelliBid calculates the required crew for the dates scheduled and the number of hours to complete the job without adding overtime hours; in this example, 5 for both Journeymen and Apprentices. Change the crew size to 5 for each of these and the overtime will disappear. With this change, you will notice a decrease in the bid total.
    With this change, you will notice a decrease in the bid total

Back to IntelliBid Tips Archive