City and County of Honolulu
ARPA State & Local Fiscal Recovery Fund (“FRF”)
Funding Request
Throughout this form, sample responses have been provided for each Section based on two hypothetical proposals. Example 1 is anagricultural grant proposal. Example 2 is a mental health support for the homeless proposal. These examples are intended toprovide you with ideas on what level of information is expected in your proposal.

1.

Project Name:BFS Fiscal Accountant
Maximum 80 characters2.

3.

Department:

BPS Budget and Fiscal Services

Division:

Accounting and Fiscal Services-

Executive Summary:
Instruction: Tn 1500 characters or less, describe your project, stating the amount of funding requested and describing how therequested funding would be used and what is expected to he accomplished.
Example 1: This is a request for $# to fund three years of agricultural grants to support approximately # farmers and food produc
ers recovering from the COVID- t9 pandemic. We estimate an increase in food production by #% and in food sales by #% by theend of the funding period.
Example 2: This is a request for $# to fund two years of counseling and treatment services for approximately; homeless persons

with mental illness. There is urgent need as previous funding has been reduced by 5; due to diversion of resources to address the
COVID- 19 pandemic.
EXECUTIVE SUMMARY

This request is for $262,924, to hire a Fiscal Accountant for 33 months to properly account for SLFRF andexpanded Federal funding. Independently performs professional accounting work in accordance withstandard accounting practices, and the policies and objectives in the maintenance of an accounting
system; analyzes fiscal data; and performs other related duties as required.

Maximum

MAYOR’S MESSAGE 43

HEcori500 characters

PAGE 1 of 5

4.

Time Sensitivity
Is there a deadline by which you need to have a decision oo this proposal? If so, provide the deadline date and reason for thedeadline.
DEADLINE DATEREASON

04/01/2022

5.

—-\,\1 would like to hire as soon as a suitable candidate is found.

