W4.1_Hassan Albarrami_Pareto Chart


1. Problem Definition

Oman is a developing country and infrastructural projects are increasing sharply. One of the main projects in Oman are the roads , unfortunately Oman is suffering from road accidents as the statistics for 2012 shows that one case of injury every hour due to road accidents and one death was reported every eight hours due to a crash. In this blog we need to identify the locations in which the most accidents happen so that more road resolutions to be exerted.

2. Identify the Feasible Alternative

Table 1 is showing statistical road accidents in Oman according to historical data form 2012.

1

Table 1

Assuming that these accidents are due to road defects, 80/20 rule will be used here to find the 20% road defects that cause 80% road accidents

3. Development of the Outcome for Alternative

Pareto chart will be applied here to find out which location need first attention. Pareto chart contains both bars and line graph in which values are plotted in descending order of relative frequency from left to right.

2

Table 2. Locations that leading to majority of road accidents

4. Selection Criteria

20% of road Locations which if tackled will reduce 80% of the problems.

5. Analysis and Comparison of the Alternative

3

Figure 1. Pareto chart analysis

 

Figure 1 shows that maximum accidents are in Mascat where as minimum accidents are in Musandam

6. Selection of the Preferred Alternative

According to figure 1, the Government should focus only on 20 % of road locations which cause 80% of accidents in this case it is Muscat area (34%):

7. Performance Monitoring and the Post Evaluation of Result

The government to start  improving the roads in Muscat and to apply the same method every sex month so that new locations can be tackled.

 

Reference

  1. Gulfnews.com ,Oman traffic accident rate tests health sector, Retrieved on 23.06.2014 from http://gulfnews.com/news/gulf/oman/oman-traffic-accident-rate-tests-health-sector-1.1193524
  2. Bright hub pm, Creating Pareto Charts With Microsoft Excel, Retrieved on 23.06.2014 from http://www.brighthubpm.com/templates-forms/8708-creating-pareto-charts-with-microsoft-excel/
  3. LAKSONO, A. (2014, June 17), W16_AL_Pareto Chart | Kristal AACE 2014. Retrieved on 23.6.2014, from http://kristalaace2014.wordpress.com/2014/06/17/w16_al_pareto-chart/

 

One thought on “W4.1_Hassan Albarrami_Pareto Chart

  1. MUCH better this time around Hassan……!!! The whole objective behind Pareto is, given a pool of scarce or limited resources, how can we prioritize where we allocate or deploy those resources in order to get “the most bang for the buck”……

    As I can almost GUARANTY that you will see a Pareto Chart question on your PMP exam, be sure to spend some time reading over your Memory Jogger 2, pages 122- 135. Pay special attention to the “before and after” picture shown on page 128. For the future, under your step 7, it would have been better if you had been more specific in stating that every six months, you would run a follow on Pareto Analysis to see if your interventions actually worked or not. (What would happen if you thought you “solved” ONE problem but found out that all you did was “kick the can down the road” by creating a larger problem in some other area?

    Anyway, nice job this time on your analysis and for the future, PLEASE try to reference the materials I provided to you….. They are the best I can find to achieve or realize our objectives and if you use them as your FIRST places to look, then you will increase your probability of achieving both our objectives.

    Make sense?

    BR,
    Dr. PDG, back home in Jakarta

Leave a comment