Occupation Data (Video): Primer Exercise & Exploration Guide

 


DOWNLOADS

Core Competencies

Occupation SOC Codes

 

RELATED ARTICLES

Occupation Data – Behind the i

Occupation Data Use Cases  

Using Occupation Data

Occupation Data Details

What can an LQ do for you?

INTRODUCTION

Location Quotients (LQ) compare the relative concentration in a specific area to the concentration in the U.S. They are mainly used for descriptive and comparative purposes for analyzing Industrial or Employment concentration. The technique compares one economy to a larger, reference economy. LQs identify specializations or weaknesses in the reference economy.

 

DETAILS

There are three things to identify first: a specific Industry or Occupation to examine, the regional economy, and the reference (or comparison), larger economy. This larger economy is often the U.S., but it can also be a group of states, state, or really anything larger than the economy of study.

The value for LQs will hover around 1. An LQ equal to 1 signifies that the local share is equal to the national share; basically the region of study is identical to the reference economy. An LQ of less than 1 means that the local share is less than the national share. This means that the Industry or Occupation’s share of local employment is smaller than its share of the nation; which can highlight a weakness in the local economy. An LQ of greater than 1 (or sometimes 1.2 as a more conservative number) means the local share is greater than the national share and is typically an exporter or perhaps has a specialization in that Industry or Occupation. These Industries employ a greater share of the local workforce than the reference economy or produces more goods and services than can be consumed locally (and are then exported). An LQ over 1.2 shows a regional specialization. So in summary, if the LQ > 1 it is an export, if it is less than 1 it’s an import (Bogart, 1998).

 

CAUTIONS

Note that using LQs is not advisable for small regions. This is because the smaller the region, the less likely it is to be economically diverse. Also, places that have a small overall employment but a few very specialized businesses will return very high LQs. Therefore, check these high LQs against the total employment in your region (Grodach & Ehrenfeucht, 2016). 

When Industries or Regions are aggregated, there will be loss of detail that may show less of a concentration (Bogart, 1998). Therefore, we recommend using the unaggregated IMPLAN Industries.

Finally, just because your Region has a small LQ does not necessarily indicate that there is a case for import substitution by building up this Industry. For example, the LQ for tree nut farming in North Carolina is 0.01. This is mostly due to the climate required to grow things like almonds, pecans, and walnuts, which isn’t in North Carolina.

 

FINDING THEM IN IMPLAN

The LQs reported in IMPLAN will always use the U.S. as the reference economy. Data on LQs can be found in Region Details.

Behind the i

     > Occupational Data

          > Area Occupation Summary

In the Location Quotient column, you will see a value that compares your region, in this example North Carolina, to the U.S. This shows the wage and salary employment based location quotient for the occupation. Clicking on the column title, you can sort the columns to show the largest and smallest LQs. In North Carolina in 2018, the largest LQ was in the Occupation 51-6063 Textile Knitting and Weaving Machine Setters, Operators, and Tenders at 6.91. In fact, the top eight Occupations are all in the Broad (4-Digit) category (51-60XX).

LQ_-_NC_Area_Occupation_Summary.jpg

You will also find LQs in Core Competencies.

Behind the i

     > Occupational Data

          > Core Competencies

               > Area Summary

In the three tables for Ability, Knowledge, and Skills, you will find the competency based LQ as compared to the U.S. as a whole.

LQ_-_NC_Area_Summary_KSA.jpg

 
In the three tables for Education Required, Work Experience Required, and On-the-Job Training, you will find the Wage and Salary Employee count based location quotient as compared to the U.S. as a whole.

LQ_-_NC_Area_Summary_EWO.jpg

 

CALCULATING THEM ON YOUR OWN

If you are looking for LQs for Employment, Labor Income, or Output, they are very easy to calculate using IMPLAN data. Select your Region and head Behind the i. On the Regions Overview screen the table at the bottom will list IMPLAN Industries with their associated Employment, Labor Income, and Output. You can download the table by clicking on the ellipses as shown. This will open up an Excel spreadsheet with the values.

LQ_-NC_Industries.jpg

You can use the LQ Template to calculate the Employment LQ for your Region against the U.S. Copy the Employment for all IMPLAN Industries from your downloaded file and paste them into Column E – Your Region’s Employment. The spreadsheet will automatically calculate the LQ in column G.

If you want to examine either Labor Income or Output, simply replace the national figures in Column C with the values for Labor Income or Output for the U.S. Then paste the Labor Income or Output value for your Region in Column E. 

You can also compare your Region to something other than the nation. For example, we could look at the Charlotte–Concord–Gastonia Metropolitan Statistical Area compared to the state of North Carolina. In this case, simply replace Column C with the North Carolina values and Column E with the MSA values.

LQ Template 

 

THE MATH

The formula is LQ =
     Local Concentration / National (or reference Region) Concentration

More specifically the formula for the Employment LQ is:

     LQ ir = (xir/xr) / (xin/xn)

     where

          xir = employment of sector i in region r

          xr  = total employment in region r

          xin = employment of sector i in the reference region

          xn  = employment in the reference region

 

GOVERNMENT RESOURCES

BEA: What are location quotients (LQs)?

QCEW Location Quotient Details

 

REFERENCES

Bogart, W.T. (1998). The Economics of Cities and Suburbs. Upper Saddle River, NJ: Prentice Hall.

Grodach, C. & Ehrenfeucht, R. (2016). Urban Revitalization: Remaking Cities in a Changing World. New York: Routledge.

 

RELATED ARTICLES

Occupation Data

Occupation Data

INTRODUCTION

The Occupation Data header contains information about all of the Standard Occupational Classification (SOC) data in your Region. The SOC categorizes jobs into one of 823 detailed occupations which contains 459 broad groups, 96 minor groups, and 23 major groups. This article outlines descriptions of the terms and categories found within the tables. 

Occupation Data only includes Wage & Salary Employment. No Proprietor Employment is included.

Level

Name

Records

Total

All occupations

1

Major

2-digit

23

Minor

3-digit

96

Broad

4-digit

459

Detail

5-digit

823

 

WAGE & SALARY INCOME VS EMPLOYEE COMPENSATION

Wage & Salary income includes base salary and/or wages, employee paid social insurance tax, bonuses, stock options, severance pay, profit distributions, and reimbursements for meals and lodging. Employee Compensation (EC) includes all the above as well as the employer portion of social insurance tax, employer contributions to 401K, and reimbursements for special benefits, such as gym memberships. As EC includes all additional costs of employment, it is often described as the total cost of an employee (or of employees) to the employer or fully-loaded payroll. The difference between them is referred to as supplements to wage and salary income and includes the employer portion of social insurance tax, employer contributions to 401K, and reimbursements for special benefits.

 

FINDING THE DATA

You can locate the Occupation Data by navigating Behind the i on the Regions screen. The Occupation Data has its own tab full of useful information.

Occ_Behind_i_-_Header.jpg

AREA OCCUPATION SUMMARY

This table lists by-occupation data for the region. By default, occupations are presented at the detail level. Use the filter option to select one of the detail levels presented in the table at the beginning of this article.

  • Occ Code = occupation code
  • Occupation = description of the occupation
  • Wage and Salary Employment = regional wage and salary employment for the occupation; excluding Proprietors which are not included in IMPLAN’s occupation data
  • Wage and Salary Income = regional wage and salary income for the occupation 
  • Supplements to Wages and Salaries = value of benefits and bonuses paid to wage and salary workers; the difference between Employee Compensation and Wage and Salary Income
  • Employee Compensation = regional employee compensation for the occupation
  • Hours Worked = hours worked by the occupation
  • Location Quotient = wage and salary employment based location quotient for the occupation, as compared to the U.S. as a whole

AREA OCCUPATIONAL AVERAGES

This table lists by-occupation average data for the region. By default, occupations are presented at the detail level. Use the filter option to select one of the detail levels presented in the table at the beginning of this article.

  • Occ Code = occupation code
  • Occupation = description of the occupation
  • Average Wage and Salary Income = average wage and salary income for the occupation
  • Average Supplements to Wages and Salaries = average value of benefits and bonuses paid to wage and salary workers; the difference between Employee Compensation and Wage and Salary Income
  • Average Employee Compensation = average employee compensation for the occupation
  • Average Hours per Year = average hours worked per year for the occupation
  • Average Wage and Salary Income per Hour = average per hour rate of wage & salary income for the occupation (W&S/hours worked)
  • Average Supplements to Wages and Salaries per Hour = average per hour rate of supplements to wage & salary income for the occupation (supplements to W&S/hours worked)
  • Average Employee Compensation per Hour = average per hour rate of employee compensation for the occupation (EC/hours worked)

 

INDUSTRY OCCUPATIONAL DETAIL

This table lists by-industry by-occupation data for the Region. By default, occupations are presented for IMPLAN Industry 1 – Oilseed Farming. Use the Filter option to select a different Industry. 

  • Occ Code = occupation code
  • Occupation = description of the occupation
  • Wage and Salary Employment = regional wage and salary employment for the occupation; excluding Proprietors which are not included in IMPLAN’s occupation data
  • Wage and Salary Income = regional wage and salary income for the occupation 
  • Supplements to Wages and Salaries = value of benefits and bonuses paid to wage and salary workers; the difference between Employee Compensation and Wage and Salary Income
  • Employee Compensation = regional Employee Compensation for the occupation
  • Hours Worked = hours worked by the occupation
     

INDUSTRY OCCUPATIONAL AVERAGES

