Attachment 6 E3 Engineering and Strategic Planning Labor Rate Spreadsheet
View the file
Other files for this federal contract opportunity
Other files attached to Electromagnetic Spectrum (EMS) Services for Operations/Electromagnetic Environmental Effects (E3) Engineering, and Strategic Planning Support, newest first.
The file's text, extracted by GovTribe without its formatting.
INSTRUCTIONS
Offeror Name:
0
Evaluation Stage:
0
Government Excel Document Instructions for Offerors
1. Fill in the Offeror's name in yellow box contained in the worksheet labeled "Base Period".
2. Fill in the appropriate stage of the evaluation in the orange box contained in the worksheet labeled "Base Period". A description of each anticipated evaluation stage is provided below. Please note that not all stages may be utilized in the evaluation process.
Evaluation Stages
INITIAL -
First Submission
INTERIM -
Submission in Response to different round of Items for Negotiations (IFNs) (i.e. Interim 1, Interim 2, Interim 3,ect…)
FINAL -
Submission of Final Proposal Revision (FPR)
3. Fill in all cells highlighted in yellow on the following tabs within this workbook.
4. Once all the information is entered in the yellow cells, the Summary worksheet will have all Evaluation Amounts totaled for validation.
SUMMARY
Offeror Name:
0
Evaluation Stage:
0
LCAT #
Government Labor Category
Offeror's Internal Labor Category
Contractor Site
Contractor Site
Government Site
Government Site
Labor Hours
Dollars
Labor Hours
Dollars
1
Electrical/Electronics Engineer
0
1a
Senior Level
0
34,000
$ - 0
44,000
$ - 0
1b
Mid Level
0
350,000
$ - 0
758,157
$ - 0
1c
Entry Level
0
44,895
$ - 0
62,000
$ - 0
2
Software Programmer
0
2a
Senior Level
0
1,375
$ - 0
1,375
$ - 0
2b
Mid Level
0
2,500
$ - 0
3,125
$ - 0
2c
Entry Level
0
3,625
$ - 0
3,000
$ - 0
3
Electrical/Electronics Technician
0
3a
Senior Level
0
13,000
$ - 0
22,000
$ - 0
3b
Mid Level
0
41,000
$ - 0
48,000
$ - 0
3c
Entry Level
0
11,000
$ - 0
11,000
$ - 0
4
Program Manager
0
4a
Program Manager
0
10,500
$ - 0
2,750
$ - 0
5
System Administrator
0
5a
Senior Level
0
1,375
$ - 0
5,500
$ - 0
5b
Mid Level
0
2,750
$ - 0
22,000
$ - 0
5c
Entry Level
0
1,375
$ - 0
5,500
$ - 0
GRAND TOTAL LABOR
517,395
$ - 0
988,407
$ - 0
Travel
$ 55,000.00
$ 55,000.00
ODCs
$ 27,500.00
$ 27,500.00
GRAND TOTAL SUMMARY
517,395
$ 82,500.00
988,407
$ 82,500.00
Hours
Dollars
GRAND TOTAL
1,505,802
$ 165,000.00
Base Period
Offeror Name:
Evaluation Stage:
LCAT #
Government Labor Category
Offeror's Internal Labor Category
Contractor Site
Contractor Site
Contractor Site
Government Site
Government Site
Government Site
Loaded Labor Rate
Labor Hours
Dollars
Loaded Labor Rate
Labor Hours
Dollars
1
Electrical/Electronics Engineer
1a
Senior Level
6,000
$ - 0
6,000
$ - 0
1b
Mid Level
60,000
$ - 0
120,157
$ - 0
1c
Entry Level
12,000
$ - 0
10,000
$ - 0
2
Software Programmer
2a
Senior Level
250
$ - 0
250
$ - 0
2b
Mid Level
500
$ - 0
500
$ - 0
2c
Entry Level
2,000
$ - 0
500
$ - 0
3
Electrical/Electronics Technician
3a
Senior Level
4,000
$ - 0
4,000
$ - 0
3b
Mid Level
8,000
$ - 0
8,000
$ - 0
3c
Entry Level
2,000
$ - 0
2,000
$ - 0
4
Program Manager
4a
Program Manager
1,500
$ - 0
500
$ - 0
5
System Administrator
5a
Senior Level
250
$ - 0
1,000
$ - 0
5b
Mid Level
500
$ - 0
4,000
$ - 0
5c
Entry Level
250
$ - 0
1,000
$ - 0
TOTAL LABOR
97,250
$ - 0
157,907
$ - 0
Travel
$ 10,000.00
$ 10,000.00
ODCs
$ 5,000.00
$ 5,000.00
TOTAL BASE PERIOD
97,250
$ 15,000.00
157,907
$ 15,000.00
Hours
Dollars
GRAND TOTAL BASE PERIOD
255,157
$ 30,000.00
Option Period 1
Offeror Name:
0
Evaluation Stage:
0
LCAT #
Government Labor Category
Offeror's Internal Labor Category
Contractor Site
Contractor Site
Contractor Site
Government Site
Government Site
Government Site
Loaded Labor Rate
Labor Hours
Dollars
Loaded Labor Rate
Labor Hours
Dollars
1
Electrical/Electronics Engineer
0
1a
Senior Level
0
14,000
$ - 0
10,000
$ - 0
1b
Mid Level
0
80,000
$ - 0
200,000
$ - 0
1c
Entry Level
0
9,980
$ - 0
12,000
$ - 0
2
Software Programmer
0
2a
Senior Level
0
250
$ - 0
250
$ - 0
2b
Mid Level
0
500
$ - 0
500
$ - 0
2c
Entry Level
0
250
$ - 0
500
$ - 0
3
Electrical/Electronics Technician
0
3a
Senior Level
0
2,000
$ - 0
4,000
$ - 0
3b
Mid Level
0
10,000
$ - 0
8,000
$ - 0
3c
Entry Level
0
2,000
$ - 0
2,000
$ - 0
4
Program Manager
0
4a
Program Manager
0
2,000
$ - 0
500
$ - 0
5
System Administrator
0
5a
Senior Level
0
250
$ - 0
1,000
$ - 0
5b
Mid Level
0
500
$ - 0
4,000
$ - 0
5c
Entry Level
0
250
$ - 0
1,000
$ - 0
TOTAL LABOR
121,980
$ - 0
243,750
$ - 0
Travel
$ 10,000.00
$ 10,000.00
ODCs
$ 5,000.00
$ 5,000.00
TOTAL OPTION PERIOD 1
121,980
$ 15,000.00
243,750
$ 15,000.00
Hours
Dollars
GRAND TOTAL OPTION PERIOD 1
365,730
$ 30,000.00
Option Period 2
Offeror Name:
0
Evaluation Stage:
0
LCAT #
Government Labor Category
Offeror's Internal Labor Category
Contractor Site
Contractor Site
Contractor Site
Government Site
Government Site
Government Site
Loaded Labor Rate
Labor Hours
Dollars
Loaded Labor Rate
Labor Hours
Dollars
1
Electrical/Electronics Engineer
0
1a
Senior Level
0
4,000
$ - 0
8,000
$ - 0
1b
Mid Level
0
60,000
$ - 0
140,000
$ - 0
1c
Entry Level
0
7,915
$ - 0
14,000
$ - 0
2
Software Programmer
0
2a
Senior Level
0
250
$ - 0
250
$ - 0
2b
Mid Level
0
500
$ - 0
500
$ - 0
2c
Entry Level
0
750
$ - 0
750
$ - 0
3
Electrical/Electronics Technician
0
3a
Senior Level
0
2,000
$ - 0
4,000
$ - 0
3b
Mid Level
0
6,000
$ - 0
10,000
$ - 0
3c
Entry Level
0
2,000
$ - 0
2,000
$ - 0
4
Program Manager
0
4a
Program Manager
0
2,000
$ - 0
500
$ - 0
5
System Administrator
0
5a
Senior Level
0
250
$ - 0
1,000
$ - 0
5b
Mid Level
0
500
$ - 0
4,000
$ - 0
5c
Entry Level
0
250
$ - 0
1,000
$ - 0
TOTAL LABOR
86,415
$ - 0
186,000
$ - 0
Travel
$ 10,000.00
$ 10,000.00
ODCs
$ 5,000.00
$ 5,000.00
TOTAL OPTION PERIOD 2
86,415
$ 15,000.00
186,000
$ 15,000.00
Hours
Dollars
GRAND TOTAL OPTION PERIOD 2
272,415
$ 30,000.00
Option Period 3
Offeror Name:
0
Evaluation Stage:
0
LCAT #
Government Labor Category
Offeror's Internal Labor Category
Contractor Site
Contractor Site
Contractor Site
Government Site
Government Site
Government Site
Loaded Labor Rate
Labor Hours
Dollars
Loaded Labor Rate
Labor Hours
Dollars
1
Electrical/Electronics Engineer
0
1a
Senior Level
0
4,000
$ - 0
8,000
$ - 0
1b
Mid Level
0
60,000
$ - 0
130,000
$ - 0
1c
Entry Level
0
6,000
$ - 0
14,000
$ - 0
2
Software Programmer
0
2a
Senior Level
0
250
$ - 0
250
$ - 0
2b
Mid Level
0
250
$ - 0
500
$ - 0
2c
Entry Level
0
250
$ - 0
500
$ - 0
3
Electrical/Electronics Technician
0
3a
Senior Level
0
2,000
$ - 0
4,000
$ - 0
3b
Mid Level
0
8,000
$ - 0
10,000
$ - 0
3c
Entry Level
0
2,000
$ - 0
2,000
$ - 0
4
Program Manager
0
4a
Program Manager
0
2,000
$ - 0
500
$ - 0
5
System Administrator
0
5a
Senior Level
0
250
$ - 0
1,000
$ - 0
5b
Mid Level
0
500
$ - 0
4,000
$ - 0
5c
Entry Level
0
250
$ - 0
1,000
$ - 0
TOTAL LABOR
85,750
$ - 0
175,750
$ - 0
Travel
$ 10,000.00
$ 10,000.00
ODCs
$ 5,000.00
$ 5,000.00
TOTAL OPTION PERIOD 3
85,750
$ 15,000.00
175,750
$ 15,000.00
Hours
Dollars
GRAND TOTAL OPTION PERIOD 3
261,500
$ 30,000.00
Option Period 4
Offeror Name:
0
Evaluation Stage:
0
LCAT #
Government Labor Category
Offeror's Internal Labor Category
Contractor Site
Contractor Site
Contractor Site
Government Site
Government Site
Government Site
Loaded Labor Rate
Labor Hours
Dollars
Loaded Labor Rate
Labor Hours
Dollars
1
Electrical/Electronics Engineer
0
1a
Senior Level
0
4,000
$ - 0
8,000
$ - 0
1b
Mid Level
0
60,000
$ - 0
112,000
$ - 0
1c
Entry Level
0
6,000
$ - 0
8,000
$ - 0
2
Software Programmer
0
2a
Senior Level
0
250
$ - 0
250
$ - 0
2b
Mid Level
0
500
$ - 0
750
$ - 0
2c
Entry Level
0
250
$ - 0
500
$ - 0
3
Electrical/Electronics Technician
0
3a
Senior Level
0
2,000
$ - 0
4,000
$ - 0
3b
Mid Level
0
6,000
$ - 0
8,000
$ - 0
3c
Entry Level
0
2,000
$ - 0
2,000
$ - 0
4
Program Manager
0
4a
Program Manager
0
2,000
$ - 0
500
$ - 0
5
System Administrator
0
5a
Senior Level
0
250
$ - 0
1,000
$ - 0
5b
Mid Level
0
500
$ - 0
4,000
$ - 0
5c
Entry Level
0
250
$ - 0
1,000
$ - 0
TOTAL LABOR
84,000
$ - 0
150,000
$ - 0
Travel
$ 10,000.00
$ 10,000.00
ODCs
$ 5,000.00
$ 5,000.00
TOTAL OPTION PERIOD 4
84,000
$ 15,000.00
150,000
$ 15,000.00
Hours
Dollars
GRAND TOTAL OPTION PERIOD 4
234,000
$ 30,000.00
6 Mo. Extension
Offeror Name:
0
Evaluation Stage:
0
LCAT #
Government Labor Category
Offeror's Internal Labor Category
Contractor Site
Contractor Site
Contractor Site
Government Site
Government Site
Government Site
Loaded Labor Rate
Labor Hours
Dollars
Loaded Labor Rate
Labor Hours
Dollars
1
Electrical/Electronics Engineer
0
1a
Senior Level
0
2,000
$ - 0
4000
$ - 0
1b
Mid Level
0
30,000
$ - 0
56000
$ - 0
1c
Entry Level
0
3,000
$ - 0
4000
$ - 0
2
Software Programmer
0
2a
Senior Level
0
125
$ - 0
125
$ - 0
2b
Mid Level
0
250
$ - 0
375
$ - 0
2c
Entry Level
0
125
$ - 0
250
$ - 0
3
Electrical/Electronics Technician
0
3a
Senior Level
0
1,000
$ - 0
2000
$ - 0
3b
Mid Level
0
3,000
$ - 0
4000
$ - 0
3c
Entry Level
0
1,000
$ - 0
1000
$ - 0
4
Program Manager
0
4a
Program Manager
0
1,000
$ - 0
250
$ - 0
5
System Administrator
0
5a
Senior Level
0
125
$ - 0
500
$ - 0
5b
Mid Level
0
250
$ - 0
2000
$ - 0
5c
Entry Level
0
125
$ - 0
500
$ - 0
TOTAL LABOR
42,000
$ - 0
75,000
$ - 0
Travel
$ 5,000.00
$ 5,000.00
ODCs
$ 2,500.00
$ 2,500.00
TOTAL 6 MO. EXTENSION PERIOD
42,000
$ 7,500.00
75,000
$ 7,500.00
Hours
Dollars
GRAND TOTAL 6 MO. EXTENSION PERIOD
117,000
$ 15,000.00
File details come from the government source that posted it.
Updated .