Attachment J.4 - Base IDIQ Price Model - Updated 9.24.2024.xlsx
XLSX spreadsheet 34 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 appears to be an attachment titled "Attachment J.4 - Base IDIQ Price Model - Updated 9.24.2024.xlsx" related to a federal contract opportunity for the Army Financial Improvement (AFI) Program Support Services (Solicitation Number W91CRB-21-R-0049).
The attachment provides a pricing model template for an Indefinite Delivery/Indefinite Quantity (IDIQ) contract with a 3-year ordering period and a total ceiling value of $249,999,999.99. The contract will include Firm Fixed Price (FFP) and Time and Materials (T&M) CLINs for key personnel labor, non-key labor, travel/ODCs, contract management reporting, contract data requirements lists, and transition-in services. Offerors are instructed to provide pricing inputs in the designated yellow cells. The related federal contract opportunity is an open competition for professional federal accounting, auditing, and change management support services to assist the Army in achieving an unmodified audit opinion.
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 ("Status") - FOR KEY PERSONNEL ONLY - indicate whether personnel are Current employees with a "C", New Hires with a "N." |
| 3) For each year, offerors shall input the proposed fully burdened labor rates in the yellow highlighted fields. |
| 4) One (1) Full Time Equivilent (FTE) equals 1,912 hours. One (1) FTE for 9 months equals 1,434 hours, as captured below. Do not deviate. |
| 5) Note: The Base Period hours are based on a full level of effort after the Transition-in is completed. |
| 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) | Status | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Escalation | Rate $ | Total | FTE | Total Hours | Escalation | Rate $ | Total | FTE | Hours | Price |
| Program Managers | 3.21 | 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 | 9.64 | 16,898.75 | $0.00 | |
| Technical Directors | 9.34 | 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 | 28.01 | 49,090.25 | $0.00 | |
| Team Leads | 30.72 | 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 | 92.15 | 161,502.00 | $0.00 | |
| $0.00 | $0.00 | $0.00 | - 0 | - 0 | $0.00 | |||||||||||||
| 43.27 | 62,043.00 | $0.00 | 43.27 | 82,724.00 | $0.00 | 43.27 | 82,724.00 | $0.00 | 129.80 | 227,491.00 | $0.00 |
Non-Key T&M
| Instructions: |
| 1) Offerors shall provide inputs in the yellow shaded areas. |
| 2) For each year, offerors shall input the proposed fully burdened labor rates in the yellow highlighted fields. |
| 3) One (1) Full Time Equivilent (FTE) equals 1,912 hours. One (1) FTE for 9 months equals 1,434 hours, as captured below. Do not deviate. |
| 4) Note: The Base Period hours are based on a full level of effort after the Transition-in is completed. |
| 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) | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Escalation | Rate $ | Total | FTE | Total Hours | Escalation | Rate $ | Total | FTE | Hours | Price |
| Senior Managers | 18.67 | 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 | 56.02 | 98,177.75 | $0.00 |
| Managers | 42.76 | 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 | 128.28 | 224,823.50 | $0.00 |
| Senior Consultants | 86.56 | 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 | 259.69 | 455,144.25 | $0.00 |
| Consultants | 106.63 | 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 | 319.90 | 560,681.00 | $0.00 |
| Research Assistants | 38.74 | 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 | 116.23 | 203,714.50 | $0.00 |
| Subject Matter Expert II | 14.66 | 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 | 43.97 | 77,071.50 | $0.00 |
| Subject Matter Expert I | 18.67 | 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 | 56.02 | 98,177.75 | $0.00 |
| Senior Inventory Analysts | 68.91 | 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 | 206.73 | 362,323.50 | $0.00 |
| Inventory Analysts | 66.87 | 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 | 200.60 | 351,576.50 | $0.00 |
| 0.00 | $0.00 | 0.00 | $0.00 | 0.00 | $0.00 | - 0 | - 0 | $0.00 | |||||||||
| 462.47 | 663,188.25 | $0.00 | 462.47 | 884,251.00 | $0.00 | 462.47 | 884,251.00 | $0.00 | 1,387.42 | 2,431,690.25 | $0.00 |
Transition-In Price FFP
| Instructions: | |||||
| 1) Offerors shall provide inputs in the yellow shaded areas. | |||||
| 2) Column C ("Status") - FOR KEY PERSONNEL ONLY - indicate whether personnel are Current employee's with a "C", New Hires with a "N." | |||||
| 3) Column D ("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. | |||||
| 4) 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. | |||||
| 5) The information for transition-in shall be the same on both Attachments J.4 and J.5. See answer to question 42 on industry question and answer document. | |||||
| Transition-In Price (90 Days) | |||||
| PWS Labor Categories^ | Key | Status | Hours | Rate $ | Total |
| Program Manager | * | 2868 | $0.00 | $0.00 | |
| Technical Director | * | 478 | $0.00 | $0.00 | |
| Senior Manager | $0.00 | $0.00 | |||
| Team Lead | * | 5736 | $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 | |||
| Subject Matter Expert II | $0.00 | $0.00 | |||
| Subject Matter Expert I | $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 .