April Report

Sunscape Estates RV Park Coop.
Profit & Loss Budget vs. Actual
January through December 2006
12:12 PM - 04/10/06 - Accrual Basis....
.
Jan - Dec 06
.Budget.
Ordinary Income/Expense Income
.
.
.
.
...3525 Operating Cash Carry Over
.
0.00
.
71,018.29
....4030 SHAREHOLDER
.
.
.
.
......4031 Shareholder Dues - 480@ $240
115,080.00
.
115,200.00
.
......4032 Shareholder Assess.480 @335
159,125.00
.
160,800.00
.
......5403 2006 Special Asses 480@$103.61
49,318.36
.
49,214.75
.
......4034 Less Frz. Dues, No Asses.
0.00
.
-1,795.00
.
.......4030 SHAREHOLDER - Other
0.00
.
.
...
.
323,523.36
.
323,419.75
...4040 OPERATIONAL INCOME
.
.
.
.
......4041 Rental Income Daily and Weekly
8,363.58
.
28,000.00
.
......4042 Rental Income Monthly
11,014.52
.
.
.
......4043 Rental Storage
1,395.50
.
3,500.00
.
......4045 Fresh Water Sales
1,218.60
.
4,000.00
.
......4050 Ice, Fax, Copies, Notary fees
868.20
.
1,300.00
.
......4055 Interest
2,492.51
.
2,300.00
.
......4060 Kitchen Receipts
4,045.49
.
15,000.00
.
......4065 Laundry
4,938.25
.
10,000.00
.
......4070 Propane Sales
12,459.09
.
15,000.00
.
......4075 Summer Weed Control
0.00
.
1,000.00
.
......4085 Transfer/lnspection Fees
1,800.00
.
3,000.00
.
...Total 4040 OPERATIONAL INCOME
.
48,595.74
.
83,100.00
......
...4100 MISCELLANEOUS INCOME
.
.
.
.
......4120 Entertainment
7,101.02
.
2,000.00
.
......4125 Globe Lights, Poles, Sensors
0.00
.
500.00
.
......4130 Alum. cans/Misc.
662.11
.
1,250.00
.
......4140 Shirts, Hats, Name Tags, Labels
774.32
.
1,000.00
.
......4145 Telephone Books
0.00
.
200.00
.
......4150 Vendor Commissions
205.00
.
500.00
.
......4155 Reimbursements to Co-op
326.29
.
.
.
......4180 OverlShort Cash
119.24
.
.
.
......4190 Gate Cards
-120.00
.
.
.
......4100 Miscellaneous Iincome - Other..
.
.
...Tota1 4100 MISCELLANEOUS INCOME.9,067.98
.
5,450.00
...
.
.
Total Income.381,187.08...482,988.04
Gross Profit.381,187.08...482,988.04
......
Expense.....
...6000 COOP. OPERATIONAL EXPENSES.....
......6005 Accountant/CPA Fees
2,732.95
.
3,000.00
.
......6010 Advertising
1,623.40
.
3,000.00
.
......6012 Architectural Committee
150.43
.
300.00
.
......6015 Auto Expense - Mileage
414.32
.
1,500.00
.
......6020 Bank Service Charges
-15.60
.
25.00
.
......6022 Board/Annual Meetings
579.65
.
1,500.00
.
......6025 Computer, Software, P/R Update
59.40
.
2,500.00
.
......6030 Copy Machine, Printing & Repro.
1,556.95
.
3,500.00
.
......6035 Dues and Subscriptions
0.00
.
1,000.00
.
......6043 Ice
349.20
.
500.00
.
......6045 Entertainment
4,052.01
.
1,500.00
.
......6050 Kitchen Supplies/Food Purchases
2,397.09
.
10,000.00
.
......6055 Legal/Attorney Fees
1,054.00
.
6,000.00
.
......6060 Licenses and Permits
24.00
.
850.00
.
......6065 Miscellaneous Expenses
10.00
.
500.00
.
......6070 Payroll Taxes Federal/FICA
1,790.36
.
7,100.00
.
......6080 Payroll-Worker Comp Insurance
0.00
.
2,600.00
.
......6085 Payroll Taxes-Fed. Unemploy
187.22
.
500.00
.
......6090 Payroll Taxes-AZ Unemployment
713.80
.
1,600.00
.
......6095 Postage and Delivery
331.60
.
600.00
.
......6100 Propane Purchases
12,440.53
.
12,000.00
.
......6105 Property Insurance
17,853.00
.
23,500.00
.
......6112 Safety & Security
2,629.83
.
4,200.00
.
......6113 Mail Room
288.04
.
.
.
......6114. Bookeeper Expense
575.00
.
.
.
......6115 Salary - Activity Director
0.00
.
6,300.00
.
......6120 Salary - Housekeeping
2,688.00
.
12,000.00
.
......6125 Salary - Kitchen
416.00
.
2,500.00
.
......6130 Salary - Maintenance
9,225.50
.
32,100.00
.
......6040 Salary - Mail Handling
725.00
.
5,400.00
.
......6135 Salary - Manager
6,250.00
.
30,000.00
.
......6143 Salary - Bookkeeper
1,656.00
.
8,700.00
.
......6145 Salary -Other
2,443.00
.
6,000.00
.
......6150 Sales Tax (Food, Propane)
1,260.86
.
3,000.00
.
......6152 Shirts, Hats, Name Tags
1,011.43
.
1,000.00
.
......6160 Supplies - CH, AC, CC
1,405.66
.
5,000.00
.
......6165 Supplies - Office
2,226.95
.
3,000.00
.
......6175 Taxes - Real Estate
0.00
.
16,000.00
.
......6180 Taxes - State Income
0.00
.
100.00
.
......6185 Transfer to SS Cap. Imp. Fund
35,176.32
.
35,176.32
.
......6196 Rental Lot Elec
1,720.96
.
5,000.00
.
......6200 Utilities - Electric
7,118.63
.
17,000.00
.
......6205 Utilities - Natural Gas
7,398.27
.
18,500.00
.
......6210 Utilities - Telephone
1,817.50
.
5,500.00
.
......6215 Utilities - Trash
5,190.75
.
6,500.00
.
......6220 Utilities - Water
8,391.09
.
19,000.00
.
......6222 Utilities - Sewer
8,912.00
.
28,000.00
.
......6225 Volunteer Appreciation
27.08
.
1,000.00
.
......6300 Park Maintenance
.
.
.
.
............6305 Buildings
2,261.02
.
50,000.00
.
............6320 Coop EquipmentlTractor Etc.
5,276.42
.
11,000.00
.
............6325 Dry Well & Septic Service
565.00
.....
...2,000.00
.
............6326 Globe Lights
0.00
.......
.....500.00
.
............6330 Grounds Maintenance
1,162.59
..
...8,500.00.
.
............6335 Pool/Solar System
327.26
...
...5,000.00
.
......Total 6300 Park Maintenance
9,592.29
.
77,000.00
.
.
.
.
.
.
......6349 Board approved capital expense
905.28
...
......6500 Capital Improvements
.
.
.
.
............6510 Activity Center
1,621.41
.
..1,621.41
.
............6530 Tools
0.00
.
.....600.56
.
............6542 New Maintenance Bldg.
7,000.00
.
25,004.00
.
............6543 used fire truck purchase
0.00
.
20,002.25
.
............6544. enclosed fire truck awning
0.00
.
..2,004.50
.
............6545 Miller 6000 & $1000 tools
1,200.00
.
..2,204.00
.
......Total 6500 Capital Improvements
9,821.41
.
51,436.72
.
.
.
.
.
.
......Total 6000 COOP. Operational Expense
.
177,177.16
.
482,988.04
......6600 Capital lmp.-Reserve Account
.
.
.
............6601 A.C. & C. C. Upgrades- AirlHeat
299.84
.
6,250.18
.
......Total 6600 Capitallmp.-Reserve Account
.
299.84
.
6,250.18
...Total Expense
.
177,477.00
.
489,238.22
.
.
.
.
.
..Net Ordinary Income
.
203,710.08
.
-6,250.18
..Other Income/Expense
.
.
.
.
...Other Income
.
.
.
.
......7000 Sunscape Money Market Acct.
.
.
.
.
............7010 Deposits & Withdrawals
35,176.32
.
.
.
......Total 7000 Sunscape Money Market
.
35,176.32
.
.
.
.
.
.
.
......Total Other Income
..
35,176.32
..
.
..Net Other Income
.
35,176.32
.
0.00
.
.
.
.
.
Net Income
.
238,886.40
.
-6,250.18
.
.
.
.

 

