The way to handle overtime in Sage Estimating (SQL) 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 here:
Item Takeoff quantity Rate table Slab on Grade
800 sqft
Regular Time
Slab on Grade
200 sqft
Overtime