Get documents about "csdwid budget report byjun30 2011
Document Sample
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.
