Technical Exhibit 3 – Estimated Workload Data.xlsx

XLSX spreadsheet 28 KB Posted Feb 14, 2020

Attached to: Preventative Maintenance and Repair of World War II Era and
Solicitation number: W912DW20Q0009
Issued by: Department of the Army Corps of Engineers Engineering District Seattle

About this file

Written by GovTribe AI · Dec 27, 2023

This technical exhibit provides estimated workload data for preventative maintenance and repair service orders at Joint Base Lewis-McChord in Washington state over a four-year period. The document includes breakdowns of estimated service orders by year, type, and required craft. The majority of annual service requests are for electrical and HVAC work. Solicitation W912DW20Q0009 seeks these preventative maintenance and repair services on a World War II-era and relocatable facilities at JBLM. As a Service-Disabled Veteran-Owned Small Business set-aside, the solicitation is open to SDVOSBs. Responses are due by the date specified on the solicitation, and the award period will cover a one-year base period and four one-year options.

View the file

Other files

File	Type	Posted
Amendment 0002_W912DW20Q0009_Prev Maint Rpr WWII Relocatables.pdf	PDF	Mar 4, 2020
Amendment 0002_Offeror Questions and Government Responses_20200303.pdf	PDF	Mar 4, 2020
Amendment 0001 Prev Maint Rpr WWII Relocatables.pdf	PDF	Mar 2, 2020
Site Visit Attendance Roster_W912DW20Q0009_20200221.pdf	PDF	Mar 2, 2020
Technical Exhibit 11 Heating Equipment List.xlsx	XLSX spreadsheet	Mar 2, 2020
Revised PWS_Preventative Maintenance and Repair of World War II Era and Relocata....pdf	PDF	Mar 2, 2020
Technical Exhibit 4 – Building List .xlsx	XLSX spreadsheet	Feb 14, 2020
Technical Exhibit 6 – Notice of Intent to Remove Friable Asbestos Material.pdf	PDF	Feb 14, 2020
Technical Exhibit 9 – Service Order Log.xlsx	XLSX spreadsheet	Feb 14, 2020
Technical Exhibit 2 – Deliverables Schedule.pdf	PDF	Feb 14, 2020
Technical Exhibit 10 – Customer Complaint Record.pdf	PDF	Feb 14, 2020
Technical Exhibit 5C SOP for C&D Waste Planning and Reporting.pdf	PDF	Feb 14, 2020
Technical Exhibit 8 – Preventative Maintenance Checklist.pdf	PDF	Feb 14, 2020
PWS_Preventative Maintenance and Repair of World War II Era and Relocatable Facilities.pdf	PDF	Feb 14, 2020
Quality Assurance Surveillance Plan (QASP).pdf	PDF	Feb 14, 2020
Technical Exhibit 1-Performance Requirements Summary.pdf	PDF	Feb 14, 2020
Technical Exhibit 7 – Task Items for Service Orders.pdf	PDF	Feb 14, 2020
Pricing Schedule.pdf	PDF	Feb 14, 2020
SCA Wage Determination_2015-5539_20191223.pdf	PDF	Feb 14, 2020
Technical Exhibit 5A C&D Diversion-Disposal Transaction Report Summary.pdf	PDF	Feb 14, 2020
Combined Synopsis-Solicitation_W912DW20Q0009_Prev Maint & Rpr WWII & Relocatables.pdf	PDF	Feb 14, 2020
Technical Exhibit 5B C&D Reporting Instructions.pdf	PDF	Feb 14, 2020

Show all 22

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.

Sheet1

TECHNICAL EXHIBIT 3

ESTIMATED WORKLOAD DATA

							SERVICE ORDERS BY TYPE					SERVICE ORDERS BY CRAFT
Total Service Requests By Year							BASE YEAR					BASE YEAR
	Base	1st OY	2nd OY	3rd OY	4th OY		EMERGENCY	URGENT	ROUTINE			Electrical	HVAC	Plumbing	Structural	Other	total
November	248	196	175	51	42	November	3	39	206	248	November	13	119	92	22	2	248
December	133	64	113	51	35	December	25	37	71	133	December	22	50	29	25	7	133
January	136	37	113	29	49	January	22	38	76	136	January	19	47	40	24	6	136
February	169	101	79	41	54	February	10	25	134	169	February	29	43	31	57	9	169
March	127	44	100	35	76	March	2	36	89	127	March	21	36	37	26	7	127
April	148	44	48	19	64	April	6	25	117	148	April	21	74	16	35	2	148
May	50	30	101	22	72	May	1	5	44	50	May	9	10	6	18	7	50
June	102	31	19	15	30	June	4	10	88	102	June	28	12	32	29	1	102
July	55	28	34	6	36	July	0	8	47	55	July	9	7	26	11	2	55
August	34	21	17	29	60	August	1	5	28	34	August	4	10	9	8	3	34
September	36	36	89	73	45	September	0	4	32	36	September	5	27	1	3	0	36
October	39	192	59	30	41	October	0	10	29	39	October	10	13	3	13	0	39
Total	1,277	824	947	401	604	TOTALS	74	242	961	1277	TOTALS	190	448	322	271	46	1277
Monthly Average Service Requests	106	69	79	33	50
Average Annual Service Requests:					811		SERVICE ORDERS BY TYPE					SERVICE ORDERS BY CRAFT
							1ST OPTION YEAR					1ST OPTION YEAR
							EMERGENCY	URGENT	ROUTINE			Electrical	HVAC	Plumbing	Structural	Other	total
						November	0	22	174	196	November	10	171	4	11	0	196
						December	0	31	33	64	December	13	29	8	14	0	64
						January	2	21	14	37	January	11	13	7	4	2	37
						February	1	27	73	101	February	8	41	9	42	1	101
						March	2	10	32	44	March	12	10	5	17	0	44
						April	0	14	30	44	April	13	11	7	13	0	44
						May	0	8	22	30	May	8	2	9	10	1	30
						June	0	8	23	31	June	10	5	4	11	1	31
						July	0	6	22	28	July	10	2	4	10	2	28
						August	0	5	16	21	August	5	2	6	8	0	21
						September	0	10	26	36	September	13	4	4	13	2	36
						October	0	21	171	192	October	38	13	9	79	53	192
						TOTALS	5	183	636	824	TOTALS	151	303	76	232	62	824

	SERVICE ORDERS BY TYPE					SERVICE ORDERS BY CRAFT
	2ND OPTION YEAR					2ND OPTION YEAR
	EMERGENCY	URGENT	ROUTINE			Electrical	HVAC	Plumbing	Structural	Other	total
November	1	28	146	175	November	25	19	8	93	30	175
December	1	33	79	113	December	18	34	6	54	1	113
January	3	38	72	113	January	27	36	11	36	3	113
February	0	27	52	79	February	11	17	10	36	5	79
March	0	23	77	100	March	18	21	11	50	0	100
April	0	19	29	48	April	13	12	4	16	3	48
May	1	12	88	101	May	12	58	6	22	3	101
June	1	4	14	19	June	6	6	1	5	1	19
July	3	5	26	34	July	5	16	3	7	3	34
August	0	4	13	17	August	1	0	8	5	3	17
September	0	4	85	89	September	3	52	7	26	1	89
October	0	17	42	59	October	15	16	8	19	1	59
TOTALS	10	214	723	947	TOTALS	154	287	83	369	54	947

	SERVICE ORDERS BY TYPE					SERVICE ORDERS BY CRAFT
	3RD OPTION YEAR					3RD OPTION YEAR
	EMERGENCY	URGENT	ROUTINE			Electrical	HVAC	Plumbing	Structural	Other	total
November	1	28	22	51	November	12	22	7	9	1	51
December	1	21	29	51	December	8	20	7	16	0	51
January	1	16	12	29	January	8	8	3	9	1	29
February	0	12	29	41	February	10	17	1	12	1	41
March	1	15	19	35	March	4	10	5	13	3	35
April	0	9	10	19	April	5	5	3	4	2	19
May	1	0	21	22	May	9	4	4	4	1	22
June	15	0	0	15	June	4	2	5	2	2	15
July	0	1	5	6	July	1	1	1	2	1	6
August	0	6	23	29	August	2	1	3	23	0	29
September	1	7	65	73	September	1	55	3	11	3	73
October	4	7	19	30	October	8	11	5	6	0	30
TOTALS	25	122	147	401	TOTALS	72	156	47	111	15	401
	SERVICE ORDERS BY TYPE					SERVICE ORDERS BY CRAFT
	4TH OPTION YEAR					4TH OPTION YEAR
	EMERGENCY	URGENT	ROUTINE			Electrical	HVAC	Plumbing	Structural	Other	total
November	0	8	34	42	November	5	26	2	9	0	42
December	0	17	18	35	December	7	17	5	6	0	35
January	0	10	39	49	January	5	14	7	21	2	49
February	0	19	35	54	February	6	19	10	19	0	54
March	0	40	36	76	March	9	29	11	27	0	76
April	0	15	49	64	April	17	10	7	29	1	64
May	0	8	64	72	May	8	47	4	13	0	72
June	0	5	25	30	June	5	5	3	17	0	30
July	0	3	33	36	July	3	1	3	29	0	36
August	0	13	47	60	August	13	8	7	30	2	60
September	0	7	38	45	September	17	7	7	14	0	45
October	0	30	11	41	October	2	19	7	12	1	41
TOTALS	0	175	429	604	TOTALS	97	202	73	226	6	604

Sheet2

