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