W56JSR-18-R-0016_-Attachment_0006_CDRL_A003_Attachment.xlsx

Title Page-Instructions

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Awardee is required to include the Minimum, Maximum and Weighted Average DL rate(s) of each Direct Labor rate proposed for the corresponding Contractor Fiscal Year (weighted approprately when crossing 2 periods). For instance, if the current billing cycle is occuring during year 4 of the subject contract, the year 4 DL rates that were originally proposed shall be included in columns S, T and U of the "DI-MGMT-81864A" worksheet but columns T,U and V of the example located in cells T36, U36 and V36 of this worksheet, "Title Page-Instrcutions"...

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

This example of PROPOSED DL rates is specifically for the "Network Engineer Intermediate" LCAT/Skill Level.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

The $65.00(cell N38) DL rate invoiced for Employee 3 of 7 exceeds the 5.0% threshold over the Maximum rate proposed of $54.00 (cell U36) requiring Contracting Officer approval.

Although the Actual DL rate invoiced at $65.00 for Employee 3 of 7 is over the 10.0% threshold of the computed wtd avg DL of $47.21 (yellow highlight cell P43) and the proposed wtd avg DL rate of $45.00 (cell V36), the invoiced rate does NOT need to be addressed in the monthly report submission b/c it is a component of the remaining 6 employees within the group of 7 employees for this LCAT/Skill level. It is the $47.21 Actual wtd avg DL rate (yellow highlight) for the "Network Engineer Intermediate" GROUP that is to be compared to the PROPOSED wtd avg DL of $45.00 (cell V36); If the ACTUAL/Invoiced wtd avg GROUP DL rate is greater than the 10.0% threshold relative to the $45.00 PROPOSED wtd avg rate, it needs to be addressed in the monthly report for that LCAT/Skill level.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

These Minimum and Maximum DL rates are effective as of 3/27/2018 and are subject to change at any time as additional DL rate data is collected and aggregated.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

The $47.21 is the "Actual" computed weighted average for the Network Engineer Intermediate LCAT. 4.9% Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

The $47.21 (cell P43) actual wtd avg DL rate is just below the 5.0% threshold in comparison to the PROPOSED wtd avg DL rate of $45.00 (cell V36) and need NOT be addressed in the monthly report.

NG524 System Engineer Senior $44.13 $66.19 If wtd avg. was > $50.00 11.1% Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

If the actual wtd avg DL rate was $50.00 (cell P44) relative to the proposed wtd avg of $45.00 (cell V36), the situation would need to be addressed. (11.1% > 10.0%).

NG532 Technical Writer Editor Intermediate $31.61 $45.04

Click here to go to Weighted Average Example.

/xl/drawings/drawing1.xml#'Title%20Page-Instructions'!V58CLICK HERE TO GO HOME /xl/drawings/drawing1.xml#'Title%20Page-Instructions'!A1 Post Award Cost Overrun Languag

DI-MGMT-81864A

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Awardee is required to include the Minimum, Maximum and Weighted Average DL rate(s) of each Direct Labor rate proposed for the corresponding Contractor Fiscal Year (weighted when crossing 2 periods). For instance, if the current billing cycle is occuring during year 4 of the subject contract, the year 4 DL rates that were originally proposed shall be included in columns S, T and U.

The Weighted Average DL rates are to be determined by utilizing the corresponding Labor Hours that relate to the specific LCAT/Skill Level labor rate within that LCAT. If there are 10 different rates proposed for say, Budget Analyst Entry, the Weighted Average must be computed and reported in column U. Maximum Proposed Direct Labor Rate within LCAT Proposed Weighted Average (By Hours) of Direct Labor Rate within LCAT/Skill Level Actual DL Rate (Regular) Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Contractor/Awardee is offered some latitude here but regardless of which option works best for your situation (Option 1 or Option 2), you will need to provide a SEPARATE Payroll submission that includes Employee Name/or Employee ID #, LCAT, # of Hours, Extended Labor Dollars. Obviously, the payroll per LCAT and Total needs to reconcile with the Total Direct Labor Dollars billed on this spreadsheet.

You can either:

1) Make multiple entries for each, say, "Budget Analyst Entry" and utilize column P "Employee Name" or;

2) Sum all Budget Analyst Entry labor dollars and divide by the number of billable hours to arrive at the average labor rate billed for that LCAT (column T).

Again, both options will require a SEPARATE Payroll submission as described above. Actual DL Rate (OT) Actual $ DL Dollars (Regular) Actual $ DL Dollars (OT) Actual $ Total DL Dollars (Regular + OT) PROPOSED FRINGE RATE Actual Fringe Rate (%) Proposed Fringe Dollars Proposed O/H Rate (%) Actual O/H Rate (%) Proposed Overhead {O/H rate*(DL+Fringe)} Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

This spreadsheet is a SAMPLE of the data that the Government is requiring the Awardee to report for each billing cycle IAW w/the subject CDRL. The contractor/Awardee is encouraged to modify this spreadsheet as necessary to remain in compliance with your financial disclosure and accounting practices. Add/delete columns as appropriate for your situation.

O/H, for example, is calculated a number of ways, i.e., (DL + Fringe)*O/H rate, (DL*O/H rate), etc.,. Modify as appropriate for your situation.

