Based on the given information please answer the following questions:

Based on this (2 wk) period

1. What is the total payroll?

2. What is the total payroll for physicians, practitioners and supervisors?

3. How much was the total payroll for nurse assistant?

4. How much money was deducted to Kushon Diallo ?

5. How many security guards do this institution needs? Why?

6. From the total payroll what was the total deduction in Social Security?

AutoSave O N F8 5 . C GO ... Substitute Assignment Monday 20st - Saved ~ Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Comments Share Calibri (Body) v 11 AA Wrap Text General Insert v v Z AP - O. Ex Delete Paste BIUV VAv E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Add-ins Analyze Formatting as Table Styles Format v Filter Select Data |19 - X V fx G H J K M 0 Q R S T U V W Objective: Basic calculations for annualizing master staffing plan, estimate working hours and calculate deductions Be aware that: weeks/days Hours Although a 40-hour workweek is typically considered full-time, the US Department of Labor reports that the Fair Labor 1 year = 52 weeks 2080 Standards Act (FLSA), a federal law that defines the basic work laws, including minimum wage and overtime pay for US workers, 1 natural week= 7 days 56 NOTE 1: does not define full-time employment nor part-time employment. In New York, just like in other states, every employer can use 1 working week= 5 days 40 their own discretion to define what constitutes employment as full-time or part-time in their company. working day= 6 to 12 Ringo Star Special Clinic / Monday to Fridays, service hours 6:00am to 2:00am. Weekends: 7:00 am to 3:00pm Persona If an employee works more than ten hours in a single day or works a split shift, a New York Labor Law requires that the employer pay an extra lo. of Based on 40 Wage per Leave (days hour for each hour in excess of ten hours that an employee works. For example, if an employee works eleven hours, their employer must pay Job Position Code hour compentensat NOTE 2: them for twelve hours. This ten-hour spread of hours counts the breaks, including lunch breaks. Workers hrs/wk ed + 10 Continuing 3 Physicians 11070 80 $150.00 35+10 Practitioner Nurse/Supervisor 11075 $100.00 35+10 Licensed practical nurse 11085 $58.00 35+3 NOTE 3: 2023 Federal Tax Brackets Nurse Assistant 11095 168 868 $28.00 35+1 15 Technicians 11065 $52.00 35 TAX BRACKET/RATE SINGLE MARRIED HEAD OF HOUSEHOLD 16 11050 ILING JOINTL Security $22.00 17 Clericals (Secretary, Call Center, Pa 11055 $18.00 10% $0 - $11,000 $0 - $22,00 $0 - $15,700 18 12% $11,001 - $44,725 $22,001 - $89,450 $15,701 - $59,850 19 22% $44, 726- $95, 375 $89,451 - $190,750 $59,851 - $95,350 0 Based on Chapter 10 and the given information here, please estimate de values in context in the following exercise for a Biweekly Payroll Period 24% $95,376 - $182,100 $190,751 - $364,200 $95,351 - $182,100 21 Deductions Job Code Name Over time hrs Pay Base Gross + Federal Tax Social NetPay 32% $182,101 - $231,250 $364,201 - $462,500 $182,101 - $231,250 Overtime Medicare 22 Rate Security 35% $231,251 - $578,125 $462,501 - $693,750 $231,251 - $578,100 23 11075 Tabatha Gonzalez 37% $578,126+ $693,751+ $578,101+ 24 11095 MayraCedeno, THE COLLEGE INVESTOR cor.com 11065 Freddy Chila, 26 11065 Esther Cummings, 27 11075 Gar Smith * Assume that all these workers are single 28 11095 Gilbenis Gilligan Employer % Employee % 29 11095 Rosaura Metz NOTE 4: Social Security 6.2 6.2 30 11095 Coomodus Pitch FICA = 15.30% MedicAre 1.45 1.45 31 11075 Yaderlyn Robertson 7.65% 7.65% 32 11065 Blake Simment 33 11065 Carlos Carmona 34 11075 Yen-Li Chun, Based on the given information please answer the following questions: 35 11095 Kamila Dembele Based on this (2 wk) period 36 11095 Thimilu Diallo 1. What is the total payroll? 37 11095 Kushon Diallo, 38 11085 Martha Encarnacion 2. What is the total payroll for physicians, practitioners and supervisors? 39 11095 Xoan Ferreira 11095 Yalix Garcia, 3. How much was the total payroll for nurse assistant? 41 11095 iam Hines, Sheet1 + Ready Accessibility: Investigate + 91%AutoSave O N F8 5 . C GO ... Substitute Assignment Monday 20st - Saved ~ Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Comments Share Calibri (Body) v 11 AA Wrap Text v General Insert v v Z AY . O. Ex Delete Paste BIUV DVAv E E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Add-ins Analyze Formatting as Table Styles Format v Filter Select Data 120 fx D F K M N 0 P Q R S T U v W 24 11095 MayraCedeno, THE COLLEGE INVESTOR 25 11065 Freddy Chila 26 11065 Esther Cummings 27 11075 Gar Smith * Assume that all these workers are single 28 11095 Gilbenis Gilligan Employer % Employee % 29 11095 Rosaura Metz NOTE 4: Social Security 6.2 6.2 30 11095 Coomodus Pitch FICA = 15.30% MedicAre 1.4 1.45 31 11075 Yaderlyn Robertson 7.65% 7.65% 32 11065 Blake Simments 33 11065 Carlos Carmona, 34 11075 Yen-Li Chun Based on the given information please answer the following questions: 35 11095 Kamila Dembele Based on this (2 wk) period 36 11095 Thimilu Diallo, 1. What is the total payroll? 37 11095 Kushon Diallo 38 11085 Martha Encarnacion 2. What is the total payroll for physicians, practitioners and supervisors? 39 11095 Xoan Ferreira, 40 11095 Yalix Garcia, 3. How much was the total payroll for nurse assistant? 41 11095 Miriam Hine 42 11095 Rachael Isaiah, 4. How much money was deducted to Kushon Diallo ? 43 11095 Okalela Jabalera 44 11070 Kamila Kamara, 5. How many security guards do this institution needs? Why? 45 11085 Tammy Kweon 46 11085 Ulinzi Lizardo, 6. From the total payroll what was the total deduction in Social Security? 47 11085 Spot Mckenzie, 48 11070 Gloria Newsome 49 11085 Jennifer Paulino 50 11085 Emilia McSpirit 51 11085 Lorenza Perez 52 11095 Sophia Quizhpi, 53 11095 Amelia Rhone , 54 11095 Amy Rodriguez, 55 11095 Yunyum Li-Que 56 11085 Alexis Encarnacion 57 11065 Felicit Ferrus, 58 11065 Yalimar Justine 59 11095 Sussan Hiuks, 60 11070 Rachael Islam 61 11095 Omaluma Yanislatia 62 11095 Kameron Turkistish 63 11085 Kweon Que 64 11065 Lizardo Berreira 65 11095 Alejandro Mckenzie, 66 11065 Joshef Mohammed 67 Total 68 Sheet1 + Ready Accessibility: Investigate + 91%