This table lists by-industry by-occupation average data for the Region. By default, occupations are presented for IMPLAN Industry 1 – Oilseed Farming. Use the Filter option to select a different Industry. 

  • Industry Code = IMPLAN Industry Code
  • Description = description of the IMPLAN Industry
  • Occ Code = occupation code
  • Occupation = description of the occupation
  • Average Wage and Salary Income = average wage and salary income for the occupation
  • Average Supplements to Wages and Salaries = average value of benefits and bonuses paid to wage and salary workers; the difference between Employee Compensation and Wage and Salary Income
  • Average Employee Compensation = average employee compensation for the occupation
  • Average Hours per Year = average hours worked per year for the occupation
  • Average Wage and Salary Income per Hour = average per hour rate of wage & salary income for the occupation(W&S/hours worked)
  • Average Supplements to Wages and Salaries per Hour = average per hour rate of supplements to wage & salary income for the occupation(supplements to W&S/hours worked)
  • Average Employee Compensation per Hour = average per hour rate of employee compensation for the occupation (EC/hours worked)

 

CORE COMPETENCIES

Occ_Behind_i_-_Core_Competencies.jpg

AREA SUMMARY

These tables summarize the regional composition of each competency. 

Ability, Knowledge, and Skills

  • Competency Code = Unique competency identifier from O*Net competency codes
  • Description = Competency description from O*Net competency descriptions 
  • Ext Description = further details on the competency description
  • Competency Points = The sum of competency points are a measure of the human capital endowments in the Region given the current occupation mix of Employment in the Region. For more information on how competency points are calculated, see the article Occupation Data Details.
  • Competency Share of Total = A measure of the relative size of a competency when compared to the total sum of like competencies; how important this competency is compared to other like competencies. Example formula (Ability: Oral Comprehension Competency Points / Sum of Ability Comprehension Points). 
  • Location Quotient = Competency based location quotient as compared to the U.S. as a whole

Education Required, Work Experience Required, and On-the-Job Training

  • Competency Code = Unique competency identifier from O*Net competency codes 
  • Description = Competency description from O*Net competency descriptions
  • Employee Count = The sum of Wage and Salary employees estimated to exhibit the specified competency. For more information, see the article Occupation Data Details.
  • Employee Count Share of Total = A measure of the percent of total wage and salary employees that exhibit the given competency.
  • Location Quotient = Wage and Salary Employee count based location quotient as compared to the U.S. as a whole

 

INDUSTRY SUMMARY

These tables summarize the regional composition of each competency by industry. Use the filter to switch which industry’s information is displayed as Industry 1 – Oilseed farming will be displayed by default.

Ability, Knowledge, and Skills

  • Industry Code = IMPLAN Industry code
  • Description = IMPLAN Industry description
  • Competency Code = Unique competency identifier from O*Net competency codes 
  • Description = Competency description from O*Net competency descriptions
  • Ext Description = further details on the competency description
  • Competency Points = The sum of competency points are a measure of the human capital endowments in the Region given the current occupation mix of Employment in the Region. For more information on how competency points are calculated, see the article Occupation Data Details.
  • Competency Share of Total = A measure of the relative size of a competency when compared to the total sum of like competencies; how important this competency is compared to other like competencies. Example formula (Ability: Oral Comprehension Competency Points / Sum of Ability Comprehension Points). 

Education Required, Work Experience Required, and On-the-Job Training

  • Industry Code = IMPLAN Industry code
  • Description = IMPLAN Industry description
  • Competency Code = Unique competency identifier from O*Net competency codes
  • Description = Competency description from O*Net competency descriptions
  • Employee Count = The sum of Wage and Salary Employees estimated to exhibit the specified competency. For more see the article Occupation Data Details.
  • Employee Count Share of Total = A measure of the percent of total Wage and Salary Employees that exhibit the given competency.

OCCUPATION SUMMARY

These tables summarize the regional composition of each competency by occupation. Use the filter to switch which occupation’s information is displayed.

Ability, Knowledge, and Skills

  • Occ Code = occupation code
  • Occupation = description of the occupation
  • Competency Code = Unique competency identifier from O*Net competency codes 
  • Description = Competency description from O*Net competency descriptions
  • Ext Description = further details on the competency description
  • Competency Points = The sum of competency points are a measure of the human capital endowments in the Region given the current occupation mix of Employment in the region. For more information on how competency points are calculated, see the article Occupation Data Details.
  • Competency Share of Total = A measure of the relative size of a competency when compared to the total sum of like competencies; how important this competency is compared to other like competencies. Example formula (Ability: Oral Comprehension Competency Points / Sum of Ability Comprehension Points). 

Education Required, Work Experience Required, and On-the-Job Training

  • Occ Code = occupation code
  • Occupation = description of the occupation
  • Competency Code = Unique competency identifier from O*Net competency codes 
  • Description = Competency description from O*Net competency descriptions 
  • Employee Count = The sum of wage and salary employees estimated to exhibit the specified competency. For more information, see the article Occupation Data Details\
  • Employee Count Share of Total = A measure of the percent of total Wage and Salary Employees that exhibit the given competency

SORTING

The title bar displayed across the top of each table contains buttons that can change the viewing attributes. Clicking next to the name in the grey box will sort the column of interest either in ascending (first click) or descending (second click) order.

Occ_Behind_i_-_Sort.jpg

 

DOWNLOADING

The export function allows data to be exported directly to a PDF or CSV file by clicking on the gear icon. Clicking on the ellipses will download each table individually.

Occ_Behind_i_-_Download.jpg

 

DOWNLOADS

Core Competencies

Occupation SOC Codes

 

RELATED ARTICLES

Occupation Data Details

Using Occupation Data in IMPLAN

Occupation Data Use Cases 

Occupation Data Use Cases

DEVELOPING TARGETED JOB TRAINING INITIATIVES WITH REGIONAL STRENGTHS & WEAKNESSES

Preparing the local workforce to fill the jobs that local businesses have open (or will have open in the future) can help close the economic loop within a regional economy. That is, the ideal situation would be for local jobs to be filled by local workers. This helps close the regional loops by preventing wage leakage due to commuting and by grounding local businesses within the community. Whether it is the local community college, job skills training programs, or vocational up-training programs it’s important that there is alignment between the training received by workers and the skills needed by local businesses. The goal of this article is to demonstrate how a community can evaluate the types of jobs in the local economy, the skills needed to fill those jobs, and the expected wages of those jobs so that local education partners can train local workers to fill them and keep more talent, more businesses, and more money in the local economy. Check out the article on Location Quotients to learn how the Occupational LQs can help inform these decisions: What can an LQ do for you?

 

EMPLOYMENT REQUIREMENTS: NEW HOSPITAL OPERATIONS

Whatever your impact or contribution, one of the most valuable ways to tell your story comes from the jobs your activity supports. Whether it’s by directly employing people, the jobs your activity supports through your supply chain, or through jobs supported by wage spending, jobs are one of the most tangible and important measures of your impact or contribution. 

As an example, let’s consider a new hospital being built in Mecklenburg County, NC. This is a new, state-of-the-art, hospital in an underserved  urban area. Once the hospital is finished it will employ 500 workers. The company building and operating the hospital would like to show the County Board of Commissioners what the Economic Impact will be of the operations of the hospital. The Board of Commissioners has said that in addition to creating economic impacts, they will need to show that at least 40% of the 500 expected jobs (or at least 200 jobs) at the hospital will go to workers who have education levels less than a bachelor’s degree in order to qualify for certain requirements for tax exemptions.

Framing a full economic impact of a hospital is covered in detailed articles on Construction and Hospitals, so here we will keep things simple and focus on fulfilling the requirement of 40% of jobs going to a workforce with less than a bachelor’s degree. After setting up and running our analysis, we can use the Occupation Data to determine what the education level is of the workers expected for the hospital. Here’s how this project looks on the Impact screen:

 

Occ_Uses_-_Hosp_Set_Up.jpg

By looking at the Core Competencies on the Results tab of our analysis, we can find the Education table below that shows the distribution of the education levels of the Direct Jobs.

 

Occ_Uses_-_Hosp_Emp.jpg

Adding up the workers at education levels below “Bachelor’s Degree” the firm is able to show that they expect more than 350 of the 500 (or more than 70%) of the jobs at the hospital to go to workers who have education levels less than a Bachelor’s Degree. 

Additionally, if we include not only the 500 Direct Jobs in the hospital, but ALL jobs through the supply chain and support through the spending of wages (i.e. Direct, Indirect, and Induced jobs), we can see that more than 70% of the nearly 800+ jobs in Mecklenburg County supported by the operations of the hospital are expected to go to workers who have less than a Bachelor’s Degree. This means that the hospital more than doubles the requirements for the tax exemption, which is sure to make the Board of Commissioners quite happy!

 

Occ_Uses_-_Hosp_Emp_2.jpg

 

EVALUATING DIFFERENT OCCUPATION OPPORTUNITIES (NMTC)

New market tax credits are powerful incentives that the economic development community can use to entice new businesses or encourage business retention within the local economy. However, it can be difficult to understand what different opportunities bring to the local economy. This section demonstrates how analysts might compare two (or more) economic development opportunities in terms of the numbers, types, and wages of the jobs that would be expected to  accompany them.

