## IMPLAN JOBS TO FTES & INCOME TO EC:

IMPLAN jobs include all full-time, part time, and temporary positions (with the exception of the 1985 database). When Employment is counted this way, one cannot tell from the data the number of hours worked or the proportion that is full or part-time. You may want to convert IMPLAN's Employment estimates into full-time equivalents (FTE) for reporting purposes, or, conversely, you may need to convert your FTE figures into Employment before inputting into IMPLAN for analysis. You can do both fairly easily using the Excel sheet named "Convert IMPLAN 546 Employment to FTE and Income to EC 2018." For 2017 (536 Sector) data, visit "Convert IMPLAN 536 Employment to FTE and Income to EC 2017*."* These spreadsheets will also allow you to estimate wage and salary Income from Employee Compensation (EC) or vice versa.

An FTE is assumed to work 2,080 hours in a standard year. The ratios in this spreadsheet are based on national averages from the BEA. You may notice that some of the ratios are the same across similar IMPLAN sectors - this is due to the fact that IMPLAN has more sector detail than the BEA data used to calculate the ratios. If you want to work with more localized values than those provided in this spreadsheet, contact your local employment security office to determine if they have their own statewide estimates. Local data should be reported by the number of hours worked in each NAICS code. Match the NAICS codes to the related IMPLAN Code, and divide the number of hours worked by the standard year - 2080 hours. This is your local vector of FTE conversions and can be used as described below.

## CONVERSION:

The first tab in the spreadsheet contains the FTE-to-Employment ratios. The first column lists the IMPLAN Sector codes. The second column contains the ratios, which represent FTE divided by Employment. You will notice that these ratios are all less than one - this is because Employment contains part-time jobs (so there are more jobs than there are FTEs). To calculate IMPLAN Employment from your FTE data, you need to *divide *your FTE estimates by the ratio. To calculate FTE from IMPLAN Employment data, you need to *multiply* the Employment estimates by the ratio. For example, if the results of your IMPLAN analysis indicate that 20 jobs will be created in Sector 19, but you'd like to know how many FTEs that represents, you would scroll down to the row for Sector 19. In this example, the ratio for Sector 19 happens to be 0.8630, so FTE = (20)*(0.8630) = 17.3.

The second tab in the spreadsheet contains the EC-to-Income ratios, which represent EC divided by Income. You will notice that these ratios are all greater than one - this is because EC includes Income *plus *benefits and employer-paid payroll taxes. To estimate EC from Income, you need to *multiply* your income figures by the ratios.

The third tab in the spreadsheet lists the BEA tables used to calculate the ratios.

## DOWNLOADS:

## 2018 FTE & Employee Compensation Conversion TableConvert IMPLAN jobs to full-time equivalents (FTEs) or vice versa using this downloadable spreadsheet using the 546 Sectoring Scheme. |
Download |

## 2017 FTE & Employee Compensation Conversion TableConvert IMPLAN jobs to full-time equivalents (FTEs) or vice versa using this downloadable spreadsheet using the 536 Sectoring Scheme. |
Download |

Updated December 12, 2019

## Comments

0 comments

Article is closed for comments.