1,280 480 = N84* R84*( 1+ T84) = O84* R84*( 1+ T84) $ 20.00 $ 40.00 0.5 $ 15,000.00 $ 5,000.00 $ 10,000.00 368 448 = N89* R89*( 1+ T89) = O89* R89*( 1+ T89) $ 13.89 $ 28.00 0.5 $ 36.00 $ 48.00 $ 350.00 6,794 4,220 = N91* R91*( 1+ T91) = O91* R91*( 1+ T91) $ 19.50 $ 35.50 0.78 $ 412,814.00 $ 427,032.00 $ 92,083.00 840 820 = N93* R93*( 1+ T93) = O93* R93*( 1+ T93) $ 21.00 $ 34.00 0.15 $ 28,000.00 $ 28,000.00 $ 8,000.00 $ 10,000 $ 1,000 NA NA NA $ 50,000.00 $ 50,000.00 $ 20,000.00 28,330 10,730 = N95* R95*( 1+ T95) = O95* R95*( 1+ T95) $ 30.00 $ 42.00 0.33 $ 200,000.00 $ 100,000.00 $ 135,000.00 16,482 7,914 = N97* R97*( 1+ T97) = O97* R97*( 1+ T97) $ 21.00 $ 28.00 0.5 $ 179,037.00 $ 84,037.00 $ 115,824.00 464 104 = N100* R100*( 1+ T100) = O100* R100*( 1+ T100) $ 19.73 $ 27.05 0.5 = 1800* 29 = 1800* 29 = 720* 29 24,000 8,000 = N101* R101*( 1+ T101) = O101* R101*( 1+ T101) $ 15.00 $ 24.00 0.4 $ 285,000.00 $ 295,000.00 $ 80,000.00 22,833 10,036 = N104* R104*( T104) = O104* R104*( T104) $ 20.16 $ 35.35 1.0817 $ 1,030,900.00 $ 1,030,900.00 $ 95,160.00 9,435 9,435 $ 25.05 $ 31.19 0.804 $ 68,325.18 $ 68,325.18 $ 120,060.00 411 258 = N113* R113*( T113) = O113* R113*( T113) $ 22.00 $ 32.00 4.52 = 562* 68 = 562* 68 = 372* 68 = 53* 33 = 37* 33 = N116* R116*( 1+ T116) = O116* R116*( 1+ T116) $ 19.50 $ 24.50 0.5 $ 153,000.00 $ 153,000.00 $ 40,800.00 February 14, 2003 62 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central X Y Z AA AB AC AD Yearly Implement Yearly Implement Yearly Implement Yearly Sampling Costs Management Salary Hrs Management Overhead Costs Total Costs $ 85,000.00 200 100 = Y63* S63*( 1+ T63) = Z63* S63*( 1+ T63) = P63+ U63+ W63+ AA63 = Q63+ V63+ X63+ AB63 $ 10,000.00 400 400 = Y71* S71*( 1+ T71) = Z71* S71*( 1+ T71) = P71+ U71+ W71+ AA71 = Q71+ V71+ X71+ AB71 $ 1,050,000.00 $ 5,650,000.00 $ 816,000.00 = P75+ U75+ W75+ AA75 = Q75+ V75+ X75+ AB75 $ 1,000.00 4,750 1,380 = Y76* S76*( 1+ T76) = Z76* S76*( 1+ T76) = P76+ U76+ W76+ AA76+ P77 = Q76+ V76+ X76+ AB76+ Q77 $ 5,000.00 480 120 = Y84* S84*( 1+ T84) = Z84* S84*( 1+ T84) = P84+ U84+ W84+ AA84 = Q84+ V84+ X84+ AB84 $ 500.00 36 48 = Y89* S89*( 1+ T89) = Z89* S89*( 1+ T89) = P89+ U89+ W89+ AA89 = Q89+ V89+ X89+ AB89 $ 96,159.00 260 250 = Y91* S91*( 1+ T91) = Z91* S91*( 1+ T91) = P91+ U91+ W91+ AA91 = Q91+ V91+ X91+ AB91 $ 8,000.00 250 200 = Y93* S93*( 1+ T93) = Z93* S93*( 1+ T93) = P93+ U93+ W93+ AA93 = Q93+ V93+ X93+ AB93 $ 20,000.00 NA NA $ 25,000.00 $ 25,000.00 = P94+ U94+ W94+ AA94 = Q94+ V94+ X94+ AB94 $ 68,000.00 $ 50,000.00 $ 25,000.00 = P95+ U95+ W95+ AA95 = Q95+ V95+ X95+ AB95 $ 120,456.00 1,440 1,440 = Y97* S97*( 1+ T97) = Z97* S97*( 1+ T97) = P97+ U97+ W97+ AA97 = Q97+ V97+ X97+ AB97 = 720* 29 84 72 = Y100* S100*( 1+ T100) = Z100* S100*( 1+ T100) = P100+ U100+ W100+ AA100 = Q100+ V100+ X100+ AB100 $ 83,000.00 7,440 7,440 = Y101* S101*( 1+ T101) = Z101* S101*( 1+ T101) = P101+ U101+ W101+ AA101 = Q101+ V101+ X101+ AB101 $ 95,160.00 1,500 750 = Y104* S104*( T104) = Z104* S104*( T104) = P104+ U104+ W104+ AA104 = Q104+ V104+ X104+ AB104 $ 129,720.00 202 202 = Y111* S111*( 1+ T111) = Z111* S111*( 1+ T111) = P111+ U111+ W111+ AA111 = Q111+ V111+ X111+ AB111 = 372* 68 40 40 = Y113* S113*( T113) = Z113* S113*( T113) = P113+ U113+ W113+ AA113 = Q113+ V113+ X113+ AB113 $ 40,800.00 135 60 = Y116* S116*( 1+ T116) = Z116* S116*( 1+ T116) = P116+ U116+ W116+ AA116 = Q116+ V116+ X116+ AB116 February 14, 2003 63 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central AE AF Implement Yearly Permitting Costs Per Facility = P63/ 132 = Q63/ 132 = P71/ 27 = Q71/ 27 = P76/ 57 = Q76/ 57 = P84/ 15 = Q84/ 15 = P89/ M89 = Q89/ M89 = P91/ 143 = Q91/ 143 = P93/ M93 = Q93/ M93 = P94/ M94 = Q94/ M94 = P95/ M95 = Q95/ M95 = P97/ 447 = Q97/ 447 = P100/ M100 = Q100/ M100 = P101/ M101 = Q101/ M101 = P104/ 599 = Q104/ 599 = P113/ 68 = Q113/ 68 = P116/ 33 = Q116/ 33 February 14, 2003 64 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central AG AH AI Implement Yearly MP& M Sites per Program Total Costs Per Facility = IF( OR( A60'= A59, M60'=""),"", SUMIF($ A$ 3:$ A$ 120, A60,$ M$ 3:$ M$ 120)) = IF( OR( A61'= A60, M61'=""),"", SUMIF($ A$ 3:$ A$ 120, A61,$ M$ 3:$ M$ 120)) = IF( OR( A62'= A61, M62'=""),"", SUMIF($ A$ 3:$ A$ 120, A62,$ M$ 3:$ M$ 120)) = AC63/ 132 = AD63/ 132 = IF( OR( A63'= A62, M63'=""),"", SUMIF($ A$ 3:$ A$ 120, A63,$ M$ 3:$ M$ 120)) = IF( OR( A64'= A63, M64'=""),"", SUMIF($ A$ 3:$ A$ 120, A64,$ M$ 3:$ M$ 120)) = IF( OR( A65'= A64, M65'=""),"", SUMIF($ A$ 3:$ A$ 120, A65,$ M$ 3:$ M$ 120)) = IF( OR( A66'= A65, M66'=""),"", SUMIF($ A$ 3:$ A$ 120, A66,$ M$ 3:$ M$ 120)) = IF( OR( A67'= A66, M67'=""),"", SUMIF($ A$ 3:$ A$ 120, A67,$ M$ 3:$ M$ 120)) = IF( OR( A68'= A67, M68'=""),"", SUMIF($ A$ 3:$ A$ 120, A68,$ M$ 3:$ M$ 120)) = IF( OR( A69'= A68, M69'=""),"", SUMIF($ A$ 3:$ A$ 120, A69,$ M$ 3:$ M$ 120)) = IF( OR( A70'= A69, M70'=""),"", SUMIF($ A$ 3:$ A$ 120, A70,$ M$ 3:$ M$ 120)) = AC71/ 27 = AD71/ 27 = IF( OR( A71'= A70, M71'=""),"", SUMIF($ A$ 3:$ A$ 120, A71,$ M$ 3:$ M$ 120)) = IF( OR( A72'= A71, M72'=""),"", SUMIF($ A$ 3:$ A$ 120, A72,$ M$ 3:$ M$ 120)) = IF( OR( A73'= A72, M73'=""),"", SUMIF($ A$ 3:$ A$ 120, A73,$ M$ 3:$ M$ 120)) = IF( OR( A74'= A73, M74'=""),"", SUMIF($ A$ 3:$ A$ 120, A74,$ M$ 3:$ M$ 120)) = AC75/ M75 = AD75/ M75 = IF( OR( A75'= A74, M75'=""),"", SUMIF($ A$ 3:$ A$ 120, A75,$ M$ 3:$ M$ 120)) = AC76/ 57 = AD76/ 57 = IF( OR( A76'= A75, M76'=""),"", SUMIF($ A$ 3:$ A$ 120, A76,$ M$ 3:$ M$ 120)) = IF( OR( A77'= A76, M77'=""),"", SUMIF($ A$ 3:$ A$ 120, A77,$ M$ 3:$ M$ 120)) = IF( OR( A78'= A77, M78'=""),"", SUMIF($ A$ 3:$ A$ 120, A78,$ M$ 3:$ M$ 120)) = IF( OR( A79'= A78, M79'=""),"", SUMIF($ A$ 3:$ A$ 120, A79,$ M$ 3:$ M$ 120)) = IF( OR( A80'= A79, M80'=""),"", SUMIF($ A$ 3:$ A$ 120, A80,$ M$ 3:$ M$ 120)) = IF( OR( A81'= A80, M81'=""),"", SUMIF($ A$ 3:$ A$ 120, A81,$ M$ 3:$ M$ 120)) = IF( OR( A82'= A81, M82'=""),"", SUMIF($ A$ 3:$ A$ 120, A82,$ M$ 3:$ M$ 120)) = IF( OR( A83'= A82, M83'=""),"", SUMIF($ A$ 3:$ A$ 120, A83,$ M$ 3:$ M$ 120)) = AC84/ 15 = AD84/ 15 = IF( OR( A84'= A83, M84'=""),"", SUMIF($ A$ 3:$ A$ 120, A84,$ M$ 3:$ M$ 120)) = IF( OR( A85'= A84, M85'=""),"", SUMIF($ A$ 3:$ A$ 120, A85,$ M$ 3:$ M$ 120)) = IF( OR( A86'= A85, M86'=""),"", SUMIF($ A$ 3:$ A$ 120, A86,$ M$ 3:$ M$ 120)) = IF( OR( A87'= A86, M87'=""),"", SUMIF($ A$ 3:$ A$ 120, A87,$ M$ 3:$ M$ 120)) = IF( OR( A88'= A87, M88'=""),"", SUMIF($ A$ 3:$ A$ 120, A88,$ M$ 3:$ M$ 120)) = AC89/ M89 = AD89/ M89 = IF( OR( A89'= A88, M89'=""),"", SUMIF($ A$ 3:$ A$ 120, A89,$ M$ 3:$ M$ 120)) = IF( OR( A90'= A89, M90'=""),"", SUMIF($ A$ 3:$ A$ 120, A90,$ M$ 3:$ M$ 120)) = AC91/ 143 = AD91/ 143 = IF( OR( A91'= A90, M91'=""),"", SUMIF($ A$ 3:$ A$ 120, A91,$ M$ 3:$ M$ 120)) = IF( OR( A92'= A91, M92'=""),"", SUMIF($ A$ 3:$ A$ 120, A92,$ M$ 3:$ M$ 120)) = AC93/ M93 = AD93/ M93 = IF( OR( A93'= A92, M93'=""),"", SUMIF($ A$ 3:$ A$ 120, A93,$ M$ 3:$ M$ 120)) = AC94/ M94 = AD94/ M94 = IF( OR( A94'= A93, M94'=""),"", SUMIF($ A$ 3:$ A$ 120, A94,$ M$ 3:$ M$ 120)) = AC95/ M95 = AD95/ M95 = IF( OR( A95'= A94, M95'=""),"", SUMIF($ A$ 3:$ A$ 120, A95,$ M$ 3:$ M$ 120)) = IF( OR( A96'= A95, M96'=""),"", SUMIF($ A$ 3:$ A$ 120, A96,$ M$ 3:$ M$ 120)) = AC97/ 447 = AD97/ 447 = IF( OR( A97'= A96, M97'=""),"", SUMIF($ A$ 3:$ A$ 120, A97,$ M$ 3:$ M$ 120)) = IF( OR( A98'= A97, M98'=""),"", SUMIF($ A$ 3:$ A$ 120, A98,$ M$ 3:$ M$ 120)) = IF( OR( A99'= A98, M99'=""),"", SUMIF($ A$ 3:$ A$ 120, A99,$ M$ 3:$ M$ 120)) = AC100/ M100 = AD100/ M100 = IF( OR( A100'= A99, M100'=""),"", SUMIF($ A$ 3:$ A$ 120, A100,$ M$ 3:$ M$ 120)) = AC101/ M101 = AD101/ M101 = IF( OR( A101'= A100, M101'=""),"", SUMIF($ A$ 3:$ A$ 120, A101,$ M$ 3:$ M$ 120)) = IF( OR( A102'= A101, M102'=""),"", SUMIF($ A$ 3:$ A$ 120, A102,$ M$ 3:$ M$ 120)) = IF( OR( A103'= A102, M103'=""),"", SUMIF($ A$ 3:$ A$ 120, A103,$ M$ 3:$ M$ 120)) = AC104/ 599 = AD104/ 599 = IF( OR( A104'= A103, M104'=""),"", SUMIF($ A$ 3:$ A$ 120, A104,$ M$ 3:$ M$ 120)) = IF( OR( A105'= A104, M105'=""),"", SUMIF($ A$ 3:$ A$ 120, A105,$ M$ 3:$ M$ 120)) = IF( OR( A106'= A105, M106'=""),"", SUMIF($ A$ 3:$ A$ 120, A106,$ M$ 3:$ M$ 120)) = IF( OR( A107'= A106, M107'=""),"", SUMIF($ A$ 3:$ A$ 120, A107,$ M$ 3:$ M$ 120)) = IF( OR( A108'= A107, M108'=""),"", SUMIF($ A$ 3:$ A$ 120, A108,$ M$ 3:$ M$ 120)) = IF( OR( A109'= A108, M109'=""),"", SUMIF($ A$ 3:$ A$ 120, A109,$ M$ 3:$ M$ 120)) = IF( OR( A110'= A109, M110'=""),"", SUMIF($ A$ 3:$ A$ 120, A110,$ M$ 3:$ M$ 120)) = AC111/ 69 = AD111/ 69 = IF( OR( A111'= A110, M111'=""),"", SUMIF($ A$ 3:$ A$ 120, A111,$ M$ 3:$ M$ 120)) = IF( OR( A112'= A111, M112'=""),"", SUMIF($ A$ 3:$ A$ 120, A112,$ M$ 3:$ M$ 120)) = AC113/ 68 = AD113/ 68 = IF( OR( A113'= A112, M113'=""),"", SUMIF($ A$ 3:$ A$ 120, A113,$ M$ 3:$ M$ 120)) = IF( OR( A114'= A113, M114'=""),"", SUMIF($ A$ 3:$ A$ 120, A114,$ M$ 3:$ M$ 120)) = IF( OR( A115'= A114, M115'=""),"", SUMIF($ A$ 3:$ A$ 120, A115,$ M$ 3:$ M$ 120)) = AC116/ 33 = AD116/ 33 = IF( OR( A116'= A115, M116'=""),"", SUMIF($ A$ 3:$ A$ 120, A116,$ M$ 3:$ M$ 120))

