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
| File | Type | Posted |
|---|---|---|
| 27-12-TAP Attachment D - Rider Experience.xlsx | XLSX spreadsheet | |
| 27-12-TAP Attachment A - Federal Contract Supplement.doc | DOC document | |
| 27-12-TAP Attachment E - Service Operation Visualization.jpg | JPG image | |
| 27-12-TAP RFP Manual - On Demand Rideshare Service.pdf | ||
| 27-12-TAP Attachment C - Rider Growth.xlsx | XLSX spreadsheet | |
| 27-12-TAP Addendum 1.pdf |
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 Name | Value |
| Start Date | 2025-08-01 |
| End Date | 2026-07-31 |
| Periods by | Months |
| Hour Range | |
| Weekdays | |
| Booking Type | |
| Service (Request) | |
| Vendor Name | |
| Booking requires >=1 WAV seat | |
| Service (Shift) | |
| Request Origin Zone | Salem Reporting |
| Request Destination Zone | Salem Reporting |
| Origin->Destination Zones | |
| Request Status | |
| Cancellation Initiator |
2.Driver Hours
| TIME | Net Driver Hours | Break Hours |
| 2025-08 | 3080.402457 | 19.226428 |
| 2025-09 | 2843.954678 | 18.657547 |
| 2025-10 | 3615.089401 | 23.526708 |
| 2025-11 | 2769.872204 | 13.264755 |
| 2025-12 | 2508.062452 | 7.112817 |
| 2026-01 | 2602.137737 | 16.379772 |
| 2026-02 | 2383.296876 | 10.257846 |
| 2026-03 | 2831.550753 | 13.909521 |
| 2026-04 | 2839.327701 | 15.502845 |
| 2026-05 | 2716.833269 | 16.112562 |
| 2026-06 | 2507.305219 | 13.293951 |
| 2026-07 | 1834.231892 | 15.401993 |
3.Utilization
| TIME | Utilization |
| 2025-08 | 4.167637 |
| 2025-09 | 4.455064 |
| 2025-10 | 4.269881 |
| 2025-11 | 4.377458 |
| 2025-12 | 4.446859 |
| 2026-01 | 4.368716 |
| 2026-02 | 4.279786 |
| 2026-03 | 4.184633 |
| 2026-04 | 4.20029 |
| 2026-05 | 4.231397 |
| 2026-06 | 4.124747 |
| 2026-07 | 4.255732 |
4.Vehicle Hours by Shift Segme
| TIME | Revenue Hours | Deadhead Hours |
| 2025-08 | 2717.608888889 | 362.816336667 |
| 2025-09 | 2521.792777778 | 322.161944444 |
| 2025-10 | 3177.290555555 | 437.798888889 |
| 2025-11 | 2428.728055555 | 341.144166667 |
| 2025-12 | 2213.39 | 294.6725 |
| 2026-01 | 2317.620833333 | 284.516944444 |
| 2026-02 | 2127.1725 | 256.124444444 |
| 2026-03 | 2497.195555556 | 334.355277778 |
| 2026-04 | 2503.539444444 | 335.788333333 |
| 2026-05 | 2394.133333333 | 322.699807778 |
| 2026-06 | 2223.441388889 | 283.863888889 |
| 2026-07 | 1613.026944444 | 221.205 |
5.Productivity
| TIME | Productivity |
| 2025-08 | 4.724005744 |
| 2025-09 | 5.02420346 |
| 2025-10 | 4.858227389 |
| 2025-11 | 4.992325086 |
| 2025-12 | 5.038877017 |
| 2026-01 | 4.905030122 |
| 2026-02 | 4.795097718 |
| 2026-03 | 4.744922749 |
| 2026-04 | 4.763655722 |
| 2026-05 | 4.801737581 |
| 2026-06 | 4.651348154 |
| 2026-07 | 4.839348795 |
6.Booking Type
| TIME | Prebooking | On Demand |
| 2025-08 | 26 | 17264 |
| 2025-09 | 23 | 20976 |
| 2025-10 | 10 | 24162 |
| 2025-11 | 24 | 18596 |
| 2025-12 | 7 | 17455 |
| 2026-01 | 9 | 17919 |
| 2026-02 | 8 | 16854 |
| 2026-03 | 2 | 18243 |
| 2026-04 | 6 | 17095 |
| 2026-05 | 15 | 16862 |
| 2026-06 | 16 | 15542 |
| 2026-07 | 5 | 12688 |
7.Met Demand
| TIME | Met Demand | Seat Unavailable |
| 2025-08 | 15867 | 1423 |
| 2025-09 | 17419 | 3580 |
| 2025-10 | 21400 | 2772 |
| 2025-11 | 15441 | 3179 |
| 2025-12 | 13942 | 3520 |
| 2026-01 | 14395 | 3533 |
| 2026-02 | 13000 | 3862 |
| 2026-03 | 14831 | 3414 |
| 2026-04 | 14326 | 2775 |
| 2026-05 | 13751 | 3126 |
| 2026-06 | 12443 | 3115 |
| 2026-07 | 11344 | 1349 |
8.Detailed Ride Requests Statu
| TIME | No Show | Seat Unavailable | Completed | Other Error | Cancel | Unaccepted Proposal | Invalid | Booked |
| 2025-08 | 424 | 1423 | 10624 | 343 | 1163 | 3306 | 7 | |
| 2025-09 | 527 | 3580 | 10815 | 414 | 1398 | 4246 | 19 | |
| 2025-10 | 725 | 2772 | 12957 | 629 | 1763 | 5299 | 23 | 4 |
| 2025-11 | 504 | 3179 | 10172 | 313 | 1240 | 3207 | 5 | |
| 2025-12 | 441 | 3520 | 9437 | 261 | 1045 | 2749 | 6 | 3 |
| 2026-01 | 439 | 3533 | 9445 | 283 | 1097 | 3119 | 9 | 3 |
| 2026-02 | 484 | 3862 | 8425 | 244 | 1063 | 2770 | 11 | 3 |
| 2026-03 | 548 | 3414 | 9669 | 336 | 1284 | 2991 | 3 | |
| 2026-04 | 473 | 2775 | 9416 | 298 | 1179 | 2954 | 3 | 3 |
| 2026-05 | 439 | 3126 | 9197 | 290 | 1059 | 2760 | 6 | |
| 2026-06 | 387 | 3115 | 8316 | 278 | 991 | 2465 | 4 | 2 |
| 2026-07 | 258 | 1349 | 7756 | 251 | 783 | 2288 | 8 |
9.Geographical Demand
| TIME | Demand Pairs <2% Combined | Salem Reporting->Salem Reporting |
| 2025-08 | 0 | 17290 |
| 2025-09 | 0 | 20999 |
| 2025-10 | 0 | 24172 |
| 2025-11 | 0 | 18620 |
| 2025-12 | 0 | 17462 |
| 2026-01 | 0 | 17928 |
| 2026-02 | 0 | 16862 |
| 2026-03 | 0 | 18245 |
| 2026-04 | 0 | 17101 |
| 2026-05 | 0 | 16877 |
| 2026-06 | 0 | 15558 |
| 2026-07 | 0 | 12693 |
File details come from the government source that posted it. Updated .