Attachment L-1 Cost Forms Amendment 1.xlsx

XLSX spreadsheet 66 KB Posted Jul 14, 2023

Attached to: Final Request for Proposal for Glenn-Langley Administrative Support Services (GLASS) Federal contract opportunity
Solicitation number: 80LARC23R0014
Issued by: National Aeronautics and Space Administration Langley Research Center

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains a cost proposal template for the Glenn-Langley Administrative Support Services (GLASS) contract opportunity issued by the National Aeronautics and Space Administration Langley Research Center.

The template includes multiple worksheets for the offeror and any subcontractors to provide fully burdened labor rates for various categories across multiple performance periods. Labor categories include Secretary II, Secretary III, Administrative Assistant, Administrative Assistant Senior, Management Analyst, and Management Analyst Journeyman. Pricing is also required for phase-in activities, core support services at Langley Research Center and Glenn Research Center, other direct costs, and indefinite delivery/indefinite quantity labor categories. Staffing plans must demonstrate the allocation of work-years by labor category between the offeror and any subcontractors.

View the file

Other files for this federal contract opportunity

Other files attached to Final Request for Proposal for Glenn-Langley Administrative Support Services (GLASS), newest first.
File	Type	Posted
Exhibit F2 - GRC WD 2015-4727 Rev 21.pdf	PDF	Jul 21, 2023
GLASS SF 33 Amendment 3.pdf	PDF	Jul 21, 2023
SF 30 Amendment 3.pdf	PDF	Jul 21, 2023
Exhibit F1 - LaRC WD 2015-4341 Rev 24.pdf	PDF	Jul 21, 2023
SF 30 Amendment 2.pdf	PDF	Jul 17, 2023
GLASS Question and Answers Amendment 2.pdf	PDF	Jul 17, 2023
GLASS RFP Section A - M Amendment 1.pdf	PDF	Jul 14, 2023
SF 30 Amendment 1.pdf	PDF	Jul 14, 2023
GLASS Question and Answers Amendment 1.pdf	PDF	Jul 14, 2023
GLASS Exhibits.zip	ZIP file	Jun 30, 2023
GLASS Final RFP Section A - M.pdf	PDF	Jun 30, 2023
GLASS Final Request for Proposal (RFP) Cover Letter.pdf	PDF	Jun 30, 2023
GLASS Question and Answers.pdf	PDF	Jun 30, 2023
GLASS Attachments.zip	ZIP file	Jun 30, 2023

Show all 14

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.

Instructions

	Cost Template Instructions
1	Please Read instructions in solicitation section L.
2	The following worksheets are formula driven requiring no input except for adding offeror name:
	CLIN Summary
	LaRC Services
	Sub LaRC Services
	GRC Serices
	Sub GRC Services
3	Offeror to provide payrates and markup by labor category on following worksheets:
	LaRC Labor Rate Buildup
	GRC Labor Rate Buildup
4	Offeror's Sub to provide payrates and markup by labor category on following worksheets:
	Sub LaRC Rate Buildup
	Sub GRC Rate Buildup
	NOTE: Add additional worksheets for additional Subs as necessary and adjust other worksheets to accommodate changes.
5	Complete Phase-in, identifying costs and effort.
	Phase-in
6	Distribute WYE's to Offeror and its Sub(s). Make sure ALL WYE's are allocated.
	Staffing Plan
	NOTE: They may be sample data on worksheets that needs to be removed.

Cost Template Data Flow

GRC Services

LaRC Labor Rate Buildup

CLIN SUMMARY

Sub LaRC Rate Buildup

Sub LaRC Services

LaRC Services Sub GRC Services

GRC Labor Rate Buildup

Sub GRC Rate Buildup

CLIN Summary

CLIN SUMMARY

GLASS

CLIN Summary

CLIN	Description	Phase-In	Base Period	Option Period 1	Option Period 2	Option Period 3	Total
CLIN 0001	Phase-In (FFP)	$ 5,000					$ 5,000
CLIN 0002	LaRC Core Services		$ 312,000	$ 156,000	$ 156,000	$ 156,000	$ 780,000
CLIN 0003	GRC Core Services		$ 6,396,000	$ 3,198,000	$ 3,198,000	$ 3,198,000	$ 15,990,000
CLIN 0004	LaRC Other Direct costs (ODC) CR no fee		$ 100,000	$ 50,000	$ 50,000	$ 50,000	$ 250,000
CLIN 0005	GRC Other Direct costs (ODC) CR no fee		$ 100,000	$ 50,000	$ 50,000	$ 50,000	$ 250,000
CLIN 0006	IDIQ LaRC		$ 550,000	$ 275,000	$ 375,000	$ 450,000	$ 1,650,000
CLIN 0007	IDIQ GRC		$ 550,000	$ 275,000	$ 375,000	$ 450,000	$ 1,650,000
CLIN 0008	IDIQ Other Centers		$ 900,000	$ 500,000	$ 600,000	$ 700,000	$ 2,700,000
Total		$ 5,000	$ 8,908,000	$ 4,504,000	$ 4,804,000	$ 5,054,000	$ 23,275,000

