Introduction to Wyoming’s Occupational Staffing Patterns and Wages 2003

William (Tony) Glover
Senior Analyst
12/28/2004

Downloads (Revised 12/28/2004)

This complete document "Introduction to Wyoming’s Staffing Patterns and Wages 2003" including the Appendices in Adobe Acrobat Portable Document Format (PDF). Requires Adobe Acrobat Reader software available for free at http://www.adobe.com).
The Excel (very large 9.9 MB) File "Wyoming’s Staffing Patterns and Wages 2003" is also available in ZIP (compressed 2.1 MB) format for download.  Requires Microsoft Excel or Excel 97/2000 Viewer available for free at http://www.microsoft.com).

 

A few questions the data described in this document allow you to answer.

Table 1 - Question 1)

I am an out-of-state entrepreneur interested in starting a small (100 employees) Computer Manufacturing company in the Northeast Region of Wyoming. What are the typical types of occupations I need to staff my company? How many of each?

Table 1 - Question 2)

What are the estimated costs associated with staffing my Computer Manufacturing company?

Table 1 - Question 3)

What are the chances of acquiring the labor with the skills I need in the Northeast Region of Wyoming?

Table 2 - Question 1)

As the prospective entrepreneur from the questions in T1-Q1 to Q3 relative to the jobs I need to fill from data in Table 1. What industries can I recruit Electrical Engineers from? How much will I have to pay?

Table 2 - Question 2)

I recently graduated with a Bachelors degree in Electrical Engineering. What industries employ Electrical Engineers and How much do they pay?

Table 3 - Question 1)

As the prospective entrepreneur from the questions in T1-Q1 to Q3 relative to the jobs I need to fill from data in Table 1. What other states can I recruit Electrical Engineers from? How much will I have to pay?

Table 3 - Question 2)

As a recent Electrical Engineering graduate would I be better off, with respect to wages, moving to Colorado? Idaho? Montana?
* The Ts and Qs are bolded above as they reference the Question & Answers format in this document. For example, the first question above is referred to as T1-Q1 and the corresponding answer is T1-A1 (Table 1 – Answer 1).

This is Research & Planning’s third release of the Customized Staffing Patterns and Wages. The initial staffing patterns were developed to assist communities, firms, educators, and counselors in identifying the labor needs and costs associated with recruiting and/or establishing new businesses. The updated staffing patterns add tools for prospective employers and job seekers to explore industry and geographic variations in employment and wages by occupation. This round, I have developed techniques whereby confidentiality issues are addressed allowing a more detailed and representative release of data than in the past.

This document begins by describes the changes between this release and the two previous versions, and introduces the three data sources used in the creation of Wyoming’s Customized Staffing Patterns and Wages 2003. An example of each table is provided with a discussion of the variable names and a question-answer format demonstrating a practical application. Lastly, the brave-hearted may review the technical documentation in Appendix IV, describing the masking procedures used to determine the level of wages disclosed and the percent distributions of employment.

Release Changes

The first release of staffing patterns used the Occupational Employment Statistics (OES; 750 occupations) classification and Standard Industrial Classification (SIC; 72 two digit industries) codes. The second release used the Standard Occupational Classification (SOC; 820 occupations) in place of the OES definitions and retained the two-digit SIC. The current release retains SOC for occupations and is adapted to the new industry standard, the North American Industrial Classification System (NAICS; 100 three-digit industries). By changing occupational and industrial classification systems we have increased from 750 to 820 possible occupations and from 72 to 100 industries. These changes have created problems with data confidentiality and reliability by distributing employment throughout a more detailed matrix and led to the development of the masking methodology outlined in Appendix IV.

Data Sources

The staffing patterns are primarily a repackaging of data from several Bureau of Labor Statistics (BLS) programs. The first of these are Wyoming’s confidential level Occupational Employment Statistics (OES) program data at the six-digit SOC, three-digit NAICS statewide, as well as, the six-digit SOC by sub-state region. Secondly, the BLS national data at the six-digit SOC by three-digit NAICS and six-digit SOC by state are available at http://stats.bls.gov/oes/tables. Lastly, a typical education/experience field relating to the specific SOC was added using data produced by the BLS. These three data sources combined produced the tables of Wyoming’s Customized Staffing Patterns and Wages 2003 (available for download in Excel format).

Tables: Variables, Descriptions, and Applications

Table 1 – Wyoming’s Staffing Patterns and Wages 2003, Occupations within Industry