Let’s say the IMPLAN Economic Development Corporation™ has received approval from Mecklenburg County, NC to provide a New Market Tax Credit (NMTC) to a new business being brought into the county. The objective of the NMTC is to provide more jobs in the county for low-skill, low-income workers in coordination with affordable housing projects in progress. So, the requirements for the NMTC are that the project must support at least 100 jobs in occupations that make an average wage of less than $45,000 per year in Mecklenburg County.

There are two applications for the NMTC. The first application is for a Restaurant Co-op which would house four different restaurants and will employ a total of 125 people. The other application is for a retail business which provides tutoring, test preparation, and other educational services which will employ 225 people. Here’s how this looks on the Impacts screen:

Occ_Uses_-_NMTC_1.jpg

Looking at the Occupation Data in IMPLAN for Mecklenburg County, we can see there are 7 major occupation categories that have an average annual wage of less than $45,000.

Occ_Uses_-_NMTC_2.jpg

Food preparation workers and education services workers are both in this group. Since we know the education services business is planning to employ 100 extra employees, we could reasonably expect that it may produce more jobs with wages below $45,000. However, with the new Occupation Data in IMPLAN we can actually look at these individual occupations and how many jobs are in each category. 

First, let’s look at the jobs breakdown for the Education Services Business:

Occ_Uses_-_NMTC_3.jpg

Next, let’s take a look at the breakdown for the Restaurant Co-op.

Occ_Uses_-_NMTC_4.jpg

Digging deeper into the occupational distribution of the jobs supported by these projects it’s apparent that the restaurant co-op project is likely to produce more jobs with annual salaries below $45,000, even though the education services business is going to initially employ 100 more people. 

Using this type of analysis can help guide local development groups towards policy that are more aligned with their stated goals. Let’s hope the four new restaurants are fantastic. Maybe we’ll finally get that good Thai food restaurant we’ve been hoping for!

Occupation

Average Annual Wage

Jobs Supported by the Restaurant Co-Op

Jobs Supported by the Education Services

Food Preparation and Service Related Occupations (35-0000)

$21,622.75

114.38

4.26

Personal Care and Service Workers (39-0000)

$22,642.71

0.77

6.24

Military (99-0000)

$26,534.78

0

0

Building and Grounds Cleaning and Maintenance Occupations (37-0000)

$30,194.95

1.61

2.69

Healthcare Support Occupations (31-0000)

$32,338.17

0.49

0.84

Protective Service Occupations (33-0000)

$39,842.25

0.57

2.48

Education, Training, and Library Occupations (25-0000)

$42,512.70

0.33

54.13

TOTAL JOBS

118.15

70.64

 

BUSINESS LOCATION OR EXPANSION

As organizations look to expand, locate, or relocate, one of the primary questions they must answer is how prospective areas match the labor force needs of the business. That is, are the workers needed by the business available in the area? What are the differences in wages between workers in one area versus another? The answers to these questions often play a crucial role in the decision-making process for business evaluating location decisions. This section demonstrates how this type of analysis can be done using the IMPLAN application and the Occupation Data within it. 

As an example, let’s consider a financial consulting firm that wants to expand its operations into North Carolina. The firm is considering Charlotte, Raleigh, and Asheville as possible locations. They would like to know how many Accountants, Actuaries, Bookkeepers, and Financial Analysts are in each of those areas and how much each makes on average. 

Charlotte is located in Mecklenburg County, Raleigh is in Wake County, and Asheville is in Buncombe County, so we’ll use those three counties as the Regions for this analysis.

The Occupation Codes for each of the interested jobs are in the table below (broad categories).

Occupation Common Name

SOC Code

SOC Code Description

Accountants

13-2010

Accountants and Auditors

Actuaries

15-2010

Actuaries

Bookkeepers

43-3030

Bookkeeping, Accounting, and Auditing Clerks

Financial Analysts

13-2050

Financial Analysts and Advisors

For each of these Occupations, the firm would like to know the number of wage and salary employees, the annual take-home wages, and the location quotient in each of three identified counties. This will help them understand how each of the proposed laborsheds are prepared to accommodate the needs of the firm. Using the data Behind the i on the Regions screen, we can gather the data requested and display it in the tables below.

Buncombe County

Occupation

Location Quotient

Wage and Salary Employment

Average Wage and Salary Income

Financial Analysts and Advisors

0.64

380

$109,403.72

Bookkeeping, Accounting, and Auditing Clerks

0.94

1,431

$36,831.00

Actuaries

0.42

8

$98,672.70

Accountants and Auditors

0.86

1,048

$67,457.31

 

Mecklenburg County

Occupation

Location Quotient

Wage and Salary Employment

Average Wage and Salary Income

Financial Analysts and Advisors

2.10

6,608

$179,280.94

Bookkeeping, Accounting, and Auditing Clerks

1.21

9,752

$57,625.92

Actuaries

1.75

175

$165,185.81

Accountants and Auditors

1.40

9,078

$113,093.86

 

Wake County

Occupation

