0 0 0 =( C$ 23)*' Unit Costs  Low'!$ D$ 50 =( D$ 23)*' Unit Costs  Low'!$ D$ 50 =( E$ 23)*' Unit Costs  Low'!$ D$ 50 =( F$ 23)*' Unit Costs  Low'!$ D$ 50 = SUM( M331: M343) = SUM( N331: N343) = SUM( O331: O343) = SUM( P331: P343) =' Inputs & Assumptions'!$ B$ 5* M344 =' Inputs & Assumptions'!$ B$ 5* N344 =' Inputs & Assumptions'!$ B$ 5* O344 =' Inputs & Assumptions'!$ B$ 5* P344 =' Inputs & Assumptions'!$ B$ 5* M336 =' Inputs & Assumptions'!$ B$ 5* N336 =' Inputs & Assumptions'!$ B$ 5* O336 =' Inputs & Assumptions'!$ B$ 5* P336 11 12 13 14 = M$ 36*' Unit Costs  Low'!$ B$ 6+ M$ 37*' Unit Costs  Low'!$ B$ 22+ M$ 38*' Unit Costs  Low'!$ B$ 38 = N$ 36*' Unit Costs  Low'!$ B$ 6+ N$ 37*' Unit Costs  Low'!$ B$ 22+ N$ 38*' Unit Costs  Low'!$ B$ 38 = O$ 36*' Unit Costs  Low'!$ B$ 6+ O$ 37*' Unit Costs  Low'!$ B$ 22+ O$ 38*' Unit Costs  Low'!$ B$ 38 = P$ 36*' Unit Costs  Low'!$ B$ 6+ P$ 37*' Unit Costs  Low'!$ B$ 22+ P$ 38*' Unit Costs  Low'!$ B$ 38 = M$ 39*' Unit Costs  Low'!$ B$ 7+ M$ 40*' Unit Costs  Low'!$ B$ 23+ M$ 38*' Unit Costs  Low'! L$ 39 = N$ 39*' Unit Costs  Low'!$ B$ 7+ N$ 40*' Unit Costs  Low'!$ B$ 23+ N$ 38*' Unit Costs  Low'! M$ 39 = O$ 39*' Unit Costs  Low'!$ B$ 7+ O$ 40*' Unit Costs  Low'!$ B$ 23+ O$ 38*' Unit Costs  Low'! N$ 39 = P$ 39*' Unit Costs  Low'!$ B$ 7+ P$ 40*' Unit Costs  Low'!$ B$ 23+ P$ 38*' Unit Costs  Low'! O$ 39 = M$ 41*' Unit Costs  Low'!$ B$ 8 = N$ 41*' Unit Costs  Low'!$ B$ 8 = O$ 41*' Unit Costs  Low'!$ B$ 8 = P$ 41*' Unit Costs  Low'!$ B$ 8 = M$ 42*' Unit Costs  Low'!$ B$ 9 = N$ 42*' Unit Costs  Low'!$ B$ 9 = O$ 42*' Unit Costs  Low'!$ B$ 9 = P$ 42*' Unit Costs  Low'!$ B$ 9 = M$ 43*' Unit Costs  Low'!$ C$ 10 = N$ 43*' Unit Costs  Low'!$ C$ 10 = O$ 43*' Unit Costs  Low'!$ C$ 10 = P$ 43*' Unit Costs  Low'!$ C$ 10 = M$ 44*' Unit Costs  Low'!$ C$ 11 = N$ 44*' Unit Costs  Low'!$ C$ 11 = O$ 44*' Unit Costs  Low'!$ C$ 11 = P$ 44*' Unit Costs  Low'!$ C$ 11 = M$ 45*' Unit Costs  Low'!$ C$ 12 = N$ 45*' Unit Costs  Low'!$ C$ 12 = O$ 45*' Unit Costs  Low'!$ C$ 12 = P$ 45*' Unit Costs  Low'!$ C$ 12 = M$ 46*' Unit Costs  Low'!$ C$ 13 = N$ 46*' Unit Costs  Low'!$ C$ 13 = O$ 46*' Unit Costs  Low'!$ C$ 13 = P$ 46*' Unit Costs  Low'!$ C$ 13 = M$ 47*' Unit Costs  Low'!$ C$ 14 = N$ 47*' Unit Costs  Low'!$ C$ 14 = O$ 47*' Unit Costs  Low'!$ C$ 14 = P$ 47*' Unit Costs  Low'!$ C$ 14 = M$ 48*' Unit Costs  Low'!$ C$ 15 = N$ 48*' Unit Costs  Low'!$ C$ 15 = O$ 48*' Unit Costs  Low'!$ C$ 15 = P$ 48*' Unit Costs  Low'!$ C$ 15 = M$ 49*' Unit Costs  Low'!$ C$ 16 = N$ 49*' Unit Costs  Low'!$ C$ 16 = O$ 49*' Unit Costs  Low'!$ C$ 16 = P$ 49*' Unit Costs  Low'!$ C$ 16 = M$ 50*' Unit Costs  Low'!$ C$ 17 = N$ 50*' Unit Costs  Low'!$ C$ 17 = O$ 50*' Unit Costs  Low'!$ C$ 17 = P$ 50*' Unit Costs  Low'!$ C$ 17 = M$ 51*' Unit Costs  Low'!$ D$ 18 = N$ 51*' Unit Costs  Low'!$ D$ 18 = O$ 51*' Unit Costs  Low'!$ D$ 18 = P$ 51*' Unit Costs  Low'!$ D$ 18 = SUM( M358: M370) = SUM( N358: N370) = SUM( O358: O370) = SUM( P358: P370) =' Inputs & Assumptions'!$ B$ 5* M371 =' Inputs & Assumptions'!$ B$ 5* N371 =' Inputs & Assumptions'!$ B$ 5* O371 =' Inputs & Assumptions'!$ B$ 5* P371 =' Inputs & Assumptions'!$ B$ 5* M363 =' Inputs & Assumptions'!$ B$ 5* N363 =' Inputs & Assumptions'!$ B$ 5* O363 =' Inputs & Assumptions'!$ B$ 5* P363 February 14, 2003 52 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 Q 0 0 0 0 0 0 0 =( G$ 23)*' Unit Costs  Low'!$ D$ 50 = SUM( Q331: Q343) =' Inputs & Assumptions'!$ B$ 5* Q344 =' Inputs & Assumptions'!$ B$ 5* Q336 15 = Q$ 36*' Unit Costs  Low'!$ B$ 6+ Q$ 37*' Unit Costs  Low'!$ B$ 22+ Q$ 38*' Unit Costs  Low'!$ B$ 38 = Q$ 39*' Unit Costs  Low'!$ B$ 7+ Q$ 40*' Unit Costs  Low'!$ B$ 23+ Q$ 38*' Unit Costs  Low'! P$ 39 = Q$ 41*' Unit Costs  Low'!$ B$ 8 = Q$ 42*' Unit Costs  Low'!$ B$ 9 = Q$ 43*' Unit Costs  Low'!$ C$ 10 = Q$ 44*' Unit Costs  Low'!$ C$ 11 = Q$ 45*' Unit Costs  Low'!$ C$ 12 = Q$ 46*' Unit Costs  Low'!$ C$ 13 = Q$ 47*' Unit Costs  Low'!$ C$ 14 = Q$ 48*' Unit Costs  Low'!$ C$ 15 = Q$ 49*' Unit Costs  Low'!$ C$ 16 = Q$ 50*' Unit Costs  Low'!$ C$ 17 = Q$ 51*' Unit Costs  Low'!$ D$ 18 = SUM( Q358: Q370) =' Inputs & Assumptions'!$ B$ 5* Q371 =' Inputs & Assumptions'!$ B$ 5* Q363 February 14, 2003 53 of 79 AD MP& M7A formula. xls  Pref Option by Type 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 A B C D Option 2/ 6/ 10 Scenario Definition Iron& steel Number of facilities operating post regulation requiring a permit = SUM( C4: C6) = 95+ 4 Of facilities operating post regulation: existing concentration based = F4 20 existing mass based = F5 79 no permit in baseline = F6 0 concentration based to be converted to mass based = F7 20 new concentration based = F8 0 new mass based = F9 0 Number of currently permitted facilities closing ( no longer requiring a permit) = SUM( C12: C13) 6 Of facilities closing due to the rule: existing concentration based = F12 0 existing mass based = F13 6 Type of Permit Required 1 2 new concentration based permit =$ C8/ 3 =$ C8/ 3 new mass based permit =$ C9/ 3 =$ C9/ 3 facility closure with concentration based permit =$ C12/ 3 =$ C12/ 3 facility closure with mass based permit =$ C13/ 3 =$ C13/ 3 conversion of conc based to mass based permit =$ C7/ 3 =$ C7/ 3 repermit  concen based: post regulation** =($ C4$ C7)/ 3 =($ C4$ C7)/ 3 repermit  mass based : post regulation** =$ C5/ 3 =$ C5/ 3 repermit  concen based: baseline*** =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 repermit  mass based : baseline*** =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 cumulative incremental number of facilities operating under permits ( new  closing) = C19+ C20 C21 C22 = C28+ D19+ D20 D21 D22 * assumes no incremental effort for facilities that already have the type of permit required by the rule, other than repermitting on a different schedule. ** facilities with existing permits excluding facilities that close due to the rule, plus new permits. *** facilities with existing permits including facilities that close due to the rule.

