Loading
Status: Live
Excel budget work
Date Posted: 22/11/2020
Category: Finance
Due Date: 22/11/2020
Willing to Pay: $15.00
Instruction
You are the manager of an EMS Agency. Your Board has come to you, stating they want to know how many FTEs you need to have next fiscal year. You are assuming a 40 hour workweek. You board would like to see a detailed breakdown. You need to staff the following: 3 Ambulances – 24 Hours a Day, 7 Days a Week 2 Ambulances – 10AM – 6PM on Monday, Tuesday, Wednesday, Thursday, and Friday 2 Ambulances – 3PM -3AM on Thursday, Friday, and Saturday Only. 1 Supervisor – 24 hours a day, 7 days a week. In addition to the above, your board wants see a breakdown of: Total salary costs Total benefit costs Total employer taxes, and Total Employer Cost for employees In order to assist with that, your Finance Director has given you the following information: EMT Salary: 14.75 per hour Paramedic Salary: 19.35 per hour Assume that every ambulance has an EMT and a Medic on it, and that your supervisor is also a Medic. Medical Benefits Any full-time staff (Either .9 or that you have will have medical benefits. The premium for the Medical Benefits is $625.00 per month. The split is 75% Employer Funded, and 25% Employee funded. Taxes: As the employer, you must pay taxes on the employee income. The taxes that you will need to calculate will be salary cost plus the employer cost of benefits. Your Finance manager has determined that all of your taxes equal 8% percent. Don't forget to show your work! (In other words, let Excel do the calculations for you.) If you do them on a calculator offline, you will not learn how to use this tool.
Attached
No File uploaded yet.
Tutor Uploads
No File uploaded yet.
Bidders
7
Average bid
$60.71
Rated 9.48 earned 51926.18 around 1728 assignments.
$75.00
Rated 9.57 earned 949.52 around 38 assignments.
$50.00
Rated 9.41 earned 20711.68 around 537 assignments.
$70.00
Rated 8.71 earned 18568.78 around 536 assignments.
$45.00
Rated 9.4 earned 6818.07 around 194 assignments.
$80.00
Rated 9.17 earned 79912.85 around 2688 assignments.
$45.00
Rated 9.31 earned 48013.43 around 1284 assignments.
$60.00