directions are listed within assignment
computer science
Description
calculate totals using correct formulas in excel. directions are listed within assignment.
| Employee | Rate | Hours | Dep. | YTD Soc. Sec. | Gross Pay | Soc. Sec. | Medicare | Fed. Tax | State Tax | Net Pay |
| Edward | 32.25 | 49.50 | 6 | $4,974.00 | $0.00 | $0.00 | ||||
| Cathy | 12.00 | 28.00 | 10 | $5,540.20 | $0.00 | $0.00 | ||||
| Duane | 22.40 | 70.00 | 4 | $4,254.00 | $0.00 | $0.00 | ||||
| Albert | 29.75 | 18.00 | 5 | $5,553.90 | $0.00 | $0.00 | ||||
| Lisa | 16.25 | 42.00 | 2 | $4,825.50 | $0.00 | $0.00 | ||||
| Robert | 22.15 | 48.00 | 6 | $4,825.50 | $0.00 | $0.00 | ||||
| Doris | 29.15 | 36.25 | 4 | $5,553.90 | $0.00 | $0.00 | ||||
| Totals | 291.75 | 35,527.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||
| SS Tax | 6.20% | |||||||||
| Medicare Tax | 1.45% | |||||||||
| Max SS | $5,553.90 | |||||||||
| METRICS | ||||||||||
| Gross Pay: Less Than or Equal to 40 hours = Hours multiplied by rate; More than 40 hours = Hours multiplied by rate + 1/2 rate for hours over 40 | ||||||||||
| Social Security: If SS Tax multiplied by Gross Pay + Gross Pay is > Max SS = Max SS - YTD; If not, SS Tax multiplied by Gross Pay | ||||||||||
| Medicare: Gross Pay multiplied by Medicare Tax | ||||||||||
| Net Pay: Gross Pay minus Social Security and all taxes | ||||||||||