1 2 develop and issue permit  concentration based = C19 = D19 develop and issue permit  mass based = C20 = D20 develop and issue permit  conc based converted to mass based = C23 = D23 provide technical guidance  concentation based = C19 = D19 provide technical guidance  mass based = C20 = D20 conduct public or evidentiary hearings = C19+ C20 = D19+ D20 inspection for permit development = C19+ C20 = D19+ D20 inspection for compliance assessment = C$ 28 = D$ 28 sample and analyze effluent = C$ 28 = D$ 28 review & record self monitoring reports = C$ 28 = D$ 28 process & act on non compliance reports = C$ 28 = D$ 28 review compliance schedule report  in compliance with schedule = C$ 28 = D$ 28 review compliance schedule report  not in compliance with schedule = C$ 28 = D$ 28 minor enforcement action ( e. g., admin order) = C$ 28 = D$ 28 minor enforcement action ( e. g., admin fine) = C$ 28 = D$ 28 repermit = C24+ C25 C26 C27 = D24+ D25 D26 D27 February 14, 2003 54 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 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 E F G H Other Total = F2 D2 53,008 = F4 D4 25,232 = F5 D5 3,764 = F6 D6 24,013 = E4/ 3 = D7+ E7 = 2/ 3* E6 = D8+ E8 = E6/ 3 = D9+ E9 = F10 D10 1,020 = F12 D12 889 = F13 D13 131 Incremental Number of Facilities by Type of 3 4 5 6 =$ C8/ 3 =$ C9/ 3 =$ C12/ 3 =$ C13/ 3 =$ C7/ 3 =($ C4$ C7)/ 3 0 0 = C24+ C19 =$ C5/ 3 0 0 = C25+ C20+ C23 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 = D28+ E19+ E20 E21 E22 = E28+ F19+ F20 F21 F22 = F28+ G19+ G20 G21 G22 = G28+ H19+ H20 H21 H22 Incremental Number of Facilities by Permitting 3 4 5 6 = E19 = E20 = E23 = E19 = E20 = E19+ E20 = E19+ E20 = E$ 28 = F$ 28 = G$ 28 = H$ 28 = E$ 28 = F$ 28 = G$ 28 = H$ 28 = E$ 28 = F$ 28 = G$ 28 = H$ 28 = E$ 28 = F$ 28 = G$ 28 = H$ 28 = E$ 28 = F$ 28 = G$ 28 = H$ 28 = E$ 28 = F$ 28 = G$ 28 = H$ 28 = E$ 28 = F$ 28 = G$ 28 = H$ 28 = E$ 28 = F$ 28 = G$ 28 = H$ 28 = E24+ E25 E26 E27 = F24+ F25 F26 F27 = G24+ G25 G26 G27 = H24+ H25 H26 H27 February 14, 2003 55 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 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 I J K L Incremental Number of Facilities by Type of Permit Required and Year* Year Relative to Promulgation of Rule 7 8 9 10 = D24+ D19 = E24+ E19 = F24+ F19 = G24+ G19 = D25+ D20+ D23 = E25+ E20+ E23 = F25+ F20+ F23 = G25+ G20+ G23 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 = H28+ I19+ I20 I21 I22 = I28+ J19+ J20 J21 J22 = J28+ K19+ K20 K21 K22 = K28+ L19+ L20 L21 L22 Incremental Number of Facilities by Permitting Activity Required and Year Year Relative to Promulgation of Rule 7 8 9 10 = I$ 28 = J$ 28 = K$ 28 = L$ 28 = I$ 28 = J$ 28 = K$ 28 = L$ 28 = I$ 28 = J$ 28 = K$ 28 = L$ 28 = I$ 28 = J$ 28 = K$ 28 = L$ 28 = I$ 28 = J$ 28 = K$ 28 = L$ 28 = I$ 28 = J$ 28 = K$ 28 = L$ 28 = I$ 28 = J$ 28 = K$ 28 = L$ 28 = I$ 28 = J$ 28 = K$ 28 = L$ 28 = I24+ I25 I26 I27 = J24+ J25 J26 J27 = K24+ K25 K26 K27 = L24+ L25 L26 L27 Permitting Hours by Activity and Year  High February 14, 2003 56 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 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 M N O P 11 12 13 14 = H24+ H19 = I24+ I19 = J24+ J19 = K24+ K19 = H25+ H20+ H23 = I25+ I20+ I23 = J25+ J20+ J23 = K25+ K20+ K23 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C4+$ C12)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 =($ C5+$ C13)/ 5 = L28+ M19+ M20 M21 M22 = M28+ N19+ N20 N21 N22 = N28+ O19+ O20 O21 O22 = O28+ P19+ P20 P21 P22 11 12 13 14 = M$ 28 = N$ 28 = O$ 28 = P$ 28 = M$ 28 = N$ 28 = O$ 28 = P$ 28 = M$ 28 = N$ 28 = O$ 28 = P$ 28 = M$ 28 = N$ 28 = O$ 28 = P$ 28 = M$ 28 = N$ 28 = O$ 28 = P$ 28 = M$ 28 = N$ 28 = O$ 28 = P$ 28 = M$ 28 = N$ 28 = O$ 28 = P$ 28 = M$ 28 = N$ 28 = O$ 28 = P$ 28 = M24+ M25 M26 M27 = N24+ N25 N26 N27 = O24+ O25 O26 O27 = P24+ P25 P26 P27 February 14, 2003 57 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 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 Q 15 = L24+ L19 = L25+ L20+ L23 =($ C4+$ C12)/ 5 =($ C5+$ C13)/ 5 = P28+ Q19+ Q20 Q21 Q22 15 = Q$ 28 = Q$ 28 = Q$ 28 = Q$ 28 = Q$ 28 = Q$ 28 = Q$ 28 = Q$ 28 = Q24+ Q25 Q26 Q27 February 14, 2003 58 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 54 55 56 57 58 59 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 A B C D 1 2 develop and issue permit = C$ 36*' Unit Costs  High'!$ B$ 6+ C$ 37*' Unit Costs  High'!$ B$ 22+ C$ 38*' Unit Costs  High'!$ B$ 38 = D$ 36*' Unit Costs  High'!$ B$ 6+ D$ 37*' Unit Costs  High'!$ B$ 22+ D$ 38*' Unit Costs  High'!$ B$ 38 provide technical guidance = C$ 39*' Unit Costs  High'!$ B$ 7+ C$ 40*' Unit Costs  High'!$ B$ 23+ C$ 38*' Unit Costs  High'! B$ 39 = D$ 39*' Unit Costs  High'!$ B$ 7+ D$ 40*' Unit Costs  High'!$ B$ 23+ D$ 38*' Unit Costs  High'! C$ 39 conduct public or evidentiary hearings = C$ 41*' Unit Costs  High'!$ B$ 8 = D$ 41*' Unit Costs  High'!$ B$ 8 inspection for permit development = C$ 42*' Unit Costs  High'!$ B$ 9 = D$ 42*' Unit Costs  High'!$ B$ 9 inspection for compliance assessment = C$ 43*' Unit Costs  High'!$ C$ 10 = D$ 43*' Unit Costs  High'!$ C$ 10 sample and analyze effluent = C$ 44*' Unit Costs  High'!$ C$ 11 = D$ 44*' Unit Costs  High'!$ C$ 11 review & record self monitoring reports = C$ 45*' Unit Costs  High'!$ C$ 12 = D$ 45*' Unit Costs  High'!$ C$ 12 process & act on non compliance reports = C$ 46*' Unit Costs  High'!$ C$ 13 = D$ 46*' Unit Costs  High'!$ C$ 13 review compliance schedule report  in compliance with schedule = C$ 47*' Unit Costs  High'!$ C$ 14 = D$ 47*' Unit Costs  High'!$ C$ 14 review compliance schedule report  not in compliance with schedule = C$ 48*' Unit Costs  High'!$ C$ 15 = D$ 48*' Unit Costs  High'!$ C$ 15 minor enforcement action ( e. g., admin order) = C$ 49*' Unit Costs  High'!$ C$ 16 = D$ 49*' Unit Costs  High'!$ C$ 16 minor enforcement action ( e. g., admin fine) = C$ 50*' Unit Costs  High'!$ C$ 17 = D$ 50*' Unit Costs  High'!$ C$ 17 repermit = C$ 51*' Unit Costs  High'!$ D$ 18 = D$ 51*' Unit Costs  High'!$ D$ 18 Total hours = SUM( C56: C68) = SUM( D56: D68) Total cost =' Inputs & Assumptions'!$ B$ 5* C69 =' Inputs & Assumptions'!$ B$ 5* D69 NPV of cost = NPV(' Inputs & Assumptions'! B4,$ C70: Q70) Maximum one year hours = MAX( C69: Q69) Maximum one year costs = MAX( C70: Q70) Annualized over 15 years = PMT(' Inputs & Assumptions'! B4,15, C71)

1 2 develop and issue permit = C$ 36*' Unit Costs  Medium'!$ B$ 6+ C$ 37*' Unit Costs  Medium'!$ B$ 22+ C$ 38*' Unit Costs  Medium'!$ B$ 38 = D$ 36*' Unit Costs  Medium'!$ B$ 6+ D$ 37*' Unit Costs  Medium'!$ B$ 22+ D$ 38*' Unit Costs  Medium'!$ B$ 38 provide technical guidance = C$ 39*' Unit Costs  Medium'!$ B$ 7+ C$ 40*' Unit Costs  Medium'!$ B$ 23+ C$ 38*' Unit Costs  Medium'! B$ 39 = D$ 39*' Unit Costs  Medium'!$ B$ 7+ D$ 40*' Unit Costs  Medium'!$ B$ 23+ D$ 38*' Unit Costs  Medium'! C$ 39 conduct public or evidentiary hearings = C$ 41*' Unit Costs  Medium'!$ B32 = D$ 41*' Unit Costs  Medium'!$ B32 inspection for permit development = C$ 42*' Unit Costs  Medium'!$ B$ 9 = D$ 42*' Unit Costs  Medium'!$ B$ 9 inspection for compliance assessment = C$ 43*' Unit Costs  Medium'!$ C$ 10 = D$ 43*' Unit Costs  Medium'!$ C$ 10 sample and analyze effluent = C$ 44*' Unit Costs  Medium'!$ C$ 11 = D$ 44*' Unit Costs  Medium'!$ C$ 11 review & record self monitoring reports = C$ 45*' Unit Costs  Medium'!$ C$ 12 = D$ 45*' Unit Costs  Medium'!$ C$ 12 process & act on non compliance reports = C$ 46*' Unit Costs  Medium'!$ C$ 13 = D$ 46*' Unit Costs  Medium'!$ C$ 13 review compliance schedule report  in compliance with schedule = C$ 47*' Unit Costs  Medium'!$ C$ 14 = D$ 47*' Unit Costs  Medium'!$ C$ 14 review compliance schedule report  not in compliance with schedule = C$ 48*' Unit Costs  Medium'!$ C$ 15 = D$ 48*' Unit Costs  Medium'!$ C$ 15 minor enforcement action ( e. g., admin order) = C$ 49*' Unit Costs  Medium'!$ C$ 16 = D$ 49*' Unit Costs  Medium'!$ C$ 16 minor enforcement action ( e. g., admin fine) = C$ 50*' Unit Costs  Medium'!$ C$ 17 = D$ 50*' Unit Costs  Medium'!$ C$ 17 repermit = C$ 51*' Unit Costs  Medium'!$ D$ 18 = D$ 51*' Unit Costs  Medium'!$ D$ 18 Total hours = SUM( C79: C91) = SUM( D79: D91) Total cost =' Inputs & Assumptions'!$ B$ 5* C92 =' Inputs & Assumptions'!$ B$ 5* D92 NPV of cost = NPV(' Inputs & Assumptions'! B$ 4, C93: Q93) Maximum one year hours = MAX( C92: Q92) Maximum one year costs = MAX( C93: Q93) Annualized over 15 years = PMT(' Inputs & Assumptions'! B$ 4,15, C94)

