The file's text, extracted by GovTribe without its formatting.
TEP
1. FFP Purchases will autopopulate from the respective tabs.
| 2. 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 |
Option Year 1 FFP Purchases $0.00
Option Year 2 FFP Purchases $0.00
Option Year 3 FFP Purchases $0.00
Option Year 4 FFP Purchases $0.00
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 | $6,650,665.27 | |
| 2. 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. | | |
| 3. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | | |
| 4. 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 | | base option year totals will be added |
| Primary/Alternate | DATABASES | CATEGORY | USAGE PERCENTAGE (based on FY19 actuals) | Annual Expenditures | Coefficient from Attach 2- Column G | Total Discount from Applied Coefficient | Total Price With Coefficient Applied |
| Primary (80% use) | Grainger | Electrical Systems | 10.08 | $535,730.31 | | $535,730.31 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 10.08 | $133,932.58 | | $133,932.58 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4.82 | $256,059.68 | $256,059.68 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4.82 | $64,014.92 | $64,014.92 | $0.00 |
| Primary (80% use) | Dayton | HVAC/Controls | 40.87 | $2,172,373.35 | $2,172,373.35 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 40.87 | $543,093.34 | $543,093.34 | $0.00 |
| Primary (80% use) | 3M | Structures | 5.92 | $314,547.14 | $314,547.14 | $0.00 |
| Alternate(20% use) | Wooster | Structures | 5.92 | $78,636.78 | $78,636.78 | $0.00 |
| Primary (80% use) | American Standard | Utilities | 16.75 | $890,321.22 | $890,321.22 | $0.00 |
| Alternate(20% use) | Anvil | Utilities | 16.75 | $222,580.30 | $222,580.30 | $0.00 |
| Primary (80% use) | Grainger | Pavements | 7.83 | $416,160.28 | $416,160.28 | $0.00 |
| Alternate(20% use) | Napa | Pavements | 7.83 | $104,040.44 | $104,040.44 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 12.48 | $663,339.94 | $663,339.94 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 12.48 | $165,834.99 | $165,834.99 | $0.00 |
| | | | $ 6,560,665.27 | $6,560,665.27 | $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. Base Year Period of Performance is NTE $1,900,000.00 | $6,650,665.27 |
| 2. 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. | |
| 3. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | |
| 4. 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 | 10.08 | $535,730.31 | | $535,730.31 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 10.08 | $133,932.58 | | $133,932.58 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4.82 | $256,059.68 | $256,059.68 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4.82 | $64,014.92 | $64,014.92 | $0.00 |
| Primary (80% use) | Dayton | HVAC/Controls | 40.87 | $2,172,373.35 | $2,172,373.35 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 40.87 | $543,093.34 | $543,093.34 | $0.00 |
| Primary (80% use) | 3M | Structures | 5.92 | $314,547.14 | $314,547.14 | $0.00 |
| Alternate(20% use) | Wooster | Structures | 5.92 | $78,636.78 | $78,636.78 | $0.00 |
| Primary (80% use) | American Standard | Utilities | 16.75 | $890,321.22 | $890,321.22 | $0.00 |
| Alternate(20% use) | Anvil | Utilities | 16.75 | $222,580.30 | $222,580.30 | $0.00 |
| Primary (80% use) | Grainger | Horizontal Rpr | 7.83 | $416,160.28 | $416,160.28 | $0.00 |
| Alternate(20% use) | Napa | Horizontal Rpr | 7.83 | $104,040.44 | $104,040.44 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 12.48 | $663,339.94 | $663,339.94 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 12.48 | $165,834.99 | $165,834.99 | $0.00 |
| | | | $ 6,560,665.27 | $6,560,665.27 | $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. Base Year Period of Performance is NTE $1,900,000.00 | $6,650,665.27 |
| 2. 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. | |
| 3. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | |
| 4. 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 | 10.08 | $535,730.31 | | $535,730.31 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 10.08 | $133,932.58 | | $133,932.58 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4.82 | $256,059.68 | $256,059.68 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4.82 | $64,014.92 | $64,014.92 | $0.00 |
| Primary (80% use) | Dayton | HVAC/Controls | 40.87 | $2,172,373.35 | $2,172,373.35 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 40.87 | $543,093.34 | $543,093.34 | $0.00 |
| Primary (80% use) | 3M | Structures | 5.92 | $314,547.14 | $314,547.14 | $0.00 |
| Alternate(20% use) | Wooster | Structures | 5.92 | $78,636.78 | $78,636.78 | $0.00 |
| Primary (80% use) | American Standard | Utilities | 16.75 | $890,321.22 | $890,321.22 | $0.00 |
| Alternate(20% use) | Anvil | Utilities | 16.75 | $222,580.30 | $222,580.30 | $0.00 |
| Primary (80% use) | Grainger | Pavements | 7.83 | $416,160.28 | $416,160.28 | $0.00 |
| Alternate(20% use) | Napa | Pavements | 7.83 | $104,040.44 | $104,040.44 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 12.48 | $663,339.94 | $663,339.94 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 12.48 | $165,834.99 | $165,834.99 | $0.00 |
| | | | $ 6,560,665.27 | $6,560,665.27 | $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. Base Year Period of Performance is NTE $1,900,000.00 | $6,650,665.27 |
| 2. 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. | |
| 3. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | |
| 4. 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 | 10.08 | $535,730.31 | | $535,730.31 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 10.08 | $133,932.58 | | $133,932.58 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4.82 | $256,059.68 | $256,059.68 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4.82 | $64,014.92 | $64,014.92 | $0.00 |
| Primary (80% use) | Dayton | HVAC/Controls | 40.87 | $2,172,373.35 | $2,172,373.35 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 40.87 | $543,093.34 | $543,093.34 | $0.00 |
| Primary (80% use) | 3M | Structures | 5.92 | $314,547.14 | $314,547.14 | $0.00 |
| Alternate(20% use) | Wooster | Structures | 5.92 | $78,636.78 | $78,636.78 | $0.00 |
| Primary (80% use) | American Standard | Utilities | 16.75 | $890,321.22 | $890,321.22 | $0.00 |
| Alternate(20% use) | Anvil | Utilities | 16.75 | $222,580.30 | $222,580.30 | $0.00 |
| Primary (80% use) | Grainger | Pavements | 7.83 | $416,160.28 | $416,160.28 | $0.00 |
| Alternate(20% use) | Napa | Pavements | 7.83 | $104,040.44 | $104,040.44 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 12.48 | $663,339.94 | $663,339.94 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 12.48 | $165,834.99 | $165,834.99 | $0.00 |
| | | | $ 6,560,665.27 | $6,560,665.27 | $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. Base Year Period of Performance is NTE $1,900,000.00 | $6,650,665.27 |
| 2. 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. | |
| 3. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate. | |
| 4. 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 | 10.08 | $535,730.31 | | $535,730.31 | $0.00 |
| Alternate(20% use) | Graybar | Electrical Systems | 10.08 | $133,932.58 | | $133,932.58 | $0.00 |
| Primary (80% use) | Grainger | Power Production | 4.82 | $256,059.68 | $256,059.68 | $0.00 |
| Alternate(20% use) | NAPA | Power Production | 4.82 | $64,014.92 | $64,014.92 | $0.00 |
| Primary (80% use) | Dayton | HVAC/Controls | 40.87 | $2,172,373.35 | $2,172,373.35 | $0.00 |
| Alternate(20% use) | Supply House | HVAC/Controls | 40.87 | $543,093.34 | $543,093.34 | $0.00 |
| Primary (80% use) | 3M | Structures | 5.92 | $314,547.14 | $314,547.14 | $0.00 |
| Alternate(20% use) | Wooster | Structures | 5.92 | $78,636.78 | $78,636.78 | $0.00 |
| Primary (80% use) | American Standard | Utilities | 16.75 | $890,321.22 | $890,321.22 | $0.00 |
| Alternate(20% use) | Anvil | Utilities | 16.75 | $222,580.30 | $222,580.30 | $0.00 |
| Primary (80% use) | Grainger | Pavements | 7.83 | $416,160.28 | $416,160.28 | $0.00 |
| Alternate(20% use) | Napa | Pavements | 7.83 | $104,040.44 | $104,040.44 | $0.00 |
| Primary (80% use) | Grainger | Tools/Safety | 12.48 | $663,339.94 | $663,339.94 | $0.00 |
| Alternate(20% use) | Tool Source | Tools/Safety | 12.48 | $165,834.99 | $165,834.99 | $0.00 |
| | | | $6,560,665.27 | $6,560,665.27 | $0.00 |