The file's text, extracted by GovTribe without its formatting.
TEP
| 1. FFP Purchases will autopopulate from the respective tabs. | |
| 2. Vendors shall populate the Extended Price Total from the SPI List for each contract year. | |
| 3. Total Evaluated Price (TEP) will total at the bottom of this sheet. This TEP will be used for source selection price evaluation purposes only. | |
| Base Year FFP Purchases | $0.00 |
| Base Year SPI Extended Price Total | |
| Option Year 1 FFP Purchases | $0.00 |
| Option Year 1 SPI Extended Price Total | |
| Option Year 2 FFP Purchases | $0.00 |
| Option Year 2 SPI Extended Price Total | |
| Option Year 3 FFP Purchases | $0.00 |
| Option Year 3 SPI Extended Price Total | |
| Option Year 4 FFP Purchases | $0.00 |
| Option Year 4 SPI Extended Price Total | |
Vendor's Total Evaluated Price $0.00
Base Year
| This sheet is for source selection evaluation purposes only and will not be included at the time of award | | | | | | | |
| 1. Base Year Period of Performance is NTE $1,900,000.00 | | | | | | | |
| 2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items. | | | | | | | |
| 3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database | | | | | | | |
| and 20% can be made using the alternate database. | | | | | | | |
| 4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | | | | | | | |
| 5. The spreadsheet will calculate applied discounts and total price by contract year. Fixed Price totals and the SPI List totals will be added to calculate Total Evaluated Price | | | | | | | |
| Primary/Alternate | DATABASES | CATEGORY | USAGE PERCENTAGE (based on FY19 actuals) | Annual Expenditures | Coefficient from Attach Y - Column H | Total Discount from Applied Coefficient | Total Price With Coefficient Applied |
| Primary (80% use) | Grainger | Electrical Systems | 21% | $277,200.00 | | $277,200.00 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 21% | $69,300.00 | | $69,300.00 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4% | $52,800.00 | $52,800.00 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4% | $13,200.00 | $13,200.00 | $0.00 |
| Primary (80% use) | Grainger | HVAC/Controls | 37% | $488,400.00 | $488,400.00 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 37% | $122,100.00 | $122,100.00 | $0.00 |
| Primary (80% use) | Grainger | Structures | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Lowes | Structures | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Utilities | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Ferguson | Utilities | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Horizontal Rpr | 9% | $118,800.00 | $118,800.00 | $0.00 |
| Alternate(20% use) | Napa | Horizontal Rpr | 9% | $29,700.00 | $29,700.00 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 7% | $92,400.00 | $92,400.00 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 7% | $23,100.00 | $23,100.00 | $0.00 |
| | | | $ 1,650,000.00 | $1,650,000.00 | $0.00 |
Option Year 1
| This sheet is for source selection evaluation purposes only and will not be included at the time of award | | | | | | | |
| 1. Option year 1 Period of Performance is NTE $1,900,000.00 | | | | | | | |
| 2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items. | | | | | | | |
| 3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database | | | | | | | |
| and 20% can be made using the alternate database. | | | | | | | |
| 4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | | | | | | | |
| 5. The spreadsheet will calculate applied discounts and total price. | | | | | | | |
| Primary/Alternate | DATABASES | CATEGORY | USAGE PERCENTAGE (based on FY19 actuals) | Annual Expenditures | Coefficient from Attach Y - Column H | Total Discount from Applied Coefficient | Total Price With Coefficient Applied |
| Primary (80% use) | Grainger | Electrical Systems | 21% | $ 277,200.00 | | $277,200.00 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 21% | $ 69,300.00 | | $69,300.00 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4% | $52,800.00 | $52,800.00 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4% | $13,200.00 | $13,200.00 | $0.00 |
| Primary (80% use) | Grainger | HVAC/Controls | 37% | $488,400.00 | $488,400.00 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 37% | $122,100.00 | $122,100.00 | $0.00 |
| Primary (80% use) | Grainger | Structures | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Lowes | Structures | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Utilities | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Ferguson | Utilities | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Horizontal Rpr | 9% | $118,800.00 | $118,800.00 | $0.00 |
| Alternate(20% use) | Napa | Horizontal Rpr | 9% | $29,700.00 | $29,700.00 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 7% | $92,400.00 | $92,400.00 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 7% | $23,100.00 | $23,100.00 | $0.00 |
| | | | $ 1,650,000.00 | $1,650,000.00 | $0.00 |
Option Year 2
| This sheet is for source selection evaluation purposes only and will not be included at the time of award | | | | | | | |
| 1. Option Year 2 Period of Performance is NTE $1,900,000.00 | | | | | | | |
| 2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items. | | | | | | | |
| 3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database | | | | | | | |
| and 20% can be made using the alternate database. | | | | | | | |
| 4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | | | | | | | |
| 5. The spreadsheet will calculate applied discounts and total price. | | | | | | | |
| Primary/Alternate | DATABASES | CATEGORY | USAGE PERCENTAGE (based on FY19 actuals) | Annual Expenditures | Coefficient from Attach Y - Column H | Total Discount from Applied Coefficient | Total Price With Coefficient Applied |
| Primary (80% use) | Grainger | Electrical Systems | 21% | $ 277,200.00 | | $277,200.00 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 21% | $ 69,300.00 | | $69,300.00 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4% | $52,800.00 | $52,800.00 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4% | $13,200.00 | $13,200.00 | $0.00 |
| Primary (80% use) | Grainger | HVAC/Controls | 37% | $488,400.00 | $488,400.00 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 37% | $122,100.00 | $122,100.00 | $0.00 |
| Primary (80% use) | Grainger | Structures | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Lowes | Structures | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Utilities | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Ferguson | Utilities | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Horizontal Rpr | 9% | $118,800.00 | $118,800.00 | $0.00 |
| Alternate(20% use) | Napa | Horizontal Rpr | 9% | $29,700.00 | $29,700.00 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 7% | $92,400.00 | $92,400.00 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 7% | $23,100.00 | $23,100.00 | $0.00 |
| | | | $ 1,650,000.00 | $1,650,000.00 | $0.00 |
Option Year 3
| This sheet is for source selection evaluation purposes only and will not be included at the time of award | | | | | | | |
| 1. Option Year 3 Period of Performance is NTE $1,900,000.00 | | | | | | | |
| 2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items. | | | | | | | |
| 3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database | | | | | | | |
| and 20% can be made using the alternate database. | | | | | | | |
| 4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | | | | | | | |
| 5. The spreadsheet will calculate applied discounts and total price. | | | | | | | |
| Primary/Alternate | DATABASES | CATEGORY | USAGE PERCENTAGE (based on FY19 actuals) | Annual Expenditures | Coefficient from Attach Y - Column H | Total Discount from Applied Coefficient | Total Price With Coefficient Applied |
| Primary (80% use) | Grainger | Electrical Systems | 21% | $ 277,200.00 | | $277,200.00 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 21% | $ 69,300.00 | | $69,300.00 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4% | $52,800.00 | $52,800.00 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4% | $13,200.00 | $13,200.00 | $0.00 |
| Primary (80% use) | Grainger | HVAC/Controls | 37% | $488,400.00 | $488,400.00 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 37% | $122,100.00 | $122,100.00 | $0.00 |
| Primary (80% use) | Grainger | Structures | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Lowes | Structures | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Utilities | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Ferguson | Utilities | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Horizontal Rpr | 9% | $118,800.00 | $118,800.00 | $0.00 |
| Alternate(20% use) | Napa | Horizontal Rpr | 9% | $29,700.00 | $29,700.00 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 7% | $92,400.00 | $92,400.00 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 7% | $23,100.00 | $23,100.00 | $0.00 |
| | | | $ 1,650,000.00 | $1,650,000.00 | $0.00 |
Option Year 4
| This sheet is for source selection evaluation purposes only and will not be included at the time of award | | | | | | | |
| 1. Option Year 4 Period of Performance is NTE $1,900,000.00 | | | | | | | |
| 2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items. | | | | | | | |
| 3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database | | | | | | | |
| and 20% can be made using the alternate database. | | | | | | | |
| 4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | | | | | | | |
| 5. The spreadsheet will calculate applied discounts and total price. | | | | | | | |
| Primary/Alternate | DATABASES | CATEGORY | USAGE PERCENTAGE (based on FY19 actuals) | Annual Expenditures | Coefficient from Attach Y - Column H | Total Discount from Applied Coefficient | Total Price With Coefficient Applied |
| Primary (80% use) | Grainger | Electrical Systems | 21% | $277,200.00 | | $277,200.00 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 21% | $69,300.00 | | $69,300.00 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4% | $52,800.00 | $52,800.00 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4% | $13,200.00 | $13,200.00 | $0.00 |
| Primary (80% use) | Grainger | HVAC/Controls | 37% | $488,400.00 | $488,400.00 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 37% | $122,100.00 | $122,100.00 | $0.00 |
| Primary (80% use) | Grainger | Structures | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Lowes | Structures | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Utilities | 11% | $145,200.00 | $145,200.00 | $0.00 |
| Alternate(20% use) | Ferguson | Utilities | 11% | $36,300.00 | $36,300.00 | $0.00 |
| Primary (80% use) | Grainger | Horizontal Rpr | 9% | $118,800.00 | $118,800.00 | $0.00 |
| Alternate(20% use) | Napa | Horizontal Rpr | 9% | $29,700.00 | $29,700.00 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 7% | $92,400.00 | $92,400.00 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 7% | $23,100.00 | $23,100.00 | $0.00 |
| | | | $1,650,000.00 | $1,650,000.00 | $0.00 |
