L-04b_KLXS_III_Basic_Cost_Template_(Amendment_2).xlsm

XLSM spreadsheet 2 MB Posted May 10, 2018

Attached to: KLXS III Award Federal contract opportunity
Solicitation number: 80KSC018R0006
Issued by: National Aeronautics and Space Administration Kennedy Space Center

About this file

From the source

L-04b KLXS III Basic Cost Template (Amendment 2)

View the file

Other files for this federal contract opportunity

Other files attached to KLXS III Award, newest first.
File	Type	Posted
KLXS_III_RFP_Responses_to_Questions_5.23.2018.pdf	PDF	May 23, 2018
KLXS_III_-_Amend_4.pdf	PDF	May 23, 2018
KLXS_III_RFP_Responses_to_Questions_5.17.2018.pdf	PDF	May 17, 2018
KLXS_III_-_Amend_3.pdf	PDF	May 17, 2018
KLXS_III_RFP_Responses_to_Questions_5.10.2018.pdf	PDF	May 10, 2018
KLXS_III_-_Amend_2.pdf	PDF	May 10, 2018
KLXS_III_-_Amend_1.pdf	PDF	Apr 24, 2018
L-04b_KLXS_III_Basic_Cost_Template_(Amendment_1).xlsm	XLSM spreadsheet	Apr 24, 2018
KLXS_III_RFP_Portfolio.pdf	PDF	Apr 13, 2018
L-04b_KLXS_III_Basic_Cost_Template.xlsm	XLSM spreadsheet	Apr 13, 2018
L-04c_KLXS_III_Rates_and_Factors_Template.xlsm	XLSM spreadsheet	Apr 13, 2018
L-04a_KLXS_III_Phase-In_Template.xlsm	XLSM spreadsheet	Apr 13, 2018

Show all 12

On GovTribe

Work with this file on GovTribe

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-04b

BASIC COST TEMPLATE

[PAGE INTENTIONALLY LEFT BLANK]

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

Template Changes_Updates Rev 1 - 04/23/2018

- Updated the "Offeror Crosswalk & Prop Hrs" tab menu selection (Column F, Cells F12:F161 and F167: F316) to include the following Government Labor Classifications: a. Analyst 2 and b.

Management Analyst 4 Rev 2 - 05/01/2018

- Updated the "Govt Provided CORE LOE Hours" tab, updated Cells C9 and C19 to remove extra space after intern 1 and to remove first extra space between IT Support Specialist 3, respectively.

- Updated the "Offeror Crosswalk & Prop Hrs instructions in Cell B3 to include the following narrative, "Offerors (Prime & Major Sub(s) that will submit an L-04b pricing template) are required to

add an underscore and PWS number at the end of each Offeror Labor Classification being proposed (for example, Engineer 2 being proposed for PWS 4 would be proposed as Engineer 2_4) in Cells E12 thru E161 (Prime) and Cells E167 thru E316 (Subcontractor). This is to prevent any pricing anomalies of Core hours in the PWS 1.0 thru 6.0 Summary tabs which is updated from the "Pivot Table- Prime" tab.

- Required Changes for Offerors using either the L-04b (initial RFP provided file); L-04b, Amendment 1; or L-04b, Amendment 2 Basic Cost Template:

All Offerors are required to perform the following update to their L-04b Basic Cost Template, "Pivot Table-Prime" tab and "Pivot Table-Sub" tab. The reason for the update is to set the Pivot Table source data range to correspond to the offeror's populated data and to exclude all non-data.

Instructions for "Pivot Table-Prime" tab:

- Navigate to the Pivot Table-Prime" tab, Cell B5

- From the menu selection, select Analyze

- Select Change Data Source, to the right of the Table/Range Block, click on the picture block with the Red Arrow (This will bring you to the data in the "Offeror Crosswalk & Prop Hrs" tab)

- Highlight all offeror populated data starting in Cell B11 and capturing all rows and all columns through Column N

- Once highlighted, click on the picture block with the Red Arrow

- Click on OK

Instructions for "Pivot Table-Sub" tab:

- Navigate to the Pivot Table-Sub" tab, Cell B5

- From the menu selection, select Analyze

- Select Change Data Source, to the right of the Table/Range Block, click on the picture block with the Red Arrow (This will bring you to the data in the "Offeror Crosswalk & Prop Hrs" tab)

