Q A_16_July_2014.pdf

UNCLASSIFIED

7/16/2014, 2:59 PM

Comment

Number Document

Page/Section/

Paragraph Question/Comment Recommendation

Response Amendment

(Y/N)

185 Cost Volume Template

Based on our review of the Cost Volume Template in the Excel format that was provided by the Government in Offeror's Package, we have noted the following discrepancies: [Continuing in Questions 186 and 187]

1) In ALL 22 of the cost input sheet (e.g., "B - CLIN 0001 EMD CPIF "), cell K32 has an incorrect formula. (the formula should all be the same as in cell H32)

Noted. A new template will be posted on FBO

See FBO for updated template

186 Cost Volume Template

2) In the 'Total Amount' worksheet there are a number of errors:

a. Column E, rows 30 thru 71 incorrectly reference column "W" in their formulas. Column W is unused/blank; should instead reference column V.

b. Column H, rows:

i. 9-27 incorrectly reference column "W" in their formulas. Should instead reference column V.

ii. 8-27 only get information from one of the Option 1 worksheets

(e.g., cell H9 shows "=SUM('O-1 CLIN 0004 LRIP OT&E FFP'!W9)". Should also pick-up the other Option 1 worksheets (like the formulas in column F;

"=SUM('O-1 CLIN 0004 LRIP OT&E FFP:O-1 CLIN 0008 INTEG SUPT CPFF'!U8)"

Noted. A new template will be posted on FBO

See FBO for updated template

187 Cost Volume Template

c. Option 2 columns I and K only include 3 of the 8 Option 2 worksheets in their sum formula (=SUM('O-2 CLIN 0009 FRP FFP

5000-7499'!U8+'O-2 CLIN 0011 FRP TRAVEL CR '!U8+'O-2 CLIN 0012 INTEG SUPT

CPFF '!U8). This excludes five Option 2 worksheets: e.g., "O-2 CLIN 0009

FRP FFP 1-999", ".1000-2499", ".2500-4999", ".7500-9999", and ".10000& UP")

d. Option 3 columns I and K also only include 3 of the 8 Option 3 worksheets (same ones missing as above but "O-3")

Per Section L, paragraph 6.4.1, "The cost formats are provided as

“Cost Price Template.” Offerors may make adjustments to the cost formats (add additional rows or columns to worksheets) if needed to reflect additional cost elements consistent with their accounting/estimating system. The Offeror shall not remove or delete rows, columns or worksheets. The Offeror shall include in-house, inter-divisional, subcontractor, and associate contractor activities."

N

188 Cost Volume Template

3) The profit or fee row - Note 4 states that "profit or fee is not allowed on FCCOM, Travel, and direct costs for equipment..".

a. FCCOM is properly excluded from the base (e.g., cells C70) in cost worksheets, and

b. Travel CLINs properly reference no fee, but

c. For CLINS that permit fee, direct costs for equipment and travel

(identified in rows 51 and 52) aren't apparently excluded from the profit/fee base amounts in cells C70.

Concerning the CLINS that permit fee, direct costs for equipment and travel (identified in rows 51 and 52) aren't apparently excluded from the profit/fee base amounts in cells C70. Those items listed under the

ODC column are intended as examples for the template and may vary from company to company. Since there are separate travel CLINs for this effort we don’t expect to see travel proposed as a part of the

CLINs that permit fee. So Yes, Is it up to the users to adjust for these two ODC lines that shouldn't bear fee.

N

189 Cost Volume Template

Referencing the discrepancies noted above, Is it up to the users to adjust for these two

ODC lines that shouldn't bear fee?

Concerning the CLINS that permit fee, direct costs for equipment and travel (identified in rows 51 and 52) aren't apparently excluded from the profit/fee base amounts in cells C70. Those items listed under the

ODC column are intended as examples for the template and may vary from company to company. Since there are separate travel CLINs for this effort we don’t expect to see travel proposed as a part of the

CLINs that permit fee. So Yes, Is it up to the users to adjust for these two ODC lines that shouldn't bear fee.

N

UNCLASSIFIED

Approved for Public Release, Distribution Unlimited

UNCLASSIFIED

7/16/2014, 2:59 PM

Comment

Number Document

Page/Section/

Paragraph Question/Comment Recommendation

Response Amendment

(Y/N)

190 Cost Volume Template

Referencing the discrepancies noted above, are Offerors allowed to make the changes in formulas based on the recommendations above?

Per Section L, paragraph 6.4.1, "The cost formats are provided as

“Cost Price Template.” Offerors may make adjustments to the cost formats (add additional rows or columns to worksheets) if needed to reflect additional cost elements consistent with their accounting/estimating system. The Offeror shall not remove or delete rows, columns or worksheets. The Offeror shall include in-house, inter-divisional, subcontractor, and associate contractor activities."

N

UNCLASSIFIED

Approved for Public Release, Distribution Unlimited