Loading...
HomeMy WebLinkAboutCOM 0454.001 2020-2022 Ashley L. Kierkiewic Z "tY`-®F �v. Office:(808)961-8265 Council Member Fax:(808)961-8912 District 4 Puna :t ashley.kierkiewicz@hawaiicounty.gov AAI`I COUNTY COUNCIL Hawaii County Building 25 Aupuni Street Hilo,Hawaii 96720 MEMORANDUM DATE: October 28, 2021 #, �a TO: Maile David, Council Chairperson And Members of the Hawaii County Council FROM: Ashley L. Kierkiewicz, Council Member Sue Lee Loy, Council Member SUBJECT: OpenGov Supplemental Material Please see the attached documents as supplemental materials to Communication No. 454 regarding the OpenGov platform. The attached documents consist of. • OpenGov Slides - general information • OpenGov ARPA and Grant Processing • OpenGov Budgeting & Planning • OpenGov Reporting & Transparency Council Members can explore the following public transparency portals who currently serve as OpenGov clients: • City of Tampa: tampa.gyov/metrics • State of Hawaii: opendata.hawaii.gov • City of Wilmington: storics.ol2engov.com/wilmingtonde/ ublished/9Svedvl26 • State of Idaho - COVID Expenditures: stories.opengov comlidahorebounds/published/ 7-Jm6E7N • Kauai County- Finance Portal: kauaihi.opengov.com Mahalo, AK/j s Comm. No Ref. To: Serving the Interests of the People of Our Island Ref. Date NOV — 2 2021 Hawai`i County is an Equal Opportunity Provider and Employer 4 0 t l 0 fi �s _ � � ,�` � u��.. m: �.�� .� .�v � *` � i � � �� {: � „��µ��. � $ �mz t .tet # YT�s` � � a k,-, 3 � w�te�{ Yi{���ay -' s. �� �«+z � �,�., F n� ,R§ _. xv �- Z —#u TkIll, X, 44 C7 tll Z t Fv # g.' x t sc 'S."~• .s:..,�{=v' - ierx x # g£ � t= x M..61 '{'VOS '1.•' �.��t �E #�K� j "x ;ti''='p„�� �.. r:''Q fir t=- „ Std �* €a €_"a //��► -' �'' �.. '+• t • x 'a ~* a r -$ v—Mme,.,'}✓ "' " # Y=zx iV is �� fgmv 4,2 IN ''�:�e k � s f � {° ,�x £. * a ''= Y} `t'SX k �"�£'� 'z F� 4�.€��£ t #t'fr A' # �R�� € t� �f��•3�=����"� XI ~f �, � + � H# • f s �' ar�x x x¢x �.� a xx�#x � � #�;,{ ����:r����-'�,�#t.-€ s�,� 1, { 8 xj g#'33 "_'# g x'i a.£ ,.yx€;'�b.y�.{•:4=y`Z*x.#�,:x k �� 3 Cs}-,yi. x ~•xx x s 3 � .. " # NA Y #y~•:•, ry � �?^ � #"�1 R—f`{ �" :v'f£,i.:xr xk i.:Sv':#S �#`' .2+.x a+' „�.•k.fi;�.Y-. " a x�& ��� a �' �F . K':' 4 � Y' '"#- F^�': � � - �sg � SM =4, .��l� g.•''£r h. `k'#,#..' "' # x 7 no ji , k T +1i t X x _ '7 nrt. ED r, },_, a p x,r c� m� YDpN1.h.pV � .0 - x Z s 3l[Hn� sgALoil ir ams e } / ± / � / / / \ / / g » / � ° / c - - � & ƒ J 7 ƒ 7 D 2 / /' ■ $ \ ■ ƒ 3 / 2 m mm \\: \ o < c g _D / ƒ % y ° / k / ƒ ƒ f } _ @ m c w CD/ / 3 / J m J / e / J ° / % � 3 0 . & 2 / / (D � 2 = 2 _ @ _ 2 / 2 ƒ m . } 2 } \ � 7 } co 0 p 2 c 2 / 3 ° / \ ƒ & ) In — = 3 s » / m t o / _ = o © / / / } \ \ c m / ° § \ e = \ / �: � t �r#. �� � t�., a, � s.,.r * # mak#": � ,x•.. � x. Vo !'` N-02, � #*� # if IR WT f 5-1 �,t i �'�'�:? � }w..k:.�"'k' a X +tJa F�yx,�'"�Oxy C '�+•#� # 41 71 ��.x xr` X•'�- r���'t:�� � 3� � rix% ' �+.�a� � .axx � r s. s # ? ' t '� kms , : t :#4a•�y x- ;�' k ..,r, � a r ue r, # � fix# e' w Qw.3 {,'.' r k{ `€xa+.�- �:�.' s-' .-sxi"xx�t R� is ,x >f•• % da � * # MRauk "I MR ' On Arm x - # t # Xk 6 f Y i American Rescue Plan Act State and local governments have • Directly to Governments:State($220B),County($65.18),and Local ($65.113) access to American Rescue Plan Act Request and receive 1st tranche or 50%of funds:Beginning May 2021 fu nds to accelerate Receive 2nd tranche or 50%of funds:Approximately 12 months later recovery efforts Deadline to obligate funds:December 31,2024 • and address Deadline to spend funds:December 31,2026 unequal impacts of z the pandemic. Use of Funds from the U.S.Department of Treasury: • Support public health expenditures • Address negative economic impacts caused by the public health emergency • Replace lost public sector revenue • Provide premium pay for essential workers • Invest in water,sewer,and broadband infrastructure ..a Step 3 of 5- Save Draft and Exit American Rescue Plan(ARP) Expenditure Categories Tracking(Departments)-with Submit your proposed/anticipated expenses in the categories outlined bythe USTreasury Department in their Treasury Categories StFRF Compliance&Reporting Guidance. Additional information on reporting can be..found here. Category 1:Public Health 1.7."c:Yif3 fg7s cnxi:iar .L�.+.<?r(C ia`,tirrg American Rescue Plan Tracking TotalCwts ib CWIDYettinatlon Coatst Mediwi SupplYeasta {t Rasrnue RapbcemeMCartz {f Mar ,:Eh,hle.: ,'ii.b;€:z,r ;,Ll fc..u.COM 7.it u.t,l;� -ifE. $1,636.569.00 $34,543.00 $43.543.00 $56.765.00 :SFeltarin6�iti � TerMOIo�Imprnvemmt Dosis (f hanspwriNon ARP RanMing y.. �CapitalPm)ect Ezpenzes �} 1 n u � 4 $435,435.00 $5,677.00 28 $1,006,047.25 Create a feedback loop between internal experts on staff and constituents in order to distribute funds responsibly and provide the best services to your community. Leverage OpenGov's approach to managing,tracking,distributing,and reporting of your federal funds by ensuring your municipality is prepared with these critical steps: gtt The legislation and information available to you is constantly evolving.Do you have Y. dedicated time to educate yourself and your team? Researching Law,Interim Final Rule,FAQs,Fact Sheets produced by credible sources. Nave you consulted trade groups and thought leaders? "3 Lastly,has this information been shared internally with staff who will be required to tr ' support the distribution and tracking of these funds? =r Now that you have access to the right information-it's time to set up your processes. Internal&External needs assessment(proposal solicitation) Establish a fund in your chart of accounts to support efficient and complete reporting Calculations of revenue loss Short,mid,long-term financial projections of all other revenue sources _ d qr ''v Once organized,build out your plan for completing the public health response and rjT spurring the economic recovery in your community. tr, # ' Decide on which programs and strategies you'll be funding with ARPA. €- kr Build line-item budgets for those programs and integrate those with existing work. • Communicate with internal and external stakeholders so that everyone is on the same page and holds the same expectations. Execute Programs Now it's time to do the work Provide for premium pays to front-line workers within and outside of your enterprise. • Support public health response by distributing funds to local nonprofits or through your public health departments to ensure the virus is contained and ultimately defeated. Solicit applications and distribute economic recovery payments for small businesses,and individuals. Build generational internal capacity by modernizing legacy systems and updating processes to match today's needs and reality --as opposed to perpetuating those that were built for the needs of yesterday. "Crack&Review Be prepared to report on progress periodically-both to the Treasury department and your community Monitor actual expenses against planned budgets to ensure that dollars aren't going unused;reallocate as necessary. Provide regular reports to Treasury on a quarterly or annual basis depending on the size of your government. Communicate with residents and business on progress and performance of programs so that they can take pride in their community and understand the breadth and depth of your government's support of the community. Learn more> bequest a Demo) About OpenGov OpenGov is the leader in modern cloud ERP software for our nation's cities,counties,and state agencies.On a mission to power more effective and accountable government,OpenGov serves more than 1,000 agencies across the U.S. Built exclusively for the unique budgeting,financial management,and citizen services needs of the public sector,the OpenGov ERP Cloud makes organizations more collaborative,digitizes mission-critical processes,and enables best-in-class communication with stakeholders. CITY OF c CITY OF COUNTY OF MINNEAPOLIS RICHMOND MIDDLESEX STATE OF CITY OF COUNTY OF OKLAHOMA CAMBRIDGE ADAMS � m ® •®sa- •a a s 9i Modern Cloud Budgeting and Planning Budgeting&Planning is a modern,full-featured cloud budgeting solution designed to meet the unique needs of public sector planning and analysis. Trusted by hundreds of forward-thinking governments,Budgeting&Planning is the industry's most collaborative experience for budget process automation,managerial reporting,and public transparency driving more effective planning and strengthening public trust. �Reparts x Budgetf°Actual Na ® FI{ten View Wrt.enu. n�.,vwm..s...nm ar"xw n.utKaue:as[ rN^a viDE+De_xtv2W9H(aN t .,tie JNa,eC °epaNnevls) Y(bl0.venun C°Yxletl(ty `"� o DR a&d C9 "e The Most Collaborative and Efficient Solution errs°.d = U"tl°,ted Powers efficient planning through �." gyp"vim. Fm intuitive end-user experiences, breakthrough communication cmnveoeY°enetnnpemnu,en RrE"g neereg&ttensp ® mown E ` rse�asp H°mm Re ares between offices and departments, "_t,a,a•m."t € a } fx and easy-to-configure controls to ensure data integrity. S.kYaube,m+cwet Ill 91-1 LIU Operating Budget Workforce Planning Capital Initiatives Online Budget Book Liberate your budgeting from Simplify planning for your Forecast long-term capital Publish a fully interactive, disparate spreadsheets with a most complex and important expenditures,manage easily digestible budget book unified process that asset-your people-with proposals,track performance, generated directly from your seamlessly ties spending to scenario analysis,advanced and easily keep the public budgeting system,not other desired outcomes. position allocations,and informed of progress. software. integrated budget requests. 130-50% 88% ~' Governments using OpenGov's 88%of all spreadsheets,including Many governments were able to Budgeting&Planning solutions have those used to make the budget, re-allocate 1%of their total budget seen a 30-50%reduction in the time have errors. to strategic,initiatives with OpenGov. spent creating the budget. ' • • • • • s • • ' t Data-First Foundation Platform to Strengthen Public Trust Budgeting&Performance comes with a robust reporting and Leverage the leading transparency platform to communicate analysis platform with out-of-the-box capabilities`for dashboards, initiatives clearly and effortlessly,run public budget simulations, managerial reporting,KPI tracking,data consolidation and publish interactive budget books online,and deliver up-to-date sharing,and scenario modeling. financial and operational data with context. 0 You 'n:Dashboards 1 Cry Manager dashboard City Manager Dashboard This dashboard hes been prepared for the swcutho,shaft and Committees and shows high level lnformatan across the city. ( Print .I Etllha - ----------- ..__i tea: Rtrends �EliCash Flow W evenue i ''. jqr But thing permits isw¢d within 5.t`,s Traffic Stops � � � Expenses by Expense Type . Isis=T.bo ain- III=Target abave-iP5 p� S i ;LGA iPi Le no @� 1 t 3IIX.1 5 0t data A _ taonr;C_. -2at2 2CIC 2016 2T0 --ua 2J1 1.s2p1't 1ut2a11 $5,295,078.05 $37,078,786.11 38 380 $42,502,174.11 usata¢zpla an<.,.¢,a2o-s rrwaeK,o;monvpzav I—lTrcemx,n tmfi i,oe".mb2pza Pollee response times gy Annual Report Parking Viofattons./performan ffit 311 Monthly Requests Target ,i %target mat Pothole R¢pair SLl $t Strategic Goal:Safx Siroe[s star:sttitM1 owe Ing - �- -- - 3115evccs iIo.nts - N'VA t—psr ailtso.n K days=-- target abwx1,100 TlokMk,,7 :onruce Tar¢emml'oG : The.M.1.850 Category 2020 p 'aPftat O,rtla S$54a,2&618 _ P nnsl5ery cos $16, y 102.83 ixw P "'lt A .. Se,irn&Cha oes $72 6.x0109 ..... ..._. o _.. i,b Ails Sex2p16 -_ p J h;�aiJ Ur205 Sae20I5 30� 6 6<wya Supp1tes&EQ,1p ort 33,978,615.02 8 a,w 9.57 masiers0 c saabaass.ra u 1,76 76 6 219,483.417 60 $I.rn6pP - zr SepMlS LbzeaiuenlAIDiB Why OpenGov? A trusted and dedicated partner. More than 1,000 governments nationwide partner with OpenGov to drive more effective and accountable operations through cloud ERP solutions. �k a ,e� r �2= � Built exclusively for state and local government,OpenGov's software,services,and expertise ,n Ys z� are backed by over 300 years of employee experience in the public sector. in .., Solutions designed for transparency and collaboration. Our intuitive solutions a5w a c2d rs •r streamline the collection,analysis,and communication of complex information for all gi stakeholders—helping eliminate silos,accelerate workflows,and increase civic � ,.PG:'� � =� engagement—allowing customers to re-allocate up to 1%of their budgets for more strategic outcomes. „„� a�z, L use� ., x .��_ 12 A platform built to grow with you. Modern cloud architecture allows us to innovate at anv3aT tee unmatched pace,ensuring all of your users have access to the latest features while reducing your IT burden. OpenGov invests more than 40%of our operating costs into R&D based on k customer feedback,helping future-proof your investment. ' CITY GFT CITY OF STATE OF ” MINNEAPOLIS RICHMOND IDAHO STATE OF COUNTY OF COUNTY OF OK ILAHOMA SUFFOLK MO O • � W 3 The Industry's Leading ortin Transparency Platform The OpenGov Reporting&Transparency Platform powers the industry's only modern cloud ERP for budgeting,financial management,and citizen services.Trusted by hundreds of forward-thinking customers,the Reporting&Transparency Platform provides a seamless connection between back-office capabilities and industry-leading communication tools—transforming better citizen engagement from aspiration to reality. City Manager Dashboard @ � cxn nw # aerem,oee,u. & ewan¢, -�5.ee tt.nro si 4: 5.poius ex ppenw.xc+ o'. j 1 ,kn $5,295,07805 $37.078,786.0 38 380 $42502,774.11 n r ,.1768„ 219,483.417 60 ® W Built with a data-first mindset to drive alignment and Build trust with constituents by communicating initiatives improve decisions,OpenGov offers unparalleled and progress clearly while fostering better engagement reporting,and analysis capabilities to drive faster, through integrated tools to collect feedback and sentiment. more effective decisions. • Publish a GFOA award-winning interactive budget book • Present complex information that the public, online to provide taxpayers with a better understanding elected officials,departments,and of how dollars are impacting the community administration can understand with at-a-glance Communicate and track strategic initiatives insights and interactive dashboards effortlessly with a simple drag-and-drop web-page • Reduce reporting bottlenecks by freeing up your builder and customizable themes that make it easy for IT,finance,and other staff with self-serve board members and residents to digest key narratives reporting supported by centralized administrative Run public meetings,virtual council chambers,and controls budget simulations using robust forms,surveys, • Sharpen your focus on outcomes by establishing reports,and tools for curated feedback and compliant and tracking relevant KPIs to keep stakeholders voting updated on spending,initiatives,and operations Deliver up-to-date financial and operational data with context to keep the public informed of progress and fiscal health Reports forecasting the Coronavirus Impact NNp ao.rD��w Filters VM11 tnr 6:SP Nar.NSO "M1i•'i y'?'i1'^"^R { iwreooucrww C.—vi iCOVID 19} ee a _ ex maad�WxNdumnr � `..'q'4 i s .'ka1C §ymr,Ym ''mWm e .`sem"-" W :sy � Dma .$nin,winwiy ...2�.r ,� ermue o a a Df mro e .n• k�mmF¢r4 bw.mAivRed .Gr' r..,.w w rm } ua HRS A �8g29],93846' ` y 3 1 OpenGov customers achieve an Governments using OpenGov's OpenGov customers improve average average of 80%time savings on Budgeting&Planning solutions double permit processing times by to 75% reporting their efficiency in time spent creating the budget t What will the Reporting&Transparency platform Do ForYou? Improve your strategic decision-making by getting a complete,accurate picture of your organization's finances,operational measures,and KPI's while saving an average of 80%of your teams on reporting and 3 reducing FOIA requests by 20%. Achieve your transparency objectives and broaden constituent engagement with virtual town halls, online feedback,and online stories that align data and easy-to-digest reports with the necessary context and background information. i Operate more efficiently with secure,accessible-anywhere financial systems designed for the collaboration necessary in real-world processes such as budget development and council or audit preparations. PC About OpenGovi.N,4 Vis' OpenGov is the leader in modern cloud ERP software for our nation's cities,counties,and mv t#e are i x fi , I state agencies.On a mission to power more effective and accountable government, F OpenGov serves more than 1,000 agencies across the U.S. Built exclusively for the "`"`"'" Q, "° at "" ! unique budgeting,financial management,and citizen services needs of the public sector, the OpenGov ERP Cloud makes organizations more collaborative,digitizes mission critical processes,and enables best-in-class communication with stakeholders. cit,til €.t.,,_,.I a ., 0f CITY OF "4a' CITY OF STATE OF MINNEAPOLIS RICHMOND IDAHO STATE OF COUNTY OF COUNTY OF OKLAHOMA SUFFOLK MONO f �