- Highlight all offeror populated data starting in Cell B166 and capturing all rows and all columns through Column N

- Once highlighted, click on the picture block with the Red Arrow

- Click on OK

ToC /xl/drawings/drawing1.xml#'Table%20of%20Contents'!A1 Instructions

KLXS III General Pricing Information:

A. Prime and Major Subcontractor(s) are both required to submit a completed KLXS III Phase-In template (L-04a); Basic Cost template (L-04b); and Rates & Factors template (L-04c) to the Government when responding to this RFP. A Major subcontractor is defined as having a total proposed value of $25 million or greater over the total KLXS III contract performance period.

B. When developing fully burdened proposed labor rates, Offerors are advised to review and comply with KLXS III RFP, Volume IV, sections L.6, 52.226-46 and L.9, 1852.231-71. Offerors are requested to provide, in their Cost Volume, all quantitative documentation to include detailed support data utilized to develop their base labor rate(s) (e.g., salary assessor data extracts such as Economic Research Institute (ERI), Salary.com, etc.; company base rate data; or any other internal/external data source(s) utilized) to aide the Government in its proposal evaluation process.

C. Offerors are advised to review pricing information provided in the KLXS III RFP, Volume IV, L.20 Cost Factor Instructions and Model Contract.

D. The Government anticipates the KLXS III to be a Cost Plus Fixed Fee (CPFF) contract with a maximum period of performance of 92 months, if all options are exercised. Details are as follows:

BASE	Contract Year 1: February 2019 - September 2019 (8 Months)
	Contract Year 2: October 2019 - September 2020 (12 Months)
Option 1	Contract Year 3: October 2020 - September 2021 (12 Months)
	Contract Year 4: October 2021 - September 2022 (12 Months)
Option 2	Contract Year 5: October 2022 - September 2023 (12 Months)
Option 3	Contract Year 6: October 2023 - September 2024 (12 Months)
Option 4	Contract Year 7: October 2024 - September 2025 (12 Months)
Option 5	Contract Year 8: October 2025 - September 2026 (12 Months)

E. The Total Price, for evaluation purposes, will be the summation of :
	a. Phase-In Price (if proposed) - Firm Fixed Price purchase order
