HIT 229 Week 3 Excel Assignment Activity

General Hospital is a short term acute care voluntary non-pro昀椀t organiza琀椀on. The u琀椀lze a hybrid Electronic Health Record. They are planning to open up a new Surgery Center for Fiscal Year 2021. The Chief FIniancial O昀케cer has asked the HIM Director to determine if the new Surgery Center will impact the HIM Deparment's sta昀케ng needs. Use the sta昀昀 produc琀椀vity to answer ques琀椀ons 1-10. Enter your FY20 218 $1,202,844,614 13,288 50,183 19 252472 Based on the FY20 Actual numbers, how many EDMS Specialists were needed to to process the page volume? (Round to the tenth place) (Cell B17) Based on the FY20 Actual numbers, how many Analysts were needed to process the chart volume? (Round to the tenth place) (Cell B18) Based on the FY20 Actual numbers, how many ROI Specialists were need to process the request volume? (Round to the tenth place) (Cell B19) If the hospital opens up a new surgery center that will result in 45% more discharges, how many discharges can be expected in FY21? (Cell C24) If the average number of pages per chart is expected to decrease to 16 in FY21 because of the new Surgery Center, what will be the projected # of pages in FY21? (you will need your answer from ques琀椀on 4) (Cell C23) If the hospital opens up a new surgery center that will result in 5% more ROI requests, how many requests can be expected in FY21? (Cell C25) Based on the FY21 Projected number of discharges (your answer to ques琀椀on #4), how many Analysts will be needed to handle the chart volume? (Round to the tenth place) (Cell C18) Based on the FY21 Projected number of pages (your answer to ques琀椀on #5), how many EDMS Specialists will be needed to to handle the page volume? (Round to the tenth place) (Cell C17) Based on the FY21 Projected number of requests (based on your answer from #6), how many ROI Specialists will be need to process the request volume? (Round to the tenth place)(Cell C19) How many new FTE's will the hospital need to hire (rounded to the tenth place) to handle the FY21 projec琀椀ons? (Cell B27)