Attachment J008 Amendment 1 030220.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Financial and Business Systems Support (FBSS) - Amendment 4 Federal contract opportunity
- 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 for this federal contract opportunity
Show all 19
On GovTribe
Work with this file on GovTribe
- 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 .