Cost Estimate Worksheet

High Impact Airport	Number of Carriers Including Cargo	Number of Annual Updates	Time Required Per Update (6 min per update)	Total Time (hours)	Wage*	Total Cost
ANC	20	365	0.1	730	$116.54	$85,074.20
ATL	19	365	0.1	693.5	$116.54	$80,820.49
BOS	15	365	0.1	547.5	$116.54	$63,805.65
BWI	11	365	0.1	401.5	$116.54	$46,790.81
CLT	10	365	0.1	365	$116.54	$42,537.10
CVG	12	365	0.1	438	$116.54	$51,044.52
DAL	4	365	0.1	146	$116.54	$17,014.84
DCA	9	365	0.1	328.5	$116.54	$38,283.39
DEN	13	365	0.1	474.5	$116.54	$55,298.23
DFW	21	365	0.1	766.5	$116.54	$89,327.91
DTW	12	365	0.1	438	$116.54	$51,044.52
EWR	12	365	0.1	438	$116.54	$51,044.52
FLL	14	365	0.1	511	$116.54	$59,551.94
HNL	11	365	0.1	401.5	$116.54	$46,790.81
HOU	8	365	0.1	292	$116.54	$34,029.68
IAD	13	365	0.1	474.5	$116.54	$55,298.23
IAH	11	365	0.1	401.5	$116.54	$46,790.81
IND	12	365	0.1	438	$116.54	$51,044.52
JFK	12	365	0.1	438	$116.54	$51,044.52
LAS	16	365	0.1	584	$116.54	$68,059.36
LAX	19	365	0.1	693.5	$116.54	$80,820.49
LGA	7	365	0.1	255.5	$116.54	$29,775.97
MCO	14	365	0.1	511	$116.54	$59,551.94
MDW	7	365	0.1	255.5	$116.54	$29,775.97
MEM	12	365	0.1	438	$116.54	$51,044.52
MIA	15	365	0.1	547.5	$116.54	$63,805.65
MSP	11	365	0.1	401.5	$116.54	$46,790.81
OAK	8	365	0.1	292	$116.54	$34,029.68
ONT	9	365	0.1	328.5	$116.54	$38,283.39
ORD	25	365	0.1	912.5	$116.54	$106,342.75
PDX	13	365	0.1	474.5	$116.54	$55,298.23
PHL	11	365	0.1	401.5	$116.54	$46,790.81
PHX	18	365	0.1	657	$116.54	$76,566.78
SAN	12	365	0.1	438	$116.54	$51,044.52
SDF	10	365	0.1	365	$116.54	$42,537.10
SEA	10	365	0.1	365	$116.54	$42,537.10
SFO	12	365	0.1	438	$116.54	$51,044.52
SLC	10	365	0.1	365	$116.54	$42,537.10
TEB	2	365	0.1	73	$116.54	$8,507.42
TPA	13	365	0.1	474.5	$116.54	$55,298.23
Total Annual Burden				17,994.5		$2,097,079.03
*BLS fully-burdened hourly wage for a 11-3012 Administrative Service Manager for 2023, $58.27*2 = Hourly wage including overhead and benefits