HomeMy WebLinkAboutVideo Lottery Fund OverviewFund 165: Video Lottery
Revenue History
Year
FY 2013-14
I
i
Total
Ql
Q2
Q3
Q4
Quarter
Projected based on average of first 3 quarters
Amount
$144,616
150,080
141,356
145,351 .
$581,403
FY 2012-13
i
Total
• FY 2011-12
i
Total
Ql
Q2
Q3
I Q4
Ql
Q2
Q3
Q4
$126,726
153,680 I
156,112 i
148,394 I
$584,912 i
i
$152,554 •
153,861 :
253,797
54,644
$614,856
FY 2010-11
i
Total
FY 2009-10
Total
Ql
Q2
Q3
Q4
Ql
Q2
Q3
Q4
$128,946
125,231 .
126,193
130,362 •
$510,732 i
I
$129,374 i
119,832 I
116,490 I
119,116
$484,812
, . 'I
Beginning-tinterest I Transfers,
Year Balance I Income L In .' Source
2010-11 General Fund $11 $1,9521 $200,000
2011-12
$993
. $456
$96,833 General Fund
2012-13 J47,333!Yideo Lo~ry Fund
2013-14 $0 N/A
Deschutes County ____ .,~~_.
Econ~D1ic De,,-~lopD1~nt FUIl<l (105)
Four-Year History . ~-----r----
i IILoan .
on Loans: Repayment' Grants Grant Detail Loans i ..,.,..... l-0~m Detail ---i
$0 N/A $1 52,0001Alchemy -$26,000 $66)29 1
. . . 'n)entInstr-t1ments -$12,000
---l-------------
jNavis -$50,000
19L S~utions -$50,000 _
f i A!!ere Pharmaceutical -$14,000
$0 $26,6671 $14,0001 Venture Catalyst i $1 23,000 jl Central Oregon Trucking -$50,000
St Vincent de Paul La Pine -$5,000
---------------. .. "'.
GeoSl'ati,!~_Solutions -$20,0,00
Medisiss -$48,000
$6,1 _$60,.Q()3,L$20...9()QLYenture Cataly~Gl~4,000 Na.vis -$50,000 ____
. E:nergyne~~ing-$34,000
Consumer Cellular -$50,000
$352 $29,331$2~,00Q.I ~merican ~irlines , . ~42,0001I~a.ladjn D(ita COl}> -$3_~~()()O
Vantage Clinical Solutions -$10,000
CATEGORY PROGRAM FY 2013-14
Projected
FY 2013-14
Actual
FY 2014-15 BALANCE
REMAINING
NOTES
RESOURCES
Beginning Net Working Capital 100,000 116,798 0 0
State Video Lottery Revenue 600,000 580,000 580,000 580,000
Interest Revenue 0 1,000 1,000 581,000
TOTAL RESOURCES 581,000 581,000
REQUIREMENTS
Administration Personnel -12,500 -1,400 -12,794 568,206
Includes 10% of Management Analyst expense to be charged as
interfund contract in FY 2014-15
Internal Services -12,500 -10,831 -7,709 560,497
Sub-Total -20,503 560,497
Contingency Contingency 0 560,497 Contingency to allow for unexpected revenue variations
Sub-Total 0 560,497
Economic Development (59-21)EDCO Regional Capacity / Operational Support -112,200 -112,200 0 560,497 Requesting $117,200 for FY 2014-15
Local Capacity: Bend -10,000 -10,000 0 560,497
Local Capacity: La Pine -20,000 -20,000 0 560,497
Local Capacity: Redmond -10,000 -10,000 0 560,497
Local Capacity: Sisters -20,000 -20,000 0 560,497
Venture Catalyst Program -30,000 -30,000 0 560,497
FoundersPad -15,000 -15,000 0 560,497
Business Loan Fund Recapitalization (Fund 105)0 0 0 560,497 Projected balance as of July 1, 2014 = $61,444
Sub-Total 0 560,497
Dues & Memberships (59-10)Central Oregon Intergovernmental Council 12,134 12,970 0 560,497
Invoice for 2014-15 dues = $12,970. In FY 2012-13, Board
indicated interest in finding another source for this item.
Sub-Total 0 560,497
Project Support (59-16 & 59-20)Shop-with-a-Cop Program -3,000 5,000 0 560,497
Public Transit: Rural Services -3,000 -2,500 -2,500 557,997 Grant match committed for FY 2013-14 & FY 2014-15
Volunteer Connect / Project Connect -3,000 0 0 557,997
Bend Westside Traffic Study 0 0 0 557,997 Requesting $25,000.
Other: 0 0 0 557,997
Other: 0 0 0 557,997
Sub-Total -2,500 557,997
Service Partners (59-20)Central Oregon Council on Aging (COCOA)-28,500 -28,500 0 557,997 Mandated or Sole Source Provider
MountainStar Family Relief Nursery -12,000 -12,000 0 557,997 County Involvement
J-Bar-J / Cascade Youth and Family Services -13,000 -13,000 0 557,997 Mandated or Sole Source Provider & County Service Impact
Redmond Senior Center -4,000 -4,000 0 557,997 Mandated or Sole Source Provider & County Service Impact
KIDS Center -20,000 -20,000 0 557,997 County Involvement
Latino Community Association -11,000 -11,000 0 557,997 Mandated or Sole Source Provider
Bethlehem Inn -15,000 -15,000 0 557,997 County Service Impact
Family Access Network (FAN)-10,000 -10,000 0 557,997 Mandated or Sole Source Provider & County Involvement
Saving Grace / Mary's Place -10,000 -10,000 0 557,997 County Involvement and County Service Impact
Central Oregon Veterans' Outreach (COVO)-10,000 -10,000 0 557,997 County Service Impact
Court Appointed Special Advocates (CASA)-30,000 -30,000 0 557,997 Mandated or Sole Source Provider
Central Oregon 2-1-1 -10,000 -10,000 0 557,997 County Involvement
Deschutes County
FY 2014-15 Video Lottery Fund Priorities
Projected Amount Available: $560,497
Upper Deschutes Watershed Council -20,000 -20,000 0 557,997 County Involvement
Other:0 0 0 557,997
Other:0 0 0 557,997
Other:0 0 0 557,997
Sub-Total 0 557,997
Discretionary Grant Program (59-20)Discretionary Grants 60,000 60,000 0 557,997 Divided equally between Commissioners
Fundraising Grants 20,000 20,000 0 557,997
Other:0 0 0 557,997
Other:0 0 0 557,997
Sub-Total 0 557,997
Community Grant Program (59-20)Emergency Food, Clothing and Shelter -75,000 -75,000 0 557,997 Administered by United Way
Health, Mental Health, and Addictions Treatment 0.00%28,425 33,000 0 557,997
Arts & Culture 0.00%6,317 3,000 0 557,997
Other Essential Services 0.00%28,425 30,000 0 557,997 Youth, vulnerable populations, animal welfare & environment
Other:0.00%0 0 0 557,997
Other:0.00%0 0 0 557,997
Sub-Total 0 557,997
TOTAL REQUIREMENTS -23,003
OVER/SHORT 557,997
Note: Total of all FY 2013-14 allocations was $673,673. If all FY 2013-14 allocations remained the same in FY 2014-15, the Video Lottery Fund would be overspent by $92,673.
Deschutes County
Video Lottery Fund (165)
FY 2013-14 Options
The Video Lottery Fund is expected to receive approximately $20,000 less in state payments than originally anticipated for fiscal year
2013-14. To ensure that the fund is not overspent at the end of the fiscal year, an adjustment of approximately $16,000 will be
required, either by reducing planned expenditures or increasing revenue. Options that could accomplish this include:
1. Reduce all outstanding third and fourth quarter Service Partner commitments by approximately 17%.
2. Limit fourth quarter fundraising and Board discretionary grant awards to approximately $19,000 in total, or approximately
$5,000 each (see chart below for fiscal year 2013-14 discretionary grant activity to date).
3. Transfer approximately $16,000 from the General Fund into the Video Lottery Fund.
Commissioner Unger Commissioner Baney Commissioner DeBone Fundraising Activities
Beginning Balance
$
20,000.00 Beginning Balance $21,166.00 Beginning Balance 20,000.00 Beginning Balance $20,000.00
Q1 -4,851.00 Q1 -3,850.00 Q1 -4,499.00 Q1 -4,500.00
Q2 -3,708.00 Q2 -3,708.00 Q2 -3,709.00 Q2 -4,000.00
Q3 -2,033.00 Q3 -2,033.00 Q3 -2,034.00 Q3 -6,700.00
Q4 Q4 Q4 Q4
Total Spent -10,592.00 Total Spent -9,591.00 Total Spent
-
10,242.00 Total Spent -15,200.00
Balance
Remaining
$
9,408.00
Balance
Remaining $11,575.00 Balance Remaining 9,758.00
Balance
Remaining $4,800.00