Attachment_0006_-_Section_L_Tables_26Jul17.pdf

Table 4. Requirements for Submission of Proposal Materials

Volume Title Unsanitized

Microsoft (MS) Word Version

Sanitized MS Word Version

Unsanitized

PDF

Version

Sanitized

PDF

Version

Unsanitized MS Excel Version

Sanitized MS Excel Version

Max.

Pages

I – Technical 1 1 1 1 N/A N/A 140 per copy*

II – Past Performance

1 N/A 1 N/A N/A N/A 50 per copy**

III – Cost/ Price N/A N/A 1*** 1*** 1 1 N/A

IV –

Miscellaneous****

N/A N/A 1 1***** N/A N/A N/A

*The company credentials (business size standard, company’s facility clearance level, ISO certifications, CMMI, etc.), resumes, graphics (i.e. company logos), conditional letters of offer and acceptance, and the table of contents are not included in the page count. Resumes shall be a maximum of two (2) pages each. Conditional letters of Offeror and acceptance shall be one (1) page each.

**PWS/SOW documents, letters of consent, letters of commitment, the POC list for Questionnaires, and the table of contents are not included in the page count.

***All supporting documentation concerning cost/ price (i.e. base of estimate (BOE), pricing methodology, direct / indirect rate support, and any other applicable supporting documentation) shall be provided in both unsanitized and sanitized versions of .pdf

****The miscellaneous volume shall include non-disclosure agreements, data and software assertions, representations and certifications, EVMS documentation, the organizational conflict of interest (OCI) mitigation plan, completed Sections B, H, and K, and Standard Forms 30 and 33. There shall be no terms and conditions proposed for the contract; however, pricing assumptions should be included in the cost volume BOE.

*****Limited to data and software assertions.

Table 5. Labor CLIN Worksheet Sample

Contractor Fiscal Year

CLIN 000X DD MON YYYY- DD MON YYYY

Hours/Base Rate Dollars

Direct Labor

Labor Category

Hours Rate from Labor Rate Worksheet

Formula ( Hours * Rate) A

Labor Category

Hours Rate from Labor Rate Worksheet

Formula ( Hours * Rate) B

Labor Category

Hours Rate from Labor Rate Worksheet

Formula ( Hours * Rate) C

Subtotal Direct Labor

Sum Sum D=A+B+C

Fringe-if applicable

Formula Base (=D) Rate from Indirect Rate Worksheet

Formula ( Base * Rate) E

Total Direct labor

Sum F=D+E

Labor Overhead Formula Base (=F) Rate from Indirect Rate Worksheet

Formula (Base * Rate) G

Subtotal Labor Sum H=F+G

S/IE

S/IE 1

From S/IE Cost proposal for applicable CLIN

K

CLIN 000X DD MON YYYY- DD MON YYYY

Hours/Base Rate Dollars

S/IE 2

From S/IE Cost proposal for applicable CLIN

L

S/IE 3

From S/IE Cost proposal for applicable CLIN

M

Total S/IE Sum N=K+L=M

Subcontractor Handling

Formula Base (=N) Rate from Indirect Rate Worksheet

Formula ( Base * Rate) O

General and Administrative (G&A)

Formula Base (=O+N+H)

Rate from Indirect Rate Worksheet

Formula ( Base * Rate)

P

Total Cost Input

(TCI)

Sum

Q=P+O+N+H

Fee- Direct Labor

Formula Base (=Q-N) Rate from Indirect Rate Worksheet

Formula ( Base * Rate) R

Fee- Subcontract Labor

Formula Base (N) Rate from Indirect Rate Worksheet

Formula ( Base * Rate)

S

DL Formula Base (D) Rate from Indirect Rate Worksheet

Formula ( Base * Rate) T

Hours/Base Rate Dollars

G&A Formula Base (=O+N+H)

Rate from Indirect Rate Worksheet

Formula ( Base * Rate) U

Total Sum V=T+U

Total Proposed Sum W=Q+R+S+V

Table 6. Materials CLIN Worksheet

Prime Materials

AA

Prime Material Handling

Formula Base

(=AA)

Rate from Indirect Rate Worksheet

Formula (Base*Rate)

BB

Prime ODCs (other than uplifts and travel)

From ODC Worksheet

CC

Prime Uplifts From Uplift Worksheet

DD

Prime Travel From Travel Worksheet

EE

Subtotal ODCs

= CC + DD +

EE

FF

S/IE

S/IE 1

From S/IE Cost proposal for applicable

CLIN

GG

S/IE 2

From S/IE Cost proposal for applicable

CLIN

HH

S/IE 3

From S/IE Cost proposal for applicable

CLIN

II

Subtotal SI&E Sum JJ=GG+HH+II

Subtotal Sum JJ=AA+BB+FF+JJ

G&A Formula Base

(=JJ)

Rate from Indirect Rate

Formula (Base*Rate)

KK

Subtotal Sum LL=JJ+KK

G&A COM

Formula Base

(=JJ)

Rate from Indirect Rate

Formula (Base* Rate)

MM