February 14, 2003 59 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 54 55 56 57 58 59 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 E F G H 3 4 5 6 = E$ 36*' Unit Costs  High'!$ B$ 6+ E$ 37*' Unit Costs  High'!$ B$ 22+ E$ 38*' Unit Costs  High'!$ B$ 38 = F$ 36*' Unit Costs  High'!$ B$ 6+ F$ 37*' Unit Costs  High'!$ B$ 22+ F$ 38*' Unit Costs  High'!$ B$ 38 = G$ 36*' Unit Costs  High'!$ B$ 6+ G$ 37*' Unit Costs  High'!$ B$ 22+ G$ 38*' Unit Costs  High'!$ B$ 38 = H$ 36*' Unit Costs  High'!$ B$ 6+ H$ 37*' Unit Costs  High'!$ B$ 22+ H$ 38*' Unit Costs  High'!$ B$ 38 = E$ 39*' Unit Costs  High'!$ B$ 7+ E$ 40*' Unit Costs  High'!$ B$ 23+ E$ 38*' Unit Costs  High'! D$ 39 = F$ 39*' Unit Costs  High'!$ B$ 7+ F$ 40*' Unit Costs  High'!$ B$ 23+ F$ 38*' Unit Costs  High'! E$ 39 = G$ 39*' Unit Costs  High'!$ B$ 7+ G$ 40*' Unit Costs  High'!$ B$ 23+ G$ 38*' Unit Costs  High'! F$ 39 = H$ 39*' Unit Costs  High'!$ B$ 7+ H$ 40*' Unit Costs  High'!$ B$ 23+ H$ 38*' Unit Costs  High'! G$ 39 = E$ 41*' Unit Costs  High'!$ B$ 8 = F$ 41*' Unit Costs  High'!$ B$ 8 = G$ 41*' Unit Costs  High'!$ B$ 8 = H$ 41*' Unit Costs  High'!$ B$ 8 = E$ 42*' Unit Costs  High'!$ B$ 9 = F$ 42*' Unit Costs  High'!$ B$ 9 = G$ 42*' Unit Costs  High'!$ B$ 9 = H$ 42*' Unit Costs  High'!$ B$ 9 = E$ 43*' Unit Costs  High'!$ C$ 10 = F$ 43*' Unit Costs  High'!$ C$ 10 = G$ 43*' Unit Costs  High'!$ C$ 10 = H$ 43*' Unit Costs  High'!$ C$ 10 = E$ 44*' Unit Costs  High'!$ C$ 11 = F$ 44*' Unit Costs  High'!$ C$ 11 = G$ 44*' Unit Costs  High'!$ C$ 11 = H$ 44*' Unit Costs  High'!$ C$ 11 = E$ 45*' Unit Costs  High'!$ C$ 12 = F$ 45*' Unit Costs  High'!$ C$ 12 = G$ 45*' Unit Costs  High'!$ C$ 12 = H$ 45*' Unit Costs  High'!$ C$ 12 = E$ 46*' Unit Costs  High'!$ C$ 13 = F$ 46*' Unit Costs  High'!$ C$ 13 = G$ 46*' Unit Costs  High'!$ C$ 13 = H$ 46*' Unit Costs  High'!$ C$ 13 = E$ 47*' Unit Costs  High'!$ C$ 14 = F$ 47*' Unit Costs  High'!$ C$ 14 = G$ 47*' Unit Costs  High'!$ C$ 14 = H$ 47*' Unit Costs  High'!$ C$ 14 = E$ 48*' Unit Costs  High'!$ C$ 15 = F$ 48*' Unit Costs  High'!$ C$ 15 = G$ 48*' Unit Costs  High'!$ C$ 15 = H$ 48*' Unit Costs  High'!$ C$ 15 = E$ 49*' Unit Costs  High'!$ C$ 16 = F$ 49*' Unit Costs  High'!$ C$ 16 = G$ 49*' Unit Costs  High'!$ C$ 16 = H$ 49*' Unit Costs  High'!$ C$ 16 = E$ 50*' Unit Costs  High'!$ C$ 17 = F$ 50*' Unit Costs  High'!$ C$ 17 = G$ 50*' Unit Costs  High'!$ C$ 17 = H$ 50*' Unit Costs  High'!$ C$ 17 = E$ 51*' Unit Costs  High'!$ D$ 18 = F$ 51*' Unit Costs  High'!$ D$ 18 = G$ 51*' Unit Costs  High'!$ D$ 18 = H$ 51*' Unit Costs  High'!$ D$ 18 = SUM( E56: E68) = SUM( F56: F68) = SUM( G56: G68) = SUM( H56: H68) =' Inputs & Assumptions'!$ B$ 5* E69 =' Inputs & Assumptions'!$ B$ 5* F69 =' Inputs & Assumptions'!$ B$ 5* G69 =' Inputs & Assumptions'!$ B$ 5* H69 3 4 5 6 = E$ 36*' Unit Costs  Medium'!$ B$ 6+ E$ 37*' Unit Costs  Medium'!$ B$ 22+ E$ 38*' Unit Costs  Medium'!$ B$ 38 = F$ 36*' Unit Costs  Medium'!$ B$ 6+ F$ 37*' Unit Costs  Medium'!$ B$ 22+ F$ 38*' Unit Costs  Medium'!$ B$ 38 = G$ 36*' Unit Costs  Medium'!$ B$ 6+ G$ 37*' Unit Costs  Medium'!$ B$ 22+ G$ 38*' Unit Costs  Medium'!$ B$ 38 = H$ 36*' Unit Costs  Medium'!$ B$ 6+ H$ 37*' Unit Costs  Medium'!$ B$ 22+ H$ 38*' Unit Costs  Medium'!$ B$ 38 = E$ 39*' Unit Costs  Medium'!$ B$ 7+ E$ 40*' Unit Costs  Medium'!$ B$ 23+ E$ 38*' Unit Costs  Medium'! D$ 39 = F$ 39*' Unit Costs  Medium'!$ B$ 7+ F$ 40*' Unit Costs  Medium'!$ B$ 23+ F$ 38*' Unit Costs  Medium'! E$ 39 = G$ 39*' Unit Costs  Medium'!$ B$ 7+ G$ 40*' Unit Costs  Medium'!$ B$ 23+ G$ 38*' Unit Costs  Medium'! F$ 39 = H$ 39*' Unit Costs  Medium'!$ B$ 7+ H$ 40*' Unit Costs  Medium'!$ B$ 23+ H$ 38*' Unit Costs  Medium'! G$ 39 = E$ 41*' Unit Costs  Medium'!$ B32 = F$ 41*' Unit Costs  Medium'!$ B32 = G$ 41*' Unit Costs  Medium'!$ B32 = H$ 41*' Unit Costs  Medium'!$ B32 = E$ 42*' Unit Costs  Medium'!$ B$ 9 = F$ 42*' Unit Costs  Medium'!$ B$ 9 = G$ 42*' Unit Costs  Medium'!$ B$ 9 = H$ 42*' Unit Costs  Medium'!$ B$ 9 = E$ 43*' Unit Costs  Medium'!$ C$ 10 = F$ 43*' Unit Costs  Medium'!$ C$ 10 = G$ 43*' Unit Costs  Medium'!$ C$ 10 = H$ 43*' Unit Costs  Medium'!$ C$ 10 = E$ 44*' Unit Costs  Medium'!$ C$ 11 = F$ 44*' Unit Costs  Medium'!$ C$ 11 = G$ 44*' Unit Costs  Medium'!$ C$ 11 = H$ 44*' Unit Costs  Medium'!$ C$ 11 = E$ 45*' Unit Costs  Medium'!$ C$ 12 = F$ 45*' Unit Costs  Medium'!$ C$ 12 = G$ 45*' Unit Costs  Medium'!$ C$ 12 = H$ 45*' Unit Costs  Medium'!$ C$ 12 = E$ 46*' Unit Costs  Medium'!$ C$ 13 = F$ 46*' Unit Costs  Medium'!$ C$ 13 = G$ 46*' Unit Costs  Medium'!$ C$ 13 = H$ 46*' Unit Costs  Medium'!$ C$ 13 = E$ 47*' Unit Costs  Medium'!$ C$ 14 = F$ 47*' Unit Costs  Medium'!$ C$ 14 = G$ 47*' Unit Costs  Medium'!$ C$ 14 = H$ 47*' Unit Costs  Medium'!$ C$ 14 = E$ 48*' Unit Costs  Medium'!$ C$ 15 = F$ 48*' Unit Costs  Medium'!$ C$ 15 = G$ 48*' Unit Costs  Medium'!$ C$ 15 = H$ 48*' Unit Costs  Medium'!$ C$ 15 = E$ 49*' Unit Costs  Medium'!$ C$ 16 = F$ 49*' Unit Costs  Medium'!$ C$ 16 = G$ 49*' Unit Costs  Medium'!$ C$ 16 = H$ 49*' Unit Costs  Medium'!$ C$ 16 = E$ 50*' Unit Costs  Medium'!$ C$ 17 = F$ 50*' Unit Costs  Medium'!$ C$ 17 = G$ 50*' Unit Costs  Medium'!$ C$ 17 = H$ 50*' Unit Costs  Medium'!$ C$ 17 = E$ 51*' Unit Costs  Medium'!$ D$ 18 = F$ 51*' Unit Costs  Medium'!$ D$ 18 = G$ 51*' Unit Costs  Medium'!$ D$ 18 = H$ 51*' Unit Costs  Medium'!$ D$ 18 = SUM( E79: E91) = SUM( F79: F91) = SUM( G79: G91) = SUM( H79: H91) =' Inputs & Assumptions'!$ B$ 5* E92 =' Inputs & Assumptions'!$ B$ 5* F92 =' Inputs & Assumptions'!$ B$ 5* G92 =' Inputs & Assumptions'!$ B$ 5* H92 February 14, 2003 60 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 54 55 56 57 58 59 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 I J K L Year Relative to Promulgation of Rule 7 8 9 10 = I$ 36*' Unit Costs  High'!$ B$ 6+ I$ 37*' Unit Costs  High'!$ B$ 22+ I$ 38*' Unit Costs  High'!$ B$ 38 = J$ 36*' Unit Costs  High'!$ B$ 6+ J$ 37*' Unit Costs  High'!$ B$ 22+ J$ 38*' Unit Costs  High'!$ B$ 38 = K$ 36*' Unit Costs  High'!$ B$ 6+ K$ 37*' Unit Costs  High'!$ B$ 22+ K$ 38*' Unit Costs  High'!$ B$ 38 = L$ 36*' Unit Costs  High'!$ B$ 6+ L$ 37*' Unit Costs  High'!$ B$ 22+ L$ 38*' Unit Costs  High'!$ B$ 38 = I$ 39*' Unit Costs  High'!$ B$ 7+ I$ 40*' Unit Costs  High'!$ B$ 23+ I$ 38*' Unit Costs  High'! H$ 39 = J$ 39*' Unit Costs  High'!$ B$ 7+ J$ 40*' Unit Costs  High'!$ B$ 23+ J$ 38*' Unit Costs  High'! I$ 39 = K$ 39*' Unit Costs  High'!$ B$ 7+ K$ 40*' Unit Costs  High'!$ B$ 23+ K$ 38*' Unit Costs  High'! J$ 39 = L$ 39*' Unit Costs  High'!$ B$ 7+ L$ 40*' Unit Costs  High'!$ B$ 23+ L$ 38*' Unit Costs  High'! K$ 39 = I$ 41*' Unit Costs  High'!$ B$ 8 = J$ 41*' Unit Costs  High'!$ B$ 8 = K$ 41*' Unit Costs  High'!$ B$ 8 = L$ 41*' Unit Costs  High'!$ B$ 8 = I$ 42*' Unit Costs  High'!$ B$ 9 = J$ 42*' Unit Costs  High'!$ B$ 9 = K$ 42*' Unit Costs  High'!$ B$ 9 = L$ 42*' Unit Costs  High'!$ B$ 9 = I$ 43*' Unit Costs  High'!$ C$ 10 = J$ 43*' Unit Costs  High'!$ C$ 10 = K$ 43*' Unit Costs  High'!$ C$ 10 = L$ 43*' Unit Costs  High'!$ C$ 10 = I$ 44*' Unit Costs  High'!$ C$ 11 = J$ 44*' Unit Costs  High'!$ C$ 11 = K$ 44*' Unit Costs  High'!$ C$ 11 = L$ 44*' Unit Costs  High'!$ C$ 11 = I$ 45*' Unit Costs  High'!$ C$ 12 = J$ 45*' Unit Costs  High'!$ C$ 12 = K$ 45*' Unit Costs  High'!$ C$ 12 = L$ 45*' Unit Costs  High'!$ C$ 12 = I$ 46*' Unit Costs  High'!$ C$ 13 = J$ 46*' Unit Costs  High'!$ C$ 13 = K$ 46*' Unit Costs  High'!$ C$ 13 = L$ 46*' Unit Costs  High'!$ C$ 13 = I$ 47*' Unit Costs  High'!$ C$ 14 = J$ 47*' Unit Costs  High'!$ C$ 14 = K$ 47*' Unit Costs  High'!$ C$ 14 = L$ 47*' Unit Costs  High'!$ C$ 14 = I$ 48*' Unit Costs  High'!$ C$ 15 = J$ 48*' Unit Costs  High'!$ C$ 15 = K$ 48*' Unit Costs  High'!$ C$ 15 = L$ 48*' Unit Costs  High'!$ C$ 15 = I$ 49*' Unit Costs  High'!$ C$ 16 = J$ 49*' Unit Costs  High'!$ C$ 16 = K$ 49*' Unit Costs  High'!$ C$ 16 = L$ 49*' Unit Costs  High'!$ C$ 16 = I$ 50*' Unit Costs  High'!$ C$ 17 = J$ 50*' Unit Costs  High'!$ C$ 17 = K$ 50*' Unit Costs  High'!$ C$ 17 = L$ 50*' Unit Costs  High'!$ C$ 17 = I$ 51*' Unit Costs  High'!$ D$ 18 = J$ 51*' Unit Costs  High'!$ D$ 18 = K$ 51*' Unit Costs  High'!$ D$ 18 = L$ 51*' Unit Costs  High'!$ D$ 18 = SUM( I56: I68) = SUM( J56: J68) = SUM( K56: K68) = SUM( L56: L68) =' Inputs & Assumptions'!$ B$ 5* I69 =' Inputs & Assumptions'!$ B$ 5* J69 =' Inputs & Assumptions'!$ B$ 5* K69 =' Inputs & Assumptions'!$ B$ 5* L69 Permitting Hours by Activity and Year  Medium Year Relative to Promulgation of Rule 7 8 9 10 = I$ 36*' Unit Costs  Medium'!$ B$ 6+ I$ 37*' Unit Costs  Medium'!$ B$ 22+ I$ 38*' Unit Costs  Medium'!$ B$ 38 = J$ 36*' Unit Costs  Medium'!$ B$ 6+ J$ 37*' Unit Costs  Medium'!$ B$ 22+ J$ 38*' Unit Costs  Medium'!$ B$ 38 = K$ 36*' Unit Costs  Medium'!$ B$ 6+ K$ 37*' Unit Costs  Medium'!$ B$ 22+ K$ 38*' Unit Costs  Medium'!$ B$ 38 = L$ 36*' Unit Costs  Medium'!$ B$ 6+ L$ 37*' Unit Costs  Medium'!$ B$ 22+ L$ 38*' Unit Costs  Medium'!$ B$ 38 = I$ 39*' Unit Costs  Medium'!$ B$ 7+ I$ 40*' Unit Costs  Medium'!$ B$ 23+ I$ 38*' Unit Costs  Medium'! H$ 39 = J$ 39*' Unit Costs  Medium'!$ B$ 7+ J$ 40*' Unit Costs  Medium'!$ B$ 23+ J$ 38*' Unit Costs  Medium'! I$ 39 = K$ 39*' Unit Costs  Medium'!$ B$ 7+ K$ 40*' Unit Costs  Medium'!$ B$ 23+ K$ 38*' Unit Costs  Medium'! J$ 39 = L$ 39*' Unit Costs  Medium'!$ B$ 7+ L$ 40*' Unit Costs  Medium'!$ B$ 23+ L$ 38*' Unit Costs  Medium'! K$ 39 = I$ 41*' Unit Costs  Medium'!$ B32 = J$ 41*' Unit Costs  Medium'!$ B32 = K$ 41*' Unit Costs  Medium'!$ B32 = L$ 41*' Unit Costs  Medium'!$ B32 = I$ 42*' Unit Costs  Medium'!$ B$ 9 = J$ 42*' Unit Costs  Medium'!$ B$ 9 = K$ 42*' Unit Costs  Medium'!$ B$ 9 = L$ 42*' Unit Costs  Medium'!$ B$ 9 = I$ 43*' Unit Costs  Medium'!$ C$ 10 = J$ 43*' Unit Costs  Medium'!$ C$ 10 = K$ 43*' Unit Costs  Medium'!$ C$ 10 = L$ 43*' Unit Costs  Medium'!$ C$ 10 = I$ 44*' Unit Costs  Medium'!$ C$ 11 = J$ 44*' Unit Costs  Medium'!$ C$ 11 = K$ 44*' Unit Costs  Medium'!$ C$ 11 = L$ 44*' Unit Costs  Medium'!$ C$ 11 = I$ 45*' Unit Costs  Medium'!$ C$ 12 = J$ 45*' Unit Costs  Medium'!$ C$ 12 = K$ 45*' Unit Costs  Medium'!$ C$ 12 = L$ 45*' Unit Costs  Medium'!$ C$ 12 = I$ 46*' Unit Costs  Medium'!$ C$ 13 = J$ 46*' Unit Costs  Medium'!$ C$ 13 = K$ 46*' Unit Costs  Medium'!$ C$ 13 = L$ 46*' Unit Costs  Medium'!$ C$ 13 = I$ 47*' Unit Costs  Medium'!$ C$ 14 = J$ 47*' Unit Costs  Medium'!$ C$ 14 = K$ 47*' Unit Costs  Medium'!$ C$ 14 = L$ 47*' Unit Costs  Medium'!$ C$ 14 = I$ 48*' Unit Costs  Medium'!$ C$ 15 = J$ 48*' Unit Costs  Medium'!$ C$ 15 = K$ 48*' Unit Costs  Medium'!$ C$ 15 = L$ 48*' Unit Costs  Medium'!$ C$ 15 = I$ 49*' Unit Costs  Medium'!$ C$ 16 = J$ 49*' Unit Costs  Medium'!$ C$ 16 = K$ 49*' Unit Costs  Medium'!$ C$ 16 = L$ 49*' Unit Costs  Medium'!$ C$ 16 = I$ 50*' Unit Costs  Medium'!$ C$ 17 = J$ 50*' Unit Costs  Medium'!$ C$ 17 = K$ 50*' Unit Costs  Medium'!$ C$ 17 = L$ 50*' Unit Costs  Medium'!$ C$ 17 = I$ 51*' Unit Costs  Medium'!$ D$ 18 = J$ 51*' Unit Costs  Medium'!$ D$ 18 = K$ 51*' Unit Costs  Medium'!$ D$ 18 = L$ 51*' Unit Costs  Medium'!$ D$ 18 = SUM( I79: I91) = SUM( J79: J91) = SUM( K79: K91) = SUM( L79: L91) =' Inputs & Assumptions'!$ B$ 5* I92 =' Inputs & Assumptions'!$ B$ 5* J92 =' Inputs & Assumptions'!$ B$ 5* K92 =' Inputs & Assumptions'!$ B$ 5* L92 Permitting Hours by Activity and Year  Low February 14, 2003 61 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 54 55 56 57 58 59 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 M N O P 11 12 13 14 = M$ 36*' Unit Costs  High'!$ B$ 6+ M$ 37*' Unit Costs  High'!$ B$ 22+ M$ 38*' Unit Costs  High'!$ B$ 38 = N$ 36*' Unit Costs  High'!$ B$ 6+ N$ 37*' Unit Costs  High'!$ B$ 22+ N$ 38*' Unit Costs  High'!$ B$ 38 = O$ 36*' Unit Costs  High'!$ B$ 6+ O$ 37*' Unit Costs  High'!$ B$ 22+ O$ 38*' Unit Costs  High'!$ B$ 38 = P$ 36*' Unit Costs  High'!$ B$ 6+ P$ 37*' Unit Costs  High'!$ B$ 22+ P$ 38*' Unit Costs  High'!$ B$ 38 = M$ 39*' Unit Costs  High'!$ B$ 7+ M$ 40*' Unit Costs  High'!$ B$ 23+ M$ 38*' Unit Costs  High'! L$ 39 = N$ 39*' Unit Costs  High'!$ B$ 7+ N$ 40*' Unit Costs  High'!$ B$ 23+ N$ 38*' Unit Costs  High'! M$ 39 = O$ 39*' Unit Costs  High'!$ B$ 7+ O$ 40*' Unit Costs  High'!$ B$ 23+ O$ 38*' Unit Costs  High'! N$ 39 = P$ 39*' Unit Costs  High'!$ B$ 7+ P$ 40*' Unit Costs  High'!$ B$ 23+ P$ 38*' Unit Costs  High'! O$ 39 = M$ 41*' Unit Costs  High'!$ B$ 8 = N$ 41*' Unit Costs  High'!$ B$ 8 = O$ 41*' Unit Costs  High'!$ B$ 8 = P$ 41*' Unit Costs  High'!$ B$ 8 = M$ 42*' Unit Costs  High'!$ B$ 9 = N$ 42*' Unit Costs  High'!$ B$ 9 = O$ 42*' Unit Costs  High'!$ B$ 9 = P$ 42*' Unit Costs  High'!$ B$ 9 = M$ 43*' Unit Costs  High'!$ C$ 10 = N$ 43*' Unit Costs  High'!$ C$ 10 = O$ 43*' Unit Costs  High'!$ C$ 10 = P$ 43*' Unit Costs  High'!$ C$ 10 = M$ 44*' Unit Costs  High'!$ C$ 11 = N$ 44*' Unit Costs  High'!$ C$ 11 = O$ 44*' Unit Costs  High'!$ C$ 11 = P$ 44*' Unit Costs  High'!$ C$ 11 = M$ 45*' Unit Costs  High'!$ C$ 12 = N$ 45*' Unit Costs  High'!$ C$ 12 = O$ 45*' Unit Costs  High'!$ C$ 12 = P$ 45*' Unit Costs  High'!$ C$ 12 = M$ 46*' Unit Costs  High'!$ C$ 13 = N$ 46*' Unit Costs  High'!$ C$ 13 = O$ 46*' Unit Costs  High'!$ C$ 13 = P$ 46*' Unit Costs  High'!$ C$ 13 = M$ 47*' Unit Costs  High'!$ C$ 14 = N$ 47*' Unit Costs  High'!$ C$ 14 = O$ 47*' Unit Costs  High'!$ C$ 14 = P$ 47*' Unit Costs  High'!$ C$ 14 = M$ 48*' Unit Costs  High'!$ C$ 15 = N$ 48*' Unit Costs  High'!$ C$ 15 = O$ 48*' Unit Costs  High'!$ C$ 15 = P$ 48*' Unit Costs  High'!$ C$ 15 = M$ 49*' Unit Costs  High'!$ C$ 16 = N$ 49*' Unit Costs  High'!$ C$ 16 = O$ 49*' Unit Costs  High'!$ C$ 16 = P$ 49*' Unit Costs  High'!$ C$ 16 = M$ 50*' Unit Costs  High'!$ C$ 17 = N$ 50*' Unit Costs  High'!$ C$ 17 = O$ 50*' Unit Costs  High'!$ C$ 17 = P$ 50*' Unit Costs  High'!$ C$ 17 = M$ 51*' Unit Costs  High'!$ D$ 18 = N$ 51*' Unit Costs  High'!$ D$ 18 = O$ 51*' Unit Costs  High'!$ D$ 18 = P$ 51*' Unit Costs  High'!$ D$ 18 = SUM( M56: M68) = SUM( N56: N68) = SUM( O56: O68) = SUM( P56: P68) =' Inputs & Assumptions'!$ B$ 5* M69 =' Inputs & Assumptions'!$ B$ 5* N69 =' Inputs & Assumptions'!$ B$ 5* O69 =' Inputs & Assumptions'!$ B$ 5* P69 11 12 13 14 = M$ 36*' Unit Costs  Medium'!$ B$ 6+ M$ 37*' Unit Costs  Medium'!$ B$ 22+ M$ 38*' Unit Costs  Medium'!$ B$ 38 = N$ 36*' Unit Costs  Medium'!$ B$ 6+ N$ 37*' Unit Costs  Medium'!$ B$ 22+ N$ 38*' Unit Costs  Medium'!$ B$ 38 = O$ 36*' Unit Costs  Medium'!$ B$ 6+ O$ 37*' Unit Costs  Medium'!$ B$ 22+ O$ 38*' Unit Costs  Medium'!$ B$ 38 = P$ 36*' Unit Costs  Medium'!$ B$ 6+ P$ 37*' Unit Costs  Medium'!$ B$ 22+ P$ 38*' Unit Costs  Medium'!$ B$ 38 = M$ 39*' Unit Costs  Medium'!$ B$ 7+ M$ 40*' Unit Costs  Medium'!$ B$ 23+ M$ 38*' Unit Costs  Medium'! L$ 39 = N$ 39*' Unit Costs  Medium'!$ B$ 7+ N$ 40*' Unit Costs  Medium'!$ B$ 23+ N$ 38*' Unit Costs  Medium'! M$ 39 = O$ 39*' Unit Costs  Medium'!$ B$ 7+ O$ 40*' Unit Costs  Medium'!$ B$ 23+ O$ 38*' Unit Costs  Medium'! N$ 39 = P$ 39*' Unit Costs  Medium'!$ B$ 7+ P$ 40*' Unit Costs  Medium'!$ B$ 23+ P$ 38*' Unit Costs  Medium'! O$ 39 = M$ 41*' Unit Costs  Medium'!$ B32 = N$ 41*' Unit Costs  Medium'!$ B32 = O$ 41*' Unit Costs  Medium'!$ B32 = P$ 41*' Unit Costs  Medium'!$ B32 = M$ 42*' Unit Costs  Medium'!$ B$ 9 = N$ 42*' Unit Costs  Medium'!$ B$ 9 = O$ 42*' Unit Costs  Medium'!$ B$ 9 = P$ 42*' Unit Costs  Medium'!$ B$ 9 = M$ 43*' Unit Costs  Medium'!$ C$ 10 = N$ 43*' Unit Costs  Medium'!$ C$ 10 = O$ 43*' Unit Costs  Medium'!$ C$ 10 = P$ 43*' Unit Costs  Medium'!$ C$ 10 = M$ 44*' Unit Costs  Medium'!$ C$ 11 = N$ 44*' Unit Costs  Medium'!$ C$ 11 = O$ 44*' Unit Costs  Medium'!$ C$ 11 = P$ 44*' Unit Costs  Medium'!$ C$ 11 = M$ 45*' Unit Costs  Medium'!$ C$ 12 = N$ 45*' Unit Costs  Medium'!$ C$ 12 = O$ 45*' Unit Costs  Medium'!$ C$ 12 = P$ 45*' Unit Costs  Medium'!$ C$ 12 = M$ 46*' Unit Costs  Medium'!$ C$ 13 = N$ 46*' Unit Costs  Medium'!$ C$ 13 = O$ 46*' Unit Costs  Medium'!$ C$ 13 = P$ 46*' Unit Costs  Medium'!$ C$ 13 = M$ 47*' Unit Costs  Medium'!$ C$ 14 = N$ 47*' Unit Costs  Medium'!$ C$ 14 = O$ 47*' Unit Costs  Medium'!$ C$ 14 = P$ 47*' Unit Costs  Medium'!$ C$ 14 = M$ 48*' Unit Costs  Medium'!$ C$ 15 = N$ 48*' Unit Costs  Medium'!$ C$ 15 = O$ 48*' Unit Costs  Medium'!$ C$ 15 = P$ 48*' Unit Costs  Medium'!$ C$ 15 = M$ 49*' Unit Costs  Medium'!$ C$ 16 = N$ 49*' Unit Costs  Medium'!$ C$ 16 = O$ 49*' Unit Costs  Medium'!$ C$ 16 = P$ 49*' Unit Costs  Medium'!$ C$ 16 = M$ 50*' Unit Costs  Medium'!$ C$ 17 = N$ 50*' Unit Costs  Medium'!$ C$ 17 = O$ 50*' Unit Costs  Medium'!$ C$ 17 = P$ 50*' Unit Costs  Medium'!$ C$ 17 = M$ 51*' Unit Costs  Medium'!$ D$ 18 = N$ 51*' Unit Costs  Medium'!$ D$ 18 = O$ 51*' Unit Costs  Medium'!$ D$ 18 = P$ 51*' Unit Costs  Medium'!$ D$ 18 = SUM( M79: M91) = SUM( N79: N91) = SUM( O79: O91) = SUM( P79: P91) =' Inputs & Assumptions'!$ B$ 5* M92 =' Inputs & Assumptions'!$ B$ 5* N92 =' Inputs & Assumptions'!$ B$ 5* O92 =' Inputs & Assumptions'!$ B$ 5* P92 February 14, 2003 62 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 54 55 56 57 58 59 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 Q 15 = Q$ 36*' Unit Costs  High'!$ B$ 6+ Q$ 37*' Unit Costs  High'!$ B$ 22+ Q$ 38*' Unit Costs  High'!$ B$ 38 = Q$ 39*' Unit Costs  High'!$ B$ 7+ Q$ 40*' Unit Costs  High'!$ B$ 23+ Q$ 38*' Unit Costs  High'! P$ 39 = Q$ 41*' Unit Costs  High'!$ B$ 8 = Q$ 42*' Unit Costs  High'!$ B$ 9 = Q$ 43*' Unit Costs  High'!$ C$ 10 = Q$ 44*' Unit Costs  High'!$ C$ 11 = Q$ 45*' Unit Costs  High'!$ C$ 12 = Q$ 46*' Unit Costs  High'!$ C$ 13 = Q$ 47*' Unit Costs  High'!$ C$ 14 = Q$ 48*' Unit Costs  High'!$ C$ 15 = Q$ 49*' Unit Costs  High'!$ C$ 16 = Q$ 50*' Unit Costs  High'!$ C$ 17 = Q$ 51*' Unit Costs  High'!$ D$ 18 = SUM( Q56: Q68) =' Inputs & Assumptions'!$ B$ 5* Q69 15 = Q$ 36*' Unit Costs  Medium'!$ B$ 6+ Q$ 37*' Unit Costs  Medium'!$ B$ 22+ Q$ 38*' Unit Costs  Medium'!$ B$ 38 = Q$ 39*' Unit Costs  Medium'!$ B$ 7+ Q$ 40*' Unit Costs  Medium'!$ B$ 23+ Q$ 38*' Unit Costs  Medium'! P$ 39 = Q$ 41*' Unit Costs  Medium'!$ B32 = Q$ 42*' Unit Costs  Medium'!$ B$ 9 = Q$ 43*' Unit Costs  Medium'!$ C$ 10 = Q$ 44*' Unit Costs  Medium'!$ C$ 11 = Q$ 45*' Unit Costs  Medium'!$ C$ 12 = Q$ 46*' Unit Costs  Medium'!$ C$ 13 = Q$ 47*' Unit Costs  Medium'!$ C$ 14 = Q$ 48*' Unit Costs  Medium'!$ C$ 15 = Q$ 49*' Unit Costs  Medium'!$ C$ 16 = Q$ 50*' Unit Costs  Medium'!$ C$ 17 = Q$ 51*' Unit Costs  Medium'!$ D$ 18 = SUM( Q79: Q91) =' Inputs & Assumptions'!$ B$ 5* Q92 February 14, 2003 63 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 A B C D 1 2 develop and issue permit = C$ 36*' Unit Costs  Low'!$ B$ 6+ C$ 37*' Unit Costs  Low'!$ B$ 22+ C$ 38*' Unit Costs  Low'!$ B$ 38 = D$ 36*' Unit Costs  Low'!$ B$ 6+ D$ 37*' Unit Costs  Low'!$ B$ 22+ D$ 38*' Unit Costs  Low'!$ B$ 38 provide technical guidance = C$ 39*' Unit Costs  Low'!$ B$ 7+ C$ 40*' Unit Costs  Low'!$ B$ 23+ C$ 38*' Unit Costs  Low'! B$ 39 = D$ 39*' Unit Costs  Low'!$ B$ 7+ D$ 40*' Unit Costs  Low'!$ B$ 23+ D$ 38*' Unit Costs  Low'! C$ 39 conduct public or evidentiary hearings = C$ 41*' Unit Costs  Low'!$ B$ 8 = D$ 41*' Unit Costs  Low'!$ B$ 8 inspection for permit development = C$ 42*' Unit Costs  Low'!$ B$ 9 = D$ 42*' Unit Costs  Low'!$ B$ 9 inspection for compliance assessment = C$ 43*' Unit Costs  Low'!$ C$ 10 = D$ 43*' Unit Costs  Low'!$ C$ 10 sample and analyze effluent = C$ 44*' Unit Costs  Low'!$ C$ 11 = D$ 44*' Unit Costs  Low'!$ C$ 11 review & record self monitoring reports = C$ 45*' Unit Costs  Low'!$ C$ 12 = D$ 45*' Unit Costs  Low'!$ C$ 12 process & act on non compliance reports = C$ 46*' Unit Costs  Low'!$ C$ 13 = D$ 46*' Unit Costs  Low'!$ C$ 13 review compliance schedule report  in compliance with schedule = C$ 47*' Unit Costs  Low'!$ C$ 14 = D$ 47*' Unit Costs  Low'!$ C$ 14 review compliance schedule report  not in compliance with schedule = C$ 48*' Unit Costs  Low'!$ C$ 15 = D$ 48*' Unit Costs  Low'!$ C$ 15 minor enforcement action ( e. g., admin order) = C$ 49*' Unit Costs  Low'!$ C$ 16 = D$ 49*' Unit Costs  Low'!$ C$ 16 minor enforcement action ( e. g., admin fine) = C$ 50*' Unit Costs  Low'!$ C$ 17 = D$ 50*' Unit Costs  Low'!$ C$ 17 repermit = C$ 51*' Unit Costs  Low'!$ D$ 18 = D$ 51*' Unit Costs  Low'!$ D$ 18 Total hours = SUM( C102: C114) = SUM( D102: D114) Total cost =' Inputs & Assumptions'!$ B$ 5* C115 =' Inputs & Assumptions'!$ B$ 5* D115 NPV of cost = NPV(' Inputs & Assumptions'! B$ 4, C116: Q116) Maximum one year hours = MAX( C115: Q115) Maximum one year costs = MAX( C116: Q116) Annualized over 15 years = PMT(' Inputs & Assumptions'! B$ 4,15, C117) Annualized over 15 years = PMT(' Inputs & Assumptions'! B$ 4,15, C118)

