Attachment J.5 - Task Order 1 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 to a federal contract opportunity, specifically the "Army Financial Improvement (AFI) Program Support Services" solicitation (W91CRB-21-R-0049).
The attachment provides a price model and instructions for offerors to submit pricing for a single-award IDIQ contract with a $249,999,999.99 ceiling. The contract will include a 90-day transition-in period and task orders issued on a Firm Fixed Price (FFP) and/or Time and Materials (T&M) basis. The performance period is anticipated to be February 2025 through February 2028. Key requirements include providing the Army with professional federal accounting and auditing solutions, as well as change management support, to assist the Army in achieving an unmodified audit opinion on its financial statements. Offerors must submit proposals by October 1, 2024. The solicitation is being issued by the Department of the Army Materiel Command, Army Contracting Command Aberdeen Proving Ground.
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
| Task Order CLINs | ||
| (Notional) | CLIN Description | Total Pricing |
Task Order 0001 (12 Months)
| CLIN 0001 | Key Personnel Labor (FFP) | $0.00 |
| CLIN 0002 | Non-Key Labor (T&M) | $0.00 |
| CLIN 0002 | Travel/ODCs (Normalized, T&M) | $645,769.99 |
| CLIN 0003 | CMR | NSP |
| CLIN 0004 | CDRLs | NSP |
| CLIN 0005 | Transition-In (90 Days) | $0.00 |
| Contract Total Ceiling w/Transition-In: | $645,769.99 |
Contract Total less Transition-In $645,769.99
| Total indirect rate (Material Handling, G&A, etc) on Travel/ODCs | 0% |
| Actual Travel Amount Available for Contract Support | $ 645,769.99 |
| 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) Offerors shall input the proposed fully burdened labor rates in the yellow highlighted fields. Task Order labor rates shall not exceed proposed base IDIQ rates. |
| 4) One (1) Full Time Equivilent (FTE) for 12 months 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 Task Order 0001 Key Pers. FFP (9 Months) | Full Performance Ordering Period | ||
| Year 2 (12 Months) | Full Performance Ordering Period | ||
| Year 3 (12 Months) | Total |
Task Order 0001 Key Pers. FFP
| 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 | 6.00 | 8,604.00 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 6.00 | 8,604.00 | $0.00 | |
| Technical Directors | 1.00 | 1,434.00 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 1.00 | 1,434.00 | $0.00 | |
| Team Leads | 12.00 | 17,208.00 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 12.00 | 17,208.00 | $0.00 | |
| $0.00 | $0.00 | $0.00 | - 0 | - 0 | $0.00 | |||||||||||||
| 19.00 | 27,246.00 | $0.00 | 0.00 | - 0 | $0.00 | 0.00 | - 0 | $0.00 | 19.00 | 27,246.00 | $0.00 |
Non-Key T&M
| Instructions: |
| 1) Offerors shall provide inputs in the yellow shaded areas. |
| 2) Offerors shall input the proposed fully burdened labor rates in the yellow highlighted fields. Task Order labor rates shall not exceed proposed base IDIQ rates. |
| 3) One (1) Full Time Equivilent (FTE) for 12 months 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 Non-Key T&M | |||
| Task Order 0001 (9 months) | Full Performance Ordering Period | ||
| Year 2 (12 months) | Full Performance Ordering Period | ||
| Year 3 (12 months) | Total |
Task Order 0001 Non-Key T&M
| 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 | 32.55 | 46,677.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 32.55 | 46,677.00 | $0.00 | |
| Managers | 81.38 | 116,693.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 81.38 | 116,693.00 | $0.00 | |
| Senior Consultants | 162.75 | 233,386.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 162.75 | 233,386.00 | $0.00 | |
| Consultants | 203.44 | 291,733.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 203.44 | 291,733.00 | $0.00 | |
| Research Assistants | 73.24 | 105,024.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 73.24 | 105,024.00 | $0.00 | |
| Subject Matter Expert II | 24.41 | 35,008.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 24.41 | 35,008.00 | $0.00 | |
| Subject Matter Expert I | 32.55 | 46,677.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 32.55 | 46,677.00 | $0.00 | |
| Senior Inventory Analysts | 88.39 | 126,754.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 88.39 | 126,754.00 | $0.00 | |
| Inventory Analysts | 85.67 | 122,846.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 85.67 | 122,846.00 | $0.00 | |
| 0.00 | $0.00 | 0.00 | $0.00 | 0.00 | $0.00 | - 0 | - 0 | $0.00 | |||||||||
| 784.38 | 1,124,798.00 | $0.00 | - 0 | - 0 | $0.00 | - 0 | - 0 | $0.00 | 784.38 | 1,124,798.00 | $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 .