Adam is a business manager at Dobee company and he id interested in calculating the "Net Earning as a percentage of salary" for his employees. Following is a table of employees salaries and job classification. It is also given that Health core-premium for management is $18,000 and non management is $12,500. build an Excel model to calculate the mean net earning as a a percentage of income for the company.\ \ First name Last name Job classification Salary \ Jim Clovis Management $ 94,565 \ Donna Anderson Non-Management $ 73,456 \ Jake Chen Non-Management $ 77,773 \ Ron Washington Management $ 120,234 \ Crystale Liu Management $ 110,564 \ Health Co-Premium \ Management Non-management \ Co-premium $1,800 $1,250 \ Income tax \ Salaries Tax rate \ $ 60,000 19% \ $ 70,000 22% \ $ 80,000 24% \ $ 90,000 26% \ $ 100,000 27%

Answer rating: 100% (QA)

Heres an Excel model to calculate the Net Earning as a percentage of salary for Dobee companys emplo... View the full answer