Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are a group of three (3) founding partners of a healthcare startup that will provide consulting services for chronic care identification and management services.

You are a group of three (3) founding partners of a healthcare startup that will provide consulting services for chronic care identification and management services. The company just received it’s first client contract, which will begin in six weeks, with an initial agreement for services to implement and analyze ACO performance. You need to immediately hire these. YOUR TASK IS TO CALCULATE THE FIRST YEAR OF SALARIES AND TOTAL BENEFITS EXPENSES (Including taxes) FOR YOUR COMPANY (THE EMPLOYER).

HINT: We reviewed benefits and taxes in your recorded lecture, a summary chart from that lecture is included at the bottom of this document. Use the chart at the bottom of the document to determine which benefits and taxes are provided by employers and to determine which benefits are pre- and post- tax.

Given Data

Annual Salaries: Partners $120,000, Data analysts $85,000, Nurse managers $75,000 and Patient coordinators$42,000


FTEs: 3 partners, 2 data analysts, 2 nurse managers and 6 community based and telehealth patient coordinators


Benefits: You have obtained the following quotes from the employee insurance broker that you have hired (Note: some are monthly and some are annual- pay attention to these terms.)

  • Health and dental monthly premiums- offering 1 HDHP plan: $400/month single, $800/month family

Assumption: 100% of partners and 50% of the other type of employee elects family coverage, remainder elects single coverage

  • Health savings account (HSA): employer monthly contribution $40 per employee
  • Retirement 401K- annual contribution 5% of annual salary
  • Long Term Disability (LTD) - $30 monthly premium per employee
  • Short Term Disability (STD)- $10 monthly premium per employee


Taxes: Use the percentages from the chart at the bottom of the document. The state in which your company is located has a SUTA/SUI of 1% of annual taxable salary with no cap.

  1. Calculate the first year of salaries and total benefits expenses (including taxes) for your company (the employer) by completing the excel table on the next page. HINT- You should not need to add any rows, if you need to, you are doing something incorrectly. F2 x ✓ fx AB CD GH E E FPatient Total All Coordinato Employees rNurse Partners Data analyst manager 12 ANNUAL SALARY 3 

F2 1 2 ANNUAL SALARY 3 FTES 4 5 N A 5 PRE-TAX BENEFITS 7 Total salary 8 9 10 Total Pre-tax benefit 3 Taxable salary amount 11 (Salary-Pretax Ben.) 12 TAXES 13 14 15 16 17 Total Taxes 18 POST-TAX BENEFITS 19 20 21 Total Post-Tax Benefits TOTAL BENEFITS EXPENSE 22 (Pre+Taxes+Post) Partners Total benefits expense as a % of total annual 23 salary: 24 esc B Sheet1 fx + C Data analyst D Nurse manager F2 E Patient Coordinato. r 20 # F3 F Total All Employees OCT 1 23 300 $ FA G H % I ^

Step by Step Solution

3.33 Rating (126 Votes )

There are 3 Steps involved in it

Step: 1

Based on the given data the first year of salaries and total benefits expenses including taxes for t... blur-text-image

Get Instant Access with AI-Powered 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

Introduction To Business Statistics

Authors: Ronald M. Weiers

7th Edition

978-0538452175, 538452196, 053845217X, 2900538452198, 978-1111524081

More Books

Students also viewed these Accounting questions