February 14, 2003 38 of 82 MPM COSTS EPA formula. xls  < 10MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B C D E F G H I J K L M N Survey Agency State Flow No. of # of MFJS Total Number ( mgd) IU 433 Others Regulated Unregulated Electroplating Regulated Unregulated MP& M Sites Implement 5 Somerset NJ 15.0 18 1 0 0 0 1 0 0 = SUM( F3: L3) 6 Albany County Sewer District NY 19.0 14 0 0 0 0 0 0 0 = SUM( F4: L4) 730 6 Albany South Plant NY 20.0 2 0 0 0 0 0 0 0 = SUM( F5: L5) 7 City of Niagra Falls NY 35.0 225 0 0 0 10 1 0 0 = SUM( F6: L6) 321 10 City of Clearwater ( Marshall Street) FL 6.5 2 2 1 2 6 2 0 5 = SUM( F7: L7) 202 10 Clearwater Northeast FL 5.5 12 0 2 0 6 2 0 8 = SUM( F8: L8) 10 Clearwater East FL 2.3 5 0 0 0 4 0 0 0 = SUM( F9: L9) 14 City of Hamilton OH 21.0 121 0 0 0 8 3 0 1 = SUM( F10: L10) 227 15 Racine WI 30.9 50 8 6 7 1 15 0 1 = SUM( F11: L11) 2,318 18 Little Rock Adams Field AR 18.0 4 2 0 0 0 0 0 0 = SUM( F12: L12) 200 18 City of Little Rock, Wastewater Utility AR 14.0 8 5 0 1 0 0 0 0 = SUM( F13: L13) 19 Fayetteville AR 11.8 11 4 1 1 0 0 0 0 = SUM( F14: L14) 588 21 South San Francisco ( SBSA) CA 20.3 38 16 8 0 0 5 0 0 = SUM( F15: L15) 1,100 24 City of Tacoma WA 23.0 3387 0 12 2 35 5 2 12 = SUM( F16: L16) 239 24 City of Tacoma, Central Treatment Plant WA 4.4 = SUM( F17: L17) 29 Fox River WRD South Plant IL 15.0 4 1 0 0 0 1 2 0 = SUM( F18: L18) 415 29 Fox River WRD North Plant IL 5.0 7 2 0 0 0 2 3 0 = SUM( F19: L19) 29 Rox River WRD West Plant IL 0.7 1 0 0 0 0 1 0 0 = SUM( F20: L20) 31 City of Everett WA 17.6 25 1 0 0 0 6 0 0 = SUM( F21: L21) 248 32 Spokane WA 40.0 9 3 4 0 40 4 0 5 = SUM( F22: L22) 3,100 42 Regional Water Reclamation Facility Medford OR 15.0 285 4 4 17 45 1 0 33 = SUM( F23: L23) 7,200 44 Madison WI 42.0 150 20 0 0 5 1 0 0 = SUM( F24: L24) 430 48 Raleigh Neuse River NC 35.1 28 13 0 0 0 2 0 0 = SUM( F25: L25) 49 Bosie West Bosie WWTP ID 13.4 830 2 5 0 0 2 0 0 = SUM( F26: L26) 80 49 Boise, Lander Street WWTP ID 13.2 410 1 5 0 3 2 0 0 = SUM( F27: L27) 51 North Charleston SC 15.0 38 1 0 0 0 1 3 0 = SUM( F28: L28) 165 55 Battle Creek MI 11.5 28 2 0 2 0 0 0 0 = SUM( F29: L29) 159 62 Johnson County Blue Ridge # 1 KA 2.08 62 Johnson County Mill Creek KA 7.92 62 Johnson County Mission Township KA 7.1 62 Johnson County Turkey Creek KA 6.86 62 Johnson County Little Bull Creek # 2 KA 0.315 62 Johnson County Tomahawk KA 4.55 62 Johnson County Little Bull Creek # 1 KA 62 Johnson County Blue Ridge # 4 KA 66 Hillsborough County Dak Mabry FL 4.13 1 0 0 0 0 0 0 0 = SUM( F38: L38) 66 Hillsborough County Eagiles FL 0.102 0 0 0 0 0 0 0 0 = SUM( F39: L39) 66 Hillsborough County Falkenburg Road FL 5.13 6 0 0 0 0 0 0 0 = SUM( F40: L40) 66 Hillsborough County Northwest Regional FL 4 1 0 0 0 0 0 0 0 = SUM( F41: L41) 66 Hillsborough County River Oaks FL 5.81 10 1 0 1 0 2 0 0 = SUM( F42: L42) 66 Hillsborough County South County FL 2.74 0 0 0 0 0 0 0 0 = SUM( F43: L43) 66 Hillsborough County Valvico FL 3.24 3 0 0 0 0 0 0 0 = SUM( F44: L44) 66 Hillsborough County Van Dyke FL 0.66 0 0 0 0 0 0 0 0 = SUM( F45: L45) = AVERAGE( E3: E45) Categorical GM Non Cat. G M # of Non Cat. Oily Waste Total Permitting  Labor Hrs February 14, 2003 39 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke O P Q R S T U V W X Yearly Implement Yearly Hourly Salary Overhead factor Implement Yearly Implement Yearly = N3* R3*( 1+ T3) = O3* R3*( 1+ T3) $ 21.00 $ 21.00 360 = N4* R4*( 1+ T4) = O4* R4*( 1+ T4) $ 25.00 $ 25.00 0.3 $ 10,000.00 $ 10,000.00 $ 2,000.00 $ 2,000.00 95 = N6* R6*( 1+ T6) = O6* R6*( 1+ T6) $ 20.25 $ 29.40 0.35 $ 8,000.00 $ 8,000.00 $ 3,200.00 $ 3,200.00 113 = N7* R7*( 1+ T7) = O7* R7*( 1+ T7) $ 16.98 $ 24.10 1.025 $ 646.00 $ 680.00 162 = N10* R10*( 1+ T10) = O10* R10*( 1+ T10) $ 25.50 $ 25.50 0.05 $ 9,000.00 $ 9,000.00 $ 1,350.00 $ 1,350.00 1,558 = N11* R11*( 1+ T11) = O11* R11*( 1+ T11) $ 19.50 $ 32.00 0.3 $ 21,328.00 $ 21,328.00 $ 27,720.00 $ 27,720.00 114 = N12* R12*( 1+ T12) = O12* R12*( 1+ T12) $ 15.00 $ 20.00 0 $ 10,000.00 $ 10,000.00 $ 1,920.00 $ 1,920.00 228 = N14* R14*( 1+ T14) = O14* R14*( 1+ T14) $ 14.00 $ 25.00 0.35 $ 6,000.00 $ 6,000.00 $ 500.00 $ 500.00 260 = N15* R15*( 1+ T15) = O15* R15*( 1+ T15) $ 28.49 $ 39.07 0.47 $ 142,000.00 $ 142,000.00 $ 20,300.00 $ 20,300.00 179 = N16* R16*( 1+ T16) = O16* R16*( 1+ T16) $ 25.00 $ 39.00 0.23 $ 54,400.00 $ 54,400.00 $ 4,216.00 $ 4,216.00 280 = N18* R18*( 1+ T18) = O18* R18*( 1+ T18) $ 22.61 $ 25.78 1 $ 30,000.00 $ 30,000.00 $ 17,000.00 $ 17,000.00 212 = N21* R21*( 1+ T21) = O21* R21*( 1+ T21) $ 27.45 $ 34.59 0.29 $ 8,400.00 $ 16,800.00 $ 6,600.00 $ 13,200.00 1,110 = N22* R22*( 1+ T22) = O22* R22*( 1+ T22) $ 20.00 $ 30.00 0.68 $ 100,000.00 $ 75,000.00 $ 100,000.00 $ 100,000.00 4,600 = N23* R23*( 1+ T23) = O23* R23*( 1+ T23) $ 24.00 $ 30.00 0.15 $ 150,000.00 $ 150,000.00 $ 80,000.00 $ 80,000.00 93 = N24* R24*( 1+ T24) = O24* R24*( 1+ T24) $ 18.00 $ 23.00 0.75 $ 15,000.00 $ 3,000.00 $ 2,500.00 $ 2,500.00 = N25* R25*( 1+ T25) = O25* R25*( 1+ T25) $ 13.00 $ 23.06 50 = N26* R26*( 1+ T26) = O26* R26*( 1+ T26) $ 16.00 $ 19.00 0.825 110 = N28* R28*( 1+ T28) = O28* R28*( 1+ T28) $ 18.00 $ 30.00 0.1 $ 5,000.00 $ 2,000.00 $ 1,500.00 $ 1,500.00 132 = N29* R29*( 1+ T29) = O29* R29*( 1+ T29) $ 19.25 $ 23.00 $ 4,020.00 $ 4,020.00 $ 1,800.00 $ 1,800.00 $ 20.00 $ 33.00 0.04 Total Permitting  Labor Hrs Permitting  Costs Labor Rate Analytical Costs Sampling Costs February 14, 2003 40 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke Y Z AA AB AC AD Implement Yearly Implement Yearly Implement Yearly = Y3* S3*( 1+ T3) = Z3* S3*( 1+ T3) = P3+ U3+ W3+ AA3 = Q3+ V3+ X3+ AB3 = Y4* S4*( 1+ T4) = Z4* S4*( 1+ T4) = P4+ U4+ W4+ AA4 = Q4+ V4+ X4+ AB4 4 4 = Y6* S6*( 1+ T6) = Z6* S6*( 1+ T6) = P6+ U6+ W6+ AA6 = Q6+ V6+ X6+ AB6 320 320 = Y7* S7*( 1+ T7) = Z7* S7*( 1+ T7) = P7+ U7+ W7+ AA7 = Q7+ V7+ X7+ AB7 = Y8* S8*( 1+ T8) = Z8* S8*( 1+ T8) = P8+ U8+ W8+ AA8 = Q8+ V8+ X8+ AB8 227 142 = Y10* S10*( 1+ T10) = Z10* S10*( 1+ T10) = P10+ U10+ W10+ AA10 = Q10+ V10+ X10+ AB10 200 50 = Y11* S11*( 1+ T11) = Z11* S11*( 1+ T11) = P11+ U11+ W11+ AA11 = Q11+ V11+ X11+ AB11 200 100 = Y12* S12*( 1+ T12) = Z12* S12*( 1+ T12) = P12+ U12+ W12+ AA12 = Q12+ V12+ X12+ AB12 400 200 = Y14* S14*( 1+ T14) = Z14* S14*( 1+ T14) = P14+ U14+ W14+ AA14 = Q14+ V14+ X14+ AB14 180 105 = Y15* S15*( 1+ T15) = Z15* S15*( 1+ T15) = P15+ U15+ W15+ AA15 = Q15+ V15+ X15+ AB15 239 179 = Y16* S16*( 1+ T16) = Z16* S16*( 1+ T16) = P16+ U16+ W16+ AA16 = Q16+ V16+ X16+ AB16 60 45 = Y18* S18*( 1+ T18) = Z18* S18*( 1+ T18) = P18+ U18+ W18+ AA18 = Q18+ V18+ X18+ AB18 60 20 = Y21* S21*( 1+ T21) = Z21* S21*( 1+ T21) = P21+ U21+ W21+ AA21 = Q21+ V21+ X21+ AB21 2,000 1,000 = Y22* S22*( 1+ T22) = Z22* S22*( 1+ T22) = P22+ U22+ W22+ AA22 = Q22+ V22+ X22+ AB22 700 700 = Y23* S23*( 1+ T23) = Z23* S23*( 1+ T23) = P23+ U23+ W23+ AA23 = Q23+ V23+ X23+ AB23 450 150 = Y24* S24*( 1+ T24) = Z24* S24*( 1+ T24) = P24+ U24+ W24+ AA24 = Q24+ V24+ X24+ AB24 780 780 = Y25* S25*( 1+ T25) = Z25* S25*( 1+ T25) = P25+ U25+ W25+ AA25 = Q25+ V25+ X25+ AB25 80 50 = Y26* S26*( 1+ T26) = Z26* S26*( 1+ T26) = P26+ U26+ W26+ AA26 = Q26+ V26+ X26+ AB26 2 1 = Y28* S28*( 1+ T28) = Z28* S28*( 1+ T28) = P28+ U28+ W28+ AA28 = Q28+ V28+ X28+ AB28 100 100 = Y29* S29*( 1+ T29) = Z29* S29*( 1+ T29) = P29+ U29+ W29+ AA29 = Q29+ V29+ X29+ AB29 Average Average w/ out Outliers Management Salary Hrs Management Overhead Costs Total Costs February 14, 2003 41 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke AE AF Implement Yearly = P6/ M6 = Q6/ M6 = P7/ 40 = Q7/ 40 = P10/ M10 = Q10/ M10 = P11/ M11 = Q11/ M11 = P12/ 8 = Q12/ 8 = P14/ M14 = Q14/ M14 = P15/ M15 = Q15/ M15 = P16/ M16 = Q16/ M16 = P18/ 12 = Q18/ 12 = P21/ M21 = Q21/ M21 = P22/ M22 = Q22/ M22 = P23/ M23 = Q23/ M23 = P24/ M24 = Q24/ M24 = P26/ 20 = Q26/ 20 = P28/ M28 = Q28/ M28 = P29/ M29 = Q29/ M29 = AVERAGE( AE3: AE45) = AVERAGE( AF3: AF45) = SUMPRODUCT( AE3: AE45,$ AM$ 3:$ AM$ 45)/ SUM($ AM$ 3:$ AM$ 45) = SUMPRODUCT( AF3: AF45,$ AO$ 3:$ AO$ 45)/ SUM($ AO$ 3:$ AO$ 45) Permitting Costs Per Facility February 14, 2003 42 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke AG AH Implement Yearly = AC6/ M6 = AD6/ M6 = AC7/ 40 = AD7/ 40 = AC10/ M10 = AD10/ M10 = AC11/ M11 = AD11/ M11 = AC12/ 8 = AD12/ 8 = AC14/ M14 = AD14/ M14 = AC15/ M15 = AD15/ M15 = AC16/ M16 = AD16/ M16 = AC18/ 12 = AD18/ 12 = AC21/ M21 = AD21/ M21 = AC22/ M22 = AD22/ M22 = AC23/ M23 = AD23/ M23 = AC24/ M24 = AD24/ M24 = AC25/ M25 = AD25/ M25 = AC26/ 20 = AD26/ 20 = AC28/ M28 = AD28/ M28 = AC29/ M29 = AD29/ M29 = AVERAGE( AG3: AG45) = AVERAGE( AH3: AH45) Total Costs Per Facility February 14, 2003 43 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke AI AJ MP& M Sites per Program Loaded Hourly Rate = IF( OR( A3'= A2, M3'=""),"", SUMIF($ A$ 3:$ A$ 45, A3,$ M$ 3:$ M$ 45)) = IF( OR( R3'="", R3'=" NA"),"", R3*( 1+$ T3)) = IF( OR( A4'= A3, M4'=""),"", SUMIF($ A$ 3:$ A$ 45, A4,$ M$ 3:$ M$ 45)) = IF( OR( R4'="", R4'=" NA"),"", R4*( 1+$ T4)) = IF( OR( A5'= A4, M5'=""),"", SUMIF($ A$ 3:$ A$ 45, A5,$ M$ 3:$ M$ 45)) = IF( OR( R5'="", R5'=" NA"),"", R5*( 1+$ T5)) = IF( OR( A6'= A5, M6'=""),"", SUMIF($ A$ 3:$ A$ 45, A6,$ M$ 3:$ M$ 45)) = IF( OR( R6'="", R6'=" NA"),"", R6*( 1+$ T6)) = IF( OR( A7'= A6, M7'=""),"", SUMIF($ A$ 3:$ A$ 45, A7,$ M$ 3:$ M$ 45)) = IF( OR( R7'="", R7'=" NA"),"", R7*( 1+$ T7)) = IF( OR( A8'= A7, M8'=""),"", SUMIF($ A$ 3:$ A$ 45, A8,$ M$ 3:$ M$ 45)) = IF( OR( R8'="", R8'=" NA"),"", R8*( 1+$ T8)) = IF( OR( A9'= A8, M9'=""),"", SUMIF($ A$ 3:$ A$ 45, A9,$ M$ 3:$ M$ 45)) = IF( OR( R9'="", R9'=" NA"),"", R9*( 1+$ T9)) = IF( OR( A10'= A9, M10'=""),"", SUMIF($ A$ 3:$ A$ 45, A10,$ M$ 3:$ M$ 45)) = IF( OR( R10'="", R10'=" NA"),"", R10*( 1+$ T10)) = IF( OR( A11'= A10, M11'=""),"", SUMIF($ A$ 3:$ A$ 45, A11,$ M$ 3:$ M$ 45)) = IF( OR( R11'="", R11'=" NA"),"", R11*( 1+$ T11)) = IF( OR( A12'= A11, M12'=""),"", SUMIF($ A$ 3:$ A$ 45, A12,$ M$ 3:$ M$ 45)) = IF( OR( R12'="", R12'=" NA"),"", R12*( 1+$ T12)) = IF( OR( A13'= A12, M13'=""),"", SUMIF($ A$ 3:$ A$ 45, A13,$ M$ 3:$ M$ 45)) = IF( OR( R13'="", R13'=" NA"),"", R13*( 1+$ T13)) = IF( OR( A14'= A13, M14'=""),"", SUMIF($ A$ 3:$ A$ 45, A14,$ M$ 3:$ M$ 45)) = IF( OR( R14'="", R14'=" NA"),"", R14*( 1+$ T14)) = IF( OR( A15'= A14, M15'=""),"", SUMIF($ A$ 3:$ A$ 45, A15,$ M$ 3:$ M$ 45)) = IF( OR( R15'="", R15'=" NA"),"", R15*( 1+$ T15)) = IF( OR( A16'= A15, M16'=""),"", SUMIF($ A$ 3:$ A$ 45, A16,$ M$ 3:$ M$ 45)) = IF( OR( R16'="", R16'=" NA"),"", R16*( 1+$ T16)) = IF( OR( A17'= A16, M17'=""),"", SUMIF($ A$ 3:$ A$ 45, A17,$ M$ 3:$ M$ 45)) = IF( OR( R17'="", R17'=" NA"),"", R17*( 1+$ T17)) = IF( OR( A18'= A17, M18'=""),"", SUMIF($ A$ 3:$ A$ 45, A18,$ M$ 3:$ M$ 45)) = IF( OR( R18'="", R18'=" NA"),"", R18*( 1+$ T18)) = IF( OR( A19'= A18, M19'=""),"", SUMIF($ A$ 3:$ A$ 45, A19,$ M$ 3:$ M$ 45)) = IF( OR( R19'="", R19'=" NA"),"", R19*( 1+$ T19)) = IF( OR( A20'= A19, M20'=""),"", SUMIF($ A$ 3:$ A$ 45, A20,$ M$ 3:$ M$ 45)) = IF( OR( R20'="", R20'=" NA"),"", R20*( 1+$ T20)) = IF( OR( A21'= A20, M21'=""),"", SUMIF($ A$ 3:$ A$ 45, A21,$ M$ 3:$ M$ 45)) = IF( OR( R21'="", R21'=" NA"),"", R21*( 1+$ T21)) = IF( OR( A22'= A21, M22'=""),"", SUMIF($ A$ 3:$ A$ 45, A22,$ M$ 3:$ M$ 45)) = IF( OR( R22'="", R22'=" NA"),"", R22*( 1+$ T22)) = IF( OR( A23'= A22, M23'=""),"", SUMIF($ A$ 3:$ A$ 45, A23,$ M$ 3:$ M$ 45)) = IF( OR( R23'="", R23'=" NA"),"", R23*( 1+$ T23)) = IF( OR( A24'= A23, M24'=""),"", SUMIF($ A$ 3:$ A$ 45, A24,$ M$ 3:$ M$ 45)) = IF( OR( R24'="", R24'=" NA"),"", R24*( 1+$ T24)) = IF( OR( A25'= A24, M25'=""),"", SUMIF($ A$ 3:$ A$ 45, A25,$ M$ 3:$ M$ 45)) = IF( OR( R25'="", R25'=" NA"),"", R25*( 1+$ T25)) = IF( OR( A26'= A25, M26'=""),"", SUMIF($ A$ 3:$ A$ 45, A26,$ M$ 3:$ M$ 45)) = IF( OR( R26'="", R26'=" NA"),"", R26*( 1+$ T26)) = IF( OR( A27'= A26, M27'=""),"", SUMIF($ A$ 3:$ A$ 45, A27,$ M$ 3:$ M$ 45)) = IF( OR( R27'="", R27'=" NA"),"", R27*( 1+$ T27)) = IF( OR( A28'= A27, M28'=""),"", SUMIF($ A$ 3:$ A$ 45, A28,$ M$ 3:$ M$ 45)) = IF( OR( R28'="", R28'=" NA"),"", R28*( 1+$ T28)) = IF( OR( A29'= A28, M29'=""),"", SUMIF($ A$ 3:$ A$ 45, A29,$ M$ 3:$ M$ 45)) = IF( OR( R29'="", R29'=" NA"),"", R29*( 1+$ T29)) = IF( OR( A30'= A29, M30'=""),"", SUMIF($ A$ 3:$ A$ 45, A30,$ M$ 3:$ M$ 45)) = IF( OR( R30'="", R30'=" NA"),"", R30*( 1+$ T30)) = IF( OR( A31'= A30, M31'=""),"", SUMIF($ A$ 3:$ A$ 45, A31,$ M$ 3:$ M$ 45)) = IF( OR( R31'="", R31'=" NA"),"", R31*( 1+$ T31)) = IF( OR( A32'= A31, M32'=""),"", SUMIF($ A$ 3:$ A$ 45, A32,$ M$ 3:$ M$ 45)) = IF( OR( R32'="", R32'=" NA"),"", R32*( 1+$ T32)) = IF( OR( A33'= A32, M33'=""),"", SUMIF($ A$ 3:$ A$ 45, A33,$ M$ 3:$ M$ 45)) = IF( OR( R33'="", R33'=" NA"),"", R33*( 1+$ T33)) = IF( OR( A34'= A33, M34'=""),"", SUMIF($ A$ 3:$ A$ 45, A34,$ M$ 3:$ M$ 45)) = IF( OR( R34'="", R34'=" NA"),"", R34*( 1+$ T34)) = IF( OR( A35'= A34, M35'=""),"", SUMIF($ A$ 3:$ A$ 45, A35,$ M$ 3:$ M$ 45)) = IF( OR( R35'="", R35'=" NA"),"", R35*( 1+$ T35)) = IF( OR( A36'= A35, M36'=""),"", SUMIF($ A$ 3:$ A$ 45, A36,$ M$ 3:$ M$ 45)) = IF( OR( R36'="", R36'=" NA"),"", R36*( 1+$ T36)) = IF( OR( A37'= A36, M37'=""),"", SUMIF($ A$ 3:$ A$ 45, A37,$ M$ 3:$ M$ 45)) = IF( OR( R37'="", R37'=" NA"),"", R37*( 1+$ T37)) = IF( OR( A38'= A37, M38'=""),"", SUMIF($ A$ 3:$ A$ 45, A38,$ M$ 3:$ M$ 45)) = IF( OR( R38'="", R38'=" NA"),"", R38*( 1+$ T38)) = IF( OR( A39'= A38, M39'=""),"", SUMIF($ A$ 3:$ A$ 45, A39,$ M$ 3:$ M$ 45)) = IF( OR( R39'="", R39'=" NA"),"", R39*( 1+$ T39)) = IF( OR( A40'= A39, M40'=""),"", SUMIF($ A$ 3:$ A$ 45, A40,$ M$ 3:$ M$ 45)) = IF( OR( R40'="", R40'=" NA"),"", R40*( 1+$ T40)) = IF( OR( A41'= A40, M41'=""),"", SUMIF($ A$ 3:$ A$ 45, A41,$ M$ 3:$ M$ 45)) = IF( OR( R41'="", R41'=" NA"),"", R41*( 1+$ T41)) = IF( OR( A42'= A41, M42'=""),"", SUMIF($ A$ 3:$ A$ 45, A42,$ M$ 3:$ M$ 45)) = IF( OR( R42'="", R42'=" NA"),"", R42*( 1+$ T42)) = IF( OR( A43'= A42, M43'=""),"", SUMIF($ A$ 3:$ A$ 45, A43,$ M$ 3:$ M$ 45)) = IF( OR( R43'="", R43'=" NA"),"", R43*( 1+$ T43)) = IF( OR( A44'= A43, M44'=""),"", SUMIF($ A$ 3:$ A$ 45, A44,$ M$ 3:$ M$ 45)) = IF( OR( R44'="", R44'=" NA"),"", R44*( 1+$ T44)) = IF( OR( A45'= A44, M45'=""),"", SUMIF($ A$ 3:$ A$ 45, A45,$ M$ 3:$ M$ 45)) = IF( OR( R45'="", R45'=" NA"),"", R45*( 1+$ T45)) = AVERAGE( AI3: AI45) = AVERAGE( AJ3: AJ45)

