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