Sunscape Estates RV Park Coop.
Profit & Loss Budget vs. Actual
January through December 2006
10:14 AM - 03/06/06 - Accrual Basis....
.
Jan - Dec 06
.Budget.
Ordinary Income/Expense Income
.
.
.
.
...3525 . Operating Cash Carry Over
.
0.00
.
115,200.00
....4030. SHAREHOLDER
.
.
.
.
......4031 . Shareholder Dues - 480@ $240
115,080.00
.
115,200.00
.
.......4032 . Shareholder Assess.480 @285
159,125.00
.
160,800.00
.
......5403 2006 Special Asses 480@$103.61
0.00
.
49,732.80
.
......4034 . Less Frz. Dues, No Asses.
0.00
.
-1,795.00
.
.......4030 . SHAREHOLDER - Other
49,629.19
.
..
.
....
.
323,834.19
..
323,937.80
...4040, OPERATIONAL INCOME
.
.
...
.
......4041 Rental Income Daily and Weekly
5011.58
 
28,000.00
 
......4042 Rental Income Monthly
8,451.20
 
.
 
......4043 Rental Storage
731.50
 
3,500.00
 
......4045 Fresh Water Sales
779.85
 
4,000.00
 
......4050 Ice, Fax, Copies, Notary fees
489.35
 
1,300.00
 
......4055 Interest
1,002.46
 
2,300.00
 
......4060 Kitchen Receipts
2,626.35
 
15,000.00
 
......4065 Laundry
2,575.00
 
10,000.00
 
......4070 Propane Sales
9,010.13
 
15,000.00
 
......4075 Summer Weed Control
0.00
 
1,000.00
 
......4085 Transfer/lnspection Fees
700.00
 
3,000.00
 
...Total 4040 OPERATIONAL INCOME
.
31,377.42
.
83,100.00
...4100 MISCELLANEOUS INCOME
.
 
.
 
......4120. Entertainment
6,279.48
 
2,000.00
 
......4125 Globe Lights, Poles, Sensors
0.00
 
500.00
 
......4130 Alum. cans/Misc.
659.11
 
1,250.00
 
......4140 Shirts, Hats, Name Tags, Labels
308.50
 
1,000.00
 
......4145 Telephone Books
0.00
 
200.00
 
......4150 Vendor Commissions
205.00
 
500.00
 
......4155 Reimbursements to Co-op
276.29
 
.
 
......4180 OverlShort Cash
138.87
 
.
 
......4190 Gate Cards
740.00
 
.
 
......4100 Miscellaneous Iincome - Other
21.00
 
.
 
...Tota1 4100 MISCELLANEOUS INCOME
/
....8.628.25
.
....5,450.00
.
..
.
..
.
Total Income
.
363,839.86
.
483,506.09
.
..
.
..
.
Gross Profit
.
363,839.86
.
483,506.09
.
..
.
..
.
..Expense
.
 
.
.
...6000 COOP. OPERATIONAL EXPENSES
.
 
.
.
......6005 Accountant/CPA Fees
2,732.95
.
3000.00
.
......6010 Advertising
1,623.40
.
3,000.00
.
......6012 Architectural Committee
150.43
.
300.00
.
......6015. Auto Expense - Mileage
161.36
.
1, 500.00
.
......6020 Bank Service Charges
-15.60
.
25.00
.
......6022 Board/Annual Meetings
295.94
.
1,500.00
.
......6025 Computer, Software, P/R Update
59.40
.
2,500.00
.
......6030 Copy Machine, Printing & Repro.
1,023.63
.
3,500.00
.
......6035 Dues and Subscriptions
0.00
.
1,000.00
.
......6043 Ice
86.60
.
500.00
.
......6045 Entertainment
3,391.22
.
1,500.00
.
......6050 Kitchen Supplies/Food Purchases
1,480.47
.
10,000.00
.
......6055 Legal/Attorney Fees
1,054.00
.
6,000.00
.
......6060 Licenses and Permits
24.00
.
850.00
.
......6065 Miscellaneous Expenses
0.00
.
500.00
.
......6070 Payroll Taxes Federal 1 FICA
1,156.75
.
7,100.00
.
......6080 Payroll-Worker Comp Insurance
0.00
.
2,600.00
.
......6085 Payroll Taxes-Fed. Unemploy
120.95
.
500.00
.
......6090 Payroll Taxes-AZ Unemployment
461.20
.
1,600.00
.
......6095 Postage and Delivery
87.70
.
600.00
.
......6100 Propane Purchases
9,236.03
.
12,000.00
.
......6105 Property Insurance
17,853.00
.
23,500.00
.
......6112 Safety & Security
2,370.35
.
4,200.00
.
......6113 Mail Room
275.00
.
.
.
......6114 Bookeeper Expense
575.00
.
.
.
......6115 Salary - Activity Director
0.00
.
6,300.00
.
......6120 Salary - Housekeeping
1,764.00
.
12,000
.
......6125 Salary - Kitchen
416.00
.
2,500
.
......6130. Salary - Maintenance
6,148.00
.

32,100.00

.
......6040 Salary - Mail Handling
435.00
.
5,400
.
......6135 Salary - Manager
4,166.66
.
30,000.00
.
......6143 Salary. Bookkeeper
931.00
.
8,700.00
.
......6145 Salary - Other
1,260.00
.
6,000.00
..
......6150 Sales Tax (Food, Propane)
876.23
.
3,000.00
..
......6152 Shirts, Hats, Name Tags
1,011.43
.
1,000.00
......
......6160 Supplies - CH, AC, CC
1,158.12
.
5,000.00
.
......6165. Supplies - Office
1,696.63
.
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
896.48
.
5,000.00
 
