L-04c_KLXS_III_Rates_and_Factors_Template.xlsm

XLSM spreadsheet 267 KB Posted

Attached to
KLXS III Award
Solicitation number
80KSC018R0006
Issued by

About this file

From the source

KLXS III Rates and Factors Template

View the file

Other files

File Type Posted
KLXS_III_RFP_Responses_to_Questions_5.23.2018.pdf PDF
KLXS_III_-_Amend_4.pdf PDF
KLXS_III_RFP_Responses_to_Questions_5.17.2018.pdf PDF
KLXS_III_-_Amend_3.pdf PDF
KLXS_III_RFP_Responses_to_Questions_5.10.2018.pdf PDF
KLXS_III_-_Amend_2.pdf PDF
L-04b_KLXS_III_Basic_Cost_Template_(Amendment_2).xlsm XLSM spreadsheet
KLXS_III_-_Amend_1.pdf PDF
L-04b_KLXS_III_Basic_Cost_Template_(Amendment_1).xlsm XLSM spreadsheet
L-04b_KLXS_III_Basic_Cost_Template.xlsm XLSM spreadsheet
L-04a_KLXS_III_Phase-In_Template.xlsm XLSM spreadsheet
KLXS_III_RFP_Portfolio.pdf PDF
Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Title Page

80KSC018R0006

KLXS III RFP

ATTACHMENT L-04c

RATES AND FACTORS TEMPLATE

&"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

Table of Contents Table of Contents - all worksheets

1Instructions
2Labor-Fringe Rate Form
3G&A Rate
4G&A Rate Base
5Overhead Rate Pool
6Overhead Base
7Overhead Labor
8Other Rate Pool
9Other Rate Base
10Other Rate Labor
11Rates & Factors Summary

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

Instructions Cost Template Instructions

RATES & FACTORS TEMPLATE

Offerors shall fill in green cells of Excel tabs ONLY. It is offeror's responsibility to ensure all protected formats and formulas in this template are changed only to comply with their Accounting/Estimating processes and or disclosure statement. The "Protect" function provided in 'table of content' tab allows the offeror fill out the green cells only. The "Unprotect" Macro will unlock all tabs. Only unpotect if it is necessary to change to maintain compliance with Company Policies/Procedures and or Disclosure Statement. If changes ae made, please explain the reason why and detail the rationale in the cost volume narrative. All Prime and Major Subcontractor(s) are to separately complete the Rates & Factors template for submittal to the Government.

1 Labor-Fringe Rate Form: The offeror shall determine if the proposed Labor Burden Rate is the same as or different than the Provisional Billing Rate and fill in the appropriate box. Offeror shall identify burdens and indirect labor expense pools by each offeror FY. Identify base to which the pool will be applied.

2 G&A Rate Tab: The offeror shall identify burdens and indirect G&A expense pools by each offeror FY. Identify base to which the pool will be applied.

3 G&A Rate Base Tab: The offeror shall list what comprises the G&A base by offeror FY. This contract must be included in the base.

4 Overhead Rate Pool Tab: The offeror shall determine if the Proposed Overhead Rate is the same as or different from the Provisional Billing Overhead Rate. The offeror shall populate row 6 if this rate is different from Proposed. Offeror shall input applicable data under appropriate categories related to Overhead by offeror FY.

5 Overhead Labor Tab: The offeror shall identify appropriate labor by occupational/position title by offeror FY. If a labor burden percentage (cells C8, F8, etc.) other than the fringe rate identified on the fringe tab is used, the offeror shall provide a basis of estimate on how this fringe rate was computed.

6 Overhead Base Tab: The offeror shall enter a Description / Account Names / Cost Elements of items contained in the Overhead Proposed Base and appropriate amounts by offeror FY.

7 Other Rate Pool Tab: If any other rate will be used to allocate cost - use this form. This form does not automatically update in the cost templates. The offeror should ensure costs related to this rate are captured in the cost template. Provide supporting documentation.

8 Other Rate Base Tab: If any other rate will be used to allocate cost - use this form. This form does not automatically update in the cost templates. The offeror should ensure costs related to this rate are captured in the cost template. Provide supporting documentation.

9 Other Rate Labor Tab: If any other rate will be used to allocate cost - use this form. This form does not automatically update in the cost templates. The offeror should ensure costs related to this rate are captured in the cost template. Provide supporting documentation.. If a labor burden percentage (cells D8, H8, etc.) other than the fringe rate identified, the offeror shall provide a basis of estimate on how this fringe rate was computed. Provide supporting documentation.

