The file's text, extracted by GovTribe without its formatting.
Schedule 1
| SCHEDULE 1 |
| SUMMARY OF ESTIMATED/PROPOSED COSTS AND FIXED FEE/PROFIT |
Offeror or Subcontractor Name: ______________________________________________
| The Government estimates that 90% of this effort will be issued as Task Orders on a Cost Plus Fixed Fee basis and the |
| remaining 10% will be issued as Task Orders on a Firm Fixed price basis. This Schedule summarizes the estimated Cost Plus |
| Fixed Fee Portion of the Year 1 Master Contract value (90% of the total effort) in the top table, the estimated Firm Fixed Price |
| Portion of the Master Contract value (10% of the total effort) in the second table. The sum of these two tables results in the |
| Maximum Contract Value (100% of the effort) in the bottom table. |
NOTE: The light green shaded cells in this Excel Workbook contain formulas.
| Contract Type | Description | Total Estimated Cost (From Schedule 2) | Fixed Fee (From Schedule 2) | Total |
| Cost Plus Fixed Fee (90% of effort) | TMSEDS | | | |
| Period 1 | $ | $ | $ - 0 |
| Total - CPFF for Period 1 | | $ - 0 | $ - 0 | $ - 0 |
| Contract Type | Description | Total Proposed Cost (From Schedule 3) | Profit (From Schedule 3) | Total |
| Firm Fixed Price (10% of effort) | TMSEDS | | | |
| Period 1 | $ | $ | $ - 0 |
| Total - FFP for Period 1 | | $ - 0 | $ - 0 | $ - 0 |
| Total Estimated Cost | $ | | |
| Total Proposed Cost | $ | | |
| Total Proposed Fixed Fee | $ | | |
| Total Proposed Profit | $ | | |
| Total Amount | $ | | |
| Each Task Order will require a separate proposal with Fixed Fee and Profit percentages |
| (as applicable), not exceeding the percentages entered into paragraph H.9 (see Schedule 6), to be negotiated for each Task |
| Order. Only the Minimum Guarantee as stated in paragraph G.14 represents the Government's obligation at time of award. |
| &"Times New Roman,Bold"ATTACHMENT J.8 | &"Times New Roman,Bold" MASTER CONTRACT COST |
| AND BUSINESS PROPOSAL SCHEDULES | &"Times New Roman,Bold"DTRT5716R20001 |
Schedule 2
| SCHEDULE 2 |
| SUMMARY OF ESTIMATED COSTS AND FIXED FEE BY COST ELEMENT |
| Offeror or Subcontractor Name: __________________________________________________ |
This schedule is for the CPFF portion of the Master Contract value (90% of effort).
| Element of Proposal | |
| Period 1 |
| Direct Labor (from Schedule 4 ) | $ |
| Fringe Benefits (using rates from Schedule 5) | $ |
| Labor Overhead (using rates from Schedule 5) | $ |
| Total Labor Costs | $ - 0 |
| Subcontracts: (from Schedule 7) | |
| Subcontractor A | $ |
| Subcontractor B | $ |
| Subcontractor C | $ |
| Subcontractor D | $ |
| Total Subcontracts | $ - 0 |
| Subcontract Burden (using rates from Schedule 5) | $ |
| Other Direct Costs: | |
| RFP-stipulated (Travel, Miscellaneous and Equipment) | $ - 0 |
| Offeror-estimated (from schedule 9) | $ |
| ODC Burden (using rates from Schedule 5) | $ |
| SUBTOTAL | $ - 0 |
| G&A (using rates from Schedule 5) | $ |
| ESTIMATED COST (except for Cost of Money) | $ - 0 |
| FIXED FEE (using rate from Schedule 6) | $ |
| Cost of Money | $ |
| TOTAL | $ - 0 |
| &"Times New Roman,Bold"ATTACHMENT J.8 | &"Times New Roman,Bold"MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES |
| &"Times New Roman,Bold"DTRT5716R20001 |
Schedule 3
| SCHEDULE 3 |
| SUMMARY OF PROPOSED COSTS AND PROFIT BY COST ELEMENT |
Offeror or Subcontractor Name: __________________________________________________
This schedule is for the FFP portion of the Master Contract value (10% of effort).
| Element of Proposal | |
| Period 1 |
| Direct Labor (from Schedule 4 ) | $ |
| Fringe Benefits (using rates from Schedule 5) | $ |
| Labor Overhead (using rates from Schedule 5) | $ |
| Total Labor Costs | $ - 0 |
| Subcontracts: (from Schedule 7) | |
| Subcontractor A | $ |
| Subcontractor B | $ |
| Subcontractor C | $ |
| Subcontractor D | $ |
| Total Subcontracts | $ - 0 |
| Subcontract Burden (using rates from Schedule 5) | $ |
| Other Direct Costs: | |
| RFP-stipulated (Travel, Miscellaneous and Equipment) | $ - 0 |
| Offeror-estimated (from schedule 9) | $ |
| ODC Burden (using rates from Schedule 5) | $ |
| SUBTOTAL | $ - 0 |
| G&A (using rates from Schedule 5) | $ |
| PROPOSED COST (except for Cost of Money) | $ - 0 |
| PROFIT (using rate from Schedule 6) | $ |
| Cost of Money | $ |
| TOTAL | $ - 0 |
&"Times New Roman,Bold"ATTACHMENT J.8 &"Times New Roman,Bold"MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES &"Times New Roman,Bold"DTRT5716R20001
Schedule 4
| SCHEDULE 4 |
| CALCULATION OF DIRECT LABOR COST |
Offeror or Subcontractor Name: _________________________________________________________
| A. Labor Hours | |
| Labor Category | Period 1 |
| Senior Staff | |
| Middle Staff | |
| Staff | |
| Junior Staff | |
| Senior Technician | |
| Technician | |
| Adminsitrative Staff (Specify) | |
| Total | 0.00 |
| B. UNBURDENED Labor Rates | |
| Labor Category | Period 1 |
| Senior Staff | $ |
| Middle Staff | $ |
| Staff | $ |
| Junior Staff | $ |
| Senior Technician | |
| Technician | |
| Administrative Staff (Specify) | $ |
| Total | $ - 0 |
| C. Extended Labor Cost (A times B) | |
| Labor Category | Period 1 |
| Senior Staff | $ |
| Middle Staff | $ |
| Staff | $ |
| Junior Staff | $ |
| Senior Technician | |
| Technician | |
| Administrative Staff (Specify) | $ |
| Total | $ - 0 |
As stated at the top of Schedule 1, the Government anticipates that 90% of this effort will be issued as Task Orders on a Cost Plus Fixed Fee basis and the remaining 10% will be issued as Task Orders on a Firm Fixed Price basis. The table below apportions the extended labor cost between Cost Plus Fixed Fee and Firm Fixed Price work consistent with these percentages for entry into Schedules 2 and 3.
| Period 1 |
| COST PLUS FIXED FEE DIRECT LABOR ALLOCATION - 90% of Total Extended Labor Cost (enter in Schedule 2) | $ - 0 |
| FIRM FIXED PRICE DIRECT LABOR ALLOCATION - 10% of Total Extended Labor Cost (enter in Schedule 3) | $ - 0 |
| &"Times New Roman,Bold"ATTACHMENT J.8 | &"Times New Roman,Bold"MASTER CONTRACT COST AND |
| BUSINESS PROPOSAL SCHEDULE | &"Times New Roman,Bold"DTRT5716R20001 |
Schedule 5
| SCHEDULE 5 |
| PROPOSED INDIRECT RATES AND ALLOCATION BASES |
Offeror or Subcontractor Name: _________________________________________________________
| Proposed Indirect Rates | |
| Fiscal Year / Rate Weightings (1) |
| Fringe Benefits (2) | FY__ Rate ____% Weight ___ |
| FY__ Rate ____% Weight ___ |
| Labor Overhead | FY__ Rate ____% Weight ___ |
| FY__ Rate ____% Weight ___ |
| Subcontract Burden (3) | FY__ Rate ____% Weight ___ |
| FY__ Rate ____% Weight ___ |
| ODC Burden (3) | FY__ Rate ____% Weight ___ |
| FY__ Rate ____% Weight ___ |
| G&A | FY__ Rate ____% Weight ___ |
| FY__ Rate ____% Weight ___ |
| Other _____________ (4) | FY__ Rate ____% Weight ___ |
| FY__ Rate ____% Weight ___ |
| (1) Unless the Offerors fiscal year coincides with planned performance period, the Offeror shall combine the rates for two | |
| fiscal years covered by the performance period into a single rate and show the weighting/calculations. | |
| (2) If separate from Overhead. | |
| (3) If separate from G&A. | |
| (4) Specify. Offerors may have to adjust schedules 2 & 3 to include the cost associated with any "other" Indirect Rates | |
| Indirect Rate | Allocation Base |
| Example: G&A | All costs except subcontract and equipment cost |
| Fringe Benefits | |
| Labor Overhead | |
| Subcontract Burden | |
| ODC Burden | |
| G&A | |
| Other | |
| &"Times New Roman,Bold"ATTACHMENT J.8 | &"Times New Roman,Bold"MASTER CONTRACT COST AND |
| BUSINESS PROPOSAL SCHEDULES | &"Times New Roman,Bold"DTRT5716R20001 |
Schedule 6
| SCHEDULE 6 |
| PROPOSED FIXED FEE AND PROFIT CALCULATION AND |
| MASTER CONTRACT MAXIMUM FEE/PROFIT RATES |
Offeror Name: _________________________________________________________
| FIXED FEE | | | |
| Estimated Cost | Percentage (3) | Fixed Fee Dollars |
| Subcontracts and Other Direct Cost from Schedule 2 (1) | $ | % | $ |
| All Other Costs from Schedule 2 (2) | $ | % | $ |
| Total | $ | | |
| Total Fixed Fee Dollars (4) | | | $ |
| PROFIT | | | |
| Estimated Cost | Percentage (3) | Profit Dollars |
| Subcontracts and Other Direct Cost from Schedule 3 (1) | $ | % | $ |
| All Other Costs from Schedule 3 (2) | $ | % | $ |
| Total | $ | | |
| Total Profit Dollars (5) | | | $ |
| (1) "Subcontracts and Travel Cost” should not include any Prime indirect burden. |
| (2) "All Other Costs" should include remaining costs from Schedule 1 except Cost of Money, if proposed. |
| (3) "Percentage" is the fee percentage the Offeror uses to develop fixed fee. These percentages will be incorporated in paragraph H.9 of the resulting contract and will be used to |
| calculate the maximum fixed fee that an Offeror may propose for subsequent task orders. Offerors may always bid less than the calculated maximum for subsequent task orders. |
| (4) Fixed fee - Schedule 2 - shall be calculated using these percentages. |
| (5) Profit - Schedule 3 - shall be calculated using these percentages. |
&"Times New Roman,Bold"ATTACHMENT J.8 &"Times New Roman,Bold"MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES &"Times New Roman,Bold"DTRT5716R20001
Schedule 7
| SCHEDULE 7 |
| TABLE OF SUBCONTRACTORS |
Offeror or Subcontractor Name: _________________________________________________________
| NOTE: The Offeror may add rows for additional subcontractors as required. The offeror is responsible for flowing this information through other |
| schedules and ensuring that formulas are adjusted to capture costs without changing the intent of the formulas. |
| Subcontractor Name | Subcontract Type (1) | Competitively Awarded? (Y/N) | No. of Proposals Received |
| Subcontractor A | | | | |
| Subcontractor B | | | | |
| Subcontractor C | | | | |
| Subcontractor D | | | | |
| (1) Subcontracts with subcontractors having an approved accounting system should be Cost Plus Fixed Fee or Firm Fixed Price. Subcontracts | | | | |
| with Subcontractors lacking an approved accounting system should be proposed as firm fixed price. Time and Materials subcontracts will only | | | | |
| be considered in limited circumstances and on a case-by-case basis. | | | | |
| Subcontract Value |
| Period 1 |
| Subcontractor A | $ - 0 |
| Subcontractor B | $ - 0 |
| Subcontractor C | $ - 0 |
| Subcontractor D | $ - 0 |
| Total | $ - 0 |
As stated at the top of Schedule 1, the Government anticipates that 90% of this effort will be issued as Task Orders on a Cost Plus Fixed Fee basis and the remaining 10% will be issued as Task Orders on a Firm Fixed Price basis. The table below apportions the extended labor cost between Cost Plus Fixed Fee and Firm Fixed Price work consistent with these percentages for entry into Schedules 2 and 3.
| COST PLUS FIXED FEE SUBCONTRACT ALLOCATION - 90% of Subcontractor Cost by Subcontractor (enter in Schedule 2) (1) | |
| Period 1 |
| Subcontractor A | $ - 0 |
| Subcontractor B | $ - 0 |
| Subcontractor C | $ - 0 |
| Subcontractor D | $ - 0 |
| FIRM FIXED PRICE SUBCONTRACT ALLOCATION - 10% of Subcontractor Cost by Subcontractor (enter in Schedule 3) (1) | |
| Period 1 |
| Subcontractor A | $ - 0 |
| Subcontractor B | $ - 0 |
| Subcontractor C | $ - 0 |
| Subcontractor D | $ - 0 |
| (1) 90% of the total value of subcontractors goes to schedule 2 and 10% to Schedule 3. | |
&"Times New Roman,Bold"ATTACHMENT J.8 &"Times New Roman,Bold"MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES &"Times New Roman,Bold"DTRT5716R20001
Schedule 8
| SCHEDULE 8 |
| BREAKDOWN OF LABOR HOURS BETWEEN OFFEROR AND SUBCONTRACTORS |
Offeror or Subcontractor Name: _________________________________________________________
| The purpose of this Schedule is to verify that all labor hours are accounted for between the the Offeror's and all Subcontractors' proposals. |
| This schedule may not be used as a substitute for the Limitation on Subcontracting calculation. |
| Labor In Hours | | | | | | |
| Offeror (1) | Sub A | Sub B | Sub C | Sub D | Total Sub | RFP Total (Offeror + All Subs) |
| Senior Staff | | | | | | 0.00 | 0.00 |
| Middle Staff | | | | | | 0.00 | 0.00 |
| Staff | | | | | | 0.00 | 0.00 |
| Junior Staff | | | | | | 0.00 | 0.00 |
| Senior Technician | | | | | | 0.00 | 0.00 |
| Technician | | | | | | 0.00 | 0.00 |
| Administrative Staff (Specify) | | | | | | 0.00 | 0.00 |
| Total Hours | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| (1) Totals must reconcile with Schedule 4 | | | | | | | |
| Direct Labor in Dollars | | | |
| Sub A | Sub B | Sub C | Sub D |
| Direct Labor Value | $ | $ | $ | $ |
&"Times New Roman,Bold"ATTACHMENT J.8 &"Times New Roman,Bold"MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES &"Times New Roman,Bold"DTRT5716R20001
Schedule 9
| SCHEDULE 9 |
| SCHEDULE OF OFFEROR PROPOSED OTHER DIRECT COSTS (ODCs) |
Offeror or Subcontractor Name: _________________________________________________________
| Offeror-Proposed ODC Value | |
| Name/Description of ODC | Period 1 | Total ODC Value |
| Total ODCs by Period | $ - 0 | $ - 0 |
| (1) The Offeror shall NOT include in its proposal travel, software licenses, cellular phones or any other costs for which an estimate has already been provided by the Government as a Request for Proposal (RFP)-stipulated ODC. See Section L, para L.6.II.2(h) of the RFP. | | |
| Period 1 |
| COST PLUS FIXED FEE ODC ALLOCATION - 90% of ODCs by Period (enter in Schedule 2) | $ - 0 |
| FIRM FIXED PRICE ODC ALLOCATION - 10% of ODC by Period (enter in Schedule 3) | $ - 0 |
| (1) The Offeror must clearly identify the different types of direct costs in accordance with its established accounting practice and provide the basis and | |
| or supporting documentation for of the cost estimate. The Offeror is discouraged from using “miscellaneous” to categorize ODCs but may do so | |
| provided the nature of the cost is identified and the amount is relatively insignificant. During task order performance, only those costs identified by the | |
| Offeror in its proposal shall be billable. ODCs that are not identified in the Offeror’s proposal must be approved by the CO before they are incurred | |
| and billed to the Government. | |
&"Times New Roman,Bold"ATTACHMENT J.8 &"Times New Roman,Bold"MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES &"Times New Roman,Bold"DTRT5716R20001
Schedule 10
| SCHEDULE 10 |
| RESUME CHECKLIST AND LABOR COST REALISM |
Offeror or Subcontractor Name: _________________________________________________________
Labor Category (from Schedule 4) No. of Resumes
| Labor Category | Resumed Person's Name (1) | Company Affiliation (Offeror's or Subcontractor's Name) | Actual Current Labor Rate from Payroll Records (2) | Period 1 Unburdened Labor Rate (from Schedule 4, table B, column B) |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| | | $ - 0 | $ - 0 |
| (1) The Offeror may modify the schedule to include additional rows if additional Key Personnel are proposed. | | | | |
| (2) If the current labor rate for the person whose resume is submitted is more than 5% higher than the Schedule 5 labor rate for that category, explain why the proposed labor rate for the labor category is still realistic. | | | | |
| &"Times New Roman,Bold"ATTACHMENT J.8 | &"Times New Roman,Bold"MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES |
| &"Times New Roman,Bold"DTRT5716R20001 |