W912DR22R0048 - Attachment A_Inventory Mapping (MAY 2022).xlsx

XLSX spreadsheet 120 KB Posted Aug 3, 2022

Attached to: Recreational Road Inventories at USACE Project Sites
Opportunity number: W912DR22R0048
Issued by: Department of the Army Corps of Engineers

About this file

From the source

Attachment A

View the file

Other files

File	Type	Posted
Line Item Structure for W912DR22R0048.docx	DOCX document	Aug 19, 2022
FLTP Road and Recreation Data Model Examples 2022.xlsx	XLSX spreadsheet	Aug 3, 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.

HIDE

For Official Use Only (FOUO)

Official Government Estimate

PWS Title: Conservation/Recreation Interns to Perform Recreational Road Inventories

Contract Number TBD

Tasks	1	2a	2b	2c	2d	2e	2f	2g	2h		Total
	Ops-Log Planning	NWK	MVS	LRL	LRH	NWO	LRP	MVR	MVP	SAS
est weeks

Noordhoff, Zachary N CIV USARMY CENAB (US): Noordhoff, Zachary N CIV USARMY CENAB (US):

Receive from Travel Est. Tab. 6 23 17 16 25 20 15 15 16 12

Labor Categories

Hours

Total Hrs

Rate

Cost

Sr Program Manager

USACE: USACE:

est 8 hours per week	92	68	64	100	80	60	60	64	48	684	$125.00	$85,500.00
	Program Manager		240

USACE: USACE:

est 40 hours per week	690	510	480	750	600	450	450	480	360	5010	$95.00	$475,950.00
	Team Leader		240

USACE: USACE:

est 2 weeks @ 40 hours per week	920	680	640	1000	800	600	600	640	480	6600	$70.00	$462,000.00
	Budget Analyst		24

USACE: USACE:

est 4 hours per week	92	68	64	100	80	60	60	64	48	660	$45.00	$29,700.00
	Admin Assistant		12

USACE: USACE:

est 2 hours per week	46	34	32	50	40	30	30	32	24	330	$25.00	$8,250.00
	Crew member/Intern		0	883	666	938	1392	792	592	566	606	463	6898	$30.00	$206,940.00

Hours by Task 564 2723 2026 2218 3392 2392 1792 1766 1886 1423 20182 $1,268,340.00

Materials

USACE: USACE:

includes equipment and support items:

-field tools (mobile phones, computers, etc.)

-meals.

-service clothing.

-PPE.

Noordhoff, Zachary N CIV USARMY CENAB (US): Noordhoff, Zachary N CIV USARMY CENAB (US):

Receive from Travel Est. Tab.

USACE: USACE:

est 8 hours per week

USACE: USACE:

est 40 hours per week

USACE: USACE:

est 2 weeks @ 40 hours per week $ 40,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $175,000.00

Travel $ 2,500 $ 22,900 $ 16,800 $ 22,600 $ 34,500 $ 19,800 $ 14,800 $ 13,300 $ 14,400 $ 10,000 $171,600.00

Cost by Task $42,500 $37,900 $31,800 $37,600 $49,500 $34,800 $29,800 $28,300 $29,400 $25,000 $1,614,940.00 TOTAL:

Prepared by: ____________________________________

Approved by:	____________________________________
Grant Manager:	____________________________________

Gov Est-Working Copy

For Official Use Only (FOUO)

Official Government Estimate

PWS Title: Conservation/Recreation Interns to Perform Recreational and Road Inventories

FY22 cost

using costs through FY23

Contract Number TBD

Period of Performance to include the rest of districts

Trans Lim REC

Tasks

Total

Ops-Log Planning

NWO

NWS

NWW

SPL

SPA

SPN

SWG

MVN

NWK

SAS

SAJ

NAE

LRH

LRP

NAP

LRC

MVP

MVR

est weeks

Noordhoff, Zachary N CIV USARMY CENAB (US): Noordhoff, Zachary N CIV USARMY CENAB (US):

Receive from Travel Est. Tab. 10 5.6692 1.75535 3.6814 1.79275 1.94005 1.73475 1.6059 2.1606 7.79965 5.99735 1.2235 5.2728 7.97675 4.9979 1.57425 1.8618 2.73225 4.23675 74.013 Andrew Huddleston: Andrew Huddleston:

Total Weeks. Add 10 weeks for onboarding and training.

Labor Categories

Hours

Total Hrs

Rate

# Employee

Cost

Sr Program Manager

USACE: USACE:

est 8 hours per week 23 7 15 7 8 7 6 9 31

USACE: USACE:

during data collection est 4 hours per week		23.9894	4.894	21.0912	31.907	19.9916	6.297	7.4472	10.929	16.947	336	$125.00	1	$42,006.50
	Program Manager		400

USACE: USACE:

est 40 hours per week 170 53 110 54 58 52 48 65 234

USACE: USACE:

during data collection est 30 hours per week		179.9205	36.705	158.184	239.3025	149.937	47.2275	55.854	81.9675	127.1025	2320	$95.00	1	$220,437.05
	Team Leader		400

USACE: USACE:

est 2 weeks @ 40 hours per week 227 70 147 72 78 69 64 86 312

USACE: USACE:

est 40 hours per week

	239.894	48.94	210.912	319.07	199.916	62.97	74.472	109.29	169.47	2961	$70.00	1	$207,236.40
Budget Analyst		40

USACE: USACE:

est 4 hours per week	23	7	15	7	8	7	6	9	31	23.9894	4.894	21.0912	31.907	19.9916	6.297	7.4472	10.929	16.947	296	$45.00	1	$13,322.34
	Admin Assistant		20

USACE: USACE:

est 2 hours per week	11	4	7	4	4	3	3	4	16		11.9947	2.447	10.5456	15.9535	9.9958	3.1485	3.7236	5.4645	8.4735	148	$25.00	1	$3,700.65
	Crew member/Intern		0	227	70	147	72	78	69	64	86	312

USACE: USACE:

from time estimator		240	49	211	319	200	63	74	109	169	25605	$30.00	10	$768,156.00
				2267.68	702.14	1472.56	717.1	776.02	693.9	642.36	864.24	3119.86		2398.94	489.4	2109.12	3190.7	1999.16	629.7	744.72	1092.9	1694.7	31600
	Hours by Task		940	2948	913	1914	932	1009	902	835	1124	4056		3119	636	2742	4148	2599	819	968	1421	2203

Materials

USACE: USACE:

includes equipment and support items:

-field tools (mobile phones, computers, etc.)

-meals.

-service clothing.

-PPE.

USACE: USACE:

during data collection est 4 hours per week

USACE: USACE:

during data collection est 30 hours per week

USACE: USACE:

est 40 hours per week

Noordhoff, Zachary N CIV USARMY CENAB (US): Noordhoff, Zachary N CIV USARMY CENAB (US):

Receive from Travel Est. Tab.

USACE: USACE:

from time estimator

USACE: USACE:

est 8 hours per week Andrew Huddleston: Andrew Huddleston:

Total Weeks. Add 10 weeks for onboarding and training.

USACE: USACE:

est 40 hours per week

USACE: USACE:

est 2 weeks @ 40 hours per week

USACE: USACE:

est 4 hours per week $ 40,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $310,000.00

