PWS_Attachment_1_Appendix_C_-_Workload_Data.xlsx

XLSX spreadsheet 46 KB Posted Sep 26, 2018

Attached to: Transportation, Supply and FMS Services Federal contract opportunity
Solicitation number: FA557018R0005
Issued by: Department of the Air Force United States Air Forces in Europe - Air Forces Africa

About this file

From the source

PWS Attachment 1 Appendix C Workload Data

View the file

Other files for this federal contract opportunity

Other files attached to Transportation, Supply and FMS Services, newest first.
File	Type	Posted
FA557018R00050002.pdf	PDF	Nov 21, 2018
Q_and_A_2.docx	DOCX document	Nov 21, 2018
Attachment_1_-_FY19_Transportation_Supply_and_FMS_Services_revised-2.DOCX	DOCX document	Nov 21, 2018
PWS_Attachment_1_Appendix_C_-_Workload_Data-revised.docx	DOCX document	Nov 21, 2018
PWS_Attachment_3_Appendix_G_-_FMS_Technical_Exhibit_3.xlsx	XLSX spreadsheet	Nov 8, 2018
PWS_Attachment_4_Appendix_I_-_Shared_Use_Property_(SUP).doc	DOC document	Nov 8, 2018
Attachment_1_-_FY19_Transportation_Supply_and_FMS_Services_revised.DOCX	DOCX document	Nov 8, 2018
Q_and_A_including_Site_Visit_Questions.docx	DOCX document	Nov 8, 2018
Attachment_2_-_GFP_Module_Attachment_-_Rev_3_5_Mar.xlsx	XLSX spreadsheet	Nov 8, 2018
PWS_Attachment_1_Appendix_C_-_Workload_Data.docx	DOCX document	Nov 8, 2018
FA557018R00050001.pdf	PDF	Nov 8, 2018
FA557018R0005.pdf	PDF	Sep 26, 2018
Attachment_2_-_GFP_Module_Attachment_-_Rev_3_5_Mar.xlsx	XLSX spreadsheet	Sep 26, 2018
Attachment_4_-_Mission_Essential_Contractor_Services.pdf	PDF	Sep 26, 2018
PWS_Attachment_2_Appendix_D_-_Government_Furnished_Facilities.pdf	PDF	Sep 26, 2018
Attachment_1_-_FY19_Transportation_Supply_and_FMS_Services_PWS.docx	DOCX document	Sep 26, 2018
Attachment_3_-_Past_Performance_Questionnaire.docx	DOCX document	Sep 26, 2018
FY19_Transportation_Supply_and_FMS_Services_PWS.docx	DOCX document	Aug 27, 2018

Show all 18

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.

PAX

RAF ALCONBURY PASSENGER TRAVEL
FY 14
	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14
Alconbury	89	62	100	37	53	40	42	78	78	95	71	49

FY 15
	Oct-14	Nov-14	Dec-14	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15
Alconbury	55	51	48	43	43	63	56	66	161	196	98	59

FY 16
	Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16
Alconbury	27	59	57	45	46	61	66	51	155	212	98	61

FY 17

Oct-16

Nov-16

Dec-16

Jan-17

Feb-17

Mar-17

Apr-17

May-17

Jun-17

Jul-17

Aug-17

Sep-17

Alconbury

FY 18

HHG

HOUSEHOLD GOOD SHIPMENTS RAF ALCONBURY
FY 14		Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14
Outbound	648	40	38	31	34	36	54	48	73	94	84	55	61
Inbound	523	62	45	27	33	42	28	43	30	26	64	63	60
Customs	551	33	31	29	27	33	40	48	65	95	62	36	52

FY 15		Oct-14	Nov-14	Dec-14	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15
Outbound	655	44	32	37	26	30	51	47	66	122	81	56	63
Inbound	545	28	40	20	31	34	45	40	23	39	56	70	119
Customs	487	37	21	14	14	24	37	39	55	117	49	38	42
QA (in person)	813	0	42	28	35	38	73	54	54	156	96	121	116

FY 16		Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16
Outbound	614	30	30	29	50	34	42	41	61	93	90	60	54
Inbound	480	60	37	26	21	28	32	26	27	40	62	59	62
QA (in person)	702	61	38	45	51	46	44	47	61	80	92	66	71

FY 17		Oct-16	Nov-16	Dec-16	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17
Outbound	241	41	40	43	63	54
Inbound	170	48	37	28	28	29
QA (in person)	233	49	47	44	49	44

Customs

CUSTOMS CY 15 CUSTOMS CY 16 CUSTOMS CY 17

HIGH RISK	TOTAL	LOW RISK	TOTAL	HIGH RISK	TOTAL	LOW RISK	TOTAL	HIGH RISK	TOTAL	LOW RISK	TOTAL
January	12	January	10	January	17	January	28	January	26	January	33

February 12 February 17 February 11 February 20 February 20 February 33

