Location Quotient Assignment: Hamilton County, Iowa
Location Quotient Examples
Hamilton LQ:
U.S. Jobs County Jobs LQ: Jobs Population LQ: TPI
111 Crop Farming 1,598,656 426
112 Livestock 1,323,972 890
113 Forestry & Logging 134,091 29
114 Fishing- Hunting & Trapping 100,823 16
115 Ag & Forestry Svcs 722,091 199
211 Oil & gas extraction 377,383 -
212 Mining 230,464 34
213 Mining services 223,117 -
221 Utilities 542,240 7
230 Construction 11,191,781 352
311 Food products 1,579,598 249
312 Beverage & Tobacco 197,054 -
313 Textile Mills 239,577 0
314 Textile Products 183,975 -
315 Apparel Mfg 311,748 -
316 Leather & Allied 49,096 11
321 Wood Products 602,635 220
322 Paper Manufacturing 484,927 -
323 Printing & Related 704,090 5
324 Petroleum & coal prod 111,048 -
325 Chemical Manufacturing 868,121 22
326 Plastics & rubber prod 808,757 2
327 Nonmetal mineral prod 501,625 10
331 Primary metal mfg 461,827 147
332 Fabricated metal prod 1,486,267 40
333 Machinery Mfg 1,160,030 41
334 Computer & oth electron 1,286,144 -
335 Electrical eqpt & appliances 443,947 2,177
336 Transportation eqpmt 1,733,836 -
337 Furniture & related prod 587,197 8
339 Miscellaneous mfg 741,521 35
42 Wholesale Trade 6,002,459 662
481 Air transportation 523,309 5
482 Rail Transportation 170,010 -
483 Water transportation 59,785 -
484 Truck transportation 1,892,154 154
485 Transit & ground passengers 591,722 16
486 Pipeline transportation 37,210 -
487 Sightseeing transportation 622,346 13
491 Postal service 1,062,215 44
492 Couriers & messengers 793,843 31
493 Warehousing & storage 630,321 123
441 Motor veh & parts dealers 1,927,632 56
442 Furniture & home furnishings 593,696 7
443 Electronics & appliances stores 526,377 8
444 Bldg materials & garden dealers 1,194,195 34
445 food & beverage stores 2,732,237 205
446 Health & personal care stores 1,043,175 40
447 Gasoline stations 843,814 226
448 Closting & accessories stores 1,418,085 26
451 Sports- hobby- book & music stores 770,856 32
452 General merch stores 2,683,448 65
453 Misc retailers 1,483,166 46
454 Non-store retailers 1,746,485 59
511 Publishing industries 1,005,542 64
512 Motion picture & sound recording 436,779 12
515 Broadcasting 1,507,100 36
518 Internet & data process svcs 442,577 -
522 Credit inmediation & related 1,031,405 15
523 Securities & other financial 1,852,006 13
524 Insurance carriers & related 2,779,960 35
525 Funds- trusts & other finan 241,890 -
521 Monetary authorities 1,880,597 108
531 Real estate 5,355,799 98
532 Rental & leasing svcs 1,036,058 27
533 Lessor of nonfinance intang assets 28,352 -
541 Professional- scientific & tech svcs 11,290,972 206
551 Management of companies 1,713,735 18
561 Admin support svcs 9,699,190 411
562 Waste mgmt & remediation svcs 353,068 38
611 Educational svcs 3,117,574 58
621 Ambulatory health care 6,106,798 194
622 Hospitals 4,109,311 -
623 Nursing & residential care 2,935,316 218
624 Social assistance 3,388,512 584
711 Performing arts & spectator sports 1,569,555 34
712 Museums & similar 106,273 1
713 Amusement- gambling & recreation 1,776,446 76
721 Accomodations 1,337,126 28
722 Food svcs & drinking places 10,776,848 341
811 Repair & maintenance 3,656,405 243
812 Personal & laundry svcs 2,081,097 27
813 Religious- grantmaking- & similar orgs 3,044,788 138
814 Private households 2,092,079 146
92 Government & non NAICs 22,587,169 1,237
Total Jobs 169,676,500 11,178
Total Population 2004
Total Personal Income 2004
Assignment 1 Answers
Transfer Income 2004
Nontransfer Income 2004
Transfer Income Differential
Basic Jobs:
LQ: Adjusted for
NonTransfer Basic Jobs: Basic Jobs: Basic Jobs: Basic Jobs: Transfer
Y Jobs Population TPI NonTransferY Payments
Basic Jobs:
Adjusted for
Basic Jobs: Basic Jobs: Basic Jobs: Basic Jobs: Transfer
Jobs Population TPI NonTransferY Payments
Total Basic
Jobs
Total
Nonbasic
Jobs
Multiplier
Economic Impacts
Initial Job
Loss
% Basic
%nonbasic
Nonbasic
Totals
Impacts
New Basic
Jobs
New Total
Jobs
New
Multiplier
Location Quotient Examples
Knox Co. LQ
U.S. Jobs Jobs LQ Jobs Population
111 Crop Farming 1,767,878 987 3.348 2.927
112 Livestock 1,248,714 305 1.464 1.280
113 Forestry & Logging 148,084 16 0.635 0.555
114 Fishing- Hunting & Trapping 128,572 0 0.000 0.000
115 Ag & Forestry Svcs 745,407 54 0.438 0.383
211 Oil & gas extraction 312,604 0 0.000 0.000
212 Mining 227,356 23 0.605 0.529
213 Mining services 193,196 0 0.000 0.000
221 Utilities 559,640 130 1.396 1.221
230 Construction 10,415,775 1,148 0.661 0.578
311 Food products 1,615,037 91 0.338 0.296
312 Beverage & Tobacco 206,520 0 0.000 0.000
313 Textile Mills 288,372 0 0.000 0.000
314 Textile Products 194,995 2 0.072 0.063
315 Apparel Mfg 380,155 187 2.946 2.575
316 Leather & Allied 55,955 0 0.000 0.000
321 Wood Products 597,617 82 0.826 0.722
322 Paper Manufacturing 527,304 160 1.816 1.587
323 Printing & Related 742,104 30 0.239 0.209
324 Petroleum & coal prod 115,856 0 0.000 0.000
325 Chemical Manufacturing 895,528 43 0.289 0.252
326 Plastics & rubber prod 836,899 369 2.641 2.309
327 Nonmetal mineral prod 514,918 100 1.163 1.017
331 Primary metal mfg 496,800 73 0.879 0.769
332 Fabricated metal prod 1,536,874 789 3.079 2.692
333 Machinery Mfg 1,214,484 81 0.400 0.350
334 Computer & oth electron 1,454,678 8 0.032 0.028
335 Electircal eqpt & appliances 492,286 1,702 20.734 18.125
336 Transportation eqpmt 1,785,253 50 0.168 0.147
337 Furniture & related prod 610,522 4 0.042 0.037
339 Miscellaneous mfg 762,609 20 0.155 0.135
42 Wholesale Trade 5,899,209 792 0.806 0.704
481 Air transportation 562,017 0 0.000 0.000
482 Rail Transportation 169,930 1 0.035 0.031
483 Water transportation 58,071 0 0.000 0.000
484 Truck transportation 1,886,801 415 1.318 1.152
485 Transit & ground passengers 561,373 44 0.475 0.416
486 Pipeline transportation 41,705 0 0.000 0.000
487 Sightseeing transportation 579,169 30 0.313 0.274
491 Postal service 823,738 100 0.727 0.635
492 Couriers & messengers 776,025 44 0.341 0.298
493 Warehousing & storage 576,623 128 1.335 1.167
441 Motor veh & parts dealers 2,094,516 371 1.062 0.928
442 Furniture & home furnishings 620,619 84 0.807 0.706
443 Electronics & appliances stores 579,550 195 2.020 1.766
444 Bldg materials & garden dealers 1,264,260 210 0.995 0.870
445 food & beverage stores 3,048,271 848 1.667 1.458
446 Health & personal care stores 1,106,520 142 0.768 0.671
447 Gasoline stations 940,781 194 1.240 1.084
448 Closting & accessories stores 1,462,679 84 0.344 0.301
451 Sports- hobby- book & music stores 831,719 72 0.519 0.454
452 General merch stores 2,864,095 758 1.586 1.387
453 Misc retailers 1,622,857 177 0.653 0.571
454 Non-store retailers 1,590,665 1,398 5.272 4.609
511 Publishing industries 1,024,296 90 0.528 0.462
512 Motion picture & sound recording 425,993 26 0.366 0.320
515 Broadcasting 1,616,300 227 0.843 0.737
518 Internet & data process svcs 487,509 10 0.118 0.103
522 Credit inmediation & related 888,850 16 0.105 0.092
523 Securities & other financial 1,925,386 29 0.089 0.078
524 Insurance carriers & related 2,720,668 164 0.361 0.315
525 Funds- trusts & other finan 248,626 7 0.178 0.155
521 Monetary authorities 1,799,763 366 1.219 1.066
531 Real estate 4,715,922 346 0.440 0.384
532 Rental & leasing svcs 1,016,140 140 0.829 0.724
533 Lessor of nonfinance intang assets 30,334 0 0.000 0.000
541 Professional- scientific & tech svcs 10,846,432 600 0.332 0.290
551 Management of companies 1,722,839 25 0.088 0.077
561 Admin support svcs 8,992,700 970 0.647 0.566
562 Waste mgmt & remediation svcs 342,829 34 0.591 0.517
611 Educational svcs 2,868,579 579 1.211 1.058
621 Ambulatory health care 5,668,539 1,077 1.139 0.996
622 Hospitals 3,940,399 1,007 1.532 1.340
623 Nursing & residential care 2,800,908 1,607 3.442 3.009
624 Social assistance 3,184,413 1,181 2.225 1.945
711 Performing arts & spectator sports 1,504,978 3 0.010 0.009
712 Museums & similar 103,317 0 0.000 0.000
713 Amusement- gambling & recreation 1,692,659 190 0.673 0.588
721 Accomodations 1,312,712 139 0.633 0.553
722 Food svcs & drinking places 10,090,404 1,940 1.153 1.008
811 Repair & maintenance 3,603,132 458 0.762 0.666
812 Personal & laundry svcs 2,005,325 226 0.675 0.590
813 Religious- grantmaking- & similar orgs 3,001,269 632 1.262 1.104
814 Private households 1,991,014 332 1.000 0.875
92 Government & non NAICs 22,625,582 2,758 0.731 0.639
Total Jobs 166,230,999 27,719
Total Population (2002) 287,941,220 54,924
Total Income (2002) 8,869,809,000 1,309,098
All Transfers 1,286,341,000 310,201
Non Transfer Income 7,583,468,000 998,897
Percent Transfers 14.5% 23.7%
Transfer income differential 9.2%
LQ Total LQ Non- Base Jobs: Total Base Jobs: Non-
Personal Transfer Base Jobs: Base Jobs: Personal Income Transfer Income
Income Income Jobs LQ Population LQ LQ LQ
3.783 4.239 692 650 726 754
1.654 1.853 97 67 121 140
0.718 0.804 0 0 0 0
0.000 0.000 0 0 0 0
0.495 0.554 0 0 0 0
0.000 0.000 0 0 0 0
0.684 0.766 0 0 0 0
0.000 0.000 0 0 0 0
1.578 1.768 37 24 48 57
0.747 0.837 0 0 0 0
0.382 0.429 0 0 0 0
0.000 0.000 0 0 0 0
0.000 0.000 0 0 0 0
0.081 0.091 0 0 0 0
3.329 3.730 123 114 131 137
0.000 0.000 0 0 0 0
0.933 1.046 0 0 0 4
2.051 2.298 72 59 82 90
0.270 0.302 0 0 0 0
0.000 0.000 0 0 0 0
0.326 0.365 0 0 0 0
2.984 3.344 229 209 245 258
1.314 1.472 14 2 24 32
0.994 1.113 0 0 0 7
3.479 3.898 533 496 562 587
0.452 0.507 0 0 0 0
0.036 0.041 0 0 0 0
23.425 26.248 1620 1608 1629 1637
0.190 0.212 0 0 0 0
0.048 0.053 0 0 0 0
0.175 0.196 0 0 0 0
0.910 1.020 0 0 0 15
0.000 0.000 0 0 0 0
0.040 0.045 0 0 0 0
0.000 0.000 0 0 0 0
1.489 1.668 100 55 136 166
0.537 0.602 0 0 0 0
0.000 0.000 0 0 0 0
0.354 0.396 0 0 0 0
0.821 0.920 0 0 0 0
0.386 0.432 0 0 0 0
1.508 1.690 32 18 43 52
1.200 1.344 22 0 62 95
0.912 1.022 0 0 0 2
2.283 2.558 99 85 110 119
1.124 1.259 0 0 23 43
1.884 2.111 339 266 398 446
0.867 0.972 0 0 0 0
1.401 1.569 38 15 56 71
0.389 0.436 0 0 0 0
0.586 0.657 0 0 0 0
1.792 2.008 280 211 335 380
0.738 0.826 0 0 0 0
5.957 6.674 1133 1095 1164 1189
0.597 0.669 0 0 0 0
0.413 0.463 0 0 0 0
0.952 1.067 0 0 0 14
0.133 0.149 0 0 0 0
0.119 0.133 0 0 0 0
0.101 0.113 0 0 0 0
0.408 0.457 0 0 0 0
0.201 0.225 0 0 0 0
1.377 1.543 66 22 100 129
0.497 0.556 0 0 0 0
0.936 1.049 0 0 0 7
0.000 0.000 0 0 0 0
0.375 0.420 0 0 0 0
0.099 0.111 0 0 0 0
0.731 0.819 0 0 0 0
0.668 0.748 0 0 0 0
1.368 1.533 101 32 156 201
1.287 1.443 132 0 240 330
1.731 1.940 350 255 425 488
3.889 4.357 1140 1073 1194 1239
2.513 2.816 650 574 711 762
0.011 0.013 0 0 0 0
0.000 0.000 0 0 0 0
0.760 0.852 0 0 0 0
0.715 0.801 0 0 0 0
1.303 1.459 257 15 451 611
0.861 0.965 0 0 0 0
0.763 0.855 0 0 0 0
1.426 1.598 131 59 189 236
1.130 1.267 0 0 38 70
0.826 0.925 0 0 0 0
8287 7004 9398 10368
Base
Multipliers: 3.345 3.957 2.949 2.673
Initial Impact
Steps
Shock to Total Loss =
Economy Nonbasic+(basic *
New Basic Recalculate basic
New Total Recalculate total
Recalculate
New Multiplier multiplier
Base Jobs Add
Adjustment for Adjustment to
Transfer Income Jobs Basis Assumption Assumption
692 Y 987
97 Y 305
0 Y 16
0 Y 0
0 Y 54
0 Y 0
0 Y 23
0 Y 0
37 N 0
0 N 0
0 Y 91
0 Y 0
0 Y 0
0 Y 2
123 Y 187
0 Y 0
0 Y 82
72 Y 160
0 Y 30
0 Y 0
0 Y 43
229 Y 369
14 Y 100
0 Y 73
533 Y 789
0 Y 81
0 Y 8
1620 Y 1702
0 Y 50
0 Y 4
0 Y 20
0 N 0
0 0 N 0
0 N 0
0 N 0
100 N 0
0 N 0
0 N 0
0 N 0
9 9 N 0
0 N 0
32 N 0
34 56 N 0
8 8 N 0
18 117 N 0
19 19 N 0
78 417 N 0
13 13 N 0
18 55 N 0
8 8 N 0
7 7 N 0
70 350 N 0
16 16 N 0
129 1262 N 0
8 8 Y 90
2 2 Y 26
21 21 Y 227
1 1 Y 10
1 1 N 0
3 3 N 0
15 15 N 0
1 1 N 0
34 99 N 0
32 32 N 0
13 13 N 0
0 0 N 0
55 55 N 0
2 2 N 0
89 89 N 0
3 3 N 0
53 154 N 0
99 231 N 0
93 442 N 0
148 1288 N 0
109 759 N 0
0 0 Y 3
0 0 Y 0
17 17 Y 190
13 13 Y 139
178 436 N 0
42 42 N 0
21 21 N 0
58 189 N 0
31 31 N 0
254 254 N 0
1821 10108 5859
2.742 4.731
1702
4,441
8,731
23,278
2.67