Travel/Vehicles $ 13,100 $ 6,500 $ 10,800 $ 6,900 $ 6,300 $ 6,000 $ 5,600 $ 5,100 $ 17,300 $ 13,600 $ 5,000 $ 20,300 $ 18,700 $ 13,100 $ 5,600 $ 6,000 $ 9,000 $ 14,200 $183,100.00

Cost by Task $118,300 $132,300 $53,763 $93,464 $54,851 $56,958 $52,885 $50,116 $59,812 $175,658 $138,831 $42,488 $132,214 $180,313 $119,961 $49,535 $55,220 $74,219 $107,071 $1,747,958.94

$848,106.77 $899,852.17

	Trans/Lim REC
Estimated hours	31600
Estimated weeks	74.013
Estimated months	18.50325
Estimated cost	$1,747,958.94

This estimate was generated using the estimated rates based on previous survey work. The estimates for the hours required for each task was developed based on information from government employees familiar with the level of effort as well as previously awarded contracts. This estimate was developed independently and prior to the receipt of any proposals.

Prepared by: ____________________________________

Approved by:	____________________________________
Grant Manager:	____________________________________

Road Mileage Discrepancy USACE FLTP Road Mileage Comparison

Original Road Mileage/Dist			SCA Road Mileage/Dist			NRMA Road Mileage/Dist
District:	Road Mileage	Parking Lots	Road Mileage	Parking Lots	Difference	Paved

Andrew Huddleston: Andrew Huddleston:

Service and Public Paved Unpaved Andrew Huddleston: Andrew Huddleston:

Service and Public Unpaved	Road Mileage	Parking Lots	Difference	SCA Actual Diff
	Alaska (POA)	13	0		-13	6.5	6.5	13	0	0
	Albuquerque (SPA)	42.71	21		-42.71	26.09	24.47	50.56	29	7.85
	Baltimore (NAB)	77.89	127		-77.89	78.18	58.46	136.64	133	58.75
	Buffalo (LRB)	1.9	8		-1.9	1.95	1.55	3.5	7	1.6
	Chicago (LRC)	53.82

Andrew Huddleston: Andrew Huddleston:

Was not included in Zach's initial rollup Andrew Huddleston: Andrew Huddleston:

Service and Public Paved Andrew Huddleston: Andrew Huddleston:

Service and Public Unpaved	84			-53.82	39.97	13.85	53.82	84	0
	Detroit (LRE)	1	0		-1		1	0	1	2	0
	Fort Worth (SWF)	540.93	1071		-540.93		536.05	65.04	601.09	1763	60.16
	Galveston (SWG)	48.11	12		-48.11		32.75	24.64	57.39	41	9.28
	Honolulu (POH)	0	0		0		0	0	0	0	0		$ 1,015,000.00
	Huntington (LRH)	312.96	391		-312.96		192.3	278.04	470.34	564	157.38		Roads budget
	Jacksonville (SAJ)	7.5	26		-7.5		5.75	0.55	6.3	25	-1.2
	Kansas City (NWK)	502.44	832		-502.44		413.98	136.14	550.12	1021	47.68
	Little Rock (SWL)	395.72	852		-395.72		379.35	35.65	415	1119	19.28		$ 508,000.00
	Los Angeles (SPL)	20	260		-20		51.5	20.7	72.2	146	52.2		spent on roads alone
	Louisville (LRL)	253.48	467		-253.48		212.43	48.19	260.62	488	7.14
	Mobile (SAM)	465.59	823	617.55	151.96		455.62	97.35	552.97	1214	87.38	-64.58
	Nashville (LRN)	260.98	541	259.32	-1.66		242.95	29.08	272.03	663	11.05	12.71
	New England (NAE)	95.94	184		-95.94		80.96	140.02	220.98	251	125.04
	New Orleans (MVN)	73	36		-73		5.75	114.76	120.51	48	47.51		$ 200.91
	Omaha (NWO)	361.08	776		-361.08		178.19	219.9	398.09	756	37.01
	Philadelphia (NAP)	9.49	10		-9.49		5.11	1.82	6.93	33	-2.56
	Pittsburgh (LRP)	121.78	196		-121.78		120.57	176.14	296.71	310	174.93
	Portland (NWP)	72.41	103	77.19	4.78		57.08	22.37	79.45	247	7.04	2.26
	Rock Island (MVR)	135.57	684		-135.57		94.35	56.44	150.79	725	15.22
	Sacramento (SPK)	70.78	180		-70.78		59.57	45.02	104.59	182	33.81
	San Francisco (SPN)	15.53	12		-15.53		22.92	10.2	33.12	28	17.59
	Savannah (SAS)	339.57	345		-339.57		244.07	189.8	433.87	445	94.3
	Seattle (NWS)	18.7	77		-18.7		15.54	3.49	19.03	78	0.33
	St. Louis (MVS)	231.56	515		-231.56		191.7	130.63	322.33	712	90.77
	St. Paul (MVP)	94.84	134		-94.84		36.34	26.62	62.96	175	-31.88
	Tulsa (SWT)	831.18	1501	1055.41	224.23		623.03	324.52	947.55	1598	116.37	-107.86
	Vicksburg (MVK)	349.24	666	367.87	18.63		259.4	109.53	368.93	890	19.69	1.06
	Walla Walla (NWW)	95.27	236		-95.27		66.89	62.01	128.9	304	33.63
	Wilmington (SAW)	173.85	350	151.1	-22.75		136.35	87.33	223.68	475	49.83	72.58
	TOTALS	6087.82	11520	2528.44			4874.19	2560.81	7435	14556	1347.18
	Aggressive Schedule	Road Mileage					493.76
	Current Efforts	818.37		124.677			179.58
	FY 19-20	2918.24
	FY 20-21	1867.93
	FY 21-22	429.46
	TOTAL	6034
	Selection Critieria:
	Districts with most road mileage
	Finishing partially completed Districts (OCAs)
	Lumping Districts geographically

Transport Only Time Estimate

TASK

NWK

NWO

NWS

NWW

SPL

SPA

SPN

SWG

MVN

SAS

SAJ

NAE

LRH

LRP

NAP

LRC

MVP

MVR

Roads

Paved/Unpaved miles from NRMA

Andrew Huddleston: Andrew Huddleston:

NRMA=NRM Assessment, unpaved and paved road mileage on all USACE OWNED roadways	550	398	19	129	72	51	33	57	121	434	6	221	470	297	7	54	63	151
	Rate per hour

Andrew Huddleston: Andrew Huddleston:

20 miles recorded per hour	20	20	20	20	20	20	20	20	20		20	20	20	20	20	20	20	20	20
	Estimated time	27.5	19.9	0.95	6.45	3.6	2.55	1.65	2.85	6.05		21.7	0.3	11.05	23.5	14.85	0.35	2.7	3.15	7.55
	20% contingency

tc={6757526E-A222-48AB-BEB1-FC3E97F35A98}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Makes up for potential unrecorded mileage	5.5	3.98	0.19	1.29	0.72	0.51	0.33	0.57	1.21		4.34	0.06	2.21	4.7	2.97	0.07	0.54	0.63	1.51
	Total estimated time (hours)	33	23.88	1.14	7.74	4.32	3.06	1.98	3.42	7.26		26.04	0.36	13.26	28.2	17.82	0.42	3.24	3.78	9.06
	Parking Lots
	Count from NRMA	1,021	756	78	304	146	29	28	41	48		445	25	251	564	310	33	84	175	725
	Rate per hour

