ISE 451 Case Study #7 A major project organization has operations in 4 different countries: USA, Germany, UK, and Brazil. They have been receiving complaints from their customers about project delays. When they did a thorough study they found various causes per stakeholder per country. Table 1 below shows the causes generated by various stakeholder groups per country. Based on the data shown in Table 1 answer the following questions: 1. Where should the organization focus its efforts to reduce customer complaints? (Hint: Causes that in total generate 80% of the problem) 2. Which country contributes the most to the problem? 3. Which stakeholder contributes the most to the problem? You must prepare appropriate charts in excel to solve this problem and get full credit. EXAMPLE Stakeholder Architect Structural engineer Service Engineer Cause Incomplete drawing Architect late issuance of instruction Architect's variation orders Architect Inadequate supervision Poor information sharing delay in work approval ay Incomplete structural drawing contincto SE late issuance of instruction Str Structural design variations SE late issuance of instruction Sedang envision SE Inadequate supervision actura an inte Poor structural design information Incomplete service drawings ka Service Eng. variation orders Service Eng. late issuance of instruction Poor service design information Contractors' financial difficulties Contractors' planning and scheduling problems ht Shortage of manpower Material Shortages mes Unforeseen material damages Equipment breakdown and maintenance problems booledo Equipment shortage Equipment delivery problem Inadequate skill of equipment operators Slow mobilization Interference with other trades Financial difficulties Late delivery of ordered materials Noncompliance of material to specifications PROJECT- USA PROJECT- UK PROJECT- DE PROJECT- Brazil 73 56 29 54 92 76 10 72 91 62 16 30 62 27 10 69 43 41 33 46 73 15 22 31 83 36 27 51 62 51 30 70 20 30 40 71 81 22 24 49 68 12 24 75 28 78 28 63 28 25 38 38 46 22 71 15 20 79 .. 61 56 24 48 44 41 29 55 74 63 38 80 62 24 26 37 2 32 74 15 58 97 91 7 58 93 62 21 56 72 36 34 69 48 46 14 76 100 54 13 76 51 69 26 59 60 42 6 76 46 63 37 62 50 89 9 9 53 19 60 1 51 49 48 33 42 Contractor Subcontractor Suppliers