Budgeted Rate Base Worksheet
Version 1.4
CTC: BOARD OF COUNTY COMMISSIONERS
County: PASCO COUNTY
1.
Complete applicable GREEN cells in column 3; YELLOW and BLUE cells are automatically completed in column 3
2.
Complete applicable GOLD cells in column and 5
Upcoming Year's
BUDGETED
Revenues
from
Oct 1st of
2020
to
Sept 30th of
2021
12345
REVENUES (CTC/Operators ONLY)
Local Non-Govt
Farebox 60,800$ 60,800$ -$
YELLOW cells
Medicaid Co-Pay Received -$ -$
are NEVER Generated by Applying Authorized Rates
Donations/ Contributions 12,000$ 12,000$
In-Kind, Contributed Services -$ -$ -$
Other 36,120$ 36,120$ -$
Bus Pass Program Revenue -$ -$ -$
Local Government
District School Board -$ -$ -$
BLUE cells
Compl. ADA Services -$ -$ -$
Should be funds generated by rates in this spreadsheet
County Cash 498,027$ 498,027$
County In-Kind, Contributed Services 18$ -$ 18$
City Cash -$ -$
City In-kind, Contributed Services -$ -$ -$
Other Cash 136,197$ 136,197$
Other In-Kind, Contributed Services -$ -$ -$
Bus Pass Program Revenue -$ -$ -$
CTD
local match req.
GREEN cells
Non-Spons. Trip Program 859,757$ 859,757$ -$ -$ 95,529$
MAY BE Revenue Generated by Applying
Non-Spons. Capital Equipment -$ -$ -$ -$ -$
Authorized Rate per Mile/Trip Charges
Rural Capital Equipment -$ -$ -$ -$ -$
Other TD -$ -$
Bus Pass Program Revenue 12,525$ -$ 12,525$
USDOT & FDOT
49 USC 5307 287,708$ -$ 287,708$
49 USC 5310 -$ -$ -$ -$ -$
49 USC 5311 (Operating) 12,524$ 12,524$
49 USC 5311(Capital) -$ -$ -$ -$ -$
Block Grant 573,447$ -$ 573,447$
Service Development -$ -$ -$
Commuter Assistance -$ -$ -$
Other DOT -$ -$
Bus Pass Program Revenue -$ -$ -$
AHCA
Medicaid -$ -$ -$
Other AHCA -$ -$
Bus Pass Program Revenue -$ -$ -$
DCF
Alcoh, Drug & Mental Health -$ -$ -$
Family Safety & Preservation -$ -$ -$
Comm. Care Dis./Aging & Adult Serv. -$ -$ -$
Other DCF -$ -$
GOLD cells
Bus Pass Program Revenue -$ -$ -$
DOH
Children Medical Services -$ -$ -$
County Public Health -$ -$ -$
Other DOH -$ -$
Bus Pass Program Revenue -$ -$ -$
DOE (state)
Carl Perkins -$ -$ -$
Div of Blind Services -$ -$ -$
Vocational Rehabilitation -$ -$ -$
Day Care Programs -$ -$ -$
Other DOE -$ -$
Bus Pass Program Revenue 17,206$ -$ 17,206$
AWI
WAGES/Workforce Board -$ -$ -$
AWI -$ -$
Bus Pass Program Revenue -$ -$ -$
DOEA
Older Americans Act 217,518$ 217,518$ -$
Community Care for Elderly -$ -$ -$
Other DOEA 48,406$ 48,406$ -$
Bus Pass Program Revenue -$ -$ -$
DCA
Community Services -$ -$ -$
Other DCA -$ -$
Bus Pass Program Revenue -$ -$ -$
Fill in that portion of Budgeted Rate Subsidy Revenue in
Column 4 that will come from Funds Earmarked by the Funding
Source for Purchasing Capital Equipment. Also include the
portion of Local Funds earmarked as Match related to the
Purchase of Capital Equipment
if a match amount is required
by the Funding Source.
Fill in that portion of budgeted revenue in Column 2 that will be
GENERATED
through the application of authorized per mile,
per trip, or combination per trip plus per mile rates. Also,
include the amount of funds that are Earmarked as local match
for Transportation Services and NOT
Capital Equipment
purchases.
If the Farebox Revenues are used as a source of Local Match
Dollars, then identify the appropriate amount of Farebox
Revenue that represents the portion of Local Match required
on any state or federal grants. This does not mean that
Farebox is the only source for Local Match.
Please review all Grant Applications and Agreements
containing State and/or Federal funds for the proper Match
Requirement levels and allowed sources.
What amount of the
Budgeted Revenue
in col. 2 will be
generated at the
rate per unit
determined by this
spreadsheet, OR
used as local match
for these type
revenues?
Budgeted Rate
Subsidy Revenue
EXcluded from
the Rate Base
What amount of the
Subsidy
Revenue in
col. 4 will come
from funds to
purchase
equipment, OR will
be used as match
for the purchase of
equipment?
Pasco 2020-21 Rate Model Approved.xls: Budgeted Rate Base
Page 4 of 9