February 14, 2003 64 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 E F G H 3 4 5 6 = E$ 36*' Unit Costs  Low'!$ B$ 6+ E$ 37*' Unit Costs  Low'!$ B$ 22+ E$ 38*' Unit Costs  Low'!$ B$ 38 = F$ 36*' Unit Costs  Low'!$ B$ 6+ F$ 37*' Unit Costs  Low'!$ B$ 22+ F$ 38*' Unit Costs  Low'!$ B$ 38 = G$ 36*' Unit Costs  Low'!$ B$ 6+ G$ 37*' Unit Costs  Low'!$ B$ 22+ G$ 38*' Unit Costs  Low'!$ B$ 38 = H$ 36*' Unit Costs  Low'!$ B$ 6+ H$ 37*' Unit Costs  Low'!$ B$ 22+ H$ 38*' Unit Costs  Low'!$ B$ 38 = E$ 39*' Unit Costs  Low'!$ B$ 7+ E$ 40*' Unit Costs  Low'!$ B$ 23+ E$ 38*' Unit Costs  Low'! D$ 39 = F$ 39*' Unit Costs  Low'!$ B$ 7+ F$ 40*' Unit Costs  Low'!$ B$ 23+ F$ 38*' Unit Costs  Low'! E$ 39 = G$ 39*' Unit Costs  Low'!$ B$ 7+ G$ 40*' Unit Costs  Low'!$ B$ 23+ G$ 38*' Unit Costs  Low'! F$ 39 = H$ 39*' Unit Costs  Low'!$ B$ 7+ H$ 40*' Unit Costs  Low'!$ B$ 23+ H$ 38*' Unit Costs  Low'! G$ 39 = E$ 41*' Unit Costs  Low'!$ B$ 8 = F$ 41*' Unit Costs  Low'!$ B$ 8 = G$ 41*' Unit Costs  Low'!$ B$ 8 = H$ 41*' Unit Costs  Low'!$ B$ 8 = E$ 42*' Unit Costs  Low'!$ B$ 9 = F$ 42*' Unit Costs  Low'!$ B$ 9 = G$ 42*' Unit Costs  Low'!$ B$ 9 = H$ 42*' Unit Costs  Low'!$ B$ 9 = E$ 43*' Unit Costs  Low'!$ C$ 10 = F$ 43*' Unit Costs  Low'!$ C$ 10 = G$ 43*' Unit Costs  Low'!$ C$ 10 = H$ 43*' Unit Costs  Low'!$ C$ 10 = E$ 44*' Unit Costs  Low'!$ C$ 11 = F$ 44*' Unit Costs  Low'!$ C$ 11 = G$ 44*' Unit Costs  Low'!$ C$ 11 = H$ 44*' Unit Costs  Low'!$ C$ 11 = E$ 45*' Unit Costs  Low'!$ C$ 12 = F$ 45*' Unit Costs  Low'!$ C$ 12 = G$ 45*' Unit Costs  Low'!$ C$ 12 = H$ 45*' Unit Costs  Low'!$ C$ 12 = E$ 46*' Unit Costs  Low'!$ C$ 13 = F$ 46*' Unit Costs  Low'!$ C$ 13 = G$ 46*' Unit Costs  Low'!$ C$ 13 = H$ 46*' Unit Costs  Low'!$ C$ 13 = E$ 47*' Unit Costs  Low'!$ C$ 14 = F$ 47*' Unit Costs  Low'!$ C$ 14 = G$ 47*' Unit Costs  Low'!$ C$ 14 = H$ 47*' Unit Costs  Low'!$ C$ 14 = E$ 48*' Unit Costs  Low'!$ C$ 15 = F$ 48*' Unit Costs  Low'!$ C$ 15 = G$ 48*' Unit Costs  Low'!$ C$ 15 = H$ 48*' Unit Costs  Low'!$ C$ 15 = E$ 49*' Unit Costs  Low'!$ C$ 16 = F$ 49*' Unit Costs  Low'!$ C$ 16 = G$ 49*' Unit Costs  Low'!$ C$ 16 = H$ 49*' Unit Costs  Low'!$ C$ 16 = E$ 50*' Unit Costs  Low'!$ C$ 17 = F$ 50*' Unit Costs  Low'!$ C$ 17 = G$ 50*' Unit Costs  Low'!$ C$ 17 = H$ 50*' Unit Costs  Low'!$ C$ 17 = E$ 51*' Unit Costs  Low'!$ D$ 18 = F$ 51*' Unit Costs  Low'!$ D$ 18 = G$ 51*' Unit Costs  Low'!$ D$ 18 = H$ 51*' Unit Costs  Low'!$ D$ 18 = SUM( E102: E114) = SUM( F102: F114) = SUM( G102: G114) = SUM( H102: H114) =' Inputs & Assumptions'!$ B$ 5* E115 =' Inputs & Assumptions'!$ B$ 5* F115 =' Inputs & Assumptions'!$ B$ 5* G115 =' Inputs & Assumptions'!$ B$ 5* H115 February 14, 2003 65 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 I J K L Year Relative to Promulgation of Rule 7 8 9 10 = I$ 36*' Unit Costs  Low'!$ B$ 6+ I$ 37*' Unit Costs  Low'!$ B$ 22+ I$ 38*' Unit Costs  Low'!$ B$ 38 = J$ 36*' Unit Costs  Low'!$ B$ 6+ J$ 37*' Unit Costs  Low'!$ B$ 22+ J$ 38*' Unit Costs  Low'!$ B$ 38 = K$ 36*' Unit Costs  Low'!$ B$ 6+ K$ 37*' Unit Costs  Low'!$ B$ 22+ K$ 38*' Unit Costs  Low'!$ B$ 38 = L$ 36*' Unit Costs  Low'!$ B$ 6+ L$ 37*' Unit Costs  Low'!$ B$ 22+ L$ 38*' Unit Costs  Low'!$ B$ 38 = I$ 39*' Unit Costs  Low'!$ B$ 7+ I$ 40*' Unit Costs  Low'!$ B$ 23+ I$ 38*' Unit Costs  Low'! H$ 39 = J$ 39*' Unit Costs  Low'!$ B$ 7+ J$ 40*' Unit Costs  Low'!$ B$ 23+ J$ 38*' Unit Costs  Low'! I$ 39 = K$ 39*' Unit Costs  Low'!$ B$ 7+ K$ 40*' Unit Costs  Low'!$ B$ 23+ K$ 38*' Unit Costs  Low'! J$ 39 = L$ 39*' Unit Costs  Low'!$ B$ 7+ L$ 40*' Unit Costs  Low'!$ B$ 23+ L$ 38*' Unit Costs  Low'! K$ 39 = I$ 41*' Unit Costs  Low'!$ B$ 8 = J$ 41*' Unit Costs  Low'!$ B$ 8 = K$ 41*' Unit Costs  Low'!$ B$ 8 = L$ 41*' Unit Costs  Low'!$ B$ 8 = I$ 42*' Unit Costs  Low'!$ B$ 9 = J$ 42*' Unit Costs  Low'!$ B$ 9 = K$ 42*' Unit Costs  Low'!$ B$ 9 = L$ 42*' Unit Costs  Low'!$ B$ 9 = I$ 43*' Unit Costs  Low'!$ C$ 10 = J$ 43*' Unit Costs  Low'!$ C$ 10 = K$ 43*' Unit Costs  Low'!$ C$ 10 = L$ 43*' Unit Costs  Low'!$ C$ 10 = I$ 44*' Unit Costs  Low'!$ C$ 11 = J$ 44*' Unit Costs  Low'!$ C$ 11 = K$ 44*' Unit Costs  Low'!$ C$ 11 = L$ 44*' Unit Costs  Low'!$ C$ 11 = I$ 45*' Unit Costs  Low'!$ C$ 12 = J$ 45*' Unit Costs  Low'!$ C$ 12 = K$ 45*' Unit Costs  Low'!$ C$ 12 = L$ 45*' Unit Costs  Low'!$ C$ 12 = I$ 46*' Unit Costs  Low'!$ C$ 13 = J$ 46*' Unit Costs  Low'!$ C$ 13 = K$ 46*' Unit Costs  Low'!$ C$ 13 = L$ 46*' Unit Costs  Low'!$ C$ 13 = I$ 47*' Unit Costs  Low'!$ C$ 14 = J$ 47*' Unit Costs  Low'!$ C$ 14 = K$ 47*' Unit Costs  Low'!$ C$ 14 = L$ 47*' Unit Costs  Low'!$ C$ 14 = I$ 48*' Unit Costs  Low'!$ C$ 15 = J$ 48*' Unit Costs  Low'!$ C$ 15 = K$ 48*' Unit Costs  Low'!$ C$ 15 = L$ 48*' Unit Costs  Low'!$ C$ 15 = I$ 49*' Unit Costs  Low'!$ C$ 16 = J$ 49*' Unit Costs  Low'!$ C$ 16 = K$ 49*' Unit Costs  Low'!$ C$ 16 = L$ 49*' Unit Costs  Low'!$ C$ 16 = I$ 50*' Unit Costs  Low'!$ C$ 17 = J$ 50*' Unit Costs  Low'!$ C$ 17 = K$ 50*' Unit Costs  Low'!$ C$ 17 = L$ 50*' Unit Costs  Low'!$ C$ 17 = I$ 51*' Unit Costs  Low'!$ D$ 18 = J$ 51*' Unit Costs  Low'!$ D$ 18 = K$ 51*' Unit Costs  Low'!$ D$ 18 = L$ 51*' Unit Costs  Low'!$ D$ 18 = SUM( I102: I114) = SUM( J102: J114) = SUM( K102: K114) = SUM( L102: L114) =' Inputs & Assumptions'!$ B$ 5* I115 =' Inputs & Assumptions'!$ B$ 5* J115 =' Inputs & Assumptions'!$ B$ 5* K115 =' Inputs & Assumptions'!$ B$ 5* L115 February 14, 2003 66 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 M N O P 11 12 13 14 = M$ 36*' Unit Costs  Low'!$ B$ 6+ M$ 37*' Unit Costs  Low'!$ B$ 22+ M$ 38*' Unit Costs  Low'!$ B$ 38 = N$ 36*' Unit Costs  Low'!$ B$ 6+ N$ 37*' Unit Costs  Low'!$ B$ 22+ N$ 38*' Unit Costs  Low'!$ B$ 38 = O$ 36*' Unit Costs  Low'!$ B$ 6+ O$ 37*' Unit Costs  Low'!$ B$ 22+ O$ 38*' Unit Costs  Low'!$ B$ 38 = P$ 36*' Unit Costs  Low'!$ B$ 6+ P$ 37*' Unit Costs  Low'!$ B$ 22+ P$ 38*' Unit Costs  Low'!$ B$ 38 = M$ 39*' Unit Costs  Low'!$ B$ 7+ M$ 40*' Unit Costs  Low'!$ B$ 23+ M$ 38*' Unit Costs  Low'! L$ 39 = N$ 39*' Unit Costs  Low'!$ B$ 7+ N$ 40*' Unit Costs  Low'!$ B$ 23+ N$ 38*' Unit Costs  Low'! M$ 39 = O$ 39*' Unit Costs  Low'!$ B$ 7+ O$ 40*' Unit Costs  Low'!$ B$ 23+ O$ 38*' Unit Costs  Low'! N$ 39 = P$ 39*' Unit Costs  Low'!$ B$ 7+ P$ 40*' Unit Costs  Low'!$ B$ 23+ P$ 38*' Unit Costs  Low'! O$ 39 = M$ 41*' Unit Costs  Low'!$ B$ 8 = N$ 41*' Unit Costs  Low'!$ B$ 8 = O$ 41*' Unit Costs  Low'!$ B$ 8 = P$ 41*' Unit Costs  Low'!$ B$ 8 = M$ 42*' Unit Costs  Low'!$ B$ 9 = N$ 42*' Unit Costs  Low'!$ B$ 9 = O$ 42*' Unit Costs  Low'!$ B$ 9 = P$ 42*' Unit Costs  Low'!$ B$ 9 = M$ 43*' Unit Costs  Low'!$ C$ 10 = N$ 43*' Unit Costs  Low'!$ C$ 10 = O$ 43*' Unit Costs  Low'!$ C$ 10 = P$ 43*' Unit Costs  Low'!$ C$ 10 = M$ 44*' Unit Costs  Low'!$ C$ 11 = N$ 44*' Unit Costs  Low'!$ C$ 11 = O$ 44*' Unit Costs  Low'!$ C$ 11 = P$ 44*' Unit Costs  Low'!$ C$ 11 = M$ 45*' Unit Costs  Low'!$ C$ 12 = N$ 45*' Unit Costs  Low'!$ C$ 12 = O$ 45*' Unit Costs  Low'!$ C$ 12 = P$ 45*' Unit Costs  Low'!$ C$ 12 = M$ 46*' Unit Costs  Low'!$ C$ 13 = N$ 46*' Unit Costs  Low'!$ C$ 13 = O$ 46*' Unit Costs  Low'!$ C$ 13 = P$ 46*' Unit Costs  Low'!$ C$ 13 = M$ 47*' Unit Costs  Low'!$ C$ 14 = N$ 47*' Unit Costs  Low'!$ C$ 14 = O$ 47*' Unit Costs  Low'!$ C$ 14 = P$ 47*' Unit Costs  Low'!$ C$ 14 = M$ 48*' Unit Costs  Low'!$ C$ 15 = N$ 48*' Unit Costs  Low'!$ C$ 15 = O$ 48*' Unit Costs  Low'!$ C$ 15 = P$ 48*' Unit Costs  Low'!$ C$ 15 = M$ 49*' Unit Costs  Low'!$ C$ 16 = N$ 49*' Unit Costs  Low'!$ C$ 16 = O$ 49*' Unit Costs  Low'!$ C$ 16 = P$ 49*' Unit Costs  Low'!$ C$ 16 = M$ 50*' Unit Costs  Low'!$ C$ 17 = N$ 50*' Unit Costs  Low'!$ C$ 17 = O$ 50*' Unit Costs  Low'!$ C$ 17 = P$ 50*' Unit Costs  Low'!$ C$ 17 = M$ 51*' Unit Costs  Low'!$ D$ 18 = N$ 51*' Unit Costs  Low'!$ D$ 18 = O$ 51*' Unit Costs  Low'!$ D$ 18 = P$ 51*' Unit Costs  Low'!$ D$ 18 = SUM( M102: M114) = SUM( N102: N114) = SUM( O102: O114) = SUM( P102: P114) =' Inputs & Assumptions'!$ B$ 5* M115 =' Inputs & Assumptions'!$ B$ 5* N115 =' Inputs & Assumptions'!$ B$ 5* O115 =' Inputs & Assumptions'!$ B$ 5* P115 February 14, 2003 67 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 Q 15 = Q$ 36*' Unit Costs  Low'!$ B$ 6+ Q$ 37*' Unit Costs  Low'!$ B$ 22+ Q$ 38*' Unit Costs  Low'!$ B$ 38 = Q$ 39*' Unit Costs  Low'!$ B$ 7+ Q$ 40*' Unit Costs  Low'!$ B$ 23+ Q$ 38*' Unit Costs  Low'! P$ 39 = Q$ 41*' Unit Costs  Low'!$ B$ 8 = Q$ 42*' Unit Costs  Low'!$ B$ 9 = Q$ 43*' Unit Costs  Low'!$ C$ 10 = Q$ 44*' Unit Costs  Low'!$ C$ 11 = Q$ 45*' Unit Costs  Low'!$ C$ 12 = Q$ 46*' Unit Costs  Low'!$ C$ 13 = Q$ 47*' Unit Costs  Low'!$ C$ 14 = Q$ 48*' Unit Costs  Low'!$ C$ 15 = Q$ 49*' Unit Costs  Low'!$ C$ 16 = Q$ 50*' Unit Costs  Low'!$ C$ 17 = Q$ 51*' Unit Costs  Low'!$ D$ 18 = SUM( Q102: Q114) =' Inputs & Assumptions'!$ B$ 5* Q115 February 14, 2003 68 of 79 AD MP& M7A formula. xls  Results  Option 2 6 10 Record for the Final Metal Product and Machinery Rule 1 2 34 5678 9 10 11 12 A B C D Summary of Incremental Costs per Facility High Medium Low Annualized over 15 years at 3 percent New concentration based permit =' Unit Costs  High'!$ B$ 71 =' Unit Costs  Medium'!$ B$ 71 =' Unit Costs  Low'!$ B$ 71 New mass based permit =' Unit Costs  High'!$ C$ 71 =' Unit Costs  Medium'!$ C$ 71 =' Unit Costs  Low'!$ C$ 71 Upgrading from concentration based to mass based =' Unit Costs  High'!$ D$ 71 =' Unit Costs  Medium'!$ D$ 71 =' Unit Costs  Low'!$ D$ 71 Annualized over 15 years at 7 percent New concentration based permit =' Unit Costs  High'!$ B$ 74 =' Unit Costs  Medium'!$ B$ 74 =' Unit Costs  Low'!$ B$ 74 New mass based permit =' Unit Costs  High'!$ C$ 74 =' Unit Costs  Medium'!$ C$ 74 =' Unit Costs  Low'!$ C$ 74 Upgrading from concentration based to mass based =' Unit Costs  High'!$ D$ 74 =' Unit Costs  Medium'!$ D$ 74 =' Unit Costs  Low'!$ D$ 74 February 14, 2003 69 of 79 AD MP& M7A formula. xls  Unit Cost Summary Record for the Final Metal Product and Machinery Rule 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A B C D High Estimate of Hours and Costs per Facility Activity Initial Year Annual ( non permitting year) Repermit Year New concentration based permit develop and issue permit =' Inputs & Assumptions'!$ D12*' Inputs & Assumptions'!$ E12*' Inputs & Assumptions'!$ F12 provide technical guidance =' Inputs & Assumptions'!$ D13*' Inputs & Assumptions'!$ E13*' Inputs & Assumptions'!$ F13 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ D14*' Inputs & Assumptions'!$ E14*' Inputs & Assumptions'!$ F14 inspection for permit development =' Inputs & Assumptions'!$ D15*' Inputs & Assumptions'!$ E15*' Inputs & Assumptions'!$ F15 inspection for compliance assessment =' Inputs & Assumptions'!$ D16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 =' Inputs & Assumptions'!$ D16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 =' Inputs & Assumptions'!$ D16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 sample and analyze effluent =' Inputs & Assumptions'!$ D17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 =' Inputs & Assumptions'!$ D17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 =' Inputs & Assumptions'!$ D17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 review & record self monitoring reports =' Inputs & Assumptions'!$ D18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 =' Inputs & Assumptions'!$ D18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 =' Inputs & Assumptions'!$ D18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 process & act on non compliance reports =' Inputs & Assumptions'!$ D19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 =' Inputs & Assumptions'!$ D19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 =' Inputs & Assumptions'!$ D19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ D20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 =' Inputs & Assumptions'!$ D20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 =' Inputs & Assumptions'!$ D20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ D21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 =' Inputs & Assumptions'!$ D21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 =' Inputs & Assumptions'!$ D21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ D22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 =' Inputs & Assumptions'!$ D22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 =' Inputs & Assumptions'!$ D22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ D23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 =' Inputs & Assumptions'!$ D23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 =' Inputs & Assumptions'!$ D23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 repermit =' Inputs & Assumptions'!$ D24*' Inputs & Assumptions'!$ E24*' Inputs & Assumptions'!$ F24 Total Hours by Year = SUM( B6: B18) = SUM( C6: C18) = SUM( D6: D18) Total Dollars by Year = B19*' Inputs & Assumptions'!$ B$ 5 = C19*' Inputs & Assumptions'!$ B$ 5 = D19*' Inputs & Assumptions'!$ B$ 5 New mass based permit develop and issue permit =' Inputs & Assumptions'!$ D26*' Inputs & Assumptions'!$ E26*' Inputs & Assumptions'!$ F26 provide technical guidance =' Inputs & Assumptions'!$ D27*' Inputs & Assumptions'!$ E27*' Inputs & Assumptions'!$ F27 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ D28*' Inputs & Assumptions'!$ E28*' Inputs & Assumptions'!$ F28 ( average considering frequency of activity and percent of facilities requiring activity)

