Arizona Supply Chain Analysis October 2005 PREPARED FOR: ARIZONA DEPARTMENT OF COMMERCE OFFICE OF ECONOMIC INFORMATION AND RESEARCH 1700 W. WASHINGTON, SUITE 600 PHOENIX, AZ 85007 PREPARED BY: APPLIED ECONOMICS 4648 E. SHEA BOULEVARD, SUITE A-260 PHOENIX, AZ 85028 CHABIN CONCEPTS 2889 COHASSET ROAD, SUITE 5 CHICO, CA 95973 Table of Contents Executive Summary .............................................................................................................................. i 1.0 Introduction ................................................................................................................................ 1 2.0 Secondary Data Analysis ............................................................................................................ 3 Identification of Suppliers by Industry............................................................................... 3 Representation of Industries of Opportunity in Arizona .................................................... 4 Arizona Supplier Gaps ....................................................................................................... 5 County Level Commodity Production ............................................................................... 13 Survey Sample Selection and Design .......................................................................................... 16 Identification of Survey Participants.................................................................................. 16 Survey Design .................................................................................................................... 17 Survey Launch and Promotion........................................................................................... 17 Survey Results ............................................................................................................................ 18 Respondent Profile ............................................................................................................. 18 Purchasing Decisions ......................................................................................................... 20 Location of Purchases ........................................................................................................ 23 Types of Purchases............................................................................................................. 24 Other Issues and Comments............................................................................................... 27 Comparison of Survey Results to Secondary Data ............................................................ 28 Models to Connect Buyers and Suppliers ................................................................................... 30 AZBusinessLinc................................................................................................................. 30 Connectory ......................................................................................................................... 32 FOCUS............................................................................................................................... 33 APPENDICES ...................................................................................................................................... 34 3.0 4.0 5.0 Appendix A – National Suppliers............................................................................................. 34 Appendix B – Arizona Share of Employment and Output ....................................................... 47 Appendix C – Arizona Supplier Gaps ...................................................................................... 56 Appendix D – Commodity Production by County ................................................................... 70 Appendix E – On-Line Survey ................................................................................................. 75 Appendix F – Personal Interview Script................................................................................... 86 i ii Executive Summary The purpose of this analysis is to identify supplier gaps in Arizona based on secondary data as well as a statewide buyer survey. The buyer survey includes results from a web-based questionnaire, as well as personal interviews. The analysis is structured around twelve industries of opportunity identified in “Arizona’s Economic Future,” prepared by Economy.com in August 2002. The following summarizes the findings from both the secondary data analysis and the buyer survey. Supplier Gaps • Electronic components, steel and other primary metals and specialized scientific supplies were noted as supplier gaps in both the survey and the secondary data analysis. Electronic components are important in software, telecommunications, high tech instruments, aerospace, other high tech and industrial machinery manufacturing, according to the secondary data. Steel and primary metals are important for industrial machinery, and scientific supplies are important for high tech instruments. • Other gaps noted in the survey that were not apparent from the secondary data included window hardware, solenoids, locks, die casting magnets, office furniture, computers, power panels, batteries, chemicals and gases and optic lasers. Most of these items (with the exception of office furniture and computers) represent highly specialized products that may only be produced by a limited number of companies throughout the country. Alternatively, professional services were noted as a gap for many industries in the secondary data analysis, but not in the survey results. • It is generally the case that companies are buying more basic goods locally. These include office supplies and printing; local services such as security, building maintenance and food service; standard manufactured products and hardware (particularly fabricated metal products) and professional and business services. The types of products being purchased outside Arizona are typically more specialized. • In general, the demand from a particular industry group may not be large compared to total commodity production, but when added to demand from all other industries in Arizona there is a deficit. It is not clear from the secondary data whether that deficit is causing a problem for the industries of opportunity. However, it would appear from this analysis that Arizona is a net importer of many manufactured goods that are used by the industries of opportunity. Other Purchasing Issues In addition to identifying specific supplier gaps, the buyer survey included a variety of questions about purchasing methods and issues in identifying suppliers. • For the companies that responded to the survey, almost all indicated that most purchasing for their Arizona operations is done at a centralized facility located within the state. This is significant because it makes it easier for ADOC or local economic development organizations to develop relationships with local buyers. • Companies use a wide variety of methods to identify suppliers and potential suppliers. The most common was internet search, followed by firm records and previous contacts and i experience of the buyer. Often the methods used depend on the commodity or service being purchased and/or contract requirements. • Survey respondents were asked to rank a number of factors by level of importance that they use when choosing suppliers. Quality of the product was by far the most important to buyers with 96 percent of buyers ranking quality as most important or very important. Reliability of delivery was ranked most important or very important by 89 percent of buyers. Other key factors included price and service/maintenance. • About half of the survey respondents purchase less than 25 percent of their supplies outside Arizona. However, another 25 percent purchase at least half of their supplies outside the state. Seventy-four percent of the companies responding to the survey indicated they have no “buy local” policy in place. • It is difficult to say whether non-local purchases are occurring because products are not available in Arizona, or whether local suppliers are unable to meet other specific criteria. However, the primary reason the products and services that could be purchased in Arizona are not according to survey respondents is that companies cannot locate local suppliers. • In addition to reasons for not purchasing locally, buyers were asked what it would take for them to buy more supplies in Arizona. Availability appeared to be the biggest issue, particularly for specialized supplies and components and particularly outside of the metro areas. However, price was ranked only slightly below availability. Review of Programs to Connect Buyers and Suppliers One of the ways that buyer supplier relationships in Arizona could be strengthened is through a statewide program that would provide resources to allow buyers and local suppliers to identify each other more easily to and provide better feedback to suppliers enabling them to compete more effectively with nonlocal vendors. This study includes reviews of three such programs: AZBusinessLinc used in Tucson; Connectory which is a similar program used in California; and FOCUS which is used for government procurement in California. • AZBusinessLinc is an on-line supplier database owned by the City of Tucson that allows companies to enter a detailed profile that can be searched by potential buyers. The program is currently marketed to buyers through the efforts of a five person staff who meet regularly with large local companies to discuss current and anticipated procurement needs. The most appealing features of the database to these companies are speed and level of detail of the supplier selection criteria. The access to staff people from the City of Tucson who will do much of the leg work in identifying potential suppliers free of charge is also very important. The database is marketed to sellers exclusively through strategic partnerships with other cities, cluster organizations and chambers in the five-county Southern Arizona region. • Connectory.com is a business-to-business, buyer-supplier marketing and communication tool that covers the State of California. It provides a regional source for products, technologies, services, company capabilities, capacities and expertise. In addition to an on-line supplier directory, the Connectory web site also includes a bulletin board that has “want ads” for buyers and suppliers, listings of international trade opportunities, employment opportunities, venture funding opportunities, success stories and upcoming events. Connectory is funded through a ii variety of public and private sources including sponsorships and sales of banner ads on the web site. • FOCUS is California's only nationwide, local government-to-government purchasing program. It allows cities, counties, schools, special districts and other public entities to acquire technology products and services quickly and at competitive rates. The program does require vendors to pre-certify; however once they are part of the program they are able to circumvent future bidding processes. FOCUS gives local government access to pre-screened, competitively bid vendors in the technology industry, avoiding the expense and delay of a protracted government RFP process. Summary While there are clearly existing supplier gaps for some types of specialized commodities, it may not be feasible to expect that all these needs can be met locally. The key to increasing the volume of local transactions for products that are available locally and making Arizona suppliers more competitive appears to be increased communication between buyers and suppliers about specific buyer requirements, and better methods for identifying local suppliers that are able to meet those requirements. iii 1.0 Introduction The purpose of this analysis is to identify Arizona supplier gaps based on secondary data as well as a statewide buyer survey. The analysis is structured around twelve industries of opportunity identified in “Arizona’s Economic Future,” prepared by Economy.com in August 2002. The industries of opportunities listed below were selected based on three criteria: (1) national industry growth projections; (2) estimated relationships between historical regional industry growth and Arizona’s comparative advantages; (3) industries with qualities that would make them competitive in the changing international economy including technology based, highly productive, research intensive, linked to export markets, and consistent with local resources and Arizona’s diverse regional economies. The resulting opportunity industries for Arizona include the following: • • • • • • • • • • • • software and systems integration health care and biotech industrial machinery telecommunications high tech instruments forest products engineering research transportation and logistics agriculture, food processing and ag technology aerospace, avionics and defense other high tech industries local government Figure 1 shows the definition of each industry group by SIC, as determined by ADOC. For the purpose of this analysis, the SICs listed in Figure 1 were converted to NAICS. Some of these industries are emerging industries in Arizona, while others are more traditional. There is also a mix of industries that are more concentrated in rural areas of the state, versus those whose presence is predominantly in urban areas. Given the broad range of industry types, there is an equally broad range of suppliers. Figure 1-1 Definitions for Industries of Opportunity Industry Group SICs Computer Software and Systems Integration 737 Healthcare and Biotechnology 283 and 80, excluding 805, 808 Industrial Machinery 35, excluding 352, 357 Telecommunications 481, 489, 366 High Tech Instruments 382, 384, 385 Forest Products 08, 24, 26 Engineering Research 873 Transportation and Logistics 40, 42 Agriculture, Food Processing and Ag Technology 01, 07, 20, 352 Defense, Aerospace and Avionics 372, 376, 381 Other High Tech 365, 367, 386, 871 Local Government 91 The first part of the study includes an analysis of secondary data and provides a basis for identifying potential gaps in the supply chain. The results are presented in Chapter 2. The second part of the study 1 presents the results of a survey of Arizona buyer industries, described in Chapters 3 and 4. This two-fold survey included both a web-based version and personal phone interviews. The purpose was to evaluate the existence of supplier gaps within the industries of opportunity and identify barriers and challenges to connecting buyers with local suppliers. Chapter 5 discusses models that are currently used in Arizona and other locations to connect buyers and suppliers. 2 2.0 Secondary Data Analysis Identification of Suppliers by Industry The first step in the secondary data analysis is to identify suppliers to each of the industries of opportunity based on national input-output data. Using data from IMPLAN, a national vendor of input-output software, it is possible to identify the volume of purchases made by each industry by commodity. Detailed results for Arizona’s industries of opportunity are shown in Appendix A. In most cases, each industry group includes several sub-groups with distinctly different supplier requirements. Thus, in order to provide a more accurate analysis, the results are shown by industry subgroup. For each industry group, the distribution of major purchases by commodity is shown along with total commodity purchases and total industry output and employment nationally. The tables are intended to highlight the largest suppliers for each industry sub-group. In general, the demand from a particular industry group may not be large compared to total commodity production, but when added to demand from all other industries in Arizona there may be a deficit. It is not clear from the secondary data whether that deficit is causing a problem for the industries of opportunity. Note that input-output data used in this analysis distributes the value of production back to all contributing sectors. For example, if an industrial machinery manufacturer buys a component part from a wholesaler, some of the value of the part will be attributed to the wholesaler, some to transportation, some to the manufacturer of the part, and some to primary metal industries and other suppliers to the part manufacturer. In a typical local economy, not all of those industries will be present, so not all of the value of supplier purchases will be captured in the local economy. However, on a national basis, the vast majority of the purchase value can be distributed back to contributing sectors. The results on national purchasing patterns provide information on the relative importance of various suppliers as well as the overall size of each industry nationally. The volume of supply purchases by a given industry is of course directly proportional to the overall size of the industry. Thus, the fifth most important supplier to a very large industry may result in a larger volume of commodity purchases than the first most important supplier to a smaller industry. The overall size of each industry sub-group nationally can be compared based on employment and output. Top national suppliers by industry group are noted below: • • • • • • • • • software and systems integration – software publishers, advertising, telecommunications health care and biotech – pharmaceutical manufacturing, lessors of intangible assets industrial machinery – wholesale trade, iron and steel mills telecommunications – communications equipment, lessors of intangible assets, electronic components, telecommunications high tech instruments – wholesale trade, electronic components forest products – forest product nurseries, agricultural support, sawmills, paper mills engineering research – real estate, satellites transportation and logistics – machinery and equipment leasing, truck transportation, automotive repair and maintenance agriculture, food processing and ag technology – grain farming, all other crop farming, cattle ranching, animal food manufacturing, iron and steel mills, agricultural support 3 • • • aerospace, avionics and defense – electronic components, communication equipment, aircraft parts other high tech industries – wholesale trade, photographic film, electronic components, sound recording local government – other government entities, wholesale trade, telecommunications, real estate The input-output data used in this analysis does not provide detail on wholesale trade, which is a larger supplier to many industries. The volume of purchases from the wholesale sector is in part an indicator of the amount of purchasing that occurs through wholesalers as opposed to directly from manufacturers. More importantly, the volume of purchases in the wholesale sector only represents the markup or contribution of the wholesaler to the final cost of the product. At the state or local level, wholesale will represent larger share of total commodity purchases than at the national level because many of the original manufacturers will be located elsewhere. Another interesting pattern that emerges from the national input-output data is that industries frequently buy from closely related industries, perhaps within the same SIC. Since any given industry may produce several products or commodities, it is possible and in fact frequent that these types of purchasing patterns occur. So for example, some industries in the telecommunications group, such as resellers, purchase a large amount of telecommunication services. Thus, a buyer industry and one of its primary suppliers fall within the same SIC. Overall, the list of the largest suppliers to each industry group is fairly diverse. However, among the top ten or so suppliers to each group, there is a fair amount of crossover with multiple industries of opportunity relying on many of the same types of suppliers. Representation of Industries of Opportunity in Arizona The next step in the analysis is to determine the share of buyer industries nationally that are present in Arizona. In this case, Arizona’s share of national output by industry sub-group is used as a proxy for allocating the local share of supplier demand to the state. Output is a measure of the value of products or services being produced, based on a combination of labor costs, material costs and value added. Figure 2-1 shows Arizona’s share of output and employment by industry within each industry group. Additional detail is provided in Appendix B. 4 Figure 2-1 Arizona Share of Employment and Output Industries of Opportunity Industry Computer Software and Systems Integration Healthcare and Biotechnology Industrial Machinery Telecommunications High Tech Instruments Forest Products Engineering Research Transportation and Logistics Agriculture, Food Processing and Ag Technology Defense, Aerospace and Avionics Other High Tech Local Government Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $3,973 44,671 $15,501 143,558 $1,598 7,779 $5,086 25,625 $1,252 6,875 $1,666 11,756 $308 5,548 $2,955 22,363 $6,263 32,287 $9,493 37,265 $11,502 78,979 $10,012 140,789 National National Output* Employment $414,133 3,568,330 $1,045,985 9,020,752 $232,496 1,207,369 $452,925 1,645,249 $105,984 555,321 $263,854 1,327,784 $60,473 842,806 $235,685 1,803,349 $772,853 4,907,692 $168,743 647,779 $339,266 2,700,451 $540,280 8,809,610 Arizona Share Output Employment 1% 1% 1% 2% 1% 1% 1% 2% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 6% 6% 3% 3% 2% 2% In most cases, Arizona only represents 1 to 2 percent of both output and employment in each industry of opportunity, although there are a few key exceptions. Specific industries where Arizona represents a large share of national employment and/or output are listed below: • • • • • • Semiconductor machinery (5 percent of output and employment) Fluid meters and counting devices (7 percent of output, 6 percent of employment) Vegetable and melon farming (6 percent of output, 4 percent of employment) Aircraft engine and engine parts (8 percent of output and employment) Guided missile and space vehicle manufacturing (25 percent of output, 26 percent of employment) Semiconductors (11 percent of output, 12 percent of employment) Although all the industries above represent key industry specialties within Arizona, it is important to remember that some of them are relatively small in terms of employment nationally. Arizona just happens to have a high concentration of employment in that small industry. Examples of specific industries where this is the case include guided missile and space vehicle manufacturing, semiconductor manufacturing and aircraft engine parts. There are other more ubiquitous industries where Arizona only represents a small percentage of national employment, but given the overall size of the industry nationally, it translates into a large number of Arizona employees and sizeable supplier demand. Industries that fall into this category and employ 15,000 or more people in Arizona include custom computer programming, doctor’s offices, ambulatory health care, hospitals, telecommunications, truck transportation, and state and local government.1 Arizona Supplier Gaps Based on Secondary Data Analysis The next step in the supplier analysis is to compare demand for specific commodities to Arizona commodity production. By applying Arizona’s share of output to total national commodity purchases by 1 Semiconductor manufacturing also employs more than 15,000 people locally, but is more appropriately classified as a local industry specialty than a large ubiquitous industry. 5 industry, it is possible to estimate local commodity demand from the industries of opportunity in Arizona. Local (Arizona) commodity demand can then be compared to local commodity production to identify supplier gaps.2 Although it will never be the case that all local demand will be fulfilled by industries within Arizona, commodities that are being demanded by multiple local buyer industries are good targets for recruitment and expansion. Having a well developed supplier base is a cornerstone to building and sustaining Arizona’s industries of opportunity. Figures 2-2 through 2-13 show the comparison between local demand from the industries of opportunity in Arizona, demand from all industries in Arizona and commodity production for the top 15 suppliers to each industry group. Commodities in bold are those where total Arizona demand from all industries exceeds Arizona commodity production. Additional commodity detail is shown in Appendix C. Figure 2-2 Arizona Supplier Gaps for Software and Systems Integration Industries Millions of Dollars Supplier Industries Employment services Advertising and related services Telecommunications Real estate Office administrative services Wholesale trade Computer systems design services Lessors of nonfinancial intangible assets Software publishers Automotive repair and maintenance Services to buildings and dwellings All other electronic component manufacturing Data processing services Monetary authorities and depository intermediaries Colleges, universities, and junior colleges Top 15 Suppliers Reproduction Info Services Programming & & Publishing Data Processing Systems Design $15.04 $20.94 $55.26 $23.90 $32.26 $17.40 $12.04 $32.22 $26.20 $12.23 $14.89 $25.32 $7.21 $9.22 $23.73 $18.71 $10.99 $6.98 $1.83 $13.24 $20.94 $5.28 $2.81 $24.52 $27.91 $0.00 $0.00 $0.96 $9.04 $13.44 $3.66 $5.41 $13.83 $7.12 $4.28 $10.73 $0.60 $7.45 $14.04 $4.17 $5.25 $7.01 $3.27 $5.10 $7.70 Software Total $91.23 $73.56 $70.46 $52.44 $40.16 $36.68 $36.01 $32.60 $27.91 $23.44 $22.90 $22.14 $22.09 $16.43 $16.08 Total Commodity Purchases (millions) $195.42 $286.76 $385.26 $867.45 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps Arizona Arizona Commodity Demand Production* All Industries $3,260.78 $1,734.37 $2,266.81 $3,155.27 $4,352.27 $5,299.03 $16,370.19 $12,092.21 $909.59 $833.44 $12,912.26 $10,831.49 $677.91 $874.31 $6,494.93 $1,698.13 $634.67 $725.68 $5,808.50 $4,104.53 $1,345.64 $1,055.66 $1,059.60 $1,350.04 $737.31 $552.98 $4,115.69 $5,985.75 $390.97 $1,602.96 $106,501.53 $92,258.54 2 Local (Arizona) commodity production is defined as net commodity supply or industry commodity production plus non-industry commodity production less foreign exports. 6 Figure 2-3 Arizona Supplier Gaps for Healthcare and Biotech Industries Millions of Dollars Top 15 Suppliers Doctors & Healthcare/ Supplier Industries Pharmaceuticals Hospitals Biotech Total Real estate $0.61 $992.56 $993.17 Wholesale trade $22.74 $342.53 $365.27 Employment services $0.43 $318.08 $318.51 Legal services $1.50 $282.09 $283.59 Securities, commodity contracts, investments $0.38 $276.08 $276.46 Pharmaceutical and medicine manufacturing $32.26 $180.10 $212.37 Postal service $0.01 $188.47 $188.48 Management of companies and enterprises $15.82 $159.98 $175.80 Management consulting services $0.71 $172.22 $172.93 Food services and drinking places $0.88 $169.08 $169.96 Telecommunications $0.99 $147.47 $148.46 Plastics products $2.88 $136.44 $139.32 Office administrative services $0.14 $129.04 $129.18 Services to buildings and dwellings $0.18 $124.77 $124.95 Business support services $0.32 $121.36 $121.67 Arizona Arizona Commodity Demand Production* All Industries $16,370.19 $12,092.21 $12,912.26 $10,831.49 $3,260.78 $1,734.37 $2,141.72 $2,676.00 $2,751.35 $4,136.42 $338.40 $1,956.21 $1,012.70 $907.69 $1,857.85 $2,534.70 $1,643.20 $1,409.71 $7,694.15 $6,598.51 $4,352.27 $5,299.03 $751.03 $1,142.92 $909.59 $833.44 $1,345.64 $1,055.66 $1,862.11 $923.99 Total Commodity Purchases (millions) Source: Minnesota IMPLAN Group, 2001 data. $92,859.38 $166.16 $4,868.32 $5,034.48 $86,130.17 * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps Figure 2-4 Arizona Supplier Gaps for Industrial Machinery Industries Millions of Dollars Supplier Industries Wholesale trade Iron and steel mills Management of companies and enterprises Ferrous metal foundries Machine shops All other forging and stamping All other electronic component manufacturing Truck transportation Aluminum foundries Lessors of nonfinancial intangible assets AC, refrigeration and forced air heating Motor and generator manufacturing Speed changers, mechanical power transmission equipment Fabricated structural metal manufacturing Iron and steel forging Top 15 Suppliers Industrial Machinery $121.18 $48.06 $37.70 $35.13 $23.40 $16.56 $16.28 $16.19 $15.57 $15.27 $15.21 $14.83 $14.48 $13.51 $13.38 Arizona Commodity Production* $12,912.26 $129.70 $1,857.85 $77.50 $317.93 $157.65 $1,059.60 $2,435.78 $105.69 $6,494.93 $326.08 $20.74 $2.57 $220.88 $4.17 Arizona Demand All Industries $10,831.49 $571.25 $2,534.70 $174.04 $387.99 $159.59 $1,350.04 $2,524.18 $112.50 $1,698.13 $392.26 $115.95 $40.21 $297.18 $61.39 Total Commodity Purchases (millions) $615.64 $65,659.02 $62,994.37 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 7 Figure 2-5 Arizona Supplier Gaps for Telecommunications Industries Millions of Dollars Supplier Industries Telecommunications Architectural and engineering services Telephone apparatus manufacturing Advertising and related services Broadcast and wireless communications equipment Lessors of nonfinancial intangible assets Wholesale trade Accounting and bookkeeping services All other electronic component manufacturing Machinery and equipment rental and leasing Real estate Household goods repair and maintenance Specialized design services All other miscellaneous professional and technical Monetary authorities and depository intermediaries Top 15 Suppliers Communication Telecom- Telecomm Equipment munication Total $2.31 $641.54 $643.85 $4.60 $107.05 $111.65 $6.43 $85.93 $92.36 $2.23 $81.46 $83.68 $74.61 $0.22 $74.83 $36.54 $25.92 $62.45 $25.96 $30.26 $56.22 $0.87 $51.77 $52.64 $32.28 $13.44 $45.72 $0.55 $36.53 $37.08 $2.01 $28.10 $30.10 $0.09 $27.71 $27.80 $0.05 $26.23 $26.27 $2.29 $21.95 $24.24 $2.42 $21.03 $23.45 Total Commodity Purchases (millions) Source: Minnesota IMPLAN Group, 2001 data. $228.30 $1,283.82 $1,512.12 Arizona Arizona Commodity Demand Production* All Industries $4,352.27 $5,299.03 $2,998.84 $3,164.91 $140.47 $285.03 $2,266.81 $3,155.27 $423.20 $770.99 $6,494.93 $1,698.13 $12,912.26 $10,831.49 $1,006.87 $1,095.47 $1,059.60 $1,350.04 $1,219.21 $883.56 $16,370.19 $12,092.21 $490.64 $370.99 $354.96 $370.89 $837.48 $458.80 $4,115.69 $5,985.75 $68,707.49 $61,872.62 * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps Figure 2-6 Arizona Supplier Gaps for High Tech Instrument Industries Millions of Dollars Supplier Industries Wholesale trade All other electronic component manufacturing Management of companies and enterprises Business support services Surgical and medical instrument manufacturing Plastics products Advertising and related services Paperboard container manufacturing Electricity and signal testing instruments Legal services Textile and fabric finishing mills Architectural and engineering services Surgical appliance and supplies manufacturing Scientific research and development services Telecommunications Top 15 Suppliers High Tech Instruments $76.15 $38.96 $32.03 $21.32 $14.52 $12.73 $12.02 $9.14 $9.09 $9.08 $8.53 $8.25 $8.15 $7.90 $7.66 Arizona Commodity Production* $12,912.26 $1,059.60 $1,857.85 $1,862.11 $99.79 $751.03 $2,266.81 $217.73 $51.39 $2,141.72 $9.89 $2,998.84 $265.15 $304.99 $4,352.27 Arizona Demand All Industries $10,831.49 $1,350.04 $2,534.70 $923.99 $185.67 $1,142.92 $3,155.27 $449.75 $83.11 $2,676.00 $34.44 $3,164.91 $265.24 $1,204.19 $5,299.03 Total Commodity Purchases (millions) $395.15 $73,825.25 $68,807.41 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 8 Figure 2-7 Arizona Supplier Gaps for Forest Product Industries Millions of Dollars Top 15 Suppliers Logging & Wood Paper Supplier Industries Forest Pdts Products Products Wholesale trade $0.86 $80.70 $46.26 Sawmills $0.03 $110.91 $9.07 Logging $3.36 $94.44 $15.80 Paper and paperboard mills $0.00 $0.41 $93.82 Truck transportation $0.05 $29.70 $17.70 Forest nurseries, forest products and timber tracts $6.31 $33.63 $0.00 Automotive repair and maintenance $0.56 $11.30 $12.04 Management of companies and enterprises $0.13 $7.16 $15.21 Natural gas distribution $0.22 $4.81 $13.46 Power generation and supply $0.02 $8.83 $9.01 Miscellaneous wood product manufacturing $0.00 $16.05 $0.01 Pulp mills $0.00 $0.00 $13.68 Veneer and plywood manufacturing $0.00 $13.38 $0.03 Cut stock, resawing lumber and planing $0.00 $11.26 $0.01 Commercial machinery repair and maintenance $0.26 $5.20 $5.51 Forest Pdts Total $127.82 $120.00 $113.59 $94.24 $47.44 $39.94 $23.90 $22.50 $18.49 $17.86 $16.06 $13.68 $13.41 $11.27 $10.97 Arizona Arizona Commodity Demand Production* All Industries $12,912.26 $10,831.49 $22.65 $461.04 $26.71 $20.60 $113.96 $676.03 $2,435.78 $2,524.18 $20.84 $18.85 $5,808.50 $4,104.53 $1,857.85 $2,534.70 $1,074.38 $1,417.70 $4,919.68 $3,102.05 $44.47 $104.95 $6.05 $16.16 $1.59 $169.42 $10.10 $56.85 $834.42 $534.52 Total Commodity Purchases (millions) $18.40 $474.07 $294.48 $786.94 $53,883.37 $51,340.54 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps Figure 2-8 Arizona Supplier Gaps for Engineering Research Services Millions of Dollars Supplier Industries Guided missile and space vehicle manufacturing Real estate Employment services Glass and glass products- except glass containers Legal services Wholesale trade Commercial printing Telecommunications Office administrative services All other miscellaneous professional and technical Management consulting services Architectural and engineering services Periodical publishers Maintenance and repair of nonresidential buildings Broadcast and wireless communications equipment Top 15 Suppliers Engineering Services $19.96 $2.70 $1.72 $1.44 $1.18 $1.11 $1.09 $0.82 $0.80 $0.76 $0.69 $0.69 $0.64 $0.64 $0.60 Arizona Commodity Production* $2,890.32 $16,370.19 $3,260.78 $96.08 $2,141.72 $12,912.26 $491.89 $4,352.27 $909.59 $837.48 $1,643.20 $2,998.84 $138.07 $750.57 $423.20 Arizona Demand All Industries $1,173.37 $12,092.21 $1,734.37 $223.04 $2,676.00 $10,831.49 $566.54 $5,299.03 $833.44 $458.80 $1,409.71 $3,164.91 $331.27 $1,672.57 $770.99 Total Commodity Purchases (millions) $39.76 $70,539.47 $62,246.08 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production foreign exports. Industries in bold represent potential supplier gaps 9 Figure 2-9 Arizona Supplier Gaps for Transportation and Logistics Industries Millions of Dollars Supplier Industries Truck transportation Automotive repair and maintenance Scenic and sightseeing transportation and support Wholesale trade Petroleum refineries Insurance carriers Motor vehicle parts manufacturing Machinery and equipment rental and leasing Warehousing and storage Automotive equipment rental and leasing Telecommunications Management of companies and enterprises Real estate Management consulting services Rail transportation Top 15 Suppliers Rail Truck Transport Transport Transport Total $1.26 $269.76 $271.02 $0.01 $156.73 $156.74 $35.62 $101.57 $137.19 $9.23 $114.63 $123.86 $8.27 $112.23 $120.50 $0.14 $65.25 $65.40 $3.42 $43.51 $46.92 $34.85 $9.87 $44.72 $0.02 $37.75 $37.77 $0.29 $31.46 $31.75 $0.23 $28.02 $28.25 $0.00 $25.86 $25.86 $1.30 $22.42 $23.72 $4.35 $16.63 $20.98 $0.82 $16.77 $17.59 Arizona Arizona Commodity Demand Production* All Industries $2,435.78 $2,524.18 $5,808.50 $4,104.53 $697.27 $673.00 $12,912.26 $10,831.49 $42.77 $2,744.31 $3,859.06 $4,631.49 $797.02 $1,832.00 $1,219.21 $883.56 $475.31 $480.22 $3,017.58 $1,408.71 $4,352.27 $5,299.03 $1,857.85 $2,534.70 $16,370.19 $12,092.21 $1,643.20 $1,409.71 $333.58 $450.47 Total Commodity Purchases (millions) $155.75 $1,131.96 $1,287.72 $74,065.59 $67,271.70 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps Figure 2-10 Arizona Supplier Gaps for Agriculture, Food Processing and Ag Technology Industries Millions of Dollars Supplier Industries Cattle ranching and farming Wholesale trade Grain farming Other animal food manufacturing Real estate All other crop farming Agriculture and forestry support activities Poultry and egg production Truck transportation Animal production- except cattle and poultry Management of companies and enterprises Animal slaughtering, except poultry Paperboard container manufacturing Petroleum refineries Lessors of nonfinancial intangible assets Agriculture $156.87 $131.66 $121.09 $166.12 $172.66 $164.19 $164.45 $17.46 $31.13 $9.18 $0.00 $0.13 $1.94 $71.61 $0.00 Top 15 Suppliers Food Farm & Garden Processing Equipment $329.53 $0.00 $262.69 $22.05 $80.28 $0.00 $15.75 $0.00 $8.64 $0.40 $8.60 $0.00 $0.00 $0.00 $118.96 $0.00 $65.23 $5.53 $81.37 $0.00 $76.37 $4.97 $80.23 $0.00 $73.78 $0.19 $2.53 $0.13 $69.43 $0.09 Agriculture Total $486.41 $416.41 $201.37 $181.88 $181.70 $172.79 $164.45 $136.41 $101.89 $90.55 $81.34 $80.36 $75.91 $74.28 $69.52 Arizona Arizona Commodity Demand Production* All Industries $1,139.49 $733.50 $12,912.26 $10,831.49 $37.22 $178.98 $70.47 $116.48 $16,370.19 $12,092.21 $173.30 $244.25 $493.87 $198.88 $13.35 $72.20 $2,435.78 $2,524.18 $40.12 $185.16 $1,857.85 $2,534.70 $379.52 $580.29 $217.73 $449.75 $42.77 $2,744.31 $6,494.93 $1,698.13 Total Commodity Purchases (millions) $1,519.56 $1,948.75 $126.31 $3,594.62 $75,991.61 $73,510.19 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 10 Figure 2-11 Arizona Supplier Gaps for Aerospace, Avionics and Defense Industries Millions of Dollars Supplier Industries Wholesale trade Other aircraft parts and equipment Search, detection and navigation instruments Aircraft engine and engine parts manufacturing Broadcast and wireless communications equipment Guided missile and space vehicle manufacturing All other electronic component manufacturing Management of companies and enterprises Propulsion units and parts for space vehicles Architectural and engineering services Scientific research and development services Metal valve manufacturing Monetary authorities and depository intermediaries Miscellaneous fabricated metal products Plastics products Top 15 Suppliers Search & Nav. Aircraft and Instruments Space Vehicles $67.36 $378.93 $0.00 $379.91 $0.86 $299.99 $0.00 $285.19 $54.99 $183.62 $0.00 $209.99 $77.02 $132.50 $34.53 $159.15 $0.00 $165.83 $14.50 $99.05 $11.75 $76.83 $0.02 $67.25 $7.97 $51.41 $0.07 $56.30 $4.59 $50.71 Aerospace Total $446.29 $379.91 $300.85 $285.19 $238.62 $209.99 $209.52 $193.67 $165.83 $113.55 $88.58 $67.27 $59.39 $56.37 $55.30 Arizona Commodity Production* $12,912.26 $382.55 $1,108.23 $672.86 $423.20 $2,890.32 $1,059.60 $1,857.85 $478.33 $2,998.84 $304.99 $472.67 $4,115.69 $63.49 $751.03 Arizona Demand All Industries $10,831.49 $521.51 $1,071.01 $1,091.42 $770.99 $1,173.37 $1,350.04 $2,534.70 $1,214.39 $3,164.91 $1,204.19 $512.91 $5,985.75 $211.01 $1,142.92 Total Commodity Purchases (millions) $455.90 $3,495.71 $3,951.60 $82,652.59 $77,119.74 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps Figure 2-12 Arizona Supplier Gaps for Other High Tech Industries Millions of Dollars Supplier Industries All other electronic component manufacturing Wholesale trade Broadcast & wireless communication equipment Architectural and engineering services Semiconductors and related device manufacturing Management of companies and enterprises Semiconductor machinery manufacturing Real estate Environmental and other technical consulting svcs Employment services Lessors of nonfinancial intangible assets Telecommunications Computer systems design services Monetary authorities & depository intermediation Advertising and related services Top 15 Suppliers Photographic Media Architecture Equipment Recording & & & Supplies Reproduction Electronics Engineering $0.53 $0.05 $417.17 $0.57 $7.24 $0.69 $363.81 $6.15 $0.24 $0.00 $194.87 $0.00 $0.28 $0.06 $49.60 $129.93 $0.32 $0.01 $114.48 $0.17 $1.06 $0.15 $97.38 $7.56 $0.00 $0.00 $85.58 $0.00 $0.14 $0.26 $21.39 $60.58 $0.01 $0.00 $1.01 $75.62 $0.08 $0.15 $4.66 $56.99 $1.45 $0.06 $55.08 $4.80 $0.18 $0.15 $24.72 $28.79 $0.09 $0.03 $40.11 $6.73 $0.42 $0.10 $28.40 $16.48 $0.11 $0.91 $31.90 $10.14 High Tech Total $418.32 $377.89 $195.12 $179.87 $114.98 $106.16 $85.58 $82.37 $76.64 $61.89 $61.39 $53.84 $46.96 $45.40 $43.07 Arizona Arizona Commodity Demand Production* All Industries $1,059.60 $1,350.04 $12,912.26 $10,831.49 $423.20 $770.99 $2,998.84 $3,164.91 $1,799.33 $790.04 $1,857.85 $2,534.70 $414.16 $648.72 $16,370.19 $12,092.21 $333.36 $270.74 $3,260.78 $1,734.37 $6,494.93 $1,698.13 $4,352.27 $5,299.03 $677.91 $874.31 $4,115.69 $5,985.75 $2,266.81 $3,155.27 Total Commodity Purchases (millions) $31.10 $6.38 $2,050.37 $648.75 $2,736.60 $106,225.93 Source: Minnesota IMPLAN Group, 2001 data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps $96,206.68 11 Figure 2-13 Arizona Supplier Gaps to State and Local Government (Non-Education) Millions of Dollars Supplier Industries State & Local Non-Education Real estate Securities, commodity contracts, investments Monetary authorities and depository credit intermediaries Wholesale trade Telecommunications Employment services Legal services Services to buildings and dwellings Food services and drinking places Postal service Hotels and motels Management consulting services Electronic equipment repair and maintenance Accounting and bookkeeping services Total Commodity Purchases (millions) Source: Minnesota IMPLAN Group, 2001 data. Top 15 Suppliers State & Local Govt $7,161.99 $406.67 $278.41 $271.60 $251.84 $246.19 $210.03 $187.16 $158.84 $156.44 $149.95 $138.33 $114.51 $103.54 $100.09 $10,375.77 Arizona Commodity Production* $5,804.53 $16,370.19 $2,751.35 $4,115.69 $12,912.26 $4,352.27 $3,260.78 $2,141.72 $1,345.64 $7,694.15 $1,012.70 $1,724.61 $1,643.20 $655.96 $1,006.87 Arizona Demand All Industries $5,804.53 $12,092.21 $4,136.42 $5,985.75 $10,831.49 $5,299.03 $1,734.37 $2,676.00 $1,055.66 $6,598.51 $907.69 $1,052.76 $1,409.71 $498.12 $1,095.47 $71,797.77 $66,123.82 * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps In general, the demand from a particular industry group may not be large compared to total commodity production, but when added to demand from all other industries in Arizona there is a deficit. It is not clear from the secondary data whether that deficit is causing a problem for the industries of opportunity. However, it would appear from this analysis that Arizona is a net importer of many manufactured goods that are used by the industries of opportunity. Some of the gaps that do exist are in industries that rely heavily on natural resources and are not likely to expand in Arizona such as pulp mills, logging and grain farming. There are however other industries that appear as gaps in multiple clusters, resulting in a high volume of overall demand, may be good candidates for expansion such as wireless communication equipment, electronic components, computer systems design services and plastic products. It is important to note that since any given industry sub-group may produce a number of specific products and services, not every industry in the sub-group may demand every commodity listed. Depending on the specific products and services produced in Arizona, relative demand for individual commodities may vary. In general, the importance of having local suppliers is proportional to the cost of transporting a particular commodity, perishability, and the just-in-time nature of production in a given buyer industry. For example, although there may be gaps for certain suppliers like petroleum refineries, the lack of refineries in Arizona is certainly not a limiting factor in the ability of local industries to obtain gasoline and related petroleum products. In other cases, there may be demand for very specialized products that are hard to find or difficult to transport, and local availability may be very important. 12 County Level Commodity Production Although the objective of this study is to find better ways to connect Arizona buyers and Arizona suppliers, the location of buyers within the state may be an issue for certain types of industries. Due to its relatively larger business base, Maricopa County produces the majority of commodities in most categories (Figure 2-14), and 80 percent of the commodities required by the industries of opportunity. However, there are some exceptions. The figure below details share of commodity production by county in terms of output value. Figure 2-14 Commodity Production by County* Apache, 0% Yuma, 1% Yavapai, 1% Santa Cruz, 0% Pinal, 1% Pima, 12% Cochise, 1% Coconino, 1% La Paz, 0% Graham, 0% Greenlee, 0% Gila, 0% Mohave, 1% Navajo, 1% Maricopa, 80% *For composite of commodities required by industries of opportunity. • • • • • Pima County has the highest production statewide in a number of specialized manufactured goods including guided missiles and space vehicles, propulsion units for space vehicles, agricultural chemicals, hardware manufacturing, surgical and medical instruments, surgical appliances, communication equipment as well as services such as software publishing and scientific research and development services. Coconino County has especially high production of surgical appliances as well as logging and forest nursery products. Yuma County, and to a lesser extent Pinal County, have an established base of agricultural suppliers utilized by the industries of opportunity such as oilseed farming, agricultural support activities, vegetable and melon farming, dry and condensed dairy products and nursery products. Navajo County has a significant base of suppliers to the forest products group such as logging, nursery products, pulp mills and paper mills. In a few cases, there is little or no Arizona production at all such as for glass containers and ball bearings. 13 Figure 2-15 shows commodity production by county for a composite list of the top 25 commodities where state-level gaps may exist based on demand from all industries of opportunity. Commodities with state level supply gaps are shown in bold. Top commodities overall where local demand exceeds local supply include telecommunications, electronic components, management of companies and enterprises, truck transportation, broadcast and wireless communication equipment and aircraft parts. Additional commodity detail is shown in Appendix D. It is important to keep in mind that the supplier gaps identified here are specific to the historical data used in the analysis. It is likely that that mix of commodities produced in Arizona will change in the future. More research on industry growth projections compared to commodities where apparent gaps exist could shed light on this issue. Additionally, some commodities such as electronic component manufacturing will be more vulnerable to global pressures. Other commodities such as aircraft engine parts, petroleum refineries could be vulnerable to other macro conditions such as oil price shocks and these factors will affect future production in Arizona. Beyond identifying gaps and targeting supplier industries for expansion, the more important factor is whether or not industries that demand products that are currently being produced in Arizona are in fact purchasing locally. It is not possible to ascertain the actual buying patterns of individual businesses from this secondary data, but this information is available through the buyer survey. 14 15 Demand from Arizona Industries of Commodity Top 25 Suppliers to Industries of Opportunity Opportunity Production* Telecommunications $1,162.83 $4,352.27 All other electronic component manufacturing $782.34 $1,059.60 Management of companies and enterprises $531.59 $1,857.85 Truck transportation $525.31 $2,435.78 Monetary authorities and depository intermediaries $517.36 $4,115.69 Broadcast and wireless communications equipment $514.47 $423.20 Architectural and engineering services $452.31 $2,998.84 Other aircraft parts and equipment $379.91 $382.55 Securities, commodity contracts and investments $376.84 $2,751.35 Advertising and related services $371.77 $2,266.81 Legal services $315.92 $2,141.72 Aircraft engine and engine parts manufacturing $285.19 $672.86 Petroleum refineries $202.36 $42.77 Grain farming $201.37 $37.22 Accounting and bookkeeping services $198.78 $1,006.87 Other animal food manufacturing $181.88 $70.47 All other crop farming $172.79 $173.30 Propulsion units and parts for space vehicles $165.83 $478.33 Warehousing and storage $153.83 $475.31 Computer systems design services $145.23 $677.91 Scientific research and development services $144.30 $304.99 Plastics products $138.44 $751.03 Poultry and egg production $136.41 $13.35 Sawmills $120.00 $22.65 Paperboard container manufacturing $119.54 $217.73 Apache $19.94 $0.05 $0.00 $0.57 $16.25 $0.21 $2.70 $0.03 $0.32 $0.80 $7.29 $0.00 $0.00 $0.12 $1.37 $0.00 $0.77 $0.08 $1.17 $0.00 $0.00 $0.00 $0.27 $4.11 $0.00 Cochise Coconino $36.09 $23.44 $14.13 $0.21 $6.13 $13.70 $26.88 $54.29 $27.81 $72.40 $0.09 $1.80 $38.80 $19.81 $0.02 $1.12 $14.16 $19.03 $16.83 $37.90 $5.84 $24.72 $0.01 $0.16 $0.00 $0.00 $7.83 $0.06 $2.21 $9.86 $0.00 $0.33 $7.43 $0.42 $0.02 $0.04 $8.06 $4.91 $45.45 $2.19 $1.02 $9.79 $0.24 $11.97 $1.52 $0.53 $0.25 $0.10 $0.00 $0.02 Gila $7.59 $1.01 $9.11 $7.29 $16.58 $0.01 $2.34 $0.00 $0.82 $10.01 $1.60 $0.00 $0.00 $0.08 $0.58 $0.00 $0.35 $0.00 $0.00 $1.72 $0.74 $0.01 $0.00 $0.02 $0.00 Graham Greenlee $0.85 $0.00 $0.00 $0.00 $0.52 $0.00 $4.74 $3.73 $9.27 $0.76 $0.00 $0.00 $1.39 $0.10 $0.01 $0.00 $1.34 $0.02 $14.37 $1.64 $1.07 $0.53 $0.22 $0.00 $0.00 $0.00 $0.24 $0.26 $1.02 $0.21 $0.00 $0.00 $0.18 $1.09 $0.01 $0.00 $0.00 $0.00 $0.95 $0.00 $0.00 $0.00 $0.30 $0.00 $0.00 $0.57 $0.00 $0.00 $0.00 $0.00 Commodity Production by County* La Paz Maricopa Mohave $3.83 $3,902.95 $71.11 $0.00 $1,257.82 $8.30 $0.00 $1,839.69 $10.39 $3.25 $2,112.03 $58.25 $5.30 $3,409.10 $57.20 $0.00 $385.37 $0.39 $0.82 $2,448.80 $64.44 $0.00 $944.01 $15.44 $0.10 $2,482.91 $14.10 $3.21 $1,657.06 $47.32 $1.03 $1,771.41 $12.37 $0.00 $1,803.69 $1.03 $0.00 $41.63 $1.56 $0.88 $14.72 $0.19 $1.13 $856.81 $16.85 $3.50 $37.58 $0.00 $21.63 $85.24 $1.36 $0.00 $177.72 $0.55 $0.00 $395.55 $0.39 $0.00 $570.65 $1.29 $0.00 $130.12 $0.76 $0.01 $623.66 $75.03 $0.00 $7.12 $0.00 $0.00 $5.48 $0.03 $0.00 $168.92 $0.15 Figure 2-15 Commodity Production by County for Key Commodities Millions of Dollars Navajo $23.10 $0.00 $6.38 $19.98 $33.92 $0.00 $2.99 $0.00 $1.93 $38.46 $4.69 $0.00 $0.00 $2.08 $3.73 $0.00 $4.27 $0.00 $0.00 $0.08 $1.90 $0.07 $0.00 $13.26 $0.00 Pima $237.21 $113.14 $181.67 $195.08 $499.76 $88.31 $453.27 $135.69 $258.37 $343.49 $297.54 $18.63 $0.07 $1.16 $91.69 $0.00 $2.68 $298.70 $32.03 $60.30 $154.14 $115.35 $0.00 $0.16 $28.53 Pinal Santa Cruz $16.67 $4.43 $10.52 $16.41 $6.80 $8.80 $34.54 $32.05 $44.11 $11.82 $0.02 $0.08 $23.82 $0.73 $0.00 $27.02 $1.22 $2.52 $14.45 $4.77 $6.05 $3.76 $0.00 $0.51 $0.00 $0.00 $10.08 $0.26 $1.80 $4.44 $32.07 $0.00 $20.69 $0.19 $0.00 $0.89 $1.59 $24.36 $0.76 $0.00 $9.68 $0.00 $3.49 $0.23 $0.66 $0.26 $0.08 $0.02 $0.01 $0.00 Yavapai $30.23 $2.72 $3.13 $35.81 $71.39 $22.24 $38.89 $52.49 $35.57 $40.28 $21.78 $1.01 $0.00 $0.90 $11.50 $0.00 $1.87 $1.86 $2.48 $3.94 $1.10 $14.30 $2.55 $0.13 $0.02 Yuma $39.77 $5.38 $11.88 $41.22 $61.10 $0.02 $17.08 $0.33 $9.55 $49.44 $20.59 $0.04 $0.00 $9.55 $9.68 $0.01 $32.74 $0.03 $11.30 $0.24 $0.87 $0.25 $0.00 $0.91 $28.59 3.0 Survey Sample Selection and Design Identification of Survey Participants Participants were selected for the web survey based primarily on industry type and availability of a purchasing or operations contact. The industry selections included twelve industries of opportunity consistent with the secondary data analysis. These industries were identified as part of the Statewide Economic Study prepared for the Arizona Department of Commerce (ADOC). • • • • • • • • • • • • software and systems integration health care and biotech industrial machinery telecommunications high tech instruments forest products engineering research transportation and logistics agriculture, food processing and ag technology aerospace, avionics and defense other high tech industries local government Company contact records were purchased from Dun & Bradstreet for 1,042 establishments in these industries. About 237 additional company names for major employers outside these industries of opportunity were added by the Department of Commerce and the Southern Arizona Technology Council. All data was carefully reviewed to eliminate duplicate records and fill in missing contact information. Based on the types of industries included, about 278 of the companies had less than 10 employees. Since these companies do not make significant supplier purchases due to their size, and because they would be less likely to respond to this type of web survey in general, a decision was made to limit the list to companies with 10 or more employees. Also, some specific industries that fell into the twelve industries of opportunity above were eliminated because they were not basic industries and did not meet the general objectives of the survey. The result was to delete 261 companies that fell into the following categories: medical, dental and chiropractic offices; rehab facilities; landscape companies; pet groomers; veterinarians; kennels; market research and other nonphysical, non-scientific research. The final list included 679 companies. From this list, 19 were selected for personal interviews. The personal interviews were generally larger companies (75 or more employees) in high tech and telecommunications industries. Employers in these industries tended to represent the largest employers in the survey sample. Of the list of potential survey participants 48 percent were in Maricopa County, 36 percent were in Pima County, and the remainder was spread throughout the state. The personal interviews were primarily with firms in Maricopa County, but included a few representative companies from Coconino and Pima counties. The largest industry groups among potential survey participants were industrial machinery and high tech, each making up 24 to 29 percent of the potential participants. Other larger industry groups included agriculture/food processing, major employers, instruments and health care/biotech. However, all of the industry groups had at least 8 potential participants on the survey list. 16 Survey Design Both the web-based survey and personal interviews were designed to gather information from buyer industries about their purchasing patterns, policies, issues and challenges. Questions included topics such as centralized purchasing trends, certification requirements for suppliers, most important factors in choosing suppliers, methods for identifying potential suppliers, types of products currently purchased locally, types of products not purchased locally and reasons why not, anticipated future purchasing trends in and out of Arizona, likelihood of future off-shoring of purchases and other general business climate issues that may be impeding local industry growth. Participants were categorized by industry, employment size, location and purchasing volume. A copy of the web-based survey instrument is included in Appendix E. The personal interviews included additional questions about past experiences using local suppliers, purchases outside of Arizona and outside the United States, challenges in purchasing off shore and actions that the Department of Commerce might take to increase local purchasing. A copy of the interview script is included in Appendix F. Survey Launch and Promotion All potential survey participants were sent a personal letter explaining the objectives of the study and inviting them to participate in the survey. A separate version of this letter was sent to businesses that were selected for personal interviews. The web-based survey was available from April 14, 2005 to June 30, 2005. During the first several weeks of the survey, potential web-survey participants were sent a series of three postcards reminding them of how important it was for them to “share their views” with the Arizona Department of Commerce. During the last week of the survey, personal telephone calls were made to companies encouraging them to spend ten minutes responding to the survey questions. As an additional incentive, survey participants were invited to supply their contact information and be entered into a prize drawing. Data from the completed surveys are presented and analyzed in this report. Approximately 17 businesses did not receive mailings due to bad addresses. Of the remaining 643 companies, 46 completed the on-line survey (7.2 percent response rate), and their responses are detailed in this report. Telephone interviews were conducted to supplement the online survey and obtain more in-depth information on companies’ purchasing practices. From a target list of 19 companies, 9 interviews were successfully completed. These particular companies were selected by the Department of Commerce because they represent large buyers and industries critical to Arizona’s economic base. Including the telephone interviews, the overall response rate was 8.3 percent. Note that several of the companies on the list for personal interviews were unable to participate because all purchasing is done from a central location outside of Arizona. Because the response rate to the survey was relatively low, there is a good likelihood of a non-response bias and the survey results should be viewed with this in mind. 17 4.0 Survey Results The survey results shown below include a profile of the respondents in terms of industry mix, size, purchasing volumes and location, followed by details on how purchasing decisions are made and the types of goods and services being purchased in and out of Arizona. Results for the web-based survey and the personal interviews are combined in the tables and graphs. Respondent Profile The participants in the web survey represented a broad mix of firms in terms of industry type, employment size and annual purchasing volumes. Figure 4-1 shows the comparison of the industry sectors included in the survey population with the respondents. All industry sectors except for telecommunications and ag/food processing were representative of the total survey sample. Note that in some cases the response group is larger than the sample for a given industry. Respondents placed themselves into industry groups as part of the survey and their classifications may have been different than the industry of opportunity they were associated with in the sample. Figure 4-1 Industry Makeup of Survey Sample Versus Respondents 30% 25% Sample Response 20% 15% 10% 5% Ag /F oo d Pr D oc ef en es se si ng /A e En ro sp gi ac ne e er in Fo g/ R G re &D ov st er P nm ro du en ct t/E H s ea du lth ca C tio ar n e/ Bi ot ec In h H du ig h st Te ria ch lM ac hi ne In ry st ru m en Te ts So le co f tw Tr m ar an m e un sp ic or at ta io tio ns n/ L M og aj is or t Em ics pl oy C er O o s n th st er ru M O ct th an io n er uf ac Se tu rv rin ic es g & Re ta il 0% The employment size of businesses responding to the survey ranged from less-than-50 to over-1,000 (Figure 4-2). These figures include Arizona employees only. Over 60 percent of responses came from companies on each end of the spectrum (0-50 employees and over 1,000 employees) A slightly greater number of responses came from smaller companies (those employing 50 or less). 18 Figure 4-2 Employment Size of Survey Respondents Less than 50 36% 51 to 100 16% 101 to 250 16% More than 1,000 28% 251 to 500 12% 501 to 1,000 20% The total volume of supplier purchases made by these companies generally corresponded to employment size, although purchase volume is also largely a function of industry type and the implied ratio of materials to labor. About half of respondents purchase less than $5 million per year in goods and services, although a full 20 percent purchase more than $100 million annually (Figure 4-3). Over 70 percent of respondents expect to increase their volume of purchases in the 2004-2005 fiscal year. Figure 4-3 Survey Respondents by Annual Purchasing Volume* Less than $1M 20% More than $200M 12% $1M to $5M 32% $6M to $10M 4% $101M to $200M 8% $51M to $100M 4% $11M to $50M 20% *Purchasing volume based on 2003-2004 fiscal year. 19 The final piece of information used to profile respondents was location. The sample was heavily weighted toward Maricopa and Pima Counties, because these counties account for the largest share of the state’s businesses. All counties in the state except for Greenlee were represented in the sample. Figure 44 compares the geographic distribution of the sample relative to the respondent pool. Note that some companies marked multiple locations in their responses, although the sample reflects only the mailing addresses of the primary respondents. In general, the response from the rural areas was good, representing a greater than proportional share relative to the sample. Figure 4-4 Geographic Distribution of Survey Sample Versus Respondents 50% 45% 40% Sample Response 35% 30% 25% 20% 15% 10% 5% Yu m a ai z Ya va p Cr u Pi na l Sa nt a Pi m a Pa z M ar ic op a M oh av e N av aj o La en le e ila G ha m G re G ra Ap ac he C oc hi se C oc on in o 0% Purchasing Decisions This next section of the survey describes the process and criteria used in making purchasing decisions. There are two key issues that impact the ability of state and local government to provide procurement assistance. These include whether purchasing is done from a central location, such as a headquarters outside Arizona, and whether all purchasing is done by purchasing department personnel. For the companies that responded to the survey, almost all indicated that most purchasing for their Arizona operations is done at a centralized facility located within the state. This is significant because it makes it easier for ADOC or local economic development organizations to develop relationships with local buyers. However, close to 40 percent of respondents also noted that purchases under $5,000 could be made by non-purchasing personnel. It is common, particularly among high tech employers that purchases below a certain amount can be made by non-purchasing personnel who are more directly involved in the production process. This can make it very difficult for outside organizations to track the types of purchases that are being made and to establish meaningful contacts within a company. 20 Companies use a wide variety of methods to identify suppliers and potential suppliers (Figure 4-5). It is interesting to note that one of the most common methods used to identify suppliers is the Internet. This is significant because almost any size local supplier could develop a web site and gain a presence on the Internet that may allow them to connect with large local buyers. In contrast, firms that rely on their own records or the experience of their purchasing agents, which are the second and third most common identification methods, may be more difficult for new suppliers or smaller suppliers to reach. Other supplier identification options used by survey participants such as vendor directories, catalogues and trade journals are less difficult to gain access to for suppliers; although there are often many choices of directories and catalogues, and it can be difficult for a small supplier to allocate advertising dollars effectively. Figure 4-5 Supplier Identification Methods Internet Search Firm Records, Previous Contacts Own Experience Catalogues Advertisement for Bids Trade Journals Government Procurement Vendor Directories Word of Mouth and Referrals Sales Force Industry Associations Trade Shows Manufacturer's Reps Distribution Channels Second Sourcing 0% 2% 4% 6% 8% 10% 12% 14% 16% 18% Often the methods used depend on the commodity or service being purchased and/or contract requirements. Noted below are the comments on the restrictions or limitations some companies face when choosing suppliers; particularly high technology companies. • they go where they can purchase the technology • government contractors are restricted to buying from approved vendors (indirect purchases are made from local companies and Internet) 21 • suppliers are selected primarily based on their ability to deliver very specific technology Because the firms responding to the survey encompass a range of industry sectors – services, industrial manufacturing, government, health care, etc. – it is expected that the criteria for their purchasing decisions would also cover a range of factors. Survey respondents were asked to rank seven factors by level of importance that they use when choosing suppliers (Figure 4-6). Quality of the product was by far the most important to buyers with 96 percent of buyers ranking quality as most important or very important. Reliability of delivery was ranked most important or very important by 89 percent of buyers. Other key factors included price and service/maintenance. It is interesting to note that geographic proximity rated virtually the same as the supplier having a web presence. Having on-line interface was noted as a key feature of web presence. In general, buyers appear to have limited interest in the physical location of vendors, relative to other factors. For products that must be purchased locally, survey respondents indicated that suppliers located outside metro Phoenix or Tucson would be sufficiently close for most products. Figure 4-6 Criteria Used to Select Suppliers Price Most Very Slightly Important Important Important Important 15 28 12 0 27% 51% 22% 0% Not Important 0 0% Reliability of Delivery 20 37% 28 52% 5 9% 1 2% 0 0% Quality of Product 34 61% 20 36% 2 4% 0 0% 0 0% Supplier's Service/Maintenance 12 22% 27 49% 14 25% 1 2% 1 2% Historical Relationship with Supplier 4 7% 22 40% 24 44% 5 9% 0 0% Geographic Proximity 1 2% 9 16% 18 33% 18 33% 9 16% Web Presence 2 4% 7 13% 13 24% 23 43% 9 17% In addition to general criteria for selecting suppliers, companies were also asked to indicate specific requirements. Almost 60 percent of the companies responded that they have no specific requirements for purchasing, however many indicated that there are factors and/or service features that influence their decisions. The most common factors included: • Ownership (minority, women, or veteran-owned) (47 percent) 22 • Shipping, Receiving, and Inspection Services (18 percent) • Warehouse distribution (14 percent) • Bondable (14 percent) • ISO 9000 Compliance (11 percent)3 • Training and Field Servicing (11 percent) Of the 27 specific requirements that were listed in the survey, all but three are considered by at least one of the companies’ responding (the exceptions are: AS 9100, CE Mark, and RoHS Compliance).4 Other items noted as important factors when selecting suppliers include: • Technology — technical expertise, electronic interface, the supplier’s ability to match and keep up with the company’s level of technology • Capacity — ability to take on additional orders, ability to handle custom work, timely delivery, willingness to provide sample products • Financial — viability of company, accuracy of invoicing, acceptance of purchasing card • Compatibility – alignment of supplier’s management system with company values Location of Purchases About half of the survey respondents purchase less than 25 percent of their supplies outside Arizona (Figure 4-7). However, another 25 percent purchase at least half of their supplies outside the state. Of those purchases that are taking place outside the state, only 8 percent of buyers are making more than 25 percent of their purchases from foreign vendors. This is generally a positive result given that domestic competition may be easier to tackle than foreign competition. However, depending on the reasons for non-local purchasing, out-of-Arizona purchasing trends may make it more difficult to connect buyers with local suppliers. For example, for companies where purchasing of some or all products is controlled from an out-of-state location, or where the product is so specialized that only a few national vendors exist, or where a long-standing relationship exists with a particular supplier outside of Arizona, it may be very difficult to change purchasing patterns. 3 ISO9000 is an international standard designed to provide companies and organizations with a common approach to applying a Quality Management System. 4 AS9100 is the quality system requirements for suppliers to the aerospace industry. CE Mark (short for CE Marking) is a declaration by the supplier that the product meets all appropriate provisions of the relevant legislation implementing certain European Directives. CE marking gives companies easier access into the European market to sell their products without adaptation or rechecking. RoHS Compliance is the European Unions Directive on Restrictions of Hazardous Substance including lead, cadmium, mercury, hexavalent chromium, PBB fire retardant and PBDE fire retardant. 23 Figure 4-7 Out of State Purchasing 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% Outside Arizona Outside U.S. 0% to 25% 26% to 50% 51% to 75% 76% - 100% Seventy-four percent of the companies responding to the survey state that they have no “buy local” policy in place. This is a critical point for Arizona’s buyer/supplier network especially considering these facts: • buyers depend on the Internet to locate potential suppliers • geographic proximity is not a key factor in selecting suppliers • many Arizona companies are already spending a significant amount of their purchasing dollars outside the state and outside the U.S. Types of Purchases Since the survey includes a wide variety of companies, there are an equally wide variety of goods and services being purchased. However, it is generally the case that companies are buying more basic goods locally. These include office supplies and printing; local services such as security, building maintenance and food service; and standard manufactured products and hardware (particularly fabricated metal products) and professional and business services. The types of products being purchased outside Arizona are typically more specialized, although there is some overlap. In some cases, these products may be available in Arizona, but local suppliers are unable to meet other specific buyer criteria. 24 Purchases Not Able To Be Made Locally Purchases Made Locally • Large equipment, vehicles, office furniture, computers • Office, operating, and shipping supplies, printing • Electronics and electrical components--parts and production materials for electronics, controllers, inverters, power panels, batteries • Linens, janitorial and cleaning products, landscaping, facility maintenance, security • Building and construction materials • Technology related to specific contracts (particularly government contracts) • Vending, coffee and food service • Hardware (rollers, handles, latches), valves, solenoids, digital print, locks, die casting magnets • Brass and PVC fittings, o-rings, screws, hardware, tools, spouts, fabricated metals, machined components, standard parts • Composite components • Computer equipment and support, electronics, office machines • Raw materials, job and production materials with specific requirements • Tooling, heat treating, metal plating, anodizing • Steel and other primary metals • • Special metal processes, fabricated metals Professional services (legal, engineering, accounting) • Specialized scientific supplies and equipment • IT services • Medical and scientific supplies • Some chemicals and gases • Injection molded plastic parts • Optic lasers • Fuel, gas and chemicals • Equipment repair, HVAC According to the survey, the primary reason the products and services that could be purchased in Arizona are not is that companies cannot locate local suppliers (Figure 4-8). While the state cannot impact companies’ pricing structures (the number two reason for out-of-state purchasing), there are initiatives and programs that could be put into place to inform local suppliers about buyer issues and help them to become more competitive by helping them understand how to market effectively to local buyers, improve quality standards, or upgrade their production techniques. 25 Figure 4-8 Reasons for Not Purchasing Locally Reliability of Delivery Existing relationships Geographic proximity Capacity concerns Quality issues Product support issues Price Unable to locate local suppliers 35% 30% 25% 20% 15% 10% 5% 0% In addition to reasons for not purchasing locally, buyers were asked what it would take for them to buy more supplies in Arizona. Availability appeared to be the biggest issue, particularly for specialized supplies and components and particularly outside of the metro areas (Figure 4-9). However, price was ranked only slightly below availability. With the decreasing importance of geographic proximity, Arizona suppliers are competing head to head with non-local suppliers in terms of price. However, quality is often a balancing factor to price. Figure 4-9 What Would It Take to Buy More Locally? 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% Availability Better prices Quality at competitive prices Capacity & ability to handle complex pdts Regulatory changes Some of the specific comments made by buyers regarding local purchasing included the following: • For companies that do a lot of government contract work, most approved subcontractors with the required technologies are not located in Arizona. 26 • In order to have a cost advantage, local firms need to have a technological advantage. This requires investing in better equipment to make production more competitive. • Labor costs are an issue when competition is global. Better technology can reduce labor’s share of production costs. • While many U.S. companies support safe work environments and worker benefits, healthcare costs, environmental health and safety requirements are not considered in many other parts of the world where they are competing, making U.S. labor costs dramatically higher. Other Issues and Comments Survey participants were asked to voice concerns about other issues that inhibit their ability to compete such as state and local taxes, workforce and regulatory policies. Among web survey respondents, 90 percent responded that none of these issues limit their ability to compete with other firms in their industry that are located outside Arizona. Among the interview participants, only one indicated that there were local policies that limited competitiveness. In this case, the issue involved incentives offered by other states to assist this company in locating facilities. Other concerns voiced by the survey participants and/or the companies interviewed include the following. Regulatory and Business Environment Affecting Competitiveness — The majority of the companies responding to the survey cited no regulations or policies that inhibit their ability to be competitive. Among those that included comments, issues are mixed between global competitiveness and local business climate factors. • Some countries require offsets but [this company is] satisfied with Arizona in this regard. • Companies have to compete with companies in other states that offer incentives to locate there. • There is a lack of cooperation in Arizona on the local, county and state level. Rather than working in tandem to assist and understand a company, they are competitive with each other. • Health care costs and environmental health and safety requirements are not considered in other parts of the world and dramatically increase labor costs in the U.S. • Air service is limited outside of metro Phoenix. • Land costs are high and water is a limited resource. • Rising housing costs in the Phoenix metro area (43 percent increase in the past year) may cause labor costs to rise or cause other locations outside Arizona appear to be a better value. • Rising lease rates, particularly in metro Phoenix. Some companies are currently in multi-year leases, but when those leases expire they could be at risk for relocation. • Competition with China for materials is causing concerns for high tech companies. • State procurement rules, especially for school districts, hinder competitiveness. Business Expansion — 27 • Limitations to expand Williams AFB due to surrounding development are hampering opportunities to grow product line (testing impacts neighbors). Technology, Education, and Workforce — • Availability of specialized technology is an issue locally. • Arizona universities do not grasp “systems engineering concepts” – understanding the components of a system such as electrical engineering, construction engineering, etc. and the entire system as a whole. There is a tendency to focus on specific engineering disciplines and not the 'architecture' of the entire system. • Very happy with the workforce, most of whom are professionals (engineers). • Lack of jobs for spouses looking for professional work is a concern (outside metro Phoenix or Tucson). • Lack of a large talent pool to draw from is an issue (outside metro Phoenix or Tucson). • Schools are under-funded • Need technological and cost advantage; recommend technical education in Arizona to enhance technical competence that contributes to higher quality products made here; investment in infrastructure to make production more competitive; reduce labor (costs and employment) through better equipment technology to compete in world market. Comparison of Survey Results to Secondary Data Analysis Much of the data collected in the survey concerns purchasing decisions and barriers to purchasing supplies locally. However, information regarding the types of commodities that are being purchased locally versus those that are not can be compared with the results from the secondary data analysis. Since the primary reason for not purchasing locally is availability, it can be assumed that most of the commodities that represent non-local purchases by survey respondents are supply gaps. However, it is important to keep in mind that due to the low survey response rate, the a non-response bias is likely and this affects the types of commodities that are reported as gaps based on the response rate from each of the different industries of opportunity. • Electronic components were noted in both the survey and the secondary data analysis. Specific types of components are used in software, telecommunications, high tech instruments, aerospace, other high tech and industrial machinery manufacturing, according to the secondary data. • Steel and other primary metals were noted as a supply gap for industrial machinery in both the secondary data and the survey. • Specialized scientific supplies were noted as a gap for high tech instruments in both the data and the survey. Other gaps noted in the survey that were not apparent from the secondary data included window hardware, solenoids, locks, die casting magnets, office furniture, computers, power panels, batteries, chemicals and gases and optic lasers. Most of these items (with the exception of office furniture and computers) represent highly specialized products that may only be produced by a limited number of companies throughout the country. 28 Alternatively, professional services were noted as a gap for many industries in the secondary data analysis, but not in the survey results. The secondary data indicated supplier gaps in a variety of professional services for almost all the industries of opportunity. These services included advertising, computer systems design, legal services, investment and banking services, accounting, architectural and engineering services, specialized design services and management of companies and enterprises. However, the survey did not validate this finding with a number of firms reporting that professional services are purchased locally. In some cases, the survey responses were not specific enough to match up to particular SICs in the secondary data such as “raw materials”, “job and production materials that meet specific requirements”, “large equipment” or “technology related to specific contracts”, so there may be other items that match up to some of the gaps indicated by the secondary data that cannot be identified. Another important factor to keep in mind in comparing the results is that survey participants were asked to name commodities that “they would like to purchase locally, but are not able to”, since this is the relevant question for making future connections between buyers and local suppliers. A listing of items that buyers would like to purchase locally is shown in the “Types of Purchases” section of Chapter 3. However, there may be items that buyers expect to purchase elsewhere or are content to purchase elsewhere that would have come up as gaps in the secondary data but were not validated by the survey. 29 5.0 Models to Connect Buyers and Suppliers AZBusinessLinc One of the programs currently being used in Southern Arizona to connect buyers and suppliers is AZBusinessLinc. It has been proposed that this program could be implemented in other parts of the state to improve the supply chain. Although the buyer survey did not reveal a lot of serious red flags, there are certainly improvements that could be made to assist buyers in locating local suppliers and to provide better feedback to suppliers to enable them to compete more effectively with non-local vendors. The following section is a description of how AZBusinessLinc has been implemented by the City of Tucson, and of the advantages of this program. AZBusinessLinc is an on-line supplier database owned by the City of Tucson that allows companies to enter a detailed profile that can be searched by potential buyers. The only criteria are that the companies are located in Arizona and that they are non-retail. The majority of the 2,300 firms currently in the database are located in a five county area in Southern Arizona because this is where the City of Tucson has focused their marketing efforts. Profile information includes general contact information, Disadvantaged Business Enterprise (DBE) certification, a wide range of quality certifications, operational experience, facilities/processes, customer support capabilities, industry type/organization type, sales experience, an open ended statement of capabilities and competitive advantages, a detailed description of products/services offered, and keywords for buyer searches. The profile also includes detailed procurement information that is used by the City of Tucson for internal purposes only. The procurement information provides the city with valuable insights into the companies’ purchasing patterns and criteria. This is important because many suppliers are also buyers. The program is currently marketed to buyers through the efforts of a five person staff who meet regularly with local companies to discuss current and anticipated procurement needs. The staff then assists the companies in identifying local suppliers with the desired capabilities. Although companies can search online for suppliers at any time, the assistance of these staff people in finding suppliers is a valuable resource. These staff people maintain long term relationships with buyer companies and help to plan for changes in supplier needs and identify appropriate resources. Although the City of Tucson partners with other cities and organizations such as chambers to raise awareness about the database among buyers and suppliers at local business events, they report that 95 percent of the actual use of AZBusinessLinc is the result of one-on-one relationships developed by staff. Typical buyer industries that use the database are very large companies, although the city is starting to see more medium sized buyers. About 98 percent of buyers are from the private sector. The most appealing features of the database to these companies are that it is very fast and that you can be very specific in the product you are looking for and the criteria you have for selecting a supplier. The system is also kept very current. Although these buyer companies often also maintain in-house supplier databases, they often find that the information is not as current as the AZBusinessLinc database. The access to staff people from the City of Tucson who will do much of the leg work in searching the database and identifying potential suppliers free of charge is also a big selling point. Interestingly, none of the buyer companies 30 were drawn to the database as a means to comply with a buy local policy. If they are buying locally, it is a function of lower transportation costs and just-in-time production requirements. The database is marketed to sellers exclusively through strategic partnerships with other cities, cluster organizations and chambers in the five-county Southern Arizona region. These other cities and organizations have been effective at encouraging local businesses and organization members to include themselves in the database and take advantage of this free marketing tool. The City of Tucson in turn provides information back to their strategic partners as to who has registered and if they are involved in successful deals. Typical sellers are small to medium sized companies with limited in-house marketing capabilities due to their size. They cover a wide range of industries, however, the top industry types in terms of the types of deals that are actually occurring through the database include maintenance repair and operations supplies (MRO), contract manufacturing, and service/support industries such as IT and engineering design. MRO creates far more opportunities than the other two. The City of Tucson did note that a large share of businesses in the database do not receive any opportunities at all. This is primarily due to the poor quality of information that they include in their profiles, particularly keyword choices that would enable them to come up in searches. There are also some companies whose products and services do not match the types of commodities that buyers are currently searching for. In order to keep the database very current, suppliers who have not made updates to their profiles within a fixed period of time are notified that they must verify their information within ten day or they will be dropped from the database. The strategic community partners are also very active in encouraging new businesses to register. The City has worked on over 600 buyer needs over the past three years of which 38 percent have resulted in actual buyer-supplier transactions. However, the failed transactions also provide valuable information to the City that they actively disseminate to local sellers to let them know what problems buyers are experiencing. While price is probably the most common issue, it is by no means the only issue. Production capacity and specific product requirements are also issues. Because of the one-on-one nature of relationships that have been developed with local buyers, AZBusinessLinc has been a valuable retention and expansion tool for the city. However, it has turned out to be equally valuable as a recruitment tool. The City noted that almost every company they have dealt with that is seriously considering a new location in Tucson is interested in the availability of suppliers in the region and this has been a valuable use of the database. Additionally, new companies are frequently interested in the presence of other similar companies in the area because it demonstrates a local labor force and the general ability of that type of company to be successful locally. This information can also be provided through the database. The City is currently in the process of upgrading the database. Enhancements will include required fields in the supplier profiles to improve the quality and completeness of the information; automated notification to suppliers to update/verify their information and automatic notification to suppliers when they are included in a buyer search. Although the profile does not include any sort of SIC or NAICS codes, the City’s experience has been that these codes are generally only used by public sector buyers who make up only a very small share of 31 users of the database. They are however considering developing an internal number system for products and services that could be used as a search criterion in addition to key word searches. The City did not look at alternative databases at the time that AZBusinessLinc was developed, but they have since become aware of a number of similar databases. Based on their experience with AZBusinessLinc, they still believe it is superior in terms of the comprehensiveness of information, ease of use and one-on-one relationship based approach to marketing. The City believes that in order for the system to be successful, it needs to be managed and marketed at the local level, given the type of relationship building that is required. It is likely that the system could provide value in other parts of the state in terms of increasing visibility and opportunities for smaller local suppliers. However, the best role for the Department of Commerce would be as an umbrella organization and facilitator to encourage communities and local economic development organizations to buy in to the system. Connectory Another similar program used in California is called Connectory. It is generally similar to AZBusinessLinc, but includes some additional features that could enhance AZBusinessLinc if it is expanded for use in other parts of the state. Connectory.com -- the California Network is a business-to-business, buyer-supplier marketing and communication tool that covers the State of California. Connectory.com began in San Diego's East County in the late 1990s and has since expanded throughout the state. Its customers include the companies that profile in and use Connectory.com to find suppliers, each other, potential markets/clients and teaming/alliance partners. In addition, economic development organizations throughout California use Connectory.com as a tool to support a wide range of tasks. Connectory.com is the regional source to find products, technologies, services, company capabilities, capacities and expertise. The following are some of the advantages and additional features offered by Connectory. Many could potentially be incorporated as enhancements to AZBusinessLinc. • Searching Criteria. In general, the profile information in AZBusinessLinc is more complete. However, Connectory offers some advantages in terms of how the search engine functions. Because Connectory.com searches the entire profile and a company's web site content, it is not limited to specific categories or topics but can use specific phrases or search strings. Searches can be statewide or limited by geography (county, city, zip code -- even street address). Other field specific searches include Company Name, Industry Code, and Certifications. • Business Connections Forum. The Connectory web site includes a bulletin board that has “want ads” for buyers needed and suppliers needed, listings of international trade opportunities, employment opportunities, venture funding opportunities and upcoming events. Users of the database can post messages in any of these categories. • Success Stories. The web site includes a series of success stories from local businesses that have used Connectory. These stories serve as powerful marketing tools for the service. • Sponsorships. Connectory is funded through a variety of public and private sources including sponsorships. Sponsorships range from $5,000 to $30,000 and include banner pages with web site 32 links that appear on the Connectory.com site. The size and placement of banners varies depending on the level of sponsorship. • Industry and Regional Focus. Starting in mid-2004, Connectory.com began to support regional portals that focus on industry/ technology companies and their suppliers with a specific region. It also launched industry portals that focus on and provide information for specific industries. Once the use of a database such as this reaches sufficient size that users can be segmented by industry and region, these targeted portals can be a valuable added resource to users. Fast Open Contracts Utilization Services (FOCUS) Another California program that is specific to government procurement is FOCUS. Fast Open Contracts Utilization Services (FOCUS) is California's only nationwide, local government-to-government purchasing program. It allows cities, counties, schools, special districts and other public entities to acquire technology products and services quickly, easily and at competitive rates. The complexities of the government procurement process were noted as a barrier by survey participants. A program such as this does require vendors to pre-certify. However, once they are part of the program, they are able to circumvent future bidding processes. FOCUS gives local government access to pre-screened, competitively bid vendors in the technology industry, avoiding the expense and delay of a protracted government RFP process. There is no cost to vendors to participate in the program. Most favored public agency pricing is offered by all FOCUS vendors. Public agencies can use the program without going to bid, however each state has its own laws addressing intergovernmental purchasing. It is recommended that prior to implementing such a program statewide that each local jurisdiction's elected body approves the use of the program. FOCUS is the result of five years of work to bring technology choices from multiple sources to public agencies. Originally formed as a result of dire budgetary constraints in the early 1990s, FOCUS emerged as a tool to procure technology goods and services, quickly and from multiple sources. The pool of vendor-partners offers a broad spectrum of information technology products and services to meet a wide range of needs. 33 APPENDIX A 34 FIGURE A-1 NATIONAL SUPPLIERS TO COMPUTER SOFTWARE AND SYSTEMS INTEGRATION INDUSTRIES Supplier Industries Employment services Advertising and related services Telecommunications Real estate Wholesale trade Software publishers Office administrative services Computer systems design services Lessors of nonfinancial intangible assets All other electronic component manufacturing Services to buildings and dwellings Automotive repair and maintenance- except car wash Data processing services Monetary authorities and depository credit intermediaries Other support services Colleges, universities and junior colleges Information services Food services and drinking places Postal service Automotive equipment rental and leasing Commercial printing Other computer related services- including facilities Audio and video media reproduction Architectural and engineering services Hotels and motels- including casino hotels Machinery and equipment rental and leasing Legal services Computer storage device manufacturing Management consulting services Securities- commodity contracts- investments Couriers and messengers Management of companies and enterprises Investigation and security services Nondepository credit intermediation Accounting and bookkeeping services Commercial machinery repair and maintenance Water transportation Power generation and supply Air transportation Maintenance and repair of nonresidential buildings General and consumer goods rental Business support services Electronic equipment repair and maintenance Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Reproduction & Publishing 8% 12% 6% 6% 10% 14% 4% 1% 3% 4% 2% 0% 0% 2% 5% 2% 1% 2% 1% 1% 3% 1% 0% 1% 1% 1% 2% 1% 1% 1% 1% 0% 1% 1% 1% 0% 0% 0% 1% 1% 0% 0% 0% Info Services Data Processing 7% 11% 11% 5% 4% 0% 3% 5% 1% 1% 2% 3% 3% 2% 1% 2% 2% 2% 2% 3% 1% 1% 4% 1% 2% 3% 1% 2% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% Programming & Systems Design 14% 5% 7% 7% 2% 0% 6% 5% 6% 3% 4% 3% 4% 2% 0% 2% 1% 1% 1% 1% 1% 2% 0% 3% 2% 1% 1% 1% 2% 1% 1% 1% 1% 1% 1% 2% 1% 1% 1% 1% 1% 1% 1% $22,634 $87,998 312,566 $22,246 $84,894 557,612 $43,870 $241,241 2,698,152 35 FIGURE A-2 NATIONAL SUPPLIERS TO HEALTHCARE AND BIOTECH INDUSTRIES Supplier Industries Lessors of nonfinancial intangible assets Pharmaceutical and medicine manufacturing Wholesale trade Real estate Management of companies and enterprises Advertising and related services Legal services Employment services Securities, commodity contracts, investments Plastics products Scientific research and development services Food services and drinking places Management consulting services Other basic organic chemical manufacturing Postal service Telecommunications Paperboard container manufacturing Commercial printing Monetary authorities and depository credit intermediaries All other miscellaneous professional and technical Warehousing and storage Office administrative services Power generation and supply Business support services Services to buildings and dwellings Colleges, universities and junior colleges Accounting and bookkeeping services Insurance carriers Truck transportation Other basic inorganic chemical manufacturing Data processing services Plastics packaging materials- film and sheet Plastics bottle manufacturing Nondepository credit intermediation Surgical and medical instrument manufacturing Natural gas distribution Other miscellaneous chemical product manufacturing Surgical appliance and supplies manufacturing Glass container manufacturing Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Pharmaceuticals 20% 18% 12% 0% 9% 5% 1% 0% 0% 2% 3% 0% 0% 2% 0% 1% 2% 1% 1% 2% 2% 0% 1% 0% 0% 1% 1% 0% 1% 1% 1% 1% 1% 1% 0% 1% 1% 0% 1% Doctors & Hospitals 1% 3% 5% 15% 2% 1% 4% 5% 4% 2% 0% 2% 3% 1% 3% 2% 0% 1% 1% 0% 0% 2% 1% 2% 2% 1% 1% 1% 1% 0% 1% 0% 0% 1% 1% 1% 0% 1% 0% $57,266 $122,964 265,648 $416,834 $923,021 8,755,104 36 FIGURE A-3 NATIONAL SUPPLIERS TO INDUSTRIAL MACHINERY INDUSTRIES Supplier Industries Wholesale trade Iron and steel mills Management of companies and enterprises Ferrous metal foundaries Machine shops All other forging and stamping All other electronic component manufacturing Truck transportation Aluminum foundries Lessors of nonfinancial intangible assets AC, refrigeration and forced air heating Motor and generator manufacturing Speed changers and mechanical power transmission equipmen Fabricated structural metal manufacturing Iron and steel forging Motor vehicle parts manufacturing Metal valve manufacturing Turned product and screw, nut and bolt manufacturing Telecommunications Semiconductor machinery manufacturing Plastics products Advertising and related services Monetary authorities and depository credit intermediaries All other miscellaneous professional and technical services Relay and industrial control manufacturing Other engine equipment manufacturing Real estate Other rubber product manufacturing Fluid power pump and motor manufacturing Power generation and supply Fluid power cylinder and actuator manufacturing Aluminum sheet, plate and foil manufacturing Securities, commodity contracts, investments Scientific research and development services Ball and roller bearing manufacturing Copper rolling, drawing and extruding Sheet metal work manufacturing Paperboard container manufacturing Cutting tool and machine tool accessory manufacturing Paint and coating manufacturing Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Industrial Machinery 14% 6% 4% 4% 3% 2% 2% 2% 2% 2% 2% 2% 2% 2% 2% 2% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% $123,197 $232,496 1,207,369 37 FIGURE A-4 NATIONAL SUPPLIERS TO TELECOMMUNICATIONS INDUSTRIES Supplier Industries Telecommunications Broadcast and wireless communications equipment Lessors of nonfinancial intangible assets All other electronic component manufacturing Wholesale trade Architectural and engineering services Telephone apparatus manufacturing Advertising and related services Semiconductors and related device manufacturing Accounting and bookkeeping services Management of companies and enterprises Real estate Machinery and equipment rental and leasing All other miscellaneous professional and technical Monetary authorities and depository credit intermediaries Household goods repair and maintenance Other communication and energy wire manufacturing Specialized design services Commercial printing Legal services Custom roll forming Sheet metal work manufacturing Plastics products Nondepository credit intermediation Fiber optic cable manufacturing All other forging and stamping Securities, commodity contracts, investments Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Communication Equipment 1% 28% 14% 12% 10% 2% 2% 1% 4% 0% 3% 1% 0% 1% 1% 0% 1% 0% 0% 0% 1% 1% 1% 0% 1% 1% 1% Telecommunication 41% 0% 2% 1% 2% 7% 5% 5% 0% 3% 0% 2% 2% 1% 1% 2% 1% 2% 1% 1% 0% 0% 0% 1% 0% 0% 0% $46,989 $100,001 230,928 $123,424 $352,925 1,414,321 38 FIGURE A-5 NATIONAL SUPPLIERS TO HIGH TECH INSTRUMENT INDUSTRIES Supplier Industries Wholesale trade All other electronic component manufacturing Management of companies and enterprises Business support services Surgical and medical instrument manufacturing Plastics products Advertising and related services Paperboard container manufacturing Electricity and signal testing instruments Legal services Textile and fabric finishing mills Architectural and engineering services Surgical appliance and supplies manufacturing Scientific research and development services Telecommunications Nonwoven fabric mills Plastics material and resin manufacturing Monetary authorities and depository credit intermediaries All other miscellaneous professional and technical Semiconductors and related device manufacturing Plastics packaging materials- film and sheet Truck transportation Real estate All other forging and stamping Lessors of nonfinancial intangible assets Metal coating and nonprecious engraving Warehousing and storage Broadcast and wireless communications equipment Iron and steel mills Machine shops Specialized design services Power generation and supply Electronic computer manufacturing Sheet metal work manufacturing Securities, commodity contracts, investments Gasket, packing and sealing device manufacturing Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Instruments 14% 7% 6% 4% 3% 2% 2% 2% 2% 2% 2% 2% 2% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% $45,044 $105,984 555,321 39 FIGURE A-6 NATIONAL SUPPLIERS TO FOREST PRODUCTS INDUSTRIES Supplier Industries Forest nurseries, forest products and timber tracts Logging Wholesale trade Agriculture and forestry support activities Paper and paperboard mills Sawmills Truck transportation Automotive repair and maintenance Management of companies and enterprises Natural gas distribution Power generation and supply Commercial machinery repair and maintenance Pulp mills Petroleum refineries Monetary authorities and depository credit intermediaries Miscellaneous wood product manufacturing Paperboard container manufacturing Veneer and plywood manufacturing All other miscellaneous professional and technical Cut stock, resawing lumber and planing Other basic organic chemical manufacturing Rail transportation Adhesive manufacturing Reconstituted wood product manufacturing Real estate Plastics material and resin manufacturing All other electronic component manufacturing Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Logging & Forest Pdts 31% 17% 4% 29% 0% 0% 0% 3% 1% 1% 0% 1% 0% 2% 1% 0% 0% 0% 0% 0% 0% 0% 0% 0% 1% 0% 0% Wood Products 6% 16% 14% 0% 0% 19% 5% 2% 1% 1% 2% 1% 0% 0% 1% 3% 0% 2% 1% 2% 0% 1% 1% 2% 0% 1% 1% Paper Products 0% 4% 12% 0% 25% 2% 5% 3% 4% 4% 2% 1% 4% 1% 1% 0% 2% 0% 1% 0% 2% 1% 1% 0% 1% 1% 1% $10,613 $22,317 142,339 $52,264 $86,552 617,314 $91,396 $154,986 568,130 40 FIGURE A-7 NATIONAL SUPPLIERS TO ENGINEERING RESEARCH SERVICES Supplier Industries Guided missile and space vehicle manufacturing Real estate Employment services Glass and glass products- except glass containers Legal services Wholesale trade Commercial printing Telecommunications Office administrative services All other miscellaneous professional and technical Management consulting services Architectural and engineering services Periodical publishers Maintenance and repair of nonresidential buildings Broadcast and wireless communications equipment Computer systems design services Power generation and supply Advertising and related services Services to buildings and dwellings Other basic organic chemical manufacturing Postal service Machinery and equipment rental and leasing Automotive equipment rental and leasing Data processing services Electroplating, anodizing and coloring metal Monetary authorities and depository credit intermediaries Commercial machinery repair and maintenance Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Engineering Services 41% 6% 4% 3% 2% 2% 2% 2% 2% 2% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% $9,475 $60,473 842,806 41 FIGURE A-8 NATIONAL SUPPLIERS TO TRANSPORTATION AND LOGISTICS SERVICES Supplier Industries Scenic and sightseeing transportation and support Truck transportation Machinery and equipment rental and leasing Wholesale trade Petroleum refineries Automotive repair and maintenance Railroad rolling stock manufacturing Motor vehicle parts manufacturing Insurance carriers Computer systems design services Other computer related services- including facilities Management consulting services Lessors of nonfinancial intangible assets Warehousing and storage Pump and pumping equipment manufacturing Automotive equipment rental and leasing Accounting and bookkeeping services Real estate Wood preservation Telecommunications Monetary authorities and depository credit intermediaries Advertising and related services Management of companies and enterprises Ferrous metal foundaries Rail transportation Other communications equipment manufacturing Nondepository credit intermediation Other concrete product manufacturing Tire manufacturing Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Rail Transport 20% 1% 20% 5% 5% 0% 8% 2% 0% 4% 3% 2% 3% 0% 3% 0% 2% 1% 2% 0% 1% 1% 0% 2% 0% 2% 1% 1% 0% Truck Transport 8% 21% 1% 9% 9% 12% 0% 3% 5% 0% 1% 1% 1% 3% 0% 2% 1% 2% 0% 2% 1% 1% 2% 0% 1% 0% 0% 0% 1% $17,957 $37,279 179,852 $99,124 $198,405 1,623,497 42 FIGURE A-9 NATIONAL SUPPLIERS TO AGRICULTURE, FOOD PROCESSING AND AG TECHNOLOGY INDUSTRIES Supplier Industries Wholesale trade Cattle ranching and farming Real estate Grain farming Other animal food manufacturing Iron and steel mills All other crop farming Agriculture and forestry support activities Truck transportation Other engine equipment manufacturing Management of companies and enterprises Poultry and egg production Motor vehicle parts manufacturing Petroleum refineries All other forging and stamping Ferrous metal foundaries Animal production- except cattle and poultry Animal slaughtering, except poultry Paperboard container manufacturing Pesticide and other agricultural chemical manufacturing Monetary authorities and depository credit intermediaries Advertising and related services Power generation and supply Plastics plumbing fixtures and all other plastics Lessors of nonfinancial intangible assets Tire manufacturing Oilseed farming Automotive repair and maintenance Insurance carriers Speed changers and mechanical power transmission equipment Soybean processing Metal can, box and other container manufacturing Architectural and engineering services Sheet metal work manufacturing Warehousing and storage Metal valve manufacturing All other miscellaneous professional and technical services Phosphatic fertilizer manufacturing Turned product and screw, nut and bolt manufacturing Natural gas distribution Flavoring syrup and concentrate manufacturing Rail transportation Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Agriculture 8% 9% 10% 7% 10% 0% 10% 10% 2% 0% 0% 1% 0% 4% 0% 0% 1% 0% 0% 3% 1% 0% 2% 0% 0% 0% 1% 1% 2% 0% 1% 0% 0% 0% 1% 0% 0% 2% 0% 0% 0% 1% Food Processing 11% 14% 0% 3% 1% 0% 0% 0% 3% 0% 3% 5% 0% 0% 0% 0% 3% 3% 3% 0% 1% 2% 1% 1% 3% 0% 2% 1% 1% 0% 2% 2% 0% 0% 1% 0% 1% 0% 0% 1% 2% 1% Farm & Garden Equipment 15% 0% 0% 0% 0% 10% 0% 0% 4% 8% 3% 0% 6% 0% 4% 4% 0% 0% 0% 0% 1% 1% 1% 2% 0% 3% 0% 1% 0% 3% 0% 0% 2% 2% 0% 2% 1% 0% 2% 1% 0% 0% $144,002 $227,583 3,015,404 $364,694 $524,751 1,810,115 $11,589 $20,519 82,173 43 FIGURE A-10 NATIONAL SUPPLIERS TO AEROSPACE, AVIONICS AND DEFENSE INDUSTRIES Supplier Industries Wholesale trade All other electronic component manufacturing Broadcast and wireless communications equipment Management of companies and enterprises Other aircraft parts and equipment Search, detection and navigation instruments Aircraft engine and engine parts manufacturing Semiconductors and related device manufacturing Architectural and engineering services Guided missile and space vehicle manufacturing Scientific research and development services Propulsion units and parts for space vehicles Monetary authorities and depository credit intermediaries Fiber optic cable manufacturing All other miscellaneous professional and technical services Warehousing and storage Machine shops Plastics products Legal services Custom computer programming services Real estate Power generation and supply All other forging and stamping Other communication and energy wire manufacturing Securities, commodity contracts, investments Telecommunications Data processing services Metal valve manufacturing Electronic computer manufacturing Sheet metal work manufacturing Turned product and screw, nut and bolt manufactur Relay and industrial control manufacturing Nondepository credit intermediation Miscellaneous fabricated metal products Electroplating, anodizing and coloring metal Custom roll forming Aluminum sheet, plate and foil manufacturing Lessors of nonfinancial intangible assets Computer systems design services Wiring device manufacturing Metal coating and nonprecious engraving Iron and steel mills Advertising and related services Electricity and signal testing instruments Ball and roller bearing manufacturing Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Search & Navigation Instruments 13% 15% 10% 7% 0% 0% 0% 5% 3% 0% 2% 0% 2% 3% 1% 1% 1% 1% 1% 2% 2% 1% 1% 1% 1% 1% 1% 0% 1% 1% 1% 1% 1% 0% 1% 1% 0% 1% 1% 1% 1% 0% 1% 1% 0% Aircraft and Space Vehicles 9% 3% 4% 4% 9% 7% 7% 1% 2% 5% 2% 4% 1% 0% 1% 1% 1% 1% 1% 0% 0% 1% 1% 0% 1% 1% 1% 2% 0% 0% 1% 0% 1% 1% 0% 0% 1% 0% 0% 0% 0% 1% 0% 0% 1% $14,448 $35,104 147,391 $69,425 $133,639 500,387 44 FIGURE A-11 NATIONAL SUPPLIERS TO OTHER HIGH TECH INDUSTRIES Supplier Industries Wholesale trade All other electronic component manufacturing Advertising and related services Sound recording industries Architectural and engineering services Photographic film and chemical manufacturing Paper and paperboard mills Management of companies and enterprises Audio and video media reproduction Real estate Broadcast and wireless communications equipment Lessors of nonfinancial intangible assets Employment services Automotive repair and maintenance, except car washes Telecommunications Environmental and other technical consulting services Semiconductors and related device manufacturing Monetary authorities and depository credit intermediation Plastics packaging materials, film and sheet Plastics plumbing fixtures and all other plastics products All other miscellaneous professional and technical services Custom computer programming services Truck transportation Paperboard container manufacturing Power generation and supply Semiconductor machinery manufacturing Magnetic and optical recording media manufacturing Other basic organic chemical manufacturing Scientific research and development services Legal services Plastics material and resin manufacturing Other basic inorganic chemical manufacturing Office administrative services Machine shops Commercial machinery repair and maintenance Computer systems design services Food services and drinking places Securities, commodity contracts, investments Accounting and bookkeeping services Management consulting services Nondepository credit intermediation and related activities Hotels and motels, including casino hotels Postal service Couriers and messengers Maintenance and repair of nonresidential buildings Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. Photographic Equipment & Supplies 20% 2% 0% 0% 1% 11% 8% 3% 0% 0% 1% 4% 0% 3% 1% 0% 1% 1% 2% 1% 1% 2% 2% 3% 1% 0% 0% 3% 1% 0% 1% 2% 0% 2% 1% 0% 1% 1% 0% 0% 1% 0% 0% 0% 1% Sound Recording & Media Reproduction 10% 1% 13% 15% 1% 0% 2% 2% 10% 4% 0% 1% 2% 1% 2% 0% 0% 1% 2% 2% 1% 1% 1% 0% 1% 0% 3% 0% 1% 1% 2% 0% 1% 0% 1% 0% 1% 1% 1% 1% 1% 1% 1% 1% 1% Electronics 15% 17% 1% 0% 2% 0% 0% 4% 0% 1% 8% 2% 0% 1% 1% 0% 5% 1% 1% 1% 1% 1% 1% 1% 1% 3% 0% 0% 2% 1% 0% 1% 0% 1% 1% 2% 0% 1% 0% 0% 1% 0% 0% 0% 0% Architecture and Engineering 0% 0% 1% 0% 10% 0% 0% 1% 0% 5% 0% 0% 4% 0% 2% 6% 0% 1% 0% 0% 1% 0% 0% 0% 1% 0% 0% 0% 0% 1% 0% 0% 2% 0% 0% 1% 1% 1% 1% 1% 1% 1% 1% 1% 0% $7,136 $15,859 60,438 $6,090 $16,891 60,160 $39,589 $56,885 325,176 $74,921 $131,945 680,158 45 FIGURE A-12 NATIONAL SUPPLIERS TO STATE AND LOCAL GOVERNMENT (NON-EDUCATION) Supplier Industries State & Local Non-Education Real estate Securities, commodity contracts, investments Monetary authorities and depository credit intermediaries Wholesale trade Telecommunications Employment services Legal services Services to buildings and dwellings Food services and drinking places Postal service Hotels and motels Management consulting services Electronic equipment repair and maintenance Accounting and bookkeeping services Other State and local government enterprises Data processing services State and local government electric utilities Investigation and security services Truck transportation Waste management and remediation services Total Commodity Puchases (millions) Total Output (millions) Employment Source: Minnesota IMPLAN Group, 2001 data. State & Local Government 61% 3% 2% 2% 2% 2% 2% 2% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% $636,999 $540,280 8,809,610 46 APPENDIX B 47 FIGURE B-1 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT COMPUTER SOFTWARE AND SYSTEMS INTEGRATION Industry Reproduction & Publishing Software reproducing Software publishers Information Services and Data Processing Information services Data processing services Programming and Systems Design Custom computer programming services Computer systems design services Other computer related services Arizona Output* $759.80 $34.68 $725.12 $1,094.32 $391.60 $702.71 $2,118.54 $1,119.09 $824.92 $174.53 Arizona Employment 4,673 383 4,290 11,389 3,860 7,529 28,609 18,295 8,204 2,110 $3,972.66 Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions 44,671 National Output* $87,998.10 $3,380.82 $84,617.28 $84,893.98 $36,499.05 $48,394.93 $241,241.10 $141,812.39 $68,000.94 $31,427.77 National Employment 312,566 27,570 284,997 557,612 193,743 363,869 2,698,152 1,773,108 605,037 320,007 $414,133.18 3,568,330 Arizona Share Output Employment 1% 1% 1% 1% 1% 2% 1% 2% 1% 2% 1% 2% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% FIGURE B-2 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT HEALTH CARE AND BIOTECHNOLOGY Industry Pharmaceuticals Pharmaceutical and medicine manufacturing Doctors and Hospitals Offices of physicians, dentists, and other providers Other ambulatory health care services Hospitals Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $394.59 1,091 $394.59 1,091 $15,106.31 142,468 $5,732.14 63,522 $3,273.24 21,639 $6,100.93 57,308 $15,500.90 143,558 National National Output* Employment $122,964.38 265,648 $122,964.38 265,648 $923,020.61 8,755,104 $338,367.56 3,739,969 $135,953.98 913,003 $448,699.06 4,102,132 $1,045,984.99 9,020,752 Arizona Share Output Employment 0% 0% 0% 0% 2% 2% 2% 2% 2% 2% 1% 1% 1% 2% 48 FIGURE B-3 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT INDUSTRIAL MACHINERY Industry Construction machinery manufacturing Mining machinery and equipment manufacturing Oil and gas field machinery and equipment Sawmill and woodworking machinery Plastics and rubber industry machinery Paper industry machinery manufacturing Textile machinery manufacturing Printing machinery and equipment manufacturing Food product machinery manufacturing Semiconductor machinery manufacturing All other industrial machinery manufacturing Other commercial and service industry machines Automatic vending, commercial laundry and dryers Air purification equipment manufacturing Industrial and commercial fan and blower man Heating equipment, except warm air furnaces AC, refrigeration, and forced air heating Industrial mold manufacturing Metal cutting machine tool manufacturing Metal forming machine tool manufacturing Special tool, die, jig, and fixture manufacturing Cutting tool and machine tool accessories Rolling mill and other metalworking machinery Turbine and turbine generator set units Other engine equipment manufacturing Speed changers and mechanical power transmissions Pump and pumping equipment manufacturing Air and gas compressor manufacturing Measuring and dispensing pump manufacturing Elevator and moving stairway manufacturing Conveyor and conveying equipment manufacturing Overhead cranes, hoists, and monorail system Industrial truck, trailer, and stacker manufacturing Power-driven hand tool manufacturing Welding and soldering equipment manufacturing Packaging machinery manufacturing Industrial process furnace and oven manufacturing Fluid power cylinder and actuator manufacturing Fluid power pump and motor manufacturing Scales, balances, and miscellaneous general Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $76.37 259 $13.30 99 $2.05 18 $8.70 88 $102.81 640 $10.80 74 $1.02 10 $6.00 43 $7.52 76 $553.22 1,181 $22.86 92 $72.99 447 $8.35 56 $3.99 54 $0.69 6 $2.85 21 $399.87 2,251 $35.72 365 $42.87 484 $18.93 183 $36.57 537 $19.15 163 $29.09 122 $51.25 127 $5.93 17 $2.74 20 $2.23 11 $2.21 11 $0.94 3 $0.00 0 $4.32 31 $0.99 5 $5.43 32 $17.61 90 $0.21 1 $0.19 1 $1.93 16 $10.08 47 $0.11 1 $16.50 101 $1,598.39 7,779 National National Output* Employment $20,315.93 71,545 $2,075.18 13,559 $6,232.99 47,226 $1,022.58 9,197 $3,162.52 16,694 $2,597.79 15,830 $1,323.99 10,817 $3,140.26 19,148 $2,652.39 22,292 $11,765.64 22,377 $8,509.26 30,611 $10,795.33 62,333 $1,863.16 12,380 $1,936.81 19,198 $2,020.78 13,986 $4,080.62 22,483 $24,792.60 127,299 $4,800.48 49,028 $4,008.91 36,579 $1,749.29 15,997 $7,179.45 93,691 $4,659.95 35,380 $3,843.77 15,818 $12,040.36 22,080 $19,335.81 50,431 $5,338.60 33,655 $7,273.75 31,020 $5,559.70 23,944 $1,127.42 3,786 $2,146.84 9,783 $6,179.78 37,493 $4,448.20 17,781 $5,044.44 27,209 $3,843.00 17,354 $3,876.33 17,489 $4,160.68 21,567 $2,262.63 16,349 $3,355.91 17,916 $2,522.61 22,791 $9,450.61 53,252 $232,496.29 1,207,369 Arizona Share Output Employment 0% 0% 1% 1% 0% 0% 1% 1% 3% 4% 0% 0% 0% 0% 0% 0% 0% 0% 5% 5% 0% 0% 1% 1% 0% 0% 0% 0% 0% 0% 0% 0% 2% 2% 1% 1% 1% 1% 1% 1% 1% 1% 0% 0% 1% 1% 0% 1% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 1% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 1% 1% 49 FIGURE B-4 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT TELECOMMUNICATIONS Industry Communications Equipment Telephone apparatus manufacturing Broadcast and wireless communications equipment Other communications equipment manufacturing Telecommunications Telecommunications Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $566.87 1,523 $142.04 336 $399.26 1,003 $25.58 183 $4,519.13 24,102 $4,519.13 24,102 National Output* $100,000.54 $50,426.18 $44,172.50 $5,401.86 $352,924.69 $352,924.69 National Employment 230,928 96,896 102,140 31,892 1,414,321 1,414,321 $5,086.00 $452,925.23 1,645,249 25,625 Arizona Share Output Employment 1% 1% 0% 0% 1% 1% 0% 1% 1% 2% 1% 2% 1% 2% FIGURE B-5 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT HIGH TECH INSTRUMENTS Industry Electromedical apparatus manufacturing Automatic environmental control manufacturing Industrial process variable instruments Totalizing fluid meters and counting devices Electricity and signal testing instruments Analytical laboratory instrument manufacturing Irradiation apparatus manufacturing Laboratory apparatus and furniture manufacturing Surgical and medical instrument manufacturing Surgical appliance and supplies manufacturing Dental equipment and supplies manufacturing Ophthalmic goods manufacturing Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $122.86 535 $177.44 1,370 $46.97 479 $277.64 923 $84.98 575 $19.92 84 $8.52 20 $16.06 113 $114.66 670 $362.46 1,916 $12.47 85 $7.75 105 $1,251.72 6,875 National National Output* Employment $13,407.50 52,498 $2,967.90 31,363 $7,249.53 65,610 $4,266.61 16,380 $12,968.98 64,665 $8,138.95 34,103 $4,271.73 11,360 $2,606.67 16,406 $22,838.59 113,874 $20,005.88 95,719 $2,979.68 16,609 $4,282.22 36,735 $105,984.26 555,321 Arizona Share Output Employment 1% 1% 6% 4% 1% 1% 7% 6% 1% 1% 0% 0% 0% 0% 1% 1% 1% 1% 2% 2% 0% 1% 0% 0% 1% 1% 50 FIGURE B-6 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT FOREST PRODUCTS Industry Logging and Forest Products Logging Forest nurseries, forest products, and timber Wood Products Sawmills Wood preservation Reconstituted wood product manufacturing Veneer and plywood manufacturing Engineered wood member and truss manufacturing Wood windows and door manufacturing Cut stock, resawing lumber, and planing Other millwork, including flooring Wood container and pallet manufacturing Manufactured home, mobile home, manufacturing Prefabricated wood building manufacturing Miscellaneous wood product manufacturing Paper Products Pulp mills Paper and paperboard mills Paperboard container manufacturing Flexible packaging foil manufacturing Surface-coated paperboard manufacturing Coated and laminated paper and packaging materials Coated and uncoated paper bag manufacturing Die-cut paper office supplies manufacturing Envelope manufacturing Stationery and related product manufacturing Sanitary paper product manufacturing All other converted paper product manufacturing Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $42.27 618 $33.15 541 $9.12 77 $974.95 8,458 $18.32 109 $2.38 8 $15.81 73 $0.74 6 $223.29 2,026 $207.91 1,503 $10.52 43 $52.04 790 $26.10 419 $288.06 2,370 $85.75 729 $44.03 380 $649.25 2,680 $0.00 0 $129.09 344 $225.46 1,057 $41.96 66 $16.64 52 $46.73 199 $7.80 61 $22.55 120 $45.79 254 $31.37 96 $26.67 157 $55.19 275 $1,666.48 11,756 National National Output* Employment $22,316.74 142,339 $17,362.75 130,464 $4,953.99 11,875 $86,551.59 617,314 $21,629.81 122,368 $4,213.31 13,445 $5,365.75 21,545 $8,020.23 53,452 $6,129.51 51,286 $11,118.22 76,186 $5,913.51 22,936 $4,875.67 67,188 $4,636.35 69,949 $7,192.80 57,820 $3,399.22 26,586 $4,057.21 34,552 $154,985.86 568,130 $3,232.26 7,623 $68,574.23 168,229 $45,521.32 208,537 $1,332.41 2,104 $802.74 2,512 $13,012.01 53,769 $3,102.26 25,387 $2,540.56 12,724 $3,615.16 22,347 $1,815.11 6,334 $6,999.06 38,010 $4,438.73 20,555 $263,854.19 1,327,784 Arizona Share Output Employment 0% 0% 0% 0% 0% 1% 1% 1% 0% 0% 0% 0% 0% 0% 0% 0% 4% 4% 2% 2% 0% 0% 1% 1% 1% 1% 4% 4% 3% 3% 1% 1% 0% 0% 0% 0% 0% 0% 0% 1% 3% 3% 2% 2% 0% 0% 0% 0% 1% 1% 1% 1% 2% 2% 0% 0% 1% 1% 1% 1% FIGURE B-7 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT ENGINEERING RESEARCH SERVICES Industry Scientific research and development services Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $307.61 5,548 National National Output* Employment $60,472.86 842,806 $307.61 $60,472.86 5,548 842,806 Arizona Share Output Employment 1% 1% 1% 1% 51 FIGURE B-8 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT TRANSPORTATION AND LOGISTICS Industry Rail Transportation Rail transportation Truck Transportation Truck transportation Arizona Arizona Output* Employment $364.56 2,058 $364.56 2,058 $2,590.19 20,305 $2,590.19 20,305 $2,954.75 Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions 22,363 National Output* $37,279.20 $37,279.20 $198,405.42 $198,405.42 National Employment 179,852 179,852 1,623,497 1,623,497 $235,684.62 1,803,349 Arizona Share Output Employment 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 52 FIGURE B-9 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT AGRICULTURE, FOOD PROCESSING AND AG TECHNOLOGY Industry Agriculture Oilseed farming Grain farming Vegetable and melon farming Tree nut farming Fruit farming Greenhouse and nursery production Tobacco farming Cotton farming Sugarcane and sugar beet farming All other crop farming Cattle ranching and farming Poultry and egg production Animal production, except cattle and poultry Food Processing Dog and cat food manufacturing Other animal food manufacturing Flour milling Rice milling Malt manufacturing Wet corn milling Soybean processing Other oilseed processing Fats and oils refining and blending Breakfast cereal manufacturing Sugar manufacturing Confectionery manufacturing from cacao beans Confectionery from purchased chocolate Nonchocolate confectionery manufacturing Frozen food manufacturing Fruit and vegetable canning and drying Fluid milk manufacturing Creamery butter manufacturing Cheese manufacturing Dry, condensed, and evaporated dairy product Ice cream and frozen dessert manufacturing Animal, except poultry, slaughtering Meat processed from carcasses Rendering and meat byproduct processing Poultry processing Seafood product preparation and packaging Frozen cakes and other pastries manufacturing Bread and bakery products, except frozen Cookie and cracker manufacturing Mixes and dough made from purchased flour Dry pasta manufacturing Arizona Arizona Output* Employment $2,641.72 18,639 $0.81 12 $47.32 527 $910.19 5,516 $9.10 82 $85.75 807 $81.40 387 $0.00 0 $136.65 578 $0.00 0 $181.43 1,459 $1,133.25 8,874 $13.54 22 $42.28 375 $3,365.08 12,730 $109.76 229 $73.85 152 $16.21 37 $0.00 0 $0.00 0 $1.73 2 $0.00 0 $6.68 12 $2.87 3 $0.00 0 $0.00 0 $0.00 0 $14.80 121 $8.90 32 $2.35 12 $67.90 273 $415.01 967 $0.00 0 $0.00 0 $181.16 293 $9.03 42 $535.87 1,405 $87.42 358 $21.68 95 $0.97 7 $0.00 0 $0.00 0 $400.05 3,344 $47.16 192 $0.56 2 $1.54 13 National National Output* Employment $227,583.37 3,015,404 $14,312.36 311,073 $34,861.38 604,801 $16,214.81 143,108 $1,501.34 23,262 $10,781.86 108,302 $15,474.24 150,543 $1,880.30 42,000 $4,954.04 36,789 $1,803.16 29,688 $18,357.49 284,012 $65,106.45 908,426 $24,569.31 96,573 $17,766.61 276,827 $524,750.64 1,810,115 $9,710.01 19,494 $18,786.68 37,836 $6,242.16 15,357 $1,804.03 4,689 $499.04 1,221 $7,576.92 9,264 $11,017.44 10,355 $1,365.59 2,584 $6,184.79 6,005 $11,033.64 14,282 $6,273.42 15,355 $4,522.24 9,137 $8,692.38 42,652 $5,766.89 24,384 $21,793.92 99,422 $30,031.42 99,302 $24,505.04 56,932 $1,863.06 1,881 $21,846.62 38,146 $10,002.13 15,981 $6,654.96 22,746 $60,909.95 156,880 $29,381.40 115,969 $2,244.35 9,055 $36,786.30 261,058 $8,742.75 46,603 $2,986.20 9,358 $34,315.59 263,764 $9,917.91 36,716 $4,733.22 15,594 $1,228.84 9,265 Arizona Share Output Employment 1% 1% 0% 0% 0% 0% 6% 4% 1% 0% 1% 1% 1% 0% 0% 0% 3% 2% 0% 0% 1% 1% 2% 1% 0% 0% 0% 0% 1% 1% 1% 1% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 2% 2% 0% 0% 0% 0% 2% 2% 0% 0% 1% 1% 0% 0% 1% 1% 0% 0% 0% 0% 0% 0% 1% 1% 0% 1% 0% 0% 0% 0% 53 FIGURE B-9 (continued) ARIZONA SHARE OF EMPLOYMENT AND OUTPUT AGRICULTURE, FOOD PROCESSING AND AG TECHNOLOGY Industry Tortilla manufacturing Roasted nuts and peanut butter manufacturing Other snack food manufacturing Coffee and tea manufacturing Flavoring syrup and concentrate manufacturing Mayonnaise, dressing, and sauce manufacturing Spice and extract manufacturing All other food manufacturing Soft drink and ice manufacturing Breweries Wineries Distilleries Farm and Garden Equipment Farm machinery and equipment manufacturing Lawn and garden equipment manufacturing Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $43.76 508 $1.72 5 $183.16 629 $5.11 14 $0.00 0 $13.07 39 $1.13 6 $70.28 333 $1,029.10 3,557 $3.54 17 $8.72 32 $0.00 0 $256.35 918 $51.50 237 $204.85 682 $6,263.15 32,287 National National Output* Employment $1,363.43 14,805 $4,313.08 11,251 $11,174.48 34,741 $5,162.16 12,068 $8,005.75 11,542 $5,623.46 12,879 $4,593.03 15,099 $12,461.84 53,571 $35,387.91 112,681 $16,901.99 27,993 $8,137.59 25,430 $4,207.02 6,765 $20,519.09 82,173 $13,925.07 60,577 $6,594.02 21,596 $772,853.09 4,907,692 Arizona Share Output Employment 3% 3% 0% 0% 2% 2% 0% 0% 0% 0% 0% 0% 0% 0% 1% 1% 3% 3% 0% 0% 0% 0% 0% 0% 1% 1% 0% 0% 3% 3% 1% 1% FIGURE B-10 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT DEFENSE, AEROSPACE AND AVIONICS Industry Search and Navigation Instruments Search, detection, and navigation instruments Aircraft and Space Vehicles Aircraft manufacturing Aircraft engine and engine parts manufacturing Other aircraft parts and equipment Guided missile and space vehicle manufacturing Propulsion units and parts for space vehicles Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Output* $1,283.16 $1,283.16 $8,209.66 $1,764.35 $2,049.36 $1,074.48 $3,304.94 $16.53 Arizona Employment 5,547 5,547 31,717 6,432 7,038 4,537 13,580 130 National Output* $35,104.04 $35,104.04 $133,639.16 $67,405.73 $26,800.92 $23,180.42 $13,267.46 $2,984.63 National Employment 147,391 147,391 500,387 235,787 93,794 96,556 51,948 22,302 $9,492.83 37,265 $168,743.20 647,779 Arizona Share Output Employment 4% 4% 4% 4% 6% 6% 3% 3% 8% 8% 5% 5% 25% 26% 1% 1% 6% 6% 54 FIGURE B-11 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT OTHER HIGH TECH Industry Photographic Equipment and Supplies Photographic film and chemical manufacturing Photographic and photocopying equipment Sound Recording & Media Reproduction Audio and video media reproduction Sound recording industries Electronics and Audio Video Equipment Audio and video equipment manufacturing Electron tube manufacturing Semiconductors and related device manufacturing All other electronic component manufacturing Architecture & Engineering Architecture & Engineering Services Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $79.05 385 $64.44 292 $14.61 93 $19.39 138 $5.69 48 $13.69 90 $8,269.09 40,729 $106.80 594 $0.00 0 $7,040.05 33,357 $1,122.24 6,778 $3,134.38 37,728 $3,134.38 37,728 $11,501.90 78,979 National Output* $15,858.97 $12,321.52 $3,537.45 $16,890.69 $4,726.14 $12,164.55 $131,945.01 $9,018.63 $3,178.74 $62,862.48 $56,885.16 $174,571.08 $174,571.08 National Employment $60,438.00 38,106 22,332 $60,160.00 26,893 33,267 $680,158.00 47,490 18,434 289,058 325,176 1,899,695 1,899,695 $339,265.75 2,700,451 Arizona Share Output Employment 0% 1% 1% 1% 0% 0% 0% 0% 0% 0% 0% 0% 6% 6% 1% 1% 0% 0% 11% 12% 2% 2% 2% 2% 2% 2% 3% 3% FIGURE B-12 ARIZONA SHARE OF EMPLOYMENT AND OUTPUT STATE AND LOCAL GOVERNMENT Industry State and local non-education State and local government passenger transit State and local government electric utilities Other State and local government enterprises Total Source: Minnesota IMPLAN Group, 2001 data. *Output in Millions Arizona Arizona Output* Employment $5,804.53 123,734 $5.35 121 $2,413.68 4,309 $1,788.84 12,626 $10,012.39 140,789 National Output* $386,469.13 $9,517.00 $29,399.00 $114,895.00 National Employment 7,759,000 214,730 63,368 772,513 $540,280.13 8,809,610 Arizona Share Output Employment 2% 2% 0% 0% 8% 7% 2% 2% 2% 2% 55 APPENDIX C 56 FIGURE C-1 ARIZONA SUPPLIER GAPS FOR SOFTWARE AND SYSTEMS INTEGRATION INDUSTRIES MILLIONS OF DOLLARS Supplier Requirements Reproduction Info Services Programming & Supplier Industries & Publishing Data Processing Systems Design Employment services $15.04 $20.94 $55.26 Advertising and related services $23.90 $32.26 $17.40 Telecommunications $12.04 $32.22 $26.20 Real estate $12.23 $14.89 $25.32 Office administrative services $7.21 $9.22 $23.73 Wholesale trade $18.71 $10.99 $6.98 Computer systems design services $1.83 $13.24 $20.94 Lessors of nonfinancial intangible assets $5.28 $2.81 $24.52 Software publishers $27.91 $0.00 $0.00 Automotive repair and maintenance $0.96 $9.04 $13.44 Services to buildings and dwellings $3.66 $5.41 $13.83 All other electronic component manufacturing $7.12 $4.28 $10.73 Data processing services $0.60 $7.45 $14.04 Monetary authorities and depository intermediaries $4.17 $5.25 $7.01 Colleges- universities- and junior colleges $3.27 $5.10 $7.70 Information services $2.54 $6.85 $5.45 Food services and drinking places $2.94 $6.17 $5.46 Architectural and engineering services $1.38 $1.86 $11.15 Automotive equipment rental and leasing $1.24 $8.10 $4.97 Postal service $2.63 $6.73 $4.92 Other computer related services $2.63 $3.80 $6.62 Hotels and motels- including casino hotels $1.75 $4.74 $6.46 Audio and video media reproduction $0.00 $12.33 $0.00 Machinery and equipment rental and leasing $1.26 $7.72 $3.19 Other support services $8.81 $3.14 $0.16 Management consulting services $1.52 $3.82 $6.53 Computer storage device manufacturing $1.86 $4.97 $4.55 Commercial printing $4.90 $4.12 $2.29 Legal services $4.11 $2.64 $3.96 Management of companies and enterprises $0.83 $3.02 $5.65 Couriers and messengers $1.33 $3.53 $4.51 Securities- commodity contracts- investments $1.95 $4.08 $2.88 Investigation and security services $1.45 $2.22 $5.01 Commercial machinery repair and maintenance $0.53 $1.70 $6.11 Water transportation $0.01 $2.83 $5.28 Accounting and bookkeeping services $1.32 $2.09 $4.03 Nondepository credit intermediation $1.90 $2.42 $2.99 Power generation and supply $0.92 $2.65 $3.37 Air transportation $1.06 $2.38 $3.13 Maintenance and repair of nonresidential buildings $1.06 $2.83 $2.32 General and consumer goods rental $0.49 $2.92 $1.96 Business support services $0.82 $2.07 $2.37 Electronic equipment repair and maintenance $0.25 $1.95 $2.86 Software Total $91.23 $73.56 $70.46 $52.44 $40.16 $36.68 $36.01 $32.60 $27.91 $23.44 $22.90 $22.14 $22.09 $16.43 $16.08 $14.84 $14.57 $14.39 $14.32 $14.28 $13.05 $12.95 $12.33 $12.17 $12.11 $11.87 $11.38 $11.31 $10.72 $9.50 $9.37 $8.91 $8.68 $8.33 $8.12 $7.44 $7.31 $6.94 $6.56 $6.21 $5.37 $5.26 $5.06 Arizona Commodity Production* $3,260.78 $2,266.81 $4,352.27 $16,370.19 $909.59 $12,912.26 $677.91 $6,494.93 $634.67 $5,808.50 $1,345.64 $1,059.60 $737.31 $4,115.69 $390.97 $425.32 $7,694.15 $2,998.84 $3,017.58 $1,012.70 $168.94 $1,724.61 $6.21 $1,219.21 $422.74 $1,643.20 $40.12 $491.89 $2,141.72 $1,857.85 $889.39 $2,751.35 $428.23 $834.42 $77.66 $1,006.87 $3,248.83 $4,919.68 $2,524.13 $750.57 $350.14 $1,862.11 $655.96 Total Commodity Puchases (millions) $195.42 $286.76 $385.26 $867.45 $106,501.53 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps Arizona Demand All Industries $1,734.37 $3,155.27 $5,299.03 $12,092.21 $833.44 $10,831.49 $874.31 $1,698.13 $725.68 $4,104.53 $1,055.66 $1,350.04 $552.98 $5,985.75 $1,602.96 $620.56 $6,598.51 $3,164.91 $1,408.71 $907.69 $303.82 $1,052.76 $52.18 $883.56 $636.35 $1,409.71 $201.91 $566.54 $2,676.00 $2,534.70 $1,007.68 $4,136.42 $414.58 $534.52 $366.79 $1,095.47 $1,395.99 $3,102.05 $1,893.61 $1,672.57 $302.97 $923.99 $498.12 $92,258.54 57 FIGURE C-2 ARIZONA SUPPLIER GAPS FOR HEALTHCARE AND BIOTECH INDUSTRIES MILLIONS OF DOLLARS Supplier Requirements Doctors & Healthcare/ Supplier Industries Pharmaceuticals Hospitals Biotech Total Real estate $0.61 $992.56 $993.17 Wholesale trade $22.74 $342.53 $365.27 Employment services $0.43 $318.08 $318.51 Legal services $1.50 $282.09 $283.59 Securities, commodity contracts, investments $0.38 $276.08 $276.46 Pharmaceutical and medicine manufacturing $32.26 $180.10 $212.37 Postal service $0.01 $188.47 $188.48 Management of companies and enterprises $15.82 $159.98 $175.80 Management consulting services $0.71 $172.22 $172.93 Food services and drinking places $0.88 $169.08 $169.96 Telecommunications $0.99 $147.47 $148.46 Plastics products $2.88 $136.44 $139.32 Office administrative services $0.14 $129.04 $129.18 Services to buildings and dwellings $0.18 $124.77 $124.95 Business support services $0.32 $121.36 $121.67 Lessors of nonfinancial intangible assets $35.93 $79.23 $115.17 Advertising and related services $8.70 $96.26 $104.96 Insurance carriers $0.07 $101.32 $101.39 Other basic organic chemical manufacturing $2.76 $89.41 $92.17 Surgical and medical instrument manufacturing $0.00 $79.99 $79.99 Power generation and supply $1.50 $78.21 $79.71 Accounting and bookkeeping services $1.05 $76.79 $77.85 Monetary authorities and depository intermediaries $2.15 $69.82 $71.97 Commercial printing $2.56 $61.32 $63.88 Surgical appliance and supplies manufacturing $0.00 $53.99 $53.99 Colleges, universities and junior colleges $2.10 $45.13 $47.23 Truck transportation $1.57 $41.07 $42.63 Nondepository credit intermediation $1.11 $41.05 $42.16 Data processing services $1.45 $40.31 $41.75 Natural gas distribution $0.94 $38.12 $39.06 Other basic inorganic chemical manufacturing $1.68 $33.15 $34.84 Scientific research and development services $5.37 $23.80 $29.17 All other misc professional and technical services $3.43 $20.29 $23.72 Paperboard container manufacturing $4.18 $17.75 $21.93 Plastics packaging materials- film and sheet $1.93 $12.55 $14.48 $1.25 $12.67 $13.92 Other miscellaneous chemical product manufacturin Warehousing and storage $3.46 $8.25 $11.71 Plastics bottle manufacturing $2.04 $6.40 $8.44 Glass container manufacturing $1.09 $1.15 $2.24 Arizona Commodity Production* $16,370.19 $12,912.26 $3,260.78 $2,141.72 $2,751.35 $338.40 $1,012.70 $1,857.85 $1,643.20 $7,694.15 $4,352.27 $751.03 $909.59 $1,345.64 $1,862.11 $6,494.93 $2,266.81 $3,859.06 $121.50 $99.79 $4,919.68 $1,006.87 $4,115.69 $491.89 $265.15 $390.97 $2,435.78 $3,248.83 $737.31 $1,074.38 $129.11 $304.99 $837.48 $217.73 $40.37 $35.35 $475.31 $87.20 $0.00 Arizona Demand All Industries $12,092.21 $10,831.49 $1,734.37 $2,676.00 $4,136.42 $1,956.21 $907.69 $2,534.70 $1,409.71 $6,598.51 $5,299.03 $1,142.92 $833.44 $1,055.66 $923.99 $1,698.13 $3,155.27 $4,631.49 $449.98 $185.67 $3,102.05 $1,095.47 $5,985.75 $566.54 $265.24 $1,602.96 $2,524.18 $1,395.99 $552.98 $1,417.70 $194.31 $1,204.19 $458.80 $449.75 $277.00 $137.61 $480.22 $133.10 $33.44 Total Commodity Puchases (millions) $166.16 $4,868.32 $5,034.48 $92,859.38 $86,130.17 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 58 FIGURE C-3 ARIZONA SUPPLIER GAPS FOR INDUSTRIAL MACHINERY INDUSTRIES MILLIONS OF DOLLARS Supplier Industries Wholesale trade Iron and steel mills Management of companies and enterprises Ferrous metal foundaries Machine shops All other forging and stamping All other electronic component manufacturing Truck transportation Aluminum foundries Lessors of nonfinancial intangible assets AC, refrigeration and forced air heating Motor and generator manufacturing Speed changers, mechanical power transmission equipment Fabricated structural metal manufacturing Iron and steel forging Motor vehicle parts manufacturing Metal valve manufacturing Turned product and screw, nut and bolt manufacturing Telecommunications Semiconductor machinery manufacturing Plastics products Advertising and related services Monetary authorities and depository credit intermediaries All other miscellaneous professional and technical services Relay and industrial control manufacturing Other engine equipment manufacturing Real estate Other rubber product manufacturing Fluid power pump and motor manufacturing Power generation and supply Fluid power cylinder and actuator manufacturing Aluminum sheet, plate and foil manufacturing Securities, commodity contracts, investments Scientific research and development services Ball and roller bearing manufacturing Copper rolling, drawing and extruding Sheet metal work manufacturing Paperboard container manufacturing Cutting tool and machine tool accessory manufacturing Paint and coating manufacturing Supplier Requirements Industrial Machinery $121.18 $48.06 $37.70 $35.13 $23.40 $16.56 $16.28 $16.19 $15.57 $15.27 $15.21 $14.83 $14.48 $13.51 $13.38 $12.84 $12.54 $12.33 $11.83 $10.27 $9.88 $9.30 $9.25 $9.22 $9.17 $8.82 $7.43 $7.32 $7.03 $6.98 $6.75 $6.26 $5.54 $5.51 $5.39 $5.17 $5.12 $5.06 $5.00 $4.86 Arizona Commodity Production* $12,912.26 $129.70 $1,857.85 $77.50 $317.93 $157.65 $1,059.60 $2,435.78 $105.69 $6,494.93 $326.08 $20.74 $2.57 $220.88 $4.17 $797.02 $472.67 $85.34 $4,352.27 $414.16 $751.03 $2,266.81 $4,115.69 $837.48 $18.49 $9.07 $16,370.19 $51.32 $8.24 $4,919.68 $21.98 $197.14 $2,751.35 $304.99 $0.04 $201.28 $316.26 $217.73 $16.91 $38.59 Arizona Demand All Industries $10,831.49 $571.25 $2,534.70 $174.04 $387.99 $159.59 $1,350.04 $2,524.18 $112.50 $1,698.13 $392.26 $115.95 $40.21 $297.18 $61.39 $1,832.00 $512.91 $191.58 $5,299.03 $648.72 $1,142.92 $3,155.27 $5,985.75 $458.80 $102.76 $129.63 $12,092.21 $157.01 $19.77 $3,102.05 $39.97 $214.94 $4,136.42 $1,204.19 $82.62 $119.34 $308.00 $449.75 $60.23 $297.60 Total Commodity Puchases (millions) $615.64 $65,659.02 $62,994.37 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 59 FIGURE C-4 ARIZONA SUPPLIER GAPS FOR TELECOMMUNICATIONS INDUSTRIES MILLIONS OF DOLLARS Supplier Requirements Communication TelecomTelecomm Supplier Industries Equipment munication Total Telecommunications $2.31 $641.54 $643.85 Architectural and engineering services $4.60 $107.05 $111.65 Telephone apparatus manufacturing $6.43 $85.93 $92.36 Advertising and related services $2.23 $81.46 $83.68 Broadcast and wireless communications equipment $74.61 $0.22 $74.83 Lessors of nonfinancial intangible assets $36.54 $25.92 $62.45 Wholesale trade $25.96 $30.26 $56.22 Accounting and bookkeeping services $0.87 $51.77 $52.64 All other electronic component manufacturing $32.28 $13.44 $45.72 Machinery and equipment rental and leasing $0.55 $36.53 $37.08 Real estate $2.01 $28.10 $30.10 Household goods repair and maintenance $0.09 $27.71 $27.80 Specialized design services $0.05 $26.23 $26.27 All other miscellaneous professional and technical $2.29 $21.95 $24.24 Monetary authorities and depositoryintermediaries $2.42 $21.03 $23.45 Commercial printing $0.01 $19.96 $19.97 Semiconductors and related device manufacturing $10.02 $7.11 $17.14 Legal services $1.13 $12.81 $13.94 Other communication and energy wire manufacturin $2.85 $10.67 $13.52 Management of companies and enterprises $7.45 $5.89 $13.33 Nondepository credit intermediation $1.20 $8.76 $9.96 Plastics products $1.92 $5.25 $7.17 Fiber optic cable manufacturing $1.70 $5.25 $6.95 All other forging and stamping $1.67 $4.69 $6.35 Securities, commodity contracts, investments $1.40 $3.73 $5.13 Sheet metal work manufacturing $2.81 $0.40 $3.22 Custom roll forming $2.91 $0.18 $3.09 Arizona Commodity Production* $4,352.27 $2,998.84 $140.47 $2,266.81 $423.20 $6,494.93 $12,912.26 $1,006.87 $1,059.60 $1,219.21 $16,370.19 $490.64 $354.96 $837.48 $4,115.69 $491.89 $1,799.33 $2,141.72 $118.17 $1,857.85 $3,248.83 $751.03 $3.17 $157.65 $2,751.35 $316.26 $26.81 Arizona Demand All Industries $5,299.03 $3,164.91 $285.03 $3,155.27 $770.99 $1,698.13 $10,831.49 $1,095.47 $1,350.04 $883.56 $12,092.21 $370.99 $370.89 $458.80 $5,985.75 $566.54 $790.04 $2,676.00 $224.27 $2,534.70 $1,395.99 $1,142.92 $67.93 $159.59 $4,136.42 $308.00 $57.67 Total Commodity Puchases (millions) $228.30 $1,283.82 $1,512.12 $68,707.49 $61,872.62 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 60 FIGURE C-5 ARIZONA SUPPLIER GAPS FOR HIGH TECH INSTRUMENT INDUSTRIES MILLIONS OF DOLLARS Supplier Industries Wholesale trade All other electronic component manufacturing Management of companies and enterprises Business support services Surgical and medical instrument manufacturing Plastics products Advertising and related services Paperboard container manufacturing Electricity and signal testing instruments Legal services Textile and fabric finishing mills Architectural and engineering services Surgical appliance and supplies manufacturing Scientific research and development services Telecommunications Nonwoven fabric mills Plastics material and resin manufacturing Monetary authorities and depository intermediaries All other miscellaneous professional and technical Semiconductors and related device manufacturing Plastics packaging materials- film and sheet Truck transportation Real estate All other forging and stamping Lessors of nonfinancial intangible assets Metal coating and nonprecious engraving Warehousing and storage Broadcast and wireless communications equipment Iron and steel mills Machine shops Specialized design services Power generation and supply Electronic computer manufacturing Sheet metal work manufacturing Securities, commodity contracts, investments Gasket, packing and sealing device manufacturing Supplier Requirements High Tech Instruments $76.15 $38.96 $32.03 $21.32 $14.52 $12.73 $12.02 $9.14 $9.09 $9.08 $8.53 $8.25 $8.15 $7.90 $7.66 $7.36 $7.17 $7.13 $6.84 $6.79 $6.74 $6.43 $6.36 $6.33 $5.88 $5.47 $5.33 $5.30 $5.16 $5.05 $4.68 $4.53 $4.43 $4.40 $4.15 $4.08 Arizona Commodity Production* $12,912.26 $1,059.60 $1,857.85 $1,862.11 $99.79 $751.03 $2,266.81 $217.73 $51.39 $2,141.72 $9.89 $2,998.84 $265.15 $304.99 $4,352.27 $3.73 $82.52 $4,115.69 $837.48 $1,799.33 $40.37 $2,435.78 $16,370.19 $157.65 $6,494.93 $72.62 $475.31 $423.20 $129.70 $317.93 $354.96 $4,919.68 $568.29 $316.26 $2,751.35 $6.85 Arizona Demand All Industries $10,831.49 $1,350.04 $2,534.70 $923.99 $185.67 $1,142.92 $3,155.27 $449.75 $83.11 $2,676.00 $34.44 $3,164.91 $265.24 $1,204.19 $5,299.03 $40.97 $318.05 $5,985.75 $458.80 $790.04 $277.00 $2,524.18 $12,092.21 $159.59 $1,698.13 $154.18 $480.22 $770.99 $571.25 $387.99 $370.89 $3,102.05 $781.87 $308.00 $4,136.42 $98.08 Total Commodity Puchases (millions) $395.15 $73,825.25 $68,807.41 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 61 FIGURE C-6 ARIZONA SUPPLIER GAPS FOR FOREST PRODUCTS INDUSTRIES MILLIONS OF DOLLARS Supplier Requirements Wood Paper Products Products $80.70 $46.26 $110.91 $9.07 $94.44 $15.80 $0.41 $93.82 $29.70 $17.70 $33.63 $0.00 $11.30 $12.04 $7.16 $15.21 $4.81 $13.46 $8.83 $9.01 $16.05 $0.01 $0.00 $13.68 $13.38 $0.03 $11.26 $0.01 $5.20 $5.51 $2.63 $7.69 $5.62 $4.02 $9.82 $0.00 $5.49 $3.75 $4.99 $3.60 $3.77 $4.05 $2.44 $4.81 $0.67 $6.74 $4.37 $2.80 $4.04 $2.92 $0.00 $0.00 $2.46 $2.51 Arizona Commodity Production* $12,912.26 $22.65 $26.71 $113.96 $2,435.78 $20.84 $5,808.50 $1,857.85 $1,074.38 $4,919.68 $44.47 $6.05 $1.59 $10.10 $834.42 $217.73 $4,115.69 $14.67 $837.48 $333.58 $104.55 $42.77 $121.50 $82.52 $1,059.60 $493.87 $16,370.19 Arizona Demand All Industries $10,831.49 $461.04 $20.60 $676.03 $2,524.18 $18.85 $4,104.53 $2,534.70 $1,417.70 $3,102.05 $104.95 $16.16 $169.42 $56.85 $534.52 $449.75 $5,985.75 $171.43 $458.80 $450.47 $97.80 $2,744.31 $449.98 $318.05 $1,350.04 $198.88 $12,092.21 Total Commodity Puchases (millions) $18.40 $474.07 $294.48 $786.94 $53,883.37 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps $51,340.54 Logging & Supplier Industries Forest Pdts Wholesale trade $0.86 Sawmills $0.03 Logging $3.36 Paper and paperboard mills $0.00 Truck transportation $0.05 Forest nurseries, forest products and timber tracts $6.31 Automotive repair and maintenance $0.56 Management of companies and enterprises $0.13 Natural gas distribution $0.22 Power generation and supply $0.02 Miscellaneous wood product manufacturing $0.00 Pulp mills $0.00 Veneer and plywood manufacturing $0.00 Cut stock, resawing lumber and planing $0.00 Commercial machinery repair and maintenance $0.26 Paperboard container manufacturing $0.00 Monetary authorities and depository intermediaries $0.22 Reconstituted wood product manufacturing $0.00 All other miscellaneous professional and technical $0.02 Rail transportation $0.01 Adhesive manufacturing $0.00 Petroleum refineries $0.34 Other basic organic chemical manufacturing $0.00 Plastics material and resin manufacturing $0.00 All other electronic component manufacturing $0.00 Agriculture and forestry support activities $5.91 Real estate $0.11 Forest Pdts Total $127.82 $120.00 $113.59 $94.24 $47.44 $39.94 $23.90 $22.50 $18.49 $17.86 $16.06 $13.68 $13.41 $11.27 $10.97 $10.32 $9.86 $9.82 $9.26 $8.59 $7.82 $7.58 $7.41 $7.17 $6.95 $5.91 $5.08 62 FIGURE C-7 ARIZONA SUPPLIER GAPS FOR ENGINEERING RESEARCH SERVICES MILLIONS OF DOLLARS Supplier Industries Guided missile and space vehicle manufacturing Real estate Employment services Glass and glass products- except glass containers Legal services Wholesale trade Commercial printing Telecommunications Office administrative services All other miscellaneous professional and technical Management consulting services Architectural and engineering services Periodical publishers Maintenance and repair of nonresidential buildings Broadcast and wireless communications equipment Computer systems design services Power generation and supply Advertising and related services Services to buildings and dwellings Other basic organic chemical manufacturing Postal service Machinery and equipment rental and leasing Automotive equipment rental and leasing Data processing services Electroplating, anodizing and coloring metal Monetary authorities and depository intermediaries Commercial machinery repair and maintenance Supplier Requirements Engineering Services $19.96 $2.70 $1.72 $1.44 $1.18 $1.11 $1.09 $0.82 $0.80 $0.76 $0.69 $0.69 $0.64 $0.64 $0.60 $0.58 $0.57 $0.56 $0.50 $0.42 $0.38 $0.34 $0.34 $0.32 $0.32 $0.30 $0.29 Arizona Commodity Production* $2,890.32 $16,370.19 $3,260.78 $96.08 $2,141.72 $12,912.26 $491.89 $4,352.27 $909.59 $837.48 $1,643.20 $2,998.84 $138.07 $750.57 $423.20 $677.91 $4,919.68 $2,266.81 $1,345.64 $121.50 $1,012.70 $1,219.21 $3,017.58 $737.31 $54.55 $4,115.69 $834.42 Arizona Demand All Industries $1,173.37 $12,092.21 $1,734.37 $223.04 $2,676.00 $10,831.49 $566.54 $5,299.03 $833.44 $458.80 $1,409.71 $3,164.91 $331.27 $1,672.57 $770.99 $874.31 $3,102.05 $3,155.27 $1,055.66 $449.98 $907.69 $883.56 $1,408.71 $552.98 $97.85 $5,985.75 $534.52 Total Commodity Puchases (millions) $39.76 $70,539.47 $62,246.08 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 63 FIGURE C-8 ARIZONA SUPPLIER GAPS FOR TRANSPORTATION & LOGISTICS INDUSTRIES MILLIONS OF DOLLARS Supplier Industries Truck transportation Automotive repair and maintenance Scenic and sightseeing transportation and support Wholesale trade Petroleum refineries Insurance carriers Motor vehicle parts manufacturing Machinery and equipment rental and leasing Warehousing and storage Automotive equipment rental and leasing Telecommunications Management of companies and enterprises Real estate Management consulting services Other computer related services Rail transportation Lessors of nonfinancial intangible assets Advertising and related services Monetary authorities and depository intermediaries Railroad rolling stock manufacturing Accounting and bookkeeping services Computer systems design services Tire manufacturing Nondepository credit intermediation Pump and pumping equipment manufacturing Wood preservation Ferrous metal foundaries Other communications equipment manufacturing Other concrete product manufacturing Total Commodity Puchases (millions) Source: Minnesota IMPLAN Group, 2001 Data. Supplier Requirements Rail Truck Transport Transport Transport Total $1.26 $269.76 $271.02 $0.01 $156.73 $156.74 $35.62 $101.57 $137.19 $9.23 $114.63 $123.86 $8.27 $112.23 $120.50 $0.14 $65.25 $65.40 $3.42 $43.51 $46.92 $34.85 $9.87 $44.72 $0.02 $37.75 $37.77 $0.29 $31.46 $31.75 $0.23 $28.02 $28.25 $0.00 $25.86 $25.86 $1.30 $22.42 $23.72 $4.35 $16.63 $20.98 $5.24 $12.91 $18.15 $0.82 $16.77 $17.59 $4.69 $12.36 $17.05 $1.66 $14.56 $16.22 $2.08 $12.83 $14.91 $14.07 $0.00 $14.07 $3.35 $7.67 $11.02 $7.33 $3.59 $10.91 $0.01 $10.13 $10.14 $0.90 $5.46 $6.35 $4.59 $0.00 $4.59 $4.34 $0.00 $4.34 $3.23 $0.00 $3.23 $3.03 $0.00 $3.03 $1.44 $0.00 $1.44 $155.75 $1,131.96 $1,287.72 Arizona Commodity Production* $2,435.78 $5,808.50 $697.27 $12,912.26 $42.77 $3,859.06 $797.02 $1,219.21 $475.31 $3,017.58 $4,352.27 $1,857.85 $16,370.19 $1,643.20 $168.94 $333.58 $6,494.93 $2,266.81 $4,115.69 $4.19 $1,006.87 $677.91 $7.27 $3,248.83 $2.64 $2.65 $77.50 $22.80 $146.74 Arizona Demand All Industries $2,524.18 $4,104.53 $673.00 $10,831.49 $2,744.31 $4,631.49 $1,832.00 $883.56 $480.22 $1,408.71 $5,299.03 $2,534.70 $12,092.21 $1,409.71 $303.82 $450.47 $1,698.13 $3,155.27 $5,985.75 $30.93 $1,095.47 $874.31 $232.14 $1,395.99 $57.98 $96.66 $174.04 $94.48 $177.12 $74,065.59 $67,271.70 * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 64 FIGURE C-9 ARIZONA SUPPLIER GAPS FOR AGRICULTURE, FOOD PROCESSING AND AG TECHNOLOGY INDUSTRIES MILLIONS OF DOLLARS Supplier Industries Cattle ranching and farming Wholesale trade Grain farming Other animal food manufacturing Real estate All other crop farming Agriculture and forestry support activities Poultry and egg production Truck transportation Animal production- except cattle and poultry Management of companies and enterprises Animal slaughtering, except poultry Paperboard container manufacturing Petroleum refineries Lessors of nonfinancial intangible assets Oilseed farming Metal can, box and other container manufacturing Pesticide and other agricultural chemical mfg Soybean processing Power generation and supply Insurance carriers Advertising and related services Monetary authorities and depository intermediaries Automotive repair and maintenance Flavoring syrup and concentrate manufacturing Warehousing and storage Phosphatic fertilizer manufacturing Cheese manufacturing Fluid milk manufacturing Plastics packaging materials- film and sheet Natural gas distribution Rail transportation Poultry processing Flour milling Plastics bottle manufacturing Wet corn milling Plastics plumbing fixtures and all other plastics Vegetable and melon farming All other miscellaneous professional and technical svcs Glass container manufacturing Rendering and meat byproduct processing Dry- condensed- and evaporated dairy products Iron and steel mills Veterinary services Motor vehicle parts manufacturing Agriculture $156.87 $131.66 $121.09 $166.12 $172.66 $164.19 $164.45 $17.46 $31.13 $9.18 $0.00 $0.13 $1.94 $71.61 $0.00 $9.70 $0.00 $55.24 $13.43 $28.25 $30.27 $4.53 $19.75 $16.40 $0.00 $18.77 $30.81 $0.00 $0.00 $0.49 $2.83 $12.43 $0.00 $2.10 $0.00 $0.48 $2.59 $4.11 $0.40 $0.08 $3.06 $0.19 $0.00 $14.47 $4.82 Supplier Requirements Food Farm & Garden Processing Equipment $329.53 $0.00 $262.69 $22.05 $80.28 $0.00 $15.75 $0.00 $8.64 $0.40 $8.60 $0.00 $0.00 $0.00 $118.96 $0.00 $65.23 $5.53 $81.37 $0.00 $76.37 $4.97 $80.23 $0.00 $73.78 $0.19 $2.53 $0.13 $69.43 $0.09 $53.01 $0.00 $55.71 $0.00 $0.00 $0.00 $38.60 $0.00 $19.14 $0.79 $15.70 $0.44 $37.13 $1.77 $21.75 $1.71 $23.91 $1.16 $38.80 $0.00 $13.71 $0.57 $0.00 $0.00 $29.88 $0.00 $29.77 $0.00 $27.70 $0.00 $24.16 $0.74 $14.84 $0.39 $26.36 $0.00 $22.04 $0.00 $23.76 $0.00 $22.42 $0.00 $16.17 $3.18 $17.13 $0.00 $18.13 $1.59 $19.99 $0.00 $15.80 $0.00 $15.31 $0.00 $0.04 $14.86 $0.00 $0.00 $1.12 $8.23 Agriculture Total $486.41 $416.41 $201.37 $181.88 $181.70 $172.79 $164.45 $136.41 $101.89 $90.55 $81.34 $80.36 $75.91 $74.28 $69.52 $62.70 $55.71 $55.24 $52.03 $48.18 $46.41 $43.42 $43.21 $41.48 $38.80 $33.05 $30.81 $29.88 $29.77 $28.19 $27.73 $27.65 $26.36 $24.14 $23.76 $22.90 $21.93 $21.24 $20.12 $20.07 $18.86 $15.50 $14.90 $14.47 $14.17 Arizona Commodity Production* $1,139.49 $12,912.26 $37.22 $70.47 $16,370.19 $173.30 $493.87 $13.35 $2,435.78 $40.12 $1,857.85 $379.52 $217.73 $42.77 $6,494.93 $26.13 $132.94 $49.08 $0.30 $4,919.68 $3,859.06 $2,266.81 $4,115.69 $5,808.50 $7.71 $475.31 $46.33 $7.08 $384.53 $40.37 $1,074.38 $333.58 $6.24 $14.24 $87.20 $1.25 $751.03 $802.95 $837.48 $0.00 $28.83 $138.32 $129.70 $265.14 $797.02 Arizona Demand All Industries $733.50 $10,831.49 $178.98 $116.48 $12,092.21 $244.25 $198.88 $72.20 $2,524.18 $185.16 $2,534.70 $580.29 $449.75 $2,744.31 $1,698.13 $3.63 $194.06 $77.74 $39.18 $3,102.05 $4,631.49 $3,155.27 $5,985.75 $4,104.53 $172.27 $480.22 $90.69 $273.35 $335.97 $277.00 $1,417.70 $450.47 $501.55 $59.68 $133.10 $71.66 $1,142.92 $250.99 $458.80 $33.44 $25.08 $136.40 $571.25 $208.99 $1,832.00 65 FIGURE C-9 (continued) ARIZONA SUPPLIER GAPS FOR AGRICULTURE, FOOD PROCESSING AND AG TECHNOLOGY INDUSTRIES MILLIONS OF DOLLARS Supplier Requirements Food Farm & Garden Processing Equipment $2.99 $0.00 $13.23 $0.00 $0.00 $11.72 $0.00 $0.49 $0.08 $0.00 $6.69 $2.82 $2.04 $6.13 $6.17 $1.49 $0.29 $3.97 $0.00 $6.28 $0.00 $3.80 $0.11 $3.15 $0.26 $2.79 $0.16 $2.54 $1.07 $1.24 $0.00 $1.92 $0.00 $1.85 $0.00 $1.81 $0.07 $1.66 $0.04 $1.11 $0.00 $1.67 $0.08 $1.07 Arizona Commodity Production* $79.16 $81.84 $9.07 $41.57 $5.76 $2,998.84 $157.65 $317.93 $7.27 $77.50 $2.57 $316.26 $472.67 $85.34 $1,059.60 $8.24 $105.69 $4.17 $38.59 $14.14 $21.98 $0.04 Arizona Demand All Industries $252.08 $460.39 $129.63 $58.36 $35.97 $3,164.91 $159.59 $387.99 $232.14 $174.04 $40.21 $308.00 $512.91 $191.58 $1,350.04 $19.77 $112.50 $61.39 $297.60 $36.79 $39.97 $82.62 Total Commodity Puchases (millions) $1,519.56 $1,948.75 $126.31 $3,594.62 $75,991.61 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps $73,510.19 Supplier Industries Agriculture Greenhouse and nursery production $10.55 Fruit and vegetable canning and drying $0.00 Other engine equipment manufacturing $0.00 Farm machinery and equipment manufacturing $10.55 Industrial truck, trailer and stacker manufacturing $9.60 Architectural and engineering services $0.00 All other forging and stamping $0.40 Machine shops $0.41 Tire manufacturing $3.78 Ferrous metal foundaries $0.00 Speed changers, mechanical power transmission equip. $0.00 Sheet metal work manufacturing $0.00 Metal valve manufacturing $0.00 Turned product and screw, nut and bolt manufacturing $0.00 All other electronic component manufacturing $0.00 Fluid power pump and motor manufacturing $0.00 Aluminum foundries $0.00 Iron and steel forging $0.00 Paint and coating manufacturing $0.07 Rubber and plastics hose and belting manufacturing $0.52 Fluid power cylinder and actuator manufacturing $0.00 Ball and roller bearing manufacturing $0.00 Agriculture Total $13.54 $13.23 $11.72 $11.04 $9.68 $9.52 $8.57 $8.07 $8.05 $6.28 $3.80 $3.26 $3.05 $2.69 $2.31 $1.92 $1.85 $1.81 $1.80 $1.67 $1.67 $1.15 66 FIGURE C-10 ARIZONA SUPPLIER GAPS FOR AEROSPACE, AVIONICS AND DEFENSE INDUSTRIES MILLIONS OF DOLLARS Supplier Requirements Search & Nav. Aircraft and Aerospace Supplier Industries Instruments Space Vehicles Total Wholesale trade $67.36 $378.93 $446.29 Other aircraft parts and equipment $0.00 $379.91 $379.91 Search, detection and navigation instruments $0.86 $299.99 $300.85 Aircraft engine and engine parts manufacturing $0.00 $285.19 $285.19 Broadcast and wireless communications equipment $54.99 $183.62 $238.62 Guided missile and space vehicle manufacturing $0.00 $209.99 $209.99 All other electronic component manufacturing $77.02 $132.50 $209.52 Management of companies and enterprises $34.53 $159.15 $193.67 Propulsion units and parts for space vehicles $0.00 $165.83 $165.83 Architectural and engineering services $14.50 $99.05 $113.55 Scientific research and development services $11.75 $76.83 $88.58 Metal valve manufacturing $0.02 $67.25 $67.27 Monetary authorities and depository credit intermediaries $7.97 $51.41 $59.39 Miscellaneous fabricated metal products $0.07 $56.30 $56.37 All other miscellaneous professional and technical services $7.32 $48.40 $55.71 Plastics products $4.59 $50.71 $55.30 Warehousing and storage $5.72 $48.44 $54.17 Semiconductors and related device manufacturing $25.75 $27.86 $53.61 Machine shops $5.20 $47.38 $52.58 Aluminum sheet, plate and foil manufacturing $0.35 $47.41 $47.76 Legal services $6.19 $37.22 $43.42 Securities, commodity contracts, investments $5.16 $35.05 $40.21 Power generation and supply $6.19 $33.64 $39.83 Turned product and screws, nuts and bolts $2.69 $36.20 $38.89 Ball and roller bearing manufacturing $0.03 $35.86 $35.90 Aluminum foundries $0.17 $32.53 $32.69 Nonferrous forging $0.14 $32.38 $32.52 All other forging and stamping $7.03 $25.30 $32.32 Data processing services $5.34 $25.91 $31.24 Hardware manufacturing $0.02 $30.93 $30.94 Nondepository credit intermediation $3.92 $25.79 $29.71 Telecommunications $5.84 $23.62 $29.45 Iron and steel forging $0.28 $29.14 $29.42 Fabricated structural metal manufacturing $0.06 $28.91 $28.97 Specialized design services $0.21 $28.19 $28.40 Real estate $7.96 $19.44 $27.40 Other communication and energy wire manufacturing $7.18 $19.69 $26.87 Iron and steel mills $1.75 $25.10 $26.85 Custom computer programming services $8.29 $17.88 $26.17 Ferrous metal foundaries $0.59 $23.60 $24.19 Aircraft manufacturing $0.00 $22.60 $22.60 Electroplating, anodizing and coloring metal $4.82 $17.76 $22.58 Wiring device manufacturing $3.21 $18.30 $21.51 Metal coating and nonprecious engraving $2.72 $17.60 $20.32 Advertising and related services $3.18 $13.21 $16.38 Computer systems design services $4.31 $10.44 $14.75 Fiber optic cable manufacturing $13.45 $0.95 $14.40 Lessors of nonfinancial intangible assets $4.99 $7.32 $12.31 Sheet metal work manufacturing $6.96 $2.34 $9.30 Relay and industrial control manufacturing $6.83 $2.44 $9.28 Electronic computer manufacturing $7.32 $0.00 $7.32 Custom roll forming $6.32 $0.23 $6.56 Electricity and signal testing instruments $4.75 $0.00 $4.75 Arizona Commodity Production* $12,912.26 $382.55 $1,108.23 $672.86 $423.20 $2,890.32 $1,059.60 $1,857.85 $478.33 $2,998.84 $304.99 $472.67 $4,115.69 $63.49 $837.48 $751.03 $475.31 $1,799.33 $317.93 $197.14 $2,141.72 $2,751.35 $4,919.68 $85.34 $0.04 $105.69 $0.39 $157.65 $737.31 $60.50 $3,248.83 $4,352.27 $4.17 $220.88 $354.96 $16,370.19 $118.17 $129.70 $1,261.38 $77.50 $844.33 $54.55 $40.25 $72.62 $2,266.81 $677.91 $3.17 $6,494.93 $316.26 $18.49 $568.29 $26.81 $51.39 Arizona Demand All Industries $10,831.49 $521.51 $1,071.01 $1,091.42 $770.99 $1,173.37 $1,350.04 $2,534.70 $1,214.39 $3,164.91 $1,204.19 $512.91 $5,985.75 $211.01 $458.80 $1,142.92 $480.22 $790.04 $387.99 $214.94 $2,676.00 $4,136.42 $3,102.05 $191.58 $82.62 $112.50 $45.32 $159.59 $552.98 $212.66 $1,395.99 $5,299.03 $61.39 $297.18 $370.89 $12,092.21 $224.27 $571.25 $1,357.70 $174.04 $1,284.38 $97.85 $226.02 $154.18 $3,155.27 $874.31 $67.93 $1,698.13 $308.00 $102.76 $781.87 $57.67 $83.11 Total Commodity Puchases (millions) $455.90 $3,495.71 $3,951.60 $82,652.59 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps $77,119.74 67 FIGURE C-11 ARIZONA SUPPLIER GAPS FOR OTHER HIGH TECH INDUSTRIES MILLIONS OF DOLLARS Supplier Industries All other electronic component manufacturing Wholesale trade Broadcast and wireless communications equipment Architectural and engineering services Semiconductors and related device manufacturing Management of companies and enterprises Semiconductor machinery manufacturing Real estate Environmental and other technical consulting svcs Employment services Lessors of nonfinancial intangible assets Telecommunications Computer systems design services Monetary authorities and depository intermediation Advertising and related services Scientific research and development services Legal services All other miscellaneous professional and technical svcs Electron tube manufacturing Automotive repair and maintenance Power generation and supply Plastics plumbing fixtures and all other plastics Plastics packaging materials, film and sheet Office administrative services Securities, commodity contracts, investments Other support services Food services and drinking places Warehousing and storage Data processing services Hotels and motels, including casino hotels Management consulting services Nondepository credit intermediation Custom computer programming services Postal service Accounting and bookkeeping services Truck transportation Paperboard container manufacturing Services to buildings and dwellings Machine shops Other basic inorganic chemical manufacturing Couriers and messengers Commercial machinery repair and maintenance Maintenance and repair of nonresidential buildings Machinery and equipment rental and leasing Electroplating, anodizing, and coloring metal Other basic organic chemical manufacturing Plastics material and resin manufacturing Commercial printing Paper and paperboard mills Photographic film and chemical manufacturing Other miscellaneous chemical product manufacturing Coated and laminated paper and packaging materials Sound recording industries Magnetic and optical recording media manufacturing Audio and video media reproduction Supplier Requirements Photographic Media Architecture Equipment Recording & & & Supplies Reproduction Electronics Engineering $0.53 $0.05 $417.17 $0.57 $7.24 $0.69 $363.81 $6.15 $0.24 $0.00 $194.87 $0.00 $0.28 $0.06 $49.60 $129.93 $0.32 $0.01 $114.48 $0.17 $1.06 $0.15 $97.38 $7.56 $0.00 $0.00 $85.58 $0.00 $0.14 $0.26 $21.39 $60.58 $0.01 $0.00 $1.01 $75.62 $0.08 $0.15 $4.66 $56.99 $1.45 $0.06 $55.08 $4.80 $0.18 $0.15 $24.72 $28.79 $0.09 $0.03 $40.11 $6.73 $0.42 $0.10 $28.40 $16.48 $0.11 $0.91 $31.90 $10.14 $0.28 $0.04 $38.56 $3.42 $0.07 $0.07 $28.59 $10.99 $0.43 $0.08 $25.29 $12.12 $0.00 $0.00 $37.29 $0.00 $1.15 $0.09 $29.11 $6.08 $0.31 $0.07 $24.90 $7.03 $0.42 $0.14 $30.08 $0.79 $0.73 $0.12 $27.86 $0.07 $0.02 $0.07 $1.67 $25.98 $0.21 $0.04 $17.96 $7.36 $0.05 $0.01 $3.70 $21.43 $0.18 $0.05 $11.34 $12.62 $0.20 $0.03 $21.78 $1.52 $0.09 $0.03 $13.28 $9.31 $0.14 $0.04 $8.63 $13.30 $0.14 $0.05 $8.63 $12.22 $0.20 $0.05 $13.97 $6.76 $0.75 $0.07 $15.77 $4.08 $0.04 $0.05 $1.90 $18.27 $0.13 $0.07 $9.93 $10.02 $0.83 $0.06 $17.96 $1.21 $0.92 $0.01 $16.22 $1.95 $0.03 $0.05 $2.12 $16.74 $0.61 $0.03 $17.65 $0.61 $0.85 $0.00 $17.26 $0.00 $0.10 $0.05 $6.60 $11.31 $0.53 $0.04 $13.41 $2.84 $0.25 $0.04 $8.38 $6.49 $0.16 $0.05 $7.70 $6.90 $0.32 $0.01 $13.32 $0.00 $0.96 $0.00 $11.49 $0.22 $0.30 $0.14 $8.53 $0.00 $0.00 $0.06 $0.05 $7.54 $2.82 $0.12 $2.19 $2.17 $3.95 $0.00 $2.43 $0.50 $0.38 $0.00 $3.45 $0.03 $0.35 $0.01 $1.17 $0.97 $0.00 $1.03 $0.00 $0.53 $0.00 $0.23 $0.05 $0.84 $0.00 $0.67 $0.00 $0.00 High Tech Total $418.32 $377.89 $195.12 $179.87 $114.98 $106.16 $85.58 $82.37 $76.64 $61.89 $61.39 $53.84 $46.96 $45.40 $43.07 $42.30 $39.72 $37.92 $37.29 $36.43 $32.31 $31.43 $28.78 $27.74 $25.58 $25.19 $24.20 $23.53 $22.71 $22.11 $21.04 $20.99 $20.67 $20.26 $20.15 $20.07 $19.10 $18.94 $18.90 $18.11 $18.06 $16.82 $15.16 $14.80 $13.66 $12.67 $8.97 $7.65 $7.30 $6.88 $3.86 $2.50 $1.55 $1.11 $0.67 Total Commodity Puchases (millions) $31.10 $6.38 $2,050.37 $648.75 $2,736.60 Source: Minnesota IMPLAN Group, 2001 Data. * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps Arizona Commodity Production* $1,059.60 $12,912.26 $423.20 $2,998.84 $1,799.33 $1,857.85 $414.16 $16,370.19 $333.36 $3,260.78 $6,494.93 $4,352.27 $677.91 $4,115.69 $2,266.81 $304.99 $2,141.72 $837.48 $5.74 $5,808.50 $4,919.68 $751.03 $40.37 $909.59 $2,751.35 $422.74 $7,694.15 $475.31 $737.31 $1,724.61 $1,643.20 $3,248.83 $1,261.38 $1,012.70 $1,006.87 $2,435.78 $217.73 $1,345.64 $317.93 $129.11 $889.39 $834.42 $750.57 $1,219.21 $54.55 $121.50 $82.52 $491.89 $113.96 $46.29 $35.35 $56.48 $14.38 $28.31 $6.21 Arizona Demand All Industries $1,350.04 $10,831.49 $770.99 $3,164.91 $790.04 $2,534.70 $648.72 $12,092.21 $270.74 $1,734.37 $1,698.13 $5,299.03 $874.31 $5,985.75 $3,155.27 $1,204.19 $2,676.00 $458.80 $20.97 $4,104.53 $3,102.05 $1,142.92 $277.00 $833.44 $4,136.42 $636.35 $6,598.51 $480.22 $552.98 $1,052.76 $1,409.71 $1,395.99 $1,357.70 $907.69 $1,095.47 $2,524.18 $449.75 $1,055.66 $387.99 $194.31 $1,007.68 $534.52 $1,672.57 $883.56 $97.85 $449.98 $318.05 $566.54 $676.03 $112.33 $137.61 $184.73 $183.34 $73.41 $52.18 $106,225.93 $96,206.68 68 FIGURE C-11 ARIZONA SUPPLIER GAPS TO STATE AND LOCAL GOVERNMENT (NON-EDUCATION) MILLIONS OF DOLLARS Supplier Industries State & Local Non-Education Real estate Securities, commodity contracts, investments Monetary authorities and depository credit intermediaries Wholesale trade Telecommunications Employment services Legal services Services to buildings and dwellings Food services and drinking places Postal service Hotels and motels Management consulting services Electronic equipment repair and maintenance Accounting and bookkeeping services Other State and local government enterprises Data processing services State and local government electric utilities Investigation and security services Truck transportation Waste management and remediation services Total Commodity Puchases (millions) Source: Minnesota IMPLAN Group, 2001 Data. Supplier Requirements State & Local Govt $7,161.99 $406.67 $278.41 $271.60 $251.84 $246.19 $210.03 $187.16 $158.84 $156.44 $149.95 $138.33 $114.51 $103.54 $100.09 $92.32 $90.25 $71.70 $64.39 $62.27 $59.28 $10,375.77 Arizona Commodity Production* $5,804.53 $16,370.19 $2,751.35 $4,115.69 $12,912.26 $4,352.27 $3,260.78 $2,141.72 $1,345.64 $7,694.15 $1,012.70 $1,724.61 $1,643.20 $655.96 $1,006.87 $824.13 $737.31 $0.00 $428.23 $2,435.78 $580.41 Arizona Demand All Industries $5,804.53 $12,092.21 $4,136.42 $5,985.75 $10,831.49 $5,299.03 $1,734.37 $2,676.00 $1,055.66 $6,598.51 $907.69 $1,052.76 $1,409.71 $498.12 $1,095.47 $804.61 $552.98 $0.00 $414.58 $2,524.18 $649.74 $71,797.77 $66,123.82 * Represents net commodity supply=industry commodity production + non-industry commodity production - foreign exports. Industries in bold represent potential supplier gaps 69 APPENDIX D 70 Demand from Industries of Supplier Industries Opportunity Wholesale trade $2,072.12 Telecommunications $1,162.83 Real estate $878.41 All other electronic component manufacturing $782.34 Management of companies and enterprises $531.59 $525.31 Truck transportation Monetary authorities and depository intermediaries $517.36 Broadcast and wireless communications equipment $514.47 Cattle ranching and farming $486.41 Employment services $456.09 Architectural and engineering services $452.31 $379.91 Other aircraft parts and equipment Securities- commodity contracts- investments $376.84 Advertising and related services $371.77 Legal services $315.92 Lessors of nonfinancial intangible assets $309.08 Automotive repair and maintenance $305.42 Search, detection and navigation instruments $300.85 $285.19 Aircraft engine and engine parts manufacturing Guided missile and space vehicle manufacturing $229.95 Services to buildings and dwellings $224.08 Food services and drinking places $209.77 Semiconductors and related device manufacturing $209.65 Petroleum refineries $202.36 Grain farming $201.37 Postal service $199.14 Accounting and bookkeeping services $198.78 Data processing services $188.71 Hotels and motels- including casino hotels $186.34 Other animal food manufacturing $181.88 Management consulting services $180.96 All other crop farming $172.79 Agriculture and forestry support activities $170.37 $165.83 Propulsion units and parts for space vehicles Power generation and supply $164.14 All other miscellaneous professional and technical service $164.07 Warehousing and storage $153.83 Computer systems design services $145.23 $144.30 Scientific research and development services Plastics products $138.44 Scenic and sightseeing transportation and support $137.19 Poultry and egg production $136.41 Machinery and equipment rental and leasing $121.29 $120.00 Sawmills $119.54 Paperboard container manufacturing Electronic equipment repair and maintenance $113.65 Logging $113.59 Insurance carriers $111.80 Office administrative services $108.86 $107.99 Machine shops Source: Minnesota IMPLAN Group, 2001 Data. 71 Arizona Commodity Production $12,912.26 $4,352.27 $16,370.19 $1,059.60 $1,857.85 $2,435.78 $4,115.69 $423.20 $1,139.49 $3,260.78 $2,998.84 $382.55 $2,751.35 $2,266.81 $2,141.72 $6,494.93 $5,808.50 $1,108.23 $672.86 $2,890.32 $1,345.64 $7,694.15 $1,799.33 $42.77 $37.22 $1,012.70 $1,006.87 $737.31 $1,724.61 $70.47 $1,643.20 $173.30 $493.87 $478.33 $4,919.68 $837.48 $475.31 $677.91 $304.99 $751.03 $697.27 $13.35 $1,219.21 $22.65 $217.73 $655.96 $26.71 $3,859.06 $909.59 $317.93 Apache $18.05 $19.94 $47.57 $0.05 $0.00 $0.57 $16.25 $0.21 $19.42 $4.88 $2.70 $0.03 $0.32 $0.80 $7.29 $0.00 $33.50 $6.74 $0.00 $0.04 $0.59 $48.98 $0.03 $0.00 $0.12 $4.96 $1.37 $0.07 $17.60 $0.00 $1.31 $0.77 $0.78 $0.08 $36.46 $0.00 $1.17 $0.00 $0.00 $0.00 $1.41 $0.27 $0.00 $4.11 $0.00 $0.00 $1.64 $23.47 $2.84 $0.01 Cochise $39.82 $36.09 $108.53 $14.13 $6.13 $26.88 $27.81 $0.09 $66.53 $0.69 $38.80 $0.02 $14.16 $16.83 $5.84 $10.85 $102.25 $1.86 $0.01 $0.01 $5.80 $121.46 $0.02 $0.00 $7.83 $24.05 $2.21 $2.05 $17.51 $0.00 $7.38 $7.43 $9.00 $0.02 $108.77 $3.48 $8.06 $45.45 $1.02 $0.24 $11.44 $1.52 $0.08 $0.25 $0.00 $47.01 $0.00 $9.04 $38.20 $0.59 Coconino $72.41 $23.44 $189.24 $0.21 $13.70 $54.29 $72.40 $1.80 $14.96 $6.76 $19.81 $1.12 $19.03 $37.90 $24.72 $9.19 $144.34 $0.09 $0.16 $0.00 $12.62 $285.50 $0.15 $0.00 $0.06 $17.47 $9.86 $0.58 $114.60 $0.33 $9.49 $0.42 $1.19 $0.04 $15.00 $2.25 $4.91 $2.19 $9.79 $11.97 $30.86 $0.53 $28.65 $0.10 $0.02 $1.71 $4.27 $44.59 $19.80 $2.96 Gila $25.80 $7.59 $69.63 $1.01 $9.11 $7.29 $16.58 $0.01 $19.96 $5.31 $2.34 $0.00 $0.82 $10.01 $1.60 $0.00 $39.37 $0.19 $0.00 $0.00 $2.87 $47.78 $0.00 $0.00 $0.08 $6.28 $0.58 $0.15 $6.89 $0.00 $0.40 $0.35 $0.21 $0.00 $0.00 $0.01 $0.00 $1.72 $0.74 $0.01 $3.57 $0.00 $6.63 $0.02 $0.00 $1.00 $7.11 $13.15 $0.58 $1.56 Graham $8.16 $0.85 $8.12 $0.00 $0.52 $4.74 $9.27 $0.00 $16.80 $0.12 $1.39 $0.01 $1.34 $14.37 $1.07 $0.00 $27.73 $0.00 $0.22 $0.00 $3.42 $22.40 $0.00 $0.00 $0.24 $2.39 $1.02 $0.05 $4.31 $0.00 $3.21 $0.18 $8.18 $0.01 $6.28 $0.05 $0.00 $0.95 $0.00 $0.30 $0.12 $0.00 $2.01 $0.00 $0.00 $0.00 $0.00 $2.18 $1.65 $0.00 Greenlee $10.01 $0.00 $0.30 $0.00 $0.00 $3.73 $0.76 $0.00 $13.57 $0.00 $0.10 $0.00 $0.02 $1.64 $0.53 $0.00 $0.00 $0.00 $0.00 $0.00 $0.94 $4.97 $0.00 $0.00 $0.26 $0.75 $0.21 $0.01 $0.16 $0.00 $0.02 $1.09 $0.14 $0.00 $4.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.14 $0.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 APPENDIX D COMMODITY PRODUCTION BY COUNTY MILLIONS OF DOLLARS Commodity Production by County La Paz Maricopa Mohave $9.74 $12,328.47 $92.47 $3.83 $3,902.95 $71.11 $25.40 $13,117.37 $187.87 $0.00 $1,257.82 $8.30 $0.00 $1,839.69 $10.39 $3.25 $2,112.03 $58.25 $5.30 $3,409.10 $57.20 $0.00 $385.37 $0.39 $2.01 $541.64 $16.28 $0.62 $2,872.95 $15.11 $0.82 $2,448.80 $64.44 $0.00 $944.01 $15.44 $0.10 $2,482.91 $14.10 $3.21 $1,657.06 $47.32 $1.03 $1,771.41 $12.37 $0.00 $7,702.33 $2.57 $0.90 $3,740.70 $231.61 $0.00 $1,038.16 $0.08 $0.00 $1,803.69 $1.03 $0.00 $282.11 $0.04 $1.47 $1,052.19 $16.63 $21.14 $5,228.01 $172.73 $0.00 $6,756.57 $0.01 $0.00 $41.63 $1.56 $0.88 $14.72 $0.19 $1.26 $669.76 $14.02 $1.13 $856.81 $16.85 $0.14 $618.82 $1.00 $2.87 $1,117.15 $21.54 $3.50 $37.58 $0.00 $0.08 $1,506.92 $8.58 $21.63 $85.24 $1.36 $11.02 $100.93 $0.90 $0.00 $177.72 $0.55 $0.00 $4,356.40 $37.75 $0.00 $722.67 $0.05 $0.00 $395.55 $0.39 $0.00 $570.65 $1.29 $0.00 $130.12 $0.76 $0.01 $623.66 $75.03 $0.46 $555.73 $10.50 $0.00 $7.12 $0.00 $0.08 $1,085.50 $4.00 $0.00 $5.48 $0.03 $0.00 $168.92 $0.15 $0.00 $550.06 $7.29 $0.00 $0.00 $0.00 $0.66 $3,282.47 $40.07 $0.01 $709.44 $1.71 $0.00 $246.22 $11.02 Navajo $27.47 $23.10 $69.23 $0.00 $6.38 $19.98 $33.92 $0.00 $27.87 $0.39 $2.99 $0.00 $1.93 $38.46 $4.69 $0.00 $70.43 $0.00 $0.00 $0.00 $3.14 $100.46 $0.00 $0.00 $2.08 $12.08 $3.73 $0.59 $19.49 $0.00 $0.89 $4.27 $2.47 $0.00 $0.49 $0.27 $0.00 $0.08 $1.90 $0.07 $1.44 $0.00 $6.72 $13.26 $0.00 $6.74 $9.32 $19.65 $1.99 $0.01 Pima $876.04 $237.21 $2,003.69 $113.14 $181.67 $195.08 $499.76 $88.31 $63.80 $313.23 $453.27 $135.69 $258.37 $343.49 $297.54 $62.42 $949.48 $173.80 $18.63 $2,609.62 $193.95 $1,160.27 $355.75 $0.07 $1.16 $200.38 $91.69 $115.25 $307.10 $0.00 $105.54 $2.68 $6.50 $298.70 $331.50 $104.62 $32.03 $60.30 $154.14 $115.35 $106.41 $0.00 $50.19 $0.16 $28.53 $32.23 $6.98 $382.91 $115.20 $44.36 Pinal Santa Cruz $118.66 $215.92 $16.67 $4.43 $107.73 $62.09 $10.52 $16.41 $6.80 $8.80 $34.54 $32.05 $44.11 $11.82 $0.02 $0.08 $256.76 $8.03 $12.06 $0.11 $23.82 $0.73 $0.00 $27.02 $1.22 $2.52 $14.45 $4.77 $6.05 $3.76 $0.00 $0.00 $81.46 $22.86 $0.01 $0.08 $0.00 $0.51 $0.00 $0.06 $5.11 $2.16 $103.92 $33.99 $0.01 $0.02 $0.00 $0.00 $10.08 $0.26 $12.90 $2.73 $1.80 $4.44 $0.19 $0.52 $10.93 $8.33 $32.07 $0.00 $2.98 $12.96 $20.69 $0.19 $28.29 $1.91 $0.00 $0.89 $7.79 $8.60 $0.35 $1.68 $1.59 $24.36 $0.76 $0.00 $9.68 $0.00 $3.49 $0.23 $6.59 $39.21 $0.66 $0.26 $19.55 $10.61 $0.08 $0.02 $0.01 $0.00 $0.55 $0.00 $0.00 $0.00 $7.03 $2.70 $1.83 $4.36 $1.54 $0.88 Yavapai $232.76 $30.23 $292.49 $2.72 $3.13 $35.81 $71.39 $22.24 $69.06 $22.52 $38.89 $52.49 $35.57 $40.28 $21.78 $4.51 $244.14 $12.72 $1.01 $0.19 $29.38 $205.00 $0.46 $0.00 $0.90 $27.54 $11.50 $1.30 $52.70 $0.00 $10.15 $1.87 $3.62 $1.86 $0.00 $2.49 $2.48 $3.94 $1.10 $14.30 $8.99 $2.55 $11.97 $0.13 $0.02 $4.18 $0.00 $55.53 $5.18 $6.68 Yuma $217.87 $39.77 $98.23 $5.38 $11.88 $41.22 $61.10 $0.02 $9.16 $8.66 $17.08 $0.33 $9.55 $49.44 $20.59 $0.00 $119.90 $0.27 $0.04 $0.04 $16.47 $145.80 $0.01 $0.00 $9.55 $20.52 $9.68 $0.77 $23.42 $0.01 $5.30 $32.74 $319.43 $0.03 $10.47 $0.17 $11.30 $0.24 $0.87 $0.25 $17.79 $0.00 $38.78 $0.91 $28.59 $5.22 $0.00 $19.55 $6.80 $2.08 Demand from Industries of Supplier Industries Opportunity $101.53 Paper and paperboard mills $95.85 Semiconductor machinery manufacturing $94.97 Iron and steel mills Telephone apparatus manufacturing $92.36 Other State and local government enterprises $92.32 Animal production- except cattle and poultry $90.55 $82.86 Metal valve manufacturing Investigation and security services $81.75 Nondepository credit intermediation $81.63 Animal slaughtering, except poultry $80.36 Environmental and other technical consulting svcs $76.64 $73.94 Motor vehicle parts manufacturing State and local government electric utilities $71.70 $70.13 All other forging and stamping $68.83 Ferrous metal foundaries Plastics packaging materials- film and sheet $63.71 Oilseed farming $62.70 Automotive equipment rental and leasing $60.73 Specialized design services $59.36 $59.28 Waste management and remediation services Miscellaneous fabricated metal products $56.37 Software publishers $55.81 Metal can, box and other container manufacturing $55.71 Pesticide and other agricultural chemical mfg $55.24 $54.02 Aluminum sheet, plate and foil manufacturing $53.92 Turned product and screw, nut and bolt manufacturin Rail transportation $53.83 Soybean processing $52.03 Commercial printing $51.34 $50.11 Aluminum foundries Other support services $49.41 $46.84 Custom computer programming services $46.22 Natural gas distribution Commercial machinery repair and maintenance $44.73 $44.61 Iron and steel forging Other computer related services $44.24 $42.47 Fabricated structural metal manufacturing $42.44 Ball and roller bearing manufacturing Other communication and energy wire manufacturing $40.39 Forest nurseries, forest products and timber tracts $39.94 Flavoring syrup and concentrate manufacturing $38.80 Electron tube manufacturing $37.29 Source: Minnesota IMPLAN Group, 2001 Data. 72 Arizona Commodity Production $113.96 $414.16 $129.70 $140.47 $824.13 $40.12 $472.67 $428.23 $3,248.83 $379.52 $333.36 $797.02 $0.00 $157.65 $77.50 $40.37 $26.13 $3,017.58 $354.96 $580.41 $63.49 $634.67 $132.94 $49.08 $197.14 $85.34 $333.58 $0.30 $491.89 $105.69 $422.74 $1,261.38 $1,074.38 $834.42 $4.17 $168.94 $220.88 $0.04 $118.17 $20.84 $7.71 $5.74 Apache $0.00 $0.00 $0.02 $0.03 $11.25 $1.88 $0.00 $0.17 $0.12 $0.00 $0.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.22 $2.03 $0.42 $13.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.61 $0.00 $0.01 $0.00 $0.35 $0.00 $4.57 $0.42 $0.00 $0.01 $0.00 $0.00 $0.00 $0.41 $0.00 $0.00 Cochise $0.00 $0.00 $0.09 $0.13 $7.18 $3.42 $0.00 $12.31 $2.31 $13.66 $0.74 $8.12 $0.00 $0.07 $0.01 $0.00 $0.45 $6.16 $0.40 $9.84 $0.36 $1.50 $0.01 $0.00 $0.00 $0.02 $6.28 $0.00 $1.94 $1.34 $1.03 $57.38 $30.85 $6.87 $0.00 $1.03 $0.41 $0.00 $0.02 $0.03 $0.01 $0.00 Coconino $1.80 $0.00 $0.00 $0.05 $13.91 $0.78 $0.87 $1.30 $3.65 $0.00 $4.45 $5.65 $0.00 $0.04 $0.01 $0.06 $0.67 $10.80 $1.94 $10.75 $1.00 $0.04 $0.00 $0.00 $0.00 $0.07 $26.78 $0.00 $8.41 $0.12 $2.15 $1.62 $27.49 $7.55 $0.00 $0.81 $0.47 $0.00 $0.00 $4.92 $0.47 $0.06 Gila $0.00 $0.00 $0.00 $0.01 $18.32 $1.32 $0.00 $1.45 $1.20 $0.00 $0.15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.89 $1.18 $4.37 $4.09 $0.00 $0.02 $0.00 $0.00 $0.00 $0.04 $3.22 $0.00 $0.54 $0.00 $2.21 $0.37 $21.92 $7.71 $0.00 $0.01 $0.38 $0.00 $0.00 $1.03 $0.00 $0.00 Graham $0.00 $0.00 $0.00 $0.00 $1.00 $0.70 $0.36 $0.00 $0.01 $4.55 $0.05 $0.00 $0.00 $0.00 $0.00 $0.00 $1.12 $0.00 $0.03 $0.34 $0.00 $0.01 $0.00 $0.00 $0.00 $0.00 $3.20 $0.00 $13.63 $0.00 $0.10 $0.21 $0.69 $13.36 $0.00 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Greenlee $0.00 $0.00 $0.00 $0.00 $1.28 $0.39 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.34 $0.00 $0.00 $0.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.04 $0.00 $0.02 $0.00 $2.23 $0.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.01 $0.00 $0.00 APPENDIX D COMMODITY PRODUCTION BY COUNTY MILLIONS OF DOLLARS Commodity Production by County La Paz Maricopa Mohave $0.00 $7.58 $0.01 $0.00 $588.30 $0.00 $0.00 $129.13 $0.10 $0.00 $152.61 $0.07 $3.76 $490.77 $10.32 $0.00 $10.39 $0.91 $0.01 $551.50 $0.34 $0.63 $364.40 $5.65 $0.03 $3,071.82 $8.25 $0.00 $426.60 $0.02 $0.01 $286.92 $0.44 $0.02 $903.89 $5.30 $0.00 $0.00 $0.00 $0.01 $151.03 $0.15 $0.00 $72.34 $0.47 $0.01 $31.09 $0.25 $1.56 $1.78 $2.01 $0.02 $2,805.92 $5.88 $0.01 $303.50 $1.27 $2.08 $414.72 $22.33 $0.00 $58.71 $2.97 $0.00 $341.19 $0.06 $0.03 $134.71 $0.02 $0.00 $26.40 $0.01 $0.01 $204.45 $0.00 $1.73 $71.13 $0.27 $2.45 $56.57 $12.16 $0.00 $0.24 $0.00 $0.00 $388.36 $10.97 $0.00 $63.39 $0.00 $0.07 $374.50 $7.91 $0.00 $1,063.05 $2.02 $0.36 $752.90 $30.85 $0.00 $605.78 $10.13 $0.00 $3.82 $0.00 $0.00 $154.87 $6.13 $0.00 $176.46 $0.12 $0.00 $0.00 $0.00 $0.00 $144.82 $0.36 $0.00 $2.13 $0.00 $0.00 $5.58 $0.01 $0.00 $1.85 $0.00 Navajo $116.82 $0.00 $0.00 $0.00 $7.22 $1.98 $0.00 $0.62 $0.70 $1.61 $0.52 $0.86 $0.00 $0.01 $0.00 $0.00 $1.12 $0.64 $8.22 $6.78 $0.01 $0.25 $0.01 $0.00 $0.00 $0.00 $99.95 $0.00 $1.65 $0.00 $2.21 $3.48 $5.02 $2.07 $0.00 $0.05 $0.00 $0.00 $0.00 $2.44 $0.02 $0.00 Pima $0.03 $42.01 $8.34 $18.03 $190.58 $5.38 $57.97 $40.35 $151.37 $0.25 $29.81 $53.76 $0.00 $7.41 $6.27 $12.58 $2.45 $208.97 $28.36 $52.34 $36.62 $349.93 $1.74 $33.28 $0.39 $11.80 $122.20 $0.04 $82.63 $13.99 $25.28 $135.87 $164.77 $143.93 $0.31 $15.02 $47.76 $0.00 $10.15 $7.17 $1.08 $3.81 Pinal Santa Cruz $0.07 $0.00 $0.00 $0.00 $2.46 $0.16 $0.09 $0.14 $17.55 $5.54 $8.57 $0.47 $0.05 $3.71 $0.29 $0.18 $0.61 $0.46 $1.04 $0.00 $2.04 $2.45 $0.04 $2.21 $0.00 $0.00 $0.06 $0.05 $0.16 $0.05 $0.21 $0.10 $2.82 $2.90 $0.33 $2.64 $1.44 $0.01 $5.84 $0.00 $0.09 $0.01 $0.02 $0.00 $0.53 $0.00 $0.39 $0.00 $0.00 $0.00 $9.81 $0.03 $12.59 $5.38 $0.02 $0.00 $2.29 $0.57 $0.78 $6.90 $2.05 $2.13 $1.57 $0.24 $14.23 $1.34 $11.87 $0.31 $0.01 $0.00 $0.97 $0.18 $0.42 $0.03 $0.00 $0.00 $0.15 $0.02 $3.01 $0.01 $0.41 $0.09 $0.00 $0.00 Yavapai $0.00 $2.24 $0.00 $0.61 $27.53 $2.81 $0.42 $2.68 $5.61 $0.00 $0.91 $5.27 $0.00 $0.08 $0.14 $0.12 $3.12 $8.98 $4.59 $22.91 $0.47 $2.44 $0.18 $0.02 $0.07 $0.20 $8.76 $0.00 $11.05 $18.69 $2.25 $11.06 $12.24 $10.90 $0.00 $0.56 $0.67 $0.04 $0.00 $0.06 $0.01 $0.01 Yuma $0.00 $0.00 $0.00 $0.05 $17.92 $3.10 $0.02 $1.90 $2.68 $0.03 $4.90 $13.22 $0.00 $2.23 $0.00 $0.00 $4.00 $9.15 $0.48 $15.13 $0.02 $0.01 $0.00 $1.94 $0.01 $0.06 $17.92 $0.00 $2.75 $0.57 $0.90 $0.10 $7.06 $13.29 $0.03 $0.15 $0.02 $0.00 $0.00 $0.02 $0.02 $0.00 Demand from Industries of Supplier Industries Opportunity Couriers and messengers $36.79 Electroplating, anodizing and coloring metal $36.55 $32.52 Nonferrous forging Colleges- universities- and junior colleges $32.16 Business support services $31.84 $30.94 Hardware manufacturing Phosphatic fertilizer manufacturing $30.81 Cheese manufacturing $29.88 Fluid milk manufacturing $29.77 Information services $29.67 Maintenance and repair of nonresidential buildings $28.21 Household goods repair and maintenance $27.80 Poultry processing $26.36 Metal coating and nonprecious engraving $25.79 Audio and video media reproduction $25.32 Sheet metal work manufacturing $25.30 Flour milling $24.14 Plastics bottle manufacturing $23.76 Plastics material and resin manufacturing $23.31 Wet corn milling $22.90 Computer storage device manufacturing $22.76 $22.60 Aircraft manufacturing $21.51 Wiring device manufacturing Fiber optic cable manufacturing $21.35 Vegetable and melon farming $21.24 $20.54 Other engine equipment manufacturing Other basic organic chemical manufacturing $20.50 Glass container manufacturing $20.07 Rendering and meat byproduct processing $18.86 $18.45 Relay and industrial control manufacturing $18.28 Speed changers, mechanical power transmission equip Tire manufacturing $18.18 Other basic inorganic chemical manufacturing $18.11 Water transportation $16.23 $16.06 Miscellaneous wood product manufacturing Dry, condensed and evaporated dairy products $15.50 $15.21 AC, refrigeration and forced air heating $14.83 Motor and generator manufacturing Surgical and medical instrument manufacturing $14.52 Veterinary services $14.47 Railroad rolling stock manufacturing $14.07 Electricity and signal testing instruments $13.83 Source: Minnesota IMPLAN Group, 2001 Data. 73 Arizona Commodity Production $889.39 $54.55 $0.39 $390.97 $1,862.11 $60.50 $46.33 $7.08 $384.53 $425.32 $750.57 $490.64 $6.24 $72.62 $6.21 $316.26 $14.24 $87.20 $82.52 $1.25 $40.12 $844.33 $40.25 $3.17 $802.95 $9.07 $121.50 $0.00 $28.83 $18.49 $2.57 $7.27 $129.11 $77.66 $44.47 $138.32 $326.08 $20.74 $99.79 $265.14 $4.19 $51.39 Apache $0.01 $0.00 $0.00 $15.93 $0.34 $0.00 $0.00 $0.00 $0.00 $0.21 $3.29 $0.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.03 $0.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.02 $0.00 $0.00 $0.00 $0.01 $0.01 $0.00 $0.00 $0.02 $0.00 $0.26 $0.00 $0.05 Cochise $6.98 $0.00 $0.00 $3.62 $10.52 $0.01 $0.52 $0.00 $0.00 $2.55 $8.86 $26.29 $0.08 $0.00 $0.00 $0.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.01 $4.78 $0.01 $58.56 $0.01 $0.37 $0.00 $0.36 $0.11 $0.00 $0.00 $0.89 $0.10 $0.03 $0.00 $0.03 $0.40 $0.49 $4.22 $0.00 $0.02 Coconino $12.43 $0.04 $0.00 $4.89 $7.76 $0.01 $0.00 $0.00 $0.04 $1.21 $12.25 $18.51 $0.00 $0.86 $0.00 $0.04 $0.01 $0.09 $0.04 $0.00 $0.01 $0.04 $0.01 $0.00 $3.12 $0.02 $0.01 $0.00 $0.00 $0.00 $0.00 $0.00 $6.18 $0.28 $5.89 $0.00 $0.02 $0.01 $11.72 $8.96 $0.00 $0.01 Gila $3.86 $0.00 $0.00 $1.48 $0.52 $0.00 $0.00 $0.00 $0.00 $0.08 $4.90 $2.42 $0.00 $0.01 $0.00 $0.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.01 $0.00 $0.00 $0.00 $0.00 $0.25 $27.59 $0.03 $0.02 $0.00 $0.00 $0.00 $0.00 $3.59 $0.00 $0.11 Graham $1.12 $0.00 $0.00 $1.13 $0.13 $0.00 $0.00 $0.00 $0.00 $0.02 $1.20 $0.00 $0.03 $0.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.41 $0.00 $0.00 $0.00 $0.12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.15 $0.00 $0.00 Greenlee $0.19 $0.00 $0.00 $0.21 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.34 $0.00 $0.00 $0.00 $0.61 $0.00 $0.00 $0.00 $0.00 $0.00 APPENDIX D COMMODITY PRODUCTION BY COUNTY MILLIONS OF DOLLARS Commodity Production by County La Paz Maricopa Mohave $0.40 $715.97 $15.95 $0.55 $50.10 $0.02 $0.00 $0.38 $0.00 $0.77 $270.15 $2.65 $0.53 $1,444.18 $9.37 $0.00 $11.81 $0.01 $0.00 $23.75 $0.00 $0.00 $1.90 $0.00 $0.00 $368.31 $0.00 $0.04 $317.41 $0.84 $0.58 $553.69 $21.36 $0.85 $355.82 $8.36 $0.00 $5.08 $0.05 $0.01 $65.02 $0.19 $0.00 $2.65 $0.00 $0.00 $224.62 $0.16 $0.01 $14.98 $0.00 $0.00 $48.27 $0.19 $0.00 $109.73 $0.12 $0.00 $1.56 $0.00 $0.00 $27.00 $3.13 $0.00 $1,139.33 $0.58 $0.00 $26.73 $0.11 $0.00 $1.22 $0.00 $28.68 $245.14 $4.76 $0.00 $10.78 $0.08 $0.00 $189.02 $0.05 $0.00 $0.00 $0.00 $0.01 $32.17 $0.00 $0.00 $13.91 $0.06 $0.01 $0.61 $0.00 $0.00 $8.44 $0.00 $0.00 $77.82 $0.85 $0.00 $81.58 $0.09 $0.00 $23.55 $3.83 $0.00 $19.17 $0.00 $0.00 $349.11 $0.02 $0.00 $31.60 $0.10 $0.00 $18.56 $0.05 $1.41 $170.61 $10.91 $0.00 $0.34 $4.60 $0.00 $82.34 $0.08 Navajo $8.15 $0.00 $0.00 $3.53 $2.29 $0.00 $0.00 $0.00 $0.00 $0.78 $7.03 $5.63 $0.28 $0.00 $0.00 $0.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.32 $0.00 $0.34 $0.00 $0.04 $0.00 $0.00 $0.00 $0.39 $11.98 $2.33 $0.00 $0.00 $0.00 $0.00 $1.58 $0.00 $0.00 Pima $84.70 $2.61 $0.01 $46.52 $373.42 $61.23 $1.23 $0.76 $0.09 $99.13 $93.19 $64.88 $0.78 $2.09 $3.99 $53.30 $0.01 $10.37 $2.08 $0.00 $16.83 $485.87 $7.65 $2.48 $2.59 $0.20 $1.93 $0.00 $0.00 $9.06 $0.08 $0.08 $36.39 $0.92 $6.45 $0.00 $1.00 $0.49 $98.44 $42.30 $0.00 $13.48 Pinal Santa Cruz $3.29 $2.12 $0.03 $0.37 $0.00 $0.00 $6.19 $0.77 $1.04 $0.29 $0.00 $0.00 $16.61 $0.00 $4.36 $0.00 $16.90 $0.00 $0.35 $0.05 $7.07 $1.91 $0.78 $0.00 $0.01 $0.00 $0.37 $0.01 $0.00 $0.00 $25.81 $0.02 $0.07 $0.00 $0.01 $0.13 $0.03 $0.02 $0.00 $0.00 $0.00 $0.00 $0.00 $1.01 $0.04 $8.55 $0.00 $0.01 $28.62 $3.13 $0.00 $0.00 $0.15 $0.00 $0.00 $0.00 $0.12 $0.00 $0.01 $0.18 $0.08 $0.00 $0.00 $0.00 $7.19 $0.00 $0.06 $0.35 $5.04 $0.09 $136.93 $0.00 $0.01 $0.01 $0.00 $0.00 $1.14 $0.17 $2.55 $0.65 $0.00 $0.00 $0.00 $0.63 Yavapai $25.72 $0.38 $0.00 $31.95 $3.28 $1.38 $2.20 $0.05 $0.00 $2.13 $22.71 $3.45 $0.01 $4.03 $0.00 $11.93 $0.00 $31.96 $0.12 $0.00 $0.00 $2.00 $0.04 $0.00 $1.70 $0.01 $0.02 $0.00 $0.00 $0.43 $2.51 $0.00 $0.02 $0.08 $0.40 $0.00 $0.39 $0.05 $0.03 $13.42 $0.00 $0.16 Yuma $8.50 $0.43 $0.00 $3.37 $12.22 $0.04 $2.14 $0.00 $0.00 $0.75 $11.97 $3.34 $0.00 $0.02 $0.00 $0.02 $0.00 $0.00 $0.11 $0.00 $0.05 $3.32 $0.04 $0.00 $520.06 $0.03 $0.23 $0.00 $0.65 $0.01 $0.00 $0.01 $0.13 $0.16 $0.02 $0.00 $55.76 $0.00 $0.44 $3.54 $0.00 $0.01 Demand from Industries of Supplier Industries Opportunity $13.68 Pulp mills $13.54 Greenhouse and nursery production $13.41 Veneer and plywood manufacturing $13.23 Fruit and vegetable canning and drying Air transportation $13.12 Electronic computer manufacturing $11.75 $11.27 Cut stock, resawing lumber and planing $11.04 Farm machinery and equipment manufacturing General and consumer goods rental $10.75 Reconstituted wood product manufacturing $9.82 $9.68 Industrial truck, trailer and stacker manufacturing Custom roll forming $9.65 Fluid power pump and motor manufacturing $8.95 Textile and fabric finishing mills $8.53 $8.43 Fluid power cylinder and actuator manufacturing Surgical appliance and supplies manufacturing $8.15 Adhesive manufacturing $7.82 Nonwoven fabric mills $7.36 $7.32 Other rubber product manufacturing Photographic film and chemical manufacturing $6.88 $6.66 Paint and coating manufacturing Copper rolling, drawing and extruding $5.17 $5.00 Cutting tool and machine tool accessory manufacturin Pump and pumping equipment manufacturing $4.59 Wood preservation $4.34 Gasket, packing and sealing device manufacturing $4.08 Other miscellaneous chemical product manufacturing $3.86 Other communications equipment manufacturing $3.03 Coated and laminated paper and packaging materials $2.50 $1.67 Rubber and plastics hose and belting manufacturing Sound recording industries $1.55 Other concrete product manufacturing $1.44 Glass and glass products- except glass containers $1.44 Magnetic and optical recording media manufacturing $1.11 Periodical publishers $0.64 Source: Minnesota IMPLAN Group, 2001 Data. 74 Arizona Commodity Production $6.05 $79.16 $1.59 $81.84 $2,524.13 $568.29 $10.10 $41.57 $350.14 $14.67 $5.76 $26.81 $8.24 $9.89 $21.98 $265.15 $104.55 $3.73 $51.32 $46.29 $38.59 $201.28 $16.91 $2.64 $2.65 $6.85 $35.35 $22.80 $56.48 $14.14 $14.38 $146.74 $96.08 $28.31 $138.07 Apache $0.00 $0.00 $0.03 $0.00 $0.00 $0.00 $0.13 $0.00 $0.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.01 $0.00 $0.00 $0.00 $0.00 Cochise $0.00 $0.29 $0.01 $10.72 $1.27 $0.22 $0.29 $0.00 $1.12 $0.00 $0.01 $0.02 $0.00 $0.00 $0.00 $9.08 $0.00 $0.05 $0.01 $0.00 $0.00 $0.00 $0.01 $0.00 $0.01 $0.00 $0.00 $0.00 $0.35 $0.00 $0.22 $0.37 $0.02 $0.00 $0.27 Coconino $0.00 $0.01 $0.00 $0.65 $27.30 $0.08 $0.18 $0.01 $21.58 $0.00 $0.01 $0.01 $0.27 $0.00 $3.05 $216.21 $0.01 $0.83 $0.05 $0.00 $1.89 $0.00 $0.39 $0.00 $0.00 $0.02 $0.05 $0.01 $8.36 $0.00 $0.02 $0.07 $0.02 $0.05 $1.80 Gila $0.00 $0.01 $0.00 $0.00 $0.16 $0.02 $0.00 $0.00 $1.30 $0.00 $0.00 $0.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.02 $0.03 $0.00 $0.00 $0.12 Graham $0.00 $0.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.03 $0.00 $0.03 $0.01 $0.00 $0.00 $0.03 Greenlee $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.04 $0.00 $0.00 $0.00 $0.00 APPENDIX D COMMODITY PRODUCTION BY COUNTY MILLIONS OF DOLLARS Commodity Production by County La Paz Maricopa Mohave $0.00 $0.08 $0.00 $0.20 $60.13 $0.15 $0.00 $0.78 $0.03 $0.00 $48.72 $0.03 $0.00 $2,726.06 $5.28 $0.00 $505.18 $0.19 $0.00 $7.86 $0.30 $0.00 $11.32 $0.03 $1.12 $266.52 $8.71 $0.00 $11.50 $0.00 $0.00 $6.80 $0.01 $0.00 $25.20 $0.08 $0.00 $6.97 $0.13 $0.00 $9.07 $0.13 $0.00 $18.07 $0.11 $0.00 $45.78 $0.06 $0.01 $117.14 $0.03 $0.00 $1.81 $0.02 $0.69 $31.86 $0.35 $0.00 $51.20 $0.83 $0.00 $24.07 $0.01 $0.00 $158.92 $3.85 $0.00 $12.19 $1.49 $0.00 $2.98 $0.01 $0.00 $0.18 $0.00 $0.01 $6.83 $0.73 $0.00 $42.98 $0.02 $0.00 $2.53 $0.01 $0.00 $50.00 $0.12 $0.00 $15.45 $0.00 $0.04 $10.53 $0.06 $0.00 $115.64 $0.22 $0.00 $114.71 $1.20 $0.00 $51.45 $0.14 $0.33 $113.93 $2.74 Navajo $5.97 $1.16 $0.15 $0.02 $0.89 $0.00 $0.49 $0.00 $1.81 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.03 $0.43 $0.02 $0.00 $0.06 Pima $0.00 $10.07 $0.55 $23.71 $263.87 $205.01 $0.55 $44.75 $29.53 $1.84 $0.13 $1.26 $0.70 $0.30 $1.45 $50.21 $0.33 $0.75 $23.33 $7.25 $8.45 $54.74 $4.33 $0.17 $0.00 $0.51 $0.15 $23.29 $2.92 $3.97 $3.01 $16.97 $10.31 $0.78 $20.28 Pinal Santa Cruz $0.00 $0.00 $4.16 $0.00 $0.00 $0.00 $0.51 $1.65 $0.55 $4.61 $0.17 $0.26 $0.09 $0.00 $0.25 $0.01 $2.43 $1.09 $0.00 $0.00 $0.02 $0.00 $0.08 $0.00 $0.00 $0.06 $0.00 $0.01 $0.00 $0.18 $1.30 $3.08 $0.03 $0.00 $0.04 $0.05 $0.04 $0.00 $0.00 $0.00 $0.02 $0.00 $0.03 $0.00 $0.03 $0.00 $0.05 $0.00 $2.37 $0.00 $0.04 $0.00 $0.05 $0.00 $0.00 $0.00 $0.11 $0.12 $0.00 $0.04 $0.07 $0.08 $13.09 $0.78 $0.53 $0.00 $0.00 $0.00 $0.03 $0.00 Yavapai $0.00 $2.36 $0.02 $0.04 $2.71 $0.05 $0.09 $0.01 $11.99 $0.00 $0.01 $0.14 $0.12 $0.41 $0.36 $0.24 $0.04 $0.01 $0.06 $0.33 $7.22 $0.00 $2.22 $0.00 $0.00 $0.02 $0.00 $0.01 $0.15 $0.00 $0.27 $0.12 $0.46 $0.19 $3.21 Yuma $0.00 $2.45 $0.08 $0.15 $7.89 $1.39 $0.11 $1.77 $2.92 $2.38 $0.02 $0.00 $0.00 $0.04 $0.00 $8.19 $0.00 $0.04 $0.03 $0.40 $0.01 $0.00 $0.02 $0.00 $0.01 $0.00 $0.69 $0.00 $0.32 $1.28 $0.09 $0.59 $0.00 $0.01 $0.07 APPENDIX E 75 Zoomerang Page 1 of 10 Arizona Business-to-Business Buyer Survey 1 What type of business is your company in? (check all that apply) Aerospace/Defense Agriculture/Food Processing Architecture/Engineering Bio Industry Forest Products Health Care Services Industrial Machinery Information Technology/Telecommunications Instruments Research/Development Semiconductors/Electronics Software Transportation Other, Please Specify 2 What is the total size of your employment in all facilities in Arizona? Less than 50 51-100 http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 2 of 10 101-250 251-500 501-1,000 More than 1,000 3 Where in Arizona is your company located ( check all that apply )? Apache Cochise Coconinno Gila Graham Greenlee LaPaz Maricopa Mohave Navajo Pima Pinal Santa Cruz Yavapai Yuma http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 3 of 10 4 5 If purchasing is done at a centralized location, where is the central purchasing facility located? Are minor purchases or purchases under $5000 handled by nonpurchasing personnel? Yes No Don't Know 6 Are there any specific requirements (for example, minority-owned businesses, restrictions, quality certifications) that influence your purchasing decisions? (check all that apply) No Minority-Owned Women-Owned Veteran-Owned Disabled AS 9100 CE Mark ISO 9000 Compliant ISO 9000 ISO 9001 ISO 9002 http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 4 of 10 ISO 9003 Military Specifications Six Sigma RoHS Compliance Software Process Involvement Statistical Process Control Prime Contractor Sub-Contractor Bondable Secured & Controlled Access Clean Room Shipping, Receiving & Inspection Temperature/Humidity Controlled Labs/QA Test, R&D and Development Facilities Warehouse Distribution Logistics Support Training, LT Field Servicing Other, Please Specify 7 Please rate the most important factors in your choice of suppliers. 1 2 3 4 5 Most Important Very Important Important Slightly Important Not Important Price http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 5 of 10 Reliability of delivery Quality of product Supplier's service/maintenance Historical relationship w/supplier Geographic proximity Web presence Other 8 If you marked "Other" in Question # 7, above, please specify. 9 How do you identify potential suppliers? (Please check all that apply) Own experience Firm's records or previous contacts http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 6 of 10 Catalogues Trade journals Internet search Vendor directories Salesforce Advertisement for bids Government procurement Other, Please Specify 10 Does your firm have a buy-local policy that gives preference to Arizona suppliers? Yes No Don't Know 11 What products and services do you currently purchase locally? 12 What additional products and services would you prefer to purchase locally but are not able to? http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 7 of 10 13 Why are you not able to purchase these products locally? (Mark all that apply) Unable to locate necessary suppliers Price Transportation Geographic proximity Reliability of delivery Quality issues Capability and capacity concerns towards local supplier Product support issues Existing historic relationship with supplier Other, Please Specify 14 If local vendors were located in Arizona but outside metro Phoenix or Tucson, would that be close enough for you? Yes No Don't Know Comments: 15 In round numbers, how much did your company spend in the last fiscal year to procure goods and services? http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 8 of 10 Less than $1 million $1 to $5 million $6 to $10 million $11 to $50 million $51 to $100 million $101 million to $200 million More than $200 million 16 Do you expect this number to increase or decrease during your fiscal year 2004-05? Increase Decrease Don't Know 17 What percentage of this amount is spent outside Arizona? 0-25% 26-50% 51-75% 76-100% 18 What percentage is spent outside the U.S.? 0-25% 26-50% http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 9 of 10 51-75% 76-100% 19 What would it take to get you to buy more supplies locally? 20 Are there any state and/or local taxing, economic development, workforce, or other policies that limit or hinder your ability to successfully compete with others in your industry who are located outside of Arizona? Comments 21 Other comments: 22 Would you like to be entered into a drawing to receive a digital camera or a 1.0 GB USB flash drive? Yes- Please fill out the contact information below. No- Please skip the next question and click "Submit" 23 Contact Information: http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 Zoomerang Page 10 of 10 Name: Company: Address 1: Address 2: City/Town: State/Province: Zip/Postal Code: Country: Email Address: Survey Page 1 http://www.zoomerang.com/members/print_survey_body.zgi?ID=L22A8RD273GC 5/12/2005 APPENDIX F 86 Script for Personal Interviews Hello, my name is ____________ . Recently you should have received a letter from Applied Economics regarding a study on supply chain issues in the state that is being conducted by the Arizona Department of Commerce in partnership with the Arizona Technology Council and the Southern Arizona Technology Council. An important part of the study is interviewing representatives from Arizona businesses. We would like to learn more about any challenges you face in locating suppliers and about general issues that may have an impact on your ability to successfully compete with other companies in your industry who are located outside of Arizona. As an important member of one of Arizona’s key industry sectors, we are hoping that you could spare 15 minutes of your time to answer some questions. I assure you that individual responses to these questions will be kept strictly confidential; only aggregated results will be reported. Are you the appropriate person for this interview? If yes… is now convenient for you or can we set another time in the next few days for me to call you back? If no… get name, title & phone number of person 87 This first group of questions is related to your purchasing patterns. 1. What are the important factors in choosing suppliers? For example: price, geographic proximity; small business: minority or women-owned business; historical relationship with supplier, etc. Most Very Important Important Important Slightly Not Important Important Price Reliability of delivery Quality of product Supplier's service/ maintenance Historical relationship w/supplier Geographic proximity Web presence Other: 2. Generally speaking, how do you locate suppliers? For example…Internet, word-of-mouth, formal RFP process… Internet Word-of-mouth RFP or bid process Referral Other 3. What types of products and services are you most likely to purchase locally? 4. What products and services are you most likely to purchase outside of Arizona (U.S. or offshore)? 5. Are you not able to purchase these products locally? If so, why not? Capability and capacity concerns towards local supplier Existing historic relationship with supplier Geographic proximity Price Product support issues Quality Issues 88 Reliability of delivery Transportation Unable to locate necessary suppliers Other, please specify 6. Do you have any recommendations on what might alleviate the issues mentioned above that might lead you purchase to more supplies locally? 7. Is your purchasing done from a centralized location? Yes No If yes, where is the centralized location? Comments: 8. Are minor purchases or purchases under $5,000 handled by non-purchasing personnel? Yes No Comments: This group of questions is related to any barriers or challenges (other than supply chain) that you may have in conducting manufacturing operations in Arizona. 9. Are there any state and/or local taxing policies that limit or hinder your ability to successfully compete with other companies in your industry who are located outside of Arizona? Yes No Comments: 10. What other factors limit your ability to compete? Callers… if necessary, prompt for answers or comments on: Other operating costs (land, labor, utility costs, local fees). Transportation/Logistic problems Quality of the workforce Thank you for your time. 89