What is the problem/issue being addressed?
Instruction: Describe the problem or issue being addressed by this proposal. Provide data to illustrate the size, value, demographics of the problem or issue. Keep in mind the data and information you provide here will be used to evaluate the soundness of
your funding request which you will describe later in the proposal. For example, if you are describing providing 200 householdswith specific assistance amounting to $1000 per household, we would expect your funding request in question 6 to be around$200,000.
Example I: According to [cite sourcel, there are approximately ft of farmers and food producers producing [volume and type of
produce can also be shown as a table/spreadsheet: in Oahu in 2019. Today, #% of these farmers and food producers have seen
more than t% decline in their revenue or production during the last two years. Research [explain type and source of research:
survey done by organization x, data analytics done by organization y, etc.] indicates that the declines are due to labor shortages
and shipping interruptions due to the COVID-19 pandemic. The average loss per farmer/producer is approximately S#, and therange is from S#—-

Example 2: Prior to the pandemic, in 2019, the City provided S# in counseling and treatment for homeless persons with mental
illness. In 2020 and 2021, the funding levels have been S# and S#. This has impacted this population in the following ways:
reduction in persons served, u% reduction in hours of counseling, #96 reduction in hospitalization and medication assistance.
PROBLEM/ISSUE BEING ADDRESSEDThe SLFRF grant is over $386 million dollars which is equivilant to 11% of the City’s FY22 Executive Operating Budget. The added work of
the SLFRF grant has primarily fallen on one of our Fiscal Officers to coordinate amongst the various fiscal sections, which is not sustainablewith the current workload and upcoming proiects such as new GASB implementation and major system upgrades. The work associated with
the SLFRF grant is only anticipated In grow as more projects are approved which will require significant OT if no new staff is added.

6.

What is the solution being proposed?
Instruction: Describe your proposal and ho” it will address the problem. Define the solution with data, including the ftinding
amount requested and the budget plans. Include appropriate administrative expenses such as fringes. Attach relevant
documents to this application, including detailed budget, draft vendor scope of work, relevant performance data, etc.
Example 1: We propose $X in providing grants to farmers and food producers over a three-year period. In order to be eligible forthe grants, an applicant must demonstrate [qualifications such as meeting the definition of being a “farmer” or “food producers’
having pre-pandemic revenue of a certain revenue level, producing certain types of products. committing to sustainable
fartners, etc.]. The grant size wdl be up to $Y because, as we have shown in our answer to question 5 above, that represents theaverage loss sustained in this population. We also calculate #% of administrative expenses. The grants will be restricted in theirusage to [specify usage restrictions for the grant].
Example 2: We provide a table of proposed budget and expenditures. These items and numbers are based on the types of services
that were provided by the city during 2019, and the cost has been adjusted based on estimate of costs in 2022 based on 2019 costs
adjusted for inflation. We anticipate delivering services to the target populations of# as stated in answer to Question 3.
PROPOSED SOLUTiON

-

-

-.

The requested Accountant position wiU help to centralize processing, ensure uniform and consistant
documentation, proper coding, and timely review of invoices for payment. It was also alleviate burnout
due to excessive OT.

PAGE 2 of 5

7.

What is the evidence that the solution will address the problem?
Instruction: Recap the problem/issue you stated in answer to Question 5, and explain why you believe the solution will address
the problem. Some explanations will be very simple and intuitive, others may want to reference sources such as research or
surveys. For example, if households don’t have electricity, we don’t need much evidence to say paying for electricity would meetthe need; however, if household are malnourished, it’s not clear giving them money would necessarily address the problem, as
households may still use the money toward purchasing food with low nutritional value.
Example 1: The problem we identified in QuestionS is reduction in food production and revenue. We believe grants to farmers
and food producers will address the problem because our data review showed that in the three years prior to the pandemic, thesefarmers and food producers had a consistent year-over-year production growth of #96 and revenue growth of $X. We also havelearned that the reduction was caused by labor shortages and supply chain disruptions. We believe the cash grants could help
meet rising labor and shipping costs for the target population.
Example 2: The problem we identified in Question 5 is the mental health counseling and treatment needs of the homeless pop
ulation. According to discussions with the community health centers, HESD’s CORE division, Institute for Health Services andother organizations assisting homelessness, there has been an increased number of homeless persons with mental illness
requiring counseling and/or treatment which impacted and/or reduced existing resources during the pandemic. This proposal
directly meets those needs.
EVIDENCETHATTHE SOLUTION WILL AODRESSTHE PROBLEM

By bringing on an additional contract accountant position it will address the issue of insufficient staff time!
to manage this $386 million project as staff is already busy with their regular workload.

8.

If your proposal is approved and implemented, what do you expect the problem to look likein 2025? Will the problems still exist? If so, how would the solution be funded after FRF?
Instruction: Describe what if your solution works as planned would the problem look like in 2025. If the problem will still
exist, explain how you plan to fund your solution after FRE funding expires.
——

Example 1: Barring other complications, we expect the food production and revenue growth will resume or exceed their histori
cal growth rate at the end of 2025, and no further funding will be needed.
Example 2: The problem will continue to exist. We will have to find other sources of funding after FRE
SOLUTION OF THE PROBLEM OR CON11NUED FUNDING

The position will need to be temporarily funded with City General funds until all SLURP grant funds arepaid out and all fiscal related reports are filed with the US Treasury.

9.

What KPIs should be used to measure the desired outcome?
Instruction: Specify what Key Performance Indicators (KPI) will be used to measure that desired outcome of your proposedsolution.
Example 1: Food production and revenue numbers and growth rates from grant recipients will be used to measure this expected
outcome.
Example 2: We anticipate that the percentage of homeless persons with mental illness receiving treatment will be #96, which
represent the percentage we have maintained since [yearl. We will use that percentage, as well as the number of persons receiving
counseling, treatment, and medication to measure the expected outcome.
KEY PERFORMANCE INDICATORS OR METRICS

Information within C2HERPS ties to reporting to the respective Federal entity and the corresponding Schedule of Expenditures of Federal
Awards (SEFA) is compiled and reported as mandated in accordance with Subpart F of 0MB Uniform Guidance with no audit findings. Timely
review for fund availability of procurment requests within 2 days. All invoices are reviewed and paid within the 30 days allowed by State HRS.

PAGE 3 of 5&

10. Is there non-FRF funding available for this project?
Instruction: There are numerous federal funding sources for a variety of projects. Make sure you have done at least the following:(1) a key word search in the American Rescue Plan Act; (2) search the website of relevant federal and state departments and agencies; and (3) search using grants.gov. Describe how and what you have searched. If you have found applicable funding. explain
why you still need FRF funds in the requested amount.
Example): Our review of ARPA found that Section 1001 allocated $4 billion for the Department of Agriculture to make availab]e loans and grants ‘for small or midsized food processors or distributors, seafood processing facilities.., farmers markets,
producers, or other organizations to respond to COVID-19, including for measures to protect workers against COVID- l9” (subsection 3); and to “provide other assistance to maintain and improve food and agricultural supply chain resiiency’ (subsection
4). We have chosen not to apply for those funding because....

Our review of U’S Department of Agriculture identified... We have determined we are not eligible or unable to apply for thosefunding because....
Our review of the Hawaii State Department of Agriculture identified the following financial assistance. We have determined weare not eligible or unable to apply for those funding because....
Example 2: Our review of ARPA found that Section 2701 allocated SI .5 billion to the Department of Health and Human Ser
vices to provide funding for block grants for community mental health services. We have chosen not to apply for those funding
because...

We Googled using “federal funding homeless mental health” and found grants available under the Projects for Assistance in Transition from Homelessness (PATH) program run by the Substance Abuse and Mental Health Service Administration (SAMHSA)of the US Department of Health and Human Services. We have chosen not to apply for those funding because...
The Google search also identified $30.8 million of available funding from the U.S. Department of Housing’s Emergency
Solutions Grant, which may be used to assist the homeless for services including mental health support, as announced by
Senator Schatz. We are applying for $# of this funding, which will be used toward [describe how this funding is not being used ina duplicative manner as the FRF request here].
AVAILABILITY OF NON-FRE FUNDING

This position is dedicated to the processing of SLFRF transactions, no other federal funding is available fort
the administration of the SLFRF grant, so City general funds will need to be made available if SLFRF grant
funds are not available.

11. Eiigibiiity—-—.--.—-

Instruction: Review guidance on eligibility in the U.S. Treasury’s Overview of Final Rules and the attached flowchart (click on thepaper clip in the left panel of the PDP). Identify at least one category for which you believe this proposal qualifies and provide
your analysis for each category identified.
Example): This project is eligible as responding to a negative economic impact of the COVID-l9 public health emergency
1. The COVID- 19 pandemic caused the following economic harm described in section 4.

