Phone: + 1 507 4052 660
Email: support@collegecustomtutors

Attention Wendy Lewis

Attention Wendy Lewis

For the purpose of this assignment, assume that you are the manager of the HIM Department of General Hospital. The hospital is due for a Joint Commission accreditation survey in six months. The CEO has asked for a report regarding medical staff compliance with Joint Commission requirements for delinquent records last year.

Information Regarding General Hospital’s Policies, Procedures, Rules, and Regulations

To implement this standard, General Hospital’s policies and procedures state:

  • The medical record delinquency rates are monitored on a monthly basis;
  • Action will be taken when a problem is indicated; and
  • Data will be available to demonstrate improvement.

In addition, to ensure the timely entry of all significant clinical information into the patient’s record, the Medical Staff Rules and Regulations list the following documentation requirements:

  • The total number of delinquent records may not exceed 50% of the total number of inpatient discharges and ambulatory surgeries performed for the month.
  • The total number of delinquent history and physicals may not exceed 2% of the total number of inpatient discharges and ambulatory surgeries performed for the month.
  • The total number of delinquent operative reports may not exceed 2% of the total number of inpatient operations and ambulatory surgeries.

Assignment Instructions

Download this Delinquent Record Report and use the data it contains to complete the following:

Part-1: Create Delinquent Record Report Table

  1. Using Microsoft Excel, input the data from the Delinquent Record Report. Include report, column and row titles, and the monthly data.
  2. Use Excel to calculate and automatically insert the total number of discharges for the month.
    1. Total discharges = total inpatient discharges + total ambulatory surgeries.
    2. Total operations = total ambulatory surgeries + total inpatient operations.
  3. Use Excel to calculate and insert the number of delinquent records, history and physical exam reports (H & Ps), and operative reports permitted according the Medical Staff Bylaws for each month in 20XX based on the hospital’s statistics for that month. To calculate the year’s figure, the monthly average should be used. Therefore, have a final monthly average column and use Excel to compute the averages for all rows.

Part-2: Create Line and Bar Graphs

  1. Using Microsoft Excel, construct both line graphs and bar graphs showing the following:
    1. The hospital’s actual delinquent records compared to the total number of delinquent records permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year)
    2. The hospital’s actual delinquent H & Ps compared to the total number of delinquent H & Ps permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year).
    3. The hospital’s actual delinquent ORs compared to the total number of delinquent ORs permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year).

Part-3: Write Narrative Analysis

  1. In a Word document, provide a narrative analysis of the findings for the CEO.
    1. Reference the table and use the graphs you prefer to illustrate compliance in the report.
    2. Include in the analysis whether the hospital was in compliance with the Medical Staff Rules and Regulations in each of the three areas during each month of the year.
    3. Was the hospital in compliance for the whole year?
Unlock Better Papers
Pages (550 words)
Approximate price: -

Why choose us?

Because we are the best Our main aim is to maximize the quality of your customer experience. We understand the intensity of the importance of your academics that is why we intend to deliver the best grades as a reward for trusting us with your valuable work. Here are reasons why you made the best decision by choosing us:

Masters of our art.

Our writers are experienced and high educated. Our team of writers is associated with the most prestigious universities. They will craft your essays according to any guidelines or requirements you want us to follow for your paper.

You are our VIP

We treat every customer as the most important part of our company, your satisfaction is what drives us.

Best pricing

The best quality for affordable prices! Contact us today to get a discount on your first purchase. We’ve got the best prices in this industry.


Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:

How it works?

Place your order

You can order an essay with us by filling out our quick and easy order form.

Proceed with the payment

After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering. All work goes through three levels of quality assurance before being sent back to you for review.

Receive the final file

Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!


How does our services benefit you?

So much stress and so little time? Take care of yourself: let us help you with your tasks. We offer all kinds of writing services.

We guarantee: no plagiarism, high quality and on time delivery.

We value your grades and we will do everything to help you achieve the highest scores possible! With us you can be sure that your work is in good hands. Our writers are professionals who know what they’re doing so there’s nothing for you to

We have a money back guarantee,

So you can be sure that if something goes wrong we will fix it for you. If your paper fails to meet our requirements by any chance just ask for a refund and get all your money back! We are serious about being number one essay writing company online, and we will prove it to you!

We offer a full privacy guarantee

Your personal information is completely safe with us. Your details are never shared or distributed to third parties. You can be sure that no one has access to your private data because all of the files and documents about you are stored in our secured system.

We will deliver your paper on time

Do not worry about the deadline. We know how important it is for you to hand in your work before the due date and that is why we always prioritize our writers’ schedules around yours. Our writers are experienced professionals who can write any type of essay within a given timeframe!

We care about the quality of our work

Our goal is not just to keep customers happy but also help them succeed in their academic goals. That’s why we provide only 100% original, custom written content that is always delivered on time.

We have a live support service!

contact us now and get the best customer service experience possible, just talk to our friendly staff members via chat or phone at any given time of your day as we are always available for you around the clock without taking breaks! Take advantage of this opportunity right now and do not hesitate to contact us for more information about how we work.