Excel
sarana
KirkanSalman_EmirRana-ExcelAssgnment.xlsxSheet1
| Jave Jive Weekly Payroll Register | |||||||||
| Employee Data | Earnings | Taxable Benefits | |||||||
| Employee Name | Benefits Level | Regular Hours | O/T Hours | Pay Rate | Gross Pay | Dental | Insurance | Medical | Taxable Income |
| Salman Rana | 2 | 35 | 20.1 | 703.5 | |||||
| Emir Kirkan | 1 | 30 | 5 | 23.75 | 890.625 | ||||
| Sandy Lee | 2 | 40 | 5 | 25.5 | 1211.25 | ||||
| Naseem Pendalt | 1 | 26 | 22.25 | 578.5 | |||||
| Lee Simpson | 2 | 5 | 23.1 | 115.5 | |||||
| Deductions | Net Pay | ||||||||
| Employee Name | Federal Tax | Provincial Tax | Employ. Insurance | Govt. Pension | Total Deductions | Net Amount | Cheque No. | ||
| Salman Rana | |||||||||
| Emir Kirkan | |||||||||
| Sandy Lee | |||||||||
| Naseem Pendalt | |||||||||
| Lee Simpson | |||||||||
| Total | |||||||||
Sheet2
| Assumptions | ||
| Overtime | 1.5 | |
| Employ. Insurance | 5% | |
| Govt. Pension | 3% | |
| Taxable Benefits ($ per week) | ||
| Benefits Level 1 | Benefits Level 2 | |
| Dental | 3.00 | 5.00 |
| Insurance | 5.00 | 11.00 |
| Medical | 8.00 | 18.00 |
| Tax Table | ||
| Earnings | Federal Tax % | Provincial Tax% |
| 0 | 0 | 0 |
| 200.00 | 0 | 0 |
| 500.00 | 5 | 4 |
| 800.00 | 7 | 6 |
| 1,100.00 | 9 | 8 |
| 1,300.00 | 11 | 10 |
| 1,500.00 | 13 | 12 |
| 1,700.00 | 16 | 14 |
| 1,900.00 | 20 | 16 |
| 2,100.00 | 24 | 18 |
