Setting up a rate table for overtime (SQL)
Description
Cause
Resolution

Setting up a rate table for overtime

The way to handle overtime in Sage Estimating is to set up a separate rate table. To do this, simply copy an existing rate table and adjust the base rates for each resource to reflect the overtime rates. Then take off the overtime items separately and attach the overtime rate table to those items in the appropriate rate table column of the spreadsheet.

Tips:

  • For benefits that are normally a percentage of the base rate but should not be affected by overtime, be sure to adjust the benefit percentages appropriately.
  • For this to work properly, you need to know what is going to be done during regular hours and what is going to occur outside of regular hours so you can do takeoff separately for regular and overtime items.

Example: Suppose a job includes 1000 square feet of slab, and you think overtime is needed to complete about 200 square feet of that total. You would need to take off the slab item twice as shown below.

Item

Takeoff quantity

Rate table

Slab on Grade

800 sqft

Regular Time

Slab on Grade

200 sqft

Overtime

 

[BCB:164:Chat Estimating US:ECB] 
Steps to duplicate
Related Solutions