Excel Assignment Week 3 LIZBETH GARCIA

.xlsx

School

DeVry University, Chicago *

*We aren’t endorsed by this school

Course

226

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by EarlEel1831

HIT 226 Excel Application Activity # 1 - See the syllabus section "Due dates for assi Short Term Acute Care Staff Productivity (Avg) Voluntary Nonprofit Hour Week Year EHR: Hybrid Prep/Scan/index (pages) 80 3,200 166,400 Chart Analysis (charts) 6 240 12,480 Total Beds ROI (requests) 5 200 10,400 Total Patient Revenue Total Discharges FTEs Total Patient Days FY20 FY21 Avg # pages per chart EDMS Specialist 3155 9/10 1.9 Avg # Pages per year Analyst 1.1 1.5 ROI Specialist 2.9 3.1 Volume FY20 (actual) FY21 (Projected) # Pages 252472 308282 # Discharges 13288 19268 # Requests 30250 31763 Question 10 3166.3 1 Based on the FY20 Actual numbers, how many EDMS Specialists were ne 2 Based on the FY20 Actual numbers, how many Analysts were needed to 3 Based on the FY20 Actual numbers, how many ROI Specialists were need 4 If the hospital opens up a new surgery center that will result in 45% mor 5 If the average number of pages per chart is expected to decrease to 16 i 6 If the hospital opens up a new surgery center that will result in 5% more 7 Based on the FY21 Projected number of discharges (your answer to ques 8 Based on the FY21 Projected number of pages (your answer to question 9 Based on the FY21 Projected number of requests (based on your answer 10 How many new FTE's will the hospital need to hire (rounded to the tenth General Hospital is a short term acute care voluntary non-profit organization. The utilze a hybrid Ele planning to open up a new Surgery Center for Fiscal Year 2021. The Chief FIniancial Officer has asked new Surgery Center will impact the HIM Deparment's staffing needs. Use the staff productivity to an answer is the corresponding cells.

ignments and exams" FY20 218 $1,202,844,614 13,288 50,183 19 252472 eeded to to process the page volume? (Round to the tenth place) (Cell B17) o process the chart volume? (Round to the tenth place) (Cell B18) d to process the request volume? (Round to the tenth place) (Cell B19) re discharges, how many discharges can be expected in FY21? (Cell C24) in FY21 because of the new Surgery Center, what will be the projected # of pages in FY21? (you will need e ROI requests, how many requests can be expected in FY21? (Cell C25) stion #4), how many Analysts will be needed to handle the chart volume? (Round to the tenth place) (Ce n #5), how many EDMS Specialists will be needed to to handle the page volume? (Round to the tenth plac r from #6), how many ROI Specialists will be need to process the request volume? (Round to the tenth pl h place) to handle the FY21 projections? (Cell B27) ectronic Health Record. They are d the HIM Director to determine if the nswer questions 1-10. Enter your

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help