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