Setting up a rate table for overtime

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