Other Indirect 1 Other Indirect 2 Other Indirect 3 PROPOSED G&A RATE Actual G&A Rate (%) Actual G&A Dollars ($) Proposed Fee Rate (%) Actual Fee Rate (%) Actual Fee FCCOM Rate (%) FCCOM Total Burdened Labor Dollars Total ODC, Material, Travel Total $ Billed Billing Period(s) - Period Ending Total DL Dollars Billed Current and Cumulative Base/Option Period(s) Total Hours Billed Current and Cumulative Base/Option Period(s) Total $ Billed Current and Cumulative Base/Option Period(s) Total Fee Dollars Billed Current and Cumulative Base/Option Period(s) SSES NexGen LCAT/Skill Level Actual Regular Labor Hours Expended Actual Aggregate Labor Hours by LCAT/Skill Level Actual Weighted Average Computation (Pro Rata) Aggregate of Actual Weighted Average Computation by LCAT/Skill Level Proposed Weighted Average (By Hours) of Direct Labor Rate within LCAT/Skill Level Actual Wtd. Avg. DL Rates = or > 10.0% over the Proposed Wtd. Avg DL Rates Identified in Red (Conditional Formatting) Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Note to COR, TM, KO and KS:

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Prior months submisions are manually inputted to arrive at the auto-calculated Cumulative Total for the Base or appropriate Option Year.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Awardee is required to include the Minimum, Maximum and Weighted Average DL rate(s) of each Direct Labor rate proposed for the corresponding Contractor Fiscal Year (weighted when crossing 2 periods). For instance, if the current billing cycle is occuring during year 4 of the subject contract, the year 4 DL rates that were originally proposed shall be included in columns S, T and U.

The Weighted Average DL rates are to be determined by utilizing the corresponding Labor Hours that relate to the specific LCAT/Skill Level labor rate within that LCAT. If there are 10 different rates proposed for say, Budget Analyst Entry, the Weighted Average must be computed and reported in column U.

Contractor/Awardee is offered some latitude here but regardless of which option works best for your situation (Option 1 or Option 2), you will need to provide a SEPARATE Payroll submission that includes Employee Name/or Employee ID #, LCAT, # of Hours, Extended Labor Dollars. Obviously, the payroll per LCAT and Total needs to reconcile with the Total Direct Labor Dollars billed on this spreadsheet.

1) Make multiple entries for each, say, "Budget Analyst Entry" and utilize column P "Employee Name" or;

2) Sum all Budget Analyst Entry labor dollars and divide by the number of billable hours to arrive at the average labor rate billed for that LCAT (column T).

Again, both options will require a SEPARATE Payroll submission as described above.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Note to COR, TM, KO and KS:

This is by aggregate of each separate LCAT/Skill Level grouping; Actual Individual separate rates billed may be below Proposed Wtd. Avg. DL Rate.

Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

GO TO ANALYSIS

/xl/drawings/drawing2.xml#'DI-MGMT-81864A'!BK5 Proposed DL Wtd. Avg. Input

Contractor/Awardee is offered some latitude here but regardless of which option works best for your situation (Option 1 or Option 2), you will need to provide a SEPARATE Payroll submission that includes Employee Name/or Employee ID #, LCAT, # of Hours, Extended Labor Dollars. Obviously, the payroll per LCAT and Total needs to reconcile with the Total Direct Labor Dollars billed on this spreadsheet.

1) Make multiple entries for each, say, "Budget Analyst Entry" and utilize column P "Employee Name" or;

2) Sum all Budget Analyst Entry labor dollars and divide by the number of billable hours to arrive at the average labor rate billed for that LCAT (column T).

Again, both options will require a SEPARATE Payroll submission as described above. Minimum Proposed Direct Labor Rate within LCAT Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Awardee is required to include the Minimum, Maximum and Weighted Average DL rate(s) of each Direct Labor rate proposed for the corresponding Contractor Fiscal Year (weighted when crossing 2 periods). For instance, if the current billing cycle is occuring during year 4 of the subject contract, the year 4 DL rates that were originally proposed shall be included in columns S, T and U.

The Weighted Average DL rates are to be determined by utilizing the corresponding Labor Hours that relate to the specific LCAT/Skill Level labor rate within that LCAT. If there are 10 different rates proposed for say, Budget Analyst Entry, the Weighted Average must be computed and reported in column U. Maximum Proposed Direct Labor Rate within LCAT Proposed Weighted Average (By Hours) of Direct Labor Rate within LCAT/Skill Level Actual DL Rate (OT) Actual $ DL Dollars (Regular) Actual $ DL Dollars (OT) Actual $ Total DL Dollars (Regular + OT) Total DL Dollars Billed Current and Cumulative Base/Option Period(s) SSES NexGen LCAT/Skill Level (Copy and Paste ONE COLUMN at a time directly from Proposal) Proposed Regular Labor Hours Expended (Copy and Paste ONE COLUMN at a time directly from Proposal) Actual Aggregate Labor Hours by LCAT/Skill Level Actual Weighted Average Computation (Pro Rata) Aggregate of Actual Weighted Average Computation by LCAT/Skill Level Proposed Weighted Average (By Hours) of Direct Labor Rate within LCAT/Skill Level Actual Wtd. Avg. DL Rates = or > 10.0% over the Proposed Wtd. Avg DL Rates Identified in Red (Conditional Formatting) Wienecke, Steven M CIV US USA: Wienecke, Steven M CIV US USA:

Note to COR, TM, KO and KS: