Attachment 7 - LOE Rev 1.xlsx

XLSX spreadsheet 23 KB Posted Apr 19, 2023

Attached to: Waterfront Operations at Building V-47, Naval Station Norfolk in Norfolk, Virginia.
Solicitation number: N0016723R0002
Issued by: Department of the Navy Naval Sea Systems Command

View the file

Other files

File	Type	Posted
Attachment 14 - DOL Wage Deter 2015-0213_R30.pdf	PDF	May 2, 2023
N0016723R0002_Amendment 03.pdf	PDF	May 2, 2023
Attachment 5 - Previous Contracting Efforts Rev 1.docx	DOCX document	Apr 19, 2023
Attachment 14 - DOL Wage Deter 2015-0213.pdf	PDF	Apr 19, 2023
Attachment 13 - DOL Wage Deter 2007-0134.pdf	PDF	Apr 19, 2023
N0016723R0002_Amendment_02.pdf	PDF	Apr 19, 2023
N0016723R0002_Amend. 0001_Conformed.pdf	PDF	Mar 22, 2023
Attachment 6 - Cost Summary Format.xls	XLS spreadsheet	Mar 21, 2023
N0016723R0002_Waterfront Ops at V47_21MAR2023.pdf	PDF	Mar 21, 2023
Attachment 11_GFP.xlsx	XLSX spreadsheet	Mar 21, 2023
Attachment 3 - Staffing Plan with Cost.xlsx	XLSX spreadsheet	Mar 21, 2023
Attachment 9 - DD Form 1861.pdf	PDF	Mar 21, 2023
Attachment 7 - LOE.xlsx	XLSX spreadsheet	Mar 21, 2023
Attachment 1 - Subcontracting Plan Coversheet.docx	DOCX document	Mar 21, 2023
Attachment 5 - Previous Contracting Efforts.docx	DOCX document	Mar 21, 2023
CDRLs A001-A014.pdf	PDF	Mar 21, 2023
Attachment 10 - DOL Wage Deter 15-4341.pdf	PDF	Mar 21, 2023
Attachment 4 - Past Performance Questionnaire.docx	DOCX document	Mar 21, 2023
Attachment 8 - Key Personnel Qualifications.docx	DOCX document	Mar 21, 2023
Attachment 12 - RFI Industry Question and Answer.pdf	PDF	Mar 21, 2023
Attachment 2 - Staffing Plan without Cost.xlsx	XLSX spreadsheet	Mar 21, 2023

Show all 21

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.

Historical Analysis FD09FD10

FD09/FD10 Last Two Years Historical Analysis
					TOTAL		MDF or Cost Estimating TIs		KBS Historical			Historical Code 813 MSC Support
TO	Year	POP	Invoiced HRs	labor Invoiced	TI Hours	Obligated Labor	TI Hours	Obligated Labor	TI Hours	Obligated Labor	Rates	Hours	Cost	Rate
FD09	BY	1/14/15-1/13/16	34,566	$3,117,760.18	46,675	$3,589,789.87	8,936	$797,960.00	37,739	$2,791,829.87	$73.98	0	$0.00
FD09	OY1	1/14/16-1/13/17	52,788	$3,801,010.28	57,261	$3,981,734.70	15,442	$1,165,342.00	41,819	$2,816,392.70	$67.35	0	$0.00
FD09	OY2	1/14/17-1/13/18	62,036	$4,700,630.00	53,227	$4,103,130.48	709	$46,000.00	52,518	$4,057,130.48	$77.25	3,849	$384,930.00
FD09	OY3	12/29/17-12/28/18	74,092	$5,783,632.21	59,577	$4,754,451.22	403	$35,000.00	59,174	$4,719,451.22	$79.76	23,734	$2,142,782.00	$90.28
FD09	OY4	12/28/18-12/28/19	TBD	TBD	69,996	$5,266,097.00	677	$59,000.00	69,319	$5,207,097.00	$75.12	27,419	$2,171,237.00	$79.19

FD10	BY			$2,590,719.48
FD10	OY1			$320,958.00
FD10	OY2	5/14/17-5/13/18	42,906	$3,681,705.95	24,663	$2,198,517.00	18,244	$1,483,188.95	$81.30
FD10	OY3	5/14/18-5/13/19	44,970	$3,737,442.40	26,014	$2,230,404.40	18,956	$1,507,038.00	$79.50

FD09/FD10 KBS	2017/2018	77,418	$6,202,640.17	$80.12
FD09/FD10 KBS	2018/2019	88,275	$6,714,135.00	$76.06
					Code 813 Future Requirements
			Employment Cost Index (ECI) Dec 2018 = 2.5%	ECI/year	Historical Hrs + Historical Travel + $2M/Yr
2020 Annual KBS Labor Requirements (from HISTORICAL)				2.5%	Hours	Cost	ODC	Total	ODC %
LOE Requirements = 2019 Hrs (88,275) x 2018 Rate x ECI		88,275	$7,249,319.50	$82.12	27,419	$2,251,703.10	ERROR:#REF!	ERROR:#REF!
Plus-Up: Code 813 (Pete Connor) MSC N74/SRD work increase (email 3/27) - 2020		ERROR:#REF!	ERROR:#REF!	$82.12	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
2020 Annual KBS Requirements (BY) (Initial)		ERROR:#REF!	ERROR:#REF!	$82.12
2020 Annual KBS Requirements (BY) (Rounded)		111,000	$9,115,541.94	$82.12	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