February 14, 2003 70 of 79 AD MP& M7A formula. xls  Unit Costs  High Record for the Final Metal Product and Machinery Rule 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 A B C D inspection for permit development =' Inputs & Assumptions'!$ D29*' Inputs & Assumptions'!$ E29*' Inputs & Assumptions'!$ F29 inspection for compliance assessment =' Inputs & Assumptions'!$ D30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 =' Inputs & Assumptions'!$ D30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 =' Inputs & Assumptions'!$ D30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 sample and analyze effluent =' Inputs & Assumptions'!$ D31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 =' Inputs & Assumptions'!$ D31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 =' Inputs & Assumptions'!$ D31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 review & record self monitoring reports =' Inputs & Assumptions'!$ D32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 =' Inputs & Assumptions'!$ D32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 =' Inputs & Assumptions'!$ D32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 process & act on non compliance reports =' Inputs & Assumptions'!$ D33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 =' Inputs & Assumptions'!$ D33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 =' Inputs & Assumptions'!$ D33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ D34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 =' Inputs & Assumptions'!$ D34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 =' Inputs & Assumptions'!$ D34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ D35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 =' Inputs & Assumptions'!$ D35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 =' Inputs & Assumptions'!$ D35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ D36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 =' Inputs & Assumptions'!$ D36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 =' Inputs & Assumptions'!$ D36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ D37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 =' Inputs & Assumptions'!$ D37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 =' Inputs & Assumptions'!$ D37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 repermit =' Inputs & Assumptions'!$ D38*' Inputs & Assumptions'!$ E38*' Inputs & Assumptions'!$ F38 Total Hours by Year = SUM( B22: B34) = SUM( C22: C34) = SUM( D22: D34) Total Dollars by Year = B35*' Inputs & Assumptions'!$ B$ 5 = C35*' Inputs & Assumptions'!$ B$ 5 = D35*' Inputs & Assumptions'!$ B$ 5 Upgrading from concentration based to mass based develop and issue permit =' Inputs & Assumptions'!$ D40*' Inputs & Assumptions'!$ E40*' Inputs & Assumptions'!$ F40 provide technical guidance =' Inputs & Assumptions'!$ D41*' Inputs & Assumptions'!$ E41*' Inputs & Assumptions'!$ F41 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ D42*' Inputs & Assumptions'!$ E42*' Inputs & Assumptions'!$ F42 inspection for permit development =' Inputs & Assumptions'!$ D43*' Inputs & Assumptions'!$ E43*' Inputs & Assumptions'!$ F43 inspection for compliance assessment =' Inputs & Assumptions'!$ D44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 =' Inputs & Assumptions'!$ D44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 =' Inputs & Assumptions'!$ D44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 sample and analyze effluent =' Inputs & Assumptions'!$ D45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 =' Inputs & Assumptions'!$ D45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 =' Inputs & Assumptions'!$ D45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 review & record self monitoring reports =' Inputs & Assumptions'!$ D46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 =' Inputs & Assumptions'!$ D46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 =' Inputs & Assumptions'!$ D46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 process & act on non compliance reports =' Inputs & Assumptions'!$ D47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 =' Inputs & Assumptions'!$ D47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 =' Inputs & Assumptions'!$ D47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 February 14, 2003 71 of 79 AD MP& M7A formula. xls  Unit Costs  High Record for the Final Metal Product and Machinery Rule 46 47 48 49 50 51 52 A B C D review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ D48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 =' Inputs & Assumptions'!$ D48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 =' Inputs & Assumptions'!$ D48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ D49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 =' Inputs & Assumptions'!$ D49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 =' Inputs & Assumptions'!$ D49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ D50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 =' Inputs & Assumptions'!$ D50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 =' Inputs & Assumptions'!$ D50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ D51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 =' Inputs & Assumptions'!$ D51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 =' Inputs & Assumptions'!$ D51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 repermit =' Inputs & Assumptions'!$ D52*' Inputs & Assumptions'!$ E52*' Inputs & Assumptions'!$ F52 Total Hours by Year = SUM( B38: B50) = SUM( C38: C50) = SUM( D38: D50) Total Dollars by Year = B51*' Inputs & Assumptions'!$ B$ 5 = C51*' Inputs & Assumptions'!$ B$ 5 = D51*' Inputs & Assumptions'!$ B$ 5 February 14, 2003 72 of 79 AD MP& M7A formula. xls  Unit Costs  High Record for the Final Metal Product and Machinery Rule 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A B C D Medium Estimate of Hours and Costs per Facility Activity Initial Year Annual ( non permitting year) Repermit Year New concentration based permit develop and issue permit =' Inputs & Assumptions'!$ C12*' Inputs & Assumptions'!$ E12*' Inputs & Assumptions'!$ F12 provide technical guidance =' Inputs & Assumptions'!$ C13*' Inputs & Assumptions'!$ E13*' Inputs & Assumptions'!$ F13 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ C14*' Inputs & Assumptions'!$ E14*' Inputs & Assumptions'!$ F14 inspection for permit development =' Inputs & Assumptions'!$ C15*' Inputs & Assumptions'!$ E15*' Inputs & Assumptions'!$ F15 inspection for compliance assessment =' Inputs & Assumptions'!$ C16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 =' Inputs & Assumptions'!$ C16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 =' Inputs & Assumptions'!$ C16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 sample and analyze effluent =' Inputs & Assumptions'!$ C17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 =' Inputs & Assumptions'!$ C17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 =' Inputs & Assumptions'!$ C17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 review & record self monitoring reports =' Inputs & Assumptions'!$ C18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 =' Inputs & Assumptions'!$ C18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 =' Inputs & Assumptions'!$ C18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 process & act on non compliance reports =' Inputs & Assumptions'!$ C19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 =' Inputs & Assumptions'!$ C19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 =' Inputs & Assumptions'!$ C19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ C20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 =' Inputs & Assumptions'!$ C20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 =' Inputs & Assumptions'!$ C20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ C21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 =' Inputs & Assumptions'!$ C21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 =' Inputs & Assumptions'!$ C21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ C22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 =' Inputs & Assumptions'!$ C22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 =' Inputs & Assumptions'!$ C22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ C23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 =' Inputs & Assumptions'!$ C23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 =' Inputs & Assumptions'!$ C23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 repermit =' Inputs & Assumptions'!$ C24*' Inputs & Assumptions'!$ E24*' Inputs & Assumptions'!$ F24 Total Hours by Year = SUM( B6: B18) = SUM( C6: C18) = SUM( D6: D18) Total Dollars by Year = B19*' Inputs & Assumptions'!$ B$ 5 = C19*' Inputs & Assumptions'!$ B$ 5 = D19*' Inputs & Assumptions'!$ B$ 5 New mass based permit develop and issue permit =' Inputs & Assumptions'!$ C26*' Inputs & Assumptions'!$ E26*' Inputs & Assumptions'!$ F26 provide technical guidance =' Inputs & Assumptions'!$ C27*' Inputs & Assumptions'!$ E27*' Inputs & Assumptions'!$ F27 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ C28*' Inputs & Assumptions'!$ E28*' Inputs & Assumptions'!$ F28 ( average considering frequency of activity and percent of facilities requiring activity)

