Sunscape Estates RV Park Coop.
Profit & Loss Budget vs. Actual
January through December 2006
10:38 AM - 05/04/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
114,088.70
.
115,200.00
.
......4032 Shareholder Assess.480 @285
157,741.30
.
160,800.00
.
......5403 2006 Special Asses 475@$103.61
49,318.36
.
49,214.75
.
......4034 Less Frz. Dues, No Asses.
0.00
.
-1,795.00
.
.......4030 SHAREHOLDER - Other
-1,618.52
.
.
.
...Total 4030 SHAREHOLDER
.
319,529.84
.
323,419.75
.....
...4040 OPERATIONAL INCOME
..
.
.
.
......4041 Rental Income Daily and Weekly
8,633.08
.
28,000.00
.
......4042 Rental Income Monthly
11,344.52
.
.
.
......4043 Rental Storage
1,625.50
.
3,500.00
.
......4045 Fresh Water Sales
1,305.65
.
4,000.00
.
......4050 Ice, Fax, Copies, Notary fees
1,005.05
.
1,300.00
.
......4055 Interest
2,475.71
.
2,300.00
.
......4060 Kitchen Receipts
4,644.57
.
15,000.00
.
......4065 Laundry
7,210.38
.
10,000.00
.
......4070 Propane Sales
12,840.06
.
15,000.00
.
......4075 Summer Weed Control
80.00
.
1,000.00
.
......4085 Transfer/lnspection Fees
1,950.00
.
3,000.00
.
...Total 4040 OPERATIONAL INCOME
.
53,114.52
.
83,100.00
...4100 MISCELLANEOUS INCOME
.
.
.
.
......4120 Entertainment
7,244.27
.
2,000.00
.
......4125 Globe Lights, Poles, Sensors
0.00
.
500.00
.
......4130 Alum. cans/Misc.
1,108.03
.
1,250.00
.
......4140 Shirts, Hats, Name Tags, Labels
969.32
.
1,000.00
.
......4145 Telephone Books
0.00
.
200.00
.
......4150 Vendor Commissions
205.00
.
500.00
.
......4155 Reimbursements to Co-op
580.21
.
.
.
......4180 OverlShort Cash
118.98
.
.
.
......4190 Gate Cards
-280.00
.
.
.
...Tota1 4100 MISCELLANEOUS INCOME
.
9,945.81
.
5,450.00
...
.
.
Total Income.382,590.17.482,988.04
Gross Profit.382,590.17.482,988.04
......
Expense....
...6000 COOP. OPERATIONAL EXPENSES....
......6005 Accountant/CPA Fees
2,732.95
.
3,000.00
.
......6010 Advertising
1,667.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.00
.
25.00
.
......6022 Board/Annual Meetings
170.02
.
1,500.00
.
......6025 Computer, Software, P/R Update
237.26
.
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,056.33
.
1,500.00
.
......6050 Kitchen Supplies/Food Purchases
2,404.98
.
10,000.00
.
......6055 Legal/Attorney Fees
2,159.00
.
6,000.00
.
......6060 Licenses and Permits
34.00
.
850.00
.
......6065 Miscellaneous Expenses
10.00
.
500.00
.
......6070 Payroll Taxes Federal 1 FICA
2,312.08
.
7,100.00
.
......6080 Payroll-Worker Comp Insurance
484.23
.
2,600.00
.
......6085 Payroll Taxes-Fed. Unemploy
241.79
.
500.00
.
......6090 Payroll Taxes-AZ Unemployment
921.81
.
1,600.00
.
......6095 Postage and Delivery
358.62
.
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
3,485.00
.
12,000.00
.
......6125 Salary - Kitchen
979.50
.
2,500.00
.
......6130 Salary - Maintenance
11,900.50
.
32,100.00
.
......6040 Salary - Mail Handling
1,025.00
.
5,400.00
.
......6135 Salary - Manager
8,333.33
.
30,000.00
.
......6143 Salary - Bookkeeper
2,056.00
.
8,700.00
.
......6145 Salary -Other
2,443.00
.
6,000.00
.
......6150 Sales Tax (Food, Propane)
1,558.83
.
3,000.00
.
......6152 Shirts, Hats, Name Tags
1,011.43
.
1,000.00
.
......6160 Supplies - CH, AC, CC
1,433.32
.
5,000.00
.
......6165 Supplies - Office
2,762.34
.
3,000.00
.
......6175 Taxes - Real Estate
7,396.70
.
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,716.64
.
5,000.00
.
......6200 Utilities - Electric
7,068.63
.
17,000.00
.
......6205 Utilities - Natural Gas
9,531.81
.
18,500.00
.
......6210 Utilities - Telephone
2,445.50
.
5,500.00
.
......6215 Utilities - Trash
6,684.62
.
6,500.00
.
......6220 Utilities - Water
10,320.36
.
19,000.00
.
......6222 Utilities - Sewer
16,042.50
.
28,000.00
.
......6225 Volunteer Appreciation
481.73
.
1,000.00
.
......6300 Park Maintenance
.
.
.
.
...........6305 Buildings
.2,340.35
.
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,396.96
..
...8,500.00
.
...........6335 Pool/Solar System
......523.60
....
...5,000.00
.
......Total 6300 Park Maintenance
10,102.33
.
77,000.00
.
......6349 Board approved, capital exp
......905.28
.
.
.
......6500 Capital Improvements
.
.
.
.
............6510 Activity Center
..1,621.41
.
..1,621.41
.
............6530 Tools
.........0.00
.
.
.
............6542 New Maintenance Bldg.
17,845.52
.
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
20,666.93
.
51,436.72
.
.
.
.
.
.
......Total 6000 COOP. Operational Expense
219,560.77
.
.
482,988.04
......6600 Capital lmp.-Reserve Account
.
.
.
.
............6601 A.C. & C. C. Upgrades- AirlHeat
424.56
.
6,205.18
.
......Total 6600 Capitallmp.-Reserve Account
.
424.56
.
6,250.18
.
..
.
.
.
...Total Expense
..
219,985.33
.
489,238.22
.
..
.
.
.
..Net Ordinary Income
.
162,604.84
.
-6,250.18
..Other Income/Expense
.
.
.
.
...Other Income
.
.
.
.
......7000 Sunscape Money Market Acct.
.
.
.
.
............7010 Deposits & Withdrawals
35,176.32
.
.
..
......Total 7000 Sunscape Money Market Acct.
.
35,176.32
.
.
.
..
.
..
...
......Total Other Income
..
35,176.32
..
..
..Net Other Income
..
35,176.32
..
0.00
.
..
.
.
.
Net Income
..
197,781.13
.
-6,250.18

 

