Second-quarter operations status report

HERMOSA BEACH FRIENDS OF THE LIBRARY FY2013 2Q Operations Status Final Report -- 6/30/2013 Actuals by Quarter | | 1/1/13 3/31/13 | 4/1/13 6/30/13 | 7/1/13 7/2/12 | 10/1/13 12/31/13 | Year to Date | 2013 Annual Budget | 2013 Quarterly Budget | Delta REVENUE: R01 Library Book Sales | 228.00 | 273.00 | | | 501.00 | 925.00 | 231.25 | 424.00 R02 DVD Rentals | 563.00 | 489.00 | | | 1,052.00 | 2,400.00 | 600.00 | 1,348.00 R03 Bookstore Sales | 1,144.75 | 1,263.90 | | | 2,408.65 | 5,800.00 | 1,450.00 | 3,391.35 R04 Monthly Sale (Sat) | 913.50 | 1,093.50 | | | 2,007.00 | 3,600.00 | 900.00 | 1,593.00 R05 Internet Sales | 1,860.43 | 1,277.89 | | | 3,138.32 | 4,600.00 | 1,150.00 | 1,461.68 R06 Membership | 292.50 | 105.00 | | | 397.50 | 2,240.00 | 560.00 | 1,842.50 R07 Donations | 5,000.00 | 1,075.00 | | | 6,075.00 | 8,100.00 | 2,025.00 | 2,025.00 R08 Other | 0.00 | 0.00 | | | 0.00 | 13.01 | 3.25 | 13.01 R09 Misc. | 0.00 | 0.00 | | | 0.00 | 0.00 | 0.00 | 0.00 | $10,002.18 | $5,577.29 | $0.00 | $0.00 | $15,579.47 | $27,678.01 | 6,919.50 | 12,098.54 EXPENSE: E01 Library Books | 42.63 | 0.00 | | | 42.63 | 2,700.00 | 675.00 | 2,657.37 E02 Library Books-Children | 0.00 | 0.00 | | | 0.00 | 2,700.00 | 675.00 | 2,700.00 E03 Library DVDs | 150.62 | 339.45 | | | 490.07 | 1,800.00 | 450.00 | 1,309.93 E04 Subscriptions | 0.00 | 0.00 | | | 0.00 | 2,600.00 | 650.00 | 2,600.00 E05 Rental DVDs | 381.98 | 791.23 | | | 1,173.21 | 1,800.00 | 450.00 | 626.79 E06 Library Supplies | 0.00 | 0.00 | | | 0.00 | 1,000.00 | 250.00 | 1,000.00 E07 Library Equipment | 0.00 | 21.79 | | | 21.79 | 120.00 | 30.00 | 98.21 E08 PAWS to Read | 0.00 | 0.00 | | | 0.00 | 125.00 | 31.25 | 125.00 E09 Library Programs | 120.00 | 0 | | | 120.00 | 300.00 | 75.00 | 180.00 E10 Summer Read | 0.00 | 1,560.00 | | | 1,560.00 | 1,825.00 | 456.25 | 265.00 E11 Teen Territory | 0.00 | 0.00 | | | 0.00 | 0.00 | 0.00 | 0.00 E12 Bookstore Supplies | 0.00 | 0.00 | | | 0.00 | 220.00 | 55.00 | 220.00 E13 Newsletter/ Postage/ PO Box | 330.07 | 0.00 | | | 330.07 | 900.00 | 225.00 | 569.93 E14 Book Marks/ Plates | 0.00 | 0.00 | | | 0.00 | 300.00 | 75.00 | 300.00 E15 Tax Returns/ Fees | 0.00 | 325.00 | | | 325.00 | 355.00 | 88.75 | 30.00 E16 Liability Insurance | 0.00 | 0.00 | | | 0.00 | 320.00 | 80.00 | 320.00 E17 Chamber of Comm | 0.00 | 0.00 | | | 0.00 | 135.00 | 33.75 | 135.00 E18 Other | 0.00 | 0.00 | | | 0.00 | 0.00 | 0.00 | 0.00 | $1,025.30 | $3,037.47 | $0.00 | $0.00 | $4,062.77 | $17,200.00 | 4,300.00 | 13,137.23 OPERATING BALANCE: | 12/31/12 | 3/31/13 | 6/30/13 | 9/30/13 | 12/31/13 Cash on Hand (Petty Cash, etc) | $200.00 | $200.00 | $200.00 Income | | 10,002.18 | 5,577.29 | 0.00 | 0.00 Expenses | | 1,025.30 | 3,037.47 | 0.00 | 0.00 Checking Account | $13,492.44 | $24,413.38 | $28,262.99 | | | * Operating Balance | $13,692.44 | $22,869.32 | $25,609.14 | | | * Notes: * 2012 Year-end Gazin $2500 Donation was deposited in Checking Account on 15Jan2013 therefore Checking Account balance does not reflect Gazin Donation until end of Q1 2013 HB_FOL_Financials_Report_2nd_Quarter_Final_20130713.xls Operations_Status_2013 1 Printed 7/14/13

