Book1.xlsx
XLSX spreadsheet 13 KB Posted
- Solicitation number
- 36C24723R0105
About this file
This spreadsheet provides data on non-emergent ambulance transportation services provided to the Tuscaloosa VA Hospital from April 2021 through March 2023. It details the total number of trips each year, trips over 25 miles including longest distances, and patients requiring advanced or basic life support. The related federal contract opportunity is a solicitation from the Department of Veterans Affairs for non-emergent ambulance transportation services in Tuscaloosa. The incumbent contractor operates two ambulances to meet the 24/7 needs, and the vendor will be paid monthly by invoice for services rendered the prior month as reconciled by the VA. The response deadline and award date are not provided.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C24723R0105 Final.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
Sheet1
| APR 2022 - MAR 2023 | TOTAL TRIPS | trips over 25 miles | ALS runs | BLS runs | APR 2021 - MAR 2022 | TOTAL TRIPS | trips over 25 miles | ALS runs | BLS runs |
| trips/most miles for day | trips/most miles for day | ||||||||
| APRIL | 230 | 29/117 | 3 | 233 | APRIL | 175 | 20/118 | 8 | 167 |
| MAY | 254 | 26/76 | 0 | 254 | MAY | 152 | 24/120 | 8 | 179 |
| JUNE | 246 | 33/186 | 5 | 246 | JUNE | 169 | 17/46 | 3 | 166 |
| JULY | 222 | 24/119 | 4 | 218 | JULY | 175 | 22/79 | 6 | 170 |
| AUGUST | 208 | 16/39 | 6 | 202 | AUGUST | 199 | 22/165 | 3 | 196 |
| SEPTEMBER | 194 | 18/1634 | 4 | 190 | SEPTEMBER | 185 | 12/196 | 6 | 179 |
| OCTOBER | 172 | 17/124 | 9 | 163 | OCTOBER | 186 | 3 28 | 6 | 179 |
| NOVEMBER | 182 | 8 28 | 5 | 179 | NOVEMBER | 201 | 25/110 | 3 | 198 |
| DECEMBER | 212 | 8 41 | 6 | 206 | DECEMBER | 178 | 18/41 | 7 | 223 |
| JANUARY | 220 | 13/47 | 6 | 219 | JANUARY | 163 | 21/41 | 5 | 183 |
| FEBRUARY | 202 | 14/41 | 2 | 200 | FEBRUARY | 138 | 28/90 | 9 | 200 |
| MARCH | 209 | 12 55 | 6 | 215 | MARCH | 204 | 16/63 | 4 | 210 |
| 2551 | 56 | 2525 | 2125 | 68 | 2250 | ||||
| 1. What was the total number of patients transported in 2021 and 2022 to and from the Tuscaloosa VA Hospital? | |||||||||
| From April 1, 2022 through March 31, 2023 = 2551 tips | |||||||||
| From April 1, 2021 through March 31, 2022 = 2125 trips | |||||||||
| 2. How many patients required transportation beyond a 25 mile radius in 2021 and 2022? | |||||||||
| April 1, 2021 through March 31, 2022 - 228 patients with longest distance 196 miles | |||||||||
| April 1, 2022 through March 31, 2023 - 219 patients with longest distance 1634 miles | |||||||||
| 3. In relationship to the patients transported beyond the 25 mile radius. What was the maximum distance traveled from the VA Hospital to drop off destination? | |||||||||
| April 1, 2021 through March 31, 2022 - longest distance = 196 miles | |||||||||
| April 1, 2022 through March 31, 2023 - longest distance = 1634 miles (this is not typical, but sometimes happens) | |||||||||
| 4. How many patients required non-emergent transportation and how many required emergent transportations with ambulance/EMT services? | |||||||||
| April 1, 2021 through March 31, 2022 - patients requiring ALS = 68 | |||||||||
| April 1, 2021 through March 31, 2022 - patients requiring BLS = 2250 | |||||||||
| April 1, 2022 through March 31, 2023 - patients requiring ALS = 56 | |||||||||
| April 1, 2022 through March 31, 2023 - patients requiring BLS = 2525 | |||||||||
| 5. How does the contract pay the winning vendor? Is it per trip or is it strictly the amount of the winning bid that is submitted? | |||||||||
| Vendor will submit invoice on the 1st of the month for the previous month. VA will reconcile the invoice. | |||||||||
| If all matches vendor will submit invoice intoTungston/IPPS and payment will be certified and processed for payment. | |||||||||
| 6. Who is the incumbent contractor? About how many ambulances are they operating? | |||||||||
| I don't think the incumbent contractor is relevent to a competing vendor and should not be given to a competitor. However, we are required to have 2 ambulances at our disposal to cover our needs 24/7 |
File details come from the government source that posted it. Updated .