Location Quotient

Wage and Salary Employment

Average Wage and Salary Income

Financial Analysts and Advisors

1.06

2,696

$135,293.58

Bookkeeping, Accounting, and Auditing Clerks

1.05

6,848

$48,785.09

Actuaries

1.18

95

$153,844.24

Accountants and Auditors

1.16

6,089

$92,513.26

From these data, the firm can see that there simply aren’t enough of the workers they would need in Buncombe County and thus Asheville would not be a wise place to locate. However, both Mecklenburg and Wake Counties have Location Quotients above 1.00, implying that these occupations are more available in these counties than the U.S. average. That means both counties are generally well stocked with the workers this firm would need.

Further, between Mecklenburg and Wake Counties there is a trade off to consider. Mecklenburg County has more employees in every relevant occupation than does Wake County. However, those workers all earn more income in Mecklenburg County, implying that labor costs of the firm would be higher in Mecklenburg County than costs for the same amount of workers in Wake County. The firm will now have to decide whether the increased availability of workers in Mecklenburg are worth the projected increased costs. 

This type of analysis provides the firm with data upon which to make sound planning decisions about where the new operation should be located.

 

DOWNLOADS

Core Competencies

Occupation SOC Codes

 

RELATED ARTICLES

Occupation Data Details

Using Occupation Data in IMPLAN

Occupation Data – Behind the i

Using Occupation Data in IMPLAN

INTRODUCTION

IMPLAN has added its occupation employment by industry data to the IMPLAN application. This dataset shows estimates of occupation employment, wages, hours, and core competencies which include knowledge, skills, abilities, education, work experience, and on-the-job training levels for each of 823 different occupations. Occupation data is available for all models, including models of combined regions, aggregated industry models, and customized models. Occupation data will match the current Data Year in IMPLAN (ie 2018 Data Year will show 2018 Employee Compensation).

There are two different types of Occupation Data that are useful during your analysis: Regional Occupation Data and Occupation Impact Data. 

Regional Occupation Data shows the Occupations, Wages, and Core Competencies that are already present in the Region you are studying. You can find this data Behind the i on the Region page. 

Occupation Impact Data shows the details for the Occupations, Wages, and Core Competencies that accompany your specific impact or contribution.

 

DETAILS

Occupation data can be used to examine study area data to gain important insights into a Region’s existing labor force, the skill requirements of various Industries, and more. The Occupation Data can also be seen in the Results of any impact or contribution analysis run within the IMPLAN application.

The data levels generally correspond to the BLS’s Standard Occupational Classification (SOC) codes. Major is the most aggregated, followed by Minor, Broad, and Detail. All data is based on national averages but brought to the regional level in IMPLAN. As with Employment, you may see fractional Occupations, especially for small firms where a few employees are spread across multiple Occupations.

The SOC categorizes occupations into one of 823 detailed occupations which contains 459 broad groups, 96 minor groups, and 23 major groups. 

Level

Name

Records

Example

Total

All occupations

1

All Occupations

Major

2-digit

23

51-0000 – Production Occupations

Minor

3-digit

96

51-7000 – Woodworkers

Broad

4-digit

459

51-7030 – Model Makers and Patternmakers, Wood

Detail

5-digit

823

51-7032 – Patternmakers, Wood

 

WHERE TO FIND OCCUPATION DATA

REGIONS OVERVIEW

The tables located in the Regions Overview provide insight into the model Region’s occupation makeup. Descriptions of the data found here are detailed in our Occupation Data – Behind the i article.

 

Occ_Behind_i_-_Header.jpg

IMPACTS

Distributions of occupation employment, wage, and core competencies are applied only to regional and results data. At this time, you cannot run impacts based on occupations.

RESULTS

The Occupation Impact Data shows the details for the Occupations, Wages, and Core Competencies that accompany your specific impact or contribution in the Results tab. Descriptions of the data found here are detailed in our Occupation Data – Behind the i article.

 

Occ_Uses_-_Results_Header.jpg

The Occupation Impact Tab opens the Occupation Impacts screen containing a single table detailing regional employment and wage impacts by-occupation. Use the Filters to limit results to desired Region, Group, Event, and Industry. The Filter can also be used to select a different occupation aggregation level. 

The Occupation Impact Averages tab opens the Occupation Impacts screen containing a single table detailing the average regional employment and wage impacts by-occupation. Use the Filters to limit results to desired Region, Group, Event, and Industry. The Filter can also be used to select a different occupation aggregation level. 

Core Competency opens the Competency Impacts screen containing tables for each core competency category (Ability, Knowledge, Skills, Education Required, Work Experience Required, On-the-Job Training Required). Use the Filters to limit results to desired Region, Group, Event, Industry, and occupation. The filter can also be used to select a different occupation aggregation level. 

 

DOWNLOADS

Core Competencies

