Attachment J.4 - Base IDIQ Price Model.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- Army Financial Improvement (AFI) Program Support Services Federal contract opportunity
- Solicitation number
- W91CRB-21-R-0049
About this file
This document is an Excel pricing template for the Army Financial Improvement (AFI) Program Support Services contract solicitation (W91CRB-21-R-0049). The solicitation is for a single award, indefinite-delivery/indefinite-quantity (IDIQ) contract with a $249,999,999.99 ceiling over a 3-year ordering period. The contract will provide the Army with professional accounting, auditing, and change management support services to achieve an unmodified audit opinion.
The pricing template includes instructions and sections for offerors to propose Fixed-Price and Time-and-Materials pricing for key personnel, non-key personnel, and transition-in labor. The template specifies the labor categories, estimated hours, and location requirements. Offerors must provide fully burdened labor rates and total pricing. The travel and other direct costs are provided as a $1,888,057.07 ceiling amount. Proposals are due by 10:00AM ET on October 1, 2024.
View the file
Other files for this federal contract opportunity
Show all 14
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
Total Price Company Name: Date of Proposal
Solicitation: Army Financial Improvement (AFI) Program Support Services
W91CRB-21-R-0049
| IDIQ CLINs | ||
| (Notional) | CLIN Description | Total Pricing |
3 Year Ordering Period
| CLIN 0001 | Key Personnel Labor (FFP) | $0.00 |
| CLIN 0002 | Non-Key Labor (T&M) | $0.00 |
| CLIN 0002 | Travel/ODCs (Normalized, T&M) | $1,888,057.07 |
| CLIN 0003 | CMR | NSP |
| CLIN 0004 | CDRLs | NSP |
| CLIN 0005 | Transition-In (90 Days) | $0.00 |
| Contract Total Ceiling w/Transition-In: | $1,888,057.07 |
Contract Total less Transition-In $1,888,057.07
| Total indirect rate (Material Handling, G&A, etc) on Travel/ODCs | 0% |
| Actual Travel Amount Available for Contract Support | $ 1,888,057.07 |
| Instructions: |
| 1) Offerors shall provide inputs in the yellow shaded areas. |
| 2) Add your company name and date of proposal above. |
| 3) No change to the Travel & ODC amount. |
| 4) Insert Material Handling rate offeror will be applying to ODCs/Travel in yellow cell. If applying indirect burdens to Travel & ODC, the contractor shall include supporting documentation (FPRAs, Disclosure Statement, Historical actuals, Pro forma indirect build-ups, etc) as necessary to establish the proposed amounts to be fair and reasonable. |
| 5) Row 21 displays the calculated value representing the total budget available for Travel and ODC support less material handling and indirect costs - please do not edit. |
Key Personnel FFP
| Instructions: |
| 1) Offerors shall provide inputs in the yellow shaded areas. |
| 2) Column B ("Location") offerors shall input the location where the labor category will perform. Proposed location(s) shall comply with PWS requirements. |
| 3) Column C ("Contractor's Title/Position") - Input your organizations Labor Categories Title/Position if different from the Government provided LCAT title. These shall be similar labor categories that match or exceed the Education and Experience requirements in the PWS. |
| 4) Column D ("Prime/Sub") - indicate "P" for Prime and "S" for Subcontractor personnel. |
| 5) Column E ("Status") - indicate whether personnel are Current employees with a "C", New Hires with a "N", or Incumbent Personnel with an "I". |
| 6) For each year, offerors shall input the proposed fully burdened labor rates in the yellow highlighted fields. |
| 7) One (1) Full Time Equivilent (FTE) equals 1,912 hours. Do not deviate. |
| 8) Note: The Base Period hours are based on a full level of effort after the Transition-in is completed. |
| 9) Column A contains several labor categories. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the hours for the individual category and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours provided by the Govt for the respective labor category. |
| Full Performance Ordering Period | |||
| Base Period (9 Months) | Full Performance Ordering Period | ||
| Year 2 (12 Months) | Full Performance Ordering Period | ||
| Year 3 (12 Months) | Total |
2 years, 9 months Full Performance Ordering Period
| PWS Labor Category (KEY PERSONNEL) | Location | Contractors Title/Position | Prime / Sub | Status | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Escalation | Rate $ | Total | FTE | Total Hours | Escalation | Rate $ | Total | FTE | Hours | Price |
| Program Managers | 2.41 | 4,608.75 | $0.00 | $0.00 | 3.21 | 6,145.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 3.21 | 6,145.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 8.84 | 16,898.75 | $0.00 | ||||
| Technical Directors | 7.00 | 13,388.25 | $0.00 | $0.00 | 9.34 | 17,851.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 9.34 | 17,851.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 25.67 | 49,090.25 | $0.00 | ||||
| Team Leads | 23.04 | 44,046.00 | $0.00 | $0.00 | 30.72 | 58,728.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 30.72 | 58,728.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 84.47 | 161,502.00 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | - 0 | - 0 | $0.00 | ||||||||||||||||
| 32.45 | 62,043.00 | $0.00 | 43.27 | 82,724.00 | $0.00 | 43.27 | 82,724.00 | $0.00 | 118.98 | 227,491.00 | $0.00 |
Non-Key T&M
| Instructions: |
| 1) Offerors shall provide inputs in the yellow shaded areas. |
| 2) Column B ("Location") offerors shall input the location where the labor category will perform. Proposed location(s) shall comply with PWS requirements. |
| 3) Column C ("Contractor's Title/Position") - Input your organizations Labor Categories Title/Position if different from the Government provided LCAT title. These shall be similar labor categories that match or exceed the Education and Experience requirements in the PWS. |
| 4) Column D ("Prime/Sub") - indicate "P" for Prime and "S" for Subcontractor personnel. |
| 5) Column E ("Status") - indicate whether personnel are Current employees with a "C", New Hires with a "N", or Incumbent Personnel with an "I". |
| 6) For each year, offerors shall input the proposed fully burdened labor rates in the yellow highlighted fields. |
| 7) One (1) Full Time Equivilent (FTE) equals 1,912 hours. Do not deviate. |
| 8) Note: The Base Period hours are based on a full level of effort after the Transition-in is completed. |
| 9) Column A contains several labor categories. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the hours for the individual category and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours provided by the Govt for the respective labor category. |
| Full Performance Ordering Period | |||
| Base Period (9 months) | Full Performance Ordering Period | ||
| Year 2 (12 months) | Full Performance Ordering Period | ||
| Year 3 (12 months) | Total |
2 years, 9 months Full Performance Ordering Period
| PWS Labor Category (Non-Key Personnel) | Location | Contractors Title/Position | Prime / Sub | Status | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Escalation | Rate $ | Total | FTE | Total Hours | Escalation | Rate $ | Total | FTE | Hours | Price |
| Senior Managers | 14.00 | 26,775.75 | $0.00 | $0.00 | 18.67 | 35,701.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 18.67 | 35,701.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 51.35 | 98,177.75 | $0.00 | ||||
| Managers | 32.07 | 61,315.50 | $0.00 | $0.00 | 42.76 | 81,754.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 42.76 | 81,754.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 117.59 | 224,823.50 | $0.00 | ||||
| Senior Consultants | 64.92 | 124,130.25 | $0.00 | $0.00 | 86.56 | 165,507.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 86.56 | 165,507.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 238.05 | 455,144.25 | $0.00 | ||||
| Consultants | 79.98 | 152,913.00 | $0.00 | $0.00 | 106.63 | 203,884.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 106.63 | 203,884.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 293.24 | 560,681.00 | $0.00 | ||||
| Research Assistants | 29.06 | 55,558.50 | $0.00 | $0.00 | 38.74 | 74,078.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 38.74 | 74,078.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 106.55 | 203,714.50 | $0.00 | ||||
| Sr. Topical Experts | 10.99 | 21,019.50 | $0.00 | $0.00 | 14.66 | 28,026.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 14.66 | 28,026.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 40.31 | 77,071.50 | $0.00 | ||||
| Jr. Topical Experts | 14.00 | 26,775.75 | $0.00 | $0.00 | 18.67 | 35,701.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 18.67 | 35,701.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 51.35 | 98,177.75 | $0.00 | ||||
| Senior Inventory Analysts | 51.68 | 98,815.50 | $0.00 | $0.00 | 68.91 | 131,754.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 68.91 | 131,754.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 189.50 | 362,323.50 | $0.00 | ||||
| Inventory Analysts | 50.15 | 95,884.50 | $0.00 | $0.00 | 66.87 | 127,846.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 66.87 | 127,846.00 | ERROR:#DIV/0! | $0.00 | $0.00 | 183.88 | 351,576.50 | $0.00 | ||||
| 0.00 | $0.00 | 0.00 | $0.00 | 0.00 | $0.00 | - 0 | - 0 | $0.00 | |||||||||||||
| 346.86 | 663,188.25 | $0.00 | 462.47 | 884,251.00 | $0.00 | 462.47 | 884,251.00 | $0.00 | 1,271.80 | 2,431,690.25 | $0.00 |
Transition-In Price FFP
| Instructions: | ||||||||
| 1) Offerors shall provide inputs in the yellow shaded areas. | ||||||||
| 2) Column B ("Location") offerors shall input the location where the labor category will perform. Proposed location(s) shall comply with PWS requirements. | ||||||||
| 3) Column C ("Contractor's Title/Position") - Input your organizations Labor Categories Title/Position if different from the Government provided LCAT title. These shall be similar labor categories that match or exceed the Education and Experience requirements in the PWS. | ||||||||
| 4) Column E ("Prime/Sub") - indicate "P" for Prime and "S" for Subcontractor personnel. | ||||||||
| 5) Column F ("Status") - indicate whether personnel are Current employee's with a "C", New Hires with a "N", or Incumbent Personnel with an "I". | ||||||||
| 6) Column G ("Hours") - offerors shall input their proposed hours for each labor category to successfully complete all Transition-In activities as required by the PWS in the yellow highlighted fields. | ||||||||
| 7) Note: Transition-in fully burdened labor rates automatically populate from the base period rates that offerors enter into the base period rate fields in the "Key Personnel FFP" and "Non-Key T&M" tabs. | ||||||||
| Transition-In Price (90 Days) | ||||||||
| PWS Labor Categories^ | Location | Contractors Title/Position | Key | Prime/Sub | Status | Hours | Rate $ | Total |
| Program Manager | * | $0.00 | $0.00 | |||||
| Technical Director | * | $0.00 | $0.00 | |||||
| Senior Manager | $0.00 | $0.00 | ||||||
| Team Lead | * | $0.00 | $0.00 | |||||
| Managers | $0.00 | $0.00 | ||||||
| Senior Consultant | $0.00 | $0.00 | ||||||
| Consultant | $0.00 | $0.00 | ||||||
| Research Assistant | $0.00 | $0.00 | ||||||
| Sr. Topical Expert | $0.00 | $0.00 | ||||||
| Jr. Topical Expert | $0.00 | $0.00 | ||||||
| Senior Inventory Analyst | $0.00 | $0.00 | ||||||
| Inventory Analyst | $0.00 | $0.00 | ||||||
| $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | |||||||
| ^Key positions marked in bold font with asterisk in column D | $0.00 |
File details come from the government source that posted it. Updated .