HIT226 - Week 3_ Excel Assignment - Part III
.pdf
keyboard_arrow_up
School
DeVry University, Alpharetta *
*We aren’t endorsed by this school
Course
226
Subject
Mechanical_engineering
Date
May 20, 2024
Type
Pages
1
Uploaded by BrigadierNarwhal3463
— HIT226 > Quizzes > Week 3: Excel Assignment - Part Il Search this course (] May 2024 Home Syllabus Announcements Modules Files Grades People Media Gallery My Media Tutoring Bookstore Search Week 3: Excel Assignment - Part Il Submission Details: o Time: 3 minutes Due May 19 at 11:59pm Points 70 Questions 10 Available May 11 at 11:59pm - Jun 22 at 11:59pm Time Limit 90 Minutes Current 70 out of Score: 70 Instructions 70 out of Kept Score: 70 Use your Week 3 Excel Assignment HIT226 Week 3 Excel Assignment Activity 12-2020 xIsx complete this quiz. There are 10 questions worth 7 points each for a total of 70 points. L @to Make sure to also submit your completed Excel file to the Week 3 Excel Assignment module. Attempt History Attempt Time Score LATEST Attempt 1 3 minutes 70 out of 70 Score for this quiz: 70 out of 70 Submitted May 14 at 11am This attempt took 3 minutes. Question 1 717 pts 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) 1.9 1.0 = 16 Question 2 717 pts Based on the FY20 Actual numbers, how many Analysts were needed to process the chart volume? (Round to the tenth place) (Cell B18) 1.0 29 Question 3 TITpts Based on the FY20 Actual numbers, how many ROI Specialists were need to process the request volume? (Round to the tenth place) (Cell B19) 3.0 Question 4 717 pts 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) 31763 13288 17415 Question 5 717pts If the average number of pages is expected to decrease to 16 in FY21 because of the new Surgery Center, what will be the projected # of pages in FY217? (you will need your answer from question 4) (Cell C23) [ comect RPN 252472 317478 310115 Question 6 717pts 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) Question 7 T17pts Based on the FY21 Projected number of discharges (your answer to question #4), how many Analysts will be needed to handle the chart volume? (Round to the tenth place) (Cell C18) Question 8 717 pts Based on the FY21 Projected number of pages (your answer to question #5), how many EDMS Specialists will be needed to to handle the page volume? (Round to the tenth place) (Cell C17) Question 9 717 pts 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) Question 10 717 pts How many new FTE's will the hospital need to hire (rounded to the tenth place) to handle the FY21 projections? (Cell B27) D o 87 Quiz Score: 70 out of 70 < Previous Next >
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help