A07-_Attachment_0005_Sample_Labor_CLIN_Worksheet.pdf

PDF 45 KB Posted

Attached to
CECOM LCMC G8 contractor Support Services
Solicitation number
W56KGY-16-R-0023
Issued by

About this file

Sample CLIN Worksheet

View the file

Other files

Show all 15

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

Solicitation # W56KGY‐16‐R‐0023 Attachment 0006

December 04, 2015

Sample Labor CLIN Worksheet

Contractor Fiscal Year

CLIN 000X DD MON YYYY- DD MON YYYY

Hours/Base Rate Dollars

Direct Labor

Labor Category 1 Hours Rate from Labor Rate Worksheet

Formula (Hours * Rate)

A

Labor Category 2 Hours Rate from Labor Rate Worksheet

Formula (Hours * Rate)

B

Labor Category 3 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

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

Solicitation # W56KGY‐16‐R‐0023 Attachment 0006

December 04, 2015

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

COM

DL COM Formula Base (D)

Rate from Indirect Rate Worksheet

Formula (Base * Rate)

T

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

Rate from Indirect Rate Worksheet

Formula (Base * Rate)

U

Total COM Sum V=T+U

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

File details come from the government source that posted it. Updated .