Attachment_11_-_COST_ANALYSIS_SPREADSHEET.xlsm
XLSM spreadsheet 589 KB Posted
- Attached to
- Amendment 0005 Federal contract opportunity
- Solicitation number
- N66604-18-R-0881
About this file
This is a cost analysis spreadsheet template for a federal contract opportunity to provide enterprise test and base operations support services. The spreadsheet is structured to calculate labor, material, and other direct costs for the base period of performance from October 2019 through September 2029. It includes tabs for prime and subcontractor cost data input and formulas to calculate loaded labor rates incorporating escalation, overhead, fringe, and G&A costs. Instructions require offerors to provide intact formulas and identify any modifications to the template format or calculations. The opportunity includes firm-fixed-price, cost-plus-award-fee, and cost-no-fee contract line items for labor, materials, ODCs, fixed requirements, CDRLs, government property, and award fees. The period of performance and optional extensions span up to ten years.
View the file
Other files for this federal contract opportunity
Show all 39
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
INSTRUCTION TO OFFERORS
INSTRUCTIONS TO OFFERORS
1 The yellow part of the spreadsheet is for input. The white part of the spreadsheet is formulated.
2 The Offeror shall provide hours by labor category, including subcontractor labor categories using eCRAFT categories. Offerors shall use the drop down menu in the spreadsheet (Column B) to cite labor categories.
3 Offerors may propose a labor category even if the labor category is not listed at the NUWC Division Newport Contracts Website. The appropriateness of any proposed labor category not listed at the NUWC Division Newport Contracts Website shall be clearly explained.
| 4 | The fringe code (cell E4 in spreadsheet) correlates to the fringe code (cells W7:W14) identified in the indirect cost section of the spreadsheet |
| 5 | The overhead code (cell D4 in spreadsheet) correlates to the overhead code (cells W15:W22) identified in the indirect cost section of spreadsheet. |
| 6 | Contractors and subcontractors may alter the format and formulas of this spreadsheet for the sole purpose of |
| accommodating their own accounting systems. Offerors shall clearly show how the spreadsheet was altered. | |
| Spreadsheets, either in the Government format or contractor format, shall | |
| contain intact formulas used to calculate any aspect of the proposal (e.g., burdened labor rates, fee, etc.). | |
| Spreadsheets provided without intact formulas are unacceptable and may render an Offeror’s proposal ineligible | |
| for award. However, prime contractors and subcontractors shall provide a single spreadsheet supporting the total | |
| amount of all CLINs listed in Section B of the solicitation. |
| 7 | The spreadsheet is set up to calculate midpoint escalation for the entire period of performance. |
| The offeror may alter the spreadsheet to propose escalation on an annual basis by entering the proposed escalation rate in cell AE73 of the spreadsheet. | |
| If the offeror elects to calculate escalation on an annual basis, the spreadsheet can be copied for each successive year proposed. | |
| If offeror elects to calculate escalation on an annual basis, a summary "rollup" sheet is required. |
| 8 | Each tab shall clearly identify the CLIN(s) proposed. |
| 9 | NSP CLINs in "SECTION B-CLINS" do not require an estimated COST input |
Summary
| CLINS | |||||||||||
| CPAF | COST | COST | FFP | NSP | NSP | NSP | CPAF | ||||
| CPAF | LABOR | MATERIALS | ODCS | FIXED REQ | CDRLs | GOVT FURN PROP | FEE PYMT | AIR PASS SUP | |||
| Category | Proposed | Evaluated | Delta | 0001 | 0002 | 0003 | 0007 | 0008 | 0009 | 0010 | 0100 |
| LABOR | $ - | $ - | $ - | 0011 | 0012 | 0013 | 0017 | 0018 | 0019 | 0020 | 0101 |
| AIR PASS SUP | $ - | $ - | $ - | 0021 | 0022 | 0023 | 0027 | 0028 | 0029 | 0030 | 0102 |
| AWARD FEE | $ - | $ - | $ - | 0031 | 0032 | 0033 | 0037 | 0038 | 0039 | 0040 | 0103 |
| $ - | $ - | $ - | 0041 | 0042 | 0043 | 0047 | 0048 | 0049 | 0050 | 0104 | |
| Check | $ - | 0051 | 0052 | 0053 | 0057 | 0058 | 0059 | 0060 | 0105 | ||
| 0106 | |||||||||||
| COST | 0107 | ||||||||||
| Category | Proposed | Evaluated | Delta | 0108 | |||||||
| Materials | $ - | $ - | $ - | 0109 | |||||||
| ODCS | |||||||||||
| CDRLS | $ - | $ - | $ - | ||||||||
| GOVT FURN PROP | $ - | $ - | $ - | ||||||||
| FEE | $ - | $ - | $ - | ||||||||
| $ - | $ - | $ - | |||||||||
| Check | $ - |
| FFP | |||
| Category | Proposed | Evaluated | Delta |
| FIXED REQ | $ - | $ - | $ - |
| $ - | $ - | $ - | |
| Check | $ - |
| SUMMARY ALL CLINS | |||
| Category | Proposed | Evaluated | Delta |
| CPAF | $ - | $ - | $ - |
| COST | $ - | $ - | $ - |
| FFP | $ - | $ - | $ - |
| $ - | $ - | $ - |
Prime -
| LABOR | CONTRACT | BASIS | TOTAL | FRG | OVD | LABOR | MIDPOINT | ESCALATED | TOTAL | FRINGE | FRINGE | OVRHD | OVERHEAD | MISC IND | MISC INDR | G&A | G&A | TOTAL | LOADED | PERIOD OF PERFORMANCE | 01 OCT 2019 - 30 SEP 2029 | KEY PERSONNEL WAGE DATA | # | VAL | COL4 | ||||||||||||||||
| CATEGORY | LABOR CATEGORY | OF | HOURS | CDE | CDE | RATE | ESC. | LABOR | LABOR | RATE | COST | RATE | COST | RATE* | COST* | RATE* | COST* | EST COST | COST/HR | CONTRACTOR FY START IS | CONTRACT | COMPOSITE | 0 | 0 | FALSE | ||||||||||||||||
| CODE | ESTIMATE | COL4 | FACTOR | PRIME CONTRACTOR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | LABOR | KEY | HOURS | WAGE | LABOR | RATE/ | COL4 | |||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 |
Paul Simone: Overhead cost is a result of applying the overhead rate to labor cost and fringe cost. If overhead rate if not applied to fringe cost then formula must be changed.
| 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||||||
| Paul Simone: Name of Prime contractor | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | COMPOSITE | CATEGORY | PERSONNEL | PROPOSED | RATE | COSTS | CATEGORY | FALSE | ||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | INDIRECT COST | MONTHS | 3 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 9 | 120 | $0.00 | COL4 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | CODE | $0.00 | FALSE | ||||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE (e.g. FULL-TIME) | 1 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE (e.g. PART-TIME) | 2 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 3 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 4 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 5 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 6 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 7 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 8 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD (e.g. NPT KR-SITE) | 9 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD (e.g. NPT GOVT-SITE) | 10 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 11 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 12 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 13 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 14 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 15 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 16 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MAT'L BURD'N PARTS/SUBK | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MISC INDIRECT/PARTS-SUBK | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MISC INDIRECT | *RATE IN WORKSHEET | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | GENERAL & ADMIN | *RATE IN WORKSHEET | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | G&A - OTHER | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | G&A - OTHER | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 9 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 10 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 11 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 12 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 13 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 14 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 15 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 16 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - MATERIAL | 17 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - G&A BASE | 18 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FEE SUMMARY | PROPOSED | EVALUATED | ||||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FEE on labor | $0 | ERROR:#DIV/0! | ||||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FEE on subcontracts | $0 | $0 | ||||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | TOTAL FEE | $0 | ERROR:#DIV/0! | ||||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | CONTRACT ESCALATION | ||||||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | 'MM/DD/YR | CALENDAR YEAR | RATE/YEAR | SUMMARY | PROPOSED | EVALUATED | DIFFERENCE | ||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | DATE OF ACTUALS | 10/1/19 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 43739.0 | 2017 | 43101.0 | 3.10% | Direct Labor | $0 | $0 | $0 | ||||||
| TOTALS | 0 | $0 | $0 | $0 | $0 | $0 | $0 | START | 10/1/19 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 43739.0 | 2018 | 43466.0 | 3.10% | Fringe | $0 | $0 | $0 | ||
| Govt Site | 0 | COMPLETION | 9/30/29 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 47391.0 | 2019 | 43466.0 | 3.10% | Overhead | $0 | $0 | $0 | |||||||||||||||||||||
| KTR Site | 0 | MATL HDLG | MATL HDLG | SUB HDLG | SUB HDLG | G&A | G&A | TOTAL | #CONTRACT YRS | 10.0 | 2020 | 43831.0 | 3.10% | Misc Indirect (on labor) | $0 | $0 | $0 | ||||||||||||
| OTHER DIRECT COSTS | Prime allocation | ERROR:#DIV/0! | AMOUNT | RATE | COST | RATE | COST | RATE | AMOUNT | COST | BRD | 2021 | 44197.0 | 3.10% | G&A (on labor) | $0 | $0 | $0 | |||||||||||
| TRAVEL | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | FCCM | BASE | CTR | FACTOR | AMOUNT | 2022 | 44562.0 | 3.10% | SUBTOTAL: | $0 | $0 | $0 | ||||||||||
| MATERIAL | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 9 | $0 | 9 | 0.00000 | $0 | 2023 | 44927.0 | 3.10% | Travel | $0 | $0 | $0 | |||||||||
| ODCs | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 10 | $0 | 10 | 0.00000 | $0 | 2024 | 45292.0 | 3.10% | Material | $0 | $0 | $0 | ||||||||||
| Sub - | 0 | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 11 | $0 | 11 | 0.00000 | $0 | 2025 | 45658.0 | 3.10% | ODC'S | $0 | $0 | $0 | |||||||||
| Sub - | 0 | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 12 | $0 | 12 | 0.00000 | $0 | 2026 | 46023.0 | 3.10% | Material Handling | $0 | $0 | $0 | |||||||||
| Sub - | 0 | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 13 | $0 | 13 | 0.00000 | $0 | 2027 | 46388.0 | 3.10% | G&A (Travel/Matl/ODC) | $0 | $0 | $0 | |||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 14 | $0 | 14 | 0.00000 | $0 | 2028 | 46753.0 | 3.10% | Sub - | $0 | $0 | $0 | ||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 15 | $0 | 15 | 0.00000 | $0 | 2029 | 47119.0 | 3.10% | Sub - | $0 | $0 | $0 | ||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 16 | $0 | 16 | 0.00000 | $0 | Sub - | $0 | $0 | $0 | |||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | MATERIAL | $0 | 17 | 0.00000 | $0 | CY | DAYS | RATE/YR | FACTOR | Sub handling (Sub) | $0 | $0 | $0 | |||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | G&A | $0 |
Paul Simone: Base amount includes material costs. If material costs have separate factor applied then they should be taken out of G&A base.
Paul Simone: Name of Prime contractor Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 18 | 0.00000 | $0 | DATA TO START | 2018 | 0 | 0.00% | G&A (Sub) | $0 | $0 | $0 | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | $0 | DATA TO START | 2019 | 0 | 0.00% | 1.000 | FCOM | $0 | $0 | $0 | ||||||||||
| TOTAL SUBCONTRACT LABOR | 0 | $0 | $0 | $0 | $0 | $0 | START TO END OF YR | 2019 | 91 | 0.77% | 1.004 | 0.250 | ESTIMATED COST | $0 | $0 | $0 | |||||||||
| TOTAL PRIME & SUBCONTRACT LABOR | 0 | FIRST CY OF PERF | 2020 | 366 | 3.11% | 1.023 | 1.026 | FIXED FEE | $0 | $0 | $0 | ||||||||||||||
| Sub allocation | ERROR:#DIV/0! | SECOND CY OF PERF | 2021 | 365 | 3.10% | 1.055 | 1.055 | TOTAL CPFF | $0 | $0 | $0 | ||||||||||||||
| THIRD CY OF PERF | 2022 | 365 | 3.10% | 1.088 | 1.088 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||
| FOURTH CY OF PERF | 2023 | 365 | 3.10% | 1.122 | 1.122 | ||||||||||||||||||||
| FIFTH CY OF PERF | 2024 | 366 | 3.11% | 1.156 | 1.160 | Bid Amount | $0 | ||||||||||||||||||
| SIXTH CY OF PERF | 2025 | 365 | 3.10% | 1.192 | 1.192 | Delta | $0 | ||||||||||||||||||
| SEVENTH CY OF PERF | 2026 | 365 | 3.10% | 1.229 | 1.229 | ||||||||||||||||||||
| EIGTH CY OF PERF | 2027 | 365 | 3.10% | 1.267 | 1.267 | ||||||||||||||||||||
| NINTH CY OF PERF | 2028 | 366 | 3.11% | 1.307 | 1.310 | ||||||||||||||||||||
| TENTH CY OF PERF | 2029 | 273 | 2.32% | 1.342 | 1.004 | ||||||||||||||||||||
| ESCALATION TO MIDPOINT | 16.97% |
| &"Times New Roman,Bold"&18C/P EVAL - | &"MS Sans Serif,Bold"&13RFP# |
| CONTROL # | &F |
&A &D
&D "SOURCE SELECTION INFORMATION - SEE FAR 3.104"
Sub-1
| LABOR | CONTRACT | BASIS | TOTAL | FRG | OVD | LABOR | MIDPOINT | ESCALATED | TOTAL | FRINGE | FRINGE | OVRHD | OVERHEAD | MISC IND | MISC INDR | G&A | G&A | TOTAL | LOADED | PERIOD OF PERFORMANCE | 01 OCT 2019 - 30 SEP 2029 | KEY PERSONNEL WAGE DATA | # | VAL | COL4 | ||||||||||||||||
| CATEGORY | LABOR CATEGORY | OF | HOURS | CDE | CDE | RATE | ESC. | LABOR | LABOR | RATE | COST | RATE | COST | RATE* | COST* | RATE* | COST* | EST COST | COST/HR | CONTRACTOR FY START IS | CONTRACT | COMPOSITE | 0 | 0 | FALSE | ||||||||||||||||
| CODE | ESTIMATE | COL4 | FACTOR | PRIME CONTRACTOR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | LABOR | KEY | HOURS | WAGE | LABOR | RATE/ | COL4 | |||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 |
Paul Simone: Overhead cost is a result of applying the overhead rate to labor cost and fringe cost. If overhead rate if not applied to fringe cost then formula must be changed.
| 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | |||||||||||||||||||||||||||||||||||
| Paul Simone: Name of Prime contractor | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | COMPOSITE | CATEGORY | PERSONNEL | PROPOSED | RATE | COSTS | CATEGORY | FALSE | |||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | INDIRECT COST | MONTHS | 3 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 9 | 120 | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | CODE | $0.00 | FALSE | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE (e.g. FULL-TIME) | 1 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE (e.g. PART-TIME) | 2 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 3 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 4 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 5 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 6 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 7 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 8 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD (e.g. NPT KR-SITE) | 9 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD (e.g. NPT GOVT-SITE) | 10 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 11 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 12 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 13 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 14 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 15 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 16 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MAT'L BURD'N PARTS/SUBK | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MISC INDIRECT/PARTS-SUBK | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MISC INDIRECT | *RATE IN WORKSHEET | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | GENERAL & ADMIN | *RATE IN WORKSHEET | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | G&A - OTHER | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | G&A - OTHER | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 9 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 10 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 11 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 12 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 13 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 14 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 15 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 16 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - MATERIAL | 17 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - G&A BASE | 18 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FEE SUMMARY | PROPOSED | EVALUATED | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | CONTRACT ESCALATION | FEE on labor | $0 | ERROR:#DIV/0! | ||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | 'MM/DD/YR | CALENDAR YEAR | RATE/YEAR | FEE on subcontracts | $0 | $0 | ||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | DATE OF ACTUALS | 10/1/19 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 43739.0 | 2017 | 43101.0 | 3.10% | TOTAL FEE | $0 | ERROR:#DIV/0! | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | START | 10/1/19 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 43739.0 | 2018 | 43466.0 | 3.10% | |||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | COMPLETION | 9/30/29 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 47391.0 | 2019 | 43466.0 | 3.10% | SUMMARY | PROPOSED | EVALUATED | DIFFERENCE | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | #CONTRACT YRS | 10.0 | 2020 | 43831.0 | 3.10% | Direct Labor | $0 | $0 | $0 | ||||||||||||
| TOTALS | 0 | $0 | $0 | $0 | $0 | $0 | $0 | 2021 | 44197.0 | 3.10% | Fringe | $0 | $0 | $0 | |||||||||||||||||||
| Govt Site | 0 | 2022 | 44562.0 | 3.10% | Overhead | $0 | $0 | $0 | |||||||||||||||||||||||||
| KTR Site | 0 | MATL HDLG | MATL HDLG | SUB HDLG | SUB HDLG | G&A | G&A | TOTAL | 2023 | 44927.0 | 3.10% | Misc Indirect (on labor) | $0 | $0 | $0 | ||||||||||||||||||
| OTHER DIRECT COSTS | AMOUNT | RATE | COST | RATE | COST | RATE | AMOUNT | COST | BRD | 2024 | 45292.0 | 3.10% | G&A (on labor) | $0 | $0 | $0 | |||||||||||||||||
| TRAVEL | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | FCCM | BASE | CTR | FACTOR | AMOUNT | 2025 | 45658.0 | 3.10% | SUBTOTAL: | $0 | $0 | $0 | ||||||||||||||
| MATERIAL | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 9 | $0 | 9 | 0.00000 | $0 | 2026 | 46023.0 | 3.10% | Travel | $0 | $0 | $0 | |||||||||||||
| ODCs | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 10 | $0 | 10 | 0.00000 | $0 | 2027 | 46388.0 | 3.10% | Material | $0 | $0 | $0 | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 11 | $0 | 11 | 0.00000 | $0 | 2028 | 46753.0 | 3.10% | ODC'S | $0 | $0 | $0 | ||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 12 | $0 | 12 | 0.00000 | $0 | 2029 | 47119.0 | 3.10% | Material Handling | $0 | $0 | $0 | ||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 13 | $0 | 13 | 0.00000 | $0 | G&A (Travel/Matl/ODC) | $0 | $0 | $0 | |||||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 14 | $0 | 14 | 0.00000 | $0 | CY | DAYS | RATE/YR | FACTOR | FCOM | $0 | $0 | $0 | |||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 15 | $0 | 15 | 0.00000 | $0 | DATA TO START | 2018 | 0 | 0.00% | ESTIMATED COST | $0 | $0 | $0 | |||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 16 | $0 | 16 | 0.00000 | $0 | DATA TO START | 2019 | 0 | 0.00% | 1.000 | FIXED FEE | $0 | $0 | $0 | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | MATERIAL | $0 | 17 | 0.00000 | $0 | START TO END OF YR | 2019 | 91 | 0.77% | 1.004 | 0.250 | TOTAL CPFF | $0 | $0 | $0 | |||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | G&A | $0 |
Paul Simone: Base amount includes material costs. If material costs have separate factor applied then they should be taken out of G&A base.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
| Paul Simone: Name of Prime contractor | 18 | 0.00000 | $0 | FIRST CY OF PERF | 2020 | 366 | 3.11% | 1.023 | 1.026 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | $0 | SECOND CY OF PERF | 2021 | 365 | 3.10% | 1.055 | 1.055 | |||||||||||||
| $0 | $0 | $0 | $0 | $0 | THIRD CY OF PERF | 2022 | 365 | 3.10% | 1.088 | 1.088 | Bid Amount | $0 | |||||||||||||
| FOURTH CY OF PERF | 2023 | 365 | 3.10% | 1.122 | 1.122 | Delta | $0 | ||||||||||||||||||
| FIFTH CY OF PERF | 2024 | 366 | 3.11% | 1.156 | 1.160 | ||||||||||||||||||||
| SIXTH CY OF PERF | 2025 | 365 | 3.10% | 1.192 | 1.192 | ||||||||||||||||||||
| SEVENTH CY OF PERF | 2026 | 365 | 3.10% | 1.229 | 1.229 | ||||||||||||||||||||
| EIGTH CY OF PERF | 2027 | 365 | 3.10% | 1.267 | 1.267 | ||||||||||||||||||||
| NINTH CY OF PERF | 2028 | 366 | 3.11% | 1.307 | 1.310 | ||||||||||||||||||||
| TENTH CY OF PERF | 2029 | 273 | 2.32% | 1.342 | 1.004 | ||||||||||||||||||||
| ESCALATION TO MIDPOINT | 16.97% |
| &"Times New Roman,Bold"&18C/P EVAL - | &"MS Sans Serif,Bold"&13RFP# |
| CONTROL # | &F |
&A
&D "SOURCE SELECTION INFORMATION - SEE FAR 3.104"
Sub-2
| LABOR | CONTRACT | BASIS | TOTAL | FRG | OVD | LABOR | MIDPOINT | ESCALATED | TOTAL | FRINGE | FRINGE | OVRHD | OVERHEAD | MISC IND | MISC INDR | G&A | G&A | TOTAL | LOADED | PERIOD OF PERFORMANCE | 01 OCT 2019 - 30 SEP 2029 | KEY PERSONNEL WAGE DATA | # | VAL | COL4 | ||||||||||||||||
| CATEGORY | LABOR CATEGORY | OF | HOURS | CDE | CDE | RATE | ESC. | LABOR | LABOR | RATE | COST | RATE | COST | RATE* | COST* | RATE* | COST* | EST COST | COST/HR | CONTRACTOR FY START IS | CONTRACT | COMPOSITE | 0 | 0 | FALSE | ||||||||||||||||
| CODE | ESTIMATE | COL4 | FACTOR | PRIME CONTRACTOR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | LABOR | KEY | HOURS | WAGE | LABOR | RATE/ | COL4 | |||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 |
Paul Simone: Overhead cost is a result of applying the overhead rate to labor cost and fringe cost. If overhead rate if not applied to fringe cost then formula must be changed.
| 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | |||||||||||||||||||||||||||||||||||
| Paul Simone: Name of Prime contractor | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | COMPOSITE | CATEGORY | PERSONNEL | PROPOSED | RATE | COSTS | CATEGORY | FALSE | |||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | INDIRECT COST | MONTHS | 3 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 9 | 120 | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | CODE | $0.00 | FALSE | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE (e.g. FULL-TIME) | 1 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE (e.g. PART-TIME) | 2 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 3 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 4 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 5 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 6 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 7 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 8 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD (e.g. NPT KR-SITE) | 9 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD (e.g. NPT GOVT-SITE) | 10 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 11 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 12 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 13 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 14 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 15 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 16 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MAT'L BURD'N PARTS/SUBK | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MISC INDIRECT/PARTS-SUBK | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MISC INDIRECT | *RATE IN WORKSHEET | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | GENERAL & ADMIN | *RATE IN WORKSHEET | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | G&A - OTHER | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | G&A - OTHER | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 9 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 10 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 11 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 12 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 13 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 14 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 15 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 16 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - MATERIAL | 17 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - G&A BASE | 18 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FEE SUMMARY | PROPOSED | EVALUATED | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | CONTRACT ESCALATION | FEE on labor | $0 | ERROR:#DIV/0! | ||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | 'MM/DD/YR | CALENDAR YEAR | RATE/YEAR | FEE on subcontracts | $0 | $0 | ||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | DATE OF ACTUALS | 10/1/19 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 43739.0 | 2017 | 43101.0 | 3.10% | TOTAL FEE | $0 | ERROR:#DIV/0! | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | START | 10/1/19 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 43739.0 | 2018 | 43466.0 | 3.10% | |||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | COMPLETION | 9/30/29 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 47391.0 | 2019 | 43466.0 | 3.10% | SUMMARY | PROPOSED | EVALUATED | DIFFERENCE | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | #CONTRACT YRS | 10.0 | 2020 | 43831.0 | 3.10% | Direct Labor | $0 | $0 | $0 | ||||||||||||
| TOTALS | 0 | $0 | $0 | $0 | $0 | $0 | $0 | 2021 | 44197.0 | 3.10% | Fringe | $0 | $0 | $0 | |||||||||||||||||||
| Govt Site | 0 | 2022 | 44562.0 | 3.10% | Overhead | $0 | $0 | $0 | |||||||||||||||||||||||||
| KTR Site | 0 | MATL HDLG | MATL HDLG | SUB HDLG | SUB HDLG | G&A | G&A | TOTAL | 2023 | 44927.0 | 3.10% | Misc Indirect (on labor) | $0 | $0 | $0 | ||||||||||||||||||
| OTHER DIRECT COSTS | AMOUNT | RATE | COST | RATE | COST | RATE | AMOUNT | COST | BRD | 2024 | 45292.0 | 3.10% | G&A (on labor) | $0 | $0 | $0 | |||||||||||||||||
| TRAVEL | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | FCCM | BASE | CTR | FACTOR | AMOUNT | 2025 | 45658.0 | 3.10% | SUBTOTAL: | $0 | $0 | $0 | ||||||||||||||
| MATERIAL | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 9 | $0 | 9 | 0.00000 | $0 | 2026 | 46023.0 | 3.10% | Travel | $0 | $0 | $0 | |||||||||||||
| ODCs | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 10 | $0 | 10 | 0.00000 | $0 | 2027 | 46388.0 | 3.10% | Material | $0 | $0 | $0 | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 11 | $0 | 11 | 0.00000 | $0 | 2028 | 46753.0 | 3.10% | ODC'S | $0 | $0 | $0 | ||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 12 | $0 | 12 | 0.00000 | $0 | 2029 | 47119.0 | 3.10% | Material Handling | $0 | $0 | $0 | ||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 13 | $0 | 13 | 0.00000 | $0 | G&A (Travel/Matl/ODC) | $0 | $0 | $0 | |||||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 14 | $0 | 14 | 0.00000 | $0 | CY | DAYS | RATE/YR | FACTOR | FCOM | $0 | $0 | $0 | |||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 15 | $0 | 15 | 0.00000 | $0 | DATA TO START | 2018 | 0 | 0.00% | ESTIMATED COST | $0 | $0 | $0 | |||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 16 | $0 | 16 | 0.00000 | $0 | DATA TO START | 2019 | 0 | 0.00% | 1.000 | FIXED FEE | $0 | $0 | $0 | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | MATERIAL | $0 | 17 | 0.00000 | $0 | START TO END OF YR | 2019 | 91 | 0.77% | 1.004 | 0.250 | TOTAL CPFF | $0 | $0 | $0 | |||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | G&A | $0 |
Paul Simone: Base amount includes material costs. If material costs have separate factor applied then they should be taken out of G&A base.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
| Paul Simone: Name of Prime contractor | 18 | 0.00000 | $0 | FIRST CY OF PERF | 2020 | 366 | 3.11% | 1.023 | 1.026 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | $0 | SECOND CY OF PERF | 2021 | 365 | 3.10% | 1.055 | 1.055 | |||||||||||||
| $0 | $0 | $0 | $0 | $0 | THIRD CY OF PERF | 2022 | 365 | 3.10% | 1.088 | 1.088 | Bid Amount | $0 | |||||||||||||
| FOURTH CY OF PERF | 2023 | 365 | 3.10% | 1.122 | 1.122 | Delta | $0 | ||||||||||||||||||
| FIFTH CY OF PERF | 2024 | 366 | 3.11% | 1.156 | 1.160 | ||||||||||||||||||||
| SIXTH CY OF PERF | 2025 | 365 | 3.10% | 1.192 | 1.192 | ||||||||||||||||||||
| SEVENTH CY OF PERF | 2026 | 365 | 3.10% | 1.229 | 1.229 | ||||||||||||||||||||
| EIGTH CY OF PERF | 2027 | 365 | 3.10% | 1.267 | 1.267 | ||||||||||||||||||||
| NINTH CY OF PERF | 2028 | 366 | 3.11% | 1.307 | 1.310 | ||||||||||||||||||||
| TENTH CY OF PERF | 2029 | 273 | 2.32% | 1.342 | 1.004 | ||||||||||||||||||||
| ESCALATION TO MIDPOINT | 16.97% |
| &"Times New Roman,Bold"&18C/P EVAL - | &"MS Sans Serif,Bold"&13RFP# |
| CONTROL # | &F |
&A
&D "SOURCE SELECTION INFORMATION - SEE FAR 3.104"
Sub-3
| LABOR | CONTRACT | BASIS | TOTAL | FRG | OVD | LABOR | MIDPOINT | ESCALATED | TOTAL | FRINGE | FRINGE | OVRHD | OVERHEAD | MISC IND | MISC INDR | G&A | G&A | TOTAL | LOADED | PERIOD OF PERFORMANCE | 01 OCT 2019 - 30 SEP 2029 | KEY PERSONNEL WAGE DATA | # | VAL | COL4 | ||||||||||||||||
| CATEGORY | LABOR CATEGORY | OF | HOURS | CDE | CDE | RATE | ESC. | LABOR | LABOR | RATE | COST | RATE | COST | RATE* | COST* | RATE* | COST* | EST COST | COST/HR | CONTRACTOR FY START IS | CONTRACT | COMPOSITE | 0 | 0 | FALSE | ||||||||||||||||
| CODE | ESTIMATE | COL4 | FACTOR | PRIME CONTRACTOR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | FISCAL YR | LABOR | KEY | HOURS | WAGE | LABOR | RATE/ | COL4 | |||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 |
Paul Simone: Overhead cost is a result of applying the overhead rate to labor cost and fringe cost. If overhead rate if not applied to fringe cost then formula must be changed.
| 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | |||||||||||||||||||||||||||||||||||
| Paul Simone: Name of Prime contractor | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | COMPOSITE | CATEGORY | PERSONNEL | PROPOSED | RATE | COSTS | CATEGORY | FALSE | |||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | INDIRECT COST | MONTHS | 3 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 9 | 120 | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | CODE | $0.00 | FALSE | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE (e.g. FULL-TIME) | 1 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE (e.g. PART-TIME) | 2 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 3 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 4 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 5 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 6 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 7 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FRINGE | 8 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD (e.g. NPT KR-SITE) | 9 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | COL4 | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD (e.g. NPT GOVT-SITE) | 10 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | FALSE | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 11 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 12 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 13 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 14 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 15 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | OVRHD | 16 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MAT'L BURD'N PARTS/SUBK | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MISC INDIRECT/PARTS-SUBK | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | MISC INDIRECT | *RATE IN WORKSHEET | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | GENERAL & ADMIN | *RATE IN WORKSHEET | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | G&A - OTHER | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | G&A - OTHER | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | $0.00 | ||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 9 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 10 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 11 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 12 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 13 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 14 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 15 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - LABOR | 16 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - MATERIAL | 17 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FCCM - G&A BASE | 18 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | 0.00000 | $0.00 | |||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | FEE SUMMARY | PROPOSED | EVALUATED | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | CONTRACT ESCALATION | FEE on labor | $0 | ERROR:#DIV/0! | ||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | 'MM/DD/YR | CALENDAR YEAR | RATE/YEAR | FEE on subcontracts | $0 | $0 | ||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | DATE OF ACTUALS | 10/1/19 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 43739.0 | 2017 | 43101.0 | 3.10% | TOTAL FEE | $0 | ERROR:#DIV/0! | ||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | START | 10/1/19 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 43739.0 | 2018 | 43466.0 | 3.10% | |||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | COMPLETION | 9/30/29 |
Paul Simone: Paul Simone:
| Insert START date when applying escalation to wage determinations in SCA categories. | 47391.0 | 2019 | 43466.0 | 3.10% | SUMMARY | PROPOSED | EVALUATED | DIFFERENCE | |||||||||||||||||||||||||
| 0.00% | $0.00 | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ERROR:#DIV/0! | #CONTRACT YRS | 10.0 | 2020 | 43831.0 | 3.10% | Direct Labor | $0 | $0 | $0 | ||||||||||||
| TOTALS | 0 | $0 | $0 | $0 | $0 | $0 | $0 | 2021 | 44197.0 | 3.10% | Fringe | $0 | $0 | $0 | |||||||||||||||||||
| Govt Site | 0 | 2022 | 44562.0 | 3.10% | Overhead | $0 | $0 | $0 | |||||||||||||||||||||||||
| KTR Site | 0 | MATL HDLG | MATL HDLG | SUB HDLG | SUB HDLG | G&A | G&A | TOTAL | 2023 | 44927.0 | 3.10% | Misc Indirect (on labor) | $0 | $0 | $0 | ||||||||||||||||||
| OTHER DIRECT COSTS | AMOUNT | RATE | COST | RATE | COST | RATE | AMOUNT | COST | BRD | 2024 | 45292.0 | 3.10% | G&A (on labor) | $0 | $0 | $0 | |||||||||||||||||
| TRAVEL | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | FCCM | BASE | CTR | FACTOR | AMOUNT | 2025 | 45658.0 | 3.10% | SUBTOTAL: | $0 | $0 | $0 | ||||||||||||||
| MATERIAL | $0 | 0.00% | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 9 | $0 | 9 | 0.00000 | $0 | 2026 | 46023.0 | 3.10% | Travel | $0 | $0 | $0 | |||||||||||||
| ODCs | $0 | $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 10 | $0 | 10 | 0.00000 | $0 | 2027 | 46388.0 | 3.10% | Material | $0 | $0 | $0 | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 11 | $0 | 11 | 0.00000 | $0 | 2028 | 46753.0 | 3.10% | ODC'S | $0 | $0 | $0 | ||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 12 | $0 | 12 | 0.00000 | $0 | 2029 | 47119.0 | 3.10% | Material Handling | $0 | $0 | $0 | ||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 13 | $0 | 13 | 0.00000 | $0 | G&A (Travel/Matl/ODC) | $0 | $0 | $0 | |||||||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 14 | $0 | 14 | 0.00000 | $0 | CY | DAYS | RATE/YR | FACTOR | FCOM | $0 | $0 | $0 | |||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 15 | $0 | 15 | 0.00000 | $0 | DATA TO START | 2018 | 0 | 0.00% | ESTIMATED COST | $0 | $0 | $0 | |||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | ENG LABOR CC 16 | $0 | 16 | 0.00000 | $0 | DATA TO START | 2019 | 0 | 0.00% | 1.000 | FIXED FEE | $0 | $0 | $0 | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | MATERIAL | $0 | 17 | 0.00000 | $0 | START TO END OF YR | 2019 | 91 | 0.77% | 1.004 | 0.250 | TOTAL CPFF | $0 | $0 | $0 | |||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | G&A | $0 |
Paul Simone: Base amount includes material costs. If material costs have separate factor applied then they should be taken out of G&A base.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
Paul Simone: Paul Simone:
Insert START date when applying escalation to wage determinations in SCA categories.
| Paul Simone: Name of Prime contractor | 18 | 0.00000 | $0 | FIRST CY OF PERF | 2020 | 366 | 3.11% | 1.023 | 1.026 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | $0 | SECOND CY OF PERF | 2021 | 365 | 3.10% | 1.055 | 1.055 | |||||||||||||
| $0 | $0 | $0 | $0 | $0 | THIRD CY OF PERF | 2022 | 365 | 3.10% | 1.088 | 1.088 | Bid Amount | $0 | |||||||||||||
| FOURTH CY OF PERF | 2023 | 365 | 3.10% | 1.122 | 1.122 | Delta | $0 | ||||||||||||||||||
| FIFTH CY OF PERF | 2024 | 366 | 3.11% | 1.156 | 1.160 | ||||||||||||||||||||
| SIXTH CY OF PERF | 2025 | 365 | 3.10% | 1.192 | 1.192 | ||||||||||||||||||||
| SEVENTH CY OF PERF | 2026 | 365 | 3.10% | 1.229 | 1.229 | ||||||||||||||||||||
| EIGTH CY OF PERF | 2027 | 365 | 3.10% | 1.267 | 1.267 | ||||||||||||||||||||
| NINTH CY OF PERF | 2028 | 366 | 3.11% | 1.307 | 1.310 | ||||||||||||||||||||
| TENTH CY OF PERF | 2029 | 273 | 2.32% | 1.342 | 1.004 | ||||||||||||||||||||
| ESCALATION TO MIDPOINT | 16.97% |
| &"Times New Roman,Bold"&18C/P EVAL - | &"MS Sans Serif,Bold"&13RFP# |
| CONTROL # | &F |
&A
&D "SOURCE SELECTION…
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .