Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please if you are not sure about the answers please, let someone who knows solve the problem. FE Bot HCM so with a Tax Rate

please if you are not sure about the answers please, let someone who knows solve the problem. image text in transcribed
FE Bot HCM so with a Tax Rate of 95% or 0.95, in cell 12 create a formula to calculate "Deduction that you can copy down the tate de sure to follow Excel's Golden Rule because the tax rate may change te a formula to cautate Total Monthly Pay that you can con down the column Total Monthly Pay is equal to Employee Base Salary Bonus Commissions With T Rated in cell 12 create a fomutato calculate 'Deduction that you can copy down the column. Deduction' is equal to "Total Monthly Pay the Tax Rate In cell 12 create a formulate calculate "Net Pay that you can copy down the column. 'NetPay is equal to "Total Monthly Pay - "Deduction 5 Add totals to the bontom of the columns Bonus Commission Total Monthly Pay, Deduction Net Pay Commission Lookup Table Deduct on Het Pay Su es Love Bonus Com son US 0.050 550 000 050 SS $75,000 1.657 $100,000 1.50$ $175.000 2.7525 5215.000 3.75% $250.000 4 15 . Meithly Payroll Table 10 Emploise Esse Bonus Bonus Tota Monthly 11 Emo Die SU Commission Commissions Pay 12 lasie Harrios S3650 $169, 175.00 Nuyer Shirley $1,200 $116 05.15 14 Maud Kaplan 52,200 $89,72315 15 Nichol Parson $1,100 $175,426 21 16 Hank Bolin $1.700 $112,335 99 27 Martin Brandon $2150 $213,251,24 Elenor Dockery $2,050 $124 261.89 Cherilyn Simone $3100 5168332S Tod Paquette $2,050 $123,311.91 Twana Kasper 53.100 $119,756.00 Isaiah Beebe $1,400 $119,792 80 Lessie Vance 52.900 S232,502 16 Trisha Mccartney $2,050 $164,994.05 Marlyn Jeffries 53,200 $216,786.94 Jonelle Whitley $2,600 $95,238.17 Lauryn Valencia $2,450 $79,798.52 Mandie Gunter $3,300 $179,555.75 Totals $43,100 $2,499.153.82 P(1) P(2) i O Toe here to search d

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

3rd Edition

0760049041, 978-0760049044

More Books

Students also viewed these Databases questions