copy of weekly report 31 03 2014
Post on 29-May-2017
216 Views
Preview:
TRANSCRIPT
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
top related