Sunscape Estates RV Park Coop.
Balance Sheet
As of February 28, 2006
ASSETS..
..Current Asset..
....Checking/Savings..
......1002 Checking AcclBOA-Operations..
......1010 . MONEY MARKET - SAVINGS..
..........1012 1012 Capitallmprovment..
..........1014 1014 Contingency Account..
..........1015 Comm. Center Exp./2002 Party..
..........1016. Operations BOA Money Mk..
..........1017 Park Improvements-Comm. Complex..
......Total 1010 MONEY MARKET - SAVINGS..
...
......1040 . CHANGE FUND ACCOUNTS..
..........1042 . Business OffIce..
..........1055 . Welcome Center Fund..
......Total 1040 . CHANGE FUND ACCOUNTS..
...
. .Total Checking/Savings..
....Accounts Receivable..
........1200 Accounts Receivable..
....Total Accounts Receivable..
...
..Total Current Assets..
...
TOTAL ASSETS..
...
LIABILITIES & EQUITY..
..Liabilities..
....Current Liabilities..
......Other Current Liabilities..
..........2100 . Payroll Liabilities..
..............2111 . State AZ Unemployment..
.............2110 . State AZ - Witholding..
.............2101. Federal 941 taxes payable..
.............2103. Federal Unemployment..
..........Total 2100 . Payroll Liabilities..
......Total Other Current Liabilities..
...Total Current liabilities..
...
....Long Term Liabilities..
......2500 . Restricted Donation..
....Total Long Term Liabilities..
...
..Total liabilities..
...
..Equity..
....3000 . Opening Bal Equity..
....3900 . Retained Earnings..
....3950 . Money Market Interest Income..
....Net Income..
..Total Equity..
...
TOTAL LIABILITIES & EQUITY..

 

