Spreadsheet: 158dcaf3-d4a8-4c40-944d-f2083a2c8688
Sheet: ALLOCATION

12/13
SAP
FUND NO. |  | OPERATING BUREAUS/FUNDS
 |  |  |  |  | NUMBER OF EMPLOYEES |  |  |  |  |  | ADJUSTED BUDGET SIZE
 |  |  | FY 09/10 | FY 10/11 | FY 2012 No. | FY 11/12 | THREE YEAR |  | FY 09/10 | FY 10/11 | FY 2012 Adj |  | THREE YEAR |  | BLENDED
 |  |  | % | % | of Employees | % | AVERAGE | 0.25 | % | % | Actual Expend. |  | AVERAGE | 0.75 | FACTOR
100000 | PL | Portland Police Bureau | 0.1950993989828941 | 0.1871582565224184 | 1207 |  |  |  | 157297509 | 129573833.81
214000 |  | Campaign Finance | 0 | 0 | 0 |  |  |  | 0 | 0
100000 | FR | Portland Fire &    Rescue | 0.1112652180613346 | 0.119512576159975 | 750 |  |  |  | 92615296 | 85346906.80499999
100000 | PK | Portland Parks &    Recreation | 0.1701340730466944 | 0.1687236369317294 | 974 |  |  |  | 60130076 | 51967978.93500002
600000 |  | Sewer System Op | 0.07397133610725844 | 0.08467426964536791 | 534 |  |  |  | 99640069 | 163300319.7399999
608000 |  | Envtl Remediation | 0.008321775312066574 | 0.0009373535385096079 | 3 |  |  |  | 5556186 | 2744587.649999999
605000 |  | [NAME] | 0.003390352904916012 | 0.004218090923293235 | 32 |  |  |  | 5397170 | 3106227.08
200000 |  | Transportation Op | 0.1112652180613346 | 0.1124824246211529 | 718 |  |  |  | 180216986 | 147219764.6799999
212000 |  | Transportation Resv | 0 | 0 | 0 |  |  |  | 0 | 0
614000 |  | Sewer System Constr | 0 | 0 | 0 |  |  |  | 111275102 | 0
609000 |  | Sewer Sys Debt Rdmpt | 0 | 0 | 0 |  |  |  | 75647150 | 0
602000 |  | Water | 0.09754969949144707 | 0.09670364005624121 | 595 |  |  |  | 76779020 | 79748480.925
615000 |  | Water Construction | 0 | 0 | 0 |  |  |  | 36338000 | 0
612000 |  | Water Bond Sinking | 0 | 0 | 0 |  |  |  | 14153186 | 0
607000 |  | Spectator Fac Op | 0 | 0 | 0 |  |  |  | 10184872 | 6818850.4
617000 |  | Sewer Sys Rate Stblt | 0 | 0 | 0 |  |  |  | 0 | 0
619000 |  | Sewer Sys Safety Net | 0 | 0 | 0 |  |  |  | 0 | 0
620000 |  | Sewer Revolving Loan | 0 | 0 | 0 |  |  |  | 0 | 0
802000 |  | F&P Suppl Retir Rsrv | 0 | 0 | 0 |  |  |  | 0 | 0
800000 |  | FPDR | 0.002619818153798736 | 0.002812060615528824 | 18 |  |  |  | 1944461 | 1960776.439999998
801000 |  | FPDR Reserve | 0 | 0 | 0 |  |  |  | 0 | 0
211000 |  | Spec Fin & Resource | 0 | 0 | 0 |  |  |  | 0 | 0
217000 |  | Grants | 0 | 0 | 0 |  |  |  | 0 | 0
853000 |  | PDC Accounts | 0 | 0 | 0 |  |  |  | 3475126 | 4039959.38
204000 |  | Property [NAME] | 0 | 0 | 0 |  |  |  | 4370400 | 4838737.1
201000 |  | Assessmnt Collection | 0 | 0 | 0 |  |  |  | 1321 | 0
209000 |  | Convention & Tourism | 0 | 0 | 0 |  |  |  | 1620077 | 1520390.49
215000 |  | Parks Local Opt Levy | 0 | 0 | 0 |  |  |  | 480476 | 210377.5
216000 |  | Children Investment | 0 | 0 | 0 |  |  |  | 8116886 | 7390892.715
403000 |  | Public Safety GO Bond Construction | 0 | 0 | 0 |  |  |  | 0 | 2145481.52
316000 |  | [NAME] | 0 | 0 | 0 |  |  |  | 437844 | 0
301000 |  | River Dist URA DR | 0 | 0 | 0 |  |  |  | 15144774 | 0
302000 |  | Bonded Dbt Int&Sinkg | 0 | 0 | 0 |  |  |  | 4231105 | 0
303000 |  | DTWF Renwl Bd Sink | 0 | 0 | 0 |  |  |  | 5098081 | 0
305000 |  | Pension Debt Rdmpt | 0 | 0 | 0 |  |  |  | 1630796 | 0
306000 |  | SO Park Block Rdmpt | 0 | 0 | 0 |  |  |  | 3592858 | 0
310000 |  | [NAME] | 0 | 0 | 0 |  |  |  | 3680482 | 0
307000 |  | Airport Way Dbt Srvc | 0 | 0 | 0 |  |  |  | 2793850 | 0
312000 |  | Convention Cntr ADS | 0 | 0 | 0 |  |  |  | 6378010 | 0
309000 |  | [NAME] URA DR | 0 | 0 | 0 |  |  |  | 5167503 | 0
313000 |  | N Macadam URA DR | 0 | 0 | 0 |  |  |  | 7771296 | 0
314000 |  | Special Prjt Dbt Svc | 0 | 0 | 0 |  |  |  | 3224922 | 0
315000 |  | Gateway URA DR | 0 | 0 | 0 |  |  |  | 1683325 | 0
213000 |  | Housing Investment | 0 | 0 | 0 |  |  |  | 8848334 | 7663108.13
210000 |  | General Reserve | 0 | 0 | 0 |  |  |  | 0 | 0
304000 |  | Interstate C Dbt Svc | 0 | 0 | 0 |  |  |  | 7098455 | 0
100000 |  | General Fund Contingency | 0 | 0 | 0 |  |  |  | 0 | 0
100000 |  | Gen Fund Reimb Expenditures | 0 | 0 | 0 |  |  |  | 0 | 0
100000 |  | General Fund Transfers | 0 | 0 | 0 |  |  |  | 0 | 0
100000 | CB | Community Technology | 0.001386962552011096 | 0.001406030307764412 | 9 |  |  |  | 1816671 | 868973
100000 |  | Office of Sustainable Development (OSD) | 0.007551240560949299 | 0 | 0 |  |  |  | 0 | 0
206000 |  | Cable | 0 | 0 | 0 |  |  |  | 2563138 | 2134040.62
100000 | HN | Office of Human Relations | 0.0006164278008938204 | 0.0006249023590064052 | 3 |  |  |  | 589509 | 485302.81
100000 |  | General Fund Revenues/Balance | 0 | 0 | 0 |  |  |  | 0 | 0
100000 |  | Business Licenses | 0 | 0 | 0 |  |  |  | 0 | 0
208000 |  | Business [NAME] | 0 | 0 | 0 |  |  |  | 0 | 0
207000 |  | Prvt Hire TR Safety | 0 | 0 | 0 |  |  |  | 15000 | 0
100000 | NI | Office of Neighborhood    Involvement | 0.007088919710278934 | 0.007342602718325261 | 46 |  |  |  | 6439822 | 5925598.785
100000 |  | General Services | 0 | 0 | 0 |  |  |  | 200320 | 193750
100000 |  | Utility Billing Sys Implent | 0 | 0 | 0 |  |  |  | 1576023 | 973016
703000 |  | P&D Srvcs Operating | 0.004160887656033287 | 0.003749414154038432 | 24 |  |  |  | 6668958 | 5599834.290000001
100000 | OE |  | 0 | 0 | 0 |  |  |  | 0 | 0
100000 |  | Revenue Bureau | 0.01032516566497149 | 0.01015466333385408 | 67 |  |  |  | 9942050 | 7041094.720000001
100000 |  | Special Appropriations | 0 | 0 | 0 |  |  |  | 11168785 | 6476768.06
220000 |  | Portland Park Mem Tr | 0 | 0 | 0 |  |  |  | 53252 | 0
500000 |  | Parks Endowment | 0 | 0 | 0 |  |  |  | 0 | 225
616000 |  | Wtr Grwth Imp Chg Tr | 0 | 0 | 0 |  |  |  | 0 | 0
700000 |  | Health Insurance Op | 0.001695176452458006 | 0.001718481487267614 | 11 |  |  |  | 2304009 | 2365925.46
100000 | PN | Bureau of Planning &    Sustainability | 0.01294498381877023 | 0.01437275425714732 | 98 |  |  |  | 11099756 | 13780055
203000 |  | Development Services | 0.02542764678687009 | 0.0242149664114982 | 174 |  |  |  | 28801272 | 16214011.535
218000 |  | CDBG Incoming (Ext) | 0 | 0 | 0 |  |  |  | 8242403 | 5342360.755000001
219000 |  | HOME Incoming (Ext) | 0 | 0 | 0 |  |  |  | 2498261 | 2565098.565
100000 | HC | Portland Housing Bureau | 0.005085529357374018 | 0.009998437744102483 | 54 |  |  |  | 9989120 | 10103832.5
 |  |  |  |  | 0 |  |  |  | 875305 | 729.12
