Attachment 1A - Historical Workload 14 Dec 2022.xlsx

XLSX spreadsheet 43 KB Posted Dec 19, 2022

Attached to: Base Operations Support (BOS) - Tyndall AFB
Solicitation number: FA481922R0014
Issued by: Department of the Air Force Air Combat Command

View the file

Other files

File	Type	Posted
Solicitation Amendment FA481922R00140005 SF 30.pdf	PDF	Jan 13, 2023
Solicitation Amendment FA481922R00140004 SF 30.pdf	PDF	Dec 30, 2022
CBA Memorandum of Agreement 14 Jun 2022.docx.pdf	PDF	Dec 30, 2022
Attachment 1A - Historical Workload 30 Dec 2022.xlsx	XLSX spreadsheet	Dec 30, 2022
Attachment 1 - Performance Work Statement 14 Dec 2022.docx	DOCX document	Dec 19, 2022
Attachment 1R - Asbestos Management and Operation Plan.pdf	PDF	Dec 19, 2022
Attachment 10 - PPI Worksheet 14 Dec 2022.docx	DOCX document	Dec 19, 2022
Solicitation Amendment FA481922R00140003 SF 30.pdf	PDF	Dec 19, 2022
Attachment 1C - Air Force Preventative Maintenance Task List Data 14 Dec 2022.xlsx	XLSX spreadsheet	Dec 19, 2022
Attachment 1D - Licenses and Certifications 14 Dec 2022.xlsx	XLSX spreadsheet	Dec 19, 2022
Attachment 1Q - Historical Real Property Asset Inventory Data 14 Dec 2022.pdf	PDF	Dec 19, 2022
Attachment 1S - 325 CES Pest Management Plan.docx	DOCX document	Dec 19, 2022
Attachment 1U - Tyndall Hazardous Waste Management Plan.pdf	PDF	Dec 19, 2022
Attachment 5 - Addendum to FAR 52.212-1 14 Dec 2022.docx	DOCX document	Dec 19, 2022
Attachment 7 - Proposal Volume II Quick View Revision 1 14 Dec 2022.pdf	PDF	Dec 19, 2022
Attachment 1B - Real Property and Facility Inventory 14 Dec 2022.xlsx	XLSX spreadsheet	Dec 19, 2022
Attachment 9 - Manpower Matrix Worksheet 14 Dec 2022.xlsx	XLSX spreadsheet	Dec 19, 2022
Solicitation Amendment FA481922R00140002.pdf	PDF	Dec 7, 2022
Solicitation Amendment FA481922R00140001.pdf	PDF	Nov 2, 2022
Site Visit Attendee List.xlsx	XLSX spreadsheet	Oct 7, 2022
Pre-Proposal Site Visit.pdf	PDF	Oct 7, 2022
Attachment 1A - Historical Workload 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Attachment 1P - Cranes_Trolley_Rail Systems_Lifts_Hoists 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Attachment 5 - Addendum to FAR 52.212-1 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 6 - Addendum to FAR 52.212-2 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 9 - Manpower Matrix Worksheet 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Attachment 10 - PPI Worksheet 20 July 2022.docx	DOCX document	Sep 13, 2022
Attachment 1 - PWS 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 1C - Air Force Preventative Maintenance Task List Data 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Attachment 1K--Publications and Forms 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 2 - CBA 2021 01 Mar 2021.pdf	PDF	Sep 13, 2022
Attachment 12 - Sample Subcontractor Letter of Consent 20 July 2022.docx	DOCX document	Sep 13, 2022
Attachment 15 - Base Access Request EAL 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Attachment 1E - Maps and Work Area Layouts 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 1G - Govt-Furnished Equip (Non- EAID) 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 1L - Local Plans 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 1M - Definitions 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 1O - Utility Privatization PODs 20 July 2022.docx	DOCX document	Sep 13, 2022
Attachment 3 - SCLS WD 2015-4559 Rev 21 28 July 2022.pdf	PDF	Sep 13, 2022
Attachment 4 - DD254 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 8 - Pricing Matrix Worksheet 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Attachment 11 - Past Performance Questionnaire 20 July 2022.docx	DOCX document	Sep 13, 2022
Attachment 13 - Sample Client Authorization Letter 20 July 2022.docx	DOCX document	Sep 13, 2022
Attachment 14 - Financial Responsibility Questionnaire 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 16 - Question Worksheet 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Solicitation - FA481922R0014.pdf	PDF	Sep 13, 2022
Attachment 1B - Real Property and Facility Inventory 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Attachment 1D - Licenses and Certifications 20 July 2022.xlsx	XLSX spreadsheet	Sep 13, 2022
Attachment 1F - Govt-Furnished Equip (EAID) 20 July 2022.pdf	PDF	Sep 13, 2022
Attachment 1H - Govt-Furnished ADPE 20 July 2022.pdf	PDF	Sep 13, 2022

