|
Spreadsheets |
|
|
Cash Flow Statement
From April - August 2009
|
Code |
Detail |
April |
May |
June |
July |
August |
September |
Total |
|
|
1 |
|
Personnel |
|
|
|
|
|
|
|
|
1-1 |
|
Centre Coordinator |
400.00 |
400.00 |
400.00 |
400.00 |
400.00 |
|
2,000.00 |
|
1-2 |
|
Project Office |
350.00 |
200.00 |
200.00 |
200.00 |
200.00 |
|
1,150.00 |
|
1-3 |
|
Centre Accountant/Administration |
285.00 |
185.00 |
185.00 |
185.00 |
185.00 |
|
1,025.00 |
|
1-4 |
|
Guard/Cleaner |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
|
400.00 |
|
|
|
Total Personnel |
1,115.00 |
865.00 |
865.00 |
865.00 |
865.00 |
|
4,575.00 |
|
2 |
|
Office Cost |
|
|
|
|
|
|
|
|
2-1 |
|
Centre Rental |
390.00 |
300.00 |
300.00 |
300.00 |
300.00 |
|
1,590.00 |
|
2-2 |
|
Communication Cost (E-mail/Internet/Tel) |
43.74 |
44.29 |
37.99 |
48.35 |
52.07 |
|
226.44 |
|
2-3 |
|
Office Supplies |
19.00 |
10.10 |
27.25 |
260.35 |
0.00 |
|
316.70 |
|
2-4 |
|
Maintenance |
143.75 |
58.50 |
90.50 |
0.00 |
0.00 |
|
292.75 |
|
2-5 |
|
Utilities (Water/Electricity/Sanitation Fee) |
27.80 |
85.40 |
27.85 |
155.49 |
46.60 |
|
343.14 |
|
2-6 |
|
Bank Charge |
1.04 |
1.20 |
5.00 |
0.00 |
0.00 |
|
7.24 |
|
2-7 |
|
Financial Audit |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
0.00 |
|
2-8 |
|
Insurance for Cyclo Centre Staff |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
0.00 |
|
2-9 |
|
Cost of T-shirt for sale |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
0.00 |
|
|
|
Total Office Cost |
625.33 |
499.49 |
488.59 |
764.19 |
398.67 |
|
2,776.27 |
|
3 |
|
Project |
|
|
|
|
|
|
|
|
3-1 |
|
Anti-Smoke Programme |
|
|
|
|
|
|
|
|
|
3-1-1 |
Tobacco Awareness Sessions |
960.00 |
444.13 |
0.00 |
0.00 |
455.25 |
|
1,859.38 |
|
|
3-1-2 |
Counseling Sessions |
0.00 |
895.75 |
6.00 |
50.63 |
51.25 |
|
1,003.63 |
|
|
3-1-3 |
Paint |
0.00 |
0.00 |
73.53 |
43.18 |
37.00 |
|
153.71 |
|
|
|
Subtotal |
960.00 |
1,339.88 |
79.53 |
93.81 |
543.50 |
|
3,016.72 |
|
3-2 |
|
Health Care/Personal Hygiene Programme |
|
|
|
|
|
|
|
|
|
3-2-1 |
Washing Facilities & Haircuts |
0.75 |
155.48 |
15.13 |
14.26 |
39.30 |
|
224.92 |
|
|
3-2-2 |
Medical Supplies |
54.20 |
50.60 |
115.30 |
0.00 |
18.75 |
|
238.85 |
|
|
3-2-3 |
Centre Doctor |
60.00 |
60.00 |
60.00 |
60.00 |
60.00 |
|
300.00 |
|
|
3-2-4 |
Eye Checks & treatment |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
0.00 |
|
|
|
Subtotal |
114.95 |
266.08 |
190.43 |
74.26 |
118.05 |
|
763.77 |
|
3-3 |
|
Communication/Information Programme |
|
|
|
|
|
|
|
|
|
3-3-1 |
Monthly Forum Meeting |
1.50 |
1.25 |
14.98 |
7.25 |
29.30 |
|
54.28 |
|
|
|
Subtotal |
1.50 |
1.25 |
14.98 |
7.25 |
29.30 |
|
54.28 |
|
3-4 |
|
Tourist Booking Service |
|
|
|
|
|
|
|
|
|
3-4-1 |
Computer System |
0.00 |
11.50 |
20.00 |
68.50 |
25.00 |
|
125.00 |
|
|
3-4-2 |
Support Transport/Mobile Phone |
60.00 |
60.00 |
60.00 |
60.00 |
60.00 |
|
300.00 |
|
|
3-4-3 |
Office Supplies |
0.00 |
0.00 |
0.00 |
372.38 |
0.00 |
|
372.38 |
|
|
3-4-4 |
Laundry |
89.17 |
103.17 |
93.40 |
152.20 |
209.68 |
|
647.62 |
|
|
|
Subtotal |
149.17 |
174.67 |
173.40 |
653.08 |
294.68 |
|
1,445.00 |
|
|
|
Total Project |
1,225.62 |
1,781.88 |
458.34 |
828.40 |
985.53 |
|
5,279.77 |
|
|
|
GRAND TOTAL |
2,965.95 |
3,146.37 |
1,811.93 |
2,457.59 |
2,249.20 |
|
12,631.04 |
Prepared By: Ms, Pal Holly, Accountant/Administrator
Approved By: Mrs. Nouv Sarany, Cyclo Centre Coordinator
BUDGET & EXPENDITURE
From April - September 2009
|
Code |
Detail |
Budget |
Actual Expenses Apr - Sep |
Balance |
Percent (%) |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
Personnel |
|
|
|
|
|
|
|
|
|
|
|
|
1-1 |
|
Centre Coordinator |
4,800.00 |
2,000.00 |
2,800.00 |
41.66% |
400.00 |
400.00 |
400.00 |
400.00 |
400.00 |
|
2,000.00 |
|
1-2 |
|
Project Office |
2,400.00 |
1,150.00 |
1,250.00 |
47.91% |
350.00 |
200.00 |
200.00 |
200.00 |
200.00 |
|
1,150.00 |
|
1-3 |
|
Accountant/Administration |
2,220.00 |
1,025.00 |
1,195.00 |
46.17 |
285.00 |
185.00 |
185.00 |
185.00 |
185.00 |
|
1,025.00 |
|
1-4 |
|
Guard/Cleaner |
960.00 |
400.00 |
560.00 |
41.66 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
|
400.00 |
|
|
|
Total Personnel |
10,380.00 |
4,575.00 |
5,805.00 |
44.07% |
1,115.00 |
865.00 |
865.00 |
865.00 |
865.00 |
|
4,575.00 |
|
2 |
|
Office Cost |
|
|
|
|
|
|
|
|
|
|
|
|
2-1 |
|
Centre Rental |
3,000.00 |
1,590.00 |
1,410.00 |
53.00% |
390.00 |
300.00 |
300.00 |
300.00 |
300.00 |
|
1,590.00 |
|
2-2 |
|
Communication Cost (Tel/Internet/E-mail) |
600.00 |
226.44 |
373.56 |
37.74% |
43.74 |
44.29 |
37.99 |
48.35 |
52.07 |
|
226.44 |
|
2-3 |
|
Office Supplies |
300.00 |
316.70 |
-16.70 |
105.56% |
19.00 |
10.10 |
27.25 |
260.35 |
0.00 |
|
316.70 |
|
2-4 |
|
Maintenance |
240.00 |
292.75 |
-52.75 |
121.97% |
143.75 |
58.50 |
90.50 |
0.00 |
0.00 |
|
292.75 |
|
2-5 |
|
Utilities (Water/Electri.) |
960.00 |
343.14 |
616.86 |
35.74% |
27.80 |
85.40 |
27.85 |
155.49 |
46.60 |
|
343.14 |
|
2-6 |
|
Bank Charges |
30.00 |
7.24 |
22.76 |
24.13% |
1.04 |
1.20 |
5.00 |
0.00 |
0.00 |
|
7.24 |
|
2-7 |
|
Financial Audit |
0.00 |
0.00 |
0.00 |
0.00% |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
0.00 |
|
2-8 |
|
Insurance for Cyclo Centre Staff |
0.00 |
0.00 |
0.00 |
0.00% |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
0.00 |
|
2-9 |
|
Cost of T-shirt for sale |
0.00 |
0.00 |
0.00 |
0.00% |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
0.00 |
|
|
|
Total Office Cost |
5,130.00 |
2,776.27 |
2,353.73 |
54.11% |
625.33 |
499.49 |
488.59 |
764.19 |
398.67 |
|
2,776.27 |
|
3 |
|
Project |
|
|
|
|
|
|
|
|
|
|
|
|
3-1 |
|
Anti-Smoke Programme |
|
|
|
|
|
|
|
|
|
|
|
|
|
3-1-1 |
Tobacco Awareness Session |
2,800.00 |
1,859.38 |
940.62 |
66.40% |
960.00 |
444.13 |
0.00 |
0.00 |
455.25 |
|
1,859.38 |
|
|
3-1-2 |
Counseling Sessions |
1,270.00 |
1,003.00 |
270.37 |
78.97% |
0.00 |
895.75 |
6.00 |
50.63 |
51.25 |
|
1,003.63 |
|
|
3-1-3 |
Paint for Cyclos |
400.00 |
153.71 |
246.29 |
38.42% |
0.00 |
0.00 |
73.53 |
43.18 |
37.00 |
|
153.71 |
|
|
|
Sub-total |
4,474.00 |
3,016.72 |
1,457.28 |
67.42% |
960.00 |
1,339.88 |
79.53 |
93.81 |
543.50 |
|
3,016.72 |
|
3-2 |
|
Health Care/Personal Hygiene Programme |
|
|
|
|
|
|
|
|
|
|
|
|
|
3-2-1 |
Washing Facilitator & haircuts |
480.00 |
224.92 |
255.08 |
46.85% |
0.75 |
155.48 |
15.13 |
14.26 |
39.30 |
|
224.92 |
|
|
3-2-2 |
Medical Supplies |
600.00 |
238.85 |
361.15 |
39.80% |
54.20 |
50.60 |
115.30 |
0.00 |
18.75 |
|
238.85 |
|
|
3-2-3 |
Centre Doctor |
720.00 |
300.00 |
420.00 |
41.66% |
60.00 |
60.00 |
60.00 |
60.00 |
60.00 |
|
300.00 |
|
|
3-2-4 |
Eye Checks & Treatment |
0.00 |
0.00 |
0.00 |
0.00% |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
0.00 |
|
|
|
Sub-total |
1,800.00 |
763.77 |
1,036.23 |
42.43% |
114.95 |
266.08 |
190.43 |
74.26 |
118.05 |
|
763.77 |
|
3-3 |
|
Communication & Information Programme |
|
|
|
|
|
|
|
|
|
|
|
|
|
3-3-1 |
Monthly Forum Meeting |
600.00 |
54.28 |
545.72 |
9.04% |
1.50 |
1.25 |
14.98 |
7.25 |
29.30 |
|
54.28 |
|
|
|
Sub-total |
600.00 |
54.28 |
545.72 |
9.04% |
1.50 |
1.25 |
14.98 |
7.25 |
29.30 |
|
54.28 |
|
3-4 |
|
Tourist Booking Services |
|
|
|
|
|
|
|
|
|
|
|
|
|
3-4-1 |
Computer System |
800.00 |
125.00 |
675.00 |
15.62% |
0.00 |
11.50 |
20.00 |
68.50 |
25.00 |
|
125.00 |
|
|
3-4-2 |
Support Transport/Mobile Phone Support |
720.00 |
300.00 |
420.00 |
41.66% |
60.00 |
60.00 |
60.00 |
60.00 |
60.00 |
|
300.00 |
|
|
3-4-3 |
Office Supplies |
300.00 |
372.38 |
-72.38 |
124.12% |
0.00 |
0.00 |
0.00 |
372.38 |
0.00 |
|
372.38 |
|
|
3-4-4 |
Laundry |
1,200.00 |
647.62 |
552.38 |
53.96% |
89.17 |
103.17 |
93.40 |
152.20 |
209.68 |
|
647.62 |
|
|
|
Sub-total |
3,020.00 |
1,445.00 |
1,575.00 |
47.84% |
149.17 |
174.67 |
173.40 |
653.08 |
294.68 |
|
1,445.00 |
|
|
|
TOTAL PROJECT |
9,894.00 |
5,279.77 |
4,614.23 |
53.36% |
1,225.62 |
1,781.88 |
458.34 |
828.40 |
985.53 |
|
5,279.77 |
|
|
|
GRAND TOTAL |
25,404.00 |
12,631.04 |
12,772.96 |
49.72% |
2,965.95 |
3,146.37 |
1,811.93 |
2,457.59 |
2,249.20 |
|
12,631.04 |
Prepared By: Ms. Pal Holly, Accountant/Administrator
Approved By: Mrs, Nouv Sarany, Cyclo Centre Coordinator