Technical Exhibit 1 - Historical Workload Data 2019-2023 v3.xlsx

XLSX spreadsheet 40 KB Posted Dec 19, 2023

Attached to: Photography Services Federal contract opportunity
Solicitation number: W912CN24Q0002
Issued by: Department of the Army Materiel Command Army Contracting Command

About this file

Written by GovTribe AI · Dec 21, 2023

This document provides historical workload data for photography services from March 2019 to February 2024 at military installations in Hawaii. The data includes the monthly numbers of official passport photos, command photos, and digital photos taken, as well as no-shows and cancelled appointments. Workload decreased during the COVID-19 pandemic but has since rebounded. This information relates to solicitation number W912CN24Q0002 issued by the Department of the Army Materiel Command Army Contracting Command for photography services at Schofield Barracks and Fort Shafter in Hawaii. The period of performance for any resulting award would be one base year with four one-year options.

View the file

Other files for this federal contract opportunity

Other files attached to Photography Services, newest first.
File	Type	Posted
Solicitation Conform 24Q0002 0001 DA Photo Services_FINAL.pdf	PDF	Dec 21, 2023
Amend 0001 Solicitation 24Q0002 0001 DA Photo Services_FINAL.pdf	PDF	Dec 21, 2023
Technical Exhibit 2 - Examples of Photo Request Memos.pdf	PDF	Dec 19, 2023
Technical Exhibit 5 - Authorized Quantities.pdf	PDF	Dec 19, 2023
Technical Exhibit 4 - CPU Request Memo Example.pdf	PDF	Dec 19, 2023
Technical Exhibit 6 - Government Furnished Facilities.pdf	PDF	Dec 19, 2023
Technical Exhibit 9 - DA Photo Weekly_Monthly Report Totals.pdf	PDF	Dec 19, 2023
Technical Exhibit 8 - DA Photo No-show No-cancel appointment Commander memo Example.pdf	PDF	Dec 19, 2023
Solicitation 24Q0002 DA Photo Services FINAL.pdf	PDF	Dec 19, 2023
Technical Exhibit 3A -DA Form 3903-Paper Version.pdf	PDF	Dec 19, 2023
Technical Exhibit 3 - DA Form 3903-VIOS Version.pdf	PDF	Dec 19, 2023
Technical Exhibit 7 - Appointments v2.pdf	PDF	Dec 19, 2023

Show all 12

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.

Sheet1

DA Photo Work Load (March 2019-AUG 2023)

			DA PHOTOS	COMMAND PHOTOS		OFFICIAL PASSPORT PHOTOS		NO SHOWS		CANCELLED APPOINTMENTS
B L U F	Studio Location		(Photo Appointments That Were Actually Shot)
	Schofield Barracks		4463	2278		9901		214		983
	Fort Shafter		3191	1180		829		227		802
	TOTAL		7654	3458		10730		441		1785
	Percentages		35%	15%		49%
Base Year (POP-1 March 2019 - 29 February 2020)																Year Total (Photo Appointments That Were Actually Shot)		Demand Increase		Average Appointments per day
	DA Photos			Command Photos			Passport Photos			No Shows			Cancelled Appointments
	FS	SB	DA Photos Total	FS	SB	Command Photos Total	FS	SB	Passport Photos Total	FS	SB	No Shows Total	FS	SB	Cancelled Total
Mar-19	95	290	385	14	58	72	4	88	92	5	5	10	4	3	7
Apr-19	182	327	509	36	85	121	17	133	150	4	36	40	18	37	55
May-19	239	382	621	48	78	126	14	25	39	18	21	39	14	32	46
Jun-19	166	164	330	35	45	80	14	14	28	8	11	19	16	32	48
Jul-19	138	175	313	28	60	88	22	4	26	3	12	15	25	32	57
Aug-19	126	132	258	28	24	52	14	707	721	7	12	19	17	24	41
Sep-19	74	105	179	17	50	67	18	112	130	5	8	13	18	13	31
Oct-19	168	188	356	35	49	84	27	259	286	5	8	13	48	47	95
Nov-19	154	157	311	27	26	53	22	482	504	4	4	8	34	32	66
Dec-19	112	119	231	12	34	46	26	159	185	6	1	7	36	37	73
Jan-20	163	181	344	26	34	60	27	276	303	4	4	8	36	35	71
Feb-20	170	229	399	23	25	48	14	88	102	13	3	16	28	54	82
Totals	1787	2449	4236	329	568	897	219	2347	2566	82	125	207	294	378	672	7699	Totals for Base			31
Option Period 1 (POP-1 March 2020- 28 February 2021)
	DA Photos			Command Photos			Passport Photos			No Shows			Cancelled Appointments
	FS	SB	DA Photos Total	FS	SB	Command Photos Total	FS	SB	Passport Photos Total	FS	SB	No Shows Total	FS	SB	Cancelled Total
