Date : 28th Feb

2014

REVENUE billed COLLECTION

ACHIEVED Billing Target Opening Outstanding from last

year billing

Collection in current month

against last year billing

Balance as on date

against last year billing

Advance if any from last

year

MONTH Current month billing as on

date

Current month target Month Current month billing

as on date

Collection against current

month billing

Balance as on date

against this month billing

Advance received in this

month but not adjusted as

on date

QUARTER Current quarter billing

excluding current month

Current quarter

target excluding

current month

Quarter Current quarter billing

excluding current

month

Collection against current

quarter billing minus

current month

Balance as on date

against current quarter

minus current month

Advance received in this

quarter minus this month

but not adjusted as on date

YEAR Current year billing

excluding current quarter

Current year target

excluding current

quarter

Year Current year billing

excluding current

quarter

Collection against current

year billing minus current

quarter and month billing

Balance against current

year minus above two

Advance received in this

year minus this quarter and

month but not adjusted as

on date

TOTAL Total of above three Total of above three Total Total of above three Total of above four Total of above four Total of above four

ORDER IN HANDnot

billed yet

Confirmed order in

hand

EXPECTED ORDER

current month

Order expected in current

month only

Expected order

current quarter

Order in this quarter after

this month

Expected order

current year

Order in current year after

this quarter

Total Total of above three

1

Date : 25th Feb

2014

REVENUE billed Acieved Billed Target COLLECTION Billing Collection Pending Outstanding Advance Collection

69939106 80000000 99276076 1823004 0 1804032 0

MONTH 3985831 6666667 635780 3985831 635780 2573079 -413755

QUARTER 7246524 13333333 8416022 7246524 8416022 2792279 -328245

YEAR 58647976 60000000 49881607 58706751 49881607 501149 0

TOTAL 69880331 80000000 58933409 69939106 58933409 7670539 -742000

ORDER IN HANDnot

billed yet

9500000

EXPECTED ORDER

current month

1000000

Expected order

current quarter

0

Expected order

current year

0

Total 1000000

2

Date : 25th Feb

2014

REVENUE billed Acieved Billed Target COLLECTION

71581934 80000000 99276076

MONTH 5687434 6666667 1943683

QUARTER 7246524 13333333 9374925

YEAR 58647976 60000000 49881607

TOTAL 71581934 80000000 61200215

ORDER IN HANDnot

billed yet

9000000

EXPECTED ORDER

current month

1000000

Expected order

current quarter

0

Expected order

current year

0

Total 1000000

Billing Collection Pending Outstanding Advance Collection

1823004 0 1804032 0

5687434 1943683 2510681 -457234

7246524 9374925 2152240 -268995

58647976 49881607 501149 0

71581934 61200215 6968102 -726229