year fcode employ sales avgsal scrap rework tothrs union grant hrsemp 1987 410032 100 4.70e+07 35000 12 0 0 12 1988 410032 131 4.30e+07 37000 8 0 0 3.053435 1989 410032 123 4.90e+07 39000 8 0 0 3.252033 1987 410440 12 1560000 10500 12 0 0 12 1988 410440 13 1970000 11000 12 0 0 12 1989 410440 14 2350000 11500 10 0 0 10 1987 410495 20 750000 17680 50 0 0 37.5 1988 410495 25 110000 18720 50 0 0 20 1989 410495 24 950000 19760 50 0 0 41.66667 1987 410500 200 2.37e+07 13729 0 0 0 0 1988 410500 155 1.97e+07 14287 0 0 0 0 1989 410500 80 2.60e+07 15758 24 0 0 6 1987 410501 6000000 0 0 0 1988 410501 8000000 0 0 0 1989 410501 1.00e+07 0 0 0 1987 410509 0 0 0 1988 410509 2800000 18000 0 0 0 1989 410509 20 3400000 18500 0 0 0 0 1987 410513 15 1413900 18465 0 0 0 0 1988 410513 16 1869348 18972 0 0 0 0 1989 410513 16 1857765 19589 20 0 0 20 1987 410517 24 13000 0 1 0 0 1988 410517 20 12168 0 1 0 0 1989 410517 18 11960 0 1 0 0 1987 410518 48 2160900 14352 14 0 0 .875 1988 410518 47 2454500 16328 14 0 0 .893617 1989 410518 66 3359800 17555 14 0 0 .8484849 1987 410521 17 1453081 16454 150 0 0 44.11765 1988 410521 16 1546911 18529 100 0 0 18.75 1989 410521 14 1672366 26428 0 0 0 0 1987 410523 70 8000000 19760 .06 40 0 0 20 1988 410523 85 1.10e+07 22360 .05 40 0 0 18.82353 1989 410523 98 1.50e+07 23920 .05 60 0 0 24.4898 1987 410529 45 1535242 20000 0 0 0 0 1988 410529 47 3209188 22000 0 0 0 0 1989 410529 51 4030352 23650 2 0 0 .0784314 1987 410531 200 1.00e+07 17500 5 0 1 0 0 1988 410531 200 1.00e+07 18700 4 20 1 0 .6 1989 410531 190 9000000 18300 2.22 20 1 0 1.052632 1987 410533 14 1600000 11500 68 0 0 14.57143 1988 410533 12 900000 13000 75 0 0 31.25 1989 410533 16 1300000 14700 35 0 0 19.6875 1987 410535 10 420664 4237 0 0 0 0 1988 410535 11 544602 7484 0 0 0 0 1989 410535 9 495331 9548 0 0 0 0 1987 410536 15 1502502 11742 12 0 0 1.6 1988 410536 16 1840912 12740 12 0 0 1.5 1989 410536 18 2273869 13700 8 0 0 1.333333 1987 410538 19760 2.64 0 1 0 1988 410538 6276271 20800 2.74 0 1 0 1989 410538 60 5286605 20800 2.54 30 1 0 25 1987 410540 50 5200000 20000 0 0 0 0 1988 410540 50 6500000 23000 0 0 0 0 1989 410540 55 5600000 25000 0 0 0 0 1987 410544 30 19760 0 0 0 0 1988 410544 32 20280 10 0 0 1.25 1989 410544 34 20800 10 0 0 1.764706 1987 410546 153 1.00e+07 12500 8 0 0 .3660131 1988 410546 134 1.10e+07 13000 8 0 0 .358209 1989 410546 146 1.20e+07 13500 40 0 0 7.671233 1987 410547 20 2300000 20000 10 0 0 0 0 1988 410547 23 2500000 23000 10 0 0 0 0 1989 410547 25 3000000 25000 10 48 0 0 1.92 1987 410556 0 0 0 1988 410556 0 0 0 1989 410556 131 7588770 16640 0 0 0 0 1987 410560 22 725000 9000 0 0 0 0 1988 410560 25 785000 9000 0 0 0 0 1989 410560 23 785000 10000 0 0 0 0 1987 410561 6 501859 0 0 0 0 1988 410561 6 580415 0 0 0 0 1989 410561 9 735442 64 0 0 7.111111 1987 410562 15 4000000 32000 10 0 0 1.333333 1988 410562 18 5000000 34000 10 0 0 1.111111 1989 410562 19 7000000 38000 25 0 0 7.894737 1987 410563 73 5300000 21500 6 0 1 0 0 1988 410563 76 5800000 22200 7 0 1 0 0 1989 410563 80 6400000 23000 5 50 1 0 5 1987 410564 160 20000 4.3 20 0 0 1.875 1988 410564 150 21000 4.1 20 0 0 2.666667 1989 410564 150 22000 4 25 0 0 5.833333 1987 410565 90 20620 21 0 1 0 0 1988 410565 112 2.18e+07 20180 11 0 1 0 0 1989 410565 128 2.58e+07 21500 .4 16 1 0 16 1987 410566 14 2101581 14850 7 8 0 0 6.857143 1988 410566 16 2400723 18100 5 3 0 0 1.875 1989 410566 13 2470633 20500 4.5 4 0 0 3.076923 1987 410567 40 3000000 10000 1 .5 0 0 0 0 1988 410567 48 3800000 11000 .5 .25 0 0 0 0 1989 410567 50 3100000 11500 .28 .13 16 0 0 16 1987 410569 20 26000 0 0 0 0 1988 410569 24 28000 0 0 0 0 1989 410569 30 30000 0 0 0 0 1987 410571 17 755050 10400 .01 25 0 0 25 1988 410571 15 1102723 10400 .01 25 0 0 25 1989 410571 20 1073785 10400 .01 25 0 0 12.5 1987 410577 75 4750000 16120 1.68 1.89 3 0 0 1.2 1988 410577 80 5100000 16432 1.57 1.76 4 0 0 1.75 1989 410577 94 5500000 16640 1.64 1.82 4 0 0 1.489362 1987 410586 116 1.10e+07 23500 47 0 0 38.89655 1988 410586 114 1.10e+07 24000 47 0 0 38.75439 1989 410586 119 1.10e+07 24600 47 0 0 39.10084 1987 410591 25 12180 0 0 0 0 1988 410591 33 13000 50 0 0 1.515152 1989 410591 37 14500 40 0 0 2.162162 1987 410592 20 30 40 0 0 1988 410592 20 24 27 0 0 1989 410592 10 20 15 0 0 1987 410593 5 3500000 1 0 0 0 0 1988 410593 5 3800000 1 0 0 0 0 1989 410593 5 4000000 1 0 0 0 0 1987 410596 8 990400 12480 10 10 0 0 10 1988 410596 16 1166100 13520 6 12 0 0 12 1989 410596 20 1815900 14560 4 14 0 0 14 1987 410603 10 1212478 12700 105 0 0 42 1988 410603 14 1159622 13600 105 0 0 22.5 1989 410603 17 1612170 14900 0 0 1987 410604 60 8320 0 0 0 0 1988 410604 100 8940 0 0 0 0 1989 410604 190 10400 0 0 0 0 1987 410606 124 1.05e+07 .66 10 0 0 3.467742 1988 410606 127 1.22e+07 14538 .34 8 0 0 1.889764 1989 410606 128 1.20e+07 14865 .39 28 0 0 19.03125 1987 410609 22 1650831 24900 0 0 0 0 1988 410609 37 1817961 23000 0 0 0 0 1989 410609 44 1642441 23200 0 0 0 0 1987 410612 60 7000000 8840 12 0 0 12 1988 410612 65 8500000 9880 12 0 0 12 1989 410612 70 1.10e+07 10920 12 0 0 12 1987 410626 27 4600000 18000 .87 24 1 0 2.666667 1988 410626 28 4900000 19000 .82 16 1 0 1.142857 1989 410626 30 5600000 21000 .71 32 1 0 6.4 1987 410627 25 2900000 21830 1 0 1988 410627 25 2800000 22454 1 0 1989 410627 25 2900000 23078 1 0 1987 410629 16 1100000 18500 1.2 .58 0 0 1988 410629 19 2050000 21000 .53 .25 0 0 1989 410629 23 2260000 23500 .49 .36 0 0 1987 410635 100 2.00e+07 22000 0 1 0 0 1988 410635 95 1.80e+07 22000 1 1 0 .0105263 1989 410635 85 1.60e+07 22000 20 1 0 11.76471 1987 410636 8 386807 14110 0 0 1988 410636 10 734613 14040 0 0 1989 410636 8 518842 14126 0 0 1987 410639 135 1.40e+07 20384 1 1 0 .3703704 1988 410639 135 1.50e+07 20800 3 1 0 1.666667 1989 410639 144 1.55e+07 20592 5 1 0 3.472222 1987 410640 13 1656000 19266 240 0 0 55.38462 1988 410640 11 1527000 20867 200 0 0 36.36364 1989 410640 13 1454000 25154 200 0 0 30.76923 1987 410641 3600000 0 0 1988 410641 3900000 0 0 1989 410641 5200000 0 0 1987 410642 0 0 0 1988 410642 45 0 0 1989 410642 45 0 0 1987 410649 30 2100000 25500 0 0 1988 410649 27 2252000 26000 0 0 1989 410649 24 1866064 28000 0 0 1987 410653 14 1950000 16000 1.06 1 0 1988 410653 13 1850000 17000 1.03 1 0 1989 410653 12 1550000 18000 1.14 1 0 1987 410665 .05 .06 0 0 0 1988 410665 12 1000000 29120 .08 .03 16 0 0 2.666667 1989 410665 14 1200000 29120 .03 .09 16 0 0 4.571429 1987 410679 30 26000 3 0 0 1988 410679 30 26000 3 0 0 1989 410679 28 27000 3 0 0 1987 410680 27 2873000 19762 100 0 0 51.85185 1988 410680 61 6097000 21120 50 0 0 4.098361 1989 410680 52 5670000 22360 70 0 0 12.11539 1987 410685 24 2213235 20004 .14 0 0 1988 410685 20 2100943 19078 .16 0 0 1989 410685 20 2174049 21099 .23 0 0 1987 410686 6 2100000 16640 0 0 0 0 1988 410686 7 1800000 18720 10 0 0 2.857143 1989 410686 6 1600000 20800 0 0 0 0 1987 418006 63 25900 0 0 0 0 1988 418006 57 25300 45 0 1 18.94737 1989 418006 59 26800 40 0 0 23.72881 1987 418007 26 2200000 10712 1.9 1 0 1988 418007 24 1800000 10940 2.6 1 0 1989 418007 21 1700000 11148 1.2 1 0 1987 418008 10 900000 0 0 0 0 1988 418008 10 1200000 16 0 1 16 1989 418008 12 1100000 20000 0 0 0 0 1987 418011 70 4200000 12400 10 9 0 1 0 0 1988 418011 50 3740000 13400 3 3 43 1 1 8.6 1989 418011 30 2040000 14000 2 1 40 1 0 6.666667 1987 418013 20 750000 14560 .27 40 0 0 4 1988 418013 18 800000 16640 .25 60 0 1 10 1989 418013 20 950000 17680 .21 40 0 0 6 1987 418014 9 6802180 13478 256 0 0 56.88889 1988 418014 12 936477 14269 281 0 1 163.9167 1989 418014 17 1437883 15558 256 0 0 75.29412 1987 418021 11 1850000 12500 1 1 0 0 0 0 1988 418021 13 2078000 13100 1 1 40 0 1 6.153846 1989 418021 13 2040000 13800 1 1 10 0 0 1.538462 1987 418024 40 5500000 10400 0 0 0 0 1988 418024 60 6000000 10400 40 0 1 38 1989 418024 100 7000000 11020 20 0 0 2 1987 418035 30 1269000 14000 6 12 0 0 0 0 1988 418035 30 1681000 14500 5 11 23 0 1 18.4 1989 418035 31 1814000 15000 3 9 0 0 0 0 1987 418036 485 17888 10 0 0 .3092783 1988 418036 500 18637 46 0 1 2.208 1989 418036 525 19386 10 0 0 .2857143 1987 418045 15 2000000 18000 2 1 30 0 0 4 1988 418045 15 2500000 20000 2 1 40 0 0 8 1989 418045 15 3500000 22000 2 1 150 0 0 150 1987 418046 15 13000 0 0 0 0 1988 418046 20 12000 24 0 1 24 1989 418046 25 12000 4 0 0 4 1987 418051 .45 .14 25 1 0 1988 418051 .5 .17 13 1 1 1989 418051 .5 .17 20 1 0 1987 418052 6 400000 25861 0 0 0 0 1988 418052 5 500000 25168 55 0 1 55 1989 418052 7 600000 23625 0 0 0 0 1987 418054 60 3330457 11500 1.25 0 0 0 0 1988 418054 65 3765312 12500 1.54 40 0 1 1.846154 1989 418054 56 3533090 13200 .96 10 0 0 0 1987 418065 259 2.69e+07 15038 1.3 .5 6 1 0 3.474904 1988 418065 331 3.22e+07 15434 1.5 .7 21 1 1 15.48036 1989 418065 321 3.10e+07 16307 1 .7 6 1 0 3.364486 1987 418066 35 2 0 0 2 1988 418066 34 0 1 1989 418066 36 3 0 0 3 1987 418076 60 3870000 19968 1.06 2 50 0 0 16.66667 1988 418076 70 3882000 20800 .8 1.5 52 0 1 30.45714 1989 418076 70 5330000 21840 .22 .5 50 0 0 14.28571 1987 418083 125 2.60e+07 20000 3 .05 0 1 0 0 1988 418083 120 3.60e+07 20000 2 0 1 1 1989 418083 60 2.20e+07 20000 1 .03 32 1 0 10.66667 1987 418084 40 1200000 10000 200 1 0 30 1988 418084 35 1100000 10300 1 1 1989 418084 50 1300000 10700 200 1 0 24 1987 418091 150 1.10e+07 12000 8.18 10 0 0 1.333333 1988 418091 175 1.50e+07 14000 .67 30 0 1 12.68571 1989 418091 200 1.80e+07 16000 .56 20 0 0 5 1987 418097 80 6000000 12480 1.67 15 5 0 0 .3125 1988 418097 150 7700000 14560 1.17 12 30 0 1 2.8 1989 418097 120 5643000 16640 1.42 10 0 0 0 0 1987 418098 15 9360 0 0 0 0 1988 418098 18 10400 40 0 1 40 1989 418098 22 13520 80 0 0 10.90909 1987 418107 10 307501 8500 .98 10 0 0 10 1988 418107 25 1961818 9000 .51 83 0 1 83 1989 418107 34 2650786 9400 .45 15 0 0 13.23529 1987 418109 6 600000 16640 200 0 0 100 1988 418109 12 820000 18304 290 0 1 120.8333 1989 418109 14 1200000 19552 320 0 0 91.42857 1987 418118 16 1608573 35000 1 10 5 0 0 3.125 1988 418118 16 1342236 38000 .5 5 25 0 1 25 1989 418118 16 1504283 41000 .1 1 5 0 0 3.125 1987 418124 15 1600000 12000 0 0 0 0 1988 418124 20 1800000 13000 40 0 1 18 1989 418124 26 2000000 16000 8 0 0 1.846154 1987 418125 72 1.05e+07 17700 .45 10 0 0 9.305555 1988 418125 128 1.54e+07 19350 .61 31 0 1 31 1989 418125 168 2.30e+07 23250 .6 14 0 0 9 1987 418126 60 5600000 23000 30 0 0 5 1988 418126 50 6200000 25000 48 0 1 48 1989 418126 48 6300000 27000 30 0 0 3.75 1987 418140 17 8 0 0 0 0 1988 418140 23 4 80 0 1 80 1989 418140 20 2.5 40 0 0 12 1987 418147 15 726833 9048 0 0 0 0 1988 418147 80 4005963 10088 40 0 0 20 1989 418147 30 2089704 10504 0 0 0 0 1987 418163 72 7742994 18305 9 0 1 0 0 1988 418163 70 8273868 19828 7 40 1 1 40 1989 418163 68 8329656 17893 6.5 0 1 0 0 1987 418168 7 5449674 .01 40 0 0 40 1988 418168 7 6131102 .11 40 0 0 40 1989 418168 8 7332464 .2 0 0 0 0 1987 418177 120 1.00e+07 28080 18 3 20 1 0 0 1988 418177 120 1.20e+07 28080 19 3 26 1 1 26 1989 418177 120 1.10e+07 28080 18 3 14 1 0 14 1987 418183 21 14800 2.4 0 0 1988 418183 25 1800000 15100 2.79 0 0 1989 418183 30 2100000 16500 2 0 0 1987 418185 31 2000000 30000 0 0 1988 418185 47 2200000 30000 0 0 1989 418185 32 1800000 30000 0 0 1987 418213 25 1400000 14000 10 0 0 1.2 1988 418213 30 1680000 16000 0 1 1989 418213 39 2806000 17000 12 0 0 1.230769 1987 418220 19 580000 8840 0 0 0 0 1988 418220 21 660000 9360 39 0 1 39 1989 418220 30 984000 10720 0 0 0 0 1987 418225 15 1300000 13000 0 1 0 0 1988 418225 18 1600000 14040 10 1 1 10 1989 418225 28 2300000 15080 0 1 0 0 1987 418229 6 490000 14560 0 0 0 0 1988 418229 7 580000 15600 0 0 0 0 1989 418229 8 660000 16640 0 0 0 0 1987 418237 28 4568907 19042 .28 0 1 0 0 1988 418237 28 4904008 19845 .2 12 1 1 6 1989 418237 29 5884603 20426 .19 10 1 0 1.37931 1987 418239 80 6900000 13728 .22 20 0 0 5 1988 418239 65 8400000 14664 .24 20 0 0 7.692307 1989 418239 75 7100000 15600 .42 20 0 0 8 1987 418243 12 15000 0 0 0 0 1988 418243 14 15000 0 0 0 0 1989 418243 15 16000 0 0 0 0 1987 418245 25 3000000 20000 0 0 0 0 1988 418245 30 4000000 25000 0 0 0 0 1989 418245 40 6000000 30000 0 0 0 0 1987 419198 17 1083644 24000 7 10 56 0 0 19.76471 1988 419198 13 851605 24000 5 8 88 0 1 88 1989 419198 9 885852 16000 4 7.5 56 0 0 6.222222 1987 419201 20 3499895 14560 2 0 0 0 0 1988 419201 17 4008997 16848 2 24 0 0 8.470589 1989 419201 13 3379103 18720 2 0 0 0 0 1987 419242 70 6400000 16141 3.97 6 1 0 5.142857 1988 419242 65 6800000 16578 3.83 36 1 1 36 1989 419242 30 2100000 16952 5.7 4 1 0 4 1987 419268 6 564694 22866 1.39 1.39 0 0 0 0 1988 419268 6 620439 22995 1.16 1.16 0 0 0 0 1989 419268 6 783261 29114 .9 .9 32 0 1 32 1987 419272 35 4200000 31000 20.5 3.03 60 0 0 10.28571 1988 419272 40 4800000 33000 24 4.17 10 0 0 2 1989 419272 43 5200000 34800 17 1.88 80 0 1 80 1987 419275 15 930000 30000 100 0 0 26.66667 1988 419275 18 980000 33000 100 0 0 27.77778 1989 419275 21 1500000 35000 150 0 1 71.42857 1987 419276 12 1200000 28000 0 0 1988 419276 10 1300000 30000 0 0 1989 419276 8 1100000 30000 0 0 1987 419289 13 1200000 18720 1.5 0 0 0 0 1988 419289 14 1350000 20800 1.41 0 0 0 0 1989 419289 15 1480000 29120 .95 72 0 1 72 1987 419297 150 2.27e+07 22006 .2 .4 50 1 0 33.33333 1988 419297 178 3.08e+07 22027 .31 .32 40 1 0 13.48315 1989 419297 171 2.84e+07 24107 .27 .48 20 1 0 4.678362 1987 419298 80 1.00e+07 33280 0 1 0 0 1988 419298 70 9000000 32240 0 1 0 0 1989 419298 65 9500000 30784 40 1 1 36.92308 1987 419302 333 22360 0 0 0 0 1988 419302 340 22360 8 0 0 .5647059 1989 419302 337 22526 12 0 1 12 1987 419303 6 875000 13500 1.5 0 0 0 0 1988 419303 8 1.59e+07 14100 1 20 0 0 5 1989 419303 11 2250000 15050 1.25 75 0 1 75 1987 419305 5 0 1 0 0 1988 419305 5 0 1 0 0 1989 419305 5 9 1 1 9 1987 419307 262 1.81e+07 22360 1 1.09 0 0 0 0 1988 419307 264 1.93e+07 23026 .85 1.07 24 0 0 .2727273 1989 419307 302 2.22e+07 21736 .89 1.07 44 0 1 44 1987 419309 6 600000 24960 .33 15 0 0 15 1988 419309 9 750000 28080 .4 20 0 0 20 1989 419309 12 1000000 30160 .4 55 0 1 55 1987 419312 60 5845000 21133 0 0 1988 419312 71 6927000 20904 0 0 1989 419312 97 1.10e+07 21445 0 0 1987 419319 60 40 0 0 40 1988 419319 69 50 0 0 50 1989 419319 78 50 0 0 50 1987 419328 27 2700000 0 1 0 0 1988 419328 27 2800000 0 1 0 0 1989 419328 27 2800000 12 1 1 12 1987 419335 57 8486927 40563 0 0 0 0 1988 419335 53 4327519 37429 40 0 0 7.54717 1989 419335 62 8533205 42583 40 0 0 3.225806 1987 419339 40 8000000 15000 .5 .3 0 1 0 0 1988 419339 40 8500000 15500 .59 .34 0 1 0 0 1989 419339 60 1.00e+07 17000 .45 .22 0 1 0 0 1987 419343 100 1.00e+07 15000 5 7 70 1 0 3.5 1988 419343 125 1.20e+07 16000 4 8 25 1 0 4.2 1989 419343 290 4.80e+07 18700 3 10 17 1 1 17 1987 419344 0 0 0 1988 419344 0 0 0 1989 419344 9 1000000 17000 0 0 0 0 1987 419347 0 0 0 1988 419347 8 0 0 1989 419347 13 0 1 1987 419351 12 18000 0 0 0 0 1988 419351 14 18000 15 0 0 0 1989 419351 14 19000 25 0 1 25 1987 419357 60 6870314 12750 2 2 50 0 0 50 1988 419357 65 7079852 11875 1 1 75 0 0 75 1989 419357 75 8040128 12625 .5 .5 120 0 1 120 1987 419375 2900000 0 0 0 1988 419375 2500000 25 0 0 1989 419375 3100000 140 0 1 1987 419376 32 6000000 15250 2 1 0 .3125 1988 419376 36 6100000 16290 4 1 0 1.111111 1989 419376 40 6300000 17370 38 1 1 38 1987 419378 20 2700000 10920 2.71 50 0 0 12.5 1988 419378 22 3100000 11856 1.52 75 0 0 40.90909 1989 419378 37 4700000 13520 1.34 154 0 1 154 1987 419379 201 23167 0 0 0 0 1988 419379 201 25929 0 0 0 0 1989 419379 237 24965 24 0 1 7.088608 1987 419380 45 1.00e+07 0 0 0 0 1988 419380 50 1.00e+07 0 0 0 0 1989 419380 55 1.20e+07 10 0 0 10 1987 419381 14 1585000 14560 .65 60 0 0 4.285714 1988 419381 11 1560000 19240 .55 0 0 0 0 1989 419381 12 1747000 20280 .38 50 0 1 50 1987 419384 50 24960 0 0 0 0 1988 419384 73 26520 0 0 0 0 1989 419384 83 28080 110 0 1 39.75904 1987 419388 40 2400000 16307 11 9 2 0 0 .5 1988 419388 36 2300000 16827 8 7 4 0 0 1.666667 1989 419388 33 2700000 17347 6 3 18 0 1 18 1987 419392 15 18000 0 0 1988 419392 18 19500 0 0 1989 419392 21 20900 0 0 1987 419400 6 373164 17680 170 0 0 56.66667 1988 419400 8 422611 17680 170 0 0 85 1989 419400 9 390210 17846 170 0 0 75.55556 1987 419401 62 5000000 29000 72 0 0 15.09677 1988 419401 74 6000000 34000 72 0 0 12.64865 1989 419401 82 8000000 39000 72 0 0 11.41463 1987 419406 1842243 0 0 1988 419406 2072633 0 0 1989 419406 2314928 0 0 1987 419409 75 8450000 13416 2.25 .5 20 0 0 10.66667 1988 419409 72 1.03e+07 15184 2.5 .5 26 0 0 26 1989 419409 75 1.02e+07 17451 2 .5 60 0 1 60 1987 419410 26 26667 14 100 0 0 23.07692 1988 419410 24 24856 10 100 0 0 33.33333 1989 419410 23 25280 9 120 0 1 120 1987 419420 19 1980000 15600 0 0 0 0 1988 419420 15 1600000 17160 0 0 0 0 1989 419420 12 1430000 18720 80 0 1 80 1987 419432 250 6000000 14352 5 3 0 0 1988 419432 290 1.80e+07 15184 4.8 3 0 0 1989 419432 350 5.40e+07 16432 5.2 4 0 0 1987 419433 19 1700000 16640 50 0 0 10.52632 1988 419433 19 2000000 17160 15 0 0 15 1989 419433 21 2200000 17680 49 0 1 25.66667 1987 419434 89 1.14e+07 14394 0 0 0 0 0 1988 419434 59 4748000 15454 .04 0 0 0 0 1989 419434 105 7175000 15558 .14 10 0 0 10 1987 419449 40 3317000 16640 30 0 0 30 1988 419449 55 3692000 16640 30 0 0 30 1989 419449 65 3252000 16640 30 0 0 6.923077 1987 419450 175 1.25e+07 9360 0 0 0 0 1988 419450 225 1.25e+07 10400 0 0 0 0 1989 419450 275 1.82e+07 11440 3 0 0 2.181818 1987 419459 110 1.51e+07 21000 1.67 .21 20 1 0 6.363636 1988 419459 125 1.60e+07 21000 2.5 .23 20 1 0 6.4 1989 419459 225 2.89e+07 21000 1.12 .15 20 1 0 14.22222 1987 419461 24 14800 0 0 0 0 1988 419461 23 15200 0 0 0 0 1989 419461 36 15800 40 0 1 33.33333 1987 419467 4 1494764 30000 80 0 0 80 1988 419467 5 2566104 31000 100 0 0 100 1989 419467 10 2191680 35000 100 0 0 100 1987 419472 120 13000 20 0 0 4.166667 1988 419472 100 13500 20 0 0 5 1989 419472 100 14000 60 0 1 60 1987 419473 18 0 1 0 0 1988 419473 18 3 1 0 3 1989 419473 18 35 1 1 35 1987 419479 0 0 0 1988 419479 30 1503906 15500 0 0 0 0 1989 419479 30 1360372 16500 20 0 0 8.666667 1987 419482 15 2.7 0 0 0 0 1988 419482 15 1000000 10000 2.59 0 0 0 0 1989 419482 18 1000000 10000 2.8 24 0 0 24 1987 419483 133 1.10e+07 13957 20 0 1 0 0 1988 419483 108 1.15e+07 14810 25 0 1 0 0 1989 419483 129 1.20e+07 14227 30 20 1 0 3.100775 1987 419486 80 7000000 16000 0 0 0 0 1988 419486 90 8500000 17000 0 0 0 0 1989 419486 100 9900000 18000 40 0 1 36 year fcode employ sales avgsal scrap rework tothrs union grant hrsemp 1987 410032 100 4.70e+07 35000 12 0 0 12 1988 410032 131 4.30e+07 37000 8 0 0 3.053435 1989 410032 123 4.90e+07 39000 8 0 0 3.252033 1987 410440 12 1560000 10500 12 0 0 12 1988 410440 13 1970000 11000 12 0 0 12 1989 410440 14 2350000 11500 10 0 0 10 1987 410495 20 750000 17680 50 0 0 37.5 1988 410495 25 110000 18720 50 0 0 20 1989 410495 24 950000 19760 50 0 0 41.66667 1987 410500 200 2.37e+07 13729 0 0 0 0 1988 410500 155 1.97e+07 14287 0 0 0 0 1989 410500 80 2.60e+07 15758 24 0 0 6 1987 410501 6000000 0 0 0 1988 410501 8000000 0 0 0 1989 410501 1.00e+07 0 0 0 1987 410509 0 0 0 1988 410509 2800000 18000 0 0 0 1989 410509 20 3400000 18500 0 0 0 0 1987 410513 15 1413900 18465 0 0 0 0 1988 410513 16 1869348 18972 0 0 0 0 1989 410513 16 1857765 19589 20 0 0 20 1987 410517 24 13000 0 1 0 0 1988 410517 20 12168 0 1 0 0 1989 410517 18 11960 0 1 0 0 1987 410518 48 2160900 14352 14 0 0 .875 1988 410518 47 2454500 16328 14 0 0 .893617 1989 410518 66 3359800 17555 14 0 0 .8484849 1987 410521 17 1453081 16454 150 0 0 44.11765 1988 410521 16 1546911 18529 100 0 0 18.75 1989 410521 14 1672366 26428 0 0 0 0 1987 410523 70 8000000 19760 .06 40 0 0 20 1988 410523 85 1.10e+07 22360 .05 40 0 0 18.82353 1989 410523 98 1.50e+07 23920 .05 60 0 0 24.4898 1987 410529 45 1535242 20000 0 0 0 0 1988 410529 47 3209188 22000 0 0 0 0 1989 410529 51 4030352 23650 2 0 0 .0784314 1987 410531 200 1.00e+07 17500 5 0 1 0 0 1988 410531 200 1.00e+07 18700 4 20 1 0 .6 1989 410531 190 9000000 18300 2.22 20 1 0 1.052632 1987 410533 14 1600000 11500 68 0 0 14.57143 1988 410533 12 900000 13000 75 0 0 31.25 1989 410533 16 1300000 14700 35 0 0 19.6875 1987 410535 10 420664 4237 0 0 0 0 1988 410535 11 544602 7484 0 0 0 0 1989 410535 9 495331 9548 0 0 0 0 1987 410536 15 1502502 11742 12 0 0 1.6 1988 410536 16 1840912 12740 12 0 0 1.5 1989 410536 18 2273869 13700 8 0 0 1.333333 1987 410538 19760 2.64 0 1 0 1988 410538 6276271 20800 2.74 0 1 0 1989 410538 60 5286605 20800 2.54 30 1 0 25 1987 410540 50 5200000 20000 0 0 0 0 1988 410540 50 6500000 23000 0 0 0 0 1989 410540 55 5600000 25000 0 0 0 0 1987 410544 30 19760 0 0 0 0 1988 410544 32 20280 10 0 0 1.25 1989 410544 34 20800 10 0 0 1.764706 1987 410546 153 1.00e+07 12500 8 0 0 .3660131 1988 410546 134 1.10e+07 13000 8 0 0 .358209 1989 410546 146 1.20e+07 13500 40 0 0 7.671233 1987 410547 20 2300000 20000 10 0 0 0 0 1988 410547 23 2500000 23000 10 0 0 0 0 1989 410547 25 3000000 25000 10 48 0 0 1.92 1987 410556 0 0 0 1988 410556 0 0 0 1989 410556 131 7588770 16640 0 0 0 0 1987 410560 22 725000 9000 0 0 0 0 1988 410560 25 785000 9000 0 0 0 0 1989 410560 23 785000 10000 0 0 0 0 1987 410561 6 501859 0 0 0 0 1988 410561 6 580415 0 0 0 0 1989 410561 9 735442 64 0 0 7.111111 1987 410562 15 4000000 32000 10 0 0 1.333333 1988 410562 18 5000000 34000 10 0 0 1.111111 1989 410562 19 7000000 38000 25 0 0 7.894737 1987 410563 73 5300000 21500 6 0 1 0 0 1988 410563 76 5800000 22200 7 0 1 0 0 1989 410563 80 6400000 23000 5 50 1 0 5 1987 410564 160 20000 4.3 20 0 0 1.875 1988 410564 150 21000 4.1 20 0 0 2.666667 1989 410564 150 22000 4 25 0 0 5.833333 1987 410565 90 20620 21 0 1 0 0 1988 410565 112 2.18e+07 20180 11 0 1 0 0 1989 410565 128 2.58e+07 21500 .4 16 1 0 16 1987 410566 14 2101581 14850 7 8 0 0 6.857143 1988 410566 16 2400723 18100 5 3 0 0 1.875 1989 410566 13 2470633 20500 4.5 4 0 0 3.076923 1987 410567 40 3000000 10000 1 .5 0 0 0 0 1988 410567 48 3800000 11000 .5 .25 0 0 0 0 1989 410567 50 3100000 11500 .28 .13 16 0 0 16 1987 410569 20 26000 0 0 0 0 1988 410569 24 28000 0 0 0 0 1989 410569 30 30000 0 0 0 0 1987 410571 17 755050 10400 .01 25 0 0 25 1988 410571 15 1102723 10400 .01 25 0 0 25 1989 410571 20 1073785 10400 .01 25 0 0 12.5 1987 410577 75 4750000 16120 1.68 1.89 3 0 0 1.2 1988 410577 80 5100000 16432 1.57 1.76 4 0 0 1.75 1989 410577 94 5500000 16640 1.64 1.82 4 0 0 1.489362 1987 410586 116 1.10e+07 23500 47 0 0 38.89655 1988 410586 114 1.10e+07 24000 47 0 0 38.75439 1989 410586 119 1.10e+07 24600 47 0 0 39.10084 1987 410591 25 12180 0 0 0 0 1988 410591 33 13000 50 0 0 1.515152 1989 410591 37 14500 40 0 0 2.162162 1987 410592 20 30 40 0 0 1988 410592 20 24 27 0 0 1989 410592 10 20 15 0 0 1987 410593 5 3500000 1 0 0 0 0 1988 410593 5 3800000 1 0 0 0 0 1989 410593 5 4000000 1 0 0 0 0 1987 410596 8 990400 12480 10 10 0 0 10 1988 410596 16 1166100 13520 6 12 0 0 12 1989 410596 20 1815900 14560 4 14 0 0 14 1987 410603 10 1212478 12700 105 0 0 42 1988 410603 14 1159622 13600 105 0 0 22.5 1989 410603 17 1612170 14900 0 0 1987 410604 60 8320 0 0 0 0 1988 410604 100 8940 0 0 0 0 1989 410604 190 10400 0 0 0 0 1987 410606 124 1.05e+07 .66 10 0 0 3.467742 1988 410606 127 1.22e+07 14538 .34 8 0 0 1.889764 1989 410606 128 1.20e+07 14865 .39 28 0 0 19.03125 1987 410609 22 1650831 24900 0 0 0 0 1988 410609 37 1817961 23000 0 0 0 0 1989 410609 44 1642441 23200 0 0 0 0 1987 410612 60 7000000 8840 12 0 0 12 1988 410612 65 8500000 9880 12 0 0 12 1989 410612 70 1.10e+07 10920 12 0 0 12 1987 410626 27 4600000 18000 .87 24 1 0 2.666667 1988 410626 28 4900000 19000 .82 16 1 0 1.142857 1989 410626 30 5600000 21000 .71 32 1 0 6.4 1987 410627 25 2900000 21830 1 0 1988 410627 25 2800000 22454 1 0 1989 410627 25 2900000 23078 1 0 1987 410629 16 1100000 18500 1.2 .58 0 0 1988 410629 19 2050000 21000 .53 .25 0 0 1989 410629 23 2260000 23500 .49 .36 0 0 1987 410635 100 2.00e+07 22000 0 1 0 0 1988 410635 95 1.80e+07 22000 1 1 0 .0105263 1989 410635 85 1.60e+07 22000 20 1 0 11.76471 1987 410636 8 386807 14110 0 0 1988 410636 10 734613 14040 0 0 1989 410636 8 518842 14126 0 0 1987 410639 135 1.40e+07 20384 1 1 0 .3703704 1988 410639 135 1.50e+07 20800 3 1 0 1.666667 1989 410639 144 1.55e+07 20592 5 1 0 3.472222 1987 410640 13 1656000 19266 240 0 0 55.38462 1988 410640 11 1527000 20867 200 0 0 36.36364 1989 410640 13 1454000 25154 200 0 0 30.76923 1987 410641 3600000 0 0 1988 410641 3900000 0 0 1989 410641 5200000 0 0 1987 410642 0 0 0 1988 410642 45 0 0 1989 410642 45 0 0 1987 410649 30 2100000 25500 0 0 1988 410649 27 2252000 26000 0 0 1989 410649 24 1866064 28000 0 0 1987 410653 14 1950000 16000 1.06 1 0 1988 410653 13 1850000 17000 1.03 1 0 1989 410653 12 1550000 18000 1.14 1 0 1987 410665 .05 .06 0 0 0 1988 410665 12 1000000 29120 .08 .03 16 0 0 2.666667 1989 410665 14 1200000 29120 .03 .09 16 0 0 4.571429 1987 410679 30 26000 3 0 0 1988 410679 30 26000 3 0 0 1989 410679 28 27000 3 0 0 1987 410680 27 2873000 19762 100 0 0 51.85185 1988 410680 61 6097000 21120 50 0 0 4.098361 1989 410680 52 5670000 22360 70 0 0 12.11539 1987 410685 24 2213235 20004 .14 0 0 1988 410685 20 2100943 19078 .16 0 0 1989 410685 20 2174049 21099 .23 0 0 1987 410686 6 2100000 16640 0 0 0 0 1988 410686 7 1800000 18720 10 0 0 2.857143 1989 410686 6 1600000 20800 0 0 0 0 1987 418006 63 25900 0 0 0 0 1988 418006 57 25300 45 0 1 18.94737 1989 418006 59 26800 40 0 0 23.72881 1987 418007 26 2200000 10712 1.9 1 0 1988 418007 24 1800000 10940 2.6 1 0 1989 418007 21 1700000 11148 1.2 1 0 1987 418008 10 900000 0 0 0 0 1988 418008 10 1200000 16 0 1 16 1989 418008 12 1100000 20000 0 0 0 0 1987 418011 70 4200000 12400 10 9 0 1 0 0 1988 418011 50 3740000 13400 3 3 43 1 1 8.6 1989 418011 30 2040000 14000 2 1 40 1 0 6.666667 1987 418013 20 750000 14560 .27 40 0 0 4 1988 418013 18 800000 16640 .25 60 0 1 10 1989 418013 20 950000 17680 .21 40 0 0 6 1987 418014 9 6802180 13478 256 0 0 56.88889 1988 418014 12 936477 14269 281 0 1 163.9167 1989 418014 17 1437883 15558 256 0 0 75.29412 1987 418021 11 1850000 12500 1 1 0 0 0 0 1988 418021 13 2078000 13100 1 1 40 0 1 6.153846 1989 418021 13 2040000 13800 1 1 10 0 0 1.538462 1987 418024 40 5500000 10400 0 0 0 0 1988 418024 60 6000000 10400 40 0 1 38 1989 418024 100 7000000 11020 20 0 0 2 1987 418035 30 1269000 14000 6 12 0 0 0 0 1988 418035 30 1681000 14500 5 11 23 0 1 18.4 1989 418035 31 1814000 15000 3 9 0 0 0 0 1987 418036 485 17888 10 0 0 .3092783 1988 418036 500 18637 46 0 1 2.208 1989 418036 525 19386 10 0 0 .2857143 1987 418045 15 2000000 18000 2 1 30 0 0 4 1988 418045 15 2500000 20000 2 1 40 0 0 8 1989 418045 15 3500000 22000 2 1 150 0 0 150 1987 418046 15 13000 0 0 0 0 1988 418046 20 12000 24 0 1 24 1989 418046 25 12000 4 0 0 4 1987 418051 .45 .14 25 1 0 1988 418051 .5 .17 13 1 1 1989 418051 .5 .17 20 1 0 1987 418052 6 400000 25861 0 0 0 0 1988 418052 5 500000 25168 55 0 1 55 1989 418052 7 600000 23625 0 0 0 0 1987 418054 60 3330457 11500 1.25 0 0 0 0 1988 418054 65 3765312 12500 1.54 40 0 1 1.846154 1989 418054 56 3533090 13200 .96 10 0 0 0 1987 418065 259 2.69e+07 15038 1.3 .5 6 1 0 3.474904 1988 418065 331 3.22e+07 15434 1.5 .7 21 1 1 15.48036 1989 418065 321 3.10e+07 16307 1 .7 6 1 0 3.364486 1987 418066 35 2 0 0 2 1988 418066 34 0 1 1989 418066 36 3 0 0 3 1987 418076 60 3870000 19968 1.06 2 50 0 0 16.66667 1988 418076 70 3882000 20800 .8 1.5 52 0 1 30.45714 1989 418076 70 5330000 21840 .22 .5 50 0 0 14.28571 1987 418083 125 2.60e+07 20000 3 .05 0 1 0 0 1988 418083 120 3.60e+07 20000 2 0 1 1 1989 418083 60 2.20e+07 20000 1 .03 32 1 0 10.66667 1987 418084 40 1200000 10000 200 1 0 30 1988 418084 35 1100000 10300 1 1 1989 418084 50 1300000 10700 200 1 0 24 1987 418091 150 1.10e+07 12000 8.18 10 0 0 1.333333 1988 418091 175 1.50e+07 14000 .67 30 0 1 12.68571 1989 418091 200 1.80e+07 16000 .56 20 0 0 5 1987 418097 80 6000000 12480 1.67 15 5 0 0 .3125 1988 418097 150 7700000 14560 1.17 12 30 0 1 2.8 1989 418097 120 5643000 16640 1.42 10 0 0 0 0 1987 418098 15 9360 0 0 0 0 1988 418098 18 10400 40 0 1 40 1989 418098 22 13520 80 0 0 10.90909 1987 418107 10 307501 8500 .98 10 0 0 10 1988 418107 25 1961818 9000 .51 83 0 1 83 1989 418107 34 2650786 9400 .45 15 0 0 13.23529 1987 418109 6 600000 16640 200 0 0 100 1988 418109 12 820000 18304 290 0 1 120.8333 1989 418109 14 1200000 19552 320 0 0 91.42857 1987 418118 16 1608573 35000 1 10 5 0 0 3.125 1988 418118 16 1342236 38000 .5 5 25 0 1 25 1989 418118 16 1504283 41000 .1 1 5 0 0 3.125 1987 418124 15 1600000 12000 0 0 0 0 1988 418124 20 1800000 13000 40 0 1 18 1989 418124 26 2000000 16000 8 0 0 1.846154 1987 418125 72 1.05e+07 17700 .45 10 0 0 9.305555 1988 418125 128 1.54e+07 19350 .61 31 0 1 31 1989 418125 168 2.30e+07 23250 .6 14 0 0 9 1987 418126 60 5600000 23000 30 0 0 5 1988 418126 50 6200000 25000 48 0 1 48 1989 418126 48 6300000 27000 30 0 0 3.75 1987 418140 17 8 0 0 0 0 1988 418140 23 4 80 0 1 80 1989 418140 20 2.5 40 0 0 12 1987 418147 15 726833 9048 0 0 0 0 1988 418147 80 4005963 10088 40 0 0 20 1989 418147 30 2089704 10504 0 0 0 0 1987 418163 72 7742994 18305 9 0 1 0 0 1988 418163 70 8273868 19828 7 40 1 1 40 1989 418163 68 8329656 17893 6.5 0 1 0 0 1987 418168 7 5449674 .01 40 0 0 40 1988 418168 7 6131102 .11 40 0 0 40 1989 418168 8 7332464 .2 0 0 0 0 1987 418177 120 1.00e+07 28080 18 3 20 1 0 0 1988 418177 120 1.20e+07 28080 19 3 26 1 1 26 1989 418177 120 1.10e+07 28080 18 3 14 1 0 14 1987 418183 21 14800 2.4 0 0 1988 418183 25 1800000 15100 2.79 0 0 1989 418183 30 2100000 16500 2 0 0 1987 418185 31 2000000 30000 0 0 1988 418185 47 2200000 30000 0 0 1989 418185 32 1800000 30000 0 0 1987 418213 25 1400000 14000 10 0 0 1.2 1988 418213 30 1680000 16000 0 1 1989 418213 39 2806000 17000 12 0 0 1.230769 1987 418220 19 580000 8840 0 0 0 0 1988 418220 21 660000 9360 39 0 1 39 1989 418220 30 984000 10720 0 0 0 0 1987 418225 15 1300000 13000 0 1 0 0 1988 418225 18 1600000 14040 10 1 1 10 1989 418225 28 2300000 15080 0 1 0 0 1987 418229 6 490000 14560 0 0 0 0 1988 418229 7 580000 15600 0 0 0 0 1989 418229 8 660000 16640 0 0 0 0 1987 418237 28 4568907 19042 .28 0 1 0 0 1988 418237 28 4904008 19845 .2 12 1 1 6 1989 418237 29 5884603 20426 .19 10 1 0 1.37931 1987 418239 80 6900000 13728 .22 20 0 0 5 1988 418239 65 8400000 14664 .24 20 0 0 7.692307 1989 418239 75 7100000 15600 .42 20 0 0 8 1987 418243 12 15000 0 0 0 0 1988 418243 14 15000 0 0 0 0 1989 418243 15 16000 0 0 0 0 1987 418245 25 3000000 20000 0 0 0 0 1988 418245 30 4000000 25000 0 0 0 0 1989 418245 40 6000000 30000 0 0 0 0 1987 419198 17 1083644 24000 7 10 56 0 0 19.76471 1988 419198 13 851605 24000 5 8 88 0 1 88 1989 419198 9 885852 16000 4 7.5 56 0 0 6.222222 1987 419201 20 3499895 14560 2 0 0 0 0 1988 419201 17 4008997 16848 2 24 0 0 8.470589 1989 419201 13 3379103 18720 2 0 0 0 0 1987 419242 70 6400000 16141 3.97 6 1 0 5.142857 1988 419242 65 6800000 16578 3.83 36 1 1 36 1989 419242 30 2100000 16952 5.7 4 1 0 4 1987 419268 6 564694 22866 1.39 1.39 0 0 0 0 1988 419268 6 620439 22995 1.16 1.16 0 0 0 0 1989 419268 6 783261 29114 .9 .9 32 0 1 32 1987 419272 35 4200000 31000 20.5 3.03 60 0 0 10.28571 1988 419272 40 4800000 33000 24 4.17 10 0 0 2 1989 419272 43 5200000 34800 17 1.88 80 0 1 80 1987 419275 15 930000 30000 100 0 0 26.66667 1988 419275 18 980000 33000 100 0 0 27.77778 1989 419275 21 1500000 35000 150 0 1 71.42857 1987 419276 12 1200000 28000 0 0 1988 419276 10 1300000 30000 0 0 1989 419276 8 1100000 30000 0 0 1987 419289 13 1200000 18720 1.5 0 0 0 0 1988 419289 14 1350000 20800 1.41 0 0 0 0 1989 419289 15 1480000 29120 .95 72 0 1 72 1987 419297 150 2.27e+07 22006 .2 .4 50 1 0 33.33333 1988 419297 178 3.08e+07 22027 .31 .32 40 1 0 13.48315 1989 419297 171 2.84e+07 24107 .27 .48 20 1 0 4.678362 1987 419298 80 1.00e+07 33280 0 1 0 0 1988 419298 70 9000000 32240 0 1 0 0 1989 419298 65 9500000 30784 40 1 1 36.92308 1987 419302 333 22360 0 0 0 0 1988 419302 340 22360 8 0 0 .5647059 1989 419302 337 22526 12 0 1 12 1987 419303 6 875000 13500 1.5 0 0 0 0 1988 419303 8 1.59e+07 14100 1 20 0 0 5 1989 419303 11 2250000 15050 1.25 75 0 1 75 1987 419305 5 0 1 0 0 1988 419305 5 0 1 0 0 1989 419305 5 9 1 1 9 1987 419307 262 1.81e+07 22360 1 1.09 0 0 0 0 1988 419307 264 1.93e+07 23026 .85 1.07 24 0 0 .2727273 1989 419307 302 2.22e+07 21736 .89 1.07 44 0 1 44 1987 419309 6 600000 24960 .33 15 0 0 15 1988 419309 9 750000 28080 .4 20 0 0 20 1989 419309 12 1000000 30160 .4 55 0 1 55 1987 419312 60 5845000 21133 0 0 1988 419312 71 6927000 20904 0 0 1989 419312 97 1.10e+07 21445 0 0 1987 419319 60 40 0 0 40 1988 419319 69 50 0 0 50 1989 419319 78 50 0 0 50 1987 419328 27 2700000 0 1 0 0 1988 419328 27 2800000 0 1 0 0 1989 419328 27 2800000 12 1 1 12 1987 419335 57 8486927 40563 0 0 0 0 1988 419335 53 4327519 37429 40 0 0 7.54717 1989 419335 62 8533205 42583 40 0 0 3.225806 1987 419339 40 8000000 15000 .5 .3 0 1 0 0 1988 419339 40 8500000 15500 .59 .34 0 1 0 0 1989 419339 60 1.00e+07 17000 .45 .22 0 1 0 0 1987 419343 100 1.00e+07 15000 5 7 70 1 0 3.5 1988 419343 125 1.20e+07 16000 4 8 25 1 0 4.2 1989 419343 290 4.80e+07 18700 3 10 17 1 1 17 1987 419344 0 0 0 1988 419344 0 0 0 1989 419344 9 1000000 17000 0 0 0 0 1987 419347 0 0 0 1988 419347 8 0 0 1989 419347 13 0 1 1987 419351 12 18000 0 0 0 0 1988 419351 14 18000 15 0 0 0 1989 419351 14 19000 25 0 1 25 1987 419357 60 6870314 12750 2 2 50 0 0 50 1988 419357 65 7079852 11875 1 1 75 0 0 75 1989 419357 75 8040128 12625 .5 .5 120 0 1 120 1987 419375 2900000 0 0 0 1988 419375 2500000 25 0 0 1989 419375 3100000 140 0 1 1987 419376 32 6000000 15250 2 1 0 .3125 1988 419376 36 6100000 16290 4 1 0 1.111111 1989 419376 40 6300000 17370 38 1 1 38 1987 419378 20 2700000 10920 2.71 50 0 0 12.5 1988 419378 22 3100000 11856 1.52 75 0 0 40.90909 1989 419378 37 4700000 13520 1.34 154 0 1 154 1987 419379 201 23167 0 0 0 0 1988 419379 201 25929 0 0 0 0 1989 419379 237 24965 24 0 1 7.088608 1987 419380 45 1.00e+07 0 0 0 0 1988 419380 50 1.00e+07 0 0 0 0 1989 419380 55 1.20e+07 10 0 0 10 1987 419381 14 1585000 14560 .65 60 0 0 4.285714 1988 419381 11 1560000 19240 .55 0 0 0 0 1989 419381 12 1747000 20280 .38 50 0 1 50 1987 419384 50 24960 0 0 0 0 1988 419384 73 26520 0 0 0 0 1989 419384 83 28080 110 0 1 39.75904 1987 419388 40 2400000 16307 11 9 2 0 0 .5 1988 419388 36 2300000 16827 8 7 4 0 0 1.666667 1989 419388 33 2700000 17347 6 3 18 0 1 18 1987 419392 15 18000 0 0 1988 419392 18 19500 0 0 1989 419392 21 20900 0 0 1987 419400 6 373164 17680 170 0 0 56.66667 1988 419400 8 422611 17680 170 0 0 85 1989 419400 9 390210 17846 170 0 0 75.55556 1987 419401 62 5000000 29000 72 0 0 15.09677 1988 419401 74 6000000 34000 72 0 0 12.64865 1989 419401 82 8000000 39000 72 0 0 11.41463 1987 419406 1842243 0 0 1988 419406 2072633 0 0 1989 419406 2314928 0 0 1987 419409 75 8450000 13416 2.25 .5 20 0 0 10.66667 1988 419409 72 1.03e+07 15184 2.5 .5 26 0 0 26 1989 419409 75 1.02e+07 17451 2 .5 60 0 1 60 1987 419410 26 26667 14 100 0 0 23.07692 1988 419410 24 24856 10 100 0 0 33.33333 1989 419410 23 25280 9 120 0 1 120 1987 419420 19 1980000 15600 0 0 0 0 1988 419420 15 1600000 17160 0 0 0 0 1989 419420 12 1430000 18720 80 0 1 80 1987 419432 250 6000000 14352 5 3 0 0 1988 419432 290 1.80e+07 15184 4.8 3 0 0 1989 419432 350 5.40e+07 16432 5.2 4 0 0 1987 419433 19 1700000 16640 50 0 0 10.52632 1988 419433 19 2000000 17160 15 0 0 15 1989 419433 21 2200000 17680 49 0 1 25.66667 1987 419434 89 1.14e+07 14394 0 0 0 0 0 1988 419434 59 4748000 15454 .04 0 0 0 0 1989 419434 105 7175000 15558 .14 10 0 0 10 1987 419449 40 3317000 16640 30 0 0 30 1988 419449 55 3692000 16640 30 0 0 30 1989 419449 65 3252000 16640 30 0 0 6.923077 1987 419450 175 1.25e+07 9360 0 0 0 0 1988 419450 225 1.25e+07 10400 0 0 0 0 1989 419450 275 1.82e+07 11440 3 0 0 2.181818 1987 419459 110 1.51e+07 21000 1.67 .21 20 1 0 6.363636 1988 419459 125 1.60e+07 21000 2.5 .23 20 1 0 6.4 1989 419459 225 2.89e+07 21000 1.12 .15 20 1 0 14.22222 1987 419461 24 14800 0 0 0 0 1988 419461 23 15200 0 0 0 0 1989 419461 36 15800 40 0 1 33.33333 1987 419467 4 1494764 30000 80 0 0 80 1988 419467 5 2566104 31000 100 0 0 100 1989 419467 10 2191680 35000 100 0 0 100 1987 419472 120 13000 20 0 0 4.166667 1988 419472 100 13500 20 0 0 5 1989 419472 100 14000 60 0 1 60 1987 419473 18 0 1 0 0 1988 419473 18 3 1 0 3 1989 419473 18 35 1 1 35 1987 419479 0 0 0 1988 419479 30 1503906 15500 0 0 0 0 1989 419479 30 1360372 16500 20 0 0 8.666667 1987 419482 15 2.7 0 0 0 0 1988 419482 15 1000000 10000 2.59 0 0 0 0 1989 419482 18 1000000 10000 2.8 24 0 0 24 1987 419483 133 1.10e+07 13957 20 0 1 0 0 1988 419483 108 1.15e+07 14810 25 0 1 0 0 1989 419483 129 1.20e+07 14227 30 20 1 0 3.100775 1987 419486 80 7000000 16000 0 0 0 0 1988 419486 90 8500000 17000 0 0 0 0 1989 419486 100 9900000 18000 40 0 1 36 The jtrain.dta dataset contains information on job training, and other variables, at a variety of manufacturing facilities. Here is a list with brief definitions of the variables in the data. Please label your answers a., b., c., d., e.

1. year 1987, 1988, or 1989

2. fcode firm code number

3. employ # employees at plant

4. sales annual sales, $

5. avgsal average employee salary

6. scrap scrap rate (per 100 items)

7. rework rework rate (per 100 items)

8. tothrs total hours training

9. union =1 if unionized

10. grant =1 if received grant

11. totrain total employees trained

12. hrsemp tothrs/totrain

13. lscrap log(scrap)

14. lemploy log(employ)

15. lsales log(sales)

16. lrework log(rework)

17. lhrsemp log(1 + hrsemp)

18. lscrap_1 lagged lscrap; missing 1987

19. grant_1 lagged grant; assumed 0 in 1987

20. lavgsal log(avgsal)

Use the command "xtset fcode year" to inform STATA that this is a panel dataset.

Run a pooled regression of lhrsemp on lavgsal lscrap lsales union granta.

a. Report below the coefficient and p-value for lsales.

b. All else equal, a 1% decrease of avgsal leads to a ____ change in hrsemp.

Run a fixed effects regression with the same variables from above, where the fixed effects entities are the firms. For reasons that will be apparent below, I recommend using the dummy variable technique.

c. All else equal, when a firm gets a grant this will increase the lhrsemp by ____. The confidence interval for this increase is between ____ and _____.

d. The intercept for firm number 410567is ___.

e. One of the firms has been "omitted" from the analysis due to perfect multicollinearity. Determine precisely why this happened. (Hint: it actually has to do with the Union variable.)