Help with this Accounting problem!

Horre ww Page Layout Formas Data Review View Analyse Solver Data Mining Table Tell me Share Comments Geral - Trebuch AA # 1.A D of S.99 M Cars Dernet H11 A 11 F 0 H 1 K M N O 2 2 4 5 Client 0 E Murray Medical Medical Monitoring Devices Criteria Range Account Rep Area Device Total Sales Client Name Eval Score Tier Rep Bonus Bonus Tiers Score Tier 0 Bronze 6 Silver Key Findings Statistic Result Average Destras Total Dests sales: 2 Gold Destra repe Platinum Account Representatives 10 Clients Client Name Account Rep Are Ok To Sales Ever The Rap Bonus 11 2355 Hopital Hiro NE Critscope 220.500 A 12 2198 Cox Family Care Gonzales SE Ann POS 158.700 13 2011 Castro Pediatric Gonzales SC Vivo 140.500 7.0 14 2855. Parkview Medical Huko NE Vivo B15 127,500 80 15 2225 Gulf Medical Center Siva SE Criscope 120,750 3.0 16 2326.9. John's Hospital Hayati MW 02 Monitors 120,100 6.57 17 306 Donovan Medical Center Ke MW Vivo $ 107,500 9.5 10 2140 Brevard Healthcare Flowers SE DataSigns 105,500 6.5 19 2701 Associated Healthcare Malick MW 02. Monitors 9.750 5.5 20 2012 Advanced Medical Center Silva SE Destra 5 88,770 80 20 2310 L Mont Medical Clinic Soko NY VIVO 5 66,000 5.0 22 2014 Midwest Clinic Malick MW Destra 15 64,500 7.01 23 2244 Bailey Heathcare Flowers SE Destra $ 58,700 5.0 24 2287 Agora Hospital Kruse NW Vivo Il 15 57.500 9.00 2203 First Choice Medical Wine sw 02 Monitors 56.300 60 26 3115 Dermatology Associates wikin SW Anes.Pro $ 52,500 701 2141 Capital Clinic Hayati MW Destra 9 47.750 7.0 2219 Mercy West Soto NW Vivo $ 10,650 45 29 2077 Northwest Hospital Kruse NW S 26,500 8.5 30 Vivo 1. Each account rep is assigned to a tier, which determines whether they receive a salary bonus. Bao wants to list the tier for each account rep according to the Bonus Tiers data in the range K5:L9. In cell Hii, enter a formula using the VLOOKUP function. Use a structured reference to the Eval Score (cell G11) as the lookup value. Use absolute cell references to the Bonus Tiers data (range K6:L9) as the table_array. Use the Tier column (column 2) as the col_index_num. Do not enter a value for the optional range_lookup argument. If Excel does not copy the formula automatically, fill the range H12:H29 with the formula in cell H11. Homework: Chapter 11 Homework L011.2 Question 1. SF11-7 (simil... Part 1013 HW Score: 0.0 of 100 points Score of 30 Save Brooke Beley works for all year andar a month of 512,800. There is no overtime pay Brooke's income tax welding til 24% of grow peyin on top oke only to wad Ww Who deducta $175 month for comment of the heathrun premium As of September 30, Brock had 5t28.000 of cumulative arnings (click the icon to www payroll text formation) Reed the more Requirement 1. Compute throcker's net sayter October (Round mount to the art cont) Cross Day 12.00 Withholding deduction Employee income to Employee Medicare Emoloyee health Employer conto tond Way Total Wilholdings Netthome) pay mework L011.2 Question 1, SF11-7 (simil... Part 1 of 3 HW Score: 0%, 0 of 100 points Score: 0 of 30 a monthly salary of $12,800. There is no overtime pay, Brooke's income tax withholding rate is 24% of gross pay. In addition to payroll taxes, B of the health insurance premium. As of September 30, Brooke had $128,000 of cumulative amings ation) - More Info clober. (Round illam For all payroll calculations, use the following tax rates and round amounts to the Dearest cent Employee OASDE 6.2% on first $132.900 earned: Medicare: 1.45% up to $200,000, 235% on emings above $200,000 Employer: OASDI: 62% on first $132.900 earned; Medicare: 1.45% FUTA: 0.6% on fest $7,000 camed: SUTA: 5.4% on first $7,000 eamed Print Done input fields and then click Check Answer Get More Help - MacBook Air