Categories
Healthcare

Instructions ECPI healthcare system has tasked Jill to provide statistical data

Burdened by Homework? Let us write your essays and assignments Order This Now

Instructions
ECPI
healthcare system has tasked Jill to provide statistical data on staffing
minutes needed to justify new coder/biller positions. Jill is the director of
HIM and is required to evaluate the current status and number of coders/billers
needed to efficiently code, based on the workload. Currently, ECPI has 2 coders
for patient charts. Reviewing current productivity shows the coder takes 25
minutes to code a patient’s chart. The coder has 36 hours a week of
productivity. The current weekly charts are 375. Please follow the
directions below in creating your excel sheet
·
Open HCA 530 Staffing Minutes Excel workbook. Download HCA 530 Staffing Minutes
Excel workbook.
o In cell
B7 insert formula =B3*B5 this will calculate the minutes required to code all
charts for the week.
o In cell
B8 insert formula =B7/60 and convert the total minutes to hours.
o In cell
B9 insert formula =B8/B4 this calculates your full-time employee that is needed
to code all charges weekly.
·
Create a PowerPoint presentation with speaker notes supporting
the change in staffing within the HIM department of the ECPI health system.
·
Be sure to include the following:
o Support
your results and determine if there are any errors found in the information.
o Create
charts to use in your presentation supporting the data and your
recommendations.
o Support
the change in staffing within the HIM department of the ECPI health system.
Requirements:
·
PowerPoint presentation (5 slides) with speaker notes not
including the title page and reference page
·
Be sure the detail you provide is thorough and supports a
high-level learner
·
Format your PowerPoint using APA style
·
Support your statements with a minimum of two (2) credible
resources, identified with in-text citations and APA references at the
end
Hands-On Statistics Calculating Staffing Minutes
Criteria
Pts
This criterion is linked to a
Learning Outcome Complete Staffing Minutes in Excel
Workbook
Using the formulas above complete
the table on minutes required to code all charts, convert minutes to hours,
and calculate full-time employees.
20 pts
This criterion is linked to a
Learning Outcome Analyze the Results
Support your results and determine
if there are any errors found in the information.
20 pts
This criterion is linked to a
Learning Outcome Visualization of Findings
Create charts to use in your presentation
supporting the data and your recommendations.
20 pts
This criterion is linked to a
Learning Outcome Justification Concerning
Additional Coders
Support the change in staffing
within the HIM department of the ECPI health system.
30 pts
This criterion is linked to a
Learning Outcome Mechanics
Responses are written at the
college level. The assignment is free of spelling and grammar errors. Follows
APA guidelines set forth in the instructions. Minimum of two scholarly
resources with in-text citations.
10 p

Burdened by Homework? Let us write your essays and assignments Order This Now

Leave a Reply