February 14, 2003 73 of 79 AD MP& M7A formula. xls  Unit Costs  Medium Record for the Final Metal Product and Machinery Rule 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 A B C D inspection for permit development =' Inputs & Assumptions'!$ C29*' Inputs & Assumptions'!$ E29*' Inputs & Assumptions'!$ F29 inspection for compliance assessment =' Inputs & Assumptions'!$ C30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 =' Inputs & Assumptions'!$ C30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 =' Inputs & Assumptions'!$ C30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 sample and analyze effluent =' Inputs & Assumptions'!$ C31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 =' Inputs & Assumptions'!$ C31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 =' Inputs & Assumptions'!$ C31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 review & record self monitoring reports =' Inputs & Assumptions'!$ C32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 =' Inputs & Assumptions'!$ C32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 =' Inputs & Assumptions'!$ C32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 process & act on non compliance reports =' Inputs & Assumptions'!$ C33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 =' Inputs & Assumptions'!$ C33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 =' Inputs & Assumptions'!$ C33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ C34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 =' Inputs & Assumptions'!$ C34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 =' Inputs & Assumptions'!$ C34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ C35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 =' Inputs & Assumptions'!$ C35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 =' Inputs & Assumptions'!$ C35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ C36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 =' Inputs & Assumptions'!$ C36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 =' Inputs & Assumptions'!$ C36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ C37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 =' Inputs & Assumptions'!$ C37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 =' Inputs & Assumptions'!$ C37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 repermit =' Inputs & Assumptions'!$ C38*' Inputs & Assumptions'!$ E38*' Inputs & Assumptions'!$ F38 Total Hours by Year = SUM( B22: B34) = SUM( C22: C34) = SUM( D22: D34) Total Dollars by Year = B35*' Inputs & Assumptions'!$ B$ 5 = C35*' Inputs & Assumptions'!$ B$ 5 = D35*' Inputs & Assumptions'!$ B$ 5 Upgrading from concentration based to mass based develop and issue permit =' Inputs & Assumptions'!$ C40*' Inputs & Assumptions'!$ E40*' Inputs & Assumptions'!$ F40 provide technical guidance =' Inputs & Assumptions'!$ C41*' Inputs & Assumptions'!$ E41*' Inputs & Assumptions'!$ F41 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ C42*' Inputs & Assumptions'!$ E42*' Inputs & Assumptions'!$ F42 inspection for permit development =' Inputs & Assumptions'!$ C43*' Inputs & Assumptions'!$ E43*' Inputs & Assumptions'!$ F43 inspection for compliance assessment =' Inputs & Assumptions'!$ C44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 =' Inputs & Assumptions'!$ C44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 =' Inputs & Assumptions'!$ C44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 sample and analyze effluent =' Inputs & Assumptions'!$ C45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 =' Inputs & Assumptions'!$ C45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 =' Inputs & Assumptions'!$ C45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 review & record self monitoring reports =' Inputs & Assumptions'!$ C46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 =' Inputs & Assumptions'!$ C46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 =' Inputs & Assumptions'!$ C46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 process & act on non compliance reports =' Inputs & Assumptions'!$ C47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 =' Inputs & Assumptions'!$ C47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 =' Inputs & Assumptions'!$ C47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 February 14, 2003 74 of 79 AD MP& M7A formula. xls  Unit Costs  Medium Record for the Final Metal Product and Machinery Rule 46 47 48 49 50 51 52 A B C D review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ C48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 =' Inputs & Assumptions'!$ C48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 =' Inputs & Assumptions'!$ C48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ C49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 =' Inputs & Assumptions'!$ C49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 =' Inputs & Assumptions'!$ C49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ C50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 =' Inputs & Assumptions'!$ C50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 =' Inputs & Assumptions'!$ C50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ C51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 =' Inputs & Assumptions'!$ C51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 =' Inputs & Assumptions'!$ C51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 repermit =' Inputs & Assumptions'!$ C52*' Inputs & Assumptions'!$ E52*' Inputs & Assumptions'!$ F52 Total Hours by Year = SUM( B38: B50) = SUM( C38: C50) = SUM( D38: D50) Total Dollars by Year = B51*' Inputs & Assumptions'!$ B$ 5 = C51*' Inputs & Assumptions'!$ B$ 5 = D51*' Inputs & Assumptions'!$ B$ 5 February 14, 2003 75 of 79 AD MP& M7A formula. xls  Unit Costs  Medium Record for the Final Metal Product and Machinery Rule 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A B C D Low Estimate of Hours and Costs per Facility Activity Initial Year Annual ( non permitting year) Repermit Year New concentration based permit develop and issue permit =' Inputs & Assumptions'!$ B12*' Inputs & Assumptions'!$ E12*' Inputs & Assumptions'!$ F12 provide technical guidance =' Inputs & Assumptions'!$ B13*' Inputs & Assumptions'!$ E13*' Inputs & Assumptions'!$ F13 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ B14*' Inputs & Assumptions'!$ E14*' Inputs & Assumptions'!$ F14 inspection for permit development =' Inputs & Assumptions'!$ B15*' Inputs & Assumptions'!$ E15*' Inputs & Assumptions'!$ F15 inspection for compliance assessment =' Inputs & Assumptions'!$ B16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 =' Inputs & Assumptions'!$ B16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 =' Inputs & Assumptions'!$ B16*' Inputs & Assumptions'!$ E16*' Inputs & Assumptions'!$ F16 sample and analyze effluent =' Inputs & Assumptions'!$ B17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 =' Inputs & Assumptions'!$ B17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 =' Inputs & Assumptions'!$ B17*' Inputs & Assumptions'!$ E17*' Inputs & Assumptions'!$ F17 review & record self monitoring reports =' Inputs & Assumptions'!$ B18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 =' Inputs & Assumptions'!$ B18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 =' Inputs & Assumptions'!$ B18*' Inputs & Assumptions'!$ E18*' Inputs & Assumptions'!$ F18 process & act on non compliance reports =' Inputs & Assumptions'!$ B19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 =' Inputs & Assumptions'!$ B19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 =' Inputs & Assumptions'!$ B19*' Inputs & Assumptions'!$ E19*' Inputs & Assumptions'!$ F19 review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ B20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 =' Inputs & Assumptions'!$ B20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 =' Inputs & Assumptions'!$ B20*' Inputs & Assumptions'!$ E20*' Inputs & Assumptions'!$ F20 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ B21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 =' Inputs & Assumptions'!$ B21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 =' Inputs & Assumptions'!$ B21*' Inputs & Assumptions'!$ E21*' Inputs & Assumptions'!$ F21 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ B22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 =' Inputs & Assumptions'!$ B22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 =' Inputs & Assumptions'!$ B22*' Inputs & Assumptions'!$ E22*' Inputs & Assumptions'!$ F22 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ B23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 =' Inputs & Assumptions'!$ B23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 =' Inputs & Assumptions'!$ B23*' Inputs & Assumptions'!$ E23*' Inputs & Assumptions'!$ F23 repermit =' Inputs & Assumptions'!$ B24*' Inputs & Assumptions'!$ E24*' Inputs & Assumptions'!$ F24 Total Hours by Year = SUM( B6: B18) = SUM( C6: C18) = SUM( D6: D18) Total Dollars by Year = B19*' Inputs & Assumptions'!$ B$ 5 = C19*' Inputs & Assumptions'!$ B$ 5 = D19*' Inputs & Assumptions'!$ B$ 5 New mass based permit develop and issue permit =' Inputs & Assumptions'!$ B26*' Inputs & Assumptions'!$ E26*' Inputs & Assumptions'!$ F26 provide technical guidance =' Inputs & Assumptions'!$ B27*' Inputs & Assumptions'!$ E27*' Inputs & Assumptions'!$ F27 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ B28*' Inputs & Assumptions'!$ E28*' Inputs & Assumptions'!$ F28 ( average considering frequency of activity and percent of facilities requiring activity)