Show 40 more

50 files listed here. See the rest on GovTribe.

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.

Craftsperson Manpower

Man-Hours by Craft
	Scope	All Shops	441 WA Sweepers	442 PX Pavements	451-IA Vertical	452-2A Service Call Carpenter	452-2B Service Call Electrical	452-2C Service Call HVAC	452-2D Service Call Plumber	453-3A / 452 2E Alarms	453-3C PM HVAC	454-4C Plumbers	454-4D Welder	469-EC Liquid Fuels	462-LF Pest Management	471 IT High Voltage	473-OX Power Production	492-CX EMCS
FY18	PM	19,334.9	4,667.0	24.0	9.0	20.5	17.5	0.0	0.0	1,618.3	7,117.4	1,464.3	8.0	1,865.3	150.0	480.7	1,892.9	0.0
	DSW Emergency	228.3	0.0	5.5	3.2	14.7	33.7	7.0	52.2	4.0	9.5	73.5	3.0	5.5	13.5	0.5	2.5	0.0
	DSW Urgent	27,397.8	72.5	1,329.2	3,071.1	1,314.2	3,713.7	6,291.5	2,317.8	1,098.3	1,136.4	2,625.3	270.0	276.5	376.5	766.5	443.8	2,294.5
	DSW Routine	21,340.4	8.0	1,233.0	4,691.8	1,950.1	4,496.6	559.0	523.7	1,413.9	993.6	1,958.4	331.5	322.8	1,070.5	532.0	228.5	1,027.0
	FOCUS	6,587.4	34.0	1,522.0	1,615.5	724.8	838.5	27.5	227.0	227.3	184.1	874.2	104.5	5.5	6.0	72.5	117.5	6.5
	LUC 19 (Labor Ops/Service/Collection WO)	20,982.8	48.0	2,691.0	156.5	1,477.8	83.0	64.2	1.0	77.5	1,249.8	3,012.9	59.5	72.0	3,331.5	1,556.0	7,100.6	1.5

FY19	PM	16,116.0	3,468.0	83.0	24.9	32.0	10.6	0.0	0.0	1,045.9	5,161.5	1,456.6	52.0	2,074.5	152.6	946.2	1,608.2	0.0
	DSW Emergency	332.3	0.0	1.2	6.0	14.7	74.2	37.7	54.9	4.0	20.2	75.5	2.0	0.0	11.5	20.0	6.4	4.0
	DSW Urgent	27,147.8	15.5	1,137.0	3,670.5	1,191.7	4,712.4	5,908.7	2,488.8	1,065.2	1,368.2	2,820.7	220.0	360.3	116.5	337.5	201.3	1,533.5
	DSW Routine	22,041.0	24.0	2,591.0	4,361.7	2,486.8	4,158.8	513.4	535.9	1,790.5	1,004.4	2,130.7	325.5	256.2	679.0	499.5	144.6	539.0
	FOCUS	7,767.9	42.5	2,107.5	2,138.5	343.0	944.0	477.4	53.0	301.3	475.9	47.5	166.5	36.0	24.0	591.0	19.8	0.0
	LUC 19 (Labor Ops/Service/Collection WO)	26,193.3	141.0	2,340.5	945.0	2,134.7	776.0	883.2	458.5	56.5	1,351.1	3,650.2	2.5	0.0	4,152.4	1,036.8	8,264.9	0.0