Occupation SOC Codes

 

RELATED ARTICLES

Occupation Data Details

Occupation Data Use Cases 

Occupation Data – Behind the i

Institutional Spending Pattern Events

INTRODUCTION

Institutional Spending Patterns, like all Spending Patterns, are made up of a list of Commodities, although Institutional Spending Patterns include government payroll Commodities to capture spending on Labor. Because Institutions are Final Demanders, in the case of Institutional Spending Patterns, each Commodity in the Spending Pattern is treated like a Commodity Output Event and will create a Direct Effect.

Event Type

Institutional Spending Patterns 

Event Use

Analyzing general fiscal spending changes

Event Specification

”WHO” 

Federal Government NonDefense

Federal Government Defense

Federal Government Investment

State/Local Govt. Other Services

State/Local Govt. Education

State/Local Govt. Hospital & Health

State/Local Govt. Investment

Capital

Inventory Additions/Deletions

Event Value

“WHAT” 

Total Spending on Goods, Services and Labor

 

INSTITUTIONAL SPENDING PATTERN EVENTS

IMPLAN can be accessed via app.IMPLAN.com. Once you are logged in, you will be directed to the IMPLAN dashboard. From the dashboard you can navigate to the Regions, Impacts, or Projects screen. 

IMPLAN_Dashboard.jpg

Once you have chosen your Region and named your new Project, you will be directed to the Impacts screen. From here, click on Add New Event to create a Institutional Spending Pattern Event. In this set of examples, 2018 Nevada data is utilized.

Institutional_Spending_Pattern_-_Impacts.jpg

Institutional Spending Pattern Events are unique in that they describe both Intermediate Inputs and Value Added within the same Spending Pattern. This results in these Spending Patterns producing ‘mixed results;’ where the reported Direct Effects describe both what we would generally consider Direct Effects (income, Employment and Value Added) and the first-round Indirect Effects that arise from the government spending its budget. Institutional Spending Pattern Events can be edited. Learn more in the article Editing Institutional Spending Pattern Events.

In this example, we want to look at a potential $1M increase in education spending by the government. We will give our new Event a Title, select the Type as Institutional Spending Pattern, the Specification is 12002 – State/Local Government Education, and the Value is $1,000,000. 

Institutional_Spending_Pattern_-_Event.jpg

Now that you have your Event, ensure that it is highlighted in teal by clicking on the Event or checking Select All Events at the top of the screen. Now the Events can be dragged into your Group on the right.

Institutional_Spending_Pattern_-_Drag.jpg

You will know when the Events have populated in the Group when the number in the upper right of the Group box equals the number of Events.

Institutional_Spending_Pattern_-_Group.jpg

Now click Run in the bottom right of the Impacts Screen.

The Institutional Spending Pattern Event Type represents a general spending distribution for measuring broad Institutional activity in your Region. 

Institutional_Spending_Pattern_-_Results.jpg

RELATED ARTICLES

ABP: Introduction to Analysis-By-Parts

Editing Institutional Spending Pattern Events

Explaining Event Types

Industry Contribution Events

INTRODUCTION

Industry Contribution Analysis (ICA) is a method used to estimate the value of an Industry or group of Industries in a Region, at their current levels of production. While the focus of the analysis still looks at backward linkages, the purpose of this analysis differs from the standard economic impact analysis. ICA shows the relative extent and magnitude of the Industry, event, or policy in the study area.

ICA is a unique method which applies a constraint upon the model by removing feedback linkages (buybacks) to the Industry being analyzed. This method can also be used with single firms, but if/when it is, the results of this method should be considered conservative.

ICA denotes that the study is looking at how the current state of an Industry supports other businesses in the local economy. When this involves a single firm, the analyst will need to determine if the Impact Method or Industry Contribution Analysis Method should be used. The results in either case should be described with words such as “contributes to” or “sustains.”  

Event Type

Industry Contribution

Event Use

Estimating effect of an existing Industry’s production

Event Specification

”WHO” 

Industry 1-546  for which the contribution is being measured

Event Value

“WHAT”

Output or % of Industry

 

INDUSTRY CONTRIBUTION EVENTS

IMPLAN can be accessed via app.IMPLAN.com. Once you are logged in, you will be directed to the IMPLAN dashboard. From the dashboard you can navigate to the Regions, Impacts, or Projects screen. 

 

IMPLAN_Dashboard.jpg

 

Once you have chosen your Region and named your new Project, you will be directed to the Impacts screen. From here, click on Add New Event to create a Industry Contribution Event. In this set of examples, 2018 Nevada data is utilized.

 

ICA_-_Impacts.jpg