All data flows from other worksheets. Confirm accuracy of formulas.

Yellow Highlighted numbers are government provided, do not change.

Phase-in

GLASS

Offeror: _________________________________________________
Description	Price
List effort and price	$ 5,000
Total	$ 5,000
Offeror to provide Phase-in price with description of efforts to be performed.

LaRC Services

GLASS

Offeror: _________________________________________________

Hours/WYE 2080

		Year 1			Year 2			Base Period		Option Period 1 -Year 3			Option Period 2 -Year 4			Option Period 3 -Year 5			Total
Labor category	WYE's	Hours	Rate	Cost	Hours	Rate	Cost			Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Cost
Secretary II	1.0	2080	$75.00	$ 156,000	2080	$75.00	$ 156,000	4,160.0	$ 312,000	2080	$75.00	$ 156,000	2080	$75.00	$ 156,000	2080	$75.00	$ 156,000	10400	$ 780,000
Secretary III	0.0	0	$75.00	$ - 0	0	$77.25	$ - 0	- 0	$ - 0	0	$75.00	$ - 0	0	$75.00	$ - 0	0	$75.00	$ - 0	0	$ - 0
Administrative Assistant	0.0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Administrative Assistant, Senior	0.0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Management Analyst	0.0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Management Analyst, Journeyman	0.0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0

Subtotal Labor	1.0	2080	$ 156,000	2080	$ 156,000	4160	$ 312,000	2080	$ 156,000	2080	$ 156,000	2080	$ 156,000	10400	$ 780,000
Sub	0.0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0
Total	1.0	2080	$ 156,000		$ 156,000	4160	$ 312,000	2080	$ 156,000	2080	$ 156,000	2080	$ 156,000	10400	$ 780,000
travel/training

All data flows from other worksheets

All data flows from other worksheets. Confirm accuracy of formulas.

LaRC Labor Rate Buildup

Offeror: _________________________________________________
Year 1
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate
					Hours per WYE reconciliation
Secretary II	$50.00	$25.00	$75.00		Total annual hours	2080
Secretary III	$50.00	$25.00	$75.00		Less Holiday
Administrative Assistant	$0.00	$0.00	$0.00		Less Vacation
Administrative Assistant, Senior	$0.00	$0.00	$0.00		Less other leave
Management Analyst	$0.00	$0.00	$0.00		Hours/WYE	2080
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00		Offeror to provide:
labor cat 9	$0.00	$0.00	$0.00		Labor Rate
labor cat 10	$0.00	$0.00	$0.00		Markup INCLUDING all indirect costs AND profit
labor cat 11	$0.00	$0.00	$0.00		Source for payrates
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 2
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$50.00	$25.00	$75.00
Secretary III	$50.00	$25.00	$75.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 3
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$50.00	$25.00	$75.00
Secretary III	$50.00	$25.00	$75.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 4
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$50.00	$25.00	$75.00
Secretary III	$50.00	$25.00	$75.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 5
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$50.00	$25.00	$75.00
Secretary III	$50.00	$25.00	$75.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Sub LaRC Services

GLASS

Offeror: _________________________________________________

Hours/WYE 2080

		Year 1			Year 2			Base Period		Option Period 1 -Year 3			Option Period 2 -Year 4			Option Period 3 -Year 5			Total
Labor category	WYE's	Hours	Rate	Cost	Hours	Rate	Cost			Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Cost
Secretary II	0	0	$93.00	$ - 0	0	$95.04	$ - 0	- 0	$ - 0	0	$97.14	$ - 0	0	$99.31	$ - 0	0	$101.53	$ - 0	0	$ - 0
Secretary III	0	0	$100.00	$ - 0	0	$102.25	$ - 0	- 0	$ - 0	0	$104.57	$ - 0	0	$106.95	$ - 0	0	$109.41	$ - 0	0	$ - 0
Administrative Assistant	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Administrative Assistant, Senior	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Management Analyst	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Management Analyst, Journeyman	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0

Total Sub	0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0
All data flows from other worksheets

All data flows from other worksheets. Confirm accuracy of formulas.

Sub LaRC Rate Buildup

Offeror: _________________________________________________
Year 1
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate
					Hours per WYE reconciliation
