These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 13, 2016

Finding Insurance Pricing Discrepancies

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

1 comment:

  1. Quantum Binary Signals

    Get professional trading signals sent to your cell phone every day.

    Start following our signals NOW & gain up to 270% daily.

    ReplyDelete

Blog Archive