Mar-20	83	94	177	18	27	45	68	22	90	4	2	6	13	23	36	DA Photo Closed on March 23, 2020 due to COVID-19
Apr-20	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	DA Photo services suspended due to COVID for April 2020
May-20	64	78	142	5	17	22	0	0	0	0	0	0	31	7	38	DA Photo services resumed on May 20, 2020
Jun-20	182	194	376	24	71	95	8	11	19	0	0	0	48	39	87
Jul-20	98	127	225	38	66	104	7	10	17	5	0	5	56	67	123
Aug-20	36	43	79	24	25	49	7	20	27	1	0	1	21	10	31
Sep-20	31	63	94	20	19	39	3	15	18	1	0	1	15	10	25
Oct-20	51	71	122	32	27	59	14	21	35	1	0	1	14	11	25
Nov-20	24	26	50	15	18	33	8	17	25	3	0	3	14	6	20
Dec-20	18	18	36	16	25	41	16	139	155	4	0	4	10	9	19
Jan-21	26	62	88	12	33	45	8	1302	1310	3	0	3	7	12	19
Feb-21	25	43	68	18	37	55	15	547	562	5	0	5	8	16	24
Totals	638	819	1457	222	365	587	154	2104	2258	27	2	29	237	210	447	4302	Totals for Opt Pd 1	-3397	-44%	17
Option Period 2 (POP-1 March 2021- 28 February 2022)
	DA Photos			Command Photos			Passport Photos			No Shows			Cancelled Appointments
	FS	SB	DA Photos Total	FS	SB	Command Photos Total	FS	SB	Passport Photos Total	FS	SB	No Shows Total	FS	SB	Cancelled Total
Mar-21	36	54	90	32	39	71	14	334	348	1	0	1	8	16	24
Apr-21	25	56	81	32	52	84	26	221	247	4	3	7	7	17	24
May-21	28	41	69	15	52	67	19	372	391	6	2	8	19	19	38
Jun-21	31	37	68	25	46	71	19	144	163	3	1	4	12	9	21
Jul-21	27	33	60	22	34	56	9	64	73	4	0	4	4	6	10
Aug-21	19	42	61	15	30	45	8	7	15	3	0	3	5	18	23
Sep-21	27	58	85	14	38	52	9	821	830	7	3	10	8	20	28
Oct-21	26	58	84	21	42	63	7	504	511	4	4	8	13	24	37
Nov-21	13	27	40	10	21	31	6	267	273	2	0	2	6	8	14
Dec-21	17	27	44	8	26	34	7	151	158	4	2	6	16	12	28
Jan-22	32	39	71	10	38	48	17	64	81	3	0	3	7	12	19
Feb-22	36	47	83	21	33	54	14	87	101	3	1	4	11	8	19
Totals	317	519	836	225	451	676	155	3036	3191	44	16	60	116	169	285	4703	Totals for Opt Pd 2	401	9%	19
Option Period 3 (POP-1 March 2022- 28 February 2023)
	DA Photos			Command Photos			Passport Photos			No Shows			Cancelled Appointments
	FS	SB	DA Photos Total	FS	SB	Command Photos Total	FS	SB	Passport Photos Total	FS	SB	No Shows Total	FS	SB	Cancelled Total
Mar-22	29	65	94	15	66	81	12	116	128	5	1	6	12	18	30
Apr-22	22	52	74	13	73	86	14	114	128	6	12	18	14	10	24
May-22	32	42	74	24	54	78	7	63	70	3	3	6	8	15	23
Jun-22	23	32	55	24	45	69	9	59	68	4	3	7	8	14	22
Jul-22	32	44	76	32	48	80	16	81	97	3	8	11	12	16	28
Aug-22	35	36	71	29	25	54	20	32	52	4	0	4	13	12	25
Sep-22	39	67	106	17	63	80	24	47	71	2	2	4	13	20	33
Oct-22	13	39	52	12	21	33	16	80	96	2	1	3	1	9	10
Nov-22	32	26	58	13	22	35	29	330	359	3	1	4	12	12	24
Dec-22	22	33	55	22	25	47	12	82	94	5	4	9	10	3	13
Jan-23	19	37	56	17	54	71	26	331	357	4	7	11	2	6	8
Feb-23	19	39	58	23	48	71	17	302	319	5	1	6	11	9	20
Totals	317	512	829	241	544	785	202	1637	1839	46	43	89	116	144	260	3550	Totals for Opt Pd 3	-1153	-25%	14
Option Period 4 (POP-1 March 2023- 28 February 2024)
	DA Photos			Command Photos			Passport Photos			No Shows			Cancelled Appointments
	FS	SB	DA Photos Total	FS	SB	Command Photos Total	FS	SB	Passport Photos Total	FS	SB	No Shows Total	FS	SB	Cancelled Total
Mar-23	34	38	72	17	61	78	20	148	168	7	7	14	8	33	41
Apr-23	12	22	34	18	34	52	8	164	172	3	2	5	4	10	14
May-23	11	23	34	31	58	89	26	105	131	5	9	14	5	6	11
Jun-23	19	15	34	32	65	97	9	104	113	3	4	7	5	6	11
Jul-23	16	14	30	20	36	56	11	42	53	3	1	4	1	5	6
Aug-23	18	20	38	35	47	82	16	47	63	4	5	9	7	9	16
Sep-23	22	32	54	10	49	59	9	167	176	3	0	3	9	13	22
Oct-23			0			0			0			0			0
Nov-23			0			0			0			0			0
Dec-23			0			0			0			0			0
Jan-24			0			0			0			0			0
Feb-24			0			0			0			0			0
Totals	132	164	296	163	350	513	99	777	876	28	28	56	39	82	121	1584	Totals for Opt Pd 4	-1966	-55%	6

&"Times New Roman,Bold"&24ATTACHMENT 1 - Historical Workload Data

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