|
||||||||||||||||
Tagkawayan, Quezon |
||||||||||||||||
Detailed Income Statement Budget for CY 2016 |
||||||||||||||||
Budget Per Mo. |
Annual Budget |
Actual 9 mos. |
||||||||||||||
INCOME |
||||||||||||||||
639 |
Income from Waterworks System |
1,544,043.75 |
18,528,525.00 |
10,940,298.63 |
||||||||||||
643 |
Sales Revenue |
7,500.00 |
90,000.00 |
61,962.88 |
||||||||||||
648 |
Other Business Income |
41,500.00 |
498,000.00 |
303,511.00 |
||||||||||||
649 |
Fines & Penalties - Business Income |
8,333.33 |
100,000.00 |
276,653.65 |
||||||||||||
664 |
Interest Income |
1,250.00 |
15,000.00 |
8,229.17 |
||||||||||||
Total Income |
1,602,627.08 |
19,231,525.00 |
11,590,655.33 |
|||||||||||||
EXPENSES |
||||||||||||||||
701 |
Salaries & Wages - Regular |
318,250.83 |
3,819,010.00 |
2,568,993.15 |
||||||||||||
711 |
Personnel Economic Relief Allowance (PERA) |
32,000.00 |
384,000.00 |
266,000.00 |
||||||||||||
713 |
Representation Allowance (RA) |
12,500.00 |
150,000.00 |
112,500.00 |
||||||||||||
714 |
Transportation Allowance (TA) |
12,500.00 |
150,000.00 |
112,500.00 |
||||||||||||
715 |
Clothing/Uniform Allowance |
6,666.67 |
80,000.00 |
70,000.00 |
||||||||||||
717 |
Productivity Incentive Allowance |
6,666.67 |
80,000.00 |
28,000.00 |
||||||||||||
719 |
Other Bonuses and Allowances |
27,000.00 |
324,000.00 |
210,600.00 |
||||||||||||
723 |
Overtime & Night Pay |
2,500.00 |
30,000.00 |
8,830.11 |
||||||||||||
724 |
Cash Gift |
6,250.00 |
75,000.00 |
25,000.00 |
||||||||||||
725 |
Year-End Bonus |
24,480.83 |
293,770.00 |
- |
||||||||||||
731 |
Life & Retirement Insurance Contributions |
35,252.50 |
423,030.00 |
251,437.24 |
||||||||||||
732 |
Pag-ibig Contributions |
1,500.00 |
18,000.00 |
12,400.00 |
||||||||||||
733 |
Philhealth Contributions |
3,000.00 |
36,000.00 |
23,312.50 |
||||||||||||
742 |
Terminal Leave Benefits |
31,000.00 |
372,000.00 |
- |
||||||||||||
749 |
Other Personnel Benefits |
66,756.00 |
801,072.00 |
434,499.71 |
||||||||||||
751 |
Traveling Expenses - Local |
12,000.00 |
144,000.00 |
68,314.00 |
||||||||||||
753 |
Training Expenses |
10,000.00 |
120,000.00 |
22,500.00 |
||||||||||||
755 |
Office Supplies Expenses |
10,000.00 |
120,000.00 |
80,777.10 |
||||||||||||
756 |
Accountable Forms Expenses |
3,000.00 |
36,000.00 |
14,687.30 |
||||||||||||
761 |
Gasoline, Oil & Lubricants Expenses |
17,500.00 |
210,000.00 |
47,827.60 |
||||||||||||
765 |
Other Supplies Expenses |
40,000.00 |
480,000.00 |
157,889.25 |
||||||||||||
767 |
Electricity Expenses |
270,000.00 |
3,240,000.00 |
2,404,532.94 |
||||||||||||
768 |
Cooking Gas Expenses |
225.00 |
2,700.00 |
- |
||||||||||||
771 |
Postage & Deliveries |
750.00 |
9,000.00 |
2,295.00 |
||||||||||||
772 |
Telephone Expenses - Landline |
2,000.00 |
24,000.00 |
11,729.02 |
||||||||||||
773 |
Telephone Expenses - Mobile |
2,500.00 |
30,000.00 |
20,100.00 |
||||||||||||
774 |
Internet Expenses |
2,000.00 |
24,000.00 |
8,027.64 |
||||||||||||
775 |
Cable, Satellite, Telegraph & Radio Expenses |
180.00 |
2,160.00 |
1,620.00 |
||||||||||||
778 |
Membership Dues & Contribution to Organizations |
2,000.00 |
24,000.00 |
3,234.00 |
||||||||||||
779 |
Awards and Indemnities |
4,200.00 |
50,400.00 |
- |
||||||||||||
780 |
Advertising Expenses |
6,000.00 |
72,000.00 |
- |
||||||||||||
781 |
Printing & Binding Expenses |
500.00 |
6,000.00 |
2,374.00 |
||||||||||||
783 |
Representation Expenses |
15,000.00 |
180,000.00 |
39,736.00 |
||||||||||||
784 |
Transportation & Delivery Expenses |
9,000.00 |
108,000.00 |
94,830.00 |
||||||||||||
786 |
Subscription Expenses |
600.00 |
7,200.00 |
4,725.00 |
||||||||||||
791 |
Legal Services |
3,000.00 |
36,000.00 |
3,660.00 |
||||||||||||
792 |
Auditing Services |
7,500.00 |
90,000.00 |
- |
||||||||||||
793 |
Consultancy Services |
3,750.00 |
45,000.00 |
- |
||||||||||||
795 |
General Services |
7,000.00 |
84,000.00 |
17,661.62 |
||||||||||||
799 |
Other Professional Services |
5,000.00 |
60,000.00 |
51,460.80 |
||||||||||||
800 |
Board Members' Allowances & Other Benefits |
14,000.00 |
168,000.00 |
66,240.00 |
||||||||||||
808 |
Repairs & Maint. - Water System & Structures |
75,000.00 |
900,000.00 |
570,635.52 |
||||||||||||
811 |
Repairs & Maint. - Office Buildings |
3,000.00 |
36,000.00 |
29,066.50 |
||||||||||||
821 |
Repairs & Maint. - Office Equipment |
1,000.00 |
12,000.00 |
10,652.08 |
||||||||||||
822 |
Repairs & Maint. - Furniture and Fixtures |
2,500.00 |
30,000.00 |
11,130.00 |
||||||||||||
823 |
Repairs & Maint. - IT Equipment & Software |
1,000.00 |
12,000.00 |
2,750.00 |
||||||||||||
826 |
Repairs & Maint. - Machinery |
5,000.00 |
60,000.00 |
20,918.00 |
||||||||||||
829 |
Repairs & Maint. - Communication Equipment |
50.00 |
600.00 |
- |
||||||||||||
841 |
Repairs & Maint. - Motor Vehicles |
2,500.00 |
30,000.00 |
28,198.00 |
||||||||||||
850 |
Repairs & Maint. - Other Property, Plant & Equip. |
65.00 |
780.00 |
420.00 |
||||||||||||
861 |
Repairs & Maint. - Reforestation - Upland |
2,500.00 |
30,000.00 |
- |
||||||||||||
878 |
Donations |
1,750.00 |
21,000.00 |
- |
||||||||||||
891 |
Taxes, Duties & Licenses |
30,000.00 |
360,000.00 |
235,137.67 |
||||||||||||
892 |
Fidelity Bond Premiums |
3,500.00 |
42,000.00 |
69,375.00 |
||||||||||||
893 |
Insurance Expenses |
3,000.00 |
36,000.00 |
30,657.39 |
||||||||||||
901 |
Bad Debts Expenses |
1,750.00 |
21,000.00 |
- |
||||||||||||
908 |
Depreciation - Water System & Structures |
85,000.00 |
1,020,000.00 |
735,154.13 |
||||||||||||
911 |
Depreciation - Office Buildings |
8,250.00 |
99,000.00 |
63,645.39 |
||||||||||||
921 |
Depreciation - Office Equipment |
2,250.00 |
27,000.00 |
9,596.76 |
||||||||||||
922 |
Depreciation - Furniture & Fixtures |
1,500.00 |
18,000.00 |
13,359.10 |
||||||||||||
923 |
Depreciation - IT Equipment |
1,500.00 |
18,000.00 |
9,502.62 |
||||||||||||
926 |
Depreciation - Machinery |
30,000.00 |
360,000.00 |
246,847.27 |
||||||||||||
929 |
Depreciation - Communication Equipment |
28.00 |
336.00 |
- |
||||||||||||
941 |
Depreciation- Motor Vehicles |
3,000.00 |
36,000.00 |
26,460.00 |
||||||||||||
950 |
Depreciation - Other Property, Plant & Equip. |
500.00 |
6,000.00 |
4,420.86 |
||||||||||||
951 |
Obsolescence-IT Software |
450.00 |
5,400.00 |
- |
||||||||||||
961 |
Loss of Assets |
450.00 |
5,400.00 |
- |
||||||||||||
969 |
Other Maintenance & Operating Expenses |
15,000.00 |
180,000.00 |
88,910.34 |
||||||||||||
971 |
Bank Charges |
266.67 |
3,200.00 |
1,240.00 |
||||||||||||
974 |
Documentary Stamp Expenses |
250.00 |
3,000.00 |
246.09 |
||||||||||||
975 |
Interest Expenses |
75,000.00 |
900,000.00 |
297,733.00 |
||||||||||||
Total Expenses |
1,390,088.17 |
# |
16,681,058.00 |
9,754,349.70 |
||||||||||||
Add/(Less): Gain/Loss on Sale of Disposed Assets |
- |
|||||||||||||||
Add/(Less): Prior Years' Adjustments |
(5,656.04) |
|||||||||||||||
RETAINED EARNINGS |
212,538.92 |
2,550,467.00 |
1,830,649.59 |
|||||||||||||
Prepared by: |
Approved by: |
|||||||||||||||
YOLANDA C. DAGOS |
CIRILO T. FRONDOSO |
|||||||||||||||
Div. Manager C, Admin. & Fin. |
General Manager |
|||||||||||||||
Noted By: |
||||||||||||||||
JOSEPH A. PUA |
||||||||||||||||
Chairman of the Board |