February 2010 Park Budget

Feb 28, 10
ASSETS
Current Assets
Checking/Savings
1002 · BofA Operations Chking 0345 79,860.57
1010 · MONEY MARKET - SAVINGS
1016 · Money Mkt. 295,431.97
1020 · Great Western C D 201,313.31
1021 · B of A Risk Free C D 25,588.74
Total 1010 · MONEY MARKET - SAVINGS 522,334.02
1040 · CHANGE FUND ACCOUNTS
1042 · Business Office 500.00
1044 · Activity Office 50.00
1048 · Kitchen 100.00
1055 · Welcome Center Fund-Petty Cash 250.00
Total 1040 · CHANGE FUND ACCOUNTS 900.00
Total Checking/Savings 603,094.59
Accounts Receivable
1200 · Accounts Receivable 16,545.17
Total Accounts Receivable 16,545.17
Total Current Assets 619,639.76
TOTAL ASSETS 619,639.76
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Other Current Liabilities
2100 · Payroll Liabilities
2101 · Federal 941 taxes payable 2,640.28
2103 · Federal Unemployment 196.12
2110 · State AZ - Witholding 59.07
2111 · State AZ Unemployment 441.27
2112 · State AZ Job Training Tax 24.52
Total 2100 · Payroll Liabilities 3,361.26
Total Other Current Liabilities 3,361.26
Total Current Liabilities 3,361.26
Long Term Liabilities
2400 · RESTRICTED LIABILITIES
1012 · 1012 Capital Improvment 148,167.14
1014 · 1014 Contingency Account 77,127.62
1017 · Park Improvements-Comm. Complex 25,066.58
Total 2400 · RESTRICTED LIABILITIES 250,361.34
Total Long Term Liabilities 250,361.34
Total Liabilities 253,722.60
Equity
3000 · Opening Bal Equity 22,608.64
3900 · Retained Earnings -173.95
Net Income 343,482.47
Total Equity 365,917.16
TOTAL LIABILITIES & EQUITY 619,639.76
Jan - Feb 10
Budget
Ordinary Income/Expense
Income
3525 · Operating Cash Carry Over
0.00
22,608.64
4030 · SHAREHOLDER
4032 · Shareholder Asses. 480@$925
441,140.00
444,000.00
4034 · Less Frz. Dues, No Asses.
0.00
-2,860.00
4038 · Transfer to Contingencies
-15,000.00
-15,000.00
4039 · Transfer to Capilal Reserve
-10,000.00
-10,000.00
Total 4030 · SHAREHOLDER
416,140.00
416,140.00
4040 · OPERATIONAL  INCOME
4010 · Activities/Entertainment Inc
3,816.90
7,000.00
4015 · Gate Cards & Mail Keys
700.00
4041 · Rental Income Daily and Weekly
4,671.90
30,000.00
4042 · Rental Income Monthly
13,085.00
4043 · Rental Storage
2,545.00
9,000.00
4044 · Rental Vendor Room
680.00
500.00
4045 · Resale & Vendor Commissions Inc
1,710.10
5,000.00
4046 · Resale - Clickers
128.50
180.00
4050 · Office Income
897.73
3,000.00
4054 · Investment Interest
104.79
4055 · Interest & Late Fees Inc
513.61
2,500.00
4060 · Kitchen Receipts
8,112.23
17,500.00
4065 · Laundry
3,011.50
9,000.00
4070 · Propane Sales
8,384.22
15,000.00
4085 · Transfer/Inspection Fees Inc
1,210.00
2,000.00
4115 · Bingo
367.14
750.00
4155 · Reimbursements to Co-op
1,177.95
2,500.00
4180 · Over/Short Cash
58.59
Total 4040 · OPERATIONAL  INCOME
51,175.16
103,930.00
Total Income
467,315.16
542,678.64
Gross Profit
467,315.16
542,678.64
Expense
6000 · COOP. OPERATIONAL EXPENSES
6005 · Accountant / CPA Fees
0.00
3,000.00
6007 · Administrative committee
22.10
300.00
6010 · Advertising & Marketing
1,338.00
3,000.00
6011 · Ambassadors
35.80
400.00
6012 · Architectural Committee
34.26
1,235.00
6015 · Autos & Mileage Exp
195.04
1,500.00
6020 · Bank Svc/Finance Charges
448.89
2,000.00
6022 · Board/Annual Meetings
720.02
3,000.00
6025 · Fire Department
52.57
3,500.00
6035 · Licenses & Permits
37.04
3,800.00
6045 · Entertainment Exp
819.84
5,000.00
6047 · Finance Committee
0.00
300.00
6050 · Kitchen Supplies/Food Purchases
2,725.03
9,670.00
6055 · Legal / Attorney Fees
770.00
12,000.00
6065 · Miscellaneous Expenses
4.62
608.64
6070 · Payroll Taxes Federal / FICA
1,932.85
9,117.00
6080 · Payroll-Worker Comp Insurance
0.00
2,400.00
6085 · Payroll Taxes-Fed Unemplymt
196.12
553.00
6090 · Payroll Taxes-AZ Unemployment
441.28
2,000.00
6095 · Office Exp & Eqt
508.45
10,700.00
6100 · Propane Purchases
6,401.97
12,000.00
6102 · Property Committee
2.55
300.00
6105 · Property Insurance
12,459.48
16,000.00
6111 · Medical
529.41
3,400.00
6112 · Safety & Security
98.45
2,300.00
6115 · Salary - Activity Director
2,400.00
8,400.00
6120 · Salary - Housekeeping
1,200.00
9,600.00
6125 · Salary - Kitchen
3,049.23
6,125.00
6130 · Salary - Maintenance
5,781.38
33,000.00
6135 · Salary - Manager
7,750.00
46,500.00
6140 · Salary - Mail Handling
1,172.50
7,020.00
6143 · Salary - Bookkeeper
2,166.66
13,000.00
6146 · Salary-Welcome Center
1,746.00
7,560.00
6150 · Sales Tax (Food, Propane)
1,033.81
3,500.00
6152 · Resale & Vendor Commissions Exp
2,826.20
2,000.00
6153 · Resale - Clickers
13.03
6159 · Supplies - Activity Office
379.95
2,500.00
6160 · Supplies - Buildings
513.08
5,000.00
6167 · Supplies Post Office
0.50
800.00
6168 · Supplies - Welcome Center
422.17
625.00
6175 · Taxes - Real Estate
0.00
22,900.00
6180 · Taxes - State Income
0.00
45.00
6192 · Payroll Taxes-Az. Job Training
24.52
70.00
6196 · Electric Rental Lot Exp
705.69
4,000.00
6200 · Utilities - Electric
4,422.56
27,000.00
6205 · Utilities - Natural Gas
2,455.19
17,000.00
6210 · Utilities - Telephone
1,305.83
5,300.00
6215 · Utilities - Trash
2,177.64
16,000.00
6220 · Utilities - Water
2,288.19
25,000.00
6222 · Utilities - Sewer
9,300.00
111,600.00
6225 · Volunteer Appreciation Exp
0.00
250.00
6300 · Park Maintenance
6320 · Coop Equipment/Tractor Etc.
731.74
4,800.00
6325 · Dry Well & Septic Service
5,049.65
8,000.00
6330 · Bldg & Grounds Maintenance
4,552.98
36,000.00
6331 · Maintenance Tools
826.48
2,000.00
6335 · Pool/Solar System
11,623.81
9,000.00
6342 · Sunscape Survey
18,082.35
Total 6300 · Park Maintenance
40,867.01
59,800.00
Total 6000 · COOP. OPERATIONAL EXPENSES
123,774.91
542,678.64
7081 · Earned Income Alocation
57.78
Total Expense
123,832.69
542,678.64
Net Ordinary Income
343,482.47
0.00
Net Income
343,482.47
0.00
Feb 28, 10
ASSETS
Current Assets
Checking/Savings
1001 · FR/D/A 12,367.75
Total Checking/Savings 12,367.75
Total Current Assets 12,367.75
TOTAL ASSETS 12,367.75
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Other Current Liabilities
2000 FR/D/A
2165 · Cancer Fund 28.60
2004 · Block Watch 163.50
2006 · Singles Club 341.50
2142 · Summer Activity Fund 147.18
2009 · Park Party Start-up Fund 6,867.90
2070 Medical - Other 34.63
2075 · Movie Night & Accessories Fund 303.75
2090 Computer Club 741.13
2110 Library 115.61
2120 Quilters 480.76
2130 Jammers 1,190.56
2152 · Scarlet Darlins' 850.75
2185 · Parade  Floats 215.99
2200 Prom & Wine & Cheese Com. 824.89
Total 2000 FR/D/A 12,306.75
Total Other Current Liabilities 12,306.75
Total Current Liabilities 12,306.75
Total Liabilities 12,306.75
Equity
2091 · Genealogy Group 61.00
Total Equity 61.00
TOTAL LIABILITIES & EQUITY 12,367.75