MPE-S_RFP_Attachment_7_QA_v3.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Mission Partner Environment Services (MPE-S)
- Solicitation number
- HC1047-18-R-4012
- Issued by
-
Defense Information Systems Agency
About this file
This document contains a question and answer file related to a solicitation for Mission Partner Environment Services (MPE-S). The Defense Information Systems Agency (DISA) intends to issue a solicitation for an Indefinite Delivery, Indefinite Quantity contract to provide services to design, implement, and operate the MPE enterprise. Services will include capabilities analysis, engineering, software development, program management, logistics, testing, and associated supplies to support the MPE-Information System and legacy systems. The contract will have one 5-year ordering period with firm-fixed-price and cost-plus-fixed-fee contract line items as well as cost reimbursable items for other direct costs and travel. The solicitation is anticipated for release in July 2018 with an expected award by the fourth quarter of 2018. The document addresses questions from potential offerors regarding corrections to formulas in pricing templates to ensure accurate pricing.
Responses to Follow-up Questions for Clarification
View the file
Other files
Show all 21
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Q and A
| MPE-S HC1047-18-R-4012 | |
| ATTACHMENT 7 - QUESTION TEMPLATE | |
| Company Name: |
| Question # | Questions / Comments | RFP Reference | Government Response | RFP Change Required (Y/N) | Location of Change | |
| 1 | The Government has a hardcoded value of $50.00 in CY1, Cell AB36, when it should be a sum formula for this task area. | |||||
| a. | Correct formula - =SUM(AB5:AB34) |
We understand the offeror is not permitted to change any formulas to the Goverment provided pricing spreadsheet
| Question: Would the Government please correct CY1 Cell AB36 and provide a revised pricing spreadsheet with the corrected formula in CY 1 Cell AB36? | Amend 0002 Attachment 06 Cost and Pricing Template | Please see the updated template. The template instructions have been changed to allow for formulas to be corrrected. | Y | Attachment 06 Cost and Pricing Template | ||
| 2 | The government formula on worksheet CY5, cell Q90 is incorrect. As 6.1.3, Subtask 3- Monthly IDIQ Contractor Performance Report is an firm fixed price (FFP) CLIN, fee should not be calculated in Q90. | |||||
| Question: Will the government please update the Attachment 6 to amend this error by removing the fixed fee formula in CY5 Cell Q90 as offerors are instructed not to modify the government provided formulas? | Amend 0002 Attachment 06 Cost and Pricing Template | Please see the updated template. The template instructions have been changed to allow for formulas to be corrrected. | Y | Attachment 06 Cost and Pricing Template | ||
| 3 | The government provided formula for the prime labor in the 6 month option column of the Total Price Rollup worksheet is incorrect. | |||||
| a. | The current formula is written as ='6 Month Extension Option'!W40+'6 Month Extension Option'!BQ40. | |||||
| b. | When you trace back the precedents to cells W40 and BQ40 of the 6 Month Extension Option worksheet, these cells are blank. | |||||
| c. | The correct formula for totaling the prime labor in the 6 month extension option for prime labor on the Total Price Rollup worksheet should be written as ='6 Month Extension Option'!W42+'6 Month Extension Option'!BQ42. | |||||
| d. | Question – Will the government please update the formula in Attachment 6 to fix this formula error as offeror’s are instructed not to adjust the government formulas. | Amend 0002 Attachment 06 Cost and Pricing Template | Please see the updated template. The template instructions have been changed to allow for formulas to be corrrected. | Y | Attachment 06 Cost and Pricing Template | |
| 4 | The government provided formula in cell G11 of the Total Proposed Price FFP in the 6 Month Option column of the Total Price Rollup worksheet is incorrect. | |||||
| a. | The current formula is written as ='6 Month Extension Option'!$W$90+'6 Month Extension Option'!$BQ$90 | |||||
| b. | The correct formula for totaling the Total Proposed Price FFP should be written as ='6 Month Extension Option'!$W$92+'6 Month Extension Option'!$BQ$92 | |||||
| c. | Question – Will the government please update the formula in Attachment 6 to fix this formula error as offeror’s are instructed not to adjust the government formulas? | Amend 0002 Attachment 06 Cost and Pricing Template | Please see the updated template. The template instructions have been changed to allow for formulas to be corrrected. | Y | Attachment 06 Cost and Pricing Template | |
| 5 | The government provided formula on worksheet 6 Month Extension Option, cell Q90 is incorrect. As 6.1.3, Subtask 3- Monthly IDIQ Contractor Performance Report is an firm fixed price (FFP) CLIN, fee should not be calculated in Q90. | |||||
| a. | Question - Will the government please update the formula in Attachment 6 to fix this formula error as offeror’s are instructed not to adjust the government provided formulas? | Amend 0002 Attachment 06 Cost and Pricing Template | Please see the updated template. The template instructions have been changed to allow for formulas to be corrrected. | Y | Attachment 06 Cost and Pricing Template | |
| 6 | Will the government please explain why there are formulas in cells K4, K16, and K19 on the Total Price Rollup worksheet? | Amend 0002 Attachment 06 Cost and Pricing Template | Please see the updated template. The template instructions have been changed to allow for formulas to be corrrected. | Y | Attachment 06 Cost and Pricing Template | |
| 7 | The government provided travel plug figure for CY4 is entered in cell BM82 as $4,250,000,000.00. Under Section L.6.2.6 (page 19/20) the Option Year 3 ODC value is $4,250,000.00 |
Question – Will the government please confirm which value is correct? Amend 0002 Attachment 06 Cost and Pricing Template; L.6.2.6 Please see the updated template. The template instructions have been changed to allow for formulas to be corrrected. Y Attachment 06 Cost and Pricing Template
File details come from the government source that posted it. Updated .