10 Rates & Factors Summary Tab: The offeror shall provide the Provisional (Labor Burden, General & Administrative Rates (G&A), and Overhead) by offeror FY. Due to formula complexity (to address any possible offeror fiscal year) and inaccuracy of percentage portions (vs. monthly data) the conversion from offeror FY to GFY / Contract Year needs to be a manual calculation on the part of the offeror. The offeror shall identify any other applicable rates here and describe its application in the Cost Volume. Offeror is required to submit supporting information for "other rates" (if applicable) in 'Other Rate Pool' tab, 'Other Rate Base' tab, and 'Other Rate Labor' tab as necessary. If multiple "Other Rates" are proposed, offeror shall make duplicate 'Other Rate Pool' tab, 'Other Rate Base' tab, and 'Other Rate Labor' tab as necessary and include sufficient information for the Government to evaluate. Offeror is to input the starting month of their fiscal year in Cell D46. The offeror's fiscal year ending month is auto calculated in Cell D47.

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&"Times New Roman,Regular"&12&P / &N &A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

Labor-Fringe Rate Form Labor-Fringe Rate Form (Composition of Burden Pool)

Offeror Prior Fiscal Yr 3Offeror Prior Fiscal Yr 2Offeror Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7Offeror FY 8
Proposed Offeror FY0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Provisional if Different from above
Prime/Sub Name:[ ] Prime[ ] Sub
Basis of Application:
Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7Offeror FY 8
Total Labor-Fringe Pool Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Application Base ($)
Base Period 1Base Year 2Option Year 1Option Year 2Option Period 3Option Period 4Option Period 5
Proposed Base/Option Year Rate
OfferorOfferorOfferorOfferorOfferorOfferorOfferorOfferorOfferorOfferorOfferor
Cost Elements withinFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
the Labor-Fringe PoolPrior Yr 3Prior Yr 2Prior Yr 112345678
USE PULL DOWN MENU PROVIDED
Payroll Taxes:
FICA (Fed Income Tax)
FUI (Federal Unemployment)
SUI (State Unemployment)
WC (Workers Comp)
Fringes:
Retirement
Health/Life Insurance
Paid Leave (Holiday, Vacation, SL)
Bonuses
Employee Incentive Plan / Bonuses
Employee Award Program
Tuition/Education Reimbursement
Holiday
Vacation
Sick leave
Military Leave/Bereavement/Jury Duty
Other (List):

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&"Times New Roman,Regular"&12Page &P / &N &A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

G&A Rate

Name:General and Administrative (G&A) Rate Form
[ ] PrimeBURDEN/INDIRECT EXPENSE POOL
[ ] SubcontractorPOOL (G&A )
Prior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7Offeror FY 8
TOTAL EXPENSES$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Proposed Offeror FY G&A Rate0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Provisional (if Different from above)
Application Base ($): ( Linked to G&A Rate Base)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ACCOUNTS (LIST)Prior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7Offeror FY 8REFERENCE/COMMENTS
(e.g. Labor, Utilities, Rent, Misc Expense, Training, Travel)
(List Separately)

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

ToC /xl/drawings/drawing4.xml#'Table%20of%20Contents'!A1 G&A Rate Base

Name:General and Administrative (G&A) Rate Base
[ ] Prime[ ] SubcontractorBURDEN/INDIRECT EXPENSE POOL BASE CALCULATION
Basis of Application:G&A Base Detail
Prior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7Offeror FY 8REFERENCE
TOTAL G&A RATE BASE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contract Title/Number

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

ToC /xl/drawings/drawing5.xml#'Table%20of%20Contents'!A1 Overhead Rate Pool

Name:Overhead Rate Pool
[ ] PrimeBURDEN/INDIRECT EXPENSE POOL
[ ] SubcontractorPOOL (Overhead )
Prior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7Offeror FY 8REFERENCE
Proposed Offeror FY0.00%0.00%0.00%0%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Provisional if Different from above
BASE (Linked from Overhead Base)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead Labor Cost (Linked from OH Labor)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL EXPENSES (labor and Non-Labor)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ACCOUNTS/ELEMENTS (LIST)
e.g.: Supplies, Equip, Other Indirect Costs, etc.

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

ToC /xl/drawings/drawing6.xml#'Table%20of%20Contents'!A1 Overhead Base

