0% found this document useful (0 votes)
10 views12 pages

Utilities Final

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views12 pages

Utilities Final

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

WATER EXPENSE 2024

MONTH AMOUNT
FUND 101 FUND 164 Total
JANUARY - -
FEBRUARY 63,854.85 63,854.85
MARCH 69,145.90 69,145.90
APRIL 72,267.65 72,267.65
MAY 52,379.12 52,379.12
JUNE 46,910.20 46,910.20
JULY 1,402.00 45,315.10 46,717.10
AUGUST 1,720.00 47,327.00 49,047.00
SEPTEMBER 51,679.66 1,625.00 53,304.66
OCTOBER - 58,270.50 58,270.50
NOVEMBER 3,370.00 57,174.55 60,544.55
DECEMBER - 65,991.80 65,991.80

362,729.38 275,703.95 638,433.33


WATER EXPENSES 2024-FUND 101
80,000.00
70,000.00
60,000.00
50,000.00
40,000.00
AMOUNT

30,000.00
20,000.00
10,000.00
-
L
RY RY CH RI AY NE LY ST R
B E OB E
R
BE
R
BE
R
A A AR AP M JU JU U
NU B RU M UG EM CT M
VE ECE
M
JA FE
A PT O
SE NO D

MONTH

Column B Linear (Column B)

WATER 2024-FUND 101 & 164


400,000.00
300,000.00
200,000.00
AMOUNT

100,000.00
-
A RY ARY RCH PRIL AY NE ULY UST BER BER BER BER
A M JU J
NU R U M A G M TO M
AU PTE OC OVE ECE
M
J A F EB E D
S N
MONTH

AMOUNT FUND 101 Linear ( AMOUNT FUND 101)


Linear ( AMOUNT FUND 101) FUND 164
Linear ( FUND 164) Moving average ( FUND 164)
ELECTRICITY EXPENSES
6000000
5000000
4000000
3000000

AMOUNT
2000000
1000000
0
H Y Y H IL
T AR UAR ARC APR MA
ON N U R M
M J A F EB
ELECTRICITY EXPENSE 2024
MONTH AMOUNT M
FUND 101 FUND 164 Total
JANUARY 573,914.45 573,914.45
Column B
FEBRUARY 72,039.24 70,827.09 142,866.33 Linear (Column B)
MARCH 777,119.35 777,119.35 Linear (Column B)
APRIL 615,671.43 163,668.50 779,339.93
MAY 1,464,179.74 480,574.38 1,944,754.12
ELECTRICITY 2024-F
JUNE 55,310.21 35,087.60 90,397.81
JULY 555,417.95 363,479.91 918,897.86 2,000,000.00
1,600,000.00
AUGUST 599,462.24 918,316.83 1,517,779.07
1,200,000.00
SEPTEMBER 38,898.37 122,097.09 160,995.46

AMOUNT
800,000.00
OCTOBER 621,076.37 340,928.19 962,004.56
400,000.00
NOVEMBER 38,731.46 975,032.25 1,013,763.71
-
DECEMBER 0 1,768,516.65 1,768,516.65 RY RY CH RI
L AY
A A AR AP M
NU B RU M
JA FE
5,411,820.81 5,238,528.49 10,650,349.30
MO

AMOUNT FUND 101


ELECTRICITY EXPENSE 2024 FUND 164
MONTH AMOUNT

JANUARY 573,914.45
FEBRUARY 142,866.33 ELECTRICITY EXPE
MARCH 777,119.35 2500000
APRIL 779,339.93
2000000
MAY 1,944,754.12
JUNE 90,397.81 1500000
JULY 918,897.86
AMOUNT

1000000
AUGUST 1,517,779.07
SEPTEMBER 160,995.46 500000
OCTOBER 962,004.56 0
RY RY CH L AY
NOVEMBER 1,013,763.71 RI
A A AR AP M J
DECEMBER 1,768,516.65 NU B RU M
JA FE

MONT
0
RY RY CH L AY
RI
A A AR AP M J
NU B RU M
JA FE

10,650,349.30 MONT
ELECTRICITY EXPENSES FOR 2024-FUND 101
6000000
5000000
4000000
3000000
2000000
1000000
0
H Y Y H IL Y E LY T R R R R
T AR UAR ARC APR MA JUN JU GUS BE OBE BE BE
ON N U R M M T M M
M J A F EB AU PTE OC OVE ECE
SE N D

