Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I really dont know how to use excel very well so could somebody solve this on EXCEL for me and maybe give it to me

image text in transcribed

I really dont know how to use excel very well

so could somebody solve this on EXCEL for me and maybe give it to me through excel file THANKYOU

hopefully u can put all the functions in excel and give me the copy :(

Name Salary |Tax Rate(%) Tax Amount Tax Table Salary Tax J. Smithl 54,000 J. Smith2 65,000 J. Smith3 37,000 J. Smith444,000 J. Smith5 62,000 J. Smith642,000 J. Smith7 31,000 J. Smith8 88,000 J. Smith9 91,000 J. Smith10 52,000 Rate (%) 8 9 10 30,000 40,000 50,000 60,000 70,000 80,000 90,000 100,000 12 13 14 TOTAL TAX AMOUNT 1. USE the vlookup function to find the appropriate Tax-Rate (in the Tax Table) for each employee 2. Calculate the individual Tax-Amount 3. Get the TOTAL TAX AMOUNT of all Tax-Amounts 4. Use Solver to increase the TOTAL TAX AMOUNT = 70,000, and use the appropriate STEP-1

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

Auditing Principle And Practice

Authors: Satyabrata Tripathy

1st Edition

9332519382, 9789332519381

More Books

Students also viewed these Accounting questions

Question

How did you feel about taking piano lessons as a child? (general)

Answered: 1 week ago