March 13 March 35 March 12 March 23 March March

April 7 April 32 April 16 April 20 April April

May 30 May 30 May 26 May 32 May May

June 44 June 73 June 28 June 61 June June

July 17 July 48 July 31 July 47 July July

August 17 August 32 August 14 August 36 August August

September 15 September 36 September 20 September 35 September September

October 12 October 16 October 14 October 23 October October

November 9 November 24 November 16 November 20 November November

December 5 December 20 December 14 December 23 December December

Total 193 Total 373 Total 219 Total 368 Total Total

CARGO

RAF ALCONBURY CARGO
Year	2014	2015	2016	2017
Hazardous Cargo	0	1	0	0
Inbound		69	68	18
Outbound		28	40	6
TCN	13	10	42	5
C185 Processed	9	5	7	1
C88	58	56	68	18
A 302 In	47	48	68	18
A 302 Out	0	0	0	0

RAF ALCONBURY VEHICLE OPERATIONS 1 Aug 2015 - 31 Jan 2016
ACTIVITY	Alconbury/Molesworth	Croughton
Shuttle	1093 Runs (see sch)	N/A
Base Tours	6
Deployments	8
MHE Support	16
Tractor/Trailer	8
Wrecher/Recovery	32
UDIs	150
Terminal Transportation	12
DVs	12
Licences	329

Author: Author:

Based on populace

RAF ALCONBURY VEHICLE OPERATIONS 1 Feb 2016 - 31 July 2016
ACTIVITY	Alconbury/Molesworth	Croughton
Shuttle	1291 (see sch)	N/A
Base Tours	6
Deployments	6
MHE Support	0
Tractor/Trailer	1
Wrecher/Recovery	20
UDIs	148
Terminal Transportation	4
DVs	25
Licences	329

Author: Author:

Based on populace

RAF ALCONBURY VEHICLE OPERATIONS 1 Aug 2016 - 31 Jan 17
ACTIVITY	Alconbury/Molesworth	Croughton
Shuttle	1168 (see sch)	N/A
Base Tours	2
Deployments	2
MHE Support	0
Tractor/Trailer	1
Wrecher/Recovery	20
UDIs	330
Terminal Transportation	4
DVs	36
Licences	329

Author: Author:

Based on Populace

Author: Author:

Based on populace Author: Author:

Based on populace

