Fort Vancouver Regional Library District
Statement Of Revenue For the Year Ending July, 2009 (With year-to-date totals) 2009 Budget (Amended Feb. 2009) Property Taxes 0311.10 Property Taxes - Clark 0311.10 Property Taxes - Skamania 0311.10 Property Taxes - Klickitat 0311.10 Property Taxes - Cowlitz Total Property Taxes Other Taxes 0311.11 Other General Tax 0318.20 Leasehold Excise Tax Total Other Taxes Intergovernmental, Grants & Contracts 0332.00 Federal in-lieu of Taxes 0333.00 Readiness to Learn Grant 0335.05 State Forest Boards 0338.72 State Grants-Gates Foundation/ESD 338.72 Department of Early Learning Grant 0338.72 Yale Valley Library Dist 0338.72 INET City of Vancouver (PEG) 0338.72 Contracts - Clark County Jail 0338.72 Contract - City of Camas 0338.72 Pass-Thru - City of Camas 0338.72 Contract - SW Wash Medical Center 0338.72 Pass-thru - SW Wash Medical Center 338.72 VLCFA 0338.72 Library Foundation - Personnel Total Intergovernmental, Grants & Contracts Charges for Services 0341.60 Equipment Use Fees 0347.21 Non-Resident Borrower Fee 0347.90 Lost / Damaged Material Fee 0347.50 Collection Agency Referral Fee Total Charges for Services Miscellaneous 0361.11 Investment Interest 1367.10 Gifts/Contributions 1369.90 Library Friends Groups' Reimbursements 369.90 Library Foundation Reimbursements 1369.40 Insurance Reimbursments 1369.90 Miscellaneous 1369.90 Postage Contributions 1369.90 Other Miscellaneous - E-Rate 1395.00 Sale of Assets Total Miscellaneous $15,019,898 $446,092 $959,552 $190,148 16,615,690 All Revenue Received thru July, 2009 $8,112,771 $256,499 $564,503 $100,378 $9,034,151 Year -to - Date Annual Budget Percent 54.01% 57.50% 58.83% 52.79% 54.37%
July, 2009 Revenues $67,864 $4,456 $5,579 $1,154 $79,053
$100,000 $50,000 $150,000
$2,432 $10,707 $13,139
$51,582 $20,804 $72,386
51.58% 41.61% 48.26%
$2,500 $0 $50,000 $30,000 $120,000 $56,525 $40,000 $500 $15,000 $7,100 $5,000 $4,700 $126,000 $286,000 $743,325
$3,487 $7,154 $2,409 $14,243 $93,035 $0 $0 $0 $0 $0 $0 $0 $0 $48,125 $168,453
$3,773 $22,073 $17,755 $14,243 $119,707 $0 $0 $0 $0 $1,256 $0 $0 $0 $167,990 $346,797
150.92% 0.00% 35.51% 47.48% 99.76% 0.00% 0.00% 0.00% 0.00% 17.69% 0.00% 0.00% 0.00% 58.74% 46.65%
$25,000 $3,000 $30,000 $17,000 $75,000
$1,979 $428 $3,654 $1,180 $7,241
$14,905 $3,444 $23,930 $7,506 $49,785
59.62% 114.80% 79.77% 44.15% 66.38%
$200,000 $2,500 $15,000 $0 $0 $10,000 $0 $50,000 $5,000 $282,500 $17,866,515
$7,366 $275 $1,865 $1,109 $0 $966 $0 $0 $820 $12,401 $280,287
$45,643 $1,953 $8,555 $12,003 $1,768 $10,872 $47 $31,631 $55,709 $168,181 $9,671,300
22.82% 78.12% 57.03% 0.00% 100.00% 108.72% 100.00% 63.26% 1114.18% 59.53% 54.13%
Fort Vancouver Regional Library District
Statement of Expenses For the Year Ending July, 2009 (With year-to-date totals) 2009 Budget (Amended Feb. 2009) Year-to-Date Totals thru July, 2009 Year to Date Annual Budget Percentage
Bars
Description
July, 2009 Expenditures
Personnel Services 01 572.00 01 572.28
Wages & Benefits Unemployment Expense
11,927,758 10,000 11,937,758
921,236 20,905 942,141 25,511 2,932 28,443
6,728,077 34,174 6,762,251 186,781 56,979 243,760
56.41% 341.74% 56.65% 39.68% 11.50% 25.23%
Supplies 02 572.30 02 572.35 & 38
Supplies Computer Supplies / Small Equipment
470,664 495,564 966,228
Library Books / Materials 03 03 572.34 03 572.39
Library Books & Materials Electronic Resources
1,708,000 310,491 2,018,491
105,308 13,926 119,234 100,117 40,005 1,283 1,052 25,300 0 9,600 20,889 7,599 626 206,471 0 0 0 0 0 33,521 11,050 44,571 949 8,716 8,716 $ 1,349,576
733,348 118,003 851,351 485,757 243,935 10,939 6,471 212,595 106,514 163,443 175,681 83,535 4,205 1,493,075 0 0 0 1,139 1,139 66,185 22,958 89,142 6,386 31,371 31,371 $ 9,472,090 199,210 4,959,965 5,159,175
42.94% 38.01% 42.18% 61.10% 39.04% 13.02% 19.97% 53.17% 94.01% 52.85% 36.69% 50.12% 97.79% 49.63% 0.00% 0.00% 0.00% 1.68% 1.68% 110.92% 77.90% 100.00% 55.53% 0.00% 272.79% 52.33%
Other Services / Charges 04 572.41 04 572.42 04 572.43 04 572.44 04 572.45 04 572.46 04 572.47 04 572.48 04 572.49 04 572.50
Professional Services Communications Training / Travel Advertising Rentals / Leases Insurance Utilities Repairs & Maintenance Misc / Dues / Printing / Other Intergovernmental Services
795,070 624,867 84,023 32,400 399,860 113,300 309,260 478,859 166,660 4,300 3,008,599
Capital Outlay 05 572.62 05 594.62 597.62 05 594.64
Buildings / Non-Owned Buildings / Owned Battle Ground Building Fund Machinery & Equipment
0 0 0 67,950 67,950
Debt Services 06 591.70 06 592.80 Contracting Entities 572.51 07 572.52
Debt Service Principal Debt Service Interest
59,671 29,472 89,143
Contract Libraries Expenditures City of Vancouver - Pass through
11,500 0 11,500
Grand Total: Net Cash Activity January 1, 2009 Cash Balance Ending Cash Balance
$
18,099,669
Personnel 2009
Dollars in Thousands
1300.0 1250.0 1200.0 1150.0 1100.0 1050.0 1000.0 950.0 900.0
Month Total Expected Expense Cumulative - Total
Jan 1177 1150
Feb 931 960
Mar 904 960
Apr 942 960
May 929 980
Jun 925 987
Jul 942
Aug
Sep 980
Oct 980
Nov 980
Dec 990
1000 1000
1177 2108 3012 3954 4883 5808 6750 6750 6750 6750 6750 6750
Cumulative - Expected 1150 2110 3070 4030 5010 5997 6997 7997 8977 9957 10937 11927
Professional Services 2009
130.0 120.0 110.0
Dollars in Thousands
100.0 90.0 80.0 70.0 60.0 50.0 40.0 30.0 20.0 10.0 0.0 Jan Feb Mar Apr May Jun 39 39 39 39 60 75 99 67 55 53 91 59 92 92 Jul 55 Aug Sep Oct Nov Dec 55 76 55 55 55
Month Total Expected Expense Cumulative - Total Cumulative - Expected
108 100
166 219 278 386 486 486 486 486 486 486
114 169 260 352 444 499 554 630 685 740 795
** "All Other professional services" includes: OCLC, TSD Preprocessing services, Telephone System configuration and Staff Development Conference"
Small Equipment 2009
180.0 160.0
Dollars in Thousands
140.0 120.0 100.0 80.0 60.0 40.0 20.0 0.0
Month Total Expected Cumulative - Total Cumulative - Expected Jan 3.0 3.0 3.0 3.0 Feb 2.0 2.0 5.0 5.0 Mar 1.6 3.0 6.6 8.0 Apr 42.0 42.0 48.6 50.0 May 0.1 2.0 48.7 52.0 Jun 5.0 5.0 53.7 Jul 2.9 60.0 56.6 75.0 56.6 60.0 56.6 140.0 90.0 56.6 56.6 14.0 56.6 Aug Sep Oct Nov Dec
57.0 117.0 192.0 252.0 392.0 482.0 496.0
General and Other Supplies 2009
Dollars in Thousands
100.0 75.0 50.0 25.0 0.0
Mo. Total Supplies Expected Cumulative - Total
Jan Feb Mar Apr May Jun
Jul
Aug Sep Oct Nov Dec
21.0 18.0 18.0 31.0 18.0 56.0 25.5 25.0 18.0 18.0 31.0 18.0 56.0 20.0 25.0 25.0 25.0 25.0 25.0 21.0 39.0 57.0 88.0 106.0 162.0 187.5 187.5 187.5 187.5 187.5 187.5
Cumulative - Expected 25.0 43.0 61.0 92.0 110.0 166.0 186.0 211.0 236.0 261.0 286.0 311.0
** "All Other Supplies includes Facilities, Computer Services, Janitorial and Summer Reading Supplies
Travel & Training 2009
40.0
Dollars in Thousands
35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0
Expected Month Total Cumulative - Total Cumulative - Expected Jan 1.0 0.2 0.2 1.0 Feb Mar 1.5 1.1 1.3 2.5 5.0 1.5 2.8 7.5 Apr May Jun 5.0 1.8 4.6 5.0 3.1 7.7 5.0 1.9 9.6 Jul 5.0 1.3 10.9 10.9 10.9 10.9 10.9 10.9 Aug Sep 5.0 5.0 Oct 5.0 Nov Dec 4.0 4.5
12.5 17.5 22.5 27.5 32.5 37.5 42.5 46.5 51.0
Capital Expenses 2009
Dollars in Thousands
60.0 55.0 50.0 45.0 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0
Expected Month Total Cumulative - Total Cumulative - Expected
Jan 0.9 0.4 0.4 0.9
Feb 0.0 0.7 1.1 0.9
Mar 0.0 0.0 1.1 0.9
April 0.0 0.0 1.1 0.9
May June 0.0 0.0 1.1 0.9 0.0 0.0 1.1 0.9
Jul 0.0 1.1 0.9
Aug 0.0 1.1 0.9
Sep 0.0 1.1 0.9
Oct 7.0 1.1 7.9
Nov 40.0 1.1 47.9
Dec 0.0 1.1 47.9
Library Materials 2009
300.0 275.0 250.0 225.0 200.0 175.0 150.0 125.0 100.0 75.0 50.0 25.0 0.0
Expected Month Total Cumulative - Total Cumulative - Expected
Dollars in Thousands
Jan 49.0 48.5 48.5 49.0
Feb 80.0 94.1
Mar 80.0 80.0
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
172.0 102.0 244.7 150.7 150.7 116.4 142.6 149.3 138.0 132.2 105.2 102.8 102.9 160.0 101.0 248.5 119.0
142.6 222.6 382.6 483.6 732.1 851.1 851.1 851.1 851.1 851.1 851.1 129.0 209.0 381.0 483.0 727.7 878.4 1029.1 1145.5 1288.1 1437.4 1575.4 1707.6 1812.8 1915.6 2018.
FVRL 2009 CASH BALANCE & MINIMUM CASH LEVEL
8,000,000
7,000,000
6,000,000
5,000,000
4,000,000
3,000,000
2,000,000
1,000,000
CASH BALANCE EXPECTED CASH BAL MINIMUM CASH LEVEL
DEC
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
4,959,859 3,501,883 2,554,237 2,239,636 6,863,515 7,354,595 6,222,669 5,142,299 4,959,859 3,500,000 2,600,000 2,300,000 6,900,000 7,300,000 6,215,000 4,687,000 3,187,000 1,987,000 7,300,000 6,500,000 5,560,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000
MONTHS
2009 REVENUE
10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0
TOTAL REVENUE RECEIVED-Each Month EXPECTED REVENUE-Each Month REVENUE RECEIVED YEAR TO DATE EXPECTED REV RECEIVED YEAR TO DATE
JAN 115,383 150,000 115,383 150,000
FEB 251,276 400,000
MAR
APR
MAY
JUN
JUL 280,287 320,000
AUG 150,000
SEP
OCT
NOV
DEC
882,260 5,958,820 1,752,831 430,933 700,000 6,000,000 1,500,000 400,000
400,000 5,000,000 2,000,000 250,000
366,659 1,248,919 7,207,739 8,960,570 9,391,503 9,671,300 550,000 1,250,000 7,250,000 8,750,000 9,150,000 9,470,000 9,620,000 10,020,00 15,020,00 17,020,00 17,270,00