Corona Data Analysis

1035 words - 5 pages

This case is about Corona Data Analysis (CDA) which processes claims for health insurance. CDA has about 90 employees out of which 75% work in the operations side of the business which is also the side of the business we were hired to consult upon. We were hired by the quality manager, Gordon Yu, who was hired by the CEO, Julieanna Sugumar. Gordon Yu has asked us to analyze the defects per unit, DPU, defects per million units , DPMO, and K-sigma quality levels. He has given us important access to the processing data and the number of errors that were made in 5 different categories including name, ss#, address, claim code, and claim date fields. This information has been given to us for the past 6 months along with the actual number of claims taken during each month. Gordon Yu has also asked for some tips on reaching Six Sigma since his boss doesn’t believe it is a good idea and is a waste of money.
DPU is also known as defects per unit which is calculated very easily by taking the total number of the defects that occurred in a process and dividing it by the total number of possible defects which is basically the amount of records in this case. Therefore to calculate DPU for each month in our case we add all the defects that were made in name, address, ss#, claim code, and claim date then we divided this sum by the total number of records for each month. These calculations are really useful because it gives us an understanding of the rate of defects that we have going on. This leads us to the next point which is DPMO.
DPMO is also known as defects per million opportunities which is calculated by taking the DPU(calculated earlier) and multiplying it by 1,000,000. Calculating DPMO gives us a better understanding of the defects that we have because it takes a bigger picture of what could happen during taking health insurance claims for a year or for more departments. This of course leads to an even bigger picture of K-sigma quality levels.
K-sigma quality levels:
K-sigma quality level is basically defects per million opportunities considering a specific off-set and a desired quality level. The off-set that we have had as specified in the information given to us is a 1.5 standard deviation. We have solved for this by using an excel formula to give us a more precise number. The formula as given in excel was NORMSINV(1-DPU)+1.5 standard deviation. The results for these calculations were between 3.774 and 3.823 which is above 3.4 which is the required amount for six-sigma but significantly lower than 32 which is the required level of 5.5 sigma. This brings us to the reason CDA should pursue six-sigma.
As we were able to see in the calculations above CDA is very close to achieving six-sigma which would be a great benefit for CDA as a cost saver and customer quality service. It is very obvious...

Find Another Essay On Corona Data Analysis

The World Health Organisation Essay

2547 words - 10 pages affected countries by coordinating supplies and additional health care workers if needed The WHO provided research teams to the most infected areas. Two of these areas are Guangdong and Hanoi. There the WHO teams collect data for research labs and try to pinpoint the characteristics of SARS. * Provide information to health officials and address public concerns The WHO has designated a whole sub-page on their

Case- Examining the Molson acquision of Bavaria in Brazil

8589 words - 34 pages BAVARIA in 2000, for $98 million CAD2. by acquiring KAISER in 2002, for $912 million CAD (for a 80% interest)After these two acquisitions Molson doubled its brewing capacity and gained a foothold in an important emerging market. As this was Molson's first major foray into a South American market there are considerable risks in the pursuit of this strategy.The present paper delivers an external and internal analysis, critiques the current strategy

Budwiser Corporate Analysis

3901 words - 16 pages targeted more than who they bargained for. Through A-B's catchy advertisements, they have attracted customers other than the 21+ age group, and recreational drinkers. It is the opinion of many researchers that Anheuser-Busch is negligent in their advertising, and insists that changes need to be made. Through proper regulation of their advertising, consumers would be allowed to make choices free of media persuasion. Situation Analysis Environment

Marketing Plan

4245 words - 17 pages . Positioning 5. Marketing Program Strategy and Tactics 85.1. Product Line 85.2. Packaging 995.3. Promotion 95.4. Place 5.5. Pricing 9106. Financial Data and Projections 106.1. Expense Distribution 116.2. Operating Expenses 116.3. Gross Profit per Unit Sold 6.4. Expected Market Share 116.5. Expected Net Revenue 127. Implementation Plan 147.1. Gantt chart 147.2. Promotion Schedule 148. Evaluation and Control 158.1. Quality Control 158.2. Risk Analysis 168.3

The Development of the Centre for Migration Studies Irish Emigration Database

5441 words - 22 pages References, which were usually transcripts or photocopies of the original item - Board of Guardian reports - Microfilms which contained shipping lists Very often other researchers in PRONI would find articles and inform me of them and these were added to our lists. These lists were compiled consecutively. While I did this, the Data Processor began to scan the relevant documents and the Repository Assistant printed microfilms of shipping lists

