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