Executive Summary
A recent study found that some medical procedures are priced differently depending on the place where they are offered. A Utah based insurance company wanted to make sure that wasn’t the case in their company so that their members could receive the fairest prices and refer members to the cheapest option. This project takes a table received from a SQL query and separates it into sorted groups through Pivot Table automation, and then compares how much a medical procedure costs in varying places of service, whether a hospital , doctor’s office, urgent care clinic, or an emergency room, and sees which one is the most and least expensive of all available options. Then it calculates the difference in pricing and calculated how much money the members could have saved if they had all been charged the lowest price, and produces summary statistics across all different kinds of procedures. The code was made flexible to process different kinds of medical procedures that use different classifications, and filters data based on the state and insurance plan used. Potential savings to customers and the insurance company of several million dollars were found if the discovered pricing discrepancies were resolved.Links
- http://files.gove.net/shares/files/16w/jsee2/Final_Project_Write_Up.docx
- http://files.gove.net/shares/files/16w/jsee2/Excel_Final_Project.xlsm
No comments:
Post a Comment