Total Sum NN=LL+MM

Table 7. Materials, Travel, and ODC Plug Numbers

During contract performance, all travel, materials, and ODC’s applicable at the prime and subcontract level shall be billed against the applicable non-fee bearing Cost CLINs below.

CLINs Travel Plug # Material Plug # ODC Plug # Total

0002AA $ 725,823 $ 184,741 $ 92,839 $ 1,003,404

0004AA $ 17,982 $ 6,609 $ 2,361 $ 26,951

0004AB $ 35,964 $ 13,217 $ 4,722 $ 53,903

0004AC $ 35,964 $ 13,217 $ 4,722 $ 53,903

0004AD $ 35,964 $ 13,217 $ 4,722 $ 53,903

0006 $ 57,421 $ 11,509 $ 5,663 $ 74,592

0008 $ 57,421 $ 11,509 $ 5,663 $ 74,592

0010 $ 57,421 $ 11,509 $ 5,663 $ 74,592

0012 $ 76,561 $ 15,345 $ 7,550 $ 99,457

0014 $ 57,421 $ 11,509 $ 5,663 $ 74,592

0016 $ 57,421 $ 11,509 $ 5,663 $ 74,592

0018 $ 57,421 $ 11,509 $ 5,663 $ 74,592

1002AA $ 754,130 $ 191,946 $ 96,460 $ 1,042,536

1004AA $ 18,683 $ 6,866 $ 2,453 $ 28,003

1004AB $ 37,366 $ 13,733 $ 4,906 $ 56,005

1004AC $ 37,366 $ 13,733 $ 4,906 $ 56,005

1004AD $ 37,366 $ 13,733 $ 4,906 $ 56,005

1006 $ 59,660 $ 11,958 $ 5,883 $ 77,502

1008 $ 59,660 $ 11,958 $ 5,883 $ 77,502

1010 $ 59,660 $ 11,958 $ 5,883 $ 77,502

1012 $ 79,547 $ 15,944 $ 7,845 $ 103,335

1014 $ 59,660 $ 11,958 $ 5,883 $ 77,502

1016 $ 59,660 $ 11,958 $ 5,883 $ 77,502

1018 $ 59,660 $ 11,958 $ 5,883 $ 77,502

2002AA $ 769,140 $ 195,767 $ 98,380 $ 1,063,287

2004AA $ 19,055 $ 7,003 $ 2,502 $ 28,560

2004AB $ 38,110 $ 14,006 $ 5,004 $ 57,120

2004AC $ 38,110 $ 14,006 $ 5,004 $ 57,120

2004AD $ 38,110 $ 14,006 $ 5,004 $ 57,120

2006 $ 60,848 $ 12,196 $ 6,000 $ 79,044

2008 $ 60,848 $ 12,196 $ 6,000 $ 79,044

2010 $ 60,848 $ 12,196 $ 6,000 $ 79,044

2012 $ 81,130 $ 16,261 $ 8,001 $ 105,392

2014 $ 60,848 $ 12,196 $ 6,000 $ 79,044

2016 $ 60,848 $ 12,196 $ 6,000 $ 79,044

2018 $ 60,848 $ 12,196 $ 6,000 $ 79,044

3002AA $ 784,615 $ 199,705 $ 100,359 $ 1,084,679

3004AA $ 19,438 $ 7,144 $ 2,552 $ 29,135

3004AB $ 38,877 $ 14,288 $ 5,104 $ 58,269

3004AC $ 38,877 $ 14,288 $ 5,104 $ 58,269

3004AD $ 38,877 $ 14,288 $ 5,104 $ 58,269

3006 $ 62,072 $ 12,441 $ 6,121 $ 80,634

3008 $ 62,072 $ 12,441 $ 6,121 $ 80,634

3010 $ 62,072 $ 12,441 $ 6,121 $ 80,634

3012 $ 82,763 $ 16,588 $ 8,162 $ 107,513

3014 $ 62,072 $ 12,441 $ 6,121 $ 80,634

3016 $ 62,072 $ 12,441 $ 6,121 $ 80,634

3018 $ 62,072 $ 12,441 $ 6,121 $ 80,634

4002AA $ 800,293 $ 203,696 $ 102,364 $ 1,106,353

4004AA $ 19,827 $ 7,287 $ 2,603 $ 29,717

4004AB $ 39,654 $ 14,573 $ 5,206 $ 59,433

4004AC $ 39,654 $ 14,573 $ 5,206 $ 59,433

4004AD $ 39,654 $ 14,573 $ 5,206 $ 59,433

4006 $ 63,312 $ 12,690 $ 6,244 $ 82,246

4008 $ 63,312 $ 12,690 $ 6,244 $ 82,246

4010 $ 63,312 $ 12,690 $ 6,244 $ 82,246

4012 $ 84,416 $ 16,920 $ 8,325 $ 109,661

4014 $ 63,312 $ 12,690 $ 6,244 $ 82,246

4016 $ 63,312 $ 12,690 $ 6,244 $ 82,246

4018 $ 63,312 $ 12,690 $ 6,244 $ 82,246