February 14, 2003 65 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central AJ AK Loaded Hourly Rate Loaded Salary Rate = IF( OR( R60'="", R60'=" NA"),"", R60*( 1+$ T60)) = IF( OR( S60'="", S60'=" NA"),"", S60*( 1+$ T60)) = IF( OR( R61'="", R61'=" NA"),"", R61*( 1+$ T61)) = IF( OR( S61'="", S61'=" NA"),"", S61*( 1+$ T61)) = IF( OR( R62'="", R62'=" NA"),"", R62*( 1+$ T62)) = IF( OR( S62'="", S62'=" NA"),"", S62*( 1+$ T62)) = IF( OR( R63'="", R63'=" NA"),"", R63*( 1+$ T63)) = IF( OR( S63'="", S63'=" NA"),"", S63*( 1+$ T63)) = IF( OR( R64'="", R64'=" NA"),"", R64*( 1+$ T64)) = IF( OR( S64'="", S64'=" NA"),"", S64*( 1+$ T64)) = IF( OR( R65'="", R65'=" NA"),"", R65*( 1+$ T65)) = IF( OR( S65'="", S65'=" NA"),"", S65*( 1+$ T65)) = IF( OR( R66'="", R66'=" NA"),"", R66*( 1+$ T66)) = IF( OR( S66'="", S66'=" NA"),"", S66*( 1+$ T66)) = IF( OR( R67'="", R67'=" NA"),"", R67*( 1+$ T67)) = IF( OR( S67'="", S67'=" NA"),"", S67*( 1+$ T67)) = IF( OR( R68'="", R68'=" NA"),"", R68*( 1+$ T68)) = IF( OR( S68'="", S68'=" NA"),"", S68*( 1+$ T68)) = IF( OR( R69'="", R69'=" NA"),"", R69*( 1+$ T69)) = IF( OR( S69'="", S69'=" NA"),"", S69*( 1+$ T69)) = IF( OR( R70'="", R70'=" NA"),"", R70*( 1+$ T70)) = IF( OR( S70'="", S70'=" NA"),"", S70*( 1+$ T70)) = IF( OR( R71'="", R71'=" NA"),"", R71*( 1+$ T71)) = IF( OR( S71'="", S71'=" NA"),"", S71*( 1+$ T71)) = IF( OR( R72'="", R72'=" NA"),"", R72*( 1+$ T72)) = IF( OR( S72'="", S72'=" NA"),"", S72*( 1+$ T72)) = IF( OR( R73'="", R73'=" NA"),"", R73*( 1+$ T73)) = IF( OR( S73'="", S73'=" NA"),"", S73*( 1+$ T73)) = IF( OR( R74'="", R74'=" NA"),"", R74*( 1+$ T74)) = IF( OR( S74'="", S74'=" NA"),"", S74*( 1+$ T74)) = IF( OR( R75'="", R75'=" NA"),"", R75*( 1+$ T75)) = IF( OR( S75'="", S75'=" NA"),"", S75*( 1+$ T75)) = IF( OR( R76'="", R76'=" NA"),"", R76*( 1+$ T76)) = IF( OR( S76'="", S76'=" NA"),"", S76*( 1+$ T76)) = IF( OR( R77'="", R77'=" NA"),"", R77*( 1+$ T77)) = IF( OR( S77'="", S77'=" NA"),"", S77*( 1+$ T77)) = IF( OR( R78'="", R78'=" NA"),"", R78*( 1+$ T78)) = IF( OR( S78'="", S78'=" NA"),"", S78*( 1+$ T78)) = IF( OR( R79'="", R79'=" NA"),"", R79*( 1+$ T79)) = IF( OR( S79'="", S79'=" NA"),"", S79*( 1+$ T79)) = IF( OR( R80'="", R80'=" NA"),"", R80*( 1+$ T80)) = IF( OR( S80'="", S80'=" NA"),"", S80*( 1+$ T80)) = IF( OR( R81'="", R81'=" NA"),"", R81*( 1+$ T81)) = IF( OR( S81'="", S81'=" NA"),"", S81*( 1+$ T81)) = IF( OR( R82'="", R82'=" NA"),"", R82*( 1+$ T82)) = IF( OR( S82'="", S82'=" NA"),"", S82*( 1+$ T82)) = IF( OR( R83'="", R83'=" NA"),"", R83*( 1+$ T83)) = IF( OR( S83'="", S83'=" NA"),"", S83*( 1+$ T83)) = IF( OR( R84'="", R84'=" NA"),"", R84*( 1+$ T84)) = IF( OR( S84'="", S84'=" NA"),"", S84*( 1+$ T84)) = IF( OR( R85'="", R85'=" NA"),"", R85*( 1+$ T85)) = IF( OR( S85'="", S85'=" NA"),"", S85*( 1+$ T85)) = IF( OR( R86'="", R86'=" NA"),"", R86*( 1+$ T86)) = IF( OR( S86'="", S86'=" NA"),"", S86*( 1+$ T86)) = IF( OR( R87'="", R87'=" NA"),"", R87*( 1+$ T87)) = IF( OR( S87'="", S87'=" NA"),"", S87*( 1+$ T87)) = IF( OR( R88'="", R88'=" NA"),"", R88*( 1+$ T88)) = IF( OR( S88'="", S88'=" NA"),"", S88*( 1+$ T88)) = IF( OR( R89'="", R89'=" NA"),"", R89*( 1+$ T89)) = IF( OR( S89'="", S89'=" NA"),"", S89*( 1+$ T89)) = IF( OR( R90'="", R90'=" NA"),"", R90*( 1+$ T90)) = IF( OR( S90'="", S90'=" NA"),"", S90*( 1+$ T90)) = IF( OR( R91'="", R91'=" NA"),"", R91*( 1+$ T91)) = IF( OR( S91'="", S91'=" NA"),"", S91*( 1+$ T91)) = IF( OR( R92'="", R92'=" NA"),"", R92*( 1+$ T92)) = IF( OR( S92'="", S92'=" NA"),"", S92*( 1+$ T92)) = IF( OR( R93'="", R93'=" NA"),"", R93*( 1+$ T93)) = IF( OR( S93'="", S93'=" NA"),"", S93*( 1+$ T93)) = IF( OR( R94'="", R94'=" NA"),"", R94*( 1+$ T94)) = IF( OR( S94'="", S94'=" NA"),"", S94*( 1+$ T94)) = IF( OR( R95'="", R95'=" NA"),"", R95*( 1+$ T95)) = IF( OR( S95'="", S95'=" NA"),"", S95*( 1+$ T95)) = IF( OR( R96'="", R96'=" NA"),"", R96*( 1+$ T96)) = IF( OR( S96'="", S96'=" NA"),"", S96*( 1+$ T96)) = IF( OR( R97'="", R97'=" NA"),"", R97*( 1+$ T97)) = IF( OR( S97'="", S97'=" NA"),"", S97*( 1+$ T97)) = IF( OR( R98'="", R98'=" NA"),"", R98*( 1+$ T98)) = IF( OR( S98'="", S98'=" NA"),"", S98*( 1+$ T98)) = IF( OR( R99'="", R99'=" NA"),"", R99*( 1+$ T99)) = IF( OR( S99'="", S99'=" NA"),"", S99*( 1+$ T99)) = IF( OR( R100'="", R100'=" NA"),"", R100*( 1+$ T100)) = IF( OR( S100'="", S100'=" NA"),"", S100*( 1+$ T100)) = IF( OR( R101'="", R101'=" NA"),"", R101*( 1+$ T101)) = IF( OR( S101'="", S101'=" NA"),"", S101*( 1+$ T101)) = IF( OR( R102'="", R102'=" NA"),"", R102*( 1+$ T102)) = IF( OR( S102'="", S102'=" NA"),"", S102*( 1+$ T102)) = IF( OR( R103'="", R103'=" NA"),"", R103*( 1+$ T103)) = IF( OR( S103'="", S103'=" NA"),"", S103*( 1+$ T103)) = IF( OR( R104'="", R104'=" NA"),"", R104*( 1+$ T104)) = IF( OR( S104'="", S104'=" NA"),"", S104*( 1+$ T104)) = IF( OR( R105'="", R105'=" NA"),"", R105*( 1+$ T105)) = IF( OR( S105'="", S105'=" NA"),"", S105*( 1+$ T105)) = IF( OR( R106'="", R106'=" NA"),"", R106*( 1+$ T106)) = IF( OR( S106'="", S106'=" NA"),"", S106*( 1+$ T106)) = IF( OR( R107'="", R107'=" NA"),"", R107*( 1+$ T107)) = IF( OR( S107'="", S107'=" NA"),"", S107*( 1+$ T107)) = IF( OR( R108'="", R108'=" NA"),"", R108*( 1+$ T108)) = IF( OR( S108'="", S108'=" NA"),"", S108*( 1+$ T108)) = IF( OR( R109'="", R109'=" NA"),"", R109*( 1+$ T109)) = IF( OR( S109'="", S109'=" NA"),"", S109*( 1+$ T109)) = IF( OR( R110'="", R110'=" NA"),"", R110*( 1+$ T110)) = IF( OR( S110'="", S110'=" NA"),"", S110*( 1+$ T110)) = IF( OR( R111'="", R111'=" NA"),"", R111*( 1+$ T111)) = IF( OR( S111'="", S111'=" NA"),"", S111*( 1+$ T111)) = IF( OR( R112'="", R112'=" NA"),"", R112*( 1+$ T112)) = IF( OR( S112'="", S112'=" NA"),"", S112*( 1+$ T112)) = IF( OR( R113'="", R113'=" NA"),"", R113*( 1+$ T113)) = IF( OR( S113'="", S113'=" NA"),"", S113*( 1+$ T113)) = IF( OR( R114'="", R114'=" NA"),"", R114*( 1+$ T114)) = IF( OR( S114'="", S114'=" NA"),"", S114*( 1+$ T114)) = IF( OR( R115'="", R115'=" NA"),"", R115*( 1+$ T115)) = IF( OR( S115'="", S115'=" NA"),"", S115*( 1+$ T115)) = IF( OR( R116'="", R116'=" NA"),"", R116*( 1+$ T116)) = IF( OR( S116'="", S116'=" NA"),"", S116*( 1+$ T116))