Andrew Huddleston: Andrew Huddleston:

10 parking lots recorded per hour	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00		10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00	10.00
	Estimated time	102.10	75.60	7.80	30.40	14.60	2.90	2.80	4.10	4.80		44.50	2.50	25.10	56.40	31.00	3.30	8.40	17.50	72.50
	20% contingency	20.42	15.12	1.56	6.08	2.92	0.58	0.56	0.82	0.96		8.90	0.50	5.02	11.28	6.20	0.66	1.68	3.50	14.50
	Total estimated time (hours)	122.52	90.72	9.36	36.48	17.52	3.48	3.36	4.92	5.76		53.4	3	30.12	67.68	37.2	3.96	10.08	21	87
	Verification (Pre/Post)
	Total Time for all features (Hours)	155.52	114.60	10.50	44.22	21.84	6.54	5.34	8.34	13.02	379.92	79.44	3.36	43.38	95.88	55.02	4.38	13.32	24.78	96.06	415.62
	Data collection + 10% Conservation Project Time	171.07	126.06	11.55	48.64	24.02	7.19	5.87	9.17	14.32	417.912	87.38	3.70	47.72	105.47	60.52	4.82	14.65	27.26	105.67	457.182

Project Count

USACE: USACE:

Project count from FY20 NRMA.

tc={6757526E-A222-48AB-BEB1-FC3E97F35A98}: [Threaded comment]

Comment:

Makes up for potential unrecorded mileage 17 9 5 8 1 7 3 2 4 56 3 2 32 40 19 4 4 12 5 121

Weeks of data collection	3.888	2.865	0.2625	1.1055	0.546	0.1635	0.1335	0.2085	0.3255	9.498	1.986	0.084	1.0845	2.397	1.3755	0.1095	0.333	0.6195	2.4015	10.3905
Weeks in travel

estimator

USACE: USACE:

this comes directly from travel estimator Andrew Huddleston: Andrew Huddleston:

10 parking lots recorded per hour	2.43125	1.75	1.34375	2.075	1.06875	1.48125	1.46875	1.1375	1.275	14.03125	2.49375	1.1375	3.2	3.81875	2.4375	1.40625	1.275	1.95625	1.86875	19.59375
	Total Weeks Per District	6.31925	4.615	1.60625	3.1805	1.61475	1.64475	1.60225	1.346	1.6005	23.52925	4.47975	1.2215	4.2845	6.21575	3.813	1.51575	1.608	2.57575	4.27025	29.98425
	Estimated hours	252.77	184.60	64.25	127.22	64.59	65.79	64.09	53.84	64.02	941.17	179.19	48.86	171.38	248.63	152.52	60.63	64.32	103.03	170.81	1199.37
	Adjusted estimated hours	253.00	185.00	65.00	128.00	65.00	66.00	65.00	54.00	65.00	946	180.00	49.00	172.00	249.00	153.00	61.00	65.00	104.00	171.00	1204
	Adjusted estimated weeks	7.00	5.00	2.00	4.00	2.00	2.00	2.00	2.00	2.00	28	5.00	2.00	5.00	7.00	4.00	2.00	2.00	3.00	5.00	35

The difference from the travel estimator is allowed as a logistical contingency. The location of projects will impact the pace and quantity of data collection

Transport_LimREC Time Estimator

TASK

NWK

NWO

NWS

NWW

SPL

SPA

SPN

SWG

MVN

SAS

SAJ

NAE

LRH

LRP

NAP

LRC

MVP

MVR

Roads

Paved/Unpaved miles from NRMA

Andrew Huddleston: Andrew Huddleston:

NRMA=NRM Assessment, unpaved and paved road mileage on all USACE OWNED roadways	550	398	19	129	72	51	33	57	121	434	6	221	470	297	7	54	63	151
	Rate per hour

tc={E27DAB32-3075-4675-A7BC-222975A77CFB}: [Threaded comment]

Comment:

Need to hone in the rate of road collection...how many road miles can be collected in 1 hour?	5	5	5	5	5	5	5	5	5		5	5	5	5	5	5	5	5	5
	Estimated time	110	79.6	3.8	25.8	14.4	10.2	6.6	11.4	24.2		86.8	1.2	44.2	94	59.4	1.4	10.8	12.6	30.2
	20% contingency	22	15.92	0.76	5.16	2.88	2.04	1.32	2.28	4.84		17.36	0.24	8.84	18.8	11.88	0.28	2.16	2.52	6.04
	Total estimated time (hours)	132	95.52	4.56	30.96	17.28	12.24	7.92	13.68	29.04		104.16	1.44	53.04	112.8	71.28	1.68	12.96	15.12	36.24
	Parking Lots
	Count from NRMA	1,021	756	78	304	146	29	28	41	48		445	25	251	564	310	33	84	175	725
	Rate per hour	15.00	15.00	15.00	15.00	15.00	15.00	15.00	15.00	15.00		15.00	15.00	15.00	15.00	15.00	15.00	15.00	15.00	15.00
	Estimated time	68.07	50.40	5.20	20.27	9.73	1.93	1.87	2.73	3.20		29.67	1.67	16.73	37.60	20.67	2.20	5.60	11.67	48.33
	20% contingency	13.61	10.08	1.04	4.05	1.95	0.39	0.37	0.55	0.64		5.93	0.33	3.35	7.52	4.13	0.44	1.12	2.33	9.67
	Total estimated time (hours)	81.68	60.48	6.24	24.32	11.68	2.32	2.24	3.28	3.84		35.6	2	20.08	45.12	24.8	2.64	6.72	14	58
	General REC (NOT in R1S)

tc={705AE2BA-9F67-4D93-83E5-B1ADD4BCABBC}: [Threaded comment]

Comment:

Includes: Shelters, Campsites, and Picnic Sites

Count from NRMA	22	16	118	187	0	79	10	37	53	8	0	204	175	132	50	79	40	10
Rate per hour

Andrew Huddleston: Andrew Huddleston:

30 campsites/shelters/picnic sites per hour Andrew Huddleston: Andrew Huddleston:

NRMA=NRM Assessment, unpaved and paved road mileage on all USACE OWNED roadways tc={E27DAB32-3075-4675-A7BC-222975A77CFB}: [Threaded comment]

Comment:

Need to hone in the rate of road collection...how many road miles can be collected in 1 hour?	25	25	25	25	25	25	25	25	25		25	25	25	25	25	25	25	25	25
	Estimated time	0.88	0.64	4.72	7.48	0.00	3.16	0.40	1.48	2.12		0.32	0.00	8.16	7.00	5.28	2.00	3.16	1.60	0.40
	20% contingency	0.18	0.13	0.94	1.50	0.00	0.63	0.08	0.30	0.42		0.06	0.00	1.63	1.40	1.06	0.40	0.63	0.32	0.08
	Total estimated time (hours)	1.06	0.77	5.66	8.98	0.00	3.79	0.48	1.78	2.54		0.38	0.00	9.79	8.40	6.34	2.40	3.79	1.92	0.48
	Verification (Pre/Post)
	Total Time for all features (Hours)	214.74	156.77	16.46	64.26	28.96	18.35	10.64	18.74	35.42	564.336	140.14	3.44	82.91	166.32	102.42	6.72	23.47	31.04	94.72	651.184
	Data collection + 10% Conservation Project Time	236.21	172.44	18.11	70.68	31.86	20.19	11.70	20.61	38.97	620.7696	154.16	3.78	91.20	182.95	112.66	7.39	25.82	34.14	104.19	716.3024

