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. The 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 contribute the most to the problem? 3. Which stakeholder contribute the most to the problem? You must prepare appropriate charts in excel to solve this problem and get full credit. EXAMPLE Stakeholder Cause PROJECT- USA PROJECT- UK le PROJECT- DE PROJECT- Brazil Architect 73 56 29 54 92 76 10 72 91 62 16 30 62 27 10 69 43 41 33 46 73 15 22 31 Structural engineer 83 36 27 51 62 51 30 70 20 30 40 71 81 22 24 49 68 12 24 75 28 78 28 63 Service Engineer 28 25 38 38 Incomplete drawing Architect late issuance of instruction Architect's variation orders Architect Inadequate supervision Poor information sharing delay in work approval Incomplete structural drawing SE late issuance of instruction Structural design variations SE late issuance of instruction SE Inadequate supervision Poor structural design information Incomplete service drawings Service Eng. variation orders Service Eng. Iate issuance of instruction Poor service design information Contractors' financial difficulties Contractors' planning and scheduling problems Shortage of manpower Material Shortages Unforeseen material damages Equipment breakdown and maintenance problems Equipment shortage Equipment delivery problem Inadequate skill of equipment operators 46 71 15 79 61 56 24 48 44 41 29 55 Contractor 74 63 38 90 62 24 26 37 32 74 15 58 97 91 7 7 58 93 62 21 56 72 36 34 69 48 46 14 76 100 54 13 76 51 69 26 59 Subcontractor Slow mobilization 60 42 6 76 Interference with other trades 46 63 37 62 Financial difficulties 50 89 9 53 Suppliers Late delivery of ordered materials 19 60 1 51 Noncompliance of material to specifications 49 48 33 42