MONTH ELECTRICITY 20
2,500,000.00
Column B Linear (Column B) 2,000,000.00
Linear (Column B) Linear (Column B)
1,500,000.00
Linear (Column B) Linear (Column B)

AMOUNT
1,000,000.00
500,000.00
ELECTRICITY 2024-FUND 101 & 164 -
L
2,000,000.00 RY RY CH RI AY NE
A A AR AP M JU
1,600,000.00 NU B RU M
JA FE
1,200,000.00
800,000.00 MONTH
400,000.00
- AMOUNT FUND 101 FU
R Y R Y CH PRIL AY NE LY ST ER B E R B E R B E R
UA UA AR A M JU JU GU MB
N BR TO M M
JA
M AU PTE OC OVE ECE
FE SE N D

MONTH

AMOUNT FUND 101 Linear ( AMOUNT FUND 101)


FUND 164 Linear ( FUND 164)

ELECTRICITY EXPENSE 2024


000

000

000

000

000

0
L
RY RY CH RI AY NE LY ST R
B E OB E
R
BE
R
BE
R
A A AR AP M JU JU U
NU RU M UG E M T E M E M
JA FE
B A PT OC OV DEC
SE N
MONTH
0
L
RY RY CH RI AY NE LY ST R
B E OB E
R
BE
R
BE
R
A A AR AP M JU JU U
NU RU M UG E M T E M E M
JA FE
B A PT OC OV DEC
SE N
MONTH
ELECTRICITY 2024
0
0
0
0
0

L
RY RY CH RI AY NE LY ST R
B E OB E
R
BE
R
BE
R
A A AR AP M JU JU U
NU RU M UG E M T E M EM
A
FE
B A PT OC OV DEC
SE N
MONTH

AMOUNT FUND 101 FUND 164 Total


WATER EXPENSE 2024
MONTH AMOUNT
JANUARY 63,748.85 WATER EXPENSE 2024
FEBRUARY 66,142.90 80,000.00
MARCH 28,356.88 70,000.00
60,000.00
APRIL 68,416.65
50,000.00
MAY 49,782.12 40,000.00

AMOUNT
JUNE 46,460.20 30,000.00
JULY 45,315.10 20,000.00
AUGUST 45,930.00 10,000.00
SEPTEMBER 41,561.65 -
L
RY RY CH RI AY NE LY ST BE
R
OCTOBER 55,269.50 A A AR AP M JU JU U B
NU RU M UG E M TO
NOVEMBER 54,685.55 JA F EB A
EP
T OC
S
DECEMBER 57,568.40 MONTH

623,237.80

ELECTRICITY EXPENSE 2024


MONTH AMOUNT
MAIN CAJIDIOCAN SFC ROMBLON ROMBLON-ADMIN
JANUARY
FEBRUARY
MARCH
APRIL
MAY
JUNE
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER

-
R EXPENSE 2024

AY NE LY ST BE
R
BE
R
BE
R
BE
R
M JU JU U
UG E M TO E M
CE
M
A PT OC V
DE
SE NO
MONTH
WATER CONSUMPTION 2024 WATER CONSUMPTION 2024
MONTH AMOUNT
MAIN ROMBLON TOTAL 80,000.00
JANUARY 63,748.85 1,673.00 65,421.85
FEBRUARY 66,142.90 1,601.00 67,743.90 70,000.00
MARCH 28,356.88 1,097.00 29,453.88
APRIL 68,416.65 1,733.00 70,149.65 60,000.00
MAY 49,782.12 1,625.00 51,407.12
JUNE 46,460.20 797.00 47,257.20 50,000.00
JULY 45,315.10 941.00 46,256.10
AUGUST 45,930.00 1,385.00 47,315.00 40,000.00

AMOUNT
SEPTEMBER 41,561.65 2,489.00 44,050.65
OCTOBER 55,269.50 2,081.00 57,350.50 30,000.00
NOVEMBER 54,685.55 1,882.65 56,568.20
DECEMBER 57,568.40 1,289.00 58,857.40 20,000.00
-
623,237.80 18,593.65 641,831.45 10,000.00

CH

NE
Y

RY

ST
AY

LY

VE R
DE BER
R