Sunscape Estates RV Park Coop.
Balance Sheet
As of April 30, 2006
ASSETS
.
.
..Current Asset
.
.
....Checking/Savings
.
.
......1002 Checking AcclBOA-Operations
.
26,082.43
......1010 . MONEY MARKET - SAVINGS
60.329.24
.
..........1012 1012 Capital lmprovment
45,139.64
.
..........1014 1014 Contingency Account
.
.
..........1015 Comm. Center Exp./2002 Party
.
.
..........1016. Operations BOA Money Mk
205,656.71
.
..........1017 Park Improvements-Comm. Complex
29,829.73
.
......Total 1010 MONEY MARKET - SAVINGS
.
340,955.32
.
.
.
......1040 . CHANGE FUND ACCOUNTS
.
.
..........1042 . Business OffIce
500.00
.
..........1055 . Welcome Center Fund
250.00
.
......Total 1040 . CHANGE FUND ACCOUNTS
.
750.00
.
.
.
. .Total Checking/Savings
.
367,787.75
....Accounts Receivable
.
.
........1200 Accounts Receivable
.
-908.61
....Total Accounts Receivable
.
-908.61
..Other Current Assets
.
.
........1499 Undeposited Funds.180.00
.. Total Other Current Assets .180.00
..Total Current Assets
.
367,059.14
.
.
.
TOTAL ASSETS
.
367,059.14
/
.
.
LIABILITIES & EQUITY
.
.
..Liabilities
.
.
....Current Liabilities
.
.
......Other Current Liabilities
.
.
..........2100 . Payroll Liabilities
.
.
..............2111 . State AZ Unemployment
208.01
.
.............2110 . State AZ - Witholding
53.86
.
.............2101. Federal 941 taxes payable
-25.31
.
.............2103. Federal Unemployment
241.79
.
..........Total 2100 . Payroll Liabilities
.
478.35
......Total Other Current Liabilities
.
478.35
...Total Current liabilities
.
478.35
.
.
.
....Long Term Liabilities
.
.
......2500 . Restricted Donation
.
29,366.27
....Total Long Term Liabilities
.
29,366.27
.
.
.
..Total liabilities
.
29,844.52
.
.
.
..Equity
.
.
....3000 . Opening Bal Equity
.
-20.60
....3900 . Retained Earnings
.
139,255.80
....3950 . Money Market Interest Income
.
689.51
....Net Income
.
197,289.81
..Total Equity
.
337,214.52
.
.
.
TOTAL LIABILITIES & EQUITY
.
367,059.14

 

Fund Raisers/ Donations/Activities
Balance Sheet
As of April 30, 2006
...
ASSETS..
..Current Assets..
.....Checking/SavingsFR/D/A.5,760.24
........Fundralsers/Donations/Activity..
.....Total Checking/Savlngs.5,760.24
..Total Current Assets.5,760.24
TOTAL ASSETS.5,760.24
....
LIABILITIES & EQUITY..
..Liabilities..
.....Current Liabilities..
........Other Current Liabilities..
...........2000 FRID/A..
...............2009 Park Party start-up Fund
500.00
.
...............2045 Cookbooks
.
.
...............2070 Medical - Other
272.60
.
...............2075 Movie Night & Accessories
126.00
.
...............2090 Computer Club
1,908.24
.
...............2110 Library
11.64
.
...............2120 Qullters
408.15
.
...............2130 Jammers
619.60
.
...............2140 Park Beautification
283.07
.
...............2152. Scarlet Darlins
519.75
.
...............2185 Christmas Float
392.39
.
...............2200 Activity Committe
506.04
.
...............2205 Unassigned
..
.
...............2215 Billiard Players
215.76
.
...........Total 2000 FRID/A
.
5,763.24
........Total Other Current Liabilities
.
5,763.24
.....Total Current Liabilities
.
5,763.24
..Total Liabilities
.
5,763.24
...
..Equity..,

.....3000 Opening Bal Equity

.-3.00
..Total Equity
.
-3.00
...
TOTAL LIABILITIES & EQUITY
.
5,760.24