IMPLAN to FTE & Income Conversions

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 Employment/FTE and W&S/Employee Compensation Conversion This spreadsheet 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 Industries - this is due to the fact that IMPLAN has more Industry 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 is for when you have Employee Compensation that you want converted to Wage & Salary data or you have a full-time equivalent (FTE) number to convert to Employment. Simply find the IMPLAN Industry in Column A and enter your Wage & Salary number in Column D or your full-time equivalent number in Column F. Results will automatically populate in Column E (Employee Compensation) or Column G (Employment), respectively.

If I am told the company in Industry 4 - Fruit Farming has an FTE of 25. Before entering that figure in IMPLAN, it must be converted to an Employment value. In cell F5 (corresponding to Industry 4), enter 25 as the FTE. This yields an Employment value of 29.15 by taking the 25 / 0.857493857. The value 29.15 can be analyzed in IMPLAN.

The second tab in the spreadsheet performs the opposite of the first. This is for when you want to convert Employee Compensation data into Wage & Salary or Employment value into FTE. Find the IMPLAN Industry in Column A and enter your Employee Compensation number in Column D or your Employment number in Column F. Results will automatically populate in Column E (Wage & Salary) or Column G (FTE), respectively.

DOWNLOADS

Written November 30, 2023