Fund Raisers/ Donations/Activities
Balance Sheet
As of February 28, 2006
...
ASSETS..
..Current Assets..
.....Checking/SavingsFR/D/A.5,809.22
........Fundralsers/Donations/Activity..
.....Total Checking/Savlngs.5,809.22
..Total Current Assets.5,809.22
TOTAL ASSETS.5,809.22
...
LIABILITIES & EQUITY..
..Liabilities..
.....Current Liabilities..
........Other Current Liabilities..
...........2000 FR/D/A..
...............2009 Park Party Start-up Fund
500.00
.
...............2070 Medical - Other
272.60
.
...............2075 Movie Night & Accessories
148.50
.
...............2090 Computer Club
1,935.37
.
...............2110 Library
11.64
.
...............2120 Qullters
408.15
.
...............2130 Jammers
651.70
.
...............2140 Park Beautification
283.07
.
...............2152. Scarlet Darlins
484.00
.
...............2185 Christmas Float
392.39
.
...............2200 Activity Committe
506.04
.
...............2205 Unassigned
0.00
.
...............2215 Billiard Players
215.76
.
...........Total 2000 FRID/A.5,809.22
...
........Total Other Current Liabilities.5,809.22
...
.....Total Current Liabilities.5,809.22
...
..Total Liabilities.5,809.22
...
TOTAL LIABILITIES & EQUITY.5,809.22