Loading...
HomeMy WebLinkAboutPackets - Council Packets (907) AGENDA ORO VALLEY TOWN COUNCIL BUDGET WORK SESSION MAY 29, 2007 ORO VALLEY TOWN COUNCIL CHAMBERS 11000 N. LA CANADA DRIVE BUDGET WORK SESSION - AT OR AFTER 5:30 p.m. CALL TO ORDER ROLL CALL TOWN MANAGER'S RECOMMENDED DISCUSSION OF BUDGET, FOR FY 2007/08 AND ITS RELATIONSHIP TO THE TOWNS LONG TERM FINANCIAL SUSTAINABILITY 2. DISCUSSION OF PROGRAM BUDGETING AND THE TOWN'S BUDGETARY PROCESS 3. FUTURE BUDGET DISCUSSIONS ADJOURNMENT POSTED: 05 24 07 12:30 p.m. cp The Town of Oro Valleycomplies with the Americans with Disabilities Act (ADA). If any person with a disability type needs anyt e of accommodation, please notify the Town Clerk's Office at (520)229-4700. 111 TOWN OF ORO VALLEY / COUNCIL COMMUNICATION STUDY SESSION DATE: May 29, 2007 TO: HONORABLE MAYOR & COUNCIL FROM: David L. Andrews, Town Manager Stacey Lemos, Finance Director SUBJECT: Discussion of Town Manager's FY 2007/08 Recommended Budget and Its Relationship to the Town's Long-Term Financial Sustainability SUMMARY: Since the last budget work session held on May 21, 2007, several Council Members have asked staff to address the issue of how the elements (i.e. staffing and service levels) included in the FY 07/08 Recommended Budget relate to the future financial sustainability of the Town over the next five to ten years. In other words, are there sufficient resources forecasted in future years to adequately pay for the service and staffing levels that are included in the Recommended Budget? In order to address this issue, Finance staff have compared the projected future growth in revenues to static expenditures to see what surpluses may exist in each year to apply towards service level expansion and inflation. Included as Attachment A and Attachment B to this communication are condensed versions of the Financial Sustainability Plan (FSP) for the General Fund and the Highway Fund that were presented to the Town Council on April 25, 2007. The first five years through 2013 are shown in separate columns, with years 2014 — 2018 combined in the last column. The following assumptions were used in these versions of the FSP: • The FY 2008 column has been updated to show the most recent revenue and expenditure projections based on changes made through Council budget work sessions • Projected revenues have been adjusted for annual inflation at a rate of 2.45% • General Fund projected revenues include the sunset of the 2% utility tax after FY 2009 • The same level of expenditures as shown in the FY 07/08 Recommended Budget have been carried forward in each of the future years and exclude: o Inflation factors o New personnel o Benefit increases o COLAs, merits, or salary adjustments o One-time expenditures and CIP carryforward projects included in the 07/08 budget • An amount of $1 million has been included in each year for capital improvement plan (CIP) items • Funding for elections has been included in the Administration budget every other year G:\STACEY\Council Communic\Budget Work Session 5-29-07 Sustainability.DOC TOWN OF ORO VALLEY COUNCIL COMMUNICATION PAGE 2 OF 3 • Annual debt service payments for the Municipal Operations Center have been included in both the General Fund and the Highway Fund • An amount of $500,000 is set aside annually to fund the Capital Asset Replacement Fund • Estimated annual sales tax rebates are included • Annual subsidy from the General Fund to the Public Transit Fund is included for each year • The model assumes the adoption of the Stormwater Utility fee, so no General Fund subsidy to Stormwater is included in the projections At the bottom of the spreadsheet, each year's projected surpluses are shown in dollars. Each surplus amount is also expressed as a percentage of total Adjusted Revenues equating to the amount of growth potential the budget would have to be able to absorb expenditure inflationary increases, salary and benefit increases, and program/service level expansions. As you can see in the General Fund (Attachment A), there are projected surpluses ranging from $2.3 million to $3.7 million in 2013. It is from these amounts that inflationary impacts, any new personnel, COLAs, merit increases, benefit increases, and service/program expansions could be funded. In the Highway Fund (Attachment B), surpluses exist for FY 2009 and FY 2010. Subsequently, as local development activity tapers off, deficits begin to appear beginning in FY 2011. In order to manage the sustainability of both funds, particularly the Highway Fund, Town management will need to closely monitor staffing levels, encourage more efficient ways of doing business, limit funding allocated to road maintenance, and limit funding for CIP projects. Also, attached for your reference as Attachments C and D are the copies of the 10-year Financial Sustainability forecasts for the General Fund and the Highway Fund that were presented at the April 25th study session. ATTACHMENTS: 1. Attachment A — General Fund forecast showing no expenditure growth 2. Attachment B — Highway Fund forecast showing no expenditure growth 3. Attachment C — General Fund 10-Year Financial Sustainability Plan forecast 4. Attachment D — Highway Fund 10-Year Financial Sustainability Plan forecast Stacey Le os Finance Di ector ("?-10i ALL,zi,( David L. Andrew Town Manager G:\STACEY\Council Communic\Budget Work Session 5-29-07 Sustainability.DOC N- N. 0 0 0 r N- MCD d' 0 CO N r-, go N 0 CO ��d' COM CO00 CO00 r 0 CO00 � o N- CD CDcoC) O r Cl) r) CO 0 0 N Lt) CO Lr• M 0) r N r 00'ti CO r- Ln N. ti;d' 0 CD 0 M 0 N o O CD ti co V. co00r) LiC000r` o ,- a) C\IIC) COd' d- � oo0r` w- 0 ,- ce) o co c� N -- 1,7 CD LC) r O O N M CO N O CD LC) 1--'NF N!O) 00 N. CD O t- O r C) CD 'Cr- * (NJ 1 Q r CO 0) O 0 CD CO CO LC) Ln 00 r- O CO 1 0) CD'Ln d- N - CO I` CO 0 Ln CD al Ln LO ' N O) N Ln O LO d• O C3) O N M M 00 ti r CD C3) CD CO r CO Ln 00.M O) N M ti Q mt _ d' M CM d- d-- CO M r) r N d• CD N M d- CO r CO ti CNI. O M N CD X CO I` O N M o N 00 CO N. ti M CD r Lr) r- d' M I- ,- r r r z >- W u. U o O M I 1 Q (O- L ' CO 0 O d-!r- CO N cod-° ` M r:N CD'Lf) ICO p N£CO O 1 r) O dLf) 0) o d- C) CD 0) M CO 0 0 L[) r• N. M N- 0 Md'-d' CO M 0) 0) N I` r 0 N 0 I` d• r- LI r- ` N 0 r M0 0 0 N- CaO O N d' ti d' CO Ln CO CD et co CO N- O O N ti V) CO d' d' O O M N ti M O M M CO N g r 0)-46 M N CD ti O d' CD ' ti N o Q tp in CD_ O N 00 N N O N O O O O d- 00 I` Ln,M N ao N M N CO O CO ti CO r r r M CO CO'CO M03 r MI `` O N. co M in Ln co N- Ln'r- M N. h d. CO ›.. OI: N ,- r- d- LO CD N 1 r CV 1 r r- r- r- r co"' 0 ,r Imo. IL N r• r M M r r) N ~ Ea Ea EA1 d-' N- 0) d' CO 0 0 CO r CO 0 N- o N- M d- N CO 1 LO I`I Cr) r CO N CO O N LC) 0 CO to d' L() r CD 0 O CO ,- 0<Ni- CO d' ,- 0 d'&CO CO 0) 0)a N N- r Ln N 0 CO CO Ln r- CD N ti N M O O r ti Cr) Ln ti O O ti d' 00 Ln o0 O 'd' M CO r d' O Ln e-. Ln N T- c0 00 r co- O CO N N O CD Ln ti M'00 c -- 050.6 M N d' ti dM O d• ' O 0 N- 0) O r Ln 0 M 0) O 0 CO Ln M 00 N'ti Ln M N 00 N M N CO O 00 M Lf) \o o N LC) CO 0 CO r,r N CD CO CO O 00 N. Ln i I` O N CO M Ln LO 00 N. LC) Cr) N.L0 co CD 7 ›- N. CD N r e-- M- d' CD N r- (NI e- r- ' r- r• CO CO 0 Ln LL r r• r CO M r M N CD F V, E c co C) N Ln'CD 0 O r r1-- d' CD C.D o d- 0 d',N CD LI) N-F M r'CO N O O O N o CO I` r Ni- LC) CO 0 0 CO r• - Ln N Cao •,- d' d';CO M'CA O N N- r L) NO00rd' Nd'�' I` CO M O N CO I` O O M r O M NI- 00 Ln,00 CD i d• M 00 r d' O M CD M I`CO O Ln 00 O M DO N0 O N- O CD M 00 N r O` M N d' ti O CO CD ' O o CDp (O r d' 0) Ln 0 10 0O O3) Ln M N CD 00,ti Ln s M N x CO N M N CO 0 I,- Cao 00 \ 0) °CON LO ti I` 00;M N N CDC)P M 00 00 CD M ti O;N M'M Ln I Ln co ti Ln co Lr) O O to T �. Ti CU r r• r M d' CD N r N r - w- r- r CM CO N to C LL r r r CO M r M r a) `.J N. Ln Ln CD 0 0 d' r d' CO CO o Ln d• d' N CD LO N- CO r CO O CO 0 0 N o N 0) N. CO r) CO 0 0 r) r- Cr)p CO N 0 e- d' d' CO M O O N ti r CO N O O 0 d' d' r O O O d- CO O O O O O Ln N Ln Co d-=co Ln co co d' co co d' d' O ti ti N co d- CA M N co- O N ti N CO N Ln d- O co co N& - O 1 L1) M N N- ti O O N titD 0 LU N. O M Ln O Ln CO O co Ln Ni- ,- M co N N- Ln N 00 N M r CO O I` N (y.) ,23 r c N .�• r O C3) 0o d' — N CD LI 1 M N 00 0 LI€ti 0) N M 1 M Lf) L1) CO ti Ln CO ti M O Ln CO N CD r ',- r cei. d' CD[ N r N e- r- r- r- r C\j Cfl d' Ln r r r CO M i r M r `1 0 so -. co N. ,-- co co O O CD r- CO CD ,- o N d' d' N CD LC) ti M r CO N O O 00 d' o O N. }' 13 LO CD Ln r CO O 0 Ln r- 0) 0 0 I` r r ;CO M C3) O N I` r Ln O O O O O ti O N O M M 0 0 0 ti N M �- N M d•1 co Ln 00 co d' co co C) 0 0 Lt) Lc) O CO O VI C) N LI7 CO O co- d' N r) (fl O - CO CO M CO N r 0)I LC) CO N O N O I` CO ' O C) c c O CO N Ln L1) 0 00 d' 0 N. d- c0 O ti Cao ti Ln M NICO N M Ln I O 0 r CO co o ti M ca N �' ti ti L1) CO to O N O Ln CO Ln N- M M ti O N M'M Ln Ln r- ti Lt)#,Ln 0) M N r >- C) Ln r r- r N r) CO N r N r- r- r- N.- O N N- N O II r r M M r M r M 1C CO LL ca _ a) 0 N. 0 r CD 40 0 0 O r 0) 0) d' N CO Ln N M r CO d- 0 0 N 0 O ti > co co� CO co O O N ti 0 co CO CG CO d' CO Ln CO CD d- OM CO CO0 0 0 O N CD CD N cp CO - - 0 C) d' r M 0 d' r N 0 0 ti N- co- CO NI.- Nr 1 L1) Ln N O N O N CO O o O \ 2 0 "Cr r CO d' CO CO N r O O N N N d-''N- Ln r) N 03 M,r) 0) 0 0 I` Ln M N- CO ti N •� d' ti •r CO L1) O O CO CO N- d' d• I`"N.:O`N Ln CO CO LO Lr) N- Ln d- 0 •CD ti IZ a. >- d` N r - e- O CA CO- N r N r.r- M r d• d- 7 C� N .> LL r r• r N N r M - >, _ E gc ci CO : CZ C C/) C Cl) u) F c cca C O m a) c v E N o —c co a) -a)- c Q CZ �'c RS a) -= -a vi s= o •a) �,}' a) m c ca rt Z LL 0_ LL ~' a) I3,m (� 0. " = O N O I V ,�N ) •V C G- CU 4t c 0 = O w L a) -a) Tf)_ — 0 ,- v a- L . a)F a) Z ca a) O co u) CD 92 a) 0 O 0 cn a) a) co a) C7 � � .� o� � � 2) 03 fa_ •� c to 06 a) a) a) v CL = = .- •c 06 0 I-- Q. . Lu 'a N Cr) m _ D a) L chCD �_ cn v cn. u, ;v c 0 s= O� I- CO W J CO W O o O cL C O i- D' E Q W Q`2 0_ 82 a J m 0 Ci 2 0 LL I- W (r) o LiJ o r- ............, _ '_' _ _ O co Nt. C) N,C) N. 0 00 In M CO CO MI o O CO 0 CO O co in in 0 ,- d- d- in O Ln I` O d- N 0o I` co N 0 0 0 00 N 1 CO Ln I� Ti- O N N Ln 00 I- CO 0) O N N CO C') O cc 00 CO ,- N d) - 0) r- N Ln d~ N 0 0 0) 0 `I' M CN O CO 00 t- M Ln Ln Co N- N ' L) N 0) 0 T- CO' CO CO d" N. O d' ,- M co coco CO VN I` C) ti CO I� CV - N M M 0 v- N N ,- �° M N I Z >. W LL 2 (A. 1 E Eft I 0 _ Q (o .4. d- CO 0) C3) CO M o 0) N 0 N• _M c CD N Lt) M CO N 0 M �- CO COCO M N M O O d' M CO O C3) C3)` M 0 �.. Co O O N O Ln co"- O N co LC) r- M Ln o Q 0 Op CO O M M M 0) CO M d- LC)I 0) M N co o 0 N Nr CO 0) CO r-. (0 T- CO Ln O `cr N M `� CO N >" N N- CY) Ln Lt) CY) N Co DO N LL m M —.N 0) 00,O CO o CO C) ,`Ln ~N CO o C3) T' d~ d' d• 0 ti C3) CO 0 N CO C3)' N Co 00 N. Co N 0 C3) CO ' CO M CO I� O C3) N O N CO • N. N oi I- CO N 00 Ln ' N- C) M Ln '- O No Co 0) 00 CO M N N CO UC) d' 0 0) M N CO N Nr w- CO LOCO N d Ln O ' NN Ln 0) Co >" C`r) r- C') Ln Lt) M N-1 Co 00 CV- LL LL j 4A Eft I. ( C co 0 O N C) Ln M d- o N- LO r- O T- N o N- M D 01 d~ Ln N 0) O) 0) ,- 00 co d~ N- LC) d• d• Ni" CO C3) d~ Ln N 1 M N- N CO 6C) (3) CO i C3) O O O O - Tr CO N 'F C3) Ln 00 ' C3) N co- L()1 r- r- M Ln o C) CTS N �0 00 O 0 NN- CO T- d' in=C3) M N O O CO - CO Ln O) d- N N Ni- O >" M N C'r) Ln Ln M T- • Co I M - LL .- E E Eft Z ,....-• - Y.. v- It) CO CO 0) CO CO 0 N- C) r- LC) N- M o CD 0 N Ln -- LC) 0 0) N N- 0) r- 0 d• 0) tt) CO CO d~ CO N 7) 1 0) N - N CO 0) CC) r- LO N T- 0 Oi d' CC) ' C) O `e- - o O LU M 0) M M N 0) d' ` ' d• 0 0) CO N I� \ 0 ty - M) d' `I O N Ln 0) d• N ,- CD >' M N M CO CO co CO - M LL 0 CT v- N. H roUD CDr- O I` O C3) co I0 00 N Ln I` T- C3) I` M Lt7!O CONd' o N Md• O i Ln ti N. ' \ M tlCk d' T- O (C) N Ln _CO Ct) M r- CO aj M crs U C co EA- Ef- ( It (ii N 0 CD CO 0) 0 0 0 O N. N N- L() 0 O Co C3) N O COOD Ln I` O O O O M CO r- N 0 ti Ll) �- Co N N- Ln O L() O O CO CO 0) 1,.. 0M0 N O C co O CO O M O Lt) N N M N O 00 Lt) N CO as 005 O Nr d~ 00 O O LO in O 0 O d• Ln N N N 0 Nr C) 00 M C3) r-' M M 00 CO d' N M M C) N N N M N- N M N N N _' LL 1 C i M 4 .Q Eft EA- Ef, N CZ mCIS ToU C/) C Cr) coC (I) C 3 C U- ) (D cy X a) U Cu (n •U c 76 1- w C' to C >- C t= O CO Cl) O i O Q COZ 4-' 'a - CV C (3CD I RI C Q C (a C (a Li- CD O O 0) N +.+ O +_ V m C O > Ln C' 0 V O 1- LL CI LL C t/) O C C OL CV L .O N c CU N 0 LV LO C O V O a) C� O cn 2 O C) L C0 0 O = O U > i ' C N > a) C > CO C C .= a s Q) •C 2 cv 0 a)I N w - C C - ca' a 'a coLij O mt= 3 ON C O O V C C 0 O N L CD L L. CU (a CD �' = CI) L 13'• " a) iZ 0 .O > C O > _� O CO C C �+ Q `. O 'O d 0) O s O a) T 'O )( O- O" = C O X C C co U 2 (� O 0 ctQ W 0 C 2 u H w Cn o w m cn m 0 > 51 -1 -niQ KfO)O CO r te 0 D > m D G) > 5 H O -0 0 73 0 CnIU)r 23 - a c X -,,n O C v C 1 v (D C 1 O-v v C v (2 x CD a 0. O -.3,w 0?CD o ~'l~ 8 co CD a -a (D o ,19: v iii v a12!3• D cp:ain� N ca. 3 m o c v v m m r v(23 n:3 m rn v < ca . O .-: (c n a te m 2 x ,,,>1 O .l�.6 ca 1�Q . (n v� a c ." x x� ? m Q°(4w c m CCD -n c a —Ex 3 cnIm v •+ 5 a < m cD m m . v) () D) (D a) ,D 77 ,� (D n o - n) FLI, ca o -� a (1) (3 u x x m a rn, €-a m u� N n€o cD fD m cD o }W —rn a TI a -0 3 �: £m -- o m o o < m c 3 c {c oo -� c c (D (D c N A 1 v x`< N 2 . C 0() (D (D (D (D 1' g(.° -a c c cli RI •c `�l n (v 1 ;3 0 i N • k t E ; ' m m (D (n 2•€(�• i3 1. o ". N 1 tto G € tt O �1�al (D (D C7 0 * .- (D Io (D (DJ €R E,Ti-, n N 1 3 co Cn o (D( ,_ N C I (u o - a f M. _ _� _ 1 £ I ta. �F W W _a N N : —— m (o A W W W -a-a N N (3) 00 03 ---.,.-1 -+N A ^< 1) N W V V A Cn 1 V Cn (r In W A-N),CIV 01 lo (O V O CO-01-0 Cn Oo,—W A -pN N Cn O) V V V V 01 O Co W W A V WI 0 V coO) -- -.. N O V --.1 N O) (n A.-• -► 4, O (D O O) _, -A 1,1101N,Up N Cn CD A -AO) Co 11 V Cn O O co O A --,A O Oo-,0 co . O n W Cn A € --, -4 O€O 1-.-co W A Q)00 cD 0o I CD A C) O) 03 O V`1.31-c3 O i W a)c0 00 0o (0 N A V V O t O O f co-.0 NJ CD CD N O) O) W A A A O --01CD O O)(D •A V W `A 0 N N#O£O1•p O -A 03 V CJI 03 N3(D co Co -.O -A O1OiO W -►O -.l CD t F £ E EA to EA } r EA EA EA ^. Ca CO E I f „E W cam) _, --1. (D _ W -1 _a- —I.,..., N --W 0) N N --, -' —'in CO Is A N V A O 011 Cn I V -,(n N I W A N-A V A 03 V O W1 cn O)N O(n co C)1 N (31 N N W O) co O)A oo -•.O°O 1 cni WO'V V(n I O)co -. V Cn Co V A,CA,co A (J1 COOO O(n(n 4, O O W (D . — A O)W O N i O V Cn 1 A A A N i(n (D —-. 0o C, N O)!V co 4,1 Oo O co Cn£CD (D •- O -A "T' V V 03 C7)O N 0 0 0 €co Cn O l O)A Cn U1 c_'•)5 V C) co 1,1=4 oo O I O O W I W N W CO CO O Co (n O (n -.N -A W O O 1(nI A 00€(n(D A O O) A (J1(D C) Co V CD,-.U1:Cn O O C7)—C)O c O O coO A(11 01 -A 00 01 O N NJ O)(o O 1 O 1 N O V coO)1 O O oo.-� (a O) oo O)(D Co O) O)' -. £ € -� O 'a) A - N -A LA .. -.,N -.W O) A W — co (n ^0C) V in N W(n-4{-oo 10NIA-a))N A V W O oo N W(n O) N -. A Co CD O -. .A N w (D -4 co (D(n 0o cO O O)i-.,4, V1O— -41-.cD V A -. W Cn O)CD 0)1 Cn O Cn W 0 N 01 0 (9 N 0 00 (D 0o (n O V V N n0 O)oo Oo W 1 N C) A N N co V V€N O 0o N W a) ID N Cn W V O O W co O A;A (n O)I(D-co(D O V O Ca In -A W lo In O O€O O W A cDO A N AD V -,1-,i N N( O N W W A£Cn N W O a)00 O O) (n (O U1 03 qq 0.) A co O O O)W O) a) a) A o N -A O) A -, O OD CO A O)O-,01 O 03 N 0) c 0 CO V W j N W A 0 0 0)Cn 01 0o -' _,.:..,.......,�.�.... , .m lw_:� M. EA EA EA 1 (A in EA co W € co W _,_, -n v ^ 01 -A N -A -.1-. N A,- co C3) A W -,O) 00 "C "CCD U1 N co O V A CJ1 V I co Cn W A In,W I a)op(n C) oo W co 1(n V N N W Co V V CJ) -N N O 0) V W O co A 0 0.O)1 N A W N -.O V O A V C) N W Cn V -,03 O O Cn CO A W 0) 0 A CO C) A N A V Oo O V l A V --•co O)A co 01 A N j A oo Cn Co co O co W O Co Cn O Ca V O W Cn V W O A 11-�V W O-CD N V O W (D (D (D co Cn-co 17)1-n)O W O)V I. W A cD N CO co O O N 1(n A V N NJ O O oo i A in Co N oo A 01103'-A 0310 O CD Cn A A Co 01 O)9) 0.) -A 0 N V.O Col N W A V -,N 0 A 3 A 0 o 00 -A V 0)03,A H O O O)Cn N a) OD „. ...,..,.,.. 1 1 W W } 1 „ W W -4 Cn -.1 CO-A —1 N -.W O) A co _,_, 'N O) V 2 O (o V 00 00 O A Cn V 1 0o•(n NIA O)W co 03 ) V co co W 1(n V N—-A co O co cD p N (n O O) O -A -A V co O O)1 N (n vil(n -.. N€N O O V co W O) O)£V N CD W O:(n.-.(o a) V O 03 (n 0( j co ace. W N O V A N Oo A O)co 1 cD V 1— A O V N w0)1 0.W N.0)0 00 -A Co A - N !(D in 17) O N O) O O O-4 � O)N 1 V(D O W O O) A N In O)Oo O O W.A'N a, Ca A C7)O O) Co V co O)O N 01t#V co Cn N (n•Ott£Oo N W A -LA O) A V -. co'O O O),-,(s1 00 W W N o 0 -,00 -A Cn O 03 N#0-ACD -A V O(n W CO c -i CO N O CO O)03 O O C7) A CD -I. - CD -D 1 1 EA EA ' T a) _ 0) � W -A I )_.N A O Cn 4 ...ti 1NIV V ”‹ a N CO O co 110 N N(n V 1 co(n i.)1-4 O)co -,oo O) -L 00 W W(n V'1,,-L-.0o 1-N)O O 4, N -- A O) O ,1 O) N NJ 0 O) N'(n 4,103-•Cnu33 co — Cn V C) A N V'00 W O N O 011 N N N CO O C) -A co N W,Cn W C3)O V O) V O f O CD,-.14, A.Cn O s O O W A O)Co O O 0314, -A 03 W W (o in 0)O co co 1-co O in O A V in,Oo in CD Cn Oo co -A tD 7-_" W Co (n O -.In O O O W)-C --A (31 Co W CD A in co O)€O) Cn A O N O N - N N V O O N -.•O (D (J1 A 0) V W Cn 0 0 0)1 0) A W V CD cD 8g O Cn W CD V O Co'N3,(D O)W �V O Co co O)a co Co O N co Cn A 0 O O)s A O W 0) df to, 1 EA EA I IlE E!/ { "C ✓ A V CO- V 01 Cn V 00 01--11)-.O) W A co V N co A 0)1(0 V W O-C;o)-4`-co N -I' N (D O) Cn N N (D -A O O) N 0)011 O — V A N -A O) 01 A O -JC) A O(n O Cn N 01 -. CO O V (D 03 O 03 N CD W 0 V(D N 00€A 0)W 0 —N (o 0 N -)CO W CO W O)O CO A 0) O N A -C V O C) O a) W 1.O A W O O•ooc0 V A(n W co V V O W (D 00 Co ba - O O)01 A 03 A V A (o(n co 0o O NJ O W CD-A N(n O V Oo V CC7,) O co O)U1C O)V N -�:O O O)CD W W �') (D 03 A o --, V 1 C W N O 00 A,A(n A -C W O A CO CD c W W -. N O—C (n O O O)CD.V V CO EA EA EA EA EA 1 EA € W W 1 „ (.3 G•) 1 _a N _a V N W -4 -+ -C N-.A€ O) at A _,I-� N(3) A 'C -1 CO O oo N CD A Cn V-co I Cn -A in O)1,)in 1 00 V -, co N W U1 V 1,1-c) -. oo O)In V 01 N -I A O) (n 0) (D (., A O O)W 0) N N -,(D)(7) N O) O) -. W V co V O) -A N O Cn -A co -,. CD a -, (n VCn -'W O A O V —O) co 0o O)Cn 1 co V 0 CO 0 CO O (n(D IO O A O 0o co£G) V CD N o N P. W:N (fl V O ACD A N1O)(D.N N£cD A CN O) O) O -.'-4,11n JoO€OO -. -4 V -. A N O1A O) V O N Cr..O CDC)N(n OIO)N cD A A W -A Oo W' 0)0) 3A W NJ Cn c -, (D(n Co A O Co,Co(n (nI(D -.O)€OW co A c (n O A V N-A A O O O Vico (D 01 EA 6n EA 1 1 I Efl EA EA (r) W €1 1 1 W W1 - -n N V N A -. -a -.N-. A O) Cn A N O) N -< - W A in Oo A N A Cn V 0o (n O in O)A oo co 00 -A oo N W}Cn V W CD -A 031-03 Cn V 01 N A N 0) w W V W O)O.O)Co V VI,Cn-A-, N W O O) N A co co V V-,0)0010'- V O 0 C) CT1 V --, 00,V 01 O O V A O W 1 O O),(n W 1 W Co V C) O O) O V-.•-.10 O'oo--►:A -' CO O A A ('•)O V - A A N (n -O O) Cn O)€A ID' 00[if) o A ° -. O � V A W O) 00(O O (n in co O O) OD cD (n CO -41-4 Co co O N O)0 0`Cn NJ-.,C):(n (n Oo O -A -A O Cn O N(Ø)QO)O) -A A VI A Co (n o0 -1 N V A O 00 01 O Cn N -A O)O 00 N 01 o N 0 N -, -►Oo°Cn1 0 01 O)CD N N EA EA EA :.�. ,.... ... a,. .M .. g EA CA EA M £ Z 1.-i W W 1 " W W € "_,. N 00 'NJ A -. ! -. -.-.N3.-.01 i 1 O) (n A _, 1 1 NEO) W V -A 03 O) 0) A (n£V,-co(n O 1 in (3) o O 1 Oo 1 Oo W n W 00 ( (n V W(D -,03110 1-01 W 01 N ^ N -4 N Co NJ O) Na A V CD O)0 0) C4 -4.Cn 1 V -.1C, -4,C,;(n O) co A A co Oo CO N(7)10 (n 1 0o I O) A O `, coV A O A 0 V V A W.N O)01.co 1 co`Co V W O) V O) -A N N€0 O oo W 1 N a) - � �I - -' a) --.1,17, W -4,1-4,' co O O) O)i(n(D171-4,10 O 0 Cn A — N N A--.11-o O W Oo I N A Cn --.1C Cn O(D (n V O N 1 N O O 1 W NJ V O i(n coA 00 — O O —C O) -.O O O O)Cn'(D O N A A A - N Cin co 0 Co (D 00 N -A O 00.O) V Cn•Cn-.O)O W:O A c w A cO Cn W O)s€O O O) O co A CO d! Ef) to 1 ER EA EA W W I 1-' W co (n N 0o N A -� -► -� N -.,(n0-3 cn A co£Oco i 91 to C31 N N (D Cn Co-co 00 A (n V j CO.Cn O I Cn-0),,-A`,N A 0o I(O C) 0o Oo (n V 1,1a3 Co cD C O) V Cn V A co O CNC,W V (n€Co -A(n O I A I O Q) C) Cn O O Co CO W 1 O)0)01 O) -A 00 C 0 03 O) V V W(n V A O V'V CO 0.)1.4,O)Cn V,Cn I(n V O N co -. A W W{O 0193 O)O N co 00 ID N -' O N --.J1-03 0)V O A-4,1-,1 O)€O) CD V N€(o'.W a O 00 co -C V O0 A-(.711-0 O OJ, V CO O N in V O lc) (9-.O N N1°l0`:---►IN W O1A1N 0o Oo co O oo V N 0000 O)€Oo A C) A O)8g (n Co O W O I CD O) O Cn 1001-..O) (DI V oo O O O (D V W(0)O.O O)i N O) N CD r... O c £ i t 3 t �, - M 0) > x 0 "`� o c M X10 m 7i 0 > - -1 0' 0 Cn 1 0 73 CO -1 C) c O 7, K (D Q. - 0 s Y az' 0 CD CD E. � C� m v 1 cD v a. O• a cD D rn ° c' v v N 3 Fps m Q) i (4 eD ( *m E (/) D , 5 la) m _A a * 9+) = n , :..4. 0 7:j u)i'-' 0 CD x -, Q _ fD .+f CD G7 01 C (D TI s1 �. ° r. a < << €�, co `< cD =' C (7) :2:, 7x 73 iitoonCo' N (0 0 v m m cn a ,•, k vii x 1 m a D"0 (D rn (D co ° 5 4 0 N N n -n -0 71 03 n c�D CDD � c cin N N 0 (<D CD i CD l CD i C -1.N C - a O- O i =r -O C C € £ • CD (D a r"`' Oa 0 (n Ohi (D (D I C) ma) Co O = n : :i DC7 n i x = SD __ CD 0a EA E) EA VD CT € € 1 m W CD 0) - W O) 0) W N N N -D --, N) -, --� N A CO 01 A A ,.,I A 0 ( , CO 01 A 1 v CD Oi C11 01 0 000 A 4, 0 D - N a) (Cl A V A -4 CO O N 0) A N N) 01 1 O i 0) CO 01 0 - CO m -, 00 C0 O CD-CO O V 00 A 00 Cb O ib i 011 . 011 -1 N 00 A 01 00 N co V O V1W CO W W Oi0=O -4 01 00 N 0) -A CD £ - 0 O 01 i 03) CO V -4 01010 CO 00 C) O EA EA EA • EA EA ' to i } 1 'T1 € "C W O 0) t -L 03 O O) � W N W A N W _ - A CO 1 C11 C) --L 011 5 ,W CO .s -P N W 00 CD -A A A 0 ) 01 0 I J -A 00 01 N N 1 W .0)1 CD A 0 CO CO CD W . CD CO 01 W 0010) A V CD -1 01€N I.:- CO'CD (Cl Cc) 0 0n 01 -- U1 -' 011•-,1 J A 0 01€co (31 N C) CO ,1 O - -..i CO W -, V N 4, 03 01 co 03) (00100 ) N O V CO A CO€CO 01 £A 03) A CO C) W N) -A CO N 0 C11'0) N o C.3) 0 0) W i 0) CD• CO 01 N '� EA EA EA i EA EA EA 1 ..:,„„,........ W 0) I 0) W O C3) ; W s N W -' N 01t - N N A CO£011 N -, O -, A A A N C) 03) -, --L (11 011 O CO CD O••-4 -L A A CD €N<CO. W CO CO (J1 O C) --4 O Co N W A O -L 011 I C3) W . N CO W 011 (3)L N A A co O N A N cn O.---4 A --L CD C11 100 CJ 00 N 6 -,1N)N f CD CD N C) W A O 6 (3) -,1 v CD A O£CO --A •-i --, CO N CO i O'01• -A cn V 0 --L 0 0) 01-, CO -4 -A 011€0) W o 0 --A -I C � - 0) CO 0) 0) --). EA EA CAEA EA EA a 71 £ N 0) i 0') -L i CO 011 01 CO N 0) -‹ W CO C) -,i--, W N A CO 1 03) -co _a 0) i-k 011 O _, -P N O 01 -4 -► C11?0) 01 W CO 0111-4 -i. -. W -4 1 N) CO 0 0 C) 6) 0 CD 0) A W Ufl CO O -A -A 01(0 N) . V CO 03 C11 i CO A N 0) C) Co W N 9) N 01 0) 0 01 0D C3)1 CO " Q) CD - -CO-N31-41-03 -1 01 N W i CD W 00 --. W -,1 1 co A .A C11'a) �1 (D A co --, CO€co co -,1 6 W -. co co 03) z,,- V 1--' 6 -� --AO W 03) o A --., CO CO (.3CD J O O 1---- ,-,,,--t- - EA EA EA s € EA EA EA 7 -a _a C) 0) N W C11 011 I 3 co --, N -< N 0 00 -.1--, A N A 0!V V 0) -A`>. (11 00 W -1' N W -4 CO -b. C11 00 CO CO CD 0 i 0) --L CJ1 CO N) N)1 0) 0) OO0 --.1 0 I -4 O W CO 0) O --LA � C11 C11 --. . CD -4 -, MI 0b=N 0) -4 CD '� . -tD CD CD C3) N O o O N 1 CD---.11-o P -' b -co W 1 03) (11 . co CO 0o N ca O 0o 6 W co!(A A N A:co co N O 00 N (n CO 1 V O A A cD N O CD V o O CO N -L C11 -A CO o CD W W O i CO CO �I 1-A -a -p r w EA EA EA 6,M..,,- EA to f EA 1 m i i ; -n 0 Vi a) N€W (Cl 01 5 1 W - -, N Q. — O -� N (3) N A 0 00 00 0) I O CO N C) 0) 0 -1 0)£O W CO CD C111 011 -L W W CO I W W 0) O W 03 0 0) 01 W co N N co -, - 01ro -4 CD CO CHID N 0 0 - W W N - V N 03) 0) A W CD CDN v -' CD 0) W A I A I O O W tD O (s)0 co N -, N 4,1 03) N) N) A A A 'I A co O N) 0010) 01 -, N) O N O W 'tel ,I -A S O N - O CO A o CO CO A 0) CD CD O) A N 0� EA EA Eflr„.. I EA EA EA I s m ....... j V iO) N W 011 (1t W I.-� -< N W -+ -,j N v N A -.,CO CO --L 0) 0).00 N ✓ CO 07 (3)i N 0>o N CO O C11 -� W co CO W N 00 CO O (c) 0 N CO CD W N C3) N -� CO -� C3) W O O CD -L C111_0 CD CO 0) O N A 01 J 01 � - N CO CD,b I W 00 A W 0111 N CO . 01 0 N Ca V -4 CD -1 N A k(3) 00 A 100€A 61 - -. W -1 -I'00 N) -.1 N) O co co W N o N i b () O) -, A 6 co - A CD 01 03)1 O N C11 co N Cc) - s EA EA EA £. EA EA {,/! i i I I i I € m N -L V 03) N A (Cl cn W - CD O) WN__. co N A Co CA -, 6 €- v (3) N 01 N (Cl 00 W -� 0)I A N) W CO 011 A -A (Cl CO N) 1 N N A --, V O 0 N 0 CO 0) CD 1 W 0) 0 --. 0) 4 -, i CD 01 W C11 103) CO• -1 C11 NJ - '- V W 0) N O (11 O A CO 1\)14, O N -• W 0 03)i A O € W W 011 0W (31 W C1-11,1 A - CO f A CD 011 A N) -J A CD V 0) 0) 0)1 A N N 0) V -► A V 0.,-,,E! CO 5 0) W -L:CO N 0 W A CO CO N 0 C11 3 0 00 01 � i .. -- O v EA EA EA EA EA EA € �+ A -- V' NiA (Cl 011 € W � N O CO 011 -� N O N A 11...)1---, O - A i-� 00 6 CD 01 N D U1 0 0 -A 4 i 0) 0) N CD/0,4, -, O co -4 1 N) N O - 011 0 0 ^ N 0 C0 0) 0) 0) CO CO - 0)I--A 0 . CD A A C11€011 V � 01 r `/ (D N CO N -,-co O CO I W C3) .JO ..--� CD--4!-031•0 -4,1--L -...4" 00 C) TT N CO A -► -L CD 1 -4 011 A s V I O �J -co 0n CO -A A N'N -,1 a, W O i A CO W A N k-4 A CD A;O Cn -L C11 C11 C11 C11 N i 03 WO v 0) EA EA EA .._,,.- { I EA EA EA rn E _ i Z O N V 4 i iN£A 011 CI1 W -A T. -coO C) -,1 N N N A 2 N N CD -� 01 -, a) 6 co 01 N V .„ V CO -1 i CO - 0) CD C71 W -, 0) W W N N) C)1 -L 0, -.a. 0 0 -, 0) A A 0).N) 01 -L -' Cr) 01 0 01 01 O 01 0) -4 £01 01 N V 1 00 (b 00 O N ',I' W -, CO C11 --1 v " CD A A-co C>7 N . Q)€ CO CO O O -, V v A 01 A -a N) W O O CO - N;co N) -i• 011 N N 00 W 0 0) 0),CO 0) CO -LCD -4 W o -4 01 N V!0) N V 0 A CD I kil to ---rt-------1 ; 1 1 m -< 0 0 N) V -1 1 N 1 A 0J1 cnW ' 01 N 0 -, 00 -,s W -co N A W i co V -L011 -,' :cola" 00 0 W 0) 00i N) 01 CO CO 0€N -, N W CO N N 0€-L ` -4 - 0 CD CO 0 A 0°0 CO -A -A 0) CD 0 N C3) 01 0111 V --4 CD°pi ->• 00 O 00 " N -CO 500 0) -A CD'0)s 00 ' --40) CO CO i CO N ---.H--,. 0o COc) 00 011 co 0 00 0 --J -, 011 A 0)i 01 03) O a) 6 O O€03) N 03)10) -, 0 O CO o -LN Co CO - A{A 01 0 CO 01 CO CO C3) N 0 -......CO t 4 TOWN OF ORO VALLEY COUNCIL COMMUNICATION STUDY SESSION DATE: May 29, 2007 TO: HONORABLE MAYOR & COUNCIL FROM: Stacey Lemos, Finance Director SUBJECT: Discussion of Program Budgeting and the Town's Budgetary Process SUMMARY: Several Council Members have requested additional information on the topic of program budgeting and how this format relates to the Town's budgetary process. Perhaps the best way to explain program budgeting is to compare it to the prior format of the Town's budget, which used line-item budgeting by department. Line item budgets were previously presented by departments whereby each line item defined how much money could be spent for certain "items", whether it was Travel and Training for the Finance Department, Office Supplies for the Town Clerk Department, or Vehicle Maintenance for the Police Department. This format was simple to explain in terms of where the taxpayer's money was going. However, while line-item budgeting provided the essential elements of order and control, it did not address issues of performance, quality and accountability. Program budgeting, on the other hand, places considerable emphasis on designing a budget format that groups expenditures and sources of funds into functional activity categories. In program budgeting terminology, a function is simply a group of related activities for which a governmental unit is responsible. Many local governments have evolved to a program based budgeting approach because it provides some functional perspective for decision makers. By organizing budgets into functional units, the focus turns to the function itself and the delivery of services. This budgeting framework then tends to lead decision makers to ask the question, "what do you do and why do you need this money to do it?" Often, program budget formats in other jurisdictions display goals and objectives of a program to answer those questions, and also include workload measures and performance measures to measure the effectiveness and efficiency of program delivery to residents. Performance budgeting often goes hand-in-hand with program budgeting as it emphasizes the outcome of local government programs and attempts to measure the performance of local government. This format of budgeting also emphasizes strategic planning and setting goals and objectives to support the strategic plan of the local government. One of the challenges of performance budgeting is identifying meaningful measurements of performance. It is easy to quantify workload; but much more difficult to measure quality, which requires a gauge of public satisfaction, productivity, cost benefit and fairness. G:\STACEY\Council Communic\Budget Work Session 5-29-07 Program Budgeting.DOC TOWN OF ORO VALLEY COUNCIL COMMUNICATION PAGE 2 OF 3 THE TOWN OF ORO VALLEY'S BUDGETARY PROCESS AND FORMAT Oro Valley's transition to program budgeting began in the fiscal year 2006/07 budget process whereby the Town adopted its first Strategic Plan, identifying its priority focus areas, and outlining steps to move the Town towards its vision. It provided direction to local decision making and a tool to manage resources. Also, each Town department was asked to identify their main program areas and identify a set of goals and objectives that supported the Town's Strategic Plan. Performance metrics or outputs were also reported by department as a means of measuring workload. The budgets were still adopted at the department level in this current fiscal year. For fiscal year 2007/08, the Town's Strategic Plan was reviewed and updated by Town management and elected officials. Internally, more analysis was conducted to determine the level of staffing and departmental resources that are allocated to each respective program area within each department's budget. This allowed the departments to prepare their FY 07/08 budget requests by program area, rather than by line-item at the department level. The departments also established goals and objectives for the year in support of the Town's Strategic Plan. We are still making the transition to a true program and performance-based budget format. One hindrance that we've had in the past has been our accounting software system, which prevented the Town from being able to capture and report costs by program area. With the implementation of the new Enterprise Resource Planning (ERP) System, the structure will now exist whereby program expenditures and revenues can be measured. Also, now that the Town has identified the various program areas, citizen surveys may now be conducted to measure constituent satisfaction with these programs and services. Funds are included in the FY 07/08 Recommended Budget for such surveys. Additionally, over the next year or two, realistic performance measures, rather than performance "outputs," may be developed for our programs to evaluate how well we are doing in their delivery. Finally, to illustrate the format of a true program and performance-based budget, attached as Attachment A to this communication is an excerpt from the award-winning City of Peoria's FY 2006/07 Program Budget. A separate budget sheet is prepared for each program area outlining a description of the program, which Strategic Plan goal(s) the program supports, the goals and objectives of the program, the performance measures associated with the program, and the summary of resources allocated to each program. The Town of Oro Valley's budget by program listing is included as Attachment B. With the tools that the Town of Oro Valley will have in place to track costs and revenues by program area, in concert with the goals and objectives of the Town's Strategic Plan of financial sustainability, leadership and communication, and quality of life, Oro Valley is building the foundation for successfully transitioning to a program and performance based budget within the next year or two. G:\STACEY\Council Communic\Budget Work Session 5-29-07 Program Budgeting.DOC TOWN OF ORO VALLEY COUNCIL COMMUNICATION PAGE 3 OF 3 ATTACHMENT: 1. Attachment A - Excerpts from City of Peoria, AZ FY 2006/07 Program Budget 2. Attachment B —Town of Oro Valley Budget by Program Listing / 2--. )/1d/O Stacey Len os Finance elector 04,04;( David L. Andrews Town Manager G:\STACEY\Council Communic\Budget Work Session 5-29-07 Program Budgeting.DOC / ATTACHMENT A EXCERPTS FROM CITY OF PEORIA, AZ PROGRAM BUDGET 1 Operating BudgetSummaryBy Division City of Peoria,Arizona FY 2007 Community Services Department - Summer Camp Program Related Council Goal Peoria Summer Camp is designed to assist parents in need of full-time childcare and provide parents the same level of servive as provided during the school year. The program provides summer fun in a secure To provide efficient, effective customer environment,and features a wide range of on-site and off-site activities.This program is licensed by the service which matches Arizona Department of Health Services and has Arizona Department of Economic Security funding available or exceeds the service to qualifying parents. needs of the citizens. Goals and Objectives > Provide a supervised and fun environment for children throughout the summer in partnership with the Peoria Unified School District. ' FY 2006 FY 2006 FY 2006 FY 2007 Budget YTD Estimate Projected • Ensure all staff are qualified to work for the program and meet all DHS requirements. ✓ #of participants receiving scholarship/assistance 100 140 140 150 ✓ #of participants attending per week 1,300 699 750 750 • Ensure all locations meet health,fire,and gas codes. ✓ Average#of staff per#of participants 1/20 1/20 1/20 1/20 ➢ Provide a quality program that meets the needs of parents and participants. FY 2006 FY 2006 FY 2006 FY 2007 Budget YTD Estimate Projected • Survey school principals,parents and participants for customer satisfaction. ./ % survey responses rated the program above avg-excellent 87% n/a 87% 87% 1 %survey responses above ave/excellent-safe environment 98% n/a 95% 95% 1 %survey response-had fun in the program 99% n/a 95% 95% 1 %survey responses-improved socialization 94% n/a 95% 95% 1 %survey responses above ave/excellent-cost/value 93% n/a 95% 95% • Review and implement needed changes based on evaluations ./ %of cost recovery 118% 96% 118% 118% • Hire,train and retain quality staff ./ %of returning staff 85% 83% 83% 85% Summary of Resources Authorized Postions l FY 04 Actual FY 05 Actual I FY 06 Estimate! FY 07 Budget #of Full-Time Equivalent 3.00 3.00 3.00 3.00 Expenditure Category FY 04 Actual FY 05 Actual l FY 06 Estimate) FY 07 Budget Personal Services $408,058 $493,194 $551,195 $624,044 Contractual Services $88,976 $113,816 $143,401 $151,250 Commodities $51,322 $96,637 $96,732 $113,940 Total: $548,357 $703,647 $791,328 $889,234 %Change from Prior Year 28.32% 12.46% 12.37% 121 Operating Budget SummaryBy Division ity of Peoria,Arizona FY 2007 Community Services Department - Parks South ' Related Council Goal This Division is responsible for maintaining all landscape and irrigation systems in Park and ROW areas in the southernp ortion of the city. In addition,this division is responsible for Neighborhood Park facilities including Toefferovctipide effcustomericient, ve playgrounds,courts,restroom buildings and ramadas.This division is also for graffiti removal Citywide. service which matches or exceeds the service 4- 'Goals and Objectives needs of the citizens. 1 ➢ Provide safe,clean and aesthetically pleasing Parks and Right of ways in the southern portion of the City. FY 2006 FY 2006 FY 2006 FY 2007 Budget YTD Estimate Projected • Daily-Trash removal,restroom cleaning and disinfecting and ' ramadas spot cleaned. ' ✓ #of days maintenance standards attained 364 273 364 364 • Weekly-Turf mowed,play equipment inspected,ramadas cleaned and disinfected and sidewalks cleaned. ✓ #of weeks maintenance standards attained 52 26 52 52 • Weekly-Litter removal in all major arterial ROW's. , ✓ #of weeks litter maintenance standards attained 52 ' 2 6 49 52 • Monthly-Playground sand maintained,parking lots cleaned and all ROW areas maintained. ' #of months maintenance standards attained 12 6 11 12 • Quarterly-Maintain all drainage areas on a quarterly basis. ✓ Quarterly cleaning of drainage areas 4 3 4 4 >To fully satisfy customer service concerns by documenting work requests,response time and customer follow up. FY 2006 FY 2006 FY 2006 FY 2007 Budget YTD Estimate Projected ' • Inspect and respond to all CUSTOMER SERVICE requests within 2 working days and assign work orders with completipn dates. ✓ %of CUSTOMER SERVICE requests met within 2 days 100% 98% 98% 100% • Inspect and correct all SAFETY related customer service requests within 24 hours. ' %of SAFETY requests met within 24 hours 100% 100% 60% 100% • Complete all ROUTINE work order requests within 24 calendar days. ✓ %of ROUTINE work requests met within 24 days 90% 90% 90% 90% • Complete all NON-ROUTINE work order requests within 45 calendar days. ✓ %of NON-ROUTINE requests met within 45 days 80% 99% 90% 80% • Conduct customer service follow-up communications on all customer contacts within 72 hours of receiving the request. ✓ %of customer follow-ups 10% 10% 10% 10% > To utilize water conservation practices throughout the Parks and Landscape system. FY 2006 FY 2006 FY 2006 FY 2007 Budget YTD Estimate Projected • Install centralized irrigation and water management systems to help reduce annual water consumption. ✓ Number of parks with water management system 7 7 7 7 ./ %of water savings(gallons)compared to previous year 0% 0% 0% 0% • Inspect parks and landscaped areas to ensure systems are functioning properly and plant material is appropriate. ✓ Perform weekly inspections of equipment and plant materials 52 26 52 52 136 1 Operating Budget Summary By Division City of Peoria,Arizona P g g FY 2007 • • Community Department De artment - Parks South >To maintain all public lands efficiently. FY 2006 FY 2006 FY 2006 FY 2007 ,Budget YTD Estimate Projected • Establish and maintain parks and landscape efficiency standards. ✓ Number of Parks 15 14 15 15 ✓ Acres of Parkland 139 129 139 139 ✓ Acres of ROW 90 TBD TBD TBD ✓ Number of employees 10 11 11 11 ✓ Acres per Full time employees 13.9 11.72 12.63 , 12.63 ✓ Cost per acre $6,130 > Expedite graffiti removal to deter recurrence. FY 2006 FY 2006 FY 2006 FY 2007 Budget YTD Estimate Projected • Remove graffiti in a timely manner. ✓ Respond to all graffiti hotline messages within 1 day 100% 90% 90% 100% I Respond to all graffiti work order requests within 3 days 100% 100% 90% 90% • Implement new and innovative graffiti removal techniques to reduce callbacks. ✓ %of customer service calls requiring a second visit 5% 3% 0% 0% Summary of Resources Authorized Postions j FY 04 Actual FY 05 Actual I FY 06 Estimate! FY 07 Budget #of Full-Time Equivalent 14.46 13.50 13.50 13.50 Expenditure Category FY 04 Actual FY 05 Actual I FY 06 Estimate FY 07 Budget Personal Services $807,788 $759,961 $833,158 $862,490 Contractual Services $668,391 $1,015,282 $1,329,282 $1,208,096 Commodities $117,819 $154,159 $121,926 $153,138 Capital Outlay $4,062 $0 $28,500 $100,500 Total: $1,598,061 $1,929,402 $2,312,866 $2,324,224 %Change from Prior Year 20.73% 19.87% 0.49% 137 Budget by.Program Attachment B Town Manager Recommend Adopted / FY 2007/08 FY 2006107 +/- Town Council $ 230,546 $ , 214,741 $ 15,805 Town Clerk Administration 377,982 212,192 165,790 Meeting Management 77,093 88,102 (11,009) License Management 57,753 40,671 17,082 $ 512,828 $ 340,965 $ 171,863 Town Manager Administration 618,697 489,655 129,042 Community Relations 294,897 118,704 176,193 Council Support&Constitutent Services 120,341 53,784 66,557 $ 1,033,935 $ 662,143 $ 371,792 Human Resource Administration 188,176 179,939 8,237 Recruitment& Employment 117,129 101,352 15,777 Benefits&Safety 168,383 47,659 120,724 $ 473,688 $ 328,950 $ 144,738 Economic Development $ 207,815 $ 343,180 $ (135,365) Finance Administration 323,904 585,668 (261,764) Accounting Services 335,527 329,757 5,770 Budgeting 161,451 143,388 18,063 Procurement 129,818 - 129,818 $ 950,700 $ 1,058,813 $ (108,113) Information Technology Administration 345,788 214,229 131,559 GIS Services I 305,695 120,038 185,657 Technical Services 315,787 191,671 124,116 Web Services 166,575 74,887 91,688 Telecommunications 168,008 95,400 72,608 $ 1,301,853 $ 696,225 $ 605,628 3eneral Administration $ 16,432,595 $ 12,672,382 $ 3,760,213 Municipal Debt Service Fund $ 1,568,239 $ 1,722,461 $ (154,222) )racle Rd Improvement District $ 464,494 $ 475,242 $ (10,748) 'olice Administration 1,104,378 973,550 130,828 Professional Development&Training 307,159 484,674 (177,515) Office of Professional Standards 294,645 202,368 92,277 Support Services 569,124 653,125 (84,001) Records 451,523 427,270 24,253 Communications 844,022 788,594 55,428 Information Technology 203,106 212,070 (8,964) Investigations 623,335 556,943 66,392 Community Relations 961,082 927,667 33,415 Grants 474,139 463,952 10,187 Property/I.D. 217,491 215,284 2,207 Fleet Maintenance 239,903 221,388 18,515 Field Services 1,415,093 1,436,189 (21,096) Patrol Bureau "A" 2,817,491 2,974,486 (156,995) Patrol Bureau "B" 2,372,635 1,615,584 757,051 Budget g et b Y Program ra m ttach m nt B Town Manager Recommend, Adopted FY 2007108 FY 2006107 +1- $ 12,895,126 $ 12,153,144 _ $ 741,982 Seizures& Forfeitures $ 348,571 $ 371,853 $ (23,282) Magistrate Court Administration 134,532 131,365 3,167 Adjudication 288,766 264,697 24,069 Case Processing& Collections ' ' 288,071 236,969 51,102 Security&Transportation 67,493 71,826 (4,333) $ 778,862 $ 704,857 $ 74,005 Legal Civil Division 575,835 597,941 (22,106) Prosecution Division 421,343 388,833 32,510 $ 997,178 $ 986,774 $ 10,404 Community Development $ - $ 419,279 _ $ (419,279) Planning&Zoning Administration 289,158 126,835 162,323 P&Z Work Plan 56,164 25,619 30,545 Planning 510,373 464,183 46,190 Zoning Enforcement 376,200 306,638 69,562 $ 1,231,895 $ 923,275 _ $ 308,620 Building Safety Administration 375,988 310,246 65,742 Inspection 521,887 481,094 40,793 Plans Examination 481,319 480,732 587 Intake& Permitting 142,176 135,134 7,042 Implementation Plan 113,930 - 113,930 $ 1,635,300 $ 1,407,206 $ 228,094 Library Administration 579,222 526,591 52,631 Youth Services 203,564 230,915 (27,351) Adult Services 241,643 259,975 (18,332) Technology 348,994 328,020 20,974 $ 1,373,423 $ 1,345,501 $ 27,922 'arks & Recreation Administration 415,528 289,855 125,673 James D. Kreigh Park 470,438 725,384 (254,946) CDO Riverfront Park 288,891 254,384 34,507 General Parks Maintenance 112,902 111,493 1,409 Naranja Town Site Park 41,102 42,015 (913) Lambert Lane Park 41,282 42,015 (733) In House Recreation Programs 248,410 248,175 235 Contracted Programs 148,602 149,388 (786) Bicycle, Pedestrian Trails 53,120 46,252 6,868 Trails Programs&Maintenance 21,512 24,411 (2,899) Aquatics 632,910 519,246 113,664 $ 2,474,697 $ 2,452,618 $ 22,079 ;team Pump Ranch Acquisition Fund $ 628,113 $ 5,000,000 $ (4,371,887) loneybee Village Development Fund $ 706,500 $ 806,500 $ (100,000) Budget by Program Attachment B Town Manager Recommend Adopted / FY 2007/08 FY 2006/07 +/- Highway Fund Administration 4,498,902 3,394,200 1,104,702 Construction Design & Management 2,707,539 , 3,558,706 (851,167) Highway Permitting 105,828 99,461 6,367 Pavement Management 208,989 125,309 83,680 Street Maintenance 1,474,768 1,345,193 129,575 Traffic Engineering 347,097 433,075 (85,978) $ 9,343,123 $ 8,955,944 $ 387,179 Development Review $ 532,816 _ $ 502,261 $ 30,555 Public Transportation ' Administration 107,516 91,235 16,281 Fleet Maintenance 79,558 63,447 16,111 Dispatch/Scheduling Operations 112,077 83,451 28,626 Driver Operations 491,406 459,080 32,326 $ 790,557 $ 697,213 $ 93,344 Stormwater Utility $ 640,061 $ 1,135,575 $ (495,514) Facilities Maintenance Library Building - 76,582 (76,582) Administration Building 90,303 60,509 29,794 Water Utility Building 13,900 6,276 7,624 Magistrate Court Building 21,818 12,060 9,758 Development Services Building 47,101 32,508 14,593 Police&Substations 47,255 30,525 16,730 Calle Concordia Facilities 43,897 34,506 9,391 Steam Pump Ranch 15,000 - 15,000 $ 279,274 $ 252,966 $ 26,308 Development Impact Fees 1 Administration 2,021,347 1,676,110 345,237 Design 565,000 909,031 (344,031) Right of Way - 100,000 (100,000) Construction 14,000,000 9,412,819 4,587,181 $ 16,586,347 $ 12,097,960 $ 4,488,387 RTA Fund $ - $ 600,000 $ (600,000)1 Vlunicipal Operations Center $ 6,612,690 $ 1,320,292 $ 5,292,398 Water Utility Enterprise Fund Administration 8,670,179 11,422,181 (2,752,002) Billing 901,728 634,690 267,038 Conservation 162,424 141,623 20,801 Water Management 1,743,905 977,830 766,075 Engineering & Planning 352,800 314,724 38,076 CIP 4,312,616 4,410,811 (98,195) Construction Inspection 148,693 191,788 (43,095) GIS 85,041 82,319 2,722 Production 2,588,464 2,805,413 (216,949) Distribution 1,199,988 956,990 242,998 $ 20,165,838 $ 21,938,369 $ (1,772,531) Jternative Water Resource Fund $ 8,758,040 $ 7,208,468 $ 1,549,572 :onnection Fees Fund $ 13,630,142 $ 9,165,717 $ 4,464,425 Budget by Program Attachment B Town Manager Recommend, Adopted FY 2007/08 FY 2006/07 +1- Water Acquisition Fund $ - $ 3,500,000 $ (3,500,000) Capital Asset Replacement Fund $ 500,000 $ - _ $ 500,000 Bed Tax Fund $ 1,878,583 $ 1,710,039 $ 168,544 Less: Financing Uses (8,103,196) (8,301,260) 198,064 ::: ,\Za+t�<a-�;SSvr.,.. ..,,} •,.n:}�+ � it : -�`f„'•:X•4 r:'t`.`. a-.y\ '+'''f' 'K. '.. .�'}:. ,o? ...`.`” ::;:• :��4 ,�'� j�� J.:r Jr,JJ,Zcs.ff.ti.� �'.'•' -' /r±� `�: :}:'i. ?C�f.�-:-.1<vYr-.}.«•:'.'.fi.{A�.�CY?J.v:. .. ''-.:•'\! . 33 ../.4\�t;..) }.. .}i]i;. <]�::::..}•:.:<::f:�:. < -}}:n......5,�.. sr .SS.f�.......1�1....�.:..�.:....\ .}4f'. P..::::.... � {'�� �"'�...:.::• i!-}:•;-J'�}v}}:v +h -:f4.' .:�;:.J.:. .......... ................ r....... ... •.:. .....::::J}:;rte: MEMORANDUM DATE: May 29, 2007 TO: Honorable Mayor and Council FROM: David Andrews, Town Manager Stacey Lemos, Finance Director RE: Follow-up Issues from May 21st Budget Review Session A number of issues were raised during the Mayor and Council's Budget Review Session on May 9th. This memorandum serves as staff follow-up to these issues. 1.) Issue: Request for adopted budget amounts and bond ratings of the twelve jurisdictions presented for the comparison of Contingency Reserve percentages. Response: Attached to this memorandum please find an updated table of those jurisdictions showing a column with the adopted FY 06/07 total budget, the adopted FY 06/07 General Fund budget, and the current bond ratings. 2.) Issue: An amount of$100,000 has been budgeted in the General Administration budget for a town-wide development impact fee study as recommended by the Town Council at a previous study session. The attached summary of Council Budget Line Item Changes has been updated to reflect this addition. i/64f/1,_ /-,b/7a Stacey Lemos Finance Director David Andrews Town Manager cc: All Department Heads 1 0) (i2 ,- + * C•0 * iN' '( 1 Q Q Q — RI < Z C Q CO 0 Q CO (0 a) U) O a) Cn >, c U 2 O o \ \ o 0a 0 o Q C) NO - ONo OL _ LUO CU M NN- N- w" NN NNNN- LL C O N i Z i C C Q 0 0 ♦..a 0 E = N 0 .0 LU CO CO — 00 O CO LU 0 0 CO O CO LU N- O CD t O O CO 1 M ti = — C) CO LU N O 00 00 CU CO N O O O M }' N I� lf) N N_ N N- N 'r V" N_ — 0)CO N O ti O O N- O C) CSO t0 L 00 N N- ti N- CO CO CO N C) 00 1.0 CD CDCD c m ti N O N M OO d' N CO v- CD N C N- ca 0 Ce '0 0 0 0 0 0 co O) O O CO O _ 1.0 CO I- N- 1.0 O CO N O O N- h-- = �= l',.. 1.0LU O 00 CO O (Y) LU N N- N- LU O Cv N- N L d- CO CD ,---- N — 00 V' O > N LU O LU O 00 LU Cfl N- N- N 00 CO V CD = d" N O 00 f` O N- t` N- O N = 0 m N O CU N O 00 CU 00 OO N- — O CD N (3) N-- (N = '1- L C N CO N- .� ♦••+ _ U) a. CCS C X CnU) U O O wU) U O U) U) in O L O E ca a) W a) z z a) a) a) Z a) a) a) a) c _ " D CO Na) .i 0• � Li_ 0- ., a) E 0 (.0 0) co co ti NO I'' _ V. N P O }+ O 'l O) CO L C(C. r- }' 0 Ca N- CD O) O C C`) O '� r- L (6 V O • c� McYicfloo � � o_ a -ct- a; � c � °� c — (>6 O O 0 C 2 Oin — N C a � a) c v (1) O 0 (0 .> TD (0 •= ca X o }+ a) a) o t� C� a s 'a Ca > Cl) co me = •8_ O o co O Ca O i 0 0 E di _a i s C.) 0 0 • _ � � L L �^ ♦/= a) = (V c- < 0020a. C♦♦ v/ I— -k -k �i Town of Oro Valley FY 2007/08 Budget Council Line Item Changes Through May 29, 2007 Department/Division Line Item Increase/(Decrease) �f�IN� j'�cFAI N 4 \-Yra*r`."•:.{�..S- �4, -•f,-{S ...v.v{.....,v....v.......v..v..v..fu n...........n.......:..............v.v......:.�....i::..vvv?:.:�::::::?::.i:i:.:.:.:v Recurring Police Department Addition of one (1) Sergeant position $ 92,413 Finance Increase in Sales Tax audit recovery service 12,000 Police Department Reduction of Holiday Pay (35,000) . Increase in Utility Sales Tax revenue (474,000) Facilities Initial cleanup & stabilization of Steam Pump Ranch 26,075 Subtotal Recurring $ (378,512) Non-Recurring Parks & Recreation Management Assessment study $ 50,000 General Administration Funding requests from outside sources 20,000 Heritage Fund grant for dog park at Riverfront Park (25,000) Library 10 Computer Replacements 12,000 IT Computer Replacements transferred to Library (12,000) PCLD Reimbursement for computer replacements (6,000) General Administration Development Impact Fee Study 100,000 Subtotal Non-Recurring $ 139,000 Total Council Adjustments $ (239,512) Contingency Per Manager's Recommended $ 9,449,754 .. Total Council Adjustments 239,512 Contingency Per Tentative Budget $ 9,689,266 HIGHWAY FUND , ,, Recurring Office Lease Increase the rental of modular units $ 8,113 Subtotal Recurring $ 8,113 Non-Recurring Arterial Roadways Overlay of Rancho Vistoso Blvd $ 900,000 PAG Reimbursement (900,000) Buildings & Improvements Increased cost for Municipal site development 160,000 Misc Other Operating Various site development& modular set up costs 57,259 Rental Equipment Rental 15,000 Subtotal Non-Recurring $ 232,259 Total Council Adjustments $ 240,372 Contingency Per Manager's Recommended $ 3,158,439 Total Council Adjustments (240,372) _Contingency Per Tentative Budget $ 2,918,067 8 D TAX EURO' ::..,:?' ..K<v x.1 Non Recurring Naranja Town Site Adoption of 2% allocation $ 758,291 G:\BUDGET\FY 07-08\Council Line Item Changes FY 07_08 5/29/2007 Deparrtment/Division 1 Line Item Increase/(Decrease) Total Council Adjustments $ 758,291 Contingency Per Manager's Recommended $ 1,179,083 Total Council Adjustments (758,291) _Contingency Per Tentative Budget $ 420,792 WATER UTILITY f Non Recurring Wells Increase project costs for Pusch View $ 600,000 Transmission/Distribution Increase project costs for North La Canada 100,000 000 Transmission/Distribution Increase project costs for Big Wash modifications 200,000 Reservoirs Increase project costs for North La Canada 2.2 MG 150,000 Subtotal Non-Recurring $ 1,050,000 Total Council Adjustments $ 1,050,000 Contingency Per Manager's Recommended $ 3,082,718 Total Council Adjustments (1,050,000) _Contingency Per Tentative Budget $ 2,032,718 HONEY BEE DEVELOPMENT Non Recurring Reduce contingency and offsetting revenue source $ (500,000) Total Council Adjustments $ (500,000) Contingency Per Manager's Recommended $ 500,000 Total Council Adjustments (500,000) Contingency Per Tentative Budget $ - G:IBUDGET\FY 07-081Council Line Item Changes FY 07_08 5/29/2007