706000 |  | Technology Services | 0.03374942209893666 | 0.03249492266833307 | 202 |  |  |  | 45641587 | 34612872.75
702000 |  | CityFleet Operating | 0.01186623516720604 | 0.0115606936416185 | 74 |  |  |  | 23925207 | 21641351.165
704000 |  | Insurance & Claim Op | 0.002311604253351826 | 0.002187158256522419 | 14 |  |  |  | 9534393 | 5398647.23
705000 |  | Wkr Comp Self Ins Op | 0.0007705347511172754 | 0.001093579128261209 | 7 |  |  |  | 4418094 | 3686446.93
707000 |  | PPA Health Insurance | 0 | 0 | 0 |  |  |  | 0 | 0
612000 |  | Water Bond Sinking | 0 | 0 | 0 |  |  |  | 0 | 0
604000 |  | Portland Int Raceway | 0.001541069502234551 | 0.0009373535385096079 | 6 |  |  |  | 1699679 | 1295730.31
603000 |  | Golf | 0.005701957158267838 | 0.006405249179815654 | 37 |  |  |  | 6898605 | 6082666.53
610000 |  | [NAME] | 0 | 0 | 0 |  |  |  | 403640 | 0
202000 |  | Emergency Comm | 0.02234550778240098 | 0.02155913138572098 | 132 |  |  |  | 20040533 | 18350352.555
601000 |  | [NAME] | 0.0004623208506703652 | 0 | 0 |  |  |  | 687311 | 381836.61
611000 |  | Hydro [NAME] Rdmpt | 0 | 0 | 0 |  |  |  | 1358405 | 0
618000 |  | Hydro Pwr Rnwl Rplmt | 0 | 0 | 0 |  |  |  | 0 | 0
606000 |  | Parking Facilities | 0 | 0 | 0 |  |  |  | 7768681 | 3172752.3
613000 |  | Parking Fac Db Rdmpt | 0 | 0 | 0 |  |  |  | 0 | 0
701000 |  | Facilities [NAME] | 0.005547850208044383 | 0.005467895641306046 | 36 |  |  |  | 29914922 | 19354126.16
400000 |  | [NAME] | 0 | 0 | 0 |  |  |  | 2076839 | 1315508.66
401000 |  | LID Construction | 0 | 0 | 0 |  |  |  | 802544 | 217803.67
308000 |  | Gas Tax Bond Rdmpt | 0 | 0 | 0 |  |  |  | 542775 | 0
311000 |  | Bancroft Int & Sinkg | 0 | 0 | 0 |  |  |  | 4306371 | 0
401000 |  | LID Construction | 0 | 0 | 0 |  |  |  | 0 | 0
402000 |  | [NAME] | 0.001695176452458006 | 0.001718481487267614 | 10 |  |  |  | 10380686 | 2561925.390000001
317000 |  | [NAME] | 0 | 0 | 0 |  |  |  | 2471735 | 0
708000 |  | Enterprise Business Solutions Services | 0.002928032054245646 | 0.002812060615528824 | 19 |  |  |  | 9931533 | 2765434.51
222000 |  | Police Special Revenue | 0 | 0 | 0 |  |  |  | 459136 | 264232.675
221000 |  | Tax Increment Financing Reimbursment | 0 | 0 | 0 |  |  |  | 33993769 | 17921490.665
100000 | MFFM | Fund Management | 0 | 0 | 0 |  |  |  | 2742562 | 0
100000 | GR, MY, PA, PS, PU, PW | Council | 0.01094159346586531 | 0.0114044680518669 | 75 |  |  |  | 9198637 | 7161645.010000001
100000 | EM | Portland Office of    Emergency Management | 0.002465711203575281 | 0.002655835025777222 | 18 |  |  |  | 10305359 | 6120432.620000001
100000 | MF | Office of Management    & Finance | 0.0302049622437972 | 0.03108889236056866 | 193 |  |  |  | 20245606 | 15751424.17
100000 | AT | Office of City Attorney | 0.00940052396363076 | 0.009373535385096079 | 63 |  |  |  | 8586319 | 7704649.2
100000 |  | Purchasing | 0 | 0 | 0 |  |  |  | 4825133 | 4620935.02
100000 | AU | Office of the City    Auditor | 0.00816766836184312 | 0.00843618184658647 | 55 |  |  |  | 9037735 | 5853754
 |  | TOTAL