CITY OF SONORA

 

 

 BUDGET WORKSHEET

 

 

 FOR YEAR ENDING SEPTEMBER 30, 2011

 

 

 

  RECAP

                

 

 

 $0.04 TAX INCREASE (.5100)

 

 

2006-07

2007-08

2008-09

 2009-10

 2010-11

 INCREASE

 

 10 -GENERAL FUND

 

 ACTUAL

 ACTUAL 

 ACTUAL 

 AMENDED

 BUDGET

 (DECREASE)

 

 RECAP

 Pg

 AUDITED

 AUDITED

 AUDITED

 BUDGET

 REQUEST

 OVER 2009-10

 COMMENTS

 

 

 

 

 

 

 

 

 

 OPERATING REVENUE

                1

  2,054,954

  2,068,486

  1,797,809

  1,609,850

  1,646,331

            36,481

 

 OPERATING EXPENDITURES

                1

  1,559,435

  1,679,104

  1,670,087

  1,687,620

  1,652,685

          (34,935)

 

 OPERATING SURPLUS (DEFICIT)

 

     495,519

     389,382

     127,722

      (77,770)

        (6,354)

            71,416

 

 CAPITAL OUTLAY EXPENDITURES

                1

     111,207

     103,704

     342,231

         2,000

       73,000

            71,000

 

 SURPLUS BEFORE TRANSFERS

 

     384,312

     285,678

    (214,509)

      (79,770)

      (79,354)

                 416

 

 TRANSFERS IN (OUT)

                1

      (30,085)

      (33,500)

    (108,000)

      (21,000)

       80,062

          101,062

 

 NET SURPLUS (DEFICIT)

 

     354,227

     252,178

    (322,509)

    (100,770)

            708

          101,478

 

 CASH AT 9/30/10

 

 

 

 

 

     947,230

 

 

 PROJECTED CASH 9/30/11

 

 

 

 

 

     947,938

 

 

 

 

 

 

 

 

 

 

 

 

 

2006-07

2007-08

2007-08

2009-10

2010-11

INCREASE

 

 11 -FORFEITED PROPERTY

 

 ACTUAL

 ACTUAL 

 ACTUAL 

 AMENDED

 BUDGET

 (DECREASE)

 

 RECAP

 Pg

 AUDITED

 AUDITED

 AUDITED

 BUDGET

 REQUEST

 OVER 2009-10

 COMMENTS

 

 

 

 

 

 

 

 

 

 OPERATING REVENUE

              17

              40

            621

                 -

            626

         1,115

                 489

 

 OPERATING EXPENDITURES

              17

                 -

                 -

                 -

            626

                 -

               (626)

 

 OPERATING SURPLUS (DEFICIT)

 

              40

            621

                 -

                 -

         1,115

              1,115

 

 TRANSFERS IN (OUT)

              17

        (1,415)

                 -

                 -

                 -

                 -

                     -

 

 NET SURPLUS (DEFICIT)

 

        (1,375)

            621

                 -

                 -

         1,115

              1,115

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2006-07

2007-08

2007-08

2009-10

2010-11

INCREASE

 

 12 -ST MAINT SALES TAX

 

 ACTUAL

 ACTUAL 

 ACTUAL 

 AMENDED

 BUDGET

 (DECREASE)

 

 RECAP

 Pg

 AUDITED

 AUDITED

 AUDITED

 BUDGET

 REQUEST

 OVER 2009-10

 COMMENTS

 

 

 

 

 

 

 

 

 

 OPERATING REVENUE

              19

     151,351

     189,382

     115,684

       80,000

       87,500

              7,500

 

 OPERATING EXPENDITURES

              19

                 -

                 -

                 -

       37,000

       35,000

            (2,000)

 

 OPERATING SURPLUS (DEFICIT)

 

     151,351

     189,382

     115,684

       43,000

       52,500

              9,500

 

   CAPITAL OUTLAY EXPENDITURES

              19

                 -

                 -

                 -

                 -

     100,000

          100,000

 

 NET SURPLUS (DEFICIT)

 

     151,351

     189,382

     115,684

       43,000

      (47,500)

          (90,500)

 

 CASH AT 9/30/10

 

 

 

 

 

     366,000

 

 

 PROJECTED CASH 9/30/11

 

 

 

 

 

     318,500

 

 

 

 

 

 

 

 

 

 

 

 

 

2006-07

2007-08

2007-08

2009-10

2010-11

INCREASE

 

 20 -AIRPORT FUND

 

 ACTUAL

 ACTUAL 

 ACTUAL 

 AMENDED

 BUDGET

 (DECREASE)

 

 RECAP

 Pg

 AUDITED

 AUDITED

 AUDITED

 BUDGET

 REQUEST

 OVER 2009-10

 COMMENTS

 

 

 

 

 

 

 

 

 

 OPERATING REVENUE

              21

       67,811

     102,120

     101,261

       46,850

     148,862

          102,012

 

 OPERATING EXPENDITURES

              21

     155,185

     172,935

     132,283

     121,960

     124,800

              2,840

 

 OPERATING SURPLUS (DEFICIT)

 

      (87,374)

      (70,815)

      (31,022)

      (75,110)

       24,062

            99,172

 

 TRANSFERS IN (OUT)

              21

       31,500

       33,500

     108,000

       21,000

       24,938

              3,938

 

 NET SURPLUS (DEFICIT) 

 

      (55,874)

      (37,315)

       76,978

      (54,110)

       49,000

          103,110

 

 OTHER CASH FLOW SOURCES (USES)

              21

       55,568

       47,253

       48,513

       53,000

      (49,000)

        (102,000)

 

 NET CASH FLOW

 

           (306)

         9,938

     125,491

        (1,110)

                 -

              1,110

 

 CASH AT 9/30/10

 

 

 

 

 

            890

 

 

 PROJECTED CASH 9/30/11

 

 

 

 

 

            890

 

 

 

 

 

 

 

 

 

 

 

 

 