CLIN 001	b. Total Price for CORE (Base Period plus all option years) - CPFF Contract
CLIN 002	c. Total Price for IDIQ (Gov't provided BEQs x Offeror Proposed Fully Burdened Labor Rates, for Base Period and all option years) - CPFF Contract

F. Initial Print Ranges have been set for each tab of this workbook. Offerors are responsible for final print range settings prior to submittal to the Government. Offeror is requested to exclude blank data from their print range settings to minimize paper waste and print costs.

Pricing Instructions, By Worksheet tab:
1	Table of Contents: Contains hyperlinks to cost forms to facilitate quick navigation between cost worksheets.
2	Unions: The Offeror shall identify the name of any union(s) and the productive hours used for each union associated with this proposal (if applicable). Total available productive hours calculations should show the total number of available hours by whole-year, the total hours estimated for holidays, vacation time, sick hours, and other. Different unions can have different productive hours calculations due to different negotiated benefits. The Offeror shall also include non-represented non-exempt productive hours on this tab. Department of Labor local area Wage Determination (WD) is available in the KLXS III RFP, Attachment J-13, SCA Wage Determination, for use as appropriate.
3	Fee & OH Determination: The Offeror shall identify the Subcontract and ODC elements which have Other Cost Elements (OCE) overhead, OCE G&A, and OCE fee applied. Costs Not Subject to Fee: In accordance with RFP Section B.8, Special Cost Requirements, paragraph d, Costs Not Subject to Fee, the Offeror shall not apply fee on the non-labor costs for the following items: equipment, special tooling, special test equipment, materials and supplies (including materials and supplies procured through subcontracts), interdivisional transfers (material only), relocation costs, leases, software licenses, maintenance agreements, travel and training.
4	Productive Hours: The Offeror shall specify the number of productive hours per Work Year Equivalent (WYE) for each year of anticipated contract performance. Productive hour calculations should show the total number of available hours by whole-year, the total hours estimated for holidays, vacation time, sick hours, and other. WYE calculations are based on total annual available hours and should not be adjusted to reflect partial years. Specify in the notes section provided on how the hours were calculated (e.g. 2,080 available hours per year – 100 hours vacation – 40 hours sick – 80 hours holiday = 1,860 Productive Hours). Proposed uncompensated overtime would affect the calculations, since uncompensated time redefines the traditional 8 hour day and 40 hour week generally used for calculation of total available, productive and non-productive time. The Government has provided tables detailing total available productive hours for GFYs 2019 thru 2026. This information is provided for reference purposes only and may be used as an aid for proposal preparation purposes, as appropriate. The Offeror is responsible for the development of productive hours (for Prime and Sub(s) as applicable) for use in its proposal submittal to the Government.
5	Offeror Crosswalk & Prop Hrs: This tab requires Offerors to estimate their (and their Subs, as applicable) Labor Classifications mapped to the Government provided Labor Classifications (Provided in the "Gov't Provided CORE LOE Hours" tab). Inputs are to be segregated between Prime and Sub(s). The Government has provided 150 rows for Prime input (Rows 12 thru 161) and 150 Rows for Sub input (Rows 167 thru 316). Offerors are not to add any rows or alter this spreadsheet in any manner as this will impact the Pivot Table tabs which are critical to pricing Offeror inputs for Prime & Sub. It is imperative that the Total Hours, by PWS, by Government Labor Classification and by Contract Year, be fully accounted for and are accurate as checked against the Government provided hours. A check of accuracy and compliance is provided in tables located in the "Offeror Crosswalk & Prop Hrs" tab. Offeror proposed hours (Prime & Sub) are captured in Columns M thru U. A calculated difference (Offeor proposed as compared to Govt provide) is provided in columns X thru AE. (Offerors have accurately matched to the Govt provided hours if these columns reflect zeros). Additional detailed instructions are provided in "Offeror Crosswalk & Prop Hrs" tab, Cell B3.
6	Gov't Provided CORE LOE Hours: The Government has provided 'CORE' LOE Hours for Offerors to utilize in the preparation of their proposal submittal. Specifically, hours are provided by Government Labor Classification which the Offeror will be required to cross-map to their own Labor Classification(s). Further, this requirement would also apply to all of the Prime's Team-Member/subcontractor(s). The provided CORE LOE Hours shall not be changed (upward or downward) by the offeror and the distribution of hours between the Prime Contractor and their Team-Member/subcontractor(s) is left to the discretion of the Prime Contractor based on their proposal strategy and must be fully accounted for. The Govt has provided a note in Cell C56.
7	Pivot Table-Prime: This spreadsheet tab captures data from the "Offeror Crosswalk & Prop Hrs" tab (Rows 10 thru 159) based on Offeror input for the Prime proposed Labor Classifications and estimated hours per Prime Labor Classification. Action that is required by the Offeror: Once data is entered in the "Offeror Crosswalk & Prop Hrs" tab, Offeror is to place their cursor in Cell B5, from the menu selection above the table, select Analyze and then select Refresh. This will update/populate the Pivot Table with the Prime's proposed hours and will populate Prime Hours in the PWS 1.0 thru 6.0 tabs. The Prime & Sub Pivot table data is utilized in formulas in the "Govt Provided CORE LOE Hours" tab, columns N thru U, for comparison to the Govt provided hours.
8	Pivot Table-Sub: This spreadsheet tab captures data from the "Offeror Crosswalk & Prop Hrs" tab (Rows 165 thru 314) based on Offeror input for the Sub proposed Labor Classifications and estimated hours per Sub Labor Classification. Action that is required by the Offeror: Once data is entered in the "Offeror Crosswalk & Prop Hrs" tab, Offeror is to place their cursor in Cell B5, from the menu selection above the table, select Analyze and then select Refresh. This will update/populate the Pivot Table with the Offeror's Sub inputs. The Prime & Sub Pivot table data is utilized in formulas in the "Govt Provided CORE LOE Hours" tab, columns N thru U, for comparison to the Govt provided hours.
9	Labor Classification: The Offeror shall use this tab to identify labor classifications, exempt or non-exempt status. Include escalation, as applicable, for labor classifications proposed, starting in year 2 of contract performance. Escalation is applicable to Exempt employees only. In instances where Covered Labor (Collective Bargaining Agreement) or Non-Exempt, Non-Represented employees are being proposed, no escalation is to be proposed for out years as this will be accommodated via the negotiated Collective Bargaining Agreement(s) and the Brevard County local Wage Determination, as updated by the Department of Labor. Offerors are to propose their own labor classifications used in the normal performance of their duties and not the Government's Labor Classifications (GLC) if they are different. The Offeror shall select the overtime rate/multiplier (Offeror shall enter 1 for exempt employees which indicates no OT or 1.5 for Non-Exempt positions which indicates OT at 1.5 times the base rate).
10	Gov't Provided IDIQ LOE Hrs&Cost: The Government has provided Best Estimated Quantity (BEQ) IDIQ hours for evaluation purposes only and does not represent a commitment or guarantee on the part of the Government. Offerors shall not change (upward or downward) the Government provided BEQ values. Offerors are to fully account for the BEQs as provided by the Government. Offerors are to develop their Fully Burdened Straight Time Labor Rates (inclusive of Fee). Once developed, these Rates are multiplied by the Government provided hours to estimate total LOE IDIQ price by GFY. The Government is also requesting Offerors to provide fully burdened (inclusive of Fee) Over Time Labor Rates. These rates will be utilized, if necessary, during the KLXS III contract performance period. The Government has purposely omitted Overtime Hours for this proposal evaluation. Specific instructions pertaining to multiple Offeror labor classifications to a common Government labor classification are provided on Row 4 of the worksheet tab. If fully burdened labor rates for 'IDIQ' are different than for CORE, the Offeror and Major Subcontractor(s) (as applicable) shall include all supporting documentation on the development of the IDIQ and the CORE fully burdened labor rates, by Offeror and Major Subcontractor labor classification.
11	ODC: The Government has provided "Non-Proposed Cost" for ODCs. These values shall not be changed (upward or downward). If needed, the Offeror may propose additional ODCs to accommodate their proposed approach. If additional ODCs are proposed, the Offeror shall provide a description, PWS, and cost by GFY for each additional item proposed. Note: "Non-Proposed Cost" are applicable to the Prime Contractor only. Major Subcontractor(s) required to submit a KLXS III L-04b Basic Cost Template shall remove Non-Proposed Cost provided in this tab prior to submittal to their Prime. This action serves to prevent the inadvertent duplication of Non-Proposed Cost in the Prime's proposal submittal to the Government.
12	Subcontractor Lists: The Offeror shall identify the subcontractor name, Contract Type, and size of contractor (Major or Minor) and small business classification, as applicable. Contract Type and Small Business Class tables are located on the bottom of this worksheet for Offerors to add any additional Contract Type or grouping of small business classes in meeting their requirements. Once the table is populated, information will be available when using the relevant provided drop-down menus.
13	Subcontractor by PWS: The Offeror shall provide information for each subcontractor (Major and Minor). Offeror is required to input: Subcontractor name, whether the subcontractor is a Major or Minor subcontractor, PWS, Labor Classification (occupational title), Comparable Government Labor Classification (pull down menu selection), Subcontractor Productive Hours per WYE, Productive straight time hours for each labor classification, straight time direct labor rate for each labor classification, Fringe rate, Overhead rate, G&A rate, and Fee rate as applicable (for major and minor subcontractors where rate data is proprietary, the fully burdened rate will be input in the Straight Time Rate ($) cell). Major Subcontractor(s) with proprietary rate data (and do not want to share with the Prime Contractor) can submit their detailed rates and factor data as part of their direct submit to the NASA Contracting Officer, or in a sealed package with the Prime's proposal submittal. Prime Offerors shall conduct the appropriate cost or price analysis to establish the reasonableness of the proposed subcontract prices and to include the results of these analyses in their proposal submittal, in accordance with FAR 15.404-3(b). Address the basis for selection and degree of competition performed for subcontracts selected and include in Prime Offeror's proposal submittal to NASA.
14	SubCon summary by co.: This tab is formula driven with no Offeror input required (except for input required for Column O, Reference - Analysis of subcontractor proposal, as applicable).
15	Direct Labor Rate Cntrct Yr 1 through 8: The Offeror (Prime Contractor and or Major Subcontractor) shall input the Straight Time Rate per Hr ($/Hr) by Labor Classification for the first year of contract performance. Labor Classifications and Exempt/Union status are both automatically populated from information provided in the "Labor Classification" tab. Direct Labor Rate Cntrct Yr 2 through 8 are automatically populated/calculated based on information provided in the "Labor Classification" tab. For positions identified as Exempt, the Offeror shall identify any uncompensated overtime being proposed. To aide the Government in performing Cost Realism of proposed Base Labor Rates, The Prime contractor and any Major Subcontractor(s) shall include all supporting detailed documentation on the development of their proposed direct base labor rates, by Offeror Labor Classification (e.g. Salary Assessor detailed data; Corporate Data; other pertinent data source(s), etc.) in their Volume IV proposal submittal to the Government.
16	Rates and Factors Summary: The Offeror (Prime Contractor and Major Subcontractor, if applicable) shall identify the Labor Burden (Fringe) rate, G&A rate, Overhead rate by Government Fiscal Year and Offeror Fiscal Year for the complete KLXS III contract performance period. The Government has provided additional (other rates) inputs for those who require modified rate structure to ensure they are capturing all their proposed cost in a manner consistent with their accounting/disclosed practices. If the Offeror does include an additional rate, the Offeror shall include the basis for the rate development and sufficient information in the cost narrative to allow the Government to perform an adequate evaluation. Data in this worksheet tab shall be consistent with data provided in the Offeror's L-02c Rates & Factors template.
17	Total Price Summary Sheet: This sheet rolls up data from PWS' 1.0, 2.0, 3.0, 4.0, 5.0 and 6.0 and represents the CORE estimated price from the Offeror for the KLXS III Contract performance period (By Government Fiscal Year). No Offeror input is required for this tab.
18	Price Summary Sheets by PWS: PWS' 1.0, 2.0, 3.0, 4.0, 5.0 and 6.0 worksheets automatically populate with the following information: Labor Classifications, Regular Hour Rate ($/hr), labor dollars by Labor Classifications, Subcontractor proposed values, ODCs, labor burdened rate, overhead rate, and general and administrative rate by year, and Labor Hours for each PWS tabs. There are Adjustment boxes (Green Cells) which allows the Offeror to adjust (add or subtract) dollars for labor burdens, overhead, G&A and Fee. If the Offeror makes an adjustment, a detailed explanation of what the adjustment is for and how it was developed shall be included in the cost narrative in sufficient detail to allow the Government to perform an adequate evaluation.
19	Govt Provided CORE LOE Hours, Pivot Table-Prime, Pivot Table-Sub, Direct Labor Rate Cntrct Yr 2 through 8, Total, 1.0, 2.0, 3.0,4.0, 5.0,6.0, Dir Lab Straight Time Rate Sum, Price by PWS, WYE by PWS, Non-Labor Cost by PWS, Labor Cost by PWS, Total Labor Hours by Prime LC, Total WYE by Prime LC, Total Labor by SUB LC, Total WYE by SUB LC, KLXS III CORE & IDIQ Total Price, and PWS Structure are all summary worksheets which require no data input. These worksheets are populated automatically based on inputs provided by the Offeror. These summary tabs are designed to: Directly - Aide the Government with its cost proposal evaluation; and Indirectly - Provide Offerors with cross-cutting summary information for use and validation of its intended proposal strategy approach.

&"Times New Roman,Regular"&12 80KSC018R0006 KLXS III RFP&"Arial,Regular" &"Times New Roman,Regular"&12ATTACHMENT L-04b&"Arial,Regular"

&"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

ToC /xl/drawings/drawing2.xml#'Table%20of%20Contents'!A1 Table of Contents Table of Contents - all worksheets

1	Instructions	22	Direct Labor Rate Cntrct Year 8
2	Unions	23	Rates & Factors Summary
3	Fee&OH Determination	24	Total
4	Productive Hours	25	1.0 (Input required if incorporating any $ adjustments)
5	Offeror Crosswalk & Prop Hrs	26	2.0 (Input required if incorporating any $ adjustments)
6	Gov't Provided CORE LOE Hours	27	3.0 (Input required if incorporating any $ adjustments)
7	Pivot Table-Prime (no inputs but required to refresh)	28	4.0 (Input required if incorporating any $ adjustments)
8	Pivot Table-Sub (no inputs but required to refresh)	29	5.0 (Input required if incorporating any $ adjustments)
9	Labor Classification	30	6.0 (Input required if incorporating any $ adjustments)
10	Gov't ProvidedIDIQ LOE Hrs&Cost	31	Dir Lab Straight Time Rate Sum
11	ODC (Input required if adding to Government provided values)	32	Price by PWS
12	Subcontractor Lists	33	WYE by PWS
13	Subcontractor by PWS	34	Non-Labor Cost by PWS
14	SubCon summary by co. (Input required for Ref./BOE column only)	35	Labor Cost by PWS
15	Direct Labor Rate Cntrct Year 1	36	Total Labor Hours by Prime LC
16	Direct Labor Rate Cntrct Year 2	37	Total WYE by Prime LC
17	Direct Labor Rate Cntrct Year 3	38	Total Labor Hours by SUB LC
18	Direct Labor Rate Cntrct Year 4	39	Total WYE by Sub LC
19	Direct Labor Rate Cntrct Year 5	40	KLXS III CORE & IDIQ Total Price
20	Direct Labor Rate Cntrct Year 6	41	PWS Structure
21	Direct Labor Rate Cntrct Year 7	42	Template Changes _Updates
	Note:
	Green font color indIcates input is required, as applicable
	Blue font color indicates no input is required

&"Times New Roman,Regular"&12ATTACHMENT L-04b&"Arial,Regular"

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

Unions Union Identification and Details

	Productive Hours**
Union Name (Non-Represented Non-Exempt listed separately, if applicable)	GFY 19

Contract Year 1

(8 mos)	GFY 2020
Contract Year 2	GFY 2021
Contract Year 3	GFY 2022
Contract Year 4	GFY 2023
Contract Year 5	GFY 2024
Contract Year 6	GFY 2025
Contract Year 7	GFY 2026

Contract Year 8

0	0	0	0	ERROR:#REF!	0	Year	Month
								Exempt
								Non-represented non-exempt
								Represented-CBA

** Data must comply with applicable Collective Bargaining Agreements

Notes/Calculation for Contract Year 1, by Union (Contract starts February 1st, 2019):

Notes/Calculation for Contract Year 2, by Union:

Notes/Calculation for Contract Year 3, by Union:

Notes/Calculation for Contract Year 4, by Union:

Notes/Calculation for Contract Year 5, by Union:

Notes/Calculation for Contract Year 6, by Union:

Notes/Calculation for Contract Year 7, by Union:

Notes/Calculation for Contract Year 8, by Union:

Notes/Calculation for Contract Year 9, by Union:

&"Times New Roman,Regular"&12ATTACHMENT L-04b&"Arial,Regular"

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

ToC /xl/drawings/drawing3.xml#'Table%20of%20Contents'!A1 Fee & OH Determination

Fee and Overhead Determination

(across PWS levels)

NOTE: This table applies to Other Cost Elements (OCE) of the cost tabs only. Apply Overhead (OH)? Apply General and Administrative (G&A)? Apply fee?

SUBCONTRACTS (Fee Eligible)
SUBCONTRACTS (Non-Fee Bearing)	NO
OTHER DIRECT COSTS	NO

Note. Fee rates input are available in the "Rates & Factor Summary" Tab: Rates & Factors Summary

&"Times New Roman,Regular"&12ATTACHMENT L-04b&"Arial,Regular"

&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 Productive Hours

	Productive Hours			The Government provided Total Work Days & Hours, By Fiscal Year, are to be considered as informational only, Offerors are responsible for estimating and supporting their Annual Productive Hours as required herein. Leap Years (February) are indicated via red font in the tables below and results in 1 additional work day in GFY 2024.
	Exempt Employees
		GFY 2019
Contract Year 1 (8 mos)	GFY 2020
Contract Year 2	GFY 2021
Contract Year 3	GFY 2022
Contract Year 4	GFY 2023
Contract Year 5	GFY 2024
Contract Year 6	GFY 2025
Contract Year 7	GFY 2026
Contract Year 8		Contract Yr 1 - GFY 2019	Contract Yr 2 - GFY 2020				Contract Yr 3 - GFY 2021
	Detailed pricing information pertaining to this tab is provided in the "Instructions" tab, #4.			Year	Month	Days	Work Days	Work Hrs @ 8Hr/Day	Year	Month	Days	Work Days	Work Hrs @ 8Hr/Day	Year	Month	Days	Work Days	Work Hrs @ 8Hr/Day
				2018	OCT	31	23	184	2019	OCT	31	23	184	2020	OCT	31	22	176
	Notes/Calculation for Contract Year 1 (Contract starts February 1st, 2019):			2018	NOV	30	22	176	2019	NOV	30	21	168	2020	NOV	30	21	168
				2018	DEC	31	21	168	2019	DEC	31	22	176	2020	DEC	31	23	184
				2019	JAN	31	23	184	2020	JAN	31	23	184	2021	JAN	31	21	168
				2019	FEB	28	20	160	2020	FEB	29	20	160	2021	FEB	28	20	160
				2019	MAR	31	21	168	2020	MAR	31	22	176	2021	MAR	31	23	184
				2019	APR	30	22	176	2020	APR	30	22	176	2021	APR	30	22	176
	Notes/Calculation for Contract Year 2:			2019	MAY	31	23	184	2020	MAY	31	21	168	2021	MAY	31	21	168
				2019	JUN	30	20	160	2020	JUN	30	22	176	2021	JUN	30	22	176
				2019	JUL	31	23	184	2020	JUL	31	23	184	2021	JUL	31	22	176
				2019	AUG	31	22	176	2020	AUG	31	21	168	2021	AUG	31	22	176
				2019	SEP	30	21	168	2020	SEP	30	22	176	2021	SEP	30	22	176
				Total Work Days & Hours:			261	2088	Total Work Days & Hours:			262	2096	Total Work Days & Hours:			261	2088
	Notes/Calculation for Contract Year 3:

	Contract Yr 4 - GFY 2022					Contract Yr 5 - GFY 2023					Contract Yr 6 - GFY 2024
	Year	Month	Days	Work Days	Work Hrs @ 8Hr/Day	Year	Month	Days	Work Days	Work Hrs @ 8Hr/Day	Year	Month	Days	Work Days	Work Hrs @ 8Hr/Day
	2021	OCT	31	21	168	2022	OCT	31	21	168	2023	OCT	31	22	176
	2021	NOV	30	22	176	2022	NOV	30	22	176	2023	NOV	30	22	176
Notes/Calculation for Contract Year 4:	2021	DEC	31	23	184	2022	DEC	31	22	176	2023	DEC	31	21	168
	2022	JAN	31	21	168	2023	JAN	31	22	176	2024	JAN	31	23	184
	2022	FEB	28	20	160	2023	FEB	28	20	160	2024	FEB	29	21	168
	2022	MAR	31	23	184	2023	MAR	31	23	184	2024	MAR	31	21	168
	2022	APR	30	21	168	2023	APR	30	20	160	2024	APR	30	22	176
	2022	MAY	31	22	176	2023	MAY	31	23	184	2024	MAY	31	23	184
Notes/Calculation for Contract Year 5:	2022	JUN	30	22	176	2023	JUN	30	22	176	2024	JUN	30	20	160
	2022	JUL	31	21	168	2023	JUL	31	21	168	2024	JUL	31	23	184
	2022	AUG	31	23	184	2023	AUG	31	23	184	2024	AUG	31	22	176
	2022	SEP	30	22	176	2023	SEP	30	21	168	2024	SEP	30	20	160
	Total Work Days & Hours:			261	2088	Total Work Days & Hours:			260	2080	Total Work Days & Hours:			260	2080

Notes/Calculation for Contract Year 6:
	Contract Yr 7 - GFY 2025					Contract Yr 8 - GFY 2026
	Year	Month	Days	Work Days	Work Hrs @ 8Hr/Day	Year	Month	Days	Work Days	Work Hrs @ 8Hr/Day
	2024	OCT	31	23	184	2025	OCT	31	23	184
	2024	NOV	30	21	168	2025	NOV	30	20	160
	2024	DEC	31	22	176	- 0	DEC	31	23	184	- 0
Notes/Calculation for Contract Year 7:	2025	JAN	31	23	184	2026	JAN	31	22	176
	2025	FEB	28	20	160	2026	FEB	28	20	160
	2025	MAR	31	21	168	2026	MAR	31	22	176
	2025	APR	30	22	176	2026	APR	30	22	176
	2025	MAY	31	22	176	2026	MAY	31	21	168
	2025	JUN	30	21	168	2026	JUN	30	22	176
Notes/Calculation for Contract Year 8:	2025	JUL	31	23	184	2026	JUL	31	23	184
	2025	AUG	31	21	168	2026	AUG	31	21	168
	2025	SEP	30	22	176	2026	SEP	30	22	176
	Total Work Days & Hours:			261	2088	Total Work Days & Hours:			261	2088

Notes/Calculation for Contract Year 9:
	Source of Data: calendar-12.com

&"Times New Roman,Regular"&12ATTACHMENT L-04b&"Arial,Regular"

&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 Offeror Crosswalk & Prop Hrs

Pricing Instruction for this tab: This tab requires inputs (Cells with green background color) for Prime (Rows 12 thru 161) and all Subcontractor(s), Major and Minor, as applicable (Rows 167 thru 316). The following inputs are required: (a) Input name of Prime in Cell C12, for Sub(s) enter name in Cells C167 thru C316 as appropriate and applicable; (b) In Column D, select the appropriate PWS that the proposed Labor Classification will be performing (Choice is made via pull down menu selection); (c) In Column E, input Offeror's and Sub's Labor Classification titles, as applicable, Offerors (Prime & Major Sub(s) that will submit an L-04b pricing template) are required to add an underscore and PWS number at the end of each Offeror Labor Classification being proposed (for example, Engineer 2 being proposed for PWS 4 would be proposed as Engineer 2_4) in Cells E12 thru E161 (Prime) and Cells E167 thru E316 (Subcontractor). This is to prevent any pricing anomalies of Core hours in the PWS 1.0 thru 6.0 Summary tabs which is updated from the "Pivot Table-Prime" tab. ; (d) In Column F, select the equivalent Government Labor Classification (Choice is made via pull down menu selection); (e) input proposed hours for GFYs 2019 thru 2026 (Columns G thru N). Note that the Government has provided Labor Hours, by Government Labor Classification, in the "Gov't Provided CORE LOE Hours" tab for use in devleloping input in this tab. This pricing template has been designed such that the Prime Hours will be priced in the "1.0" thru "6.0" tabs. Subcontractor Hours (as applicable) will be priced in the "Subcontractor by PWS" tab. The sum of the Prime and Subs (if applicable) must equal the Government provided Labor Hours, in total, by PWS, by equivalent Government Labor Classification, and by GFY. The Government has provided a table which summarizes the Offeror's proposed Prime and Sub hours (located in the "Govt Provided CORE LOE Hours" tab, Columns M thru U) as well as a Difference table (located in the "Govt Provided CORE LOE Hours" tab, Columns W thru AE). To match the Government provided hours, the values in the Difference table must be 0 in all applicable cells (by Government LC, by PWS, and by GFY). A Positive number indicates the proposed value is above the Government provided number. A Negative number indicates the proposed value is below the Government provided number. Offerors are not to change or add any rows to this spreadsheet tab as this data feeds to the "Pivot Table-Prime" & "Pivot Table-Sub" tabs. The pivot table-prime data (Prime's hours) are captured in the PWS price summary tabs ("1.0" thru "6.0") The pivot table-sub data (Sub.hours) are captured in the "Subcontractor bu PWS' tab. Hours will be priced once the Offeror has developed their proposed fully burdened Labor Rate(s). Again, it is critcical that the Offeror achieves mathematical accuracy (Hours proposed for Prime and Sub(s), as applicable, are equal to the Government provided labor hours, by PWS, by Government Labor Classification, and by GFY) prior to proposal submittal to the Government.

KLXS III CORE LOE - Offeror to the Government Mapping of Labor Classifications - Proposed Hours, By Offeror Labor Classification and by GFY

Proposed Hours - Totals, by offeror LC (Prime & Subs, if applicable), MUST match, by Equivalent Gov't LC, by GFY, and by PWS, the hours provided in the "Gov't Provided CORE LOE Hours" tab.

BASE

Option 1

Option 2

Option 3

Option 4

Option 5

Prime

Prime Name

PWS

(Select via pull down menu selection)

Prime Labor Classification Title

Equivalent Government Labor Classification Title

(Select via pull down menu selection)

GFY 2019

(8 mos)

GFY 2020

GFY 2021

GFY 2022

GFY 2023

GFY 2024

GFY 2025

GFY 2026

Totals

Prime

- 0

Prime

Analyst 3

Prime

- 0

Subcontractor (Major)

Business Specialist 1

Prime

- 0

Subcontractor (Minor)

Business Specialist 2

Prime

- 0

Business Specialist 3

Prime

- 0

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.