Attachment_11_-_COST_ANALYSIS_SPREADSHEET_r1.xlsm
XLSM spreadsheet 628 KB Posted
- Attached to
- Amendment 0005 Federal contract opportunity
- Solicitation number
- N66604-18-R-0881
About this file
This is an amendment to a solicitation issued by the Department of the Navy Naval Sea Systems Command. The amendment updates the list of attachments in Section J, modifies paragraphs in Section L regarding proposal instructions and evaluation criteria, revises the contract data requirements list exhibit, and provides answers to questions from potential offerors. Key details include changing documentation requirements, revising the process for proposal submission and evaluation, and clarifying contractual aspects in response to inquiries from industry.
Attachment 11 Cost Analysis Spreadsheet r1
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 |
| 10 | The SUMMARY tab is for Government Use Only. |
Summary
| FOR GOVERNMENT USE ONLY | |||||||||||
| FOR GOVERNMENT USE ONLY | 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 - CPAF
| 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 | 08/1/19 | 43678.0 | 2017 | 43101.0 | 3.10% | Direct Labor | $0 | $0 | $0 | |||||||||||||||||||
| TOTALS | 0 | $0 | $0 | $0 | $0 | $0 | $0 | START | 08/1/19 | 43678.0 | 2018 | 43466.0 | 3.10% | Fringe | $0 | $0 | $0 | ||||||||||||||||||||||||
| Govt Site | 0 | COMPLETION | 7/31/29 | 47330.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 | 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 | 152 | 1.29% | 1.006 | 0.419 | ESTIMATED COST | $0 | $0 | $0 | |||||||||||
| TOTAL PRIME & SUBCONTRACT LABOR | 0 | FIRST CY OF PERF | 2020 | 366 | 3.11% | 1.029 | 1.031 | FIXED FEE | $0 | $0 | $0 | ||||||||||||||||
| Sub allocation | ERROR:#DIV/0! | SECOND CY OF PERF | 2021 | 365 | 3.10% | 1.060 | 1.060 | TOTAL CPFF | $0 | $0 | $0 | ||||||||||||||||
| THIRD CY OF PERF | 2022 | 365 | 3.10% | 1.093 | 1.093 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| FOURTH CY OF PERF | 2023 | 365 | 3.10% | 1.127 | 1.127 | ||||||||||||||||||||||
| FIFTH CY OF PERF | 2024 | 366 | 3.11% | 1.162 | 1.166 | Bid Amount | $0 | ||||||||||||||||||||
| SIXTH CY OF PERF | 2025 | 365 | 3.10% | 1.198 | 1.198 | Delta | $0 | ||||||||||||||||||||
| SEVENTH CY OF PERF | 2026 | 365 | 3.10% | 1.236 | 1.236 | ||||||||||||||||||||||
| EIGTH CY OF PERF | 2027 | 365 | 3.10% | 1.274 | 1.274 | ||||||||||||||||||||||
| NINTH CY OF PERF | 2028 | 366 | 3.11% | 1.313 | 1.317 | ||||||||||||||||||||||
| TENTH CY OF PERF | 2029 | 212 | 1.80% | 1.346 | 0.782 | ||||||||||||||||||||||
| 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"
Prime - COST
| 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 | 08/1/19 | 43678.0 | 2017 | 43101.0 | 3.10% | Direct Labor | $0 | $0 | $0 | |||||||||||||||||||
| TOTALS | 0 | $0 | $0 | $0 | $0 | $0 | $0 | START | 08/1/19 | 43678.0 | 2018 | 43466.0 | 3.10% | Fringe | $0 | $0 | $0 | ||||||||||||||||||||||||
| Govt Site | 0 | COMPLETION | 7/31/29 | 47330.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 | 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 | 152 | 1.29% | 1.006 | 0.419 | ESTIMATED COST | $0 | $0 | $0 | |||||||||||
| TOTAL PRIME & SUBCONTRACT LABOR | 0 | FIRST CY OF PERF | 2020 | 366 | 3.11% | 1.029 | 1.031 | FIXED FEE | $0 | $0 | $0 | ||||||||||||||||
| Sub allocation | ERROR:#DIV/0! | SECOND CY OF PERF | 2021 | 365 | 3.10% | 1.060 | 1.060 | TOTAL CPFF | $0 | $0 | $0 | ||||||||||||||||
| THIRD CY OF PERF | 2022 | 365 | 3.10% | 1.093 | 1.093 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| FOURTH CY OF PERF | 2023 | 365 | 3.10% | 1.127 | 1.127 | ||||||||||||||||||||||
| FIFTH CY OF PERF | 2024 | 366 | 3.11% | 1.162 | 1.166 | Bid Amount | $0 | ||||||||||||||||||||
| SIXTH CY OF PERF | 2025 | 365 | 3.10% | 1.198 | 1.198 | Delta | $0 | ||||||||||||||||||||
| SEVENTH CY OF PERF | 2026 | 365 | 3.10% | 1.236 | 1.236 | ||||||||||||||||||||||
| EIGTH CY OF PERF | 2027 | 365 | 3.10% | 1.274 | 1.274 | ||||||||||||||||||||||
| NINTH CY OF PERF | 2028 | 366 | 3.11% | 1.313 | 1.317 | ||||||||||||||||||||||
| TENTH CY OF PERF | 2029 | 212 | 1.80% | 1.346 | 0.782 | ||||||||||||||||||||||
| 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"
Prime - FFP
| 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 | 08/1/19 | 43678.0 | 2017 | 43101.0 | 3.10% | Direct Labor | $0 | $0 | $0 | |||||||||||||||||||
| TOTALS | 0 | $0 | $0 | $0 | $0 | $0 | $0 | START | 08/1/19 | 43678.0 | 2018 | 43466.0 | 3.10% | Fringe | $0 | $0 | $0 | ||||||||||||||||||||||||
| Govt Site | 0 | COMPLETION | 7/31/29 | 47330.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 | 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 | 152 | 1.29% | 1.006 | 0.419 | ESTIMATED COST | $0 | $0 | $0 | |||||||||||
| TOTAL PRIME & SUBCONTRACT LABOR | 0 | FIRST CY OF PERF | 2020 | 366 | 3.11% | 1.029 | 1.031 | FIXED FEE | $0 | $0 | $0 | ||||||||||||||||
| Sub allocation | ERROR:#DIV/0! | SECOND CY OF PERF | 2021 | 365 | 3.10% | 1.060 | 1.060 | TOTAL CPFF | $0 | $0 | $0 | ||||||||||||||||
| THIRD CY OF PERF | 2022 | 365 | 3.10% | 1.093 | 1.093 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| FOURTH CY OF PERF | 2023 | 365 | 3.10% | 1.127 | 1.127 | ||||||||||||||||||||||
| FIFTH CY OF PERF | 2024 | 366 | 3.11% | 1.162 | 1.166 | Bid Amount | $0 | ||||||||||||||||||||
| SIXTH CY OF PERF | 2025 | 365 | 3.10% | 1.198 | 1.198 | Delta | $0 | ||||||||||||||||||||
| SEVENTH CY OF PERF | 2026 | 365 | 3.10% | 1.236 | 1.236 | ||||||||||||||||||||||
| EIGTH CY OF PERF | 2027 | 365 | 3.10% | 1.274 | 1.274 | ||||||||||||||||||||||
| NINTH CY OF PERF | 2028 | 366 | 3.11% | 1.313 | 1.317 | ||||||||||||||||||||||
| TENTH CY OF PERF | 2029 | 212 | 1.80% | 1.346 | 0.782 | ||||||||||||||||||||||
| 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-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 | 08/1/19 | 43678.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 | 08/1/19 | 43678.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 | 7/31/29 | 47330.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 | 152 | 1.29% | 1.006 | 0.419 | 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: Name of Prime contractor | 18 | 0.00000 | $0 | FIRST CY OF PERF | 2020 | 366 | 3.11% | 1.029 | 1.031 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||
| $0 | 0.00% | $0 | 0.00% | $0 | $0 | $0 | SECOND CY OF PERF | 2021 | 365 | 3.10% | 1.060 | 1.060 | |||||||||||||
| $0 | $0 | $0 | $0 | $0 | THIRD CY OF PERF | 2022 | 365 | 3.10% | 1.093 | 1.093 | Bid Amount | $0 | |||||||||||||
| FOURTH CY OF PERF | 2023 | 365 | 3.10% | 1.127 | 1.127 | Delta | $0 | ||||||||||||||||||
| FIFTH CY OF PERF | 2024 | 366 | 3.11% | 1.162 | 1.166 | ||||||||||||||||||||
| SIXTH CY OF PERF | 2025 | 365 | 3.10% | 1.198 | 1.198 | ||||||||||||||||||||
| SEVENTH CY OF PERF | 2026 | 365 | 3.10% | 1.236 | 1.236 | ||||||||||||||||||||
| EIGTH CY OF PERF | 2027 | 365 | 3.10% | 1.274 | 1.274 | ||||||||||||||||||||
| NINTH CY OF PERF | 2028 | 366 | 3.11% | 1.313 | 1.317 | ||||||||||||||||||||
| TENTH CY OF PERF | 2029 | 212 | 1.80% | 1.346 | 0.782 | ||||||||||||||||||||
| 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 |
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 .