ATTACHMENT C - CLIN (VISN) Projected Usage.xlsx
XLSX spreadsheet 12 KB Posted
- Attached to
- 6515--36C10X23R0007 | RFP MSPV Gen-Z V1 - Distribution and Supply Management - Amendment 0002
- Solicitation number
- 36C10X23R0007
About this file
This document contains details regarding a draft request for proposals for medical supply prime vendor services. The Department of Veterans Affairs is seeking to award multiple indefinite delivery, indefinite quantity contracts to provide distribution and supply management of medical, surgical, dental, and laboratory supplies to Veterans Affairs medical centers and other government agencies across 22 Veterans Integrated Service Networks. The period of performance will include a five-year base period and one optional five-year period, for a maximum potential contract length of ten years. Each delivery order will include an implementation period. Questions regarding the draft RFP are due by November 21st, 2022, with the finalized solicitation anticipated for release in December 2022.
View the file
Other files
Show all 21
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
ATTACHMENT C
| All values based on annual estimates | VISN 1 | VISN 2 | VISN 4 | VISN 5 | VISN 6 | VISN 7 | VISN 8 | VISN 9 | VISN 10 | VISN 12 | VISN 15 | VISN 16 | VISN 17 | VISN 19 | VISN 20 | VISN 21 | VISN 22 | VISN 23 | PR | OGA |
| VISN Annual Supply Spend | $28,080,869 | $39,436,322 | $24,917,780 | $21,185,187 | $37,118,289 | $39,978,600 | $68,007,441 | $30,696,857 | $49,580,312 | $31,593,885 | $27,648,016 | $46,607,767 | $43,291,591 | $29,732,291 | $28,567,887 | $40,728,697 | $61,655,280 | $29,247,202 | $8,150,053 | $27,280,084 |
| % of spend under CBD | 91.55% | 94.97% | 96.25% | 96.56% | 99.00% | 98.20% | 98.39% | 90.73% | 90.19% | 94.59% | 89.93% | 95.78% | 98.67% | 93.95% | 88.86% | 88.86% | 99.01% | 88.32% | 100.00% | 94.87% |
| % of spend under LUM | 8.45% | 5.03% | 3.75% | 3.44% | 1.00% | 1.80% | 1.61% | 9.27% | 9.81% | 5.41% | 10.07% | 4.22% | 1.33% | 6.05% | 11.14% | 11.14% | 0.99% | 11.68% | 0.00% | 5.13% |
| % of spend utilizing Stockless Service | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% |
| Additional Emergency Deliveries | 180 | 384 | 36 | 48 | 156 | 36 | 60 | 48 | 144 | 96 | 108 | 180 | 144 | 480 | 12 | 12 | 72 | 540 | 156 | 0 |
| Average # of drop shipments | 1620 | 9660 | 4126 | 4728 | 3048 | 2628 | 3840 | 2964 | 4824 | 2352 | 3132 | 3288 | 3996 | 5664 | 5592 | 5592 | 5004 | 4272 | 4320 | 2328 |
| Average # of restocks | 60 | 80 | 60 | 60 | 264 | 420 | 55 | 72 | 108 | 60 | 48 | 36 | 408 | 84 | 60 | 60 | 120 | 72 | 12 | 324 |
| Average # of Will/Call | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 240 |
| Average # of FT OSR | 2 | 3 | 1 | 3 | 4 | 5 | 3 | 1 | 2 | 1 | 1 | 6 | 4 | 3 | 2 | 2 | 8 | 0 | 1 | 0 |
| Average # of PT OSR | 2 | 8 | 2 | 2 | 2 | 2 | 1 | 1 | 6 | 2 | 4 | 3 | 3 | 4 | 4 | 4 | 1 | 8 | 0 | 0 |
| Average # of Off-Site (<25 miles) | 48 | 48 | 48 | 48 | 48 | 72 | 384 | 48 | 48 | 48 | 48 | 48 | 444 | 48 | 144 | 144 | 36 | 48 | 384 | 24 |
| Average # of Off-Site (>25 miles) | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 72 |
| Average Spend - Inside Delivery | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $0 |
| Commercial Fee | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% |
File details come from the government source that posted it. Updated .