Record for the Final Metal Product and Machinery Rule 123456 7 9 13 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 A B C D E F VARIABLE DESCRIPTIONS FOR MPCT_ JULY. XLS PROPOSED/ NODA OPTION TO THE FINAL MP& M RULE VARIABLE DESCRIPTION WORKSHEET COLUMN CBI FORMULA Sector Sector Abbreviation Values A N CPT Coef Cost Pass Through Coefficient Values B N Long Name Sector Name Values C N Total Cost: Baseline Total Costs in the Baseline by Sector, 1996$ Values D Y = SUMIF( Base!$ C$ 7:$ C$ 947,$ A23, Base!$ G$ 7:$ G$ 947)

Change in Costs ( Compliance Costs): Option 2 Total Option 2 Compliance Costs by Sector, 1996$ Values E Y = SUMIF(' O2'!$ C$ 6:$ C$ 945,$ A23,' O2'!$ J$ 6:$ J$ 945)

Post Compliance Price Change Factor: Option 2 Percent of Post Compliance Price Change in Option 2 Values I N =($ B23* F23/$ D23)*$ S23 Moderate Impacts: EBIT / Total Assets ( PTRA) for Manufacturers PTRA Threshold for Manufacturers Values M N Moderate Impacts: EBIT / Total Assets ( PTRA) for Nonmanufacturers PTRA Threshold for Nonmanufacturers Values N N Moderate Impacts: EBITDA / Interest ( ICR) for Manufacturers ICR Thresholdfor Manufacturers Values O N Moderate Impacts: EBITDA / Interest ( ICR) for Nonmanufacturers ICR Threshold for Non manufacturers Values P N Manufacturing Output, 1996 Manufacturing Output by Sector, Census of Manufacturers, 1996 Values Q Y Baseline Revenues Total Revenues in the Baseline by Sector, 1996$ Values R Y = SUMIF( Base!$ C$ 7:$ C$ 946,$ A23, Base!$ Z$ 7:$ Z$ 946)

Percent Regulated Percent of the Industry Regulated by Sector Values S N = IF( R23/ Q23> 1,1, R23/ Q23)

Capacity Utilization: Phase 1 Based on data for years 1987 1989 Values T N Capacity Utilization: Phase 2 Based on data for years 1994 1996 Values U N SID Survey ID Base A N = IF( RawData! B7<>"", RawData! B7,"") Weight Sample Weight Base B Y = IF( ISNA( VLOOKUP($ A7, FacData, 2, FALSE)), 0, VLOOKUP($ A7, FacData, 2, FALSE)) Sector Primary Sector Base C Y = IF( ISNA( VLOOKUP($ A7, FacData, 4, FALSE))," UNK", VLOOKUP($ A7, FacData, 4, FALSE)) Scale Factor: Q6 If question 6 was not answered with site data then a scaling factor was calculated to estimate the percent that comes from the site. If question 6 was answered with site data the scaling factor is 1. Base D Y = IF( RawData! V7'= 1,1, IF( RawData! V7'= 2, IF( NOT( ISERR( RawData! R7/ RawData! O7)), RawData! R7/ Raw Data! O7, IF( NOT( ISERR( RawData! S7/ RawData! P7)), RawData! S7/ RawData! P7, IF( NOT( ISERR( RawDat a! T7/ RawData! Q7)), RawData! T7/ RawData! Q7,))), 1))

Scale Factor: Q7 If question 7 was not answered with site data then a scaling factor was calculated to estimate the percent that comes from the site. If question 7 was answered with site data the scaling factor is 1. Base E Y = IF( RawData! W7'= 1,1, IF( RawData! W7'= 2, IF( NOT( ISERR( RawData! R7/ RawData! O7)), RawData! R7/ Ra wData! O7, IF( NOT( ISERR( RawData! S7/ RawData! P7)), RawData! S7/ RawData! P7, IF( NOT( ISERR( RawD ata! T7/ RawData! Q7)), RawData! T7/ RawData! Q7,))), 1))

Avg Revenue Average of Three Years of Revenues from the survey, 1996$ Base F Y = RawData! C7*$ D7 Average Costs and Expenses: Total Cost Average of Three Years of Total Costs from the survey, 1996$ Base G Y = RawData! D7*$ D7 BB7 Average Costs and Expenses: Interest Average of Three Years of Interest from the survey, 1996$ Base H Y = RawData! E7*$ D7 Average Costs and Expenses: Taxes Average of Three Years of Taxes from the survey, 1996$ Base I Y = RawData! F7*$ D7 February 14, 2003 Page 1 of 89 MPCT_ July. xls  Var Desc Record for the Final Metal Product and Machinery Rule 123 A B C D E F VARIABLE DESCRIPTIONS FOR MPCT_ JULY. XLS PROPOSED/ NODA OPTION TO THE FINAL MP& M RULE VARIABLE DESCRIPTION WORKSHEET COLUMN CBI FORMULA 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 Average Costs and Expenses: Depr Average of Three Years of Depreciation from the survey, 1996$ Base J Y = RawData! K7*$ D7 Adjusted Tax This adjusted tax rate includes the tax on interest Base K Y = MAX( 0, I7+( H7* TAX_ RATE))

EBIT Earnings Before Interest and Taxes Base L Y =+$ F7$ G7+$ H7+$ I7 Capital Expenditures Estimated Capital Expenditures Base M Y = IF( A7>"", AR7* 1000000* CAPEX_ ON,"") Test of Net Present Value ( NPV): Unlevered ATCF The unlevered after tax cash flow includes the tax on interest Base N Y = F7 G7+ J7 M7+ H7+ I7 K7 Test of Net Present Value ( NPV): LV Liquidation Value Base O Y 0 Test of Net Present Value ( NPV): Tax_ Ben Tax Benefit from Liquidation Base P Y 0 Test of Net Present Value ( NPV): NPV Net Present Value Base Q Y = IF( ISNA( O7), N7/ AMORT_ D, N7/ AMORT_ D( O7 P7))

