csdwid budget report byjun30 2011 by 0Ot0AvJ

VIEWS: 0 PAGES: 11

									CSDWID Ongoing Budget Report 2011-2012
G. Perkins
29-Mar-11

                                                                                            Budget Worksheet, 2011 - 2012

                                                                                                           Expenses

                                             Projects




                                                                                                                                                                           Publishing & County Fees &




                                                                                                                                                                                                                       Sales Tax on Water Sales
                                                                                 Maintenance & Repairs &




                                                                                                                                                Financial Administration
                                                                                                                          System Management
                                               Mclouth's Lane




                                                                                                                                                                           Website Costs
                                                                                 Water Testing
                                                                Kizzar Project




                                                                                                                                                                                                                                                  Emergencies
                               Rogers Lane




                                                                                                                                                                                                          Insurance
                 New Well




                                                                                                              Utilities
2011-2012
Planned                     35000            6000                                16000                      9000 17000                        9000                           2000                       3000          6300 20000

 Accrual Jul 1
    2010 thru:
     31-Jul-11
    31-Aug-11
    30-Sep-11
     31-Oct-11
    30-Nov-11
    31-Dec-11
    31-Jan-12
    29-Feb-12
    31-Mar-12
     30-Apr-12
    31-May-12
    30-Jun-12
    2011-2012
  budgeted vs
       actual



Category Assignments 2010-2011:
                                       New Well                                                            Any expenditure related to installing the new well and its realated b
                                   Rogers Lane                                                             Any expenditure related to this project including engineering, easem
                                Mclouth's Lane                                                             Any expenditure related to this project including engineering, easem
                                  Kizzar Project                                                           Any expenditure related to this project including engineering, easem
       Maintenance & Repairs and water testing                                                             Ongoing maintenance and repairs not related to projects. Includes
                                        Utilities                                                          Includes Electricity
                          System Management                                                                This is Rob's Management fee
                       Financial Administration                                                            This is Stephanie's administration fee
 Publishing and County Fees and Website costs                                                              This includes publishing fees, country assessments (fees) and web
                                      Insurance                                                            This is our insurance policy
                      Sales Tax on Water Sales                                                             This is the sales tax we pay for customer water sales. It does not i
                                   Emergencies                                                             Includes everything not foreseen in the planned budget
             Total Expenses Including Projects                                                             Sum of all expenses including projects. This is a summation, no ne
       Gross Water Sales   Includes water bills, deposits, (refunds), etc.
Checking Account Balance   Current checking account balance
                                                                    Checking Account Balance
                 Total Expenses (including




                                                Gross Water Sales
                 projects)




               123300                        87000




                                     0
                                     0
                                     0
                                     0
                                     0
                                     0
                                     0
                                     0
                                     0
                                     0




ng the new well and its realated buildings and getting it going. This includes Labor, Materials, Water testing, Fees, etc.
oject including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
oject including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
oject including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
s not related to projects. Includes all labor, materials, water testing and other fees not related to projects



untry assessments (fees) and website creation/maintenance

ustomer water sales. It does not include sales tax we pay for purchase of materials, etc.
 in the planned budget
ojects. This is a summation, no need to fill-in.
bor, Materials, Water testing, Fees, etc.
terials, testing, etc.
terials, testing, etc.
terials, testing, etc.
es not related to projects
CSDWID Ongoing Budget Report 2010-2011
G. Perkins
30-Mar-11

                                                                                                           Budget Worksheet, 2010 - 2011

                                                                                                                             Expenses

                                               Projects




                                                                                                                                                                                                Publishing & County Fees &




                                                                                                                                                                                                                                                                                                                                                 Checking Account Balance
                                                                                                                                                                                                                                                                                        Total Expenses (including
                                                                                                                                                                                                                                             Sales Tax on Water Sales
                                                                                                   Maintenance & Repairs &




                                                                                                                                                                     Financial Administration
                                                                                                                                               System Management




                                                                                                                                                                                                                                                                                                                       Gross Water Sales
                                                 Mclouth's Lane




                                                                                                                                                                                                Website Costs
                                                                                                   Water Testing
                                                                    Kizzar Project




                                                                                                                                                                                                                                                                        Emergencies
                                 Rogers Lane




                                                                                     TBD Project




                                                                                                                                                                                                                               Insurance




                                                                                                                                                                                                                                                                                        projects)
                  New Well




                                                                                                                                 Utilities
2010-2011
Planned                      35000             6000                                                16000                       9000 17000                          9000                          2000                        3000          6300                                       103300                        87000

Accrual Jul 1
   2010 thru:
     31-Jul-10
    31-Aug-10
    30-Sep-10    640                                              4100                              9001                       3593          6196                  3306                                275                                 1752                                        28863                        26169
    31-Oct-10    846                                              4490                              8861                       3593          7890                  3838                                352                                 2240                                        32110                        34661
    30-Nov-10    846                                              4490                             10099                       4364          9584                  4549                                435                   2256          2714                                        39337                        42508                  44704.77
    31-Dec-10    846          1438                                4490                             10835                       4859          9584                  4549                                435                   2256          3143                                        42435                        48586                  47800.33
    31-Jan-11    846          4073                                4490                             13334                       5334 13005                          5971                                435                   2256          3527                                        53271                        53510                  41887.28
    28-Feb-11    846          4073              765               4490                             15225                       5911 13005                          5971                                435                   2256          3931                                        56908                        60965                  45665.72
    31-Mar-11    846          4073              765               4490                             15928                       5911 14732                          6682                                436                   2256          4369                                        60488                        67286                  48447.03
    30-Apr-11                                                                                                                                                                                                                                                                                              0
    31-May-11                                                                                                                                                                                                                                                                                              0
   30-Jun-11     846         15000                      0         4490                             21237                       7881 19643                          8909                         581.3                        2256          5825                              0        86669.3                       89715                                                   This line predicted
   2010-2011
 budgeted vs
      actual     846         -20000            -6000              4490                              5237                      -1119          2643 -90.67                                        -1419                        -744 -474.7                                     0        -16631                        2714.7                                                  This line based on predictions of row 24


Category Assignments 2010-2011:
                                          New Well                                                                           Any expenditure related to installing the new well and its realated buildings and getting it going. This includes Labor, Materials, Water testing, Fees, etc.
                                      Rogers Lane                                                                            Any expenditure related to this project including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
                                    Mclouth's Lane                                                                           Any expenditure related to this project including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
                                     Kizzar Project                                                                          Any expenditure related to this project including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
           Maintenance & Repairs and water testing                                                                           Ongoing maintenance and repairs not related to projects. Includes all labor, materials, water testing and other fees not related to projects
                                            Utilities                                                                        Includes Electricity
                              System Management                                                                              This is Rob's Management fee
                           Financial Administration                                                                          This is Stephanie's administration fee
     Publishing and County Fees and Website costs                                                                            This includes publishing fees, country assessments (fees) and website creation/maintenance
                                         Insurance                                                                           This is our insurance policy
                          Sales Tax on Water Sales                                                                           This is the sales tax we pay for customer water sales. It does not include sales tax we pay for purchase of materials, etc.
                                      Emergencies                                                                            Includes everything not foreseen in the planned budget
                  Total Expenses Including Projects                                                                          Sum of all expenses including projects. This is a summation, no need to fill-in.
                                 Gross Water Sales                                                                           Includes water bills, deposits, (refunds), etc.
                         Checking Account Balance                                                                            Current checking account balance