Project Count

USACE: USACE:

Project count from FY20 NRMA. 17 9 5 8 1 7 3 2 4 56 3 2 32 40 19 4 4 12 5 121

Weeks of data collection	5.3684	3.9192	0.4116	1.6064	0.724	0.4588	0.266	0.4684	0.8856	14.1084	3.5036	0.086	2.0728	4.158	2.5604	0.168	0.5868	0.776	2.368	16.2796
Weeks in travel

estimator

USACE: USACE:

this comes directly from travel estimator tc={705AE2BA-9F67-4D93-83E5-B1ADD4BCABBC}: [Threaded comment]

Comment:

Includes: Shelters, Campsites, and Picnic Sites	2.43125	1.75	1.34375	2.075	1.06875	1.48125	1.46875	1.1375	1.275	14.03125	2.49375	1.1375	3.2	3.81875	2.4375	1.40625	1.275	1.95625	1.86875	19.59375
	Total Weeks Per District	7.79965	5.6692	1.75535	3.6814	1.79275	1.94005	1.73475	1.6059	2.1606	28.13965	5.99735	1.2235	5.2728	7.97675	4.9979	1.57425	1.8618	2.73225	4.23675	35.87335
	Estimated hours	311.99	226.77	70.21	147.26	71.71	77.60	69.39	64.24	86.42	1125.586	239.89	48.94	210.91	319.07	199.92	62.97	74.47	109.29	169.47	1434.934
	Adjusted estimated hours	312.00	227.00	71.00	148.00	72.00	78.00	70.00	65.00	87.00	1130	240.00	49.00	211.00	320.00	200.00	63.00	75.00	110.00	170.00	1438.00
	Adjusted estimated weeks	8.00	6.00	2.00	4.00	2.00	2.00	2.00	2.00	3.00	31	6.00	2.00	6.00	8.00	5.00	2.00	2.00	3.00	5.00	39

The difference from the travel estimator is allowed as a logistical contingency. The location of projects will impact the pace and quantity of data. collection

Disclaimer: This information is accurate to the best of the USACE's knowledge. There may be some increases or decreases based on what is found in the field.

Travel Estimator

	NWK	NWO	NWS	NWW	SPL	SPA	SPN	SWG	MVN	SAS	SAJ	NAE	LRH	LRP	NAP	LRC	MVP	MVR
Proj Count	17	9	5	8	1	7	3	2	4	3	2	32	40	19	4	4	12	5

# Projects with 1-10 PSAs	15	8	5	4	1	7	1	2	4	1	2	32	40	18	3	4	11	1
Hours/proj	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75
Total Hours	41.25	22	13.75	11	2.75	19.25	2.75	5.5	11	2.75	5.5	88	110	49.5	8.25	11	30.25	2.75	437.25

# Projects with 11-25 PSAs	2	1	0	4	0	0	2	0	0	0	0	0	0	1	1	0	1	4
Hours/proj	8	8	8	8	8	8	8	8	8	8	8	8	8	8	8	8	8	8
Total Hours	16	8	0	32	0	0	16	0	0	0	0	0	0	8	8	0	8	32	128

# Projects with 26-50 PSAs	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0
Hours/proj	17	17	17	17	17	17	17	17	17	17	17	17	17	17	17	17	17	17
Total Hours	0	0	0	0	0	0	0	0	0	17	0	0	0	0	0	0	0	0	17

# Projects with 50+ PSAs	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0
Hours/proj	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40
Total Hours	0	0	0	0	0	0	0	0	0	40	0	0	0	0	0	0	0	0	40

Total Hours of Travel Between PSA's and Projects	57.25	30.00	13.75	43.00	2.75	19.25	18.75	5.50	11.00	59.75	5.50	88.00	110.00	57.50	16.25	11.00	38.25	34.75	622.25	1300.41
Hours of Prep and Travel Between Districts

Andrew Huddleston: Andrew Huddleston:

This includes intro, pre, and post meetings with dist and proj staff	40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00		40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00
	Total Est Weeks of Prep and Travel	2.43	1.75	1.34	2.08	1.07	1.48	1.47	1.14	1.28		2.49	1.14	3.20	3.75	2.44	1.41	1.28	1.96	1.87
	Weeks of

data collection Andrew Huddleston: Andrew Huddleston:

Pulled from time estimator	3.91	2.88	0.38	1.29	0.55	0.24	0.14	0.25	0.38		1.99	0.08	1.29	2.57	1.51	0.16	0.41	0.66	2.41
	Total Weeks of Data and Travel	6.34	4.63	1.72	3.37	1.61	1.72	1.61	1.38	1.65		4.49	1.22	4.49	6.32	3.95	1.57	1.69	2.62	4.28
	Nights of lodging needed	44.39	32.42	12.07	23.57	11.30	12.07	11.29	9.68	11.57		31.41	8.55	31.42	44.25	27.62	10.96	11.81	18.31	29.93
	Est nights in paid housing x3 rooms	133.17	97.25	36.21	70.72	33.91	36.20	33.86	29.04	34.72		94.24	25.65	94.26	132.76	82.85	32.88	35.43	54.93	89.80
	Hotel rate in region	$ 115.75	$ 120.00	$ 148.50	$ 129.83	$ 179.20	$ 141.25	$ 141.25	$ 159.33	$ 117.50		$ 123.67	$ 158.33	$ 188.25	$ 119.00	$ 134.50	$ 136.00	$ 140.00	$ 135.50	$ 141.50
	Est Lodging/rental costs	$ 15,413.99	$ 11,670.12	$ 5,377.07	$ 9,181.49	$ 6,076.63	$ 5,113.07	$ 4,782.34	$ 4,627.52	$ 4,080.01		$ 11,654.69	$ 4,061.49	$ 17,744.16	$ 15,798.68	$ 11,142.65	$ 4,471.78	$ 4,959.78	$ 7,443.12	$ 12,706.88
	Utilities

USACE: USACE:

est $50 per week $ 121.56 $ 87.50 $ 67.19 $ 103.75 $ 53.44 $ 74.06 $ 73.44 $ 56.88 $ 63.75 $ 124.69 $ 56.88 $ 160.00 $ 187.50 $ 121.88 $ 70.31 $ 63.75 $ 97.81 $ 93.44

Rental Car cost	$ 531.84	$ 382.81	$ 293.95	$ 453.91	$ 233.79	$ 324.02	$ 321.29	$ 248.83	$ 278.91	$ 545.51	$ 248.83	$ 700.00	$ 820.31	$ 533.20	$ 307.62	$ 278.91	$ 427.93	$ 408.79
Rental Car Gas

Andrew Huddleston: Andrew Huddleston:

5 cars $100/week $ 1,215.63 $ 875.00 $ 671.88 $ 1,037.50 $ 534.38 $ 740.63 $ 734.38 $ 568.75 $ 637.50 $ 1,246.88 $ 568.75 $ 1,600.00 $ 1,875.00 $ 1,218.75 $ 703.13 $ 637.50 $ 978.13 $ 934.38