FY20	PM (RWP)	15,672.6	3,524.2	132.0	18.4	25.5	16.1	0.0	40.9	939.6	4,546.8	1,754.7	744.5	1,279.6	144.0	837.2	1,669.1	0.0
	DSW Emergency	162.8	0.0	0.0	33.0	10.5	16.0	23.9	12.3	4.5	27.1	17.9	9.5	0.0	5.5	0.0	1.2	1.4
	DSW Urgent	19,395.2	4.5	540.0	2,571.6	882.5	2,589.4	4,735.2	2,294.6	895.1	1,335.2	1,234.8	210.0	141.9	158.0	175.2	43.3	1,583.9
	DSW Routine	18,773.4	49.0	2,242.5	3,345.3	2,111.2	3,699.2	986.1	623.0	912.6	789.6	1,758.2	409.5	172.5	578.5	583.5	345.7	167.0
	FOCUS	22,243.7	266.0	4,215.0	2,905.0	1,276.5	4,231.5	1,471.0	538.5	681.8	1,067.7	1,754.9	290.0	280.0	793.0	1,074.3	1,328.0	70.5
	LUC 19 (Labor Ops/Service/Collection WO)	21,008.9	18.5	1,599.5	90.5	2,663.6	26.5	336.4	0.0	5.0	674.5	3,979.2	17.0	0.0	3,436.5	1,024.5	7,137.2	0.0

FY21	PM (RWP)	6,587.4	34.0	1,522.0	1,615.5	724.8	838.5	27.5	227.0	227.3	184.1	874.2	104.5	5.5	6.0	72.5	117.5	6.5
	DSW Emergency	99.4	0.0	0.0	0.0	12.7	4.5	25.7	17.9	0.0	27.1	0.0	0.0	0.0	9.1	1.0	0.0	1.4
	DSW Urgent	36,655.4	3,572.2	2,823.0	174.9	1,503.3	99.1	64.2	41.9	1,017.1	5,796.6	4,767.6	804.0	1,351.6	3,475.5	2,393.2	8,769.7	1.5
	DSW Routine	35,511.2	3,472.5	623.0	2,596.5	914.5	2,600.0	4,735.2	2,294.6	1,941.0	6,496.7	2,691.4	262.0	2,216.4	310.6	1,121.4	1,651.5	1,583.9
	FOCUS	19,105.7	49.0	2,243.7	3,351.3	2,125.9	3,773.4	1,023.8	677.9	916.6	809.8	1,833.7	411.5	172.5	590.0	603.5	352.1	171.0
	LUC 19 (Labor Ops/Service/Collection WO)	21,810.2	87.4	2,108.7	445.0	1,508.8	281.8	450.8	183.8	49.9	1,002.6	3,346.8	24.5	32.0	4,085.0	1,260.1	6,943.2	0.0

4 Yr Total	PM	57,710.9	11,693.2	1,761.0	1,667.8	802.8	882.7	27.5	267.9	3,831.1	17,009.8	5,549.8	909.0	5,224.9	452.6	2,336.6	5,287.7	6.5
	DSW Emergency	822.8	0.0	6.7	42.2	52.6	128.4	94.3	137.3	12.5	83.9	166.9	14.5	5.5	39.6	21.5	10.1	6.8
	DSW Urgent	110,596.2	3,664.7	5,829.2	9,488.1	4,891.7	11,114.6	16,999.6	7,143.1	4,075.7	9,636.4	11,448.4	1,504.0	2,130.3	4,126.5	3,672.4	9,458.1	5,413.4
	DSW Routine	97,666.0	3,553.5	6,689.5	14,995.3	7,462.6	14,954.6	6,793.7	3,977.2	6,058.0	9,284.3	8,538.7	1,328.5	2,967.9	2,638.6	2,736.4	2,370.3	3,316.9
	FOCUS	55,704.7	391.5	10,088.2	10,010.3	4,470.2	9,787.4	2,999.7	1,496.4	2,127.0	2,537.5	4,510.3	972.5	494.0	1,413.0	2,341.3	1,817.4	248.0
	LUC 19 (Labor Ops/Service/Collection WO)	89,995.2	294.9	8,739.7	1,637.0	7,784.9	1,167.3	1,734.6	643.3	188.9	4,278.0	13,989.1	103.5	104.0	15,005.4	4,877.4	29,445.9	1.5