2021 Annual KBS Requirements (OY1) 111,000 $9,343,430.49 $84.18 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

2022 Annual KBS Requirements (OY2) 111,000 $9,577,016.25 $86.28 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

2023 Annual KBS Requirements (OY3) 111,000 $9,577,016.25 $88.44 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

2024 Annual KBS Requirements (OY4) 111,000 $9,577,016.25 $90.65 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

KBS 5 Year Task Order LABOR Requirements	555,000	ERROR:#REF!		ERROR:#REF!	ERROR:#REF!
			ODC %
KBS 5 Year Task Order ODC Requirements		ERROR:#REF!	5%			ERROR:#REF!	ERROR:#REF!

TOTAL KBS Requirements ERROR:#REF! ERROR:#REF!

LOE

Task Order Labor Categories Labor Mix Total 1st Year Hours 2nd Year Hours 3rd Year Hours 4th Year Hours 5th Year Hours

Government Site, Key Personnel
Program Manager	Senior	9,600.0	1,920.0	1,920.0	1,920.0	1,920.0	1,920.0
Site Manager	Senior	9,600.0	1,920.0	1,920.0	1,920.0	1,920.0	1,920.0
Boat Captain A	Senior	48,000.0	9,600.0	9,600.0	9,600.0	9,600.0	9,600.0
Boat Captain A Overtime	Senior	5,760.0	1,152.0	1,152.0	1,152.0	1,152.0	1,152.0
Engineering Tech V Mechanical	Senior	9,600.0	1,920.0	1,920.0	1,920.0	1,920.0	1,920.0
Engineering Tech V Mechanical Overtime	Senior	3,840.0	768.0	768.0	768.0	768.0	768.0
Engineering Tech V Electronics	Senior	9,600.0	1,920.0	1,920.0	1,920.0	1,920.0	1,920.0
Engineering Tech V Electronics Overtime	Senior	2,880.0	576.0	576.0	576.0	576.0	576.0

Government Site, Non-Key Personnel
EHSA Technician	Mid-Level	19,200.0	3,840.0	3,840.0	3,840.0	3,840.0	3,840.0
Administrative Assistant	Mid-Level	28,800.0	5,760.0	5,760.0	5,760.0	5,760.0	5,760.0
General Clerk	Mid-Level	29,088.0	5,817.6	5,817.6	5,817.6	5,817.6	5,817.6
Maintenance Scheduler	Mid-Level	19,200.0	3,840.0	3,840.0	3,840.0	3,840.0	3,840.0
Receptionist	Mid-Level	19,200.0	3,840.0	3,840.0	3,840.0	3,840.0	3,840.0
Tool Attendant	Mid-Level	19,200.0	3,840.0	3,840.0	3,840.0	3,840.0	3,840.0
Warehouse Specialist	Mid-Level	29,280.0	5,856.0	5,856.0	5,856.0	5,856.0	5,856.0
Able Seaman	Mid-Level	19,200.0	3,840.0	3,840.0	3,840.0	3,840.0	3,840.0
Able Seaman Overtime	Mid-Level	5,760.0	1,152.0	1,152.0	1,152.0	1,152.0	1,152.0
Boat Captain B	Mid-Level	28,800.0	5,760.0	5,760.0	5,760.0	5,760.0	5,760.0
Boat Captain B Overtime	Mid-Level	4,800.0	960.0	960.0	960.0	960.0	960.0
Diver	Mid-Level	2,880.0	576.0	576.0	576.0	576.0	576.0
Engineering Tech IV Electronics	Senior	19,200.0	3,840.0	3,840.0	3,840.0	3,840.0	3,840.0
Engineering Tech IV Electronics Overtime	Senior	3,840.0	768.0	768.0	768.0	768.0	768.0
Engineering Tech IV Mechanical	Senior	32,640.0	7,680.0	5,760.0	5,760.0	5,760.0	7,680.0
Engineering Tech IV Mechanical Overtime	Senior	6,720.0	1,344.0	1,344.0	1,344.0	1,344.0	1,344.0
Mechanic	Mid-Level	38,400.0	7,680.0	7,680.0	7,680.0	7,680.0	7,680.0
Mechanic Overtime	Mid-Level	5,760.0	1,152.0	1,152.0	1,152.0	1,152.0	1,152.0
Technical Instructor/Course Developer	Mid-Level	2,880.0	576.0	576.0	576.0	576.0	576.0
Truckdriver	Mid-Level	9,600.0	1,920.0	1,920.0	1,920.0	1,920.0	1,920.0
Truckdriver Overtime	Mid-Level	4,800.0	960.0	960.0	960.0	960.0	960.0
Marine Surveyor	Mid-Level	2,400.0	480.0	480.0	480.0	480.0	480.0
Welder	Mid-Level	19,200.0	3,840.0	3,840.0	3,840.0	3,840.0	3,840.0
Welder Overtime	Mid-Level	2,880.0	576.0	576.0	576.0	576.0	576.0
Subtotal Government Site Hours		472,608.0
Government Site %		100%
Labor Hour Totals		472,608.00	95,673.60	93,753.60	93,753.60	93,753.60	95,673.60

Labor Mix Hours/Percentages

Total

Senior Hours	161,280.0
Senior %	34.13%

Mid-level Hours	311,328.0
Mid-Level %	65.87%

Junior Hours	0.0
Junior %	0.00%

Hours	472,608.0
%	100%

Attachment 7 - N0016723R0002

File details come from the government source that posted it. Updated Apr 19, 2023.