Total Travel	$ 17,283.02	$ 13,015.43	$ 6,410.08	$ 10,776.65	$ 6,898.23	$ 6,251.78	$ 5,911.44	$ 5,501.97	$ 5,060.17	$ 13,571.76	$ 4,935.94	$ 20,204.16	$ 18,681.49	$ 13,016.48	$ 5,552.84	$ 5,939.94	$ 8,946.98	$ 14,143.48
Round Up	$ 17,300.00	$ 13,100.00	$ 6,500.00	$ 10,800.00	$ 6,900.00	$ 6,300.00	$ 6,000.00	$ 5,600.00	$ 5,100.00	$ 13,600.00	$ 5,000.00	$ 20,300.00	$ 18,700.00	$ 13,100.00	$ 5,600.00	$ 6,000.00	$ 9,000.00	$ 14,200.00

Crew = 10
Cars = 5
1 hour per PSA/1 day per project
Assume mixed gender so three rooms needed
Assume 25% of time can get project lodging
Use perdiem to help estimate hotel costs in region
Enterprise lease program $175/week/vehicle (Sedan/SUV) 2 ppl per vehicle
30 min travel between PSA's
1-10 psa/proj	2.75 hours travel per project
11-25 psa/proj	8 hours travel per project
26-50 psa/proj	17 hours travel per project
50+ psa/proj	40 hours travel per project

District Data

		District	Projects	# PSA's/Proj	PSA's in R1S?	# Campsites in
