36C10G19R0050-009.xlsx
XLSX spreadsheet Posted
- Solicitation number
- 36C10G19R0050
About this file
36C10G19R0050 ATTACHMENT G - CLIN(VISN) Projected Usage.xlsx
View the file
Other files
Show all 33
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
| 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 | $ 37,986,203 | $ 58,048,195 | $ 41,356,535 | $ 34,076,645 | $ 61,044,228 | $ 57,174,333 | $ 114,384,964 | $ 45,792,259 | $ 75,854,937 | $ 46,865,749 | $ 42,778,251 | $ 68,701,569 | $ 64,562,699 | $ 45,872,844 | $ 39,822,168 | $ 53,563,011 | $ 86,902,206 | $ 52,842,753 | $ 12,651,105 | $ 45,000,000 |
| % 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% | 95.73% | 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% | 4.27% | 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 | 3336 | 5592 | 5004 | 4272 | 4320 | 2328 |
| Average # of restocks | 60 | 80 | 60 | 60 | 264 | 420 | 55 | 72 | 108 | 60 | 48 | 36 | 408 | 84 | 36 | 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 | 1 | 1 | 1 | 6 | 4 | 3 | 2 | 2 | 8 | 0 | 1 | 0 |
| Average # of PT OSR | 2 | 8 | 2 | 0 | 2 | 0 | 1 | 1 | 8 | 2 | 4 | 3 | 3 | 4 | 0 | 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 | 48 | 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 |
File details come from the government source that posted it. Updated .