Reference no: EM132674583
Task:
Start with your Excel workbook from Unit #5 and create a new tab titled Personnel Expenses. Use this tab to show your detailed calculations. This unit, you will calculate FTEs, salary and benefit expenses using a base year of 2019. Remember that during 2019, these surgeries will still be performed in the hospital , but this data is needed to provide a baseline (prior year data) to project expenses for when the ASC opens in 2020. Use your readings and asynchronous video lectures as resources.
Required FTEs: Use the data given below to calculate the following for 2019: (HINT: Next week you will be calculating years 2020-2022. Build your calculations so that they use links and can easily be copied for future years).
o the number of Pre-op hours per year needed for each specialty and in total
o the number of Operating Room (OR) hours per year needed for each specialty and in total.
o the number of Post-op hours per year needed for each specialty and in total.
• Hint: You already calculated the number of surgeries for 2019 on your Gross Revenues tab- be sure your results here match those results.
o the number of pre-op beds needed, based on total hours needed (calculated above) divided by total hours available (use available times listed above under "ASC Room Usage"). None of these beds/rooms are specialty -specific, so you do not need to calculate them for each specialty, you can calculate the beds needed using the total for all three specialties. Round your calculated number of beds needed up to the next 0.5 to allow for some flexibility in the schedule for complications, late starts, etc. (ex. 5.3 ORs rounds to 5.5, 5.7 rounds to 6- use the function wizard and the CEILING function to do this)
o repeat this calculation for OR beds
o repeat the calculation for post-op beds
o the number of FTEs needed for each type of position, based on your above calculations and the staffing model shown below. Include 10% NPT as needed.
Attachment:- Course Project.rar