TE 3 Estimated Workload W91247-22-R-9002 Parent Child Advocacy.xlsx

XLSX spreadsheet 54 KB Posted Jan 21, 2022

Attached to: Child Advocacy Program Support Services
Solicitation number: W91247-22-R-9002
Issued by: Department of the Army Materiel Command Mission and Installation Contracting Command

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains an estimated workload spreadsheet and description of a federal contract opportunity for Child Advocacy Program Support Services with the Department of the Army Materiel Command Mission and Installation Contracting Command. The incumbent contractor will provide various classes, outreach events, and administrative support for the Child Advocacy Program, totaling over 197,000 hours of instruction and outreach annually. Specific requirements include conducting parenting, child safety, and child abuse prevention classes; performing monthly outreach at childcare centers, schools, clinics and other locations; and providing administrative functions such as managing registrations, creating marketing materials, and maintaining databases and websites. The period of performance and total contract value are not specified in the opportunity description.

View the file

Other files

File	Type	Posted
Amend 0001 Solicitation W91247-22-R-9002 Family Advocacy 14 Feb 2022.pdf	PDF	Feb 15, 2022
Technical Exhibit 4 Solicitation Questions and Responses 15 Feb 2022.xlsx	XLSX spreadsheet	Feb 15, 2022
Technical Exhibit 3 Estimated Workload 15 Feb 2022.xlsx	XLSX spreadsheet	Feb 15, 2022
Attachment 2 - Question Submission Form W91247-22-R-9002 Parent Child Advocacy.xlsx	XLSX spreadsheet	Jan 21, 2022
Solicitation Released W91247-22-R-9002 Parent Child Advocacy.pdf	PDF	Jan 21, 2022
Attachment 1 DOL WD Rev 17 27 Dec 2021 W91247-22-R-9002.pdf	PDF	Jan 21, 2022
Attachment 3 - Price Matrix Template W91247-22-R-9002 Parent Child Advocacy.xlsx	XLSX spreadsheet	Jan 21, 2022

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.

CAP

	ESTIMATED WORKLOAD - CLASSES & DURATION*	# OF SESSIONS (DAYS) PER CLASS	INSTRUCTION HOURS PER CLASS	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	ANNUAL TOTAL
# CLASSES	ANNUAL TOTAL # HOURS
	ScreamFree Parenting - consisting of three four hour sessions spread over three consecutive weeks (1 class = 12 hrs of instruction)	3	4	1	1	1	1	1	1	1	1	1	1	1	1	12	144
	Parenting 1-4 consisting of three two hour sessions spread over three consecutive weeks (1 class = 6 hrs of instruction)	3	2	1	1	1	1	1	1	1	1	1	1	1	1	12	72
	Positive Discipline consisting of one three hour session	1	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36
	Child Safety Puppet Shows	1	3	6	6	6	6	6	6	6	6	6	6	6	6	72	216
	Child Abuse ID & Rpt (Initial & Refresher)	1	2	5	5	5	5	5	5	5	5	5	5	5	5	60	120
	Active Parenting For Step Familes	3	3	1	1	1	1	1	1	1	1	1	1	1	1	12	108
	Information and Referral	1	0.25	1251	1251	1251	1251	1251	1251	1251	1251	1251	1251	1251	1251	15012	3753
	Information and Referral	1	0.5	330	330	330	330	330	330	330	330	330	330	330	330	3960	1980
	Darkness to Light/Stewards of Children	1	3	3	3	3	3	3	3	3	3	3	3	3	3	36	108
	MDTI Inspections	1	15	0	0	0	0	0	0	0	0	0	0	0	15	15	225
	CARAT Inspections	9	8	1	1	1	1	1	0	1	1	1	0	0	1	9	648
	Annual Training	1	1	3.3	3.3	3.3	3.3	3.3	3.3	3.3	3.3	3.3	3.3	3.3	3.3	39.6	39.6
	Child Advocate /Instructor Administrative Duties	1	1	43	43	43	43	43	43	43	43	43	43	43	43	516	516
	TOTAL	28	45	1646.3	1646.3	1646.3	1646.3	1646.3	1646.3	1646.3	1646.3	1646.3	1646.3	1646.3	1646.3	19755.6	7965.6

Outreach

Childcare Centers		Monthly	Duration (Hours)	January	February	March	April	May	June	July	August	September	October	November	December	Total Annual Events	Total Annual Hours	Miles from SSC (one way)
	Baugess CDC	Monthly	5	1	1	1	1	1	1	1	1	1	1	1	1	12	60	1
	Cook CDC	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	1
	Maholic CDC	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	1
	Stout CDC	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	15
	Alexander CDC	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	5
	Fernandez CDC	Monthly	5	1	1	1	1	1	1	1	1	1	1	1	1	12	60	3
	Pope CDC	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	4
	Prager CDC	Monthly	5	1	1	1	1	1	1	1	1	1	1	1	1	12	60	4
	Rodgers CDC	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	1
	Rodriguez CDC	Monthly	5	1	1	1	1	1	1	1	1	1	1	1	1	12	60	1
	Baez SAS	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	15
	Morales SAS	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	4
	WWK SAS	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	4
	MST	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	1
	SKIES	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	0
	CYSS Main Office	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	0
