Palm Beach Budget 2009-10 V1
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Palm Beach Budget 2009-10 V1 as PDF for free.
More details
- Words: 3,907
- Pages: 9
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_
_x000D__x000D__x000D_
. OCT $
2008 NOV $
2008 DEC $
JAN $
FEB $
MAR $
57,960
57,959
57,223
60,502
53,794
56,256
28146 44696
36400 61348
38419 51313
38901 46598
39925 46123
37430 40177
4749 700
4670 700
4794 700
4868 700
4745 700
4745 700
138237
126538
161202 153259 148167 151995
JUL $
AUG $
BAR TRADING
51,022
48,326
CATERING TRADING POKER MACHINE TRADING
34801 46965
SEPT $
APR $
MAY $
JUNE $
TOTAL $
60,106 44,550
49,946
49,556
647,199
37036 61505
41711 45985
21977 33934
28031 40170
30476 43777
413253 562590
4842 35
4684 35
5139 35
4628 700
4625 700
4644 700
57133 6405
136278
159516
123471 129154
1686581
INCOME
SUNDRY MERCHANDISE
TOTAL GROSS INCOME
152977 105788
DEDUCT : EXPENSES
ENTERTAINMENT PROMOTIONS MEMBERS AMENITIES SERVICE & MAINTENANCE FINANCE ADMIN & OVERHEAD
8970 5078
8970 750
8970 6333
8970 3649
8970 4575
8970 4932
8970 2976
8970 1863
8970 3041
8970 2275
8970 4271
8970 5352
107640 43769
14200 1426 59501
14200 2183 57537
14200 4286 60428
14220 4278 58278
14200 1859 58757
14200 1458 55115
14200 1499 56956
14200 2557 55416
14200 1608 60642
14200 2031 59575
14200 2124 57022
14200 632 56125
170420 21541 695352
TOTAL EXPENSES
89175
83640
94217
89395
88361
84675
84601
83006
88461
87051
86587
85279
1044448
NET PROFIT BEFORE TAX
49062
42898
66985
63864
59806
67320
51677
76510
64516
18737
36884
43875
642133
SURF CLUB EXPENSES SURF CLUB OTHER LOAN INTEREST PAID
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
60000
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
108000 45600
NET PROFIT AFTER TAX
31262
25098
49185
46064
42006
49520
33877
58710
46716
937
19084
26075
428533
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_
_x000D__x000D__x000D_
BAR SALES BOTTLE SHOP BREAD & MILK
2010 MAY A 116,500 8,000 300
2010 JUNE A 111,000 8,000 300
2010 JULY A 129,000 11,000 300
2010 AUG AA 133,000 9,000 300
2010 SEPT A 130,000 9,500 300
2010 OCT A 136,000 8,000 3,000
2010 NOV A 130,000 9,500 300
DEC B 140,000 9,000 300
JAN B 146,000 8,500 300
FEB B 109,000 7,000 300
MAR B 118,000 8,000 300
APR TOTAL B 116,000 1,514,500 8,500 104,000 300 6,300
NET BAR SALES
124,800
119,300
140,300
142,300
139,800
147,000
139,800
149,300
154,800
116,300
126,300
124,800 1,624,800
COST OF SALES
44,928
42,948
50,508
51,228
50,328
52,920
53,124
56,734
57,276
43,031
46,731
46,176
GROSS PROFIT
79,872
76,352
89,792
91,072
89,472
94,080
86,676
92,566
97,524
73,269
79,569
78,624 1,028,868 63.3%
UNDERS & OVERS 12 PROMOS & ADVERTISING 1750 LOYALTY REDEMPTIONS 200 CONSUMABLES 699 GAS BAR 209 WAGES - BAR 20,970 WAGES - BOTTLE SHOP 1,282 WAGES - LEAVE PROV 1282 SUPER - BAR 1,887 SUPER - B.S 115 WORKERS COMP - BAR 419 WORKERS COMP - B.S. 26
11 1750 200 666 645 19,980 1,221 1221 1,798 110 400 24
13 1750 150 774 377 23,220 1,419 1419 2,090 128 464 28
13 1750 250 798 641 23,940 1,463 1463 2,155 132 479 29
13 1750 250 780 465 23,400 1,430 1430 2,106 129 468 29
14 1750 200 816 469 24,480 1,496 1496 2,203 135 490 30
13 1750 300 780 1048 23,400 1,430 1430 2,106 129 468 29
14 1750 300 840 631 26,600 1,540 1540 2,394 139 532 31
15 1750 300 876 297 27,740 1,606 1606 2,497 145 555 32
11 1750 200 654 586 20,710 1,199 1199 1,864 108 414 24
12 1750 300 708 538 21,240 1,298 1298 1,912 117 425 26
12 1750 250 696 491 20,880 1,276 1276 1,879 115 418 26
151 ### 21000 1.4% 2900 0.2% 9087 0.6% 6397 0.4% 276560 18.3% 16660 1.1% 16660 1.1% 24890 9.0% 1499 9.0% 5531 2.0% 333 2.0%
TOTAL OTHER EXPENSES 28,850
28,026
31,832
33,113
32,249
33,578
32,882
36,310
37,418
28,719
29,623
29,068
381,669 23.5%
NET INCOME FOR BAR
51,022
48,326
57,960
57,959
57,223
60,502
53,794
56,256
60,106
44,550
49,946
49,556
647,199
% OF NET INCOME TO TOTAL SALES
43.80%
43.54%
44.93%
43.58%
44.02%
44.49%
41.38%
40.18%
41.17%
40.87%
42.33%
42.72%
42.73%
595,932 36.7%
63 until may
LESS : OTHER EXPENSES
19 until march
.
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ 2010 GL CODE
MAY POKER MACHINE TAKINGS KENO TAKINGS POKER MACHINE REVENUE
2010
JUNE
2010
JUL
2010
AUG
2010
SEPT
2010
OCT
_x000D__x000D__x000D_
2010
NOV
DEC
JAN
FEB
MAR
APR
TOTAL
84100 81164 105443 92486 85857 83843 82433 100981 88271 69036 74971 80438 1029023 3523 3258 3195 2808 2351 2786 2946 2782 2831 1953 2606 3150 34189 87623 84422 108638 95294 88208 86629 85379 103763 91102 70989 77577 83588 1063212
LESS : OTHER EXPENSES
UNDERS & OVERS - GAMING 2 2 UNDERS & OVERS - KENO 0 0 PROMOS & ADVERTISING 4205 4058 SURF REWARDS - PROMO 505 487 DEPRECIATION 5127 5127 EQUIPMENT HIRE 2300 2300 KENO CONNECTION FEE 1117 1117 KENO STATIONERY 200 200 LICENSE FEES & TAXES 15714 15172 MGMT FEE - MONEY TRAIN 1780 1780 MONITORING FEES 720 720 WAGES GAMING 5257 5065 WAGES - PROMOTIONS 2489 2489 WAGES LEAVE PROVISION 384 384 WAGESS - SUPER 473 456 WAGES SUPER - PROMOTIONS 224 224 WORKERS COMP - GAMING 106 95 WORKERS COMP - PROMOTIONS 55 50
2 2 2 2 2 2 2 1 1 2 21 0 0 0 0 0 0 0 0 0 0 1 5272 4624 4293 4192 4122 5049 4414 3452 3749 4022 51451 633 555 515 503 495 606 530 414 450 483 6174 5127 5127 5127 5127 5600 5600 5600 5600 5600 5600 64362 2300 2300 2300 2300 2300 2300 2300 2300 2300 2300 27600 1117 1117 1117 1117 1117 1117 1117 1117 1117 1117 13404 200 200 200 200 200 200 200 200 200 200 2400 19700 17944 16319 15855 19987 15018 19218 12684 12964 14749 195324 1780 1780 1780 1780 1780 1780 1780 1780 1780 1780 21360 720 720 720 720 720 720 720 720 720 720 8640 6518 5718 5292 5198 5123 6226 5466 4259 4655 5015 63793 2489 2489 2489 2489 2489 2489 2489 2489 2489 2489 29868 471 470 594 167 430 265 462 1300 572 521 6020 587 515 476 468 461 560 492 383 419 451 5741 224 224 224 224 224 224 224 224 224 224 2688 105 138 114 119 153 102 104 84 111 87 1318 45 59 47 46 0 0 0 47 57 51 457
0.060% 0.000% 5.0% 0.6% 6.1% 2.6% 1.3% 0.2% 18.4% 2.0% 0.8% 6.0% 2.8%
TOTAL EXPENSES
40658 39726
47290 43981 41610 40506 45202 42258 45117 37055 37407 39811 500622
47.1%
NET INCOME POKER MACHINES 46965 44696
61348 51313 46598 46123 40177 61505 45985 33934 40170 43777 562590
% OF NET INCOME TO NET REVENUE K AVERAGE No Poker Machines .
54%
53%
56%
54%
53%
53%
47%
59%
50%
48%
52%
52%
53%
1685 52
1624 52
2089 52
1833 52
1696 52
1666 52
1642 52
1995 52
1752 52
1365 52
1492 52
1607 245357 52 52
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ GL CO DE
MAY
JUN
JUL
AUG
CATERING SALES 140,000 123,000 144,000 156,000 FUNCTIONS - FOOD SALES 6,000 6,000 6,000 6,000 FUNCTION ROOM HIRE 400 400 400 400 COFFEE SHOP SALES 9,000 9,000 9,000 9,000 COST OF SALES
_x000D__x000D__x000D_
SEPT
OCT
NOV
DEC
JAN
FEB
MAR
APR
159,000 6,000 400 9,000
160,000 6,000 400 9,000
154,000 6,000 400 9,000
165,000 4,000 300 9,000
183,000 4,000 300 9,000
110,000 128,000 136,000 1,758,000 4,000 4,000 4,000 62,000 300 300 300 4,300 9,000 9,000 9,000 108,000
58,275
51,900
59,775
64,275
65,400
65,775
63,525
69,537
76,557
97,125
86,500
99,625 107,125
109,000
109,625
105,875
108,763
119,743
14 7000 400 1518 1200 1200 50 300 180 0 25200 15400 2700 900 1400 2268 1386 81 243 504 308 18 54
12 7000 400 3219 1200 1200 50 300 180 0 22140 13530 2700 900 1230 1993 1218 54 243 443 271 18 54
14 7000 400 1118 1200 1200 50 300 180 0 25920 15840 2700 900 1440 2333 1426 54 243 518 317 18 54
16 7000 400 2615 1200 1200 50 300 180 0 28080 17160 2700 900 1560 2527 1544 54 243 562 343 18 54
16 7000 400 2903 1200 1200 50 300 180 109 28620 17490 2700 900 1590 2576 1574 54 243 572 350 18 54
16 7000 400 2281 1200 1200 50 300 180 0 28800 17600 2700 900 1600 2592 1584 54 243 576 352 18 54
15 7000 400 3018 1200 1200 50 300 180 0 27720 16940 2700 900 1540 2495 1525 54 243 554 339 18 54
17 7000 400 2056 1200 1200 50 300 180 0 30525 18150 2700 600 1650 2747 1634 36 243 611 363 12 54
18 7000 400 2285 1200 1200 50 300 180 0 33855 20130 2700 600 1830 3047 1812 36 243 677 403 12 54
11 7000 400 2864 1200 1200 50 300 180 500 20350 12100 2700 600 1100 1832 1089 36 243 407 242 12 54
14 7000 400 2208 1200 1200 50 300 180 0 25160 14960 2700 600 1360 2264 1346 36 243 503 299 12 54
176 84000 4800 28479 14400 14400 600 3600 2160 609 320050 193380 32400 9300 17580 28805 17404 585 2916 6401 3868 186 648
11 TOTAL OTHER EXPENSES 62,324
11 58,354
11 63,225
11 68,706
11 70,099
11 69,700
11 68,445
11 71,727
11 78,032
11 11 11 54,470 59,575 62,090
786,746
28,146
36,400
38,419
38,901
39,925
37,430
37,036
41,711
21,977 28,031 30,476
413,253
24.86% 22.88% 25.28% 24.63%
24.47%
24.95%
24.31%
22.45%
22.79%
19.98% 21.90% 22.41%
23.51%
GROSS PROFIT
46,854 53,694 56,734
TOTAL
5.0%
732,301
37.9%
76,446 87,606 92,566 1,199,999
62.1%
LESS : OTHER EXPENSES
Unders / Overs Promotion / advertising loyalty redemptions Consumables - catering Equipment Hire gas - Catering Cleaning Expenses Linen Hire liquid waste removal Uniforms - catering Wages - food prepared Wages - food served Wages - café Wages - functions Wages - leave Provision wages - super food prep wages - Super food serve Wages - Super functions Wages - Super Café workers comp prepared workers comp served workers comp Functions workers comp café
NET INCOME
% OF NET INCOME TO TOTAL SALES
34,801
13 7000 400 2394 1200 1200 50 300 180 0 23680 14080 2700 600 1280 2131 1267 36 243 474 282 12 54
0.01% 4.78% 0.27% 1.62% 0.82% 0.82% 0.03% 0.20% 0.12% 0.03% 18.21% 11.00% 30.00% 15.00% 1.00% 9.00% 9.00% 6.29% 9.00% 2.00% 2.00% 2.00% 2.00%
.
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ GL CODE
MAY MEMBERSHIP SUBSCRIPTIONS TELEPHONE INCOME COMMISSION ATM INTEREST RECEIVED INSURANCE CLAIMS VENDING MACHINE INCOME MEMBERS BOOK SPONSORS
TOTAL OTHER INCOME
JUN
JUL
AUG
SEPT
OCT
NOV
DEC
JAN
FEB
_x000D__x000D__x000D_
MAR
APR
TOTAL
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
30
30
30
30
30
30
30
30
30
30
30
30
0
0
0
0
0
0
0
0
0
0
0
0
36,000 0
1,219
1,140
1,264
1,338
1,215
1,215
1,312
1,154
1,609
1,098
1,095
1,114
14,773
0
0
0
0
0
0
0
0
0
0
0
0
360
0
0
0
0
0
0
0
0
0
0
0
0
0
0
500
500
500
500
500
500
500
500
500
500
500
500
6,000
0
0
0
0
0
0
0
0
0
0
0
0
0
4,749
4,670
4,794
4,868
4,745
4,745
4,842
4,684
5,139
4,628
4,625
4,644
57,133
ENTERTAINMENT ENTERTAINMENT - MEMBERS
0
0
0
0
0
0
0
0
0
0
0
0
0
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
96,000
970
970
970
970
970
970
970
970
970
970
970
970
11,640
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
107,640
RAFFLE INCOME
5,078
3,558
4,122
4,679
4,158
3,866
2,449
1,864
2,187
1,864
4,629
5,315
43,769
TOTAL INCOME
5,078
3,558
4,122
4,679
4,158
3,866
2,449
1,864
2,187
1,864
4,629
5,315
43,769
0
0
0
0
0
0
0
0
0
0
0
0
0
3,490
BANDS AND ARTISTS AUSTAR TOTAL ENTERTAINMENT EXPENSES
PROMOTIONS
LESS : EXPENSES ADVERTISING RAFFLE EXPENSES
0
5,583
2,899
3,825
4,182
2,226
1,113
2,291
1,525
3,521
4,602
35,257
750
750
750
750
750
750
750
750
750
750
750
750
9,000
PROMO
0
0
0
0
0
0
0
0
0
0
0
0
0
PROMOTIONS
0
0
0
0
0
0
0
0
0
0
0
0
0
MEMBERS DRAW
TOTAL PROMOTIONS EXPENSES
4,240
750
6,333
3,649
4,575
4,932
2,976
1,863
3,041
2,275
4,271
5,352
44,257
NET EXPENSES AFTER INCOME
-838
-2,808
2,211
-1,030
417
1,066
527
-1
854
411
-358
37
488
MEMBERSHIP CARDS
0
0
0
0
0
0
0
0
0
0
0
0
0
FLORAL TRIBUTES
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL EXPENSES
0
0
0
0
0
0
0
0
0
0
0
0
0
MEMBERS AMENITIES
SERVICE & MAINTENANCE CLEANING MATERIALS
0
0
0
20
0
0
0
0
0
0
0
0
20
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
84,000
CLEANING GENERAL
0
0
0
0
0
0
0
0
0
0
0
0
0
LAUNDRY
0
0
0
0
0
0
0
0
0
0
0
0
FIRE - SERVICE & MAINTENANCE
0
0
0
0
0
0
0
0
0
0
0
0
0
200
200
200
200
200
200
200
200
200
200
200
200
2,400
0
0
0
0
0
0
0
0
0
0
0
0
0
REPAIRS & MAINT. - GAMING
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
30,000
REPAIRS & MAINT. - CATERING
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
CONTRACT CLEANER
PEST CONTROL WASTE REMOVAL
REPAIRS & MAINT. - BAR
300
REPAIRS & MAINTENANCE GENERAL 2,000
0
300
300
300
300
300
300
300
300
300
300
300
3,600
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
24,000
200
200
200
200
200
200
200
200
200
200
200
200
2,400
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
TOTAL SERVICE & MAINT. EXPENSES 14,200
14,200
14,200
14,220
14,200
14,200
14,200
14,200
14,200
14,200
14,200
14,200
170,420
REPAIRS & MAINT. - BU8 REPAIRS & MAINT. - GROUNDS
FINANCE EXPENSES AUDITORS RENUMERATION
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
14,400
COMPUTER SUPPORT
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
155
174
277
399
177
168
231
259
253
179
173
165
71
809
609
479
482
90
68
1,098
155
652
751
467
5,731
CONSULTANTS FEES
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
0
13,200
TOTAL FINANCE EXPENSES
1,426
2,183
4,286
4,278
1,859
1,458
1,499
2,557
1,608
2,031
2,124
632
21,541
BANK CHARGES EFPOS CHARGES
2,610
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_
GL CODE
MAY
MERCHANDISE SALES
JUN
JUL
AUG
2008 SEP
2008 OCT
NOV
DEC
JAN
FEB
MAR
_x000D__x000D__x000D_
APR TOTAL
2000
2000
2000
2000
2000
2000
100
100
100
2000
2000
2000 18300
1300
1300
1300
1300
1300
1300
65
65
65
1300
1300
1300 11895
700
700
700
700
700
700
35
35
35
700
700
700
6405
35%
35%
35%
35%
35%
35%
35%
35%
35%
35%
35%
35%
35%
LESS COST OF SALES: MERCHANDISE EXP
GROSS PROFIT
GROSS PROFIT % TO SALES
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ GL CODE
MAY
JUN
JUL
5,000 700 0 4,049 2 1,031 5,000 500 1,200 63 2,087 80 192
SEPT
200 250 2,205 778 0 6,000 118 120 500 0 800 0 0 14,000 1,000 6,100 1,700 1,179 1,260 90 549 153 280 20 122 0 0
200 250 3,989 958 2,500 6,000 0 120 500 0 800 0 0 13,500 1,000 6,100 1,700 2,053 1,215 90 549 153 270 20 122 0 0
200 250 1,775 670 0 6,000 0 120 500 0 800 0 100 13,500 1,000 6,100 1,700 5,781 1,215 90 549 153 270 20 122 21 0
200 250 2,513 849 0 6,000 0 120 500 450 800 0 0 13,000 1,000 6,100 1,700 2,545 1,170 90 549 153 260 20 122 31 0
200 250 2,452 371 0 6,000 0 120 500 0 800 0 0 13,000 1,000 6,100 1,700 2,316 1,170 90 549 153 260 20 122 25 0
TOTAL ADMIN EXPENSES
57,537
60,428
58,278
58,757
55,115
56,956
55,416
60,642
59,575
57,022
56,125
695,352
o
5,000 700 0 4,049 11 390 5,000 500 0 0 2,087 0 863 o
5,000 700 121 4,049 1 591 5,000 500 0 0 2,087 388 490
TOTAL
200 250 4,968 163 0 6,000 0 120 500 0 800 0 100 13,000 1,000 6,100 1,700 1,911 1,170 90 549 153 260 20 122 0 0
o
5,000 700 0 4,049 1 334 5,000 500 0 0 2,087 227 741
APR
200 250 2,031 1,385 0 6,000 0 120 500 0 800 0 0 13,000 1,000 6,100 1,700 743 1,170 90 549 153 260 20 122 33 0
o
5,000 700 0 4,049 1 711 5,000 500 0 0 2,087 505 0
MAR
200 250 2,684 1,481 0 6,000 0 120 500 350 800 0 0 13,000 1,000 6,100 1,700 2,644 1,170 90 549 153 260 20 122 33 0
o
5,000 700 0 4,049 1 442 5,000 500 0 0 2,087 0 213
FEB
200 250 4,041 1,164 0 6,000 0 120 500 150 800 0 0 13,000 1,000 6,100 1,700 2,090 1,170 90 549 153 260 20 122 39 0
o
5,000 700 36 4,049 1 305 5,000 500 0 0 2,087 0 102
JAN
200 250 2,332 1,101 2,500 6,000 0 120 500 0 800 0 0 13,000 1,000 6,100 1,700 2,518 1,170 90 549 153 260 20 122 39 0
o
5,000 700 12 4,049 2 950 5,000 500 0 0 2,087 350 239
DEC 2008
200 250 2,296 1,325 0 6,000 118 120 500 0 800 0 100 13,000 1,000 6,100 1,700 2,518 1,170 90 549 153 260 20 122 31 0
o
5,000 700 0 4,049 2 340 5,000 500 300 0 2,087 154 1,399
NOV 2008
60,000 8,400 169 48,588 25 6,124 60,000 6,000 2,900 63 25,044 2,572 4,787 0 2,400 3,000 35,167 14,109 5,000 72,000 236 1,440 6,000 950 9,600 0 300 158,000 12,000 73,200 20,400 28,005 14,220 1,080 6,588 1,836 3,160 240 1,464 285 0
o
5,000 700 0 4,049 1 494 5,000 500 700 0 2,087 0 229
OCT
PROMOS / ADVERTISING EXP 5,000 PROMOTIONAL GIFT VOUCHER 700 COURIERS 0 DEPRECIATION 4,049 DONATIONS 1 EQUIPMENT HIRE - ADMIN 266 ELECTRICITY & GAS 5,000 FUEL - BUS 500 GAS OUTDOOR HEATERS 200 GENERAL MGR EXPENSES 0 INSURANCE 2,087 KIDS CLUB 0 LICENSE FEES 179 UNREDEEMED LOYALTY POINTS o o PHOTOCOPIER EXPENSES 200 POSTAGE 250 PAYROLL TAX 3,881 PRINTING & STATIONERY 3,864 RATES / EXCESS WATERS 0 SECURITY 6,000 SUBSCRIPTIONS 0 STAFF MEALS 120 STAFF MEAL DISCOUNTS 500 STAFF TRAINING - ADMIN 0 TELEPHONE EXPENSES 800 TRAVELLING EXPENSES 0 UNIFORMS - ADMIN 0 WAGES - ADMINISTRATION 13,000 WAGES - BUS 1,000 WAGES - RECEPTION 6,100 WAGES - STORE 1,700 LEAVE PROVISION - ADMIN 1,707 SUPERANNUATION - ADMIN 1,170 SUPER BUS 90 SUPER - RECEPTION 549 SUPER - STORES 153 WORKERS COMP - ADMIN 260 WORKERS COMP - BUS 20 WORKERS COMP - RECEPTION 122 WORKERS COMP - STORES 33 SAFE SHORTS / OVERS 0
59,501
5,000 700 0 4,049 1 270 5,000 500 500 0 2,087 868 140
AUG
_x000D__x000D__x000D_
o
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ JUL NET PROFIT
AUG
SEP
OCT
NOV
#NAME? #NAME?
DEC
#NAME?
#NAME?
MEMBERSHIP CARDS
0
0
0
0
0
MEMBERSHIP SUBS
0
0
0
0
0
ACCOUNTING FEES
0
0
0
0
AUDIT FEES
0
0
0
#NAME?
#NAME?
JAN
#NAME? #NAME?
FEB
MAR
_x000D__x000D__x000D_
APR
MAY
JUN
TOTAL
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#NAME? #NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0
250
TIMING DIFFERENCES ADD
RENT INSURANCE
250
0
#NAME?
#NAME?
GAMING TAX - STATE
0
0
0
GAMING TAX - FEDERAL
0
0
0
WAGES - GROSS
#NAME?
#NAME?
SOFTWARE SUPPORT SUB TOTAL
0 #NAME?
0 #NAME? #REF!
#NAME?
#NAME? #REF!
INSURANCE - W/COMP
0
0
0
0
0
0
0
0
#NAME? #NAME?
0
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#NAME? #NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0
0
0
0
0
0
0
0
#NAME? #REF!
#NAME? #REF!
0
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
0 #NAME? #REF!
LESS MEMBERSHIP CARDS
0
0
0
0
0
0
0
0
0
0
0
0
0
MEMBERSHIP SUBS
0
0
0
0
0
0
0
0
0
0
0
0
0
ACCOUNTING FEES
0
0
0
0
0
0
0
0
0
0
0
0
0
AUDIT FEES
0
0
0
0
0
0
0
0
0
0
0
0
0
INSURANCE
0
0
0
0
0
0
0
0
0
0
0
0
0
INSURANCE - W/COMP
0
0
0
0
0
0
0
0
0
0
0
0
0
SOFTWARE SUPPORT
0
0
0
0
0
0
0
0
0
0
0
0
0
GAMING TAX - STATE
0
0
0
0
0
0
0
0
0
0
0
0
0
GAMING TAX - FEDERAL
0
0
0
0
0
0
0
0
0
0
0
0
0
WAGES - NET
0
0
0
0
0
0
0
0
0
0
0
0
0
WAGES - PAYG TAX
0
0
0
0
0
0
0
0
0
0
0
0
0
HOPPERS
0
0
0
0
0
0
0
0
0
0
0
0
0
CAPITAL FINANCE PAYMENTS
0
0
0
0
0
0
0
0
0
0
0
0
0
INVEST MANAGED FUND
0
0
0
0
0
0
0
0
0
0
0
0
0
AIRCONDITIONER UPGRADE
0
0
0
0
0
0
0
0
0
0
0
0
0
IT UPGRADES
0
0
0
0
0
0
0
0
0
0
0
0
0
GAMING ROOM IMPROVEMENTS
0
0
0
0
0
0
0
0
0
0
0
0
0
MAIN BAR - BAR TOPS
0
0
0
0
0
0
0
0
0
0
0
0
0
SURF CLUB DONATIONS
0
0
0
0
0
0
0
0
0
0
0
0
RENT SURF CLUB
0
0
0
0
0
0
0
0
0
0
0
0
0
SURF CLUB DONATION
0
0
0
0
0
0
0
0
0
0
0
0
0
SUB TOTAL
0
0
0
0
0
0
0
0
0
0
0
0
0
CASHFLOW
#NAME? #REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#VALUE! #REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#VALUE! #REF!
#REF!
#REF!
#REF!
BALANCE B/F PROGRESSIVE CASHFLOW
#NAME?
#VALUE!
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_
_x000D__x000D__x000D_
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
_x000D__x000D__x000D_
. OCT $
2008 NOV $
2008 DEC $
JAN $
FEB $
MAR $
57,960
57,959
57,223
60,502
53,794
56,256
28146 44696
36400 61348
38419 51313
38901 46598
39925 46123
37430 40177
4749 700
4670 700
4794 700
4868 700
4745 700
4745 700
138237
126538
161202 153259 148167 151995
JUL $
AUG $
BAR TRADING
51,022
48,326
CATERING TRADING POKER MACHINE TRADING
34801 46965
SEPT $
APR $
MAY $
JUNE $
TOTAL $
60,106 44,550
49,946
49,556
647,199
37036 61505
41711 45985
21977 33934
28031 40170
30476 43777
413253 562590
4842 35
4684 35
5139 35
4628 700
4625 700
4644 700
57133 6405
136278
159516
123471 129154
1686581
INCOME
SUNDRY MERCHANDISE
TOTAL GROSS INCOME
152977 105788
DEDUCT : EXPENSES
ENTERTAINMENT PROMOTIONS MEMBERS AMENITIES SERVICE & MAINTENANCE FINANCE ADMIN & OVERHEAD
8970 5078
8970 750
8970 6333
8970 3649
8970 4575
8970 4932
8970 2976
8970 1863
8970 3041
8970 2275
8970 4271
8970 5352
107640 43769
14200 1426 59501
14200 2183 57537
14200 4286 60428
14220 4278 58278
14200 1859 58757
14200 1458 55115
14200 1499 56956
14200 2557 55416
14200 1608 60642
14200 2031 59575
14200 2124 57022
14200 632 56125
170420 21541 695352
TOTAL EXPENSES
89175
83640
94217
89395
88361
84675
84601
83006
88461
87051
86587
85279
1044448
NET PROFIT BEFORE TAX
49062
42898
66985
63864
59806
67320
51677
76510
64516
18737
36884
43875
642133
SURF CLUB EXPENSES SURF CLUB OTHER LOAN INTEREST PAID
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
60000
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
9000 3800
108000 45600
NET PROFIT AFTER TAX
31262
25098
49185
46064
42006
49520
33877
58710
46716
937
19084
26075
428533
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_
_x000D__x000D__x000D_
BAR SALES BOTTLE SHOP BREAD & MILK
2010 MAY A 116,500 8,000 300
2010 JUNE A 111,000 8,000 300
2010 JULY A 129,000 11,000 300
2010 AUG AA 133,000 9,000 300
2010 SEPT A 130,000 9,500 300
2010 OCT A 136,000 8,000 3,000
2010 NOV A 130,000 9,500 300
DEC B 140,000 9,000 300
JAN B 146,000 8,500 300
FEB B 109,000 7,000 300
MAR B 118,000 8,000 300
APR TOTAL B 116,000 1,514,500 8,500 104,000 300 6,300
NET BAR SALES
124,800
119,300
140,300
142,300
139,800
147,000
139,800
149,300
154,800
116,300
126,300
124,800 1,624,800
COST OF SALES
44,928
42,948
50,508
51,228
50,328
52,920
53,124
56,734
57,276
43,031
46,731
46,176
GROSS PROFIT
79,872
76,352
89,792
91,072
89,472
94,080
86,676
92,566
97,524
73,269
79,569
78,624 1,028,868 63.3%
UNDERS & OVERS 12 PROMOS & ADVERTISING 1750 LOYALTY REDEMPTIONS 200 CONSUMABLES 699 GAS BAR 209 WAGES - BAR 20,970 WAGES - BOTTLE SHOP 1,282 WAGES - LEAVE PROV 1282 SUPER - BAR 1,887 SUPER - B.S 115 WORKERS COMP - BAR 419 WORKERS COMP - B.S. 26
11 1750 200 666 645 19,980 1,221 1221 1,798 110 400 24
13 1750 150 774 377 23,220 1,419 1419 2,090 128 464 28
13 1750 250 798 641 23,940 1,463 1463 2,155 132 479 29
13 1750 250 780 465 23,400 1,430 1430 2,106 129 468 29
14 1750 200 816 469 24,480 1,496 1496 2,203 135 490 30
13 1750 300 780 1048 23,400 1,430 1430 2,106 129 468 29
14 1750 300 840 631 26,600 1,540 1540 2,394 139 532 31
15 1750 300 876 297 27,740 1,606 1606 2,497 145 555 32
11 1750 200 654 586 20,710 1,199 1199 1,864 108 414 24
12 1750 300 708 538 21,240 1,298 1298 1,912 117 425 26
12 1750 250 696 491 20,880 1,276 1276 1,879 115 418 26
151 ### 21000 1.4% 2900 0.2% 9087 0.6% 6397 0.4% 276560 18.3% 16660 1.1% 16660 1.1% 24890 9.0% 1499 9.0% 5531 2.0% 333 2.0%
TOTAL OTHER EXPENSES 28,850
28,026
31,832
33,113
32,249
33,578
32,882
36,310
37,418
28,719
29,623
29,068
381,669 23.5%
NET INCOME FOR BAR
51,022
48,326
57,960
57,959
57,223
60,502
53,794
56,256
60,106
44,550
49,946
49,556
647,199
% OF NET INCOME TO TOTAL SALES
43.80%
43.54%
44.93%
43.58%
44.02%
44.49%
41.38%
40.18%
41.17%
40.87%
42.33%
42.72%
42.73%
595,932 36.7%
63 until may
LESS : OTHER EXPENSES
19 until march
.
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ 2010 GL CODE
MAY POKER MACHINE TAKINGS KENO TAKINGS POKER MACHINE REVENUE
2010
JUNE
2010
JUL
2010
AUG
2010
SEPT
2010
OCT
_x000D__x000D__x000D_
2010
NOV
DEC
JAN
FEB
MAR
APR
TOTAL
84100 81164 105443 92486 85857 83843 82433 100981 88271 69036 74971 80438 1029023 3523 3258 3195 2808 2351 2786 2946 2782 2831 1953 2606 3150 34189 87623 84422 108638 95294 88208 86629 85379 103763 91102 70989 77577 83588 1063212
LESS : OTHER EXPENSES
UNDERS & OVERS - GAMING 2 2 UNDERS & OVERS - KENO 0 0 PROMOS & ADVERTISING 4205 4058 SURF REWARDS - PROMO 505 487 DEPRECIATION 5127 5127 EQUIPMENT HIRE 2300 2300 KENO CONNECTION FEE 1117 1117 KENO STATIONERY 200 200 LICENSE FEES & TAXES 15714 15172 MGMT FEE - MONEY TRAIN 1780 1780 MONITORING FEES 720 720 WAGES GAMING 5257 5065 WAGES - PROMOTIONS 2489 2489 WAGES LEAVE PROVISION 384 384 WAGESS - SUPER 473 456 WAGES SUPER - PROMOTIONS 224 224 WORKERS COMP - GAMING 106 95 WORKERS COMP - PROMOTIONS 55 50
2 2 2 2 2 2 2 1 1 2 21 0 0 0 0 0 0 0 0 0 0 1 5272 4624 4293 4192 4122 5049 4414 3452 3749 4022 51451 633 555 515 503 495 606 530 414 450 483 6174 5127 5127 5127 5127 5600 5600 5600 5600 5600 5600 64362 2300 2300 2300 2300 2300 2300 2300 2300 2300 2300 27600 1117 1117 1117 1117 1117 1117 1117 1117 1117 1117 13404 200 200 200 200 200 200 200 200 200 200 2400 19700 17944 16319 15855 19987 15018 19218 12684 12964 14749 195324 1780 1780 1780 1780 1780 1780 1780 1780 1780 1780 21360 720 720 720 720 720 720 720 720 720 720 8640 6518 5718 5292 5198 5123 6226 5466 4259 4655 5015 63793 2489 2489 2489 2489 2489 2489 2489 2489 2489 2489 29868 471 470 594 167 430 265 462 1300 572 521 6020 587 515 476 468 461 560 492 383 419 451 5741 224 224 224 224 224 224 224 224 224 224 2688 105 138 114 119 153 102 104 84 111 87 1318 45 59 47 46 0 0 0 47 57 51 457
0.060% 0.000% 5.0% 0.6% 6.1% 2.6% 1.3% 0.2% 18.4% 2.0% 0.8% 6.0% 2.8%
TOTAL EXPENSES
40658 39726
47290 43981 41610 40506 45202 42258 45117 37055 37407 39811 500622
47.1%
NET INCOME POKER MACHINES 46965 44696
61348 51313 46598 46123 40177 61505 45985 33934 40170 43777 562590
% OF NET INCOME TO NET REVENUE K AVERAGE No Poker Machines .
54%
53%
56%
54%
53%
53%
47%
59%
50%
48%
52%
52%
53%
1685 52
1624 52
2089 52
1833 52
1696 52
1666 52
1642 52
1995 52
1752 52
1365 52
1492 52
1607 245357 52 52
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ GL CO DE
MAY
JUN
JUL
AUG
CATERING SALES 140,000 123,000 144,000 156,000 FUNCTIONS - FOOD SALES 6,000 6,000 6,000 6,000 FUNCTION ROOM HIRE 400 400 400 400 COFFEE SHOP SALES 9,000 9,000 9,000 9,000 COST OF SALES
_x000D__x000D__x000D_
SEPT
OCT
NOV
DEC
JAN
FEB
MAR
APR
159,000 6,000 400 9,000
160,000 6,000 400 9,000
154,000 6,000 400 9,000
165,000 4,000 300 9,000
183,000 4,000 300 9,000
110,000 128,000 136,000 1,758,000 4,000 4,000 4,000 62,000 300 300 300 4,300 9,000 9,000 9,000 108,000
58,275
51,900
59,775
64,275
65,400
65,775
63,525
69,537
76,557
97,125
86,500
99,625 107,125
109,000
109,625
105,875
108,763
119,743
14 7000 400 1518 1200 1200 50 300 180 0 25200 15400 2700 900 1400 2268 1386 81 243 504 308 18 54
12 7000 400 3219 1200 1200 50 300 180 0 22140 13530 2700 900 1230 1993 1218 54 243 443 271 18 54
14 7000 400 1118 1200 1200 50 300 180 0 25920 15840 2700 900 1440 2333 1426 54 243 518 317 18 54
16 7000 400 2615 1200 1200 50 300 180 0 28080 17160 2700 900 1560 2527 1544 54 243 562 343 18 54
16 7000 400 2903 1200 1200 50 300 180 109 28620 17490 2700 900 1590 2576 1574 54 243 572 350 18 54
16 7000 400 2281 1200 1200 50 300 180 0 28800 17600 2700 900 1600 2592 1584 54 243 576 352 18 54
15 7000 400 3018 1200 1200 50 300 180 0 27720 16940 2700 900 1540 2495 1525 54 243 554 339 18 54
17 7000 400 2056 1200 1200 50 300 180 0 30525 18150 2700 600 1650 2747 1634 36 243 611 363 12 54
18 7000 400 2285 1200 1200 50 300 180 0 33855 20130 2700 600 1830 3047 1812 36 243 677 403 12 54
11 7000 400 2864 1200 1200 50 300 180 500 20350 12100 2700 600 1100 1832 1089 36 243 407 242 12 54
14 7000 400 2208 1200 1200 50 300 180 0 25160 14960 2700 600 1360 2264 1346 36 243 503 299 12 54
176 84000 4800 28479 14400 14400 600 3600 2160 609 320050 193380 32400 9300 17580 28805 17404 585 2916 6401 3868 186 648
11 TOTAL OTHER EXPENSES 62,324
11 58,354
11 63,225
11 68,706
11 70,099
11 69,700
11 68,445
11 71,727
11 78,032
11 11 11 54,470 59,575 62,090
786,746
28,146
36,400
38,419
38,901
39,925
37,430
37,036
41,711
21,977 28,031 30,476
413,253
24.86% 22.88% 25.28% 24.63%
24.47%
24.95%
24.31%
22.45%
22.79%
19.98% 21.90% 22.41%
23.51%
GROSS PROFIT
46,854 53,694 56,734
TOTAL
5.0%
732,301
37.9%
76,446 87,606 92,566 1,199,999
62.1%
LESS : OTHER EXPENSES
Unders / Overs Promotion / advertising loyalty redemptions Consumables - catering Equipment Hire gas - Catering Cleaning Expenses Linen Hire liquid waste removal Uniforms - catering Wages - food prepared Wages - food served Wages - café Wages - functions Wages - leave Provision wages - super food prep wages - Super food serve Wages - Super functions Wages - Super Café workers comp prepared workers comp served workers comp Functions workers comp café
NET INCOME
% OF NET INCOME TO TOTAL SALES
34,801
13 7000 400 2394 1200 1200 50 300 180 0 23680 14080 2700 600 1280 2131 1267 36 243 474 282 12 54
0.01% 4.78% 0.27% 1.62% 0.82% 0.82% 0.03% 0.20% 0.12% 0.03% 18.21% 11.00% 30.00% 15.00% 1.00% 9.00% 9.00% 6.29% 9.00% 2.00% 2.00% 2.00% 2.00%
.
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ GL CODE
MAY MEMBERSHIP SUBSCRIPTIONS TELEPHONE INCOME COMMISSION ATM INTEREST RECEIVED INSURANCE CLAIMS VENDING MACHINE INCOME MEMBERS BOOK SPONSORS
TOTAL OTHER INCOME
JUN
JUL
AUG
SEPT
OCT
NOV
DEC
JAN
FEB
_x000D__x000D__x000D_
MAR
APR
TOTAL
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
30
30
30
30
30
30
30
30
30
30
30
30
0
0
0
0
0
0
0
0
0
0
0
0
36,000 0
1,219
1,140
1,264
1,338
1,215
1,215
1,312
1,154
1,609
1,098
1,095
1,114
14,773
0
0
0
0
0
0
0
0
0
0
0
0
360
0
0
0
0
0
0
0
0
0
0
0
0
0
0
500
500
500
500
500
500
500
500
500
500
500
500
6,000
0
0
0
0
0
0
0
0
0
0
0
0
0
4,749
4,670
4,794
4,868
4,745
4,745
4,842
4,684
5,139
4,628
4,625
4,644
57,133
ENTERTAINMENT ENTERTAINMENT - MEMBERS
0
0
0
0
0
0
0
0
0
0
0
0
0
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
96,000
970
970
970
970
970
970
970
970
970
970
970
970
11,640
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
8,970
107,640
RAFFLE INCOME
5,078
3,558
4,122
4,679
4,158
3,866
2,449
1,864
2,187
1,864
4,629
5,315
43,769
TOTAL INCOME
5,078
3,558
4,122
4,679
4,158
3,866
2,449
1,864
2,187
1,864
4,629
5,315
43,769
0
0
0
0
0
0
0
0
0
0
0
0
0
3,490
BANDS AND ARTISTS AUSTAR TOTAL ENTERTAINMENT EXPENSES
PROMOTIONS
LESS : EXPENSES ADVERTISING RAFFLE EXPENSES
0
5,583
2,899
3,825
4,182
2,226
1,113
2,291
1,525
3,521
4,602
35,257
750
750
750
750
750
750
750
750
750
750
750
750
9,000
PROMO
0
0
0
0
0
0
0
0
0
0
0
0
0
PROMOTIONS
0
0
0
0
0
0
0
0
0
0
0
0
0
MEMBERS DRAW
TOTAL PROMOTIONS EXPENSES
4,240
750
6,333
3,649
4,575
4,932
2,976
1,863
3,041
2,275
4,271
5,352
44,257
NET EXPENSES AFTER INCOME
-838
-2,808
2,211
-1,030
417
1,066
527
-1
854
411
-358
37
488
MEMBERSHIP CARDS
0
0
0
0
0
0
0
0
0
0
0
0
0
FLORAL TRIBUTES
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL EXPENSES
0
0
0
0
0
0
0
0
0
0
0
0
0
MEMBERS AMENITIES
SERVICE & MAINTENANCE CLEANING MATERIALS
0
0
0
20
0
0
0
0
0
0
0
0
20
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
7,000
84,000
CLEANING GENERAL
0
0
0
0
0
0
0
0
0
0
0
0
0
LAUNDRY
0
0
0
0
0
0
0
0
0
0
0
0
FIRE - SERVICE & MAINTENANCE
0
0
0
0
0
0
0
0
0
0
0
0
0
200
200
200
200
200
200
200
200
200
200
200
200
2,400
0
0
0
0
0
0
0
0
0
0
0
0
0
REPAIRS & MAINT. - GAMING
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
2,500
30,000
REPAIRS & MAINT. - CATERING
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
CONTRACT CLEANER
PEST CONTROL WASTE REMOVAL
REPAIRS & MAINT. - BAR
300
REPAIRS & MAINTENANCE GENERAL 2,000
0
300
300
300
300
300
300
300
300
300
300
300
3,600
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
24,000
200
200
200
200
200
200
200
200
200
200
200
200
2,400
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
TOTAL SERVICE & MAINT. EXPENSES 14,200
14,200
14,200
14,220
14,200
14,200
14,200
14,200
14,200
14,200
14,200
14,200
170,420
REPAIRS & MAINT. - BU8 REPAIRS & MAINT. - GROUNDS
FINANCE EXPENSES AUDITORS RENUMERATION
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
14,400
COMPUTER SUPPORT
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
155
174
277
399
177
168
231
259
253
179
173
165
71
809
609
479
482
90
68
1,098
155
652
751
467
5,731
CONSULTANTS FEES
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
0
13,200
TOTAL FINANCE EXPENSES
1,426
2,183
4,286
4,278
1,859
1,458
1,499
2,557
1,608
2,031
2,124
632
21,541
BANK CHARGES EFPOS CHARGES
2,610
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_
GL CODE
MAY
MERCHANDISE SALES
JUN
JUL
AUG
2008 SEP
2008 OCT
NOV
DEC
JAN
FEB
MAR
_x000D__x000D__x000D_
APR TOTAL
2000
2000
2000
2000
2000
2000
100
100
100
2000
2000
2000 18300
1300
1300
1300
1300
1300
1300
65
65
65
1300
1300
1300 11895
700
700
700
700
700
700
35
35
35
700
700
700
6405
35%
35%
35%
35%
35%
35%
35%
35%
35%
35%
35%
35%
35%
LESS COST OF SALES: MERCHANDISE EXP
GROSS PROFIT
GROSS PROFIT % TO SALES
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ GL CODE
MAY
JUN
JUL
5,000 700 0 4,049 2 1,031 5,000 500 1,200 63 2,087 80 192
SEPT
200 250 2,205 778 0 6,000 118 120 500 0 800 0 0 14,000 1,000 6,100 1,700 1,179 1,260 90 549 153 280 20 122 0 0
200 250 3,989 958 2,500 6,000 0 120 500 0 800 0 0 13,500 1,000 6,100 1,700 2,053 1,215 90 549 153 270 20 122 0 0
200 250 1,775 670 0 6,000 0 120 500 0 800 0 100 13,500 1,000 6,100 1,700 5,781 1,215 90 549 153 270 20 122 21 0
200 250 2,513 849 0 6,000 0 120 500 450 800 0 0 13,000 1,000 6,100 1,700 2,545 1,170 90 549 153 260 20 122 31 0
200 250 2,452 371 0 6,000 0 120 500 0 800 0 0 13,000 1,000 6,100 1,700 2,316 1,170 90 549 153 260 20 122 25 0
TOTAL ADMIN EXPENSES
57,537
60,428
58,278
58,757
55,115
56,956
55,416
60,642
59,575
57,022
56,125
695,352
o
5,000 700 0 4,049 11 390 5,000 500 0 0 2,087 0 863 o
5,000 700 121 4,049 1 591 5,000 500 0 0 2,087 388 490
TOTAL
200 250 4,968 163 0 6,000 0 120 500 0 800 0 100 13,000 1,000 6,100 1,700 1,911 1,170 90 549 153 260 20 122 0 0
o
5,000 700 0 4,049 1 334 5,000 500 0 0 2,087 227 741
APR
200 250 2,031 1,385 0 6,000 0 120 500 0 800 0 0 13,000 1,000 6,100 1,700 743 1,170 90 549 153 260 20 122 33 0
o
5,000 700 0 4,049 1 711 5,000 500 0 0 2,087 505 0
MAR
200 250 2,684 1,481 0 6,000 0 120 500 350 800 0 0 13,000 1,000 6,100 1,700 2,644 1,170 90 549 153 260 20 122 33 0
o
5,000 700 0 4,049 1 442 5,000 500 0 0 2,087 0 213
FEB
200 250 4,041 1,164 0 6,000 0 120 500 150 800 0 0 13,000 1,000 6,100 1,700 2,090 1,170 90 549 153 260 20 122 39 0
o
5,000 700 36 4,049 1 305 5,000 500 0 0 2,087 0 102
JAN
200 250 2,332 1,101 2,500 6,000 0 120 500 0 800 0 0 13,000 1,000 6,100 1,700 2,518 1,170 90 549 153 260 20 122 39 0
o
5,000 700 12 4,049 2 950 5,000 500 0 0 2,087 350 239
DEC 2008
200 250 2,296 1,325 0 6,000 118 120 500 0 800 0 100 13,000 1,000 6,100 1,700 2,518 1,170 90 549 153 260 20 122 31 0
o
5,000 700 0 4,049 2 340 5,000 500 300 0 2,087 154 1,399
NOV 2008
60,000 8,400 169 48,588 25 6,124 60,000 6,000 2,900 63 25,044 2,572 4,787 0 2,400 3,000 35,167 14,109 5,000 72,000 236 1,440 6,000 950 9,600 0 300 158,000 12,000 73,200 20,400 28,005 14,220 1,080 6,588 1,836 3,160 240 1,464 285 0
o
5,000 700 0 4,049 1 494 5,000 500 700 0 2,087 0 229
OCT
PROMOS / ADVERTISING EXP 5,000 PROMOTIONAL GIFT VOUCHER 700 COURIERS 0 DEPRECIATION 4,049 DONATIONS 1 EQUIPMENT HIRE - ADMIN 266 ELECTRICITY & GAS 5,000 FUEL - BUS 500 GAS OUTDOOR HEATERS 200 GENERAL MGR EXPENSES 0 INSURANCE 2,087 KIDS CLUB 0 LICENSE FEES 179 UNREDEEMED LOYALTY POINTS o o PHOTOCOPIER EXPENSES 200 POSTAGE 250 PAYROLL TAX 3,881 PRINTING & STATIONERY 3,864 RATES / EXCESS WATERS 0 SECURITY 6,000 SUBSCRIPTIONS 0 STAFF MEALS 120 STAFF MEAL DISCOUNTS 500 STAFF TRAINING - ADMIN 0 TELEPHONE EXPENSES 800 TRAVELLING EXPENSES 0 UNIFORMS - ADMIN 0 WAGES - ADMINISTRATION 13,000 WAGES - BUS 1,000 WAGES - RECEPTION 6,100 WAGES - STORE 1,700 LEAVE PROVISION - ADMIN 1,707 SUPERANNUATION - ADMIN 1,170 SUPER BUS 90 SUPER - RECEPTION 549 SUPER - STORES 153 WORKERS COMP - ADMIN 260 WORKERS COMP - BUS 20 WORKERS COMP - RECEPTION 122 WORKERS COMP - STORES 33 SAFE SHORTS / OVERS 0
59,501
5,000 700 0 4,049 1 270 5,000 500 500 0 2,087 868 140
AUG
_x000D__x000D__x000D_
o
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_ JUL NET PROFIT
AUG
SEP
OCT
NOV
#NAME? #NAME?
DEC
#NAME?
#NAME?
MEMBERSHIP CARDS
0
0
0
0
0
MEMBERSHIP SUBS
0
0
0
0
0
ACCOUNTING FEES
0
0
0
0
AUDIT FEES
0
0
0
#NAME?
#NAME?
JAN
#NAME? #NAME?
FEB
MAR
_x000D__x000D__x000D_
APR
MAY
JUN
TOTAL
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#NAME? #NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0
250
TIMING DIFFERENCES ADD
RENT INSURANCE
250
0
#NAME?
#NAME?
GAMING TAX - STATE
0
0
0
GAMING TAX - FEDERAL
0
0
0
WAGES - GROSS
#NAME?
#NAME?
SOFTWARE SUPPORT SUB TOTAL
0 #NAME?
0 #NAME? #REF!
#NAME?
#NAME? #REF!
INSURANCE - W/COMP
0
0
0
0
0
0
0
0
#NAME? #NAME?
0
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#NAME? #NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0
0
0
0
0
0
0
0
#NAME? #REF!
#NAME? #REF!
0
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
0 #NAME? #REF!
LESS MEMBERSHIP CARDS
0
0
0
0
0
0
0
0
0
0
0
0
0
MEMBERSHIP SUBS
0
0
0
0
0
0
0
0
0
0
0
0
0
ACCOUNTING FEES
0
0
0
0
0
0
0
0
0
0
0
0
0
AUDIT FEES
0
0
0
0
0
0
0
0
0
0
0
0
0
INSURANCE
0
0
0
0
0
0
0
0
0
0
0
0
0
INSURANCE - W/COMP
0
0
0
0
0
0
0
0
0
0
0
0
0
SOFTWARE SUPPORT
0
0
0
0
0
0
0
0
0
0
0
0
0
GAMING TAX - STATE
0
0
0
0
0
0
0
0
0
0
0
0
0
GAMING TAX - FEDERAL
0
0
0
0
0
0
0
0
0
0
0
0
0
WAGES - NET
0
0
0
0
0
0
0
0
0
0
0
0
0
WAGES - PAYG TAX
0
0
0
0
0
0
0
0
0
0
0
0
0
HOPPERS
0
0
0
0
0
0
0
0
0
0
0
0
0
CAPITAL FINANCE PAYMENTS
0
0
0
0
0
0
0
0
0
0
0
0
0
INVEST MANAGED FUND
0
0
0
0
0
0
0
0
0
0
0
0
0
AIRCONDITIONER UPGRADE
0
0
0
0
0
0
0
0
0
0
0
0
0
IT UPGRADES
0
0
0
0
0
0
0
0
0
0
0
0
0
GAMING ROOM IMPROVEMENTS
0
0
0
0
0
0
0
0
0
0
0
0
0
MAIN BAR - BAR TOPS
0
0
0
0
0
0
0
0
0
0
0
0
0
SURF CLUB DONATIONS
0
0
0
0
0
0
0
0
0
0
0
0
RENT SURF CLUB
0
0
0
0
0
0
0
0
0
0
0
0
0
SURF CLUB DONATION
0
0
0
0
0
0
0
0
0
0
0
0
0
SUB TOTAL
0
0
0
0
0
0
0
0
0
0
0
0
0
CASHFLOW
#NAME? #REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#VALUE! #REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#VALUE! #REF!
#REF!
#REF!
#REF!
BALANCE B/F PROGRESSIVE CASHFLOW
#NAME?
#VALUE!
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
PALM BEACH SUPPORTERS CLUB_x000D_PROJECTED BUDGET _x000D_
_x000D__x000D__x000D_
_x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D__x000D_PAGE 1
Related Documents
Palm Beach Budget 2009-10 V1
July 2020 1
Palm Beach Resort.docx
June 2020 0
200910
June 2020 49
Grant Budget V1
November 2019 6
Palm
April 2020 5
Seizure Warrant For Madoff's Palm Beach Home
April 2020 1More Documents from "DealBook"
Palm Beach Budget 2009-10 V1
July 2020 1
Herbal Abortion
August 2019 31
Computer Laptop Repairing.docx
April 2020 13
Label Obat Pkm New.docx
June 2020 15
Hotpantz: Herbal Gynecology
August 2019 25