February 14, 2003 44 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke AK AL AM Permitting Hrs/ MP& M Site Loaded Salary Rate Implement Oulier'= 0 = IF( OR( S3'="", S3'=" NA"),"", S3*( 1+$ T3)) = IF( OR( N3'="",$ M3'="",$ M3'= 0),"", N3/$ M3) = IF( AL3'="","", IF( AL3> AL$ 46* 2,0,1)) = IF( OR( S4'="", S4'=" NA"),"", S4*( 1+$ T4)) = IF( OR( N4'="",$ M4'="",$ M4'= 0),"", N4/$ M4) = IF( AL4'="","", IF( AL4> AL$ 46* 2,0,1)) = IF( OR( S5'="", S5'=" NA"),"", S5*( 1+$ T5)) = IF( OR( N5'="",$ M5'="",$ M5'= 0),"", N5/$ M5) = IF( AL5'="","", IF( AL5> AL$ 46* 2,0,1)) = IF( OR( S6'="", S6'=" NA"),"", S6*( 1+$ T6)) = IF( OR( N6'="",$ M6'="",$ M6'= 0),"", N6/$ M6) = IF( AL6'="","", IF( AL6> AL$ 46* 2,0,1)) = IF( OR( S7'="", S7'=" NA"),"", S7*( 1+$ T7)) = IF( OR( N7'="",$ M7'="",$ M7'= 0),"", N7/$ M7) = IF( AL7'="","", IF( AL7> AL$ 46* 2,0,1)) = IF( OR( S8'="", S8'=" NA"),"", S8*( 1+$ T8)) = IF( OR( N8'="",$ M8'="",$ M8'= 0),"", N8/$ M8) = IF( AL8'="","", IF( AL8> AL$ 46* 2,0,1)) = IF( OR( S9'="", S9'=" NA"),"", S9*( 1+$ T9)) = IF( OR( N9'="",$ M9'="",$ M9'= 0),"", N9/$ M9) = IF( AL9'="","", IF( AL9> AL$ 46* 2,0,1)) = IF( OR( S10'="", S10'=" NA"),"", S10*( 1+$ T10)) = IF( OR( N10'="",$ M10'="",$ M10'= 0),"", N10/$ M10) = IF( AL10'="","", IF( AL10> AL$ 46* 2,0,1)) = IF( OR( S11'="", S11'=" NA"),"", S11*( 1+$ T11)) = IF( OR( N11'="",$ M11'="",$ M11'= 0),"", N11/$ M11) = IF( AL11'="","", IF( AL11> AL$ 46* 2,0,1)) = IF( OR( S12'="", S12'=" NA"),"", S12*( 1+$ T12)) = IF( OR( N12'="",$ M12'="",$ M12'= 0),"", N12/$ M12) = IF( AL12'="","", IF( AL12> AL$ 46* 2,0,1)) = IF( OR( S13'="", S13'=" NA"),"", S13*( 1+$ T13)) = IF( OR( N13'="",$ M13'="",$ M13'= 0),"", N13/$ M13) = IF( AL13'="","", IF( AL13> AL$ 46* 2,0,1)) = IF( OR( S14'="", S14'=" NA"),"", S14*( 1+$ T14)) = IF( OR( N14'="",$ M14'="",$ M14'= 0),"", N14/$ M14) = IF( AL14'="","", IF( AL14> AL$ 46* 2,0,1)) = IF( OR( S15'="", S15'=" NA"),"", S15*( 1+$ T15)) = IF( OR( N15'="",$ M15'="",$ M15'= 0),"", N15/$ M15) = IF( AL15'="","", IF( AL15> AL$ 46* 2,0,1)) = IF( OR( S16'="", S16'=" NA"),"", S16*( 1+$ T16)) = IF( OR( N16'="",$ M16'="",$ M16'= 0),"", N16/$ M16) = IF( AL16'="","", IF( AL16> AL$ 46* 2,0,1)) = IF( OR( S17'="", S17'=" NA"),"", S17*( 1+$ T17)) = IF( OR( N17'="",$ M17'="",$ M17'= 0),"", N17/$ M17) = IF( AL17'="","", IF( AL17> AL$ 46* 2,0,1)) = IF( OR( S18'="", S18'=" NA"),"", S18*( 1+$ T18)) = IF( OR( N18'="",$ M18'="",$ M18'= 0),"", N18/$ M18) = IF( AL18'="","", IF( AL18> AL$ 46* 2,0,1)) = IF( OR( S19'="", S19'=" NA"),"", S19*( 1+$ T19)) = IF( OR( N19'="",$ M19'="",$ M19'= 0),"", N19/$ M19) = IF( AL19'="","", IF( AL19> AL$ 46* 2,0,1)) = IF( OR( S20'="", S20'=" NA"),"", S20*( 1+$ T20)) = IF( OR( N20'="",$ M20'="",$ M20'= 0),"", N20/$ M20) = IF( AL20'="","", IF( AL20> AL$ 46* 2,0,1)) = IF( OR( S21'="", S21'=" NA"),"", S21*( 1+$ T21)) = IF( OR( N21'="",$ M21'="",$ M21'= 0),"", N21/$ M21) = IF( AL21'="","", IF( AL21> AL$ 46* 2,0,1)) = IF( OR( S22'="", S22'=" NA"),"", S22*( 1+$ T22)) = IF( OR( N22'="",$ M22'="",$ M22'= 0),"", N22/$ M22) = IF( AL22'="","", IF( AL22> AL$ 46* 2,0,1)) = IF( OR( S23'="", S23'=" NA"),"", S23*( 1+$ T23)) = IF( OR( N23'="",$ M23'="",$ M23'= 0),"", N23/$ M23) = IF( AL23'="","", IF( AL23> AL$ 46* 2,0,1)) = IF( OR( S24'="", S24'=" NA"),"", S24*( 1+$ T24)) = IF( OR( N24'="",$ M24'="",$ M24'= 0),"", N24/$ M24) = IF( AL24'="","", IF( AL24> AL$ 46* 2,0,1)) = IF( OR( S25'="", S25'=" NA"),"", S25*( 1+$ T25)) = IF( OR( N25'="",$ M25'="",$ M25'= 0),"", N25/$ M25) = IF( AL25'="","", IF( AL25> AL$ 46* 2,0,1)) = IF( OR( S26'="", S26'=" NA"),"", S26*( 1+$ T26)) = IF( OR( N26'="",$ M26'="",$ M26'= 0),"", N26/$ M26) = IF( AL26'="","", IF( AL26> AL$ 46* 2,0,1)) = IF( OR( S27'="", S27'=" NA"),"", S27*( 1+$ T27)) = IF( OR( N27'="",$ M27'="",$ M27'= 0),"", N27/$ M27) = IF( AL27'="","", IF( AL27> AL$ 46* 2,0,1)) = IF( OR( S28'="", S28'=" NA"),"", S28*( 1+$ T28)) = IF( OR( N28'="",$ M28'="",$ M28'= 0),"", N28/$ M28) = IF( AL28'="","", IF( AL28> AL$ 46* 2,0,1)) = IF( OR( S29'="", S29'=" NA"),"", S29*( 1+$ T29)) = IF( OR( N29'="",$ M29'="",$ M29'= 0),"", N29/$ M29) = IF( AL29'="","", IF( AL29> AL$ 46* 2,0,1)) = IF( OR( S30'="", S30'=" NA"),"", S30*( 1+$ T30)) = IF( OR( N30'="",$ M30'="",$ M30'= 0),"", N30/$ M30) = IF( AL30'="","", IF( AL30> AL$ 46* 2,0,1)) = IF( OR( S31'="", S31'=" NA"),"", S31*( 1+$ T31)) = IF( OR( N31'="",$ M31'="",$ M31'= 0),"", N31/$ M31) = IF( AL31'="","", IF( AL31> AL$ 46* 2,0,1)) = IF( OR( S32'="", S32'=" NA"),"", S32*( 1+$ T32)) = IF( OR( N32'="",$ M32'="",$ M32'= 0),"", N32/$ M32) = IF( AL32'="","", IF( AL32> AL$ 46* 2,0,1)) = IF( OR( S33'="", S33'=" NA"),"", S33*( 1+$ T33)) = IF( OR( N33'="",$ M33'="",$ M33'= 0),"", N33/$ M33) = IF( AL33'="","", IF( AL33> AL$ 46* 2,0,1)) = IF( OR( S34'="", S34'=" NA"),"", S34*( 1+$ T34)) = IF( OR( N34'="",$ M34'="",$ M34'= 0),"", N34/$ M34) = IF( AL34'="","", IF( AL34> AL$ 46* 2,0,1)) = IF( OR( S35'="", S35'=" NA"),"", S35*( 1+$ T35)) = IF( OR( N35'="",$ M35'="",$ M35'= 0),"", N35/$ M35) = IF( AL35'="","", IF( AL35> AL$ 46* 2,0,1)) = IF( OR( S36'="", S36'=" NA"),"", S36*( 1+$ T36)) = IF( OR( N36'="",$ M36'="",$ M36'= 0),"", N36/$ M36) = IF( AL36'="","", IF( AL36> AL$ 46* 2,0,1)) = IF( OR( S37'="", S37'=" NA"),"", S37*( 1+$ T37)) = IF( OR( N37'="",$ M37'="",$ M37'= 0),"", N37/$ M37) = IF( AL37'="","", IF( AL37> AL$ 46* 2,0,1)) = IF( OR( S38'="", S38'=" NA"),"", S38*( 1+$ T38)) = IF( OR( N38'="",$ M38'="",$ M38'= 0),"", N38/$ M38) = IF( AL38'="","", IF( AL38> AL$ 46* 2,0,1)) = IF( OR( S39'="", S39'=" NA"),"", S39*( 1+$ T39)) = IF( OR( N39'="",$ M39'="",$ M39'= 0),"", N39/$ M39) = IF( AL39'="","", IF( AL39> AL$ 46* 2,0,1)) = IF( OR( S40'="", S40'=" NA"),"", S40*( 1+$ T40)) = IF( OR( N40'="",$ M40'="",$ M40'= 0),"", N40/$ M40) = IF( AL40'="","", IF( AL40> AL$ 46* 2,0,1)) = IF( OR( S41'="", S41'=" NA"),"", S41*( 1+$ T41)) = IF( OR( N41'="",$ M41'="",$ M41'= 0),"", N41/$ M41) = IF( AL41'="","", IF( AL41> AL$ 46* 2,0,1)) = IF( OR( S42'="", S42'=" NA"),"", S42*( 1+$ T42)) = IF( OR( N42'="",$ M42'="",$ M42'= 0),"", N42/$ M42) = IF( AL42'="","", IF( AL42> AL$ 46* 2,0,1)) = IF( OR( S43'="", S43'=" NA"),"", S43*( 1+$ T43)) = IF( OR( N43'="",$ M43'="",$ M43'= 0),"", N43/$ M43) = IF( AL43'="","", IF( AL43> AL$ 46* 2,0,1)) = IF( OR( S44'="", S44'=" NA"),"", S44*( 1+$ T44)) = IF( OR( N44'="",$ M44'="",$ M44'= 0),"", N44/$ M44) = IF( AL44'="","", IF( AL44> AL$ 46* 2,0,1)) = IF( OR( S45'="", S45'=" NA"),"", S45*( 1+$ T45)) = IF( OR( N45'="",$ M45'="",$ M45'= 0),"", N45/$ M45) = IF( AL45'="","", IF( AL45> AL$ 46* 2,0,1)) = AVERAGE( AK3: AK45) = AVERAGE( AL3: AL45) = SUMPRODUCT( AL3: AL45,$ AM$ 3:$ AM$ 45)/ SUM($ AM$ 3:$ AM$ 45)

February 14, 2003 45 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke AN AO Permitting Hrs/ MP& M Site Yearly Oulier'= 0 = IF( OR( O3'="",$ M3'="",$ M3'= 0),"", O3/$ M3) = IF( AN3'="","", IF( AN3> AN$ 46* 2,0,1)) = IF( OR( O4'="",$ M4'="",$ M4'= 0),"", O4/$ M4) = IF( AN4'="","", IF( AN4> AN$ 46* 2,0,1)) = IF( OR( O5'="",$ M5'="",$ M5'= 0),"", O5/$ M5) = IF( AN5'="","", IF( AN5> AN$ 46* 2,0,1)) = IF( OR( O6'="",$ M6'="",$ M6'= 0),"", O6/$ M6) = IF( AN6'="","", IF( AN6> AN$ 46* 2,0,1)) = IF( OR( O7'="",$ M7'="",$ M7'= 0),"", O7/$ M7) = IF( AN7'="","", IF( AN7> AN$ 46* 2,0,1)) = IF( OR( O8'="",$ M8'="",$ M8'= 0),"", O8/$ M8) = IF( AN8'="","", IF( AN8> AN$ 46* 2,0,1)) = IF( OR( O9'="",$ M9'="",$ M9'= 0),"", O9/$ M9) = IF( AN9'="","", IF( AN9> AN$ 46* 2,0,1)) = IF( OR( O10'="",$ M10'="",$ M10'= 0),"", O10/$ M10) = IF( AN10'="","", IF( AN10> AN$ 46* 2,0,1)) = IF( OR( O11'="",$ M11'="",$ M11'= 0),"", O11/$ M11) = IF( AN11'="","", IF( AN11> AN$ 46* 2,0,1)) = IF( OR( O12'="",$ M12'="",$ M12'= 0),"", O12/$ M12) = IF( AN12'="","", IF( AN12> AN$ 46* 2,0,1)) = IF( OR( O13'="",$ M13'="",$ M13'= 0),"", O13/$ M13) = IF( AN13'="","", IF( AN13> AN$ 46* 2,0,1)) = IF( OR( O14'="",$ M14'="",$ M14'= 0),"", O14/$ M14) = IF( AN14'="","", IF( AN14> AN$ 46* 2,0,1)) = IF( OR( O15'="",$ M15'="",$ M15'= 0),"", O15/$ M15) = IF( AN15'="","", IF( AN15> AN$ 46* 2,0,1)) = IF( OR( O16'="",$ M16'="",$ M16'= 0),"", O16/$ M16) = IF( AN16'="","", IF( AN16> AN$ 46* 2,0,1)) = IF( OR( O17'="",$ M17'="",$ M17'= 0),"", O17/$ M17) = IF( AN17'="","", IF( AN17> AN$ 46* 2,0,1)) = IF( OR( O18'="",$ M18'="",$ M18'= 0),"", O18/$ M18) = IF( AN18'="","", IF( AN18> AN$ 46* 2,0,1)) = IF( OR( O19'="",$ M19'="",$ M19'= 0),"", O19/$ M19) = IF( AN19'="","", IF( AN19> AN$ 46* 2,0,1)) = IF( OR( O20'="",$ M20'="",$ M20'= 0),"", O20/$ M20) = IF( AN20'="","", IF( AN20> AN$ 46* 2,0,1)) = IF( OR( O21'="",$ M21'="",$ M21'= 0),"", O21/$ M21) = IF( AN21'="","", IF( AN21> AN$ 46* 2,0,1)) = IF( OR( O22'="",$ M22'="",$ M22'= 0),"", O22/$ M22) = IF( AN22'="","", IF( AN22> AN$ 46* 2,0,1)) = IF( OR( O23'="",$ M23'="",$ M23'= 0),"", O23/$ M23) = IF( AN23'="","", IF( AN23> AN$ 46* 2,0,1)) = IF( OR( O24'="",$ M24'="",$ M24'= 0),"", O24/$ M24) = IF( AN24'="","", IF( AN24> AN$ 46* 2,0,1)) = IF( OR( O25'="",$ M25'="",$ M25'= 0),"", O25/$ M25) = IF( AN25'="","", IF( AN25> AN$ 46* 2,0,1)) = IF( OR( O26'="",$ M26'="",$ M26'= 0),"", O26/$ M26) = IF( AN26'="","", IF( AN26> AN$ 46* 2,0,1)) = IF( OR( O27'="",$ M27'="",$ M27'= 0),"", O27/$ M27) = IF( AN27'="","", IF( AN27> AN$ 46* 2,0,1)) = IF( OR( O28'="",$ M28'="",$ M28'= 0),"", O28/$ M28) = IF( AN28'="","", IF( AN28> AN$ 46* 2,0,1)) = IF( OR( O29'="",$ M29'="",$ M29'= 0),"", O29/$ M29) = IF( AN29'="","", IF( AN29> AN$ 46* 2,0,1)) = IF( OR( O30'="",$ M30'="",$ M30'= 0),"", O30/$ M30) = IF( AN30'="","", IF( AN30> AN$ 46* 2,0,1)) = IF( OR( O31'="",$ M31'="",$ M31'= 0),"", O31/$ M31) = IF( AN31'="","", IF( AN31> AN$ 46* 2,0,1)) = IF( OR( O32'="",$ M32'="",$ M32'= 0),"", O32/$ M32) = IF( AN32'="","", IF( AN32> AN$ 46* 2,0,1)) = IF( OR( O33'="",$ M33'="",$ M33'= 0),"", O33/$ M33) = IF( AN33'="","", IF( AN33> AN$ 46* 2,0,1)) = IF( OR( O34'="",$ M34'="",$ M34'= 0),"", O34/$ M34) = IF( AN34'="","", IF( AN34> AN$ 46* 2,0,1)) = IF( OR( O35'="",$ M35'="",$ M35'= 0),"", O35/$ M35) = IF( AN35'="","", IF( AN35> AN$ 46* 2,0,1)) = IF( OR( O36'="",$ M36'="",$ M36'= 0),"", O36/$ M36) = IF( AN36'="","", IF( AN36> AN$ 46* 2,0,1)) = IF( OR( O37'="",$ M37'="",$ M37'= 0),"", O37/$ M37) = IF( AN37'="","", IF( AN37> AN$ 46* 2,0,1)) = IF( OR( O38'="",$ M38'="",$ M38'= 0),"", O38/$ M38) = IF( AN38'="","", IF( AN38> AN$ 46* 2,0,1)) = IF( OR( O39'="",$ M39'="",$ M39'= 0),"", O39/$ M39) = IF( AN39'="","", IF( AN39> AN$ 46* 2,0,1)) = IF( OR( O40'="",$ M40'="",$ M40'= 0),"", O40/$ M40) = IF( AN40'="","", IF( AN40> AN$ 46* 2,0,1)) = IF( OR( O41'="",$ M41'="",$ M41'= 0),"", O41/$ M41) = IF( AN41'="","", IF( AN41> AN$ 46* 2,0,1)) = IF( OR( O42'="",$ M42'="",$ M42'= 0),"", O42/$ M42) = IF( AN42'="","", IF( AN42> AN$ 46* 2,0,1)) = IF( OR( O43'="",$ M43'="",$ M43'= 0),"", O43/$ M43) = IF( AN43'="","", IF( AN43> AN$ 46* 2,0,1)) = IF( OR( O44'="",$ M44'="",$ M44'= 0),"", O44/$ M44) = IF( AN44'="","", IF( AN44> AN$ 46* 2,0,1)) = IF( OR( O45'="",$ M45'="",$ M45'= 0),"", O45/$ M45) = IF( AN45'="","", IF( AN45> AN$ 46* 2,0,1)) = AVERAGE( AN3: AN45) = SUMPRODUCT( AN3: AN45,$ AO$ 3:$ AO$ 45)/ SUM($ AO$ 3:$ AO$ 45)

February 14, 2003 46 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke AP AQ Implement Oulier'= 0 = IF( OR( Y3'="", Y3'=" NA",$ M3'="",$ M3'= 0),"", Y3/$ M3) = IF( AP3'="","", IF( AP3> AP$ 46* 2,0, IF( AP3> AL3,0,1))) = IF( OR( Y4'="", Y4'=" NA",$ M4'="",$ M4'= 0),"", Y4/$ M4) = IF( AP4'="","", IF( AP4> AP$ 46* 2,0, IF( AP4> AL4,0,1))) = IF( OR( Y5'="", Y5'=" NA",$ M5'="",$ M5'= 0),"", Y5/$ M5) = IF( AP5'="","", IF( AP5> AP$ 46* 2,0, IF( AP5> AL5,0,1))) = IF( OR( Y6'="", Y6'=" NA",$ M6'="",$ M6'= 0),"", Y6/$ M6) = IF( AP6'="","", IF( AP6> AP$ 46* 2,0, IF( AP6> AL6,0,1))) = IF( OR( Y7'="", Y7'=" NA",$ M7'="",$ M7'= 0),"", Y7/$ M7) = IF( AP7'="","", IF( AP7> AP$ 46* 2,0, IF( AP7> AL7,0,1))) = IF( OR( Y8'="", Y8'=" NA",$ M8'="",$ M8'= 0),"", Y8/$ M8) = IF( AP8'="","", IF( AP8> AP$ 46* 2,0, IF( AP8> AL8,0,1))) = IF( OR( Y9'="", Y9'=" NA",$ M9'="",$ M9'= 0),"", Y9/$ M9) = IF( AP9'="","", IF( AP9> AP$ 46* 2,0, IF( AP9> AL9,0,1))) = IF( OR( Y10'="", Y10'=" NA",$ M10'="",$ M10'= 0),"", Y10/$ M10) = IF( AP10'="","", IF( AP10> AP$ 46* 2,0, IF( AP10> AL10,0,1))) = IF( OR( Y11'="", Y11'=" NA",$ M11'="",$ M11'= 0),"", Y11/$ M11) = IF( AP11'="","", IF( AP11> AP$ 46* 2,0, IF( AP11> AL11,0,1))) = IF( OR( Y12'="", Y12'=" NA",$ M12'="",$ M12'= 0),"", Y12/$ M12) = IF( AP12'="","", IF( AP12> AP$ 46* 2,0, IF( AP12> AL12,0,1))) = IF( OR( Y13'="", Y13'=" NA",$ M13'="",$ M13'= 0),"", Y13/$ M13) = IF( AP13'="","", IF( AP13> AP$ 46* 2,0, IF( AP13> AL13,0,1))) = IF( OR( Y14'="", Y14'=" NA",$ M14'="",$ M14'= 0),"", Y14/$ M14) = IF( AP14'="","", IF( AP14> AP$ 46* 2,0, IF( AP14> AL14,0,1))) = IF( OR( Y15'="", Y15'=" NA",$ M15'="",$ M15'= 0),"", Y15/$ M15) = IF( AP15'="","", IF( AP15> AP$ 46* 2,0, IF( AP15> AL15,0,1))) = IF( OR( Y16'="", Y16'=" NA",$ M16'="",$ M16'= 0),"", Y16/$ M16) = IF( AP16'="","", IF( AP16> AP$ 46* 2,0, IF( AP16> AL16,0,1))) = IF( OR( Y17'="", Y17'=" NA",$ M17'="",$ M17'= 0),"", Y17/$ M17) = IF( AP17'="","", IF( AP17> AP$ 46* 2,0, IF( AP17> AL17,0,1))) = IF( OR( Y18'="", Y18'=" NA",$ M18'="",$ M18'= 0),"", Y18/$ M18) = IF( AP18'="","", IF( AP18> AP$ 46* 2,0, IF( AP18> AL18,0,1))) = IF( OR( Y19'="", Y19'=" NA",$ M19'="",$ M19'= 0),"", Y19/$ M19) = IF( AP19'="","", IF( AP19> AP$ 46* 2,0, IF( AP19> AL19,0,1))) = IF( OR( Y20'="", Y20'=" NA",$ M20'="",$ M20'= 0),"", Y20/$ M20) = IF( AP20'="","", IF( AP20> AP$ 46* 2,0, IF( AP20> AL20,0,1))) = IF( OR( Y21'="", Y21'=" NA",$ M21'="",$ M21'= 0),"", Y21/$ M21) = IF( AP21'="","", IF( AP21> AP$ 46* 2,0, IF( AP21> AL21,0,1))) = IF( OR( Y22'="", Y22'=" NA",$ M22'="",$ M22'= 0),"", Y22/$ M22) = IF( AP22'="","", IF( AP22> AP$ 46* 2,0, IF( AP22> AL22,0,1))) = IF( OR( Y23'="", Y23'=" NA",$ M23'="",$ M23'= 0),"", Y23/$ M23) = IF( AP23'="","", IF( AP23> AP$ 46* 2,0, IF( AP23> AL23,0,1))) = IF( OR( Y24'="", Y24'=" NA",$ M24'="",$ M24'= 0),"", Y24/$ M24) = IF( AP24'="","", IF( AP24> AP$ 46* 2,0, IF( AP24> AL24,0,1))) = IF( OR( Y25'="", Y25'=" NA",$ M25'="",$ M25'= 0),"", Y25/$ M25) = IF( AP25'="","", IF( AP25> AP$ 46* 2,0, IF( AP25> AL25,0,1))) = IF( OR( Y26'="", Y26'=" NA",$ M26'="",$ M26'= 0),"", Y26/$ M26) = IF( AP26'="","", IF( AP26> AP$ 46* 2,0, IF( AP26> AL26,0,1))) = IF( OR( Y27'="", Y27'=" NA",$ M27'="",$ M27'= 0),"", Y27/$ M27) = IF( AP27'="","", IF( AP27> AP$ 46* 2,0, IF( AP27> AL27,0,1))) = IF( OR( Y28'="", Y28'=" NA",$ M28'="",$ M28'= 0),"", Y28/$ M28) = IF( AP28'="","", IF( AP28> AP$ 46* 2,0, IF( AP28> AL28,0,1))) = IF( OR( Y29'="", Y29'=" NA",$ M29'="",$ M29'= 0),"", Y29/$ M29) = IF( AP29'="","", IF( AP29> AP$ 46* 2,0, IF( AP29> AL29,0,1))) = IF( OR( Y30'="", Y30'=" NA",$ M30'="",$ M30'= 0),"", Y30/$ M30) = IF( AP30'="","", IF( AP30> AP$ 46* 2,0, IF( AP30> AL30,0,1))) = IF( OR( Y31'="", Y31'=" NA",$ M31'="",$ M31'= 0),"", Y31/$ M31) = IF( AP31'="","", IF( AP31> AP$ 46* 2,0, IF( AP31> AL31,0,1))) = IF( OR( Y32'="", Y32'=" NA",$ M32'="",$ M32'= 0),"", Y32/$ M32) = IF( AP32'="","", IF( AP32> AP$ 46* 2,0, IF( AP32> AL32,0,1))) = IF( OR( Y33'="", Y33'=" NA",$ M33'="",$ M33'= 0),"", Y33/$ M33) = IF( AP33'="","", IF( AP33> AP$ 46* 2,0, IF( AP33> AL33,0,1))) = IF( OR( Y34'="", Y34'=" NA",$ M34'="",$ M34'= 0),"", Y34/$ M34) = IF( AP34'="","", IF( AP34> AP$ 46* 2,0, IF( AP34> AL34,0,1))) = IF( OR( Y35'="", Y35'=" NA",$ M35'="",$ M35'= 0),"", Y35/$ M35) = IF( AP35'="","", IF( AP35> AP$ 46* 2,0, IF( AP35> AL35,0,1))) = IF( OR( Y36'="", Y36'=" NA",$ M36'="",$ M36'= 0),"", Y36/$ M36) = IF( AP36'="","", IF( AP36> AP$ 46* 2,0, IF( AP36> AL36,0,1))) = IF( OR( Y37'="", Y37'=" NA",$ M37'="",$ M37'= 0),"", Y37/$ M37) = IF( AP37'="","", IF( AP37> AP$ 46* 2,0, IF( AP37> AL37,0,1))) = IF( OR( Y38'="", Y38'=" NA",$ M38'="",$ M38'= 0),"", Y38/$ M38) = IF( AP38'="","", IF( AP38> AP$ 46* 2,0, IF( AP38> AL38,0,1))) = IF( OR( Y39'="", Y39'=" NA",$ M39'="",$ M39'= 0),"", Y39/$ M39) = IF( AP39'="","", IF( AP39> AP$ 46* 2,0, IF( AP39> AL39,0,1))) = IF( OR( Y40'="", Y40'=" NA",$ M40'="",$ M40'= 0),"", Y40/$ M40) = IF( AP40'="","", IF( AP40> AP$ 46* 2,0, IF( AP40> AL40,0,1))) = IF( OR( Y41'="", Y41'=" NA",$ M41'="",$ M41'= 0),"", Y41/$ M41) = IF( AP41'="","", IF( AP41> AP$ 46* 2,0, IF( AP41> AL41,0,1))) = IF( OR( Y42'="", Y42'=" NA",$ M42'="",$ M42'= 0),"", Y42/$ M42) = IF( AP42'="","", IF( AP42> AP$ 46* 2,0, IF( AP42> AL42,0,1))) = IF( OR( Y43'="", Y43'=" NA",$ M43'="",$ M43'= 0),"", Y43/$ M43) = IF( AP43'="","", IF( AP43> AP$ 46* 2,0, IF( AP43> AL43,0,1))) = IF( OR( Y44'="", Y44'=" NA",$ M44'="",$ M44'= 0),"", Y44/$ M44) = IF( AP44'="","", IF( AP44> AP$ 46* 2,0, IF( AP44> AL44,0,1))) = IF( OR( Y45'="", Y45'=" NA",$ M45'="",$ M45'= 0),"", Y45/$ M45) = IF( AP45'="","", IF( AP45> AP$ 46* 2,0, IF( AP45> AL45,0,1))) = AVERAGE( AP3: AP45) = SUMPRODUCT( AP3: AP45,$ AQ$ 3:$ AQ$ 45)/ SUM($ AQ$ 3:$ AQ$ 45)