2006-07

2007-08

2007-08

2009-10

2010-11

INCREASE

 

 30 -WATER FUND

 

 ACTUAL

 ACTUAL 

 ACTUAL 

 AMENDED

 BUDGET

 (DECREASE)

 

 RECAP

 Pg

 AUDITED

 AUDITED

 AUDITED

 BUDGET

 REQUEST

 OVER 2009-10

 COMMENTS

 

 

 

 

 

 

 

 

 

 OPERATING REVENUE

              25

     707,321

     829,408

     904,147

     885,710

     939,000

            53,290

 

 OPERATING EXPENDITURES

              25

     553,189

     565,856

     644,061

     676,780

     643,497

          (33,283)

 

 OPERATING SURPLUS (DEFICIT)

 

     154,132

     263,552

     260,086

     208,930

     295,503

            86,573

 

 TRANSFERS IN (OUT)

              25

        (3,920)

                 -

                 -

                 -

    (111,000)

        (111,000)

 

 NET SURPLUS (DEFICIT) 

 

     150,212

     263,552

     260,086

     208,930

     184,503

          (24,427)

 

 OTHER CASH FLOW SOURCES (USES)

              25

                 -

           (700)

     114,704

      (83,210)

    (112,300)

          (29,090)

 

 NET CASH FLOW

 

     150,212

     262,852

     374,790

     125,720

       72,203

          (53,517)

 

 CASH AT 9/30/10

 

 

 

 

 

  1,682,720

 

 

 PROJECTED CASH 9/30/11

 

 

 

 

 

  1,754,923

 

 

 

 

 

 

 

 

 

 

 

 

 

2006-07

2007-08

2007-08

2009-10

2010-11

INCREASE

 

 40 -SEWER FUND

 

 ACTUAL

 ACTUAL 

 ACTUAL 

 AMENDED

 BUDGET

 (DECREASE)

 

 RECAP

 Pg

 AUDITED

 AUDITED

 AUDITED

 BUDGET

 REQUEST

 OVER 2009-10

 COMMENTS

 

 

 

 

 

 

 

 

 

 OPERATING REVENUE

              31

     653,668

     669,581

     728,772

     751,500

     769,600

            18,100

 

 OPERATING EXPENDITURES

              31

     620,861

     535,907

     652,035

     532,130

     729,651

          197,521

 

 OPERATING SURPLUS (DEFICIT)

 

       32,807

     133,674

       76,737

     219,370

       39,949

        (179,421)

 

 TRANSFERS IN (OUT)

              31

         3,920

                 -

                 -

                 -

     111,000

          111,000

 

 NET SURPLUS (DEFICIT) 

 

       36,727

     133,674

       76,737

     219,370

     150,949

          (68,421)

 

 OTHER CASH FLOW SOURCES (USES)

              31

                 -

           (500)

    (116,201)

    (320,000)

    (150,000)

          170,000

 

 NET CASH FLOW

 

       36,727

     133,174

      (39,464)

    (100,630)

            949

          101,579

 

 CASH AT 9/30/10

 

 

 

 

 

       55,370

 

 

 PROJECTED CASH 9/30/11

 

 

 

 

 

       56,319

 

 

 

 

 

 

 

 

 

 

 

 

 

2006-07

2007-08

2007-08

2009-10

2010-11

INCREASE

 

 50 -SANITATION FUND

 

 ACTUAL

 ACTUAL 

 ACTUAL 

 AMENDED

 BUDGET

 (DECREASE)

 

 RECAP

 Pg

 AUDITED

 AUDITED

 AUDITED

 BUDGET

 REQUEST

 OVER 2009-10

 COMMENTS

 

 

 

 

 

 

 

 

 

 OPERATING REVENUE

              36

     488,925

     535,156

     557,222

     532,500

     531,000

            (1,500)

 

 OPERATING EXPENDITURES

              36

     458,338

     500,594

     681,420

     597,325

     522,675

          (74,650)

 

 OPERATING SURPLUS (DEFICIT)

 

       30,587

       34,562

    (124,198)

      (64,825)

         8,325

            73,150

 

 TRANSFERS IN (OUT)

              36

                 -

                 -

                 -

                 -

    (105,000)

        (105,000)

 

 NET SURPLUS (DEFICIT) 

 

       30,587

       34,562

    (124,198)

      (64,825)

      (96,675)

          (31,850)

 

 OTHER CASH FLOW SOURCES (USES)

              36

                 -

                 -

         3,927

         6,200

         6,200

                     -

 

 NET CASH FLOW

 

       30,587

       34,562

    (120,271)

      (58,625)

      (90,475)

          (31,850)

 

 CASH AT 9/30/10

 

 

 

 

 

       96,375

 

 

 PROJECTED CASH 9/30/11

 

 

 

 

 

         5,900