Answered step by step
Verified Expert Solution
Link Copied!

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 :

image text in transcribed Here is the final how it looks just need you to give me the formula please how they work? image text in transcribed

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

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

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

More Books

Students also viewed these Databases questions

Question

=+what kinds of policies and practices should be developed?

Answered: 1 week ago

Question

=+ Of the HR issues mentioned in the case,

Answered: 1 week ago