The file's text, extracted by GovTribe without its formatting.
Instructions for Proposal Cost Template in Response to Request for Proposal HSBP1015R0040
1. General Approach: The Proposal Cost Template Excel workbook consists of 33 tabs or worksheets. Offeror data or input is required in 23 of the tabs and is calculated and linked to 9 tabs and one other tab required no input.
2. Offeror data: Offeror data or input will include the information necessary to complete the Proposal Cost Template. Data will include Labor Categories and related Labor Rates, Units for Activity, Number of Activities, Travel Time per Activity, Materials, Subcontract and related Unit Rates, Equipment and related Unit Rates, and Other Direct Costs, as appropriate. In order to facilitate government analysis, offerors shall not lock cells containing offeror data.
3. Government Links and Formulas: The government uses links and formulas to calculate and combine amounts, as appropriate.
4. Definitions: Key definitions are provided below.
| Tab Name |
| Related Meanings |
| L&E |
| Lighting and Electrical |
| V&D |
| Vegetation Control and Debris Removal |
| Column Heading |
| Related Meanings |
| Units of Activity |
| “Units of Activity” varies depending upon the location in the spreadsheet. In the labor category, “Units of Activity” refers to labor hours to accomplish the work activity described in the Sample Work Plan; in the materials category, it refers to the quantity of material needed to accomplish the work activity, and in the equipment category it refers to the number of pieces of equipment need to accomplish the work activity. |
| Number of Activities |
| “Number of Activities” refers to the number of times the activity is to be accomplished as defined in the Sample Work Plan. |
| Travel Time per Activity |
| “Travel Time per Activity” is the travel hours as define in the Sample Work Plan |
5. Spreadsheet Tab Guide: Details concerning data entry are provided below.
| Summary Total Contract |
| 1. No data entry is required except for the G&A rate and profit/fee rate. Prime labor rates are burdened with fringe and overhead, so a separate fringe and overhead amounts were not required. |
2. Cell D62 contained the government provided amount of $750,000 for “(M) CLIN 9 - Improvement Activities”. The offeror shall not change this amount. The amount includes all indirects and profit. The amount is not escalated but remains the same in each of the option periods.
| CLINS 1-5 Totals |
| The offeror shall not provide input on this tab. |
| CLINS 1 Totals |
| The offeror shall not provide input on this tab. |
| CLINS 2 Totals |
| The offeror shall not provide input on this tab. |
| CLINS 3 Totals |
| The offeror shall not provide input on this tab. |
| CLINS 4 Totals |
| The offeror shall not provide input on this tab. |
| CLINS 5 Totals |
| The offeror shall not provide input on this tab. |
| Summary EPT |
| The offeror shall not provide input on this tab. |
| F&G EPT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. |
| F&G EPT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| R&B EPT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. |
| R&B EPT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| D&G EPT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. |
| D&G EPT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| L&E EPT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. |
| L&E EPT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| V&D EPT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. |
| V&D EPT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary EPT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| Summary BBT |
| The offeror shall not provide input on this tab. |
| F&G BBT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary BBT” tab. |
| F&G BBT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary BBT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| R&B BBT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary BBT” tab. |
| R&B BBT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary BBT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| D&G BBT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary BBT” tab. |
| D&G BBT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary BBT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| L&E BBT (No Requirement) |
| The offeror shall not provide input on this tab. |
| V&D BBT (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary BBT” tab. |
| V&D BBT (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary BBT” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| Urgent Requirements (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary Total Contract” tab. |
| Urgent Req (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary Total Contract” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| Program Management (Prime) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary Total Contract” tab. |
| Program Mgt (Subcontractor) |
| The offeror shall provide input only in the cell shaded in yellow. If the offeror finds it necessary to “insert” additional rows in any tables or additional sheets for additional subcontractors, the offeror is responsible to make the appropriate formula and link adjustments to insure the subtotals and totals are correct within the tab and that the totals link appropriately to the “Summary Total Contract” tab. Note that the subcontractor total includes total price (fully burdened with profit/fee). |
| Wage Labor Rates |
| The purpose of this tab is to allow the offeror to display the base pay and components of pay that lead to the “wage labor rate(s)” used in other parts of the proposal cost template. Also, the offeror may choose the alter some of the suggested headings for the components of the “buildup” of the wage labor rates. However, each wage labor rate used in the template must be detailed in this table. The offeror may “insert” additional rows or columns in any tables as appropriate. The offeror is responsible to make the appropriate formula and link adjustments to insure the links to other tabs or worksheets are appropriate. |