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