Table 1 is a brief excerpt from the full table in Appendix I and shows several variables for the occupations found in the designated industry. In this example, the industry selected (NAICS –

Table 1: Wyoming’s Staffing Patterns and Wages 2003, Occupations Within Industry (an excerpt form full table in Appendix I).
                 

Enter Your Estimated Employment Below

NAICS & Title 334000 – Computer and Electronic Product Manufacturing              
                     

SOC & Title

Typical Ed.

Wage Source

WY Emp

WY Hourly

WY Annual

WY Percent

US Emp

US Hourly

US Annual

US Percent

100

51-2092 – Team Assemblers Mod OJT

WYXAgg

0

$9.90

$20,580

11.82

65,880

$11.67

$24,260

5.13

12

41-4011 – Sales Represent. Mod OJT

WYXInd

25

$39.96

$76,870

6.75

15,300

$33.91

$70,540

1.19

7

42-2094 – Electronics Repairers PS

WYXAgg

0

$23.48

$48,830

6.06

7,760

$20.13

$41,870

0.60

6

51-2022 - Electronic Assemblers Short OJT

WYXAgg

0

$11.47

$23,860

5.06

138,310

$12.15

$25,280

10.76

5

51-2023 – Electromechanical Assemblers Short OJT

USXInd

0

$12.55

$26,100

4.57

20,140

$12.55

$26,100

1.57

5

11-1021 – General Managers BA/BS +

WYXInd

15

$49.48

$102,920

3.97

18,510

$61.05

$126,990

1.44

4

53-7064 - Packers Short OJT

WYXAgg

0

$6.86

$14,270

3.58

5,780

$10.17

$21,150

0.45

4

13-1023 – Purchasing Agents Rel Exp

WYXInd

12

$23.41

$48,690

3.28

19,050

$25.87

$53,800

1.48

3

17-2071 – Electrical Engineers BA/BS

WYXInd

11

$39.36

$81,870

3.08

35,340

$36.42

$75,750

2.75

3

Title) is "334000 - Computer and Electronic Product Manufacturing." The Excel version of this table features a drop down list with a selection of 88 NAICS codes – title combinations. Referring to Table 1, the most predominate occupation (SOC – Title) is "51-2092 – Team Assemblers," which represents an estimated 11.82 percent (WY Percent) of the employment followed by "41-4011 - Sales Representative" with 6.75 percent of the employment within the specific industry in Wyoming. The variables appearing in Table 1 and the remainder of the tables in this paper are described in the Variable List below.

In Table 1 we see (referring to the Variable List) that four of the top five occupations in this industry require either Moderate or Short term On-the-Job-Training (Mod OJT, Short OJT) and one of the occupations "42-2094 – Electronic Assemblers" requires a Postsecondary vocational award. Of the occupations in this industry, General Managers earn the highest wage ($49.48/hour) followed by Sales Representatives ($39.96/hour), Electronics Repairers ($23.48/hour), and Electromechanical Assemblers ($12.55/hour). We also see the three highest paying occupations in the industry have a higher average hourly wage in Wyoming than in the US (41-4011 - Sales Representatives, 42-2094 - Electronic Repairers, and 17-2071 - Electrical Engineers).

Variable List: List of Variables, Descriptions, and Source & Notes for Table 1.
Variable Description
NAICS & Title North American Industrial Classification System number and associated industry title.
SOC & Title Standard Occupational Classification Number and associated occupational title.
Typical Ed. Typical Education and Experience Level of the occupation.
Short OJT Short-term on-the-job training
  Mod OJT Moderate-term on-the-job training
  Long OJT Long-term on-the-job training
  Rel Exp Experience in a related occupation
  PS Postsecondary vocational award
  AS / AA Associate degree
  BS / BA Bachelor's degree
  BS / BA + Bachelor's plus work experience
  MA / MS Master's degree
  PhD Doctoral degree
  Prof First professional degree
  N/A N/A
Wage Source Source of Wyoming Average Hourly and Annual Wages
  SSXInd Sub-State Region by 3-Digit NAICS
  SSXAgg Sub-State Region by Across All Industries
  WYXInd Wyoming Statewide by 3-Digit NAICS
  WYXAgg Wyoming Statewide by Across All Industries
  USXInd National by 3-Digit NAICS
  USXAgg National by Across All Industries
WY Emp Wyoming estimated employment. Non-disclosable where WY Emp equals 0 and the WY Percent is greater than 0.
WY Hourly Average hourly wage at Wage Source level.
WY Annual Average annual wage at Wage Source Level.
WY Percent Estimated / Adjusted percent of employment in the occupation in the specific industry (See Appendix IV).
US Emp US estimated employment.
US Hourly Average hourly wage US.
US Annual Average annual wage US
US Percent Percent of US employment in the occupation in the specific industry
Enter Estimated Box in which users can type an estimated total employment, hit enter and the Excel file fills the column with the employment needed by occupation
State Two letter abbreviation of the state.
Sub-state Region Wyoming’s OES Sub-state regions.
  Casper Natrona County
  Central Southeast Albany, Carbon, Converse, Goshen, Niobrara, and Platte Counties
  Cheyenne Laramie County
  Northeast Campbell, Crook, Johnson, Sheridan, and Weston Counties
  Northwest Big Horn, Fremont, Hot Springs, Park, and Washakie Counties
  Southwest Lincoln, Sublette, Sweetwater, Teton, and Uinta Counties

 

