Attachment-02-Cost-Spreadsheet_14-R-0042.xls
XLS spreadsheet 79 KB Posted
- Attached to
- AMTD Machine Shop Maintenance
- Solicitation number
- N6893614R0042
About this file
Attachment-02-Cost-Spreadsheet 14-R-0042
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_4_-_Department_of_Labor_Wage_Determination.pdf | ||
| Questions_from_Site_Visits_and_Interested_Parties_-_DaNell's_review_3-25-14JC.docx | DOCX document | |
| Attachment_6_-__Updated_AMTD_Physical_Inventory_List.xls | XLS spreadsheet | |
| Exhibit_A_-_CDRLs.doc | DOC document | |
| 14-R-0042_Solicitation.pdf | ||
| N68936-14-R-0042-0001_Solicitation.pdf | ||
| N68936-14-R-0042_Solicitation.pdf | ||
| ATTACHMENT_1_Past_Performance_Questionnaire_14-R-0042.docx | DOCX document | |
| Exhibit_A_-__CDRLs_14-R-0042.doc | DOC document | |
| Attachment_3-_Physical_Inventory_List_14-R-0042.xls | XLS spreadsheet |
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
Basic Period (Yr1-3
| Basic Yr. 1 | Basic Yr. 2 | Basic Yr. 3 | ||||||||||||
| RFP LABOR CATEGORY | CONTRACTOR EQUIVALENT LABOR CATEGORY | Hours | Rate | Dollars | RFP LABOR CATEGORY | CONTRACTOR EQUIVALENT LABOR CATEGORY | Hours | Rate | Dollars | RFP LABOR CATEGORY | CONTRACTOR EQUIVALENT LABOR CATEGORY | Hours | Rate | Dollars |
| (Labor Category) | 0 | $0 | (Labor Category) | 0 | $0 | (Labor Category) | 0 | $0 | ||||||
| Direct Labor Total | Direct Labor Total | Direct Labor Total | ||||||||||||
| Overtime Labor | Overtime Labor | Overtime Labor | ||||||||||||
| OT Labor Category | OT Labor Category | OT Labor Category | ||||||||||||
| OT Total | OT Total | OT Total | ||||||||||||
| Labor Subtotal | Labor Subtotal | Labor Subtotal | ||||||||||||
| TOTAL BURDENED LABOR | TOTAL BURDENED LABOR | TOTAL BURDENED LABOR | ||||||||||||
| Other Direct Costs (ODCs) (Non-IT Materials and Travel) (No Fee) | Other Direct Costs (ODCs) (Non-IT Materials and Travel) (No Fee) | Other Direct Costs (ODCs) (Non-IT Materials and Travel) (No Fee) | ||||||||||||
| IT Materials | IT Materials | IT Materials | ||||||||||||
| TOTAL BURDENED ODCs | TOTAL BURDENED ODCs | TOTAL BURDENED ODCs | ||||||||||||
| TOTAL COST | TOTAL COST | TOTAL COST | ||||||||||||
| TOTAL FEE | TOTAL FEE | TOTAL FEE | ||||||||||||
| TOTAL COST PLUS FEE | TOTAL COST PLUS FEE | TOTAL COST PLUS FEE | ||||||||||||
| Basic Total (Yr 1 -3) | ||||||||||||||
| RFP LABOR CATEGORY | CONTRACTOR EQUIVALENT LABOR CATEGORY | Hours | Rate | Dollars | ||||||||||
| (Labor Category) | 0 | $0 | ||||||||||||
| Direct Labor Total | ||||||||||||||
| Overtime Labor | ||||||||||||||
| OT Labor Category | ||||||||||||||
| OT Total | ||||||||||||||
| Labor Subtotal | ||||||||||||||
| TOTAL BURDENED LABOR | ||||||||||||||
| Other Direct Costs (ODCs) (Non-IT Materials and Travel) (No Fee) | ||||||||||||||
| IT Materials | ||||||||||||||
| TOTAL BURDENED ODCs | ||||||||||||||
| TOTAL COST | ||||||||||||||
| TOTAL FEE | ||||||||||||||
| TOTAL COST PLUS FEE |
Escalation Rates CONTRACTOR
| FY14 | ||||||||||
| DIRECT LABOR | Rate | Escalation Rate | Total Direct Labor Rate | Overhead Rate (Onsite) | Overhead Rate (Offsite) | G&A Rate | Total Labor Per Hour (Onsite) | Total Labor Per Hour (OffSite) | Overtime Rate (Onsite) | Overtime Rate (Offsite) |
| Administrative assistant | $29.64 | 2.15% | $30.28 | $15.71 | $19.21 | 4% | $48.18 | $51.90 | $72.27 | $77.85 |
| Data Specialist | $20.57 | 2.15% | $21.01 | $10.90 | $13.33 | 4% | $33.43 | $36.02 | $50.15 | $54.03 |
| Engineer | $57.55 | 2.15% | $58.79 | $30.50 | $37.31 | 4% | $93.54 | $100.77 | $140.31 | $151.16 |
| Engineering/Electronics Technician | $44.23 | 2.15% | $45.18 | $23.44 | $28.67 | 4% | $71.89 | $77.45 | $107.84 | $116.17 |
| Professional (P1-PVI) | $57.55 | 2.15% | $58.79 | $30.50 | $37.31 | 4% | $93.54 | $100.77 | $140.31 | $151.16 |
| Program Manager | $91.03 | 2.15% | $92.99 | $48.25 | $59.01 | 4% | $147.96 | $159.40 | $221.94 | $239.09 |
| Project Manager | $66.20 | 2.15% | $67.62 | $35.09 | $42.91 | 4% | $107.60 | $115.92 | $161.40 | $173.88 |
| Senior Administrative Assistant | $66.31 | 2.15% | $67.74 | $35.14 | $42.98 | 4% | $107.78 | $116.11 | $161.67 | $174.17 |
| Senior consultant | $31.79 | 2.15% | $32.47 | $16.85 | $20.61 | 4% | $51.67 | $55.67 | $77.51 | $83.50 |
| Senior Engineer | $78.93 | 2.15% | $80.63 | $41.83 | $51.17 | 4% | $128.29 | $138.21 | $192.44 | $207.31 |
| Senior Systems Analyst | $64.65 | 2.15% | $66.04 | $34.26 | $41.91 | 4% | $105.08 | $113.20 | $105.08 | $113.20 |
| Subject Matter/Technical Expert | $76.88 | 2.15% | $78.53 | $40.75 | $49.84 | 4% | $124.96 | $134.62 | $124.96 | $134.62 |
| Systems Analyst | $35.06 | 2.15% | $35.81 | $18.58 | $22.73 | 4% | $56.99 | $61.39 | $56.99 | $61.39 |
| Task Manager | $74.00 | 2.15% | $75.59 | $39.22 | $47.97 | 4% | $120.28 | $129.58 | $120.28 | $129.58 |
| Technical Writer | $47.33 | 2.15% | $48.35 | $25.08 | $30.68 | 4% | $76.93 | $82.88 | $76.93 | $82.88 |
| FY 15 | ||||||||||
| DIRECT LABOR | Rate | Escalation Rate | Total Direct Labor Rate | Overhead Rate- Onsite | Overhead Rate - Offsite | G&A Rate | Total Labor Per Hour (Onsite) | Total Labor Per Hour (OffSite) | Overtime Rate (Onsite) | Overtime Rate (Offsite) |
| Administrative assistant | $30.28 | 2.65% | $31.08 | $16.47 | $20.15 | 4% | $49.45 | $53.28 | $74.18 | $79.91 |
| Data Specialist | $21.01 | 2.65% | $21.57 | $11.43 | $13.98 | 4% | $34.32 | $36.97 | $51.48 | $55.46 |
| Engineer | $58.79 | 2.65% | $60.35 | $31.98 | $39.12 | 4% | $96.02 | $103.44 | $144.03 | $155.16 |
| Engineering/Electronics Technician | $45.18 | 2.65% | $46.38 | $24.58 | $30.06 | 4% | $73.80 | $79.50 | $110.70 | $119.25 |
| Professional (P1-PVI) | $58.79 | 2.65% | $60.35 | $31.98 | $39.12 | 4% | $96.02 | $103.44 | $144.03 | $155.16 |
| Program Manager | $92.99 | 2.65% | $95.45 | $50.59 | $61.88 | 4% | $151.88 | $163.62 | $227.82 | $245.43 |
| Project Manager | $67.62 | 2.65% | $69.42 | $36.79 | $45.00 | 4% | $110.45 | $118.99 | $165.68 | $178.48 |
| Senior Administrative Assistant | $67.74 | 2.65% | $69.53 | $36.85 | $45.07 | 4% | $110.64 | $119.19 | $165.96 | $178.78 |
| Senior consultant | $32.47 | 2.65% | $33.33 | $17.67 | $21.61 | 4% | $53.04 | $57.14 | $79.56 | $85.71 |
| Senior Engineer | $80.63 | 2.65% | $82.76 | $43.86 | $53.65 | 4% | $131.69 | $141.87 | $197.54 | $212.81 |
| Senior Systems Analyst | $66.04 | 2.65% | $67.79 | $35.93 | $43.94 | 4% | $107.87 | $116.20 | $161.80 | $174.31 |
| Subject Matter/Technical Expert | $78.53 | 2.65% | $80.61 | $42.73 | $52.26 | 4% | $128.27 | $138.19 | $192.41 | $207.28 |
| Systems Analyst | $35.81 | 2.65% | $36.76 | $19.48 | $23.83 | 4% | $58.50 | $63.02 | $87.75 | $94.53 |
| Task Manager | $75.59 | 2.65% | $77.59 | $41.12 | $50.30 | 4% | $123.47 | $133.01 | $185.20 | $199.51 |
| Technical Writer | $48.35 | 2.65% | $49.63 | $26.30 | $32.17 | 4% | $78.97 | $85.07 | $118.45 | $127.61 |
| FY 16 | ||||||||||
| DIRECT LABOR | Total Direct Labor Rate | Escalation Rate | Total Direct Labor Rate | Overhead Rate - Onsite | Overhead Rate - Offsite | G&A Rate | Total Labor Per Hour (Onsite) | Total Labor Per Hour (OffSite) | Overtime Rate (Onsite) | Overtime Rate (Offsite) |
| Administrative assistant | $31.08 | 3.02% | $32.02 | $16.97 | $20.76 | 4% | $50.95 | $54.88 | $76.42 | $82.33 |
| Data Specialist | $21.57 | 3.02% | $22.22 | $11.78 | $14.40 | 4% | $35.36 | $38.09 | $53.04 | $57.13 |
| Engineer | $60.35 | 3.02% | $62.17 | $32.95 | $40.30 | 4% | $98.92 | $106.57 | $148.38 | $159.85 |
| Engineering/Electronics Technician | $46.38 | 3.02% | $47.78 | $25.32 | $30.97 | 4% | $76.03 | $81.90 | $114.04 | $122.85 |
| Professional (P1-PVI) | $60.35 | 3.02% | $62.17 | $32.95 | $40.30 | 4% | $98.92 | $106.57 | $148.38 | $159.85 |
| Program Manager | $95.45 | 3.02% | $98.33 | $52.12 | $63.74 | 4% | $156.47 | $168.56 | $234.70 | $252.84 |
| Project Manager | $69.42 | 3.02% | $71.51 | $37.90 | $46.36 | 4% | $113.79 | $122.58 | $170.68 | $183.87 |
| Senior Administrative Assistant | $69.53 | 3.02% | $71.63 | $37.96 | $46.43 | 4% | $113.98 | $122.79 | $170.97 | $184.18 |
| Senior consultant | $33.33 | 3.02% | $34.34 | $18.20 | $22.26 | 4% | $54.64 | $58.87 | $81.96 | $88.30 |
| Senior Engineer | $82.76 | 3.02% | $85.26 | $45.19 | $55.27 | 4% | $135.67 | $146.16 | $203.51 | $219.23 |
| Senior Systems Analyst | $67.79 | 3.02% | $69.84 | $37.01 | $45.27 | 4% | $111.13 | $119.71 | $166.69 | $179.57 |
| Subject Matter/Technical Expert | $80.61 | 3.02% | $83.05 | $44.02 | $53.84 | 4% | $132.15 | $142.36 | $198.22 | $213.54 |
| Systems Analyst | $36.76 | 3.02% | $37.87 | $20.07 | $24.55 | 4% | $60.26 | $64.92 | $90.40 | $97.38 |
| Task Manager | $77.59 | 3.02% | $79.94 | $42.37 | $51.82 | 4% | $127.20 | $137.03 | $190.79 | $205.54 |
| Technical Writer | $49.63 | 3.02% | $51.13 | $27.10 | $33.14 | 4% | $81.35 | $87.64 | $122.03 | $131.46 |
Escalation Rates BANDED
| FY14 | ||||||||||
| DIRECT LABOR | Rate | Escalation Rate | Total Direct Labor Rate | Overhead Rate (Onsite) | Overhead Rate (Offsite) | G&A Rate | Total Labor Per Hour (Onsite) | Total Labor Per Hour (OffSite) | Overtime Rate (Onsite) | Overtime Rate (Offsite) |
| Administrative assistant | $30.66 | 2.15% | $31.32 | $16.60 | $20.30 | 4% | $49.84 | $53.69 | $74.75 | $80.53 |
| Data Specialist | $24.00 | 2.15% | $24.52 | $12.99 | $15.89 | 4% | $39.01 | $42.02 | $58.51 | $63.04 |
| Engineer | $58.57 | 2.15% | $59.83 | $31.71 | $38.78 | 4% | $95.20 | $102.56 | $142.80 | $153.84 |
| Engineering/Electronics Technician | $45.89 | 2.15% | $46.88 | $24.84 | $30.39 | 4% | $74.59 | $80.35 | $111.89 | $120.53 |
| Professional (P1-PVI) | $57.55 | 2.15% | $58.79 | $31.16 | $38.11 | 4% | $93.54 | $100.77 | $140.31 | $151.16 |
| Program Manager | $85.63 | 2.15% | $87.47 | $46.36 | $56.70 | 4% | $139.18 | $149.94 | $208.78 | $224.91 |
| Project Manager | $87.02 | 2.15% | $88.89 | $47.11 | $57.62 | 4% | $141.44 | $152.37 | $212.16 | $228.56 |
| Senior Administrative Assistant | $85.91 | 2.15% | $87.76 | $46.51 | $56.89 | 4% | $139.64 | $150.43 | $209.46 | $225.65 |
| Senior consultant | $37.40 | 2.15% | $38.20 | $20.25 | $24.77 | 4% | $60.79 | $65.49 | $91.19 | $98.23 |
| Senior Engineer | $52.92 | 2.15% | $54.06 | $28.65 | $35.04 | 4% | $86.02 | $92.66 | $129.03 | $139.00 |
| Senior Systems Analyst | $91.03 | 2.15% | $92.99 | $49.28 | $60.28 | 4% | $147.96 | $159.40 | $147.96 | $159.40 |
| Subject Matter/Technical Expert | $91.03 | 2.15% | $92.99 | $49.28 | $60.28 | 4% | $147.96 | $159.40 | $147.96 | $159.40 |
| Systems Analyst | $35.06 | 2.15% | $35.81 | $18.98 | $23.22 | 4% | $56.99 | $61.39 | $56.99 | $61.39 |
| Task Manager | $35.06 | 2.15% | $35.81 | $18.98 | $23.22 | 4% | $56.99 | $61.39 | $56.99 | $61.39 |
| Technical Writer | $47.33 | 2.15% | $48.35 | $25.62 | $31.34 | 4% | $76.93 | $82.88 | $76.93 | $82.88 |
| FY 15 | ||||||||||
| DIRECT LABOR | Rate | Escalation Rate | Total Direct Labor Rate | Overhead Rate- Onsite | Overhead Rate - Offsite | G&A Rate | Total Labor Per Hour (Onsite) | Total Labor Per Hour (OffSite) | Overtime Rate (Onsite) | Overtime Rate (Offsite) |
| Administrative assistant | $31.32 | 2.65% | $32.15 | $17.04 | $20.84 | 4% | $51.16 | $55.11 | $76.73 | $82.66 |
| Data Specialist | $24.52 | 2.65% | $25.17 | $13.34 | $16.31 | 4% | $40.04 | $43.14 | $60.07 | $64.71 |
| Engineer | $59.83 | 2.65% | $61.41 | $32.55 | $39.81 | 4% | $97.72 | $105.28 | $146.58 | $157.91 |
| Engineering/Electronics Technician | $46.88 | 2.65% | $48.12 | $25.50 | $31.19 | 4% | $76.57 | $82.48 | $114.85 | $123.73 |
| Professional (P1-PVI) | $58.79 | 2.65% | $60.35 | $31.98 | $39.12 | 4% | $96.02 | $103.44 | $144.03 | $155.16 |
| Program Manager | $87.47 | 2.65% | $89.79 | $47.59 | $58.20 | 4% | $142.87 | $153.91 | $214.31 | $230.87 |
| Project Manager | $88.89 | 2.65% | $91.25 | $48.36 | $59.15 | 4% | $145.19 | $156.41 | $217.79 | $234.62 |
| Senior Administrative Assistant | $87.76 | 2.65% | $90.08 | $47.74 | $58.40 | 4% | $143.34 | $154.42 | $215.01 | $231.63 |
| Senior consultant | $38.20 | 2.65% | $39.22 | $20.78 | $25.42 | 4% | $62.40 | $67.22 | $93.60 | $100.84 |
| Senior Engineer | $54.06 | 2.65% | $55.49 | $29.41 | $35.97 | 4% | $88.30 | $95.12 | $132.44 | $142.68 |
| Senior Systems Analyst | $92.99 | 2.65% | $95.45 | $50.59 | $61.88 | 4% | $151.88 | $163.62 | $227.82 | $245.43 |
| Subject Matter/Technical Expert | $92.99 | 2.65% | $95.45 | $50.59 | $61.88 | 4% | $151.88 | $163.62 | $227.82 | $245.43 |
| Systems Analyst | $35.81 | 2.65% | $36.76 | $19.48 | $23.83 | 4% | $58.50 | $63.02 | $87.75 | $94.53 |
| Task Manager | $35.81 | 2.65% | $36.76 | $19.48 | $23.83 | 4% | $58.50 | $63.02 | $87.75 | $94.53 |
| Technical Writer | $48.35 | 2.65% | $49.63 | $26.30 | $32.17 | 4% | $78.97 | $85.07 | $118.45 | $127.61 |
| FY 16 | ||||||||||
| DIRECT LABOR | Total Direct Labor Rate | Escalation Rate | Total Direct Labor Rate | Overhead Rate - Onsite | Overhead Rate - Offsite | G&A Rate | Total Labor Per Hour (Onsite) | Total Labor Per Hour (OffSite) | Overtime Rate (Onsite) | Overtime Rate (Offsite) |
| Administrative assistant | $32.15 | 3.02% | $33.12 | $17.55 | $21.47 | 4% | $52.70 | $56.77 | $79.05 | $85.16 |
| Data Specialist | $25.17 | 3.02% | $25.93 | $13.74 | $16.81 | 4% | $41.25 | $44.44 | $61.88 | $66.66 |
| Engineer | $61.41 | 3.02% | $63.27 | $33.53 | $41.01 | 4% | $100.67 | $108.45 | $151.01 | $162.68 |
| Engineering/Electronics Technician | $48.12 | 3.02% | $49.57 | $26.27 | $32.13 | 4% | $78.88 | $84.97 | $118.32 | $127.46 |
| Professional (P1-PVI) | $60.35 | 3.02% | $62.17 | $32.95 | $40.30 | 4% | $98.92 | $106.57 | $148.38 | $159.85 |
| Program Manager | $89.79 | 3.02% | $92.50 | $49.03 | $59.96 | 4% | $147.19 | $158.56 | $220.78 | $237.84 |
| Project Manager | $91.25 | 3.02% | $94.00 | $49.82 | $60.94 | 4% | $149.58 | $161.14 | $224.36 | $241.70 |
| Senior Administrative Assistant | $90.08 | 3.02% | $92.80 | $49.19 | $60.16 | 4% | $147.67 | $159.08 | $221.50 | $238.62 |
| Senior consultant | $39.22 | 3.02% | $40.40 | $21.41 | $26.19 | 4% | $64.29 | $69.25 | $96.43 | $103.88 |
| Senior Engineer | $55.49 | 3.02% | $57.17 | $30.30 | $37.06 | 4% | $90.96 | $97.99 | $136.44 | $146.99 |
| Senior Systems Analyst | $95.45 | 3.02% | $98.33 | $52.12 | $63.74 | 4% | $156.47 | $168.56 | $234.70 | $252.84 |
| Subject Matter/Technical Expert | $95.45 | 3.02% | $98.33 | $52.12 | $63.74 | 4% | $156.47 | $168.56 | $234.70 | $252.84 |
| Systems Analyst | $36.76 | 3.02% | $37.87 | $20.07 | $24.55 | 4% | $60.26 | $64.92 | $90.40 | $97.38 |
| Task Manager | $36.76 | 3.02% | $37.87 | $20.07 | $24.55 | 4% | $60.26 | $64.92 | $90.40 | $97.38 |
| Technical Writer | $49.63 | 3.02% | $51.13 | $27.10 | $33.14 | 4% | $81.35 | $87.64 | $122.03 | $131.46 |
Option Year 1
| Option Yr. 1 | ||||
| RFP LABOR CATEGORY | CONTRACTOR EQUIVALENT LABOR CATEGORY | Hours | Rate | Dollars |
| (Labor Category) | 0 | $0 | ||
| Direct Labor Total | ||||
| Overtime Labor | ||||
| OT Labor Category | ||||
| OT Total | ||||
| Labor Subtotal | ||||
| TOTAL BURDENED LABOR | ||||
| Other Direct Costs (ODCs) (Non-IT Materials and Travel) (No Fee) | ||||
| IT Materials | ||||
| TOTAL BURDENED ODCs | ||||
| TOTAL COST | ||||
| TOTAL FEE | ||||
| TOTAL COST PLUS FEE |
Option Year 2
| Option Yr. 2 | ||||
| RFP LABOR CATEGORY | CONTRACTOR EQUIVALENT LABOR CATEGORY | Hours | Rate | Dollars |
| (Labor Category) | 0 | $0 | ||
| Direct Labor Total | ||||
| Overtime Labor | ||||
| OT Labor Category | ||||
| OT Total | ||||
| Labor Subtotal | ||||
| TOTAL BURDENED LABOR | ||||
| Other Direct Costs (ODCs) (Non-IT Materials and Travel) (No Fee) | ||||
| IT Materials | ||||
| TOTAL BURDENED ODCs | ||||
| TOTAL COST | ||||
| TOTAL FEE | ||||
| TOTAL COST PLUS FEE |
Total Proposed Basic + Options
| Total Cost Including Options | ||||
| RFP LABOR CATEGORY | CONTRACTOR EQUIVALENT LABOR CATEGORY | Hours | Rate | Dollars |
| (Labor Category) | 0 | $0 | ||
| Direct Labor Total | ||||
| Overtime Labor | ||||
| OT Labor Category | ||||
| OT Total | ||||
| Labor Subtotal | ||||
| TOTAL BURDENED LABOR | ||||
| Other Direct Costs (ODCs) (Non-IT Materials and Travel) (No Fee) | ||||
| IT Materials | ||||
| TOTAL BURDENED ODCs | ||||
| TOTAL COST | ||||
| TOTAL FEE | ||||
| TOTAL COST PLUS FEE |
File details come from the government source that posted it. Updated .