4 Yr Average	PM	14,427.7	2,923.3	440.3	417.0	200.7	220.7	6.9	67.0	957.8	4,252.5	1,387.5	227.3	1,306.2	113.2	584.2	1,321.9	1.6
	DSW Emergency	205.7	0.0	1.7	10.6	13.2	32.1	23.6	34.3	3.1	21.0	41.7	3.6	1.4	9.9	5.4	2.5	1.7
	DSW Urgent	27,649.1	916.2	1,457.3	2,372.0	1,222.9	2,778.7	4,249.9	1,785.8	1,018.9	2,409.1	2,862.1	376.0	532.6	1,031.6	918.1	2,364.5	1,353.4
	DSW Routine	24,416.5	888.4	1,672.4	3,748.8	1,865.7	3,738.7	1,698.4	994.3	1,514.5	2,321.1	2,134.7	332.1	742.0	659.7	684.1	592.6	829.2
	FOCUS	13,926.2	97.9	2,522.1	2,502.6	1,117.6	2,446.9	749.9	374.1	531.8	634.4	1,127.6	243.1	123.5	353.3	585.3	454.4	62.0
	LUC 19 (Labor Ops/Service/Collection WO)	22,498.8	73.7	2,184.9	409.3	1,946.2	291.8	433.6	160.8	47.2	1,069.5	3,497.3	25.9	26.0	3,751.3	1,219.3	7,361.5	0.4
	Total Hours	103123.96	4899.44	8278.57	9460.18	6366.21	9508.74	7162.34	3416.30	4073.29	10707.48	11050.80	1208.01	2731.64	5918.91	3996.40	12097.36	2248.28

Non-Craftsperson Manpower

Man-Hours by Position
	Position Description	ANNUAL HOURS
FY18/19/20/21	Engineers	6240
	Engineering Techs	10400
	Customer Service	6240
	HAZMAT/Security	2080
	Administration	2080
	Planner	4160
	Buyers	4160
	QC/Safety	4160
	Account Specialist	2080
	IT Administration	2080
	Warehouse Personnel	6240

TOTAL 43680

Annual DSW Count

Annual DSW Count by Craft
	Scope	All Shops	441 WA Sweepers	442 PX Pavements	451-IA Vertical	452-2A Service Call Carpenter	452-2B Service Call Electrical	452-2C Service Call HVAC	452-2D Service Call Plumber	453-3A / 452 2E Alarms	453-3C PM HVAC	454-4C Plumbers	454-4D Welder	469-EC Liquid Fuels	462-LF Pest Management	471 IT High Voltage	473-OX Power Production	492-CX EMCS
FY18	DSW Emergency	176	0	7	3	13	30	9	42	2	6	35	2	3	19	1	4	0
	DSW Urgent	17,053	28	506	1,371	936	2,541	3,902	2,013	672	690	1,576	114	137	282	298	242	1,745
	DSW Routine	11,808	1	388	2,084	1,593	2,420	309	434	913	558	985	132	141	854	264	90	642

FY19	DSW Emergency	200	0	1	4	10	42	28	28	4	13	36	1	0	22	4	5	2
	DSW Urgent	14,281	5	349	1,418	923	2,421	3,358	1,554	662	692	1,283	84	153	108	220	103	948
	DSW Routine	10,578	6	735	1,485	1,811	2,088	272	294	970	564	958	109	105	510	324	54	293

