Spreadsheet: 69652d1270207848-formatting-problem-attaching-consolidate-target-updated
Sheet: Collection

Innovative  Pvt. Ltd. |  |  |  |  | Collection Analysis – 2009-2010
 |  |  |  |  |  |  |  |  |  |  | Actual | Last year | Actual | Last year | Actual | Last year | Actual | Last year | Actual | Last year
 |  | Total | PS | ES | BS | Services | VAS |  | Quar | Sta | Total Actual | Total Last year | PS Actual | PS Last year | ES Actual | ES Last year | BS Actual | BS Last year | Services Actual | Services Last year | I2c
Q1 | Lhr | 13105993 | 6367328 | 0 |  | 6738665 |  |  | Q1 | Lhr | 13105993 | 128504029.8 | 6367328 | 12316125.31 | 0 | 66925041.49 | 0 |  | 6738665 | 4262863 | 45000000
 | [NAME] | 81535226.24000001 | 31709757 | 15000000 | 8876710 | 23853181.24 | 2095578 |  |  | [NAME] | 81535226.24000001 | 153219537 | 31709757 | 24890181 | 15000000 | 45125805 | 8876710 | 79359046 | 23853181.24 | 3844505 | 0
 | ID | 26442201.77 | 19429061.65 | 0 |  | 7013140.12 |  |  |  | ID | 26442201.77 | 15142872 | 19429061.65 | 13201715 | 0 | 0 | 0 |  | 7013140.12 | 1941157 | 0
 |  | 121083421.01 |  |  |  |  |  |  |  |  | 121083421.01 | 296866438.8
Q2 | Lhr | 7797237 | 4975676 | 0 |  | 2821561 | 0 |  | Q2 | Lhr | 7797237 | 78958415.24 | 20759583.24 | 20759583.24 | 0 | 11613000 | 0 |  | 2821561 | 1585832 | 45000000
 | [NAME] | 92326248 | 35540648 | 0 | 36536757 | 16437916 | 3810927 |  |  | [NAME] | 92326248 | 90905397.52 | 18496239 | 18496239 | 0 | 11997346 | 36536757 | 44248656 | 16437916 | 16163156.52 | 0
 | ID | 24089121 | 20741186 | 0 |  | 3347935 | 0 |  |  | ID | 24089121 | 13395346 | 12570827 | 12570827 | 0 | 0 | 0 |  | 3347935 | 824519 | 0
 |  | 124212606 |  |  |  |  |  |  |  |  | 124212606 | 183259158.76
Q3 | Lhr | 11583937 | 9085885 | 31500 | 326095 | 2140457 | 0 |  | Q3 | Lhr | 11583937 | 57642133 | 6993813 | 6993813 | 31500 | 3774941 | 326095 | 0 | 2140457 | 1873379 | 45000000
 | [NAME] | 56516439.17 | 12260738.22 | 0 | 30119654.95 | 10146226 | 3989820 |  |  | [NAME] | 56516439.17 | 135284618.09 | 18292070.09 | 18292070.09 | 0 | 4512000 | 30119654.95 | 89588025 | 10146226 | 22892523 | 0
 | ID | 21514030.28 | 17647616.28 | 0 | 0 | 3866414 | 0 |  |  | ID | 21514030.28 | 4638981 | 2922269 | 2922269 | 0 | 0 | 0 | 0 | 3866414 | 1716712 | 0
 |  | 89614406.45 |  |  |  |  |  |  |  |  | 89614406.45 | 197565732.09
Q4 | Lhr | 0 | 0 | 0 |  | 0 | 0 |  | Q4 | Lhr | 0 | 71745746 | 14950737 | 14950737 | 0 | 0 | 0 |  | 0 | 11795009 | 45000000
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 |  |  | [NAME] | 0 | 145986872.9 | 40062552.8 | 40062552.8 | 0 | 288000 | 0 | 78230104.1 | 0 | 27406216 | 0
 | ID | 0 | 0 | 0 |  | 0 | 0 |  |  | ID | 0 | 17970950 | 16887207 | 16887207 | 0 | 0 | 0 |  | 0 | 1083743 | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0 | 235703568.9
Total | Lhr | 32487167 | 20428889 | 31500 | 326095 | 11700683 | 0 |  | Total | Lhr | 32487167 | 336850324.04 | 55020258.55 | 55020258.55 | 31500 | 82312982.49 | 326095 | 0 | 11700683 | 19517083 | 180000000
 | [NAME] | 230377913.41 | 79511143.22 | 15000000 | 75533121.95 | 50437323.24 | 9896325 |  |  | [NAME] | 230377913.41 | 525396425.51 | 101741042.89 | 101741042.89 | 15000000 | 61923151 | 75533121.95 | 291425831.1 | 50437323.24 | 70306400.52 | 0
 | ID | 72045353.05 | 57817863.93 | 0 | 0 | 14227489.12 | 0 |  |  | ID | 72045353.05 | 51148149 | 45582018 | 45582018 | 0 | 0 | 0 | 0 | 14227489.12 | 5566131 | 0
Total |  | 334910433.46 | 157757896.15 | 15031500 | 75859216.95 | 76365495.36 | 9896325 |  | Total |  | 334910433.46 | 913394898.55 | 202343319.44 | 202343319.44 | 15031500 | 144236133.49 | 75859216.95 | 291425831.1 | 76365495.36 | 95389614.52 | 180000000
 |  | Quarterly/Branch Wise Collection – 2009-10
 |  |  | Product Line Breakdown
 |  |  | Branch [NAME]
 |  |  | [NAME]
 |  |  | Branch- [NAME]
 |  | Q1 | Q2 | Q3 | Q4
 | Lhr | 13105993 | 7797237 | 11583937 | 0
 | [NAME] | 81535226.24000001 | 92326248 | 56516439.17 | 0
 | ID | 26442201.77 | 24089121 | 21514030.28 | 0
 |  | 121083421.01 | 124212606 | 89614406.45 | 0