Truck drivers have the option of working 70 hours in 8 days or 60 hours in 7 days. The recap is the review of all of the on duty hours that have been worked inside of the last 7 or 8 days depending on your company's cycle settings. A recap table is a good way to keep track of how many hours a driver has been on duty to make sure they remain compliant with the FMCSA regulation. A driver is allowed to work as many hours as they want, however, if they have worked more than the required hours inside of their 7 or 8 day window they cannot drive until their hours drop off later in the week or they do a 34 hour reset.
Drivers Hours Calculator Excel
If you're like me and want to finish work, go home like any other normal person and not have to spend inordinate amounts of unpaid time recording and calculating drivers hours, the WTD, last weeks driving and working hours, paybacks and other details that you need to track to comply with legislation, the My Driving Hours Driver Calculator is a real benefit. I also found that with the increasing amount of legislation that has come our way; I needed to try to simplify the process, so I did.
Many people, especially freelancers, enjoy the autonomy of controlling how they record their hours. For individuals or smaller teams, excel spreadsheets are a fantastic option for figuring it out. You can design the sheets to use the formulas mentioned and personalize them to your needs.
The relevant data are presented in Table 3. While the table first presents the Cook at al. 2018 data on numbers of drivers and weekly fares, our analysis essentially starts with what passengers are paying the drivers. Note that the hours-weighted gross fare per hour (Row 6 in Table 2 and Row 11 in Table 3) does not reflect what riders provide in fares because it excludes the booking fee they pay for each trip. So we need to add the booking fees charged per hour to the fares generated per hour from Table 2 to obtain the total amount riders pay Uber per hour; the booking fees per hour are derived in Rows 7 through 10.
To derive booking fees per hour, we pull data from Cook et al. 2018 (Table 1) on the number of trips each week (29.83) and the hours worked each week (17.06), and we enter these figures in Rows 5 and 6 in Table 3. Given this, we know that drivers average 1.75 trips per hour (Row 9 in our Table 3). To compute booking fees per hour, we multiply the 1.75 trips per hour by an Uber booking fee of $1.55 per trip,14 which means that Uber earns $2.71 in booking fees for every hour worked by a driver.
If you don't want to record clock in and clock out times, check out our other free Excel Timesheet and Time Card templates. The free timesheet calculators on this page all involve entering the time in and time out to calculate total hours worked. 2ff7e9595c
Commentaires