J.4 Price Proposal Model.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Army Audited Financial Statement Compilation and Publication Federal contract opportunity
- Solicitation number
- W91CRB24R0013
About this file
This document appears to be a Price Proposal Model spreadsheet related to a federal contract opportunity for Army Audit Financial Statement Compilation and Publication (Solicitation W91CRB-23-R-0032). The spreadsheet includes pricing for various contract line items (CLINs) across a base period and four option years, as well as a phase-in period. Key details include:
The contract requires the provision of quarterly financial statements for the Army General Fund and Army Working Capital Fund, as well as annual financial statement compilation and publication services for the consolidated financial statements of the U.S. Department of the Army General Fund, Army Working Capital Fund, and Army Corps of Engineers Civil Works. The total contract value is $302,500, with $55,000 allocated per year for the base period and each option year, and $27,500 for the 6-month Option to Extend Services period. The pricing model provides line items for labor, travel, and other direct costs, with the travel and ODC amounts fixed. No escalation is applied to the Option to Extend Services CLINs.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Solicitation_W91CRB24R0013_RFP Questions and Govt Response 2.pdf | ||
| Request for Proposal_W91CRB24R0013 AMENDMENT 1.pdf | ||
| J.4+Price+Proposal+Model AMENDMENT 1.xlsx | XLSX spreadsheet | |
| Solicitation_W91CRB24R0013_RFP Questions and Govt Response.pdf | ||
| J.5 - Government Furnished Property (GFP) Attachment.pdf | ||
| J.1 CDRL DD1423.5 A0017-A0020.pdf | ||
| J.1 CDRL DD1423.2 A0005-A0008.pdf | ||
| Question and Answers_Draft Solicitation_W91CRB24R0013.pdf | ||
| Request for Proposal_W91CRB24R0013.pdf | ||
| J.1 CDRL DD1423.4 A0013-A0016.pdf | ||
| J.1 CDRL DD1423.1 A0001-A0004.pdf | ||
| J.1 CDRL DD1423.6 A0021-A0024.pdf | ||
| J.3 Past Peformance Questionnaire (PPQ).pdf | ||
| J.2 - DD Form 254.pdf | ||
| J.1 CDRL DD1423.8 A0025-A0027.pdf | ||
| J.1 CDRL DD1423.3 A0009-A0012.pdf |
Show all 16
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 Audit Financial Statement Compilation and Publication W91CRB-23-R-0032
| CLINs (Notional) | Base Period | Opt 1 | Opt 2 | Opt 3 | Opt 4 | OES 52.217-8 | Contract Total | ||||||
| CLIN 0001 | Labor | $0.00 | CLIN 1001 | $0.00 | CLIN 2001 | $0.00 | CLIN 3001 | $0.00 | CLIN 4001 | $0.00 | CLIN 5001 | $0.00 | $0.00 |
| SubCLIN 000201 | Travel | $40,000.00 | SubCLIN 100201 | $40,000.00 | SubCLIN 200201 | $40,000.00 | SubCLIN 300201 | $40,000.00 | SubCLIN 400201 | $40,000.00 | SubCLIN 500201 | $20,000.00 | $220,000.00 |
| SubCLIN 000202 | ODC | $15,000.00 | SubCLIN 100202 | $15,000.00 | SubCLIN 200202 | $15,000.00 | SubCLIN 300202 | $15,000.00 | SubCLIN 400202 | $15,000.00 | SubCLIN 500202 | $7,500.00 | $82,500.00 |
| CLIN 0003 | CMR | NSP | CLIN 1003 | NSP | CLIN 2003 | NSP | CLIN 3003 | NSP | CLIN 4003 | NSP | CLIN 5003 | NSP | NSP |
| CLIN 0004 | CDRLs | NSP | CLIN 1004 | NSP | CLIN 2004 | NSP | CLIN 3004 | NSP | CLIN 4004 | NSP | CLIN 5004 | NSP | NSP |
| CLIN 0005 | Phase In (30 Days) | $0.00 | NA | NA | NA | NA | NA | $0.00 | |||||
| Totals | $55,000.00 | $55,000.00 | $55,000.00 | $55,000.00 | $55,000.00 | $27,500.00 | $302,500.00 |
Contract Total without Phase In $302,500.00
Contract Total with Phase In $302,500.00
| Total indirect rate (Material Handling, G&A, etc) on Travel | 0% | 0% | 0% | 0% | 0% | 0% |
| Actual Travel Amount Available for Contract Support | $ 40,000.00 | $ 40,000.00 | $ 40,000.00 | $ 40,000.00 | $ 40,000.00 | $ 20,000.00 |
| Total indirect rate (Material Handling, G&A, etc) on ODCs | 0% | 0% | 0% | 0% | 0% | 0% |
| Actual ODC Amount Available for Contract Support | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 7,500.00 |
| 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 amounts. |
| 4) Insert Material Handling rate offeror will be applying to ODCs/Travel in yellow cells. 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) Rows 22 and 24 display calculated values representing the total budget available for Travel and ODC support less material handling and indirect costs - please do not edit. |
Contract Yr Pricing
| Instructions: |
| 1) Offerors shall provide inputs in the yellow shaded areas. |
| 2) 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. |
| 3) Column E ("Prime/Sub") - indicate "P" for Prime and "S" for Subcontractor personnel. |
| 4) Column F ("Status") - indicate whether personnel are Current employee's with a "C", New Hires with a "N", or Incumbent Personnel with an "I". |
| 5) For the Base and 4 Option Years input the proposed fully burdened labor rates. |
| 6) One (1) Full Time Equivilent (FTE) equals 1,980 hours. Do not deviate. |
| 7) Note: The Base Period hours are based on a full level of effort after the Phase in is completed. |
| 8) 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. |
9) Offerors shall not edit the OES CLIN inputs, which are calculated automatically based on other areas of the workbook/spreadsheet.
| Base Period (10 Months) | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | Option to Extend Services (OES) IAW FAR 52.217-8 | ||||||||||||||||||||||||
| 6-Month Optional Extension Period | |||||||||||||||||||||||||||||
| PWS Labor Category^ | Location | Contractors Title/Position | Key | Prime / Sub | Status | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Rate $ | Total | FTE | Total Hours | Rate $* | Total |
| Program Manager | * | 0.83 | 1,650 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 0.50 | 990 | $0.00 | $0.00 | ||||
| Subject Matter Expert (SME) General Fund Lead Accountant | * | 0.83 | 1,650 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 0.50 | 990 | $0.00 | $0.00 | ||||
| Subject Matter Expert (SME) Working Capital Fund Lead Accountant | * | 0.83 | 1,650 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 0.50 | 990 | $0.00 | $0.00 | ||||
| Senior Associates/Senior Accountants | 1.67 | 3,300 | $0.00 | $0.00 | 2.00 | 3,960 | $0.00 | $0.00 | 2.00 | 3,960 | $0.00 | $0.00 | 2.00 | 3,960 | $0.00 | $0.00 | 2.00 | 3,960 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | |||||
| Staff Accountants | 5.00 | 9,900 | $0.00 | $0.00 | 6.00 | 11,880 | $0.00 | $0.00 | 6.00 | 11,880 | $0.00 | $0.00 | 6.00 | 11,880 | $0.00 | $0.00 | 6.00 | 11,880 | $0.00 | $0.00 | 3.00 | 5,940 | $0.00 | $0.00 | |||||
| Professional Publisher | 0.28 | 550 | $0.00 | $0.00 | 0.33 | 660 | $0.00 | $0.00 | 0.33 | 660 | $0.00 | $0.00 | 0.33 | 660 | $0.00 | $0.00 | 0.33 | 660 | $0.00 | $0.00 | 0.17 | 330 | $0.00 | $0.00 | |||||
| Systems Application and Products (SAP) Expert (Senior Accountant/EDP Consultant/IT Specialist) | * | 0.83 | 1,650 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 1.00 | 1,980 | $0.00 | $0.00 | 0.50 | 990 | $0.00 | $0.00 | ||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | 0 | $0.00 | $0.00 | |||||||||||
| ^Key positions marked in bold font with asterisk in column D | Totals | 20,350 | $0.00 | 24,420 | $0.00 | 24,420 | $0.00 | 24,420 | $0.00 | 24,420 | $0.00 | 12,210 | $0.00 | ||||||||||||||||
| *No escalation on OES CLINs |
Phase In Price
| Instructions: | ||||||||
| 1) Offerors shall provide inputs in the yellow shaded areas. | ||||||||
| 2) 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. | ||||||||
| 3) Column E ("Prime/Sub") - indicate "P" for Prime and "S" for Subcontractor personnel. | ||||||||
| 4) Column F ("Status") - indicate whether personnel are Current employee's with a "C", New Hires with a "N", or Incumbent Personnel with an "I". | ||||||||
| Phase In Price (60 Day Phase-In) | ||||||||
| PWS Labor Category^ | Location | Contractors Title/Position | Key | Prime/Sub | Status | Hours | Rate $ | Total |
| Program Manager | * | 330 | $0.00 | $0.00 | ||||
| Subject Matter Expert (SME) General Fund Lead Accountant | * | 660 | $0.00 | $0.00 | ||||
| Subject Matter Expert (SME) Working Capital Fund Lead Accountant | * | 660 | $0.00 | $0.00 | ||||
| Senior Associates/Senior Accountants | 660 | $0.00 | $0.00 | |||||
| Staff Accountants | 1980 | $0.00 | $0.00 | |||||
| Professional Publisher | 110 | $0.00 | $0.00 | |||||
| Systems Application and Products (SAP) Expert (Senior Accountant/EDP Consultant/IT Specialist) | * | 330 | $0.00 | $0.00 | ||||
| $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | |||||||
| $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 .