Fox Lake Country Club - Employee Salary Template
Weekly Sales Social Security Rate Federal Tax Rate
$25,000 8.2% 29%
Employee Hours Hourly Commission Gross Pay Federal Tax Worked Wage 35 15.00 6% $2,025.00 587.25 40 12.00 8% $2,480.00 719.20 35 10.00 5% $1,600.00 464.00 33 13.00 1% $679.00 196.91 32 10.00 0% $320.00 92.80 23 11.00 3% $1,003.00 290.87 30 10.00 10% $2,800.00 812.00 34 12.00 0% $408.00 118.32 33 12.00 5% $1,646.00 477.34 28 11.00 0% $308.00 89.32 42 13.00 6% $2,046.00 593.34 36 12.00 3% $1,182.00 342.78 50 10.00 3% $1,250.00 362.50 451 17,747.00 $5,147.00
Soc Sec Tax
Net Pay 166.05 $1,271.70 203.36 $1,557.44 131.20 $1,004.80 55.68 426.41 26.24 200.96 82.25 629.88 229.60 1,758.40 33.46 256.22 134.97 1,033.69 25.26 193.42 167.77 1,284.89 96.92 742.30 102.50 $785.00 1,455.25 $11,145.12
Rick Linda Stan Elaine Burton Don Tridas Paul Laurie Ray Sunder Baohong Michael Payroll Totals
Instructions:
Insert a function to calculate Gross Pay (In other words, if an employee receives a commission, then his/her Gross Pay will equal (Hours Worked * Hourly Wage+(Commission %*Weekly Sales.<Weekly Sales is in cell B3> Insert a formula to calculate the amount of Federal Tax (Note: Federal and Soc Sec Tax are a percentage of the gross pay). Insert a formula to calculate the amount of Soc Sec Tax (Note: Federal and Soc Sec Tax are a percentage of the gross pay). Insert a formula to calculate each employee's Net Pay (the difference between gross pay and the total tax). Insert a formula to calculate the company totals for Hours Worked, Gross Pay, and Net Pay
Questions:
Which employee received the largest paycheck (Net Pay)?
What is the total number of hours worked for all employees?
What is the minimum Net Pay? What is the average Net Pay?
How much did Fox Lake pay in payroll (use the Gross Pay column)?
If Weekly Sales drop to $8,000, which employee will receive the largest paycheck? (Type the value and change weekly sales back to 25k after you answer)
What would the total Net Pay equal if Weekly Sales was $40,000? (Type the value and change weekly sales back to 25k after you answer)
Tridas $451.00 $193.42 857.32 17,747.00
$40 41
Directions
Book Order
PivotTable
Charity Donations
Employee Payroll
Pricing Info
Golf Distribution