CHAPTER XII Census of Wholesale Trade--Establishment and Firm Size Abstract XIII-3 Introduction XIII-5 File Specifications XIII-7 File Layout XIII-9 Database Structures XIII-13 User Notes XIII-15 CENSUS OF WHOLESALE TRADE ESTABLISHMENT AND FIRM SIZE Abstract CONTENTS Citation XIII 3 Type of File XIII 3 Universe Description XIII 3 Subject-Matter Description XIII 3 Geographic Coverage XIII 3 Technical Description XIII 3 Reference Materials XIII 3 Related Printed Reports XIII 4 Related Machine-Readable Data Files XIII 4 Availability XIII 4 CITATION Census of Wholesale Trade on CD-ROM, 1987: Establishment and Firm Size [machine-readable data file] / prepared by the Bureau of the Census. -Washington: The Bureau [producer and distributor], 1990. Type of File: Summary statistics. Universe Description: The universe is all establishments with payroll primarily engaged wholesale trade. Subject-Matter Description: Data are presented cross-tabulated by size of establishment, size of firm, and legal form of organization. Data are shown by kind of business and type of operation on the number of establishments and sales. For merchant wholesalers, the data include payroll, employment, operating expenses, and inventories. Establishment statistics are provided by sales and employment size; data are presented for firms by sales size (including concentration by largest firms), by employment size, and by number of establishments for the United States. Geographic Coverage: Data are provided for the United States. Technical Description: File Structure: dBase III+ The file has one dBase ".NDX" index file and several label files that can be linked to it. WC87S1 1. File sequence: Table number by kind of business by one of several table-specific size codes 2. Available index: WC87S1 First record for each kind of business within table number 3. Linkable label files: a. WHS87KB (kind-of-business labels) b. SIZECODE (labels for table number and each of the size codes presented in the file) Reference Materials: 1987 Economic Census CD-ROM Volume 1: Report Series, Release 1C Technical Documentation. This documentation has general information, record layouts for all files, and other reference material. One copy accompanies each CD-ROM order. Additional copies are available for $5 from Customer Services, Data User Services Division, Bureau of the Census, Washington, DC 20233. Guide to the 1987 Economic Censuses and Related Statistics. Describes the scope, coverage, classification systems, data items, and data products for each of the economic censuses and related surveys. Data comparability and uses are also discussed. Single copies are available free from Customer Services, Data Users Services Division, Bureau of the Census, Washington, DC 20233. Standard Industrial Classification Manual 1987. Prepared by the Executive Office of the President, Office of Management and Budget and available from Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402. Price is $24. Related Printed Reports: 1987 Census of Wholesale Trade: Establishment and Firm Size (WC87-S-1). One publication for the United States as a whole. For the sale by the Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402. Price is $14. Related Machine-Readable Data Files: Census of Wholesale Trade on CD-ROM, 1987 Geographic Area Series with U.S. Summary. Presents data for establishments with payroll by kind of business for States, metropolitan areas, counties, and places with 2,500 or more inhabitants. Availability: The full data set for all States is available on one CD-ROM. The subscription price of $475 includes up to 7 successive editions of discs as reissued every 3 to 4 months. Individual discs are $150 CENSUS OF WHOLESALE TRADE ESTABLISHMENT AND FIRM SIZE Introduction CONTENTS Size of Establishment XIII-5 Size of Firm XIII-5 Legal Form of Organization XIII-6 Geographic Areas Covered XIII-6 Dollar Values XIII-6 This file represents a recompilation of data collected in the 1987 Census of Wholesale Trade and is divided into three categories: size of establishment, size of firm, and legal form of organization. Size of establishment Only establishments which operated the entire year have been classified into the various size groups used in the establishment size tables (tables 1 through 4). An establishment is classified as "operated entire year" if it operated 10 months or more during the year. Data for establishment which reported that they were in operation less than 10 months, while not included in the size groups, are included in the totals fro the kind of business and are separately summarized as "not operated entire year." Sales size Data in tables 1 and 2 are classified into 9 to 11 sales size groups depending on the value of sales and other receipts reported for the year 1987. Employment size Data in tables 3 and 4 are classified into 11 to 13 employment size groups depending on the number of employees on the payroll during the pay period including March 12. Proprietors and unpaid family workers were not regarded as employees in determining the employment size of an establishment. SIZE OF FIRM A firm may be either a single establishment (single unit) firm or multiestablishment (multiunit) firm. Firm size groups are based on aggregate data for all establishments operated by the same firm in the kind-of-business classification, group, or total for which data are presented. For example, a firm operates three wholesale establishments: a hardware store(SIC 5072), a plumbing supply store (SIC 5074), and an electrical appliance and television (SIC 5064). At the most detailed level of classification, each of the establishments is a single unit operated by a multiestablishment firm. At the hardware, plumbing, heating equipment and supply group level (SIC 507), it is a 2-establishment multiunit. Data are presented based on sales size of firms, employment size of firms, and concentration by largest firms, as well as fro single units and multiunits (by number of establishments operated). Single units and multiunits Data in table 5 are classified not 10 firm with only one establishment engaged in economic activities. A multi- establishment firm may, however, operate only one establishment classified in wholesale trade. Sale size Data in table 6 are classified into 10 to 12 sales size groups depending on the values of sales and other receipts reported for the year 1987. Employment Size Data in table 7 are classified into 6 to 9 employment size groups depending on the number of employees on the payroll during the pay period including March 12. Proprietors and unpaid family workers were not regarded as employees in determining size of a firm. Concentration of largest firms Data in table 8 are presented separately for the 4, 8, 20, and 50 largest firms based on total sales. LEGAL FORM OF ORGANIZATION Data in table 9 represent a summary for both firms and individual establishment. For the method of assigning legal form, see Glossary, Legal form of Organization. GEOGRAPHIC AREAS COVERED This report series presents data for the United States as a whole. DOLLAR VALUES All dollar values presented in this report are expressed in current dollars, i.e., 1987 data are expressed in 1987 dollars and 1982 data in 1982 dollars. Consequently, when making comparisons to prior years, users of the data should consider the inflation that has occurred. CENSUS OF WHOLESALE TRADE ESTABLISHMENT AND FIRM SIZE File Specifications CONTENTS General Data Specifications XIII-7 File Layout XIII-7 GENERAL DATA SPECIFICATIONS Data Fields. This file is recorded in dBase III+ format. Numeric data fields contain no alphabetic information. A few fields (those in percentage form) have explicit decimals, unlike corresponding data on tape, which carry only implied decimals. On the other hand, many data items are scaled in thousands or millions, and this is noted only in the file layouts. Any data field which is subject to any special conditions (e.g., suppression to avoid disclosure, not applicable) is preceded by an information flag field which contains explanatory codes. Kind-of-Business and Size Code Labels. Records in the files are specific to a particular kind of business, as identified by the WHS87KB code. The term "kind of business" is used instead of "standard industrial classification" (SIC) because some kind-of-business categories represent sub-di- visions of SIC categories. Titles for each kind of business are available in Appendix E, and also in the file WHS87KB.dbf on the CD-ROM. Kind-of-business and size code titles can be linked to data files using the dBase SET RELATION command. Index Files. This data file has one index file which can be used quickly jump to desired records (e.g., using the dBase FIND command) or to change the sequence of access. The available index file is listed in the abstract. Where noted in the abstract that an index is to the "first record for" a particular kind of business, the index can be used during dBase FINDs, but the index must be shut off with SET INDEX TO in order to get access to records other than the first for each kind of business. FILE LAYOUT Most data items have an associated "flag" to describe any special conditions applicable. Flags 1, 2, and 3 indicate that the data are not shown and the corresponding data fields contain zeroes. Flags 3 and 4 correspond to categories that are bracketed in the corresponding printed report. Records with flag 4 carry data summarizing the current record and one or more preceding records which carry a flag of 3. The codes are the same for all flags, but are listed in the record layout only for the first flag. In the geographic identification field in each file, NA fields contain either all zeroes or all 9's. See Geographic Code Structure. Census of Wholesale Trade, 1987 Establishment and Firm Size FILE LAYOUT ------------------------------------------------------------ Mnemonic Record Type File Description ------------------------------------------------------------ Num of Chars US ------------------------------------------------------------ WHS87KB 3 Data Kind-of-Business Code (Table Stub Line Number) e.g. 001 Total Wholesale Trade RECTYPE 2 01 Record Type Code: US OPTYPE2 2 Data Type of Operation Code 01 All Types of Operation 02 Merchant Wholesalers 03 Manufacturers Sales Branches and Offices 04 Agents, Brokers, and Commission Merchants 99 Not Applicable to this Record (Tables 2,4, and 8) TABLE_WS 2 Data Table Identifier 01 Sales Size of Establishments, 1987 02 Sales Size of Establishments for Merchant Wholesalers: 1987 03 Employment Size of Establishments, 1987 04 Employment Size of Establishments for Merchant Wholesalers: 1987 05 Single Units and Multiunits, 1987 06 Sales Size of Firms, 1987 07 Employment Size of Firms, 1987 08 Concentration by Largest Firms, 1987 09 Legal Form of Organization, 1987 SALESESW 2 Data Sales Size of Establishments, 1987 01 All Establishments 02 Establishments operated entire year With annual sales of 03 $25,000,000 or more 04 $10,000,000 to $24,999,999 05 $5,000,000 to $9,999,999 06 $2,500,000 to $4,999,999 07 $1,000,000 to $2,499,999 08 $500,000 to $999,999 09 $250,000 to $499,999 10 $100,000 to $249,999 11 Less than $100,000 12 Establishments not operated entire year 99 Not applicable to this record (Tables 2-9) EMPLESTW 2 Data Employment Size of Establishments, 1987 01 All Establishments 02 Establishments Operated Entire Year 03 No employees 04 1 employee 05 2 employees 06 3 or 4 employees 07 5 or 6 employees 08 7 to 9 employees 09 10 to 14 employees 10 15 to 19 employees 11 20 to 49 employees 12 50 to 99 employees 13 100 employees or more 14 100 to 249 employees 15 250 to 499 employees 16 500 to 999 employees 17 1,000 employees or more 18 Establishments not operated entire year 99 Not applicable to this record (Tables 1, 2, 4-9) UNITS_W 2 Data Single Unit/Multiunit Number of Establishments in firm, 1987 01 All Firms 02 Single units 03 Multiunits 04 1 establishment 05 2 establishments 06 3 or 4 establishments 07 5 to 9 establishments 08 10 to 24 establishments 09 25 establishments or more 10 25 to 49 establishments 11 50 to 99 establishments 12 100 establishments or more 99 Not applicable to this record (Tables 1-4, 6-9) SALEFRMW 2 Data Sales Size of Firms, 1987 01 All Firms 02 Firms Operated Entire Year With annual sales of 03 $250,000,000 or more 04 $100,000,0000 or more 05 $100,000,000 to $249,999,999 06 $50,000,000 to $99,999,999 07 $25,000,000 to $49,999,999 08 $10,000,000 to $24,999,999 09 $5,000,000 to $9,999,999 10 $2,500,000 to $4,999,999 11 $1,000,000 to $2,499,999 12 $500,000 to $999,999 13 $250,000 to $499,999 14 Less than $250,000 15 Firms not operated entire year 99 Not applicable to this record (Tables 1-5, 7-9) EMPLFRMW 2 Data Employment Size of Firms, 1987 01 All Firms 02 Firms Operated Entire Year 03 Less than 5 employees 04 5-9 employees 05 10-19 employees 06 20 to 49 employees 07 50 to 99 employees 08 100 employees or more 09 100 to 249 employees 10 250 to 499 employees 11 500 to 999 employees 12 1,000 employees or more 13 Firms not operated entire year 99 Not applicable to this record (Tables 1-6,8,9) CONCENTR 2 Data Concentration by Largest Firms, 1987 01 All Firms 02 4 Largest Firms 03 8 Largest Firms 04 20 Largest Firms 05 50 Largest Firms 99 Not applicable to this record (Tables 1-7, 9) LEGAL_W 2 Data Legal Form of Organization, 1987 01 All types 02 Corporations 03 Individual Proprietorships 04 Partnerships 05 Cooperative associations 06 Other 99 Not applicable to this record (Tables 1-8) FIRMSF 1 Data Data Flag 0 No suppression 1 Data are withheld to avoid disclosing data for individual companies 2 Data not available (NA)(1) 3 Data bracketed, total shown on subsequent record 4 Data bracketed, total shown on this record FIRMS 6 Data/NA Number of Firms, 1987 (NA for Tables 1-4, 8) ESTABF 1 Data Data Flag ESTAB 6 Data Number of establishments, 1987 SALESF 1 Data Data Flag SALES 10 Data Sales, 1987 ($1,000) SALEPCTF 1 Data Data Flag SALEPCT 5 Data/NA Sales as a percent of total sales (1 explicit decimal) (NA for Tables 1-7 and 9) PAYROLLF 1 Data Data Flag PAYROLL 9 Data/NA Annual payroll, 1987 ($1,000) (NA for Tables 1,3,5-7) PAYSALEF 1 Data Data Flag PAYSALE 5 Data/NA Annual payroll as a percent of sales, 1987 (1 explicit decimal) (NA for Tables 1-7 and 9) PAYRO1QF 1 Data Data Flag PAYRO1Q 8 Data/NA First quarter payroll ($1,000) (NA for Tables 1,3,5-7,9) EMPLOYEF 1 Data Data Flag EMPLOYE 7 Data/NA Paid employees for pay period including March 12 (number) (NA for Tables 1,3,5-7) EXPENSEF 1 Data Data Flag EXPENSE 9 Data/NA Operating expenses ($1,000) (NA for Tables 1,3,5-9) INVEN86F 1 Data Data Flag INVEN86 9 Data/NA End of 1986 inventories ($1,000) (NA for Tables 1,3,5-9) INVEN87F 1 Data Data Flag INVEN87 9 Data/NA End of 1987 inventories ($1,000) (NA for Tables 1,3,5-9) The record size is 117 characters (1. This code is used as a flag when the variable is not applicable to a particular table. For example, Table 1, which is identified in position 85 as 01, has no data for firms. The number of firms field will have a flag of 2 for this record). Census of Wholesale Trade, 1987 Establishment and Firm Size on CD-ROM DATABASE STRUCTURE Field Field Field Name Type Size Decimal Field Description WHS87KB C 3 0 Wholesale Trade Kind-of-Business Code (001=Total Wholesale) RECTYPE C 2 0 Record Type (01=U.S.) OPTYPE2 C 2 0 Type of Operation (00=All, 10=Merchant, 20=Mfr, 40=Agent) TABLE_WS C 2 0 Table Identifier SALESESW C 2 0 Sales Size of Establishments Code EMPLESTW C 2 0 Employment Size of Establishments Code UNITS_W C 2 0 Single Unit/Multiunit Number of Establishments in Firm Code SALEFRMW C 2 0 Sales Size of Firm Code EMPLFRMW C 2 0 Employment Size of Firm Code CONCENTR C 2 0 Concentration of Largest Firms Code LEGAL_W C 2 0 Legal Form of Organization Code FIRMSF N 1 0 Flag for FIRMS (0=data, 1- disclosure, 2=NA, 3=}, 4=}total) FIRMS N 6 0 Number of firms, 1987 ESTABF N 1 0 Flag for ESTAB (0=data, 3=}, 4=}total) ESTAB N 6 0 Number of establishments, 1987 SALESF N 1 0 Flag for SALES (0=data, 1=disclosure, 2=NA, 3=}, 4=}total) SALES N 10 0 Sales ($1,000), 1987 SALEPCTF N 1 0 Flag for SALEPCT (0=data, 1=disclosure, 2=NA, 3=}, 4=}total) SALEPCT N 5 1 Sales as a percent of total for this WHS87KB, 1987 (Tab 6 only) PAYROLLF N 1 0 Flag for PAYROLL (0=data, 1- disclosure, 2=NA, 3=}, 4=}total) PAYROLL N 9 0 Payroll entire year ($1,000), 1987 PAYSALEF N 1 0 Flag for PAYSALE (0=data, 1- disclosure, 2=NA, 3=}, 4=}total) PAYSALE N 5 1 Payroll entire year as a percent of sales (NA for tabs 4-5) PAYRO1QF N 1 0 Flag for PAYRO1Q (0=data, 1- disclosure, 2=NA, 3=}, 4=}total) PAYRO1Q N 8 0 Payroll first quarter ($1,000), 1987 EMPLOYEF N 1 0 Flag for EMPLOYE (0=data, 1- disclosure, 2=NA, 3=}, 4=}total) EMPLOYE N 7 0 Number of paid employees for pay period including March 12, 1987 EXPENSEF N 1 0 Flag for EXPENSE (0=data, 1- disclosure, 2=NA, 3=}, 4=}total) EXPENSE N 9 0 Operating expenses ($1,000), 1987 INVEN86F N 1 0 Flag for INVEN86 (0=data, 1- disclosure, 2=NA, 3=}, 4=}total) INVEN86 N 9 0 End-of-1986 inventories ($1,000) INVEN87F N 1 0 Flag for INVEN87 (0=data, 1- disclosure, 2=NA, 3=}, 4=}total) INVEN87 N 9 0 End of 1987 inventories ($1,000) Total Size 117 CENSUS OF WHOLESALE TRADE ESTABLISHMENT AND FIRM SIZE User Notes This section will contain information relevant to the 1987 Census of Wholesale Trade: Geographic Area Series on CD-ROM that indicates specific problems with the data, or that becomes available after the file is released. The cover letter to the updated information should be filed behind this page. User Notes will be sent to all users who (1) purchased their file (or technical documentation) from the Census Bureau and (2) returned the coupon following the CD-ROM File Information.