HERMOSA BEACH FRIENDS OF THE LIBRARY
FY2013 2Q Operations Status Final Report -- 6/30/2013
Actuals by Quarter 1/1/13
REVENUE:
R01 Library Book Sales
R02 DVD Rentals
R03 Bookstore Sales
R04 Monthly Sale (Sat)
R05 Internet Sales
R06 Membership
R07 Donations
R08 Other
R09 Misc.
EXPENSE:
E01 Library Books
E02 Library Books-Children
E03 Library DVDs
E04 Subscriptions
E05 Rental DVDs
E06 Library Supplies
E07 Library Equipment
E08 PAWS to Read
E09
E10
Library Programs
Summer Read
E11 Teen Territory
E12 Bookstore Supplies
E13 Newsletter/ Postage/ PO Box
E14 Book Marks/ Plates
E15 Tax Returns/ Fees
E16 Liability Insurance
E17 Chamber of Comm
E18 Other
3/31/13
228.00
563.00
1,144.75
913.50
1,860.43
292.50
5,000.00
0.00
0.00
$10,002.18
42.63
0.00
150.62
0.00
381.98
0.00
0.00
0.00
120.00
0.00
0.00
0.00
330.07
0.00
0.00
0.00
0.00
0.00
$1,025.30
OPERATING BALANCE:
Cash on Hand (Petty Cash, etc)
ncome
Expenses
Checking Account
Operating Balance
12/31/12
$200.00
$13,492.44
$13,692.44
3/31/13
$200.00
10,002.18
1,025.30
$24,413.38
$22,869.32
4/1/13
6/30/13
273.00
489.00
1,263.90
1,093.50
1,277.89
105.00
1,075.00
0.00
0.00
$5,577.29
0.00
0.00
339.45
0.00
791.23
0.00
21.79
0.00
1,560.00
0.00
0.00
0.00
0.00
325.00
0.00
0.00
0.00
$3,037.47
7/1/13
7/2/12
$0.00 $0.00
$0.00 $0.00
6/30/13
$200.00
5,577.29
3,037.47
$28,262.99
$25,609.14
9/30/13 12/31/13
0.00
0.00
0.00
0.00
Notes:
* 2012 Year-end Gazin $2500 Donation was deposited in Checking Account on 15Jan2013
therefore Checking Account balance does not reflect Gazin Donation until end of Q1 2013|
10/1/13 Year to Date
12/31/13
2013 Annual P013 Quarterly
Budget Budget
501.00
1,052.00]
2,408.65 |
2,007.00 |
3,138.32
397.50
6,075.00
0.00
0.00
$15,579.47
42.63
0.00
490.07
0.00
1,173.21|
0.00
21.79|
0.00
120.00
1,560.00
0.00
0.00
330.07
0.00
325.00
0.00
0.00
0.00
$4,062.77
925.00
2,400.00
5,800.00
3,600.00
4,600.00
2.240.00
8,100.00
13.01
0.00
$27,678.01
2,700.00
2,700.00
1,800.00
2,600.00
1,800.00
1,000.00
120.00
125.00
300.00
1,825.00
0.00
220.00
900.00
300.00
355.00
320.00
135.00
0.00
$17,200.00
231.25
600.00
1,450.00
900.00
1,150.00
560.00
2,025.00
3.25
0.00
6,919.50
675.00
675.00
450.00
650.00
450.00
250.00
30.00
31.25
75.00
456.25
0.00
55.00
225.00
75.00
88.75
80.00
33.75
0.00
4,300.00
HB_FOL_Financials_Report_2nd_Quarter_Final_20130713.xls Operations_Status_2013 1
Delta
424.00
1,348.00
3,391.35
1,593.00
1,461.68
1,842.50
2,025.00
13.01
0.00
12,098.54
2,657.37
2,700.00
1,309.93
2,600.00
626.79
1,000.00
98.21
125.00
180.00
265.00
0.00
220.00
569.93
300.00
30.00
320.00
135.00
0.00
13,137.23
Printed 7/14/13