| Wage Conversion Chart | |||||||||
| This is a guide to convert various wage and earnings inputs to a quarterly wage as required in PIRL data elements 1703, 1704, 1705, and 1706. | |||||||||
| Collect the hourly/weekly/bi-weekly/monthly/annual wages from the participant and enter that value in the appropriate cell. The example input values in red must be replaced with the appropriate information collected from the participant to calculate the reportable quarterly wage. | |||||||||
| Convert Hourly Rate to Quarterly Wages | |||||||||
| Hourly Rate ($xxx.xx/hour) |
hours worked per week on average (xx.x) |
13 weeks per quarter | Quarterly Wages | ||||||
| $7.25 | X | 32.0 | X | 13 | = | $3,016.00 | |||
| Convert Weekly Wages to Quarterly Wages | |||||||||
| Weekly Wages ($xxxxx.xx) |
13 weeks per quarter | Quarterly Wages | |||||||
| $290.00 | X | 13 | = | $3,770.00 | |||||
| Convert Biweekly Wages to Quarterly Wages | |||||||||
| Biweekly Wages ($xxxxx.xx) |
6.5 biweekly pay periods per quarter | Quarterly Wages | |||||||
| $580.00 | X | 6.5 | = | $3,770.00 | |||||
| Convert Monthly Wages to Quarterly Wages | |||||||||
| Monthly Wages ($xxxxx.xx) |
3 months per quarter | Quarterly Wages | |||||||
| $1,256.67 | X | 3 | = | $3,770.01 | |||||
| Convert Annual Wages to Quarterly Wages | |||||||||
| Annual Wages ($xxxxxx.xx) |
4 quarters per year | Quarterly Wages | |||||||
| $15,080.00 | / | 4 | = | $3,770.00 | |||||
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |