Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you help me to fill that annual salary, Annual Health Ins Cost, Annual Workers Comp Cost, Annual Unemp Ins Cos, Total Emp Cost please
Can you help me to fill that annual salary, Annual Health Ins Cost, Annual Workers Comp Cost, Annual Unemp Ins Cos, Total Emp Cost please I will attend the answer just need to the formula :
Here is the final how it looks just need you to give me the formula please how they work?
B D F G H E Whovian Industries Admin. Employees Years of Service Hourly Rate Annual Salary Annual Health Ins Cost Annual Workers Comp Cost Annual Unemp Ins Cost Total Emp Cost 33.3 38 35 35 32 7.5 20 23 19 20 Amy Pond Martha Jones Rose Tyer Adam Mitchell Mickey Smith Donna Noble Rory Williams 1 River Song 2 Craig Owens 3 Clara Oswald 18 18 5 10 5 13 8 12 30 25 4 Sarah Jane Smith 10 22 5 Harry Sullivan 27 25 3 7 Totals 242.3 248.5 Insurance Rates % 0.29 Health 1 Workers Comp - Unemployment 0.08 0.11 1 2 Whovian Industries Admin. Employees Years of Hourly Service Rate Annual Health Annual Workers Annual Unemp Total Emp. Annual Salary Ins Cost Comp Cost Ins Cost Cost 3 4 38 Student_Lastname Employee Costs 33.3 35 32 20 16% 35 7.5 23 20 18 10 1096 14% 19 18 Amy Pond Martha Jones Rose Tyer Adam Mitchell Mickey Smith Donna Noble Rory Williams River Song Craig Owens Clara Oswald Sarah Jane Smith Harry Sullivan $ 79,306.00 $ 22,998.74 $ $ 73,045.00 $ 21,183.05 $ $ 15,652.50 $ 4,539.23 $ $ 48,001.00 $ 13,920.29 $ $ 41,740.00 $ 12,104.60 $ $ 37,566.00 $ 10,894.14 $ $ 20,870.00 $ 6,052.30 $ $ 27,131.00 $ 7,867.99 S $ 25,044.00 $ 7,262.76 $ $ 52,175.00 $ 15,130.75 $ $ 45,914.00 $ 13,315.06 $ $ 52,175.00 $ 15,130.75 $ 6,344.48 $ 5,843.60 $ 1,252.20 $ 3,840.08 $ 3,339.20$ 3,005.28 $ 1,669.60 $ 2,170.48 $ 2,003.52 $ 4,174.00 $ 3,673.12 $ 4,174.00 $ 5 6 7 8 9 10 11 12 13 14 15 16 17 8,723.66 $ 117,372.88 8,034.95 $ 108,106.60 1,721.78 $ 23,165.70 5,280.11 $ 71,041.48 4,591.40 $ 61,775.20 4,132.26 $ 55,597.68 2,295.70 $ 30,887.60 2,984.41 $ 40,153.88 2,754.84 $ 37,065.12 5,739.25 $ 77,219.00 5,050.54 $ 67,952.72 5,739.25 $ 77,219.00 996 796 89 5 5 8 5% 3% 5% 4% 30 10 27 13 12 25 22 25 Martha Jones - Rose Tyer Adam Mitchell - Amy Pond - Mickey Smith - Donna Noble - Rory Williams River Song Totals 242.3 248.5 $518,619.50 $ 150,399.66 $ 41,489.56 $ 57,048.15 $767,556.86 Craig Owens Clara Oswald Sarah Jane Smith. Harry Sullivan 18 19 20 21 22 Insurance Rates Health Workers Comp Unemployment % 0.29 0.08 0.11
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started