The file's text, extracted by GovTribe without its formatting.
Sheet1
| TED - Pricing Template - BASE YEAR | | | | | | | |
| LABOR CATEGORIES | LABOR RATE PER HOUR | NUMBER OF HOURS | TOTAL LABOR COST FOR CATEGORY | TOTAL - ALL LABOR CATEGORIES | TOTAL - LABOR & TRAVEL | TOTAL - LABOR, TRAVEL, & HW/SW | TOTAL - LABOR, TRAVEL, HW/SW & MISC. |
| Project Manager | | 450 | $0.00 | $0.00 | $75,000.00 | $75,000.00 | $75,000.00 |
| Subject Matter Expert - DBE | | 500 | $0.00 | | | | |
| Subject Matter Expert - Title VI | | 500 | $0.00 | | | | |
| Subject Matter Expert - EEO | | 500 | $0.00 | | | | |
| Review Team Leader | | 1,200 | $0.00 | | | | |
| Review Team Member | | 1,800 | $0.00 | | | | |
| Technical Writer | | 1,500 | $0.00 | | | | |
TRAVEL (NTE)* $75,000.00
| MISC. EXPENSES - BASE PERIOD | $0.00 |
| *Travel is for an estimated 14 trips | | |
| TED - OPTION YEAR 1 | | | | | | | |
| ESCLATION RATE | | The escalation rate to the right will consist of the number one, representing the rate for the previous base period or option period, plus the esclation rate for the current period. For example, if it is decided the estimated esclation rate for each labor category will be increased by 03%, then the number in this block -----------> will be 103 The percentage keyed in this block will automatically be copied into the other esclation blocks for the remaining periods. | | | | | % |
| LABOR CATEGORIES | LABOR RATE PER HOUR | NUMBER OF HOURS | TOTAL LABOR COST FOR CATEGORY | TOTAL - ALL LABOR CATEGORIES | TOTAL - LABOR & TRAVEL | TOTAL - LABOR, TRAVEL, & HW/SW | TOTAL - LABOR, TRAVEL, HW/SW & MISC. |
| Project Manager | | 450 | $0.00 | $0.00 | $75,000.00 | $75,000.00 | $75,000.00 |
| Subject Matter Expert - DBE | | 500 | $0.00 | | | | |
| Subject Matter Expert - Title VI | | 500 | $0.00 | | | | |
| Subject Matter Expert - EEO | | 500 | $0.00 | | | | |
| Review Team Leader | | 1,200 | $0.00 | | | | |
| Review Team Member | | 1,800 | $0.00 | | | | |
| Technical Writer | | 1,500 | $0.00 | | | | |
TRAVEL (NTE)* $75,000.00
| MISC. EXPENSES |
| *Travel is for an estimated 14 trips | |
| TED - OPTION YEAR 2 | | | | | | | |
| ESCLATION RATE | | The escalation rate to the right is automatically copied to the block from the escalation block for Option Period #1 above. If a different escalation rate is required, key in the rate according to the instructions provided for Option Year 1. | | | | | % |
| LABOR CATEGORIES | LABOR RATE PER HOUR | NUMBER OF HOURS | TOTAL LABOR COST FOR CATEGORY | TOTAL - ALL LABOR CATEGORIES | TOTAL - LABOR & TRAVEL | TOTAL - LABOR, TRAVEL, & HW/SW | TOTAL - LABOR, TRAVEL, HW/SW & MISC. |
| Project Manager | | 450 | $0.00 | $0.00 | $75,000.00 | $75,000.00 | $75,000.00 |
| Subject Matter Expert - DBE | | 500 | $0.00 | | | | |
| Subject Matter Expert - Title VI | | 500 | $0.00 | | | | |
| Subject Matter Expert - EEO | | 500 | $0.00 | | | | |
| Review Team Leader | | 1200 | $0.00 | | | | |
| Review Team Member | | 1800 | $0.00 | | | | |
| Technical Writer | | 1500 | $0.00 | | | | |
TRAVEL (NTE)* $75,000.00
| MISC. EXPENSES |
| *Travel is for an estimated 14 trips | |
| TED - OPTION YEAR 3 | | | | | | | |
| ESCLATION RATE | | The escalation rate to the right is automatically copied to the block from the escalation block for Option Period #1 above. If a different escalation rate is required, key in the rate according to the instructions provided for option year two. | | | | | % |
| LABOR CATEGORIES | LABOR RATE PER HOUR | NUMBER OF HOURS | TOTAL LABOR COST FOR CATEGORY | TOTAL - ALL LABOR CATEGORIES | TOTAL - LABOR & TRAVEL | TOTAL - LABOR, TRAVEL, & HW/SW | TOTAL - LABOR, TRAVEL, HW/SW & MISC. |
| Project Manager | | 450 | $0.00 | $0.00 | $75,000.00 | $75,000.00 | $75,000.00 |
| Subject Matter Expert - DBE | | 500 | $0.00 | | | | |
| Subject Matter Expert - Title VI | | 500 | $0.00 | | | | |
| Subject Matter Expert - EEO | | 500 | $0.00 | | | | |
| Review Team Leader | | 1,200 | $0.00 | | | | |
| Review Team Member | | 1,800 | $0.00 | | | | |
| Technical Writer | | 1,500 | $0.00 | | | | |
TRAVEL (NTE)* $5,000,050.00 $75,000.00
| MISC. EXPENSES |
| *Travel is for an estimated 14 trips | |
| TED - OPTION YEAR 4 | | | | | | | |
| ESCLATION RATE | | The escalation rate to the right is automatically copied to the block from the escalation block for Option Period #1 above. If a different escalation rate is required, key in the rate according to the instructions provided for option year 3. | | | | | % |
| LABOR CATEGORIES | LABOR RATE PER HOUR | NUMBER OF HOURS | TOTAL LABOR COST FOR CATEGORY | TOTAL - ALL LABOR CATEGORIES | TOTAL - LABOR & TRAVEL | TOTAL - LABOR, TRAVEL, & HW/SW | TOTAL - LABOR, TRAVEL, HW/SW & MISC. |
| Project Manager | | 450 | $0.00 | $0.00 | $75,000.00 | $75,000.00 | $75,000.00 |
| Subject Matter Expert - DBE | | 500 | $0.00 | | | | |
| Subject Matter Expert - Title VI | | 500 | $0.00 | | | | |
| Subject Matter Expert - EEO | | 500 | $0.00 | | | | |
| Review Team Leader | | 1,200 | $0.00 | | | | |
| Review Team Member | | 1,800 | $0.00 | | | | |
| Technical Writer | | 1,500 | $0.00 | | | | |
| ERROR:#VALUE! | | | | | | |
| | | TRAVEL (NTE)* | $75,000.00 | | | |
| MISC. EXPENSES |
| *Travel is for an estimated 14 trips | |
| TED - SUMMARY SHEET - BASE YEAR AND OPTION YEARS 1 THROUGH 4 | | | | | | | |
| LABOR CATEGORIES | TOTAL NUMBER OF HOURS FOR EACH LABOR CATEGORY- ALL PERIODS | TOTAL COST FOR EACH LABOR CATEGORY - ALL PERIODS | | TOTAL FOR ALL LABOR CATEGORIES FOR ALL PERIODS | TOTAL FOR ALL LABOR & TRAVEL | TOTAL FOR ALL LABOR, TRAVEL, & HW/SW | TOTALFOR ALL LABOR, TRAVEL, HW/SW & MISC. |
| Project Manager | 2,250 | $0.00 | | $0.00 | $375,000.00 | $375,000.00 | $375,000.00 |
| Subject Matter Expert - DBE | 2,500 | $0.00 | | | | | |
| Subject Matter Expert - Title VI | 2,500 | $0.00 | | | | | |
| Subject Matter Expert - EEO | 2,500 | $0.00 | | | | | |
| Review Team Leader | 6,300 | $0.00 | | | | | |
| Review Team Member | 9,000 | | $0.00 | | | | |
| Technical Writer | 7,500 | $0.00 | | | | | |
TRAVEL (NTE) $375,000.00
| MISC. EXPENSES | $0.00 |
| REMARKS: | | |
| NOTES: |
| TRAVEL: Key in the amount estimated for long distance and local travel, including hotels and per diem. |
| MISCELLANEOUS EXPENSES: Key in any miscellaneous cost that is anticipated, e.g. reports, telephone calls, etc. |
| TOTAL - ALL LABOR CATEGORIES: The total amount for all labor categories will automately be totalled from each of the labor cost for each labor category. |
| TOTAL - LABOR AND TRAVEL: This amount will be the total amount for all the labor categories and the cost for travel for all categories. |
| TOTAL - LABOR, TRAVEL, & HW/SW: This amount will be the total amont for all labor categories, the cost for travel for all categories, and the cost for any hardware and software. |
| TOTAL - LABOR, TRAVEL, HW/SW & MISC.: This amount will be the total amount for all of the labor categories, the cost for travel for all categories, the cost for hardware and software, and any miscellaneous costs, such as reports, telephone calls, etc. |