FY20	DSW Emergency	108	0	0	18	4	14	15	10	4	14	14	2	0	11	0	1	1
	DSW Urgent	10,601	4	190	1,151	543	1,416	2,843	1,193	643	772	634	81	62	140	79	24	826
	DSW Routine	7,668	13	637	1,111	1,033	1,654	358	260	458	319	754	140	68	449	247	74	93

FY21	DSW Emergency	66	0	0	0	8	4	14	14	0	3	0	0	0	18	2	0	3
	DSW Urgent	3,687	1	38	282	272	544	847	679	232	6	320	14	14	182	35	14	207
	DSW Routine	2,999	9	147	352	507	409	271	205	100	25	499	8	8	291	128	17	23

4 Yr Total	DSW Emergency	550	0	8	25	35	90	66	94	10	36	33	5	3	70	7	10	6
	DSW Urgent	45,622	38	1,083	4,222	2,674	6,922	10,950	5,439	2,209	2,160	5,305	293	366	712	632	383	3,726
	DSW Routine	33,053	29	1,907	5,032	4,944	6,571	1,210	1,193	2,441	1,466	6,939	389	322	2,104	963	235	1,051

4 Yr Average	DSW Emergency	137	0	2	6	9	23	17	23	3	9	8	1	1	18	2	3	2
	DSW Urgent	11,406	10	271	1,056	669	1,731	2,738	1,360	552	540	1,326	73	92	178	158	96	932
	DSW Routine	8,263	7	477	1,258	1,236	1,643	303	298	610	367	1,735	97	81	526	241	59	263

FOCUS and PM Count

FOCUS Program Count			Preventative Maintenance Count
Fiscal Year	Quarter	Focus Project Count	Fiscal Year	Quarter	PM Count
FY21	Q1	13	FY18	Oct	533
FY21	Q2	11	FY18	Nov	1016
FY21	Q3	12	FY18	Dec	928
FY21	Q4	10	FY18	Jan	781
FY20	Q1	11	FY18	Feb	784
FY20	Q2	12	FY18	Mar	690
FY20	Q3	11	FY18	Apr	866
FY20	Q4	13	FY18	May	606
FY19	Q1	11	FY18	Jun	557
FY19	Q2	13	FY18	Jul	(No info - ACES Issue)
FY19	Q3	12	FY18	Aug	742
FY19	Q4	14	FY18	Sep	931
FY18	Q1	10	FY19	Oct	No PM (Hurricane Michael)
FY18	Q2	12	FY19	Nov	No PM (Hurricane Michael)
FY18	Q3	10	FY19	Dec	143
FY18	Q4	12	FY19	Jan	679
			FY19	Feb	697
			FY19	Mar	697
			FY19	Apr	620
			FY19	May	591
			FY19	Jun	784
			FY19	Jul	894
			FY19	Aug	749
			FY19	Sep	824
			FY20	Oct	922
			FY20	Nov	820
			FY20	Dec	1058
			FY20	Jan	1090
			FY20	Feb	875
			FY20	Mar	993
			FY20	Apr	657
			FY20	May	776
			FY20	Jun	793
			FY20	Jul	876
			FY20	Aug	953
			FY20	Sep	970
			FY21	Oct	884
			FY21	Nov	963
			FY21	Dec	800
			FY21	Jan	985
			FY21	Feb	921
			FY21	Mar	756
			FY21	Apr	693
			FY21	May	(NEXGEN-IT Implementation - NO Items)
			FY21	Jun	(NEXGEN-IT Implementation - NO Items)
			FY21	Jul	(NEXGEN-IT Implementation - NO Items)
			FY21	Aug	(NEXGEN-IT Implementation - NO Items)
			FY21	Sep	(NEXGEN-IT Implementation - NO Items)

File details come from the government source that posted it. Updated Dec 19, 2022.