R1S	# Shelters in
R1S	# Pic Sites in
R1S	2021 Visitation	5+ PSA's or >400k vis
	FY22-23:	Kansas City	Clinton Lake	8	Y				1,300,952	Yes
		17	Harlan Lake	9	Y				851,667	Yes
			Harry S. Truman	16	Y				1,977,707	Yes
			Hillsdale	1	N	0	1	2	458,602	Yes
			Kanopolis	5	Y				394,212	Yes
			Little Blue River	1	N	0	0	1	872,995	Yes
			Long Branch	1	N	0	0	7	265,748	No
			Melvern Lake	5	Y				526,675	Yes
			Milford Lake	9	Y				1,395,793	Yes
			Perry Lake	8	Y				674,571	Yes
			Pomme De Terre	8	Y				1,054,838	Yes
			Pomona Lake	9	Y				459,875	Yes
			Rathbun Lake	6	Y				651,732	Yes
			Smithville Lake	2	N	0	1	10	1,244,147	No
			Stockton Lake	14	Y				914,214	Yes
			Tuttle Creek	6	Y				1,068,742	Yes
			Wilson Lake	4	Y				502,573
			TOTAL			0	2	20		Yes
		Omaha	Big Bend Dam	9	Y				1,096,630	Yes
		9	Cold Brook Lake	1	Y				57,172	No
			Cottonwood Springs	1	Y				16,714	No
			Fort Peck	26	Y				611,785	Yes
			Fort Randall	6	N	0	0	7	362,994	Yes
			Garrison Dam	10	Y				1,878,945	Yes
			Gavins Point	7	Y				1,081,246	Yes
			Oahe Dam	6	Y				1,392,988	Yes
			Pipestem Lake	1	N	6	0	3	33,804	No
			TOTAL			6	0	10
		Seattle	Albeni Falls Dam	7	Y				448,892	Yes
		5	Chief Joseph Dam	10	N	3	10	49	277,633	Yes
			Ballard Locks	1	N	0	0	0	723,563	Yes
			Libby Dam	7	N	24	4	28	111,397	Yes
			Mud Mountain	1	Y				16,004	No
			TOTAL			27	14	77
		Walla Walla	Dworshak	12	Y				364,093	Yes
		8	Ice Harbor	14	Y				265,906	Yes
			Little Goose	10	N	49	0	6	298,229	Yes
			Lower Granite	14	N	52	4	33	1,997,385	Yes
			Lower Monumental	6	N	41	2	0	170,015	Yes
			Lucky Peak	8	Y				914,187	Yes
			McNary Lock and Dam	11	Y				2,927,322	Yes
			Mill Creek	1	Y				123,160	No
			TOTAL			142	6	39
		Los Angeles (SPL)	Sepulveda Dam	1	N	0	0	0	991,417	Yes
			TOTAL			0	0	0
		Albuquerque (SPA)	Abiquiu Dam	5	Y				127,099	Yes
		7	Cochiti Lake	3	Y				104,779	No
			Conchas Lake	4	N	20	1	40	92,535	No
			Galisteo Dam	1	N	0	0	6	250	No
			John Martin Resevoir	1	N	0	1	0	499,674	Yes
			Santa Rosa Dam	1	N	0	0	2	66,616	No
			Two Rivers Dam	1	N	0	0	9	958	No
			TOTAL			20	2	57
		Galveston (SWG)	Buffalo Bayou	1	N	0	0	2	2,456,445	Yes
		2	Wallisville Lake	4	N	0	1	34	75,008	No
			TOTAL			0	1	36
		New Orleans (MVN)	Atch Basin Floodway	2	N	0	0	2	322,066	No
		4	Bonnet Carre Spillway	6	N	0	0	10	495,369	Yes
			Old River	2	N	30	0	7	34,433	No
			Port Allen	2	N	0	0	4	289,819	No
			TOTAL			30	0	23
	FY23:	Savannah (SAS)	Hartwell Dam	48	Y				8,495,905	Yes
		3	J Strom Thurmond Dam	53	Y				4,529,567	Yes
			Richard B. Russel Dam	3	N	0	2	6	669,132	Yes
			TOTAL			0	2	6
		Jacksonville (SAJ)	Central and South FL	4	Y				624,241	Yes
		2	Okeechobee Waterway	3	Y				584,238	Yes
			TOTAL			0	0	0
		New England (NAE)	Ball Mountain Lake	2	Y				67,800	No
		32	Barre Falls Dam	1	Y				70,436	No
			Birch Hill Dam	1	N	0	0	7	489,431	Yes
			Black Rock Lake	1	N	0	0	0	46,371	No
			Blackwater Dam	6	N	0	0	7	24,674	Yes
			Buffumville Lake	2	Y				134,127	Yes
			Cape Cod Canal	5	N	0	4	108	2,784,074	Yes
			Charles River	1	N	0	0	0	3,659	No
			Colebrooke River Lake	2	N	0	0	3	70,699	No
			Conant Brook Dam	1	N	0	0	0	19,503	No
			East Brimfield Dam	3	N	0	0	16	135,435	No
			Edward MacDowell Lake	2	Y				40,056	No
			Franklin Falls Dam	6	N	0	2	29	145,149	Yes
			Hancock Brook Lake	2	N	0	0	0	21,074	No
			Hodges Village Dam	1	N	0	0	2	168,927	No
			Hop Brook Lake	2	Y				187,868	No
			Hopkinton Everett Lake	8	Y				418,235	Yes
			Knightville Dam	3	Y				14,190	No
			Littleville Lake	3	N	0	0	0	20,261	No
			Mansfield Hollow Lake	1	N	0	0	0	493,682	Yes
			North Hartland Lake	4	Y				129,357	No
			North Springfield Lake	5	Y				90,421	Yes
			Northfield Brook Lake	1	Y				31,933	No
			Otter Brook Lake	3	Y				80,070	No
			Surry Mountain Lake	3	Y				59,442	No
			Thomaston Dam	1	N	0	0	26	98,952	No
			Townshend Lake	3	Y				47,528	No
			Tully Lake	1	Y				229,700	No
			Union Village Dam	2	Y				56,888	No
			West Hill Dam	2	Y				73,629	No
			West Thompson Lake	2	Y				250,539	No
			Westville Lake	2	Y				100,394	No
			TOTAL			0	6	198
		Huntington (LRH)	Alum Creek Lake	2	Y				236,774	No
		40	Atwood Lake	1	N	0	1	29	29,004	No
			Beach City Lake	1	N	0	0	4	7,800	No
			Beech Fork Lake	3	Y				116,491	No
			Belleville Lock	2	N	0	2	0	33,135	No
			Bluestone Lake	3	Y				64,507	No
			Bolivar Dam	1	N	0	0	17	7,250	No
			Burnsville Lake	7	Y				128,487	Yes
			Capt. Anthony Meldahl	2	N	0	2	8	47,905	No
			Charles Mill Lake	1	N	0	0	25	30,674	No
			Clendening Lake	1	N	0	0	10	12,270	No
			Deer Creek Lake	1	Y				215,790	No
			Delaware Lake	1	Y				84,248	No
			Dewey Lake	3	Y				76,795	No
			Dillon Lake	1	Y				54,998	No
			Dover Dam	1	N	0	0	6	10,788	No
			East Lynn Lake	6	Y				114,094	Yes
			Fishtrap Lake	5	Y				167,010	Yes
			Grayson Lake	2	Y				103,857	No
			Greenup Lock	3	N	0	8	2	56,820	No
			John Flannagan Dam	7	Y				73,788	Yes
			London Lock	1	N	0	0	3	4,789	No
			Marmet Lock	1	N	0	2	0	15,615	No
			Mohicanville Dam	1	N	0	0	0	5,756	No
			NB Kokosing River Lake	2	N	0	0	0	5,857	No
			NF of Pound Lake	1	N	0	0	3	15,262	No
			Paint Creek Lake	1	Y				47,906	No
			Paintsville Lake	2	N	0	0	0	111,945	No
			Pleasant Hill Lake	1	N	0	1	5	16,731	No
			RD Bailey Lake	5	Y				144,374	Yes
			Racine Lock	1	N	0	2	0	6,694	No
			Robert Byrd Lock	2	N	0	5	20	31,235	No
			Summersville Lake	6	Y				409,987	Yes
			Sutton Lake	4	Y				186,205	No
			Tappan Lake	1	N	0	0	3	16,618	No
			Tom Jenkins Dam	1	N	0	2	8	14,068	No
			Willow Island Lock	1	N	0	2	0	9,761	No
			Wills Creek Lake	1	N	0	0	0	27,886	No
			Winfield Lock	2	N	0	5	0	20,169	No
			Yatesville Lake	1	N	0	0	0	37,499	No
			TOTAL			0	32	143
		Pittsburgh (LRP)	Berlin Lake	3	N	316	2	60	788,759	Yes
		19	Conemaugh River Lake	3	Y				239,036	No
			Crooked Creek Lake	6	Y				248,927	Yes
			E. Branch Clarion Lake	4	Y				18,010	No
			Hannibal Locks	1	N	0	1	11	114,103	No
			Kinzua and Allegheny Resevoir	4	N	0	0	10	175,105	No
			Loyalhanna Lake	2	Y				260,027	No
			Mahoning Creek Lake	1	N	0	3	35	60,054	No
			Michael Kirwan Dam	3	N	0	1	3	568,335	Yes
			Mosquito Creek Lake	4	N	0	1	57	882,639	Yes
			New Cumberland Locks and Dam	1	N	0	0	3	14,016	No
			Pike Island Locks and Dam	1	N	0	0	0	37,465	No
			Shenango River Lake	21	Y				560,017	Yes
			Stonewall Jackson Lake	1	N	0	0	3	233,848	No
			Tionesta Lake	7	Y				112,514	Yes
			Tygart Lake	1	N	0	1	1	441,992	Yes
			Union City Lake	1	N	0	0	2	28,763	No
			Woodcock Creek	5	Y				222,149	Yes
			Youghigheny River Lake	4	Y				485,049	Yes
			TOTAL			316	9	185
		San Francisco (SPN)	Lake Mendocino	16	Y				267,288	Yes
		3	Lake Sonoma	14	Y				497,677	Yes
			San Francisco Bay	1	N	0	0	10	101,269	No
			TOTAL			0	0	10
		Philadelphia (NAP)	Beltzville Lake	1	N	0	0	1	670,708	Yes
		4	Blue Marsh Lake	23	Y				934,679	Yes
			Francis Walter Dam	6	N	0	0	47	130,644	Yes
			Prompton Lake	2	N	0	0	2	48,463	No
			TOTAL			0	0	50
		Chicago (LRC)	J. Edward Roush Lake	3	N	0	3	29	233,811	No
		4	Mississinewa Lake	3	N	0	3	29	565,690	Yes
			Salamonite Lake	2	N	0	2	13	334,611	No
			Sturgeon Bay	1	N	0	0	0	31,277	No
			TOTAL			0	8	71
		St. Paul (MVP)	Cross Lake	5	Y				162,372	Yes
		12	Eau Galle River Lake	5	Y				64,403	Yes
			Gull Lake	2	Y				89,425	No
			Lac Qui Parle Lakes	2	N	0	2	16	32,718	No
			Lake Ashtabula	7	Y				146,109	Yes
			Lake Traverse	3	N	0	0	13	18,713	No
			Leech Lake	1	Y				32,567	No
			Mississippi River	16	Y				226,347	Yes
			Orwell Lake	1	N	0	2	7	7,616	No
			Pokegema Lake	1	Y				25,177	No
			Sandy Lake Resevoir	1	Y				12,899	No
			Winnibigosh Lake	1	Y				14,768	No
			TOTAL			0	4	36
		Rock Island (MVR)	Coraville Lake	28	Y				1,163,057	Yes
		5	Illinois Waterway	4	N	0	1	9	109,072	No
			Mississippi River	32	Y				2,459,035	Yes
			Red Rock Dam	37	Y				1,130,255	Yes
			Saylorville Lake	19	Y				2,374,042	Yes
			TOTAL			0	1	9
			Total Projects	177						Revised Total Projects
			Total PSA's	907						Revised Total PSA's
			AVG PSA's	5
			AVG Visitation						435,172
			# PSA Assets NOT in R1S			541

Andrew Huddleston: Andrew Huddleston:

Campsites NOT in R1S 87 Andrew Huddleston: Andrew Huddleston:

Shelters NOT in R1S 970 Andrew Huddleston: Andrew Huddleston:

Picnic Sites NOT in R1S

Final Mile_Lot Count

Full Capability - Anticipated - Add FHWA Request:
	District	Number of PSA's

Huddleston, Andrew J CIV USARMY CENWS (USA): Huddleston, Andrew J CIV USARMY CENWS (USA):

TOTAL PSA's, USACE managed PSA's is much less	Day Use
Car Spaces	Developed
Single User Campsites	Number Parking
Lots	Paved Miles	Unpaved
Miles	Total Mileage	Month of
Completion	# Weeks	$/month/rental car	Number

Rental Cars Andrew Huddleston: Andrew Huddleston:

2 ppl per vehicle…11 ppl on the team

