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