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.1

 

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