Rental Car Mo Cost	~Hours per PSA	~Days per Project
FY22:	Omaha	220	22,129	4,837	756	178.19	219.9	398.09	SEPT 22	6	$ 700.00	5	3500	1	1
FY23:	Seattle	34	1,160	235	78	15.54	3.49	19.03	OCT 22	2	$ 700.00	5	3500	1	1
	Walla Walla	107	9,318	1,129	304	66.89	62.01	128.9	NOV 22	4	$ 1,400.00	5	7000	1	1
	Los Angeles	16	25,691	454	146	51.5	20.7	72.2	DEC 22	2	$ 700.00	5	3500	1	1
	Albuquerque	31	1,668	718	29	26.09	24.47	50.56	DEC 22	2	$ 700.00	5	3500	1	1
	San Francisco	32	1,583	473	28	22.92	10.2	33.12	JAN 23	2	$ 700.00	5	3500	1	1
	Galveston	14	6,452	0	41	32.75	24.64	57.39	JAN 23	2	$ 700.00	5	3500	1	1
	New Orleans	14	1,675	0	48	5.75	114.76	120.51	FEB 23	2	$ 700.00	5	3500	1	1
	Kansas City	208	19,829	9,853	1,021	413.98	136.14	550.12	MAR 23	8	$ 700.00	5	3500	1	1
		644	87,922	17,226	2,423	790.69	606.11	1396.8
FY24:	Savannah	254	8,192	2,894	445	244.07	189.8	433.87	APR 23	6	$ 700.00	5	3500	1	1
	Jacksonville	8	437	109	25	5.75	0.55	6.3	MAY 23	2	$ 700.00	5	3500	1	1
	New England	98	7,934	930	251	80.96	140.02	220.98	JUNE 23	6	$ 700.00	5	3500	1	1
	Huntington	184	16,432	3,798	564	192.3	278.04	470.34	JULY 23	8	$ 700.00	5	3500	1	1
	Pittsburgh	163	10,552	1,887	310	120.57	176.14	296.71	AUG 23	5	$ 700.00	5	3500	1	1
	Philadelphia	36	2,312	0	33	5.11	1.82	6.93	SEPT 23	2	$ 700.00	5	3500	1	1
	Chicago	25	2,283	830	84	39.97	13.85	53.82	OCT 23	2
	St. Paul	100	1,953	1,256	175	36.34	26.62	62.96	NOV 23	3	$ 700.00	5	3500	1	1
	Rock Island	227	10,433	2,962	725	94.35	56.44	150.79	DEC 23	5
		1,127	62,111	15,139	2,640	842.34	893.48	1735.82

Sheet2 USACE FLTP Road Mileage Comparison

Original Road Mileage/Dist			SCA Road Mileage/Dist			NRMA Road Mileage/Dist
District:	Road Mileage	Parking Lots	Road Mileage	Parking Lots	Difference	Paved

Andrew Huddleston: Andrew Huddleston:

Service and Public Paved Unpaved Andrew Huddleston: Andrew Huddleston:

Service and Public Unpaved	Road Mileage	Parking Lots	Difference	SCA Actual Diff
	Alaska (POA)	13	0		-13	6.5	6.5	13	0	0
	Albuquerque (SPA)	42.71	21		-42.71	26.09	24.47	50.56	29	7.85
	Baltimore (NAB)	77.89	127		-77.89	78.18	58.46	136.64	133	58.75
	Buffalo (LRB)	1.9	8		-1.9	1.95	1.55	3.5	7	1.6
	Chicago (LRC)	53.82

Andrew Huddleston: Andrew Huddleston:

Was not included in Zach's initial rollup Andrew Huddleston: Andrew Huddleston:

Service and Public Paved Andrew Huddleston: Andrew Huddleston:

Service and Public Unpaved	84			-53.82	39.97	13.85	53.82	84	0
	Detroit (LRE)	1	0		-1		1	0	1	2	0
	Fort Worth (SWF)	540.93	1071		-540.93		536.05	65.04	601.09	1763	60.16
	Galveston (SWG)	48.11	12		-48.11		32.75	24.64	57.39	41	9.28
	Honolulu (POH)	0	0		0		0	0	0	0	0		$ 1,015,000.00
	Huntington (LRH)	312.96	391		-312.96		192.3	278.04	470.34	564	157.38		Roads budget
	Jacksonville (SAJ)	7.5	26		-7.5		5.75	0.55	6.3	25	-1.2
	Kansas City (NWK)	502.44	832		-502.44		413.98	136.14	550.12	1021	47.68
	Little Rock (SWL)	395.72	852		-395.72		379.35	35.65	415	1119	19.28		$ 508,000.00
	Los Angeles (SPL)	20	260		-20		51.5	20.7	72.2	146	52.2		spent on roads alone
	Louisville (LRL)	253.48	467		-253.48		212.43	48.19	260.62	488	7.14
	Mobile (SAM)	465.59	823	617.55	151.96		455.62	97.35	552.97	1214	87.38	-64.58
	Nashville (LRN)	260.98	541	259.32	-1.66		242.95	29.08	272.03	663	11.05	12.71
	New England (NAE)	95.94	184		-95.94		80.96	140.02	220.98	251	125.04
	New Orleans (MVN)	73	36		-73		5.75	114.76	120.51	48	47.51		$ 200.91
	Omaha (NWO)	361.08	776		-361.08		178.19	219.9	398.09	756	37.01
	Philadelphia (NAP)	9.49	10		-9.49		5.11	1.82	6.93	33	-2.56
	Pittsburgh (LRP)	121.78	196		-121.78		120.57	176.14	296.71	310	174.93
	Portland (NWP)	72.41	103	77.19	4.78		57.08	22.37	79.45	247	7.04	2.26
	Rock Island (MVR)	135.57	684		-135.57		94.35	56.44	150.79	725	15.22
	Sacramento (SPK)	70.78	180		-70.78		59.57	45.02	104.59	182	33.81
	San Francisco (SPN)	15.53	12		-15.53		22.92	10.2	33.12	28	17.59
	Savannah (SAS)	339.57	345		-339.57		244.07	189.8	433.87	445	94.3
	Seattle (NWS)	18.7	77		-18.7		15.54	3.49	19.03	78	0.33
	St. Louis (MVS)	231.56	515		-231.56		191.7	130.63	322.33	712	90.77
	St. Paul (MVP)	94.84	134		-94.84		36.34	26.62	62.96	175	-31.88
	Tulsa (SWT)	831.18	1501	1055.41	224.23		623.03	324.52	947.55	1598	116.37	-107.86
	Vicksburg (MVK)	349.24	666	367.87	18.63		259.4	109.53	368.93	890	19.69	1.06
	Walla Walla (NWW)	95.27	236		-95.27		66.89	62.01	128.9	304	33.63
	Wilmington (SAW)	173.85	350	151.1	-22.75		136.35	87.33	223.68	475	49.83	72.58
	TOTALS	6087.82	11520	2528.44			4874.19	2560.81	7435	14556	1347.18
	Aggressive Schedule	Road Mileage					493.76
	Current Efforts	818.37		124.677			179.58
	FY 19-20	2918.24
	FY 20-21	1867.93
	FY 21-22	429.46
	TOTAL	6034
	Selection Critieria:
	Districts with most road mileage
	Finishing partially completed Districts (OCAs)
	Lumping Districts geographically

