Attachment 6 - Price Schedule.xlsx
XLSX spreadsheet 98 KB Posted
- Solicitation number
- 47QFPA23K0020
About this file
This document appears to be a pricing template for a federal contract opportunity for Operational Support for the OPA Project ID# 47QFPA23K0020. The solicitation is being issued by the General Services Administration (GSA) Federal Acquisition Service Assisted Acquisition Services Region 9 on behalf of the Department of Defense's (DoD) Office of People Analytics (OPA).
The contract will provide specialized data collection support services to assist OPA's Centers for Health & Resilience and Retention & Readiness in conducting surveys, organizing, tabulating, and storing data to support personnel information needs of the Office of the Under Secretary of Defense for Personnel and Readiness. The pricing template includes labor categories, hours, and fully burdened labor rates for a 5-year base period plus a 6-month option period. Other direct costs for items like travel are also included. Offerors are instructed to fill out the pricing template, indicating if labor is being proposed by the prime contractor or a subcontractor. No other details about the solicitation requirements, schedule, or evaluation criteria are provided in this document.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_5_-_Question Response_4.18.2024_OPAresponse_clean (1).pdf | ||
| Amendment 0001 SF30.pdf | ||
| Attachment 2 - Commercial Model_Subk Plan- Apr 2024 - 508 Compliant (1).docx | DOCX document | |
| 47QFPA23K0020_RFP_OPA updated 24 April 20224 (1).docx | DOCX document | |
| Attachment 1 - Operations PWS_revised_18apr2024 (1).docx | DOCX document | |
| Attachment 2 - Commercial Model_Subk Plan-Jan 2023 - Final_508.docx | DOCX document | |
| Attachment 3 - Reference Information Sheet.docx | DOCX document | |
| Attachment 7 - Operations Personnel Requirements.xlsx | XLSX spreadsheet | |
| Attachment 5 - Question and Answers Template.docx | DOCX document | |
| Attachment 4 - QASP.docx | DOCX document | |
| Attachment 1 - Operations PWS.docx | DOCX document | |
| 47QFPA23K0020_RFP_OPA.docx | DOCX document |
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Flat Rate +.- Template
| New Cost | Old Cost | Delta | Delta Divided by 11 (Labor Categories) |
| $ 3,710,879.63 | $ 457,536.24 | $ 3,253,343.39 | $ 295,758.49 |
| New Hours | Weight | Rate | Total | Savings | New Total |
| 1447 | 7.8% | $ 237.21 | $ 47,442.45 | $ (295,758.49) | $ 343,200.94 |
| 1865 | 7.8% | $ 177.59 | $ 35,518.81 | $ (295,758.49) | $ 331,277.30 |
| 1951 | 7.8% | $ 164.20 | $ 24,630.07 | $ (295,758.49) | $ 320,388.56 |
| 2898 | 9.4% | $ 109.60 | $ 21,920.41 | $ (295,758.49) | $ 317,678.90 |
| 2081 | 20.3% | $ 187.03 | $ 93,512.90 | $ (295,758.49) | $ 389,271.39 |
| 2093 | 10.9% | $ 160.52 | $ 40,130.02 | $ (295,758.49) | $ 335,888.51 |
| 2125 | 9.4% | $ 149.78 | $ 22,467.41 | $ (295,758.49) | $ 318,225.90 |
| 1790 | 7.8% | $ 219.90 | $ 97,856.35 | $ (295,758.49) | $ 393,614.84 |
| 3086 | 6.2% | $ 106.17 | $ 31,850.77 | $ (295,758.49) | $ 327,609.26 |
| 4063 | 6.2% | $ 78.61 | $ 23,581.66 | $ (295,758.49) | $ 319,340.15 |
| 7326 | 6.3% | $ 42.92 | $ 18,625.39 | $ (295,758.49) | $ 314,383.88 |
| 30724 | $ 457,536.24 | $ (3,253,343.39) | $ 753,294.73 | ||
| $ 3,253,343.39 | |||||
| Remaining | $ 6,506,686.79 | 60000 |
Instructions
| 47QFPA23K0020 RFP Exhibit A - INSTRUCTIONS TO OFFERORS | |
| 1 | General Instructions: |
| 2 | Insert Offeror Name |
| 3 | Fill out all applicable cells on all tabs of this Excel workbook. |
| 4 | Include all applicable prices and costs for the IDIQ contract on the Price Input Tab, including both prime and suboffer (subcontract) amounts. |
| Ensure all formulas are functional on the proposal submission. |
| 1 | IDIQ Price Input Tab Instructions: |
| 2 | Column B - If offeror nomenclature differs from Government provided labor category name, add offeror's equivalent or alternative name for each Government provided labor category. Otherwise, leave blank. |
| 3 | Column C- Indicate if information in this row will be for the prime contractor or a subcontractor. Provide subcontractor name if applicable. |
| 4 | Columns D, H, L, P, T, X - Enter a fully burdened labor rate for each labor category. If proposing subcontractor labor, a separate fully burdened labor rate may be proposed that differs from the rate proposed for prime contractor labor. Provide labor rates that are fair, reasonable, and realistic for the work to be accomplished in the PWS. |
| 5 | If proposing to add indirect burdens to the Government's other direct cost or travel estimate for the IDIQ contract, provide a description of the burden type, applicable rate, and amount for each type of indirect burden in the price narrative, not in this spreadsheet. |
| 6 | Enter any escalation rate used or applied to develop option year labor rates in row 39. |
| 7 | Do not edit Column A labor categories, labor hours per labor category, total labor hours per year, or other direct cost amounts. These are provided for proposal consistency purposes and to help develop realistic maximum IDIQ contract amounts. |
Price Input
| Input in Bright Yellow Cells ONLY | Year 1: 12 Months | Year 2: 12 Months | Year 3: 12 Months | Year 4: 12 Months | Year 5: 12 Months | Option to Extend Services: 6 Months | ||||||||||||||
| Labor Category | Provide offeror's equivalent or alternate LCAT name (if different than LCAT Name in Column A, otherwise leave blank) | Indicate if labor proposed is from prime or subofferor (sub) (If sub, also include name of sub) | Hours | Fully Burdened Labor Rate | Total | Hours | Fully Burdened Labor Rate | Total | Hours | Fully Burdened Labor Rate | Total | Hours | Fully Burdened Labor Rate | Total | Hours | Fully Burdened Labor Rate | Total | Hours | Fully Burdened Labor Rate | Total |
| Sr. Program Manager | 4,508 | $0.00 | 4,686 | $0.00 | 4,815 | $0.00 | 4,866 | $0.00 | 4,883 | $0.00 | 2,442 | $0.00 | $0.00 | |||||||
| Sr. Project Manager | 4,875 | $0.00 | 4,771 | $0.00 | 4,865 | $0.00 | 4,864 | $0.00 | 5,058 | $0.00 | 2,529 | $0.00 | $0.00 | |||||||
| Intermediate Project Manager | 4,841 | $0.00 | 5,035 | $0.00 | 5,240 | $0.00 | 5,146 | $0.00 | 5,179 | $0.00 | 2,590 | $0.00 | $0.00 | |||||||
| Support Specialist | 8,328 | $0.00 | 8,852 | $0.00 | 8,335 | $0.00 | 8,542 | $0.00 | 8,426 | $0.00 | 4,213 | $0.00 | $0.00 | |||||||
| Sr Software Developer | 12,128 | $0.00 | 11,312 | $0.00 | 11,043 | $0.00 | 11,157 | $0.00 | 10,896 | $0.00 | 5,448 | $0.00 | $0.00 | |||||||
| Intermediate Software Developer | 10,142 | $0.00 | 9,468 | $0.00 | 9,380 | $0.00 | 9,693 | $0.00 | 9,904 | $0.00 | 4,952 | $0.00 | $0.00 | |||||||
| Data Analyst | 4,421 | $0.00 | 4,912 | $0.00 | 4,749 | $0.00 | 4,904 | $0.00 | 4,815 | $0.00 | 2,408 | $0.00 | $0.00 | |||||||
| Operations Manager | 4,348 | $0.00 | 4,851 | $0.00 | 5,507 | $0.00 | 6,378 | $0.00 | 7,028 | $0.00 | 3,514 | $0.00 | $0.00 | |||||||
| Sr. Operations Specialist | 6,076 | $0.00 | 6,845 | $0.00 | 7,032 | $0.00 | 6,882 | $0.00 | 6,898 | $0.00 | 3,449 | $0.00 | $0.00 | |||||||
| Operations Specialist | 7,163 | $0.00 | 7,703 | $0.00 | 8,490 | $0.00 | 7,753 | $0.00 | 8,286 | $0.00 | 4,143 | $0.00 | $0.00 | |||||||
| Operations Clerk | 9,935 | $0.00 | 11,071 | $0.00 | 12,295 | $0.00 | 11,964 | $0.00 | 12,730 | $0.00 | 6,365 | $0.00 | $0.00 |
Labor Total 76,765 $0.00 79,506 $0.00 81,751 $0.00 82,149 $0.00 84,103 $0.00 42,052 $0.00
| Other Direct Costs (ODCs) | $1,600,033.00 | $1,582,041.50 | $1,550,049.03 | $1,586,044.08 | $1,552,546.82 | $776,273.41 |
| Mailings, letters, paper surveys, etc. |
Travel $15,023.00 $15,000.00 $15,039.83 $15,034.17 $15,015.76 $7,507.88
| ODC/Travel Subtotal | $1,615,056.00 | $1,597,041.50 | $1,565,088.86 | $1,601,078.25 | $1,567,562.58 | $783,781.29 |
| Period Total | $1,615,056.00 | $1,597,041.50 | $1,565,088.86 | $1,601,078.25 | $1,567,562.58 | $783,781.29 |
| Cumulative TOTAL | $1,615,056.00 | $3,212,097.50 | $4,777,186.36 | $6,378,264.61 | $7,945,827.19 | $8,729,608.48 |
Indicate Any Escalation Rate (Esc.) applied to labor rates from one year to the next in this row as a percentage (example: 2.0%) Esc. Rate year 1 Esc. Rate year 2 Esc. Rate year 3 Esc. Rate year 4
File details come from the government source that posted it. Updated .