Question description

I need you write 5 full pages for this project answering these questions:( Use graph and chart for the result and revenue cycle in general) -Does printing the letter on colored paper have an impact on response ?- Does the patient balance have an impact on response?-what percentage of patients respond by calling the office ?- what percentage of patients respond by paying the balance ?- Does the type of practice have an impact on response?-Do the results justify the expense ? Project instructions :
A brief description of the project, its purpose and your
role should be included as background information only.  Your report should focus in detail how
the project helped you attain the goals set out in your Learning Contract
and/or Learning Logs.  Examples of your
written work (e.g. memos, charts, power point presentations, etc.) are strongly
encouraged.  Check with your Preceptor
regarding confidentiality and proprietary nature of materials.  NO patient names should appear in any
documents.  It would be NICE if you could
take this piece on a job interview, but it is not required.  The Project report will be submitted as part
of the Assessment Portfolio.
I am doing my internship in Medical billing company called Physician Support Service this project is under the goal that set in my learning contract and learning goal “Goal 3:Define the revenue cycle for physician billing. How can each aspect be improved”The company provided me an Excel sheet that I will uploaded to answer the questions above. You need to calculate the total patients ( blue color) that I have already investigate and the result will be in the (red color) ( don’t worry about the patients who don’t have result red color) you need to do that for all clients ( COS,MT Wash, HRT,WC,Joslin,ENT,Hospitalist ) the patients in total.   the patient highlighted in yellow color are  is for the first question . Start the paper about the background of revenue cycle management for physician billing company and its impact in raising their profit  and follow up to get their money.  By end of the project you need to write recommendation and evaluation.This may help to know more about the duties of department 🙁 you may include this in the background of the follow up department but you MUST  start with the background of revenue cycle management for physician billing company”My duties in the follow up department as an intern, were to write off claims
that were past time, obtain details from insurance companies through making a
call, receiving denial claims, and making resubmission of denial claims, and
give regular updates to clients when needed to do so”Follow up department tasks : Reports claims 30 days or older, call insurance to appeal >> to find out why claim is denied , send out ,Follow up works on rejected claims , Appeals- correct claim , sending medical records, sending additional information an insurance company may ask, work on rejected claims that come back denied by insurance for example: No authorization, patient not eligible  
   sp_letters_111515.xlsx