OCA Time Estimator

TASK

NWK

NWO

NWS

NWW

SPL

SPA

SPN

SWG

MVN

SAS

SAJ

NAE

LRH

LRP

NAP

LRC

MVP

MVR

Roads

Paved/Unpaved miles from NRMA

Andrew Huddleston: Andrew Huddleston:

NRMA=NRM Assessment, unpaved and paved road mileage on all USACE OWNED roadways	550	398	19	129	72	51	33	57	121	434	6	221	470	297	7	54	63	151
	Rate per hour

tc={59DB17E9-7978-49E4-91A2-D4FA40761747}: [Threaded comment]

Comment:

Need to hone in the rate of road collection...how many road miles can be collected in 1 hour?	20	20	20	20	20	20	20	20	20		20	20	20	20	20	20	20	20	20
	Estimated time	27.5	19.9	0.95	6.45	3.6	2.55	1.65	2.85	6.05		21.7	0.3	11.05	23.5	14.85	0.35	2.7	3.15	7.55
	20% contingency	5.5	3.98	0.19	1.29	0.72	0.51	0.33	0.57	1.21		4.34	0.06	2.21	4.7	2.97	0.07	0.54	0.63	1.51
	Total estimated time (hours)	33	23.88	1.14	7.74	4.32	3.06	1.98	3.42	7.26		26.04	0.36	13.26	28.2	17.82	0.42	3.24	3.78	9.06
	Parking Lots
	Count from NRMA	1,021	756	78	304	146	29	28	41	48		445	25	251	564	310	33	84	175	725
	Rate per hour	25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00		25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00
	Estimated time	40.84	30.24	3.12	12.16	5.84	1.16	1.12	1.64	1.92		17.80	1.00	10.04	22.56	12.40	1.32	3.36	7.00	29.00
	20% contingency	8.17	6.05	0.62	2.43	1.17	0.23	0.22	0.33	0.38		3.56	0.20	2.01	4.51	2.48	0.26	0.67	1.40	5.80
	Total estimated time (hours)	49.008	36.288	3.744	14.592	7.008	1.392	1.344	1.968	2.304		21.36	1.2	12.048	27.072	14.88	1.584	4.032	8.4	34.8
	Campsites
	Count from NRMA	9,853	4,837	235	1,129	454	718	473	0	0		2,894	109	930	3,798	1,887	0	830	1,256	2,962
	Rate per hour	100	100	100	100	100	100	100	100	100		100	100	100	100	100	100	100	100	100
	Estimated time	98.53	48.37	2.35	11.29	4.54	7.18	4.73	0.00	0.00		28.94	1.09	9.30	37.98	18.87	0.00	8.30	12.56	29.62
	20% contingency	19.71	9.67	0.47	2.26	0.91	1.44	0.95	0.00	0.00		5.79	0.22	1.86	7.60	3.77	0.00	1.66	2.51	5.92
	Total estimated time (hours)	118.24	58.04	2.82	13.55	5.45	8.62	5.68	0.00	0.00		34.73	1.31	11.16	45.58	22.64	0.00	9.96	15.07	35.54
	Other features (point only)
	Total Count from NRMA

Andrew Huddleston: Andrew Huddleston:

Traffic Counters Dump Stations Trail Heads Amph Fish Features Restrooms Boat Ramp Swim Beach Picnic Site Group Picnic Site Group Camp Shelter

1,901	1,790	374	1,446	980	306	362	1,233	132		2,521	103	1,474	1,968	1,189	527	400	651	1,144
Rate per hour	50	50	50	50	50	50	50	50	50		50	50	50	50	50	50	50	50	50
Estimated time	38.02	35.8	7.48	28.92	19.6	6.12	7.24	24.66	2.64		50.42	2.06	29.48	39.36	23.78	10.54	8	13.02	22.88
30% Contingency	11.406	10.74	2.244	8.676	5.88	1.836	2.172	7.398	0.792		15.126	0.618	8.844	11.808	7.134	3.162	2.4	3.906	6.864
Total estimated time (hours)	49.426	46.54	9.724	37.596	25.48	7.956	9.412	32.058	3.432		65.546	2.678	38.324	51.168	30.914	13.702	10.4	16.926	29.744
OCA Data Collection

Additional Weeks Andrew Huddleston: Andrew Huddleston:

Add 4 days to each project for OCA collection, rating, etc.	10	6	3	5	1	4	2	2	3		2	2	19	24	11	3	3	7	3
	Total Time for all features (Hours)	249.67	164.75	17.43	73.48	42.26	21.02	18.41	37.45	13.00		147.67	5.55	74.79	152.02	86.26	15.71	27.63	44.18	109.15
	Data collection + 10% Conservation Project Time	274.64	181.23	19.17	80.82	46.48	23.13	20.25	41.19	14.30		162.44	6.10	82.27	167.22	94.88	17.28	30.40	48.60	120.06

Project Count

USACE: USACE:

Project count from FY20 NRMA.

tc={59DB17E9-7978-49E4-91A2-D4FA40761747}: [Threaded comment]

Comment:

Need to hone in the rate of road collection...how many road miles can be collected in 1 hour? 17 9 5 8 1 7 3 2 4 3 2 32 41 19 4 4 12 5

Weeks of data collection	6.24175	4.1188	0.4357	1.8369	1.0564	0.5256	0.4603	0.93615	0.3249	3.69185	0.13865	1.8698	3.8004	2.15645	0.39265	0.6908	1.10445	2.7287
Weeks in travel

estimator

USACE: USACE:

this comes directly from travel estimator Andrew Huddleston: Andrew Huddleston:

Traffic Counters Dump Stations Trail Heads Amph Fish Features Restrooms Boat Ramp Swim Beach Picnic Site Group Picnic Site Group Camp Shelter

Andrew Huddleston: Andrew Huddleston:

Add 4 days to each project for OCA collection, rating, etc.	2.43125	1.75	1.34375	2.075	1.06875	1.48125	1.46875	1.1375	1.275		2.49375	1.1375	3.2	3.81875	2.4375	1.40625	1.275	1.95625	1.86875
	Total Weeks Per District	18.673	11.8688	4.77945	8.9119	3.12515	6.00685	3.92905	4.07365	4.5999		8.1856	3.27615	24.0698	31.61915	15.59395	4.7989	4.9658	10.0607	7.59745	176.14
	Estimated hours	746.92	474.75	191.18	356.48	125.01	240.27	157.16	162.95	184.00		327.42	131.05	962.79	1264.77	623.76	191.96	198.63	402.43	303.90	7045.41
	Adjusted estimated hours	747.00	475.00	192.00	357.00	126.00	241.00	158.00	163.00	184.00		328.00	132.00	963.00	1265.00	624.00	192.00	199.00	403.00	304.00	7053.00
	Adjusted estimated weeks	19.00	12.00	5.00	9.00	4.00	7.00	4.00	5.00	5.00		9.00	4.00	25.00	32.00	16.00	5.00	5.00	11.00	8.00	185.00
	Adjusted estimated months	4.75	3	1.25	2.25	1	1.75	1	1.25	1.25	0	2.25	1	6.25	8	4	1.25	1.25	2.75	2	46.25

The difference from the travel estimator is allowed as a logistical contingency. The location of projects will impact the pace and quantity of data collection

File details come from the government source that posted it. Updated Aug 5, 2022.