CSDWID Ongoing Budget Report 2009-2010
G. Perkins
22-May-10

                                                                                                                                Budget Worksheet, 2009 - 2010
                                                                                                         Expenses                                                                                                Income and On-hand                            Balance
                                                                              Projects




                                                                                                                                                                                           Total Expenses
                                                                                                                                            Office Supplies




                                                                                                                                                                                                                                              Total Income &
                                                                                                                                            Administration
                                                                                                  Maintenance &




                                                                                                                                            Water Testing




                                                                                                                                                                                                                            previous year
                                                                                                                                            and Fees and




                                                                                                                                                                                                                            balance from
                                                                                                                                                                            Sales Tax on
                                                                                                                               Management
                             Rogers Lane




                                                                                                                                                                                                              Gross Water
                                                                                                                                                                            Water Sales
                                                                                    May Project
                                                                     Unforeseen
                                                       Glory East




                                                                                                                                                                                           (including
                                                                                                                                                                Insurance
                                           Mclouth's




                                                                                                                                                                                                                                                                 Income &
                                                                                                                                                                                                                                                                 Onhand -
                                                                                                                                            Financial
                  New Well




                                                                                                                                                                                           projects)




                                                                                                                                                                                                                                                                 Expense
                                                                                                                                                                                                                            Forward
                                                       Morning




                                                                     Projects




                                                                                                                                                                                                                                              Onhand
                                                                                                  Repairs


                                                                                                                   Utilities

                                                                                                                               System




                                                                                                                                                                                                              Sales
                                           Lane


2009-2010
Planned         8600 12300                 5000        7000           3000                0 14500 12000 25000                                   0    2200     3000          4879              97479          92000               5479        97479                       0



Accrual Jul
1 2010 thru:

   30-Apr-10    8176               0              0            0             0    4396 12797                      7111 14031                7092     2811     2558          4438              63410          72486               5479        77965                 14555
 31MAY2010
  (Projected)   8176               0              0            0             0    4396 14077 7822.1 15434 7801.2 3092.1                                       2558 4881.8                     68238         79734.6              5479       85213.6              16975.6
 31MAY2010
    (Actual)                                                                                                                                                                                           0                         5479                                    0
 31JUN2010
  (Projected)   8600               0              0            0             0    4396 15356 8533.2 16837 8510.4 3373.2                                       2558 5325.6                     73490         86983.2              5479       92462.2              18972.2
 30JUN2010
    (Actual)                                                                                                                                                                                           0                         5479                                    0
  2009-2010
budgeted vs
    current-
  projected           0 12300              5000        7000           3000        -4396 -856.4 3466.8 8162.8                                -8510    -1173     442 -446.6                     23989          5016.8                    0     5016.8              -18972.2



Category Assignments 2009-2010:
                  New Well                                          Any expenditure related to installing the new well and its realated buildings and getting it going. This includes Labor, Materials, Water tes
               Rogers Lane                                          Any expenditure related to this project including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
           McClouth's Lane                                          Any expenditure related to this project including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
         Morning Glory East                                         Any expenditure related to this project including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
         Unforeseen Project                                         Any expenditure related to this project including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
                May Project                                         Any expenditure related to this project including engineering, easements, ADEQ and ofther fees, actual work, materials, testing, etc.
     Maintenance & Repairs                                          Ongoing maintenance and repairs not related to projects. Includes all labor, materials, fees, etc.
                    Utilities                                       Includes electricity, & telephone
       System Management                                            This is Rob's Management fee
 Financial Administration   This is Stephanie's administration fee
Office Supplies and Fees    This includes office supplies, publishing fees, County fees, etc.
               Insurance    This is our insurance policy
Sales Tax on Water Sales    This is the sales tax we pay for customer water sales. It does not include sales tax we pay for purchase of materials, etc.
       Gross Water Sales    Includes water bills, deposits, (refunds), etc.
              Tax Levies    This any tax levied by the county on our behalf
aterials, Water testing, Fees, etc.
, testing, etc.
, testing, etc.
, testing, etc.
, testing, etc.
, testing, etc.

								
To top