Test of Severe Impacts: ATCF Is After Tax Cash Flow positive? Yes= 1; No= 0 Base R N 0 Test of Severe Impacts: NPV Is Net Present Value positive? Yes= 1; No= 1 Base S N = IF($ A7>"", IF( Q7>'= 0,1,0),"")

Test of Severe Impacts: Either Does the site pass either the ATCF or NPV test? 1= Yes; 0= Baseline Closure Base T N = IF( AND($ A7>"", Base! F7'= 0), 1, IF($ A7>"", MAX( S7, R7),""))

Test of Moderate Impacts: PTRA Pre Tax Return on Assets Base U Y = IF( ISERR( L7/ AC7)," n/ a", L7/ AC7)

Test of Moderate Impacts: ICR Interest Coverage Ratio Base V Y = IF( ISERR(( L7+ J7)/ H7), 999,( L7+ J7)/ H7)

Test of Moderate Impacts: Pass? Is the PTRA> 8% and ICR> 4.0? 1= Yes; 0= Moderate Impact Base W N = IF($ A7'="","", IF( AND( Y7'=" R", U7>'= VLOOKUP($ C7, ModerateThresholds, 14,0), V7>'= VLOOKUP($ C7, ModerateThresholds, 16,0)), 1, IF( AND( U7>'= VLOOKUP($ C7, ModerateThresholds, 13,0), V7>'= VLOOKU P($ C7, ModerateThresholds, 15,0)), 1,0))) Opp. of W Opposite of Column W Base X N = IF( W7'= 1,0,1) Revenue Source M= Revenues come from manufacturing only; R= Revenues come from rebuilding and maintenance only; B= Revenues come from both manufacturing and rebuilding and maintenance; U= Unknown Base Y N = IF( A7>"", VLOOKUP( A7, FacData!$ A$ 6:$ J$ 698,9,0),"")

Baseline Revenues ( excl Rbldg & Main) Regulated Manufacturing Baseline Revenues, 1996$ Base Z Y = IF( A7>"", IF( Y7'=" R", 0, B7* F7),"")

Phase Phase 1 or Phase 2 Base AA N = VLOOKUP( A7, FacData!$ A$ 6:$ H$ 698,8,0) Inputs to Capital Expenditures Estimation: Operating Income Operating Income Base AB Y = IF( A7>"", F7 G7,"")

Inputs to Capital Expenditures Estimation: Assets Assets Base AC Y = IF( A7>"", RawData! J7* Base! E7,"")

Inputs to Capital Expenditures Estimation: ROA Return on Assets Base AD Y = IF( A7>"", IF( AC7'= 0,0, MAX( AB7/ AC7, 0.313)),"")

Inputs to Capital Expenditures Estimation: CAPT Capital Turnover Rate Base AE Y = IF( A7>"", IF( AC7'= 0,0, J7/ AC7),"")

Inputs to Capital Expenditures Estimation: CAPI Capital Intensity Base AF Y = IF( A7>"", IF( F7'= 0,0, AC7/ F7),"")

February 14, 2003 Page 2 of 89 MPCT_ July. xls  Var Desc Record for the Final Metal Product and Machinery Rule 123 A B C D E F VARIABLE DESCRIPTIONS FOR MPCT_ JULY. XLS PROPOSED/ NODA OPTION TO THE FINAL MP& M RULE VARIABLE DESCRIPTION WORKSHEET COLUMN CBI FORMULA 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 Inputs to Capital Expenditures Estimation: DEBTCST Debt to Cost Ratio Base AG Y = IF($ AA7'=" Phase 1", DEBTCST_ P1, IF($ AA7'=" Phase 2", DEBTCST_ P2,""))

Inputs to Capital Expenditures Estimation: CAPPRC Price of Capital Equipment Base AH Y = IF($ AA7'=" Phase 1", CAP_ PRC_ P1, IF($ AA7'=" Phase 2", CAP_ PRC_ P2,""))

Inputs to Capital Expenditures Estimation: CAPUTIL Capacity Utilization Base AI Y = IF( AND( AA7'=" Phase 2", A7>""), VLOOKUP($ C7, Values!$ A$ 23:$ U$ 41,21, FALSE), IF( AND( AA7'=" Phase 1", A7>""), VLOOKUP($ C7, Values!$ A$ 23:$ U$ 41,20, FALSE),"")) Estimation of Capital Expenditures: CAPEX Capital Expenditures Base AJ Y = IF( A7>"", EXP( AJ$ 4),"")

Estimation of Capital Expenditures: ROA Return on Assets Base AK Y = IF( A7>"",( AD7+ 0.3134659)^ AK$ 4,"")

Estimation of Capital Expenditures: REVENUE Revenue Base AL Y = IF( A7>"",( F7/ 1000000)^ AL$ 4,"")

Estimation of Capital Expenditures: CAPT Capital Turnover Rate Base AM Y = IF( A7>"", AE7^ AM$ 4,"")

Estimation of Capital Expenditures: CAPI Capital Intensity Base AN Y = IF( A7>"", AF7^ AN$ 4,"")

Estimation of Capital Expenditures: DEBTCST Debt to Cost Ratio Base AO Y = IF( A7>"", AG7^ AO$ 4,"")

Estimation of Capital Expenditures: CAPPRC Price of Capital Equipment Base AP Y = IF( A7>"", AH7^ AP$ 4,"")

Estimation of Capital Expenditures: CAPUTIL Capacity Utilization Base AQ Y = IF( A7>"", AI7^ AQ$ 4,"")

Estimation of Capital Expenditures: CAPEX ( mil) Capital expenditures ( millions) Base AR Y = IF( A7>"", PRODUCT( AJ7: AQ7),"")

FTE Full Time Equivalents Base AS Y = IF( A7>"", VLOOKUP( A7, FacData!$ A$ 5:$ J$ 714,10,0),"") Total Labor Cost Base AT Y = IF( A7>"", RawData! X7*$ D7,"") LABOR/ FTE Base AU Y = IF( A7>"", AT7/ AS7,"") Emp Flag Base AV Y = IF($ AS7<= 4,1, IF($ AS7<= 9,2, IF($ AS7<= 19,3, IF($ AS7<= 49,4, IF($ AS7<= 99,5, IF($ AS7<= 249,6, IF($ AS 7<= 499,7, IF($ AS7<= 999,8,9)))))))) Sector Flag Base AW Y = IF( C7=" JS", 1, IF( C7=" PC", 2, IF( C7=" BT", 3,0))) Sector Emp Flag Base AX Y = CONCATENATE( AW7, AV7) Average Payroll ( Census) Base AY Y = IF( ISNA( VLOOKUP( AX7, Census!$ B$ 6:$ E$ 54,3, FALSE)),"", VLOOKUP( AX7, Census!$ B$ 6:$ E$ 54,3, F ALSE)) Adjusted Average Payroll Base AZ Y = IF( AY7="","", IF( AU7> 1.25* AY7,1.25* AY7, AU7)) Revised Total Labor Cost Base BA Y = IF( AZ7="","", AZ7* AS7) Adjustment to Labor Cost Base BB Y = IF( ISERR( BA7), 0, IF( BA7="", 0, AT7 BA7)) SID Survey ID O2 A N = RawData! B7 Weight Sample Weight O2 B Y = Base! B7 Sector Primary Sector O2 C Y = Base! C7 Unweighted Compliance Cost: Capital Capital Compliance Costs, 1996$ O2 D Y = VLOOKUP($ A7, Costs!$ A$ 7:$ M$ 1500, D$ 1,0)

Unweighted Compliance Cost: Recurring Annual Compliance Costs, 1996$ O2 E Y = VLOOKUP($ A7, Costs!$ A$ 7:$ M$ 1500, E$ 1,0)

Unweighted Compliance Cost: Other O2 F N Unweighted Compliance Cost: Pvt_ Cost( AT) After tax Compliance Costs, 1996$ O2 G Y = IF( J7= 0,0, J7( K7* TAX_ RATE)+ L7)

Unweighted Compliance Cost: Soc_ Cost ( BT) Before tax Compliance Costs, 1996$ O2 H Y = IF( OR( ISNA( F7), ISERR( F7)), 0, E7+ D7* AMORT_ O)

Revenue Change Change in Revenue based on Cost Pass Through Coefficient O2 I Y = IF($ A7>"", VLOOKUP( C7, Dprice, I$ 1, FALSE)* Base! F7,0)

Changes in Average Costs and Expenses: Ann_ Cost Annualized Compliance Costs O2 J Y = IF( OR( ISNA( F7), ISERR( F7)), 0, E7+ D7* AMORT_ D)

February 14, 2003 Page 3 of 89 MPCT_ July. xls  Var Desc Record for the Final Metal Product and Machinery Rule 123 A B C D E F VARIABLE DESCRIPTIONS FOR MPCT_ JULY. XLS PROPOSED/ NODA OPTION TO THE FINAL MP& M RULE VARIABLE DESCRIPTION WORKSHEET COLUMN CBI FORMULA 89 90 91 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 Changes in Average Costs and Expenses: Interest Change in Interest from Baseline O2 K Y = D7* 0.0485 Changes in Average Costs and Expenses: Taxes Change in Taxes from Baseline O2 L Y =( MIN( Base! K7,(( I7 E7 M7)* TAX_ RATE)* 1))* 1 Changes in Average Costs and Expenses: Depr Change in Depreciation from Baseline O2 M Y = D7/ DEP_ YRS Test of Net Present Value ( NPV): After Tax Cash Flow ( ATCF) After Tax Cash Flow plus Interest O2 O Y = Base! N7+( I7 E7) L7 Test of Net Present Value ( NPV): NPV Net Present Value O2 P Y = IF( ISNA( Base! O7), O7/ AMORT_ D D7, O7/ AMORT_ D D7( Base! O7 Base! P7))

Test of Severe Impacts ( unwgtd): ATCF Is After Tax Cash Flow positive? Yes= 1; No= 0 O2 Q N 0 Test of Severe Impacts ( unwgtd): NPV Is Net Present Value positive? Yes= 1; No= 1 O2 R N = IF($ A7>"", IF( P7>'= 0,1,0),"")

Test of Severe Impacts ( unwgtd): Either Does the site pass either the ATCF or NPV test? 1= Yes; 0= Baseline Closure O2 S N = IF( AND($ A7>"", Base! F7'= 0), 1, IF($ A7>"", MAX( R7, Q7),""))

Test of Severe Impacts ( unwgtd): Incr? Is there an incremental failure from the baseline? 0= No; 1= Post compliance Closure O2 T N = IF( Base! T7="", 0, IF($ A7>"", IF( S7= 0, IF( Base! T7= 1,1,0), IF( AND( S7= 1, Base! T7= 0), 1,0)),""))

Test of Severe Impacts ( wgtd): Incr? Weighted Post Compliance Closures O2 U Y = T7*$ B7 Test of Moderate Impacts: EBIT Earnings Before Interest and Taxes O2 V Y =( Base! L7+ I7) E7 M7 Test of Moderate Impacts: EBIT/ Total Assets Profit Before Taxes as a % of Sales O2 W Y = IF( ISERR( V7/ Base! AC7), 9.99, V7/ Base! AC7)

Test of Moderate Impacts: EBITDA / Interest Expense Interest Coverage Ratio O2 X Y = IF( ISERR(( V7+( M7+ Base! J7))/( K7+ Base! H7)), 999,( V7+( M7+ Base! J7))/( K7+ Base! H7))

Test of Moderate Impacts: Incr? Is there an incremental failure from the baseline? 0= No; 1= Post compliance Moderate Impact O2 Y N = IF($ A7="","", IF( AND($ A7>"", Base! F7= 0), 0, IF( Base! W7= 0,0, IF( AND( Base! Y7=" R", W7>= VLOOKUP($ C7, ModerateThresholds, 14,0), X7>= VLOOKUP($ C7, ModerateThresholds, 16,0)), 0, IF( AND( W7>= VLOO KUP($ C7, ModerateThresholds, 13,0), X7>= VLOOKUP($ C7, ModerateThresholds, 15,0)), 0,1)))))

Post Compliance Revenue Post Compliance Revenue O2 Z Y = Base!$ F7+$ I7 ACC as % of PCR Annual Compliance Cost as a percent of Post Compliance Revenue O2 AA Y = G7/ Z7 SID Site ID RawData B N REV_ AVG Average Revenue RawData C Y COST_ TOT Total Costs RawData D Y COST_ INT Interest RawData E Y COST_ TAX Taxes RawData F Y LV_ NET Net LV RawData G Y INT Interest Rate, Site RawData H Y DEBT Total Debt RawData I Y ASSETS Total Assets RawData J Y DEPR Depreciation Expense RawData K Y FIRM_ REV Firm Revenue RawData L Y CURR_ LIA Current Liabilities RawData M Y NON_ LIA Non Current Liabilities RawData N Y UNIT_ REV Unit Revenues RawData O Y UNIT_ COST Unit Costs RawData P Y UNIT_ EMP Unit Employment RawData Q Y SITE_ REV Site Revenues RawData R Y SITE_ COST Site Costs RawData S Y SITE_ EMP Site Employment RawData T Y February 14, 2003 Page 4 of 89 MPCT_ July. xls  Var Desc Record for the Final Metal Product and Machinery Rule 123 A B C D E F VARIABLE DESCRIPTIONS FOR MPCT_ JULY. XLS PROPOSED/ NODA OPTION TO THE FINAL MP& M RULE VARIABLE DESCRIPTION WORKSHEET COLUMN CBI FORMULA 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 UNITDATA Unit Data Provided RawData U Y REVREP6 Unit/ Site Data for Question 6 RawData V Y REVREP7 Unit/ Site Data for Question 7 RawData W Y LABOR Total Labor Cost RawData X Y SID Survey ID FacData A N Weight Sample Weight FacData B Y = VLOOKUP($ A7,[ facdata_ July. xls] FacData!$ A$ 6:$ H$ 2377, B$ 5,0) Small Owned by a Small Entity? FacData C Y = VLOOKUP($ A7,[ facdata_ July. xls] FacData!$ A$ 6:$ H$ 2377, C$ 5,0) Sector Primary Sector FacData D Y = VLOOKUP($ A7,[ facdata_ July. xls] FacData!$ A$ 6:$ H$ 2377, D$ 5,0) Subcat Subcategory FacData E Y = VLOOKUP($ A7,[ facdata_ July. xls] FacData!$ A$ 6:$ H$ 2377, E$ 5,0) FlowRange Flow Category Range FacData F Y = VLOOKUP($ A7,[ facdata_ July. xls] FacData!$ A$ 6:$ H$ 2377, F$ 5,0) Direct? Discharge type: D= Direct; I= Indirect FacData G N = VLOOKUP($ A7,[ facdata_ July. xls] FacData!$ A$ 6:$ K$ 2377, G$ 5,0)

Phase Phase 1 or Phase 2 Data Collection Effort FacData H N = IF( VLOOKUP($ A7,[ facdata_ July. xls] FacData!$ A$ 6:$ H$ 2377, H$ 5,0)=" Phase 1"," Phase 1"," Phase 2")

Revenue Source M= Revenues come from manufacturing only; R= Revenues come from rebuilding and maintenance only; B= Revenues come from both manufacturing and rebuilding and maintenance; U= Unknown; MU= Municipality; IS= Iron and Steel; ERG = represents two facilities that were FacData I N = VLOOKUP( A7,[ RevbySct_ July. xls] Summary!$ A$ 3:$ BV$ 898,64,0)

FTE Full Time Equivalents FacData J Y = VLOOKUP( A7,[ facdata_ July. xls] SBA!$ A$ 7:$ E$ 850,5,0) ID Survey ID Costs A N ='[ CompCost_ July. xls] 1996'!$ A8 CapCst1 Option 1 Capital Costs, 1996 Costs B Y = IF('[ CompCost_ July. xls] 1996'! E8<>"",'[ CompCost_ July. xls] 1996'! E8,0) AnnCst1 Option 1 Annual Costs, 1996 Costs C Y = IF('[ CompCost_ July. xls] 1996'! F8<>"",'[ CompCost_ July. xls] 1996'! F8,0) CC1_ 96 Option 1 Costs Annualized at 7% over 15 years, 1996 Costs D Y = IF('[ CompCost_ July. xls] 1996'! G8<>"",'[ CompCost_ July. xls] 1996'! G8,0)

CapCst2 Option 2 Capital Costs, 1996 Costs E Y = IF('[ CompCost_ July. xls] 1996'! H8<>"",'[ CompCost_ July. xls] 1996'! H8,0) AnnCst2 Option 2 Annual Costs, 1996 Costs F Y = IF('[ CompCost_ July. xls] 1996'! I8<>"",'[ CompCost_ July. xls] 1996'! I8,0) CC2_ 96 Option 2 Costs Annualized at 7% over 15 years, 1996 Costs G Y = IF('[ CompCost_ July. xls] 1996'! J8<>"",'[ CompCost_ July. xls] 1996'! J8,0)

CapCst3 Option 3 Capital Costs, 1996 Costs H Y = IF('[ CompCost_ July. xls] 1996'! K8<>"",'[ CompCost_ July. xls] 1996'! K8,0) AnnCst3 Option 3 Annual Costs, 1996 Costs I Y = IF('[ CompCost_ July. xls] 1996'! L8<>"",'[ CompCost_ July. xls] 1996'! L8,0) CC3_ 96 Option 3 Costs Annualized at 7% over 15 years, 1996 Costs J Y = IF('[ CompCost_ July. xls] 1996'! M8<>"",'[ CompCost_ July. xls] 1996'! M8,0)

CapCst4 Option 4 Capital Costs, 1996 Costs K Y = IF('[ CompCost_ July. xls] 1996'! N8<>"",'[ CompCost_ July. xls] 1996'! N8,0) AnnCst4 Option 4 Annual Costs, 1996 Costs L Y = IF('[ CompCost_ July. xls] 1996'! O8<>"",'[ CompCost_ July. xls] 1996'! O8,0) CC4_ 96 Option 4 Costs Annualized at 7% over 15 years, 1996 Costs M Y = IF('[ CompCost_ July. xls] 1996'! P8<>"",'[ CompCost_ July. xls] 1996'! P8,0)

Split Flag for those facilities which are both indirect and direct dischargers Costs N N Sector Emp Flag Sector Employment Flag Census B N Establishment Size Establishment Size Census C N Average Payroll Average Payroll Census D N Average Capital Expenditures Average Capital Expenditures Census E N February 14, 2003 Page 5 of 89 MPCT_ July. xls  Var Desc Record for the Final Metal Product and Machinery Rule 123456789 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 A B C D E I M N O P Q Constants and Other Numeric Values blue numbers are exogenous CPI94 147.2 Consumer Price Index, 1994 CPI95 151.5 Consumer Price Index, 1995 CPI96 155.8 Consumer Price Index, 1996 CPI97 159.9 Consumer Price Index, 1997 RATE_ D 0.07 discount rate for amortization RATE_ O 0.03 OMB discount rate for social opportunity cost PERIOD 15 Number of years amortized AMORT_ D 0.109794625 Amortization factor, 15 years AMORT_ O 0.08376658 Amortization factor, 15 years, OMB rate INFL 0.05 CPI U Inflation rate, 1996 TAX_ RATE 0.34 Marginal corporate tax rate DEP_ YRS 15 Number of years depreciated DEBTCST_ P1 9.8 Bloomberg Ticker ( C7A0 Index), average of 1987 1989 DEBTCST_ P2 7.11 Bloomberg Ticker ( IN10YA1 Index), average of 1994 1996 CAP_ PRC_ P1 115.87 PPI for Capital Equipment, average of 1987 1989 CAP_ PRC_ P2 135.4 PPI for Capital Equipment, average of 1994 1996 9 13 14 15 16 17 Total Cost Change in Costs ( Compliance Costs) Post Compliance Price Change Factor Moderate Impacts Percent of Industry Regulated Profit Before Taxes as a % of Sales EBIT/ Interest Sector CPT Coef Long Name Baseline Option 1 Option 1 Man. Non Man Man. Non Man Manufacturing Output, 1996 HW 77.2% Hardware 0.08% 4.4% 4.4% 1.3 1.3 AI 100.0% Aircraft 0.03% 7.9% 5.7% 1.6 1.2 EE 39.5% Electronic Equipment 0.04% 4.4% 4.4% 1.2 1.2 SI 79.1% Stationary Industrial Equipment 0.05% 3.7% 11.3% 1.2 1.4 OR 59.1% Ordnance 0.12% 4.1% 5.1% 1.2 1.3 AS 98.3% Aerospace 0.04% 4.1% 5.1% 1.2 1.3 MI 79.1% Mobile Industrial Equipment 0.16% 3.7% 3.7% 1.3 1.3 IN 77.1% Instrument 0.08% 4.7% 4.7% 1.5 1.4 PM 64.0% Precious and Non Precious Metals 0.03% 3.5% 3.5% 1.7 1.7 SB 82.3% Ships and Boats 0.03% 3.8% 6.6% 1.3 1.2 HE 63.6% Household Equipment 0.02% 4.7% 4.5% 1.9 1.9 RR 88.1% Railroad 0.02% 3.3% 3.3% ( 0.7) ( 0.7) MV 82.0% Motor Vehicle 0.07% 3.9% 2.1% 1.2 1.5 BT 86.4% Bus and Truck 0.06% 3.6% 3.5% 1.7 1.2 OF 0.0% Office Machine 0.00% 2.8% 3.5% 0.2 0.6 PC 0.0% Printed Circuit Board 0.00% 2.4% 2.4% 0.9 0.9 JS 57.5% Job Shop 0.61% 4.0% 4.0% 1.1 1.1 OM 63.1% Other Metal Products 0.04% 4.4% 4.0% 1.2 1.1 UNK 0.0% Unknown Sector 0.00% 4.1% 5.1% 1.2 1.3 February 14, 2003 Page 6 of 89 MPCT_ July. xls  Values Record for the Final Metal Product and Machinery Rule 123456789 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 R S T U 18 19 20 21 Percent of Industry Regulated Capacity Utilization Baseline Revenues Percent Regulated Phase 1 Phase 2 33.5% 81.93 86.45 100.0% 80.01 73.67 100.0% 80.84 86.37 32.2% 78.61 85.1 100.0% 79.77 81.87 100.0% 80.01 73.67 100.0% 79.45 79.01 100.0% 80.28 77.21 42.8% 80.28 77.21 100.0% 80.01 73.67 100.0% 80.78 84.24 11.4% 80.01 73.69 44.1% 79.78 81.24 100.0% 80.01 73.69 34.5% 78.61 85.02 53.6% 80.84 86.44 43.7% 79.77 81.92 100.0% 79.99 80.01 0.0% 80.05 80.03 February 14, 2003 Page 7 of 89 MPCT_ July. xls  Values Record for the Final Metal Product and Machinery Rule 1234 5 6 789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 A B C D E F G H I J K L M N O P Q R S T U Baseline Financial Data Proposed/ NODA Option Uses Sector Specific Producer Price Indices to Inflate Data to 1996 Dollars Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 1 0 1 1 2 0 1 1 3 0 1 1 5 0 1 1 6 0 1 1 7 0 1 1 8 0 1 1 9 0 1 1 10 0 1 1 11 0 1 1 12 0 1 1 13 0 1 1 14 0 1 1 15 0 0 0 16 0 1 1 20 0 0 0 21 0 1 1 22 0 1 1 24 0 1 1 25 0 1 1 26 0 1 1 27 0 1 1 28 0 0 0 29 0 0 0 31 0 1 1 32 0 1 1 33 0 1 1 35 0 0 0 36 0 1 1 37 0 1 1 38 0 1 1 41 0 1 1 42 0 0 0 43 0 1 1 44 0 1 1 45 0 1 1 46 0 0 0 47 0 1 1 48 0 1 1 50 0 1 1 51 0 0 0 52 0 1 1 53 0 1 1 55 0 1 1 57 0 1 1 58 0 0 0 59 0 1 1 60 0 1 1 61 0 1 1 62 0 1 1 64 0 1 1 65 0 1 1 February 14, 2003 Page 8 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 1234 5 6 789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO  2.0774 0.6182 1.0248 0.5995 0.9765  0.2050 Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 0 1 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 U Phase 2 0 1 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 2 1 0 R Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 0 1 M Phase 2 1 0 U Phase 1 1 0 B Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 1 0 U Phase 1 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 2 0 1 B Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 R Phase 1 0 1 U Phase 1 1 0 B Phase 2 0 1 M Phase 2 0 1 M Phase 2 1 0 U Phase 2 February 14, 2003 Page 9 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 1234 5 6 789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 AP AQ AR AS AT AU AV AW AX AY AZ BA BB  0.4779 0.9043 of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost February 14, 2003 Page 10 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 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 112 113 114 67 0 1 1 68 0 1 1 69 0 1 1 70 0 1 1 71 0 1 1 72 0 1 1 73 0 1 1 74 0 1 1 75 0 1 1 76 0 0 0 77 0 1 1 78 0 1 1 79 0 1 1 81 0 1 1 83 0 0 0 84 0 1 1 85 0 1 1 86 0 1 1 87 0 1 1 88 0 0 0 89 0 1 1 90 0 1 1 91 0 1 1 92 0 0 0 94 0 1 1 95 0 1 1 96 0 1 1 97 0 1 1 99 0 1 1 100 0 0 0 101 0 1 1 102 0 1 1 103 0 1 1 105 0 1 1 106 0 1 1 108 0 1 1 109 0 1 1 110 0 1 1 111 0 1 1 112 0 1 1 113 0 0 0 114 0 1 1 115 0 1 1 116 0 1 1 118 0 1 1 119 0 1 1 120 0 1 1 121 0 1 1 122 0 1 1 125 0 1 1 126 0 1 1 127 0 1 1 128 0 1 1 129 0 1 1 130 0 1 1 131 0 1 1 February 14, 2003 Page 11 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 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 112 113 114 0 1 B Phase 2 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 R Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 B Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 B Phase 1 1 0 M Phase 1 1 0 M Phase 2 0 1 U Phase 1 1 0 R Phase 2 1 0 M Phase 2 1 0 M Phase 2 0 1 R Phase 2 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 2 1 0 B Phase 1 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 2 1 0 R Phase 2 1 0 U Phase 1 1 0 B Phase 2 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 U Phase 1 0 1 M Phase 1 1 0 M Phase 1 0 1 U Phase 2 1 0 M Phase 2 1 0 B Phase 1 0 1 M Phase 2 1 0 R Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 February 14, 2003 Page 12 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 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 112 113 114 February 14, 2003 Page 13 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 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 166 167 168 169 170 132 0 1 1 135 0 1 1 136 0 1 1 137 0 1 1 138 0 0 0 140 0 1 1 141 0 1 1 142 0 0 0 143 0 1 1 146 0 1 1 147 0 1 1 148 0 1 1 149 0 1 1 150 0 1 1 151 0 1 1 153 0 1 1 154 0 1 1 155 0 0 0 156 0 1 1 157 0 0 0 159 0 1 1 161 0 1 1 162 0 1 1 163 0 1 1 164 0 1 1 165 0 1 1 166 0 1 1 170 0 0 0 172 0 1 1 173 0 1 1 174 0 1 1 176 0 1 1 177 0 1 1 178 0 1 1 179 0 1 1 181 0 1 1 182 0 1 1 183 0 1 1 184 0 1 1 185 0 1 1 186 0 1 1 187 0 1 1 188 0 1 1 189 0 1 1 190 0 1 1 191 0 1 1 192 0 1 1 193 0 1 1 195 0 1 1 196 0 1 1 197 0 1 1 199 0 1 1 200 0 1 1 201 0 1 1 202 0 1 1 203 0 1 1 February 14, 2003 Page 14 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 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 166 167 168 169 170 0 1 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 0 1 B Phase 1 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 2 1 0 R Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 2 1 0 U Phase 1 0 1 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 U Phase 2 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 2 1 0 U Phase 1 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 2 February 14, 2003 Page 15 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 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 166 167 168 169 170 February 14, 2003 Page 16 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 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 224 225 226 204 0 1 1 207 0 1 1 208 0 1 1 209 0 1 1 210 0 1 1 211 0 1 1 212 0 0 0 214 0 1 1 215 0 1 1 216 0 1 1 219 0 1 1 221 0 1 1 222 0 0 0 223 0 1 1 224 0 1 1 225 0 1 1 226 0 1 1 227 0 1 1 228 0 1 1 229 0 0 0 230 0 1 1 231 0 1 1 232 0 1 1 233 0 1 1 234 0 1 1 235 0 1 1 237 0 1 1 239 0 1 1 240 0 1 1 241 0 1 1 242 0 1 1 243 0 1 1 245 0 1 1 246 0 1 1 247 0 1 1 248 0 1 1 249 0 1 1 250 0 1 1 252 0 1 1 253 0 1 1 254 0 1 1 255 0 1 1 257 0 0 0 259 0 1 1 260 0 1 1 261 0 1 1 262 0 1 1 263 0 1 1 264 0 1 1 265 0 1 1 266 0 1 1 267 0 1 1 268 0 1 1 269 0 1 1 270 0 0 0 271 0 1 1 February 14, 2003 Page 17 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 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 224 225 226 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 B Phase 1 0 1 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 B Phase 2 1 0 M Phase 1 0 1 U Phase 1 1 0 M Phase 2 0 1 B Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 2 0 1 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 B Phase 1 1 0 B Phase 1 1 0 B Phase 1 1 0 M Phase 2 1 0 M Phase 1 0 1 R Phase 2 1 0 M Phase 1 0 1 M Phase 2 0 1 R Phase 2 1 0 M Phase 2 0 1 B Phase 1 1 0 M Phase 1 0 1 B Phase 1 1 0 B Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 U Phase 1 0 1 M Phase 2 0 1 M Phase 2 1 0 M Phase 2 February 14, 2003 Page 18 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 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 224 225 226 February 14, 2003 Page 19 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 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 278 279 280 281 282 273 0 1 1 274 0 1 1 276 0 1 1 279 0 0 0 280 0 0 0 281 0 1 1 282 0 1 1 283 0 1 1 284 0 1 1 285 0 1 1 286 0 1 1 288 0 1 1 289 0 1 1 290 0 1 1 291 0 1 1 293 0 1 1 295 0 1 1 296 0 1 1 298 0 0 0 299 0 1 1 300 0 0 0 301 0 0 0 302 0 0 0 303 0 1 1 304 0 0 0 305 0 0 0 306 0 0 0 307 0 1 1 308 0 1 1 309 0 1 1 310 0 1 1 312 0 0 0 313 0 1 1 314 0 1 1 315 0 1 1 316 0 1 1 319 0 0 0 320 0 0 0 322 0 1 1 323 0 1 1 324 0 1 1 325 0 1 1 326 0 1 1 327 0 1 1 328 0 1 1 329 0 0 0 330 0 0 0 331 0 1 1 332 0 1 1 333 0 1 1 334 0 1 1 335 0 1 1 336 0 1 1 337 0 1 1 338 0 0 0 339 0 1 1 February 14, 2003 Page 20 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 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 278 279 280 281 282 1 0 M Phase 1 1 0 B Phase 1 1 0 M Phase 1 0 1 M Phase 1 0 1 U Phase 1 1 0 B Phase 1 1 0 M Phase 1 1 0 U Phase 1 0 1 B Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 1 0 R Phase 2 1 0 M Phase 1 0 1 M Phase 2 0 1 M Phase 1 0 1 R Phase 2 1 0 M Phase 2 0 1 M Phase 2 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 0 1 U Phase 1 0 1 M Phase 1 0 1 U Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 1 0 B Phase 1 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 0 1 U Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 B Phase 2 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 B Phase 2 0 1 M Phase 2 1 0 M Phase 1 1 0 U Phase 2 1 0 B Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 U Phase 2 0 1 M Phase 1 1 0 M Phase 2 February 14, 2003 Page 21 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 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 278 279 280 281 282 February 14, 2003 Page 22 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 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 336 337 338 340 0 1 1 342 0 1 1 345 0 1 1 349 0 1 1 350 0 1 1 351 0 0 0 355 0 1 1 357 0 1 1 358 0 0 0 359 0 1 1 361 0 1 1 363 0 1 1 364 0 1 1 365 0 1 1 366 0 0 0 369 0 1 1 370 0 1 1 371 0 1 1 372 0 1 1 374 0 1 1 375 0 0 0 376 0 1 1 377 0 1 1 378 0 1 1 380 0 1 1 381 0 1 1 383 0 1 1 384 0 1 1 386 0 1 1 387 0 1 1 388 0 1 1 390 0 1 1 392 0 1 1 393 0 1 1 395 0 1 1 396 0 1 1 398 0 1 1 399 0 0 0 400 0 1 1 401 0 1 1 402 0 1 1 403 0 1 1 404 0 1 1 406 0 1 1 407 0 1 1 408 0 0 0 409 0 0 0 410 0 0 0 411 0 1 1 412 0 1 1 413 0 1 1 414 0 1 1 416 0 1 1 417 0 1 1 418 0 1 1 419 0 0 0 February 14, 2003 Page 23 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 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 336 337 338 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 0 1 M Phase 2 0 1 M Phase 1 0 1 U Phase 1 1 0 M Phase 1 1 0 B Phase 1 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 U Phase 1 1 0 M Phase 1 1 0 R Phase 2 1 0 M Phase 2 1 0 M Phase 2 0 1 U Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 B Phase 1 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 B Phase 1 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 U Phase 1 1 0 M Phase 2 0 1 M Phase 2 0 1 M Phase 1 0 1 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 2 1 0 U Phase 1 0 1 M Phase 1 1 0 M Phase 1 1 0 R Phase 2 0 1 M Phase 1 0 1 M Phase 2 February 14, 2003 Page 24 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 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 336 337 338 February 14, 2003 Page 25 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 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 381 382 383 384 385 386 387 388 389 390 391 392 393 394 420 0 1 1 421 0 1 1 422 0 1 1 423 0 1 1 424 0 1 1 425 0 1 1 426 0 1 1 428 0 1 1 429 0 1 1 430 0 1 1 433 0 1 1 434 0 1 1 435 0 1 1 438 0 1 1 439 0 1 1 440 0 1 1 441 0 1 1 442 0 1 1 443 0 1 1 445 0 1 1 446 0 1 1 447 0 0 0 448 0 0 0 449 0 1 1 450 0 1 1 451 0 1 1 452 0 0 0 453 0 1 1 455 0 1 1 456 0 1 1 457 0 1 1 458 0 1 1 459 0 1 1 460 0 1 1 461 0 0 0 462 0 1 1 463 0 1 1 464 0 0 0 466 0 1 1 468 0 1 1 470 0 1 1 471 0 1 1 472 0 1 1 473 0 1 1 474 0 0 0 475 0 1 1 476 0 1 1 477 0 1 1 479 0 0 0 480 0 1 1 481 0 0 0 482 0 1 1 484 0 1 1 486 0 1 1 487 0 1 1 488 0 1 1 February 14, 2003 Page 26 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 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 381 382 383 384 385 386 387 388 389 390 391 392 393 394 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 B Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 U Phase 2 1 0 M Phase 2 1 0 R Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 B Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 B Phase 2 0 1 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 2 1 0 M Phase 2 1 0 B Phase 1 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 B Phase 1 0 1 M Phase 1 0 1 M Phase 1 0 1 R Phase 2 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 B Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 U Phase 1 1 0 M Phase 1 0 1 R Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 R Phase 1 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 February 14, 2003 Page 27 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 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 381 382 383 384 385 386 387 388 389 390 391 392 393 394 February 14, 2003 Page 28 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 489 0 1 1 490 0 1 1 492 0 1 1 493 0 1 1 494 0 1 1 495 0 1 1 496 0 1 1 497 0 1 1 498 0 1 1 501 0 1 1 502 0 1 1 503 0 1 1 504 0 1 1 505 0 1 1 506 0 1 1 507 0 1 1 509 0 1 1 510 0 1 1 511 0 1 1 513 0 1 1 514 0 1 1 515 0 1 1 516 0 1 1 517 0 1 1 518 0 1 1 519 0 1 1 520 0 1 1 522 0 1 1 523 0 1 1 524 0 1 1 525 0 1 1 526 0 1 1 527 0 1 1 528 0 1 1 530 0 0 0 531 0 0 0 532 0 1 1 533 0 1 1 534 0 1 1 536 0 1 1 537 0 1 1 538 0 1 1 539 0 1 1 540 0 1 1 542 0 1 1 543 0 0 0 545 0 1 1 547 0 1 1 548 0 1 1 549 0 1 1 550 0 1 1 551 0 1 1 552 0 1 1 555 0 0 0 556 0 1 1 560 0 1 1 February 14, 2003 Page 29 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 0 1 M Phase 1 1 0 M Phase 1 0 1 B Phase 1 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 R Phase 2 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 R Phase 2 0 1 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 B Phase 1 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 0 1 M Phase 1 0 1 B Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 U Phase 1 0 1 M Phase 1 0 1 B Phase 1 1 0 B Phase 1 1 0 U Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 R Phase 2 1 0 U Phase 2 February 14, 2003 Page 30 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 February 14, 2003 Page 31 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 561 0 1 1 563 0 1 1 564 0 1 1 566 0 1 1 567 0 1 1 570 0 1 1 574 0 1 1 575 0 1 1 577 0 1 1 578 0 1 1 579 0 0 0 580 0 1 1 583 0 1 1 584 0 1 1 585 0 0 0 586 0 1 1 587 0 1 1 590 0 1 1 591 0 1 1 592 0 1 1 594 0 1 1 595 0 1 1 597 0 1 1 598 0 1 1 599 0 1 1 600 0 1 1 603 0 1 1 605 0 0 0 606 0 1 1 607 0 1 1 608 0 1 1 609 0 1 1 610 0 1 1 611 0 1 1 612 0 1 1 613 0 1 1 614 0 0 0 615 0 1 1 616 0 1 1 617 0 1 1 619 0 1 1 621 0 1 1 622 0 0 0 623 0 1 1 624 0 1 1 625 0 1 1 626 0 1 1 627 0 1 1 628 0 1 1 629 0 1 1 630 0 1 1 631 0 0 0 632 0 1 1 633 0 0 0 634 0 1 1 635 0 1 1 February 14, 2003 Page 32 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 0 1 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 B Phase 1 1 0 M Phase 2 0 1 M Phase 2 1 0 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 0 1 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 0 1 B Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 B Phase 1 0 1 M Phase 1 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 February 14, 2003 Page 33 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 February 14, 2003 Page 34 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 636 0 1 1 637 0 1 1 639 0 1 1 640 0 1 1 641 0 1 1 642 0 1 1 643 0 1 1 645 0 1 1 648 0 1 1 649 0 1 1 650 0 1 1 651 0 1 1 653 0 1 1 655 0 0 0 656 0 1 1 658 0 1 1 660 0 1 1 661 0 1 1 662 0 1 1 663 0 1 1 664 0 1 1 665 0 1 1 666 0 1 1 667 0 1 1 668 0 1 1 669 0 0 0 670 0 1 1 671 0 1 1 673 0 1 1 674 0 1 1 675 0 1 1 678 0 1 1 679 0 1 1 680 0 1 1 681 0 1 1 682 0 1 1 683 0 1 1 684 0 1 1 685 0 1 1 687 0 1 1 688 0 1 1 690 0 0 0 693 0 1 1 694 0 1 1 695 0 1 1 696 0 1 1 699 0 0 0 700 0 1 1 701 0 1 1 702 0 1 1 703 0 1 1 704 0 1 1 705 0 0 0 706 0 1 1 707 0 1 1 708 0 1 1 February 14, 2003 Page 35 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 1 0 M Phase 2 1 0 U Phase 2 1 0 M Phase 2 0 1 U Phase 2 0 1 M Phase 2 0 1 U Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 B Phase 1 1 0 B Phase 2 1 0 U Phase 2 1 0 M Phase 1 1 0 U Phase 1 1 0 M Phase 1 1 0 B Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 2 0 1 U Phase 1 1 0 B Phase 2 0 1 U Phase 1 1 0 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 B Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 2 1 0 M Phase 2 1 0 B Phase 2 1 0 B Phase 1 0 1 M Phase 1 1 0 U Phase 1 1 0 M Phase 1 0 1 M Phase 1 February 14, 2003 Page 36 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 February 14, 2003 Page 37 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 709 0 1 1 710 0 1 1 711 0 0 0 712 0 1 1 713 0 1 1 714 0 1 1 715 0 1 1 716 0 1 1 717 0 1 1 718 0 0 0 719 0 1 1 720 0 1 1 721 0 1 1 722 0 1 1 723 0 1 1 724 0 1 1 725 0 0 0 726 0 1 1 727 0 1 1 728 0 1 1 729 0 1 1 730 0 1 1 732 0 0 0 733 0 1 1 734 0 1 1 735 0 1 1 737 0 1 1 738 0 1 1 739 0 1 1 740 0 1 1 741 0 1 1 745 0 0 0 746 0 1 1 747 0 0 0 748 0 1 1 749 0 0 0 751 0 1 1 752 0 1 1 753 0 1 1 755 0 1 1 756 0 1 1 757 0 1 1 758 0 1 1 759 0 0 0 760 0 1 1 762 0 1 1 763 0 1 1 764 0 1 1 765 0 1 1 766 0 1 1 767 0 1 1 768 0 0 0 771 0 1 1 772 0 0 0 773 0 1 1 774 0 1 1 February 14, 2003 Page 38 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 0 1 B Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 1 0 R Phase 2 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 B Phase 2 1 0 M Phase 2 0 1 M Phase 2 1 0 M Phase 2 1 0 M Phase 2 1 0 U Phase 1 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 B Phase 1 1 0 U Phase 1 1 0 U Phase 1 1 0 R Phase 2 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 0 1 R Phase 2 1 0 U Phase 1 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 2 1 0 R Phase 2 0 1 M Phase 1 February 14, 2003 Page 39 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 February 14, 2003 Page 40 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 775 0 1 1 777 0 1 1 778 0 1 1 779 0 1 1 780 0 1 1 781 0 1 1 782 0 1 1 784 0 1 1 785 0 0 0 786 0 1 1 787 0 0 0 788 0 1 1 789 0 1 1 790 0 1 1 791 0 1 1 792 0 1 1 793 0 1 1 795 0 0 0 796 0 1 1 797 0 1 1 799 0 1 1 800 0 1 1 802 0 1 1 804 0 1 1 805 0 1 1 806 0 1 1 807 0 1 1 808 0 0 0 809 0 1 1 811 0 1 1 813 0 0 0 814 0 1 1 815 0 1 1 816 0 1 1 817 0 1 1 818 0 1 1 819 0 1 1 820 0 0 0 821 0 1 1 822 0 1 1 823 0 1 1 824 0 1 1 825 0 1 1 829 0 1 1 830 0 1 1 831 0 1 1 834 0 1 1 836 0 1 1 837 0 0 0 839 0 1 1 841 0 1 1 842 0 1 1 843 0 1 1 844 0 1 1 846 0 1 1 848 0 1 1 February 14, 2003 Page 41 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 U Phase 1 1 0 M Phase 2 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 0 1 M Phase 2 0 1 M Phase 1 0 1 M Phase 1 0 1 U Phase 2 1 0 M Phase 2 1 0 M Phase 2 0 1 M Phase 2 1 0 U Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 0 1 M Phase 2 1 0 R Phase 2 0 1 M Phase 2 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 B Phase 2 0 1 M Phase 2 0 1 M Phase 2 0 1 M Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 2 0 1 M Phase 1 1 0 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 0 1 M Phase 2 0 1 B Phase 2 1 0 M Phase 2 1 0 R Phase 2 0 1 R Phase 2 1 0 M Phase 2 0 1 M Phase 2 February 14, 2003 Page 42 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 February 14, 2003 Page 43 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M N O P Q R S T U Scale Factor Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Test of Moderate Impacts SID Weight Sector Q6 Q7 Avg Revenue Total Cost Interest Taxes Depr Adjusted Tax EBIT Capital Expenditures Unlevered ATCF LV Tax_ Ben NPV ATCF NPV Either EBIT/ Revenues 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 849 0 1 1 850 0 1 1 851 0 1 1 853 0 1 1 854 0 1 1 855 0 1 1 856 0 1 1 857 0 0 0 858 0 0 0 859 0 1 1 860 0 0 0 861 0 1 1 862 0 1 1 863 0 1 1 864 0 1 1 866 0 1 1 867 0 1 1 869 0 1 1 870 0 1 1 871 0 1 1 873 0 1 1 874 0 1 1 875 0 1 1 879 0 1 1 880 0 1 1 884 0 1 1 885 0 1 1 886 0 1 1 887 0 1 1 888 0 1 1 891 0 1 1 894 0 1 1 905 0 1 1 918 0 1 1 921 0 1 1 922 0 1 1 926 0 1 1 927 0 1 1 929 0 1 1 930 0 1 1 934 0 1 1 February 14, 2003 Page 44 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO Test of Moderate Impacts Inputs to Capital Expenditures Estimation Estimation of Capital Expenditures ICR Pass? Opp. of W Revenue Source Baseline Revenues ( excl Rbldg & Main) Phase Operating Income Assets ROA CAPT CAPI DEBTCST CAPPRC CAPUTIL CAPEX ROA REVENUE CAPT CAPI DEBTCST 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 0 1 M Phase 2 1 0 M Phase 1 0 1 M Phase 1 1 0 B Phase 1 1 0 M Phase 1 1 0 M Phase 1 0 1 M Phase 1 1 0 M Phase 1 0 1 B Phase 1 0 1 M Phase 1 0 1 B Phase 1 0 1 U Phase 1 1 0 M Phase 2 1 0 B Phase 2 1 0 M Phase 1 1 0 M Phase 2 1 0 B Phase 1 1 0 U Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 M Phase 1 1 0 B Phase 1 1 0 B Phase 1 1 0 B Phase 2 1 0 U Phase 1 1 0 M Phase 2 1 0 M Phase 1 1 0 M Phase 1 1 0 B Phase 2 1 0 R Phase 2 1 0 B Phase 2 1 0 M Phase 2 0 1 R Phase 2 0 1 R Phase 2 1 0 R Phase 2 1 0 M Phase 2 1 0 R Phase 2 0 1 M Phase 2 1 0 R Phase 2 1 0 M Phase 2 0 1 M Phase 2 February 14, 2003 Page 45 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 5 6 7 AP AQ AR AS AT AU AV AW AX AY AZ BA BB of Capital Expenditures Adjustment of Labor Costs for Job Shops & Printed Circuit Boards CAPPRC CAPUTIL CAPEX ( mil) FTE Total Labor Cost LABOR/ FTE Emp Flag Sector Flag Sector Emp Flag Average Payroll ( Census) Adjusted Average Payroll Revised Total Labor Cost Adjustment to Labor Cost 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 February 14, 2003 Page 46 of 89 MPCT_ July. xls  Base Record for the Final Metal Product and Machinery Rule 1234 5 6 789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 A B C D E F G H I J K L M O P Q R Option = 1 2 3 9 Facility Impacts: Basic Option Proposed/ NODA Option Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 1 0 1 2 0 1 3 0 1 5 0 1 6 0 1 7 0 1 8 0 1 9 0 1 10 0 1 11 0 1 12 0 1 13 0 1 14 0 1 15 0 0 16 0 1 20 0 0 21 0 1 22 0 1 24 0 1 25 0 1 26 0 1 27 0 1 28 0 0 29 0 0 31 0 1 32 0 1 33 0 1 35 0 0 36 0 1 37 0 1 38 0 1 41 0 1 42 0 0 43 0 1 44 0 1 45 0 1 46 0 0 47 0 1 48 0 1 50 0 1 51 0 0 52 0 1 53 0 1 55 0 1 57 0 1 58 0 0 59 0 1 60 0 1 61 0 1 62 0 1 64 0 1 65 0 1 February 14, 2003 Page 47 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 1234 5 6 789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 February 14, 2003 Page 48 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 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 112 113 114 67 0 0 68 0 1 69 0 1 70 0 1 71 0 1 72 0 1 73 0 1 74 0 0 75 0 1 76 0 0 77 0 1 78 0 1 79 0 1 81 0 1 83 0 0 84 0 1 85 0 1 86 0 1 87 0 1 88 0 0 89 0 0 90 0 1 91 0 1 92 0 0 94 0 1 95 0 1 96 0 1 97 0 1 99 0 1 100 0 0 101 0 1 102 0 1 103 0 1 105 0 1 106 0 1 108 0 1 109 0 1 110 0 1 111 0 0 112 0 1 113 0 0 114 0 1 115 0 1 116 0 1 118 0 1 119 0 1 120 0 1 121 0 1 122 0 1 125 0 1 126 0 0 127 0 1 128 0 1 129 0 1 130 0 1 131 0 1 February 14, 2003 Page 49 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 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 112 113 114 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 1 1 0 0 0 0 0 1 0 0 1 0 0 1 0 1 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 1 1 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 February 14, 2003 Page 50 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 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 166 167 168 169 170 132 0 1 135 0 1 136 0 1 137 0 0 138 0 0 140 0 0 141 0 1 142 0 0 143 0 1 146 0 1 147 0 1 148 0 1 149 0 1 150 0 1 151 0 1 153 0 1 154 0 1 155 0 0 156 0 1 157 0 0 159 0 1 161 0 0 162 0 1 163 0 1 164 0 1 165 0 1 166 0 1 170 0 0 172 0 1 173 0 1 174 0 1 176 0 1 177 0 1 178 0 1 179 0 1 181 0 1 182 0 1 183 0 1 184 0 1 185 0 1 186 0 1 187 0 1 188 0 1 189 0 0 190 0 1 191 0 1 192 0 1 193 0 1 195 0 1 196 0 0 197 0 1 199 0 1 200 0 1 201 0 1 202 0 1 203 0 1 February 14, 2003 Page 51 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 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 166 167 168 169 170 1 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 1 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 1 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 February 14, 2003 Page 52 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 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 224 225 226 204 0 1 207 0 1 208 0 1 209 0 1 210 0 1 211 0 0 212 0 0 214 0 1 215 0 1 216 0 1 219 0 1 221 0 1 222 0 0 223 0 1 224 0 1 225 0 1 226 0 1 227 0 1 228 0 1 229 0 0 230 0 1 231 0 1 232 0 1 233 0 1 234 0 1 235 0 1 237 0 0 239 0 1 240 0 1 241 0 1 242 0 0 243 0 1 245 0 1 246 0 1 247 0 1 248 0 1 249 0 1 250 0 1 252 0 1 253 0 0 254 0 1 255 0 0 257 0 0 259 0 1 260 0 1 261 0 1 262 0 1 263 0 1 264 0 1 265 0 1 266 0 1 267 0 1 268 0 1 269 0 1 270 0 0 271 0 1 February 14, 2003 Page 53 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 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 224 225 226 1 0 0 1 0 1 1 0 0 1 0 0 1 0 0 0 1 0 0 0 0 1 0 0 1 0 1 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 1 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 1 1 0 0 0 1 0 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 0 1 0 0 0 0 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 February 14, 2003 Page 54 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 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 278 279 280 281 282 273 0 1 274 0 1 276 0 1 279 0 0 280 0 0 281 0 1 282 0 1 283 0 1 284 0 0 285 0 1 286 0 1 288 0 1 289 0 1 290 0 1 291 0 1 293 0 1 295 0 1 296 0 1 298 0 0 299 0 1 300 0 0 301 0 0 302 0 0 303 0 1 304 0 0 305 0 0 306 0 0 307 0 1 308 0 1 309 0 1 310 0 1 312 0 0 313 0 1 314 0 1 315 0 1 316 0 1 319 0 0 320 0 0 322 0 1 323 0 1 324 0 1 325 0 1 326 0 1 327 0 1 328 0 1 329 0 0 330 0 0 331 0 1 332 0 1 333 0 1 334 0 1 335 0 1 336 0 1 337 0 1 338 0 0 339 0 1 February 14, 2003 Page 55 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 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 278 279 280 281 282 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 February 14, 2003 Page 56 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 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 336 337 338 340 0 1 342 0 1 345 0 1 349 0 1 350 0 1 351 0 0 355 0 1 357 0 1 358 0 0 359 0 1 361 0 1 363 0 1 364 0 1 365 0 1 366 0 0 369 0 1 370 0 1 371 0 1 372 0 1 374 0 1 375 0 0 376 0 1 377 0 1 378 0 1 380 0 1 381 0 1 383 0 1 384 0 1 386 0 1 387 0 1 388 0 1 390 0 1 392 0 1 393 0 1 395 0 0 396 0 1 398 0 1 399 0 0 400 0 1 401 0 1 402 0 1 403 0 1 404 0 1 406 0 1 407 0 1 408 0 0 409 0 0 410 0 0 411 0 1 412 0 1 413 0 1 414 0 1 416 0 1 417 0 0 418 0 1 419 0 0 February 14, 2003 Page 57 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 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 336 337 338 1 0 0 1 0 0 1 0 0 1 0 1 1 0 0 0 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 1 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 1 1 0 0 0 0 0 February 14, 2003 Page 58 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 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 381 382 383 384 385 386 387 388 389 390 391 392 393 394 420 0 1 421 0 1 422 0 1 423 0 1 424 0 1 425 0 1 426 0 1 428 0 1 429 0 1 430 0 1 433 0 1 434 0 1 435 0 1 438 0 1 439 0 1 440 0 1 441 0 1 442 0 1 443 0 1 445 0 1 446 0 1 447 0 0 448 0 0 449 0 1 450 0 1 451 0 1 452 0 0 453 0 1 455 0 1 456 0 1 457 0 1 458 0 1 459 0 1 460 0 0 461 0 0 462 0 1 463 0 0 464 0 0 466 0 1 468 0 1 470 0 1 471 0 1 472 0 1 473 0 1 474 0 0 475 0 1 476 0 1 477 0 0 479 0 0 480 0 1 481 0 0 482 0 1 484 0 1 486 0 1 487 0 1 488 0 1 February 14, 2003 Page 59 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 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 381 382 383 384 385 386 387 388 389 390 391 392 393 394 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 1 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 0 0 0 1 0 0 0 1 1 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 0 1 1 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 February 14, 2003 Page 60 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 489 0 1 490 0 1 492 0 1 493 0 1 494 0 1 495 0 0 496 0 1 497 0 1 498 0 1 501 0 0 502 0 1 503 0 0 504 0 1 505 0 1 506 0 1 507 0 1 509 0 1 510 0 1 511 0 1 513 0 1 514 0 1 515 0 1 516 0 1 517 0 0 518 0 1 519 0 1 520 0 1 522 0 1 523 0 1 524 0 1 525 0 1 526 0 1 527 0 1 528 0 1 530 0 0 531 0 0 532 0 1 533 0 1 534 0 1 536 0 1 537 0 1 538 0 1 539 0 1 540 0 1 542 0 1 543 0 0 545 0 1 547 0 1 548 0 1 549 0 1 550 0 1 551 0 1 552 0 0 555 0 0 556 0 1 560 0 1 February 14, 2003 Page 61 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 1 1 0 0 0 1 0 1 0 0 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 1 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 1 0 0 0 1 0 0 1 0 0 February 14, 2003 Page 62 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 561 0 1 563 0 0 564 0 1 566 0 1 567 0 1 570 0 1 574 0 1 575 0 1 577 0 1 578 0 1 579 0 0 580 0 1 583 0 1 584 0 1 585 0 0 586 0 1 587 0 1 590 0 1 591 0 1 592 0 1 594 0 1 595 0 1 597 0 1 598 0 1 599 0 1 600 0 0 603 0 1 605 0 0 606 0 0 607 0 1 608 0 1 609 0 1 610 0 0 611 0 1 612 0 1 613 0 1 614 0 0 615 0 1 616 0 1 617 0 1 619 0 1 621 0 1 622 0 0 623 0 1 624 0 1 625 0 1 626 0 1 627 0 1 628 0 1 629 0 1 630 0 1 631 0 0 632 0 1 633 0 0 634 0 1 635 0 1 February 14, 2003 Page 63 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 1 0 0 0 1 0 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 0 0 0 0 1 0 1 0 0 1 0 0 1 0 0 0 1 1 1 0 0 1 0 1 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 February 14, 2003 Page 64 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 636 0 1 637 0 1 639 0 1 640 0 0 641 0 0 642 0 1 643 0 1 645 0 1 648 0 1 649 0 0 650 0 1 651 0 1 653 0 1 655 0 0 656 0 1 658 0 1 660 0 1 661 0 1 662 0 1 663 0 1 664 0 1 665 0 1 666 0 1 667 0 1 668 0 1 669 0 0 670 0 0 671 0 1 673 0 1 674 0 1 675 0 1 678 0 1 679 0 1 680 0 1 681 0 1 682 0 0 683 0 1 684 0 1 685 0 0 687 0 1 688 0 1 690 0 0 693 0 1 694 0 1 695 0 1 696 0 1 699 0 0 700 0 1 701 0 0 702 0 1 703 0 1 704 0 1 705 0 0 706 0 1 707 0 1 708 0 1 February 14, 2003 Page 65 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 1 0 0 1 0 0 1 0 0 0 1 0 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 1 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 1 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 1 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 February 14, 2003 Page 66 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 709 0 1 710 0 1 711 0 0 712 0 1 713 0 1 714 0 1 715 0 1 716 0 1 717 0 1 718 0 0 719 0 1 720 0 1 721 0 1 722 0 1 723 0 1 724 0 1 725 0 0 726 0 1 727 0 1 728 0 1 729 0 1 730 0 1 732 0 0 733 0 1 734 0 1 735 0 1 737 0 1 738 0 1 739 0 1 740 0 1 741 0 1 745 0 0 746 0 1 747 0 0 748 0 1 749 0 0 751 0 1 752 0 1 753 0 1 755 0 0 756 0 1 757 0 1 758 0 1 759 0 0 760 0 1 762 0 1 763 0 1 764 0 1 765 0 1 766 0 1 767 0 1 768 0 0 771 0 1 772 0 0 773 0 1 774 0 1 February 14, 2003 Page 67 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 1 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 February 14, 2003 Page 68 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 775 0 1 777 0 1 778 0 0 779 0 1 780 0 1 781 0 1 782 0 1 784 0 1 785 0 0 786 0 1 787 0 0 788 0 0 789 0 1 790 0 1 791 0 0 792 0 1 793 0 1 795 0 0 796 0 1 797 0 1 799 0 1 800 0 1 802 0 1 804 0 1 805 0 0 806 0 1 807 0 1 808 0 0 809 0 1 811 0 1 813 0 0 814 0 1 815 0 1 816 0 1 817 0 1 818 0 1 819 0 1 820 0 0 821 0 1 822 0 1 823 0 1 824 0 1 825 0 1 829 0 1 830 0 1 831 0 0 834 0 1 836 0 1 837 0 0 839 0 1 841 0 1 842 0 1 843 0 1 844 0 1 846 0 1 848 0 0 February 14, 2003 Page 69 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 1 0 0 1 0 0 0 1 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 1 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 1 0 February 14, 2003 Page 70 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 A B C D E F G H I J K L M O P Q R Unweighted Compliance Cost Option 1 Changes in Average Costs and Expenses Test of Net Present Value ( NPV) Pass Tests? Unweighted SID Weight Sector Capital Recurring Other Pvt_ Cost( AT) Soc_ Cost ( BT) Revenue Change Ann_ Cost Interest Taxes Depr After Tax Cash Flow ( ATCF) NPV ATCF NPV 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 849 0 0 850 0 1 851 0 1 853 0 1 854 0 1 855 0 1 856 0 1 857 0 0 858 0 0 859 0 1 860 0 0 861 0 1 862 0 1 863 0 1 864 0 1 866 0 1 867 0 1 869 0 1 870 0 1 871 0 1 873 0 1 874 0 1 875 0 1 879 0 1 880 0 1 884 0 1 885 0 1 886 0 1 887 0 1 888 0 1 891 0 1 894 0 1 905 0 1 918 0 1 921 0 1 922 0 1 926 0 1 927 0 1 929 0 1 930 0 1 934 0 1 February 14, 2003 Page 71 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 5 6 7 S T U V W X Y Z AA Pass Tests? Unweighted Test of Moderate Impacts Either Incr? Wgtd Incr? EBIT EBIT/ Revenues ICR Incr? Post Compliance Revenue ACC as % of PCR 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 0 1 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 0 February 14, 2003 Page 72 of 89 MPCT_ July. xls  O2 Record for the Final Metal Product and Machinery Rule 1 234 5 6 789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 A B C D E F G H I J K L M N SURVEY DATA Phase 2 data imported from " Final Data" worksheet in " Import_ Final. xls": Copy and paste special values into blue and green shaded regions. Phase 1 data imported from " Phase 1 MPCT" worksheet in " Import_ P1. xls": Copy and paste special values into orange shaded region. Uses Sector Specific Producer Price Indices to Inflate Data to 1996 Dollars Description Site ID Average Revenue Total Costs Interest Taxes Net LV Interest Rate, Site Total Debt Total Assets Depreciation Expense Firm Revenue Current Liabilities Non Current Liabilities Access Variable Name SID REV_ AVG COST_ TOT COST_ INT COST_ TAX LV_ NET INT DEBT ASSETS DEPR FIRM_ REV CURR_ LIA NON_ LIA 1 2 5 6 8 9 21 22 26 27 29 36 37 41 44 45 47 50 51 53 61 62 64 67 71 74 75 79 81 87 89 90 91 92 95 97 99 103 106 108 110 111 113 116 121 122 126 127 128 131 137 Note: All data except site identification not shown to protect confidential business information. Sample page provided to show structure of worksheet. February 14, 2003 Page 73 of 89 MPCT_ July. xls  RawData Record for the Final Metal Product and Machinery Rule 1 234 5 6 789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 O P Q R S T U V W X Unit Revenues Unit Costs Unit Employment Site Revenues Site Costs Site Employment Unit Data Provided Unit/ Site Data for Question 6 Unit/ Site Data for Question 7 Total Labor Cost UNIT_ REV UNIT_ COST UNIT_ EMP SITE_ REV SITE_ COST SITE_ EMP UNITDATA REVREP6 REVREP7 LABOR Note: All data except site identification not shown to protect confidential business information. Sample page provided to show structure of worksheet. February 14, 2003 Page 74 of 89 MPCT_ July. xls  RawData Record for the Final Metal Product and Machinery Rule 1 2345 6789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B C D E F G H I J Facility Characteristics From FacData_ Final. xls 6 4 3 8 5 2 7 10 SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 1 I Phase 2 M 2 I Phase 2 M 3 I Phase 1 M 5 I Phase 2 U 6 I Phase 2 M 7 I Phase 1 M 8 D Phase 2 M 9 I Phase 2 M 10 I Phase 1 R 11 D Phase 1 M 12 I Phase 1 M 13 I Phase 1 M 14 I Phase 1 M 15 I Phase 1 M 16 I Phase 1 M 20 I Phase 1 M 21 I Phase 2 M 22 I Phase 2 M 24 I Phase 1 U 25 I Phase 1 B 26 I Phase 2 M 27 I Phase 2 M 28 I Phase 1 M 29 I Phase 2 M 31 I Phase 1 U 32 I Phase 1 M 33 I Phase 2 M 35 I Phase 1 M 36 I Phase 2 M 37 I Phase 2 M 38 I Phase 1 M 41 I Phase 2 M 42 I Phase 1 M 43 I Phase 1 M 44 I Phase 2 M 45 I Phase 2 M 46 I Phase 1 M 47 I Phase 2 M 48 I Phase 1 M 50 D Phase 2 M 51 I Phase 2 M 52 I Phase 1 M 53 I Phase 2 M 55 I Phase 1 B 57 I Phase 1 M 58 I Phase 1 M 59 I Phase 1 R 60 I Phase 1 U 61 I Phase 2 B 62 D Phase 2 M 64 I Phase 2 M 65 D Phase 2 U 67 I Phase 2 B February 14, 2003 Page 75 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 68 I Phase 1 M 69 I Phase 1 M 70 I Phase 1 M 71 I Phase 2 M 72 I Phase 1 M 73 I Phase 1 M 74 I Phase 2 R 75 I Phase 2 M 76 D Phase 1 M 77 I Phase 1 M 78 I Phase 1 B 79 I Phase 2 M 81 I Phase 2 M 83 I Phase 1 M 84 D Phase 1 M 85 I Phase 1 B 86 I Phase 1 M 87 I Phase 2 M 88 I Phase 1 U 89 I Phase 2 R 90 I Phase 2 M 91 I Phase 2 M 92 I Phase 2 R 94 I Phase 1 M 95 I Phase 2 M 96 D Phase 1 M 97 I Phase 2 M 99 I Phase 2 M 100 D Phase 1 M 101 I Phase 2 M 102 I Phase 1 B 103 I Phase 2 M 105 I Phase 1 M 106 I Phase 2 M 108 I Phase 2 R 109 I Phase 1 U 110 I Phase 2 B 111 I Phase 2 M 112 I Phase 1 M 113 I Phase 2 M 114 I Phase 1 M 115 I Phase 1 M 116 I Phase 2 M 118 D Phase 1 U 119 I Phase 1 M 120 I Phase 1 M 121 I Phase 2 U 122 I Phase 2 M 125 I Phase 1 B 126 I Phase 2 M 127 I Phase 2 R 128 D Phase 2 M 129 I Phase 1 M 130 I Phase 1 M 131 I Phase 2 M 132 I Phase 1 M 135 I Phase 1 M 136 I Phase 1 M February 14, 2003 Page 76 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 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 166 167 168 169 170 171 172 173 174 175 137 I Phase 2 M 138 I Phase 1 M 140 I Phase 2 M 141 D Phase 1 B 142 D Phase 1 M 143 D Phase 1 M 146 I Phase 2 M 147 I Phase 1 M 148 I Phase 1 M 149 I Phase 1 M 150 I Phase 2 M 151 I Phase 2 M 153 I Phase 2 R 154 I Phase 1 M 155 I Phase 1 M 156 I Phase 2 M 157 I Phase 2 M 159 I Phase 1 U 161 I Phase 2 M 162 I Phase 1 M 163 I Phase 1 M 164 D Phase 1 M 165 I Phase 1 M 166 I Phase 1 M 170 I Phase 1 M 172 D Phase 1 M 173 I Phase 2 M 174 I Phase 1 M 176 I Phase 2 M 177 D Phase 1 M 178 I Phase 1 M 179 I Phase 1 M 181 I Phase 1 M 182 I Phase 2 M 183 I Phase 1 M 184 D Phase 1 M 185 I Phase 1 M 186 I Phase 2 U 187 D Phase 1 M 188 I Phase 1 M 189 I Phase 2 M 190 D Phase 1 M 191 I Phase 1 M 192 I Phase 2 M 193 I Phase 1 M 195 I Phase 2 M 196 I Phase 2 M 197 I Phase 1 U 199 I Phase 1 M 200 I Phase 1 M 201 I Phase 2 M 202 I Phase 1 M 203 I Phase 2 M 204 I Phase 2 M 207 I Phase 2 M 208 I Phase 1 M 209 I Phase 1 M 210 D Phase 1 B February 14, 2003 Page 77 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 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 224 225 226 227 228 229 230 231 232 233 211 I Phase 2 M 212 I Phase 1 M 214 D Phase 1 M 215 I Phase 2 M 216 I Phase 1 M 219 I Phase 1 M 221 I Phase 1 M 222 I Phase 2 M 223 I Phase 1 M 224 I Phase 2 M 225 I Phase 2 M 226 I Phase 1 M 227 I Phase 1 M 228 I Phase 2 M 229 I Phase 1 M 230 I Phase 1 M 231 I Phase 2 B 232 D Phase 1 M 233 I Phase 1 U 234 I Phase 2 M 235 I Phase 1 B 237 I Phase 2 M 239 D Phase 1 M 240 I Phase 2 M 241 I Phase 2 M 242 I Phase 2 M 243 I Phase 2 M 245 D Phase 1 M 246 I Phase 2 M 247 I Phase 1 B 248 I Phase 1 B 249 I Phase 1 B 250 I Phase 2 M 252 I Phase 1 M 253 I Phase 2 R 254 I Phase 1 M 255 I Phase 2 M 257 I Phase 2 R 259 I Phase 2 M 260 D Phase 1 B 261 I Phase 1 M 262 I Phase 1 B 263 I Phase 2 B 264 I Phase 1 M 265 D Phase 1 M 266 D Phase 1 M 267 I Phase 1 M 268 I Phase 1 U 269 I Phase 2 M 270 I Phase 2 M 271 I Phase 2 M 273 D Phase 1 M 274 D Phase 1 B 276 I Phase 1 M 279 I Phase 1 M 280 I Phase 1 U 281 D Phase 1 B 282 I Phase 1 M February 14, 2003 Page 78 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 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 278 279 280 281 282 283 284 285 286 287 288 289 290 291 283 D Phase 1 U 284 D Phase 1 B 285 I Phase 1 M 286 I Phase 2 M 288 I Phase 1 M 289 I Phase 1 M 290 I Phase 2 M 291 I Phase 2 R 293 I Phase 1 M 295 I Phase 2 M 296 I Phase 1 M 298 I Phase 2 R 299 I Phase 2 M 300 I Phase 2 M 301 I Phase 1 M 302 I Phase 1 M 303 I Phase 1 M 304 D Phase 1 U 305 I Phase 1 M 306 D Phase 1 U 307 I Phase 2 M 308 I Phase 2 M 309 I Phase 1 M 310 I Phase 2 M 312 I Phase 2 M 313 I Phase 1 M 314 I Phase 1 B 315 I Phase 1 M 316 I Phase 2 M 319 D Phase 1 M 320 I Phase 1 U 322 I Phase 1 M 323 I Phase 1 M 324 I Phase 2 B 325 I Phase 1 M 326 I Phase 1 M 327 I Phase 2 M 328 I Phase 2 M 329 I Phase 2 B 330 I Phase 2 M 331 I Phase 1 M 332 I Phase 2 U 333 I Phase 1 B 334 D Phase 2 M 335 I Phase 1 M 336 I Phase 1 M 337 I Phase 2 U 338 I Phase 1 M 339 D Phase 2 M 340 I Phase 1 M 342 I Phase 2 M 345 I Phase 1 M 349 I Phase 2 M 350 I Phase 2 M 351 I Phase 1 M 355 I Phase 2 M 357 I Phase 2 M 358 D Phase 1 M February 14, 2003 Page 79 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 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 336 337 338 339 340 341 342 343 344 345 346 347 348 349 359 I Phase 1 U 361 I Phase 1 M 363 I Phase 1 B 364 I Phase 1 M 365 I Phase 1 M 366 I Phase 1 M 369 I Phase 1 U 370 I Phase 1 M 371 I Phase 2 R 372 I Phase 2 M 374 I Phase 2 M 375 I Phase 1 U 376 I Phase 1 M 377 D Phase 1 M 378 I Phase 1 M 380 I Phase 1 M 381 I Phase 1 M 383 I Phase 2 M 384 I Phase 1 M 386 I Phase 1 M 387 I Phase 1 B 388 I Phase 1 M 390 D Phase 1 M 392 D Phase 2 M 393 I Phase 2 M 395 D Phase 1 M 396 I Phase 1 M 398 I Phase 1 B 399 I Phase 1 M 400 I Phase 2 M 401 I Phase 2 M 402 I Phase 2 M 403 D Phase 1 M 404 D Phase 1 U 406 I Phase 2 M 407 I Phase 2 M 408 I Phase 1 M 409 I Phase 1 M 410 I Phase 1 M 411 I Phase 2 M 412 D Phase 2 M 413 D Phase 1 U 414 I Phase 1 M 416 I Phase 1 M 417 I Phase 2 R 418 I Phase 1 M 419 I Phase 2 M 420 I Phase 2 M 421 I Phase 2 M 422 I Phase 1 M 423 I Phase 2 M 424 I Phase 1 M 425 I Phase 2 M 426 I Phase 1 B 428 I Phase 1 M 429 I Phase 1 M 430 I Phase 2 M 433 I Phase 2 M February 14, 2003 Page 80 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 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 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 434 I Phase 2 U 435 I Phase 2 M 438 I Phase 2 R 439 I Phase 2 M 440 I Phase 1 M 441 I Phase 1 B 442 I Phase 1 M 443 I Phase 2 M 445 I Phase 2 B 446 I Phase 1 M 447 I Phase 1 M 448 I Phase 2 M 449 I Phase 2 M 450 I Phase 2 M 451 I Phase 1 B 452 I Phase 1 M 453 I Phase 2 M 455 I Phase 2 M 456 I Phase 1 M 457 I Phase 1 B 458 I Phase 1 M 459 I Phase 1 M 460 I Phase 2 R 461 I Phase 1 M 462 I Phase 1 M 463 I Phase 2 M 464 I Phase 1 M 466 I Phase 1 M 468 D Phase 1 B 470 I Phase 1 M 471 I Phase 2 M 472 D Phase 1 U 473 D Phase 1 M 474 I Phase 2 R 475 I Phase 1 M 476 I Phase 2 M 477 I Phase 2 M 479 I Phase 1 R 480 I Phase 1 M 481 I Phase 1 M 482 I Phase 2 M 484 D Phase 1 M 486 I Phase 1 M 487 I Phase 2 M 488 I Phase 1 M 489 I Phase 1 M 490 I Phase 1 M 492 I Phase 1 B 493 I Phase 1 M 494 I Phase 2 M 495 I Phase 2 M 496 I Phase 1 M 497 I Phase 2 M 498 D Phase 2 M 501 I Phase 2 R 502 I Phase 1 M 503 I Phase 2 M 504 I Phase 1 M February 14, 2003 Page 81 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 505 I Phase 2 R 506 I Phase 2 M 507 I Phase 2 M 509 I Phase 1 M 510 I Phase 1 M 511 I Phase 1 M 513 I Phase 2 M 514 I Phase 1 M 515 I Phase 1 M 516 D Phase 2 M 517 I Phase 2 M 518 I Phase 1 M 519 I Phase 2 M 520 I Phase 1 M 522 I Phase 1 B 523 I Phase 1 M 524 I Phase 1 M 525 I Phase 2 M 526 I Phase 1 M 527 I Phase 2 M 528 I Phase 2 M 530 I Phase 1 M 531 I Phase 1 M 532 I Phase 1 B 533 I Phase 2 M 534 D Phase 1 M 536 I Phase 1 U 537 I Phase 1 M 538 I Phase 1 B 539 D Phase 1 B 540 I Phase 1 U 542 I Phase 1 M 543 I Phase 2 M 545 I Phase 1 M 547 I Phase 2 M 548 I Phase 1 M 549 I Phase 2 M 550 I Phase 2 M 551 D Phase 1 M 552 I Phase 2 M 555 I Phase 1 M 556 I Phase 2 R 560 I Phase 2 U 561 I Phase 1 M 563 I Phase 2 M 564 I Phase 2 M 566 I Phase 1 M 567 I Phase 1 M 570 D Phase 1 M 574 D Phase 1 M 575 I Phase 2 M 577 I Phase 2 M 578 I Phase 1 M 579 I Phase 1 M 580 I Phase 2 M 583 D Phase 1 M 584 I Phase 2 M 585 I Phase 1 M February 14, 2003 Page 82 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 586 I Phase 1 M 587 D Phase 2 M 590 I Phase 1 M 591 I Phase 2 M 592 I Phase 1 M 594 I Phase 2 M 595 I Phase 1 B 597 D Phase 2 M 598 I Phase 2 M 599 D Phase 2 M 600 I Phase 2 M 603 I Phase 1 M 605 I Phase 1 M 606 I Phase 2 M 607 I Phase 2 M 608 I Phase 1 M 609 I Phase 1 M 610 I Phase 2 M 611 D Phase 1 M 612 I Phase 1 M 613 I Phase 1 M 614 I Phase 1 M 615 I Phase 1 M 616 D Phase 1 B 617 I Phase 1 M 619 I Phase 2 M 621 I Phase 1 M 622 D Phase 1 M 623 I Phase 1 M 624 I Phase 1 M 625 I Phase 2 M 626 I Phase 2 M 627 I Phase 1 M 628 I Phase 2 M 629 D Phase 1 M 630 I Phase 1 B 631 I Phase 1 M 632 I Phase 1 M 633 I Phase 1 M 634 D Phase 1 M 635 D Phase 1 M 636 I Phase 2 M 637 I Phase 2 U 639 I Phase 2 M 640 I Phase 2 U 641 I Phase 2 M 642 I Phase 1 U 643 I Phase 2 M 645 I Phase 2 M 648 I Phase 1 M 649 I Phase 2 M 650 D Phase 2 M 651 I Phase 2 M 653 I Phase 1 M 655 I Phase 1 M 656 D Phase 1 B 658 I Phase 2 B 660 I Phase 2 U February 14, 2003 Page 83 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 661 D Phase 1 M 662 I Phase 1 U 663 I Phase 1 M 664 I Phase 1 B 665 I Phase 1 M 666 I Phase 2 M 667 I Phase 2 M 668 D Phase 2 M 669 I Phase 1 M 670 I Phase 2 M 671 I Phase 2 M 673 I Phase 1 M 674 I Phase 2 M 675 I Phase 1 U 678 I Phase 2 B 679 I Phase 1 U 680 I Phase 2 M 681 I Phase 1 M 682 I Phase 2 M 683 I Phase 1 M 684 I Phase 1 M 685 I Phase 2 M 687 I Phase 1 M 688 D Phase 1 M 690 I Phase 1 M 693 I Phase 1 M 694 I Phase 2 M 695 I Phase 1 B 696 I Phase 1 M 699 I Phase 2 M 700 I Phase 1 M 701 D Phase 2 M 702 I Phase 2 M 703 I Phase 2 B 704 I Phase 1 B 705 I Phase 1 M 706 I Phase 1 U 707 I Phase 1 M 708 I Phase 1 M 709 I Phase 2 B 710 I Phase 1 M 711 I Phase 1 M 712 I Phase 2 M 713 I Phase 2 M 714 D Phase 1 M 715 I Phase 2 M 716 I Phase 2 M 717 I Phase 1 M 718 I Phase 1 M 719 I Phase 2 M 720 I Phase 1 M 721 I Phase 2 M 722 I Phase 2 M 723 I Phase 2 M 724 I Phase 2 M 725 I Phase 2 M 726 D Phase 1 M 727 D Phase 2 R February 14, 2003 Page 84 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 728 I Phase 2 M 729 I Phase 2 M 730 D Phase 1 M 732 I Phase 1 M 733 I Phase 2 B 734 I Phase 2 M 735 I Phase 2 M 737 I Phase 2 M 738 I Phase 2 M 739 D Phase 1 U 740 I Phase 1 M 741 I Phase 1 M 745 I Phase 2 M 746 I Phase 1 M 747 I Phase 1 M 748 I Phase 2 M 749 I Phase 1 M 751 I Phase 1 B 752 I Phase 1 U 753 I Phase 1 U 755 I Phase 2 R 756 I Phase 1 M 757 I Phase 2 M 758 I Phase 1 M 759 I Phase 2 M 760 I Phase 1 M 762 I Phase 2 R 763 D Phase 1 U 764 I Phase 1 M 765 I Phase 2 M 766 I Phase 2 M 767 I Phase 1 M 768 I Phase 2 M 771 I Phase 1 M 772 I Phase 2 M 773 I Phase 2 R 774 I Phase 1 M 775 I Phase 1 M 777 D Phase 1 M 778 I Phase 2 M 779 I Phase 2 M 780 D Phase 1 U 781 I Phase 2 M 782 I Phase 2 M 784 I Phase 2 M 785 I Phase 1 M 786 I Phase 2 M 787 I Phase 1 M 788 I Phase 2 M 789 I Phase 1 M 790 I Phase 1 M 791 I Phase 2 U 792 I Phase 2 M 793 I Phase 2 M 795 I Phase 2 M 796 D Phase 1 U 797 I Phase 1 M 799 I Phase 1 M February 14, 2003 Page 85 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 800 I Phase 1 M 802 I Phase 2 M 804 I Phase 2 R 805 I Phase 2 M 806 I Phase 2 M 807 I Phase 1 M 808 I Phase 1 M 809 D Phase 1 M 811 D Phase 2 M 813 I Phase 1 M 814 I Phase 1 M 815 I Phase 1 M 816 I Phase 1 M 817 I Phase 2 B 818 D Phase 2 M 819 I Phase 2 M 820 I Phase 2 M 821 I Phase 1 M 822 I Phase 2 M 823 I Phase 1 M 824 I Phase 1 M 825 I Phase 2 M 829 I Phase 1 M 830 D Phase 2 M 831 I Phase 1 M 834 I Phase 2 M 836 I Phase 1 M 837 I Phase 1 M 839 D Phase 2 M 841 I Phase 2 B 842 I Phase 2 M 843 I Phase 2 R 844 D Phase 2 R 846 I Phase 2 M 848 I Phase 2 M 849 I Phase 2 M 850 I Phase 1 M 851 I Phase 1 M 853 I Phase 1 B 854 I Phase 1 M 855 I Phase 1 M 856 I Phase 1 M 857 I Phase 1 M 858 I Phase 1 B 859 I Phase 1 M 860 I Phase 1 B 861 I Phase 1 U 862 I Phase 2 M 863 I Phase 2 B 864 I Phase 1 M 866 I Phase 2 M 867 I Phase 1 B 869 I Phase 2 U 870 I Phase 1 M 871 D Phase 1 M 873 I Phase 1 M 874 I Phase 1 B 875 I Phase 1 B February 14, 2003 Page 86 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 6 A B C D E F G H I J SID Weight Small Sector Subcat FlowRange Direct? Phase Revenue Source FTE 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 879 I Phase 2 B 880 D Phase 1 U 884 I Phase 2 M 885 I Phase 1 M 886 I Phase 1 M 887 I Phase 2 B 888 I Phase 2 R 891 I Phase 2 B 894 I Phase 2 M 905 I Phase 2 R 918 I Phase 2 R 921 I Phase 2 R 922 I Phase 2 M 926 I Phase 2 R 927 I Phase 2 M 929 I Phase 2 R 930 I Phase 2 M 934 I Phase 2 M February 14, 2003 Page 87 of 89 MPCT_ July. xls  FacData Record for the Final Metal Product and Machinery Rule 12345 6789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 A B C D E F G H I J K L M N 1 2 3 4 2 3 4 2 3 4 5 6 7 Compliance Costs in 1996 Dollars Costs as of July 19, 2002 SID$ CapCst1 AnnCst1 CC1_ 96 CapCst2 AnnCst2 CC2_ 96 CapCst3 AnnCst3 CC3_ 96 CapCst4 AnnCst4 CC4_ 96 2 3 4 5 6 7 8 9 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 50 51 52 53 54 55 Note: All data except site identification not shown to protect confidential business information. Sample page provided to show structure of worksheet. February 14, 2003 Page 88 of 89 MPCT_ July. xls  Costs Record for the Final Metal Product and Machinery Rule 1234 56789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 A B C D E F Census Data  Average Payroll and Capital Expenditures by Sector ( all data in 1996$) Source: H:\ ENVR\ Triton05 MP& M\ EPA DCF\ Census Data\ Industry Statistics. xls Printed Circuit Boards Sector Emp Flag Establishment Size Average Payroll Average Capital Expenditures 21 1 to 4 $ 24,758 $ 10,307 22 5 to 9 $ 25,370 $ 31,700 23 10 to 19 $ 25,474 $ 81,762 24 20 to 49 $ 27,690 $ 133,231 25 50 to 99 $ 29,777 $ 416,240 26 100 to 249 $ 28,702 $ 1,198,614 27 250 to 499 $ 29,005 $ 3,711,765 28 500 to 999 $ 25,116 $ 8,971,792 29 1000 to 2499 $ 45,267 $ 28,370,591 All $ 29,539 $ 485,073 Job Shops Sector Emp Flag Establishment Size Average Payroll Average Capital Expenditures 11 1 to 4 $ 22,937 $ 7,994 12 5 to 9 $ 25,427 $ 56,966 13 10 to 19 $ 26,273 $ 63,764 14 20 to 49 $ 27,322 $ 113,120 15 50 to 99 $ 28,378 $ 320,576 16 100 to 249 $ 30,258 $ 1,371,749 17 250 to 499 $ 28,138 $ 6,644,760 18 500 to 999 $ 26,971 $ 2,928,762 19 1000 to 2499 All $ 27,833 $ 169,422 Iron & Steel Establishment Size Average Payroll Average Capital Expenditures 1 to 4 $ 29,038 $ 11,456 5 to 9 $ 28,419 $ 38,463 10 to 19 $ 30,498 $ 149,129 20 to 49 $ 31,747 $ 398,675 50 to 99 $ 32,940 $ 677,746 100 to 249 $ 35,014 $ 1,305,155 250 to 499 $ 36,500 $ 2,604,033 500 to 999 $ 44,228 $ 2,194,425 1000 to 2499 All $ 35,414 $ 789,544 Bus & Truck Sector Emp Flag Establishment Size Average Payroll Average Capital Expenditures 31 1 to 4 $ 23,017 32 5 to 9 $ 23,441 33 10 to 19 $ 24,578 34 20 to 49 $ 25,717 35 50 to 99 $ 26,407 36 100 to 249 $ 26,639 37 250 to 499 $ 28,965 38 500 to 999 $ 26,490 39 1000 to 2499 $ 29,568 All $ 27,443 February 14, 2003 Page 89 of 89 MPCT_ July. xls  Census