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 19 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 E F G H Incremental Number 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 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 20 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 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 February 14, 2003 21 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 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 22 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 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 23 of 79 AD MP& M7A formula. xls  Pref Option by Type 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 100 101 102 103 104 105 106 107 108 109 110 111 A B C D High Permitting Hours by Activity and Year  New Concentration Based 1 2 develop and issue permit = C$ 36*' Unit Costs  High'!$ B$ 6 = D$ 36*' Unit Costs  High'!$ B$ 6 provide technical guidance = C$ 39*' Unit Costs  High'!$ B$ 7 = D$ 39*' Unit Costs  High'!$ B$ 7 conduct public or evidentiary hearings = C$ 19*' Unit Costs  High'!$ B$ 8 = D$ 19*' Unit Costs  High'!$ B$ 8 inspection for permit development = C$ 19*' Unit Costs  High'!$ B$ 9 = D$ 19*' Unit Costs  High'!$ B$ 9 inspection for compliance assessment =( C$ 19 C$ 21)*' Unit Costs  High'!$ C$ 10 = C61+( D$ 19 D$ 21)*' Unit Costs  High'!$ C$ 10 sample and analyze effluent =( C$ 19 C$ 21)*' Unit Costs  High'!$ C$ 11 = C62+( D$ 19 D$ 21)*' Unit Costs  High'!$ C$ 11 review & record self monitoring reports =( C$ 19 C$ 21)*' Unit Costs  High'!$ C$ 12 = C63+( D$ 19 D$ 21)*' Unit Costs  High'!$ C$ 12 process & act on non compliance reports =( C$ 19 C$ 21)*' Unit Costs  High'!$ C$ 13 = C64+( D$ 19 D$ 21)*' Unit Costs  High'!$ C$ 13 review compliance schedule report  in compliance with schedule =( C$ 19 C$ 21)*' Unit Costs  High'!$ C$ 14 = C65+( D$ 19 D$ 21)*' Unit Costs  High'!$ C$ 14 review compliance schedule report  not in compliance with schedule =( C$ 19 C$ 21)*' Unit Costs  High'!$ C$ 15 = C66+( D$ 19 D$ 21)*' Unit Costs  High'!$ C$ 15 minor enforcement action ( e. g., admin order) =( C$ 19 C$ 21)*' Unit Costs  High'!$ C$ 16 = C67+( D$ 19 D$ 21)*' Unit Costs  High'!$ C$ 16 minor enforcement action ( e. g., admin fine) =( C$ 19 C$ 21)*' Unit Costs  High'!$ C$ 17 = C68+( D$ 19 D$ 21)*' Unit Costs  High'!$ C$ 17 repermit =( C$ 24 C$ 26)*' Unit Costs  High'!$ D$ 18 =( D$ 24 D$ 26)*' Unit Costs  High'!$ D$ 18 Total hours = SUM( C57: C69) = SUM( D57: D69) Total cost =' Inputs & Assumptions'!$ B$ 5* C70 =' Inputs & Assumptions'!$ B$ 5* D70 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C71: Q71) Maximum one year hours = MAX( C70: Q70) Maximum one year costs = MAX( C71: Q71) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C72) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C62 =' Inputs & Assumptions'!$ B$ 5* D62 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C76: Q76) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C77) Annualized Permitting ( Net of Sampling & Analysis) = C75 C78 High Permitting Hours by Activity and Year  New Mass Based 1 2 develop and issue permit = C$ 37*' Unit Costs  High'!$ B$ 22 = D$ 37*' Unit Costs  High'!$ B$ 22 provide technical guidance = C$ 40*' Unit Costs  High'!$ B$ 23 = D$ 40*' Unit Costs  High'!$ B$ 23 conduct public or evidentiary hearings = C$ 20*' Unit Costs  High'!$ B$ 24 = D$ 20*' Unit Costs  High'!$ B$ 24 inspection for permit development = C$ 20*' Unit Costs  High'!$ B$ 25 = D$ 20*' Unit Costs  High'!$ B$ 25 inspection for compliance assessment =( C$ 20 C$ 22)*' Unit Costs  High'!$ C$ 26 = C88+( D$ 20 D$ 22)*' Unit Costs  High'!$ C$ 26 sample and analyze effluent =( C$ 20 C$ 22)*' Unit Costs  High'!$ C$ 27 = C89+( D$ 20 D$ 22)*' Unit Costs  High'!$ C$ 27 review & record self monitoring reports =( C$ 20 C$ 22)*' Unit Costs  High'!$ C$ 28 = C90+( D$ 20 D$ 22)*' Unit Costs  High'!$ C$ 28 process & act on non compliance reports =( C$ 20 C$ 22)*' Unit Costs  High'!$ C$ 29 = C91+( D$ 20 D$ 22)*' Unit Costs  High'!$ C$ 29 review compliance schedule report  in compliance with schedule =( C$ 20 C$ 22)*' Unit Costs  High'!$ C$ 30 = C92+( D$ 20 D$ 22)*' Unit Costs  High'!$ C$ 30 review compliance schedule report  not in compliance with schedule =( C$ 20 C$ 22)*' Unit Costs  High'!$ C$ 31 = C93+( D$ 20 D$ 22)*' Unit Costs  High'!$ C$ 31 minor enforcement action ( e. g., admin order) =( C$ 20 C$ 22)*' Unit Costs  High'!$ C$ 32 = C94+( D$ 20 D$ 22)*' Unit Costs  High'!$ C$ 32 minor enforcement action ( e. g., admin fine) =( C$ 20 C$ 22)*' Unit Costs  High'!$ C$ 33 = C95+( D$ 20 D$ 22)*' Unit Costs  High'!$ C$ 33 repermit =( C$ 25 C$ 27)*' Unit Costs  High'!$ D$ 34 =( D$ 25 D$ 27)*' Unit Costs  High'!$ D$ 34 Total hours = SUM( C84: C96) = SUM( D84: D96) Total cost =' Inputs & Assumptions'!$ B$ 5* C97 =' Inputs & Assumptions'!$ B$ 5* D97 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C98: Q98) Maximum one year hours = MAX( C97: Q97) Maximum one year costs = MAX( C98: Q98) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C99) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C89 =' Inputs & Assumptions'!$ B$ 5* D89 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C103: Q103) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C104) Annualized Permitting ( Net of Sampling & Analysis) = C102 C105 High Permitting Hours by Activity and Year  Conc to Mass Based 1 2 develop and issue permit = C$ 38*' Unit Costs  High'!$ B$ 38 = D$ 38*' Unit Costs  High'!$ B$ 38 February 14, 2003 24 of 79 AD MP& M7A formula. xls  Pref Option by Type 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 100 101 102 103 104 105 106 107 108 109 110 111 E F G H 3 4 5 6 = E$ 36*' Unit Costs  High'!$ B$ 6 = F$ 36*' Unit Costs  High'!$ B$ 6 = G$ 36*' Unit Costs  High'!$ B$ 6 = H$ 36*' Unit Costs  High'!$ B$ 6 = E$ 39*' Unit Costs  High'!$ B$ 7 = F$ 39*' Unit Costs  High'!$ B$ 7 = G$ 39*' Unit Costs  High'!$ B$ 7 = H$ 39*' Unit Costs  High'!$ B$ 7 = E$ 19*' Unit Costs  High'!$ B$ 8 = F$ 19*' Unit Costs  High'!$ B$ 8 = G$ 19*' Unit Costs  High'!$ B$ 8 = H$ 19*' Unit Costs  High'!$ B$ 8 = E$ 19*' Unit Costs  High'!$ B$ 9 = F$ 19*' Unit Costs  High'!$ B$ 9 = G$ 19*' Unit Costs  High'!$ B$ 9 = H$ 19*' Unit Costs  High'!$ B$ 9 = D61+( E$ 19 E$ 21)*' Unit Costs  High'!$ C$ 10 = E61+( F$ 19 F$ 21)*' Unit Costs  High'!$ C$ 10 = F61+( G$ 19 G$ 21)*' Unit Costs  High'!$ C$ 10 = G61+( H$ 19 H$ 21)*' Unit Costs  High'!$ C$ 10 = D62+( E$ 19 E$ 21)*' Unit Costs  High'!$ C$ 11 = E62+( F$ 19 F$ 21)*' Unit Costs  High'!$ C$ 11 = F62+( G$ 19 G$ 21)*' Unit Costs  High'!$ C$ 11 = G62+( H$ 19 H$ 21)*' Unit Costs  High'!$ C$ 11 = D63+( E$ 19 E$ 21)*' Unit Costs  High'!$ C$ 12 = E63+( F$ 19 F$ 21)*' Unit Costs  High'!$ C$ 12 = F63+( G$ 19 G$ 21)*' Unit Costs  High'!$ C$ 12 = G63+( H$ 19 H$ 21)*' Unit Costs  High'!$ C$ 12 = D64+( E$ 19 E$ 21)*' Unit Costs  High'!$ C$ 13 = E64+( F$ 19 F$ 21)*' Unit Costs  High'!$ C$ 13 = F64+( G$ 19 G$ 21)*' Unit Costs  High'!$ C$ 13 = G64+( H$ 19 H$ 21)*' Unit Costs  High'!$ C$ 13 = D65+( E$ 19 E$ 21)*' Unit Costs  High'!$ C$ 14 = E65+( F$ 19 F$ 21)*' Unit Costs  High'!$ C$ 14 = F65+( G$ 19 G$ 21)*' Unit Costs  High'!$ C$ 14 = G65+( H$ 19 H$ 21)*' Unit Costs  High'!$ C$ 14 = D66+( E$ 19 E$ 21)*' Unit Costs  High'!$ C$ 15 = E66+( F$ 19 F$ 21)*' Unit Costs  High'!$ C$ 15 = F66+( G$ 19 G$ 21)*' Unit Costs  High'!$ C$ 15 = G66+( H$ 19 H$ 21)*' Unit Costs  High'!$ C$ 15 = D67+( E$ 19 E$ 21)*' Unit Costs  High'!$ C$ 16 = E67+( F$ 19 F$ 21)*' Unit Costs  High'!$ C$ 16 = F67+( G$ 19 G$ 21)*' Unit Costs  High'!$ C$ 16 = G67+( H$ 19 H$ 21)*' Unit Costs  High'!$ C$ 16 = D68+( E$ 19 E$ 21)*' Unit Costs  High'!$ C$ 17 = E68+( F$ 19 F$ 21)*' Unit Costs  High'!$ C$ 17 = F68+( G$ 19 G$ 21)*' Unit Costs  High'!$ C$ 17 = G68+( H$ 19 H$ 21)*' Unit Costs  High'!$ C$ 17 =( E$ 24 E$ 26)*' Unit Costs  High'!$ D$ 18 =( F$ 24 F$ 26)*' Unit Costs  High'!$ D$ 18 =( G$ 24 G$ 26)*' Unit Costs  High'!$ D$ 18 =( H$ 24 H$ 26)*' Unit Costs  High'!$ D$ 18 = SUM( E57: E69) = SUM( F57: F69) = SUM( G57: G69) = SUM( H57: H69) =' Inputs & Assumptions'!$ B$ 5* E70 =' Inputs & Assumptions'!$ B$ 5* F70 =' Inputs & Assumptions'!$ B$ 5* G70 =' Inputs & Assumptions'!$ B$ 5* H70 =' Inputs & Assumptions'!$ B$ 5* E62 =' Inputs & Assumptions'!$ B$ 5* F62 =' Inputs & Assumptions'!$ B$ 5* G62 =' Inputs & Assumptions'!$ B$ 5* H62 3 4 5 6 = E$ 37*' Unit Costs  High'!$ B$ 22 = F$ 37*' Unit Costs  High'!$ B$ 22 = G$ 37*' Unit Costs  High'!$ B$ 22 = H$ 37*' Unit Costs  High'!$ B$ 22 = E$ 40*' Unit Costs  High'!$ B$ 23 = F$ 40*' Unit Costs  High'!$ B$ 23 = G$ 40*' Unit Costs  High'!$ B$ 23 = H$ 40*' Unit Costs  High'!$ B$ 23 = E$ 20*' Unit Costs  High'!$ B$ 24 = F$ 20*' Unit Costs  High'!$ B$ 24 = G$ 20*' Unit Costs  High'!$ B$ 24 = H$ 20*' Unit Costs  High'!$ B$ 24 = E$ 20*' Unit Costs  High'!$ B$ 25 = F$ 20*' Unit Costs  High'!$ B$ 25 = G$ 20*' Unit Costs  High'!$ B$ 25 = H$ 20*' Unit Costs  High'!$ B$ 25 = D88+( E$ 20 E$ 22)*' Unit Costs  High'!$ C$ 26 = E88+( F$ 20 F$ 22)*' Unit Costs  High'!$ C$ 26 = F88+( G$ 20 G$ 22)*' Unit Costs  High'!$ C$ 26 = G88+( H$ 20 H$ 22)*' Unit Costs  High'!$ C$ 26 = D89+( E$ 20 E$ 22)*' Unit Costs  High'!$ C$ 27 = E89+( F$ 20 F$ 22)*' Unit Costs  High'!$ C$ 27 = F89+( G$ 20 G$ 22)*' Unit Costs  High'!$ C$ 27 = G89+( H$ 20 H$ 22)*' Unit Costs  High'!$ C$ 27 = D90+( E$ 20 E$ 22)*' Unit Costs  High'!$ C$ 28 = E90+( F$ 20 F$ 22)*' Unit Costs  High'!$ C$ 28 = F90+( G$ 20 G$ 22)*' Unit Costs  High'!$ C$ 28 = G90+( H$ 20 H$ 22)*' Unit Costs  High'!$ C$ 28 = D91+( E$ 20 E$ 22)*' Unit Costs  High'!$ C$ 29 = E91+( F$ 20 F$ 22)*' Unit Costs  High'!$ C$ 29 = F91+( G$ 20 G$ 22)*' Unit Costs  High'!$ C$ 29 = G91+( H$ 20 H$ 22)*' Unit Costs  High'!$ C$ 29 = D92+( E$ 20 E$ 22)*' Unit Costs  High'!$ C$ 30 = E92+( F$ 20 F$ 22)*' Unit Costs  High'!$ C$ 30 = F92+( G$ 20 G$ 22)*' Unit Costs  High'!$ C$ 30 = G92+( H$ 20 H$ 22)*' Unit Costs  High'!$ C$ 30 = D93+( E$ 20 E$ 22)*' Unit Costs  High'!$ C$ 31 = E93+( F$ 20 F$ 22)*' Unit Costs  High'!$ C$ 31 = F93+( G$ 20 G$ 22)*' Unit Costs  High'!$ C$ 31 = G93+( H$ 20 H$ 22)*' Unit Costs  High'!$ C$ 31 = D94+( E$ 20 E$ 22)*' Unit Costs  High'!$ C$ 32 = E94+( F$ 20 F$ 22)*' Unit Costs  High'!$ C$ 32 = F94+( G$ 20 G$ 22)*' Unit Costs  High'!$ C$ 32 = G94+( H$ 20 H$ 22)*' Unit Costs  High'!$ C$ 32 = D95+( E$ 20 E$ 22)*' Unit Costs  High'!$ C$ 33 = E95+( F$ 20 F$ 22)*' Unit Costs  High'!$ C$ 33 = F95+( G$ 20 G$ 22)*' Unit Costs  High'!$ C$ 33 = G95+( H$ 20 H$ 22)*' Unit Costs  High'!$ C$ 33 =( E$ 25 E$ 27)*' Unit Costs  High'!$ D$ 34 =( F$ 25 F$ 27)*' Unit Costs  High'!$ D$ 34 =( G$ 25 G$ 27)*' Unit Costs  High'!$ D$ 34 =( H$ 25 H$ 27 C$ 23)*' Unit Costs  High'!$ D$ 34 = SUM( E84: E96) = SUM( F84: F96) = SUM( G84: G96) = SUM( H84: H96) =' Inputs & Assumptions'!$ B$ 5* E97 =' Inputs & Assumptions'!$ B$ 5* F97 =' Inputs & Assumptions'!$ B$ 5* G97 =' Inputs & Assumptions'!$ B$ 5* H97 =' Inputs & Assumptions'!$ B$ 5* E89 =' Inputs & Assumptions'!$ B$ 5* F89 =' Inputs & Assumptions'!$ B$ 5* G89 =' Inputs & Assumptions'!$ B$ 5* H89 3 4 5 6 = E$ 38*' Unit Costs  High'!$ B$ 38 = F$ 38*' Unit Costs  High'!$ B$ 38 = G$ 38*' Unit Costs  High'!$ B$ 38 = H$ 38*' Unit Costs  High'!$ B$ 38 February 14, 2003 25 of 79 AD MP& M7A formula. xls  Pref Option by Type 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 100 101 102 103 104 105 106 107 108 109 110 111 I J K L Year Relative to Promulgation of Rule 7 8 9 10 = I$ 36*' Unit Costs  High'!$ B$ 6 = J$ 36*' Unit Costs  High'!$ B$ 6 = K$ 36*' Unit Costs  High'!$ B$ 6 = L$ 36*' Unit Costs  High'!$ B$ 6 = I$ 39*' Unit Costs  High'!$ B$ 7 = J$ 39*' Unit Costs  High'!$ B$ 7 = K$ 39*' Unit Costs  High'!$ B$ 7 = L$ 39*' Unit Costs  High'!$ B$ 7 = I$ 19*' Unit Costs  High'!$ B$ 8 = J$ 19*' Unit Costs  High'!$ B$ 8 = K$ 19*' Unit Costs  High'!$ B$ 8 = L$ 19*' Unit Costs  High'!$ B$ 8 = I$ 19*' Unit Costs  High'!$ B$ 9 = J$ 19*' Unit Costs  High'!$ B$ 9 = K$ 19*' Unit Costs  High'!$ B$ 9 = L$ 19*' Unit Costs  High'!$ B$ 9 = H61+( I$ 19 I$ 21)*' Unit Costs  High'!$ C$ 10 = I61+( J$ 19 J$ 21)*' Unit Costs  High'!$ C$ 10 = J61+( K$ 19 K$ 21)*' Unit Costs  High'!$ C$ 10 = K61+( L$ 19 L$ 21)*' Unit Costs  High'!$ C$ 10 = H62+( I$ 19 I$ 21)*' Unit Costs  High'!$ C$ 11 = I62+( J$ 19 J$ 21)*' Unit Costs  High'!$ C$ 11 = J62+( K$ 19 K$ 21)*' Unit Costs  High'!$ C$ 11 = K62+( L$ 19 L$ 21)*' Unit Costs  High'!$ C$ 11 = H63+( I$ 19 I$ 21)*' Unit Costs  High'!$ C$ 12 = I63+( J$ 19 J$ 21)*' Unit Costs  High'!$ C$ 12 = J63+( K$ 19 K$ 21)*' Unit Costs  High'!$ C$ 12 = K63+( L$ 19 L$ 21)*' Unit Costs  High'!$ C$ 12 = H64+( I$ 19 I$ 21)*' Unit Costs  High'!$ C$ 13 = I64+( J$ 19 J$ 21)*' Unit Costs  High'!$ C$ 13 = J64+( K$ 19 K$ 21)*' Unit Costs  High'!$ C$ 13 = K64+( L$ 19 L$ 21)*' Unit Costs  High'!$ C$ 13 = H65+( I$ 19 I$ 21)*' Unit Costs  High'!$ C$ 14 = I65+( J$ 19 J$ 21)*' Unit Costs  High'!$ C$ 14 = J65+( K$ 19 K$ 21)*' Unit Costs  High'!$ C$ 14 = K65+( L$ 19 L$ 21)*' Unit Costs  High'!$ C$ 14 = H66+( I$ 19 I$ 21)*' Unit Costs  High'!$ C$ 15 = I66+( J$ 19 J$ 21)*' Unit Costs  High'!$ C$ 15 = J66+( K$ 19 K$ 21)*' Unit Costs  High'!$ C$ 15 = K66+( L$ 19 L$ 21)*' Unit Costs  High'!$ C$ 15 = H67+( I$ 19 I$ 21)*' Unit Costs  High'!$ C$ 16 = I67+( J$ 19 J$ 21)*' Unit Costs  High'!$ C$ 16 = J67+( K$ 19 K$ 21)*' Unit Costs  High'!$ C$ 16 = K67+( L$ 19 L$ 21)*' Unit Costs  High'!$ C$ 16 = H68+( I$ 19 I$ 21)*' Unit Costs  High'!$ C$ 17 = I68+( J$ 19 J$ 21)*' Unit Costs  High'!$ C$ 17 = J68+( K$ 19 K$ 21)*' Unit Costs  High'!$ C$ 17 = K68+( L$ 19 L$ 21)*' Unit Costs  High'!$ C$ 17 =( I$ 24 I$ 26)*' Unit Costs  High'!$ D$ 18 =( J$ 24 J$ 26)*' Unit Costs  High'!$ D$ 18 =( K$ 24 K$ 26)*' Unit Costs  High'!$ D$ 18 =( L$ 24 L$ 26)*' Unit Costs  High'!$ D$ 18 = SUM( I57: I69) = SUM( J57: J69) = SUM( K57: K69) = SUM( L57: L69) =' Inputs & Assumptions'!$ B$ 5* I70 =' Inputs & Assumptions'!$ B$ 5* J70 =' Inputs & Assumptions'!$ B$ 5* K70 =' Inputs & Assumptions'!$ B$ 5* L70 =' Inputs & Assumptions'!$ B$ 5* I62 =' Inputs & Assumptions'!$ B$ 5* J62 =' Inputs & Assumptions'!$ B$ 5* K62 =' Inputs & Assumptions'!$ B$ 5* L62 Year Relative to Promulgation of Rule 7 8 9 10 = I$ 37*' Unit Costs  High'!$ B$ 22 = J$ 37*' Unit Costs  High'!$ B$ 22 = K$ 37*' Unit Costs  High'!$ B$ 22 = L$ 37*' Unit Costs  High'!$ B$ 22 = I$ 40*' Unit Costs  High'!$ B$ 23 = J$ 40*' Unit Costs  High'!$ B$ 23 = K$ 40*' Unit Costs  High'!$ B$ 23 = L$ 40*' Unit Costs  High'!$ B$ 23 = I$ 20*' Unit Costs  High'!$ B$ 24 = J$ 20*' Unit Costs  High'!$ B$ 24 = K$ 20*' Unit Costs  High'!$ B$ 24 = L$ 20*' Unit Costs  High'!$ B$ 24 = I$ 20*' Unit Costs  High'!$ B$ 25 = J$ 20*' Unit Costs  High'!$ B$ 25 = K$ 20*' Unit Costs  High'!$ B$ 25 = L$ 20*' Unit Costs  High'!$ B$ 25 = H88+( I$ 20 I$ 22)*' Unit Costs  High'!$ C$ 26 = I88+( J$ 20 J$ 22)*' Unit Costs  High'!$ C$ 26 = J88+( K$ 20 K$ 22)*' Unit Costs  High'!$ C$ 26 = K88+( L$ 20 L$ 22)*' Unit Costs  High'!$ C$ 26 = H89+( I$ 20 I$ 22)*' Unit Costs  High'!$ C$ 27 = I89+( J$ 20 J$ 22)*' Unit Costs  High'!$ C$ 27 = J89+( K$ 20 K$ 22)*' Unit Costs  High'!$ C$ 27 = K89+( L$ 20 L$ 22)*' Unit Costs  High'!$ C$ 27 = H90+( I$ 20 I$ 22)*' Unit Costs  High'!$ C$ 28 = I90+( J$ 20 J$ 22)*' Unit Costs  High'!$ C$ 28 = J90+( K$ 20 K$ 22)*' Unit Costs  High'!$ C$ 28 = K90+( L$ 20 L$ 22)*' Unit Costs  High'!$ C$ 28 = H91+( I$ 20 I$ 22)*' Unit Costs  High'!$ C$ 29 = I91+( J$ 20 J$ 22)*' Unit Costs  High'!$ C$ 29 = J91+( K$ 20 K$ 22)*' Unit Costs  High'!$ C$ 29 = K91+( L$ 20 L$ 22)*' Unit Costs  High'!$ C$ 29 = H92+( I$ 20 I$ 22)*' Unit Costs  High'!$ C$ 30 = I92+( J$ 20 J$ 22)*' Unit Costs  High'!$ C$ 30 = J92+( K$ 20 K$ 22)*' Unit Costs  High'!$ C$ 30 = K92+( L$ 20 L$ 22)*' Unit Costs  High'!$ C$ 30 = H93+( I$ 20 I$ 22)*' Unit Costs  High'!$ C$ 31 = I93+( J$ 20 J$ 22)*' Unit Costs  High'!$ C$ 31 = J93+( K$ 20 K$ 22)*' Unit Costs  High'!$ C$ 31 = K93+( L$ 20 L$ 22)*' Unit Costs  High'!$ C$ 31 = H94+( I$ 20 I$ 22)*' Unit Costs  High'!$ C$ 32 = I94+( J$ 20 J$ 22)*' Unit Costs  High'!$ C$ 32 = J94+( K$ 20 K$ 22)*' Unit Costs  High'!$ C$ 32 = K94+( L$ 20 L$ 22)*' Unit Costs  High'!$ C$ 32 = H95+( I$ 20 I$ 22)*' Unit Costs  High'!$ C$ 33 = I95+( J$ 20 J$ 22)*' Unit Costs  High'!$ C$ 33 = J95+( K$ 20 K$ 22)*' Unit Costs  High'!$ C$ 33 = K95+( L$ 20 L$ 22)*' Unit Costs  High'!$ C$ 33 =( I$ 25 I$ 27 D$ 23)*' Unit Costs  High'!$ D$ 34 =( J$ 25 J$ 27 E$ 23)*' Unit Costs  High'!$ D$ 34 =( K$ 25 K$ 27 F$ 23)*' Unit Costs  High'!$ D$ 34 =( L$ 25 L$ 27 G$ 23)*' Unit Costs  High'!$ D$ 34 = SUM( I84: I96) = SUM( J84: J96) = SUM( K84: K96) = SUM( L84: L96) =' Inputs & Assumptions'!$ B$ 5* I97 =' Inputs & Assumptions'!$ B$ 5* J97 =' Inputs & Assumptions'!$ B$ 5* K97 =' Inputs & Assumptions'!$ B$ 5* L97 =' Inputs & Assumptions'!$ B$ 5* I89 =' Inputs & Assumptions'!$ B$ 5* J89 =' Inputs & Assumptions'!$ B$ 5* K89 =' Inputs & Assumptions'!$ B$ 5* L89 Year Relative to Promulgation of Rule 7 8 9 10 = I$ 38*' Unit Costs  High'!$ B$ 38 = J$ 38*' Unit Costs  High'!$ B$ 38 = K$ 38*' Unit Costs  High'!$ B$ 38 = L$ 38*' Unit Costs  High'!$ B$ 38 February 14, 2003 26 of 79 AD MP& M7A formula. xls  Pref Option by Type 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 100 101 102 103 104 105 106 107 108 109 110 111 M N O P 11 12 13 14 = M$ 36*' Unit Costs  High'!$ B$ 6 = N$ 36*' Unit Costs  High'!$ B$ 6 = O$ 36*' Unit Costs  High'!$ B$ 6 = P$ 36*' Unit Costs  High'!$ B$ 6 = M$ 39*' Unit Costs  High'!$ B$ 7 = N$ 39*' Unit Costs  High'!$ B$ 7 = O$ 39*' Unit Costs  High'!$ B$ 7 = P$ 39*' Unit Costs  High'!$ B$ 7 = M$ 19*' Unit Costs  High'!$ B$ 8 = N$ 19*' Unit Costs  High'!$ B$ 8 = O$ 19*' Unit Costs  High'!$ B$ 8 = P$ 19*' Unit Costs  High'!$ B$ 8 = M$ 19*' Unit Costs  High'!$ B$ 9 = N$ 19*' Unit Costs  High'!$ B$ 9 = O$ 19*' Unit Costs  High'!$ B$ 9 = P$ 19*' Unit Costs  High'!$ B$ 9 = L61+( M$ 19 M$ 21)*' Unit Costs  High'!$ C$ 10 = M61+( N$ 19 N$ 21)*' Unit Costs  High'!$ C$ 10 = N61+( O$ 19 O$ 21)*' Unit Costs  High'!$ C$ 10 = O61+( P$ 19 P$ 21)*' Unit Costs  High'!$ C$ 10 = L62+( M$ 19 M$ 21)*' Unit Costs  High'!$ C$ 11 = M62+( N$ 19 N$ 21)*' Unit Costs  High'!$ C$ 11 = N62+( O$ 19 O$ 21)*' Unit Costs  High'!$ C$ 11 = O62+( P$ 19 P$ 21)*' Unit Costs  High'!$ C$ 11 = L63+( M$ 19 M$ 21)*' Unit Costs  High'!$ C$ 12 = M63+( N$ 19 N$ 21)*' Unit Costs  High'!$ C$ 12 = N63+( O$ 19 O$ 21)*' Unit Costs  High'!$ C$ 12 = O63+( P$ 19 P$ 21)*' Unit Costs  High'!$ C$ 12 = L64+( M$ 19 M$ 21)*' Unit Costs  High'!$ C$ 13 = M64+( N$ 19 N$ 21)*' Unit Costs  High'!$ C$ 13 = N64+( O$ 19 O$ 21)*' Unit Costs  High'!$ C$ 13 = O64+( P$ 19 P$ 21)*' Unit Costs  High'!$ C$ 13 = L65+( M$ 19 M$ 21)*' Unit Costs  High'!$ C$ 14 = M65+( N$ 19 N$ 21)*' Unit Costs  High'!$ C$ 14 = N65+( O$ 19 O$ 21)*' Unit Costs  High'!$ C$ 14 = O65+( P$ 19 P$ 21)*' Unit Costs  High'!$ C$ 14 = L66+( M$ 19 M$ 21)*' Unit Costs  High'!$ C$ 15 = M66+( N$ 19 N$ 21)*' Unit Costs  High'!$ C$ 15 = N66+( O$ 19 O$ 21)*' Unit Costs  High'!$ C$ 15 = O66+( P$ 19 P$ 21)*' Unit Costs  High'!$ C$ 15 = L67+( M$ 19 M$ 21)*' Unit Costs  High'!$ C$ 16 = M67+( N$ 19 N$ 21)*' Unit Costs  High'!$ C$ 16 = N67+( O$ 19 O$ 21)*' Unit Costs  High'!$ C$ 16 = O67+( P$ 19 P$ 21)*' Unit Costs  High'!$ C$ 16 = L68+( M$ 19 M$ 21)*' Unit Costs  High'!$ C$ 17 = M68+( N$ 19 N$ 21)*' Unit Costs  High'!$ C$ 17 = N68+( O$ 19 O$ 21)*' Unit Costs  High'!$ C$ 17 = O68+( P$ 19 P$ 21)*' Unit Costs  High'!$ C$ 17 =( M$ 24 M$ 26)*' Unit Costs  High'!$ D$ 18 =( N$ 24 N$ 26)*' Unit Costs  High'!$ D$ 18 =( O$ 24 O$ 26)*' Unit Costs  High'!$ D$ 18 =( P$ 24 P$ 26)*' Unit Costs  High'!$ D$ 18 = SUM( M57: M69) = SUM( N57: N69) = SUM( O57: O69) = SUM( P57: P69) =' Inputs & Assumptions'!$ B$ 5* M70 =' Inputs & Assumptions'!$ B$ 5* N70 =' Inputs & Assumptions'!$ B$ 5* O70 =' Inputs & Assumptions'!$ B$ 5* P70 =' Inputs & Assumptions'!$ B$ 5* M62 =' Inputs & Assumptions'!$ B$ 5* N62 =' Inputs & Assumptions'!$ B$ 5* O62 =' Inputs & Assumptions'!$ B$ 5* P62 11 12 13 14 = M$ 37*' Unit Costs  High'!$ B$ 22 = N$ 37*' Unit Costs  High'!$ B$ 22 = O$ 37*' Unit Costs  High'!$ B$ 22 = P$ 37*' Unit Costs  High'!$ B$ 22 = M$ 40*' Unit Costs  High'!$ B$ 23 = N$ 40*' Unit Costs  High'!$ B$ 23 = O$ 40*' Unit Costs  High'!$ B$ 23 = P$ 40*' Unit Costs  High'!$ B$ 23 = M$ 20*' Unit Costs  High'!$ B$ 24 = N$ 20*' Unit Costs  High'!$ B$ 24 = O$ 20*' Unit Costs  High'!$ B$ 24 = P$ 20*' Unit Costs  High'!$ B$ 24 = M$ 20*' Unit Costs  High'!$ B$ 25 = N$ 20*' Unit Costs  High'!$ B$ 25 = O$ 20*' Unit Costs  High'!$ B$ 25 = P$ 20*' Unit Costs  High'!$ B$ 25 = L88+( M$ 20 M$ 22)*' Unit Costs  High'!$ C$ 26 = M88+( N$ 20 N$ 22)*' Unit Costs  High'!$ C$ 26 = N88+( O$ 20 O$ 22)*' Unit Costs  High'!$ C$ 26 = O88+( P$ 20 P$ 22)*' Unit Costs  High'!$ C$ 26 = L89+( M$ 20 M$ 22)*' Unit Costs  High'!$ C$ 27 = M89+( N$ 20 N$ 22)*' Unit Costs  High'!$ C$ 27 = N89+( O$ 20 O$ 22)*' Unit Costs  High'!$ C$ 27 = O89+( P$ 20 P$ 22)*' Unit Costs  High'!$ C$ 27 = L90+( M$ 20 M$ 22)*' Unit Costs  High'!$ C$ 28 = M90+( N$ 20 N$ 22)*' Unit Costs  High'!$ C$ 28 = N90+( O$ 20 O$ 22)*' Unit Costs  High'!$ C$ 28 = O90+( P$ 20 P$ 22)*' Unit Costs  High'!$ C$ 28 = L91+( M$ 20 M$ 22)*' Unit Costs  High'!$ C$ 29 = M91+( N$ 20 N$ 22)*' Unit Costs  High'!$ C$ 29 = N91+( O$ 20 O$ 22)*' Unit Costs  High'!$ C$ 29 = O91+( P$ 20 P$ 22)*' Unit Costs  High'!$ C$ 29 = L92+( M$ 20 M$ 22)*' Unit Costs  High'!$ C$ 30 = M92+( N$ 20 N$ 22)*' Unit Costs  High'!$ C$ 30 = N92+( O$ 20 O$ 22)*' Unit Costs  High'!$ C$ 30 = O92+( P$ 20 P$ 22)*' Unit Costs  High'!$ C$ 30 = L93+( M$ 20 M$ 22)*' Unit Costs  High'!$ C$ 31 = M93+( N$ 20 N$ 22)*' Unit Costs  High'!$ C$ 31 = N93+( O$ 20 O$ 22)*' Unit Costs  High'!$ C$ 31 = O93+( P$ 20 P$ 22)*' Unit Costs  High'!$ C$ 31 = L94+( M$ 20 M$ 22)*' Unit Costs  High'!$ C$ 32 = M94+( N$ 20 N$ 22)*' Unit Costs  High'!$ C$ 32 = N94+( O$ 20 O$ 22)*' Unit Costs  High'!$ C$ 32 = O94+( P$ 20 P$ 22)*' Unit Costs  High'!$ C$ 32 = L95+( M$ 20 M$ 22)*' Unit Costs  High'!$ C$ 33 = M95+( N$ 20 N$ 22)*' Unit Costs  High'!$ C$ 33 = N95+( O$ 20 O$ 22)*' Unit Costs  High'!$ C$ 33 = O95+( P$ 20 P$ 22)*' Unit Costs  High'!$ C$ 33 =( H$ 25 H$ 27 C$ 23)*' Unit Costs  High'!$ D$ 34 =( I$ 25 I$ 27 D$ 23)*' Unit Costs  High'!$ D$ 34 =( J$ 25 J$ 27 E$ 23)*' Unit Costs  High'!$ D$ 34 =( K$ 25 K$ 27 F$ 23)*' Unit Costs  High'!$ D$ 34 = SUM( M84: M96) = SUM( N84: N96) = SUM( O84: O96) = SUM( P84: P96) =' Inputs & Assumptions'!$ B$ 5* M97 =' Inputs & Assumptions'!$ B$ 5* N97 =' Inputs & Assumptions'!$ B$ 5* O97 =' Inputs & Assumptions'!$ B$ 5* P97 =' Inputs & Assumptions'!$ B$ 5* M89 =' Inputs & Assumptions'!$ B$ 5* N89 =' Inputs & Assumptions'!$ B$ 5* O89 =' Inputs & Assumptions'!$ B$ 5* P89 11 12 13 14 = M$ 38*' Unit Costs  High'!$ B$ 38 = N$ 38*' Unit Costs  High'!$ B$ 38 = O$ 38*' Unit Costs  High'!$ B$ 38 = P$ 38*' Unit Costs  High'!$ B$ 38 February 14, 2003 27 of 79 AD MP& M7A formula. xls  Pref Option by Type 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 100 101 102 103 104 105 106 107 108 109 110 111 Q 15 = Q$ 36*' Unit Costs  High'!$ B$ 6 = Q$ 39*' Unit Costs  High'!$ B$ 7 = Q$ 19*' Unit Costs  High'!$ B$ 8 = Q$ 19*' Unit Costs  High'!$ B$ 9 = P61+( Q$ 19 Q$ 21)*' Unit Costs  High'!$ C$ 10 = P62+( Q$ 19 Q$ 21)*' Unit Costs  High'!$ C$ 11 = P63+( Q$ 19 Q$ 21)*' Unit Costs  High'!$ C$ 12 = P64+( Q$ 19 Q$ 21)*' Unit Costs  High'!$ C$ 13 = P65+( Q$ 19 Q$ 21)*' Unit Costs  High'!$ C$ 14 = P66+( Q$ 19 Q$ 21)*' Unit Costs  High'!$ C$ 15 = P67+( Q$ 19 Q$ 21)*' Unit Costs  High'!$ C$ 16 = P68+( Q$ 19 Q$ 21)*' Unit Costs  High'!$ C$ 17 =( Q$ 24 Q$ 26)*' Unit Costs  High'!$ D$ 18 = SUM( Q57: Q69) =' Inputs & Assumptions'!$ B$ 5* Q70 =' Inputs & Assumptions'!$ B$ 5* Q62 15 = Q$ 37*' Unit Costs  High'!$ B$ 22 = Q$ 40*' Unit Costs  High'!$ B$ 23 = Q$ 20*' Unit Costs  High'!$ B$ 24 = Q$ 20*' Unit Costs  High'!$ B$ 25 = P88+( Q$ 20 Q$ 22)*' Unit Costs  High'!$ C$ 26 = P89+( Q$ 20 Q$ 22)*' Unit Costs  High'!$ C$ 27 = P90+( Q$ 20 Q$ 22)*' Unit Costs  High'!$ C$ 28 = P91+( Q$ 20 Q$ 22)*' Unit Costs  High'!$ C$ 29 = P92+( Q$ 20 Q$ 22)*' Unit Costs  High'!$ C$ 30 = P93+( Q$ 20 Q$ 22)*' Unit Costs  High'!$ C$ 31 = P94+( Q$ 20 Q$ 22)*' Unit Costs  High'!$ C$ 32 = P95+( Q$ 20 Q$ 22)*' Unit Costs  High'!$ C$ 33 =( L$ 25 L$ 27 G$ 23)*' Unit Costs  High'!$ D$ 34 = SUM( Q84: Q96) =' Inputs & Assumptions'!$ B$ 5* Q97 =' Inputs & Assumptions'!$ B$ 5* Q89 15 = Q$ 38*' Unit Costs  High'!$ B$ 38 February 14, 2003 28 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 A B C D provide technical guidance 0 0 conduct public or evidentiary hearings 0 0 inspection for permit development 0 0 inspection for compliance assessment 0 0 sample and analyze effluent 0 0 review & record self monitoring reports 0 0 process & act on non compliance reports 0 0 review compliance schedule report  in compliance with schedule 0 0 review compliance schedule report  not in compliance with schedule 0 0 minor enforcement action ( e. g., admin order) 0 0 minor enforcement action ( e. g., admin fine) 0 0 repermit 0 0 Total hours = SUM( C111: C123) = SUM( D111: D123) Total cost =' Inputs & Assumptions'!$ B$ 5* C124 =' Inputs & Assumptions'!$ B$ 5* D124 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C125: Q125) Maximum one year hours = MAX( C124: Q124) Maximum one year costs = MAX( C125: Q125) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C126) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C116 =' Inputs & Assumptions'!$ B$ 5* D116 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C130: Q130) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C131) Annualized Permitting ( Net of Sampling & Analysis) = C129 C132 High Permitting Hours by Activity and Year  Total 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( C138: C150) = SUM( D138: D150) Total cost =' Inputs & Assumptions'!$ B$ 5* C151 =' Inputs & Assumptions'!$ B$ 5* D151 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C152: Q152) Maximum one year hours = MAX( C151: Q151) Maximum one year costs = MAX( C152: Q152) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C153) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C143 =' Inputs & Assumptions'!$ B$ 5* D143 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C157: Q157) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C158) Annualized Permitting ( Net of Sampling & Analysis) = C156 C159 Medium Permitting Hours by Activity and Year  New Concentration Based February 14, 2003 29 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 E F G H 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 =( C$ 23)*' Unit Costs  High'!$ D$ 50 = SUM( E111: E123) = SUM( F111: F123) = SUM( G111: G123) = SUM( H111: H123) =' Inputs & Assumptions'!$ B$ 5* E124 =' Inputs & Assumptions'!$ B$ 5* F124 =' Inputs & Assumptions'!$ B$ 5* G124 =' Inputs & Assumptions'!$ B$ 5* H124 =' Inputs & Assumptions'!$ B$ 5* E116 =' Inputs & Assumptions'!$ B$ 5* F116 =' Inputs & Assumptions'!$ B$ 5* G116 =' Inputs & Assumptions'!$ B$ 5* H116 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( E138: E150) = SUM( F138: F150) = SUM( G138: G150) = SUM( H138: H150) =' Inputs & Assumptions'!$ B$ 5* E151 =' Inputs & Assumptions'!$ B$ 5* F151 =' Inputs & Assumptions'!$ B$ 5* G151 =' Inputs & Assumptions'!$ B$ 5* H151 =' Inputs & Assumptions'!$ B$ 5* E143 =' Inputs & Assumptions'!$ B$ 5* F143 =' Inputs & Assumptions'!$ B$ 5* G143 =' Inputs & Assumptions'!$ B$ 5* H143 February 14, 2003 30 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 I J K L 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 =( D$ 23)*' Unit Costs  High'!$ D$ 50 =( E$ 23)*' Unit Costs  High'!$ D$ 50 =( F$ 23)*' Unit Costs  High'!$ D$ 50 =( G$ 23)*' Unit Costs  High'!$ D$ 50 = SUM( I111: I123) = SUM( J111: J123) = SUM( K111: K123) = SUM( L111: L123) =' Inputs & Assumptions'!$ B$ 5* I124 =' Inputs & Assumptions'!$ B$ 5* J124 =' Inputs & Assumptions'!$ B$ 5* K124 =' Inputs & Assumptions'!$ B$ 5* L124 =' Inputs & Assumptions'!$ B$ 5* I116 =' Inputs & Assumptions'!$ B$ 5* J116 =' Inputs & Assumptions'!$ B$ 5* K116 =' Inputs & Assumptions'!$ B$ 5* L116 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( I138: I150) = SUM( J138: J150) = SUM( K138: K150) = SUM( L138: L150) =' Inputs & Assumptions'!$ B$ 5* I151 =' Inputs & Assumptions'!$ B$ 5* J151 =' Inputs & Assumptions'!$ B$ 5* K151 =' Inputs & Assumptions'!$ B$ 5* L151 =' Inputs & Assumptions'!$ B$ 5* I143 =' Inputs & Assumptions'!$ B$ 5* J143 =' Inputs & Assumptions'!$ B$ 5* K143 =' Inputs & Assumptions'!$ B$ 5* L143 Year Relative to Promulgation of Rule February 14, 2003 31 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 M N O P 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 =( C$ 23)*' Unit Costs  High'!$ D$ 50 =( D$ 23)*' Unit Costs  High'!$ D$ 50 =( E$ 23)*' Unit Costs  High'!$ D$ 50 =( F$ 23)*' Unit Costs  High'!$ D$ 50 = SUM( M111: M123) = SUM( N111: N123) = SUM( O111: O123) = SUM( P111: P123) =' Inputs & Assumptions'!$ B$ 5* M124 =' Inputs & Assumptions'!$ B$ 5* N124 =' Inputs & Assumptions'!$ B$ 5* O124 =' Inputs & Assumptions'!$ B$ 5* P124 =' Inputs & Assumptions'!$ B$ 5* M116 =' Inputs & Assumptions'!$ B$ 5* N116 =' Inputs & Assumptions'!$ B$ 5* O116 =' Inputs & Assumptions'!$ B$ 5* P116 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( M138: M150) = SUM( N138: N150) = SUM( O138: O150) = SUM( P138: P150) =' Inputs & Assumptions'!$ B$ 5* M151 =' Inputs & Assumptions'!$ B$ 5* N151 =' Inputs & Assumptions'!$ B$ 5* O151 =' Inputs & Assumptions'!$ B$ 5* P151 =' Inputs & Assumptions'!$ B$ 5* M143 =' Inputs & Assumptions'!$ B$ 5* N143 =' Inputs & Assumptions'!$ B$ 5* O143 =' Inputs & Assumptions'!$ B$ 5* P143 February 14, 2003 32 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 Q 0 0 0 0 0 0 0 0 0 0 0 =( G$ 23)*' Unit Costs  High'!$ D$ 50 = SUM( Q111: Q123) =' Inputs & Assumptions'!$ B$ 5* Q124 =' Inputs & Assumptions'!$ B$ 5* Q116 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( Q138: Q150) =' Inputs & Assumptions'!$ B$ 5* Q151 =' Inputs & Assumptions'!$ B$ 5* Q143 February 14, 2003 33 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 A B C D 1 2 develop and issue permit = C$ 36*' Unit Costs  Medium'!$ B$ 6 = D$ 36*' Unit Costs  Medium'!$ B$ 6 provide technical guidance = C$ 39*' Unit Costs  Medium'!$ B$ 7 = D$ 39*' Unit Costs  Medium'!$ B$ 7 conduct public or evidentiary hearings = C$ 19*' Unit Costs  Medium'!$ B$ 8 = D$ 19*' Unit Costs  Medium'!$ B$ 8 inspection for permit development = C$ 19*' Unit Costs  Medium'!$ B$ 9 = D$ 19*' Unit Costs  Medium'!$ B$ 9 inspection for compliance assessment =( C$ 19 C$ 21)*' Unit Costs  Medium'!$ C$ 10 = C171+( D$ 19 D$ 21)*' Unit Costs  Medium'!$ C$ 10 sample and analyze effluent =( C$ 19 C$ 21)*' Unit Costs  Medium'!$ C$ 11 = C172+( D$ 19 D$ 21)*' Unit Costs  Medium'!$ C$ 11 review & record self monitoring reports =( C$ 19 C$ 21)*' Unit Costs  Medium'!$ C$ 12 = C173+( D$ 19 D$ 21)*' Unit Costs  Medium'!$ C$ 12 process & act on non compliance reports =( C$ 19 C$ 21)*' Unit Costs  Medium'!$ C$ 13 = C174+( D$ 19 D$ 21)*' Unit Costs  Medium'!$ C$ 13 review compliance schedule report  in compliance with schedule =( C$ 19 C$ 21)*' Unit Costs  Medium'!$ C$ 14 = C175+( D$ 19 D$ 21)*' Unit Costs  Medium'!$ C$ 14 review compliance schedule report  not in compliance with schedule =( C$ 19 C$ 21)*' Unit Costs  Medium'!$ C$ 15 = C176+( D$ 19 D$ 21)*' Unit Costs  Medium'!$ C$ 15 minor enforcement action ( e. g., admin order) =( C$ 19 C$ 21)*' Unit Costs  Medium'!$ C$ 16 = C177+( D$ 19 D$ 21)*' Unit Costs  Medium'!$ C$ 16 minor enforcement action ( e. g., admin fine) =( C$ 19 C$ 21)*' Unit Costs  Medium'!$ C$ 17 = C178+( D$ 19 D$ 21)*' Unit Costs  Medium'!$ C$ 17 repermit =( C$ 24 C$ 26)*' Unit Costs  Medium'!$ D$ 18 =( D$ 24 D$ 26)*' Unit Costs  Medium'!$ D$ 18 Total hours = SUM( C167: C179) = SUM( D167: D179) Total cost =' Inputs & Assumptions'!$ B$ 5* C180 =' Inputs & Assumptions'!$ B$ 5* D180 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C181: Q181) Maximum one year hours = MAX( C180: Q180) Maximum one year costs = MAX( C181: Q181) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C182) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C172 =' Inputs & Assumptions'!$ B$ 5* D172 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C186: Q186) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C187) Annualized Permitting ( Net of Sampling & Analysis) = C185 C188 Medium Permitting Hours by Activity and Year  New Mass Based 1 2 develop and issue permit = C$ 37*' Unit Costs  Medium'!$ B$ 22 = D$ 37*' Unit Costs  Medium'!$ B$ 22 provide technical guidance = C$ 40*' Unit Costs  Medium'!$ B$ 23 = D$ 40*' Unit Costs  Medium'!$ B$ 23 conduct public or evidentiary hearings = C$ 20*' Unit Costs  Medium'!$ B$ 24 = D$ 20*' Unit Costs  Medium'!$ B$ 24 inspection for permit development = C$ 20*' Unit Costs  Medium'!$ B$ 25 = D$ 20*' Unit Costs  Medium'!$ B$ 25 inspection for compliance assessment =( C$ 20 C$ 22)*' Unit Costs  Medium'!$ C$ 26 = C198+( D$ 20 D$ 22)*' Unit Costs  Medium'!$ C$ 26 sample and analyze effluent =( C$ 20 C$ 22)*' Unit Costs  Medium'!$ C$ 27 = C199+( D$ 20 D$ 22)*' Unit Costs  Medium'!$ C$ 27 review & record self monitoring reports =( C$ 20 C$ 22)*' Unit Costs  Medium'!$ C$ 28 = C200+( D$ 20 D$ 22)*' Unit Costs  Medium'!$ C$ 28 process & act on non compliance reports =( C$ 20 C$ 22)*' Unit Costs  Medium'!$ C$ 29 = C201+( D$ 20 D$ 22)*' Unit Costs  Medium'!$ C$ 29 review compliance schedule report  in compliance with schedule =( C$ 20 C$ 22)*' Unit Costs  Medium'!$ C$ 30 = C202+( D$ 20 D$ 22)*' Unit Costs  Medium'!$ C$ 30 review compliance schedule report  not in compliance with schedule =( C$ 20 C$ 22)*' Unit Costs  Medium'!$ C$ 31 = C203+( D$ 20 D$ 22)*' Unit Costs  Medium'!$ C$ 31 minor enforcement action ( e. g., admin order) =( C$ 20 C$ 22)*' Unit Costs  Medium'!$ C$ 32 = C204+( D$ 20 D$ 22)*' Unit Costs  Medium'!$ C$ 32 minor enforcement action ( e. g., admin fine) =( C$ 20 C$ 22)*' Unit Costs  Medium'!$ C$ 33 = C205+( D$ 20 D$ 22)*' Unit Costs  Medium'!$ C$ 33 repermit =( C$ 25 C$ 27)*' Unit Costs  Medium'!$ D$ 34 =( D$ 25 D$ 27)*' Unit Costs  Medium'!$ D$ 34 Total hours = SUM( C194: C206) = SUM( D194: D206) Total cost =' Inputs & Assumptions'!$ B$ 5* C207 =' Inputs & Assumptions'!$ B$ 5* D207 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C208: Q208) Maximum one year hours = MAX( C207: Q207) Maximum one year costs = MAX( C208: Q208) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C209) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C199 =' Inputs & Assumptions'!$ B$ 5* D199 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C213: Q213) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C214) Annualized Permitting ( Net of Sampling & Analysis) = C212 C215 Medium Permitting Hours by Activity and Year  Conc to Mass Based 1 2 develop and issue permit = C$ 38*' Unit Costs  Medium'!$ B$ 38 = D$ 38*' Unit Costs  Medium'!$ B$ 38 provide technical guidance 0 0 conduct public or evidentiary hearings 0 0 February 14, 2003 34 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 E F G H 3 4 5 6 = E$ 36*' Unit Costs  Medium'!$ B$ 6 = F$ 36*' Unit Costs  Medium'!$ B$ 6 = G$ 36*' Unit Costs  Medium'!$ B$ 6 = H$ 36*' Unit Costs  Medium'!$ B$ 6 = E$ 39*' Unit Costs  Medium'!$ B$ 7 = F$ 39*' Unit Costs  Medium'!$ B$ 7 = G$ 39*' Unit Costs  Medium'!$ B$ 7 = H$ 39*' Unit Costs  Medium'!$ B$ 7 = E$ 19*' Unit Costs  Medium'!$ B$ 8 = F$ 19*' Unit Costs  Medium'!$ B$ 8 = G$ 19*' Unit Costs  Medium'!$ B$ 8 = H$ 19*' Unit Costs  Medium'!$ B$ 8 = E$ 19*' Unit Costs  Medium'!$ B$ 9 = F$ 19*' Unit Costs  Medium'!$ B$ 9 = G$ 19*' Unit Costs  Medium'!$ B$ 9 = H$ 19*' Unit Costs  Medium'!$ B$ 9 = D171+( E$ 19 E$ 21)*' Unit Costs  Medium'!$ C$ 10 = E171+( F$ 19 F$ 21)*' Unit Costs  Medium'!$ C$ 10 = F171+( G$ 19 G$ 21)*' Unit Costs  Medium'!$ C$ 10 = G171+( H$ 19 H$ 21)*' Unit Costs  Medium'!$ C$ 10 = D172+( E$ 19 E$ 21)*' Unit Costs  Medium'!$ C$ 11 = E172+( F$ 19 F$ 21)*' Unit Costs  Medium'!$ C$ 11 = F172+( G$ 19 G$ 21)*' Unit Costs  Medium'!$ C$ 11 = G172+( H$ 19 H$ 21)*' Unit Costs  Medium'!$ C$ 11 = D173+( E$ 19 E$ 21)*' Unit Costs  Medium'!$ C$ 12 = E173+( F$ 19 F$ 21)*' Unit Costs  Medium'!$ C$ 12 = F173+( G$ 19 G$ 21)*' Unit Costs  Medium'!$ C$ 12 = G173+( H$ 19 H$ 21)*' Unit Costs  Medium'!$ C$ 12 = D174+( E$ 19 E$ 21)*' Unit Costs  Medium'!$ C$ 13 = E174+( F$ 19 F$ 21)*' Unit Costs  Medium'!$ C$ 13 = F174+( G$ 19 G$ 21)*' Unit Costs  Medium'!$ C$ 13 = G174+( H$ 19 H$ 21)*' Unit Costs  Medium'!$ C$ 13 = D175+( E$ 19 E$ 21)*' Unit Costs  Medium'!$ C$ 14 = E175+( F$ 19 F$ 21)*' Unit Costs  Medium'!$ C$ 14 = F175+( G$ 19 G$ 21)*' Unit Costs  Medium'!$ C$ 14 = G175+( H$ 19 H$ 21)*' Unit Costs  Medium'!$ C$ 14 = D176+( E$ 19 E$ 21)*' Unit Costs  Medium'!$ C$ 15 = E176+( F$ 19 F$ 21)*' Unit Costs  Medium'!$ C$ 15 = F176+( G$ 19 G$ 21)*' Unit Costs  Medium'!$ C$ 15 = G176+( H$ 19 H$ 21)*' Unit Costs  Medium'!$ C$ 15 = D177+( E$ 19 E$ 21)*' Unit Costs  Medium'!$ C$ 16 = E177+( F$ 19 F$ 21)*' Unit Costs  Medium'!$ C$ 16 = F177+( G$ 19 G$ 21)*' Unit Costs  Medium'!$ C$ 16 = G177+( H$ 19 H$ 21)*' Unit Costs  Medium'!$ C$ 16 = D178+( E$ 19 E$ 21)*' Unit Costs  Medium'!$ C$ 17 = E178+( F$ 19 F$ 21)*' Unit Costs  Medium'!$ C$ 17 = F178+( G$ 19 G$ 21)*' Unit Costs  Medium'!$ C$ 17 = G178+( H$ 19 H$ 21)*' Unit Costs  Medium'!$ C$ 17 =( E$ 24 E$ 26)*' Unit Costs  Medium'!$ D$ 18 =( F$ 24 F$ 26)*' Unit Costs  Medium'!$ D$ 18 =( G$ 24 G$ 26)*' Unit Costs  Medium'!$ D$ 18 =( H$ 24 H$ 26)*' Unit Costs  Medium'!$ D$ 18 = SUM( E167: E179) = SUM( F167: F179) = SUM( G167: G179) = SUM( H167: H179) =' Inputs & Assumptions'!$ B$ 5* E180 =' Inputs & Assumptions'!$ B$ 5* F180 =' Inputs & Assumptions'!$ B$ 5* G180 =' Inputs & Assumptions'!$ B$ 5* H180 =' Inputs & Assumptions'!$ B$ 5* E172 =' Inputs & Assumptions'!$ B$ 5* F172 =' Inputs & Assumptions'!$ B$ 5* G172 =' Inputs & Assumptions'!$ B$ 5* H172 3 4 5 6 = E$ 37*' Unit Costs  Medium'!$ B$ 22 = F$ 37*' Unit Costs  Medium'!$ B$ 22 = G$ 37*' Unit Costs  Medium'!$ B$ 22 = H$ 37*' Unit Costs  Medium'!$ B$ 22 = E$ 40*' Unit Costs  Medium'!$ B$ 23 = F$ 40*' Unit Costs  Medium'!$ B$ 23 = G$ 40*' Unit Costs  Medium'!$ B$ 23 = H$ 40*' Unit Costs  Medium'!$ B$ 23 = E$ 20*' Unit Costs  Medium'!$ B$ 24 = F$ 20*' Unit Costs  Medium'!$ B$ 24 = G$ 20*' Unit Costs  Medium'!$ B$ 24 = H$ 20*' Unit Costs  Medium'!$ B$ 24 = E$ 20*' Unit Costs  Medium'!$ B$ 25 = F$ 20*' Unit Costs  Medium'!$ B$ 25 = G$ 20*' Unit Costs  Medium'!$ B$ 25 = H$ 20*' Unit Costs  Medium'!$ B$ 25 = D198+( E$ 20 E$ 22)*' Unit Costs  Medium'!$ C$ 26 = E198+( F$ 20 F$ 22)*' Unit Costs  Medium'!$ C$ 26 = F198+( G$ 20 G$ 22)*' Unit Costs  Medium'!$ C$ 26 = G198+( H$ 20 H$ 22)*' Unit Costs  Medium'!$ C$ 26 = D199+( E$ 20 E$ 22)*' Unit Costs  Medium'!$ C$ 27 = E199+( F$ 20 F$ 22)*' Unit Costs  Medium'!$ C$ 27 = F199+( G$ 20 G$ 22)*' Unit Costs  Medium'!$ C$ 27 = G199+( H$ 20 H$ 22)*' Unit Costs  Medium'!$ C$ 27 = D200+( E$ 20 E$ 22)*' Unit Costs  Medium'!$ C$ 28 = E200+( F$ 20 F$ 22)*' Unit Costs  Medium'!$ C$ 28 = F200+( G$ 20 G$ 22)*' Unit Costs  Medium'!$ C$ 28 = G200+( H$ 20 H$ 22)*' Unit Costs  Medium'!$ C$ 28 = D201+( E$ 20 E$ 22)*' Unit Costs  Medium'!$ C$ 29 = E201+( F$ 20 F$ 22)*' Unit Costs  Medium'!$ C$ 29 = F201+( G$ 20 G$ 22)*' Unit Costs  Medium'!$ C$ 29 = G201+( H$ 20 H$ 22)*' Unit Costs  Medium'!$ C$ 29 = D202+( E$ 20 E$ 22)*' Unit Costs  Medium'!$ C$ 30 = E202+( F$ 20 F$ 22)*' Unit Costs  Medium'!$ C$ 30 = F202+( G$ 20 G$ 22)*' Unit Costs  Medium'!$ C$ 30 = G202+( H$ 20 H$ 22)*' Unit Costs  Medium'!$ C$ 30 = D203+( E$ 20 E$ 22)*' Unit Costs  Medium'!$ C$ 31 = E203+( F$ 20 F$ 22)*' Unit Costs  Medium'!$ C$ 31 = F203+( G$ 20 G$ 22)*' Unit Costs  Medium'!$ C$ 31 = G203+( H$ 20 H$ 22)*' Unit Costs  Medium'!$ C$ 31 = D204+( E$ 20 E$ 22)*' Unit Costs  Medium'!$ C$ 32 = E204+( F$ 20 F$ 22)*' Unit Costs  Medium'!$ C$ 32 = F204+( G$ 20 G$ 22)*' Unit Costs  Medium'!$ C$ 32 = G204+( H$ 20 H$ 22)*' Unit Costs  Medium'!$ C$ 32 = D205+( E$ 20 E$ 22)*' Unit Costs  Medium'!$ C$ 33 = E205+( F$ 20 F$ 22)*' Unit Costs  Medium'!$ C$ 33 = F205+( G$ 20 G$ 22)*' Unit Costs  Medium'!$ C$ 33 = G205+( H$ 20 H$ 22)*' Unit Costs  Medium'!$ C$ 33 =( E$ 25 E$ 27)*' Unit Costs  Medium'!$ D$ 34 =( F$ 25 F$ 27)*' Unit Costs  Medium'!$ D$ 34 =( G$ 25 G$ 27)*' Unit Costs  Medium'!$ D$ 34 =( H$ 25 H$ 27 C$ 23)*' Unit Costs  Medium'!$ D$ 34 = SUM( E194: E206) = SUM( F194: F206) = SUM( G194: G206) = SUM( H194: H206) =' Inputs & Assumptions'!$ B$ 5* E207 =' Inputs & Assumptions'!$ B$ 5* F207 =' Inputs & Assumptions'!$ B$ 5* G207 =' Inputs & Assumptions'!$ B$ 5* H207 =' Inputs & Assumptions'!$ B$ 5* E199 =' Inputs & Assumptions'!$ B$ 5* F199 =' Inputs & Assumptions'!$ B$ 5* G199 =' Inputs & Assumptions'!$ B$ 5* H199 3 4 5 6 = E$ 38*' Unit Costs  Medium'!$ B$ 38 = F$ 38*' Unit Costs  Medium'!$ B$ 38 = G$ 38*' Unit Costs  Medium'!$ B$ 38 = H$ 38*' Unit Costs  Medium'!$ B$ 38 0 0 0 0 0 0 0 0 February 14, 2003 35 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 I J K L 7 8 9 10 = I$ 36*' Unit Costs  Medium'!$ B$ 6 = J$ 36*' Unit Costs  Medium'!$ B$ 6 = K$ 36*' Unit Costs  Medium'!$ B$ 6 = L$ 36*' Unit Costs  Medium'!$ B$ 6 = I$ 39*' Unit Costs  Medium'!$ B$ 7 = J$ 39*' Unit Costs  Medium'!$ B$ 7 = K$ 39*' Unit Costs  Medium'!$ B$ 7 = L$ 39*' Unit Costs  Medium'!$ B$ 7 = I$ 19*' Unit Costs  Medium'!$ B$ 8 = J$ 19*' Unit Costs  Medium'!$ B$ 8 = K$ 19*' Unit Costs  Medium'!$ B$ 8 = L$ 19*' Unit Costs  Medium'!$ B$ 8 = I$ 19*' Unit Costs  Medium'!$ B$ 9 = J$ 19*' Unit Costs  Medium'!$ B$ 9 = K$ 19*' Unit Costs  Medium'!$ B$ 9 = L$ 19*' Unit Costs  Medium'!$ B$ 9 = H171+( I$ 19 I$ 21)*' Unit Costs  Medium'!$ C$ 10 = I171+( J$ 19 J$ 21)*' Unit Costs  Medium'!$ C$ 10 = J171+( K$ 19 K$ 21)*' Unit Costs  Medium'!$ C$ 10 = K171+( L$ 19 L$ 21)*' Unit Costs  Medium'!$ C$ 10 = H172+( I$ 19 I$ 21)*' Unit Costs  Medium'!$ C$ 11 = I172+( J$ 19 J$ 21)*' Unit Costs  Medium'!$ C$ 11 = J172+( K$ 19 K$ 21)*' Unit Costs  Medium'!$ C$ 11 = K172+( L$ 19 L$ 21)*' Unit Costs  Medium'!$ C$ 11 = H173+( I$ 19 I$ 21)*' Unit Costs  Medium'!$ C$ 12 = I173+( J$ 19 J$ 21)*' Unit Costs  Medium'!$ C$ 12 = J173+( K$ 19 K$ 21)*' Unit Costs  Medium'!$ C$ 12 = K173+( L$ 19 L$ 21)*' Unit Costs  Medium'!$ C$ 12 = H174+( I$ 19 I$ 21)*' Unit Costs  Medium'!$ C$ 13 = I174+( J$ 19 J$ 21)*' Unit Costs  Medium'!$ C$ 13 = J174+( K$ 19 K$ 21)*' Unit Costs  Medium'!$ C$ 13 = K174+( L$ 19 L$ 21)*' Unit Costs  Medium'!$ C$ 13 = H175+( I$ 19 I$ 21)*' Unit Costs  Medium'!$ C$ 14 = I175+( J$ 19 J$ 21)*' Unit Costs  Medium'!$ C$ 14 = J175+( K$ 19 K$ 21)*' Unit Costs  Medium'!$ C$ 14 = K175+( L$ 19 L$ 21)*' Unit Costs  Medium'!$ C$ 14 = H176+( I$ 19 I$ 21)*' Unit Costs  Medium'!$ C$ 15 = I176+( J$ 19 J$ 21)*' Unit Costs  Medium'!$ C$ 15 = J176+( K$ 19 K$ 21)*' Unit Costs  Medium'!$ C$ 15 = K176+( L$ 19 L$ 21)*' Unit Costs  Medium'!$ C$ 15 = H177+( I$ 19 I$ 21)*' Unit Costs  Medium'!$ C$ 16 = I177+( J$ 19 J$ 21)*' Unit Costs  Medium'!$ C$ 16 = J177+( K$ 19 K$ 21)*' Unit Costs  Medium'!$ C$ 16 = K177+( L$ 19 L$ 21)*' Unit Costs  Medium'!$ C$ 16 = H178+( I$ 19 I$ 21)*' Unit Costs  Medium'!$ C$ 17 = I178+( J$ 19 J$ 21)*' Unit Costs  Medium'!$ C$ 17 = J178+( K$ 19 K$ 21)*' Unit Costs  Medium'!$ C$ 17 = K178+( L$ 19 L$ 21)*' Unit Costs  Medium'!$ C$ 17 =( I$ 24 I$ 26)*' Unit Costs  Medium'!$ D$ 18 =( J$ 24 J$ 26)*' Unit Costs  Medium'!$ D$ 18 =( K$ 24 K$ 26)*' Unit Costs  Medium'!$ D$ 18 =( L$ 24 L$ 26)*' Unit Costs  Medium'!$ D$ 18 = SUM( I167: I179) = SUM( J167: J179) = SUM( K167: K179) = SUM( L167: L179) =' Inputs & Assumptions'!$ B$ 5* I180 =' Inputs & Assumptions'!$ B$ 5* J180 =' Inputs & Assumptions'!$ B$ 5* K180 =' Inputs & Assumptions'!$ B$ 5* L180 =' Inputs & Assumptions'!$ B$ 5* I172 =' Inputs & Assumptions'!$ B$ 5* J172 =' Inputs & Assumptions'!$ B$ 5* K172 =' Inputs & Assumptions'!$ B$ 5* L172 Year Relative to Promulgation of Rule 7 8 9 10 = I$ 37*' Unit Costs  Medium'!$ B$ 22 = J$ 37*' Unit Costs  Medium'!$ B$ 22 = K$ 37*' Unit Costs  Medium'!$ B$ 22 = L$ 37*' Unit Costs  Medium'!$ B$ 22 = I$ 40*' Unit Costs  Medium'!$ B$ 23 = J$ 40*' Unit Costs  Medium'!$ B$ 23 = K$ 40*' Unit Costs  Medium'!$ B$ 23 = L$ 40*' Unit Costs  Medium'!$ B$ 23 = I$ 20*' Unit Costs  Medium'!$ B$ 24 = J$ 20*' Unit Costs  Medium'!$ B$ 24 = K$ 20*' Unit Costs  Medium'!$ B$ 24 = L$ 20*' Unit Costs  Medium'!$ B$ 24 = I$ 20*' Unit Costs  Medium'!$ B$ 25 = J$ 20*' Unit Costs  Medium'!$ B$ 25 = K$ 20*' Unit Costs  Medium'!$ B$ 25 = L$ 20*' Unit Costs  Medium'!$ B$ 25 = H198+( I$ 20 I$ 22)*' Unit Costs  Medium'!$ C$ 26 = I198+( J$ 20 J$ 22)*' Unit Costs  Medium'!$ C$ 26 = J198+( K$ 20 K$ 22)*' Unit Costs  Medium'!$ C$ 26 = K198+( L$ 20 L$ 22)*' Unit Costs  Medium'!$ C$ 26 = H199+( I$ 20 I$ 22)*' Unit Costs  Medium'!$ C$ 27 = I199+( J$ 20 J$ 22)*' Unit Costs  Medium'!$ C$ 27 = J199+( K$ 20 K$ 22)*' Unit Costs  Medium'!$ C$ 27 = K199+( L$ 20 L$ 22)*' Unit Costs  Medium'!$ C$ 27 = H200+( I$ 20 I$ 22)*' Unit Costs  Medium'!$ C$ 28 = I200+( J$ 20 J$ 22)*' Unit Costs  Medium'!$ C$ 28 = J200+( K$ 20 K$ 22)*' Unit Costs  Medium'!$ C$ 28 = K200+( L$ 20 L$ 22)*' Unit Costs  Medium'!$ C$ 28 = H201+( I$ 20 I$ 22)*' Unit Costs  Medium'!$ C$ 29 = I201+( J$ 20 J$ 22)*' Unit Costs  Medium'!$ C$ 29 = J201+( K$ 20 K$ 22)*' Unit Costs  Medium'!$ C$ 29 = K201+( L$ 20 L$ 22)*' Unit Costs  Medium'!$ C$ 29 = H202+( I$ 20 I$ 22)*' Unit Costs  Medium'!$ C$ 30 = I202+( J$ 20 J$ 22)*' Unit Costs  Medium'!$ C$ 30 = J202+( K$ 20 K$ 22)*' Unit Costs  Medium'!$ C$ 30 = K202+( L$ 20 L$ 22)*' Unit Costs  Medium'!$ C$ 30 = H203+( I$ 20 I$ 22)*' Unit Costs  Medium'!$ C$ 31 = I203+( J$ 20 J$ 22)*' Unit Costs  Medium'!$ C$ 31 = J203+( K$ 20 K$ 22)*' Unit Costs  Medium'!$ C$ 31 = K203+( L$ 20 L$ 22)*' Unit Costs  Medium'!$ C$ 31 = H204+( I$ 20 I$ 22)*' Unit Costs  Medium'!$ C$ 32 = I204+( J$ 20 J$ 22)*' Unit Costs  Medium'!$ C$ 32 = J204+( K$ 20 K$ 22)*' Unit Costs  Medium'!$ C$ 32 = K204+( L$ 20 L$ 22)*' Unit Costs  Medium'!$ C$ 32 = H205+( I$ 20 I$ 22)*' Unit Costs  Medium'!$ C$ 33 = I205+( J$ 20 J$ 22)*' Unit Costs  Medium'!$ C$ 33 = J205+( K$ 20 K$ 22)*' Unit Costs  Medium'!$ C$ 33 = K205+( L$ 20 L$ 22)*' Unit Costs  Medium'!$ C$ 33 =( I$ 25 I$ 27 D$ 23)*' Unit Costs  Medium'!$ D$ 34 =( J$ 25 J$ 27 E$ 23)*' Unit Costs  Medium'!$ D$ 34 =( K$ 25 K$ 27 F$ 23)*' Unit Costs  Medium'!$ D$ 34 =( L$ 25 L$ 27 G$ 23)*' Unit Costs  Medium'!$ D$ 34 = SUM( I194: I206) = SUM( J194: J206) = SUM( K194: K206) = SUM( L194: L206) =' Inputs & Assumptions'!$ B$ 5* I207 =' Inputs & Assumptions'!$ B$ 5* J207 =' Inputs & Assumptions'!$ B$ 5* K207 =' Inputs & Assumptions'!$ B$ 5* L207 =' Inputs & Assumptions'!$ B$ 5* I199 =' Inputs & Assumptions'!$ B$ 5* J199 =' Inputs & Assumptions'!$ B$ 5* K199 =' Inputs & Assumptions'!$ B$ 5* L199 Year Relative to Promulgation of Rule 7 8 9 10 = I$ 38*' Unit Costs  Medium'!$ B$ 38 = J$ 38*' Unit Costs  Medium'!$ B$ 38 = K$ 38*' Unit Costs  Medium'!$ B$ 38 = L$ 38*' Unit Costs  Medium'!$ B$ 38 0 0 0 0 0 0 0 0 February 14, 2003 36 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 M N O P 11 12 13 14 = M$ 36*' Unit Costs  Medium'!$ B$ 6 = N$ 36*' Unit Costs  Medium'!$ B$ 6 = O$ 36*' Unit Costs  Medium'!$ B$ 6 = P$ 36*' Unit Costs  Medium'!$ B$ 6 = M$ 39*' Unit Costs  Medium'!$ B$ 7 = N$ 39*' Unit Costs  Medium'!$ B$ 7 = O$ 39*' Unit Costs  Medium'!$ B$ 7 = P$ 39*' Unit Costs  Medium'!$ B$ 7 = M$ 19*' Unit Costs  Medium'!$ B$ 8 = N$ 19*' Unit Costs  Medium'!$ B$ 8 = O$ 19*' Unit Costs  Medium'!$ B$ 8 = P$ 19*' Unit Costs  Medium'!$ B$ 8 = M$ 19*' Unit Costs  Medium'!$ B$ 9 = N$ 19*' Unit Costs  Medium'!$ B$ 9 = O$ 19*' Unit Costs  Medium'!$ B$ 9 = P$ 19*' Unit Costs  Medium'!$ B$ 9 = L171+( M$ 19 M$ 21)*' Unit Costs  Medium'!$ C$ 10 = M171+( N$ 19 N$ 21)*' Unit Costs  Medium'!$ C$ 10 = N171+( O$ 19 O$ 21)*' Unit Costs  Medium'!$ C$ 10 = O171+( P$ 19 P$ 21)*' Unit Costs  Medium'!$ C$ 10 = L172+( M$ 19 M$ 21)*' Unit Costs  Medium'!$ C$ 11 = M172+( N$ 19 N$ 21)*' Unit Costs  Medium'!$ C$ 11 = N172+( O$ 19 O$ 21)*' Unit Costs  Medium'!$ C$ 11 = O172+( P$ 19 P$ 21)*' Unit Costs  Medium'!$ C$ 11 = L173+( M$ 19 M$ 21)*' Unit Costs  Medium'!$ C$ 12 = M173+( N$ 19 N$ 21)*' Unit Costs  Medium'!$ C$ 12 = N173+( O$ 19 O$ 21)*' Unit Costs  Medium'!$ C$ 12 = O173+( P$ 19 P$ 21)*' Unit Costs  Medium'!$ C$ 12 = L174+( M$ 19 M$ 21)*' Unit Costs  Medium'!$ C$ 13 = M174+( N$ 19 N$ 21)*' Unit Costs  Medium'!$ C$ 13 = N174+( O$ 19 O$ 21)*' Unit Costs  Medium'!$ C$ 13 = O174+( P$ 19 P$ 21)*' Unit Costs  Medium'!$ C$ 13 = L175+( M$ 19 M$ 21)*' Unit Costs  Medium'!$ C$ 14 = M175+( N$ 19 N$ 21)*' Unit Costs  Medium'!$ C$ 14 = N175+( O$ 19 O$ 21)*' Unit Costs  Medium'!$ C$ 14 = O175+( P$ 19 P$ 21)*' Unit Costs  Medium'!$ C$ 14 = L176+( M$ 19 M$ 21)*' Unit Costs  Medium'!$ C$ 15 = M176+( N$ 19 N$ 21)*' Unit Costs  Medium'!$ C$ 15 = N176+( O$ 19 O$ 21)*' Unit Costs  Medium'!$ C$ 15 = O176+( P$ 19 P$ 21)*' Unit Costs  Medium'!$ C$ 15 = L177+( M$ 19 M$ 21)*' Unit Costs  Medium'!$ C$ 16 = M177+( N$ 19 N$ 21)*' Unit Costs  Medium'!$ C$ 16 = N177+( O$ 19 O$ 21)*' Unit Costs  Medium'!$ C$ 16 = O177+( P$ 19 P$ 21)*' Unit Costs  Medium'!$ C$ 16 = L178+( M$ 19 M$ 21)*' Unit Costs  Medium'!$ C$ 17 = M178+( N$ 19 N$ 21)*' Unit Costs  Medium'!$ C$ 17 = N178+( O$ 19 O$ 21)*' Unit Costs  Medium'!$ C$ 17 = O178+( P$ 19 P$ 21)*' Unit Costs  Medium'!$ C$ 17 =( M$ 24 M$ 26)*' Unit Costs  Medium'!$ D$ 18 =( N$ 24 N$ 26)*' Unit Costs  Medium'!$ D$ 18 =( O$ 24 O$ 26)*' Unit Costs  Medium'!$ D$ 18 =( P$ 24 P$ 26)*' Unit Costs  Medium'!$ D$ 18 = SUM( M167: M179) = SUM( N167: N179) = SUM( O167: O179) = SUM( P167: P179) =' Inputs & Assumptions'!$ B$ 5* M180 =' Inputs & Assumptions'!$ B$ 5* N180 =' Inputs & Assumptions'!$ B$ 5* O180 =' Inputs & Assumptions'!$ B$ 5* P180 =' Inputs & Assumptions'!$ B$ 5* M172 =' Inputs & Assumptions'!$ B$ 5* N172 =' Inputs & Assumptions'!$ B$ 5* O172 =' Inputs & Assumptions'!$ B$ 5* P172 11 12 13 14 = M$ 37*' Unit Costs  Medium'!$ B$ 22 = N$ 37*' Unit Costs  Medium'!$ B$ 22 = O$ 37*' Unit Costs  Medium'!$ B$ 22 = P$ 37*' Unit Costs  Medium'!$ B$ 22 = M$ 40*' Unit Costs  Medium'!$ B$ 23 = N$ 40*' Unit Costs  Medium'!$ B$ 23 = O$ 40*' Unit Costs  Medium'!$ B$ 23 = P$ 40*' Unit Costs  Medium'!$ B$ 23 = M$ 20*' Unit Costs  Medium'!$ B$ 24 = N$ 20*' Unit Costs  Medium'!$ B$ 24 = O$ 20*' Unit Costs  Medium'!$ B$ 24 = P$ 20*' Unit Costs  Medium'!$ B$ 24 = M$ 20*' Unit Costs  Medium'!$ B$ 25 = N$ 20*' Unit Costs  Medium'!$ B$ 25 = O$ 20*' Unit Costs  Medium'!$ B$ 25 = P$ 20*' Unit Costs  Medium'!$ B$ 25 = L198+( M$ 20 M$ 22)*' Unit Costs  Medium'!$ C$ 26 = M198+( N$ 20 N$ 22)*' Unit Costs  Medium'!$ C$ 26 = N198+( O$ 20 O$ 22)*' Unit Costs  Medium'!$ C$ 26 = O198+( P$ 20 P$ 22)*' Unit Costs  Medium'!$ C$ 26 = L199+( M$ 20 M$ 22)*' Unit Costs  Medium'!$ C$ 27 = M199+( N$ 20 N$ 22)*' Unit Costs  Medium'!$ C$ 27 = N199+( O$ 20 O$ 22)*' Unit Costs  Medium'!$ C$ 27 = O199+( P$ 20 P$ 22)*' Unit Costs  Medium'!$ C$ 27 = L200+( M$ 20 M$ 22)*' Unit Costs  Medium'!$ C$ 28 = M200+( N$ 20 N$ 22)*' Unit Costs  Medium'!$ C$ 28 = N200+( O$ 20 O$ 22)*' Unit Costs  Medium'!$ C$ 28 = O200+( P$ 20 P$ 22)*' Unit Costs  Medium'!$ C$ 28 = L201+( M$ 20 M$ 22)*' Unit Costs  Medium'!$ C$ 29 = M201+( N$ 20 N$ 22)*' Unit Costs  Medium'!$ C$ 29 = N201+( O$ 20 O$ 22)*' Unit Costs  Medium'!$ C$ 29 = O201+( P$ 20 P$ 22)*' Unit Costs  Medium'!$ C$ 29 = L202+( M$ 20 M$ 22)*' Unit Costs  Medium'!$ C$ 30 = M202+( N$ 20 N$ 22)*' Unit Costs  Medium'!$ C$ 30 = N202+( O$ 20 O$ 22)*' Unit Costs  Medium'!$ C$ 30 = O202+( P$ 20 P$ 22)*' Unit Costs  Medium'!$ C$ 30 = L203+( M$ 20 M$ 22)*' Unit Costs  Medium'!$ C$ 31 = M203+( N$ 20 N$ 22)*' Unit Costs  Medium'!$ C$ 31 = N203+( O$ 20 O$ 22)*' Unit Costs  Medium'!$ C$ 31 = O203+( P$ 20 P$ 22)*' Unit Costs  Medium'!$ C$ 31 = L204+( M$ 20 M$ 22)*' Unit Costs  Medium'!$ C$ 32 = M204+( N$ 20 N$ 22)*' Unit Costs  Medium'!$ C$ 32 = N204+( O$ 20 O$ 22)*' Unit Costs  Medium'!$ C$ 32 = O204+( P$ 20 P$ 22)*' Unit Costs  Medium'!$ C$ 32 = L205+( M$ 20 M$ 22)*' Unit Costs  Medium'!$ C$ 33 = M205+( N$ 20 N$ 22)*' Unit Costs  Medium'!$ C$ 33 = N205+( O$ 20 O$ 22)*' Unit Costs  Medium'!$ C$ 33 = O205+( P$ 20 P$ 22)*' Unit Costs  Medium'!$ C$ 33 =( H$ 25 H$ 27 C$ 23)*' Unit Costs  Medium'!$ D$ 34 =( I$ 25 I$ 27 D$ 23)*' Unit Costs  Medium'!$ D$ 34 =( J$ 25 J$ 27 E$ 23)*' Unit Costs  Medium'!$ D$ 34 =( K$ 25 K$ 27 F$ 23)*' Unit Costs  Medium'!$ D$ 34 = SUM( M194: M206) = SUM( N194: N206) = SUM( O194: O206) = SUM( P194: P206) =' Inputs & Assumptions'!$ B$ 5* M207 =' Inputs & Assumptions'!$ B$ 5* N207 =' Inputs & Assumptions'!$ B$ 5* O207 =' Inputs & Assumptions'!$ B$ 5* P207 =' Inputs & Assumptions'!$ B$ 5* M199 =' Inputs & Assumptions'!$ B$ 5* N199 =' Inputs & Assumptions'!$ B$ 5* O199 =' Inputs & Assumptions'!$ B$ 5* P199 11 12 13 14 = M$ 38*' Unit Costs  Medium'!$ B$ 38 = N$ 38*' Unit Costs  Medium'!$ B$ 38 = O$ 38*' Unit Costs  Medium'!$ B$ 38 = P$ 38*' Unit Costs  Medium'!$ B$ 38 0 0 0 0 0 0 0 0 February 14, 2003 37 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 Q 15 = Q$ 36*' Unit Costs  Medium'!$ B$ 6 = Q$ 39*' Unit Costs  Medium'!$ B$ 7 = Q$ 19*' Unit Costs  Medium'!$ B$ 8 = Q$ 19*' Unit Costs  Medium'!$ B$ 9 = P171+( Q$ 19 Q$ 21)*' Unit Costs  Medium'!$ C$ 10 = P172+( Q$ 19 Q$ 21)*' Unit Costs  Medium'!$ C$ 11 = P173+( Q$ 19 Q$ 21)*' Unit Costs  Medium'!$ C$ 12 = P174+( Q$ 19 Q$ 21)*' Unit Costs  Medium'!$ C$ 13 = P175+( Q$ 19 Q$ 21)*' Unit Costs  Medium'!$ C$ 14 = P176+( Q$ 19 Q$ 21)*' Unit Costs  Medium'!$ C$ 15 = P177+( Q$ 19 Q$ 21)*' Unit Costs  Medium'!$ C$ 16 = P178+( Q$ 19 Q$ 21)*' Unit Costs  Medium'!$ C$ 17 =( Q$ 24 Q$ 26)*' Unit Costs  Medium'!$ D$ 18 = SUM( Q167: Q179) =' Inputs & Assumptions'!$ B$ 5* Q180 =' Inputs & Assumptions'!$ B$ 5* Q172 15 = Q$ 37*' Unit Costs  Medium'!$ B$ 22 = Q$ 40*' Unit Costs  Medium'!$ B$ 23 = Q$ 20*' Unit Costs  Medium'!$ B$ 24 = Q$ 20*' Unit Costs  Medium'!$ B$ 25 = P198+( Q$ 20 Q$ 22)*' Unit Costs  Medium'!$ C$ 26 = P199+( Q$ 20 Q$ 22)*' Unit Costs  Medium'!$ C$ 27 = P200+( Q$ 20 Q$ 22)*' Unit Costs  Medium'!$ C$ 28 = P201+( Q$ 20 Q$ 22)*' Unit Costs  Medium'!$ C$ 29 = P202+( Q$ 20 Q$ 22)*' Unit Costs  Medium'!$ C$ 30 = P203+( Q$ 20 Q$ 22)*' Unit Costs  Medium'!$ C$ 31 = P204+( Q$ 20 Q$ 22)*' Unit Costs  Medium'!$ C$ 32 = P205+( Q$ 20 Q$ 22)*' Unit Costs  Medium'!$ C$ 33 =( L$ 25 L$ 27 G$ 23)*' Unit Costs  Medium'!$ D$ 34 = SUM( Q194: Q206) =' Inputs & Assumptions'!$ B$ 5* Q207 =' Inputs & Assumptions'!$ B$ 5* Q199 15 = Q$ 38*' Unit Costs  Medium'!$ B$ 38 0 0 February 14, 2003 38 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 A B C D inspection for permit development 0 0 inspection for compliance assessment 0 0 sample and analyze effluent 0 0 review & record self monitoring reports 0 0 process & act on non compliance reports 0 0 review compliance schedule report  in compliance with schedule 0 0 review compliance schedule report  not in compliance with schedule 0 0 minor enforcement action ( e. g., admin order) 0 0 minor enforcement action ( e. g., admin fine) 0 0 repermit 0 0 Total hours = SUM( C221: C233) = SUM( D221: D233) Total cost =' Inputs & Assumptions'!$ B$ 5* C234 =' Inputs & Assumptions'!$ B$ 5* D234 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C235: Q235) Maximum one year hours = MAX( C234: Q234) Maximum one year costs = MAX( C235: Q235) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C236) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C226 =' Inputs & Assumptions'!$ B$ 5* D226 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C240: Q240) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C241) Annualized Permitting ( Net of Sampling & Analysis) = C239 C242 Medium Permitting Hours by Activity and Year  Total 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'!$ B$ 32 = D$ 41*' Unit Costs  Medium'!$ B$ 32 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( C248: C260) = SUM( D248: D260) Total cost =' Inputs & Assumptions'!$ B$ 5* C261 =' Inputs & Assumptions'!$ B$ 5* D261 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C262: Q262) Maximum one year hours = MAX( C261: Q261) Maximum one year costs = MAX( C262: Q262) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C263) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C253 =' Inputs & Assumptions'!$ B$ 5* D253 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C267: Q267) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C268) Annualized Permitting ( Net of Sampling & Analysis) = C266 C269 Low Permitting Hours by Activity and Year  New Concentration Based 1 2 develop and issue permit = C$ 36*' Unit Costs  Low'!$ B$ 6 = D$ 36*' Unit Costs  Low'!$ B$ 6 February 14, 2003 39 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 E F G H 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 =( C$ 23)*' Unit Costs  Medium'!$ D$ 50 = SUM( E221: E233) = SUM( F221: F233) = SUM( G221: G233) = SUM( H221: H233) =' Inputs & Assumptions'!$ B$ 5* E234 =' Inputs & Assumptions'!$ B$ 5* F234 =' Inputs & Assumptions'!$ B$ 5* G234 =' Inputs & Assumptions'!$ B$ 5* H234 =' Inputs & Assumptions'!$ B$ 5* E226 =' Inputs & Assumptions'!$ B$ 5* F226 =' Inputs & Assumptions'!$ B$ 5* G226 =' Inputs & Assumptions'!$ B$ 5* H226 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'!$ B$ 32 = F$ 41*' Unit Costs  Medium'!$ B$ 8 = G$ 41*' Unit Costs  Medium'!$ B$ 8 = H$ 41*' Unit Costs  Medium'!$ B$ 8 = 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( E248: E260) = SUM( F248: F260) = SUM( G248: G260) = SUM( H248: H260) =' Inputs & Assumptions'!$ B$ 5* E261 =' Inputs & Assumptions'!$ B$ 5* F261 =' Inputs & Assumptions'!$ B$ 5* G261 =' Inputs & Assumptions'!$ B$ 5* H261 =' Inputs & Assumptions'!$ B$ 5* E253 =' Inputs & Assumptions'!$ B$ 5* F253 =' Inputs & Assumptions'!$ B$ 5* G253 =' Inputs & Assumptions'!$ B$ 5* H253 3 4 5 6 = E$ 36*' Unit Costs  Low'!$ B$ 6 = F$ 36*' Unit Costs  Low'!$ B$ 6 = G$ 36*' Unit Costs  Low'!$ B$ 6 = H$ 36*' Unit Costs  Low'!$ B$ 6 February 14, 2003 40 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 I J K L 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 =( D$ 23)*' Unit Costs  Medium'!$ D$ 50 =( E$ 23)*' Unit Costs  Medium'!$ D$ 50 =( F$ 23)*' Unit Costs  Medium'!$ D$ 50 =( G$ 23)*' Unit Costs  Medium'!$ D$ 50 = SUM( I221: I233) = SUM( J221: J233) = SUM( K221: K233) = SUM( L221: L233) =' Inputs & Assumptions'!$ B$ 5* I234 =' Inputs & Assumptions'!$ B$ 5* J234 =' Inputs & Assumptions'!$ B$ 5* K234 =' Inputs & Assumptions'!$ B$ 5* L234 =' Inputs & Assumptions'!$ B$ 5* I226 =' Inputs & Assumptions'!$ B$ 5* J226 =' Inputs & Assumptions'!$ B$ 5* K226 =' Inputs & Assumptions'!$ B$ 5* L226 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'!$ B$ 8 = J$ 41*' Unit Costs  Medium'!$ B$ 8 = K$ 41*' Unit Costs  Medium'!$ B$ 8 = L$ 41*' Unit Costs  Medium'!$ B$ 8 = 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( I248: I260) = SUM( J248: J260) = SUM( K248: K260) = SUM( L248: L260) =' Inputs & Assumptions'!$ B$ 5* I261 =' Inputs & Assumptions'!$ B$ 5* J261 =' Inputs & Assumptions'!$ B$ 5* K261 =' Inputs & Assumptions'!$ B$ 5* L261 =' Inputs & Assumptions'!$ B$ 5* I253 =' Inputs & Assumptions'!$ B$ 5* J253 =' Inputs & Assumptions'!$ B$ 5* K253 =' Inputs & Assumptions'!$ B$ 5* L253 Year Relative to Promulgation of Rule 7 8 9 10 = I$ 36*' Unit Costs  Low'!$ B$ 6 = J$ 36*' Unit Costs  Low'!$ B$ 6 = K$ 36*' Unit Costs  Low'!$ B$ 6 = L$ 36*' Unit Costs  Low'!$ B$ 6 February 14, 2003 41 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 M N O P 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 =( C$ 23)*' Unit Costs  Medium'!$ D$ 50 =( D$ 23)*' Unit Costs  Medium'!$ D$ 50 =( E$ 23)*' Unit Costs  Medium'!$ D$ 50 =( F$ 23)*' Unit Costs  Medium'!$ D$ 50 = SUM( M221: M233) = SUM( N221: N233) = SUM( O221: O233) = SUM( P221: P233) =' Inputs & Assumptions'!$ B$ 5* M234 =' Inputs & Assumptions'!$ B$ 5* N234 =' Inputs & Assumptions'!$ B$ 5* O234 =' Inputs & Assumptions'!$ B$ 5* P234 =' Inputs & Assumptions'!$ B$ 5* M226 =' Inputs & Assumptions'!$ B$ 5* N226 =' Inputs & Assumptions'!$ B$ 5* O226 =' Inputs & Assumptions'!$ B$ 5* P226 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'!$ B$ 8 = N$ 41*' Unit Costs  Medium'!$ B$ 8 = O$ 41*' Unit Costs  Medium'!$ B$ 8 = P$ 41*' Unit Costs  Medium'!$ B$ 8 = 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( M248: M260) = SUM( N248: N260) = SUM( O248: O260) = SUM( P248: P260) =' Inputs & Assumptions'!$ B$ 5* M261 =' Inputs & Assumptions'!$ B$ 5* N261 =' Inputs & Assumptions'!$ B$ 5* O261 =' Inputs & Assumptions'!$ B$ 5* P261 =' Inputs & Assumptions'!$ B$ 5* M253 =' Inputs & Assumptions'!$ B$ 5* N253 =' Inputs & Assumptions'!$ B$ 5* O253 =' Inputs & Assumptions'!$ B$ 5* P253 11 12 13 14 = M$ 36*' Unit Costs  Low'!$ B$ 6 = N$ 36*' Unit Costs  Low'!$ B$ 6 = O$ 36*' Unit Costs  Low'!$ B$ 6 = P$ 36*' Unit Costs  Low'!$ B$ 6 February 14, 2003 42 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 Q 0 0 0 0 0 0 0 0 0 =( G$ 23)*' Unit Costs  Medium'!$ D$ 50 = SUM( Q221: Q233) =' Inputs & Assumptions'!$ B$ 5* Q234 =' Inputs & Assumptions'!$ B$ 5* Q226 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'!$ B$ 8 = 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( Q248: Q260) =' Inputs & Assumptions'!$ B$ 5* Q261 =' Inputs & Assumptions'!$ B$ 5* Q253 15 = Q$ 36*' Unit Costs  Low'!$ B$ 6 February 14, 2003 43 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 A B C D provide technical guidance = C$ 39*' Unit Costs  Low'!$ B$ 7 = D$ 39*' Unit Costs  Low'!$ B$ 7 conduct public or evidentiary hearings = C$ 19*' Unit Costs  Low'!$ B$ 8 = D$ 19*' Unit Costs  Low'!$ B$ 8 inspection for permit development = C$ 19*' Unit Costs  Low'!$ B$ 9 = D$ 19*' Unit Costs  Low'!$ B$ 9 inspection for compliance assessment =( C$ 19 C$ 21)*' Unit Costs  Low'!$ C$ 10 = C281+( D$ 19 D$ 21)*' Unit Costs  Low'!$ C$ 10 sample and analyze effluent =( C$ 19 C$ 21)*' Unit Costs  Low'!$ C$ 11 = C282+( D$ 19 D$ 21)*' Unit Costs  Low'!$ C$ 11 review & record self monitoring reports =( C$ 19 C$ 21)*' Unit Costs  Low'!$ C$ 12 = C283+( D$ 19 D$ 21)*' Unit Costs  Low'!$ C$ 12 process & act on non compliance reports =( C$ 19 C$ 21)*' Unit Costs  Low'!$ C$ 13 = C284+( D$ 19 D$ 21)*' Unit Costs  Low'!$ C$ 13 review compliance schedule report  in compliance with schedule =( C$ 19 C$ 21)*' Unit Costs  Low'!$ C$ 14 = C285+( D$ 19 D$ 21)*' Unit Costs  Low'!$ C$ 14 review compliance schedule report  not in compliance with schedule =( C$ 19 C$ 21)*' Unit Costs  Low'!$ C$ 15 = C286+( D$ 19 D$ 21)*' Unit Costs  Low'!$ C$ 15 minor enforcement action ( e. g., admin order) =( C$ 19 C$ 21)*' Unit Costs  Low'!$ C$ 16 = C287+( D$ 19 D$ 21)*' Unit Costs  Low'!$ C$ 16 minor enforcement action ( e. g., admin fine) =( C$ 19 C$ 21)*' Unit Costs  Low'!$ C$ 17 = C288+( D$ 19 D$ 21)*' Unit Costs  Low'!$ C$ 17 repermit =( C$ 24 C$ 26)*' Unit Costs  Low'!$ D$ 18 =( D$ 24 D$ 26)*' Unit Costs  Low'!$ D$ 18 Total hours = SUM( C277: C289) = SUM( D277: D289) Total cost =' Inputs & Assumptions'!$ B$ 5* C290 =' Inputs & Assumptions'!$ B$ 5* D290 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C291: Q291) Maximum one year hours = MAX( C290: Q290) Maximum one year costs = MAX( C291: Q291) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C292) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C282 =' Inputs & Assumptions'!$ B$ 5* D282 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C296: Q296) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C297) Annualized Permitting ( Net of Sampling & Analysis) = C295 C298 Low Permitting Hours by Activity and Year  New Mass Based 1 2 develop and issue permit = C$ 37*' Unit Costs  Low'!$ B$ 22 = D$ 37*' Unit Costs  Low'!$ B$ 22 provide technical guidance = C$ 40*' Unit Costs  Low'!$ B$ 23 = D$ 40*' Unit Costs  Low'!$ B$ 23 conduct public or evidentiary hearings = C$ 20*' Unit Costs  Low'!$ B$ 24 = D$ 20*' Unit Costs  Low'!$ B$ 24 inspection for permit development = C$ 20*' Unit Costs  Low'!$ B$ 25 = D$ 20*' Unit Costs  Low'!$ B$ 25 inspection for compliance assessment =( C$ 20 C$ 22)*' Unit Costs  Low'!$ C$ 26 = C308+( D$ 20 D$ 22)*' Unit Costs  Low'!$ C$ 26 sample and analyze effluent =( C$ 20 C$ 22)*' Unit Costs  Low'!$ C$ 27 = C309+( D$ 20 D$ 22)*' Unit Costs  Low'!$ C$ 27 review & record self monitoring reports =( C$ 20 C$ 22)*' Unit Costs  Low'!$ C$ 28 = C310+( D$ 20 D$ 22)*' Unit Costs  Low'!$ C$ 28 process & act on non compliance reports =( C$ 20 C$ 22)*' Unit Costs  Low'!$ C$ 29 = C311+( D$ 20 D$ 22)*' Unit Costs  Low'!$ C$ 29 review compliance schedule report  in compliance with schedule =( C$ 20 C$ 22)*' Unit Costs  Low'!$ C$ 30 = C312+( D$ 20 D$ 22)*' Unit Costs  Low'!$ C$ 30 review compliance schedule report  not in compliance with schedule =( C$ 20 C$ 22)*' Unit Costs  Low'!$ C$ 31 = C313+( D$ 20 D$ 22)*' Unit Costs  Low'!$ C$ 31 minor enforcement action ( e. g., admin order) =( C$ 20 C$ 22)*' Unit Costs  Low'!$ C$ 32 = C314+( D$ 20 D$ 22)*' Unit Costs  Low'!$ C$ 32 minor enforcement action ( e. g., admin fine) =( C$ 20 C$ 22)*' Unit Costs  Low'!$ C$ 33 = C315+( D$ 20 D$ 22)*' Unit Costs  Low'!$ C$ 33 repermit =( C$ 25 C$ 27)*' Unit Costs  Low'!$ D$ 34 =( D$ 25 D$ 27)*' Unit Costs  Low'!$ D$ 34 Total hours = SUM( C304: C316) = SUM( D304: D316) Total cost =' Inputs & Assumptions'!$ B$ 5* C317 =' Inputs & Assumptions'!$ B$ 5* D317 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C318: Q318) Maximum one year hours = MAX( C317: Q317) Maximum one year costs = MAX( C318: Q318) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C319) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C309 =' Inputs & Assumptions'!$ B$ 5* D309 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C323: Q323) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C324) Annualized Permitting ( Net of Sampling & Analysis) = C322 C325 Low Permitting Hours by Activity and Year  Conc to Mass Based 1 2 develop and issue permit = C$ 38*' Unit Costs  Low'!$ B$ 38 = D$ 38*' Unit Costs  Low'!$ B$ 38 provide technical guidance 0 0 conduct public or evidentiary hearings 0 0 inspection for permit development 0 0 inspection for compliance assessment 0 0 February 14, 2003 44 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 E F G H = E$ 39*' Unit Costs  Low'!$ B$ 7 = F$ 39*' Unit Costs  Low'!$ B$ 7 = G$ 39*' Unit Costs  Low'!$ B$ 7 = H$ 39*' Unit Costs  Low'!$ B$ 7 = E$ 19*' Unit Costs  Low'!$ B$ 8 = F$ 19*' Unit Costs  Low'!$ B$ 8 = G$ 19*' Unit Costs  Low'!$ B$ 8 = H$ 19*' Unit Costs  Low'!$ B$ 8 = E$ 19*' Unit Costs  Low'!$ B$ 9 = F$ 19*' Unit Costs  Low'!$ B$ 9 = G$ 19*' Unit Costs  Low'!$ B$ 9 = H$ 19*' Unit Costs  Low'!$ B$ 9 = D281+( E$ 19 E$ 21)*' Unit Costs  Low'!$ C$ 10 = E281+( F$ 19 F$ 21)*' Unit Costs  Low'!$ C$ 10 = F281+( G$ 19 G$ 21)*' Unit Costs  Low'!$ C$ 10 = G281+( H$ 19 H$ 21)*' Unit Costs  Low'!$ C$ 10 = D282+( E$ 19 E$ 21)*' Unit Costs  Low'!$ C$ 11 = E282+( F$ 19 F$ 21)*' Unit Costs  Low'!$ C$ 11 = F282+( G$ 19 G$ 21)*' Unit Costs  Low'!$ C$ 11 = G282+( H$ 19 H$ 21)*' Unit Costs  Low'!$ C$ 11 = D283+( E$ 19 E$ 21)*' Unit Costs  Low'!$ C$ 12 = E283+( F$ 19 F$ 21)*' Unit Costs  Low'!$ C$ 12 = F283+( G$ 19 G$ 21)*' Unit Costs  Low'!$ C$ 12 = G283+( H$ 19 H$ 21)*' Unit Costs  Low'!$ C$ 12 = D284+( E$ 19 E$ 21)*' Unit Costs  Low'!$ C$ 13 = E284+( F$ 19 F$ 21)*' Unit Costs  Low'!$ C$ 13 = F284+( G$ 19 G$ 21)*' Unit Costs  Low'!$ C$ 13 = G284+( H$ 19 H$ 21)*' Unit Costs  Low'!$ C$ 13 = D285+( E$ 19 E$ 21)*' Unit Costs  Low'!$ C$ 14 = E285+( F$ 19 F$ 21)*' Unit Costs  Low'!$ C$ 14 = F285+( G$ 19 G$ 21)*' Unit Costs  Low'!$ C$ 14 = G285+( H$ 19 H$ 21)*' Unit Costs  Low'!$ C$ 14 = D286+( E$ 19 E$ 21)*' Unit Costs  Low'!$ C$ 15 = E286+( F$ 19 F$ 21)*' Unit Costs  Low'!$ C$ 15 = F286+( G$ 19 G$ 21)*' Unit Costs  Low'!$ C$ 15 = G286+( H$ 19 H$ 21)*' Unit Costs  Low'!$ C$ 15 = D287+( E$ 19 E$ 21)*' Unit Costs  Low'!$ C$ 16 = E287+( F$ 19 F$ 21)*' Unit Costs  Low'!$ C$ 16 = F287+( G$ 19 G$ 21)*' Unit Costs  Low'!$ C$ 16 = G287+( H$ 19 H$ 21)*' Unit Costs  Low'!$ C$ 16 = D288+( E$ 19 E$ 21)*' Unit Costs  Low'!$ C$ 17 = E288+( F$ 19 F$ 21)*' Unit Costs  Low'!$ C$ 17 = F288+( G$ 19 G$ 21)*' Unit Costs  Low'!$ C$ 17 = G288+( H$ 19 H$ 21)*' Unit Costs  Low'!$ C$ 17 =( E$ 24 E$ 26)*' Unit Costs  Low'!$ D$ 18 =( F$ 24 F$ 26)*' Unit Costs  Low'!$ D$ 18 =( G$ 24 G$ 26)*' Unit Costs  Low'!$ D$ 18 =( H$ 24 H$ 26)*' Unit Costs  Low'!$ D$ 18 = SUM( E277: E289) = SUM( F277: F289) = SUM( G277: G289) = SUM( H277: H289) =' Inputs & Assumptions'!$ B$ 5* E290 =' Inputs & Assumptions'!$ B$ 5* F290 =' Inputs & Assumptions'!$ B$ 5* G290 =' Inputs & Assumptions'!$ B$ 5* H290 =' Inputs & Assumptions'!$ B$ 5* E282 =' Inputs & Assumptions'!$ B$ 5* F282 =' Inputs & Assumptions'!$ B$ 5* G282 =' Inputs & Assumptions'!$ B$ 5* H282 3 4 5 6 = E$ 37*' Unit Costs  Low'!$ B$ 22 = F$ 37*' Unit Costs  Low'!$ B$ 22 = G$ 37*' Unit Costs  Low'!$ B$ 22 = H$ 37*' Unit Costs  Low'!$ B$ 22 = E$ 40*' Unit Costs  Low'!$ B$ 23 = F$ 40*' Unit Costs  Low'!$ B$ 23 = G$ 40*' Unit Costs  Low'!$ B$ 23 = H$ 40*' Unit Costs  Low'!$ B$ 23 = E$ 20*' Unit Costs  Low'!$ B$ 24 = F$ 20*' Unit Costs  Low'!$ B$ 24 = G$ 20*' Unit Costs  Low'!$ B$ 24 = H$ 20*' Unit Costs  Low'!$ B$ 24 = E$ 20*' Unit Costs  Low'!$ B$ 25 = F$ 20*' Unit Costs  Low'!$ B$ 25 = G$ 20*' Unit Costs  Low'!$ B$ 25 = H$ 20*' Unit Costs  Low'!$ B$ 25 = D308+( E$ 20 E$ 22)*' Unit Costs  Low'!$ C$ 26 = E308+( F$ 20 F$ 22)*' Unit Costs  Low'!$ C$ 26 = F308+( G$ 20 G$ 22)*' Unit Costs  Low'!$ C$ 26 = G308+( H$ 20 H$ 22)*' Unit Costs  Low'!$ C$ 26 = D309+( E$ 20 E$ 22)*' Unit Costs  Low'!$ C$ 27 = E309+( F$ 20 F$ 22)*' Unit Costs  Low'!$ C$ 27 = F309+( G$ 20 G$ 22)*' Unit Costs  Low'!$ C$ 27 = G309+( H$ 20 H$ 22)*' Unit Costs  Low'!$ C$ 27 = D310+( E$ 20 E$ 22)*' Unit Costs  Low'!$ C$ 28 = E310+( F$ 20 F$ 22)*' Unit Costs  Low'!$ C$ 28 = F310+( G$ 20 G$ 22)*' Unit Costs  Low'!$ C$ 28 = G310+( H$ 20 H$ 22)*' Unit Costs  Low'!$ C$ 28 = D311+( E$ 20 E$ 22)*' Unit Costs  Low'!$ C$ 29 = E311+( F$ 20 F$ 22)*' Unit Costs  Low'!$ C$ 29 = F311+( G$ 20 G$ 22)*' Unit Costs  Low'!$ C$ 29 = G311+( H$ 20 H$ 22)*' Unit Costs  Low'!$ C$ 29 = D312+( E$ 20 E$ 22)*' Unit Costs  Low'!$ C$ 30 = E312+( F$ 20 F$ 22)*' Unit Costs  Low'!$ C$ 30 = F312+( G$ 20 G$ 22)*' Unit Costs  Low'!$ C$ 30 = G312+( H$ 20 H$ 22)*' Unit Costs  Low'!$ C$ 30 = D313+( E$ 20 E$ 22)*' Unit Costs  Low'!$ C$ 31 = E313+( F$ 20 F$ 22)*' Unit Costs  Low'!$ C$ 31 = F313+( G$ 20 G$ 22)*' Unit Costs  Low'!$ C$ 31 = G313+( H$ 20 H$ 22)*' Unit Costs  Low'!$ C$ 31 = D314+( E$ 20 E$ 22)*' Unit Costs  Low'!$ C$ 32 = E314+( F$ 20 F$ 22)*' Unit Costs  Low'!$ C$ 32 = F314+( G$ 20 G$ 22)*' Unit Costs  Low'!$ C$ 32 = G314+( H$ 20 H$ 22)*' Unit Costs  Low'!$ C$ 32 = D315+( E$ 20 E$ 22)*' Unit Costs  Low'!$ C$ 33 = E315+( F$ 20 F$ 22)*' Unit Costs  Low'!$ C$ 33 = F315+( G$ 20 G$ 22)*' Unit Costs  Low'!$ C$ 33 = G315+( H$ 20 H$ 22)*' Unit Costs  Low'!$ C$ 33 =( E$ 25 E$ 27)*' Unit Costs  Low'!$ D$ 34 =( F$ 25 F$ 27)*' Unit Costs  Low'!$ D$ 34 =( G$ 25 G$ 27)*' Unit Costs  Low'!$ D$ 34 =( H$ 25 H$ 27 C$ 23)*' Unit Costs  Low'!$ D$ 34 = SUM( E304: E316) = SUM( F304: F316) = SUM( G304: G316) = SUM( H304: H316) =' Inputs & Assumptions'!$ B$ 5* E317 =' Inputs & Assumptions'!$ B$ 5* F317 =' Inputs & Assumptions'!$ B$ 5* G317 =' Inputs & Assumptions'!$ B$ 5* H317 =' Inputs & Assumptions'!$ B$ 5* E309 =' Inputs & Assumptions'!$ B$ 5* F309 =' Inputs & Assumptions'!$ B$ 5* G309 =' Inputs & Assumptions'!$ B$ 5* H309 3 4 5 6 = E$ 38*' Unit Costs  Low'!$ B$ 38 = F$ 38*' Unit Costs  Low'!$ B$ 38 = G$ 38*' Unit Costs  Low'!$ B$ 38 = H$ 38*' Unit Costs  Low'!$ B$ 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 February 14, 2003 45 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 I J K L = I$ 39*' Unit Costs  Low'!$ B$ 7 = J$ 39*' Unit Costs  Low'!$ B$ 7 = K$ 39*' Unit Costs  Low'!$ B$ 7 = L$ 39*' Unit Costs  Low'!$ B$ 7 = I$ 19*' Unit Costs  Low'!$ B$ 8 = J$ 19*' Unit Costs  Low'!$ B$ 8 = K$ 19*' Unit Costs  Low'!$ B$ 8 = L$ 19*' Unit Costs  Low'!$ B$ 8 = I$ 19*' Unit Costs  Low'!$ B$ 9 = J$ 19*' Unit Costs  Low'!$ B$ 9 = K$ 19*' Unit Costs  Low'!$ B$ 9 = L$ 19*' Unit Costs  Low'!$ B$ 9 = H281+( I$ 19 I$ 21)*' Unit Costs  Low'!$ C$ 10 = I281+( J$ 19 J$ 21)*' Unit Costs  Low'!$ C$ 10 = J281+( K$ 19 K$ 21)*' Unit Costs  Low'!$ C$ 10 = K281+( L$ 19 L$ 21)*' Unit Costs  Low'!$ C$ 10 = H282+( I$ 19 I$ 21)*' Unit Costs  Low'!$ C$ 11 = I282+( J$ 19 J$ 21)*' Unit Costs  Low'!$ C$ 11 = J282+( K$ 19 K$ 21)*' Unit Costs  Low'!$ C$ 11 = K282+( L$ 19 L$ 21)*' Unit Costs  Low'!$ C$ 11 = H283+( I$ 19 I$ 21)*' Unit Costs  Low'!$ C$ 12 = I283+( J$ 19 J$ 21)*' Unit Costs  Low'!$ C$ 12 = J283+( K$ 19 K$ 21)*' Unit Costs  Low'!$ C$ 12 = K283+( L$ 19 L$ 21)*' Unit Costs  Low'!$ C$ 12 = H284+( I$ 19 I$ 21)*' Unit Costs  Low'!$ C$ 13 = I284+( J$ 19 J$ 21)*' Unit Costs  Low'!$ C$ 13 = J284+( K$ 19 K$ 21)*' Unit Costs  Low'!$ C$ 13 = K284+( L$ 19 L$ 21)*' Unit Costs  Low'!$ C$ 13 = H285+( I$ 19 I$ 21)*' Unit Costs  Low'!$ C$ 14 = I285+( J$ 19 J$ 21)*' Unit Costs  Low'!$ C$ 14 = J285+( K$ 19 K$ 21)*' Unit Costs  Low'!$ C$ 14 = K285+( L$ 19 L$ 21)*' Unit Costs  Low'!$ C$ 14 = H286+( I$ 19 I$ 21)*' Unit Costs  Low'!$ C$ 15 = I286+( J$ 19 J$ 21)*' Unit Costs  Low'!$ C$ 15 = J286+( K$ 19 K$ 21)*' Unit Costs  Low'!$ C$ 15 = K286+( L$ 19 L$ 21)*' Unit Costs  Low'!$ C$ 15 = H287+( I$ 19 I$ 21)*' Unit Costs  Low'!$ C$ 16 = I287+( J$ 19 J$ 21)*' Unit Costs  Low'!$ C$ 16 = J287+( K$ 19 K$ 21)*' Unit Costs  Low'!$ C$ 16 = K287+( L$ 19 L$ 21)*' Unit Costs  Low'!$ C$ 16 = H288+( I$ 19 I$ 21)*' Unit Costs  Low'!$ C$ 17 = I288+( J$ 19 J$ 21)*' Unit Costs  Low'!$ C$ 17 = J288+( K$ 19 K$ 21)*' Unit Costs  Low'!$ C$ 17 = K288+( L$ 19 L$ 21)*' Unit Costs  Low'!$ C$ 17 =( I$ 24 I$ 26)*' Unit Costs  Low'!$ D$ 18 =( J$ 24 J$ 26)*' Unit Costs  Low'!$ D$ 18 =( K$ 24 K$ 26)*' Unit Costs  Low'!$ D$ 18 =( L$ 24 L$ 26)*' Unit Costs  Low'!$ D$ 18 = SUM( I277: I289) = SUM( J277: J289) = SUM( K277: K289) = SUM( L277: L289) =' Inputs & Assumptions'!$ B$ 5* I290 =' Inputs & Assumptions'!$ B$ 5* J290 =' Inputs & Assumptions'!$ B$ 5* K290 =' Inputs & Assumptions'!$ B$ 5* L290 =' Inputs & Assumptions'!$ B$ 5* I282 =' Inputs & Assumptions'!$ B$ 5* J282 =' Inputs & Assumptions'!$ B$ 5* K282 =' Inputs & Assumptions'!$ B$ 5* L282 Year Relative to Promulgation of Rule 7 8 9 10 = I$ 37*' Unit Costs  Low'!$ B$ 22 = J$ 37*' Unit Costs  Low'!$ B$ 22 = K$ 37*' Unit Costs  Low'!$ B$ 22 = L$ 37*' Unit Costs  Low'!$ B$ 22 = I$ 40*' Unit Costs  Low'!$ B$ 23 = J$ 40*' Unit Costs  Low'!$ B$ 23 = K$ 40*' Unit Costs  Low'!$ B$ 23 = L$ 40*' Unit Costs  Low'!$ B$ 23 = I$ 20*' Unit Costs  Low'!$ B$ 24 = J$ 20*' Unit Costs  Low'!$ B$ 24 = K$ 20*' Unit Costs  Low'!$ B$ 24 = L$ 20*' Unit Costs  Low'!$ B$ 24 = I$ 20*' Unit Costs  Low'!$ B$ 25 = J$ 20*' Unit Costs  Low'!$ B$ 25 = K$ 20*' Unit Costs  Low'!$ B$ 25 = L$ 20*' Unit Costs  Low'!$ B$ 25 = H308+( I$ 20 I$ 22)*' Unit Costs  Low'!$ C$ 26 = I308+( J$ 20 J$ 22)*' Unit Costs  Low'!$ C$ 26 = J308+( K$ 20 K$ 22)*' Unit Costs  Low'!$ C$ 26 = K308+( L$ 20 L$ 22)*' Unit Costs  Low'!$ C$ 26 = H309+( I$ 20 I$ 22)*' Unit Costs  Low'!$ C$ 27 = I309+( J$ 20 J$ 22)*' Unit Costs  Low'!$ C$ 27 = J309+( K$ 20 K$ 22)*' Unit Costs  Low'!$ C$ 27 = K309+( L$ 20 L$ 22)*' Unit Costs  Low'!$ C$ 27 = H310+( I$ 20 I$ 22)*' Unit Costs  Low'!$ C$ 28 = I310+( J$ 20 J$ 22)*' Unit Costs  Low'!$ C$ 28 = J310+( K$ 20 K$ 22)*' Unit Costs  Low'!$ C$ 28 = K310+( L$ 20 L$ 22)*' Unit Costs  Low'!$ C$ 28 = H311+( I$ 20 I$ 22)*' Unit Costs  Low'!$ C$ 29 = I311+( J$ 20 J$ 22)*' Unit Costs  Low'!$ C$ 29 = J311+( K$ 20 K$ 22)*' Unit Costs  Low'!$ C$ 29 = K311+( L$ 20 L$ 22)*' Unit Costs  Low'!$ C$ 29 = H312+( I$ 20 I$ 22)*' Unit Costs  Low'!$ C$ 30 = I312+( J$ 20 J$ 22)*' Unit Costs  Low'!$ C$ 30 = J312+( K$ 20 K$ 22)*' Unit Costs  Low'!$ C$ 30 = K312+( L$ 20 L$ 22)*' Unit Costs  Low'!$ C$ 30 = H313+( I$ 20 I$ 22)*' Unit Costs  Low'!$ C$ 31 = I313+( J$ 20 J$ 22)*' Unit Costs  Low'!$ C$ 31 = J313+( K$ 20 K$ 22)*' Unit Costs  Low'!$ C$ 31 = K313+( L$ 20 L$ 22)*' Unit Costs  Low'!$ C$ 31 = H314+( I$ 20 I$ 22)*' Unit Costs  Low'!$ C$ 32 = I314+( J$ 20 J$ 22)*' Unit Costs  Low'!$ C$ 32 = J314+( K$ 20 K$ 22)*' Unit Costs  Low'!$ C$ 32 = K314+( L$ 20 L$ 22)*' Unit Costs  Low'!$ C$ 32 = H315+( I$ 20 I$ 22)*' Unit Costs  Low'!$ C$ 33 = I315+( J$ 20 J$ 22)*' Unit Costs  Low'!$ C$ 33 = J315+( K$ 20 K$ 22)*' Unit Costs  Low'!$ C$ 33 = K315+( L$ 20 L$ 22)*' Unit Costs  Low'!$ C$ 33 =( I$ 25 I$ 27 D$ 23)*' Unit Costs  Low'!$ D$ 34 =( J$ 25 J$ 27 E$ 23)*' Unit Costs  Low'!$ D$ 34 =( K$ 25 K$ 27 F$ 23)*' Unit Costs  Low'!$ D$ 34 =( L$ 25 L$ 27 G$ 23)*' Unit Costs  Low'!$ D$ 34 = SUM( I304: I316) = SUM( J304: J316) = SUM( K304: K316) = SUM( L304: L316) =' Inputs & Assumptions'!$ B$ 5* I317 =' Inputs & Assumptions'!$ B$ 5* J317 =' Inputs & Assumptions'!$ B$ 5* K317 =' Inputs & Assumptions'!$ B$ 5* L317 =' Inputs & Assumptions'!$ B$ 5* I309 =' Inputs & Assumptions'!$ B$ 5* J309 =' Inputs & Assumptions'!$ B$ 5* K309 =' Inputs & Assumptions'!$ B$ 5* L309 Year Relative to Promulgation of Rule 7 8 9 10 = I$ 38*' Unit Costs  Low'!$ B$ 38 = J$ 38*' Unit Costs  Low'!$ B$ 38 = K$ 38*' Unit Costs  Low'!$ B$ 38 = L$ 38*' Unit Costs  Low'!$ B$ 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 February 14, 2003 46 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 M N O P = M$ 39*' Unit Costs  Low'!$ B$ 7 = N$ 39*' Unit Costs  Low'!$ B$ 7 = O$ 39*' Unit Costs  Low'!$ B$ 7 = P$ 39*' Unit Costs  Low'!$ B$ 7 = M$ 19*' Unit Costs  Low'!$ B$ 8 = N$ 19*' Unit Costs  Low'!$ B$ 8 = O$ 19*' Unit Costs  Low'!$ B$ 8 = P$ 19*' Unit Costs  Low'!$ B$ 8 = M$ 19*' Unit Costs  Low'!$ B$ 9 = N$ 19*' Unit Costs  Low'!$ B$ 9 = O$ 19*' Unit Costs  Low'!$ B$ 9 = P$ 19*' Unit Costs  Low'!$ B$ 9 = L281+( M$ 19 M$ 21)*' Unit Costs  Low'!$ C$ 10 = M281+( N$ 19 N$ 21)*' Unit Costs  Low'!$ C$ 10 = N281+( O$ 19 O$ 21)*' Unit Costs  Low'!$ C$ 10 = O281+( P$ 19 P$ 21)*' Unit Costs  Low'!$ C$ 10 = L282+( M$ 19 M$ 21)*' Unit Costs  Low'!$ C$ 11 = M282+( N$ 19 N$ 21)*' Unit Costs  Low'!$ C$ 11 = N282+( O$ 19 O$ 21)*' Unit Costs  Low'!$ C$ 11 = O282+( P$ 19 P$ 21)*' Unit Costs  Low'!$ C$ 11 = L283+( M$ 19 M$ 21)*' Unit Costs  Low'!$ C$ 12 = M283+( N$ 19 N$ 21)*' Unit Costs  Low'!$ C$ 12 = N283+( O$ 19 O$ 21)*' Unit Costs  Low'!$ C$ 12 = O283+( P$ 19 P$ 21)*' Unit Costs  Low'!$ C$ 12 = L284+( M$ 19 M$ 21)*' Unit Costs  Low'!$ C$ 13 = M284+( N$ 19 N$ 21)*' Unit Costs  Low'!$ C$ 13 = N284+( O$ 19 O$ 21)*' Unit Costs  Low'!$ C$ 13 = O284+( P$ 19 P$ 21)*' Unit Costs  Low'!$ C$ 13 = L285+( M$ 19 M$ 21)*' Unit Costs  Low'!$ C$ 14 = M285+( N$ 19 N$ 21)*' Unit Costs  Low'!$ C$ 14 = N285+( O$ 19 O$ 21)*' Unit Costs  Low'!$ C$ 14 = O285+( P$ 19 P$ 21)*' Unit Costs  Low'!$ C$ 14 = L286+( M$ 19 M$ 21)*' Unit Costs  Low'!$ C$ 15 = M286+( N$ 19 N$ 21)*' Unit Costs  Low'!$ C$ 15 = N286+( O$ 19 O$ 21)*' Unit Costs  Low'!$ C$ 15 = O286+( P$ 19 P$ 21)*' Unit Costs  Low'!$ C$ 15 = L287+( M$ 19 M$ 21)*' Unit Costs  Low'!$ C$ 16 = M287+( N$ 19 N$ 21)*' Unit Costs  Low'!$ C$ 16 = N287+( O$ 19 O$ 21)*' Unit Costs  Low'!$ C$ 16 = O287+( P$ 19 P$ 21)*' Unit Costs  Low'!$ C$ 16 = L288+( M$ 19 M$ 21)*' Unit Costs  Low'!$ C$ 17 = M288+( N$ 19 N$ 21)*' Unit Costs  Low'!$ C$ 17 = N288+( O$ 19 O$ 21)*' Unit Costs  Low'!$ C$ 17 = O288+( P$ 19 P$ 21)*' Unit Costs  Low'!$ C$ 17 =( M$ 24 M$ 26)*' Unit Costs  Low'!$ D$ 18 =( N$ 24 N$ 26)*' Unit Costs  Low'!$ D$ 18 =( O$ 24 O$ 26)*' Unit Costs  Low'!$ D$ 18 =( P$ 24 P$ 26)*' Unit Costs  Low'!$ D$ 18 = SUM( M277: M289) = SUM( N277: N289) = SUM( O277: O289) = SUM( P277: P289) =' Inputs & Assumptions'!$ B$ 5* M290 =' Inputs & Assumptions'!$ B$ 5* N290 =' Inputs & Assumptions'!$ B$ 5* O290 =' Inputs & Assumptions'!$ B$ 5* P290 =' Inputs & Assumptions'!$ B$ 5* M282 =' Inputs & Assumptions'!$ B$ 5* N282 =' Inputs & Assumptions'!$ B$ 5* O282 =' Inputs & Assumptions'!$ B$ 5* P282 11 12 13 14 = M$ 37*' Unit Costs  Low'!$ B$ 22 = N$ 37*' Unit Costs  Low'!$ B$ 22 = O$ 37*' Unit Costs  Low'!$ B$ 22 = P$ 37*' Unit Costs  Low'!$ B$ 22 = M$ 40*' Unit Costs  Low'!$ B$ 23 = N$ 40*' Unit Costs  Low'!$ B$ 23 = O$ 40*' Unit Costs  Low'!$ B$ 23 = P$ 40*' Unit Costs  Low'!$ B$ 23 = M$ 20*' Unit Costs  Low'!$ B$ 24 = N$ 20*' Unit Costs  Low'!$ B$ 24 = O$ 20*' Unit Costs  Low'!$ B$ 24 = P$ 20*' Unit Costs  Low'!$ B$ 24 = M$ 20*' Unit Costs  Low'!$ B$ 25 = N$ 20*' Unit Costs  Low'!$ B$ 25 = O$ 20*' Unit Costs  Low'!$ B$ 25 = P$ 20*' Unit Costs  Low'!$ B$ 25 = L308+( M$ 20 M$ 22)*' Unit Costs  Low'!$ C$ 26 = M308+( N$ 20 N$ 22)*' Unit Costs  Low'!$ C$ 26 = N308+( O$ 20 O$ 22)*' Unit Costs  Low'!$ C$ 26 = O308+( P$ 20 P$ 22)*' Unit Costs  Low'!$ C$ 26 = L309+( M$ 20 M$ 22)*' Unit Costs  Low'!$ C$ 27 = M309+( N$ 20 N$ 22)*' Unit Costs  Low'!$ C$ 27 = N309+( O$ 20 O$ 22)*' Unit Costs  Low'!$ C$ 27 = O309+( P$ 20 P$ 22)*' Unit Costs  Low'!$ C$ 27 = L310+( M$ 20 M$ 22)*' Unit Costs  Low'!$ C$ 28 = M310+( N$ 20 N$ 22)*' Unit Costs  Low'!$ C$ 28 = N310+( O$ 20 O$ 22)*' Unit Costs  Low'!$ C$ 28 = O310+( P$ 20 P$ 22)*' Unit Costs  Low'!$ C$ 28 = L311+( M$ 20 M$ 22)*' Unit Costs  Low'!$ C$ 29 = M311+( N$ 20 N$ 22)*' Unit Costs  Low'!$ C$ 29 = N311+( O$ 20 O$ 22)*' Unit Costs  Low'!$ C$ 29 = O311+( P$ 20 P$ 22)*' Unit Costs  Low'!$ C$ 29 = L312+( M$ 20 M$ 22)*' Unit Costs  Low'!$ C$ 30 = M312+( N$ 20 N$ 22)*' Unit Costs  Low'!$ C$ 30 = N312+( O$ 20 O$ 22)*' Unit Costs  Low'!$ C$ 30 = O312+( P$ 20 P$ 22)*' Unit Costs  Low'!$ C$ 30 = L313+( M$ 20 M$ 22)*' Unit Costs  Low'!$ C$ 31 = M313+( N$ 20 N$ 22)*' Unit Costs  Low'!$ C$ 31 = N313+( O$ 20 O$ 22)*' Unit Costs  Low'!$ C$ 31 = O313+( P$ 20 P$ 22)*' Unit Costs  Low'!$ C$ 31 = L314+( M$ 20 M$ 22)*' Unit Costs  Low'!$ C$ 32 = M314+( N$ 20 N$ 22)*' Unit Costs  Low'!$ C$ 32 = N314+( O$ 20 O$ 22)*' Unit Costs  Low'!$ C$ 32 = O314+( P$ 20 P$ 22)*' Unit Costs  Low'!$ C$ 32 = L315+( M$ 20 M$ 22)*' Unit Costs  Low'!$ C$ 33 = M315+( N$ 20 N$ 22)*' Unit Costs  Low'!$ C$ 33 = N315+( O$ 20 O$ 22)*' Unit Costs  Low'!$ C$ 33 = O315+( P$ 20 P$ 22)*' Unit Costs  Low'!$ C$ 33 =( H$ 25 H$ 27 C$ 23)*' Unit Costs  Low'!$ D$ 34 =( I$ 25 I$ 27 D$ 23)*' Unit Costs  Low'!$ D$ 34 =( J$ 25 J$ 27 E$ 23)*' Unit Costs  Low'!$ D$ 34 =( K$ 25 K$ 27 F$ 23)*' Unit Costs  Low'!$ D$ 34 = SUM( M304: M316) = SUM( N304: N316) = SUM( O304: O316) = SUM( P304: P316) =' Inputs & Assumptions'!$ B$ 5* M317 =' Inputs & Assumptions'!$ B$ 5* N317 =' Inputs & Assumptions'!$ B$ 5* O317 =' Inputs & Assumptions'!$ B$ 5* P317 =' Inputs & Assumptions'!$ B$ 5* M309 =' Inputs & Assumptions'!$ B$ 5* N309 =' Inputs & Assumptions'!$ B$ 5* O309 =' Inputs & Assumptions'!$ B$ 5* P309 11 12 13 14 = M$ 38*' Unit Costs  Low'!$ B$ 38 = N$ 38*' Unit Costs  Low'!$ B$ 38 = O$ 38*' Unit Costs  Low'!$ B$ 38 = P$ 38*' Unit Costs  Low'!$ B$ 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 February 14, 2003 47 of 79 AD MP& M7A formula. xls  Pref Option by Type Record for the Final Metal Product and Machinery Rule 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 Q = Q$ 39*' Unit Costs  Low'!$ B$ 7 = Q$ 19*' Unit Costs  Low'!$ B$ 8 = Q$ 19*' Unit Costs  Low'!$ B$ 9 = P281+( Q$ 19 Q$ 21)*' Unit Costs  Low'!$ C$ 10 = P282+( Q$ 19 Q$ 21)*' Unit Costs  Low'!$ C$ 11 = P283+( Q$ 19 Q$ 21)*' Unit Costs  Low'!$ C$ 12 = P284+( Q$ 19 Q$ 21)*' Unit Costs  Low'!$ C$ 13 = P285+( Q$ 19 Q$ 21)*' Unit Costs  Low'!$ C$ 14 = P286+( Q$ 19 Q$ 21)*' Unit Costs  Low'!$ C$ 15 = P287+( Q$ 19 Q$ 21)*' Unit Costs  Low'!$ C$ 16 = P288+( Q$ 19 Q$ 21)*' Unit Costs  Low'!$ C$ 17 =( Q$ 24 Q$ 26)*' Unit Costs  Low'!$ D$ 18 = SUM( Q277: Q289) =' Inputs & Assumptions'!$ B$ 5* Q290 =' Inputs & Assumptions'!$ B$ 5* Q282 15 = Q$ 37*' Unit Costs  Low'!$ B$ 22 = Q$ 40*' Unit Costs  Low'!$ B$ 23 = Q$ 20*' Unit Costs  Low'!$ B$ 24 = Q$ 20*' Unit Costs  Low'!$ B$ 25 = P308+( Q$ 20 Q$ 22)*' Unit Costs  Low'!$ C$ 26 = P309+( Q$ 20 Q$ 22)*' Unit Costs  Low'!$ C$ 27 = P310+( Q$ 20 Q$ 22)*' Unit Costs  Low'!$ C$ 28 = P311+( Q$ 20 Q$ 22)*' Unit Costs  Low'!$ C$ 29 = P312+( Q$ 20 Q$ 22)*' Unit Costs  Low'!$ C$ 30 = P313+( Q$ 20 Q$ 22)*' Unit Costs  Low'!$ C$ 31 = P314+( Q$ 20 Q$ 22)*' Unit Costs  Low'!$ C$ 32 = P315+( Q$ 20 Q$ 22)*' Unit Costs  Low'!$ C$ 33 =( L$ 25 L$ 27 G$ 23)*' Unit Costs  Low'!$ D$ 34 = SUM( Q304: Q316) =' Inputs & Assumptions'!$ B$ 5* Q317 =' Inputs & Assumptions'!$ B$ 5* Q309 15 = Q$ 38*' Unit Costs  Low'!$ B$ 38 0 0 0 0 February 14, 2003 48 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 A B C D sample and analyze effluent 0 0 review & record self monitoring reports 0 0 process & act on non compliance reports 0 0 review compliance schedule report  in compliance with schedule 0 0 review compliance schedule report  not in compliance with schedule 0 0 minor enforcement action ( e. g., admin order) 0 0 minor enforcement action ( e. g., admin fine) 0 0 repermit 0 0 Total hours = SUM( C331: C343) = SUM( D331: D343) Total cost =' Inputs & Assumptions'!$ B$ 5* C344 =' Inputs & Assumptions'!$ B$ 5* D344 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C345: Q345) Maximum one year hours = MAX( C344: Q344) Maximum one year costs = MAX( C345: Q345) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C346) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C336 =' Inputs & Assumptions'!$ B$ 5* D336 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C350: Q350) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C351) Annualized Permitting ( Net of Sampling & Analysis) = C349 C352 Low Permitting Hours by Activity and Year  Total 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( C358: C370) = SUM( D358: D370) Total cost =' Inputs & Assumptions'!$ B$ 5* C371 =' Inputs & Assumptions'!$ B$ 5* D371 NPV of cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C372: Q372) Maximum one year hours = MAX( C371: Q371) Maximum one year costs = MAX( C372: Q372) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C373) Sampling & Analysis Cost =' Inputs & Assumptions'!$ B$ 5* C363 =' Inputs & Assumptions'!$ B$ 5* D363 NPV of Sampling & Analysis Cost = NPV(' Inputs & Assumptions'!$ B$ 4,$ C377: Q377) Annualized over 15 years = PMT(' Inputs & Assumptions'!$ B$ 4,15, C378) Annualized Permitting ( Net of Sampling & Analysis) = C376 C379 February 14, 2003 49 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 E F G H 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 =( C$ 23)*' Unit Costs  Low'!$ D$ 50 = SUM( E331: E343) = SUM( F331: F343) = SUM( G331: G343) = SUM( H331: H343) =' Inputs & Assumptions'!$ B$ 5* E344 =' Inputs & Assumptions'!$ B$ 5* F344 =' Inputs & Assumptions'!$ B$ 5* G344 =' Inputs & Assumptions'!$ B$ 5* H344 =' Inputs & Assumptions'!$ B$ 5* E336 =' Inputs & Assumptions'!$ B$ 5* F336 =' Inputs & Assumptions'!$ B$ 5* G336 =' Inputs & Assumptions'!$ B$ 5* H336 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( E358: E370) = SUM( F358: F370) = SUM( G358: G370) = SUM( H358: H370) =' Inputs & Assumptions'!$ B$ 5* E371 =' Inputs & Assumptions'!$ B$ 5* F371 =' Inputs & Assumptions'!$ B$ 5* G371 =' Inputs & Assumptions'!$ B$ 5* H371 =' Inputs & Assumptions'!$ B$ 5* E363 =' Inputs & Assumptions'!$ B$ 5* F363 =' Inputs & Assumptions'!$ B$ 5* G363 =' Inputs & Assumptions'!$ B$ 5* H363 February 14, 2003 50 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 I J K L 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 =( D$ 23)*' Unit Costs  Low'!$ D$ 50 =( E$ 23)*' Unit Costs  Low'!$ D$ 50 =( F$ 23)*' Unit Costs  Low'!$ D$ 50 =( G$ 23)*' Unit Costs  Low'!$ D$ 50 = SUM( I331: I343) = SUM( J331: J343) = SUM( K331: K343) = SUM( L331: L343) =' Inputs & Assumptions'!$ B$ 5* I344 =' Inputs & Assumptions'!$ B$ 5* J344 =' Inputs & Assumptions'!$ B$ 5* K344 =' Inputs & Assumptions'!$ B$ 5* L344 =' Inputs & Assumptions'!$ B$ 5* I336 =' Inputs & Assumptions'!$ B$ 5* J336 =' Inputs & Assumptions'!$ B$ 5* K336 =' Inputs & Assumptions'!$ B$ 5* L336 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( I358: I370) = SUM( J358: J370) = SUM( K358: K370) = SUM( L358: L370) =' Inputs & Assumptions'!$ B$ 5* I371 =' Inputs & Assumptions'!$ B$ 5* J371 =' Inputs & Assumptions'!$ B$ 5* K371 =' Inputs & Assumptions'!$ B$ 5* L371 =' Inputs & Assumptions'!$ B$ 5* I363 =' Inputs & Assumptions'!$ B$ 5* J363 =' Inputs & Assumptions'!$ B$ 5* K363 =' Inputs & Assumptions'!$ B$ 5* L363 February 14, 2003 51 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 M N O P 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0