2.

The proposed project addresses or responds to the economic harm described in sections 5 and 6.

Example 2: This project is eligible as a response to a public health need created by COVID- 19 because

We believe the proposal qualifies for the Public Health/Negative Economic Impact category because the homeless populations
mental and physical health conditions have been exacerbated by the COVID-l9 disease: their lackof access to treatment due toreduced ftinding caused by COVID-l9 have exacerbated their pie-existing health conditions. XVe believe this project also qual
ifies as government services under the revenue loss category because these mental health services have been part of government
services that were offered to the homeless population prior to the pandemic.
ELIGIBILITY

Revenue Replacement
EXPLANATION

We believe that this position would fall under Administration but since funding for this category is limited, we arerequesting the use of Revenue Replacement funds.
PAGE4of5

S.

12. How does the solution relate to the Recovery Plan?
Instruction: The City’s Recovery Plan outlines four goals for the deployment of FRE Explain how the solution meets at least oneof the four goals.
Example 1: The solution proposed supports equitable economic recovery by supporting farmers who have been economicallyharmed by COVJD-19 in ways that would allow them to recover to contribute to Oahu’s economic growth.
Example 2: The solution provides community support under the first goal of the Recovery Plan. The solution is also listed in
Exhibit A.
RECOVERY PLAN CATEGORIZATION
1Modernize City Operations
OPTIONAL DESCRIPTION

We believe this request falls under the Recovery Plan’s Operating Budget
positions to support expanded Federal funds and contract awards,-

Personnel Funding for-

13. Identify the proposed method of procurement.
Instruction: Identify the procurement method you propose to use. Purchasing will make the final decision on the appropriate
procurement method.
Example): We plan to use competitive RFP/RFB to identify a grant administration service provider.
Example 2: We expect to use sole source to procure mental health services from an existing service provider.

lAllow applicant to upload any supporting documents]
PROCUREMENT METHOD--

select procurement method--

ATTESTATION
I have reviewed the U.S. Treasury Guidance for Coronavirus
Staic Fiscal Recovery Fund. I understand we must comply
with all SLFRF requirements issued by the Department of
the U.S. Treasury; including reporting requirements. I will
participate in quarterly and annual report activities by the
U.S. Treasuryr

APPROVEDDISAPPROVEDCMANAGING DIRECTORCOMMENTS

I have reviewed other available federal and state funding
sources and determined there is no other funding available
outside of SL.FRF for this project. I have consulted with Cor
poration Counsel to assess the eligibility of this proposed
use under SLFRF, and the consultation supports eligibility.
Based on my review and consultation, I have determinedthat the funds requested are reasonable and necessary for
its intended use in my judgment as the official responsible
for the expenditure of SLFRF funds.
Digilally signed by Kawano,

Date: 202203.16 16:45.16-1000

DEPARTMENT OR AGENCY HEADPAGES of S