In this example, we want to look at the contribution of the entirety of the hotel Industry in Nevada. We will give our new Event a Title, select the Type as Industry Contribution Analysis, the Specification is 507 – Hotels and motels, including casino hotels, and the Value is 1. The buttons after the Event Value give us the choice between entering a dollar value or entering a percentage of the total Industry. In that we want to see the entire Industry, we will select the %. Check out the article Picking an Industry for assistance in choosing the appropriate IMPLAN Industry.

 

ICA_-_Event.jpg

Now that you have your Event, ensure that it is highlighted in teal by clicking on the Event or checking Select All Events at the top of the screen. Now the Events can be dragged into your Group on the right.

 

ICA_-_Drag.jpg

You will know when the Events have populated in the Group when the number in the upper right of the Group box equals the number of Events. You will also see a new icon in teal indicating that this is an Industry Contribution Analysis.

ICA_-_Group.jpg

 

Now click Run in the bottom right of the Impacts Screen.

 

ICA_-_Results.jpg

To see how the constraints on the hotel Industry worked, navigate to the Output tab in the Results. The largest Industry in terms of Output was Industry 507 – Hotels and motels, including casino hotels with a total of $15,193,837,564.97. On the Industries by Impact table, you can see that the entirety of this was in the Direct Effect and the Indirect and Induced Effects in this Industry are zero. If we had used a standard Industry Output Event, there would be additional Indirect and Induced Effects in our Results.

 

ICA_-_Output_Results.jpg

 

 

RELATED ARTICLES

Explaining Event Types

ICA: Introduction to Industry Contribution Analysis

Industry Spending Pattern Events

INTRODUCTION

Industry Spending Patterns include all Intermediate Inputs for a given Industry. Industry Spending Pattern Events are most appropriate to use when an analyst has the data required to build a customized Spending Pattern which reflects specific purchases by an Industry or when the ratios in an Industry’s Leontief Production Function must be modified to a degree beyond that which is achievable by simply customizing an Industry Event. 

Event Type

Industry Spending Patterns 

Event Use

Analyzing a change in Intermediate Inputs

Event Specification

”WHO” 

Industry 1-546 making purchases of Intermediate Inputs

Event Value

“WHAT”

Intermediate Inputs or Output (per Advanced Menu)

INDUSTRY SPENDING PATTERN EVENTS

IMPLAN can be accessed via app.IMPLAN.com. Once you are logged in, you will be directed to the IMPLAN dashboard. From the dashboard you can navigate to the Regions, Impacts, or Projects screen. 

IMPLAN_Dashboard.jpg

Once you have chosen your Region and named your new Project, you will be directed to the Impacts screen. From here, click on Add New Event to create an Industry Spending Pattern Event. In this set of examples, 2018 Nevada data is utilized.

Industry_Spending_Pattern_-_Impacts.jpg

At the most basic level, Industry Spending Pattern Events can be used to examine the economic impact of only the Intermediate Inputs of an Industry. Intermediate Inputs are the purchases of non-durable goods and services that are used to produce other goods and services rather than for final consumption. Industry Spending Patterns can be edited through the Advanced Menu. Learn more in the article: Editing Industry Spending Pattern Events.

In this example, we want to look at only the spending on Intermediate Inputs by casinos. We will give our new Event a Title, select the Type as Industry Spending Pattern, the Specification is 503 – Gambling industries (except casino hotels), and the Value is $1,000,000. Check out the article Picking an Industry for assistance in choosing the appropriate IMPLAN Industry.

Industry_Spending_Pattern_-_Events.jpg

Now that you have your Event, ensure that it is highlighted in teal by clicking on the Event or checking Select All Events at the top of the screen. Now the Event can be dragged into your Group on the right.

Industry_Spending_Pattern_-_Drag_Events.jpg

You will know when the Events have populated in the Group when the number in the upper right of the Group box equals the number of Events.

Industry_Spending_Pattern_-_Group.jpg

Now click Run in the bottom right of the Impacts Screen.

The first thing you will notice is that there are no Direct Effects. Industry Spending Pattern Events only affect spending on Intermediate Inputs, so there will only be Indirect and Induced Effects. Learn more in the article Explaining Event Types.

 

Industry_Spending_Pattern_-_Results.jpg

Industry Spending Pattern Events are often used as part of Analysis-by-Parts (ABP). ABP allows you to examine a specialized Industry or a firm that is not reflected by an IMPLAN Industry due to differences in the structure of the Leontief Production Function and/or Spending Pattern that cannot be edited via a single Industry Event. This type of analysis is typically used to split the stemming ripple effects of an Industry Impact into its individual impact components – budgetary Spending Pattern (Intermediate Inputs), which can be analyzed using an Industry Spending Pattern Event, and payroll, which can be analyzed using Labor Income Event(s).

 

RELATED ARTICLES

ABP: Introduction to Analysis-By-Parts

Editing Industry Spending Pattern Events

Explaining Event Types

Understanding Intermediate Inputs (II)