DoDEA County Schools	Youth Services Admin Office	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	4
	Armed Services YMCA	Monthly	3	1	1	1	1	1	1	1	1	1	1	1	1	12	36	0
	FCC Providers	Monthly	3	1								1				2	6	4
	DODEA (S)	Monthly	3	1								1				2	6	1
	Albritton (M)	Monthly	5	1								1				2	10	4
	Bowley (E)	Monthly	5	1								1				2	10	2
	Butner (E)	Monthly	5	1								1				2	10	4
	Devers(E)	Monthly	5	1								1				2	10	15
	Gordan(E)	Monthly	5	1								1				2	10	4
	Holbrook (E)	Monthly	5	1								1				2	10	2
	Irwin(I)	Monthly	5	1								1				2	10	4
	McNair (E)	Monthly	5	1								1				2	10	4
	Murray(E)	Monthly	5	1								1				2	10	3
	Pope(E)	Monthly	5	1								1				2	10	15
	Shughart (E)	Monthly	5	1								1				2	10	8
	ACS Linden Oaks	Monthly	5	1	1	1	1	1	1	1	1	1	1	1	1	12	60	4
	Airborne Attic	Monthly	5	1	1	1	1	1	1	1	1	1	1	1	1	12	60	14
Clinics / Hospital	Joel Clinic	Daily Sweeps (per month)	1	10	10	10	10	10	10	10	10	10	10	10	10	120	120	4
	Clark Clinic	Daily Sweeps (per month)	1	10	10	10	10	10	10	10	10	10	10	10	10	120	120	4
	Robinson Clinic	Daily Sweeps (per month)	1	10	10	10	10	10	10	10	10	10	10	10	10	120	120	2
	DENTAC HQ (Check with them before going to any dental clinic)	Daily Sweeps (per month)	1	10	10	10	10	10	10	10	10	10	10	10	10	120	120	1
	WAMC (Must check with POC before going to any clinic)	Daily Sweeps (per month)	1	10	10	10	10	10	10	10	10	10	10	10	10	120	120	9
	Fayetteville Medical Home	Daily Sweeps (per month)	1	10	10	10	10	10	10	10	10	10	10	10	10	120	120	3
	The Fisher House	Daily Sweeps (per month)	1	10	10	10	10	10	10	10	10	10	10	10	10	120	120	4
	Troop Family Medical Clinic	Daily Sweeps (per month)	1	10	10	10	10	10	10	10	10	10	10	10	10	120	120	11
	Hope Mills Medical Home	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	3
	Cleland Ice Rink	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	2
Chapels	Main Post Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	3
	Airborne Artillery Memorial Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	4
	Division Memorial Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	4
	Wood Memorial Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	5
	Division North Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	5
	Hope Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	4
	Peace Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	3
	JFK Memorial Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	4
	Pope Chapel	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	5
	Watters Center	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	4
Libraries	Pope Library	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	4
	Throckmorton Library-	Monthly	1	1	1	1	1	1	1	1	1	1	1	1	1	12	12	8

127 114 114 114 114 114 114 114 127 114 114 114 116.1666666667

Admin

ESTIMATED WORKLOAD - ADMINISTRATIVE SUPPORT	AVERAGE GOVT TIME TO COMPLETE	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	TOTAL	TOTAL TIME (HRS)
Answer Multi-line Phone	120 calls per day x 3 minutes each	2600	2600	2700	2700	2600	2600	2600	2600	2600	2600	2600	2600	31400	1570
Greet/Assist Walk in Customers	30 per day x 4 minutes each	650	650	680	680	650	650	650	650	650	650	650	650	7860	524
Distribute Mail	2 times per day x 30 minutes each	43.3	43.3	43.3	43.3	43.3	43.3	43.3	43.3	43.3	43.3	43.3	43.3	519.6	259.8
Registrations/Requests via Email	2 hours per week	8	8	8	8	8	8	8	8	8	8	8	8	96	96
Serve as POC for Reg for Special Events	66 hours per quarter	1	0	0	0	1	0	0	0	1	0	0	1	4	264
Maintain life skills class Reg Binder	1 hour per day	20	20	20	20	20	20	20	20	20	20	20	20	240	240
Update sign in/out board	4 hours per week	16	16	16	16	16	16	16	16	16	16	16	16	192	192
Schedule/Coordinate Life Skill Classes	5 hours per week	20	20	20	20	20	20	20	20	20	20	20	20	240	240
Database/filing class rosters and evaluations	3 hours per day	60	60	60	60	60	60	60	60	60	60	60	60	720	720
Track FAP Marketing Materials	15 hours per week	60	60	60	60	60	60	60	60	60	60	60	60	720	720
Desk Printing (letters, labels, etc)	15 hours per week	60	60	60	60	60	60	60	60	60	60	60	60	720	720
Agency Updates/ADS	6 hours per month	6	6	6	6	6	6	6	6	6	6	6	6	72	72
Meetings/Trainings	8 hours per month	8	8	8	8	8	8	8	8	8	8	8	8	96	96
Maintain FAP Class rosters & Evaluations	60 hours per month	60	60	60	60	60	60	60	60	60	60	60	60	720	720
Articles		8				8				8			8		N/A
Maintain Four Marquee Signs	25 hours per month	25	25	25	25	25	25	25	25	25	25	25	25	300	300
Create FAP Class Calendar	16 hours per calendar	0	0	0	0	1	0	0	0	0	0	0	1	2	32
Create FAP Special Event Flyers, 4-Fold Flyers	8 hours per flyer	4	4	4	8	4	4	4	4	4	8	4	4	56	448
Create/Update FAP Adverstisments	8 hours per advertisement	6	6	6	6	6	6	6	6	6	6	6	6	72	576
Photography of Outreach and Special Events	2 hours per event	12	12	12	24	12	12	12	12	12	24	12	12	168	336
FAP website/social media maintenance	1 hour per day	20	20	20	20	20	20	20	20	20	20	20	20	240	240
TOTAL		42	42	42	58	43	42	42	42	42	58	42	43	538	8365.8

File details come from the government source that posted it. Updated Jan 21, 2022.