Questions & Answers for Table 1 & Full Table in Appendix I: Wyoming’s Staffing Patterns and Wages 2003, Occupations Within Industry.

T1-Q1)

I am an out-of-state entrepreneur interested in starting a small (100 employees) Computer Manufacturing company in the Northeast Region of Wyoming. What are the typical types of occupations I need to staff my company? How many of each?
  T1-A1) The far right column of Table 1 represents the estimated number of jobs by occupation you would have to fill in this particular industry. The worksheet of the Excel file has a yellow box like the one appearing in Table 1 that allows you to enter your prospective number of employees. The numbers below the yellow box are automatically filled in with the number of jobs by occupation.
   

T1-Q2)

What are the estimated costs associated with staffing my Computer Manufacturing company?
  T1-A2) After reviewing the estimated number of jobs by occupations needed and refining the estimates based on your personal experiences in the industry, the associated wages "WY Hourly" is multiplied by the estimated/adjusted employment. For example, 12 Team Assemblers at $9.90/hour equals $118.80/hour plus 7 Sales Reps at $39.96/hour equals $279.72/hour plus 6 Electronic Repairers at $23.48/hour equals $140.88/hour, and so on (the total is approximately $2,600/hour).
   

T1-Q3)

What are the chances of acquiring the labor with the skills I need in the Northeast Region of Wyoming?
  T1-A3) Combining the total employment of Campbell County (available on our Internet site) with the aggregate industry "000000 Total All Industries" from Table 1 you can create a countywide staffing pattern. For example Campbell County’s average employment for third quarter of 2003 is 21,083. Placing 21,083 in the yellow box of the industry aggregate staffing pattern and finding the first occupation of our prospective company 51-2092 we see that there should be approximately 31 Team Assemblers in Campbell County. Follow the same procedure for all occupations of interest.

Table 2 – Wyoming’s Staffing Patterns and Wages 2003, Occupations by Industry

Table 2 lists all industries in Wyoming in which the selected occupation "17-2071 – Electrical Engineers" is found. Referring to Table 2, the industry with the largest number of Electrical Engineering jobs is "561000 – Administrative and Support Services" with 17.73 of Wyoming’s Employment followed closely by "541000 – Professional, Scientific, and Technical Services" with 16.08 percent. The industry with the highest average wage for Electrical Engineers is "334000 - Computer and Electronic Product Manufacturing" (same industry discussed in Table 1) at $39.36/hour followed by "541000 – Professional, Scientific, and Technical Services" at $34.65/hour.

Table 2: Wyoming’s Staffing Patterns and Wages 2003, Occupations by Industry (an excerpt form full table in Appendix II).
                 

SOC & Title

17-2071 – Electrical Engineers          
                     

NAICS & Title

Typical Ed.

Wage Source

WY Emp

WY Hourly

WY Annual

WY Percent

US Emp

US Hourly

US Annual

US Percent

561000 – Administrative and Support Services BA/BS

WYXAgg

0

$32.11

$66,790

17.73

3,120

$34.84

$72,460

2.19

541000 – Professional, Scientific, and Technical Services BA/BS

WYXInd

0

$34.65

$72,070

16.08

42,050

$35.52

$73,870

29.54

551000 – Management of Companies and Enterprises BA/BS

WYXAgg

0

$32.11

$66,790

14.18

3,610

$35.12

$73,040

2.54

211000 – Oil and Gas Extraction BA/BS

WYXInd

21

$32.67

$67,950

11.58

200

$35.82

$74,500

0.14

999000 – Federal, State, and Local Government (OES Designation) BA/BS

WYXInd

17

$30.10

$62,620

8.51

7,860

$33.28

$69,230

5.52

334000 – Computer and Electronic Product Manufacturing BA/BS

WYXInd

11

$39.36

$81,870

6.38

35,340

$36.42

$75,750

24.83

325000 – Chemical Manufacturing BA/BS

WYXAgg

0

$32.11

$66,790

5.20

1,070

$35.17

$73,160

0.75

811000 – Repair and Maintenance BA/BS

WYXAgg

0

$32.11

$66,790

4.73

850

$31.75

$66,030

0.60

324000 – Petroleum and Coal Products Manufacturing BA/BS

WYXAgg

0

$32.11

$66,790

3.78

260

$36.37

$75,650

0.18

486000 – Pipeline Transportation BA/BS