February 14, 2003 66 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central AL AM Permitting Hrs/ MP& M Site Implement Oulier'= 0 = IF( OR( N60'="",$ M60'="",$ M60'= 0),"", N60/$ M60) = IF( AL60'="","", IF( AL60> AL$ 121* 2,0,1)) = IF( OR( N61'="",$ M61'="",$ M61'= 0),"", N61/$ M61) = IF( AL61'="","", IF( AL61> AL$ 121* 2,0,1)) = IF( OR( N62'="",$ M62'="",$ M62'= 0),"", N62/$ M62) = IF( AL62'="","", IF( AL62> AL$ 121* 2,0,1)) = IF( OR( N63'="",$ M63'="",$ M63'= 0),"", N63/$ M63) = IF( AL63'="","", IF( AL63> AL$ 121* 2,0,1)) = IF( OR( N64'="",$ M64'="",$ M64'= 0),"", N64/$ M64) = IF( AL64'="","", IF( AL64> AL$ 121* 2,0,1)) = IF( OR( N65'="",$ M65'="",$ M65'= 0),"", N65/$ M65) = IF( AL65'="","", IF( AL65> AL$ 121* 2,0,1)) = IF( OR( N66'="",$ M66'="",$ M66'= 0),"", N66/$ M66) = IF( AL66'="","", IF( AL66> AL$ 121* 2,0,1)) = IF( OR( N67'="",$ M67'="",$ M67'= 0),"", N67/$ M67) = IF( AL67'="","", IF( AL67> AL$ 121* 2,0,1)) = IF( OR( N68'="",$ M68'="",$ M68'= 0),"", N68/$ M68) = IF( AL68'="","", IF( AL68> AL$ 121* 2,0,1)) = IF( OR( N69'="",$ M69'="",$ M69'= 0),"", N69/$ M69) = IF( AL69'="","", IF( AL69> AL$ 121* 2,0,1)) = IF( OR( N70'="",$ M70'="",$ M70'= 0),"", N70/$ M70) = IF( AL70'="","", IF( AL70> AL$ 121* 2,0,1)) = IF( OR( N71'="",$ M71'="",$ M71'= 0),"", N71/$ M71) = IF( AL71'="","", IF( AL71> AL$ 121* 2,0,1)) = IF( OR( N72'="",$ M72'="",$ M72'= 0),"", N72/$ M72) = IF( AL72'="","", IF( AL72> AL$ 121* 2,0,1)) = IF( OR( N73'="",$ M73'="",$ M73'= 0),"", N73/$ M73) = IF( AL73'="","", IF( AL73> AL$ 121* 2,0,1)) = IF( OR( N74'="",$ M74'="",$ M74'= 0),"", N74/$ M74) = IF( AL74'="","", IF( AL74> AL$ 121* 2,0,1)) = IF( OR( N75'="",$ M75'="",$ M75'= 0),"", N75/$ M75) = IF( AL75'="","", IF( AL75> AL$ 121* 2,0,1)) = IF( OR( N76'="",$ M76'="",$ M76'= 0),"", N76/$ M76) = IF( AL76'="","", IF( AL76> AL$ 121* 2,0,1)) = IF( OR( N77'="",$ M77'="",$ M77'= 0),"", N77/$ M77) = IF( AL77'="","", IF( AL77> AL$ 121* 2,0,1)) = IF( OR( N78'="",$ M78'="",$ M78'= 0),"", N78/$ M78) = IF( AL78'="","", IF( AL78> AL$ 121* 2,0,1)) = IF( OR( N79'="",$ M79'="",$ M79'= 0),"", N79/$ M79) = IF( AL79'="","", IF( AL79> AL$ 121* 2,0,1)) = IF( OR( N80'="",$ M80'="",$ M80'= 0),"", N80/$ M80) = IF( AL80'="","", IF( AL80> AL$ 121* 2,0,1)) = IF( OR( N81'="",$ M81'="",$ M81'= 0),"", N81/$ M81) = IF( AL81'="","", IF( AL81> AL$ 121* 2,0,1)) = IF( OR( N82'="",$ M82'="",$ M82'= 0),"", N82/$ M82) = IF( AL82'="","", IF( AL82> AL$ 121* 2,0,1)) = IF( OR( N83'="",$ M83'="",$ M83'= 0),"", N83/$ M83) = IF( AL83'="","", IF( AL83> AL$ 121* 2,0,1)) = IF( OR( N84'="",$ M84'="",$ M84'= 0),"", N84/$ M84) = IF( AL84'="","", IF( AL84> AL$ 121* 2,0,1)) = IF( OR( N85'="",$ M85'="",$ M85'= 0),"", N85/$ M85) = IF( AL85'="","", IF( AL85> AL$ 121* 2,0,1)) = IF( OR( N86'="",$ M86'="",$ M86'= 0),"", N86/$ M86) = IF( AL86'="","", IF( AL86> AL$ 121* 2,0,1)) = IF( OR( N87'="",$ M87'="",$ M87'= 0),"", N87/$ M87) = IF( AL87'="","", IF( AL87> AL$ 121* 2,0,1)) = IF( OR( N88'="",$ M88'="",$ M88'= 0),"", N88/$ M88) = IF( AL88'="","", IF( AL88> AL$ 121* 2,0,1)) = IF( OR( N89'="",$ M89'="",$ M89'= 0),"", N89/$ M89) = IF( AL89'="","", IF( AL89> AL$ 121* 2,0,1)) = IF( OR( N90'="",$ M90'="",$ M90'= 0),"", N90/$ M90) = IF( AL90'="","", IF( AL90> AL$ 121* 2,0,1)) = IF( OR( N91'="",$ M91'="",$ M91'= 0),"", N91/$ M91) = IF( AL91'="","", IF( AL91> AL$ 121* 2,0,1)) = IF( OR( N92'="",$ M92'="",$ M92'= 0),"", N92/$ M92) = IF( AL92'="","", IF( AL92> AL$ 121* 2,0,1)) = IF( OR( N93'="",$ M93'="",$ M93'= 0),"", N93/$ M93) = IF( AL93'="","", IF( AL93> AL$ 121* 2,0,1)) = IF( OR( N94'="",$ M94'="",$ M94'= 0),"", N94/$ M94) = IF( AL94'="","", IF( AL94> AL$ 121* 2,0,1)) = IF( OR( N95'="",$ M95'="",$ M95'= 0),"", N95/$ M95) = IF( AL95'="","", IF( AL95> AL$ 121* 2,0,1)) = IF( OR( N96'="",$ M96'="",$ M96'= 0),"", N96/$ M96) = IF( AL96'="","", IF( AL96> AL$ 121* 2,0,1)) = IF( OR( N97'="",$ M97'="",$ M97'= 0),"", N97/$ M97) = IF( AL97'="","", IF( AL97> AL$ 121* 2,0,1)) = IF( OR( N98'="",$ M98'="",$ M98'= 0),"", N98/$ M98) = IF( AL98'="","", IF( AL98> AL$ 121* 2,0,1)) = IF( OR( N99'="",$ M99'="",$ M99'= 0),"", N99/$ M99) = IF( AL99'="","", IF( AL99> AL$ 121* 2,0,1)) = IF( OR( N100'="",$ M100'="",$ M100'= 0),"", N100/$ M100) = IF( AL100'="","", IF( AL100> AL$ 121* 2,0,1)) = IF( OR( N101'="",$ M101'="",$ M101'= 0),"", N101/$ M101) = IF( AL101'="","", IF( AL101> AL$ 121* 2,0,1)) = IF( OR( N102'="",$ M102'="",$ M102'= 0),"", N102/$ M102) = IF( AL102'="","", IF( AL102> AL$ 121* 2,0,1)) = IF( OR( N103'="",$ M103'="",$ M103'= 0),"", N103/$ M103) = IF( AL103'="","", IF( AL103> AL$ 121* 2,0,1)) = IF( OR( N104'="",$ M104'="",$ M104'= 0),"", N104/$ M104) = IF( AL104'="","", IF( AL104> AL$ 121* 2,0,1)) = IF( OR( N105'="",$ M105'="",$ M105'= 0),"", N105/$ M105) = IF( AL105'="","", IF( AL105> AL$ 121* 2,0,1)) = IF( OR( N106'="",$ M106'="",$ M106'= 0),"", N106/$ M106) = IF( AL106'="","", IF( AL106> AL$ 121* 2,0,1)) = IF( OR( N107'="",$ M107'="",$ M107'= 0),"", N107/$ M107) = IF( AL107'="","", IF( AL107> AL$ 121* 2,0,1)) = IF( OR( N108'="",$ M108'="",$ M108'= 0),"", N108/$ M108) = IF( AL108'="","", IF( AL108> AL$ 121* 2,0,1)) = IF( OR( N109'="",$ M109'="",$ M109'= 0),"", N109/$ M109) = IF( AL109'="","", IF( AL109> AL$ 121* 2,0,1)) = IF( OR( N110'="",$ M110'="",$ M110'= 0),"", N110/$ M110) = IF( AL110'="","", IF( AL110> AL$ 121* 2,0,1)) = IF( OR( N111'="",$ M111'="",$ M111'= 0),"", N111/$ M111) = IF( AL111'="","", IF( AL111> AL$ 121* 2,0,1)) = IF( OR( N112'="",$ M112'="",$ M112'= 0),"", N112/$ M112) = IF( AL112'="","", IF( AL112> AL$ 121* 2,0,1)) = IF( OR( N113'="",$ M113'="",$ M113'= 0),"", N113/$ M113) = IF( AL113'="","", IF( AL113> AL$ 121* 2,0,1)) = IF( OR( N114'="",$ M114'="",$ M114'= 0),"", N114/$ M114) = IF( AL114'="","", IF( AL114> AL$ 121* 2,0,1)) = IF( OR( N115'="",$ M115'="",$ M115'= 0),"", N115/$ M115) = IF( AL115'="","", IF( AL115> AL$ 121* 2,0,1)) = IF( OR( N116'="",$ M116'="",$ M116'= 0),"", N116/$ M116) = IF( AL116'="","", IF( AL116> AL$ 121* 2,0,1))

February 14, 2003 67 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central AN AO Permitting Hrs/ MP& M Site Yearly Oulier'= 0 = IF( OR( O60'="",$ M60'="",$ M60'= 0),"", O60/$ M60) = IF( AN60'="","", IF( AN60> AN$ 121* 2,0,1)) = IF( OR( O61'="",$ M61'="",$ M61'= 0),"", O61/$ M61) = IF( AN61'="","", IF( AN61> AN$ 121* 2,0,1)) = IF( OR( O62'="",$ M62'="",$ M62'= 0),"", O62/$ M62) = IF( AN62'="","", IF( AN62> AN$ 121* 2,0,1)) = IF( OR( O63'="",$ M63'="",$ M63'= 0),"", O63/$ M63) = IF( AN63'="","", IF( AN63> AN$ 121* 2,0,1)) = IF( OR( O64'="",$ M64'="",$ M64'= 0),"", O64/$ M64) = IF( AN64'="","", IF( AN64> AN$ 121* 2,0,1)) = IF( OR( O65'="",$ M65'="",$ M65'= 0),"", O65/$ M65) = IF( AN65'="","", IF( AN65> AN$ 121* 2,0,1)) = IF( OR( O66'="",$ M66'="",$ M66'= 0),"", O66/$ M66) = IF( AN66'="","", IF( AN66> AN$ 121* 2,0,1)) = IF( OR( O67'="",$ M67'="",$ M67'= 0),"", O67/$ M67) = IF( AN67'="","", IF( AN67> AN$ 121* 2,0,1)) = IF( OR( O68'="",$ M68'="",$ M68'= 0),"", O68/$ M68) = IF( AN68'="","", IF( AN68> AN$ 121* 2,0,1)) = IF( OR( O69'="",$ M69'="",$ M69'= 0),"", O69/$ M69) = IF( AN69'="","", IF( AN69> AN$ 121* 2,0,1)) = IF( OR( O70'="",$ M70'="",$ M70'= 0),"", O70/$ M70) = IF( AN70'="","", IF( AN70> AN$ 121* 2,0,1)) = IF( OR( O71'="",$ M71'="",$ M71'= 0),"", O71/$ M71) = IF( AN71'="","", IF( AN71> AN$ 121* 2,0,1)) = IF( OR( O72'="",$ M72'="",$ M72'= 0),"", O72/$ M72) = IF( AN72'="","", IF( AN72> AN$ 121* 2,0,1)) = IF( OR( O73'="",$ M73'="",$ M73'= 0),"", O73/$ M73) = IF( AN73'="","", IF( AN73> AN$ 121* 2,0,1)) = IF( OR( O74'="",$ M74'="",$ M74'= 0),"", O74/$ M74) = IF( AN74'="","", IF( AN74> AN$ 121* 2,0,1)) = IF( OR( O75'="",$ M75'="",$ M75'= 0),"", O75/$ M75) = IF( AN75'="","", IF( AN75> AN$ 121* 2,0,1)) = IF( OR( O76'="",$ M76'="",$ M76'= 0),"", O76/$ M76) = IF( AN76'="","", IF( AN76> AN$ 121* 2,0,1)) = IF( OR( O77'="",$ M77'="",$ M77'= 0),"", O77/$ M77) = IF( AN77'="","", IF( AN77> AN$ 121* 2,0,1)) = IF( OR( O78'="",$ M78'="",$ M78'= 0),"", O78/$ M78) = IF( AN78'="","", IF( AN78> AN$ 121* 2,0,1)) = IF( OR( O79'="",$ M79'="",$ M79'= 0),"", O79/$ M79) = IF( AN79'="","", IF( AN79> AN$ 121* 2,0,1)) = IF( OR( O80'="",$ M80'="",$ M80'= 0),"", O80/$ M80) = IF( AN80'="","", IF( AN80> AN$ 121* 2,0,1)) = IF( OR( O81'="",$ M81'="",$ M81'= 0),"", O81/$ M81) = IF( AN81'="","", IF( AN81> AN$ 121* 2,0,1)) = IF( OR( O82'="",$ M82'="",$ M82'= 0),"", O82/$ M82) = IF( AN82'="","", IF( AN82> AN$ 121* 2,0,1)) = IF( OR( O83'="",$ M83'="",$ M83'= 0),"", O83/$ M83) = IF( AN83'="","", IF( AN83> AN$ 121* 2,0,1)) = IF( OR( O84'="",$ M84'="",$ M84'= 0),"", O84/$ M84) = IF( AN84'="","", IF( AN84> AN$ 121* 2,0,1)) = IF( OR( O85'="",$ M85'="",$ M85'= 0),"", O85/$ M85) = IF( AN85'="","", IF( AN85> AN$ 121* 2,0,1)) = IF( OR( O86'="",$ M86'="",$ M86'= 0),"", O86/$ M86) = IF( AN86'="","", IF( AN86> AN$ 121* 2,0,1)) = IF( OR( O87'="",$ M87'="",$ M87'= 0),"", O87/$ M87) = IF( AN87'="","", IF( AN87> AN$ 121* 2,0,1)) = IF( OR( O88'="",$ M88'="",$ M88'= 0),"", O88/$ M88) = IF( AN88'="","", IF( AN88> AN$ 121* 2,0,1)) = IF( OR( O89'="",$ M89'="",$ M89'= 0),"", O89/$ M89) = IF( AN89'="","", IF( AN89> AN$ 121* 2,0,1)) = IF( OR( O90'="",$ M90'="",$ M90'= 0),"", O90/$ M90) = IF( AN90'="","", IF( AN90> AN$ 121* 2,0,1)) = IF( OR( O91'="",$ M91'="",$ M91'= 0),"", O91/$ M91) = IF( AN91'="","", IF( AN91> AN$ 121* 2,0,1)) = IF( OR( O92'="",$ M92'="",$ M92'= 0),"", O92/$ M92) = IF( AN92'="","", IF( AN92> AN$ 121* 2,0,1)) = IF( OR( O93'="",$ M93'="",$ M93'= 0),"", O93/$ M93) = IF( AN93'="","", IF( AN93> AN$ 121* 2,0,1)) = IF( OR( O94'="",$ M94'="",$ M94'= 0),"", O94/$ M94) = IF( AN94'="","", IF( AN94> AN$ 121* 2,0,1)) = IF( OR( O95'="",$ M95'="",$ M95'= 0),"", O95/$ M95) = IF( AN95'="","", IF( AN95> AN$ 121* 2,0,1)) = IF( OR( O96'="",$ M96'="",$ M96'= 0),"", O96/$ M96) = IF( AN96'="","", IF( AN96> AN$ 121* 2,0,1)) = IF( OR( O97'="",$ M97'="",$ M97'= 0),"", O97/$ M97) = IF( AN97'="","", IF( AN97> AN$ 121* 2,0,1)) = IF( OR( O98'="",$ M98'="",$ M98'= 0),"", O98/$ M98) = IF( AN98'="","", IF( AN98> AN$ 121* 2,0,1)) = IF( OR( O99'="",$ M99'="",$ M99'= 0),"", O99/$ M99) = IF( AN99'="","", IF( AN99> AN$ 121* 2,0,1)) = IF( OR( O100'="",$ M100'="",$ M100'= 0),"", O100/$ M100) = IF( AN100'="","", IF( AN100> AN$ 121* 2,0,1)) = IF( OR( O101'="",$ M101'="",$ M101'= 0),"", O101/$ M101) = IF( AN101'="","", IF( AN101> AN$ 121* 2,0,1)) = IF( OR( O102'="",$ M102'="",$ M102'= 0),"", O102/$ M102) = IF( AN102'="","", IF( AN102> AN$ 121* 2,0,1)) = IF( OR( O103'="",$ M103'="",$ M103'= 0),"", O103/$ M103) = IF( AN103'="","", IF( AN103> AN$ 121* 2,0,1)) = IF( OR( O104'="",$ M104'="",$ M104'= 0),"", O104/$ M104) = IF( AN104'="","", IF( AN104> AN$ 121* 2,0,1)) = IF( OR( O105'="",$ M105'="",$ M105'= 0),"", O105/$ M105) = IF( AN105'="","", IF( AN105> AN$ 121* 2,0,1)) = IF( OR( O106'="",$ M106'="",$ M106'= 0),"", O106/$ M106) = IF( AN106'="","", IF( AN106> AN$ 121* 2,0,1)) = IF( OR( O107'="",$ M107'="",$ M107'= 0),"", O107/$ M107) = IF( AN107'="","", IF( AN107> AN$ 121* 2,0,1)) = IF( OR( O108'="",$ M108'="",$ M108'= 0),"", O108/$ M108) = IF( AN108'="","", IF( AN108> AN$ 121* 2,0,1)) = IF( OR( O109'="",$ M109'="",$ M109'= 0),"", O109/$ M109) = IF( AN109'="","", IF( AN109> AN$ 121* 2,0,1)) = IF( OR( O110'="",$ M110'="",$ M110'= 0),"", O110/$ M110) = IF( AN110'="","", IF( AN110> AN$ 121* 2,0,1)) = IF( OR( O111'="",$ M111'="",$ M111'= 0),"", O111/$ M111) = IF( AN111'="","", IF( AN111> AN$ 121* 2,0,1)) = IF( OR( O112'="",$ M112'="",$ M112'= 0),"", O112/$ M112) = IF( AN112'="","", IF( AN112> AN$ 121* 2,0,1)) = IF( OR( O113'="",$ M113'="",$ M113'= 0),"", O113/$ M113) = IF( AN113'="","", IF( AN113> AN$ 121* 2,0,1)) = IF( OR( O114'="",$ M114'="",$ M114'= 0),"", O114/$ M114) = IF( AN114'="","", IF( AN114> AN$ 121* 2,0,1)) = IF( OR( O115'="",$ M115'="",$ M115'= 0),"", O115/$ M115) = IF( AN115'="","", IF( AN115> AN$ 121* 2,0,1)) = IF( OR( O116'="",$ M116'="",$ M116'= 0),"", O116/$ M116) = IF( AN116'="","", IF( AN116> AN$ 121* 2,0,1))

February 14, 2003 68 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central AP AQ Implement Oulier'= 0 = IF( OR( Y60'="", Y60'=" NA",$ M60'="",$ M60'= 0),"", Y60/$ M60) = IF( AP60'="","", IF( AP60> AP$ 121* 2,0, IF( AP60> AL60,0,1))) = IF( OR( Y61'="", Y61'=" NA",$ M61'="",$ M61'= 0),"", Y61/$ M61) = IF( AP61'="","", IF( AP61> AP$ 121* 2,0, IF( AP61> AL61,0,1))) = IF( OR( Y62'="", Y62'=" NA",$ M62'="",$ M62'= 0),"", Y62/$ M62) = IF( AP62'="","", IF( AP62> AP$ 121* 2,0, IF( AP62> AL62,0,1))) = IF( OR( Y63'="", Y63'=" NA",$ M63'="",$ M63'= 0),"", Y63/$ M63) = IF( AP63'="","", IF( AP63> AP$ 121* 2,0, IF( AP63> AL63,0,1))) = IF( OR( Y64'="", Y64'=" NA",$ M64'="",$ M64'= 0),"", Y64/$ M64) = IF( AP64'="","", IF( AP64> AP$ 121* 2,0, IF( AP64> AL64,0,1))) = IF( OR( Y65'="", Y65'=" NA",$ M65'="",$ M65'= 0),"", Y65/$ M65) = IF( AP65'="","", IF( AP65> AP$ 121* 2,0, IF( AP65> AL65,0,1))) = IF( OR( Y66'="", Y66'=" NA",$ M66'="",$ M66'= 0),"", Y66/$ M66) = IF( AP66'="","", IF( AP66> AP$ 121* 2,0, IF( AP66> AL66,0,1))) = IF( OR( Y67'="", Y67'=" NA",$ M67'="",$ M67'= 0),"", Y67/$ M67) = IF( AP67'="","", IF( AP67> AP$ 121* 2,0, IF( AP67> AL67,0,1))) = IF( OR( Y68'="", Y68'=" NA",$ M68'="",$ M68'= 0),"", Y68/$ M68) = IF( AP68'="","", IF( AP68> AP$ 121* 2,0, IF( AP68> AL68,0,1))) = IF( OR( Y69'="", Y69'=" NA",$ M69'="",$ M69'= 0),"", Y69/$ M69) = IF( AP69'="","", IF( AP69> AP$ 121* 2,0, IF( AP69> AL69,0,1))) = IF( OR( Y70'="", Y70'=" NA",$ M70'="",$ M70'= 0),"", Y70/$ M70) = IF( AP70'="","", IF( AP70> AP$ 121* 2,0, IF( AP70> AL70,0,1))) = IF( OR( Y71'="", Y71'=" NA",$ M71'="",$ M71'= 0),"", Y71/$ M71) = IF( AP71'="","", IF( AP71> AP$ 121* 2,0, IF( AP71> AL71,0,1))) = IF( OR( Y72'="", Y72'=" NA",$ M72'="",$ M72'= 0),"", Y72/$ M72) = IF( AP72'="","", IF( AP72> AP$ 121* 2,0, IF( AP72> AL72,0,1))) = IF( OR( Y73'="", Y73'=" NA",$ M73'="",$ M73'= 0),"", Y73/$ M73) = IF( AP73'="","", IF( AP73> AP$ 121* 2,0, IF( AP73> AL73,0,1))) = IF( OR( Y74'="", Y74'=" NA",$ M74'="",$ M74'= 0),"", Y74/$ M74) = IF( AP74'="","", IF( AP74> AP$ 121* 2,0, IF( AP74> AL74,0,1))) = IF( OR( Y75'="", Y75'=" NA",$ M75'="",$ M75'= 0),"", Y75/$ M75) = IF( AP75'="","", IF( AP75> AP$ 121* 2,0, IF( AP75> AL75,0,1))) = IF( OR( Y76'="", Y76'=" NA",$ M76'="",$ M76'= 0),"", Y76/$ M76) = IF( AP76'="","", IF( AP76> AP$ 121* 2,0, IF( AP76> AL76,0,1))) = IF( OR( Y77'="", Y77'=" NA",$ M77'="",$ M77'= 0),"", Y77/$ M77) = IF( AP77'="","", IF( AP77> AP$ 121* 2,0, IF( AP77> AL77,0,1))) = IF( OR( Y78'="", Y78'=" NA",$ M78'="",$ M78'= 0),"", Y78/$ M78) = IF( AP78'="","", IF( AP78> AP$ 121* 2,0, IF( AP78> AL78,0,1))) = IF( OR( Y79'="", Y79'=" NA",$ M79'="",$ M79'= 0),"", Y79/$ M79) = IF( AP79'="","", IF( AP79> AP$ 121* 2,0, IF( AP79> AL79,0,1))) = IF( OR( Y80'="", Y80'=" NA",$ M80'="",$ M80'= 0),"", Y80/$ M80) = IF( AP80'="","", IF( AP80> AP$ 121* 2,0, IF( AP80> AL80,0,1))) = IF( OR( Y81'="", Y81'=" NA",$ M81'="",$ M81'= 0),"", Y81/$ M81) = IF( AP81'="","", IF( AP81> AP$ 121* 2,0, IF( AP81> AL81,0,1))) = IF( OR( Y82'="", Y82'=" NA",$ M82'="",$ M82'= 0),"", Y82/$ M82) = IF( AP82'="","", IF( AP82> AP$ 121* 2,0, IF( AP82> AL82,0,1))) = IF( OR( Y83'="", Y83'=" NA",$ M83'="",$ M83'= 0),"", Y83/$ M83) = IF( AP83'="","", IF( AP83> AP$ 121* 2,0, IF( AP83> AL83,0,1))) = IF( OR( Y84'="", Y84'=" NA",$ M84'="",$ M84'= 0),"", Y84/$ M84) = IF( AP84'="","", IF( AP84> AP$ 121* 2,0, IF( AP84> AL84,0,1))) = IF( OR( Y85'="", Y85'=" NA",$ M85'="",$ M85'= 0),"", Y85/$ M85) = IF( AP85'="","", IF( AP85> AP$ 121* 2,0, IF( AP85> AL85,0,1))) = IF( OR( Y86'="", Y86'=" NA",$ M86'="",$ M86'= 0),"", Y86/$ M86) = IF( AP86'="","", IF( AP86> AP$ 121* 2,0, IF( AP86> AL86,0,1))) = IF( OR( Y87'="", Y87'=" NA",$ M87'="",$ M87'= 0),"", Y87/$ M87) = IF( AP87'="","", IF( AP87> AP$ 121* 2,0, IF( AP87> AL87,0,1))) = IF( OR( Y88'="", Y88'=" NA",$ M88'="",$ M88'= 0),"", Y88/$ M88) = IF( AP88'="","", IF( AP88> AP$ 121* 2,0, IF( AP88> AL88,0,1))) = IF( OR( Y89'="", Y89'=" NA",$ M89'="",$ M89'= 0),"", Y89/$ M89) = IF( AP89'="","", IF( AP89> AP$ 121* 2,0, IF( AP89> AL89,0,1))) = IF( OR( Y90'="", Y90'=" NA",$ M90'="",$ M90'= 0),"", Y90/$ M90) = IF( AP90'="","", IF( AP90> AP$ 121* 2,0, IF( AP90> AL90,0,1))) = IF( OR( Y91'="", Y91'=" NA",$ M91'="",$ M91'= 0),"", Y91/$ M91) = IF( AP91'="","", IF( AP91> AP$ 121* 2,0, IF( AP91> AL91,0,1))) = IF( OR( Y92'="", Y92'=" NA",$ M92'="",$ M92'= 0),"", Y92/$ M92) = IF( AP92'="","", IF( AP92> AP$ 121* 2,0, IF( AP92> AL92,0,1))) = IF( OR( Y93'="", Y93'=" NA",$ M93'="",$ M93'= 0),"", Y93/$ M93) = IF( AP93'="","", IF( AP93> AP$ 121* 2,0, IF( AP93> AL93,0,1))) = IF( OR( Y94'="", Y94'=" NA",$ M94'="",$ M94'= 0),"", Y94/$ M94) = IF( AP94'="","", IF( AP94> AP$ 121* 2,0, IF( AP94> AL94,0,1))) = IF( OR( Y95'="", Y95'=" NA",$ M95'="",$ M95'= 0),"", Y95/$ M95) = IF( AP95'="","", IF( AP95> AP$ 121* 2,0, IF( AP95> AL95,0,1))) = IF( OR( Y96'="", Y96'=" NA",$ M96'="",$ M96'= 0),"", Y96/$ M96) = IF( AP96'="","", IF( AP96> AP$ 121* 2,0, IF( AP96> AL96,0,1))) = IF( OR( Y97'="", Y97'=" NA",$ M97'="",$ M97'= 0),"", Y97/$ M97) = IF( AP97'="","", IF( AP97> AP$ 121* 2,0, IF( AP97> AL97,0,1))) = IF( OR( Y98'="", Y98'=" NA",$ M98'="",$ M98'= 0),"", Y98/$ M98) = IF( AP98'="","", IF( AP98> AP$ 121* 2,0, IF( AP98> AL98,0,1))) = IF( OR( Y99'="", Y99'=" NA",$ M99'="",$ M99'= 0),"", Y99/$ M99) = IF( AP99'="","", IF( AP99> AP$ 121* 2,0, IF( AP99> AL99,0,1))) = IF( OR( Y100'="", Y100'=" NA",$ M100'="",$ M100'= 0),"", Y100/$ M100) = IF( AP100'="","", IF( AP100> AP$ 121* 2,0, IF( AP100> AL100,0,1))) = IF( OR( Y101'="", Y101'=" NA",$ M101'="",$ M101'= 0),"", Y101/$ M101) = IF( AP101'="","", IF( AP101> AP$ 121* 2,0, IF( AP101> AL101,0,1))) = IF( OR( Y102'="", Y102'=" NA",$ M102'="",$ M102'= 0),"", Y102/$ M102) = IF( AP102'="","", IF( AP102> AP$ 121* 2,0, IF( AP102> AL102,0,1))) = IF( OR( Y103'="", Y103'=" NA",$ M103'="",$ M103'= 0),"", Y103/$ M103) = IF( AP103'="","", IF( AP103> AP$ 121* 2,0, IF( AP103> AL103,0,1))) = IF( OR( Y104'="", Y104'=" NA",$ M104'="",$ M104'= 0),"", Y104/$ M104) = IF( AP104'="","", IF( AP104> AP$ 121* 2,0, IF( AP104> AL104,0,1))) = IF( OR( Y105'="", Y105'=" NA",$ M105'="",$ M105'= 0),"", Y105/$ M105) = IF( AP105'="","", IF( AP105> AP$ 121* 2,0, IF( AP105> AL105,0,1))) = IF( OR( Y106'="", Y106'=" NA",$ M106'="",$ M106'= 0),"", Y106/$ M106) = IF( AP106'="","", IF( AP106> AP$ 121* 2,0, IF( AP106> AL106,0,1))) = IF( OR( Y107'="", Y107'=" NA",$ M107'="",$ M107'= 0),"", Y107/$ M107) = IF( AP107'="","", IF( AP107> AP$ 121* 2,0, IF( AP107> AL107,0,1))) = IF( OR( Y108'="", Y108'=" NA",$ M108'="",$ M108'= 0),"", Y108/$ M108) = IF( AP108'="","", IF( AP108> AP$ 121* 2,0, IF( AP108> AL108,0,1))) = IF( OR( Y109'="", Y109'=" NA",$ M109'="",$ M109'= 0),"", Y109/$ M109) = IF( AP109'="","", IF( AP109> AP$ 121* 2,0, IF( AP109> AL109,0,1))) = IF( OR( Y110'="", Y110'=" NA",$ M110'="",$ M110'= 0),"", Y110/$ M110) = IF( AP110'="","", IF( AP110> AP$ 121* 2,0, IF( AP110> AL110,0,1))) = IF( OR( Y111'="", Y111'=" NA",$ M111'="",$ M111'= 0),"", Y111/$ M111) = IF( AP111'="","", IF( AP111> AP$ 121* 2,0, IF( AP111> AL111,0,1))) = IF( OR( Y112'="", Y112'=" NA",$ M112'="",$ M112'= 0),"", Y112/$ M112) = IF( AP112'="","", IF( AP112> AP$ 121* 2,0, IF( AP112> AL112,0,1))) = IF( OR( Y113'="", Y113'=" NA",$ M113'="",$ M113'= 0),"", Y113/$ M113) = IF( AP113'="","", IF( AP113> AP$ 121* 2,0, IF( AP113> AL113,0,1))) = IF( OR( Y114'="", Y114'=" NA",$ M114'="",$ M114'= 0),"", Y114/$ M114) = IF( AP114'="","", IF( AP114> AP$ 121* 2,0, IF( AP114> AL114,0,1))) = IF( OR( Y115'="", Y115'=" NA",$ M115'="",$ M115'= 0),"", Y115/$ M115) = IF( AP115'="","", IF( AP115> AP$ 121* 2,0, IF( AP115> AL115,0,1))) = IF( OR( Y116'="", Y116'=" NA",$ M116'="",$ M116'= 0),"", Y116/$ M116) = IF( AP116'="","", IF( AP116> AP$ 121* 2,0, IF( AP116> AL116,0,1)))

