Demand History - VISN 20 OFL Lenses.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- VA VISN 20 OFL Lenses BPA RFQ
- Solicitation number
- 36C26025Q0268
About this file
The file is a demand history spreadsheet for optical lenses used by VA VISN 20 Optical Fabrication Lab, providing a comprehensive 5-year forecast of lens usage by material type and lens category. The data covers fiscal years 2025-2029, with detailed breakdowns for single vision (SV), bifocal, trifocal, and progressive addition lenses (PAL) across multiple lens materials including CR-39, Poly, Crown Glass, and Trivex, with various refractive indices.
The historical demand data shows consistent annual requirements, with total estimated lens demand ranging from approximately 30,000 to 82,600 lenses per year across different fiscal years. The spreadsheet aligns with the related federal contract opportunity (Solicitation 36C26025Q0268), which seeks to establish a multiple-award Blanket Purchase Agreement (BPA) for lens manufacturers to supply ophthalmic lenses for veterans' eyeglasses through the Veterans Health Administration's VISN 20 Optical Fabrication Lab. The VA intends to award two or more BPAs to lens manufacturer suppliers, with the demand history providing critical procurement planning data.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C26025Q0268 0001.docx | DOCX document | |
| D.1 Material and Price List Lenses 36C26025Q0268.xlsx | XLSX spreadsheet | |
| 36C26025Q0268.docx | DOCX document |
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
Lenses Demand History Lens Usage by Material and Type
FORECASTED AND NOT GUARANTEED ESTIMATE OF 5 YEAR ORDERING PERIOD DEMAND BASED UPON ACTUAL 5 YEAR HISTORICAL DEMAND DATA
| SV | Bifocal | Trifocal | PAL | Total | Annual Total | ||
| FY25 | CR-39 | 14,843 | 6,828 | 966 | 9,268 | 31,906 | 137,215 |
| Poly | 848 | 307 | 393 | 26 | 1,574 | ||
| PL 1.60 | 0 | - 0 | - 0 | 179 | 179 | ||
| Crown Glass | 311 | 496 | 138 | 442 | 1,388 | ||
| PL 1.56 | 70 | 56 | 47 | - 0 | 174 | ||
| PL 1.67 | 5,318 | 1,186 | 154 | 6,544 | 13,203 | ||
| PL 1.595 | 993 | 52 | - 0 | - 0 | 1,045 | ||
| PHTCHRM 1.50 | 5,204 | 8,438 | 1,554 | 15,551 | 30,747 | ||
| PL 1.74 | 1 | - 0 | - 0 | 11 | 12 | ||
| Trivex | 15,352 | 12,712 | 2,157 | 26,766 | 56,987 | ||
| FY26 | CR-39 | 14,843 | 6,828 | 966 | 9,268 | 31,906 | 137,215 |
| Poly | 848 | 307 | 393 | 26 | 1,574 | ||
| PL 1.60 | 0 | - 0 | - 0 | 179 | 179 | ||
| Crown Glass | 311 | 496 | 138 | 442 | 1,388 | ||
| PL 1.56 | 70 | 56 | 47 | - 0 | 174 | ||
| PL 1.67 | 5,318 | 1,186 | 154 | 6,544 | 13,203 | ||
| PL 1.595 | 993 | 52 | - 0 | - 0 | 1,045 | ||
| PHTCHRM 1.50 | 5,204 | 8,438 | 1,554 | 15,551 | 30,747 | ||
| PL 1.74 | 1 | - 0 | - 0 | 11 | 12 | ||
| Trivex | 15,352 | 12,712 | 2,157 | 26,766 | 56,987 | ||
| FY27 | CR-39 | 14,843 | 6,828 | 966 | 9,268 | 31,906 | 137,215 |
| Poly | 848 | 307 | 393 | 26 | 1,574 | ||
| PL 1.60 | 0 | - 0 | - 0 | 179 | 179 | ||
| Crown Glass | 311 | 496 | 138 | 442 | 1,388 | ||
| PL 1.56 | 70 | 56 | 47 | - 0 | 174 | ||
| PL 1.67 | 5,318 | 1,186 | 154 | 6,544 | 13,203 | ||
| PL 1.595 | 993 | 52 | - 0 | - 0 | 1,045 | ||
| PHTCHRM 1.50 | 5,204 | 8,438 | 1,554 | 15,551 | 30,747 | ||
| PL 1.74 | 1 | - 0 | - 0 | 11 | 12 | ||
| Trivex | 15,352 | 12,712 | 2,157 | 26,766 | 56,987 | ||
| FY28 | CR-39 | 14,843 | 6,828 | 966 | 9,268 | 31,906 | 137,215 |
| Poly | 848 | 307 | 393 | 26 | 1,574 | ||
| PL 1.60 | 0 | - 0 | - 0 | 179 | 179 | ||
| Crown Glass | 311 | 496 | 138 | 442 | 1,388 | ||
| PL 1.56 | 70 | 56 | 47 | - 0 | 174 | ||
| PL 1.67 | 5,318 | 1,186 | 154 | 6,544 | 13,203 | ||
| PL 1.595 | 993 | 52 | - 0 | - 0 | 1,045 | ||
| PHTCHRM 1.50 | 5,204 | 8,438 | 1,554 | 15,551 | 30,747 | ||
| PL 1.74 | 1 | - 0 | - 0 | 11 | 12 | ||
| Trivex | 15,352 | 12,712 | 2,157 | 26,766 | 56,987 | ||
| FY29 | CR-39 | 14,843 | 6,828 | 966 | 9,268 | 31,906 | 137,215 |
| Poly | 848 | 307 | 393 | 26 | 1,574 | ||
| PL 1.60 | 0 | - 0 | - 0 | 179 | 179 | ||
| Crown Glass | 311 | 496 | 138 | 442 | 1,388 | ||
| PL 1.56 | 70 | 56 | 47 | - 0 | 174 | ||
| PL 1.67 | 5,318 | 1,186 | 154 | 6,544 | 13,203 | ||
| PL 1.595 | 993 | 52 | - 0 | - 0 | 1,045 | ||
| PHTCHRM 1.50 | 5,204 | 8,438 | 1,554 | 15,551 | 30,747 | ||
| PL 1.74 | 1 | - 0 | - 0 | 11 | 12 | ||
| Trivex | 15,352 | 12,712 | 2,157 | 26,766 | 56,987 | ||
| TOTAL ESTIMATE FY25 through FY29 | CR-39 | 74,216 | 34,140 | 4,832 | 46,340 | 159,528 | 686,074 |
| Poly | 4,242 | 1,536 | 1,963 | 129 | 7,870 | ||
| PL 1.60 | 2 | - 0 | - 0 | 895 | 897 | ||
| Crown Glass | 1,553 | 2,482 | 692 | 2,211 | 6,938 | ||
| PL 1.56 | 351 | 282 | 235 | - 0 | 868 | ||
| PL 1.67 | 26,590 | 5,931 | 772 | 32,722 | 66,015 | ||
| PL 1.595 | 4,965 | 262 | - 0 | - 0 | 5,227 | ||
| PHTCHRM 1.50 | 26,022 | 42,189 | 7,769 | 77,756 | 153,736 | ||
| PL 1.74 | 3 | - 0 | - 0 | 55 | 58 | ||
| Trivex | 76,762 | 63,559 | 10,784 | 133,832 | 284,937 |
| 5-YEAR AVERAGE OF ACTUAL HISTORICAL DEMAND DATA WITH ESTIMATED COMPOSITE PER UNIT LENS ITEM RATES | |||||||
| SV | Bifocal | Trifocal | PAL | Total | Annual Total | ||
| AVERAGE OF FY20 through FY24 Actual Historical Demand Data | CR-39 | 14,843 | 6,828 | 966 | 9,268 | 31,906 | 137,215 |
| Poly | 848 | 307 | 393 | 26 | 1,574 | ||
| PL 1.60 | 0 | - 0 | - 0 | 179 | 179 | ||
| Crown Glass | 311 | 496 | 138 | 442 | 1,388 | ||
| PL 1.56 | 70 | 56 | 47 | - 0 | 174 | ||
| PL 1.67 | 5,318 | 1,186 | 154 | 6,544 | 13,203 | ||
| PL 1.595 | 993 | 52 | - 0 | - 0 | 1,045 | ||
| PHTCHRM 1.50 | 5,204 | 8,438 | 1,554 | 15,551 | 30,747 | ||
| PL 1.74 | 1 | - 0 | - 0 | 11 | 12 | ||
| Trivex | 15,352 | 12,712 | 2,157 | 26,766 | 56,987 |
| ACTUAL HISTORICAL DEMAND DATA WITH ESTIMATED COMPOSITE PER UNIT LENS ITEM RATES ALIGNING TO ACTUAL BUDGET EXPENDITUES IN PRIOR FISCAL YEARS | |||||||
| SV | Bifocal | Trifocal | PAL | Total | Annual Total | ||
| FY24 | CR-39 | 15,111 | 5,790 | 807 | 9,056 | 30,764 | 134,714 |
| Poly | 644 | 162 | 141 | 57 | 1,004 | ||
| PL 1.60 | - 0 | - 0 | - 0 | 138 | 138 | ||
| Crown Glass | 312 | 412 | 106 | 376 | 1,206 | ||
| PL 1.56 | - 0 | - 0 | 8 | - 0 | 8 | ||
| PL 1.67 | 5,909 | 1,069 | 126 | 6,174 | 13,278 | ||
| PL 1.595 | 496 | 8 | - 0 | - 0 | 504 | ||
| PHTCHRM 1.50 | 5,355 | 6,736 | 1,191 | 14,755 | 28,037 | ||
| PL 1.74 | - 0 | - 0 | - 0 | 16 | 16 | ||
| Trivex | 19,423 | 13,399 | 2,242 | 24,695 | 59,759 | ||
| FY23 | CR-39 | 15,318 | 6,425 | 894 | 9,525 | 32,162 | 139,671 |
| Poly | 1,047 | 601 | 710 | 14 | 2,372 | ||
| PL 1.60 | - 0 | - 0 | - 0 | 62 | 62 | ||
| Crown Glass | 280 | 500 | 120 | 464 | 1,364 | ||
| PL 1.56 | - 0 | - 0 | 30 | - 0 | 30 | ||
| PL 1.67 | 6,130 | 1,281 | 132 | 7,003 | 14,546 | ||
| PL 1.595 | 512 | 10 | - 0 | - 0 | 522 | ||
| PHTCHRM 1.50 | 5,185 | 7,865 | 1,462 | 15,287 | 29,799 | ||
| PL 1.74 | - 0 | - 0 | - 0 | 14 | 14 | ||
| Trivex | 18,299 | 13,468 | 1,892 | 25,141 | 58,800 | ||
| FY22 | CR-39 | 16,345 | 7,275 | 942 | 10,126 | 34,688 | 166,188 |
| Poly | 1,141 | 489 | 656 | 26 | 2,312 | ||
| PL 1.60 | - 0 | - 0 | - 0 | 164 | 164 | ||
| Crown Glass | 312 | 542 | 148 | 470 | 1,472 | ||
| PL 1.56 | - 0 | - 0 | 26 | - 0 | 26 | ||
| PL 1.67 | 5,861 | 1,312 | 160 | 7,186 | 14,519 | ||
| PL 1.595 | 728 | 14 | - 0 | - 0 | 742 | ||
| PHTCHRM 1.50 | 5,620 | 9,587 | 1,707 | 17,247 | 34,161 | ||
| PL 1.74 | - 0 | - 0 | - 0 | 2 | 2 | ||
| Trivex | 14,566 | 12,474 | 1,962 | 49,100 | 78,102 | ||
| FY21 | CR-39 | 13,802 | 7,011 | 1,078 | 8,832 | 30,723 | 124,918 |
| Poly | 1,010 | 174 | 372 | 16 | 1,572 | ||
| PL 1.60 | - 0 | - 0 | - 0 | 187 | 187 | ||
| Crown Glass | 307 | 498 | 142 | 441 | 1,388 | ||
| PL 1.56 | 26 | 2 | 56 | - 0 | 84 | ||
| PL 1.67 | 4,640 | 1,146 | 188 | 6,180 | 12,154 | ||
| PL 1.595 | 858 | 12 | - 0 | - 0 | 870 | ||
| PHTCHRM 1.50 | 4,961 | 8,747 | 1,730 | 15,669 | 31,107 | ||
| PL 1.74 | - 0 | - 0 | - 0 | 16 | 16 | ||
| Trivex | 13,038 | 12,569 | 2,292 | 18,892 | 46,791 | ||
| PL 1.555 | 26 | - 0 | - 0 | - 0 | 26 | ||
| FY20 | CR-39 | 13,640 | 7,639 | 1,111 | 8,801 | 31,191 | 121,033 |
| Poly | 400 | 110 | 84 | 16 | 610 | ||
| PL 1.60 | 2 | - 0 | - 0 | 344 | 346 | ||
| Crown Glass | 342 | 530 | 176 | 460 | 1,508 | ||
| PL 1.56 | 325 | 280 | 115 | - 0 | 720 | ||
| PL 1.67 | 4,050 | 1,123 | 166 | 6,179 | 11,518 | ||
| PL 1.595 | 2,371 | 218 | - 0 | - 0 | 2,589 | ||
| PHTCHRM 1.50 | 4,901 | 9,254 | 1,679 | 14,798 | 30,632 | ||
| PL 1.74 | 3 | - 0 | - 0 | 7 | 10 | ||
| Trivex | 11,436 | 11,649 | 2,396 | 16,004 | 41,485 | ||
| PL 1.555 | 325 | 56 | 43 | - 0 | 424 | ||
| FY19 | CR-39 | 18,604 | 10,710 | 1,492 | 11,778 | 42,584 | 154,768 |
| Poly | 3,946 | 512 | 60 | 606 | 5,124 | ||
| PL 1.60 | - 0 | - 0 | - 0 | 266 | 266 | ||
| Crown Glass | 404 | 707 | 206 | 583 | 1,900 | ||
| PL 1.56 | 388 | 1,582 | 444 | - 0 | 2,414 | ||
| PL 1.67 | 4,590 | 1,398 | 202 | 7,300 | 13,490 | ||
| PL 1.595 | 2,812 | 513 | - 0 | - 0 | 3,325 | ||
| PHTCHRM 1.50 | 5,847 | 11,416 | 2,178 | 15,917 | 35,358 | ||
| PL 1.74 | 105 | - 0 | - 0 | 59 | 164 | ||
| Trivex | 11,954 | 13,970 | 2,765 | 20,220 | 48,909 | ||
| PL 1.555 | 388 | 458 | 388 | - 0 | 1,234 | ||
| FY18 | CR-39 | 16,034 | 10,245 | 1,624 | 11,518 | 39,421 | 122,778 |
| Poly | 3,212 | 475 | 90 | 896 | 4,673 | ||
| PL 1.60 | - 0 | - 0 | - 0 | 504 | 504 | ||
| Crown Glass | 354 | 595 | 166 | 440 | 1,555 | ||
| PL 1.56 | 174 | 2,242 | 422 | - 0 | 2,838 | ||
| PL 1.67 | 3,605 | 1,043 | 152 | 5,489 | 10,289 | ||
| PL 1.595 | 2,613 | 820 | - 0 | - 0 | 3,433 | ||
| PHTCHRM 1.50 | 4,627 | 8,616 | 1,694 | 12,674 | 27,611 | ||
| PL 1.74 | 50 | - 0 | - 0 | 18 | 68 | ||
| Trivex | 7,208 | 9,158 | 1,952 | 13,074 | 31,392 | ||
| PL 1.555 | 174 | 398 | 422 | - 0 | 994 | ||
| FY17 | CR-39 | 22,076 | 15,411 | 2,168 | 15,386 | 55,041 | 184,353 |
| Poly | 9,121 | 5,749 | 929 | 6,377 | 22,176 | ||
| PL 1.60 | - 0 | - 0 | - 0 | 86 | 86 | ||
| Crown Glass | 595 | 865 | 252 | 716 | 2,428 | ||
| PL 1.56 | - 0 | 1,152 | - 0 | - 0 | 1,152 | ||
| PL 1.67 | 8,220 | 2,341 | 232 | 8,630 | 19,423 | ||
| PL 1.595 | 718 | 412 | - 0 | - 0 | 1,130 | ||
| PHTCHRM 1.50 | 3,954 | 9,166 | 1,645 | 11,907 | 26,672 | ||
| PL 1.549 | 52 | 34 | - 0 | 22 | 108 | ||
| PL 1.740 | 118 | - 0 | - 0 | 104 | 222 | ||
| Trivex | 14,811 | 15,800 | 3,450 | 19,549 | 53,610 | ||
| PL 1.555 | 60 | 1,855 | 358 | 32 | 2,305 | ||
| FY16 | CR-39 | 36,529 | 24,238 | 2,781 | 19,057 | 82,605 | 238,958 |
| Poly | 12,595 | 8,630 | 1,050 | 6,526 | 28,801 | ||
| PL 1.60 | 22 | - 0 | - 0 | - 0 | 22 | ||
| Crown Glass | 652 | 1,137 | 337 | 742 | 2,868 | ||
| PL 1.56 | - 0 | 4 | 2 | - 0 | 6 | ||
| PL 1.67 | 9,907 | 2,798 | 330 | 7,524 | 20,559 | ||
| PHTCHRM 1.50 | 4,642 | 9,715 | 1,619 | 10,889 | 26,865 | ||
| PL 1.549 | 1,331 | 971 | - 0 | 432 | 2,734 | ||
| PL 1.740 | 365 | - 0 | - 0 | 154 | 519 | ||
| Trivex | 21,445 | 20,482 | 3,693 | 23,752 | 69,372 | ||
| PL 1.555 | 467 | 2,819 | 722 | 599 | 4,607 | ||
| FY15 | CR-39 | 18,295 | 12,145 | 1,393 | 9,549 | 41,382 | 119,656 |
| Poly | 6,309 | 4,330 | 526 | 3,267 | 14,432 | ||
| PL 1.60 | 11 | - 0 | - 0 | - 0 | 11 | ||
| Crown Glass | 326 | 570 | 169 | 371 | 1,436 | ||
| PL 1.56 | - 0 | 2 | 1 | - 0 | 3 | ||
| PL 1.67 | 4,958 | 1,401 | 165 | 3,765 | 10,289 | ||
| PHTCHRM 1.50 | 2,323 | 4,866 | 810 | 5,452 | 13,451 | ||
| PL 1.549 | 666 | 487 | - 0 | 217 | 1,370 | ||
| PL 1.740 | 183 | - 0 | - 0 | 77 | 260 | ||
| Trivex | 10,734 | 10,250 | 1,849 | 11,882 | 34,715 | ||
| PL 1.555 | 234 | 1,411 | 362 | 300 | 2,307 |
File details come from the government source that posted it. Updated .