Treasurer’s Report June 30, 2011
•
•
• •
•
•
•
Funds on deposit as of June 1, 2011 totaled $94,475.63: o Money Market Account: $93,477.83 o Checking Account: $997.80 Income for June totaled $11,352.24 consisting of: o $11,282.50 deposit from the tuition raffle. o $30.00 from Merchandise petty cash returned by Wayne Sapp. o $39.74 in interest on the Money Market account. Expenses for June totaled $90.00 and consisted of: o $90.00 – Check #8408 to Signs-N-Motion for auction signage. Distributions for June totaled $4,984.38 and consisted of: o $2,234.38 – Check #8405 to BK Athletic Department for Spring postseason transportation. o $2,300.00 – Check #8406 to BKHS for the Botball Team transportation expense to California. o $450.00 – Check #8408 to AAA Trophy Mart for post-season trophies and awards. Funds on deposit as of June 30, 2011 totaled $100,753.49. o Money Market Account: $99,830.07 o Checking Account: $923.42 Encumbrances as of June 30, 2011 totaled $41,890.00 and consisted of: o $1,000.00 deposit to Jacksonville Golf and Country Club for 2011 Tournament. o $5,000.00 for the Logan Scholarship for the 2011-2012 School Year. o $90.00 for membership designated dollars. o $7,800.00 for white game uniforms for the football team. o $25,000 annual action proceeds for the athletic department. o $3,000 for new cheerleading uniforms. Total unencumbered balance as of June 30, 2011 was $58,863.49.
Bishop Kenny Booster Club 2010 - 2011 Financial Report Executive Summary 30-Jun-11
Beginning Balance (7/1/2010)
$
81,503.35
Net Income Membership Golf Auction Raffle Interest Merchandise Other Net Income
$ $ $ $ $ $ $ $
29,437.64 11,346.36 49,660.00 9,470.36 366.24 442.00 (81,472.46) 19,250.14
Cash Available for Contributions Contributions Ending Balance (6/30/2011)
$ $ $
100,753.49 (44,118.74) 56,634.75
Ending Cash Balance by Fund $
7/5/11
Contribution 63,442.72
$
Post Season 37,310.77
$
1 of 6
Total 100,753.49
BK_Booster_Club_Treasurers_Report_June 30, 2011.xlsx
Bishop Kenny Booster Club Treasurer's Report as of June 30, 2011
Fund
Post Season
Contribution
Total
Description
Funds as of May 31, 2011
$
56,685.38
$
37,790.25
$
Money Markey: $93,477.83 94,475.63 Checking: $997.80
Income Membership (60% to Contribution & 40% to Post Season) Golf (60% to Contribution & 40% to Post Season) Auction Raffle (60% to Contribution & 40% to Post Season) Interest (Net of Serv. Charges) (60% to Contribution & 40% to Post Season) Merchandise Other Total Income
$ $ $ $ $ $ $ $
6,769.50 23.84 18.00 6,811.34
$ $ $ $ $ $ $ $
4,513.00 15.90 12.00 4,540.90
$ $ $ $ $ $ $ $
11,282.50 39.74 30.00 Petty cash returned by Wayne Sapp 11,352.24
Expenses Membership (60% to Contribution & 40% to Post Season) Golf (60% to Contribution & 40% to Post Season) Auction Raffle (60% to Contribution & 40% to Post Season) Interest (Net of Serv. Charges) (60% to Contribution & 40% to Post Season) Merchandise Direct Mail Postage Printing Bank Fees Other Total Expenses
$ $ $ $ $ $ $ $ $ $ $ $
Net Income - June 30, 2011
$
6,757.34
$
4,504.90
$
11,262.24
Balances before Distributions
$
63,442.72
$
42,295.15
$
105,737.87
Distributions Chk #8405 - BK Athletic Department
$
-
$
(2,234.38) $
(2,234.38) Spring Post-Season Transportation: • Weightlifting - $79.38 • Track - $1,900.00 • Baseball - $255.00
Chk #8406 - BKHS Chk #8409 - AAA Trophy Mart
$ $
-
$ $
(2,300.00) $ (450.00) $
Total Distributions
$ $ $ $ $ $
-
$ $ $ $ $ $
(4,984.38)
$ $ $ $ $ $
(2,300.00) Botball team travel to California for National Robotics Tournament (450.00) Post-Season Trophies and Awards: • Boys' Track - $150.00 • Girls' Track - $150.00 • Baseball - $150.00 (4,984.38)
Fund Balances as of June 30, 2011
$
63,442.72
$
37,310.77
$
Money Markey: $99,830.07 100,753.49 Checking: $923.42
Total Encumbrances
$ $ $ $ $ $ $ $ $
(600.00) (3,000.00) (54.00) (4,680.00) (15,000.00) (1,800.00) (25,134.00)
$ $ $ $ $ $ $ $ $
(400.00) (2,000.00) (36.00) (3,120.00) (10,000.00) (1,200.00) (16,756.00)
$ $ $ $ $ $ $ $ $
(1,000.00) (5,000.00) (90.00) New memberships since $5,040 paid in January (7,800.00) (25,000.00) (3,000.00) (41,890.00)
Unencumbered Fund Balances as of June 30, 2011
$
38,308.72
$
20,554.77
$
Encumbrances Golf Deposit - 2011 Tournament Logan Scholarship - 2011-2012 School Year 3/2/2011 - Membership Designated Dollars 3/3/2011 - White Game Uniforms for Football Team 5/4/2011 - 2011 Annual Auction Proceeds 6/8/2011 - Cheerleader Uniforms
Fund Balances as of June 30, 2010 Unencumbered Fund Balances as of June 30, 2010
7/5/11
(54.00) (54.00)
$ $ $ $ $ $ $ $ $ $ $ $
(36.00) (36.00)
$ $ $ $ $ $ $ $ $ $ $ $
(90.00) Chk #8408 - Signs-N-Motion: Auction Signage (90.00)
58,863.49
$81,503.00 $44,267.82
2 of 6
BK_Booster_Club_Treasurers_Report_June 30, 2011.xlsx
Bishop Kenny Booster Club Treasurer's Report as of June 30, 2011
Net Income by Source
Income Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun YTD 2010/2011
Membership $ $ 13,545.00 $ 13,580.00 $ 1,260.00 $ 450.00 $ $ $ 682.64 $ $ $ $ $ 29,517.64
$ $ $ $ $ $ $ $ $ $ $ $ $
20,380.25 20,380.25
$ $ $ $ $ $ $ $ $ $ $ $ $
Expenses or other Disbursements Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun YTD 2010/2011
$ $ $ $ $ $ $ $ $ $ $ $ $
$ $ $ $ $ $ $ $ $ $ $ $ $
(227.46) (950.00) (6,212.43) (1,644.00) (9,033.89)
$ $ $ $ $ $ $ $ $ $ $ $ $
Net Income Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun YTD 2010/2011
$ $ $ $ $ $ $ $ $ $ $ $ $
$ $ $ $ $ $ $ $ $ $ $ $ $
(227.46) 19,430.25 (6,212.43) (1,644.00) 11,346.36
Total Funds by Source Beginning Balance (June 30, 2010) Net Income from Income Sources Total Funds Available
$ 81,503.35 $ 19,250.14 $ 100,753.49
Distributions by Organization Academic Team Band/Chorus Baseball Basketball - Girls Basketball - Boys Cheerleading Cross Country, Girls Cross Country, Boys Drama Engineering Football Forensics/Debate
$ $ $ $ $ $ $ $ $ $ $ $
7/5/11
(80.00) (80.00) 13,545.00 13,500.00 1,260.00 450.00 682.64 29,437.64
Total (30.00) (165.00) (4,445.00) (937.50) (3,427.13) (405.00) (1,669.50) (1,939.50) (60.00) (1,141.00) (45.00)
Golf
$ $ $ $ $ $ $ $ $ $ $ $ $
$ $ $ $ $ $ $ $ $ $ $ $ $
(250.00) (90.00) (340.00)
$ $ $ $ $ $ $ $ $ $ $ $ $
(1,231.00) (781.14) (2,012.14)
$ $ $ $ $ $ $ $ $ $ $ $ $
-
$ $ $ $ $ $ $ $ $ $ $ $ $
-
$ $ $ $ $ $ $ $ $ $ $ $ $
(2,386.93) (6,677.78) (31,643.50) (289.00) (16,128.16) (11,340.00) (8,140.55) (1,402.34) (1,509.82) (4,984.38) (84,502.46)
$ $ $ $ $ $ $ $ $ $ $ $ $
$ $ $ $ $ $ $ $ $ $ (250.00) $ 50,000.00 $ (90.00) $ 49,660.00
$ $ $ $ $ $ $ $ $ $ $ $ $
200.00 (1,231.00) (781.14) 11,282.50 9,470.36
$ $ $ $ $ $ $ $ $ $ $ $ $
40.20 40.92 28.05 30.14 34.46 32.57 25.29 20.88 20.31 19.37 34.31 39.74 366.24
$ $ $ $ $ $ $ $ $ $ $ $ $
10.00 40.00 362.00 30.00 442.00
$ $ $ $ $ $ $ $ $ $ $ $ $
(2,386.93) (3,677.78) (31,643.50) (289.00) (16,128.16) (11,310.00) (8,140.55) (1,402.34) (1,509.82) (4,984.38) (81,472.46)
$ (2,146.73) $ 9,908.14 $ (18,332.91) $ 1,330.14 $ 19,987.71 $ (22,308.02) $ (12,928.71) $ (7,437.03) $ (1,382.03) $ (1,461.63) $ 47,743.35 $ 6,277.86 $ 19,250.14
-
$ $ $ $ $ $ $ $ $ $ $ $
Aug -
Interest (Net of Serv. Charges) Merchandise 40.20 $ $ 40.92 $ $ 28.05 $ 10.00 $ 30.14 $ 40.00 $ 34.46 $ 362.00 $ 32.57 $ $ 25.29 $ $ 20.88 $ $ 20.31 $ $ 19.37 $ $ 34.31 $ $ 39.74 $ 30.00 $ 366.24 $ 442.00 $
Raffle 200.00 11,282.50 11,482.50
Jul $ $ $ $ $ $ $ $ $ $ $ $
Auction 50,000.00 50,000.00
$ $ $ $ $ $ $ $ $ $ $ $
(150.00) -
Sep $ $ $ $ $ $ $ $ $ $ $ $
Oct -
$ $ $ $ $ $ $ $ $ $ $ $
3 of 6
Nov (144.50) (144.50) -
Other 3,000.00 30.00 3,030.00
Total $ 240.20 $ 16,585.92 $ 13,618.05 $ 1,330.14 $ 21,226.71 $ 32.57 $ 55.29 $ 703.52 $ 20.31 $ 19.37 $ 50,034.31 $ 11,352.24 $ 115,218.63
Dec $ $ $ $ $ $ $ $ $ $ $ $
(3,000.00) (1,420.00) (1,420.00) -
$ $ $ $ $ $ $ $ $ $ $ $
(2,386.93) (6,677.78) (31,950.96) (1,239.00) (22,340.59) (12,984.00) (8,140.55) (1,402.34) (1,481.00) (2,290.96) (5,074.38) (95,968.49)
Jan (30.00) (165.00) (390.00) (300.00) (120.00) (405.00) (105.00) (375.00) (60.00) (765.00) (45.00)
Feb $ $ $ $ $ $ $ $ $ $ $ $
(3,500.00) (376.00) -
Mar $ $ $ $ $ $ $ $ $ $ $ $
(637.50) -
Apr $ $ $ $ $ $ $ $ $ $ $ $
May -
$ $ $ $ $ $ $ $ $ $ $ $
(307.13) -
Jun $ $ $ $ $ $ $ $ $ $ $ $
(405.00) -
BK_Booster_Club_Treasurers_Report_June 30, 2011.xlsx
Bishop Kenny Booster Club Treasurer's Report as of June 30, 2011 Golf, girls Golf, boys Journalism Logan Scholarship Multiproduction ROTC Robotics Soccer, girls Soccer, boys Softball Student Council Swimming/Diving - Girls Swimming/Diving - Boys Tennis - Girls Tennis - Boys Track & Field - girls Track & Field - boys Volleyball Weightlifting Weight Room Renovation Wrestling Zip Club Total Distributions by Organization
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(127.00) (680.86) (15.00) (5,000.00) (180.00) (2,300.00) (2,784.84) (1,995.00) (256.00) (2,742.50) (2,742.50) (306.93) (30.00) (1,340.00) (3,214.80) (2,432.50) (179.58) (3,526.60) (44,118.74)
Total Funds Available as of June 30, 2011
$
56,634.75
$
(44,118.74)
7/5/11
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(216.93) (2,084.80) (85.20) (2,386.93) NA
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(150.00) NA
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(5,000.00) (1,580.50) (6,580.50) NA
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
NA
4 of 6
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(289.00) NA
$ $ (522.86) $ $ $ $ $ $ (2,200.00) $ (1,650.00) $ $ $ (2,375.00) $ (2,375.00) $ $ $ $ $ (147.00) $ $ $ $ $ (15,109.86) NA
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(105.00) (105.00) (15.00) (180.00) (180.00) (195.00) (120.00) (112.50) (112.50) (90.00) (30.00) (240.00) (30.00) (705.00) (15.00) (45.00) (5,040.00) NA
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(3,428.60) (7,304.60) NA
$ $ $ $ $ $ $ $ (404.84) $ (150.00) $ $ $ (105.00) $ (105.00) $ $ $ $ $ $ $ $ $ $ (1,402.34) NA
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
NA
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(22.00) (53.00) (136.00) (150.00) (150.00) (53.00) (871.13) NA
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
(2,300.00) (1,100.00) (1,100.00) (79.38) (4,984.38) NA
BK_Booster_Club_Treasurers_Report_June 30, 2011.xlsx