Secretary II	$68.00	$25.00	$93.00		Total annual hours	2080
Secretary III	$75.00	$25.00	$100.00		Less Holiday
Administrative Assistant	$0.00	$0.00	$0.00		Less Vacation
Administrative Assistant, Senior	$0.00	$0.00	$0.00		Less other leave
Management Analyst	$0.00	$0.00	$0.00		Hours/WYE	2080
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00		Offeror's Sub to provide:
labor cat 8	$0.00	$0.00	$0.00		Labor Rate
labor cat 9	$0.00	$0.00	$0.00		Markup INCLUDING all indirect costs AND profit
labor cat 10	$0.00	$0.00	$0.00		Source for payrates
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 2
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$70.04	$25.00	$95.04
Secretary III	$77.25	$25.00	$102.25
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 3
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$72.14	$25.00	$97.14
Secretary III	$79.57	$25.00	$104.57
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 4
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$74.31	$25.00	$99.31
Secretary III	$81.95	$25.00	$106.95
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 5
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$76.53	$25.00	$101.53
Secretary III	$84.41	$25.00	$109.41
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

GRC Services

GLASS

Offeror: _________________________________________________

Hours/WYE 2080

		Year 1			Year 2			CLIN 1- Base Period		Option Period 1 -Year 3			Option Period 2 -Year 4			Option Period 3 -Year 5			Total
Labor category	WYE's	Hours	Rate	Cost	Hours	Rate	Cost			Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Cost
Secretary II	0	0	$85.00	$ - 0	0	$85.00	$ - 0	- 0	$ - 0	0	$85.00	$ - 0	0	$85.00	$ - 0	0	$85.00	$ - 0	0	$ - 0
Secretary III	15	31200	$85.00	$ 2,652,000	31200	$85.00	$ 2,652,000	62,400.0	$ 5,304,000	31200	$85.00	$ 2,652,000	31200	$85.00	$ 2,652,000	31200	$85.00	$ 2,652,000	156000	$ 13,260,000
Administrative Assistant	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Administrative Assistant, Senior	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Management Analyst	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Management Analyst, Journeyman	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0

Subtotal Labor	15	31200	$ 2,652,000	31200	$ 2,652,000	62,400.0	$ 5,304,000	31200	$ 2,652,000	31200	$ 2,652,000	31200	$ 2,652,000		$ 13,260,000
Sub		5200	$ 546,000	5200	$ 546,000	10400	$ 1,092,000	5200	$ 546,000	5200	$ 546,000	5200	$ 546,000	26000	$ 2,730,000
Subtotal All Labor	15	36400	$ 3,198,000	36400	$ 3,198,000	72800	$ 6,396,000	36400	$ 3,198,000	36400	$ 3,198,000	36400	$ 3,198,000

All data flows from other worksheets

All data flows from other worksheets. Confirm accuracy of formulas.

GRC Labor Rate Buildup

Offeror: _________________________________________________
Year 1
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate
					Hours per WYE reconciliation
Secretary II	$60.00	$25.00	$85.00		Total annual hours	2080
Secretary III	$60.00	$25.00	$85.00		Less Holiday
Administrative Assistant	$0.00	$0.00	$0.00		Less Vacation
Administrative Assistant, Senior	$0.00	$0.00	$0.00		Less other leave
Management Analyst	$0.00	$0.00	$0.00		Hours/WYE	2080
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00		Offeror to provide:
labor cat 8	$0.00	$0.00	$0.00		Labor Rate
labor cat 9	$0.00	$0.00	$0.00		Markup INCLUDING all indirect costs AND profit
labor cat 10	$0.00	$0.00	$0.00		Source for payrates
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 2
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$60.00	$25.00	$85.00
Secretary III	$60.00	$25.00	$85.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 3
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$60.00	$25.00	$85.00
Secretary III	$60.00	$25.00	$85.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 4
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$60.00	$25.00	$85.00
Secretary III	$60.00	$25.00	$85.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 5
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$60.00	$25.00	$85.00
Secretary III	$60.00	$25.00	$85.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Sub GRC Services

GLASS

Offeror: _________________________________________________

Hours/WYE 2080

		Year 1			Year 2			CLIN 1- Base Period		Option Period 1 -Year 3			Option Period 2 -Year 4			Option Period 3 -Year 5			Total
Labor category	WYE's	Hours	Rate	Cost	Hours	Rate	Cost			Hours	Rate	Cost	Hours	Rate	Cost	Hours	Rate	Cost	Hours	Cost
Secretary II	0	0	$105.00	$ - 0	0	$105.00	$ - 0	- 0	$ - 0	0	$105.00	$ - 0	0	$105.00	$ - 0	0	$105.00	$ - 0	0	$ - 0
Secretary III	2.5	5200	$105.00	$ 546,000	5200	$105.00	$ 546,000	10,400.0	$ 1,092,000	5200	$105.00	$ 546,000	5200	$105.00	$ 546,000	5200	$105.00	$ 546,000	26000	$ 2,730,000
Administrative Assistant	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Administrative Assistant, Senior	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Management Analyst	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0
Management Analyst, Journeyman	0	0	$0.00	$ - 0	0	$0.00	$ - 0	- 0	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$0.00	$ - 0	0	$ - 0