......6200 Utilities - Electric
2,910.11
.
17,000.00
 
4,46205 Utilities - Natural Gas
4,942.88
.
18,500.00
 
......6210 Utilities - Telephone
1,418.03
.
5,500.00
 
......6215 Utilities - Trash
3,990.87
.
6,500.00
 
......6220 . Utilities - Water
6,281.63
.
19,000.00
 
......6222 Utilities - Sewer
6,684.00
.
28,000.00
 
......6225 Volunteer Appreciation
22.70
.
1,000.00
 
......6300 Park Maintenance
.
.
.
............6305 Buildings
...877.67
.

50,000.00

 
............6320 Coop EquipmentlTractor Etc.
4,521.00
.
11,000.00
 
............6325 Dry Well & Septic Service
...565.00
.
..2,000.00
 
............6326 Globe Lights
.......0.00
.
.....500.00
 
............6330 Grounds Maintenance
1,275.89
.
..8,500.00
 
............6335 Pool/Solar System
...253.20
.
..5,000.00
 
......Total 6300 Park Maintenance
7,492.76
.
77,000.00
 
.
.
..
.
.
......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,267.20
 
............6543 used fire truck purchase
.......0.00
.
20,212.80
 
............6544 enclosed fire truck awning
.......0.00
.
..2,025.60
 
............6545 Miller 6000 & $1000 tools
1,200.00
.
..2,227.20
 
......Total 6500 Capital Improvements
9,821.41
.
51,954.77
 
.
.
..
.
.
......Total 6000 COOP. OPERATIONAL EXPENSES
143,704.05
.
483,506.09
 
......6600 Capitallmp.-Reserve Account
.
.
.
 
............6601 A.C. & C. C. Upgrades- AirlHeat
10.30
.
6,250.18
 
......Total 6600 Capitallmp.-Reserve Account
10.30
.
6,250.18
 
.
.
..
.
.
...Total Expense
143,714.35
.
483,505.09
 
.
.
..
.
.
.Net Ordinary Income
220,125.51
.
-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
255,301.83
.
-6,250.18
 

 

Sunscape Estates RV Park Coop.
Balance Sheet
As of February 28, 2006
ASSETS..
..Current Asset..
....Checking/Savings..
......1002 Checking AcclBOA-Operations.36,863.85
......1010 MONEY MARKET - SAVINGS
.
.
..........1012 1012 Capitallmprovment
60,061.03
.
..........1014 1014 Contingency Account
44,939.11
.
..........1015 Comm. Center Exp./2002 Party
6,168.44
.
..........1016 Operations BOA Money Mk
204,723.90
.
..........1017 Park Improvements-Comm. Complex
16,431.63
.
......Total 1010 MONEY MARKET - SAVINGS.332,333.11
.....
......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.369,946.96
....Accounts Receivable..
........1200 Accounts Receivable......6,378.99
....Total Accounts Receivable......6,378.99
...
..Total Current Assets.376,325.95
...
TOTAL ASSETS.376,325.95
...
LIABILITIES & EQUITY..
..Liabilities..
....Current Liabilities..
......Other Current Liabilities..
..........2100 Payroll Liabilities..
..............2111 State AZ Unemployment
461.20
.
.............2110 State AZ - Witholding
199.91
.
.............2101 Federal 941 taxes payable
-38.17
.
.............2103 Federal Unemployment
120.96
.
..........Total 2100 Payroll Liabilities........743.90
......Total Other Current Liabilities........743.90
...Total Current Liabilities........743.90
...
....Long Term Liabilities..
......2500 Restricted Donation.22,234.11
....Total Long Term Liabilities.22,234.11
...
..Total liabilities.22,978.01
...
..Equity..
....3000 Opening Bal Equity.........-15.60
....3900 Retained Earnings.139,382.16
....3950 Money Market Interest Income.........689.51
....Net Income.213,291.87
..Total Equity.353,347.94
...
TOTAL LIABILITIES & EQUITY.376,325.95

 

Fund Raisers/ Donations/Activities
Balance Sheet
As of February 28, 2006
...
ASSETS..
..Current Assets..
.....Checking/Savings..
........Fundralsers/Donations/Activity.3,078.87
.....Total Checking/Savlngs.3,078.87
..Total Current Assets.3,078.87
TOTAL ASSETS.3,078.87
..
LIABILITIES & EQUITY..
..Liabilities..
.....Current Liabilities..
........Other Current Liabilities..
...........2000 FRID/A..
...............2045 Cookbooks
190.50
.
...............2070 Medical - Other
139.50
.
...............2090 Computer Club
589.19
.
...............2110 Library
11.64
.
...............2120 Qullters
362.45
.
...............2130 Jammers
592.10
.
...............2140 Park Beautification
325.72
.
...............2152 Scarlet Darlins
79.00
.
...............2185 Christmas Float
392.39
.
...............2200 Activity Committe
254.62
.
...............2205 Unassigned
126.00
.
...............2215 Billiard Players
15.76
.
...........Total 2000 FRID/A.3,078.87
...
........Total Other Current Liabilities.3,078.87
.....Total Current Liabilities.3,078.87
..Total Liabilities.3,078.87
TOTAL LIABILITIES & EQUITY.3,078.87