Loading...
2012.02.13 CC Finance Committee Agenda Packet                 AGENDA EDMONDS CITY COUNCIL FINANCE COMMITTEE City Hall - Fourtner Room 121 5th Ave. North, Edmonds MONDAY, FEBRUARY 13, 2012 3:00 P.M.                 1. (15 Minutes) AM-4564 Discussion regarding Human Resources temporary staffing proposal.   2. (10 Minutes) AM-4560 General Fund Update - December 2011 (unaudited)   3. (15 Minutes) AM-4561 Discussion regarding Budgeting by Priorities.   4. (15 Minutes) AM-4562 Discussion regarding updates to various policies.   5. (15 Minutes) AM-4563 Discussion regarding financial statements.   6. (10 Minutes)Public Comments (3-minute limit per person)   7.ADJOURN   Packet Page 1 of 14 AM-4564   Item #: 1. City Council Finance Committee Meeting Date: 02/13/2012 Time:15 Minutes   Submitted For:Dave Earling Submitted By:Carolyn LaFave Department:Mayor's Office Committee:Finance Type:Action Information Subject Title Discussion regarding Human Resources temporary staffing proposal. Recommendation from Mayor and Staff Council approve proposal for additional expenditure authority to sufficiently cover the duties of the Human Resources Department as per discussions with the Mayor. Previous Council Action Narrative Attached is a proposal to cover the duties and responsibilities for the Human Resources department on a temporary basis. This proposal includes several components that will allow us to operate status quo, until such time as a permanent reorganization can be considered. This proposal includes retaining the Parks, Recreation, and Cultural Services Director in an oversight capacity, and the HR analyst in an Acting Manager capacity. These two positions have been compensated for these additional duties in an " acting " capacity since September 22, 2011. In addition to these positions, this proposal adds a temporary file clerk for 10 hours per week, and a temporary HR assistant for 20 hours per week. Also included in this proposal is compensation for Ms. Tara Adams to complete Police Negotiations and two special projects she has been coordinating. We currently have an ordinance that was adopted last year by Council that allows for " acting " pay to be granted for a limited time of six months. Because of the unusual circumstances, I would also like to request that Council reconsider this policy to allow for the Mayor to approve " acting" pay for the length of time that is needed to reorganize operations.  Attachments HR Proposal Form Review Inbox Reviewed By Date Final Approval Sandy Chase 02/09/2012 03:25 PM Form Started By: Carolyn LaFave Started On: 02/09/2012 02:48 PM Final Approval Date: 02/09/2012  Packet Page 2 of 14 Packet Page 3 of 14 AM-4560   Item #: 2. City Council Finance Committee Meeting Date: 02/13/2012 Time:10 Minutes   Submitted For:Shawn Hunstock Submitted By:Shawn Hunstock Department:Finance Committee:Finance Type:Information Information Subject Title General Fund Update - December 2011 (unaudited) Recommendation from Mayor and Staff Informational purposes only. Previous Council Action N/A Narrative General Fund update for the month of December 2011. Amounts shown do not include any adjustments that could take place over the next few months as part of the annual financial statement audit by the State Auditor's Office. Attachments GF Update December 2011 Form Review Inbox Reviewed By Date City Clerk Sandy Chase 02/09/2012 10:36 AM Mayor Dave Earling 02/09/2012 12:21 PM Final Approval Sandy Chase 02/09/2012 01:35 PM Form Started By: Shawn Hunstock Started On: 02/09/2012  Final Approval Date: 02/09/2012  Packet Page 4 of 14 i CITY OF EDMONDS GENERAL FUND UPDATE DECEMBER, 2011 (UNAUDITED) Overview The attached report provides the following information regarding the General Fund: - 2011 revised annual budget of revenue and expenditures - January 2011 through December 2011 actual revenues and expenditures - The variance in dollars between budget and actual results - Actual compared to budget expressed as a percentage. December represents 100% of the year (12 months divided by 12 months). Discussed below are the revenues and expenditures where there is a material variance from actual to budget: Revenues: - Property Taxes - are collected twice a year (May & November). The December receipts were collected in the current month. In total, for regular property taxes, EMS levy and the voter-approved bond levy, property taxes ended the year 1.3% under budget ($172,588). - Telephone Utility Tax - Since Feb 2011 actuals have been below budget. We ended the year with receipts of $1,367,782, which is 13% below the budgeted amount of $1,563,000. See attached chart for further details. The budget for this line item was decreased for 2012 to $1,390,242. - Licenses & Permits - actuals in excess of budget relate to the franchise agreements of approximately $100,000 from Blackrock and Verizon not budgeted in 2011. We are also expecting to be over budget in Building Permit revenue by approximately 5% by year end, not including the franchise payments. - Intergovernmental - In the last couple months we received yearly PUD Privilege tax revenue of $181,000 and quarterly Liquor Profits of $56,000. We also have approximately $90,000 of unbudgeted intergovernmental billings with Fire District #1. These billings relate to utilities the City pays for fire stations and is reimbursed by the Fire District. Year-end receipts were $1,041,806, which is 12% above the budgeted amount of $927,139. - Charges for Goods & Services - actuals in excess to budget relate to Inter-fund reimbursement of the General Fund, EMS Transport Fees, Park & Rec Program Fees and Plan Check Fees. Year-end receipts were $4,011,025 which was 10% above the budgeted amount of $3,637,480. Expenditures: - Salaries & Benefits – actuals below budget due to open positions from 2011 retirements and resignations as well as 2011 budgeted but unfilled positions. - Supplies – actuals below budget across most City departments. - Intergovernmental – actuals below budget by 1% due to minor differences between budgeted and actual payments. - Debt Service – the payments are consistent with budgeted amounts for principal and interest payments due. Packet Page 5 of 14 2011 Revised Annual Budget YTD Actuals Variance % Rec/Exp BEGINNING FUND BALANCE 6,855,108 6,855,108 - REVENUES: REAL PERSONAL / PROPERTY TAX 9,506,114 9,208,655 297,459 97% EMS PROPERTY TAX 3,233,038 3,403,388 (170,350) 105% VOTED PROPERTY TAX 877,984 832,505 45,479 95% LOCAL RETAIL SALES/USE TAX 4,524,195 4,618,011 (93,816) 102% NATURAL GAS USE TAX 16,667 11,605 5,062 70% 1/10 SALES TAX LOCAL CRIM JUST 530,130 513,541 16,589 97% GAS UTILITY TAX 890,000 876,598 13,402 98% T.V. CABLE UTILITY TAX 698,865 720,293 (21,428) 103% TELEPHONE UTILITY TAX 1,563,454 1,367,782 195,672 87% ELECTRIC UTILITY TAX 1,532,043 1,464,826 67,217 96% SOLID WASTE UTILITY TAX 285,918 301,641 (15,723) 105% WATER UTILITY TAX 764,082 792,639 (28,557) 104% SEWER UTILITY TAX 470,000 468,078 1,922 100% STORMWATER UTILITY TAX 237,600 244,628 (7,028) 103% LEASEHOLD EXCISE TAX 250,938 218,038 32,900 87% PULLTABS TAX 61,043 62,123 (1,080) 102% LICENSES AND PERMITS 1,484,829 1,685,226 (200,397) 113% INTERGOVERNMENTAL 927,139 1,041,806 (114,667) 112% CHARGES FOR GOODS AND SERVICES 3,637,480 4,011,025 (373,545) 110% FINES AND FORFEITURES 667,100 690,079 (22,979) 103% MISCELLANEOUS 339,073 384,581 (45,508) 113% INTERFUND TRANSFERS 35,349 25,086 10,263 71% 32,533,041 32,942,155 (409,114) 101% EXPENDITURES: SALARIES / WAGES 12,780,202 12,429,499 350,703 97% BENEFITS 4,338,586 4,148,169 190,417 96% SUPPLIES 533,562 474,292 59,270 89% SERVICES 4,034,808 3,832,003 202,805 95% INTERGOVERNMENTAL 9,029,698 8,903,031 126,667 99% CAPITAL OUTLAY - - - 0% DEBT SERVICE PRINCIPAL 1,111,369 1,094,128 17,241 98% DEBT SERVICE INTEREST 340,759 339,649 1,110 100% INTERFUND SERVICES 1,101,678 972,865 128,813 88% 33,270,662 32,193,636 1,077,026 97% CHANGE IN FUND BALANCE (YTD)(737,621) 748,519 (1,486,140) ENDING FUND BALANCE 6,117,487 7,603,627 (1,486,140) Page 1 of 6 City of Edmonds General Fund Update December 2011 (Unaudited) Packet Page 6 of 14 20 1 0 O U T L O O K 55 2 , 6 5 3 20 1 1 B U D G E T 7 0 0 , 0 0 0 TOTAL JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C Mo n t h l y F o r e c a s t % 8 % 5 % 7 % 8 % 8 % 1 0 % 9 % 1 1 % 1 0 % 1 0 % 8 % 7 % Cu m u l a t i v e F o r e c a s t % 8 % 1 3 % 1 9 % 2 8 % 3 6 % 4 6 % 5 5 % 6 6 % 7 6 % 8 6 % 9 3 % 1 0 0 % Mo n t h l y F o r e c a s t $ 5 4 , 5 0 9 3 5 , 4 1 5 4 5 , 8 5 4 5 8 , 5 4 8 5 5 , 9 7 5 7 1 , 3 6 3 6 5 , 1 3 8 7 5 , 8 8 2 6 7 , 5 2 5 6 8 , 7 2 6 5 4 , 7 9 8 46,268 Cu m u l a t i v e F o r e c a s t $ 5 4 , 5 0 9 8 9 , 9 2 3 1 3 5 , 7 7 7 1 9 4 , 3 2 5 2 5 0 , 3 0 0 3 2 1 , 6 6 3 3 8 6 , 8 0 1 4 6 2 , 6 8 3 5 3 0 , 2 0 8 5 9 8 , 9 3 4 6 5 3 , 7 3 2 700,000 Ac t u a l C o l l e c t e d $ 6 4 , 4 5 0 2 6 , 9 9 2 3 0 , 9 6 9 6 1 , 1 9 3 5 1 , 9 6 4 3 6 , 9 2 1 5 1 , 9 3 8 4 3 , 2 9 4 5 2 , 8 8 6 5 1 , 2 3 2 3 4 , 8 9 6 45,918 Cu m u l a t i v e C o l l e c t i o n $ 6 4 , 4 5 0 9 1 , 4 4 2 1 2 2 , 4 1 1 1 8 3 , 6 0 4 2 3 5 , 5 6 8 2 7 2 , 4 8 9 3 2 4 , 4 2 7 3 6 7 , 7 2 1 4 2 0 , 6 0 7 4 7 1 , 8 3 9 5 0 6 , 7 3 5 552,653 YE A R E N D F O R E C A S T 8 2 7 , 6 6 7 7 1 1 , 8 2 2 6 3 1 , 0 9 0 6 6 1 , 3 8 0 6 5 8 , 7 9 9 5 9 2 , 9 8 8 5 8 7 , 1 2 1 5 5 6 , 3 3 0 5 5 5 , 3 0 1 5 5 1 , 4 5 9 5 4 2 , 6 0 0 552,653 Pr o j e c t e d Y E V a r i a n c e 1 2 7 , 6 6 7 1 1 , 8 2 2 ( 6 8 , 9 1 0 ) ( 3 8 , 6 2 0 ) ( 4 1 , 2 0 1 ) ( 1 0 7 , 0 1 2 ) ( 1 1 2 , 8 7 9 ) ( 1 4 3 , 6 7 0 ) ( 1 4 4 , 6 9 9 ) ( 1 4 8 , 5 4 1 ) ( 1 5 7 , 4 0 0 ) (147,347) Bu d g e t V a r i a n c e % 1 8 % 2 % - 1 0 % - 6 % - 6 % - 1 5 % - 1 6 % - 2 1 % - 2 1 % - 2 1 % - 2 2 % - 2 1 % Ci t y o f E d m o n d s 20 1 1 M o n t h l y R e v e n u e F o r e c a s t i n g M o d e l RE A L E S T A T E E X C I S E T A X - 2 0 0 , 0 0 0 4 0 0 , 0 0 0 6 0 0 , 0 0 0 8 0 0 , 0 0 0 JA N FE B MA R AP R MA Y JU N JU L AU G SE P OC T NO V DEC 20 1 1 C U M U L A T I V E CO L L E C T I O N S Ac t u a l s / T r e n d Bu d g e t R: \ F i n a n c e C o m m i t t e e \ 2 0 1 1 \ M o n t h l y R e p o r t s \ G F R e p o r t 1 2 . 2 0 1 1 1 1 C H A R T S Pa g e 2 o f 6 2/9/2012 10:11 AM Pa c k e t Pa g e 7 of 14 20 1 1 O U T L O O K 4, 6 1 8 , 0 1 1 20 1 1 B U D G E T 4 , 5 2 4 , 1 9 5 TOTAL JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C Mo n t h l y F o r e c a s t % 8 % 1 0 % 7 % 8 % 9 % 8 % 8 % 9 % 8 % 8 % 9 % 8 % Cu m u l a t i v e F o r e c a s t % 8 % 1 8 % 2 5 % 3 3 % 4 1 % 4 9 % 5 7 % 6 6 % 7 5 % 8 3 % 9 2 % 1 0 0 % Mo n t h l y F o r e c a s t $ 3 6 1 , 1 3 8 4 5 8 , 8 5 6 3 2 0 , 3 0 7 3 3 9 , 6 1 5 3 9 2 , 1 8 8 3 5 1 , 8 8 1 3 5 3 , 1 3 9 4 2 2 , 2 0 1 3 7 6 , 0 2 1 3 7 8 , 9 3 0 4 2 1 , 8 8 4 348,035 Cu m u l a t i v e F o r e c a s t $ 3 6 1 , 1 3 8 8 1 9 , 9 9 4 1 , 1 4 0 , 3 0 2 1 , 4 7 9 , 9 1 6 1 , 8 7 2 , 1 0 4 2 , 2 2 3 , 9 8 5 2 , 5 7 7 , 1 2 4 2 , 9 9 9 , 3 2 5 3 , 3 7 5 , 3 4 5 3 , 7 5 4 , 2 7 6 4 , 1 7 6 , 1 6 0 4,524,195 Ac t u a l C o l l e c t e d $ 3 5 8 , 4 1 5 4 4 9 , 7 9 1 3 4 4 , 7 1 3 3 2 5 , 2 7 9 4 2 4 , 5 6 7 3 6 5 , 3 8 1 3 7 5 , 9 8 2 4 1 1 , 3 9 2 3 5 2 , 6 8 1 3 8 7 , 6 9 3 4 2 2 , 0 8 5 400,033 Cu m u l a t i v e C o l l e c t i o n $ 3 5 8 , 4 1 5 8 0 8 , 2 0 5 1 , 1 5 2 , 9 1 8 1 , 4 7 8 , 1 9 7 1 , 9 0 2 , 7 6 4 2 , 2 6 8 , 1 4 5 2 , 6 4 4 , 1 2 7 3 , 0 5 5 , 5 1 9 3 , 4 0 8 , 2 0 0 3 , 7 9 5 , 8 9 3 4 , 2 1 7 , 9 7 7 4,618,011 YE A R E N D F O R E C A S T 4 , 4 9 0 , 0 7 5 4 , 4 5 9 , 1 5 0 4 , 5 7 4 , 2 5 1 4 , 5 1 8 , 9 3 9 4 , 5 9 8 , 2 8 9 4 , 6 1 4 , 0 2 9 4 , 6 4 1 , 8 2 0 4 , 6 0 8 , 9 5 9 4 , 5 6 8 , 2 3 2 4 , 5 7 4 , 3 4 7 4 , 5 6 9 , 4 9 8 4,618,011 Pr o j e c t e d Y E V a r i a n c e ( 3 4 , 1 2 0 ) ( 6 5 , 0 4 5 ) 5 0 , 0 5 6 ( 5 , 2 5 6 ) 7 4 , 0 9 4 8 9 , 8 3 4 1 1 7 , 6 2 5 8 4 , 7 6 4 4 4 , 0 3 7 5 0 , 1 5 2 4 5 , 3 0 3 93,816 Bu d g e t V a r i a n c e % -1 % -1 % 1% 0% 2% 2% 3% 2% 1% 1%1%2% Ci t y o f E d m o n d s 20 1 1 M o n t h l y R e v e n u e F o r e c a s t i n g M o d e l SA L E S A N D U S E T A X - 5 0 0 , 0 0 0 1 , 0 0 0 , 0 0 0 1 , 5 0 0 , 0 0 0 2 , 0 0 0 , 0 0 0 2 , 5 0 0 , 0 0 0 3 , 0 0 0 , 0 0 0 3 , 5 0 0 , 0 0 0 4 , 0 0 0 , 0 0 0 4 , 5 0 0 , 0 0 0 5 , 0 0 0 , 0 0 0 JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C 20 1 1 C U M U L A T I V E CO L L E C T I O N S Ac t u a l s / T r e n d Bu d g e t R: \ F i n a n c e C o m m i t t e e \ 2 0 1 1 \ M o n t h l y R e p o r t s \ G F R e p o r t 1 2 . 2 0 1 1 1 1 C H A R T S Pa g e 3 o f 6 2/9/2012 10:11 AM Pa c k e t Pa g e 8 of 14 20 1 1 O U T L O O K 87 6 , 5 9 8 20 1 1 B U D G E T 8 9 0 , 0 0 0 TOTAL JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C Mo n t h l y F o r e c a s t % 1 4 % 1 5 % 1 3 % 1 1 % 9 % 7 % 5 % 4 % 3 % 4 % 6 % 9 % Cu m u l a t i v e F o r e c a s t % 1 4 % 2 9 % 4 2 % 5 3 % 6 2 % 6 9 % 7 5 % 7 8 % 8 1 % 8 5 % 9 1 % 1 0 0 % Mo n t h l y F o r e c a s t $ 1 2 4 , 2 9 7 1 3 1 , 6 4 5 1 1 9 , 1 9 6 9 7 , 0 6 9 8 2 , 9 4 5 6 2 , 2 6 2 4 5 , 7 2 8 3 2 , 2 5 1 2 9 , 9 3 0 3 2 , 6 3 7 5 5 , 8 2 5 76,215 Cu m u l a t i v e F o r e c a s t $ 1 2 4 , 2 9 7 2 5 5 , 9 4 2 3 7 5 , 1 3 8 4 7 2 , 2 0 7 5 5 5 , 1 5 2 6 1 7 , 4 1 3 6 6 3 , 1 4 1 6 9 5 , 3 9 2 7 2 5 , 3 2 2 7 5 7 , 9 6 0 8 1 3 , 7 8 5 890,000 Ac t u a l C o l l e c t e d $ 1 1 8 , 2 1 6 1 1 9 , 2 7 9 1 1 1 , 0 7 6 1 0 3 , 9 8 8 8 3 , 7 2 8 6 2 , 6 5 9 4 5 , 2 0 7 3 2 , 7 9 1 3 0 , 3 0 7 2 9 , 2 4 3 4 8 , 3 8 9 91,714 Cu m u l a t i v e C o l l e c t i o n $ 1 1 8 , 2 1 6 2 3 7 , 4 9 5 3 4 8 , 5 7 1 4 5 2 , 5 5 9 5 3 6 , 2 8 7 5 9 8 , 9 4 6 6 4 4 , 1 5 3 6 7 6 , 9 4 4 7 0 7 , 2 5 1 7 3 6 , 4 9 5 7 8 4 , 8 8 4 876,598 YE A R E N D F O R E C A S T 8 4 6 , 4 6 0 8 2 5 , 8 5 4 8 2 6 , 9 7 1 8 5 2 , 9 6 8 8 5 9 , 7 5 7 8 6 3 , 3 7 9 8 6 4 , 5 1 6 8 6 6 , 3 8 9 8 6 7 , 8 2 6 8 6 4 , 7 9 5 8 5 8 , 3 9 2 876,598 Pr o j e c t e d Y E V a r i a n c e ( 4 3 , 5 4 0 ) ( 6 4 , 1 4 6 ) ( 6 3 , 0 2 9 ) ( 3 7 , 0 3 2 ) ( 3 0 , 2 4 3 ) ( 2 6 , 6 2 1 ) ( 2 5 , 4 8 4 ) ( 2 3 , 6 1 1 ) ( 2 2 , 1 7 4 ) ( 2 5 , 2 0 5 ) ( 3 1 , 6 0 8 ) (13,402) Bu d g e t V a r i a n c e % - 5 % - 7 % - 7 % - 4 % - 3 % - 3 % - 3 % - 3 % - 2 % - 3 % - 4 % - 2 % Ci t y o f E d m o n d s 20 1 1 M o n t h l y R e v e n u e F o r e c a s t i n g M o d e l GA S U T I L I T Y T A X - 2 0 0 , 0 0 0 4 0 0 , 0 0 0 6 0 0 , 0 0 0 8 0 0 , 0 0 0 1 , 0 0 0 , 0 0 0 JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C 20 1 1 C U M U L A T I V E CO L L E C T I O N S Ac t u a l s / T r e n d Bu d g e t R: \ F i n a n c e C o m m i t t e e \ 2 0 1 1 \ M o n t h l y R e p o r t s \ G F R e p o r t 1 2 . 2 0 1 1 1 1 C H A R T S Pa g e 4 o f 6 2/9/2012 10:11 AM Pa c k e t Pa g e 9 of 14 20 1 1 O U T L O O K 1, 3 6 7 , 7 8 3 20 1 1 B U D G E T 1 , 5 6 3 , 4 5 4 TOTAL JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C Mo n t h l y F o r e c a s t % 6 % 1 0 % 1 0 % 6 % 9 % 7 % 1 0 % 9 % 6 % 1 1 % 6 % 1 3 % Cu m u l a t i v e F o r e c a s t % 6 % 1 5 % 2 5 % 3 1 % 4 0 % 4 6 % 5 6 % 6 5 % 7 1 % 8 2 % 8 7 % 1 0 0 % Mo n t h l y F o r e c a s t $ 8 8 , 1 0 5 1 4 8 , 9 7 1 1 4 9 , 5 0 1 9 8 , 5 6 0 1 3 4 , 1 5 4 1 0 1 , 8 3 2 1 4 9 , 2 0 0 1 3 9 , 7 7 7 9 7 , 1 7 8 1 7 3 , 1 5 3 8 6 , 9 0 0 196,123 Cu m u l a t i v e F o r e c a s t $ 8 8 , 1 0 5 2 3 7 , 0 7 6 3 8 6 , 5 7 6 4 8 5 , 1 3 6 6 1 9 , 2 9 1 7 2 1 , 1 2 3 8 7 0 , 3 2 3 1 , 0 1 0 , 1 0 0 1 , 1 0 7 , 2 7 8 1 , 2 8 0 , 4 3 1 1 , 3 6 7 , 3 3 1 1,563,454 Ac t u a l C o l l e c t e d $ 1 1 9 , 0 4 6 7 6 , 8 4 0 1 3 4 , 7 6 4 1 1 3 , 6 9 8 1 1 0 , 4 9 8 1 1 0 , 7 4 7 1 0 7 , 1 5 7 1 1 6 , 5 5 1 1 1 8 , 8 8 7 1 3 0 , 5 6 1 1 1 2 , 3 9 0 116,645 Cu m u l a t i v e C o l l e c t i o n $ 1 1 9 , 0 4 6 1 9 5 , 8 8 6 3 3 0 , 6 4 9 4 4 4 , 3 4 7 5 5 4 , 8 4 5 6 6 5 , 5 9 2 7 7 2 , 7 4 9 8 8 9 , 3 0 0 1 , 0 0 8 , 1 8 7 1 , 1 3 8 , 7 4 8 1 , 2 5 1 , 1 3 8 1,367,783 YE A R E N D F O R E C A S T 2 , 1 1 2 , 5 1 4 1 , 2 9 1 , 8 1 6 1 , 3 3 7 , 2 6 6 1 , 4 3 2 , 0 0 2 1 , 4 0 0 , 7 5 6 1 , 4 4 3 , 0 5 9 1 , 3 8 8 , 1 7 1 1 , 3 7 6 , 4 7 7 1 , 4 2 3 , 5 3 9 1 , 3 9 0 , 4 5 4 1 , 4 3 0 , 5 9 5 1,367,783 Pr o j e c t e d Y E V a r i a n c e 5 4 9 , 0 6 0 ( 2 7 1 , 6 3 8 ) ( 2 2 6 , 1 8 8 ) ( 1 3 1 , 4 5 2 ) ( 1 6 2 , 6 9 8 ) ( 1 2 0 , 3 9 5 ) ( 1 7 5 , 2 8 3 ) ( 1 8 6 , 9 7 7 ) ( 1 3 9 , 9 1 5 ) ( 1 7 3 , 0 0 0 ) ( 1 3 2 , 8 5 9 ) (195,671) Bu d g e t V a r i a n c e % 3 5 % - 1 7 % - 1 4 % - 8 % - 1 0 % - 8 % - 1 1 % - 1 2 % - 9 % - 1 1 % - 8 % - 1 3 % Ci t y o f E d m o n d s 20 1 1 M o n t h l y R e v e n u e F o r e c a s t i n g M o d e l TE L E P H O N E U T I L I T Y T A X - 2 5 0 , 0 0 0 5 0 0 , 0 0 0 7 5 0 , 0 0 0 1 , 0 0 0 , 0 0 0 1 , 2 5 0 , 0 0 0 1 , 5 0 0 , 0 0 0 1 , 7 5 0 , 0 0 0 2 , 0 0 0 , 0 0 0 JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C 20 1 1 C U M U L A T I V E CO L L E C T I O N S Ac t u a l s / T r e n d Bu d g e t R: \ F i n a n c e C o m m i t t e e \ 2 0 1 1 \ M o n t h l y R e p o r t s \ G F R e p o r t 1 2 . 2 0 1 1 1 1 C H A R T S Pa g e 5 o f 6 2/9/2012 10:11 AM Pa c k e t Pa g e 10 of 14 20 1 1 O U T L O O K 1, 4 6 4 , 8 2 6 20 1 1 B U D G E T 1 , 5 3 2 , 0 4 3 TOTAL JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C Mo n t h l y F o r e c a s t % 1 0 % 1 2 % 1 1 % 1 1 % 9 % 8 % 7 % 6 % 7 % 6 % 7 % 7 % Cu m u l a t i v e F o r e c a s t % 1 0 % 2 2 % 3 2 % 4 3 % 5 2 % 6 0 % 6 7 % 7 3 % 8 0 % 8 6 % 9 3 % 1 0 0 % Mo n t h l y F o r e c a s t $ 1 5 4 , 3 4 4 1 8 0 , 8 6 5 1 6 1 , 0 3 9 1 6 1 , 3 9 7 1 4 2 , 2 0 7 1 1 6 , 7 9 8 1 1 0 , 5 9 7 9 6 , 9 3 1 1 0 1 , 3 8 1 8 8 , 7 7 9 1 1 2 , 4 7 4 105,231 Cu m u l a t i v e F o r e c a s t $ 1 5 4 , 3 4 4 3 3 5 , 2 0 9 4 9 6 , 2 4 8 6 5 7 , 6 4 5 7 9 9 , 8 5 2 9 1 6 , 6 5 1 1 , 0 2 7 , 2 4 7 1 , 1 2 4 , 1 7 8 1 , 2 2 5 , 5 5 9 1 , 3 1 4 , 3 3 8 1 , 4 2 6 , 8 1 2 1,532,043 Ac t u a l C o l l e c t e d $ 1 6 3 , 7 7 0 1 4 2 , 7 4 3 1 5 1 , 1 9 7 1 6 2 , 8 2 2 1 4 0 , 8 8 7 1 1 3 , 7 1 5 1 0 7 , 5 7 9 8 8 , 0 7 8 1 0 1 , 1 3 3 8 4 , 0 6 8 1 0 1 , 2 6 9 107,563 Cu m u l a t i v e C o l l e c t i o n $ 1 6 3 , 7 7 0 3 0 6 , 5 1 4 4 5 7 , 7 1 1 6 2 0 , 5 3 3 7 6 1 , 4 2 0 8 7 5 , 1 3 5 9 8 2 , 7 1 4 1 , 0 7 0 , 7 9 2 1 , 1 7 1 , 9 2 5 1 , 2 5 5 , 9 9 3 1 , 3 5 7 , 2 6 3 1,464,826 YE A R E N D F O R E C A S T 1 , 6 2 5 , 6 1 2 1 , 4 0 0 , 8 9 5 1 , 4 1 3 , 0 6 9 1 , 4 4 5 , 5 8 7 1 , 4 5 8 , 4 3 0 1 , 4 6 2 , 6 5 6 1 , 4 6 5 , 6 2 6 1 , 4 5 9 , 2 8 7 1 , 4 6 4 , 9 9 6 1 , 4 6 4 , 0 3 4 1 , 4 5 7 , 3 6 4 1,464,826 Pr o j e c t e d Y E V a r i a n c e 9 3 , 5 6 9 ( 1 3 1 , 1 4 8 ) ( 1 1 8 , 9 7 4 ) ( 8 6 , 4 5 6 ) ( 7 3 , 6 1 3 ) ( 6 9 , 3 8 7 ) ( 6 6 , 4 1 7 ) ( 7 2 , 7 5 6 ) ( 6 7 , 0 4 7 ) ( 6 8 , 0 0 9 ) ( 7 4 , 6 7 9 ) (67,217) Bu d g e t V a r i a n c e % 6 % - 9 % - 8 % - 6 % - 5 % - 5 % - 4 % - 5 % - 4 % - 4 % - 5 % - 4 % Ci t y o f E d m o n d s 20 1 1 M o n t h l y R e v e n u e F o r e c a s t i n g M o d e l EL E C T R I C U T I L I T Y T A X - 2 5 0 , 0 0 0 5 0 0 , 0 0 0 7 5 0 , 0 0 0 1 , 0 0 0 , 0 0 0 1 , 2 5 0 , 0 0 0 1 , 5 0 0 , 0 0 0 1 , 7 5 0 , 0 0 0 JA N F E B M A R A P R M A Y J U N J U L A U G S E P O C T N O V D E C 20 1 1 C U M U L A T I V E CO L L E C T I O N S Ac t u a l s / T r e n d Bu d g e t R: \ F i n a n c e C o m m i t t e e \ 2 0 1 1 \ M o n t h l y R e p o r t s \ G F R e p o r t 1 2 . 2 0 1 1 1 1 C H A R T S Pa g e 6 o f 6 2/9/2012 10:11 AM Pa c k e t Pa g e 11 of 14 AM-4561   Item #: 3. City Council Finance Committee Meeting Date: 02/13/2012 Time:15 Minutes   Submitted For:Shawn Hunstock Submitted By:Shawn Hunstock Department:Finance Review Committee: Finance Committee Action: Type:Information  Information Subject Title Discussion regarding Budgeting by Priorities. Recommendation from Mayor and Staff N.A. Informational purposes only. Previous Council Action N.A. Narrative Committee members will review information presented at the City Council Retreat as well as the presentation by Mike Bailey, Finance Director for the City of Redmond, at a meeting of the Puget Sound Finance Officers Association on February 8, 2012. Form Review Inbox Reviewed By Date City Clerk Sandy Chase 02/09/2012 10:41 AM Mayor Dave Earling 02/09/2012 12:12 PM Final Approval Sandy Chase 02/09/2012 01:35 PM Form Started By: Shawn Hunstock Started On: 02/09/2012 10:37 AM Final Approval Date: 02/09/2012  Packet Page 12 of 14 AM-4562   Item #: 4. City Council Finance Committee Meeting Date: 02/13/2012 Time:15 Minutes   Submitted For:Shawn Hunstock Submitted By:Shawn Hunstock Department:Finance Review Committee: Finance Committee Action: Type:Information  Information Subject Title Discussion regarding updates to various policies. Recommendation from Mayor and Staff N.A. Informational purposes only. Previous Council Action N.A. Narrative Committee members will discuss the status, timing and priority for updates to various City financial policies. Form Review Inbox Reviewed By Date City Clerk Sandy Chase 02/09/2012 10:43 AM Mayor Dave Earling 02/09/2012 12:11 PM Final Approval Sandy Chase 02/09/2012 01:35 PM Form Started By: Shawn Hunstock Started On: 02/09/2012 10:41 AM Final Approval Date: 02/09/2012  Packet Page 13 of 14 AM-4563   Item #: 5. City Council Finance Committee Meeting Date: 02/13/2012 Time:15 Minutes   Submitted For:Shawn Hunstock Submitted By:Shawn Hunstock Department:Finance Review Committee: Finance Committee Action: Type:Information  Information Subject Title Discussion regarding financial statements. Recommendation from Mayor and Staff N.A. Informational purposes only. Previous Council Action N.A. Narrative Committee members will discuss various financial statements, current and proposed new ones, to be made available to the public on the City's website. Timing, content and format of the information will be discussed. Form Review Inbox Reviewed By Date City Clerk Sandy Chase 02/09/2012 10:46 AM Mayor Dave Earling 02/09/2012 12:09 PM Final Approval Sandy Chase 02/09/2012 01:35 PM Form Started By: Shawn Hunstock Started On: 02/09/2012 10:43 AM Final Approval Date: 02/09/2012  Packet Page 14 of 14