Attachment J008 Amendment 1 030220.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- 693KA9-20-R-00004
About this file
This document contains a labor estimate spreadsheet and description of a federal contract opportunity for financial and business systems support services. The labor estimate spreadsheet outlines various labor categories, hours, rates, and costs over a seven year period for providing administrative, analytical, technical, and managerial support services. The total labor cost over the seven years is estimated at over $101 million. The related federal contract opportunity is for the Financial and Business Systems Support contract to provide a broad range of system-support-related services to ensure the Federal Aviation Administration's business, finance, and management systems meet agency requirements. The opportunity is a solicitation from the Department of Transportation Federal Aviation Administration Headquarters.
View the file
Other files
Show all 19
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
Labor Estimate
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | |||||||||||||||||||||||||||||
| Rate Escalation | Rate Escalation | 0.00% | Rate Escalation | 0.00% | Rate Escalation | 0.00% | Rate Escalation | 0.00% | Rate Escalation | 0.00% | |||||||||||||||||||||||||
| Labor Category | Govt Site Hours | Gov Site Rate | Kr Site Hours | Kr Site Rate | Total Cost | Govt Site Hours | Gov Site Rate | Kr Site Hours | Kr Site Rate | Total Cost | Govt Site Hours | Gov Site Rate | Kr Site Hours | Kr Site Rate | Total Cost | Govt Site Hours | Gov Site Rate | Kr Site Hours | Kr Site Rate | Total Cost | Govt Site Hours | Gov Site Rate | Kr Site Hours | Kr Site Rate | Total Cost | Govt Site Hours | Gov Site Rate | Kr Site Hours | Kr Site Rate | Total Cost | Govt Site Hours | Gov Site Rate | Kr Site Hours | Kr Site Rate | Total Cost |
| Administrative Assisstant | 768 | $0.00 | 768 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 |
| Business Requirements Analyst I | 3168 | $0.00 | 1056 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 |
| Business Requirements Analyst II | 3168 | $0.00 | 1056 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 |
| Business Requirements Analyst III | 3168 | $0.00 | 1056 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 | 3960 | $0.00 | 1320 | $0.00 | $0.00 |
| Database Programmer/Analyst I | 1920 | $0.00 | 2688 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 |
| Database Programmer/Analyst II | 1920 | $0.00 | 3072 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 |
| Database Programmer/Analyst III | 1920 | $0.00 | 3072 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 |
| Financial/Cost Analyst I | 1536 | $0.00 | 3072 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 |
| Financial/Cost Analyst II | 9216 | $0.00 | 3072 | $0.00 | $0.00 | 11520 | $0.00 | 3840 | $0.00 | $0.00 | 11520 | $0.00 | 3840 | $0.00 | $0.00 | 11520 | $0.00 | 3840 | $0.00 | $0.00 | 11520 | $0.00 | 3840 | $0.00 | $0.00 | 11520 | $0.00 | 3840 | $0.00 | $0.00 | 11520 | $0.00 | 3840 | $0.00 | $0.00 |
| Financial/Cost Analyst III | 3072 | $0.00 | 3072 | $0.00 | $0.00 | 3840 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | 3840 | $0.00 | $0.00 | 3840 | $0.00 | 3840 | $0.00 | $0.00 |
| Helpdesk Technician I | 384 | $0.00 | 1152 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 |
| Helpdesk Technician II | 1536 | $0.00 | 3072 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 | 1920 | $0.00 | 3840 | $0.00 | $0.00 |
| Helpdesk Technician III | 13056 | $0.00 | 12288 | $0.00 | $0.00 | 16320 | $0.00 | 15360 | $0.00 | $0.00 | 16320 | $0.00 | 15360 | $0.00 | $0.00 | 16320 | $0.00 | 15360 | $0.00 | $0.00 | 16320 | $0.00 | 15360 | $0.00 | $0.00 | 16320 | $0.00 | 15360 | $0.00 | $0.00 | 16320 | $0.00 | 15360 | $0.00 | $0.00 |
| Program Manager | 230 | $0.00 | 384 | $0.00 | $0.00 | 288 | $0.00 | 480 | $0.00 | $0.00 | 288 | $0.00 | 480 | $0.00 | $0.00 | 288 | $0.00 | 480 | $0.00 | $0.00 | 288 | $0.00 | 480 | $0.00 | $0.00 | 288 | $0.00 | 480 | $0.00 | $0.00 | 288 | $0.00 | 480 | $0.00 | $0.00 |
| Subject Matter Expert | 384 | $0.00 | 1152 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 | 480 | $0.00 | 1440 | $0.00 | $0.00 |
| Systems Engineer/Developer I | 1920 | $0.00 | 2688 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 | 2400 | $0.00 | 3360 | $0.00 | $0.00 |
| Systems Engineer/Developer II | 1920 | $0.00 | 3072 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 |
| Systems Engineer/Developer III | 1920 | $0.00 | 3072 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 | 2400 | $0.00 | 3840 | $0.00 | $0.00 |
| Task Leader | 768 | $0.00 | 1152 | $0.00 | $0.00 | 960 | $0.00 | 1440 | $0.00 | $0.00 | 960 | $0.00 | 1440 | $0.00 | $0.00 | 960 | $0.00 | 1440 | $0.00 | $0.00 | 960 | $0.00 | 1440 | $0.00 | $0.00 | 960 | $0.00 | 1440 | $0.00 | $0.00 | 960 | $0.00 | 1440 | $0.00 | $0.00 |
| Technical Writer | 768 | $0.00 | 768 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | 960 | $0.00 | $0.00 |
| Totals | 52742 | 50784 | $0.00 | 65928 | 63480 | $0.00 | 65928 | 63480 | $0.00 | 65928 | 63480 | $0.00 | 65928 | 63480 | $0.00 | 65928 | 63480 | $0.00 | 65928 | 63480 | $0.00 |
| Year | Hours | FTE | Labor Cost |
| Year 1 | 103,526 | 53.9 | $0.00 |
| Year 2 | 129,408 | 67.4 | $0.00 |
| Year 3 | 129,408 | 67.4 | $0.00 |
| Year 4 | 129,408 | 67.4 | $0.00 |
| Year 5 | 129,408 | 67.4 | $0.00 |
| Year 6 | 129,408 | 67.4 | $0.00 |
| Year 7 | 129,408 | 67.4 | $0.00 |
| Totals | 879,974 | 458 | $0.00 |
Summary
| Total Labor Cost (Initial) | Total Labor Cost (Updated) | ODCs | Travel | Grand Total (Original) | Grand Total (Updated) | |
| Year 1 | $11,283,179.59 | $0.00 | $25,768.60 | $83,258.75 | $11,392,206.95 | $109,027.36 |
| Year 2 | $12,226,453.40 | $0.00 | $27,733.46 | $90,044.34 | $12,344,231.21 | $117,777.80 |
| Year 3 | $13,248,584.91 | $0.00 | $29,848.14 | $97,382.95 | $13,375,816.00 | $127,231.09 |
| Year 4 | $14,356,166.61 | $0.00 | $32,124.06 | $105,319.66 | $14,493,610.33 | $137,443.72 |
| Year 5 | $15,556,342.14 | $0.00 | $34,573.52 | $113,903.22 | $15,704,818.87 | $148,476.73 |
| Year 6 | $16,856,852.34 | $0.00 | $37,209.75 | $123,186.33 | $17,017,248.42 | $160,396.08 |
| Year 7 | $18,266,085.19 | $0.00 | $40,046.99 | $133,226.01 | $18,439,358.20 | $173,273.01 |
| Grand Total | $101,793,664.18 | $0.00 | $227,304.52 | $746,321.27 | $102,767,289.97 | $973,625.79 |
File details come from the government source that posted it. Updated .