February 14, 2003 47 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke AR AS Oversight Hrs/ MP& M Site Cost Yearly = IF( AQ3'="","", AQ3* AP3*$ AK3) = IF( OR( Z3'="", Z3'=" NA",$ M3'="",$ M3'= 0),"", Z3/$ M3) = IF( AQ4'="","", AQ4* AP4*$ AK4) = IF( OR( Z4'="", Z4'=" NA",$ M4'="",$ M4'= 0),"", Z4/$ M4) = IF( AQ5'="","", AQ5* AP5*$ AK5) = IF( OR( Z5'="", Z5'=" NA",$ M5'="",$ M5'= 0),"", Z5/$ M5) = IF( AQ6'="","", AQ6* AP6*$ AK6) = IF( OR( Z6'="", Z6'=" NA",$ M6'="",$ M6'= 0),"", Z6/$ M6) = IF( AQ7'="","", AQ7* AP7*$ AK7) = IF( OR( Z7'="", Z7'=" NA",$ M7'="",$ M7'= 0),"", Z7/$ M7) = IF( AQ8'="","", AQ8* AP8*$ AK8) = IF( OR( Z8'="", Z8'=" NA",$ M8'="",$ M8'= 0),"", Z8/$ M8) = IF( AQ9'="","", AQ9* AP9*$ AK9) = IF( OR( Z9'="", Z9'=" NA",$ M9'="",$ M9'= 0),"", Z9/$ M9) = IF( AQ10'="","", AQ10* AP10*$ AK10) = IF( OR( Z10'="", Z10'=" NA",$ M10'="",$ M10'= 0),"", Z10/$ M10) = IF( AQ11'="","", AQ11* AP11*$ AK11) = IF( OR( Z11'="", Z11'=" NA",$ M11'="",$ M11'= 0),"", Z11/$ M11) = IF( AQ12'="","", AQ12* AP12*$ AK12) = IF( OR( Z12'="", Z12'=" NA",$ M12'="",$ M12'= 0),"", Z12/$ M12) = IF( AQ13'="","", AQ13* AP13*$ AK13) = IF( OR( Z13'="", Z13'=" NA",$ M13'="",$ M13'= 0),"", Z13/$ M13) = IF( AQ14'="","", AQ14* AP14*$ AK14) = IF( OR( Z14'="", Z14'=" NA",$ M14'="",$ M14'= 0),"", Z14/$ M14) = IF( AQ15'="","", AQ15* AP15*$ AK15) = IF( OR( Z15'="", Z15'=" NA",$ M15'="",$ M15'= 0),"", Z15/$ M15) = IF( AQ16'="","", AQ16* AP16*$ AK16) = IF( OR( Z16'="", Z16'=" NA",$ M16'="",$ M16'= 0),"", Z16/$ M16) = IF( AQ17'="","", AQ17* AP17*$ AK17) = IF( OR( Z17'="", Z17'=" NA",$ M17'="",$ M17'= 0),"", Z17/$ M17) = IF( AQ18'="","", AQ18* AP18*$ AK18) = IF( OR( Z18'="", Z18'=" NA",$ M18'="",$ M18'= 0),"", Z18/$ M18) = IF( AQ19'="","", AQ19* AP19*$ AK19) = IF( OR( Z19'="", Z19'=" NA",$ M19'="",$ M19'= 0),"", Z19/$ M19) = IF( AQ20'="","", AQ20* AP20*$ AK20) = IF( OR( Z20'="", Z20'=" NA",$ M20'="",$ M20'= 0),"", Z20/$ M20) = IF( AQ21'="","", AQ21* AP21*$ AK21) = IF( OR( Z21'="", Z21'=" NA",$ M21'="",$ M21'= 0),"", Z21/$ M21) = IF( AQ22'="","", AQ22* AP22*$ AK22) = IF( OR( Z22'="", Z22'=" NA",$ M22'="",$ M22'= 0),"", Z22/$ M22) = IF( AQ23'="","", AQ23* AP23*$ AK23) = IF( OR( Z23'="", Z23'=" NA",$ M23'="",$ M23'= 0),"", Z23/$ M23) = IF( AQ24'="","", AQ24* AP24*$ AK24) = IF( OR( Z24'="", Z24'=" NA",$ M24'="",$ M24'= 0),"", Z24/$ M24) = IF( AQ25'="","", AQ25* AP25*$ AK25) = IF( OR( Z25'="", Z25'=" NA",$ M25'="",$ M25'= 0),"", Z25/$ M25) = IF( AQ26'="","", AQ26* AP26*$ AK26) = IF( OR( Z26'="", Z26'=" NA",$ M26'="",$ M26'= 0),"", Z26/$ M26) = IF( AQ27'="","", AQ27* AP27*$ AK27) = IF( OR( Z27'="", Z27'=" NA",$ M27'="",$ M27'= 0),"", Z27/$ M27) = IF( AQ28'="","", AQ28* AP28*$ AK28) = IF( OR( Z28'="", Z28'=" NA",$ M28'="",$ M28'= 0),"", Z28/$ M28) = IF( AQ29'="","", AQ29* AP29*$ AK29) = IF( OR( Z29'="", Z29'=" NA",$ M29'="",$ M29'= 0),"", Z29/$ M29) = IF( AQ30'="","", AQ30* AP30*$ AK30) = IF( OR( Z30'="", Z30'=" NA",$ M30'="",$ M30'= 0),"", Z30/$ M30) = IF( AQ31'="","", AQ31* AP31*$ AK31) = IF( OR( Z31'="", Z31'=" NA",$ M31'="",$ M31'= 0),"", Z31/$ M31) = IF( AQ32'="","", AQ32* AP32*$ AK32) = IF( OR( Z32'="", Z32'=" NA",$ M32'="",$ M32'= 0),"", Z32/$ M32) = IF( AQ33'="","", AQ33* AP33*$ AK33) = IF( OR( Z33'="", Z33'=" NA",$ M33'="",$ M33'= 0),"", Z33/$ M33) = IF( AQ34'="","", AQ34* AP34*$ AK34) = IF( OR( Z34'="", Z34'=" NA",$ M34'="",$ M34'= 0),"", Z34/$ M34) = IF( AQ35'="","", AQ35* AP35*$ AK35) = IF( OR( Z35'="", Z35'=" NA",$ M35'="",$ M35'= 0),"", Z35/$ M35) = IF( AQ36'="","", AQ36* AP36*$ AK36) = IF( OR( Z36'="", Z36'=" NA",$ M36'="",$ M36'= 0),"", Z36/$ M36) = IF( AQ37'="","", AQ37* AP37*$ AK37) = IF( OR( Z37'="", Z37'=" NA",$ M37'="",$ M37'= 0),"", Z37/$ M37) = IF( AQ38'="","", AQ38* AP38*$ AK38) = IF( OR( Z38'="", Z38'=" NA",$ M38'="",$ M38'= 0),"", Z38/$ M38) = IF( AQ39'="","", AQ39* AP39*$ AK39) = IF( OR( Z39'="", Z39'=" NA",$ M39'="",$ M39'= 0),"", Z39/$ M39) = IF( AQ40'="","", AQ40* AP40*$ AK40) = IF( OR( Z40'="", Z40'=" NA",$ M40'="",$ M40'= 0),"", Z40/$ M40) = IF( AQ41'="","", AQ41* AP41*$ AK41) = IF( OR( Z41'="", Z41'=" NA",$ M41'="",$ M41'= 0),"", Z41/$ M41) = IF( AQ42'="","", AQ42* AP42*$ AK42) = IF( OR( Z42'="", Z42'=" NA",$ M42'="",$ M42'= 0),"", Z42/$ M42) = IF( AQ43'="","", AQ43* AP43*$ AK43) = IF( OR( Z43'="", Z43'=" NA",$ M43'="",$ M43'= 0),"", Z43/$ M43) = IF( AQ44'="","", AQ44* AP44*$ AK44) = IF( OR( Z44'="", Z44'=" NA",$ M44'="",$ M44'= 0),"", Z44/$ M44) = IF( AQ45'="","", AQ45* AP45*$ AK45) = IF( OR( Z45'="", Z45'=" NA",$ M45'="",$ M45'= 0),"", Z45/$ M45) = AVERAGE( AS3: AS45) = SUMPRODUCT( AR3: AR45,$ AQ$ 3:$ AQ$ 45)/ SUM($ AQ$ 3:$ AQ$ 45) = SUMPRODUCT( AS3: AS45,$ AT$ 3:$ AT$ 45)/ SUM($ AT$ 3:$ AT$ 45)

February 14, 2003 48 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B Survey Agency Number 5 Somerset 6 Albany County Sewer District 6 Albany South Plant 7 City of Niagra Falls 10 City of Clearwater ( Marshall Street) 10 Clearwater Northeast 10 Clearwater East 14 City of Hamilton 15 Racine 18 Little Rock Adams Field 18 City of Little Rock, Wastewater Utility 19 Fayetteville 21 South San Francisco ( SBSA) 24 City of Tacoma 24 City of Tacoma, Central Treatment Plant 29 Fox River WRD South Plant 29 Fox River WRD North Plant 29 Rox River WRD West Plant 31 City of Everett 32 Spokane 42 Regional Water Reclamation Facility Medford 44 Madison 48 Raleigh Neuse River 49 Bosie West Bosie WWTP 49 Boise, Lander Street WWTP 51 North Charleston 55 Battle Creek 62 Johnson County Blue Ridge # 1 62 Johnson County Mill Creek 62 Johnson County Mission Township 62 Johnson County Turkey Creek 62 Johnson County Little Bull Creek # 2 62 Johnson County Tomahawk 62 Johnson County Little Bull Creek # 1 62 Johnson County Blue Ridge # 4 66 Hillsborough County Dak Mabry 66 Hillsborough County Eagiles 66 Hillsborough County Falkenburg Road 66 Hillsborough County Northwest Regional 66 Hillsborough County River Oaks 66 Hillsborough County South County 66 Hillsborough County Valvico 66 Hillsborough County Van Dyke AT AU Oulier'= 0 Cost = IF( AS3'="","", IF( AS3> AS$ 46* 2,0, IF( AS3> AN3,0,1))) = IF( AT3'="","", AT3* AS3*$ AK3) = IF( AS4'="","", IF( AS4> AS$ 46* 2,0, IF( AS4> AN4,0,1))) = IF( AT4'="","", AT4* AS4*$ AK4) = IF( AS5'="","", IF( AS5> AS$ 46* 2,0, IF( AS5> AN5,0,1))) = IF( AT5'="","", AT5* AS5*$ AK5) = IF( AS6'="","", IF( AS6> AS$ 46* 2,0, IF( AS6> AN6,0,1))) = IF( AT6'="","", AT6* AS6*$ AK6) = IF( AS7'="","", IF( AS7> AS$ 46* 2,0, IF( AS7> AN7,0,1))) = IF( AT7'="","", AT7* AS7*$ AK7) = IF( AS8'="","", IF( AS8> AS$ 46* 2,0, IF( AS8> AN8,0,1))) = IF( AT8'="","", AT8* AS8*$ AK8) = IF( AS9'="","", IF( AS9> AS$ 46* 2,0, IF( AS9> AN9,0,1))) = IF( AT9'="","", AT9* AS9*$ AK9) = IF( AS10'="","", IF( AS10> AS$ 46* 2,0, IF( AS10> AN10,0,1))) = IF( AT10'="","", AT10* AS10*$ AK10) = IF( AS11'="","", IF( AS11> AS$ 46* 2,0, IF( AS11> AN11,0,1))) = IF( AT11'="","", AT11* AS11*$ AK11) = IF( AS12'="","", IF( AS12> AS$ 46* 2,0, IF( AS12> AN12,0,1))) = IF( AT12'="","", AT12* AS12*$ AK12) = IF( AS13'="","", IF( AS13> AS$ 46* 2,0, IF( AS13> AN13,0,1))) = IF( AT13'="","", AT13* AS13*$ AK13) = IF( AS14'="","", IF( AS14> AS$ 46* 2,0, IF( AS14> AN14,0,1))) = IF( AT14'="","", AT14* AS14*$ AK14) = IF( AS15'="","", IF( AS15> AS$ 46* 2,0, IF( AS15> AN15,0,1))) = IF( AT15'="","", AT15* AS15*$ AK15) = IF( AS16'="","", IF( AS16> AS$ 46* 2,0, IF( AS16> AN16,0,1))) = IF( AT16'="","", AT16* AS16*$ AK16) = IF( AS17'="","", IF( AS17> AS$ 46* 2,0, IF( AS17> AN17,0,1))) = IF( AT17'="","", AT17* AS17*$ AK17) = IF( AS18'="","", IF( AS18> AS$ 46* 2,0, IF( AS18> AN18,0,1))) = IF( AT18'="","", AT18* AS18*$ AK18) = IF( AS19'="","", IF( AS19> AS$ 46* 2,0, IF( AS19> AN19,0,1))) = IF( AT19'="","", AT19* AS19*$ AK19) = IF( AS20'="","", IF( AS20> AS$ 46* 2,0, IF( AS20> AN20,0,1))) = IF( AT20'="","", AT20* AS20*$ AK20) = IF( AS21'="","", IF( AS21> AS$ 46* 2,0, IF( AS21> AN21,0,1))) = IF( AT21'="","", AT21* AS21*$ AK21) = IF( AS22'="","", IF( AS22> AS$ 46* 2,0, IF( AS22> AN22,0,1))) = IF( AT22'="","", AT22* AS22*$ AK22) = IF( AS23'="","", IF( AS23> AS$ 46* 2,0, IF( AS23> AN23,0,1))) = IF( AT23'="","", AT23* AS23*$ AK23) = IF( AS24'="","", IF( AS24> AS$ 46* 2,0, IF( AS24> AN24,0,1))) = IF( AT24'="","", AT24* AS24*$ AK24) = IF( AS25'="","", IF( AS25> AS$ 46* 2,0, IF( AS25> AN25,0,1))) = IF( AT25'="","", AT25* AS25*$ AK25) = IF( AS26'="","", IF( AS26> AS$ 46* 2,0, IF( AS26> AN26,0,1))) = IF( AT26'="","", AT26* AS26*$ AK26) = IF( AS27'="","", IF( AS27> AS$ 46* 2,0, IF( AS27> AN27,0,1))) = IF( AT27'="","", AT27* AS27*$ AK27) = IF( AS28'="","", IF( AS28> AS$ 46* 2,0, IF( AS28> AN28,0,1))) = IF( AT28'="","", AT28* AS28*$ AK28) = IF( AS29'="","", IF( AS29> AS$ 46* 2,0, IF( AS29> AN29,0,1))) = IF( AT29'="","", AT29* AS29*$ AK29) = IF( AS30'="","", IF( AS30> AS$ 46* 2,0, IF( AS30> AN30,0,1))) = IF( AT30'="","", AT30* AS30*$ AK30) = IF( AS31'="","", IF( AS31> AS$ 46* 2,0, IF( AS31> AN31,0,1))) = IF( AT31'="","", AT31* AS31*$ AK31) = IF( AS32'="","", IF( AS32> AS$ 46* 2,0, IF( AS32> AN32,0,1))) = IF( AT32'="","", AT32* AS32*$ AK32) = IF( AS33'="","", IF( AS33> AS$ 46* 2,0, IF( AS33> AN33,0,1))) = IF( AT33'="","", AT33* AS33*$ AK33) = IF( AS34'="","", IF( AS34> AS$ 46* 2,0, IF( AS34> AN34,0,1))) = IF( AT34'="","", AT34* AS34*$ AK34) = IF( AS35'="","", IF( AS35> AS$ 46* 2,0, IF( AS35> AN35,0,1))) = IF( AT35'="","", AT35* AS35*$ AK35) = IF( AS36'="","", IF( AS36> AS$ 46* 2,0, IF( AS36> AN36,0,1))) = IF( AT36'="","", AT36* AS36*$ AK36) = IF( AS37'="","", IF( AS37> AS$ 46* 2,0, IF( AS37> AN37,0,1))) = IF( AT37'="","", AT37* AS37*$ AK37) = IF( AS38'="","", IF( AS38> AS$ 46* 2,0, IF( AS38> AN38,0,1))) = IF( AT38'="","", AT38* AS38*$ AK38) = IF( AS39'="","", IF( AS39> AS$ 46* 2,0, IF( AS39> AN39,0,1))) = IF( AT39'="","", AT39* AS39*$ AK39) = IF( AS40'="","", IF( AS40> AS$ 46* 2,0, IF( AS40> AN40,0,1))) = IF( AT40'="","", AT40* AS40*$ AK40) = IF( AS41'="","", IF( AS41> AS$ 46* 2,0, IF( AS41> AN41,0,1))) = IF( AT41'="","", AT41* AS41*$ AK41) = IF( AS42'="","", IF( AS42> AS$ 46* 2,0, IF( AS42> AN42,0,1))) = IF( AT42'="","", AT42* AS42*$ AK42) = IF( AS43'="","", IF( AS43> AS$ 46* 2,0, IF( AS43> AN43,0,1))) = IF( AT43'="","", AT43* AS43*$ AK43) = IF( AS44'="","", IF( AS44> AS$ 46* 2,0, IF( AS44> AN44,0,1))) = IF( AT44'="","", AT44* AS44*$ AK44) = IF( AS45'="","", IF( AS45> AS$ 46* 2,0, IF( AS45> AN45,0,1))) = IF( AT45'="","", AT45* AS45*$ AK45)

= SUMPRODUCT( AU3: AU45,$ AT$ 3:$ AT$ 45)/ SUM($ AT$ 3:$ AT$ 45)

February 14, 2003 49 of 82 MPM COSTS EPA formula. xls  10 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 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 1 Monroe County NY 90.0 35 18 0 2 3 12 0 0 = SUM( F3: L3) 1 Monroe County Northwest Qusdrent NY 12.0 0 0 0 0 0 0 0 0 = SUM( F4: L4) 2 Metro Wastewater Reclamation District CO 160.0 11,565 9 0 0 458 14 2 102 = SUM( F5: L5) 8 Providence Fields Point WWTP RI 45.5 674 15 1 37 373 41 1 0 = SUM( F6: L6) 8 Providence Bucklin Point WWTF RI 23.9 344 9 2 26 187 14 1 0 = SUM( F7: L7) 9 Broward County FL 66.0 41 14 3 3 0 10 4 0 = SUM( F8: L8) 11 NYC Port Richmond NY 31.0 290 25 27 62 475 263 0 25 = SUM( F9: L9) 11 NYC Red Hook NY 30.0 11 NYC Oakwood Beach NY 25.3 11 NYC NTC Rockaway NY 20.0 11 NYC East NY 2.3 11 NYC Newton Creek NY 216.0 11 NYC Wards Island NY 184.0 11 NYC North River NY 128.0 11 NYC Hunts Point NY 118.0 11 NYC Bowery Bay NY 108.0 11 NYC Owls Head NY 101.0 11 NYC Coney Island NY 93.0 11 NYC Jamacia NY 78.0 11 NYC 26th Ward NY 58.0 11 NYC Tallman Island NY 54.0 12 MS D Little Miami OH 27.0 33 5 0 6 0 2 0 0 = SUM( F24: L24) 12 Cincinnati Muddy Creek OH 12.0 6 1 0 0 0 1 1 0 = SUM( F25: L25) 12 Cincinnati Sycamore Creek OH 3.0 7 2 0 0 0 0 0 0 = SUM( F26: L26) 12 Cincinnati Mill Creek OH 140.0 188 17 0 29 0 13 4 0 = SUM( F27: L27) 17 Birmingham Valley Creek AL 35.4 12 2 2 0 0 0 0 0 = SUM( F28: L28) 17 Birmingham Village Creek AL 33.5 15 3 0 0 0 0 0 0 = SUM( F29: L29) 17 Birmingham Five Mile Creek AL 12.3 14 4 0 0 0 0 0 2 = SUM( F30: L30) 17 Birmingham Cahaba River AL 8.9 0 0 0 0 0 0 0 0 = SUM( F31: L31) 17 Birmingham Turkey Creek AL 4.2 0 0 0 0 0 0 0 0 = SUM( F32: L32) 17 Birmingham Trussville AL 1.9 1 1 0 0 0 0 0 0 = SUM( F33: L33) 17 Birmingham Leeds AL 0.9 1 1 0 0 0 0 0 0 = SUM( F34: L34) 17 Birmingham Prudes Creek AL 0.4 0 0 0 0 0 0 0 0 = SUM( F35: L35) 17 Birmingham Warrior AL 0.1 0 0 0 0 0 0 0 0 = SUM( F36: L36) 20 LA County Joint WPCP CA 334.1 1896 47 17 11 0 231 13 0 = SUM( F37: L37) 20 LA Los Coyotes WRP CA 34.4 216 10 0 0 0 42 0 0 = SUM( F38: L38) 20 LA Long Beach WRP CA 18.8 28 1 0 0 0 4 0 0 = SUM( F39: L39) 20 LA Valencia WRP CA 11.2 54 1 0 3 0 9 0 0 = SUM( F40: L40) 20 LA Pomona WRP CA 10.7 77 1 0 0 0 5 0 0 = SUM( F41: L41) 20 LA Lancaster WRP CA 9.2 22 1 0 3 0 3 0 0 = SUM( F42: L42) 20 LA Palmdale WRP CA 8.3 10 2 0 0 0 0 0 0 = SUM( F43: L43) 20 LA Whittier Narrows WRP CA 7.6 246 9 0 2 0 36 2 0 = SUM( F44: L44) 20 LA Saugus WRP CA 5.5 13 0 1 1 0 0 0 0 = SUM( F45: L45) 20 LA San Jose Creek WRP CA 92.9 351 13 3 1 0 48 1 0 = SUM( F46: L46) 22 Chino Basin Municipal Water District CA NA 1200 1 1 0 0 2 0 0 = SUM( F47: L47) 23 IEUA Regional Plant # 1 CA 38.8 = SUM( F48: L48) 23 Fontana Carbon Cayon Water Reclamation CA 8.8 = SUM( F49: L49) 23 Fontana Regional Plant # 2 CA 3.9 = SUM( F50: L50) 23 Fontana Regional Plant # 4 CA 3.8 = SUM( F51: L51) 25 Dallas Water Utilities ( Central) TX 155.5 129 24 12 0 0 5 0 0 = SUM( F52: L52) 25 Dallas Southside WWTP TX 87.0 = SUM( F53: L53) 27 Virginia Beach VIP VA 27.6 17 1 0 10 0 1 4 1 = SUM( F54: L54) 27 Virginia Beach Atlantic VA 27.5 16 1 0 3 0 0 3 9 = SUM( F55: L55) 27 Virginia Beach Nansemond VA 17.2 8 0 0 2 0 1 3 2 = SUM( F56: L56) 27 Virginia Beach Chesapeake  Elizabeth VA 16.9 7 0 0 2 1 0 2 2 = SUM( F57: L57) 27 Virginia Beach Williamsburg VA 14.0 12 2 0 3 0 2 4 1 = SUM( F58: L58) 27 Virginia Beach James River VA 13.1 13 1 0 6 0 0 0 6 = SUM( F59: L59) Categorical GM Non Cat. G M # of Non Cat. Oily Waste February 14, 2003 50 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River N O P Q R S T U V W Implement Yearly Implement Yearly Hourly Salary Overhead factor Implement Yearly Implement 641 187 = N3* R3*( 1+ T3) = O3* R3*( 1+ T3) $ 19.00 $ 26.00 0.33 $ 1,600.00 $ 1,600.00 $ 960.00 N/ A N/ A $ 19.00 $ 26.00 0.33 15,837 2,091 = N5* R5*( 1+ T5) = O5* R5*( 1+ T5) $ 23.77 $ 40.00 0.45 $ 3,000,000.00 $ 3,000,000.00 $ 850,000.00 8,161 1,459 = N6* R6*( 1+ T6) = O6* R6*( 1+ T6) $ 20.00 $ 35.00 0.5 $ 480,000.00 $ 480,000.00 $ 350,000.00 5,640 1,227 = N8* R8*( 1+ T8) = O8* R8*( 1+ T8) $ 20.00 $ 30.00 0.3 $ 20,000.00 $ 20,000.00 $ 2,500.00 29,487 17,956 = N9* R9*( 1+ T9) = O9* R9*( 1+ T9) $ 22.13 $ 38.50 $ 150,000.00 1,247 965 = N24* R24*( 1+ T24) = O24* R24*( 1+ T24) $ 20.00 $ 25.00 0.33 $ 162,000.00 $ 162,000.00 $ 388,800.00 730 330 = N28* R28*( 1+ T28) = O28* R28*( 1+ T28) $ 15.00 $ 26.00 0.4 $ 31,500.00 $ 21,000.00 $ 3,600.00 = 78* 521 = 521* 45 = N37* R37*( 1+ T37) = O37* R37*( 1+ T37) $ 50.00 $ 60.00 0.46 $ 165,000.00 $ 173,250.00 $ 99,000.00 101 38 = N47* R47*( 1+ T47) = O47* R47*( 1+ T47) $ 14.00 $ 24.00 0.4 $ 1,200.00 $ 4,800.00 $ 480.00 $ 0 $ 0 $ 50.00 $ 75.00 0.5 = N49* R49*( 1+ T49) = O49* R49*( 1+ T49) = N50* R50*( 1+ T50) = O50* R50*( 1+ T50) = N51* R51*( 1+ T51) = O51* R51*( 1+ T51) 2,060 1,115 = N52* R52*( 1+ T52) = O52* R52*( 1+ T52) $ 18.00 $ 21.00 0.2 $ 130,000.00 $ 130,000.00 $ 40,000.00 1,457 1,015 = N54* R54*( 1+ T54) = O54* R54*( 1+ T54) $ 15.40 $ 29.73 0.6331 $ 284,188.00 $ 294,912.00 $ 79,977.00 Total Permitting  Labor Hrs Permitting  Costs Labor Rate Analytical Costs Sampling Costs February 14, 2003 51 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River X Y Z AA AB AC AD Yearly Implement Yearly Implement Yearly Implement Yearly $ 960.00 1,441 587 = Y3* S3*( 1+ T3) = Z3* S3*( 1+ T3) = P3+ U3+ W3+ AA3 = Q3+ V3+ X3+ AB3 $ 850,000.00 3,500 1,000 = Y5* S5*( 1+ T5) = Z5* S5*( 1+ T5) = P5+ U5+ W5+ AA5 = Q5+ V5+ X5+ AB5 $ 275,000.00 100 100 = Y6* S6*( 1+ T6) = Z6* S6*( 1+ T6) = P6+ U6+ W6+ AA6 = Q6+ V6+ X6+ AB6 $ 2,500.00 2,400 100 = Y8* S8*( 1+ T8) = Z8* S8*( 1+ T8) = P8+ U8+ W8+ AA8 = Q8+ V8+ X8+ AB8 $ 300,000.00 = Y9* S9*( 1+ T9) = Z9* S9*( 1+ T9) = P9+ U9+ W9+ AA9 = Q9+ V9+ X9+ AB9 $ 388,800.00 1,247 965 = Y24* S24*( 1+ T24) = Z24* S24*( 1+ T24) = P24+ U24+ W24+ AA24 = Q24+ V24+ X24+ AB24 $ 1,800.00 700 400 = Y28* S28*( 1+ T28) = Z28* S28*( 1+ T28) = P28+ U28+ W28+ AA28 = Q28+ V28+ X28+ AB28 $ 103,950.00 104 78 = Y37* S37*( 1+ T37) = Z37* S37*( 1+ T37) = P37+ U37+ W37+ AA37 = Q37+ V37+ X37+ AB37 $ 1,920.00 80 20 = Y47* S47*( 1+ T47) = Z47* S47*( 1+ T47) = P47+ U47+ W47+ AA47 = Q47+ V47+ X47+ AB47 $ 40,000.00 250 50 = Y52* S52*( 1+ T52) = Z52* S52*( 1+ T52) = P52+ U52+ W52+ AA52 = Q52+ V52+ X52+ AB52 $ 82,995.00 544 360 = Y54* S54*( 1+ T54) = Z54* S54*( 1+ T54) = P54+ U54+ W54+ AA54 = Q54+ V54+ X54+ AB54 Sampling Costs Management Salary Hrs Management Overhead Costs Total Costs February 14, 2003 52 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River AE AF Implement Yearly = P3/ M3 = Q3/ M3 = P5/ M5 = Q5/ M5 = P6/ 707 = Q6/ 707 = P8/ M8 = Q8/ M8 = P9/ M9 = Q9/ M9 = P24/ 81 = Q24/ 81 = P28/ 15 = Q28/ 15 = P37/ 521 = Q37/ 521 = P47/ M47 = Q47/ M47 = P52/ M52 = Q52/ M52 = P54/ 106 = Q54/ 106 Permitting Costs Per Facility February 14, 2003 53 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River AG AH AI Implement Yearly MP& M Sites per Program = AC3/ M3 = AD3/ M3 = IF( OR( A3'= A2, M3'=""),"", SUMIF($ A$ 3:$ A$ 120, A3,$ M$ 3:$ M$ 120)) = IF( OR( A4'= A3, M4'=""),"", SUMIF($ A$ 3:$ A$ 120, A4,$ M$ 3:$ M$ 120)) = AC5/ M5 = AD5/ M5 = IF( OR( A5'= A4, M5'=""),"", SUMIF($ A$ 3:$ A$ 120, A5,$ M$ 3:$ M$ 120)) = AC6/ 707 = AD6/ 707 = IF( OR( A6'= A5, M6'=""),"", SUMIF($ A$ 3:$ A$ 120, A6,$ M$ 3:$ M$ 120)) = IF( OR( A7'= A6, M7'=""),"", SUMIF($ A$ 3:$ A$ 120, A7,$ M$ 3:$ M$ 120)) = AC8/ M8 = AD8/ M8 = IF( OR( A8'= A7, M8'=""),"", SUMIF($ A$ 3:$ A$ 120, A8,$ M$ 3:$ M$ 120)) = AC9/ M9 = AD9/ M9 = IF( OR( A9'= A8, M9'=""),"", SUMIF($ A$ 3:$ A$ 120, A9,$ M$ 3:$ M$ 120)) = IF( OR( A10'= A9, M10'=""),"", SUMIF($ A$ 3:$ A$ 120, A10,$ M$ 3:$ M$ 120)) = IF( OR( A11'= A10, M11'=""),"", SUMIF($ A$ 3:$ A$ 120, A11,$ M$ 3:$ M$ 120)) = IF( OR( A12'= A11, M12'=""),"", SUMIF($ A$ 3:$ A$ 120, A12,$ M$ 3:$ M$ 120)) = IF( OR( A13'= A12, M13'=""),"", SUMIF($ A$ 3:$ A$ 120, A13,$ M$ 3:$ M$ 120)) = IF( OR( A14'= A13, M14'=""),"", SUMIF($ A$ 3:$ A$ 120, A14,$ M$ 3:$ M$ 120)) = IF( OR( A15'= A14, M15'=""),"", SUMIF($ A$ 3:$ A$ 120, A15,$ M$ 3:$ M$ 120)) = IF( OR( A16'= A15, M16'=""),"", SUMIF($ A$ 3:$ A$ 120, A16,$ M$ 3:$ M$ 120)) = IF( OR( A17'= A16, M17'=""),"", SUMIF($ A$ 3:$ A$ 120, A17,$ M$ 3:$ M$ 120)) = IF( OR( A18'= A17, M18'=""),"", SUMIF($ A$ 3:$ A$ 120, A18,$ M$ 3:$ M$ 120)) = IF( OR( A19'= A18, M19'=""),"", SUMIF($ A$ 3:$ A$ 120, A19,$ M$ 3:$ M$ 120)) = IF( OR( A20'= A19, M20'=""),"", SUMIF($ A$ 3:$ A$ 120, A20,$ M$ 3:$ M$ 120)) = IF( OR( A21'= A20, M21'=""),"", SUMIF($ A$ 3:$ A$ 120, A21,$ M$ 3:$ M$ 120)) = IF( OR( A22'= A21, M22'=""),"", SUMIF($ A$ 3:$ A$ 120, A22,$ M$ 3:$ M$ 120)) = IF( OR( A23'= A22, M23'=""),"", SUMIF($ A$ 3:$ A$ 120, A23,$ M$ 3:$ M$ 120)) = AC24/ 81 = AD24/ 81 = IF( OR( A24'= A23, M24'=""),"", SUMIF($ A$ 3:$ A$ 120, A24,$ M$ 3:$ M$ 120)) = IF( OR( A25'= A24, M25'=""),"", SUMIF($ A$ 3:$ A$ 120, A25,$ M$ 3:$ M$ 120)) = IF( OR( A26'= A25, M26'=""),"", SUMIF($ A$ 3:$ A$ 120, A26,$ M$ 3:$ M$ 120)) = IF( OR( A27'= A26, M27'=""),"", SUMIF($ A$ 3:$ A$ 120, A27,$ M$ 3:$ M$ 120)) = AC28/ 15 = AD28/ 15 = IF( OR( A28'= A27, M28'=""),"", SUMIF($ A$ 3:$ A$ 120, A28,$ M$ 3:$ M$ 120)) = IF( OR( A29'= A28, M29'=""),"", SUMIF($ A$ 3:$ A$ 120, A29,$ M$ 3:$ M$ 120)) = IF( OR( A30'= A29, M30'=""),"", SUMIF($ A$ 3:$ A$ 120, A30,$ M$ 3:$ M$ 120)) = IF( OR( A31'= A30, M31'=""),"", SUMIF($ A$ 3:$ A$ 120, A31,$ M$ 3:$ M$ 120)) = IF( OR( A32'= A31, M32'=""),"", SUMIF($ A$ 3:$ A$ 120, A32,$ M$ 3:$ M$ 120)) = IF( OR( A33'= A32, M33'=""),"", SUMIF($ A$ 3:$ A$ 120, A33,$ M$ 3:$ M$ 120)) = IF( OR( A34'= A33, M34'=""),"", SUMIF($ A$ 3:$ A$ 120, A34,$ M$ 3:$ M$ 120)) = IF( OR( A35'= A34, M35'=""),"", SUMIF($ A$ 3:$ A$ 120, A35,$ M$ 3:$ M$ 120)) = IF( OR( A36'= A35, M36'=""),"", SUMIF($ A$ 3:$ A$ 120, A36,$ M$ 3:$ M$ 120)) = AC37/ 521 = AD37/ 521 = IF( OR( A37'= A36, M37'=""),"", SUMIF($ A$ 3:$ A$ 120, A37,$ M$ 3:$ M$ 120)) = IF( OR( A38'= A37, M38'=""),"", SUMIF($ A$ 3:$ A$ 120, A38,$ M$ 3:$ M$ 120)) = IF( OR( A39'= A38, M39'=""),"", SUMIF($ A$ 3:$ A$ 120, A39,$ M$ 3:$ M$ 120)) = IF( OR( A40'= A39, M40'=""),"", SUMIF($ A$ 3:$ A$ 120, A40,$ M$ 3:$ M$ 120)) = IF( OR( A41'= A40, M41'=""),"", SUMIF($ A$ 3:$ A$ 120, A41,$ M$ 3:$ M$ 120)) = IF( OR( A42'= A41, M42'=""),"", SUMIF($ A$ 3:$ A$ 120, A42,$ M$ 3:$ M$ 120)) = IF( OR( A43'= A42, M43'=""),"", SUMIF($ A$ 3:$ A$ 120, A43,$ M$ 3:$ M$ 120)) = IF( OR( A44'= A43, M44'=""),"", SUMIF($ A$ 3:$ A$ 120, A44,$ M$ 3:$ M$ 120)) = IF( OR( A45'= A44, M45'=""),"", SUMIF($ A$ 3:$ A$ 120, A45,$ M$ 3:$ M$ 120)) = IF( OR( A46'= A45, M46'=""),"", SUMIF($ A$ 3:$ A$ 120, A46,$ M$ 3:$ M$ 120)) = AC47/ M47 = AD47/ M47 = IF( OR( A47'= A46, M47'=""),"", SUMIF($ A$ 3:$ A$ 120, A47,$ M$ 3:$ M$ 120)) = IF( OR( A48'= A47, M48'=""),"", SUMIF($ A$ 3:$ A$ 120, A48,$ M$ 3:$ M$ 120)) = IF( OR( A49'= A48, M49'=""),"", SUMIF($ A$ 3:$ A$ 120, A49,$ M$ 3:$ M$ 120)) = IF( OR( A50'= A49, M50'=""),"", SUMIF($ A$ 3:$ A$ 120, A50,$ M$ 3:$ M$ 120)) = IF( OR( A51'= A50, M51'=""),"", SUMIF($ A$ 3:$ A$ 120, A51,$ M$ 3:$ M$ 120)) = AC52/ M52 = AD52/ M52 = IF( OR( A52'= A51, M52'=""),"", SUMIF($ A$ 3:$ A$ 120, A52,$ M$ 3:$ M$ 120)) = IF( OR( A53'= A52, M53'=""),"", SUMIF($ A$ 3:$ A$ 120, A53,$ M$ 3:$ M$ 120)) = AC54/ 106 = AD54/ 106 = IF( OR( A54'= A53, M54'=""),"", SUMIF($ A$ 3:$ A$ 120, A54,$ M$ 3:$ M$ 120)) = IF( OR( A55'= A54, M55'=""),"", SUMIF($ A$ 3:$ A$ 120, A55,$ M$ 3:$ M$ 120)) = IF( OR( A56'= A55, M56'=""),"", SUMIF($ A$ 3:$ A$ 120, A56,$ M$ 3:$ M$ 120)) = IF( OR( A57'= A56, M57'=""),"", SUMIF($ A$ 3:$ A$ 120, A57,$ M$ 3:$ M$ 120)) = IF( OR( A58'= A57, M58'=""),"", SUMIF($ A$ 3:$ A$ 120, A58,$ M$ 3:$ M$ 120)) = IF( OR( A59'= A58, M59'=""),"", SUMIF($ A$ 3:$ A$ 120, A59,$ M$ 3:$ M$ 120)) Total Costs Per Facility February 14, 2003 54 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River AJ AK Loaded Hourly Rate Loaded Salary Rate = IF( OR( R3'="", R3'=" NA"),"", R3*( 1+$ T3)) = IF( OR( S3'="", S3'=" NA"),"", S3*( 1+$ T3)) = IF( OR( R4'="", R4'=" NA"),"", R4*( 1+$ T4)) = IF( OR( S4'="", S4'=" NA"),"", S4*( 1+$ T4)) = IF( OR( R5'="", R5'=" NA"),"", R5*( 1+$ T5)) = IF( OR( S5'="", S5'=" NA"),"", S5*( 1+$ T5)) = IF( OR( R6'="", R6'=" NA"),"", R6*( 1+$ T6)) = IF( OR( S6'="", S6'=" NA"),"", S6*( 1+$ T6)) = IF( OR( R7'="", R7'=" NA"),"", R7*( 1+$ T7)) = IF( OR( S7'="", S7'=" NA"),"", S7*( 1+$ T7)) = IF( OR( R8'="", R8'=" NA"),"", R8*( 1+$ T8)) = IF( OR( S8'="", S8'=" NA"),"", S8*( 1+$ T8)) = IF( OR( R9'="", R9'=" NA"),"", R9*( 1+$ T9)) = IF( OR( S9'="", S9'=" NA"),"", S9*( 1+$ T9)) = IF( OR( R10'="", R10'=" NA"),"", R10*( 1+$ T10)) = IF( OR( S10'="", S10'=" NA"),"", S10*( 1+$ T10)) = IF( OR( R11'="", R11'=" NA"),"", R11*( 1+$ T11)) = IF( OR( S11'="", S11'=" NA"),"", S11*( 1+$ T11)) = IF( OR( R12'="", R12'=" NA"),"", R12*( 1+$ T12)) = IF( OR( S12'="", S12'=" NA"),"", S12*( 1+$ T12)) = IF( OR( R13'="", R13'=" NA"),"", R13*( 1+$ T13)) = IF( OR( S13'="", S13'=" NA"),"", S13*( 1+$ T13)) = IF( OR( R14'="", R14'=" NA"),"", R14*( 1+$ T14)) = IF( OR( S14'="", S14'=" NA"),"", S14*( 1+$ T14)) = IF( OR( R15'="", R15'=" NA"),"", R15*( 1+$ T15)) = IF( OR( S15'="", S15'=" NA"),"", S15*( 1+$ T15)) = IF( OR( R16'="", R16'=" NA"),"", R16*( 1+$ T16)) = IF( OR( S16'="", S16'=" NA"),"", S16*( 1+$ T16)) = IF( OR( R17'="", R17'=" NA"),"", R17*( 1+$ T17)) = IF( OR( S17'="", S17'=" NA"),"", S17*( 1+$ T17)) = IF( OR( R18'="", R18'=" NA"),"", R18*( 1+$ T18)) = IF( OR( S18'="", S18'=" NA"),"", S18*( 1+$ T18)) = IF( OR( R19'="", R19'=" NA"),"", R19*( 1+$ T19)) = IF( OR( S19'="", S19'=" NA"),"", S19*( 1+$ T19)) = IF( OR( R20'="", R20'=" NA"),"", R20*( 1+$ T20)) = IF( OR( S20'="", S20'=" NA"),"", S20*( 1+$ T20)) = IF( OR( R21'="", R21'=" NA"),"", R21*( 1+$ T21)) = IF( OR( S21'="", S21'=" NA"),"", S21*( 1+$ T21)) = IF( OR( R22'="", R22'=" NA"),"", R22*( 1+$ T22)) = IF( OR( S22'="", S22'=" NA"),"", S22*( 1+$ T22)) = IF( OR( R23'="", R23'=" NA"),"", R23*( 1+$ T23)) = IF( OR( S23'="", S23'=" NA"),"", S23*( 1+$ T23)) = IF( OR( R24'="", R24'=" NA"),"", R24*( 1+$ T24)) = IF( OR( S24'="", S24'=" NA"),"", S24*( 1+$ T24)) = IF( OR( R25'="", R25'=" NA"),"", R25*( 1+$ T25)) = IF( OR( S25'="", S25'=" NA"),"", S25*( 1+$ T25)) = IF( OR( R26'="", R26'=" NA"),"", R26*( 1+$ T26)) = IF( OR( S26'="", S26'=" NA"),"", S26*( 1+$ T26)) = IF( OR( R27'="", R27'=" NA"),"", R27*( 1+$ T27)) = IF( OR( S27'="", S27'=" NA"),"", S27*( 1+$ T27)) = IF( OR( R28'="", R28'=" NA"),"", R28*( 1+$ T28)) = IF( OR( S28'="", S28'=" NA"),"", S28*( 1+$ T28)) = IF( OR( R29'="", R29'=" NA"),"", R29*( 1+$ T29)) = IF( OR( S29'="", S29'=" NA"),"", S29*( 1+$ T29)) = IF( OR( R30'="", R30'=" NA"),"", R30*( 1+$ T30)) = IF( OR( S30'="", S30'=" NA"),"", S30*( 1+$ T30)) = IF( OR( R31'="", R31'=" NA"),"", R31*( 1+$ T31)) = IF( OR( S31'="", S31'=" NA"),"", S31*( 1+$ T31)) = IF( OR( R32'="", R32'=" NA"),"", R32*( 1+$ T32)) = IF( OR( S32'="", S32'=" NA"),"", S32*( 1+$ T32)) = IF( OR( R33'="", R33'=" NA"),"", R33*( 1+$ T33)) = IF( OR( S33'="", S33'=" NA"),"", S33*( 1+$ T33)) = IF( OR( R34'="", R34'=" NA"),"", R34*( 1+$ T34)) = IF( OR( S34'="", S34'=" NA"),"", S34*( 1+$ T34)) = IF( OR( R35'="", R35'=" NA"),"", R35*( 1+$ T35)) = IF( OR( S35'="", S35'=" NA"),"", S35*( 1+$ T35)) = IF( OR( R36'="", R36'=" NA"),"", R36*( 1+$ T36)) = IF( OR( S36'="", S36'=" NA"),"", S36*( 1+$ T36)) = IF( OR( R37'="", R37'=" NA"),"", R37*( 1+$ T37)) = IF( OR( S37'="", S37'=" NA"),"", S37*( 1+$ T37)) = IF( OR( R38'="", R38'=" NA"),"", R38*( 1+$ T38)) = IF( OR( S38'="", S38'=" NA"),"", S38*( 1+$ T38)) = IF( OR( R39'="", R39'=" NA"),"", R39*( 1+$ T39)) = IF( OR( S39'="", S39'=" NA"),"", S39*( 1+$ T39)) = IF( OR( R40'="", R40'=" NA"),"", R40*( 1+$ T40)) = IF( OR( S40'="", S40'=" NA"),"", S40*( 1+$ T40)) = IF( OR( R41'="", R41'=" NA"),"", R41*( 1+$ T41)) = IF( OR( S41'="", S41'=" NA"),"", S41*( 1+$ T41)) = IF( OR( R42'="", R42'=" NA"),"", R42*( 1+$ T42)) = IF( OR( S42'="", S42'=" NA"),"", S42*( 1+$ T42)) = IF( OR( R43'="", R43'=" NA"),"", R43*( 1+$ T43)) = IF( OR( S43'="", S43'=" NA"),"", S43*( 1+$ T43)) = IF( OR( R44'="", R44'=" NA"),"", R44*( 1+$ T44)) = IF( OR( S44'="", S44'=" NA"),"", S44*( 1+$ T44)) = IF( OR( R45'="", R45'=" NA"),"", R45*( 1+$ T45)) = IF( OR( S45'="", S45'=" NA"),"", S45*( 1+$ T45)) = IF( OR( R46'="", R46'=" NA"),"", R46*( 1+$ T46)) = IF( OR( S46'="", S46'=" NA"),"", S46*( 1+$ T46)) = IF( OR( R47'="", R47'=" NA"),"", R47*( 1+$ T47)) = IF( OR( S47'="", S47'=" NA"),"", S47*( 1+$ T47)) = IF( OR( R48'="", R48'=" NA"),"", R48*( 1+$ T48)) = IF( OR( S48'="", S48'=" NA"),"", S48*( 1+$ T48)) = IF( OR( R49'="", R49'=" NA"),"", R49*( 1+$ T49)) = IF( OR( S49'="", S49'=" NA"),"", S49*( 1+$ T49)) = IF( OR( R50'="", R50'=" NA"),"", R50*( 1+$ T50)) = IF( OR( S50'="", S50'=" NA"),"", S50*( 1+$ T50)) = IF( OR( R51'="", R51'=" NA"),"", R51*( 1+$ T51)) = IF( OR( S51'="", S51'=" NA"),"", S51*( 1+$ T51)) = IF( OR( R52'="", R52'=" NA"),"", R52*( 1+$ T52)) = IF( OR( S52'="", S52'=" NA"),"", S52*( 1+$ T52)) = IF( OR( R53'="", R53'=" NA"),"", R53*( 1+$ T53)) = IF( OR( S53'="", S53'=" NA"),"", S53*( 1+$ T53)) = IF( OR( R54'="", R54'=" NA"),"", R54*( 1+$ T54)) = IF( OR( S54'="", S54'=" NA"),"", S54*( 1+$ T54)) = IF( OR( R55'="", R55'=" NA"),"", R55*( 1+$ T55)) = IF( OR( S55'="", S55'=" NA"),"", S55*( 1+$ T55)) = IF( OR( R56'="", R56'=" NA"),"", R56*( 1+$ T56)) = IF( OR( S56'="", S56'=" NA"),"", S56*( 1+$ T56)) = IF( OR( R57'="", R57'=" NA"),"", R57*( 1+$ T57)) = IF( OR( S57'="", S57'=" NA"),"", S57*( 1+$ T57)) = IF( OR( R58'="", R58'=" NA"),"", R58*( 1+$ T58)) = IF( OR( S58'="", S58'=" NA"),"", S58*( 1+$ T58)) = IF( OR( R59'="", R59'=" NA"),"", R59*( 1+$ T59)) = IF( OR( S59'="", S59'=" NA"),"", S59*( 1+$ T59))

February 14, 2003 55 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River AL AM Permitting Hrs/ MP& M Site Implement Oulier'= 0 = IF( OR( N3'="",$ M3'="",$ M3'= 0),"", N3/$ M3) = IF( AL3'="","", IF( AL3> AL$ 121* 2,0,1)) = IF( OR( N4'="",$ M4'="",$ M4'= 0),"", N4/$ M4) = IF( AL4'="","", IF( AL4> AL$ 121* 2,0,1)) = IF( OR( N5'="",$ M5'="",$ M5'= 0),"", N5/$ M5) = IF( AL5'="","", IF( AL5> AL$ 121* 2,0,1)) = IF( OR( N6'="",$ M6'="",$ M6'= 0),"", N6/$ M6) = IF( AL6'="","", IF( AL6> AL$ 121* 2,0,1)) = IF( OR( N7'="",$ M7'="",$ M7'= 0),"", N7/$ M7) = IF( AL7'="","", IF( AL7> AL$ 121* 2,0,1)) = IF( OR( N8'="",$ M8'="",$ M8'= 0),"", N8/$ M8) = IF( AL8'="","", IF( AL8> AL$ 121* 2,0,1)) = IF( OR( N9'="",$ M9'="",$ M9'= 0),"", N9/$ M9) = IF( AL9'="","", IF( AL9> AL$ 121* 2,0,1)) = IF( OR( N10'="",$ M10'="",$ M10'= 0),"", N10/$ M10) = IF( AL10'="","", IF( AL10> AL$ 121* 2,0,1)) = IF( OR( N11'="",$ M11'="",$ M11'= 0),"", N11/$ M11) = IF( AL11'="","", IF( AL11> AL$ 121* 2,0,1)) = IF( OR( N12'="",$ M12'="",$ M12'= 0),"", N12/$ M12) = IF( AL12'="","", IF( AL12> AL$ 121* 2,0,1)) = IF( OR( N13'="",$ M13'="",$ M13'= 0),"", N13/$ M13) = IF( AL13'="","", IF( AL13> AL$ 121* 2,0,1)) = IF( OR( N14'="",$ M14'="",$ M14'= 0),"", N14/$ M14) = IF( AL14'="","", IF( AL14> AL$ 121* 2,0,1)) = IF( OR( N15'="",$ M15'="",$ M15'= 0),"", N15/$ M15) = IF( AL15'="","", IF( AL15> AL$ 121* 2,0,1)) = IF( OR( N16'="",$ M16'="",$ M16'= 0),"", N16/$ M16) = IF( AL16'="","", IF( AL16> AL$ 121* 2,0,1)) = IF( OR( N17'="",$ M17'="",$ M17'= 0),"", N17/$ M17) = IF( AL17'="","", IF( AL17> AL$ 121* 2,0,1)) = IF( OR( N18'="",$ M18'="",$ M18'= 0),"", N18/$ M18) = IF( AL18'="","", IF( AL18> AL$ 121* 2,0,1)) = IF( OR( N19'="",$ M19'="",$ M19'= 0),"", N19/$ M19) = IF( AL19'="","", IF( AL19> AL$ 121* 2,0,1)) = IF( OR( N20'="",$ M20'="",$ M20'= 0),"", N20/$ M20) = IF( AL20'="","", IF( AL20> AL$ 121* 2,0,1)) = IF( OR( N21'="",$ M21'="",$ M21'= 0),"", N21/$ M21) = IF( AL21'="","", IF( AL21> AL$ 121* 2,0,1)) = IF( OR( N22'="",$ M22'="",$ M22'= 0),"", N22/$ M22) = IF( AL22'="","", IF( AL22> AL$ 121* 2,0,1)) = IF( OR( N23'="",$ M23'="",$ M23'= 0),"", N23/$ M23) = IF( AL23'="","", IF( AL23> AL$ 121* 2,0,1)) = IF( OR( N24'="",$ M24'="",$ M24'= 0),"", N24/$ M24) = IF( AL24'="","", IF( AL24> AL$ 121* 2,0,1)) = IF( OR( N25'="",$ M25'="",$ M25'= 0),"", N25/$ M25) = IF( AL25'="","", IF( AL25> AL$ 121* 2,0,1)) = IF( OR( N26'="",$ M26'="",$ M26'= 0),"", N26/$ M26) = IF( AL26'="","", IF( AL26> AL$ 121* 2,0,1)) = IF( OR( N27'="",$ M27'="",$ M27'= 0),"", N27/$ M27) = IF( AL27'="","", IF( AL27> AL$ 121* 2,0,1)) = IF( OR( N28'="",$ M28'="",$ M28'= 0),"", N28/$ M28) = IF( AL28'="","", IF( AL28> AL$ 121* 2,0,1)) = IF( OR( N29'="",$ M29'="",$ M29'= 0),"", N29/$ M29) = IF( AL29'="","", IF( AL29> AL$ 121* 2,0,1)) = IF( OR( N30'="",$ M30'="",$ M30'= 0),"", N30/$ M30) = IF( AL30'="","", IF( AL30> AL$ 121* 2,0,1)) = IF( OR( N31'="",$ M31'="",$ M31'= 0),"", N31/$ M31) = IF( AL31'="","", IF( AL31> AL$ 121* 2,0,1)) = IF( OR( N32'="",$ M32'="",$ M32'= 0),"", N32/$ M32) = IF( AL32'="","", IF( AL32> AL$ 121* 2,0,1)) = IF( OR( N33'="",$ M33'="",$ M33'= 0),"", N33/$ M33) = IF( AL33'="","", IF( AL33> AL$ 121* 2,0,1)) = IF( OR( N34'="",$ M34'="",$ M34'= 0),"", N34/$ M34) = IF( AL34'="","", IF( AL34> AL$ 121* 2,0,1)) = IF( OR( N35'="",$ M35'="",$ M35'= 0),"", N35/$ M35) = IF( AL35'="","", IF( AL35> AL$ 121* 2,0,1)) = IF( OR( N36'="",$ M36'="",$ M36'= 0),"", N36/$ M36) = IF( AL36'="","", IF( AL36> AL$ 121* 2,0,1)) = IF( OR( N37'="",$ M37'="",$ M37'= 0),"", N37/$ M37) = IF( AL37'="","", IF( AL37> AL$ 121* 2,0,1)) = IF( OR( N38'="",$ M38'="",$ M38'= 0),"", N38/$ M38) = IF( AL38'="","", IF( AL38> AL$ 121* 2,0,1)) = IF( OR( N39'="",$ M39'="",$ M39'= 0),"", N39/$ M39) = IF( AL39'="","", IF( AL39> AL$ 121* 2,0,1)) = IF( OR( N40'="",$ M40'="",$ M40'= 0),"", N40/$ M40) = IF( AL40'="","", IF( AL40> AL$ 121* 2,0,1)) = IF( OR( N41'="",$ M41'="",$ M41'= 0),"", N41/$ M41) = IF( AL41'="","", IF( AL41> AL$ 121* 2,0,1)) = IF( OR( N42'="",$ M42'="",$ M42'= 0),"", N42/$ M42) = IF( AL42'="","", IF( AL42> AL$ 121* 2,0,1)) = IF( OR( N43'="",$ M43'="",$ M43'= 0),"", N43/$ M43) = IF( AL43'="","", IF( AL43> AL$ 121* 2,0,1)) = IF( OR( N44'="",$ M44'="",$ M44'= 0),"", N44/$ M44) = IF( AL44'="","", IF( AL44> AL$ 121* 2,0,1)) = IF( OR( N45'="",$ M45'="",$ M45'= 0),"", N45/$ M45) = IF( AL45'="","", IF( AL45> AL$ 121* 2,0,1)) = IF( OR( N46'="",$ M46'="",$ M46'= 0),"", N46/$ M46) = IF( AL46'="","", IF( AL46> AL$ 121* 2,0,1)) = IF( OR( N47'="",$ M47'="",$ M47'= 0),"", N47/$ M47) = IF( AL47'="","", IF( AL47> AL$ 121* 2,0,1)) = IF( OR( N48'="",$ M48'="",$ M48'= 0),"", N48/$ M48) = IF( AL48'="","", IF( AL48> AL$ 121* 2,0,1)) = IF( OR( N49'="",$ M49'="",$ M49'= 0),"", N49/$ M49) = IF( AL49'="","", IF( AL49> AL$ 121* 2,0,1)) = IF( OR( N50'="",$ M50'="",$ M50'= 0),"", N50/$ M50) = IF( AL50'="","", IF( AL50> AL$ 121* 2,0,1)) = IF( OR( N51'="",$ M51'="",$ M51'= 0),"", N51/$ M51) = IF( AL51'="","", IF( AL51> AL$ 121* 2,0,1)) = IF( OR( N52'="",$ M52'="",$ M52'= 0),"", N52/$ M52) = IF( AL52'="","", IF( AL52> AL$ 121* 2,0,1)) = IF( OR( N53'="",$ M53'="",$ M53'= 0),"", N53/$ M53) = IF( AL53'="","", IF( AL53> AL$ 121* 2,0,1)) = IF( OR( N54'="",$ M54'="",$ M54'= 0),"", N54/$ M54) = IF( AL54'="","", IF( AL54> AL$ 121* 2,0,1)) = IF( OR( N55'="",$ M55'="",$ M55'= 0),"", N55/$ M55) = IF( AL55'="","", IF( AL55> AL$ 121* 2,0,1)) = IF( OR( N56'="",$ M56'="",$ M56'= 0),"", N56/$ M56) = IF( AL56'="","", IF( AL56> AL$ 121* 2,0,1)) = IF( OR( N57'="",$ M57'="",$ M57'= 0),"", N57/$ M57) = IF( AL57'="","", IF( AL57> AL$ 121* 2,0,1)) = IF( OR( N58'="",$ M58'="",$ M58'= 0),"", N58/$ M58) = IF( AL58'="","", IF( AL58> AL$ 121* 2,0,1)) = IF( OR( N59'="",$ M59'="",$ M59'= 0),"", N59/$ M59) = IF( AL59'="","", IF( AL59> AL$ 121* 2,0,1))

February 14, 2003 56 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River AN AO Permitting Hrs/ MP& M Site Yearly Oulier'= 0 = IF( OR( O3'="",$ M3'="",$ M3'= 0),"", O3/$ M3) = IF( AN3'="","", IF( AN3> AN$ 121* 2,0,1)) = IF( OR( O4'="",$ M4'="",$ M4'= 0),"", O4/$ M4) = IF( AN4'="","", IF( AN4> AN$ 121* 2,0,1)) = IF( OR( O5'="",$ M5'="",$ M5'= 0),"", O5/$ M5) = IF( AN5'="","", IF( AN5> AN$ 121* 2,0,1)) = IF( OR( O6'="",$ M6'="",$ M6'= 0),"", O6/$ M6) = IF( AN6'="","", IF( AN6> AN$ 121* 2,0,1)) = IF( OR( O7'="",$ M7'="",$ M7'= 0),"", O7/$ M7) = IF( AN7'="","", IF( AN7> AN$ 121* 2,0,1)) = IF( OR( O8'="",$ M8'="",$ M8'= 0),"", O8/$ M8) = IF( AN8'="","", IF( AN8> AN$ 121* 2,0,1)) = IF( OR( O9'="",$ M9'="",$ M9'= 0),"", O9/$ M9) = IF( AN9'="","", IF( AN9> AN$ 121* 2,0,1)) = IF( OR( O10'="",$ M10'="",$ M10'= 0),"", O10/$ M10) = IF( AN10'="","", IF( AN10> AN$ 121* 2,0,1)) = IF( OR( O11'="",$ M11'="",$ M11'= 0),"", O11/$ M11) = IF( AN11'="","", IF( AN11> AN$ 121* 2,0,1)) = IF( OR( O12'="",$ M12'="",$ M12'= 0),"", O12/$ M12) = IF( AN12'="","", IF( AN12> AN$ 121* 2,0,1)) = IF( OR( O13'="",$ M13'="",$ M13'= 0),"", O13/$ M13) = IF( AN13'="","", IF( AN13> AN$ 121* 2,0,1)) = IF( OR( O14'="",$ M14'="",$ M14'= 0),"", O14/$ M14) = IF( AN14'="","", IF( AN14> AN$ 121* 2,0,1)) = IF( OR( O15'="",$ M15'="",$ M15'= 0),"", O15/$ M15) = IF( AN15'="","", IF( AN15> AN$ 121* 2,0,1)) = IF( OR( O16'="",$ M16'="",$ M16'= 0),"", O16/$ M16) = IF( AN16'="","", IF( AN16> AN$ 121* 2,0,1)) = IF( OR( O17'="",$ M17'="",$ M17'= 0),"", O17/$ M17) = IF( AN17'="","", IF( AN17> AN$ 121* 2,0,1)) = IF( OR( O18'="",$ M18'="",$ M18'= 0),"", O18/$ M18) = IF( AN18'="","", IF( AN18> AN$ 121* 2,0,1)) = IF( OR( O19'="",$ M19'="",$ M19'= 0),"", O19/$ M19) = IF( AN19'="","", IF( AN19> AN$ 121* 2,0,1)) = IF( OR( O20'="",$ M20'="",$ M20'= 0),"", O20/$ M20) = IF( AN20'="","", IF( AN20> AN$ 121* 2,0,1)) = IF( OR( O21'="",$ M21'="",$ M21'= 0),"", O21/$ M21) = IF( AN21'="","", IF( AN21> AN$ 121* 2,0,1)) = IF( OR( O22'="",$ M22'="",$ M22'= 0),"", O22/$ M22) = IF( AN22'="","", IF( AN22> AN$ 121* 2,0,1)) = IF( OR( O23'="",$ M23'="",$ M23'= 0),"", O23/$ M23) = IF( AN23'="","", IF( AN23> AN$ 121* 2,0,1)) = IF( OR( O24'="",$ M24'="",$ M24'= 0),"", O24/$ M24) = IF( AN24'="","", IF( AN24> AN$ 121* 2,0,1)) = IF( OR( O25'="",$ M25'="",$ M25'= 0),"", O25/$ M25) = IF( AN25'="","", IF( AN25> AN$ 121* 2,0,1)) = IF( OR( O26'="",$ M26'="",$ M26'= 0),"", O26/$ M26) = IF( AN26'="","", IF( AN26> AN$ 121* 2,0,1)) = IF( OR( O27'="",$ M27'="",$ M27'= 0),"", O27/$ M27) = IF( AN27'="","", IF( AN27> AN$ 121* 2,0,1)) = IF( OR( O28'="",$ M28'="",$ M28'= 0),"", O28/$ M28) = IF( AN28'="","", IF( AN28> AN$ 121* 2,0,1)) = IF( OR( O29'="",$ M29'="",$ M29'= 0),"", O29/$ M29) = IF( AN29'="","", IF( AN29> AN$ 121* 2,0,1)) = IF( OR( O30'="",$ M30'="",$ M30'= 0),"", O30/$ M30) = IF( AN30'="","", IF( AN30> AN$ 121* 2,0,1)) = IF( OR( O31'="",$ M31'="",$ M31'= 0),"", O31/$ M31) = IF( AN31'="","", IF( AN31> AN$ 121* 2,0,1)) = IF( OR( O32'="",$ M32'="",$ M32'= 0),"", O32/$ M32) = IF( AN32'="","", IF( AN32> AN$ 121* 2,0,1)) = IF( OR( O33'="",$ M33'="",$ M33'= 0),"", O33/$ M33) = IF( AN33'="","", IF( AN33> AN$ 121* 2,0,1)) = IF( OR( O34'="",$ M34'="",$ M34'= 0),"", O34/$ M34) = IF( AN34'="","", IF( AN34> AN$ 121* 2,0,1)) = IF( OR( O35'="",$ M35'="",$ M35'= 0),"", O35/$ M35) = IF( AN35'="","", IF( AN35> AN$ 121* 2,0,1)) = IF( OR( O36'="",$ M36'="",$ M36'= 0),"", O36/$ M36) = IF( AN36'="","", IF( AN36> AN$ 121* 2,0,1)) = IF( OR( O37'="",$ M37'="",$ M37'= 0),"", O37/$ M37) = IF( AN37'="","", IF( AN37> AN$ 121* 2,0,1)) = IF( OR( O38'="",$ M38'="",$ M38'= 0),"", O38/$ M38) = IF( AN38'="","", IF( AN38> AN$ 121* 2,0,1)) = IF( OR( O39'="",$ M39'="",$ M39'= 0),"", O39/$ M39) = IF( AN39'="","", IF( AN39> AN$ 121* 2,0,1)) = IF( OR( O40'="",$ M40'="",$ M40'= 0),"", O40/$ M40) = IF( AN40'="","", IF( AN40> AN$ 121* 2,0,1)) = IF( OR( O41'="",$ M41'="",$ M41'= 0),"", O41/$ M41) = IF( AN41'="","", IF( AN41> AN$ 121* 2,0,1)) = IF( OR( O42'="",$ M42'="",$ M42'= 0),"", O42/$ M42) = IF( AN42'="","", IF( AN42> AN$ 121* 2,0,1)) = IF( OR( O43'="",$ M43'="",$ M43'= 0),"", O43/$ M43) = IF( AN43'="","", IF( AN43> AN$ 121* 2,0,1)) = IF( OR( O44'="",$ M44'="",$ M44'= 0),"", O44/$ M44) = IF( AN44'="","", IF( AN44> AN$ 121* 2,0,1)) = IF( OR( O45'="",$ M45'="",$ M45'= 0),"", O45/$ M45) = IF( AN45'="","", IF( AN45> AN$ 121* 2,0,1)) = IF( OR( O46'="",$ M46'="",$ M46'= 0),"", O46/$ M46) = IF( AN46'="","", IF( AN46> AN$ 121* 2,0,1)) = IF( OR( O47'="",$ M47'="",$ M47'= 0),"", O47/$ M47) = IF( AN47'="","", IF( AN47> AN$ 121* 2,0,1)) = IF( OR( O48'="",$ M48'="",$ M48'= 0),"", O48/$ M48) = IF( AN48'="","", IF( AN48> AN$ 121* 2,0,1)) = IF( OR( O49'="",$ M49'="",$ M49'= 0),"", O49/$ M49) = IF( AN49'="","", IF( AN49> AN$ 121* 2,0,1)) = IF( OR( O50'="",$ M50'="",$ M50'= 0),"", O50/$ M50) = IF( AN50'="","", IF( AN50> AN$ 121* 2,0,1)) = IF( OR( O51'="",$ M51'="",$ M51'= 0),"", O51/$ M51) = IF( AN51'="","", IF( AN51> AN$ 121* 2,0,1)) = IF( OR( O52'="",$ M52'="",$ M52'= 0),"", O52/$ M52) = IF( AN52'="","", IF( AN52> AN$ 121* 2,0,1)) = IF( OR( O53'="",$ M53'="",$ M53'= 0),"", O53/$ M53) = IF( AN53'="","", IF( AN53> AN$ 121* 2,0,1)) = IF( OR( O54'="",$ M54'="",$ M54'= 0),"", O54/$ M54) = IF( AN54'="","", IF( AN54> AN$ 121* 2,0,1)) = IF( OR( O55'="",$ M55'="",$ M55'= 0),"", O55/$ M55) = IF( AN55'="","", IF( AN55> AN$ 121* 2,0,1)) = IF( OR( O56'="",$ M56'="",$ M56'= 0),"", O56/$ M56) = IF( AN56'="","", IF( AN56> AN$ 121* 2,0,1)) = IF( OR( O57'="",$ M57'="",$ M57'= 0),"", O57/$ M57) = IF( AN57'="","", IF( AN57> AN$ 121* 2,0,1)) = IF( OR( O58'="",$ M58'="",$ M58'= 0),"", O58/$ M58) = IF( AN58'="","", IF( AN58> AN$ 121* 2,0,1)) = IF( OR( O59'="",$ M59'="",$ M59'= 0),"", O59/$ M59) = IF( AN59'="","", IF( AN59> AN$ 121* 2,0,1))

February 14, 2003 57 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River AP AQ Implement Oulier'= 0 = IF( OR( Y3'="", Y3'=" NA",$ M3'="",$ M3'= 0),"", Y3/$ M3) = IF( AP3'="","", IF( AP3> AP$ 121* 2,0, IF( AP3> AL3,0,1))) = IF( OR( Y4'="", Y4'=" NA",$ M4'="",$ M4'= 0),"", Y4/$ M4) = IF( AP4'="","", IF( AP4> AP$ 121* 2,0, IF( AP4> AL4,0,1))) = IF( OR( Y5'="", Y5'=" NA",$ M5'="",$ M5'= 0),"", Y5/$ M5) = IF( AP5'="","", IF( AP5> AP$ 121* 2,0, IF( AP5> AL5,0,1))) = IF( OR( Y6'="", Y6'=" NA",$ M6'="",$ M6'= 0),"", Y6/$ M6) = IF( AP6'="","", IF( AP6> AP$ 121* 2,0, IF( AP6> AL6,0,1))) = IF( OR( Y7'="", Y7'=" NA",$ M7'="",$ M7'= 0),"", Y7/$ M7) = IF( AP7'="","", IF( AP7> AP$ 121* 2,0, IF( AP7> AL7,0,1))) = IF( OR( Y8'="", Y8'=" NA",$ M8'="",$ M8'= 0),"", Y8/$ M8) = IF( AP8'="","", IF( AP8> AP$ 121* 2,0, IF( AP8> AL8,0,1))) = IF( OR( Y9'="", Y9'=" NA",$ M9'="",$ M9'= 0),"", Y9/$ M9) = IF( AP9'="","", IF( AP9> AP$ 121* 2,0, IF( AP9> AL9,0,1))) = IF( OR( Y10'="", Y10'=" NA",$ M10'="",$ M10'= 0),"", Y10/$ M10) = IF( AP10'="","", IF( AP10> AP$ 121* 2,0, IF( AP10> AL10,0,1))) = IF( OR( Y11'="", Y11'=" NA",$ M11'="",$ M11'= 0),"", Y11/$ M11) = IF( AP11'="","", IF( AP11> AP$ 121* 2,0, IF( AP11> AL11,0,1))) = IF( OR( Y12'="", Y12'=" NA",$ M12'="",$ M12'= 0),"", Y12/$ M12) = IF( AP12'="","", IF( AP12> AP$ 121* 2,0, IF( AP12> AL12,0,1))) = IF( OR( Y13'="", Y13'=" NA",$ M13'="",$ M13'= 0),"", Y13/$ M13) = IF( AP13'="","", IF( AP13> AP$ 121* 2,0, IF( AP13> AL13,0,1))) = IF( OR( Y14'="", Y14'=" NA",$ M14'="",$ M14'= 0),"", Y14/$ M14) = IF( AP14'="","", IF( AP14> AP$ 121* 2,0, IF( AP14> AL14,0,1))) = IF( OR( Y15'="", Y15'=" NA",$ M15'="",$ M15'= 0),"", Y15/$ M15) = IF( AP15'="","", IF( AP15> AP$ 121* 2,0, IF( AP15> AL15,0,1))) = IF( OR( Y16'="", Y16'=" NA",$ M16'="",$ M16'= 0),"", Y16/$ M16) = IF( AP16'="","", IF( AP16> AP$ 121* 2,0, IF( AP16> AL16,0,1))) = IF( OR( Y17'="", Y17'=" NA",$ M17'="",$ M17'= 0),"", Y17/$ M17) = IF( AP17'="","", IF( AP17> AP$ 121* 2,0, IF( AP17> AL17,0,1))) = IF( OR( Y18'="", Y18'=" NA",$ M18'="",$ M18'= 0),"", Y18/$ M18) = IF( AP18'="","", IF( AP18> AP$ 121* 2,0, IF( AP18> AL18,0,1))) = IF( OR( Y19'="", Y19'=" NA",$ M19'="",$ M19'= 0),"", Y19/$ M19) = IF( AP19'="","", IF( AP19> AP$ 121* 2,0, IF( AP19> AL19,0,1))) = IF( OR( Y20'="", Y20'=" NA",$ M20'="",$ M20'= 0),"", Y20/$ M20) = IF( AP20'="","", IF( AP20> AP$ 121* 2,0, IF( AP20> AL20,0,1))) = IF( OR( Y21'="", Y21'=" NA",$ M21'="",$ M21'= 0),"", Y21/$ M21) = IF( AP21'="","", IF( AP21> AP$ 121* 2,0, IF( AP21> AL21,0,1))) = IF( OR( Y22'="", Y22'=" NA",$ M22'="",$ M22'= 0),"", Y22/$ M22) = IF( AP22'="","", IF( AP22> AP$ 121* 2,0, IF( AP22> AL22,0,1))) = IF( OR( Y23'="", Y23'=" NA",$ M23'="",$ M23'= 0),"", Y23/$ M23) = IF( AP23'="","", IF( AP23> AP$ 121* 2,0, IF( AP23> AL23,0,1))) = IF( OR( Y24'="", Y24'=" NA",$ M24'="",$ M24'= 0),"", Y24/$ M24) = IF( AP24'="","", IF( AP24> AP$ 121* 2,0, IF( AP24> AL24,0,1))) = IF( OR( Y25'="", Y25'=" NA",$ M25'="",$ M25'= 0),"", Y25/$ M25) = IF( AP25'="","", IF( AP25> AP$ 121* 2,0, IF( AP25> AL25,0,1))) = IF( OR( Y26'="", Y26'=" NA",$ M26'="",$ M26'= 0),"", Y26/$ M26) = IF( AP26'="","", IF( AP26> AP$ 121* 2,0, IF( AP26> AL26,0,1))) = IF( OR( Y27'="", Y27'=" NA",$ M27'="",$ M27'= 0),"", Y27/$ M27) = IF( AP27'="","", IF( AP27> AP$ 121* 2,0, IF( AP27> AL27,0,1))) = IF( OR( Y28'="", Y28'=" NA",$ M28'="",$ M28'= 0),"", Y28/$ M28) = IF( AP28'="","", IF( AP28> AP$ 121* 2,0, IF( AP28> AL28,0,1))) = IF( OR( Y29'="", Y29'=" NA",$ M29'="",$ M29'= 0),"", Y29/$ M29) = IF( AP29'="","", IF( AP29> AP$ 121* 2,0, IF( AP29> AL29,0,1))) = IF( OR( Y30'="", Y30'=" NA",$ M30'="",$ M30'= 0),"", Y30/$ M30) = IF( AP30'="","", IF( AP30> AP$ 121* 2,0, IF( AP30> AL30,0,1))) = IF( OR( Y31'="", Y31'=" NA",$ M31'="",$ M31'= 0),"", Y31/$ M31) = IF( AP31'="","", IF( AP31> AP$ 121* 2,0, IF( AP31> AL31,0,1))) = IF( OR( Y32'="", Y32'=" NA",$ M32'="",$ M32'= 0),"", Y32/$ M32) = IF( AP32'="","", IF( AP32> AP$ 121* 2,0, IF( AP32> AL32,0,1))) = IF( OR( Y33'="", Y33'=" NA",$ M33'="",$ M33'= 0),"", Y33/$ M33) = IF( AP33'="","", IF( AP33> AP$ 121* 2,0, IF( AP33> AL33,0,1))) = IF( OR( Y34'="", Y34'=" NA",$ M34'="",$ M34'= 0),"", Y34/$ M34) = IF( AP34'="","", IF( AP34> AP$ 121* 2,0, IF( AP34> AL34,0,1))) = IF( OR( Y35'="", Y35'=" NA",$ M35'="",$ M35'= 0),"", Y35/$ M35) = IF( AP35'="","", IF( AP35> AP$ 121* 2,0, IF( AP35> AL35,0,1))) = IF( OR( Y36'="", Y36'=" NA",$ M36'="",$ M36'= 0),"", Y36/$ M36) = IF( AP36'="","", IF( AP36> AP$ 121* 2,0, IF( AP36> AL36,0,1))) = IF( OR( Y37'="", Y37'=" NA",$ M37'="",$ M37'= 0),"", Y37/$ M37) = IF( AP37'="","", IF( AP37> AP$ 121* 2,0, IF( AP37> AL37,0,1))) = IF( OR( Y38'="", Y38'=" NA",$ M38'="",$ M38'= 0),"", Y38/$ M38) = IF( AP38'="","", IF( AP38> AP$ 121* 2,0, IF( AP38> AL38,0,1))) = IF( OR( Y39'="", Y39'=" NA",$ M39'="",$ M39'= 0),"", Y39/$ M39) = IF( AP39'="","", IF( AP39> AP$ 121* 2,0, IF( AP39> AL39,0,1))) = IF( OR( Y40'="", Y40'=" NA",$ M40'="",$ M40'= 0),"", Y40/$ M40) = IF( AP40'="","", IF( AP40> AP$ 121* 2,0, IF( AP40> AL40,0,1))) = IF( OR( Y41'="", Y41'=" NA",$ M41'="",$ M41'= 0),"", Y41/$ M41) = IF( AP41'="","", IF( AP41> AP$ 121* 2,0, IF( AP41> AL41,0,1))) = IF( OR( Y42'="", Y42'=" NA",$ M42'="",$ M42'= 0),"", Y42/$ M42) = IF( AP42'="","", IF( AP42> AP$ 121* 2,0, IF( AP42> AL42,0,1))) = IF( OR( Y43'="", Y43'=" NA",$ M43'="",$ M43'= 0),"", Y43/$ M43) = IF( AP43'="","", IF( AP43> AP$ 121* 2,0, IF( AP43> AL43,0,1))) = IF( OR( Y44'="", Y44'=" NA",$ M44'="",$ M44'= 0),"", Y44/$ M44) = IF( AP44'="","", IF( AP44> AP$ 121* 2,0, IF( AP44> AL44,0,1))) = IF( OR( Y45'="", Y45'=" NA",$ M45'="",$ M45'= 0),"", Y45/$ M45) = IF( AP45'="","", IF( AP45> AP$ 121* 2,0, IF( AP45> AL45,0,1))) = IF( OR( Y46'="", Y46'=" NA",$ M46'="",$ M46'= 0),"", Y46/$ M46) = IF( AP46'="","", IF( AP46> AP$ 121* 2,0, IF( AP46> AL46,0,1))) = IF( OR( Y47'="", Y47'=" NA",$ M47'="",$ M47'= 0),"", Y47/$ M47) = IF( AP47'="","", IF( AP47> AP$ 121* 2,0, IF( AP47> AL47,0,1))) = IF( OR( Y48'="", Y48'=" NA",$ M48'="",$ M48'= 0),"", Y48/$ M48) = IF( AP48'="","", IF( AP48> AP$ 121* 2,0, IF( AP48> AL48,0,1))) = IF( OR( Y49'="", Y49'=" NA",$ M49'="",$ M49'= 0),"", Y49/$ M49) = IF( AP49'="","", IF( AP49> AP$ 121* 2,0, IF( AP49> AL49,0,1))) = IF( OR( Y50'="", Y50'=" NA",$ M50'="",$ M50'= 0),"", Y50/$ M50) = IF( AP50'="","", IF( AP50> AP$ 121* 2,0, IF( AP50> AL50,0,1))) = IF( OR( Y51'="", Y51'=" NA",$ M51'="",$ M51'= 0),"", Y51/$ M51) = IF( AP51'="","", IF( AP51> AP$ 121* 2,0, IF( AP51> AL51,0,1))) = IF( OR( Y52'="", Y52'=" NA",$ M52'="",$ M52'= 0),"", Y52/$ M52) = IF( AP52'="","", IF( AP52> AP$ 121* 2,0, IF( AP52> AL52,0,1))) = IF( OR( Y53'="", Y53'=" NA",$ M53'="",$ M53'= 0),"", Y53/$ M53) = IF( AP53'="","", IF( AP53> AP$ 121* 2,0, IF( AP53> AL53,0,1))) = IF( OR( Y54'="", Y54'=" NA",$ M54'="",$ M54'= 0),"", Y54/$ M54) = IF( AP54'="","", IF( AP54> AP$ 121* 2,0, IF( AP54> AL54,0,1))) = IF( OR( Y55'="", Y55'=" NA",$ M55'="",$ M55'= 0),"", Y55/$ M55) = IF( AP55'="","", IF( AP55> AP$ 121* 2,0, IF( AP55> AL55,0,1))) = IF( OR( Y56'="", Y56'=" NA",$ M56'="",$ M56'= 0),"", Y56/$ M56) = IF( AP56'="","", IF( AP56> AP$ 121* 2,0, IF( AP56> AL56,0,1))) = IF( OR( Y57'="", Y57'=" NA",$ M57'="",$ M57'= 0),"", Y57/$ M57) = IF( AP57'="","", IF( AP57> AP$ 121* 2,0, IF( AP57> AL57,0,1))) = IF( OR( Y58'="", Y58'=" NA",$ M58'="",$ M58'= 0),"", Y58/$ M58) = IF( AP58'="","", IF( AP58> AP$ 121* 2,0, IF( AP58> AL58,0,1))) = IF( OR( Y59'="", Y59'=" NA",$ M59'="",$ M59'= 0),"", Y59/$ M59) = IF( AP59'="","", IF( AP59> AP$ 121* 2,0, IF( AP59> AL59,0,1)))

