Question
Use the appropriate LOOKUP function to calculate the charitable contributions for each employee. Note that the percentages in the range below represent the percent of
Use the appropriate LOOKUP function to calculate the charitable contributions for each employee. Note that the percentages in the range below represent the percent of total earnings contributed to the respective voluntary withholdings. creating a formula to calculate each employees net pay, and totaling columns where appropriate. SS Wage Base $118,500
| Earnings | |||||||
| Employee Name | Regular Hours | Regular Rate | Regular Earnings | Overtime Hours | Overtime Rate | Overtime Earnings | Total Earnings |
| Brenner, J. | 40 | $ 8.40 | $ 336.00 | 4 | $ 12.60 | ||
| Moynihan, W. | 40 | $ 8.40 | $ 336.00 | 1 | $ 12.60 | ||
| James, V. | 40 | $ 8.40 | $ 336.00 | 6 | $ 12.60 | ||
| Smith, T. | 40 | $ 8.40 | $ 336.00 | 2 | $ 12.60 | ||
| King, D. | 40 | $ 8.40 | $ 336.00 | 0 | $ 12.60 | ||
| Totals: | $ 1,680.00 | ||||||
| Total Earnings | Hosp. Don. | Sch. Don. |
| $ 250 | 0.4% | 1.0% |
| $ 300 | 0.8% | 1.2% |
| $ 350 | 1.2% | 1.4% |
| $ 400 | 1.6% | 1.6% |
| $ 450 | 2.0% | 1.8% |
| Name | Prior Earnings |
| Brenner, J. | $ 42,600 |
| Moynihan, W. | $ 93,200 |
| James, V. | $ 118,320 |
| Smith, T. | $ 131,600 |
| King, D. | $ 62,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Uniform Administrative Requirements Cost Principles And Audit Requirements For Federal Awards A Handbook For Institutions Of Higher Education And State And Local Governments
Authors: Andrew Shepard-Smith
1st Edition
1505298482, 978-1505298482
