January 2010 Park Budget

Jan 31, 10
ASSETS
Current Assets
Checking/Savings
1002 · BofA Operations Chking 0345 71,552.16
1010 · MONEY MARKET - SAVINGS
1016 · Money Mkt. 295,358.49
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,260.54
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 594,712.70
Accounts Receivable
1200 · Accounts Receivable 41,846.20
Total Accounts Receivable 41,846.20
Other Current Assets
1499 · Undeposited Funds 15,425.00
Total Other Current Assets 15,425.00
Total Current Assets 651,983.90
TOTAL ASSETS 651,983.90
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Other Current Liabilities
2100 · Payroll Liabilities
2101 · Federal 941 taxes payable 2,712.42
2103 · Federal Unemployment 102.50
2111 · State AZ Unemployment 230.62
2112 · State AZ Job Training Tax 12.81
2100 · Payroll Liabilities - Other 178.26
Total 2100 · Payroll Liabilities 3,236.61
Total Other Current Liabilities 3,236.61
Total Current Liabilities 3,236.61
Long Term Liabilities
2400 · RESTRICTED LIABILITIES
1012 · 1012 Capital Improvment 138,147.66
1014 · 1014 Contingency Account 62,117.48
1017 · Park Improvements-Comm. Complex 25,063.28
Total 2400 · RESTRICTED LIABILITIES 225,328.42
Total Long Term Liabilities 225,328.42
Total Liabilities 228,565.03
Equity
3000 · Opening Bal Equity 8,660.55
3900 · Retained Earnings 13,774.14
Net Income 400,984.18
Total Equity 423,418.87
TOTAL LIABILITIES & EQUITY 651,983.90
     