February 14, 2003 76 of 79 AD MP& M7A formula. xls  Unit Costs  Low Record for the Final Metal Product and Machinery Rule 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 A B C D inspection for permit development =' Inputs & Assumptions'!$ B29*' Inputs & Assumptions'!$ E29*' Inputs & Assumptions'!$ F29 inspection for compliance assessment =' Inputs & Assumptions'!$ B30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 =' Inputs & Assumptions'!$ B30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 =' Inputs & Assumptions'!$ B30*' Inputs & Assumptions'!$ E30*' Inputs & Assumptions'!$ F30 sample and analyze effluent =' Inputs & Assumptions'!$ B31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 =' Inputs & Assumptions'!$ B31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 =' Inputs & Assumptions'!$ B31*' Inputs & Assumptions'!$ E31*' Inputs & Assumptions'!$ F31 review & record self monitoring reports =' Inputs & Assumptions'!$ B32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 =' Inputs & Assumptions'!$ B32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 =' Inputs & Assumptions'!$ B32*' Inputs & Assumptions'!$ E32*' Inputs & Assumptions'!$ F32 process & act on non compliance reports =' Inputs & Assumptions'!$ B33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 =' Inputs & Assumptions'!$ B33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 =' Inputs & Assumptions'!$ B33*' Inputs & Assumptions'!$ E33*' Inputs & Assumptions'!$ F33 review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ B34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 =' Inputs & Assumptions'!$ B34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 =' Inputs & Assumptions'!$ B34*' Inputs & Assumptions'!$ E34*' Inputs & Assumptions'!$ F34 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ B35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 =' Inputs & Assumptions'!$ B35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 =' Inputs & Assumptions'!$ B35*' Inputs & Assumptions'!$ E35*' Inputs & Assumptions'!$ F35 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ B36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 =' Inputs & Assumptions'!$ B36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 =' Inputs & Assumptions'!$ B36*' Inputs & Assumptions'!$ E36*' Inputs & Assumptions'!$ F36 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ B37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 =' Inputs & Assumptions'!$ B37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 =' Inputs & Assumptions'!$ B37*' Inputs & Assumptions'!$ E37*' Inputs & Assumptions'!$ F37 repermit =' Inputs & Assumptions'!$ B38*' Inputs & Assumptions'!$ E38*' Inputs & Assumptions'!$ F38 Total Hours by Year = SUM( B22: B34) = SUM( C22: C34) = SUM( D22: D34) Total Dollars by Year = B35*' Inputs & Assumptions'!$ B$ 5 = C35*' Inputs & Assumptions'!$ B$ 5 = D35*' Inputs & Assumptions'!$ B$ 5 Upgrading from concentration based to mass based develop and issue permit =' Inputs & Assumptions'!$ B40*' Inputs & Assumptions'!$ E40*' Inputs & Assumptions'!$ F40 provide technical guidance =' Inputs & Assumptions'!$ B41*' Inputs & Assumptions'!$ E41*' Inputs & Assumptions'!$ F41 conduct public or evidentiary hearings =' Inputs & Assumptions'!$ B42*' Inputs & Assumptions'!$ E42*' Inputs & Assumptions'!$ F42 inspection for permit development =' Inputs & Assumptions'!$ B43*' Inputs & Assumptions'!$ E43*' Inputs & Assumptions'!$ F43 inspection for compliance assessment =' Inputs & Assumptions'!$ B44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 =' Inputs & Assumptions'!$ B44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 =' Inputs & Assumptions'!$ B44*' Inputs & Assumptions'!$ E44*' Inputs & Assumptions'!$ F44 sample and analyze effluent =' Inputs & Assumptions'!$ B45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 =' Inputs & Assumptions'!$ B45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 =' Inputs & Assumptions'!$ B45*' Inputs & Assumptions'!$ E45*' Inputs & Assumptions'!$ F45 review & record self monitoring reports =' Inputs & Assumptions'!$ B46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 =' Inputs & Assumptions'!$ B46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 =' Inputs & Assumptions'!$ B46*' Inputs & Assumptions'!$ E46*' Inputs & Assumptions'!$ F46 process & act on non compliance reports =' Inputs & Assumptions'!$ B47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 =' Inputs & Assumptions'!$ B47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 =' Inputs & Assumptions'!$ B47*' Inputs & Assumptions'!$ E47*' Inputs & Assumptions'!$ F47 February 14, 2003 77 of 79 AD MP& M7A formula. xls  Unit Costs  Low Record for the Final Metal Product and Machinery Rule 46 47 48 49 50 51 52 A B C D review compliance schedule report  in compliance with schedule =' Inputs & Assumptions'!$ B48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 =' Inputs & Assumptions'!$ B48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 =' Inputs & Assumptions'!$ B48*' Inputs & Assumptions'!$ E48*' Inputs & Assumptions'!$ F48 review compliance schedule report  not in compliance with schedule =' Inputs & Assumptions'!$ B49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 =' Inputs & Assumptions'!$ B49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 =' Inputs & Assumptions'!$ B49*' Inputs & Assumptions'!$ E49*' Inputs & Assumptions'!$ F49 minor enforcement action ( e. g., admin order) =' Inputs & Assumptions'!$ B50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 =' Inputs & Assumptions'!$ B50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 =' Inputs & Assumptions'!$ B50*' Inputs & Assumptions'!$ E50*' Inputs & Assumptions'!$ F50 minor enforcement action ( e. g., admin fine) =' Inputs & Assumptions'!$ B51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 =' Inputs & Assumptions'!$ B51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 =' Inputs & Assumptions'!$ B51*' Inputs & Assumptions'!$ E51*' Inputs & Assumptions'!$ F51 repermit =' Inputs & Assumptions'!$ B52*' Inputs & Assumptions'!$ E52*' Inputs & Assumptions'!$ F52 Total Hours by Year = SUM( B38: B50) = SUM( C38: C50) = SUM( D38: D50) Total Dollars by Year = B51*' Inputs & Assumptions'!$ B$ 5 = C51*' Inputs & Assumptions'!$ B$ 5 = D51*' Inputs & Assumptions'!$ B$ 5 February 14, 2003 78 of 79 AD MP& M7A formula. xls  Unit Costs  Low Record for the Final Metal Product and Machinery Rule 1 23456 7 89 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 A B C D E F G Inputs & Assumptions Source: estimates of hours by activity and average hourly rate from the 1996 MP& M POTW Survey. Discount rate: 7% Average hourly rate: $ 36.98 ( 1999$)