Name:Overhead Base
[ ] PrimeBURDEN/INDIRECT EXPENSE POOL BASE CALCULATION
[ ] SubcontractorOverhead Base DetailBasis of Application:
Prior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7Offeror FY 8REFERENCE
TOTAL OVERHEAD BASE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ACCOUNTS/ELEMENTS (LIST)

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

ToC /xl/drawings/drawing7.xml#'Table%20of%20Contents'!A1 Overhead Labor

Overhead Labor
Name:TOTAL LABOR AND FRINGE COST
[ ] PrimeOverhead Labor
[ ] SubcontractorPrior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7Offeror FY 8TOTAL
COSTS:
PROD. LABOR COSTS$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
LABOR BURDENSLabor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0$ - 0
SUBTOTAL$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ELEMENTSReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECost
PROD. LABOR HOURS:
Labor Categories
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00
0.000.000.00

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

ToC /xl/drawings/drawing8.xml#'Table%20of%20Contents'!A1 Other Rate Pool

Name:Other Rate Pool Rate
[ ] PrimeBURDEN/INDIRECT EXPENSE POOL
[ ] SubcontractorPOOL (Other)
Prior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7REFERENCE
Proposed0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Provisional If Different from above
BASE (Linked from Other Base)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Rate Labor (Linked from Other Rate Labor)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL EXPENSES (labor and Non-Labor)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ACCOUNTS/ELEMENTS LIST

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&"Times New Roman,Regular"&12Page &P / &N &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

ToC /xl/drawings/drawing9.xml#'Table%20of%20Contents'!A1 Other Rate Base

Name:Other Rate Base
[ ] PrimeBURDEN/INDIRECT EXPENSE POOL BASE CALCULATION
[ ] subcontractorOther Base DetailBasis of Application:
TOTAL OTHER BASE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ACCOUNTS/ELEMENTS (LIST)Prior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Phase InOfferor
FY 1Offeror
FY 2Offeror
FY 3Offeror
FY 4Offeror
FY 5Offeror
FY 6Offeror
FY 7REFERENCE

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

ToC /xl/drawings/drawing10.xml#'Table%20of%20Contents'!A1 Other Rate Labor

Name:Other Rate Labor
[ ] PrimeTOTAL ESTIMATED COST
[ ] subcontractorOther Rate Cost
Prior Fiscal Yr 3Prior Fiscal Yr 2Prior Fiscal Yr 1Offeror FY 1Offeror FY 2Offeror FY 3Offeror FY 4Offeror FY 5Offeror FY 6Offeror FY 7TOTAL
COSTS:
PROD. LABOR COSTS$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
LABOR BURDENSLabor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0Labor Burden %$ - 0$ - 0
SUBTOTAL$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ACCOUNTS/ELEMENTSReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Prod HrsWYECostReg Productive HrsWYECost
PROD. LABOR HOURS:
Labor Categories
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0
0.000.00$ - 0

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP &"Times New Roman,Regular"&12Attachment L-04c

&A &"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

ToC /xl/drawings/drawing11.xml#'Table%20of%20Contents'!A1 Rates & Factors Summary

Rates & Factors Summary
PROPOSED - By Contract Year (Base Year and Option Years)
Base PeriodOption 1Option 2Option 3Option 4Option 5
GFY 2019 - Contract
Year 1GFY 2020 - Contract
Year 2GFY 2021 - Contract
Year 3GFY 2022 - Contract
Year 4GFY 2023 - Contract
Year 5GFY 2024 - Contract
Year 6GFY 2025 - Contract
Year 7GFY 2026 - Contract

Year 8

Labor Burden
G&A
Overhead
Other Rates * (if applicable)
Other Rates * (if applicable)
Other Rates * (if applicable)
Other Rates * (if applicable)

* Provide Name of Rate or Factor

Rates & Factors Summary
PROPOSED - By Offeror Fiscal Year (Offeror FYs)
Base PeriodOption 1Option 2Option 3Option 4Option 5
Contract
Year 1Contract
Year 2Contract
Year 3Contract
Year 4Contract
Year 5Contract
Year 6Contract
Year 7Contract

Year 8

Labor Burden0.00%0.00%0.00%0.00%0.00%0.00%0.00%January
G&A0.00%0.00%0.00%0.00%0.00%0.00%0.00%February
Overhead0.00%0.00%0.00%0.00%0.00%0.00%0.00%March
April
Other Rates * (if applicable)

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it.