WYXAgg

0

$32.11

$66,790

3.31

280

$32.37

$67,330

0.20

 

Questions & Answers for Table 2 & Full Table in Appendix II: Wyoming’s Staffing Patterns and Wages 2003, Occupations within Industry.

T2-Q1)

As the prospective entrepreneur from the questions in T1-Q1 to Q3 relative to the jobs I need to fill from data in Table 1. What industries can I recruit Electrical Engineers from? How much will I have to pay?
  T2-A1) Using the data in Table 2 we see that there are five industries in Wyoming employing more Electrical Engineers than Computer and Electronic Product Manufacturing this creates our recruitment pool. All pay less than the entrepreneur is expecting to pay.
   

T2-Q2)

I recently graduated with a Bachelors degree in Electrical Engineering. What industries employ Electrical Engineers and how much do they pay?
  T2-A2) Table 2 lists the data necessary to start looking for a career along with the Average Wages currently paid.

Table 3 Wyoming’s Staffing Patterns and Wages 2003, Occupations by State, Wyoming Sub-state Region, Wages and Wage Rank.

Table 3 lists the average hourly and annual wages for the occupation "17-2071 Electrical Engineers" by state and Wyoming sub-state Region. The full Excel worksheet consists of a drop down menu to select the desired SOC & Title combination and lists the employment, wages, and ranks by state. For simplicity, several states in Table 3 were removed and only the US Total, Wyoming Border States, and Wyoming with sub-state Region appears in Table 3 (the complete table is attached in Appendix III). A review of Table 3 shows that Wyoming is ranked 33rd nationally with an average hourly wage of $32.11/hour. Wyoming has a higher average wage than Nebraska (Rank 40, $31.25/hour), South Dakota (Rank 50, $27.28/hour), and Montana (Rank 51,

Table 3: Wyoming’s Staffing Patterns and Wages 2003, Occupations by State, Wyoming Sub-state Region, Wages, and Wage Rank (an excerpt form full table in Appendix III).
 
SOC & Title 17-2071 – Electrical Engineers      
               

Typical Education

State

Sub-State Region

Wage Source

Location Emp

Location Hourly

Location Annual

Wage Rank

BA/BS US Total

USXAgg

146,150

$34.66

$72,090

 
  Idaho Total

IDXAgg

1,050

$34.78

$72,350

13

  Utah Total

UTXAgg

880

$34.73

$72,230

14

  Colorado Total

COXAgg

5,090

$34.01

$70,740

19

  Wyoming Total

WYXAgg

160

$32.11

$66,790

33

    Casper

SSXAgg

20

$31.31

$65,130

33

    Cheyenne

SSXAgg

21

$37.51

$78,020

33

    C-SE

WYXAgg

0

$27.80

$57,830

33

    NE

SSXAgg

13

$31.10

$64,690

33

NW

SSXAgg

21

$29.48

$61,320

33

    SW

WYXAgg

0

$35.11

$73,020

33

  Nebraska Total

NEXAgg

820

$31.25

$65,000

40

  South Dakota Total

SDXAgg

120

$27.28

$56,740

50

  Montana Total

MTXAgg

340

$25.91

$53,890

51

$25.91/hour) and a lower average wage than Colorado (Rank 19, $34.01/hour), Utah (Rank 14, $34.73/hour), and Idaho (Rank 13, $34.78/hour). The Cheyenne M.S.A. of Wyoming has a highest average wage for Electrical Engineers appearing in Table 3. Referring to Appendix III we see that the wage for Electrical Engineers in the Cheyenne ($37.51/hour) ranks between New Mexico (Rank = 4, $37.53/hour) and the District of Columbia (Rank = 5, $37.33/hour).

Questions & Answers for Table 3 & Full Table in Appendix III: Wyoming’s Staffing Patterns and Wages 2003, Occupations by State, Wyoming Sub-state Region, Wages, and Wage Rank.

T3-Q1)

As the prospective entrepreneur from the questions in T1-Q1 to Q3 relative to the jobs I need to fill from data in Table 1. What other states can I recruit Electrical Engineers from? How much will I have to pay?
  T3-A1) Using the data in Table 3 we see the number of Electrical Engineers employed in other states and the regional our recruitment pool. All pay less than the entrepreneur expects to pay based on the wages in Table 1.
   

T3-Q2)

As a recent Electrical Engineering graduate would I be better off, with respect to wages, moving to Colorado? Idaho? Montana?
  T3-A2) There are other factors to consider beside wages Cost of Living, Working Environment, Personal Preference, and Family to name a few. Considering wages only you would be paid more on average in Colorado ($34.01/hour) and Idaho ($34.78/hour) and less in Montana ($25.91/hour).


Labor Market Information | Wyoming Job Network | Send Us Mail