When the Bubble Burst

1539 words - 6 pages By the time I arrived state side from my second tour in the Middle East the housing bubble had already burst. I noticed a drastic change in the way that many of my friends and family were living. Several of my friends that worked in real estate had sold their boats and seconds houses. My own stock portfolio had lost a third of its value. My sister and her husband had defaulted on their home mortgage leaving them scrambling for a place to live. I

phase diagram

4456 words - 18 pages 348.8 K Relative Error 3.4 7.7 0.6 0.1 1.2 Table 1 Summary of results. A = Naphtalene, B = Durene Figure 1 Phase diagram of (Naphtalene/Durene) system via thermal analysis Figure 2 Phase diagram of (Naphtalene/Durene) system via visual analysis Figure 3Experimental data vs fitted data for runs (1 to 6) Figure 4 Experimental data vs fitted data for

Revolutionary Work of Art

1890 words - 8 pages criticism, there would be more opportunities for screen actors to increase their products to the masses. In final analysis, Benjamin argues that the loss of aura through technological reproducibility and capitalism is a positive thing as time progresses. The loss of authenticity might be a way of making people free and create new access for art to expand its knowledge. Cinema, which could be a radical new art form, can provide the masses with an

Enlightenment Thought in New Zealand Schools

1594 words - 6 pages New Zealand Curriculum Framework and associated curriculum documents for the seven curriculum areas. These dictated what must be taught in schools. This allowed the central government to have full control of what was taught in each and every classroom. McCulloch (1992) states that “during the 1980’s the curriculum became the focus of explicit and often fierce contestation at a national level, political analysis of ‘ what counts as knowledge

Psychological Egoism Theory

2240 words - 9 pages The theory of psychological egoism is indeed plausible. The meaning of plausible in the context of this paper refers to the validity or the conceivability of the theory in question, to explain the nature and motivation of human behavior (Hinman, 2007). Human actions are motivated by the satisfaction obtained after completing a task that they are involved in. For example, Mother Teresa was satisfied by her benevolent actions and

How Celtic Folkore has Influenced My Family

1587 words - 6 pages Every family has a unique background that influences the way they live and interact with other people. My parents, who emigrated from Ireland to the States with my three brothers in 1989, brought over their own Celtic folklore and traditions that have helped shaped the way our family operates and lives. One aspect of folklore that has helped shape my family dynamic is the Celtic cross—both its background and what role it has played in our lives

Similar Essays

Gas Discharge Visualization Used For Cardio Vascular Disease In India

3114 words - 13 pages 11 4.0. ASSESSMENTS 11 5.0. DATA EXTRACTION 11 6.0. DATA ANALYSIS 11 7.0. EXPECTED OUTCOMES 11 8.0. DISCUSSION 11 REFERENCES: . 11 1. INTRODUCTION The gas discharge visualization technique (GDV) was developed by Konstantin Korotkov at St Petersburg State Technical University during the 1990s (Korotkov, 1998). The first GDV camera was made in 1995; afterwards hundreds of such cameras have been produced and developed in new designs. GDV cameras

Lc Ms And Lc Ms/Ms: Principles And Applications

1470 words - 6 pages further be used to identify, quantify and purify these components. The combination of MS and LC is a highly specialised analytical technique with high sensitivity and combines the separation capability of HPLC with the mass analysis of MS (COVEY, et. al., 1986). Liquid chromatography-mass spectrometry (LC-MS also known as HPLC-MS) can be used for the specific detection of a certain chemical substance in the presence of numerous other

F. Scott Fitzgerald And His Novels: Parallels Between His Worlds Of Fiction And Reality

1222 words - 5 pages to having a big beautiful mansion, owning fancy, unnecessary material possessions, and throwing parties to impress his dream girl, Daisy. According to Judith S. Baughman, “between October 1922 and May 1924, the Fitzgeralds rented a house in Great Neck, Long Island, where they met and partied with upper class people”, it is said that the inspiration for the East and West Eggs came from there. Similarly, “the Corona dump in the borough of Queens

Remote Sensing In Afghanistan Essay

2111 words - 8 pages information about objects or areas from a distance, typically from aircraft or satellite. Remote Sensing data can be in several forms such as, Signals intelligence (SIGINT) information gathered by the interception of electronic signals. Measurement and signature intelligence (MASINT), information gathered by radar, acoustic, nuclear, chemical, or biological means. Most often MASINT collection requires special purpose remote sensors. Imagery