27-12-TAP Attachment B - Service Operation.xlsx

XLSX spreadsheet 14 KB Posted

Attached to
On Demand Rideshare Service
Solicitation number
BD-27-1165-COSPD-COS01-132484
Issued by
Essex County, Massachusetts

About this file

This is a service operation report for the Massachusetts Transportation Access Program (TAP) on-demand rideshare service, covering the contract period from August 1, 2025, through July 31, 2026. The report provides comprehensive operational metrics for the rideshare service serving Salem, Massachusetts, filtered by service requests with at least one wheelchair-accessible vehicle (WAV) seat requirement. The data encompasses driver hours, vehicle utilization rates, booking patterns, demand fulfillment, and ride request statuses across the 12-month period.

The report demonstrates significant operational activity, with net driver hours ranging from approximately 1,834 to 3,615 hours monthly, representing substantial service delivery capacity. Vehicle utilization metrics averaged between 4.12 and 4.46 revenue-generating hours per vehicle across the contract year, while productivity ranged from 4.65 to 5.04 completed rides per vehicle hour. Demand patterns show approximately 17,290 to 24,172 total demand pairs for Salem throughout the period, with on-demand bookings consistently representing the dominant booking type (ranging from 12,688 to 24,162 requests monthly) compared to pre-bookings. Service completion rates averaged approximately 78 to 88 percent of demand, with seat unavailability accounting for the majority of unmet requests (1,349 to 3,862 instances monthly), indicating capacity constraints during peak demand periods. The operational data reflects the service's role in providing accessible transportation to eligible TAP participants while identifying ongoing challenges in meeting full demand during high-utilization months.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

1.Report Filters

Filter NameValue
Start Date2025-08-01
End Date2026-07-31
Periods byMonths
Hour Range
Weekdays
Booking Type
Service (Request)
Vendor Name
Booking requires >=1 WAV seat
Service (Shift)
Request Origin ZoneSalem Reporting
Request Destination ZoneSalem Reporting
Origin->Destination Zones
Request Status
Cancellation Initiator

2.Driver Hours

TIMENet Driver HoursBreak Hours
2025-083080.40245719.226428
2025-092843.95467818.657547
2025-103615.08940123.526708
2025-112769.87220413.264755
2025-122508.0624527.112817
2026-012602.13773716.379772
2026-022383.29687610.257846
2026-032831.55075313.909521
2026-042839.32770115.502845
2026-052716.83326916.112562
2026-062507.30521913.293951
2026-071834.23189215.401993

3.Utilization

TIMEUtilization
2025-084.167637
2025-094.455064
2025-104.269881
2025-114.377458
2025-124.446859
2026-014.368716
2026-024.279786
2026-034.184633
2026-044.20029
2026-054.231397
2026-064.124747
2026-074.255732

4.Vehicle Hours by Shift Segme

TIMERevenue HoursDeadhead Hours
2025-082717.608888889362.816336667
2025-092521.792777778322.161944444
2025-103177.290555555437.798888889
2025-112428.728055555341.144166667
2025-122213.39294.6725
2026-012317.620833333284.516944444
2026-022127.1725256.124444444
2026-032497.195555556334.355277778
2026-042503.539444444335.788333333
2026-052394.133333333322.699807778
2026-062223.441388889283.863888889
2026-071613.026944444221.205

5.Productivity

TIMEProductivity
2025-084.724005744
2025-095.02420346
2025-104.858227389
2025-114.992325086
2025-125.038877017
2026-014.905030122
2026-024.795097718
2026-034.744922749
2026-044.763655722
2026-054.801737581
2026-064.651348154
2026-074.839348795

6.Booking Type

TIMEPrebookingOn Demand
2025-082617264
2025-092320976
2025-101024162
2025-112418596
2025-12717455
2026-01917919
2026-02816854
2026-03218243
2026-04617095
2026-051516862
2026-061615542
2026-07512688

7.Met Demand

TIMEMet DemandSeat Unavailable
2025-08158671423
2025-09174193580
2025-10214002772
2025-11154413179
2025-12139423520
2026-01143953533
2026-02130003862
2026-03148313414
2026-04143262775
2026-05137513126
2026-06124433115
2026-07113441349

8.Detailed Ride Requests Statu

TIMENo ShowSeat UnavailableCompletedOther ErrorCancelUnaccepted ProposalInvalidBooked
2025-08424142310624343116333067
2025-095273580108154141398424619
2025-1072527721295762917635299234
2025-11504317910172313124032075
2025-12441352094372611045274963
2026-01439353394452831097311993
2026-024843862842524410632770113
2026-0354834149669336128429913
2026-04473277594162981179295433
2026-0543931269197290105927606
2026-0638731158316278991246542
2026-072581349775625178322888

9.Geographical Demand

TIMEDemand Pairs <2% CombinedSalem Reporting->Salem Reporting
2025-08017290
2025-09020999
2025-10024172
2025-11018620
2025-12017462
2026-01017928
2026-02016862
2026-03018245
2026-04017101
2026-05016877
2026-06015558
2026-07012693

File details come from the government source that posted it. Updated .