Enter a lookup function in cell E5 that returns the tax deduction amount for the number of
Fantastic news! We've Found the answer you've been seeking!
Question:
Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will
receive no additional deductions.
Transcribed Image Text:
Beta Manufacturing Emplayee Withholdings Employee ID Status Dependents Salary 90,212 Deduction Withholding Statistics 7276 FT Number of FT Employees 13 9858 PT 18,984 Average Salary Full Time $ 67,950.77 8936 FT 42,906 Additional Information Average Salary of FT>-1 Dependent 6881 FT 37,191 3852 FT 52,528 6580 PT 17,126 65,771.58 4772 FT 94,101 4296 PT 12,471 Dependents Deduction 8884 FT 67,132 50.00 9916 FT 88,604 125.00 5803 FT 55,680 250.00 8708 FT 98,869 325.00 SS6S PT 11,994 SO0.00 6142 PT 17,957 FICA Withholdings FT at least 1 Dependent B164 FT G6,693 4338 FT 84,432 5833 PT 18,994 PT or FT No Dapendents 5% 6060 FT 65,648 2559 PT 18,835 5569 PT 15,525 Employee ID Status Dependents Salary Deduction Withholdings 3488 PT 15,861 ET 7353 PT 16,173 4990 PT 9,893 4785 PT 17,081 3040 FT 39,364 B087 PT 19,306 4474 PT 9,933 4251 PT 16,707 %3B Beta Manufacturing Emplayee Withholdings Employee ID Status Dependents Salary 90,212 Deduction Withholding Statistics 7276 FT Number of FT Employees 13 9858 PT 18,984 Average Salary Full Time $ 67,950.77 8936 FT 42,906 Additional Information Average Salary of FT>-1 Dependent 6881 FT 37,191 3852 FT 52,528 6580 PT 17,126 65,771.58 4772 FT 94,101 4296 PT 12,471 Dependents Deduction 8884 FT 67,132 50.00 9916 FT 88,604 125.00 5803 FT 55,680 250.00 8708 FT 98,869 325.00 SS6S PT 11,994 SO0.00 6142 PT 17,957 FICA Withholdings FT at least 1 Dependent B164 FT G6,693 4338 FT 84,432 5833 PT 18,994 PT or FT No Dapendents 5% 6060 FT 65,648 2559 PT 18,835 5569 PT 15,525 Employee ID Status Dependents Salary Deduction Withholdings 3488 PT 15,861 ET 7353 PT 16,173 4990 PT 9,893 4785 PT 17,081 3040 FT 39,364 B087 PT 19,306 4474 PT 9,933 4251 PT 16,707 %3B
Expert Answer:
Answer rating: 100% (QA)
Answer VLOOKUPC5H14I182FALSE LOOKUP functions are used in excel to se... View the full answer
Related Book For
College Algebra Graphs and Models
ISBN: 978-0321845405
5th edition
Authors: Marvin L. Bittinger, Judith A. Beecher, David J. Ellenbogen, Judith A. Penna
Posted Date:
Students also viewed these programming questions
-
For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Open the downloaded file exploring_e02_grader_a1.xlsx . 0 2 Insert a lookup...
-
The following table display data from four experiments: a. Cell volume after 10 minutes in a watery bath b. Fish mass after 1 week in a chilly tank c. Gnat population size after 3 days without food...
-
The following table display data from four experiments: a. Cell volume after 10 minutes in a watery bath b. Fish mass after 1 week in a chilly tank c. Gnat population size after 3 days without food...
-
Write a short report in which you assess the impact of one piece of health and safety legislation in an organisation of your choice.
-
a. Financial statements should aid the user of the statements in making decisions. In your opinion, would the user of the statements be aided if there were a distinction between financial reporting...
-
Define the followings: 1. Multiple use 2. Hydrologic cycle 3. Geologic erosion 4. Waterspreading 5. Coordinated resource management planning
-
From 2008 to 2015, auto loan rates in the United States declined from around 8% to near historic lows of around 4%. At the same time, auto sales increased dramatically. How, if at all, does this...
-
Trevor Price bought 10-year bonds issued by Harvest Foods five years ago for $936.05. The bonds make semiannual coupon payments at a rate of 8.4 percent. If the current price of the bonds is...
-
A broadcasting antenna emits a power of 40 W. The gain of the antenna is 300L. The receiving antenna is at a distance of 50 km from the transmitting antenna, and its effective surface area is 10-2 m....
-
XYZ Company is considering a new project with a cost of $25,000 and a life of 5 years. The projects yearly pretax operating cash revenues and expenses are $20,000 and $9,000, respectively. The...
-
Assume Vans and Converse play the following simultaneous-move advertising game. Both companies have to decide whether or not they want to advertise on Instagram. If neither company advertises on...
-
The law of increasing costs is explained by each of the following except __________. a) the law of diminishing returns b) diseconomies of scale c) factor suitability d) overspecialization
-
Which of the following would be the most accurate description of our economy since the end of 2007? a) We have had virtually no economic problems. b) We experienced the worst economic mess since the...
-
As we produce increasing amounts of a particular good, the resources used in its production ________. a) become more suitable b) become less suitable c) continue to have the same suitability
-
Which statement is true? a) Although our economy was not performing well, college graduates from the class of 2012 received more job offers than any other graduating class in history. b) The economic...
-
Each of the following was a major contributing factor to suburbanization except ______. a) low-interest federal loans b) a federal highway building program c) the pent-up demand for housing d) the...
-
Explore the various tax planning strategies that corporations employ to legally minimize their tax liability. Using this information and from the viewpoint of a tax professional, write an initial...
-
Why do markets typically lead to an efficient outcome for buyers and sellers?
-
The graph of f (x) = x3 - x2 - 2 is which of the following? D. 5-4-3-2-1
-
Find an equation of a hyperbola with vertices (3, 7) and (-3, 7) and e = 5/3. The eccentricity of a hyperbola is defined as e = c > a. For a hyperbola, c > a > 0, so e > 1 when e is close to 1, a...
-
Express as a sum or a difference of logarithms. a. loga (x - y) / (x2 - y2) b. loga (9 - x2)
-
If the carrying value of a fixed asset is USD 2,500, and its value in use is USD 2,200, which of the following is false? (Note: value-inuse is greater than its fair value less cost to sell) a. USD...
-
Which component is not present on the balance sheet? a. Net realisable value b. Allowance for credit losses c. Cumulative impairment d. Provision accounts
-
GRE Tire Corporation tests its machine for impairment at the end of the financial year 2023. The carrying value of the machine is USD 3,000. The firm estimates its value in use to be USD 2,800 and...
Study smarter with the SolutionInn App