February 14, 2003 69 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central AR AS Oversight Hrs/ MP& M Site Cost Yearly = IF( AQ60'="","", AQ60* AP60*$ AK60) = IF( OR( Z60'="", Z60'=" NA",$ M60'="",$ M60'= 0),"", Z60/$ M60) = IF( AQ61'="","", AQ61* AP61*$ AK61) = IF( OR( Z61'="", Z61'=" NA",$ M61'="",$ M61'= 0),"", Z61/$ M61) = IF( AQ62'="","", AQ62* AP62*$ AK62) = IF( OR( Z62'="", Z62'=" NA",$ M62'="",$ M62'= 0),"", Z62/$ M62) = IF( AQ63'="","", AQ63* AP63*$ AK63) = IF( OR( Z63'="", Z63'=" NA",$ M63'="",$ M63'= 0),"", Z63/$ M63) = IF( AQ64'="","", AQ64* AP64*$ AK64) = IF( OR( Z64'="", Z64'=" NA",$ M64'="",$ M64'= 0),"", Z64/$ M64) = IF( AQ65'="","", AQ65* AP65*$ AK65) = IF( OR( Z65'="", Z65'=" NA",$ M65'="",$ M65'= 0),"", Z65/$ M65) = IF( AQ66'="","", AQ66* AP66*$ AK66) = IF( OR( Z66'="", Z66'=" NA",$ M66'="",$ M66'= 0),"", Z66/$ M66) = IF( AQ67'="","", AQ67* AP67*$ AK67) = IF( OR( Z67'="", Z67'=" NA",$ M67'="",$ M67'= 0),"", Z67/$ M67) = IF( AQ68'="","", AQ68* AP68*$ AK68) = IF( OR( Z68'="", Z68'=" NA",$ M68'="",$ M68'= 0),"", Z68/$ M68) = IF( AQ69'="","", AQ69* AP69*$ AK69) = IF( OR( Z69'="", Z69'=" NA",$ M69'="",$ M69'= 0),"", Z69/$ M69) = IF( AQ70'="","", AQ70* AP70*$ AK70) = IF( OR( Z70'="", Z70'=" NA",$ M70'="",$ M70'= 0),"", Z70/$ M70) = IF( AQ71'="","", AQ71* AP71*$ AK71) = IF( OR( Z71'="", Z71'=" NA",$ M71'="",$ M71'= 0),"", Z71/$ M71) = IF( AQ72'="","", AQ72* AP72*$ AK72) = IF( OR( Z72'="", Z72'=" NA",$ M72'="",$ M72'= 0),"", Z72/$ M72) = IF( AQ73'="","", AQ73* AP73*$ AK73) = IF( OR( Z73'="", Z73'=" NA",$ M73'="",$ M73'= 0),"", Z73/$ M73) = IF( AQ74'="","", AQ74* AP74*$ AK74) = IF( OR( Z74'="", Z74'=" NA",$ M74'="",$ M74'= 0),"", Z74/$ M74) = IF( AQ75'="","", AQ75* AP75*$ AK75) = IF( OR( Z75'="", Z75'=" NA",$ M75'="",$ M75'= 0),"", Z75/$ M75) = IF( AQ76'="","", AQ76* AP76*$ AK76) = IF( OR( Z76'="", Z76'=" NA",$ M76'="",$ M76'= 0),"", Z76/$ M76) = IF( AQ77'="","", AQ77* AP77*$ AK77) = IF( OR( Z77'="", Z77'=" NA",$ M77'="",$ M77'= 0),"", Z77/$ M77) = IF( AQ78'="","", AQ78* AP78*$ AK78) = IF( OR( Z78'="", Z78'=" NA",$ M78'="",$ M78'= 0),"", Z78/$ M78) = IF( AQ79'="","", AQ79* AP79*$ AK79) = IF( OR( Z79'="", Z79'=" NA",$ M79'="",$ M79'= 0),"", Z79/$ M79) = IF( AQ80'="","", AQ80* AP80*$ AK80) = IF( OR( Z80'="", Z80'=" NA",$ M80'="",$ M80'= 0),"", Z80/$ M80) = IF( AQ81'="","", AQ81* AP81*$ AK81) = IF( OR( Z81'="", Z81'=" NA",$ M81'="",$ M81'= 0),"", Z81/$ M81) = IF( AQ82'="","", AQ82* AP82*$ AK82) = IF( OR( Z82'="", Z82'=" NA",$ M82'="",$ M82'= 0),"", Z82/$ M82) = IF( AQ83'="","", AQ83* AP83*$ AK83) = IF( OR( Z83'="", Z83'=" NA",$ M83'="",$ M83'= 0),"", Z83/$ M83) = IF( AQ84'="","", AQ84* AP84*$ AK84) = IF( OR( Z84'="", Z84'=" NA",$ M84'="",$ M84'= 0),"", Z84/$ M84) = IF( AQ85'="","", AQ85* AP85*$ AK85) = IF( OR( Z85'="", Z85'=" NA",$ M85'="",$ M85'= 0),"", Z85/$ M85) = IF( AQ86'="","", AQ86* AP86*$ AK86) = IF( OR( Z86'="", Z86'=" NA",$ M86'="",$ M86'= 0),"", Z86/$ M86) = IF( AQ87'="","", AQ87* AP87*$ AK87) = IF( OR( Z87'="", Z87'=" NA",$ M87'="",$ M87'= 0),"", Z87/$ M87) = IF( AQ88'="","", AQ88* AP88*$ AK88) = IF( OR( Z88'="", Z88'=" NA",$ M88'="",$ M88'= 0),"", Z88/$ M88) = IF( AQ89'="","", AQ89* AP89*$ AK89) = IF( OR( Z89'="", Z89'=" NA",$ M89'="",$ M89'= 0),"", Z89/$ M89) = IF( AQ90'="","", AQ90* AP90*$ AK90) = IF( OR( Z90'="", Z90'=" NA",$ M90'="",$ M90'= 0),"", Z90/$ M90) = IF( AQ91'="","", AQ91* AP91*$ AK91) = IF( OR( Z91'="", Z91'=" NA",$ M91'="",$ M91'= 0),"", Z91/$ M91) = IF( AQ92'="","", AQ92* AP92*$ AK92) = IF( OR( Z92'="", Z92'=" NA",$ M92'="",$ M92'= 0),"", Z92/$ M92) = IF( AQ93'="","", AQ93* AP93*$ AK93) = IF( OR( Z93'="", Z93'=" NA",$ M93'="",$ M93'= 0),"", Z93/$ M93) = IF( AQ94'="","", AQ94* AP94*$ AK94) = IF( OR( Z94'="", Z94'=" NA",$ M94'="",$ M94'= 0),"", Z94/$ M94) = IF( AQ95'="","", AQ95* AP95*$ AK95) = IF( OR( Z95'="", Z95'=" NA",$ M95'="",$ M95'= 0),"", Z95/$ M95) = IF( AQ96'="","", AQ96* AP96*$ AK96) = IF( OR( Z96'="", Z96'=" NA",$ M96'="",$ M96'= 0),"", Z96/$ M96) = IF( AQ97'="","", AQ97* AP97*$ AK97) = IF( OR( Z97'="", Z97'=" NA",$ M97'="",$ M97'= 0),"", Z97/$ M97) = IF( AQ98'="","", AQ98* AP98*$ AK98) = IF( OR( Z98'="", Z98'=" NA",$ M98'="",$ M98'= 0),"", Z98/$ M98) = IF( AQ99'="","", AQ99* AP99*$ AK99) = IF( OR( Z99'="", Z99'=" NA",$ M99'="",$ M99'= 0),"", Z99/$ M99) = IF( AQ100'="","", AQ100* AP100*$ AK100) = IF( OR( Z100'="", Z100'=" NA",$ M100'="",$ M100'= 0),"", Z100/$ M100) = IF( AQ101'="","", AQ101* AP101*$ AK101) = IF( OR( Z101'="", Z101'=" NA",$ M101'="",$ M101'= 0),"", Z101/$ M101) = IF( AQ102'="","", AQ102* AP102*$ AK102) = IF( OR( Z102'="", Z102'=" NA",$ M102'="",$ M102'= 0),"", Z102/$ M102) = IF( AQ103'="","", AQ103* AP103*$ AK103) = IF( OR( Z103'="", Z103'=" NA",$ M103'="",$ M103'= 0),"", Z103/$ M103) = IF( AQ104'="","", AQ104* AP104*$ AK104) = IF( OR( Z104'="", Z104'=" NA",$ M104'="",$ M104'= 0),"", Z104/$ M104) = IF( AQ105'="","", AQ105* AP105*$ AK105) = IF( OR( Z105'="", Z105'=" NA",$ M105'="",$ M105'= 0),"", Z105/$ M105) = IF( AQ106'="","", AQ106* AP106*$ AK106) = IF( OR( Z106'="", Z106'=" NA",$ M106'="",$ M106'= 0),"", Z106/$ M106) = IF( AQ107'="","", AQ107* AP107*$ AK107) = IF( OR( Z107'="", Z107'=" NA",$ M107'="",$ M107'= 0),"", Z107/$ M107) = IF( AQ108'="","", AQ108* AP108*$ AK108) = IF( OR( Z108'="", Z108'=" NA",$ M108'="",$ M108'= 0),"", Z108/$ M108) = IF( AQ109'="","", AQ109* AP109*$ AK109) = IF( OR( Z109'="", Z109'=" NA",$ M109'="",$ M109'= 0),"", Z109/$ M109) = IF( AQ110'="","", AQ110* AP110*$ AK110) = IF( OR( Z110'="", Z110'=" NA",$ M110'="",$ M110'= 0),"", Z110/$ M110) = IF( AQ111'="","", AQ111* AP111*$ AK111) = IF( OR( Z111'="", Z111'=" NA",$ M111'="",$ M111'= 0),"", Z111/$ M111) = IF( AQ112'="","", AQ112* AP112*$ AK112) = IF( OR( Z112'="", Z112'=" NA",$ M112'="",$ M112'= 0),"", Z112/$ M112) = IF( AQ113'="","", AQ113* AP113*$ AK113) = IF( OR( Z113'="", Z113'=" NA",$ M113'="",$ M113'= 0),"", Z113/$ M113) = IF( AQ114'="","", AQ114* AP114*$ AK114) = IF( OR( Z114'="", Z114'=" NA",$ M114'="",$ M114'= 0),"", Z114/$ M114) = IF( AQ115'="","", AQ115* AP115*$ AK115) = IF( OR( Z115'="", Z115'=" NA",$ M115'="",$ M115'= 0),"", Z115/$ M115) = IF( AQ116'="","", AQ116* AP116*$ AK116) = IF( OR( Z116'="", Z116'=" NA",$ M116'="",$ M116'= 0),"", Z116/$ M116)

February 14, 2003 70 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 27 Virginia Beach Boat Harbor 27 Virginia Beach Army Base 27 Virginia Beach York River 30 Minneapolis St Paul Metropolitan 30 ST. Paul Seneca WWTP 30 ST. Paul Blue Lake WWTP 30 St. Paul Empire WWTP 30 ST. Paul Stillwater WWTP 30 St. Paul Cottage Grove WWTP 30 St. Paul Hasting WWTP 30 St. Paul Rosemount 33 Unified Sewerage Agency ( Durham) 33 USA Rock Creek 33 USA Hillsboro 33 USA Hillsboro Forrest Grove 34 Detroit 35 Kansas City Blue River 35 Kansas City Birmingham 35 Kansas City Westside 35 Kansas City Todd Creek 35 Kansas City Rocky Branch 35 Kansas CityFishing River 35 KC Northland Mobile Home 35 KC Industrial Park 36 Jacksonville ( JEA) 36 Jacksonville District 4 36 Jacksonville District 3 36 Jacksonville District 5 36 Jacksonville District 2 40 New Orleans East Bank 40 New Orleans West Bank 43 Phoneix  91st Ace. 43 Phoenix 45 City of Tampa 46 District of Columbia 52 OCSD WWTP # 2 52 Orange County Reclam Plant # 1 53 NORSD Southerly WWTP 53 NORSD Westerly WWTP 53 NORSD Easterly WWTP 54 Akron WPC 56 Atlanta RM Clayton 56 Atlanta South River 56 Atlanta Utoy Creek 57 MWRDGC Stickney 57 MWRDGC Calumet 57 MWRDGC Northside 57 MWRDGC Kirie 57 MWRDGC Egan 57 MWRDGC Hanover Park 57 MWRDGC Lemont 58 MWRA Boston Deer Island 58 MWRA Boston Clinton 59 Philadelphia Northeast 59 Philadelphia Southwest 59 Philadelphia Southeast 60 Nashville Central AT AU Oulier'= 0 Cost = IF( AS60'="","", IF( AS60> AS$ 121* 2,0, IF( AS60> AN60,0,1))) = IF( AT60'="","", AT60* AS60*$ AK60) = IF( AS61'="","", IF( AS61> AS$ 121* 2,0, IF( AS61> AN61,0,1))) = IF( AT61'="","", AT61* AS61*$ AK61) = IF( AS62'="","", IF( AS62> AS$ 121* 2,0, IF( AS62> AN62,0,1))) = IF( AT62'="","", AT62* AS62*$ AK62) = IF( AS63'="","", IF( AS63> AS$ 121* 2,0, IF( AS63> AN63,0,1))) = IF( AT63'="","", AT63* AS63*$ AK63) = IF( AS64'="","", IF( AS64> AS$ 121* 2,0, IF( AS64> AN64,0,1))) = IF( AT64'="","", AT64* AS64*$ AK64) = IF( AS65'="","", IF( AS65> AS$ 121* 2,0, IF( AS65> AN65,0,1))) = IF( AT65'="","", AT65* AS65*$ AK65) = IF( AS66'="","", IF( AS66> AS$ 121* 2,0, IF( AS66> AN66,0,1))) = IF( AT66'="","", AT66* AS66*$ AK66) = IF( AS67'="","", IF( AS67> AS$ 121* 2,0, IF( AS67> AN67,0,1))) = IF( AT67'="","", AT67* AS67*$ AK67) = IF( AS68'="","", IF( AS68> AS$ 121* 2,0, IF( AS68> AN68,0,1))) = IF( AT68'="","", AT68* AS68*$ AK68) = IF( AS69'="","", IF( AS69> AS$ 121* 2,0, IF( AS69> AN69,0,1))) = IF( AT69'="","", AT69* AS69*$ AK69) = IF( AS70'="","", IF( AS70> AS$ 121* 2,0, IF( AS70> AN70,0,1))) = IF( AT70'="","", AT70* AS70*$ AK70) = IF( AS71'="","", IF( AS71> AS$ 121* 2,0, IF( AS71> AN71,0,1))) = IF( AT71'="","", AT71* AS71*$ AK71) = IF( AS72'="","", IF( AS72> AS$ 121* 2,0, IF( AS72> AN72,0,1))) = IF( AT72'="","", AT72* AS72*$ AK72) = IF( AS73'="","", IF( AS73> AS$ 121* 2,0, IF( AS73> AN73,0,1))) = IF( AT73'="","", AT73* AS73*$ AK73) = IF( AS74'="","", IF( AS74> AS$ 121* 2,0, IF( AS74> AN74,0,1))) = IF( AT74'="","", AT74* AS74*$ AK74) = IF( AS75'="","", IF( AS75> AS$ 121* 2,0, IF( AS75> AN75,0,1))) = IF( AT75'="","", AT75* AS75*$ AK75) = IF( AS76'="","", IF( AS76> AS$ 121* 2,0, IF( AS76> AN76,0,1))) = IF( AT76'="","", AT76* AS76*$ AK76) = IF( AS77'="","", IF( AS77> AS$ 121* 2,0, IF( AS77> AN77,0,1))) = IF( AT77'="","", AT77* AS77*$ AK77) = IF( AS78'="","", IF( AS78> AS$ 121* 2,0, IF( AS78> AN78,0,1))) = IF( AT78'="","", AT78* AS78*$ AK78) = IF( AS79'="","", IF( AS79> AS$ 121* 2,0, IF( AS79> AN79,0,1))) = IF( AT79'="","", AT79* AS79*$ AK79) = IF( AS80'="","", IF( AS80> AS$ 121* 2,0, IF( AS80> AN80,0,1))) = IF( AT80'="","", AT80* AS80*$ AK80) = IF( AS81'="","", IF( AS81> AS$ 121* 2,0, IF( AS81> AN81,0,1))) = IF( AT81'="","", AT81* AS81*$ AK81) = IF( AS82'="","", IF( AS82> AS$ 121* 2,0, IF( AS82> AN82,0,1))) = IF( AT82'="","", AT82* AS82*$ AK82) = IF( AS83'="","", IF( AS83> AS$ 121* 2,0, IF( AS83> AN83,0,1))) = IF( AT83'="","", AT83* AS83*$ AK83) = IF( AS84'="","", IF( AS84> AS$ 121* 2,0, IF( AS84> AN84,0,1))) = IF( AT84'="","", AT84* AS84*$ AK84) = IF( AS85'="","", IF( AS85> AS$ 121* 2,0, IF( AS85> AN85,0,1))) = IF( AT85'="","", AT85* AS85*$ AK85) = IF( AS86'="","", IF( AS86> AS$ 121* 2,0, IF( AS86> AN86,0,1))) = IF( AT86'="","", AT86* AS86*$ AK86) = IF( AS87'="","", IF( AS87> AS$ 121* 2,0, IF( AS87> AN87,0,1))) = IF( AT87'="","", AT87* AS87*$ AK87) = IF( AS88'="","", IF( AS88> AS$ 121* 2,0, IF( AS88> AN88,0,1))) = IF( AT88'="","", AT88* AS88*$ AK88) = IF( AS89'="","", IF( AS89> AS$ 121* 2,0, IF( AS89> AN89,0,1))) = IF( AT89'="","", AT89* AS89*$ AK89) = IF( AS90'="","", IF( AS90> AS$ 121* 2,0, IF( AS90> AN90,0,1))) = IF( AT90'="","", AT90* AS90*$ AK90) = IF( AS91'="","", IF( AS91> AS$ 121* 2,0, IF( AS91> AN91,0,1))) = IF( AT91'="","", AT91* AS91*$ AK91) = IF( AS92'="","", IF( AS92> AS$ 121* 2,0, IF( AS92> AN92,0,1))) = IF( AT92'="","", AT92* AS92*$ AK92) = IF( AS93'="","", IF( AS93> AS$ 121* 2,0, IF( AS93> AN93,0,1))) = IF( AT93'="","", AT93* AS93*$ AK93) = IF( AS94'="","", IF( AS94> AS$ 121* 2,0, IF( AS94> AN94,0,1))) = IF( AT94'="","", AT94* AS94*$ AK94) = IF( AS95'="","", IF( AS95> AS$ 121* 2,0, IF( AS95> AN95,0,1))) = IF( AT95'="","", AT95* AS95*$ AK95) = IF( AS96'="","", IF( AS96> AS$ 121* 2,0, IF( AS96> AN96,0,1))) = IF( AT96'="","", AT96* AS96*$ AK96) = IF( AS97'="","", IF( AS97> AS$ 121* 2,0, IF( AS97> AN97,0,1))) = IF( AT97'="","", AT97* AS97*$ AK97) = IF( AS98'="","", IF( AS98> AS$ 121* 2,0, IF( AS98> AN98,0,1))) = IF( AT98'="","", AT98* AS98*$ AK98) = IF( AS99'="","", IF( AS99> AS$ 121* 2,0, IF( AS99> AN99,0,1))) = IF( AT99'="","", AT99* AS99*$ AK99) = IF( AS100'="","", IF( AS100> AS$ 121* 2,0, IF( AS100> AN100,0,1))) = IF( AT100'="","", AT100* AS100*$ AK100) = IF( AS101'="","", IF( AS101> AS$ 121* 2,0, IF( AS101> AN101,0,1))) = IF( AT101'="","", AT101* AS101*$ AK101) = IF( AS102'="","", IF( AS102> AS$ 121* 2,0, IF( AS102> AN102,0,1))) = IF( AT102'="","", AT102* AS102*$ AK102) = IF( AS103'="","", IF( AS103> AS$ 121* 2,0, IF( AS103> AN103,0,1))) = IF( AT103'="","", AT103* AS103*$ AK103) = IF( AS104'="","", IF( AS104> AS$ 121* 2,0, IF( AS104> AN104,0,1))) = IF( AT104'="","", AT104* AS104*$ AK104) = IF( AS105'="","", IF( AS105> AS$ 121* 2,0, IF( AS105> AN105,0,1))) = IF( AT105'="","", AT105* AS105*$ AK105) = IF( AS106'="","", IF( AS106> AS$ 121* 2,0, IF( AS106> AN106,0,1))) = IF( AT106'="","", AT106* AS106*$ AK106) = IF( AS107'="","", IF( AS107> AS$ 121* 2,0, IF( AS107> AN107,0,1))) = IF( AT107'="","", AT107* AS107*$ AK107) = IF( AS108'="","", IF( AS108> AS$ 121* 2,0, IF( AS108> AN108,0,1))) = IF( AT108'="","", AT108* AS108*$ AK108) = IF( AS109'="","", IF( AS109> AS$ 121* 2,0, IF( AS109> AN109,0,1))) = IF( AT109'="","", AT109* AS109*$ AK109) = IF( AS110'="","", IF( AS110> AS$ 121* 2,0, IF( AS110> AN110,0,1))) = IF( AT110'="","", AT110* AS110*$ AK110) = IF( AS111'="","", IF( AS111> AS$ 121* 2,0, IF( AS111> AN111,0,1))) = IF( AT111'="","", AT111* AS111*$ AK111) = IF( AS112'="","", IF( AS112> AS$ 121* 2,0, IF( AS112> AN112,0,1))) = IF( AT112'="","", AT112* AS112*$ AK112) = IF( AS113'="","", IF( AS113> AS$ 121* 2,0, IF( AS113> AN113,0,1))) = IF( AT113'="","", AT113* AS113*$ AK113) = IF( AS114'="","", IF( AS114> AS$ 121* 2,0, IF( AS114> AN114,0,1))) = IF( AT114'="","", AT114* AS114*$ AK114) = IF( AS115'="","", IF( AS115> AS$ 121* 2,0, IF( AS115> AN115,0,1))) = IF( AT115'="","", AT115* AS115*$ AK115) = IF( AS116'="","", IF( AS116> AS$ 121* 2,0, IF( AS116> AN116,0,1))) = IF( AT116'="","", AT116* AS116*$ AK116)

February 14, 2003 71 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B C D E F G H I J K L M Survey Agency State Flow No. of # of MFJS Total Number ( mgd) IU 433 Others Regulated Unregulated Electroplating Regulated Unregulated MP& M Sites Categorical GM Non Cat. G M # of Non Cat. Oily Waste 117 118 119 120 121 122 60 Nashville Whites Creek TN 25.0 4 1 0 0 0 1 0 0 = SUM( F117: L117) 60 Nashville Dry Creek TN 14.0 8 1 0 1 0 5 0 0 = SUM( F118: L118) 63 Wayne County MI 50 463 7 2 13 0 11 6 0 = SUM( F119: L119) 65 City of Dayton OH 52.12 44 23 4 5 20 25 1 15 = SUM( F120: L120) = AVERAGE( E3: E120)

February 14, 2003 72 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton N O P Q R S T U V W Implement Yearly Implement Yearly Hourly Salary Overhead factor Implement Yearly Implement Total Permitting  Labor Hrs Permitting  Costs Labor Rate Analytical Costs Sampling Costs 578 190 = N119* R119*( 1+ T119) = O119* R119*( 1+ T119) $ 22.00 $ 30.00 2.75 = M119* 650 = M119* 650 = M119* 100 6071 5861 = N120* R120*( 1+ T120) = O120* R120*( 1+ T120) $ 20.00 $ 25.00 0.25 $ 55,800.00 $ 55,800.00 $ 41,850.00 February 14, 2003 73 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton X Y Z AA AB AC AD Yearly Implement Yearly Implement Yearly Implement Yearly Sampling Costs Management Salary Hrs Management Overhead Costs Total Costs = M119* 100 400 100 = Y119* S119*( 1+ T119) = Z119* S119*( 1+ T119) = P119+ U119+ W119+ AA119 = Q119+ V119+ X119+ AB119 $ 41,850.00 663 313 = Y120* S120*( 1+ T120) = Z120* S120*( 1+ T120) = P120+ U120+ W120+ AA120 = Q120+ V120+ X120+ AB120 Average Average w/ out Outliers February 14, 2003 74 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton AE AF Implement Yearly Permitting Costs Per Facility = P119/ 39 = Q119/ 39 = P120/ 93 = Q120/ 93 = AVERAGE( AE3: AE120) = AVERAGE( AF3: AF120) = SUMPRODUCT( AE3: AE120,$ AM$ 3:$ AM$ 120)/ SUM($ AM$ 3:$ AM$ 120) = SUMPRODUCT( AF3: AF120,$ AO$ 3:$ AO$ 120)/ SUM($ AO$ 3:$ AO$ 120)

February 14, 2003 75 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton AG AH AI Implement Yearly MP& M Sites per Program Total Costs Per Facility = IF( OR( A117'= A116, M117'=""),"", SUMIF($ A$ 3:$ A$ 120, A117,$ M$ 3:$ M$ 120)) = IF( OR( A118'= A117, M118'=""),"", SUMIF($ A$ 3:$ A$ 120, A118,$ M$ 3:$ M$ 120)) = AC119/ 39 = AD119/ 39 = IF( OR( A119'= A118, M119'=""),"", SUMIF($ A$ 3:$ A$ 120, A119,$ M$ 3:$ M$ 120)) = AC120/ 93 = AD120/ 93 = IF( OR( A120'= A119, M120'=""),"", SUMIF($ A$ 3:$ A$ 120, A120,$ M$ 3:$ M$ 120)) = AVERAGE( AG3: AG120) = AVERAGE( AH3: AH120) = AVERAGE( AI3: AI120)

February 14, 2003 76 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton AJ AK Loaded Hourly Rate Loaded Salary Rate = IF( OR( R117'="", R117'=" NA"),"", R117*( 1+$ T117)) = IF( OR( S117'="", S117'=" NA"),"", S117*( 1+$ T117)) = IF( OR( R118'="", R118'=" NA"),"", R118*( 1+$ T118)) = IF( OR( S118'="", S118'=" NA"),"", S118*( 1+$ T118)) = IF( OR( R119'="", R119'=" NA"),"", R119*( 1+$ T119)) = IF( OR( S119'="", S119'=" NA"),"", S119*( 1+$ T119)) = IF( OR( R120'="", R120'=" NA"),"", R120*( 1+$ T120)) = IF( OR( S120'="", S120'=" NA"),"", S120*( 1+$ T120)) = AVERAGE( AJ3: AJ120) = AVERAGE( AK3: AK120)

February 14, 2003 77 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton AL AM Permitting Hrs/ MP& M Site Implement Oulier'= 0 = IF( OR( N117'="",$ M117'="",$ M117'= 0),"", N117/$ M117) = IF( AL117'="","", IF( AL117> AL$ 121* 2,0,1)) = IF( OR( N118'="",$ M118'="",$ M118'= 0),"", N118/$ M118) = IF( AL118'="","", IF( AL118> AL$ 121* 2,0,1)) = IF( OR( N119'="",$ M119'="",$ M119'= 0),"", N119/$ M119) = IF( AL119'="","", IF( AL119> AL$ 121* 2,0,1)) = IF( OR( N120'="",$ M120'="",$ M120'= 0),"", N120/$ M120) = IF( AL120'="","", IF( AL120> AL$ 121* 2,0,1)) = AVERAGE( AL3: AL120) = SUMPRODUCT( AL3: AL120,$ AM$ 3:$ AM$ 120)/ SUM($ AM$ 3:$ AM$ 120)

February 14, 2003 78 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton AN AO Permitting Hrs/ MP& M Site Yearly Oulier'= 0 = IF( OR( O117'="",$ M117'="",$ M117'= 0),"", O117/$ M117) = IF( AN117'="","", IF( AN117> AN$ 121* 2,0,1)) = IF( OR( O118'="",$ M118'="",$ M118'= 0),"", O118/$ M118) = IF( AN118'="","", IF( AN118> AN$ 121* 2,0,1)) = IF( OR( O119'="",$ M119'="",$ M119'= 0),"", O119/$ M119) = IF( AN119'="","", IF( AN119> AN$ 121* 2,0,1)) = IF( OR( O120'="",$ M120'="",$ M120'= 0),"", O120/$ M120) = IF( AN120'="","", IF( AN120> AN$ 121* 2,0,1)) = AVERAGE( AN3: AN120) = SUMPRODUCT( AN3: AN120,$ AO$ 3:$ AO$ 120)/ SUM($ AO$ 3:$ AO$ 120)

February 14, 2003 79 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton AP AQ Implement Oulier'= 0 = IF( OR( Y117'="", Y117'=" NA",$ M117'="",$ M117'= 0),"", Y117/$ M117) = IF( AP117'="","", IF( AP117> AP$ 121* 2,0, IF( AP117> AL117,0,1))) = IF( OR( Y118'="", Y118'=" NA",$ M118'="",$ M118'= 0),"", Y118/$ M118) = IF( AP118'="","", IF( AP118> AP$ 121* 2,0, IF( AP118> AL118,0,1))) = IF( OR( Y119'="", Y119'=" NA",$ M119'="",$ M119'= 0),"", Y119/$ M119) = IF( AP119'="","", IF( AP119> AP$ 121* 2,0, IF( AP119> AL119,0,1))) = IF( OR( Y120'="", Y120'=" NA",$ M120'="",$ M120'= 0),"", Y120/$ M120) = IF( AP120'="","", IF( AP120> AP$ 121* 2,0, IF( AP120> AL120,0,1))) = AVERAGE( AP3: AP120) = SUMPRODUCT( AP3: AP120,$ AQ$ 3:$ AQ$ 120)/ SUM($ AQ$ 3:$ AQ$ 120)

February 14, 2003 80 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton AR AS Oversight Hrs/ MP& M Site Cost Yearly = IF( AQ117'="","", AQ117* AP117*$ AK117) = IF( OR( Z117'="", Z117'=" NA",$ M117'="",$ M117'= 0),"", Z117/$ M117) = IF( AQ118'="","", AQ118* AP118*$ AK118) = IF( OR( Z118'="", Z118'=" NA",$ M118'="",$ M118'= 0),"", Z118/$ M118) = IF( AQ119'="","", AQ119* AP119*$ AK119) = IF( OR( Z119'="", Z119'=" NA",$ M119'="",$ M119'= 0),"", Z119/$ M119) = IF( AQ120'="","", AQ120* AP120*$ AK120) = IF( OR( Z120'="", Z120'=" NA",$ M120'="",$ M120'= 0),"", Z120/$ M120) = AVERAGE( AS3: AS120) = SUMPRODUCT( AR3: AR120,$ AQ$ 3:$ AQ$ 120)/ SUM($ AQ$ 3:$ AQ$ 120) = SUMPRODUCT( AS3: AS120,$ AT$ 3:$ AT$ 120)/ SUM($ AT$ 3:$ AT$ 120)

February 14, 2003 81 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 2 A B Survey Agency Number 117 118 119 120 121 122 60 Nashville Whites Creek 60 Nashville Dry Creek 63 Wayne County 65 City of Dayton AT AU Oulier'= 0 Cost = IF( AS117'="","", IF( AS117> AS$ 121* 2,0, IF( AS117> AN117,0,1))) = IF( AT117'="","", AT117* AS117*$ AK117) = IF( AS118'="","", IF( AS118> AS$ 121* 2,0, IF( AS118> AN118,0,1))) = IF( AT118'="","", AT118* AS118*$ AK118) = IF( AS119'="","", IF( AS119> AS$ 121* 2,0, IF( AS119> AN119,0,1))) = IF( AT119'="","", AT119* AS119*$ AK119) = IF( AS120'="","", IF( AS120> AS$ 121* 2,0, IF( AS120> AN120,0,1))) = IF( AT120'="","", AT120* AS120*$ AK120)

= SUMPRODUCT( AU3: AU120,$ AT$ 3:$ AT$ 120)/ SUM($ AT$ 3:$ AT$ 120)

February 14, 2003 82 of 82 MPM COSTS EPA formula. xls  > 50MGD


PAPERWORK REDUCTION ACT SUBMISSION SAN 4535 Please read the instructions before completing this form. For additional forms or assistance in completing this form, contact your agency's Paperwork Clearance Officer. Send two copies of this form, the collection instrument to be reviewed, the Supporting Statement and any additional documentation to: Office of Information and Regulatory Affairs, Office of Management and Budget, Docket Library, Room 10102, 725 17th Street NW Washington, DC 20503.

1. Agency/ Subagency originating request U. S. Environmental Protection Agency 2. OMB control number b. None a 2 0 6 0  017 0 3. Type of information collection ( check one) a. G New collection b. X Revision of a currently approved collection c. G Extension of a currently approved collection d. G Reinstatement, without change, of a previously approved collection for which approval has expired e. G Reinstatement, with change, of a previously approved collection for which approval has expired f. G Existing collection in use without an OMB control number 4. Type of review requested ( check one) a. X Regular b. G Emergency  Approval requested by: / / c. G Delegated 5. Small entities Will this information collection have a significant economic impact on a substantial number of small entities? G Yes X No For b f, note item A2 of Supporting Statement Instructions 6. Requested expiration date a. Three years from approval date b. X Other Specify: 05 / 31 / 2005 7. Title: Recordkeeping and Periodic Reporting of the Production, Import, Recycling, Destruction, Transshipment and Feedstock Use of Ozone Depleting Substances ( Process for Exempting Critical Users from the Phaseout of Methyl Bromide) ( 40 CFR Part 82) ( Revision of Proposed Rule)

8. Agency form number( s) ( If applicable) 1432.23 9. Keywords Treaties, agriculture, pesticides and pests, methyl bromide, critical use exemption 10. Abstract EPA is seeking permission to require submission of data on a quarterly and annual basis from regulated industries and to require recordkeeping activities in conjunction with a proposed action to create an exemption to the phaseout of methyl bromide for critical uses. This requests amends an existing ICR. EPA is seeking this information in order to ensure compliance with the Montreal Protocol on Substances that Deplete the Ozone Layer, the treaty which protects the ozone layer. The respondents are producers, importers, distributors, and applicators of methyl bromide as well as end users of methyl bromide who are primarily farmers of minor vegetable crops and companies that store agricultural commodities.

11. Affected public ( Mark primary with " P" and all others that apply with " X") a. Individuals or households d. X Farms b. P Business or other for profit e. Federal Government c. Not for profit institutions f. State, Local or Tribal Government 12. Obligation to respond ( Mark primary with " P" and all others that apply with " X") a. G Voluntary b. X Required to obtain or retain benefits c. P Mandatory 13. Annual reporting and recordkeeping hour burden a. Number of respondents 2,654 b. Total annual responses 3,740 1. Percentage of these responses collected electronically 50 % c. Total hours requested 9,938 d. Current OMB inventory 9,937 e. Difference 1 f. Explanation of difference 1. Program Change 1 2. Adjustment 0 14. Annual reporting and recordkeeping cost burden ( in thousands of dollars)

a. Total annualized capital/ startup costs 0 b. Total annual costs ( O& M) 1 c. Total annualized cost requested 1 d. Current OMB inventory 1 e. Difference 0 f. Explanation of difference 1. Program change 0 2. Adjustment 0 15. Purpose of information collection ( Mark Primary With " P" and all others that apply with " X") a. P Application for benefits e. __ Program planning or management b. __ Program evaluation f. __ Research c. __ General purpose statistics g. X Regulatory or compliance d. __ Audit 16. Frequency of recordkeeping or reporting ( check all that apply) a. X Recordkeeping b. Q Third party disclosure c. X Reporting 1. Q On occasion 2. Q Weekly 3. Q Monthly 4. X Quarterly 5. Q Semi annually 6. X Annually 7. Q Biannually 8. Q Other ( describe)

17. Statistical methods Does this information collection employ statistical methods?

Q Yes X No 18. Agency contact ( person who can best answer questions regarding the content of this submission) Name: Hodayah Finman Phone: 202 343 9246 OMB 83 I 10/ 95 19. Certification for Paperwork Reduction Act Submissions On behalf of this Federal agency, 1 certify that the collection of information encompassed by this request complies with' 5 CFR 1320.9.

NOTE: The text of 5 CFR 1320.9, and the related provisions of 5 CFR 1320.8( b)( 3), appear at the end of the instructions. The certification is to be made with reference to those regulatory provisions as set forth in the instructions.

The following is a summary of the topics, regarding the proposed collection of information, that the certification covers:

( a) It is necessary for the proper performance of agency functions;

( b) It avoids unnecessary duplication;

( c) It reduces burden on small entities;

( d) It uses plain, coherent, and unambiguous terminology that is understandable to respondents;

( e) Its implementation will be consistent and compatible with current reporting and recordkeeping practices;

( f) It indicates the retention periods for recordkeeping requirements;

( g) It informs respondents of the information called for under 5 CFR 1320.8( b)( 3): ( I) Why the information is being collected' ( ii) Use of information; ( iii) Burden estimate; ( iv) Nature of response ( voluntary, required for a benefit, or mandatory); ( v) Nature and extent of confidentiality; and ( vi) Need to display currently valid OMB control number;

( h) It was developed by an office that has planned and allocated resources for the efficient and effective management and use of the information to be collected ( see note in Item 19 of the instructions);

( I) It uses effective and efficient statistical survey methodology; and ( j) It makes appropriate use of information technology.

If you are unable to certify compliance with any of these provisions, identify the item below and explain the reason in Item 18 of the Supporting Statement.

Signature of Program Official Date Signature of Senior Official or designee Deborah Williams, Acting Director Collection Strategies Division Office of Environmental Information Date OMB 83 I 10/ 95


[Federal Register Volume 77, Number 65 (Wednesday, April 4, 2012)]
[Notices]
[Page 20381]
[FR Doc No: 2012-8028]

-----------------------------------------------------------------------

DEPARTMENT OF ENERGY

Federal Energy Regulatory Commission

[Docket No. ER12-1316-000]

Silver State Solar Power North, LLC; Supplemental Notice That
Initial Market-Based Rate Filing Includes Request for Blanket Section
204 Authorization

    This is a supplemental notice in the above-referenced proceeding of
Silver State Solar Power North, LLC's application for market-based rate
authority, with an accompanying rate tariff, noting that such
application includes a request for blanket authorization, under 18 CFR
part 34, of future issuances of securities and assumptions of
liability.
    Any person desiring to intervene or to protest should file with the
Federal Energy Regulatory Commission, 888 First Street NE., Washington,
DC 20426, in accordance with Rules 211 and 214 of the Commission's
Rules of Practice and Procedure (18 CFR 385.211 and 385.214). Anyone
filing a motion to intervene or protest must serve a copy of that
document on the Applicant.
    Notice is hereby given that the deadline for filing protests with
regard to the applicant's request for blanket authorization, under 18
CFR part 34, of future issuances of securities and assumptions of
liability, is April 17, 2012.
    The Commission encourages electronic submission of protests and
interventions in lieu of paper, using the FERC Online links at http://www.ferc.gov. To facilitate electronic service, persons with Internet
access who will eFile a document and/or be listed as a contact for an
intervenor must create and validate an eRegistration account using the
eRegistration link. Select the eFiling link to log on and submit the
intervention or protests.
    Persons unable to file electronically should submit an original and
14 copies of the intervention or protest to the Federal Energy
Regulatory Commission, 888 First Street NE., Washington, DC 20426.
    The filings in the above-referenced proceeding are accessible in
the Commission's eLibrary system by clicking on the appropriate link in
the above list. They are also available for review in the Commission's
Public Reference Room in Washington, DC. There is an eSubscription link
on the Web site that enables subscribers to receive email notification
when a document is added to a subscribed docket(s). For assistance with
any FERC Online service, please email<EMAIL_ADDRESS>or
call<PHONE_NUMBER> (toll free). For TTY, call<PHONE_NUMBER>.

    Dated: March 28, 2012.
Nathaniel J. Davis, Sr.,
Deputy Secretary.
[FR Doc. 2012-8028 Filed 4-3-12; 8:45 am]
BILLING CODE 6717-01-P


[Federal Register Volume 88, Number 103 (Tuesday, May 30, 2023)]
[Proposed Rules]
[Pages 34459-34460]
[FR Doc No: 2023-11351]

-----------------------------------------------------------------------

DEPARTMENT OF TRANSPORTATION

Federal Aviation Administration

14 CFR Part 71

[Docket No. FAA-2023-0919; Airspace Docket No. 23-AGL-11]
RIN 2120-AA66

Amendment of Class E Airspace; Rush City, MN

AGENCY: Federal Aviation Administration (FAA), DOT.

ACTION: Notice of proposed rulemaking (NPRM).

-----------------------------------------------------------------------

SUMMARY: This action proposes to amend the Class E airspace at Rush
City, MN. The FAA is proposing this action as the result of an airspace
review caused by the decommissioning of the Rush City non-directional
beacon (NDB). The geographic coordinates of the airport would also be
updated to coincide with the FAA's aeronautical database.

DATES: Comments must be received on or before July 14, 2023.

ADDRESSES: Send comments identified by FAA Docket No. FAA-2023-0919 and
Airspace Docket No. 23-AGL-11 using any of the following methods:
    * Federal eRulemaking Portal: Go to www.regulations.gov and follow
the online instruction for sending your comments electronically.
    * Mail: Send comments to Docket Operations, M-30; U.S. Department
of Transportation, 1200 New Jersey Avenue SE, Room W12-140, West
Building Ground Floor, Washington, DC 20590-0001.
    * Hand Delivery or Courier: Take comments to Docket Operations in
Room W12-140 of the West Building Ground Floor at 1200 New Jersey
Avenue SE, Washington, DC, between 9 a.m. and 5 p.m., Monday through
Friday, except Federal holidays.
    * Fax: Fax comments to Docket Operations at<PHONE_NUMBER>.
    Docket: Background documents or comments received may be read at
www.regulations.gov at any time. Follow the online instructions for
accessing the docket or go to Docket Operations in Room W12-140 of the
West Building Ground Floor at 1200 New Jersey Avenue SE, Washington,
DC, between 9 a.m. and 5 p.m., Monday through Friday, except Federal
holidays.
    FAA Order JO 7400.11G, Airspace Designations and Reporting Points,
and subsequent amendments can be viewed online at www.faa.gov/air_traffic/publications/. You may also contact the Rules and
Regulations Group, Office of Policy, Federal Aviation Administration,
800 Independence Avenue SW, Washington DC 20591; telephone: (202) 267-
8783.

FOR FURTHER INFORMATION CONTACT: Rebecca Shelby, Federal Aviation
Administration, Operations Support Group, Central Service Center, 10101
Hillwood Parkway, Fort Worth, TX 76177; telephone<PHONE_NUMBER>.

SUPPLEMENTARY INFORMATION:

Authority for This Rulemaking

    The FAA's authority to issue rules regarding aviation safety is
found in Title 49 of the United States Code. Subtitle I, Section 106
describes the authority of the FAA Administrator. Subtitle VII,
Aviation Programs, describes in more detail the scope of the agency's
authority. This rulemaking is promulgated under the authority described
in Subtitle VII, Part A, Subpart I, Section 40103. Under that section,
the FAA is charged with prescribing regulations to assign the use of
airspace necessary to ensure the safety of aircraft and the efficient
use of airspace. This regulation is within the scope of that authority
as it would amend the Class E airspace extending upward from 700 feet
above the surface at Rush City Regional Airport, Rush City, MN, to
support instrument flight rule (IFR) operations at this airport.

Comments Invited

    The FAA invites interested persons to participate in this
rulemaking by submitting written comments, data, or views. Comments are
specifically invited on the overall regulatory, aeronautical, economic,
environmental, and energy-related aspects of the proposal. The most
helpful comments reference a specific portion of the proposal, explain
the reason for any recommended change, and include supporting data. To
ensure the docket does not contain duplicate comments, commenters
should submit only one time if comments are filed electronically, or
commenters should send only one copy of written comments if comments
are filed in writing.
    The FAA will file in the docket all comments it receives, as well
as a report summarizing each substantive public contact with FAA
personnel concerning this proposed rulemaking. Before acting on this
proposal, the FAA will consider all comments it received on or before
the closing date for comments. The FAA will consider comments filed
after the comment period has closed if it is possible to do so without
incurring expense or dely. The FAA may change this proposal in light of
the comments it receives.
    Privacy: In accordance with 5 U.S.C. 553(c), DOT solicits comments
from the public to better inform its rulemaking process. DOT post these
comments, without edit, including any personal information the
commenter provides, to www.regulations.gov as described in the system
of records notice (DOT/ALL-14FDMS), which can be reviewed at
www.dot.gov/privacy.

Availability of Rulemaking Documents

    An electronic copy of this document may be downloaded through the
internet at www.regulations.gov. Recently published rulemaking
documents can also be accessed through the FAA's web page at
www.faa.gov/air_traffic/publications/airspace_amendments/.
    You may review the public docket containing the proposal, any
comments received, and any final disposition in person in the Dockets
Office (see the ADDRESSES section for the address, phone number, and
hours of operations). An informal docket may also be examined during
normal business hours at the Federal Aviation Administration, Air
Traffic Organization, Central Service Center, Operations Support Group,
10101 Hillwood Parkway, Fort Worth, TX 76177.

Incorporation by Reference

    Class E airspace is published in paragraph 6005 of FAA Order JO
7400.11, Airspace Designations and Reporting Points, which is
incorporated by reference in 14 CFR 71.1 on an annual basis. This
document proposes to amend the current version of that order, FAA Order
JO 7400.11G, dated August 19, 2022, and effective September 15, 2022.
These updates would be published subsequently in the next update to FAA
Order JO 7400.11. That order is publicly available as listed in the
ADDRESSES section of this document.
    FAA Order JO 7400.11G lists Class A, B, C, D, and E airspace areas,
air traffic service routes, and reporting points.

The Proposal

    The FAA is proposing an amendment to 14 CFR part 71 by modifying
the Class E airspace extending upward from 700 feet above the surface
to within a 6.4-mile (decreased from a 6.5-mile) radius of Rush City
Regional Airport, Rush City, MN; removing the Rush City NDB from the
airspace legal description; and updating the geographic coordinates of
the airport to coincide with the FAA's aeronautical database.

    This action is the result of an airspace review caused by the
decommissioning of the Rush City NDB which provided navigation
information for the instrument procedures at this airport.

Regulatory Notices and Analyses

    The FAA has determined that this proposed regulation only involves
an established body of technical regulations for which frequent and
routine amendments are necessary to keep them operationally current.
It, therefore: (1) is not a ``significant regulatory action'' under
Executive Order 12866; (2) is not a ``significant rule'' under DOT
Regulatory Policies and Procedures (44 FR 11034; February 26, 1979);
and (3) does not warrant preparation of a regulatory evaluation as the
anticipated impact is so minimal. Since this is a routine matter that
will only affect air traffic procedures and air navigation, it is
certified that this proposed rule, when promulgated, will not have a
significant economic impact on a substantial number of small entities
under the criteria of the Regulatory Flexibility Act.

Environmental Review

    This proposal will be subject to an environmental analysis in
accordance with FAA Order 1050.1F, ``Environmental Impacts: Policies
and Procedures'' prior to any FAA final regulatory action.

List of Subjects in 14 CFR Part 71

    Airspace, Incorporation by reference, Navigation (air).

The Proposed Amendment

    In consideration of the foregoing, the Federal Aviation
Administration proposes to amend 14 CFR part 71 as follows:

PART 71--DESIGNATION OF CLASS A, B, C, D, AND E AIRSPACE AREAS; AIR
TRAFFIC SERVICE ROUTES; AND REPORTING POINTS

0
1. The authority citation for 14 CFR part 71 continues to read as
follows:

    Authority: 49 U.S.C. 106(f), 106(g); 40103, 40113, 40120; E.O.
10854, 24 FR 9565, 3 CFR, 1959-1963 Comp., p. 389.

Sec.  71.1  [Amended]

0
2. The incorporation by reference in 14 CFR 71.1 of FAA Order JO
7400.11G, Airspace Designations and Reporting Points, dated August 19,
2022, and effective September 15, 2022, is amended as follows:

Paragraph 6005 Class E Airspace Areas Extending Upward From 700
Feet or More Above the Surface of the Earth.

* * * * *

AGL MN E5 Rush City, MN [Amended]

Rush City Regional Airport, TX
    (Lat 45[deg]41'50'' N, long 092[deg]57'08'' W)

    That airspace extending upward from 700 feet above the surface
within a 6.4-mile radius of Rush City Regional Airport.
* * * * *

    Issued in Fort Worth, Texas, on May 22, 2023.
Martin A. Skinner,
Acting Manager, Operations Support Group, ATO Central Service Center.
[FR Doc. 2023-11351 Filed 5-26-23; 8:45 am]
BILLING CODE 4910-13-P