| Other Opex Details | |||||||||||||||||||||||||||
| 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | ||||||||||||||||||
| Account Code | January | February | March | April | May | June | July | August | September | October | November | December | |||||||||||||||
| 501-703 | Purchased Water | Min. | Price | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost | Volume | Cost |
| Mactan Rock Industrial Inc. | 5,000 | 26.72 | 164,300 | 4,390,096.00 | 148,400 | 3,965,248.00 | 164,300 | 4,390,096.00 | 159,000 | 4,248,480.00 | 164,300 | 4,390,096.00 | 159,000 | 4,248,480.00 | 164,300 | 4,390,096.00 | 164,300 | 4,390,096.00 | 159,000 | 4,248,480.00 | 164,300 | 4,390,096.00 | 159,000 | 4,248,480.00 | 164,300 | 4,390,096.00 | |
| Foremost Utilities Incorporated | 4,364 | 19.34 | 143,389 | 2,773,140.97 | 129,513 | 2,504,772.49 | 143,389 | 2,773,140.97 | 138,763 | 2,683,684.81 | 143,389 | 2,773,140.97 | 138,763 | 2,683,684.81 | 143,389 | 2,773,140.97 | 143,389 | 2,773,140.97 | 138,763 | 2,683,684.81 | 143,389 | 2,773,140.97 | 138,763 | 2,683,684.81 | 143,389 | 2,773,140.97 | |
| Abejo Waters Corporation (Talisay) | 4,545 | 18.18 | 149,363 | 2,715,428.19 | 134,909 | 2,452,644.82 | 149,363 | 2,715,428.19 | 144,545 | 2,627,833.74 | 149,363 | 2,715,428.19 | 144,545 | 2,627,833.74 | 149,363 | 2,715,428.19 | 149,363 | 2,715,428.19 | 144,545 | 2,627,833.74 | 149,363 | 2,715,428.19 | 144,545 | 2,627,833.74 | 149,363 | 2,715,428.19 | |
| Abejo Waters Corporation (Consolacion) | 7,000 | 14.08 | 230,020 | 3,238,681.60 | 207,760 | 2,925,260.80 | 230,020 | 3,238,681.60 | 222,600 | 3,134,208.00 | 230,020 | 3,238,681.60 | 222,600 | 3,134,208.00 | 230,020 | 3,238,681.60 | 230,020 | 3,238,681.60 | 222,600 | 3,134,208.00 | 230,020 | 3,238,681.60 | 222,600 | 3,134,208.00 | 230,020 | 3,238,681.60 | |
| Abejo Waters Corporation (Apas) | 2,000 | 14.78 | 65,720 | 971,341.60 | 59,360 | 877,340.80 | 65,720 | 971,341.60 | 63,600 | 940,008.00 | 65,720 | 971,341.60 | 63,600 | 940,008.00 | 65,720 | 971,341.60 | 65,720 | 971,341.60 | 63,600 | 940,008.00 | 65,720 | 971,341.60 | 63,600 | 940,008.00 | 65,720 | 971,341.60 | |
| Abejo Waters Corporation (BC Homes) | 2,000 | 16.48 | 65,720 | 1,083,065.60 | 59,360 | 978,252.80 | 65,720 | 1,083,065.60 | 63,600 | 1,048,128.00 | 65,720 | 1,083,065.60 | 63,600 | 1,048,128.00 | 65,720 | 1,083,065.60 | 65,720 | 1,083,065.60 | 63,600 | 1,048,128.00 | 65,720 | 1,083,065.60 | 63,600 | 1,048,128.00 | 65,720 | 1,083,065.60 | |
| Abejo Waters Corporation (Guadalajara) | 2,250 | 14.48 | 73,935 | 1,070,578.80 | 66,780 | 966,974.40 | 73,935 | 1,070,578.80 | 71,550 | 1,036,044.00 | 73,935 | 1,070,578.80 | 71,550 | 1,036,044.00 | 73,935 | 1,070,578.80 | 73,935 | 1,070,578.80 | 71,550 | 1,036,044.00 | 73,935 | 1,070,578.80 | 71,550 | 1,036,044.00 | 73,935 | 1,070,578.80 | |
| Abejo Waters Corporation (Kabajar) | 2,250 | 14.48 | 73,935 | 1,070,578.80 | 66,780 | 966,974.40 | 73,935 | 1,070,578.80 | 71,550 | 1,036,044.00 | 73,935 | 1,070,578.80 | 71,550 | 1,036,044.00 | 73,935 | 1,070,578.80 | 73,935 | 1,070,578.80 | 71,550 | 1,036,044.00 | 73,935 | 1,070,578.80 | 71,550 | 1,036,044.00 | 73,935 | 1,070,578.80 | |
| Pilipinas Water (Banawa) | 1,500 | 14.08 | 49,290 | 694,003.20 | 44,520 | 626,841.60 | 49,290 | 694,003.20 | 47,700 | 671,616.00 | 49,290 | 694,003.20 | 47,700 | 671,616.00 | 49,290 | 694,003.20 | 49,290 | 694,003.20 | 47,700 | 671,616.00 | 49,290 | 694,003.20 | 47,700 | 671,616.00 | 49,290 | 694,003.20 | |
| Pilipinas Water (Talamban) | 3,592 | 14.21 | 118,027 | 1,677,166.59 | 106,605 | 1,514,860.14 | 118,027 | 1,677,166.59 | 114,220 | 1,623,064.44 | 118,027 | 1,677,166.59 | 114,220 | 1,623,064.44 | 118,027 | 1,677,166.59 | 118,027 | 1,677,166.59 | 114,220 | 1,623,064.44 | 118,027 | 1,677,166.59 | 114,220 | 1,623,064.44 | 118,027 | 1,677,166.59 | |
| Purchased Water - Cabancalan | 5,000 | 14.78 | 0 | - | - | - | - | - | - | - | - | - | 164,300 | 2,428,354.00 | 159,000 | 2,350,020.00 | 164,300 | 2,428,354.00 | |||||||||
| Purchased Water - Northern Cebu Bulk Water | 18,000 | 24.59 | 0 | - | - | - | - | - | - | 574,740 | 14,132,856.60 | 586,121 | 14,412,710.64 | 567,000 | 13,942,530.00 | 585,900 | 14,407,281.00 | 572,400 | 14,075,316.00 | 530,480 | 13,044,493.20 | ||||||
| Purchased Water - Pit-os Talamban | 4,500 | 15.68 | 0 | - | - | - | - | - | - | 147,870 | 2,318,601.60 | 147,870 | 2,318,601.60 | 143,100 | 2,243,808.00 | 147,870 | 2,318,601.60 | 143,100 | 2,243,808.00 | 147,870 | 2,318,601.60 | ||||||
| PCA | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,059.94 | 1,435,060.94 | |||||||||||||||
| PWA | (3,281,865.03) | (3,281,865.03) | (3,281,865.03) | (3,281,865.03) | (3,281,865.03) | (3,281,865.03) | (3,281,865.03) | (3,281,865.03) | (3,281,865.03) | (3,281,865.03) | (3,547,671.03) | (3,556,532.21) | |||||||||||||||
| 1,133,700 | 17,837,276.26 | 1,023,986.71 | 15,932,365.16 | 1,133,699.57 | 17,837,276.26 | 1,097,128.62 | 17,202,305.90 | 1,133,699.57 | 17,837,276.26 | 1,097,128.62 | 17,202,305.90 | 1,856,309.57 | 34,288,734.46 | 1,867,690.38 | 34,568,588.50 | 1,807,228.62 | 33,388,643.90 | 2,031,769.57 | 36,991,512.86 | 1,971,628.62 | 35,605,643.90 | 1,976,349.17 | 35,354,058.88 | ||||
| 0.00 | 0.00 | 0.00 | (0.00) | 0.00 | (0.00) | 0.00 | 0.00 | (0.00) | 0.00 | (0.00) | 0.00 | ||||||||||||||||
| (1,323,087.90) | (1,323,087.90) | (1,323,087.90) | (1,323,087.90) | (1,323,087.90) | (1,323,087.90) | (808,046.36) | (803,122.51) | (803,217.47) | (738,264.91) | (795,872.97) | (822,486.99) | ||||||||||||||||
| 501-803-01 | Installation and Disconnection Expense - net | January | February | March | April | May | June | July | August | September | October | November | December | ||||||||||||||
| 532 | Salaries & Wages - Basic Pay | 864,841.00 | 864,841.00 | 896,365.00 | 896,322.00 | 896,522.00 | 896,722.00 | 897,405.00 | 897,578.00 | 897,578.00 | 897,786.00 | 897,786.00 | 897,786.00 | ||||||||||||||
| Salaries & Wages - OT | 35,004.55 | 35,004.55 | 36,580.75 | 36,578.60 | 36,588.60 | 36,598.60 | 36,599.05 | 36,607.70 | 36,607.70 | 36,618.10 | 36,618.10 | 36,618.10 | |||||||||||||||
| Employee Benefits | 203,003.59 | 203,003.59 | 203,003.59 | 203,003.59 | 203,003.59 | 140,260.39 | 140,268.72 | 140,268.72 | 140,268.72 | 140,268.72 | 140,268.72 | 140,268.72 | |||||||||||||||
| Other Employee Benefits | 311,300.00 | 311,300.00 | 313,700.00 | 314,100.00 | 314,100.00 | 314,300.00 | 315,000.00 | 315,300.00 | 315,500.00 | 315,900.00 | 316,100.00 | 316,200.00 | |||||||||||||||
| Office Supplies | 17,584.65 | 11,521.15 | 16,773.15 | 12,332.65 | 16,773.15 | 11,521.15 | 17,584.65 | 11,521.15 | 16,773.15 | 12,332.65 | 16,773.15 | 11,733.55 | |||||||||||||||
| Materials | 1,387,710.37 | 875,798.36 | 879,484.14 | (66,474.24) | (66,474.24) | (66,474.24) | (66,474.24) | (66,474.24) | (66,474.24) | (66,474.24) | (66,474.24) | (1,012,432.66) | |||||||||||||||
| Other Operating Expenses - Others | 355,740.31 | 355,740.31 | 355,740.31 | 355,740.31 | 1,495,105.05 [1] | 355,740.31 | 355,740.31 | 1,810,167.06 | 355,740.31 | 2,009,002.48 | 355,740.31 | 533,240.27 | |||||||||||||||
| Other OPEX - Materials | 3,468.00 | 13,303.66 | 15,225.61 | 11,757.61 | 15,225.61 | 13,303.66 | 3,468.00 | 13,303.66 | 15,225.61 | 11,757.61 | 15,225.61 | 13,303.66 | |||||||||||||||
| 532-A | Salaries & Wages - Basic Pay | 380,859.00 | 380,859.00 | 380,859.00 | 380,859.00 | 380,859.00 | 381,059.00 | 381,059.00 | 381,198.00 | 381,198.00 | 381,198.00 | 381,198.00 | 381,198.00 | ||||||||||||||
| Salaries & Wages - OT | 19,042.95 | 19,042.95 | 19,042.95 | 19,042.95 | 19,042.95 | 19,052.95 | 19,052.95 | 19,059.90 | 19,059.90 | 19,059.90 | 19,059.90 | 19,059.90 | |||||||||||||||
| Employee Benefits | 80,283.70 | 80,283.70 | 80,283.70 | 80,283.70 | 80,283.70 | 60,761.10 | 60,761.10 | 60,761.10 | 60,761.10 | 60,761.10 | 60,761.10 | 60,761.10 | |||||||||||||||
| Other Employee Benefits | 103,900.00 | 103,900.00 | 104,000.00 | 104,000.00 | 104,100.00 | 104,100.00 | 104,200.00 | 104,200.00 | 104,300.00 | 104,700.00 | 104,800.00 | 104,800.00 | |||||||||||||||
| Office Supplies | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | 50,943.10 | |||||||||||||||
| Materials | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,124,903.28 | 5,460,852.72 | |||||||||||||||
| Other Operating Expenses - Others | 102,336.31 | 102,336.35 | 102,336.35 | 102,336.35 | 102,336.35 | 102,336.35 | 102,336.35 | 102,336.35 | 102,336.35 | 741,087.28 | 102,336.35 | 461,936.35 | |||||||||||||||
| Service Connection Costs | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | (5,977,333.37) | |||||||||||||||
| Misc. Revenue | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | (257,600.00) | |||||||||||||||
| 2,805,987.44 | 2,297,847.63 | 2,344,307.56 | 1,390,795.53 | 2,538,378.77 | 1,310,194.28 | 1,307,913.90 | 2,766,740.41 | 1,319,787.61 | 3,604,910.61 | 1,321,106.01 | 1,241,335.44 | ||||||||||||||||
| - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||