VEHICLE MANAGEMENT WORKLOAD DATA - MAJOR MAINTENANCE 2013-2014															VEHICLE MANAGEMENT WORKLOAD DATA - MAJOR MAINTENANCE 2014-2015															VEHICLE MANAGEMENT WORKLOAD DATA - MAJOR MAINTENANCE 2015-2016
RAF MOLESWORTH DATA															RAF MOLESWORTH DATA															RAF MOLESWORTH DATA
		RAF Molesworth Number Of Work Orders															RAF Molesworth Number Of Work Orders															RAF Molesworth Number Of Work Orders
		October-13	November-13	December-13	January-14	February-14	March-14	April-14	May-14	June-14	July-14	August-14	September-14	Total Year			October-14	November-14	December-14	January-15	February-15	March-15	April-15	May-15	June-15	July-15	August-15	September-15	Total Year			October-15	November-15	December-15	January-16	February-16	March-16	April-16	May-16	June-16	July-16	August-16	September-16	Total Year
	Abuse	0	0	0	0	0	1	1	0	0	0	1	0	3		Abuse	0	0	0	0	0	0	1	0	0	0	0	0	1		Abuse	0	1	0										1
	Accident	2	2	0	1	0	1	0	1	1	1	3	0	12		Accident	0	2	0	0	3	0	2	1	1	2	0	3	14		Accident	0	0	4										4
	T.C.T.O.	0	0	0	0	0	0	0	0	0	0	0	0	0		T.C.T.O.	0	0	0	0	0	0	0	0	0	0	0	0	0		T.C.T.O.	0	0	0			D							0
	Warranty	0	0	0	0	0	0	0	0	2	0	0	0	2		Warranty	0	1	1	1	0	1	0	0	0	1	0	0	5		Warranty	0	0	0				P						0
	Special inspections	0	0	0	0	0	0	0	0	0	0	0	0	0		Special inspections	0	0	0	0	0	0	0	0	0	0	0	0	0		Special inspections	0	0	0					A					0
	Contract	0	1	1	2	1	1	2	0	1	1	0	2	12		Contract	1	1	2	3	1	1	1	1	0	2	0	0	13		Contract	0	3	0						S				3
	Scheduled	10	13	12	14	15	23	15	23	23	37	15	20	220		Scheduled	18	18	13	20	16	19	32	20	18	36	12	20	242		Scheduled	17	14	6		Data	Not	AVAIL						37
	Unscheduled	31	37	16	26	16	34	19	22	13	18	18	16	266		Unscheduled	17	13	21	14	9	7	15	17	16	17	14	29	189		Unscheduled	14	28	25										67
	Total Major Work Orders	43	53	29	43	32	60	37	46	40	57	37	38	515		Total Major Work Orders	36	35	37	38	29	28	51	39	35	58	26	52	464		Total Major Work Orders	31	46	35	0	0	0	0	0	0	0	0	0	112
	VEHICLE MANAGEMENT WORKLOAD DATA - MINOR MAINTENANCE															VEHICLE MANAGEMENT WORKLOAD DATA - MINOR MAINTENANCE															VEHICLE MANAGEMENT WORKLOAD DATA - MINOR MAINTENANCE
	Total Minor Maintenance	10	12	12	16	13	14	21	23	16	12	15	16	180		Total Minor Maintenance	14	12	12	24	12	20	14	15	35	15	11	18	202		Total Minor Maintenance	23	43	16										82
														Average															Average															Average
	Fleet VIC (Molesworth)	88.4	89.9	92.9	94.8	94.3	94.7	96.7	97.0	95.4	93.2	96.0	96.4	94.14		Fleet VIC (Molesworth)	96.9	97.6	97.3	95.7	95.1	96.5	94.6	97.3	97.0	95.5	97.0	96.5	96.42		Fleet VIC (Molesworth)	95.1	93.6	95.2										94.63
	NMCM (Molesworth)	11.0	8.7	5.3	3.8	3.0	3.5	1.3	2.4	4.3	4.5	3.1	1.8	4.39		NMCM (Molesworth)	2.1	1.3	1.9	2.9	1.2	2.3	3.2	1.5	1.9	2.0	1.4	2.8	2.04		NMCM (Molesworth)	3.1	4.1	3.7										3.63
	NMCS (Molesworth)	0.6	1.4	1.8	1.4	2.7	1.8	2.0	0.6	0.3	2.3	0.9	1.8	1.47		NMCS (Molesworth)	1.0	1.1	0.8	1.4	3.7	1.2	2.2	1.2	1.1	2.5	1.6	0.7	1.54		NMCS (Molesworth)	1.8	2.3	1.1										1.73
														Total															Total															Total
														YEAR															YEAR															YEAR
	Call outs (Molesworth)	0	2	4	0	3	1	0	0	0	0	1	1	12		Call outs (Molesworth)	2	4	0	1	1	2	2	5	4	0	2	0	23		Call outs (Molesworth)	1	0	1										2
	Wrecker runs (Molesworth)	5	8	2	3	3	5	13	6	5	5	3	7	65		Wrecker runs (Molesworth)	5	3	2	3	12	5	7	2	10	2	9	3	63		Wrecker runs (Molesworth)	1	3	2										6

Delivery Service

DELIVERY SERVICES
FY14	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14
Digby Mail	22	18	19	21	19	21	21	21	21	21	20	21
Alconbury/Mildenhall/Alconbury HGV & Laundry	9	7	7	6	10	8	7	9	6	3	10	7
Delivery Croughton/Yeovilton/Croughton Mail	5	3	3	4	4	4	4	5	4	5	2	4
Delivery Croughton/Yeovilton/DCMA/Croughton Mail	5	4	4	4	4	4	5	4	4	5	4	5
Delivery Services Croughton/IMJIN/Fairford/Croughton/Alconbury/Croughton Mail	26	23	26	25	23	26	25	25	26	25	25	25

FY15	Oct-14	Nov-14	Dec-14	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15
Digby Mail	22	17	21	19	19	22	21	19	21	20	20	21
Alconbury HGV	2	0	1	0	1	1	1	3	5	2	2	1
Croughton HGV	3	1	1	4	0	2	5	3	4	2	0	2
Linen	5	4	5	4	4	4	5	4	4	5	4	5
Bristol DCMA/Yeovilton	9	6	8	8	9	9	9	8	9	9	8	9
Croughton Mail	26	23	26	24	23	27	25	25	24	25	26	25
Delivery Services 151-200mls rad Menwith Hill	0	0	0	0	0	0	0	0	0	0	0	2

FY16	Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16
Digby Mail	21	18	20	19	20	22	20	20	21	19	22	21
Alconbury HGV	2	3	2	2	2	4	4	2	7	2	4	1
Croughton HGV	2	4	0	1	4	4	3	1	4	3	2	4
Linen	4	4	5	4	4	5	4	4	5	4	5	2
Bristol DCMA/Yeovilton	9	7	8	8	8	10	8	9	9	7	9	9
Croughton Mail	25	24	26	24	24	27	24	26	25	24	26	25

FY17	Oct-16	Nov-16	Dec-16	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17
Digby Mail	20	19	19	20	19
Alconbury HGV	5	2	1	1	1
Croughton HGV	2	5	0	1	0
Linen	4	5	4	4	4
Bristol DCMA/Yeovilton	8	8	9	9	8
Croughton Mail	25	23	22	24	23

File details come from the government source that posted it.