Demand History - VISN 20 OFL Lenses.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
VA VISN 20 OFL Lenses BPA RFQ
Solicitation number
36C26025Q0268
Issued by

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

SVBifocalTrifocalPALTotalAnnual Total
FY25CR-3914,8436,8289669,26831,906137,215
Poly848307393261,574
PL 1.600- 0- 0179179
Crown Glass3114961384421,388
PL 1.56705647- 0174
PL 1.675,3181,1861546,54413,203
PL 1.59599352- 0- 01,045
PHTCHRM 1.505,2048,4381,55415,55130,747
PL 1.741- 0- 01112
Trivex15,35212,7122,15726,76656,987
FY26CR-3914,8436,8289669,26831,906137,215
Poly848307393261,574
PL 1.600- 0- 0179179
Crown Glass3114961384421,388
PL 1.56705647- 0174
PL 1.675,3181,1861546,54413,203
PL 1.59599352- 0- 01,045
PHTCHRM 1.505,2048,4381,55415,55130,747
PL 1.741- 0- 01112
Trivex15,35212,7122,15726,76656,987
FY27CR-3914,8436,8289669,26831,906137,215
Poly848307393261,574
PL 1.600- 0- 0179179
Crown Glass3114961384421,388
PL 1.56705647- 0174
PL 1.675,3181,1861546,54413,203
PL 1.59599352- 0- 01,045
PHTCHRM 1.505,2048,4381,55415,55130,747
PL 1.741- 0- 01112
Trivex15,35212,7122,15726,76656,987
FY28CR-3914,8436,8289669,26831,906137,215
Poly848307393261,574
PL 1.600- 0- 0179179
Crown Glass3114961384421,388
PL 1.56705647- 0174
PL 1.675,3181,1861546,54413,203
PL 1.59599352- 0- 01,045
PHTCHRM 1.505,2048,4381,55415,55130,747
PL 1.741- 0- 01112
Trivex15,35212,7122,15726,76656,987
FY29CR-3914,8436,8289669,26831,906137,215
Poly848307393261,574
PL 1.600- 0- 0179179
Crown Glass3114961384421,388
PL 1.56705647- 0174
PL 1.675,3181,1861546,54413,203
PL 1.59599352- 0- 01,045
PHTCHRM 1.505,2048,4381,55415,55130,747
PL 1.741- 0- 01112
Trivex15,35212,7122,15726,76656,987
TOTAL ESTIMATE FY25 through FY29CR-3974,21634,1404,83246,340159,528686,074
Poly4,2421,5361,9631297,870
PL 1.602- 0- 0895897
Crown Glass1,5532,4826922,2116,938
PL 1.56351282235- 0868
PL 1.6726,5905,93177232,72266,015
PL 1.5954,965262- 0- 05,227
PHTCHRM 1.5026,02242,1897,76977,756153,736
PL 1.743- 0- 05558
Trivex76,76263,55910,784133,832284,937
5-YEAR AVERAGE OF ACTUAL HISTORICAL DEMAND DATA WITH ESTIMATED COMPOSITE PER UNIT LENS ITEM RATES
SVBifocalTrifocalPALTotalAnnual Total
AVERAGE OF FY20 through FY24 Actual Historical Demand DataCR-3914,8436,8289669,26831,906137,215
Poly848307393261,574
PL 1.600- 0- 0179179
Crown Glass3114961384421,388
PL 1.56705647- 0174
PL 1.675,3181,1861546,54413,203
PL 1.59599352- 0- 01,045
PHTCHRM 1.505,2048,4381,55415,55130,747
PL 1.741- 0- 01112
Trivex15,35212,7122,15726,76656,987
ACTUAL HISTORICAL DEMAND DATA WITH ESTIMATED COMPOSITE PER UNIT LENS ITEM RATES ALIGNING TO ACTUAL BUDGET EXPENDITUES IN PRIOR FISCAL YEARS
SVBifocalTrifocalPALTotalAnnual Total
FY24CR-3915,1115,7908079,05630,764134,714
Poly644162141571,004
PL 1.60- 0- 0- 0138138
Crown Glass3124121063761,206
PL 1.56- 0- 08- 08
PL 1.675,9091,0691266,17413,278
PL 1.5954968- 0- 0504
PHTCHRM 1.505,3556,7361,19114,75528,037
PL 1.74- 0- 0- 01616
Trivex19,42313,3992,24224,69559,759
FY23CR-3915,3186,4258949,52532,162139,671
Poly1,047601710142,372
PL 1.60- 0- 0- 06262
Crown Glass2805001204641,364
PL 1.56- 0- 030- 030
PL 1.676,1301,2811327,00314,546
PL 1.59551210- 0- 0522
PHTCHRM 1.505,1857,8651,46215,28729,799
PL 1.74- 0- 0- 01414
Trivex18,29913,4681,89225,14158,800
FY22CR-3916,3457,27594210,12634,688166,188
Poly1,141489656262,312
PL 1.60- 0- 0- 0164164
Crown Glass3125421484701,472
PL 1.56- 0- 026- 026
PL 1.675,8611,3121607,18614,519
PL 1.59572814- 0- 0742
PHTCHRM 1.505,6209,5871,70717,24734,161
PL 1.74- 0- 0- 022
Trivex14,56612,4741,96249,10078,102
FY21CR-3913,8027,0111,0788,83230,723124,918
Poly1,010174372161,572
PL 1.60- 0- 0- 0187187
Crown Glass3074981424411,388
PL 1.5626256- 084
PL 1.674,6401,1461886,18012,154
PL 1.59585812- 0- 0870
PHTCHRM 1.504,9618,7471,73015,66931,107
PL 1.74- 0- 0- 01616
Trivex13,03812,5692,29218,89246,791
PL 1.55526- 0- 0- 026
FY20CR-3913,6407,6391,1118,80131,191121,033
Poly4001108416610
PL 1.602- 0- 0344346
Crown Glass3425301764601,508
PL 1.56325280115- 0720
PL 1.674,0501,1231666,17911,518
PL 1.5952,371218- 0- 02,589
PHTCHRM 1.504,9019,2541,67914,79830,632
PL 1.743- 0- 0710
Trivex11,43611,6492,39616,00441,485
PL 1.5553255643- 0424
FY19CR-3918,60410,7101,49211,77842,584154,768
Poly3,946512606065,124
PL 1.60- 0- 0- 0266266
Crown Glass4047072065831,900
PL 1.563881,582444- 02,414
PL 1.674,5901,3982027,30013,490
PL 1.5952,812513- 0- 03,325
PHTCHRM 1.505,84711,4162,17815,91735,358
PL 1.74105- 0- 059164
Trivex11,95413,9702,76520,22048,909
PL 1.555388458388- 01,234
FY18CR-3916,03410,2451,62411,51839,421122,778
Poly3,212475908964,673
PL 1.60- 0- 0- 0504504
Crown Glass3545951664401,555
PL 1.561742,242422- 02,838
PL 1.673,6051,0431525,48910,289
PL 1.5952,613820- 0- 03,433
PHTCHRM 1.504,6278,6161,69412,67427,611
PL 1.7450- 0- 01868
Trivex7,2089,1581,95213,07431,392
PL 1.555174398422- 0994
FY17CR-3922,07615,4112,16815,38655,041184,353
Poly9,1215,7499296,37722,176
PL 1.60- 0- 0- 08686
Crown Glass5958652527162,428
PL 1.56- 01,152- 0- 01,152
PL 1.678,2202,3412328,63019,423
PL 1.595718412- 0- 01,130
PHTCHRM 1.503,9549,1661,64511,90726,672
PL 1.5495234- 022108
PL 1.740118- 0- 0104222
Trivex14,81115,8003,45019,54953,610
PL 1.555601,855358322,305
FY16CR-3936,52924,2382,78119,05782,605238,958
Poly12,5958,6301,0506,52628,801
PL 1.6022- 0- 0- 022
Crown Glass6521,1373377422,868
PL 1.56- 042- 06
PL 1.679,9072,7983307,52420,559
PHTCHRM 1.504,6429,7151,61910,88926,865
PL 1.5491,331971- 04322,734
PL 1.740365- 0- 0154519
Trivex21,44520,4823,69323,75269,372
PL 1.5554672,8197225994,607
FY15CR-3918,29512,1451,3939,54941,382119,656
Poly6,3094,3305263,26714,432
PL 1.6011- 0- 0- 011
Crown Glass3265701693711,436
PL 1.56- 021- 03
PL 1.674,9581,4011653,76510,289
PHTCHRM 1.502,3234,8668105,45213,451
PL 1.549666487- 02171,370
PL 1.740183- 0- 077260
Trivex10,73410,2501,84911,88234,715
PL 1.5552341,4113623002,307

File details come from the government source that posted it. Updated .