2014-11	2014-12	2015-01	2015-02	2015-03	2015-04	2015-05	2015-06	2015-07	2015-08	2015-09	2015-10
3	3	1	2	1	3	3	2	2	3	2	3
3	1	2	3	3	3	2	1	2	3	2	2
2	1	2	2	3	1	2	1	3	3	3	3
3	2	2	3	3	3	3	2	3	3	3	3
3	2	2	3	3	1	3	3	3	3	3	3
3	2	1	3	3	3	2	3	3	3	3	3
3	3	3	3	2	2	1	3	3	3	3	3
3	3	2	3	2	1	3	3	3	3	3	3
3	2	3	3	3	2	3	3	3	3	3	3
3	2	3	3	3	2	3	3	2	3	3	3
3	3	2	3	2	3	3	3	3	2	3	2
3	3	3	3	2	3	3	3	3	2	3	3
3	2	3	3	2	3	3	2	3	3	3	3
3	2	1	3	2	3	3	2	3	2	3	3
3	3	3	3	3	3	3	3	3	1	2	2
3	1	3	3	3	3	3	3	3	3	3	3
3	3	3	3	3	3	3	1	3	3	3	2
3	3	2	3	3	3	3	3	3	3	3	2
3	3	3	3	3	3	3	3	3	2	3	3
3	3	3	3	3	3	3	3	3	2	3	2
3	2	2	3	3	3	3	3	3	3	3	2
3	1	2	3	3	3	3	3	3	3	3	3
3	2	1	3	3	3	3	3	3	3	3	3
3	2	2	2	3	3	3	3	3	3	3	3
3	2	3	3	3	3	3	3	3	3	3	3
3	2	3	3	3	3	3	3	3	3	3	3
3	3	3	3	3	3	3	3	3	3	3	3
3	2	3	3	3	2	2	3	3	3	3	2
3	2	3	3	2	2	3	3	3	3	3	2
3	2	1	3	3	2	3	3	3	3	3	3
3	1	2	3	2	3	3	3	2	3	3	3
3	1	3	3	2	3	3	2	2	3	3	3
3	3	2	3	3	3	3	3	3	3	2	3
3	3	3	3	3	2	3	3	3	3	3	3
3	3	3	3	3	3	3	2	3		3	3
3	3	3	3	3	2	3	3	3		3	3
3	3	2	3	3	2	3	3	3			3
3	3	3	3	3	3	3	3	3			3
3	3	1	3	3	3	3	3	3			2
3	3	1	3	3	3	3	3	3
3	3	1	3	3	3	2	3	3
3	2	3	3	3	3	3	3	3
3	3	1	3	3	3	3	3	2
3	2	1	3	3	3	3	1	3
3	2	3	3	3	3	3	3	3
3	1	2	3	3	3	3	2	2
3	3	3	3	3	3	3	2	2
3	1	3	3	3	3	3	2	3
1	1	3	3	2	3	3	3	3
3	1	3	3	3	2	3	3	3
3	1	3	3	2	2		3	3
3	1	3	1	3	2		3	3
3	1	3	1	3	2		3	3
3	1	3	3	3	2		3	3
3	1	3	3	2	2		3	3
3	1	3	2	3	3		3
3	3	2	1	3	3		3
3	3	2	3	3	2		3
3	3	2	3	3	2		3
3	3	2	3	3	2		3
3	3	3	3	3	3		3
3	3	3	3	2	3		3
3	3	3	1	2	3		3
3	3	2	2	2	3		3
3	3	2	3	2	3		3
3	3	3	3	2	3		3
3	3	2	1	2	3		3
3	1	3	3	3	3		3
3	1	3	3	3	3		3
3	1	3	3	3	3		3
3	3	3	3	3	3		3
3	3	3	3	3	3		3
3	3	2	3	2	3		3
3	3	1	3	3	3		3
3	3	2	3	3	3		3
3	1	3	3	3	3		2
3	2	3	2	2	3		3
3	3	3	3	2	1		3
3	3	3	3	1	2		3
3	3	3	2	2	2		3
3	3	3	3	2	2		3
3	3	3	3	3	3		3
3	3	3	3	2	3		3
3	3	3	3	3	3		3
3	3	3	3	3	3		3
3	3	3	2	3	3		3
3	3	3	2	3	2		3
3	3	3	2	2	3		3
3	3	3	2	2	3		3
3	3	3	2	2	3		3
3	2	3	2	3	3		3
3	2	1	2	3	3		3
3	2	2	3	3	3		3
3	3	2	3	3	3		3
3	1	1	2	3	3		3
3	3	2	3	3	3		3
3	3	2	3	3	3		3
3	2	3	2	3	3		3
3	2	3	2	3	3		3
3	1	1	3	3	3		3
3	1	2	2	3	3		3
3	2	2	3	3	3		3
3	3	3	3	3	3
3	3	1	3	3	3
3	3	2	3	3	3
2	3	2	3	3	3
2	3	3	3	3	3
3	3	3	3	2	3
2	3	3	3	2	3
2	3	1	3	3	3
2	3	3	3	3	3
1	3	3	3	3	2
2	3	1	3	2	3
2	3	1	3	3	3
3	3	2	3	3	3
3	1	3	3	3	3
3	2	1	3	3	2
3	2	1	3	2	3
3	2	2	3	3	3
3	1	2	3	3	3
2	3	3	3	2	3
2	2	3	3	3	1
2	2	3	3	2	3
2	2	1	3	2	3
2	3	1	2	2	3
2	2	3	3	2	3
3	2	3	3	3	3
3	2	3	2		3
3	2	3	2		3
3	3	2	1		3
3	2	2	1		3
3	2	3	2		3
2	3	3	3		3
3		3	3		3
3		2	3		3
3		2	3		3
3			2		3
3			2		3
3			1		3
3			3		3
3			3		3
2			3		3
2			3		3
3			3		1
3			3		2
3			3		3
3			3		3
3			3		3
3			3
3			3
3			3
3			3
3			3
2			3
3			3
2			3
2			2
3			1
3			3
2			3
3			3
3			3
2			3
2			3
3			3
3			3
3			1
3			3
2			3
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
2
3
3
1
3
3
3
3
3
3
3
3
3
3
3
3
2
2
2
2
2
3
2
3
3
3
3
3
3

File details come from the government source that posted it. Updated Mar 3, 2020.