Tagkawayan Water District

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