Total Sub	2.5	5200	$ 546,000	5200	$ 546,000	10400	$ 1,092,000	5200	$ 546,000	5200	$ 546,000	5200	$ 546,000	26000	$ 2,730,000
All data flows from other worksheets

All data flows from other worksheets. Confirm accuracy of formulas.

Sub GRC Rate Buildup

Offeror: _________________________________________________
Year 1
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate
Logistics					Hours per WYE reconciliation
Secretary II	$80.00	$25.00	$105.00		Total annual hours	2080
Secretary III	$80.00	$25.00	$105.00		Less Holiday
Administrative Assistant	$0.00	$0.00	$0.00		Less Vacation
Administrative Assistant, Senior	$0.00	$0.00	$0.00		Less other leave
Management Analyst	$0.00	$0.00	$0.00		Hours/WYE	2080
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00		Offeror's Sub to provide:
labor cat 8	$0.00	$0.00	$0.00		Labor Rate
labor cat 9	$0.00	$0.00	$0.00		Markup INCLUDING all indirect costs AND profit
labor cat 10	$0.00	$0.00	$0.00		Source for payrates
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 2
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$80.00	$25.00	$105.00
Secretary III	$80.00	$25.00	$105.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 3
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$80.00	$25.00	$105.00
Secretary III	$80.00	$25.00	$105.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 4
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$80.00	$25.00	$105.00
Secretary III	$80.00	$25.00	$105.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

Year 5
Labor Category	Direct Labor Rate	Markup	Bill Rate Includes Fee	Source for Pay Rate

Secretary II	$80.00	$25.00	$105.00
Secretary III	$80.00	$25.00	$105.00
Administrative Assistant	$0.00	$0.00	$0.00
Administrative Assistant, Senior	$0.00	$0.00	$0.00
Management Analyst	$0.00	$0.00	$0.00
Management Analyst, Journeyman	$0.00	$0.00	$0.00
labor cat 7	$0.00	$0.00	$0.00
labor cat 8	$0.00	$0.00	$0.00
labor cat 9	$0.00	$0.00	$0.00
labor cat 10	$0.00	$0.00	$0.00
labor cat 11	$0.00	$0.00	$0.00
labor cat 12	$0.00	$0.00	$0.00
labor cat 13	$0.00	$0.00	$0.00
labor cat 14	$0.00	$0.00	$0.00
labor cat 15	$0.00	$0.00	$0.00

LaRC IDIQ Schedule

	Bill Rate
Labor Category	Year 1	Year 2	Year 3	Year 4	Year 5
Secretary II
Secretary III
Administrative Assistant
Administrative Assistant, Senior
Management Analyst
Management Analyst, Journeyman
Provide support for IDIQ rates proposed. Additional worksheet(s) may be added.

GRC IDIQ Schedule

	Bill Rate
Labor Category	Year 1	Year 2	Year 3	Year 4	Year 5
Secretary II
Secretary III
Administrative Assistant
Administrative Assistant, Senior
Management Analyst
Management Analyst, Journeyman
Provide support for IDIQ rates proposed. Additional worksheet(s) may be added.

Other Center IDIQ Schedule

	Bill Rate
Labor Category	Year 1	Year 2	Year 3	Year 4	Year 5
Secretary II
Secretary III
Administrative Assistant
Administrative Assistant, Senior
Management Analyst
Management Analyst, Journeyman
Provide support for IDIQ rates proposed. Additional worksheet(s) may be added.

Staffing Plan

Langley Research Center
Labor Category	LaRC Core WYE	Exempt Status	Labor Rate ($/Hr)	Offeror WYE allocation	Sub WYE Allocation	Unallocated
Secretary II	1	Non-Exempt		1		0
Secretary III	20	Non-Exempt				20
Administrative Assistant	0	Non-Exempt				0
Administrative Assistant, Senior	15	Non-Exempt				15
Management Analyst	2	Exempt				2
Management Analyst, Journeyman	2	Exempt				2
	40			1	0	39

Glenn Research Center
Labor Category	GRC Core WYE	Exempt Status	Labor Rate ($/Hr)	Offeror WYE allocation	Sub WYE Allocation	Unallocated
Secretary II	19	Non-Exempt				19
Secretary III	19	Non-Exempt		15	2.5	1.5
Administrative Assistant	11	Non-Exempt				11
Administrative Assistant, Senior	0	Non-Exempt				0
Management Analyst	1	Exempt				1
Management Analyst, Journeyman	0	Exempt				0
	50			15	2.5	32.5
Distribute WYE's to Offeror and its Sub(s). Make sure ALL WYE's are allocated.

File details come from the government source that posted it. Updated Jul 14, 2023.