The client had huge variation in collection efficiency across various sub offices and wanted to analyze the reasons for such variations, therefore below attached excel comparative sheet was prepared to analyze the same with comments written to make correct comparison.