Attachment J.5 - Task Order 1 Price Model.xlsx
XLSX spreadsheet 36 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 model attachment for Task Order 1 under the Army Financial Improvement (AFI) Program Support Services indefinite-delivery/indefinite-quantity (IDIQ) contract, Solicitation Number W91CRB-21-R-0049.
The pricing model includes instructions and yellow-shaded input cells for offerors to propose pricing for key personnel on a firm-fixed-price basis, non-key personnel on a time-and-materials basis, and transition-in pricing. The contract has a total ceiling value of $649,769.99 over the base 12-month ordering period, including a 90-day transition-in period. Proposed labor rates shall not exceed those offered under the base IDIQ contract. The government-provided labor categories and hours must be used. The pricing model also includes instructions for offerors to provide supporting documentation for proposed indirect rates on travel and other direct costs.
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 ("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) 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. |
| 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 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) | 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 | 3.26 | 6,225.75 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 3.26 | 6,225.75 | $0.00 | ||||
| Technical Directors | 10.14 | 19,379.25 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 10.14 | 19,379.25 | $0.00 | ||||
| Team Leads | 34.00 | 65,013.75 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 34.00 | 65,013.75 | $0.00 | ||||
| $0.00 | $0.00 | $0.00 | - 0 | - 0 | $0.00 | ||||||||||||||||
| 47.39 | 90,618.75 | $0.00 | 0.00 | - 0 | $0.00 | 0.00 | - 0 | $0.00 | 47.39 | 90,618.75 | $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) 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. |
| 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 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) | 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 | 20.27 | 38,757.75 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 20.27 | 38,757.75 | $0.00 | ||||
| Managers | 47.74 | 91,269.75 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 47.74 | 91,269.75 | $0.00 | ||||
| Senior Consultants | 93.51 | 178,789.50 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 93.51 | 178,789.50 | $0.00 | ||||
| Consultants | 116.40 | 222,549.75 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 116.40 | 222,549.75 | $0.00 | ||||
| Research Assistants | 43.16 | 82,518.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 | 43.16 | 82,518.00 | $0.00 | ||||
| Sr. Topical Experts | 15.69 | 30,006.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 | 15.69 | 30,006.00 | $0.00 | ||||
| Jr. Topical Experts | 20.27 | 38,757.75 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 20.27 | 38,757.75 | $0.00 | ||||
| Senior Inventory Analysts | 51.68 | 98,815.50 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 51.68 | 98,815.50 | $0.00 | ||||
| Inventory Analysts | 50.15 | 95,884.50 | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 0.00 | - 0 | ERROR:#DIV/0! | $0.00 | $0.00 | 50.15 | 95,884.50 | $0.00 | ||||
| 0.00 | $0.00 | 0.00 | $0.00 | 0.00 | $0.00 | - 0 | - 0 | $0.00 | |||||||||||||
| 458.86 | 877,348.50 | $0.00 | - 0 | - 0 | $0.00 | - 0 | - 0 | $0.00 | 458.86 | 877,348.50 | $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 .