R
RI
AR

BE

NO B E

BE
JU

GU
M
UA

AR

JU
AP

M
TO
NU

AU
BR

CE
OC
JA

PT
FE

SE
MONTH
Data Provided by: Summary & Graph Prepared by: Checked by:
AMOUNT MAIN ROMBLON

Faith F. Serrano Lotlot A. Sabigan Shiela Buen F. Servañez


AO II ACCOUNTANT II SAO-FINANCE

Bryan F. Dela Vega


ACCTG CLERK
ELECTRICITY CONSUMPTION 2024
MONTH AMOUNT
MAIN ROMBLON CAJIDIOCAN SFC SAN ANDRES CALATRAVA SAN AGUSTIN STA MARIA STA FE AGPUDLOS TOTAL AMOUNT

JANUARY 525,236.32 24,499.43 16,240.24 29,194.84 10,212.71 4,150.59 26,467.50 13,667.39 9,297.87 6,605.07 665,571.96
FEBRUARY 615,753.06 27,567.92 19,501.63 39,705.58 10,205.55 4,153.24 27,567.06 11,490.27 9,761.96 11,413.08 777,119.35
MARCH 615,261.39 26,565.97 22,370.77 35,460.59 10,709.70 3,813.84 30,843.86 12,584.92 9,094.50 12,634.55 779,340.09
APRIL 739,738.97 31,527.36 38,078.67 47,441.50 12,689.32 4,261.82 37,076.75 13,208.23 11,527.79 14,261.88 949,812.29
MAY 888,085.77 77,244.86 35,087.60 55,310.21 13,642.40 4,598.71 48,371.49 13,326.34 13,554.39 14,722.28 1,163,944.05
JUNE 645,387.88 38,439.06 17,835.61 46,522.43 11,034.11 3,436.95 46,503.80 10,117.34 9,535.71 10,442.50 839,255.39
JULY 615,686.69 24,143.52 13,782.27 31,116.90 10,715.38 3,858.17 38,570.11 9,300.66 4,365.38 14,112.22 765,651.30
AUGUST 862,509.01 42,970.89 17,636.44 38,898.37 14,985.49 6,243.99 51,154.49 12,108.03 9,527.10 19,035.05 1,075,068.86
SEPTEMBER 752,801.20 46,063.10 24,528.74 38,731.46 15,893.25 6,579.72 47,831.16 13,040.50 11,071.49 18,950.38 975,491.00
OCTOBER 764,426.79 36,556.76 23,739.26 38,805.44 16,520.31 9,097.97 53,993.90 12,955.12 12,740.40 25,307.89 994,143.84
NOVEMBER 750,595.16 43,158.76 25,797.03 36,674.41 15,083.15 5,639.83 54,919.34 14,055.29 12,677.72 21,185.77 979,786.46
DECEMBER 625,558.43 22,064.71 26,932.93 28,150.21 14,215.82 4,248.98 51,582.62 15,330.69 11,650.78 22,879.35 822,614.52
-
8,401,040.67 440,802.34 281,531.19 466,011.94 155,907.19 60,083.81 514,882.08 151,184.78 124,805.09 191,550.02 10,787,799.11

ELECTRICITY 2024
1,400,000.00
Data Provided by: Summary & Graph Prepared by: Checked by:

1,200,000.00
Faith F. Serrano Lotlot A. Sabigan Shiela Buen F. Servañez
AO III ACCOUNTANT II SAO-FINANCE
1,000,000.00

AMOUNT
Renalyn D. Formon 800,000.00
Finance Staff

600,000.00

400,000.00

200,000.00

CH

NE
Y

RY

ST
AY

LY

N O B ER

R
R

R
RI
AR

BE

BE

BE
JU

GU
M
UA

AR

JU
AP

M
TO
NU

AU
BR

VE

CE
OC
JA

PT
FE

DE
SE
MONTH

AMOUNT MAIN ROMBLON CAJIDIOCAN


SFC SAN ANDRES CALATRAVA
SAN AGUSTIN STA MARIA STA FE
AGPUDLOS TOTAL AMOUNT
AMOUNT MAIN ROMBLON CAJIDIOCAN
SFC SAN ANDRES CALATRAVA
SAN AGUSTIN STA MARIA STA FE
AGPUDLOS TOTAL AMOUNT

You might also like