Permitting Activities and Assumptions Activity Low Medium High % Facil x/ yr Notes New concentration based permit develop and issue permit 3.7 9.7 30.7 100.0% 1 one time provide technical guidance 1.0 3.3 10.7 100.0% 1 one time conduct public or evidentiary hearings 2.3 8.0 33.3 3.2% 1 one time, 3.2% of facilities inspection for permit development 2.3 4.7 12.0 100.0% 1 one time inspection for compliance assessment 1.8 3.7 10.0 100.0% 1 annual sample and analyze effluent 1.0 3.0 14.0 100.0% 1 annual review & record self monitoring reports 0.5 1.0 3.5 100.0% 1 annual process & act on non compliance reports 1.0 2.0 5.7 38.5% 5 5x/ year, 38.5% of facilities review compliance schedule report  in compliance with schedule 0.5 1.0 3.0 = 0.17* 0.94 2 2x/ yr, 17% of facilities with compliance milestones, of which 94% in compliance review compliance schedule report  not in compliance with schedule 0.8 1.8 6.0 = 0.17* 0.06 2 2x/ yr, 17% of facilities with compliance milestones, of which 6% not in compliance minor enforcement action ( e. g., admin order) 1.0 3.7 13.3 7.0% 1 annual, 7% of facilities minor enforcement action ( e. g., admin fine) 1.0 5.3 24.7 7.0% 1 annual, 7% of facilities repermit 1.0 4.0 17.0 100.0% 1 every five years New mass based permit develop and issue permit 4.0 12.0 40.0 100.0% 1 one time provide technical guidance 2.0 3.7 13.0 100.0% 1 one time conduct public or evidentiary hearings 2.3 8.0 33.3 3.2% 1 one time, 3.2% of facilities inspection for permit development 2.3 4.7 12.0 100.0% 1 one time inspection for compliance assessment 1.8 3.7 10.0 100.0% 1 annual sample and analyze effluent 1.0 3.0 14.0 100.0% 1 annual review & record self monitoring reports 0.5 1.0 3.5 100.0% 1 annual process & act on non compliance reports 1.0 2.0 5.7 38.5% 5 5x/ year, 38.5% of facilities review compliance schedule report  in compliance with schedule 0.5 1.0 3.0 = 0.17* 0.94 2 2x/ yr, 17% of facilities with compliance milestones, of which 94% in compliance review compliance schedule report  not in compliance with schedule 0.8 1.8 6.0 = 0.17* 0.06 2 2x/ yr, 17% of facilities with compliance milestones, of which 6% not in compliance minor enforcement action ( e. g., admin order) 1.0 3.7 13.3 7.0% 1 annual, 7% of facilities minor enforcement action ( e. g., admin fine) 1.0 5.3 24.7 7.0% 1 annual, 7% of facilities repermit 1.0 4.0 17.0 100.0% 1 every five years Converting concentration based to mass based develop and issue permit 2.0 8.0 21.0 100.0% 1 one time provide technical guidance conduct public or evidentiary hearings inspection for permit development inspection for compliance assessment 1.8 3.7 10.0 100.0% 1 annual sample and analyze effluent 1.0 3.0 14.0 100.0% 1 annual review & record self monitoring reports 0.5 1.0 3.5 100.0% 1 annual process & act on non compliance reports 1.0 2.0 5.7 38.5% 5 5x/ year, 38.5% of facilities review compliance schedule report  in compliance with schedule 0.5 1.0 3.0 = 0.17* 0.94 2 2x/ yr, 17% of facilities with compliance milestones, of which 94% in compliance review compliance schedule report  not in compliance with schedule 0.8 1.8 6.0 = 0.17* 0.06 2 2x/ yr, 17% of facilities with compliance milestones, of which 6% not in compliance minor enforcement action ( e. g., admin order) 1.0 3.7 13.3 7.0% 1 annual, 7% of facilities minor enforcement action ( e. g., admin fine) 1.0 5.3 24.7 7.0% 1 annual, 7% of facilities repermit 1.0 4.0 17.0 100.0% 1 every five years February 14, 2003 79 of 79 AD MP& M7A formula. xls  Inputs & Assumptions


% Drinking water exposure
% Infant, Body weight set to 4.8 kg
% Dose to reach average blood cpfos conc = 0.004 ug/L
% Cecilia Tan
% August 30, 2016

% Setting model parameters
use human_parameters_MRP
use preg_female_parameters
BWSW=1;		% Set BW to a fixed value
BWST=4.8;	 % Set BW
PREG=0;		% Not pregnant
TSTOP=504;	%Simulation time = 21 days

%21-day exposure
VOLUME=0.68557  % Water consumption volume in L/DAY
EVENTS=6        % Drinking frequency per day
DT = xlsRead("Drinkingwater.xls", "infant", "A2:A128") ; % Dosing Times
AMTCDOSE=xlsRead("Drinkingwater.xls", "infant", "F2:F128")*VOLUME/EVENTS; % Dose in ug/l

prepare time rbcce
start@nocallback

prepare @clear@all
start @NoCallback
simall = [_time _rbcce _urinetcpy _cv*350.6 _cvo*334.5 _blauc*350.6 _blauco*334.5 _blaucavg*350.6 _blaucoavg*334.5];	%conc unit = ug/L

save simall @file='water_infant_cc' @format=ascii