February 14, 2003 58 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River AR AS Oversight Hrs/ MP& M Site Cost Yearly = IF( AQ3'="","", AQ3* AP3*$ AK3) = IF( OR( Z3'="", Z3'=" NA",$ M3'="",$ M3'= 0),"", Z3/$ M3) = IF( AQ4'="","", AQ4* AP4*$ AK4) = IF( OR( Z4'="", Z4'=" NA",$ M4'="",$ M4'= 0),"", Z4/$ M4) = IF( AQ5'="","", AQ5* AP5*$ AK5) = IF( OR( Z5'="", Z5'=" NA",$ M5'="",$ M5'= 0),"", Z5/$ M5) = IF( AQ6'="","", AQ6* AP6*$ AK6) = IF( OR( Z6'="", Z6'=" NA",$ M6'="",$ M6'= 0),"", Z6/$ M6) = IF( AQ7'="","", AQ7* AP7*$ AK7) = IF( OR( Z7'="", Z7'=" NA",$ M7'="",$ M7'= 0),"", Z7/$ M7) = IF( AQ8'="","", AQ8* AP8*$ AK8) = IF( OR( Z8'="", Z8'=" NA",$ M8'="",$ M8'= 0),"", Z8/$ M8) = IF( AQ9'="","", AQ9* AP9*$ AK9) = IF( OR( Z9'="", Z9'=" NA",$ M9'="",$ M9'= 0),"", Z9/$ M9) = IF( AQ10'="","", AQ10* AP10*$ AK10) = IF( OR( Z10'="", Z10'=" NA",$ M10'="",$ M10'= 0),"", Z10/$ M10) = IF( AQ11'="","", AQ11* AP11*$ AK11) = IF( OR( Z11'="", Z11'=" NA",$ M11'="",$ M11'= 0),"", Z11/$ M11) = IF( AQ12'="","", AQ12* AP12*$ AK12) = IF( OR( Z12'="", Z12'=" NA",$ M12'="",$ M12'= 0),"", Z12/$ M12) = IF( AQ13'="","", AQ13* AP13*$ AK13) = IF( OR( Z13'="", Z13'=" NA",$ M13'="",$ M13'= 0),"", Z13/$ M13) = IF( AQ14'="","", AQ14* AP14*$ AK14) = IF( OR( Z14'="", Z14'=" NA",$ M14'="",$ M14'= 0),"", Z14/$ M14) = IF( AQ15'="","", AQ15* AP15*$ AK15) = IF( OR( Z15'="", Z15'=" NA",$ M15'="",$ M15'= 0),"", Z15/$ M15) = IF( AQ16'="","", AQ16* AP16*$ AK16) = IF( OR( Z16'="", Z16'=" NA",$ M16'="",$ M16'= 0),"", Z16/$ M16) = IF( AQ17'="","", AQ17* AP17*$ AK17) = IF( OR( Z17'="", Z17'=" NA",$ M17'="",$ M17'= 0),"", Z17/$ M17) = IF( AQ18'="","", AQ18* AP18*$ AK18) = IF( OR( Z18'="", Z18'=" NA",$ M18'="",$ M18'= 0),"", Z18/$ M18) = IF( AQ19'="","", AQ19* AP19*$ AK19) = IF( OR( Z19'="", Z19'=" NA",$ M19'="",$ M19'= 0),"", Z19/$ M19) = IF( AQ20'="","", AQ20* AP20*$ AK20) = IF( OR( Z20'="", Z20'=" NA",$ M20'="",$ M20'= 0),"", Z20/$ M20) = IF( AQ21'="","", AQ21* AP21*$ AK21) = IF( OR( Z21'="", Z21'=" NA",$ M21'="",$ M21'= 0),"", Z21/$ M21) = IF( AQ22'="","", AQ22* AP22*$ AK22) = IF( OR( Z22'="", Z22'=" NA",$ M22'="",$ M22'= 0),"", Z22/$ M22) = IF( AQ23'="","", AQ23* AP23*$ AK23) = IF( OR( Z23'="", Z23'=" NA",$ M23'="",$ M23'= 0),"", Z23/$ M23) = IF( AQ24'="","", AQ24* AP24*$ AK24) = IF( OR( Z24'="", Z24'=" NA",$ M24'="",$ M24'= 0),"", Z24/$ M24) = IF( AQ25'="","", AQ25* AP25*$ AK25) = IF( OR( Z25'="", Z25'=" NA",$ M25'="",$ M25'= 0),"", Z25/$ M25) = IF( AQ26'="","", AQ26* AP26*$ AK26) = IF( OR( Z26'="", Z26'=" NA",$ M26'="",$ M26'= 0),"", Z26/$ M26) = IF( AQ27'="","", AQ27* AP27*$ AK27) = IF( OR( Z27'="", Z27'=" NA",$ M27'="",$ M27'= 0),"", Z27/$ M27) = IF( AQ28'="","", AQ28* AP28*$ AK28) = IF( OR( Z28'="", Z28'=" NA",$ M28'="",$ M28'= 0),"", Z28/$ M28) = IF( AQ29'="","", AQ29* AP29*$ AK29) = IF( OR( Z29'="", Z29'=" NA",$ M29'="",$ M29'= 0),"", Z29/$ M29) = IF( AQ30'="","", AQ30* AP30*$ AK30) = IF( OR( Z30'="", Z30'=" NA",$ M30'="",$ M30'= 0),"", Z30/$ M30) = IF( AQ31'="","", AQ31* AP31*$ AK31) = IF( OR( Z31'="", Z31'=" NA",$ M31'="",$ M31'= 0),"", Z31/$ M31) = IF( AQ32'="","", AQ32* AP32*$ AK32) = IF( OR( Z32'="", Z32'=" NA",$ M32'="",$ M32'= 0),"", Z32/$ M32) = IF( AQ33'="","", AQ33* AP33*$ AK33) = IF( OR( Z33'="", Z33'=" NA",$ M33'="",$ M33'= 0),"", Z33/$ M33) = IF( AQ34'="","", AQ34* AP34*$ AK34) = IF( OR( Z34'="", Z34'=" NA",$ M34'="",$ M34'= 0),"", Z34/$ M34) = IF( AQ35'="","", AQ35* AP35*$ AK35) = IF( OR( Z35'="", Z35'=" NA",$ M35'="",$ M35'= 0),"", Z35/$ M35) = IF( AQ36'="","", AQ36* AP36*$ AK36) = IF( OR( Z36'="", Z36'=" NA",$ M36'="",$ M36'= 0),"", Z36/$ M36) = IF( AQ37'="","", AQ37* AP37*$ AK37) = IF( OR( Z37'="", Z37'=" NA",$ M37'="",$ M37'= 0),"", Z37/$ M37) = IF( AQ38'="","", AQ38* AP38*$ AK38) = IF( OR( Z38'="", Z38'=" NA",$ M38'="",$ M38'= 0),"", Z38/$ M38) = IF( AQ39'="","", AQ39* AP39*$ AK39) = IF( OR( Z39'="", Z39'=" NA",$ M39'="",$ M39'= 0),"", Z39/$ M39) = IF( AQ40'="","", AQ40* AP40*$ AK40) = IF( OR( Z40'="", Z40'=" NA",$ M40'="",$ M40'= 0),"", Z40/$ M40) = IF( AQ41'="","", AQ41* AP41*$ AK41) = IF( OR( Z41'="", Z41'=" NA",$ M41'="",$ M41'= 0),"", Z41/$ M41) = IF( AQ42'="","", AQ42* AP42*$ AK42) = IF( OR( Z42'="", Z42'=" NA",$ M42'="",$ M42'= 0),"", Z42/$ M42) = IF( AQ43'="","", AQ43* AP43*$ AK43) = IF( OR( Z43'="", Z43'=" NA",$ M43'="",$ M43'= 0),"", Z43/$ M43) = IF( AQ44'="","", AQ44* AP44*$ AK44) = IF( OR( Z44'="", Z44'=" NA",$ M44'="",$ M44'= 0),"", Z44/$ M44) = IF( AQ45'="","", AQ45* AP45*$ AK45) = IF( OR( Z45'="", Z45'=" NA",$ M45'="",$ M45'= 0),"", Z45/$ M45) = IF( AQ46'="","", AQ46* AP46*$ AK46) = IF( OR( Z46'="", Z46'=" NA",$ M46'="",$ M46'= 0),"", Z46/$ M46) = IF( AQ47'="","", AQ47* AP47*$ AK47) = IF( OR( Z47'="", Z47'=" NA",$ M47'="",$ M47'= 0),"", Z47/$ M47) = IF( AQ48'="","", AQ48* AP48*$ AK48) = IF( OR( Z48'="", Z48'=" NA",$ M48'="",$ M48'= 0),"", Z48/$ M48) = IF( AQ49'="","", AQ49* AP49*$ AK49) = IF( OR( Z49'="", Z49'=" NA",$ M49'="",$ M49'= 0),"", Z49/$ M49) = IF( AQ50'="","", AQ50* AP50*$ AK50) = IF( OR( Z50'="", Z50'=" NA",$ M50'="",$ M50'= 0),"", Z50/$ M50) = IF( AQ51'="","", AQ51* AP51*$ AK51) = IF( OR( Z51'="", Z51'=" NA",$ M51'="",$ M51'= 0),"", Z51/$ M51) = IF( AQ52'="","", AQ52* AP52*$ AK52) = IF( OR( Z52'="", Z52'=" NA",$ M52'="",$ M52'= 0),"", Z52/$ M52) = IF( AQ53'="","", AQ53* AP53*$ AK53) = IF( OR( Z53'="", Z53'=" NA",$ M53'="",$ M53'= 0),"", Z53/$ M53) = IF( AQ54'="","", AQ54* AP54*$ AK54) = IF( OR( Z54'="", Z54'=" NA",$ M54'="",$ M54'= 0),"", Z54/$ M54) = IF( AQ55'="","", AQ55* AP55*$ AK55) = IF( OR( Z55'="", Z55'=" NA",$ M55'="",$ M55'= 0),"", Z55/$ M55) = IF( AQ56'="","", AQ56* AP56*$ AK56) = IF( OR( Z56'="", Z56'=" NA",$ M56'="",$ M56'= 0),"", Z56/$ M56) = IF( AQ57'="","", AQ57* AP57*$ AK57) = IF( OR( Z57'="", Z57'=" NA",$ M57'="",$ M57'= 0),"", Z57/$ M57) = IF( AQ58'="","", AQ58* AP58*$ AK58) = IF( OR( Z58'="", Z58'=" NA",$ M58'="",$ M58'= 0),"", Z58/$ M58) = IF( AQ59'="","", AQ59* AP59*$ AK59) = IF( OR( Z59'="", Z59'=" NA",$ M59'="",$ M59'= 0),"", Z59/$ M59)

February 14, 2003 59 of 82 MPM COSTS EPA formula. xls  > 50MGD Record for the Final Metal Product and Machinery Rule 1 23456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B Survey Agency Number 1 Monroe County 1 Monroe County Northwest Qusdrent 2 Metro Wastewater Reclamation District 8 Providence Fields Point WWTP 8 Providence Bucklin Point WWTF 9 Broward County 11 NYC Port Richmond 11 NYC Red Hook 11 NYC Oakwood Beach 11 NYC NTC Rockaway 11 NYC East 11 NYC Newton Creek 11 NYC Wards Island 11 NYC North River 11 NYC Hunts Point 11 NYC Bowery Bay 11 NYC Owls Head 11 NYC Coney Island 11 NYC Jamacia 11 NYC 26th Ward 11 NYC Tallman Island 12 MS D Little Miami 12 Cincinnati Muddy Creek 12 Cincinnati Sycamore Creek 12 Cincinnati Mill Creek 17 Birmingham Valley Creek 17 Birmingham Village Creek 17 Birmingham Five Mile Creek 17 Birmingham Cahaba River 17 Birmingham Turkey Creek 17 Birmingham Trussville 17 Birmingham Leeds 17 Birmingham Prudes Creek 17 Birmingham Warrior 20 LA County Joint WPCP 20 LA Los Coyotes WRP 20 LA Long Beach WRP 20 LA Valencia WRP 20 LA Pomona WRP 20 LA Lancaster WRP 20 LA Palmdale WRP 20 LA Whittier Narrows WRP 20 LA Saugus WRP 20 LA San Jose Creek WRP 22 Chino Basin Municipal Water District 23 IEUA Regional Plant # 1 23 Fontana Carbon Cayon Water Reclamation 23 Fontana Regional Plant # 2 23 Fontana Regional Plant # 4 25 Dallas Water Utilities ( Central) 25 Dallas Southside WWTP 27 Virginia Beach VIP 27 Virginia Beach Atlantic 27 Virginia Beach Nansemond 27 Virginia Beach Chesapeake  Elizabeth 27 Virginia Beach Williamsburg 27 Virginia Beach James River AT AU Oulier'= 0 Cost = IF( AS3'="","", IF( AS3> AS$ 121* 2,0, IF( AS3> AN3,0,1))) = IF( AT3'="","", AT3* AS3*$ AK3) = IF( AS4'="","", IF( AS4> AS$ 121* 2,0, IF( AS4> AN4,0,1))) = IF( AT4'="","", AT4* AS4*$ AK4) = IF( AS5'="","", IF( AS5> AS$ 121* 2,0, IF( AS5> AN5,0,1))) = IF( AT5'="","", AT5* AS5*$ AK5) = IF( AS6'="","", IF( AS6> AS$ 121* 2,0, IF( AS6> AN6,0,1))) = IF( AT6'="","", AT6* AS6*$ AK6) = IF( AS7'="","", IF( AS7> AS$ 121* 2,0, IF( AS7> AN7,0,1))) = IF( AT7'="","", AT7* AS7*$ AK7) = IF( AS8'="","", IF( AS8> AS$ 121* 2,0, IF( AS8> AN8,0,1))) = IF( AT8'="","", AT8* AS8*$ AK8) = IF( AS9'="","", IF( AS9> AS$ 121* 2,0, IF( AS9> AN9,0,1))) = IF( AT9'="","", AT9* AS9*$ AK9) = IF( AS10'="","", IF( AS10> AS$ 121* 2,0, IF( AS10> AN10,0,1))) = IF( AT10'="","", AT10* AS10*$ AK10) = IF( AS11'="","", IF( AS11> AS$ 121* 2,0, IF( AS11> AN11,0,1))) = IF( AT11'="","", AT11* AS11*$ AK11) = IF( AS12'="","", IF( AS12> AS$ 121* 2,0, IF( AS12> AN12,0,1))) = IF( AT12'="","", AT12* AS12*$ AK12) = IF( AS13'="","", IF( AS13> AS$ 121* 2,0, IF( AS13> AN13,0,1))) = IF( AT13'="","", AT13* AS13*$ AK13) = IF( AS14'="","", IF( AS14> AS$ 121* 2,0, IF( AS14> AN14,0,1))) = IF( AT14'="","", AT14* AS14*$ AK14) = IF( AS15'="","", IF( AS15> AS$ 121* 2,0, IF( AS15> AN15,0,1))) = IF( AT15'="","", AT15* AS15*$ AK15) = IF( AS16'="","", IF( AS16> AS$ 121* 2,0, IF( AS16> AN16,0,1))) = IF( AT16'="","", AT16* AS16*$ AK16) = IF( AS17'="","", IF( AS17> AS$ 121* 2,0, IF( AS17> AN17,0,1))) = IF( AT17'="","", AT17* AS17*$ AK17) = IF( AS18'="","", IF( AS18> AS$ 121* 2,0, IF( AS18> AN18,0,1))) = IF( AT18'="","", AT18* AS18*$ AK18) = IF( AS19'="","", IF( AS19> AS$ 121* 2,0, IF( AS19> AN19,0,1))) = IF( AT19'="","", AT19* AS19*$ AK19) = IF( AS20'="","", IF( AS20> AS$ 121* 2,0, IF( AS20> AN20,0,1))) = IF( AT20'="","", AT20* AS20*$ AK20) = IF( AS21'="","", IF( AS21> AS$ 121* 2,0, IF( AS21> AN21,0,1))) = IF( AT21'="","", AT21* AS21*$ AK21) = IF( AS22'="","", IF( AS22> AS$ 121* 2,0, IF( AS22> AN22,0,1))) = IF( AT22'="","", AT22* AS22*$ AK22) = IF( AS23'="","", IF( AS23> AS$ 121* 2,0, IF( AS23> AN23,0,1))) = IF( AT23'="","", AT23* AS23*$ AK23) = IF( AS24'="","", IF( AS24> AS$ 121* 2,0, IF( AS24> AN24,0,1))) = IF( AT24'="","", AT24* AS24*$ AK24) = IF( AS25'="","", IF( AS25> AS$ 121* 2,0, IF( AS25> AN25,0,1))) = IF( AT25'="","", AT25* AS25*$ AK25) = IF( AS26'="","", IF( AS26> AS$ 121* 2,0, IF( AS26> AN26,0,1))) = IF( AT26'="","", AT26* AS26*$ AK26) = IF( AS27'="","", IF( AS27> AS$ 121* 2,0, IF( AS27> AN27,0,1))) = IF( AT27'="","", AT27* AS27*$ AK27) = IF( AS28'="","", IF( AS28> AS$ 121* 2,0, IF( AS28> AN28,0,1))) = IF( AT28'="","", AT28* AS28*$ AK28) = IF( AS29'="","", IF( AS29> AS$ 121* 2,0, IF( AS29> AN29,0,1))) = IF( AT29'="","", AT29* AS29*$ AK29) = IF( AS30'="","", IF( AS30> AS$ 121* 2,0, IF( AS30> AN30,0,1))) = IF( AT30'="","", AT30* AS30*$ AK30) = IF( AS31'="","", IF( AS31> AS$ 121* 2,0, IF( AS31> AN31,0,1))) = IF( AT31'="","", AT31* AS31*$ AK31) = IF( AS32'="","", IF( AS32> AS$ 121* 2,0, IF( AS32> AN32,0,1))) = IF( AT32'="","", AT32* AS32*$ AK32) = IF( AS33'="","", IF( AS33> AS$ 121* 2,0, IF( AS33> AN33,0,1))) = IF( AT33'="","", AT33* AS33*$ AK33) = IF( AS34'="","", IF( AS34> AS$ 121* 2,0, IF( AS34> AN34,0,1))) = IF( AT34'="","", AT34* AS34*$ AK34) = IF( AS35'="","", IF( AS35> AS$ 121* 2,0, IF( AS35> AN35,0,1))) = IF( AT35'="","", AT35* AS35*$ AK35) = IF( AS36'="","", IF( AS36> AS$ 121* 2,0, IF( AS36> AN36,0,1))) = IF( AT36'="","", AT36* AS36*$ AK36) = IF( AS37'="","", IF( AS37> AS$ 121* 2,0, IF( AS37> AN37,0,1))) = IF( AT37'="","", AT37* AS37*$ AK37) = IF( AS38'="","", IF( AS38> AS$ 121* 2,0, IF( AS38> AN38,0,1))) = IF( AT38'="","", AT38* AS38*$ AK38) = IF( AS39'="","", IF( AS39> AS$ 121* 2,0, IF( AS39> AN39,0,1))) = IF( AT39'="","", AT39* AS39*$ AK39) = IF( AS40'="","", IF( AS40> AS$ 121* 2,0, IF( AS40> AN40,0,1))) = IF( AT40'="","", AT40* AS40*$ AK40) = IF( AS41'="","", IF( AS41> AS$ 121* 2,0, IF( AS41> AN41,0,1))) = IF( AT41'="","", AT41* AS41*$ AK41) = IF( AS42'="","", IF( AS42> AS$ 121* 2,0, IF( AS42> AN42,0,1))) = IF( AT42'="","", AT42* AS42*$ AK42) = IF( AS43'="","", IF( AS43> AS$ 121* 2,0, IF( AS43> AN43,0,1))) = IF( AT43'="","", AT43* AS43*$ AK43) = IF( AS44'="","", IF( AS44> AS$ 121* 2,0, IF( AS44> AN44,0,1))) = IF( AT44'="","", AT44* AS44*$ AK44) = IF( AS45'="","", IF( AS45> AS$ 121* 2,0, IF( AS45> AN45,0,1))) = IF( AT45'="","", AT45* AS45*$ AK45) = IF( AS46'="","", IF( AS46> AS$ 121* 2,0, IF( AS46> AN46,0,1))) = IF( AT46'="","", AT46* AS46*$ AK46) = IF( AS47'="","", IF( AS47> AS$ 121* 2,0, IF( AS47> AN47,0,1))) = IF( AT47'="","", AT47* AS47*$ AK47) = IF( AS48'="","", IF( AS48> AS$ 121* 2,0, IF( AS48> AN48,0,1))) = IF( AT48'="","", AT48* AS48*$ AK48) = IF( AS49'="","", IF( AS49> AS$ 121* 2,0, IF( AS49> AN49,0,1))) = IF( AT49'="","", AT49* AS49*$ AK49) = IF( AS50'="","", IF( AS50> AS$ 121* 2,0, IF( AS50> AN50,0,1))) = IF( AT50'="","", AT50* AS50*$ AK50) = IF( AS51'="","", IF( AS51> AS$ 121* 2,0, IF( AS51> AN51,0,1))) = IF( AT51'="","", AT51* AS51*$ AK51) = IF( AS52'="","", IF( AS52> AS$ 121* 2,0, IF( AS52> AN52,0,1))) = IF( AT52'="","", AT52* AS52*$ AK52) = IF( AS53'="","", IF( AS53> AS$ 121* 2,0, IF( AS53> AN53,0,1))) = IF( AT53'="","", AT53* AS53*$ AK53) = IF( AS54'="","", IF( AS54> AS$ 121* 2,0, IF( AS54> AN54,0,1))) = IF( AT54'="","", AT54* AS54*$ AK54) = IF( AS55'="","", IF( AS55> AS$ 121* 2,0, IF( AS55> AN55,0,1))) = IF( AT55'="","", AT55* AS55*$ AK55) = IF( AS56'="","", IF( AS56> AS$ 121* 2,0, IF( AS56> AN56,0,1))) = IF( AT56'="","", AT56* AS56*$ AK56) = IF( AS57'="","", IF( AS57> AS$ 121* 2,0, IF( AS57> AN57,0,1))) = IF( AT57'="","", AT57* AS57*$ AK57) = IF( AS58'="","", IF( AS58> AS$ 121* 2,0, IF( AS58> AN58,0,1))) = IF( AT58'="","", AT58* AS58*$ AK58) = IF( AS59'="","", IF( AS59> AS$ 121* 2,0, IF( AS59> AN59,0,1))) = IF( AT59'="","", AT59* AS59*$ AK59)

February 14, 2003 60 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 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 VA 12.5 17 2 0 4 2 4 3 2 = SUM( F60: L60) 27 Virginia Beach Army Base VA 11.4 4 0 0 1 0 0 2 1 = SUM( F61: L61) 27 Virginia Beach York River VA 10.4 12 0 0 5 1 1 3 2 = SUM( F62: L62) 30 Minneapolis St Paul Metropolitan MN 203.9 463 21 1 15 1 88 4 0 = SUM( F63: L63) 30 ST. Paul Seneca WWTP MN 34.5 = SUM( F64: L64) 30 ST. Paul Blue Lake WWTP MN 24.3 = SUM( F65: L65) 30 St. Paul Empire WWTP MN 8.0 15 0 0 0 0 2 0 0 = SUM( F66: L66) 30 ST. Paul Stillwater WWTP MN 3.1 = SUM( F67: L67) 30 St. Paul Cottage Grove WWTP MN 2.1 = SUM( F68: L68) 30 St. Paul Hasting WWTP MN 1.8 = SUM( F69: L69) 30 St. Paul Rosemount MN 0.7 = SUM( F70: L70) 33 Unified Sewerage Agency ( Durham) OR 22.0 72 0 0 0 0 11 0 0 = SUM( F71: L71) 33 USA Rock Creek OR 29.9 55 0 0 0 0 12 0 0 = SUM( F72: L72) 33 USA Hillsboro OR 4.6 13 0 0 0 0 3 0 0 = SUM( F73: L73) 33 USA Hillsboro Forrest Grove OR 3.7 12 0 0 0 0 1 0 0 = SUM( F74: L74) 34 Detroit MI 620.0 2125 80 84 33 1328 134 25 322 = SUM( F75: L75) 35 Kansas City Blue River MO 75.0 35 4 0 0 7 13 1 10 = SUM( F76: L76) 35 Kansas City Birmingham MO 20.0 4 1 0 0 1 0 0 2 = SUM( F77: L77) 35 Kansas City Westside MO 17.0 16 0 0 0 4 5 1 6 = SUM( F78: L78) 35 Kansas City Todd Creek MO 1.4 2 2 0 0 0 0 0 0 = SUM( F79: L79) 35 Kansas City Rocky Branch MO 0.7 = SUM( F80: L80) 35 Kansas CityFishing River MO 0.2 = SUM( F81: L81) 35 KC Northland Mobile Home MO 0.1 = SUM( F82: L82) 35 KC Industrial Park MI 0.0 = SUM( F83: L83) 36 Jacksonville ( JEA) FL 28.1 64 1 4 2 0 1 2 0 = SUM( F84: L84) 36 Jacksonville District 4 FL 11.8 7 2 1 0 0 0 1 0 = SUM( F85: L85) 36 Jacksonville District 3 FL 7.4 1 0 0 0 0 0 0 0 = SUM( F86: L86) 36 Jacksonville District 5 FL 5.6 1 1 0 0 0 0 0 0 = SUM( F87: L87) 36 Jacksonville District 2 FL 4.3 7 0 0 0 0 0 0 0 = SUM( F88: L88) 40 New Orleans East Bank LA 95.2 1 1 0 0 0 0 0 0 = SUM( F89: L89) 40 New Orleans West Bank LA 8.8 0 0 0 0 0 0 0 0 = SUM( F90: L90) 43 Phoneix  91st Ace. AZ 139.0 120 23 10 0 7 33 6 19 = SUM( F91: L91) 43 Phoenix AZ 54.5 57 12 1 0 3 13 5 11 = SUM( F92: L92) 45 City of Tampa FL 50.0 80 4 12 0 30 7 0 5 = SUM( F93: L93) 46 District of Columbia DC 318.0 10,000 19 2 0 260 21 5 5 = SUM( F94: L94) 52 OCSD WWTP # 2 CA 151.0 442 229 90 19 0 273 0 0 = SUM( F95: L95) 52 Orange County Reclam Plant # 1 CA 90.0 53 NORSD Southerly WWTP OH 106.7 581 33 17 113 0 56 30 0 = SUM( F97: L97) 53 NORSD Westerly WWTP OH 32.7 148 12 5 30 0 20 7 0 = SUM( F98: L98) 53 NORSD Easterly WWTP OH 108.0 220 11 16 47 0 38 12 0 = SUM( F99: L99) 54 Akron WPC OH 72.0 55 4 0 0 5 19 0 1 = SUM( F100: L100) 56 Atlanta RM Clayton GA 90.0 8 0 7 40 5 5 60 = SUM( F101: L101) 56 Atlanta South River GA 40.0 = SUM( F102: L102) 56 Atlanta Utoy Creek GA 30.0 = SUM( F103: L103) 57 MWRDGC Stickney IL 780.0 941 38 20 20 0 95 768 0 = SUM( F104: L104)/ 3 57 MWRDGC Calumet IL 265.0 193 4 16 8 0 4 161 0 = SUM( F105: L105)/ 3 57 MWRDGC Northside IL 268.0 396 21 1 1 0 38 335 0 = SUM( F106: L106)/ 3 57 MWRDGC Kirie IL 37.0 193 10 5 5 0 32 141 0 = SUM( F107: L107)/ 3 57 MWRDGC Egan IL 26.0 50 4 1 0 0 3 42 0 = SUM( F108: L108)/ 3 57 MWRDGC Hanover Park IL 9.0 22 1 0 3 0 0 18 0 = SUM( F109: L109)/ 3 57 MWRDGC Lemont IL 2.0 3 0 0 0 0 0 3 0 = SUM( F110: L110)/ 3 58 MWRA Boston Deer Island MA 601.4 1473 10 0 0 0 55 1 0 = SUM( F111: L111) 58 MWRA Boston Clinton MA 3.4 17 1 0 0 0 2 0 0 = SUM( F112: L112) 59 Philadelphia Northeast PA 196.0 88 12 0 2 0 33 1 0 = SUM( F113: L113) 59 Philadelphia Southwest PA 196.0 31 4 0 1 0 8 1 0 = SUM( F114: L114) 59 Philadelphia Southeast PA 93.0 16 1 0 0 0 4 1 0 = SUM( F115: L115) 60 Nashville Central TN 85.0 30 7 2 2 0 13 0 0 = SUM( F116: L116)

February 14, 2003 61 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 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 2,625 763 = N63* R63*( 1+ T63) = O63* R63*( 1+ T63) $ 25.09 $ 33.80 0.59 $ 27,000.00 $ 22,000.00 $ 110,000.00 980 240 = N71* R71*( 1+ T71) = O71* R71*( 1+ T71) $ 23.00 $ 30.00 0.38 $ 10,000.00 $ 7,000.00 $ 20,000.00 78,260 23,190 = N75* R75*( 1+ T75) = O75* R75*( 1+ T75) $ 870,000.00 $ 87,000.00 $ 2,100,000.00 4,750 1,380 = N76* R76*( 1+ T76) = O76* R76*( 1+ T76) $ 12.50 $ 23.00 0.36 $ 33,170.00 $ 33,170.00 $ 14,000.00 790 680 = N77* R76*( 1+ T77) = O77* R76*( 1+ T77)