Jan 10 Budget
Ordinary Income/Expense
Income
3525 · Operating Cash Carry Over 0.00 22,608.64
4030 · SHAREHOLDER
4032 · Shareholder Asses. 480@$925 0.00 444,000.00
4034 · Less Frz. Dues, No Asses. 0.00 -2,860.00
4038 · Transfer to Contingencies 0.00 -15,000.00
4039 · Transfer to Capilal Reserve 0.00 -10,000.00
4030 · SHAREHOLDER - Other 441,140.00  
Total 4030 · SHAREHOLDER 441,140.00 416,140.00
4040 · OPERATIONAL  INCOME
4010 · Activities/Entertainment Inc 1,218.42 7,000.00
4015 · Gate Cards & Mail Keys 540.00
4041 · Rental Income Daily and Weekly 2,853.00 30,000.00
4042 · Rental Income Monthly 6,267.50
4043 · Rental Storage 1,410.00 9,000.00
4044 · Rental Vendor Room 315.00 500.00
4045 · Resale & Vendor Commissions Inc 741.25 5,000.00
4046 · Resale - Clickers 128.50 180.00
4050 · Office Income 229.27 3,000.00
4054 · Investment Interest 25.91
4055 · Interest & Late Fees Inc 0.00 2,500.00
4060 · Kitchen Receipts 3,556.12 17,500.00
4065 · Laundry 1,596.50 9,000.00
4070 · Propane Sales 4,015.70 15,000.00
4085 · Transfer/Inspection Fees Inc 610.00 2,000.00
4115 · Bingo 61.14 750.00
4155 · Reimbursements to Co-op 764.89 2,500.00
4180 · Over/Short Cash 8.60  
Total 4040 · OPERATIONAL  INCOME 24,341.80 103,930.00
Total Income 465,481.80 542,678.64
Gross Profit 465,481.80 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 0.00 3,000.00
6011 · Ambassadors 3.77 400.00
6012 · Architectural Committee 9.81 1,235.00
6015 · Autos & Mileage Exp 56.99 1,500.00
6020 · Bank Svc/Finance Charges 187.91 2,000.00
6022 · Board/Annual Meetings 298.51 3,000.00
6025 · Fire Department 52.07 3,500.00
6035 · Licenses & Permits 0.00 3,800.00
6045 · Entertainment Exp 643.38 5,000.00
6047 · Finance Committee 0.00 300.00
6050 · Kitchen Supplies/Food Purchases 1,243.21 9,670.00
6055 · Legal / Attorney Fees 506.00 12,000.00
6065 · Miscellaneous Expenses 0.00 608.64
6070 · Payroll Taxes Federal / FICA 980.21 9,117.00
6080 · Payroll-Worker Comp Insurance 0.00 2,400.00
6085 · Payroll Taxes-Fed Unemplymt 102.50 553.00
6090 · Payroll Taxes-AZ Unemployment 230.63 2,000.00
6095 · Office Exp & Eqt 153.32 10,700.00
6100 · Propane Purchases 3,645.10 12,000.00
6102 · Property Committee 0.00 300.00
6105 · Property Insurance 8,824.48 16,000.00
6111 · Medical 272.29 3,400.00
6112 · Safety & Security 95.55 2,300.00
6115 · Salary - Activity Director 1,200.00 8,400.00
6120 · Salary - Housekeeping 800.00 9,600.00
6125 · Salary - Kitchen 1,454.59 6,125.00
6130 · Salary - Maintenance 2,941.00 33,000.00
6135 · Salary - Manager 3,875.00 46,500.00
6140 · Salary - Mail Handling 586.25 7,020.00
6143 · Salary - Bookkeeper 1,083.33 13,000.00
6146 · Salary-Welcome Center 873.00 7,560.00
6150 · Sales Tax (Food, Propane) 485.20 3,500.00
6152 · Resale & Vendor Commissions Exp 931.23 2,000.00
6153 · Resale - Clickers 13.03
6159 · Supplies - Activity Office 53.95 2,500.00
6160 · Supplies - Buildings 179.37 5,000.00
6167 · Supplies Post Office 0.50 800.00
6168 · Supplies - Welcome Center 108.30 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 12.81 70.00
6196 · Electric Rental Lot Exp 631.47 4,000.00
6200 · Utilities - Electric 2,402.91 27,000.00
6205 · Utilities - Natural Gas 1,346.16 17,000.00
6210 · Utilities - Telephone 653.03 5,300.00
6215 · Utilities - Trash 1,342.32 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. 575.77 4,800.00
6325 · Dry Well & Septic Service 2,863.83 8,000.00
6330 · Bldg & Grounds Maintenance 3,098.03 36,000.00
6331 · Maintenance Tools 777.76 2,000.00
6335 · Pool/Solar System 7,113.40 9,000.00
6342 · Sunscape Survey 159.90  
Total 6300 · Park Maintenance 14,588.69 59,800.00
Total 6000 · COOP. OPERATIONAL EXPENSES 64,478.16 542,678.64
7081 · Earned Income Alocation 19.46  
Total Expense 64,497.62 542,678.64
Net Ordinary Income 400,984.18 0.00
Net Income 400,984.18 0.00
Jan 31, 10
ASSETS
Current Assets
Checking/Savings
1001 · FR/D/A 7,343.55
Total Checking/Savings 7,343.55
Total Current Assets 7,343.55
TOTAL ASSETS 7,343.55
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 296.50
2142 · Summer Activity Fund 147.18
2009 · Park Party Start-up Fund 2,931.10
2070 Medical - Other 72.33
2075 · Movie Night & Accessories Fund 322.45
2090 Computer Club 103.13
2110 Library 87.45
2120 Quilters 34.76
2130 Jammers 1,353.22
2152 · Scarlet Darlins' 900.75
2185 · Parade  Floats 215.99
2200 Prom & Wine & Cheese Com. 625.59
Total 2000 FR/D/A 7,282.55
Total Other Current Liabilities 7,282.55
Total Current Liabilities 7,282.55
Total Liabilities 7,282.55
Equity
2091 · Genealogy Group 61.00
Total Equity 61.00
TOTAL LIABILITIES & EQUITY 7,343.55