Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Cost Allocation Plan - Updates 2014
)1 0 laail3 ES )1m 00 704033 oswoo 0900l.).elen.ur sala1,1 1.1 lilbiaM P.M, lilbiallll P-ialae3 lilbiallll P.M, lilbiaM P.M, 8E Pur,,Muen0/41en0 J.1.,0000 l l9 ...WI,0111V EE P,PueEls,Jed 0000 lE0 pd �eleoI a..0 Paa4 n, P OE 6EE SE 90: 00 080 E li,8,E SZ EEC OP OWE ■ue (span .ien,ie P 00 099 SE EVE 00 08CrE s)1,,,,19nd 8Z EEE � � "I.„ .a.,I' ”I a P l d P,e; — eeu eue Eq. i r 431 P IN Mewl s au v d P P lo°117a sn1el ��0 $ — P (sleud�17Tssua.rPl,. ..s. o 0000 o. es 10 es vmw P 1ueweb w es do0 sN )1 04..43 su.1eselIV ry symed fop )1 04..43 LewumS Isa-Vul (.1.01)..11015 ssi4rleJe sale. laayspeaJds Mai uaileaalIV P 3 i 3011e,Idea a N°O.13°°3 N 0-auie1,11uatimedad p Wad P i ao eai, dal a N iV i N 0 NI wye a pl a P i revs 31 P w smpe,001,0300V (:u.w Im P sa .)sl°,11sos 1 P punk, spiatuvedaa aainias l a 11.33°9 P ", a=QI of[117['3 1 173. 1 i anla Paal 1 e o na vl Joj no P 11 P3 City of Tigard,OR City Mgmt, Risk Mgmt, Council: Personnel Cost Analysis Worksheet and Line Item Apportionment FY 2013-14 Proposed Budget Indirect Cost Pools/Direct Service Departments Personnel Cost Analysis Worksheet 1 2 3 4 5 Risk Mngmnt- Must City Mngmnt-City City Mngmnt-Web Risk Mngmnt- Employee Name/Title/Description FTEs be Line Item-Annual G&A Mayor&Council Manager Services Insurance Claims&Misc 100% Personnel Cost Premiums $ % $ % $ % $ % $ % $ City Manager-M Wine 100 100% $ 174,771 - loo o% 174,771 - - - Asst City Mgr/Adman Svcs Dir-L Newton 0 70 100% $ 114,962 - - ioo 0% 114,962 - - - Exec Asst to City Mgr-J Bengtson 0 90 100% $ 76,313 - 100 0% 76,313 - - - WebServicesCoordinator-N Lof 100 100% $ 95,620 - - 200% 19,124 800% 76,496 - - Asst to the City Mgr-L Mills 1 00 100% $ 120,974 - - 20 of 24,195 - - 80 of 96,779 Sr Management Analyst-K Wyatt 100 100% $ 103,575 - 200i 20,715 so 0% 51,788 1 - 300 31,073 Risk Mgmt Tech-J Curran 0 50 100% $ 30,893 _ - 100 0% 30,893 Mayor&City Council 0 00 100% $ 150,187 - ioo o% 150,187 0% - - - - - AdjustmentforCityManager 100% - 858% - 142% Adjustment for Risk 100% - 100 0% 0% - - Total Personnel Cost I $ 867,295 $ $ 170,902 $ 461,152 $ 76,496 $ $ 158,745 Total Personnel Cost/line entry before G&A allocation $ 867,295 $ - $ 170,902 $ 461,152 $ 76,496 $ - $ 158,745 Personnel Cost Ratio before G&A allocation 100 00% 0 00% 19 71% 53 17% 8 82% 0 00% 18 30% Reallocate G&A $ $ $ $ $ $ - $ Total Personnel Costs after G&A allocation $ 867,295 $ - $ 170,902 $ 461,152 $ 76,496 $ $ 158,745 Personnel Cost Ratio after G&A allocation 100.00% 0% 20% 53% 9% 0%0 18% FTEs before G&A allocation 6 10 0 00 0 20 3 50 IF 0 80 * 0 00 1 60 I Reallocate G&A 0 00 0 00 0 00 0 00 0 00 0 00 0 00 FTEs after G&A Allocation 6.10 0.00 0.20 3.50 0.80 0.00 1.60 Line Item Apportionment 1 2 3 4 5 Line Item- City Mngmnt-City City Mngmnt-Web Risk Mngmnt- Risk Mngmnt- Line Item-Description Department Allocation Mayor&Council Insurance Budget/Actuals Manager Services Premiums Claims&Misc 0500-Mayor&Council All Non-Personnel $ 112,190 1 All to Mayor&Council $ 112,190 $ - - $ - $ - 1000-City Manager All Non-Personnel $ 189,947 A City Mgmt $ $ 162,922 $ 27,025 $ - $ -I 1200-Risk Management Materials,Services,&Capital $ 107,220 5 All to Risk Mngmnt-Claims&Misc $ - $ - $ - $ - $ 107,220 1200-Risk Management Insurance $ 327,402 4 All to Risk Mngmnt-Insurance Premiums $ $ - $ - $ 327,402 $ - Total Line Item Apportionment $ 736,759 112,190 162,922 27,025 327,402 107,220 Total Personnel Costs after G&A allocation $ 867,295 $ 170,902 I $ 461,152 I $ 76,496 I $ -I $ 158,745 Total Line Item Apportionment $ 736,759 $ 112,190 $ 162,922 $ 27,025 $ 327,402 $ 107,220 'Grand Total-Costs I $ 1,604,054 I I I I $ 283,092 I $ 327,402 624,074 103,521 265,965 A-87 Adjustments 1 2 3 4 5 Risk Mngmnt- City Mngmnt-City City Mngmnt-Web Risk Mngmnt- Description Budget/Actuals Department Allocation Mayor&Council Insurance Manager Services Claims&Misc Premiums Remove costs of Council b/c unallowable per A87 guidelines $ (283,092) 1 All to Mayor&Council $ (283,092) $ - $ $ $ - City Mngr-Advertising $ (41,200) A City Mgmt $ - $ (35,338) $ (5,862) $ $ City Mngr-Dues&Subscriptions(lobbying) $ (3,092) A city Mgmt $ - $ (2,652) $ 440) $ - $ City Mngr-Special Dept Expenses(celebrations) $ (1,000) A City Mgmt $ - $ (858) $ (142) $ - $ City Mngr-Capital $ - A City Mgmt $ - $ - $ $ - $ Risk-Capital $ - 5 All to Risk Mngmnt-Claims&Misc $ - $ - $ - $ - $ Total $ (328,384) (283,092) (38,848) (6,444) - ['Grand Total-Costs I$ 1,604,054 I I $ 283,092 11 $ 624,074 $ 103,521 I_J $ 327,402- $ 265,965 I 7/31/2013 Appendix A-Page 2 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR City Mgmt, Risk Mgmt, Council: Personnel Cost Analysis Worksheet and Line Item Apportionment FY 2013-14 Proposed Budget I�Total A-87 Adjustments I$ (328,384)1 I I I $ (283,092)1 I $ (38,848)1 I $ (6,444)1 I $ -I I $ -I Total Net Costs I $ 1,275,670 I I I I $ -I I $ 585,226 I I $ 97,077 1 I $ 327,402 I I $ 265,965 Allocation Factor Distributor-All Departments or City Management Only 1 2 3 4 5 Allocation Factor City Mngmnt-City City Mngmnt-Web Risk Mngmnt- Risk Mngmnt- # Allocation Factor Data Department Allocation Mayor&Council Manager Services Insurance Claims&Misc 1 Total Actual Expenditures $ 1,604,054 B Total Expenditures 283,092 624,074 103,521 327,402 265,965 3 FTEs 6 10 C Total FTEs 0 4 1 0 2 4 Web Services 17 A City Mgmt 0 00 14 58 2 42 0 00 0 00 6 Property Value $ 370,522 A City Mgmt _ 0 317,805 52,717 0 0 7 Graphics Staff Time(Minutes) 12,665 A City Mgmt 0 10,863 1,802 0 0 8#of Records Requests 17 A City Mgmt I 0 15 2 0 0 9 Time on Records Requests 15 A City Mgmt 0 13 2 0 0 10 Journal Entries 70 A City Mgmt 0 60 10 0 0 14#of Printers/Copiers 1 A City Mgmt 0 1 0 0 0 15 Help Desk Tickets 73 A City Mgmt I 0 63 10 0 0 16 P-Card Transactions 125 A City Mgmt 0 107 18 0 0 20#of Invoices 88 A City Mgmt 0 75 13 0 0 26 3yr Avg#Insurance Incidents 0 67 A City Mgmt 0 1 0 0 0 Allocation Factor Distributor-Risk Management Only 1 2 3 4 5 Allocation Factor City Mngmnt-City City Mngmnt-Web Risk Mngmnt- Risk Mngmnt- # Allocation Factor Data Department Allocation Mayor&Council Manager Services Insurance Claims&Misc 6 Property Value $ 288,184 5 All to Risk Mngmnt-Claims&Misc 0 0 0 0 288,184 7 Graphics Staff Time(Minutes) 665 5 Ali to Risk Mngmnt-Claims&Misc I 0 0 0 _ 0 665 8#of Records Requests 17 5 Ali to Risk Mngmnt-Claims&Misc 0 00 0 00 0 00 0 00 17 00 9 Time on Records Requests 10 5 Ali to Risk Mngmnt-Claims&Misc 0 0 0 0 10 10 Journal Entries 92 5 Ali to Risk Mngmnt-Ciaims&Misc 0 0 0 0 92 15 Help Desk Tickets 34 5 Ali to Risk Mngmnt-Claims&Misc ' I 0 0 0 0 34 16 P-Card Transactions 64 5 Ali to Risk Mngmnt-Claims&Misc 0 0 0 11° 64 20#of Invoices 45 5 Ali to Risk Mngmnt-Claims&Misc 0 0 0 45 34#of Record Boxes 53 5 Ali to Risk Mngmnt-Claims&Misc 0 0 0 53 Department Allocation Risk Mngmnt- City Mngmnt-City City Mngmnt-Web Risk Mngmnt- Mayor&Council Insurance Manager Services Claims&Misc Name Premiums A City Mgmt 86% 14% B Total Expenditures 18% 39% 6% 20% 17% C Total FTEs 3% 57% 13% 0% 26% D Risk E F G H J 7/31/2013 Appendix A-Page 3 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Design&Records: Personnel Cost Analysis Worksheet and Line Item Apportionment FY 2013-14 Proposed Budget Indirect Cost Pools/Direct Service Departments Personnel Cost Anal sis Worksheet 1 2 3 4 5 6 7 8 Recorder/Records- Recorder/Records- Must Design&Comm- Design&Comm- Design&Comm- Recorder/Records- Recorder/Records- Employee Name/Title/Description FTE5 be Line Item-Annual G&A Mail Graphics Copiers Records Council Support Municipal Court Elections p Personnel Costs p p Management pport Records Requests Supervisor 100% % $ % $ % $ % $ % $ % $ % $ % $ % $ Admin Support Suprv-Helen Kerstiens-Marvin 1 00 100% $ 108,636 - loo of 108,636 - _ - _ - - - Graphic Designer-Meghan Carlsrud 0 80 100% $ 68,084 - - loo of 68,084 - - - - - Reprographics Specialist-Donna Witten 0 80 100% $ 59,749 - 36,447 39 o% 23,302 - - - - - - City Recorder-Catherine Wheatley 100 100% $ 105,259 - - - - 257% 27,008 71,347 12% 1,315 10% 1,095 43% 4,493 Deputy City Recorder-Carol Krager 100 100% $ 90,682 - - - - 194% 17,551 58,505 - ssi 5,850 97% 8,776 Assistant City Manager-L Newton 0 30 100% $ 49,269 - oo 7% 32,848 ill 333% 16,421 Records Mgmt Spec-Debora Garland 100 100% $ 84,678 - - - - 862% 72,962 - 113% 9,586 25% 2,130 - 0% - Admin Srvcs Mgr-Nadine Robinson-Webster 0 50 100% $ 65,290 - - so o/ 32,645 - so 0% 32,645 - - - - MunicipalCourt 315 100% $ 341,849 - - - - - - - 1000% 341,849 - Adjustments AL AI. 0% - - - - - - - - - Total Personnel Costs $ 973,496 $ $ 36,447 $ 265,515 $ - $ 166,587 el $ 129,852 $ 10,902 $ 350,925 $ 13,269 Total Personnel Costs/line ent before G&A allocation $ 973,496 $ - $ 36,447 $ 265,515 $ - $ 166,587 $ 129,852 $ 10,902 $ 350,925 $ 13,269 Personnel Cost Ratio before G&A allocation 100 00% 0 00% 3 74% 27 27% 0 00% 17 11% 13 34% 1 12% 36 05% 1 36% Reallocate G&A $ i$ - $ - $ - $ - $ - $ - $ - $ - $ Total Personnel Costs after G&A allocation $ 973,496 $ - $ 36,447 $ 265 515 IZI $ 166,587 $ 129 852 $ 10 902 $ 350,925 $ 13,269 Personnel Cost Ratio after G&A allocation 100.00% 0% 4% 27% 0% 17% 13% 1% 36% 1% FTE5 before G&A allocation 9 55 0 00 0 49 2 56 0 00 1 66 1 32 0 13 3 25 0 14 Reallocate G&A 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 FTEs after G&A Allocation 9.55 0.00 0.49 2.56 0.00 1.66 1.32 0.13 3.25 0.14 Line Item Apportionment V 1 2 3 4 5 6 7 8 Recorder/Records- Recorder/Records- Line Item- Design&Comm- Design&Comm- Design&Comm- Recorder/Records- Recorder/Records- Line Item-Description Department Allocation Records Municipal Court Elections Budget/Actuals Mail Graphics Copiers Management Council Support Records Requests Supervisor 1500-City Recorder/Records All Non-Personnel $ 78,574 B Records $ - $ - $ - $ 40,827 $ 31,824 $ 2,672 $ - $ 3,252 1300-Design&Comm Punters/Copiers $ 46,144 3 All to Design&Comm-Copiers $ - $ - $ 46,144 $ - IZ11 $ - $ - $ 1300-Design&Comm Paper for all copiers/punters $ 10,000 3 All to Design&Comm-Copiers $ - $ - $ 10,000 $ - 1Z1 $ - $ - $ - 1300-Design&Comm General postage&postage supplies $ 50,000 1 All to Design&Comm-Mee $ 50,000 $ - IZI $ - IZ11 $ - $ - $ - 1300-Design&Comm Cityscape postage,permit fees,etc $ 42,000 1 All to Design&Comm-Mee $ 42,000 $ - 111 $ - 1Z1 $ - $ - $ - 1300-Design&Comm Remaining M&S and Capital $ 30,354 2 All to Design&Comm-Graphics $ - $ 30,354 IZI $ - $ - $ - $ - $ - 1400-Municipal Court-All Non-Personnel $ 184,018 7 All to Municipal Court $ - $ - $ - $ - $ - $ - $ 184,018 $ - Total Line Item Apportionment $ 441,090 92,000 30,354 56,144 40,827 31,824 2,672 184,018 3,252 Total Personnel Item Costs after G&A allocation $ 973,496 I $ 92,000 I $ 265,515 30,354 I $ 56,144 I $ 166,587 40,827 I $ 129,852 3 ,824 $ 10,902,672 I $ 184,018 I $ 13,269 Total Line Item Apportionment $ 441,090 (Grand Total-Costs I$ 1,414,586 I I I I$ 128,447 I I$ 295,869 1 I$ 56,144 I I$ 207,414 1 I$ 161,676 I I$ 13,573 1 I$ 534,943 1 I$ 16,521 A-87 Adjustments liiii 2 3 4 5 6 7 8 Recorder/Records- Recorder/Records- Design&Comm- Design&Comm- Design&Comm- Recorder/Records- Recorder/Records- Description Budget/Actuals Department Allocation Mail Graphics Copiers Records Council Support Records Requests Municipal Court Elections Management Supervisor Design&Comm-Special Department Expenses $ (50) 2 All to Design&Comm-Graphics $ - $ (50) il$ - $ - $ - $Alk - $Design&Comm-Capital $ (2,000) 2 All to Design&Comm-Graphics $ - $ (2,000) $ - $ - $ -City Recorder/Records-Capital $ (2,900) B Records $ - $ - $ - $ 1,507 � $ - $ 120 City Recorder/Records-Council Support $ (160,501) 5 All to Recorder/Records-Councl Support $ - $ - $ - $ - $ (160,501) $ - $Total $ (165,451) - (2,050) - (1,507) (161,676) (99) - (120) Grand Total-Costs $ 1,414,586 $ 128,447 1 $ 295,869 1 $ 56,144 1 $ 207,414 1 $ 161,676 1 $ 13,573 1 $ 534,943 1 $ 16,521 Total A-87 Adjustments $ (165,451) I $ - $ (2,050) $ - $ (1,507) $(161,676) $ (99) $ - $ (120) (Total Net Costs I$ 1,249,135 I I 1 I$ 128,447 1 I$ 293,819 1 I$ 56,144 1 I$ 205,907 1 I$ -I I$ 13,475 1 I$ 534,943 1 I$ 16,401 7/31/2013 Appendix A-Page 4 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Design&Records: Personnel Cost Analysis Worksheet and Line Item Apportionment FY 2013-14 Proposed Budget Illndirect Cost Pools/Direct Service Departments Allocation Factor Distributor-All Departments or Design Only II 1 2 IT 4 5 6 7 8 Recorder/Records- Recorder/Records- Design&Comm- Design&ComComm- Recorder/Records- Recorder/Records- # Allocation Factor Allocation Factor Department Allocation Mail Graphics ers Records Council Support Records Requests Municipal Court Elections Data Management Supervisor 1 Total Actual Expenditures $ 1,414,586 D _ Total expenditures 128,447 295, 4 I 207,41 161,67 _ 13,57 I 534,943 16,521 3 FTES 9 55 E FTES 0 49 2 0 1 3 0 1 3 25 0 1 6 Property Value $ 370,522 A Design 44,722 325,7 Graphics Staff Time(Minutes) 21,475 A Design 2,592 18,8#of Records Requests 16 A Design 2 9 Time on Records Requests 1 A Design 0 10 Journal Entries 110 A Design 13 0 14#of Punters/Copiers 3 C Au except Mcni Court 0 18 1 0 ∎ 0 6 0 0 0 15 Help Desk Tickets 111 A Design 13 0 16 P-Card Transactions 212 A Design 26 17 Fleet Work Order Expenses 121 A Design 15 18#of POs 6 A Design 1 0 19$of POs $ 34,378 A Design 4,149 30,20#of Invoices 158 A Design 19 0 Allocation Factor Distributor-Records Only I 1 2 3 4 5 6 7 8 Recorder/Records- Recorder/Records- Design&Comm- Design&Comm- Design&Comm- Recorder/Records- Recorder/Records- # Allocation Factor Allocation Factor Department Allocation Mail Graphics Copiers Records Council Support Records Requests Municipal Court Elections Data Management Supervisor 6 Property Value $ 545,045 B Records 0 283,202 220,752 _ 18,533 0 22,558 7 Graphics Staff Time(Minutes) 2,990 B Records 0 1,554 1,211 102 0 124 10 Journal Entries 67 B Records 0 0 0 0 0 00 34 81 27 14 2 28 0 00 2 77 16 P-Card Transactions 61 B Records 0 32 25 2 0 3 18#of POs 1 B Records 0 1 0 0 0 0 19$of POs $ 6,450 B Records 3,351 2,612 219 0 267 20#of Invoices 31 B Records 16 13 1 0 1 5#of Autos 1 B Records 0 1 0 0 0 17 Fleet Work Order Expenses 0 B Records 0 0 00 0 00 0 00 0 0 00 32 Direct Salaries&Wages $ 13,269 8 All to Reo rder/Records-Elections Supervisor 0 0 0 0 0 13,269 Department Allocation Recorder/Records- Recorder/Records- Design&Comm- Design&Comm- Design&Comm- Recorder/Records- Recorder/Records- Mail Graphics Copiers Records Council Support Records Requests Municipal Court Elections Name Management Supervisor A Design 12% 88% 0% B Records 52% 41% 3% 4% C All except Muni Court 6% 43% 0% 27% 21% 2% 2% D Total expenditures 9% 21% 4% 15% 11% 1% 38% 1% E FTES 5% 27% 0% 17% 14% 1% 34% 1% F G H J 7/31/2013 Appendix A-Page 5 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Finance&IT:Personnel Cost Analysis Worksheet and Line Item Apportionment FY 2013-14 Proposed Budget Indirect Cost Pools/Direct Service Departments Personnel Cost Analysis Worksheet 1 2 3 4 5 6 7 8 9 10 11 Must Fin&Info Srvcs- Fin O Fin R rtin Fin O Utility Billing eter Contracts and Fin&Info Srvcs- LineItem-Annual G&A ps p g ps Fin Ops-AP Fin Ops-Payroll Utility Billing-Billing y g IT-Support IT-GIS Passports/Business Employee Name/Title/Descnption FTES be Butlget/CIP /Mngmnt Accounting/GL Reading Purchasing 100/ Personnel Costs Licensing Finance&Info Srvcs Director-T LaFrance 100 100% $ 165,365 1000% 165,365 11 - - - - - - - - ConfExecutiveAssistant-L Lutz 100 100% $ 89,974 726% 65318 - - - - - - - - 274% 24,656 Sr Management Analyst-C Collins 1 00 100% $ 108758 - 1000% 108/58 - AssistantFinanceDirector-D Smith-Wagar 100 100% $ 149,845 - 119,876 - - - 200% 29,969 - - - - - AccountngSupervisor-A Lawson 100 100% $ 104254 - 104,254 - - - - - - - - Accountant-Vacant 080 100% $ 97,513 - 97513 - - - - - - - - SrAccountingAssistant-A McCoy 100 100% $ 83288 - - 10., 83288 - - - - - - PayrollSpecalist-K Strayer 100 100% $ 90223 - - - - 10., 90,223 - - - - - - Sr Management Analyst-J Barrett 1 00 100% $ 119,920 - - - - - - - - 1000% 119,920 - UBSupervisor-Vacant 100 100% $ 90,925 - - - - 90,925 - - - - - AccountingAssistantll-C Damell 080 100% $ 62,580 - - - - 62,580 - - - - - ITManager-L Sears 100 100% $ 162707 - - - - - - - 101,094 379% 61,613 - - DBA-Rob Adams 100 100% $ 97,519 - - - - - - - loo 0, 97,519 - - - NetworkAdministrator-J Whalen 1 00 100% $ 113227 - - - - - - - loo 0, 113227 - - - NetworkAdministrator-M Nolop 100 100% $ 110186 - - _ - - - - _ - loo 0% 110186 - - - GISCoordinator-P Beck 080 100% $ 86102 - - - - - - - - loo 0, 86,102 - - GISProgrammerAnalyst-N Shaub 100 100% $ 109496 - - - - - - - 10., 109,496 - - SrAccounting Assistant-J Greenberg 100 100% $ 88,048 - - - - - - 17,610 - - - 800% 70,438 - AccountingASSlstantll-A Williams 100 100% $ 79,814 - - - - - ]3,429 - - - - 6,385 Accounting Assistant II-J Adams 100 100% $ 82114 - - - - - ]5,545 - - - - 80% 6,569 Customer Service Worker-J Mason 100 100% $ 78,]24 - - - - - - ]8,]24 - - - - Sr Customer Service Worker-C Famer 1 00 100% $ 89,]59 - - - - - - - 89,]59 - Customer Service Worker-M DeCastro 080 100% $ 64,578 - - - - - 64578 - - - Adjustments 100% 1000% Total Personnel Costs $ 2,324,919 $ 230,683 $ 108,758 $ 119,876 $ 201,767 $ 83,288 $ 90,223 $ 350,057 $ 233,061 $ 422,026 $ 257,211 $ 190,358 $ 37,611 Total Personnel Costs/line entry before G&A allocation $ 2,324,919 $ 230,683 $ 108/58 $119876 $ 201/67■$ 83288■$ 90,223 $ 350,057 $ 233061 $ 422,026■$ 25]211 $ 190,358 $ 37,611 Personnel Cost Ratio before G&A allocation 10000% 992% 468% 516% 868% 358% 388% 1506% 1002% 1815% 1106% 819% 162/ Reallocate G&A $ - $ (230,683) $ 11,980 $ 13,204 $ 22,225 $ 9174 $ 9,938 $ 38,559 $ 25,672 $ 46,487 $ 28,332 $ 20,968 $ 4143 Total Personnel Costs after G&A allocation $ 2,324,919 $ $ 120,738 $ 133,080 $ 223,992 $ 92,462 $ 100,161 $ 388,617 $ 258,]33 $ 468,512 $ 35 . 211,327 $ 41,753 Personnel Cost Ratio after GSA allocation 100.00% 0% 5% 6% 10% 4% 4% 17% 11% 20% 12% 9% 2% FTES before G&A allocation 2220 173 100 I 080 180 I 100 100 404 280 ! 362 111 218 rr 180 043 Reallocate G&A 000 -173 008 007 015 008 008 ® 024 031 018 015 004 FTES after G&A Allocation 22.20 0.00 1.08 0.87 1.95 1.08 1.08 4.38 3.04 3.93 2.36 1.95 i 0.47 Line Item Apportionment i 1 2 3 4 5 6 7 8 9 10 11 Line Item- Fin&Info Srvcs- Fin O Fin n din Fin O Utility Billing Meter Contacts and Fin&Info Srvcs- Lineltem-Description Department Allocation ps p g ps Fin Ops-AP Fin Ops-Payroll Utility Billing-Billing y g IT-Support IT-GIS PassportsBUSmess Butlget/Actuals Butlget/CIP /Mngmnt Accounting/GL Reading Purchasing Licensing 2000Finance&Info Srvcs Admn Total non-personnel $ 78,980 Personnel after G. I $ 4,102 $ 4,521 $ ],609 $ 3141 $ 3,403 $ 13202 $ 8,789 $ 15,916 $ 9,700 $ ]1]9 $ 1418 2100-Finance Ops Total non-personnel $ 79,500 D $ - $ 19,24] $ 32395 $ 13,3]2 $ 14,486 $ - $ - $ - $ - $ - $ - 2200-Utility Billing Total non-personnel for meter reading $ 31450 7 $ - $ $ $ - $ - $ - $ 31450 $ - $ - $ - $ 2200-Utility Billing Totalmtrls&srvcs costs for utility billing $ 188,500 6 $ - $ $ $ - $ - $ 188,500 $ - $ - $ - $ - $ - 2300-Information Tech Non-personnel(cod GIS capital) $ 721,599 8 $ - $ - $ - $ - $ - ® $ - $ 721,599 $ - $ - $ - 2300-Information Tech GIS capital $ 54,390 9 $ - $ - $ - $ - $ - ® $ - $ - $ 54,390 $ - $ - 2500-Contracts&Purch Total non-personnel $ 9,375 10 All to contacts and Purchasing $ - $ $ - $ - $ - - - $ - $ - $ 9,375 $ Total Line Item Apportionment $ 1,163,794 4,102 23,768 40,004 16,513 17,888 201,702 40,239 737,515 64,090 16,554 1,418 Total Personnel Costs after G&A allocation _ $ 2,324,919 $ 120,738 $ 133,080 $ 223,992 $ 92,462 $ 100,161 $ 388,617 $ 258,733 $ 468,512 $ 285,544 $ 211,327 $ 41,753 Total Line Item Apportionment $ 1,163,794 $ 4,102 $ 23,768 $ 40,004 1 $ 16,513 $ 17,888 $ 201,702 $ 40,239 $ 737,515 $ 64,090 $ 16,554 $ 1,418 Grand Total-Costs $ 3,488,713 $ 124,839 $ 156,848 $ 263,996 $ 108,976 $ 118,050 $ 590,318 $ 298,972 $ 1,206,027 $ 349,634 $ 227,881 $ 43,172 7/31/2013 Appendix A-Page 6 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Finance&IT:Personnel Cost Analysis Worksheet and Line Item Apportionment FY 2013-14 Proposed Budget Indirect Cost Pools/Direct Service Departments A-87 Adjustments 1 2 3 4 5 6 7 8 9 10 11 Fin&Info Srvcs- Fin Ops-Fin Rprting Fin Ops- Utility Billing-Meter Contacts and Fin&Info Srvcs- Description Butlget/Actuals Department Allocation Butlget/CIP /Mngmnt Accounting/GL Fin Ops-AP Fin Ops-Payroll Utility Billing-Billing Reading IT-Support IT-GIS purchasing Passports/Business Licensing Finance Admin-Advertising $ (1]25) o $ (90) $ (99) $ (166) $ (69) $ (74) $ (288) $ (192) $ 348) $ (212) $ (157) $ (31) Finance Admin-Dues $ (1350) Personnel cosy Ratio anerea,4 $ (55) $ (60) $ (101) $ (42) $ 45 ® $ 117 $ )21� $ 29) $ (95) $ f19) Finance Adman-Capital $ Finance Ops Advertising $ — Finance Ops $ - $ - $ - $ - $ - ® $ - $ $ - $ - $ - FInanceops-Dues $ (2,500) Finance Ops $ - $ (605) $ (1019) $ (421) $ 456 ® $ - $ $ - $ - $ Utility Billing Advertising $ — $ — $ — $ —1 $ — $ — ® $ - $ - $ $ - $ UhlityBilling-Special Department Expenses $ (2,000) $ - $ - $ - $ - $ - $ (2,000) $ - $ - $ $ - $ - UtlityBilling-Capital $ (20000) All to Utility Billing Bill, $ - $ - $ - $ - $ - $ 20000 $ - $ $ $ - $ IT—Advertising $ (1,500) All to IT Support $ — $ — $ — $ — $ — ® $ — $ (150 j $ 1 $ - $ IT-Other Capital $ (68,100) All to IT Support $ - $ - $ _ $ - $ - $ - $ - $ (68,100) $ $ - $ IT-GIS Capital $ (54,390) Alto IT GIs $ - 1— - $ $ - - - - $ - $ (54390) $ - $ Total $ (151,265) (144) (764) (1,286) (531) (575) (22,464) (309) (70,159) (54,731) (252) (50) Grand Total Costs $ 3,488,7213 $ 124839 $ 156,848 $ 263996 $ 108,376 $ 118050 $ 590,318 $ 298,372 $ 1206,027 $ 349,634 $ 227,881 $ 43,172 'Total A.87 Adjustments $ (151,265) $ (144) $ (164) $ (1286) $ (531) $ (575) $ (22,464) $ (309) $ (70159) $ (54]31) $ (252) $ (50) rotal Net Costs I$ 3,337,448 I I I I$ 124,695 I I$ 156,084 I I$ 262,7101 I$ 108,445 I I$ 117,475 I I$ 567,854 I I$ 298,664 I I$ 1,135,868 I I$ 294,9031 I$ 227,628 I I$ 43,122 Allocation Factor Distributor-All Divisions or Finance Only 1 2 3 4 5 6 7 8 9 10 11 Fin&Info Srvcs- Fin Ops-Fin Rprting Fin Ops- Utility Billing-Meter Contacts and Fin&Info Srvcs- 9 Allocation Factor Allocation Factor Department Allocation Butlget/CIP /Mngmnt Accounting/GL Fin Ops-AP Fin Ops-Payroll Utility Billing-Billing Reatling IT-Support IT-GIS Purchasing PassportsBUSmess Data Licensing 1 Total Actual Expenditures $ 3,488,713 F Tor ores I 1241830 156,84 263996 108,976 118,05 590,318 298,97 1206,02 349,634 227,88 4317 3 FTES 2220 G 10 08 195 108 10 438 30 39 236 19 04 4Web Services 12 Personnel Cost Ratio after G. 06 06 ® 048 05 201 13 24 147 10 02 6 Property Value $ 741,044 A Finance 96,88 106,78 179735 74193 8037 0 0 169,57 3350 7 Graphics Staff Time(Minutes) 2540 A Finance 33 36 ® 254 27 0 0 58 11 8#of Records Requests 18 A Finance 2 ® 0 9 Time on Records Requests 9 A Finance 1 ® 0 13#of Computers 59 Personnel Cost aA 2 ® 1 7 14#of Printers/Copiers 3 E Finance 05 05 09 039 ■ 000 00 00 000 00 01 15 Help Desk Tickets 264 E Finance 4 4 8 34 ® ® 0 1 16 P Card Transactions 104 E 1 1 3 14 ® ® 0 23 Agenda Items 36 Personnel Cost Ratio after G. 4 25 Electronic Records 58 Personnel Cost Ratio after G. ® 1 26 3yr Avg#Insurance Incidents 033 Pe os aA ® ® 0 20#ofInvoices 320 E 5 6 10 4 45 0 0 1 32 Direct Salaries&Wages $ 37,611 11 All to Fin Licensing 0 0 0 37,61 34#of Record Boxes 142 Personnel Cost Ratio after G. 1 6 24 1 2 17 1 Allocation Factor Distributor-Utility Billing Only 1 2 3 4 5 6 7 8 9 10 11 Fin&Info Srvcs- Fin O Fin R rtn Fin O Utility Billing Meter Contacts and Fin&Info Srvcs- Ps- P 9 Ps- Y 9- 11 Allocation Factor Allocation Factor Department Allocation Butlget/CIP /Mngmnt Accounting/GL Fin Ops-AP Fin Ops-Payroll Utility Billing-Billing Reading IT-Support IT-GIS Purchasing PassportsBUSmess Data Licensing 6 Property Value $ 370,522 g _ 0 222,432 148,090 7 Graphics Staff Time(Minutes) 125 Utility Biding 0 75 50 8#of Records Requests 3 00 00 00 00 000 180 120 00 00 00 00 9 Time on Records Requests 225 ® 1 1 10 Journal Entries 80 48 32 _ 14#of Printers/Copiers 2 Utility Bill, 1 1 16 P Card Transactions 68 Utility Billing 41 27 17 Fleet Work Order Expenses 11,013 ueiry Billing 6,611 4,402 18#ofPOs 9 Utility Billing 5 4 19$of POs $ 54,596 _ 32,775 21,821 20#of Invoices 68 Utility Bill, I _ 41 21 5#of Autos 2 All to Meter Reading 0 2 34#of Record Boxes 59 y g 35 24 7/31/2013 Appendix A-Page 7 of 53 Tigard ICAP Budget 2014 Budget System Load City of Tigard,OR Finance&IT:Personnel Cost Analysis Worksheet and Line Item Apportionment FY 2013-14 Proposed Budget Indirect Cost Pools/Direct Service Departments Allocation Factor Distributor-IT Only 1 2 3 4 5 6 7 8 9 10 11 Fin&Info Srvcs- Fin Ops-Fin Rprting Fin Ops- Utility Billing-Meter Contacts and Fin&Info Srvcs- 9 Allocation Factor Allocation Factor Department Allocation Butlget/CIP /Mngmnt Accounting/GL Fin Ops-AP Fin Ops-Payroll Utility Billing-Billing Reading IT-Support IT-GIS purchasing Passports/Business_ Licensing 6 Property Value $ 1205,220 0 748,831 456389 Graphics Staff Time(Minutes) 2205 i -.1 1,3]0 835 8#of Records Requests 0 i 00 00 00 00 00 000 00 000 000 00 00 9 Time on Records Requests 0 75 ® 0 0 10 Journal Entries 274 i -.1 170 104 14#of Printers/Copiers 3 i ".1 2 1 1 Desk Tickets 1,626 i ".1 ® 1010 616 16 P Card Transactions 480 i ".1 ® 298 182 1 Fleet work order Expenses 260 ® ® 162 98 18#of POs 10 i ".1 ® 6 4 19$ofPOs $ 177 146 i ® ® 110,065 67 081 200#ofInvoices 203 - ® ® 126 n" • 26 Syr Avg#Insurance Incidents 033 — ® 0 — 0 0_ 5#of Autos 1 T 0 0 1 0 Department Allocation Fin&Info Srvcs- Fin Ops-Fin Rprting Fin Ops- Utility Billing-Meter Contacts and Fin&Info Srvcs- Butlget/CIP /Mngmnt Accounting/GL Fin Ops-AP Fin Ops-Payroll Utility Billing-Billing Reading IT-Support IT-GIS Purchasing PassportsBUSiness Name Licensing Finance 13% 14% 24% 10% 11% 23% 5% Utility Billing 60% 40% IT 62% 38% Finance Ops 24% 41% 17% 18% Finance cod Purch 17% 19% 31% 13% 14% 6% Total Expenditures 4% 4% 8% 3% 3% 17% 9% 35% 10% 7% 1% FTES 5% 4% 9% 5% 5% 20% 14% 18% 11% 9% 2% J 7/31/2013 Appendix A-Page 8 of 53 Tigard ICAP Budget 2014 System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet City Hall Permit Center Police Sq Ft Depr Facilities Sq Ft Depr Facilities Sq Ft De r 4,634 I 5,513 I 11,811 100 0500 Mayor&Council $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager 352 $ - $ - $ - $ - $ - 600 1000 City Mngmnt-Web Services $ - $ - $ - $ - $ - 600 1100 Human Resources $ - $ - 365 $ - $ - $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ - $ - 3 $ - $ - $ - 600 1300 Design&Comm-Mail $ - $ - $ - $ - $ - 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - $ - $ - $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - $ - $ - $ - 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - 600 2100 Fin Ops-AP $ - $ - $ - $ - 1$ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading $ - $ - $ - $ - $ - 600 2300 IT-Support $ - $ - $ - $ - $ - 600 2300 IT-GIS $ - $ - $ - $ - $ - 600 2500 Contracts and Purchasing $ - $ - $ - $ - $ - 650 6300 Fleet Maintenance $ - $ - $ - $ - $ - 650 6400 Property Management $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 100 1400 Municipal Court $ - $ - $ - $ - $ - 100 3000 Community Development Admin $ - $ - $ - $ - $ - 230 3100 Building $ $ 1,110 $ $ $ - 100 3200 Development Services $ - $ - 683 $ - $ - $ - 100 3300 Community Planning $ - $ - 632 $ - $ - $ - 100 3700 Downtown Redevelopment $ - $ - 107 $ - $ - $ - 100 4000 Police Administration $ - $ - $ - $ - 875 $ - 100 4100 Police Operations $ - $ - 299 $ - $ - 10,936 $ - 100 4200 Support Services $ - $ - $ - $ - $ - 100 5000 Library Administration $ - $ - $ - $ - $ - 100 5100 Library Readers'Services $ - $ - $ - $ - $ - 100 5200 Library Technical Services $ - $ - $ - $ - $ - 100 5300 Library Circulation $ - $ - $ - $ - $ - 100 5900 Social Svcs&Community Events $ - $ - $ - $ - $ - 100 6000 Public Works Administration $ - $ - $ - $ - $ - 100 6100 Parks&Grounds $ - $ - $ - $ - $ - 200 6200 Street Maintenance $ - $ - $ - $ - $ - 100 6250 Project Engineering $ - $ - $ - $ - $ - 100 0000 CIP/Transfers/Contingency $ - $ - $ - $ - $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - $ - $ - $ - $ - 205 0000 City Gas Tax Fund $ - $ - $ - $ - $ - 220 0000 Electrical Inspection Fund $ - $ - $ - $ - $ - 240 0000 Criminal Forfeiture Fund $ - $ - $ - $ - $ - 260 0000 Urban Forestry Fund $ - $ - $ - $ - $ - 300 0000 Bancroft Debt Service Fund $ - $ - $ - $ - $ - 350 0000 GO Debt Service Fund $ - $ - $ - $ - $ - 400 0000 Facilities Fund $ - $ - $ - $ - $ - 405 0000 Transportation Development Tax $ - $ - $ - $ - $ - 410 0000 Traffic Impact Fee $ - $ - $ - $ - $ - 411 0000 Underground Utility Fund $ - $ - $ - $ - $ - 412 0000 Street Maintenance Fee Fund $ - $ - $ - $ - $ - 420 0000 Parks Capital Fund $ - $ - $ - $ - $ - 421 0000 Parks Bond Fund $ - $ - $ - $ - $ - 425 0000 Parks SDC Fund $ - $ - $ - $ - $ - 460 0000 Transportation CIP Fund $ - $ - $ - $ - $ - 500 6600 Sanitary Sewer Fund $ - $ - $ - $ - $ - 510 6700 StormwaterFund $ - $ - $ - $ - $ - 511 0000 Water Quality/Quantity Fund $ - $ - $ - $ - $ - 530 6500 Water Fund $ - $ - $ - $ - $ - 531 0000 WaterSDC Fund $ - $ - $ - $ - $ - 532 0000 Water CIP Fund $ - $ - $ - $ - $ - 533 0000 Water Debt Service Fund $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Elections Supervisor $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Passports/Business Licensing $ - $ - $ - $ - $ - 660 0000 Insurance Fund $ - $ - $ - $ - $ - 930 0000 Urban Renewal Debt Srvc $ - $ - $ - $ - $ - 940 9000 Urban Renewal Cap Improvements $ - $ - $ - $ - $ - 510 6260 Healthy Streams $ - $ - $ - $ - $ - Other Jurisdictions $ - $ - $ - $ - $ - II $ - 1$ - II $ - $ - II $ - Check O.K. Check O.K. Check O.K. Check O.K. Check O.K. Common Areas I 6,7991 I 7,8681 I I Grand Total Sq Ft 11,433 13,381 11,811 7/31/2013 Appendix B-Page 9 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet Facilities 100 0500 Mayor&Council $ - 600 1000 City Mngmnt-City Manager $ - 600 1000 City Mngmnt-Web Services $ - 600 1100 Human Resources $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - 600 1200 Risk Mngmnt-Claims&Misc $ - 600 1300 Design&Comm-Mail $ - 600 1300 Design&Comm-Graphics $ - 600 1300 Design&Comm-Copiers $ - 600 1500 Recorder/Records-Records Management $ - 600 1500 Recorder/Records-Council Support $ - 600 1500 Recorder/Records-Records Requests $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - 600 2100 Fin Ops-Accounting/GL $ - 600 2100 Fin Ops-AP $ - 600 2100 Fin Ops-Payroll $ - 600 2200 Utility Billing-Billing $ - 600 2200 Utility Billing-Meter Reading $ - 600 2300 IT-Support $ - 600 2300 IT-GIS $ - 600 2500 Contracts and Purchasing $ - 650 6300 Fleet Maintenance $ - 650 6400 Property Management $ - $ - 100 1400 Municipal Court $ - 100 3000 Community Development Admin $ - 230 3100 Building $ - 100 3200 Development Services $ - 100 3300 Community Planning $ - 100 3700 Downtown Redevelopment $ - 100 4000 Po lice Administration $ - 100 4100 Police Operations $ - 100 4200 Support Services $ - 100 5000 Library Administration $ - 100 5100 Library Readers'Services $ - 100 5200 Library Technical Services $ - 100 5300 Library Circulation $ - 100 5900 Social Svcs&Community Events $ - 100 6000 Public Works Administration $ - 100 6100 Parks&Grounds $ - 200 6200 Street Maintenance $ - 100 6250 Project Engineering $ - 100 0000 CIP/Transfers/Contingency $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - 205 0000 City Gas Tax Fund $ - 220 0000 Electrical Inspection Fund $ - 240 0000 Criminal Forfeiture Fund $ - 260 0000 Urban Forestry Fund $ - 300 0000 Bancroft Debt Service Fund $ - 350 0000 GO Debt Service Fund $ - 400 0000 Facilities Fund $ - 405 0000 Transportation Development Tax $ - 410 0000 Traffic Impact Fee $ - 411 0000 Underground Utility Fund $ - 412 0000 Street Maintenance Fee Fund $ - 420 0000 Parks Capital Fund $ - 421 0000 Parks Bond Fund $ - 425 0000 Parks SDC Fund $ - 460 0000 Transportation CIP Fund $ - 500 6600 Sanitary Sewer Fund $ - 510 6700 Stomiwater Fund $ - 511 0000 Water Quality/Quantity Fund $ - 530 6500 Water Fund $ - 531 0000 WaterSDC Fund $ - 532 0000 Water CIP Fund $ - 533 0000 Water Debt Service Fund $ - 600 1500 Recorder/Records-Elections Supervisor $ - 600 2000 Fin&Info Srvcs-Passports/Business Licensir$ - 660 0000 Insurance Fund $ - 930 0000 Urban Renewal Debt Srvc $ - 940 9000 Urban Renewal Cap Improvements $ - 510 6260 Healthy Streams $ - Other Jurisdictions $ - $ - Check O.K. Common Areas Grand Total Sq Ft 7/31/2013 Appendix B-Page 10 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet Library City Hall Modular Building Niche Building Sq Ft Der Facilities Sq Ft Der Facilities Sq Ft De r 48,001 1,980 5,940 100 0500 Mayor&Council $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager $ - $ - $ - $ - $ - 600 1000 City Mngmnt-Web Services $ - $ - $ - $ - $ - 600 1100 Human Resources $ - $ - 232 $ - $ - $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ - $ - 207 $ - $ - $ - 600 1300 Design&Comm-Mail $ - $ - $ - $ - $ - 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - 263 $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - $ - $ - $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - 200 $ - $ - $ - 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - 600 2100 Fin Ops-AP $ - $ - $ - $ - $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - 104 $ - $ - $ - 600 2200 Utility Billing-Meter Reading $ - $ - $ - $ - $ - 600 2300 IT-Support $ - $ - $ - $ - 5.940 $ - 600 2300 IT-GIS $ - $ - $ - $ - $ - 600 2500 Contracts and Purchasing $ - $ - $ - $ - $ - 650 6300 Fleet Maintenance $ - $ - $ - $ - $ - 650 6400 Property Management $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 100 1400 Municipal Court $ - $ - $ - $ - $ - 100 3000 Community Development Admin $ - $ - $ - $ - $ - 230 3100 Building $ - $ - 228 $ - $ - $ - 100 3200 Development Services $ - $ - 225 $ - $ - $ - 100 3300 Community Planning $ - $ - $ - $ - $ - 100 3700 Downtown Redevelopment $ $ $ $ $ 100 4000 Police Administration $ - $ - 521 $ - $ - $ - 100 4100 Police Operations $ - $ - $ - $ - $ - 100 4200 Support Services $ - $ - $ - $ - $ - 100 5000 Library Administration 2,2 $ - $ - $ - $ - $ - - 100 5100 Library Readers'Services 30,1 $ - $ - $ - $ - $ - 100 5200 Library Technical Services 4,4 $ - $ - $ - $ - $ - 100 5300 Library Circulation 11,1 $ - $ - $ - $ - $ - 100 5900 Social Svcs&Community Events $ - $ - $ - $ - $ - 100 6000 Public Works Administration $ - $ - $ - $ - $ - 100 6100 Parks&Grounds $ - $ - $ - $ - $ - 200 6200 Street Maintenance $ - $ - $ - $ - $ - 100 6250 Project Engineering $ - $ - $ - $ - $ - 100 0000 CIP/Transfers/Contingency $ - $ - $ - $ - $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - $ - $ - $ - $ - 205 0000 City Gas Tax Fund $ - $ - $ - $ - $ - 220 0000 Electrical Inspection Fund $ - $ - $ - $ - $ - 240 0000 Criminal Forfeiture Fund $ - $ - $ - $ - $ - 260 0000 Urban Forestry Fund $ - $ - $ - $ - $ - 300 0000 Bancroft Debt Service Fund $ - $ - $ - $ - $ - 350 0000 GO Debt Service Fund $ - $ - $ - $ - $ - 400 0000 Facilities Fund $ - $ - $ - $ - $ - 405 0000 Transportation Development Tax $ - $ - $ - $ - $ - 410 0000 Traffic Impact Fee $ - $ - $ - $ - $ - 411 0000 Underground Utility Fund $ - $ - $ - $ - $ - 412 0000 Street Maintenance Fee Fund $ - $ - $ - $ - $ - 420 0000 Parks Capital Fund $ - $ - $ - $ - $ - 421 0000 Parks Bond Fund $ - $ - $ - $ - $ - 425 0000 Parks SDC Fund $ - $ - $ - $ - $ - 460 0000 Transportation CIP Fund $ - $ - $ - $ - $ - 500 6600 Sanitary Sewer Fund $ - $ - $ - $ - $ - 510 6700 StowaterFund $ - $ - $ - $ - $ - 511 0000 Water Quality/Quantity Fund $ - $ - $ - $ - $ - 530 6500 Water Fund $ - $ - $ - $ - $ - 531 0000 WaterSDC Fund $ - $ - $ - $ - $ - 532 0000 Water CIP Fund $ - $ - $ - $ - $ - 533 0000 Water Debt Service Fund $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Elections Supervisor $ - $ - $ - $ - $ - 600 2000 Fin&Info Styes-Passports/Business Licensi $ - $ - $ - $ - $ - 660 0000 Insurance Fund $ - $ - $ - $ - $ - 930 0000 Urban Renewal Debt Srvc $ - $ - $ - $ - $ - 940 9000 Urban Renewal Cap Improvements $ - $ - $ - $ - $ - 510 6260 Healthy Streams $ - $ - $ - $ - $ - Other Jurisdictions $ - $ - $ - $ - $ - �I $ - $ - II $ - $ - II $ - Check O.K. Check O.K. Check O.K. Check O.K. Check O.K. Common Areas I I I I I I Grand Total Sq Ft 48,001 1,980 5,940 7/31/2013 Appendix B-Page 11 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet Facilities 100 0500 Mayor&Council $ - 600 1000 City Mngmnt-City Manager $ - 600 1000 City Mngmnt-Web Services $ - 600 1100 Human Resources $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - 600 1200 Risk Mngmnt-Claims&Misc $ - 600 1300 Design&Comm-Mail $ - 600 1300 Design&Comm-Graphics $ - 600 1300 Design&Comm-Copiers $ - 600 1500 Recorder/Records-Records Management $ - 600 1500 Recorder/Records-Council Support $ - 600 1500 Recorder/Records-Records Requests $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - 600 2100 Fin Ops-Accounting/GL $ - 600 2100 Fin Ops-AP $ - 600 2100 Fin Ops-Payroll $ - 600 2200 Utility Billing-Billing $ - 600 2200 Utility Billing-Meter Reading $ - 600 2300 IT-Support $ - 600 2300 IT-GIS $ - 600 2500 Contracts and Purchasing $ - 650 6300 Fleet Maintenance $ - 650 6400 Property Management $ - $ - 100 1400 Municipal Court $ - 100 3000 Community Development Admin $ - 230 3100 Building $ - 100 3200 Development Services $ - 100 3300 Community Planning $ - 100 3700 Downtown Redevelopment $ - 100 4000 Po lice Administration $ - 100 4100 Police Operations $ - 100 4200 Support Services $ - 100 5000 Library Administration $ - 100 5100 Library Readers'Services $ - 100 5200 Library Technical Services $ - 100 5300 Library Circulation $ - 100 5900 Social Svcs&Community Events $ - 100 6000 Public Works Administration $ - 100 6100 Parks&Grounds $ - 200 6200 Street Maintenance $ - 100 6250 Project Engineering $ - 100 0000 CIP/Transfers/Contingency $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - 205 0000 City Gas Tax Fund $ - 220 0000 Electrical Inspection Fund $ - 240 0000 Criminal Forfeiture Fund $ - 260 0000 Urban Forestry Fund $ - 300 0000 Bancroft Debt Service Fund $ - 350 0000 GO Debt Service Fund $ - 400 0000 Facilities Fund $ - 405 0000 Transportation Development Tax $ - 410 0000 Traffic Impact Fee $ - 411 0000 Underground Utility Fund $ - 412 0000 Street Maintenance Fee Fund $ - 420 0000 Parks Capital Fund $ - 421 0000 Parks Bond Fund $ - 425 0000 Parks SDC Fund $ - 460 0000 Transportation CIP Fund $ - 500 6600 Sanitary Sewer Fund $ - 510 6700 Stomiwater Fund $ - 511 0000 Water Quality/Quantity Fund $ - 530 6500 Water Fund $ - 531 0000 WaterSDC Fund $ - 532 0000 Water CIP Fund $ - 533 0000 Water Debt Service Fund $ - 600 1500 Recorder/Records-Elections Supervisor $ - 600 2000 Fin&Info Srvcs-Passports/Business Licensir$ - 660 0000 Insurance Fund $ - 930 0000 Urban Renewal Debt Srvc $ - 940 9000 Urban Renewal Cap Improvements $ - 510 6260 Healthy Streams $ - Other Jurisdictions $ - $ - Check O.K. Common Areas Grand Total Sq Ft 7/31/2013 Appendix B-Page 12 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet Goon Pain,Panno G.nU Ash Street(Old Public Works Bldg) PW Building Park Rest Room,Sumn Shops,Wind Mill,Zuber Hr Pron. So Ft De.r Facilities Sq Ft De.r Facilities Sq Ft De r 17,438 III 10,064 100 0500 Mayor&Council $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager $ - $ - $ - $ - $ - 600 1000 City Mngmnt-Web Services $ _ s - $ - $ - $ - 600 1100 Human Resources $ - - $ - $ - $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ - $ - $ - $ - $ - 600 1300 Design&Comm-Mail $ - $ - $ - $ - $ - 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - $ - $ - $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - $ - $ - $ - 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - 600 2100 Fin Ops-AP $ - $ - $ - $ - $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading $ - $ - $ - $ - $ - 600 2300 IT-Support $ - $ - $ - $ - $ - 600 2300 IT-GIS $ - $ - $ - $ - $ - 600 2500 Contracts and Purchasing $ - $ - $ - $ - $ - 650 6300 Fleet Maintenance $ - $ - $ - $ - $ - 650 6400 Property Management 3.825 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 100 1400 Municipal Court $ - $ - $ - $ - $ - 100 3000 Community Development Admin $ - $ - $ - $ - $ - 230 3100 Building $ - $ - $ - $ - $ - 100 3200 Development Services $ - $ - $ - $ - $ - 100 3300 Community Planning $ - $ - $ - $ - $ - 100 3700 Downtown Redevelopment $ - $ - $ - $ - $ - 100 4000 Police Administration $ - $ - $ - $ - $ - 100 4100 Police Operations $ - $ - $ - $ - $ - 100 4200 Support Services $ - $ - $ - $ - $ - 100 5000 Library Administration $ - $ - $ - $ - $ - 100 5100 Library Readers'Services $ - $ - $ - $ - $ - 100 5200 Library Technical Services $ - $ - $ - $ - $ - 100 5300 Library Circulation $ - $ - $ - $ - $ - 100 5900 Social Svcs&Community Events $ - $ - $ - $ - $ - 100 6000 Public Works Administration 4,962 $ - $ - $ - $ - $ - 100 6100 Parks&Grounds 3,920 $ - $ - $ - $ - $ - 200 6200 Street Maintenance 4,5:: $ - $ - $ - $ - $ - 100 6250 Project Engineering $ - $ - $ - $ - $ - 100 0000 CIP/Transfers/Contingency $ - $ - $ - $ - $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - $ - $ - $ - $ - 205 0000 City Gas Tax Fund $ - $ - $ - $ - - 220 0000 Electrical Inspection Fund $ - $ - $ - $ - - 240 0000 Criminal Forfeiture Fund $ - $ - $ - $ - $ - 260 0000 Urban Forestry Fund $ - $ - $ - $ - $ - 300 0000 Bancroft Debt Service Fund $ - $ - $ - $ - $ - 350 0000 GO Debt Service Fund $ - $ - $ - $ - $ - 400 0000 Facilities Fund $ - $ - $ - $ - $ - 405 0000 Transportation Development Tax $ - $ - $ - $ - $ - 410 0000 Traffic Impact Fee $ - $ - $ - $ - $ - 411 0000 Underground Utility Fund $ - $ - $ - $ - $ - 412 0000 Street Maintenance Fee Fund $ - $ - $ - $ - $ - 420 0000 Parks Capital Fund $ - $ - $ - $ - $ - 421 0000 Parks Bond Fund $ - $ - $ - $ - $ - 425 0000 Parks SDC Fund $ - $ - $ - $ - $ - 460 0000 Transportation CIP Fund $ - $ - $ - $ - $ - 500 6600 Sanitary Sewer Fund $ - $ - 2,081 $ - $ - $ - 510 6700 Stomiwater Fund $ - $ - 1,187 $ - $ - $ - 511 0000 Water Quality/Quantity Fund $ - $ - $ - $ - $ - 530 6500 Water Fund $ - $ - 2,553 $ - $ - $ - 531 0000 WaterSDC Fund $ - $ - $ - $ - $ - 532 0000 Water CIP Fund $ - $ - $ - $ - $ - 533 0000 Water Debt Service Fund $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Elections Supervisor $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Passports/Business Licensi $ - $ - $ - $ - $ - 660 0000 Insurance Fund $ - $ - $ - $ - $ - 930 0000 Urban Renewal Debt Srvc $ - $ - $ - $ - $ - 940 9000 Urban Renewal Cap Improvements $ - $ - $ - $ - $ - 510 6260 Healthy Streams $ - $ - $ - $ - $ - Other Jurisdictions $ - $ - $ - $ - $ - II $ - 1$ - II $ - $ - II $ - Check O.K. Check O.K. Check O.K. Check O.K. Check O.K. Common Areas I 1,4001 1 7,9031 I 1 Grand Total Sq Ft 18,838 17,967 1 7/31/2013 Appendix B-Page 13 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet us e,S na ie ner Lake )use,Cashe Facilities 100 0500 Mayor&Council $ - 600 1000 City Mngmnt-City Manager $ - 600 1000 City Mngmnt-Web Services $ - 600 1100 Human Resources $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - 600 1200 Risk Mngmnt-Claims&Misc $ - 600 1300 Design&Comm-Mail $ - 600 1300 Design&Comm-Graphics $ - 600 1300 Design&Comm-Copiers $ - 600 1500 Recorder/Records-Records Management $ - 600 1500 Recorder/Records-Council Support $ - 600 1500 Recorder/Records-Records Requests $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - 600 2100 Fin Ops-Accounting/GL $ - 600 2100 Fin Ops-AP $ - 600 2100 Fin Ops-Payroll $ - 600 2200 Utility Billing-Billing $ - 600 2200 Utility Billing-Meter Reading $ - 600 2300 IT-Support $ - 600 2300 IT-GIS $ - 600 2500 Contracts and Purchasing $ - 650 6300 Fleet Maintenance $ - 650 6400 Property Management $ - $ - 100 1400 Municipal Court $ - 100 3000 Community Development Admin $ - 230 3100 Building $ - 100 3200 Development Services $ - 100 3300 Community Planning $ - 100 3700 Downtown Redevelopment $ - 100 4000 Police Administration $ - 100 4100 Police Operations $ - 100 4200 Support Services $ - 100 5000 Library Administration $ - 100 5100 Library Readers'Services $ - 100 5200 Library Technical Services $ - 100 5300 Library Circulation $ - 100 5900 Social Svcs&Community Events $ - 100 6000 Public Works Administration $ - 100 6100 Parks&Grounds $ - 200 6200 Street Maintenance $ - 100 6250 Project Engineering $ - 100 0000 CIP/Transfers/Contingency $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - 205 0000 City Gas Tax Fund $ - 220 0000 Electrical Inspection Fund $ - 240 0000 Criminal Forfeiture Fund $ - 260 0000 Urban Forestry Fund $ - 300 0000 Bancroft Debt Service Fund $ - 350 0000 GO Debt Service Fund $ - 400 0000 Facilities Fund $ - 405 0000 Transportation Development Tax $ - 410 0000 Traffic Impact Fee $ - 411 0000 Underground Utility Fund $ - 412 0000 Street Maintenance Fee Fund $ - 420 0000 Parks Capital Fund $ - 421 0000 Parks Bond Fund $ - 425 0000 Parks SDC Fund $ - 460 0000 Transportation CIP Fund $ - 500 6600 Sanitary Sewer Fund $ - 510 6700 StormwaterFund $ - 511 0000 Water Quality/Quantity Fund $ - 530 6500 Water Fund $ - 531 0000 WaterSDC Fund $ - 532 0000 Water CIP Fund $ - 533 0000 Water Debt Service Fund $ - 600 1500 Recorder/Records-Elections Supervisor $ - 600 2000 Fin&Info Srvcs-Passports/Business Licensir$ - 660 0000 Insurance Fund $ - 930 0000 Urban Renewal Debt Srvc $ - 940 9000 Urban Renewal Cap Improvements $ - 510 6260 Healthy Streams $ - Other Jurisdictions $ - $ - Check O.K. Common Areas Grand Total Sq Ft 7/31/2013 Appendix B-Page 14 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet Police Dept Annex PD Storage Senior Center Sq Ft De.r Facilities Sq Ft De.r Facilities Sq Ft De r 2,652 III 2,820 11. 7,718 100 0500 Mayor&Council $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager $ - $ - $ - $ - $ - 600 1000 City Mngmnt-Web Services $ $ $ - $ - $ - 600 1100 Human Resources $ - - $ - $ - $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ - $ - $ - $ - $ - 600 1300 Design&Comm-Mail $ - $ - $ - $ - $ - 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - $ - $ - $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - $ - $ - $ - 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - 600 2100 Fin Ops-AP $ - $ - $ - $ - $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading $ - $ - $ - $ - $ - 600 2300 IT-Support $ - $ - $ - $ - $ - 600 2300 IT-GIS $ - $ - $ - $ - $ - 600 2500 Contracts and Purchasing $ - $ - $ - $ - $ - 650 6300 Fleet Maintenance $ - $ - $ - $ - - 650 6400 Property Management $ - $ - $ - $ - - $ - $ - $ - $ - $ - 100 1400 Municipal Court $ - $ - $ - $ - $ - 100 3000 Community Development Admin $ - $ - $ - $ - $ - 230 3100 Building $ - $ - $ - $ - $ - 100 3200 Development Services $ - $ - $ - $ - $ - 100 3300 Community Planning $ - $ - $ - $ - $ - 100 3700 Downtown Redevelopment $ - $ - $ - $ - $ - 100 4000 Police Administration $ - $ - $ - $ - $ - 100 4100 Police Operations $ - $ - $ - $ - $ - 100 4200 Support Services $ - $ - $ - $ - $ - 100 5000 Library Administration $ - $ - $ - $ - $ - 100 5100 Library Readers'Services $ - $ - $ - $ - $ - 100 5200 Library Technical Services $ - $ - $ - $ - $ - 100 5300 Library Circulation $ - $ - $ - $ - $ - 100 5900 Social Svcs&Community Events $ - $ - $ - $ - $ - 100 6000 Public Works Administration $ - $ - $ - $ - $ - 100 6100 Parks&Grounds $ - $ - $ - $ - $ - 200 6200 Street Maintenance $ - $ - $ - $ - $ - 100 6250 Project Engineering $ - $ - $ - $ - $ - 100 0000 CIP/Transfers/Contingency $ - $ - $ - $ - $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - $ - $ - $ - $ - 205 0000 City Gas Tax Fund $ - $ - $ - $ - $ - 220 0000 Electrical Inspection Fund $ - $ - $ - $ - $ - 240 0000 Criminal Forfeiture Fund $ - $ - $ - $ - $ - 260 0000 Urban Forestry Fund $ - $ - $ - $ - $ - 300 0000 Bancroft Debt Service Fund $ - $ - $ - $ - $ -_ __0000 GO Debt Service Fund $ - $ - $ - $ - - 400 0000 Facilities Fund $ - $ - $ - $ - - 405 0000 Transportation Development Tax $ - $ - $ - $ - $ - 410 0000 Traffic Impact Fee $ - $ - $ - $ - $ - 411 0000 Underground Utility Fund $ - $ - $ - $ - $ - 412 0000 Street Maintenance Fee Fund $ - $ - $ - $ - $ - 420 0000 Parks Capital Fund $ - $ - $ - $ - $ - 421 0000 Parks Bond Fund $ - $ - $ - $ - $ - 425 0000 Parks SDC Fund $ - $ - $ - $ - $ - 460 0000 Transportation CIP Fund $ - $ - $ - $ - $ - 500 6600 Sanitary Sewer Fund $ - $ - $ - $ - $ - 510 6700 Stormwater Fund $ - $ - $ - $ - $ - 511 0000 Water Quality/Quantity Fund $ - $ - $ - $ - $ - 530 6500 Water Fund $ - $ - $ - $ - $ - 531 0000 WaterSDC Fund $ - $ - $ - $ - $ - 532 0000 Water CIP Fund $ - $ - $ - $ - $ - 533 0000 Water Debt Service Fund $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Elections Supervisor $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Passports/Business Licensi $ - $ - $ - $ - $ - 660 0000 Insurance Fund $ - $ - $ - $ - $ - 930 0000 Urban Renewal Debt Srvc $ - $ - $ - $ - $ - 940 9000 Urban Renewal Cap Improvements $ - $ - $ - $ - $ - 510 6260 Healthy Streams $ - $ - $ - $ - $ - Other Jurisdictions $ - $ - $ - $ - $ - II $ - 1$ - II $ - $ - II $ - Check O.K. Check O.K. Check O.K. Check O.K. Check O.K. Common Areas I I I I I I Grand Total Sq Ft 2,652 2,820 7,718 7/31/2013 Appendix B-Page 15 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet Facilities 100 0500 Mayor&Council $ - 600 1000 City Mngmnt-City Manager $ - 600 1000 City Mngmnt-Web Services $ - 600 1100 Human Resources $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - 600 1200 Risk Mngmnt-Claims&Misc $ - 600 1300 Design&Comm-Mail $ - 600 1300 Design&Comm-Graphics $ - 600 1300 Design&Comm-Copiers $ - 600 1500 Recorder/Records-Records Management $ - 600 1500 Recorder/Records-Council Support $ - 600 1500 Recorder/Records-Records Requests $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - 600 2100 Fin Ops-Accounting/GL $ - 600 2100 Fin Ops-AP $ - 600 2100 Fin Ops-Payroll $ - 600 2200 Utility Billing-Billing $ - 600 2200 Utility Billing-Meter Reading $ - 600 2300 IT-Support $ - 600 2300 IT-GIS $ - 600 2500 Contracts and Purchasing $ - 650 6300 Fleet Maintenance $ - 650 6400 Property Management $ - $ - 100 1400 Municipal Court $ - 100 3000 Community Development Admin $ - 230 3100 Building $ - 100 3200 Development Services $ - 100 3300 Community Planning $ - 100 3700 Downtown Redevelopment $ - 100 4000 Po lice Administration $ - 100 4100 Police Operations $ - 100 4200 Support Services $ - 100 5000 Library Administration $ - 100 5100 Library Readers'Services $ - 100 5200 Library Technical Services $ - 100 5300 Library Circulation $ - 100 5900 Social Svcs&Community Events $ - 100 6000 Public Works Administration $ - 100 6100 Parks&Grounds $ - 200 6200 Street Maintenance $ - 100 6250 Project Engineering $ - 100 0000 CIP/Transfers/Contingency $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - 205 0000 City Gas Tax Fund $ - 220 0000 Electrical Inspection Fund $ - 240 0000 Criminal Forfeiture Fund $ - 260 0000 Urban Forestry Fund $ - 300 0000 Bancroft Debt Service Fund $ - 350 0000 GO Debt Service Fund $ - 400 0000 Facilities Fund $ - 405 0000 Transportation Development Tax $ - 410 0000 Traffic Impact Fee $ - 411 0000 Underground Utility Fund $ - 412 0000 Street Maintenance Fee Fund $ - 420 0000 Parks Capital Fund $ - 421 0000 Parks Bond Fund $ - 425 0000 Parks SDC Fund $ - 460 0000 Transportation CIP Fund $ - 500 6600 Sanitary Sewer Fund $ - 510 6700 Stomiwater Fund $ - 511 0000 Water Quality/Quantity Fund $ - 530 6500 Water Fund $ - 531 0000 WaterSDC Fund $ - 532 0000 Water CIP Fund $ - 533 0000 Water Debt Service Fund $ - 600 1500 Recorder/Records-Elections Supervisor $ - 600 2000 Fin&Info Srvcs-Passports/Business Licensir$ - 660 0000 Insurance Fund $ - 930 0000 Urban Renewal Debt Srvc $ - 940 9000 Urban Renewal Cap Improvements $ - 510 6260 Healthy Streams $ - Other Jurisdictions $ - $ - Check O.K. Common Areas Grand Total Sq Ft 7/31/2013 Appendix B-Page 16 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Sq Ft Spreadsheet Canterbury Building i otai racurties Prop Mngmt Total Sq Ft Der Facilities Cost Depreciation Total Sq Ft 4,321 - $ - 122,893 100 0500 Mayor&Council $ $ _ $ - 600 1000 City Mngmnt-City Manager $ - $ - $ - 352 600 1000 City Mngmnt-Web Services $ - $ - _ $ - 600 1100 Human Resources $ - - - $ - 597 600 1200 Risk Mngmnt-Insurance Premiums $ $ _ $ - 600 1200 Risk Mngmnt-Claims&Misc $ - $ - _ $ - 513 600 1300 Design&Comm-Mail $ - $ - _ $ - 404 600 1300 Design&Comm-Graphics $ - $ - _ $ - _ 600 1300 Design&Comm-Copiers $ - $ - _ $ - 600 1500 Recorder/Records-Records Management $ - $ - _ $ - 461 600 1500 Recorder/Records-Council Support $ - $ - _ $ - 600 1500 Recorder/Records-Records Requests $ - $ $ - 263 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - - $ - 327 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - - S - 896 600 2100 Fin Ops-Accounting/GL $ - $ - - S - - 600 2100 Fin Ops-AP $ - $ - - S - - 600 2100 Fin Ops-Payroll $ - $ - - S - 600 2200 Utility Billing-Billing $ - $ - - S - 1,528 600 2200 Utility Billing-Meter Reading $ - $ - - S - 600 2300 IT-Support $ - $ - - S - 5,940 600 2300 IT-GIS $ - $ - - S - 600 2500 Contracts and Purchasing $ - $ - - S - 400 650 6300 Fleet Maintenance $ - $ - - S - 2,352 650 6400 Property Management $ - $ - - $ - 3,825 $ - $ - - $ - 100 1400 Municipal Court $ - $ - - $ - 570 100 3000 Community Development Admin $ - $ - - $ - 230 3100 Building $ - $ - - $ - 1,338 100 3200 Development Services $ - - - $ - 908 100 3300 Community Planning $ - $ - - $ - 632 100 3700 Downtown Redevelopment $ - $ - - $ - 107 100 4000 Police Administration $ - $ - - $ - 4,048 100 4100 Police Operations $ - $ - - $ - 14,055 100 4200 Support Services $ - $ - - $ - - 100 5000 Library Administration $ - $ - - $ - 2,227 100 5100 Library Readers'Services $ - $ - - $ - 30,186 100 5200 Library Technical Services $ - $ - - $ - 4,454 100 5300 Library Circulation $ - $ - - $ - 11,134 100 5900 Social Svcs&Community Events $ - $ - - $ - 7,718 100 6000 Public Works Administration $ - $ - - $ - 10,936 100 6100 Parks&Grounds $ - $ - - $ - 4,159 200 6200 Street Maintenance $ - $ - - $ - 4,588 100 6250 Project Engineering $ - $ - - $ - 2,011 100 0000 CIP/Transfers/Contingency $ - $ - - $ - - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - $ - - $ - - 205 0000 City Gas Tax Fund $ - $ - - $ - - 220 0000 Electrical Inspection Fund $ - $ - - $ - - 240 0000 Criminal Forfeiture Fund $ - $ - - $ - - 260 0000 Urban Forestry Fund $ - $ - - $ - - 300 0000 Bancroft Debt Service Fund $ - $ - - $ - - 350 0000 GO Debt Service Fund $ - $ - - $ - - 400 0000 Facilities Fund $ - $ - - $ - - 405 0000 Transportation Development Tax $ - $ - - $ - - 410 0000 Traffic Impact Fee $ - $ - - $ - - 411 0000 Underground Utility Fund $ - $ - - $ - - 412 0000 Street Maintenance Fee Fund $ - $ - - $ - - 420 0000 Parks Capital Fund $ - $ - - $ - - 421 0000 Parks Bond Fund $ - $ - - $ - - 425 0000 Parks SDC Fund $ - $ - - $ - - 460 0000 Transportation CIP Fund $ - $ - - $ 500 6600 Sanitary Sewer Fund $ - $ - - $ - 2,081 510 6700 StormwaterFund $ - $ - - $ - 1,187 511 0000 Water Quality/Quantity Fund $ - $ - - $ 530 6500 Water Fund $ - $ - - $ - 2,696 531 0000 WaterSDC Fund $ - $ - - $ - - 532 0000 Water CIP Fund $ - $ - - $ - _- 533 0000 Water Debt Service Fund $ - $ - - $ - 600 1500 Recorder/Records-Elections Supervisor $ - $ - - $ - - 600 2000 Fin&Info Srvcs-Passports/Business Licensi $ - $ - - $ - - 660 0000 Insurance Fund $ - $ - - $ - - 930 0000 Urban Renewal Debt Srvc $ - $ - - $ - - 940 9000 Urban Renewal Cap Improvements $ - $ - - S - - 510 6260 Healthy Streams $ - $ - - $ - - Other Jurisdictions $ - $ - - $ - - II $ - I$ - I - I 1$ - I I 122,893 Check O.K. Check O.K. Check O.K. Check O.K. Check O.K. Common Areas Grand Total Sq Ft 4,321 7/31/2013 Appendix B-Page 17 of 53 Tigard ICAP Budget 2014-Budget System Load Indirect Cost Model for the FY 2013-14 Budget Year Shared Copiers Copier Expense Spreadsheet Mailroom Color Copier City Hall B/W Copier Copies Rental Maint. Copies Rental Maint. 167,150 $2,692.68 I$3,933.81 62,165 $4,081.00 $ 245.98 100 0500 Mayor&Council 16,264 $ 262 $ 383 27,129 $1,780.96 $ 10735 600 1000 City Mngmnt-City Manager 8,358 $ 135 $ 197 5,893 $ 386.86 $ 2332 600 1000 City Mngmnt-Web Services $ - $ - $ - $ - 600 1100 Human Resources 786 $ 13 $ 18 2,350 $ 15427 $ 930 600 1200 Risk Mngmnt-Insurance Premiums 451 $ 7 $ 11 19 $ 125 $ 0.08 600 1200 Risk Mngmnt-Claims&Misc $ - $ - $ - $ - 600 1300 Design&Comm-Mail 5,900 $ 95 $ 139 379 $ 24.88 $ 1.50 600 1300 Design&Comm-Graphics $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management 29,569 $ 47634 $ 695.89 6,925 $ 454.61 $ 27.40 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP 13,890 $ 223.76 $ 326.90 5,017 $ 32936 $ 19.85 600 2100 Fin Ops-Fin Rprting/Mngmnt 1,120 $ 18.04 $ 2636 1,026 $ 6735 $ 4.06 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - 600 2100 Fin Ops-AP $ - $ - $ - $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - 600 2200 Utility Billing-Billing 2 741 $ 44.16 $ 64.51 8,299 $ 544.81 $ 32.84 600 2200 Utility Billing-Meter Reading $ - $ - $ - $ - 600 2300 IT-Support $ - $ - 168 $ 11.03 $ 0.66 600 2300 IT- GIS $ - $ - $ - $ - 600 2500 Contracts and Purchasing 5,315 $ 85.62 $ 125.09 721 $ 4733 $ 2.85 650 6300 Fleet Maintenance $ - $ - $ - $ - 650 6400 Property Management 17 $ 027 $ 0.40 $ - $ - $ - $ - $ - $ - 100 1400 Municipal Court 535 $ 8.62 $ 12.59 814 $ 53.44 $ 322 100 3000 Community Development Admin 669 $ 10.78 $ 15.74 31 $ 2.04 $ 0.12 230 3100 Building $ - $ - 25 $ 1.64 $ 0.10 100 3200 Development Services 2,190 $ 3528 $ 51.54 224 $ 14.71 $ 0.89 100 3300 Community Planning 46,517 $ 74936 $1,094.76 1,908 $ 12526 $ 7.55 100 3700 Downtown Redevelopment 217 $ 3.50 $ 5.11 6 $ 039 $ 0.02 100 4000 Police Administration 1,488 $ 23.97 $ 35.02 $ - $ - 100 4100 Police Operations $ - $ - 37 $ 2.43 $ 0.15 100 4200 Support Services 6,084 $ 98.01 $ 143.18 25 $ 1.64 $ 0.10 100 5000 Library Administration 16,180 $ 260.65 $ 380.79 112 $ 735 $ 0.44 100 5100 Library Readers'Services $ - $ - $ - $ - 100 5200 Library Technical Services $ - $ - $ - $ - 100 5300 Library Circulation $ - $ - $ - $ - 100 5900 Social Svcs&Community Events $ - $ - $ - $ - 100 6000 Public Works Administration 2,357 $ 37.97 $ 55.47 50 $ 328 $ 020 100 6100 Parks&Grounds $ - $ - $ - $ - 200 6200 Street Maintenance $ - $ - $ - $ - 100 6250 Project Engineering 6,502 $ 104.74 $ 153.02 1,007 $ 66.11 $ 3.98 100 0000 CIP/Transfers/Contingency $ - $ - $ - $ - 200 6800 Gas Tax Fund(Street Lights&Signals) $ - $ - $ - $ - 205 0000 City Gas Tax Fund $ - $ - $ - $ - 220 0000 Electrical Inspection Fund $ - $ - $ - $ - 240 0000 Criminal Forfeiture Fund - - - 260 0000 Urban Forestry Fund $ - $ - $ - $ - 300 0000 Bancroft Debt Service Fund $ - $ - $ - $ - 350 0000 GO Debt Service Fund $ - $ - $ - $ - 400 0000 Facilities Fund $ - $ - $ - $ - 405 0000 Transportation Development Tax $ - $ - $ - $ - 410 0000 Traffic Impact Fee $ - $ - $ - $ - 411 0000 Underground Utility Fund $ - $ - $ - $ - 412 0000 Street Maintenance Fee Fund $ - $ - $ - $ - 420 0000 Parks Capital Fund $ - $ - $ - $ - 421 0000 Parks Bond Fund $ - $ - $ - $ - 425 0000 Parks SDC Fund $ - $ - $ - $ - 460 0000 Transportation CIP Fund $ - $ - $ - $ - 500 6600 Sanitary Sewer Fund $ - $ - $ - $ - 510 6700 Stormwater Fund $ - $ - $ - $ - 511 0000 Water Quality/Quantity Fund $ - $ - $ - $ - 530 6500 Water Fund $ - $ - $ - $ - 531 0000 Water SDC Fund $ - $ - $ - $ - 532 0000 Water CIP Fund $ - $ - $ - $ - 533 0000 Water Debt Service Fund $ - $ - $ - $ - 600 1500 Recorder/Records-Elections Supervisor $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Passports/Business Licensing $ - $ - $ - $ - 660 0000 Insurance Fund $ - $ - $ - $ - 930 0000 Urban Renewal Debt Srvc $ - $ - $ - $ - 940 9000 Urban Renewal Cap Improvements $ - $ - $ - $ - 510 6260 Healthy Streams $ - $ - $ - $ - Other Jurisdictions $ - $ - $ - $ - II $2,692.68 $ 3,934 11 $ 4,081 $ 246 Check O.K. Check O.K. Check O.K. Check O.K. 7/31/2013 Appendix C-Page 18 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Yi Allocation Factors Municipal Court 100 1400 Community Development Admin 100 3000 Building 230 3100 Development Services 100 3200 Community Planning 100 3300 Downtown Redevelopment 100 3700 Police Administration 100 4000 Police Operations 100 4100 Support Services 100 4200 Library Administration 100 5000 Library Readers'Services 100 5100 Library Technical Services 100 5200 Library Circulation 100 5300 Social Svcs&Community Events 100 5900 Public Works Administration 100 6000 Parks&Grounds 100 6100 Street Maintenance 200 6200 Project Engineering 100 6250 CIP/Transfers/Contingency 100 8000 Gas Tax Fund(Street Lights&Signals) 200 6800 City Gas Tax Fund 205 7000 Electrical Inspection Fund 220 8000 Criminal Forfeiture Fund 240 0000 a) Urban Forestry Fund 260 0000 E Bancroft Debt Service Fund 300 0000 Q- GO Debt Service Fund 350 0000 a) o Facilities Fund 400 0000 15 Transportation Development Tax 405 0000 o Traffic Impact Fee 410 0000 Underground Utility Fund 411 0000 Street Maintenance Fee Fund 412 0000 Parks Capital Fund 4201.0000 Parks Bond Fund 421 0000 Parks SDC Fund 425 0000 Transportation CIP Fund 460 8000 Sanitary Sewer Fund 500 6600 Stormwater Fund 510 6700 Water Quality/Quantity Fund 511 0000 Water Fund 530 6500 Water SDC Fund 531 8000 Water CIP Fund 532 0000 Water Debt Service Fund 53 0000 Recorder/Records-Elections Supervisor 600 1500 Fin&Info Srvcs-Passports/Business Licensing 600 2000 Insurance Fund 660 0000 Urban Renewal Debt Srvc MO 0000 Urban Renewal Cap Improvements 940 9000 Healthy Streams 510 6260 Other Jurisdictions All Other 7/31/2013 Section VI -Page 19 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Citywide Indirect Cost Pool Summary FY 2013-14 Proposed Budget Total Citywide A. to ineligible Net total Total Citywide 87 Allocable indirect cost Citywide A-87 Fund Dept# Department-Division -Function !Allocable Costs Costs pools allocated cost 100 0500 Mayor&Council $ 283,092 $ 283,092 $ - $ 283,092 600 1000 City Mngmnt-City Manager $ 624,074 $ 624,074 $ ;; $ 624,074 600 1000 City Mngmnt-Web Services $ 103,521 $ 103,521 III 11 $ 103,521 600 1100 Human Resources $ 734,804 $ 731,864 $ ;; $ 731,864 600 1200 Risk Mngmnt-Insurance Premiums $ 327,402 $ 327,402 $ ;; $ 327,402 600 1200 Risk Mngmnt-Claims&Misc $ 265,965 $ 265,965 $ ;; $ 265,965 600 1300 Design&Comm-Mail $ 128,447 $ 128,447 ,;;u ;; $ 128,447 600 1300 Design&Comm-Graphics $ 295,869 $ 295,869 i ;; $ 295,869 600 1300 Design&Comm-Copiers $ 56,144 $ 56,144 ;; $ 56,144 600 1500 Recorder/Records-Records Management $ 207,414 $ 207,414 ° 011111 ;; $ 207,414 600 1500 Recorder/Records-Council Support $ 161,676 $ 161,676 $ I ;; $ 161,676 600 1500 Recorder/Records-Records Requests $ 13,573 $ 13,573 $ ;; $ 13,573 600 2000 Fin&Info Srvcs-Budget/CIP $ 124,839 $ 124,839 $ ;; $ 124,839 600 2100 Fin Ops-Fin Rprting/Mngmnt $ 156,848 $ 156,848 ;; $ 156,848 600 2100 Fin Ops-Accounting/GL $ 263,996 $ 263,996 $ y ;; $ 263,996 600 2100 Fin Ops-AP $ 108,976 $ 108,976 $ ;; $ 108,976 600 2100 Fin Ops-Payroll $ 118,050 $ 118,050 $ ;; $ 118,050 600 2200 Utility Billing-Billing $ 590,318 $ 590,318 0 ,;;E ;; $ 590,318 600 2200 Utility Billing-Meter Reading $ 298,972 $ 298,972 p, y ;; $ 298,972 600 2300 IT-Support $ 1,206,027 $ 1,206,027 $ ;; $ ,206,027 600 2300 IT- GIS $ 349,634 $ 349,634 OE ;; $ 349,634 600 2500 Contracts and Purchasing $ 227,881 $ 227,881 $ y 11 $ 227,881 650 6300 Fleet Maintenance $ 213,867 $ 213,867 $ y ;; $ 213,867 650 6400 Property Management $ 1,435,350 $ 1,427,030 $ iii111111111111111,1iii $ 1,427,030 Grand Total I I $ 8,296,738 4. 8,285,478 4. IIIIIIIIIMI 8,285,478 7/31/2013 Section V- Page 20 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Mayor&Council FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - IIIP - $ - $ IIIII11IIIIIIIIIIIIIIIIIIIIIII1'1'III 11115 - Remove indirect charges $ $ $ - Illh - Indirect charges from previous years cost plan Total from Worksheet $ 283,092 $ 283,092 $ 283,092 $ - IN 283,092 See Appendix A (Total $ 283,092 $ - $ 283,092 $ - II$ 283,092 II$ - I mg 283,092 II City Mngmnt-City Manager FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - _ $ - $ R $ - — $ - $ 111111111111111111111111111111ii551$ 11111111111111111111111111111111111 $ $ $ $ $ $ i $ $ $ $ $ $ $ $ $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ i $ $ 11111111111 MB $ - $ - $ III,,-_. - Total from Worksheet $ 624,074 $ 624,074 $ 624,074 $ - $ '''- 624,074 See Appendix A (Total $ 624,074 $ - $ 624,074 $ - II$ 624,074 II$ - II$ 624,074 II 7/31/2013 Section V-Page 21 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off City Mngmnt-Web Services FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - III - $ - $ 11111111 1111111111111111111111111111 $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIiiIIL$ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIiiIIL$ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIiiIIL$ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIiiIIL$ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIiiIIL$ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIiiIIL$ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIiiIIL.......... 11111 - Total from Worksheet $ 103,521 $ 103,521 $ 103,521 $ - IN 103,521 See Appendix A Total $ 103,521 $ - $ 103,521 $ - 11$ 103,521 II$ - I mg 103,521 II Human Resources FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $ 734,804 $ 734,804 $ 734,804 $ 734,804 Remove Advertising Costs $ - $ - $ VIII - Unallowable according to A87 guidelines Remove Dues Costs $ - $ - $ (2•'• =11II1 (2,940) Unallowable according to A87 guidelines $ $ 9IIIIII1 - $ $ $ IIIIIIIIIIIIII $ $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII $ $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII $ $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII $ $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII $ $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII $ $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII $ $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIII'1 $ $ $ IIIIIIIIIIIIIIIIIII Total from Worksheet $ - $ - $ - 1Total $ 734,804 $ - $ 734,804 $ - 11$ 734,804 II$ (2,940)11$ 731,864 II 7/31/2013 Section V-Page 22 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Risk Mngmnt-Insurance Premiums FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: General Liability $ 195,795 $ 195,795_ $ 195,795 $ IIIII 195,795 Premium costs for FY 2012 Auto Liability&Physical Damage $ 59,508 $ 59,508_ $ 59,508 $ 1 59,508 Property/Inland Marine $ 105,926 $ 105,926 $ 2,283 $ 108,209 $ IIIII' 108,209 Moved flood insurance to property insurance All Other $ 10,767 $ 10,767 $ (2,283) $ 8,484 $ IIIII' 8,484 Insurance discount $ (44,594) $ (44,594) $ (44,594) $ 1111 44,594) Discount provided to City by insurer $ $ _- $ lllllllllllllllllll M. _ $ $ $ lllllllllllllllllll ll $ - $ - $ 1111111111111111111111E 1 $ - $ - $ IIIIIIIIIIIIIIIIIIIII _ $ - $ - $ IIIIIIIIIIIIIIIIIII II '.1111 $_ - $ - $ 1I11I11I11I1l Total from Worksheet $ 327,402 $ (327,402) $ - $ - $ - $ 11111 See Appendix A (Total I$ 654,804 $ (327,402) $ 327,402 $ - II$ 327,402 II$ - I Lium 327,402 II Risk Mngmnt-Claims&Misc FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - - $ - $ R $ - _ $ - $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII.......... $ $ $ $ $ i $ $ $ $ $ $ $ $ $ $ $ III - $ - $ 30,893 $ 30,893 $ 1 30,893 Total from Worksheet $ 265,965 $ 265,965 $ (30,893) $ 235,072 $ - $ '''- 235,072 See Appendix A (Total $ 265,965 $ - $ 265,965 $ - II$ 265,965 II$ - II$ 265,965 II 7/31/2013 Section V-Page 23 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Design&Comm-Mail FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - IIIP - $ - $ 1111111P 1111111111111111111111111111 $ $ IIIII�:. Cityscape postage,permit fees,etc. 42,000 $ 42,000 A 42,000 Total from Worksheet $ 128,447 $ 128,447 $ (42,000) $ 86,447 $ - 11 86,447 See Appendix A (Total $ 128,447 $ - $ 128,447 $ - II$ 128,447 II$ - I mg 128,447 II Design&Comm-Graphics FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - _ $ - $ R $ - - $ - $ 111111111111111111111111111111ii55I$ 11111111111111111111111111111111111 $ $ $ $ $ $ i $ $ $ $ $ $ $ $ $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ i $ $ 11111111111 MB $ $ - $ III,,_ - Total from Worksheet $ 295,869 $ 295,869 $ 295,869 $ - $ '''- 295,869 See Appendix A (Total $ 295,869 $ - $ 295,869 $ - II$ 295,869 II$ - II$ 295,869 II 7/31/2013 Section V-Page 24 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Design&Comm-Copiers FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - 1111 - $ _ $ 11111111 1111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 1111111111111111111111 Paper for all copiers/printers $ - $ 10,000 $ 10,000 1111111111111111110,000 Total from Worksheet $ 56,144 $ 56,144 $ (10,000) $ 46,144 $ - 1111111111111111111;i 6,144 See Appendix A (Total $ 56,144 $ - $ 56,144 $ - II$ 56,144 II$ - imunatamai Recorder/Records-Records Management FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - _ $ - $ R $ - _ $ - $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIII��III$ 11111111111111111111111111111111111 $ $ $ $ $ $ $ i $ $ $ $ $ $ $ $ $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ - $ - $ 1111111111111111111 $ $ - $ IIIII1 Total from Worksheet $ 207,414 $ 207,414 $ 207,414 $ - $ '''- 207,414 See Appendix A (Total $ 207,414 $ - $ 207,414 $ - II$ 207,414 II$ - II$ 207,414 q 7/31/2013 Section V-Page 25 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Recorder/Records-Council Support FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - 111$ 1111 $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIII1'1'III $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 Total from Worksheet $ 161,676 $ 161,676 $ 161,676 $ - IN • See Appendix A (Total $ 161,676 $ - $ 161,676 $ - 11$ 161,676 II$ - I mg 161,676 II Recorder/Records-Records Requests FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - $ R $ - $ - $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIII��III $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ lllllllllllllllllllllllllllllliillI.................... $ - $ - $ 11111111111 $ $ - $ 1111 Total from Worksheet $ 13,573 $ 13,573 $ 13,573 $ - $ '''- 13,573 See Appendix A (Total $ 13,573 $ - $ 13,573 $ - II$ 13,573 II$ - II$ 13,573 II 7/31/2013 Section V-Page 26 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Fin&Info Srvcs-Budget/CIP FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - II) $ $ - IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII........... IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIh Illh Total from Worksheet $ 124,839 $ 124,839 $ 124,839 $ - IN See Appendix A (Total $ 124,839 $ - $ 124,839 $ - II$ 124,839 II$ - I mg 124,839 II Fin Ops-Fin Rprting/Mngmnt FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - _ $ - $ R $ - _ $ - $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIII��III$ 11111111111111111111111111111111111 $ $ $ $ $ $ $ i $ $ $ $ $ $ $ $ $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ i $ $ 11111111111 MB $ $ - $ 1111 Total from Worksheet $ 156,848 $ 156,848 $ 156,848 $ - $ '''- 156,848 See Appendix A (Total $ 156,848 $ - $ 156,848 $ - II$ 156,848 II$ - II$ 156,848 II 7/31/2013 Section V-Page 27 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Fin Ops-Accounting/GL FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - 111 $ _ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ $ 11111111111111111111111111111111111 $ - M $ III�� Total from Worksheet $ 263,996 $ 263,996 $ 263,996 $ - IN See Appendix A (Total $ 263,996 $ - $ 263,996 $ - II$ 263,996 II$ - I mg 263,996 II Fin Ops-AP FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - _ $ - $ R $ - _ $ - $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIII��III$ 11111111111111111111111111111111111 $ $ $ $ $ $ $ i $ $ $ $ $ $ $ $ $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ - $ - $ 1111111111111111111 $ $ - $ IIIII1 Total from Worksheet $ 108,976 $ 108,976 $ 108,976 $ - $ '''- 108,976 See Appendix A (Total $ 108,976 $ - $ 108,976 $ - II$ 108,976 II$ - II$ 108,976 II 7/31/2013 Section V-Page 28 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Fin Ops-Payroll FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - 11111 - $ - $ 11111111 1111111111111111111111111111 61111111111F 7- M- $ $ 11111111111111111111111111111111111 1111111 - 11111 - Total from Worksheet $ 118,050 $ 118,050 $ 118,050 $ - IN 118,050 See Appendix A (Total $ 118,050 $ - $ 118,050 $ - 11$ 118,050 II$ - I mg 118,050 II Utility Billing-Billing FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - — $ - $ R $ - _ $ - $ 111111111111111111111111111111ii551 $ $ $ $ $ ir $ $ IIIII�:.$ 11111111111111111111111111111111111 $ $ $ $ $ $ $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ $ 11111 - Printing and Mailing Billing Statements $ - $ 140,000 $ 140,000 $ IN 140,000 Provided by Bend Mailing Total from Worksheet $ 590,318 $ 590,318 $ (140,000) $ 450,318 $ - $ '''- 450,318 See Appendix A (Total $ 590,318 $ - $ 590,318 $ - II$ 590,318 II$ - II$ 590,318 II 7/31/2013 Section V-Page 29 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Utility Billing-Meter Reading FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $ - $ - 111 $_ $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 Total from Worksheet $ 298,972 $ 298,972 $ 298,972 $ - 11111111111111I?;E.: • See Appendix A Total I$ 298,972 - $ 298,972 $ - II$ 298,972 II$ - ILIIIIIIIIIIEMOI IT-Support FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - _ $ - $ R $ - _ $ - $ 11111111111111111111111111111151$ 11111111111111111111111111111111111 $ $ $ $ $ $ $ i $ $ $ $ $ $ $ $ $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ $ - $ 111111111111111111111 $ $ $ 111111 Total from Worksheet $ 1,206,027 $ 1,206,027 $ 1,206,027 $ - $ ''' 1,206,027 See Appendix A Total $ 1,206,027 $ - $ 1,206,027 $ - II$ 1,206,027 II$ - II$ 1,206,027 q 7/31/2013 Section V-Page 30 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off IT- GIS FY LU1U-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - $ - II) $ $ - IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII........... IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIh Illh Total from Worksheet $ 349,634 $ 349,634 $ 349,634 $ - IN See Appendix A (Total $ 349,634 $ - $ 349,634 $ - II$ 349,634 II$ - I mg 349,634 II Contracts and Purchasing FY LU1U-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $_ - _ $ - $ R $ - _ $ - $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIII��III $ $ $ $ $ $ $ ir $ $ $ $ $ $ $ $ $ $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ 11111111111111111111111111111111111 $ $ - $ IIIIIi Total from Worksheet $ 227,881 $ 227,881 $ 227,881 $ - $ '''- 227,881 See Appendix A (Total $ 227,881 $ - $ 227,881 $ - II$ 227,881 II$ - II$ 227,881 II 7/31/2013 Section V-Page 31 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year A-87 allocation is Citywide Indirect Cost Pools I FY 2013-14 Proposed Budget Off Fleet Maintenance FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $ 213,867 $ 213,867 $ 213,867 $ 213,867 $ $ - $ 11111 Remove dues&subscriptions - $ - $ - $ 11111 „ Potentially unallowalbe according to A87 guidelines $ - — $ - $ 111111111111111111111111111111ii11I............. $ $ $ $ $ $ $ - _ $ - $ 111111111111111111111111111111ii11I........... $ - $ - $ ������������������������������ii���........... $ 1111111111111111111111111111111111I $ 1111111111111111111111111111111111I $ 1111111111111111111111111111111111I $ 1111111111111111111111111111111111I $ - $ - $ IIIIIIIIIIIIIIIIIIIIIIIIIIIII' $ - $ - $ IIIIIIIIIIIIIIIIIIIII1 Total from Worksheet $ - $ - $ - $ - ITotal $ 213,867 $ - $ 213,867 $ - II$ 213,867 II$ - II$ 213,867 II Property Management FY LU13-14 Proposed less:Non Subtotal:Costs Additional Citywide A-87 A-87 Allocable Operating Cost Categories Budget Allocable Costs Considered Adjustments Allocable Costs Adjustments Costs Notes: Total $ 1,435,350 $ 1,435,350 $ 1,435,350 1111 1,435,350 $_ - $ - IIIIILi Remove capital $ - $ - $ (7,870) IIIIIP 7,870) Unallowable according to A87 guidelines Remove dues&subscriptions $ - $ - $ (450) IIIIIIIIIIIM (450) Potentially unallowalbe according to A87 guidelines $ $ - IIIIIIIIIIIIIIIIIIIII $ $ IIIIIIIIIIIIIIIIIIIIIIIIIIIIII11III $ $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ - $ 11111111111111111111111111111111111 $ $ 1111111E ". Total from Worksheet $ $ $ IN - ITotal $ 1,435,350 $ - $ 1,435,350 $ - 11$ 1,435,350 II$ (8,320)II$ 1,427,030 II ITotal $ 8,624,140 $ (327,402) $ 8,296,738 $ - $ 8,296,738 $ (11,260) $ 8,285,478 I 7/31/2013 Section V-Page 32 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Indirect Cast Model for the FV 2913-14 Budget Year Pnrrary&Secondary Gtyande Cost Allocations FY 2013-10 Proposed-3 FrF= CI (Choose Allocation earns and i e on selecyon NUmbe/J 1:Factor/I 1 23 00 0 3 39 02 07 ] 08 06 23 i 9 01 31 _ 10 20 _ 3 09 12 03 00 05 17 _ 29 Pnmary Allocation I Ipgendaaerm ExpcMOeM aservices fife Costs COMBO man COMBO I etGraphics stm COMBOeIm Mel COMBO (Ca°mess Journal Entnes petinvoices fife stony Mme meter Reading come° oiscome° come° omersxpemce sq rt gllocaaon Factor COMBO Dam(Minutes) xx-• Bo COMBO c COMBO agenda Ee Requests cMMngmet- CMMngmm- o stony engne- Matey amine- eM Total Fund-Division-Name IndRec[Cost Pool cCity MManager - - - Management Allocated ® �' I 100 9599 Mayor&CUnal $ 1,954 $ 898 $ $ 578 $ 135 $ 24 $ 122 $ 24,713 $ 2,533 $ 40 $ 892 $ $ 198 $ 791 $ 2,912 $ 1,381 $ 93 $ $ 411 $ 197 $ 3,117 $ $ $ 39526 800 1999 Cry Mngmnt-Cry Manager $ 18,448 $ 5,529 $ 15,995 $ 19,199 $ 2,781 $ 1,899 $ 1,581 $ 31,398 $ 878 $ 895 $ 19,538 $ 1,428 $ 235 $ 1,544 $ 1,295 $ 1,993 $ 1,824 $ $ 18,375 $ 3,444 $ 3,828 $ $ 4,111 $ 135,505 800 1999 Cry Mngmnt-Web Services $ 4,217 $ 1,188 $ 2,594 $ 2,311 $ 897 $ 309 $ 352 $ 5,193 $ 23 $ 159 $ 2,498 $ 237 $ 39 $ 258 $ 215 $ 188 $ 371 $ $ 3,499 $ 787 $ 189 $ $ $ 20,998 800 1199 Human Resources $ 25,399 $ 7,343 $ $ 13,884 $ 3,895 $ 583 $ 2,125 $ 9,482 $ 2,129 $ 38,377 $ 14,449 $ 300 $ 278 $ 1,818 $ 1,359 $ 1,989 $ 2,227 $ $ 32,489 $ 4,723 $ 2,585 $ $ 8,973 $ 171,077 800 1299 Risk Mngmnt-Insurance Premiums $ $ 848 $ $ $ $ $ 44 $ $ 1,718 $ $ $ $ 123 $ 819 $ $ $ $ $ $ $ 731 $ $ $ 0,073 800 1299 Risk Mngmnt-Claims&Wsc $ 8,433 $ 2,489 $ $ 4,821 $ 1,438 $ 194 $ 711 $ 1,917 $ 79 $ 2,459 $ 4,818 $ 1,992 $ igg $ 858 $ 1,984 $ 598 $ 742 $ $ 9,578 $ 1,574 $ 578 $ $ 5,992 $ 50,005 800 1399 Design&Comm-Mat $ 2,572 $ 853 $ $ 1,419 $ 742 $ 59 $ 223 $ 7,479 $ 288 $ 52 $ 1,489 $ 7 $ 48 $ 318 $ 288 $ 253 $ 228 $ $ 3,345 $ 489 $ 777 $ 12 $ 4,719 $ 25,610 800 1399 Design&Comm-Graphics $ 13,594 $ 3,728 $ $ 7,499 $ 2,138 $ 311 $ 1,122 $ 54,421 $ 293 $ 274 $ 7,712 $ 49 $ 111 $ 732 $ 2,988 $ 1,845 $ 1,189 $ $ 22,323 $ 2,521 $ 5,858 $ 88 $ - $ 127,010 800 1399 Design&Comm-Copiers $ $ 111 $ $ $ $ $ 7 $ $ $ $ $ - $ 21 $ 139 $ $ $ $ $ $ $ $ $ $ 279 800 1599 Recorder/Records-Records Management $ 8,759 $ 2,449 $ $ 4,899 $ 1,859 $ 292 $ 729 $ 4,477 $ 1,782 $ 7,999 $ 5,992 $ - $ 78 $ 513 $ 751 $ 214 $ 771 $ $ 8,541 $ 1,835 $ 889 $ $ 5,384 $ 56,030 800 1599 Recorder/Records-CUnsl Support $ 8,973 $ 1,943 $ $ 3,821 $ 1,312 $ 181 $ 589 $ 3,499 $ 99 $ 8,388 $ 3,982 $ - $ 81 $ 400 $ 585 $ 187 $ 814 $ $ 6,714 $ 1,392 $ 537 $ $ $ 39,110 800 1599 Recorder/Records-Records Requests $ 883 $ 181 $ $ 383 $ 129 $ 15 $ 55 $ 293 $ 8 $ 895 $ 378 $ $ 5 $ 34 $ 49 $ 14 $ 58 $ $ 594 $ 124 $ 45 $ $ 3,972 $ 6,676 800 2999 Fin&Into Srvcs-BUdgeEClP $ 1,842 $ 1,577 $ 845 $ 3,132 $ 853 $ 179 $ 475 $ 957 $ 981 $ 3,523 $ 1,952 $ 131 $ 47 $ 309 $ 1,143 $ 721 $ 593 $ $ 9,934 $ 1,259 $ 2,531 $ $ 3,819 $ 35,595 800 2199 Fm Ops-Fin Rprtrng/Mngmnt $ 2,931 $ 1,375 $ 711 $ 2,595 $ 719 $ 147 $ 387 $ 1,955 $ 295 $ 2,915 $ 1,189 $ 144 $ 59 $ 388 $ 1,935 $ 794 $ 493 $ $ 19,959 $ 1,377 $ 3,884 $ $ 19,485 $ 02,688 800 2199 Fm Ops-Aceounkng/GL $ 3,418 $ 2,917 $ 1,197 $ 5,837 $ 1,543 $ 398 $ 889 $ 1,775 $ 2,889 $ 8,389 $ 1,952 $ 242 $ 99 $ 853 $ 77,711 $ 1,337 $ 908 $ $ 18,429 $ 2,318 $ 295 $ $ - $ 130,625 800 2199 Fm Ops-AP $ 1,411 $ 1,548 $ 494 $ 3,132 $ 828 $ 181 $ 472 $ 733 $ 82 $ 3,449 $ 898 $ igg $ 41 $ 279 $ - $ 552 $ 593 $ $ 7,898 $ 957 $ 122 $ $ - $ 23,203 800 2199 Fin Ops-Payroll $ 1,528 $ 1,584 $ 535 $ 3,132 $ 833 $ 183 $ 474 $ 794 $ 87 $ 3,489 $ 873 $ 198 $ 44 $ 292 $ $ 598 $ 593 $ $ 8,241 $ 1,937 $ 132 $ $ $ 20,388 °0 800 2299 UMW/all,-all, $ 5,939 $ 8,542 $ 2,978 $ 12,853 $ 3,249 $ 854 $ 1,929 $ 218 $ 1,814 $ 2,555 $ 3,388 $ 159 $ 222 $ 1,481 $ 1,938 $ 542 $ 2,933 $ $ 18079 $ 4,922 $ 4,499 $ 5,458 $ 17,847 $ 90,130 800 2299 UM!.Baling-Meter Reading $ 3,948 $ 4,318 $ 1,382 $ 8,769 $ 3,884 $ 459 $ 1,322 $ 144 $ 127 $ 1,701 $ 2,255 $ igg $ 112 $ 749 $ 890 $ 381 $ 1,499 $ $ 19,899 $ 2,878 $ 2,995 $ 3,833 $ $ 51,095 0 800 2399 IT-Support $ 7,149 $ 7,295 $ 2,593 $ 11,342 $ 3,891 $ 1,979 $ 1,819 $ 3,948 $ 588 $ 1,244 $ 4,983 $ 52 $ 453 $ 2,984 $ 3,872 $ 1,875 $ 1,822 $ $ 114,943 $ 4,849 $ 9,893 $ 133 $ 89,377 $ 253,095 U, 800 2399 IT-GIS $ 4,357 $ 3,599 $ 1,528 $ 8,823 $ 2,298 $ 854 $ 1,944 $ 2,498 $ 189 $ 758 $ 2,488 $ 32 $ 131 $ 885 $ 2,238 $ 1,921 $ 1,998 $ $ 89,505 $ 2,955 $ 5,997 $ 81 $ $ 109,956 WI 800 2599 Contracts and Purchasng $ 3,225 $ 2,845 $ 1,129 $ 5,837 $ 1,539 $ 394 $ 855 $ 1,875 $ 429 $ 581 $ 1,842 $ 229 $ 88 $ 584 $ 453 $ 129 $ 908 $ $ 15,872 $ 2,187 $ 844 $ $ 4,872 $ 05,753 a 850 8399 Fleet Maintenance $ $ 1,537 $ $ 2,888 $ 8,989 $ 853 $ 443 $ $ 159 $ $ $ $ 59 $ 388 $ 2,992 $ 877 $ 484 $ $ 9,792 $ 1,831 $ 858 $ 1,997 $ 27,471 $ 59,396 050 0400 Property Management $ $ 7,707 $ $ 11,120 $ 0,495 $ 3,417 $ 1,827 $ $ 159 $ $ $ $ 507 $ 3,730 $ 17,043 $ 11,317 $ 1,787 $ $ 22,732 $ 2,855 $ 14,207 $ 2,000 $ 44,075 $ 152,303 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 100 1400 Muncpal Court $ - $ 5,040 $ $ 9,387 $ 2,057 $ 395 $ 1,444 $ 11,043 $ 405 $ 415 $ - $ 111'$ 201 $ 1,324 $ 4,012 $ 10,348 $ 1,508 $ $ 20,201 $ 3,198 $ 333 $ - $ 0,057 $ 79,305 100 3000 Community Development Admin $ $ 3,233 $ 2,401 $ 5,777 $ 1,719 $ 1,729 $ 897 $ 1,317 $ 1,001 $ $ $ 5,104 $ 148 $ 975 $ 4,422 $ 405 $ 928 $ $ 37,005 $ 1,538 $ 2,498 $ $ $ 71,935 230 3100 Bullring $ 1,793 $ 12,385 $ 9,597 $ 22,529 $ 7,430 $ 3,897 $ 3,484 $ 205 $ 4,072 $ 83,050 $ 1,024 $ 2,337 $ 535 $ 3,521 $ 5,051 $ 757 $ 3,019 $ $ 51,274 $ 5,997 $ 4,008 $ 1,301 $ 15,027 $ 200,155 100 3200 Development Services $ 23,050 $ 7,307 $ 5,000 $ 13,287 $ 4,193 $ 4,994 $ 2,055 $ 2,034 $ 3,840 $ 22,235 $ 13,500 $ $ 310 $ 2,079 $ 4,745 $ 398 $ 2,135 $ $ 12,950 $ 3,537 $ 531 $ 1,081 $ 10,005 $ 102,303 100 3300 Community Planning $ 30,400 $ 14,140 $ 11,073 $ 25,995 $ 0,401 $ 1,093 $ 4,010 $ 15,015 $ 2,130 $ - $ 20,823 $ $ 588 $ 3,874 $ 5,780 $ 1,182 $ 4,170 $ $ 32,232 $ 40,254 $ 8,478 $ 1,040 $ 7,382 $ 208,192 100 3700 Downtown Redevelopment $ $ 1,589 $ 1,230 $ 2,888 $ 1,042 $ 121 $ 447 $ 7,113 $ 9 $ $ $ $ 89 $ 453 $ 3,257 $ 345 $ 404 $ $ 2,330 $ 709 $ 387 $ $ 1,250 $ 23,]]0 100 4000 Police Adminisira0on $ 25,108 $ 5,098 $ 184 $ 8,005 $ 3,482 $ 2,582 $ 1,303 $ 4,004 $ 3,310 $ 0,515 $ 14,339 $ 222 $ 209 $ 1,772 $ 0,341 $ 1,793 $ 1,392 $ $ 9,825 $ 5,201 $ 3,003 $ 231 $ 47,279 $ 152,705 100 4100 Police Operakons $ - $ 77,551 $ 3,003 $ 144,419 $ 50,073 $ 100,598 $ 22,210 $ 571 $ 3,214 $ - $ - $ $ 3,079 $ 20,209 $ 7,441 $ 7,545 $ 23,202 $ $ 83,093 $ 29,083 $ 14,007 $ 83,200 $ 104,158 $ 800,002 100 4200 Support Services $ $ 49,409 $ 1,930 $ 90,984 $ 30,001 $ 8,201 $ 14,029 $ 2,490 $ 243 $ $ $ $ 2,044 $ 13,458 $ 10,439 $ 5,001 $ 14,017 $ $ 74,014 $ 18,701 $ 8,213 $ 29,278 $ $ 373,776 100 5000 Library Administa0on $ 2,950 $ 5,127 $ 1,237 $ 9,243 $ 10,022 $ 389 $ 1,432 $ 24,059 $ 4,525 $ 733 $ 1,088 $ $ 228 $ 1,502 $ 5,284 $ 1,000 $ 1,485 $ $ 02,590 $ 14,071 $ 2,703 $ - $ 20,011 $ 178,105 100 5100 Library Readers'Services $ - $ 20,020 $ 4,911 $ 30,082 $ 10,505 $ 1,542 $ 5,704 $ 40,230 $ 1,905 $ - $ - $ $ 958 $ 0,308 $ 14,537 $ 10,093 $ 5,893 $ $ 129,533 $ 11,827 $ 10,095 $ - $ 352,503 $ 670,513 100 5200 Ebaw Technical Services $ - $ 8,444 $ 2,204 $ 10,404 $ 11,763 $ 1,424 $ 2,505 $ - $ 470 $ - $ - $ $ 270 $ 1,815 $ 10,784 $ 213 $ 2,045 $ $ 28,912 $ 3,071 $ 0,349 $ - $ 52,021 $ 109,965 100 5300 Library Crculadon $ - $ 18,874 $ 5,105 $ 38,127 $ 10,843 $ 3,089 $ 5,756 $ - $ 2,250 $ - $ - $ $ 509 $ 3,352 $ 3,305 $ 571 $ 0,125 $ $ 40,932 $ 8,157 $ 201 $ - $ 130,041 $ 283,363 100 5900 Sooal Svcs&Community Events $ $ 202 $ $ $ $ $ 14 $ $ $ $ $ $ 38 $ 253 $ 22 $ 300 $ $ $ $ $ $ $ 90,144 $ 90,978 100 0000 Public Works Admmstrakon $ 18,723 $ 14,505 $ 2,713 $ 20,573 $ 12,450 $ 3,335 $ 4,102 $ 2,297 $ 0,318 $ 3,074 $ 10,093 $ 808 $ 011 $ 4,023 $ 7,031 $ 1,793 $ 4,209 $ $ 08,828 $ 34,540 $ 5,813 $ 979 $ 127,729 $ 361,873 100 0100 Parts&Grounds $ - $ 15,274 $ 2,875 $ 28,102 $ 23,099 $ 15,970 $ 4,341 $ 2,870 $ 317 $ - $ - $ - $ 029 $ 4,142 $ 8,908 $ 3,706 $ 4,524 $ $ 23,317 $ 10,958 $ 10,320 $ 19,058 $ 48,570 $ 227,059 200 0200 Street Maintenance $ $ 11,952 $ 2,138 $ 20,941 $ 9,300 $ 23,057 $ 3,208 $ $ $ $ $ $ 809 $ 3,822 $ 5,457 $ 3,101 $ 3,304 $ $ 5,298 $ 5,807 $ 15,209 $ 9,725 $ 53,580 $ 176,950 100 0250 Protect Engineenng $ 30,548 $ 20,000 $ 3,833 $ 37,549 $ 15,335 $ 14,885 $ 5,764 $ 10,047 $ 5,117 $ 0,989 $ 17,440 $ 420 $ 771 $ 5,074 $ 7,312 $ 810 $ 0,032 $ $ 08,155 $ 49,101 $ 3,742 $ 1,005 $ 23,488 $ 333,095 100 0000 CIP/iansters'COntmgency $ $ 1,082 $ $ $ $ $ 113 $ $ $ $ $ $ 319 $ 2,102 $ 025 $ $ $ $ $ $ 030 $ $ $ 5,078 y 200 0800 Gas Tax Fund(Street Dghts&Signals) $ $ 1,440 $ $ $ $ $ 97 $ $ $ $ $ $ 274 $ 1,800 $ 2,809 $ 8,008 $ $ $ $ $ 2,400 $ $ $ 17,559 a 205 0000 Cry Gas Tax Fund $ $ $ $ $ $ $ $ $ $ $ $ $ 121 $ $ 1,531 $ 120 $ $ $ $ $ - $ $ $ 1,]]2 Y 220 0000 Electncel Inspect!.Fund $ $ 302 $ $ $ $ $ 24 $ $ $ $ $ $ 89 $ 452 $ 173 $ - $ $ $ $ $ - $ $ $ 1,080 i 240 0000 Cnminal Fortelmre Fund $ $ 99 $ $ $ $ $ 7 $ $ $ $ $ $ 19 $ 124 $ $ $ $ $ $ $ $ $ $ 208 ti 200 0000 Urban Forestry Fund $ $ 302 $ $ $ $ $ 20 $ $ $ $ $ $ 57 $ 378 $ 194 $ 40 $ $ $ $ $ 4,583 $ $ $ 5,575 a 300 0000 Bancroft Debt Service Fund $ $ - $ $ $ $ $ - $ $ $ $ $ $ 188 $ - $ 388 $ $ $ $ $ $ 1,978 $ $ $ 2,555 2 350 0000 GO Deb[Service Funtl $ $ $ $ $ $ $ $ $ $ $ $ $ 825 $ $ 80 $ 27 $ $ $ $ $ $ $ $ 937 a 400 0000 Faslitres FUntl $ $ 2,081 $ $ $ $ $ 180 $ $ $ $ $ $ 1,388 $ 3,297 $ 1,424 $ 88 $ $ $ $ 855 $ $ $ $ 9,891 w 405 0000 Tansportakon Development Tax $ $ 2,551 $ $ $ $ $ 172 $ $ $ $ $ $ 484 $ 3,187 $ 22 $ - $ $ $ $ $ $ $ $ 6,015 410 0000 Traffic Impact Fee $ $ 509 $ $ $ $ $ 34 $ $ $ $ $ $ 97 $ 030 $ 129 $ - $ $ $ $ $ $ $ $ 1,005 5 411 0000 Underground Utkty Fund $ $ 495 $ $ $ $ $ 33 $ $ $ $ $ $ 94 $ 019 $ 43 $ $ $ $ $ $ $ $ $ 1,285 412 0000 Street Maintenance Fee Fund $ $ 3,071 $ $ $ $ $ 247 $ $ $ $ $ $ 1,782 $ 479 $ 090 $ 93 $ 79,230 $ $ $ $ $ $ $ 86,199 420 0000 Parts Capital Fund $ $ 23,075 $ $ $ $ $ 1,553 $ $ $ $ $ $ 11,990 $ $ - $ 1,528 $ - $ $ $ $ $ $ $ 38,152 421 0000 Parts Bond Fund $ $ 0,130 $ $ $ $ $ 413 $ $ $ $ $ $ 1,103 $ 7,059 $ $ 40 $ - $ $ $ $ $ $ $ 15,005 425 0000 Parts SDC Fund $ $ 3,045 $ $ $ $ $ 205 $ $ $ $ $ $ 578 $ 3,805 $ 453 $ $ - $ $ $ $ $ $ $ 8,086 400 0000 Tansportaoon ClP Fund ANL $ 13027 $JOWLS irM=M11.$ $ 917 $ $ $ $ $ 7 084 $ - $ - $ 571 - $ 2 999 $ 25,198 500 0000 Sanitary Sewer Fund $ $ 27,215 $ 1,910 $ 18,774 $ 8,740 $ 22,234 $ 4,040 $ $ $ $ $ $ 8,010 $ 5,250 $ 5,029 $ 2,577 $ 3,010 58,349 $ 109,843 $ 11,142 $ 10,880 $ 12,230 $ 17,320 $ 24,305 $ 352580 510 0700 Stormwater Fund $ $ 14,390 $ 1,022 $ 15,880 $ 7,350 $ 11,024 $ 2,838 $ 1,147 $ $ $ $ $ 2,760 $ 4,007 $ 0,492 $ 3,573 $ 2,552 90,211 $ $ 5,505 $ 18,733 $ 18,431 $ 3,850 $ 13,804 $ 230,808 511 0000 Water Oualiry&uantrry Fund $ $ 1,891 $ $ $ $ $ 127 $ $ $ $ $ $ 359 $ 2,302 $ $ $ $ $ $ $ $ $ $ 0,739 530 0500 Water Fund $ 17,934 $ 30,499 $ 3,538 $ 34,001 $ 37,953 $ 27,337 $ 0,130 $ 12,344 $ $ $ 10,242 $ $ 2,995 $ 19,716 $ 9,037 $ 10,480 $ 5,508 350,523 $ 189,129 $ 13,998 $ 20,093 $ 23,350 $ 32,021 $ 31,488 $ 896,200 531 0000 Water SDC Fund $ - $ 10 $ - $ - $ - $ - $ 1 $ - $ $ $ - $ $ 2 $ 13 $ 85 $ $ - $ $ - $ - $ - $ $ $ 90 532 0000 Water ClP Fund $ - $ 127,724 $ - $ - $ - $ - $ 8,590 $ $ $ $ - $ $ 00,311 $ 328 $ - $ 1,448 $ - $ $ - $ - $ - $ $ $ 200,006 533 0000 Water Debt Service Fund $ $ - $ $ $ $ $ $ $ 1,835 $ $ $ 1,448 $ $ $ $ - $ $ $ $ 3,283 000 1500 Recorder/Records-Electrons Supervisor $ 524 $ 204 $ $ 403 $ 122 $ 17 $ 81 $ 357 $ 10 $ 137 $ 299 $ $ 8 $ 41 $ 80 $ 17 $ 85 $ $ 408 $ $ 23 $ $ $ 2,753 000 2000 Pr!&Info Srvcs-Passports.umness Dcensng $ 037 $ 003 $ 223 $ 1,359 $ 300 $ 70 $ 205 $ 331 $ 28 $ 111 $ 304 $ 45 $ 10 $ 107 $ $ 249 $ 218 $ $ 3,435 $ 432 $ 55 $ $ $ 8,909 000 0000 Insurance Fund $ - $ 101 $ - $ - $ - $ - $ 7 $ - $ - $ - $ - $ $ 19 $ 120 $ 85 $ - $ - $ $ - $ - $ - $ $ $ 317 930 0000 Urban Renewal Debt Srvc $ - $ $ - $ - $ - $ - $ $ - $ - $ - $ - $ $ $ $ - $ $ - $ $ - $ - $ - $ $ 940 9000 Urban Renewal Cap Improvements $ - $ 903 $ - $ - $ - $ - $ 81 $ - $ - $ - $ - $ $ 171 $ 1,128 $ - $ 837 $ - $ $ - $ - $ - $ $ $ 3,101 510 0200 Healthy Streams $ - $ 34 $ $ - $ - $ - $ 2 $ - $ - $ - $ - $ $ 8 $ 43 $ - $ - $ - $ $ - $ - $ - $ $ $ 85 Other JUnsd.ons $ - $ - $ 0,211 $ - $ - $ - $ - $ - $ - $ - $ - $ $ - $ - $ - $ - $ - $ $ - $ - $ - $ $ $ 6,211 Grand Total-Primary $ 283,092 $ 620,070 $ 103,521 $ 730,800 $ 327,002 $ 265,965 $ 128,007 $ 295,869 $ 56,100 $ 207,010 $ 161,676 $ 13,573 $ 120,839 $ 156,808 $ 263,996 $ 108,976 $ 118,050 590,318 $ 298,972 $1,206,027 $ 309,630 $ 227,881 $ 213,867 $1,035,350 $8,296,738 Subtotal Indirect I$ 120,760 $ 69,989 $ 29,798 $ 126,008 $ 09,303 $ 11,917 $ 19,539 $ 156,069 $ 16,909 $ 83,555 $ 71,251 $ 0,000 $ 3,120 $ 20,567 $ 119,230 $ 26,006 $ 20,250 - $ - $ 019,720 $ 00,903 $ 60,507 $ 12,506 $ 208,576 $1,703,817 Subtotal Direct $ 158,332 $ 550,085 $ 73,723 $ 608,756 $ 278,099 $ 250,008 $ 108,908 $ 139,000 $ 39,195 $ 123,858 $ 90,025 $ 9,173 $ 121,715 $ 136,281 $ 100,762 $ 82,529 $ 97,799 590,318 $ 298,972 $ 786,303 $ 300,730 $ 163,370 $ 201,361 $1,226,770 $6,592,921 Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK 7/31/2013 Seckon VIII-Page 33 of 53 Tigard ICAP Budget 2014-Budget System Load 0°,W9SASI.PnEl bl0,96,7,1 d,1 p.0, ES..9001 II,u.1,9S C.... MO 10040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 010040 )1 010040 )1 010040 )1 010040 )1 010040 )1 010040 )1 010040 )1 010040 )1 010040 )1 0 10040 )1 0 10040 )1 0 10040 )1 0 10040 LI,Ell COL1,$ nen, $ ssns $ 09190 $ 996601 $ 960,93 $ 96019 $ 001:06 99t03 $ ZOZ,Z $ 939001 $ 99930 $ 6990 $ 9199 $ 01160 $ 0099 $ LZ $ 01,0'LZI, $ 1993 $ 90009 $ 0106 $ 1101111 $ 96663 $ 909901 $ 93969 $ 100,0 1010100S - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 100,0011010100S 1140011$ nen, 0 ssns 0 09190 $ 996601 $ 960,93 $ 96019 $ 001:06 99t03 $ ZOZ,Z $ 939001 $ 99930 $ 6990 $ 9199 $ 01160 $ 0099 $ LZ $ 01,0'LZI, $ 1993 $ 90009 $ 0106 $ 1101111 $ 96663 $ 909901 $ 93960 $ 01000000S-10101 P110,10 306 $ L9Z11 $ 90..1,0E119911 00E9 099 - $ .10040,1 Pu0 0100,00 009Z 009 - $ 010 11 COE 009 $0,nS . COE 009 001P09L1,9191,1 .qpe/gm oozz oos .■Ipe .qpe 41qn oozz oos $ 11..1 060 01 001, 009 $ 16'.0 01 CO. 009 F $ 00,011,00,060 01 001, 009 g,- $ 11,001161/,11,0 u11 .0 01 CO. 009 $, $ 110690,8 00,0 0411,6 1111 000Z 009 ; - $ sl.s9.9,P,.. sPos9LIP9P.S. OH, 009 g 1.ddr,1..00 sPos9LIP9Pos. OH, 009 7, $ 1.w.euelAl sP,.. sPos9LIP9Pos. OH, 009 g s s,s,so wws,s,oossa ooe, oos . s ssNos,o o-0oso,s,o.sso 00El 009 $ 11061 1,0,00,01090 00El 009 $ 0011,116.01010 1.0,1,16010 00Z, 009 $ 01,1,961 9.0,0,1.61,1,16010 00Z, 009 $ 0901,90 691.1.0.616610 000, 009 $ .60,61,010 111.1.1,16610 000, 009 $ 110,00,060W 0090 00, LI,Ell COL1,$ efle Z91, $ 969,9 $ Z9L,0 $ 996601, $ 960,0 $ 9601,9 $ OZ1'06 $ 9991, $ ZOZ,Z $ 9Z9,91, $ 999'ZO $ 969,9 $ 9(99 $ 01,169 $ 09099 $ 6LZ $ 01,0LZI, $ 01,9,Z $ 90009 $ UO1, $ LL01,L1, $ 9660Z $ 909,91, $ 9Z9,Z $ 1)0100011W 100000.1 1 80 I , I LP I ZO I ne I e I , I 0, I . 1 P-,010U, uounnopy.pUOnap ,E,0, WI:B:esu e pi .es,uuldzuxe,i;0 I 11:::::00ufnn dd 0:I 9:isi,0 I i000llinoss,:, I uom76 J..9 9.9.9 I 1.1,1 9 9...19$9,7.91e913. 95.4:911...11119: 5 0 als::0 E 10110:10: 9 9]091309e M7;9: e:1 10 5,0 80.I 01 I emery-uoisinie-pun, P'E"" MoOom 1000 aue SP.1.3 .....1.1, .n.117%1411 1 Med s:'1"sod:u"I'"uuno""0:ur r.,..17.::::uirl......I lumin:cul:u1;n8.1.i.1..„ulusi7..1.6en.11.::....Unl. 1..710...:":1i.ureuNp,..:078"ulnua u.r0 7"8eulne 0....0 3 8 u n.ne 0 ImunuiP Nu.11 .......?...M. nu... Puun MP 43 $00,11.00600/0S 00 06,6/Pue 6,66 0,6000,06004. 11.$60,0,1 010103 Ad bo01,00,1,00,b01))110 00,10,,$0,66,sl l09.1190PnEl bl ClOZ.11 94,0.9,6,000 609.0 .'p6!1 1 0 4o City of Tigard,OR Indirect Cast Model for the FY 2913-14 Budget Year Pnrrary&Secondary Ctywttle Cost Allocations FY 2013-10 Proposed )/moose AllocaM1On eases and Type on Selemon Num;etJ rIlocabonM 1 23 00 0 3 39 02 I 07 I 7 I 08 I 06 23 9 01 31 10 I 20 I 3 I 09 I 12 I 03 I 00 I 05 I 17 I 29 Total cMwtaegllocahon I Ingeoda perm ..:cal..) wen fife osrscoMOI man COMBO I namcssrm l pocoMBOef I N COMBO tE.eomta7I�ourmt Eames norm mores firs I Unlit=og Immer Bead. comoo OIS COMBO COMBO' 10,==. sq Et AllocaEOn Name omen rre lminmesl poop Bo COMBO c COMBO a....Items Requests cimenmm- WMmegmm- come resign B uat BBmmg- OmMBmmg- geM Total Fund-Dwtzmn-Name IndBec[Cost Pool oracounnt City Manager a senores Resources premums cmnsamis -Man Graphics copiers manmenent Support Bequests euaeevctp mnerrnt Accounting GL fin Bps AP ran Bps paKOn inane comer Beaaine B suppon B-Bas Purchasing maimmname Management Allocated egg 9599 Mayor&Councl $ _ 000 1999 Cry Mngmnt-Cry Manager $ _ 800 1999 Cry Mngmnt-Web Services $ _ 800 1199 Human Resources $ _ 800 1299 Risk Mngmnt-Insurance Premiums $ _ 800 1299 Risk Mngmnt-Claims&Mist $ _ 800 1399 Des ign&Comm-Mail 000 1399 Design&Comm-Graphcs $ a agg 1399 Des ign&Comm-Cop iers 600 1599 Recorder&Records-Records Management $ _ 800 1599 Recorder/Records-Counol Support $ _ 0 800 1599 Recorder/Records-Records Requests $ ?, 800 2999 Fin&Info Srvcs-BUdgeEClP $ _ I, 800 2199 Fm Ops-Fin RprOng/Mngmnt $ _ a 800 2199 Fm Ops-Account nq/GL $ _ 800 2199 Fm Ops-AP $ _ 800 2199 Fin Ops-Payroll $ _ 800 2299 UOIiry Bills ng-Billing $ _ 800 2299 UOIiry Billing-Meter Reading $ _ figg 2399 IT Support $ _ 800 2399 IT GIS $ _ 800 2599 Contracts and Purcbasing $ _ 850 8399 Fleet Maintenance _ 050 0400 Property Management 100 1400 Muniopal Court $ - $ 0,334 $ $ 12,020 $ 2,090 $ 400 $ 1,407 $ 22,200 $ 40 $ 510 $ - $ 192 $ 201 $ 1 738 $ 7,032 $ 13,202 $ 1,004 $ $ 20,091 $ 3304 $ 411 $ - $ 7404 $ 103,160 100 3000 Community Development Admen $ $ 4,055 $ 3,295 $ 7,400 $ 1,745 $ 1,791 $ 929 $ 2,521 $ 1,00 $ 70 $ $ 0,922 $ 193 $ 1,200 $ 0,411 $ 590 $ 1,159 $ $ 37,901 $ 1,075 $ 2,555 $ $ $ 85,580 230 3100 Building $ 2,241 $ 15,539 $ 12,051 $ 20,001 $ 7,539 $ 4,122 $ 3,000 $ 507 $ 4,07 $ 03,305 $ 1,407 $ 4,037 $ 095 $ 4,024 $ 10,750 $ 970 $ 4,522 $ $ 52417 $ 0493 $ 4,215 $ 1,004 $ 17500 $ 272,082 100 3200 Development Serve ces $ 29554 $ 9107 $ 7,579 $ 17,020 $ 4,255 $ 5,127 $ 2,123 $ 5,042 $ 3,04 $ 22,305 $ 19,340 $ $ 411 $ 2731 $ g,027 $ 511 $ 2,007 $ $ 13,025 $ 3,030 $ 053 $ 2,177 $ 11,922 $ 172,999 100 3300 Community Planni ng $ 45,502 $ 17,744 $ 14,020 $ 33,301 $ 0,557 $ 1,341 $ 4,137 $ 20,740 $ 2,13 $ 200 $ 29,020 $ $ 705 $ 5,007 $ 10,990 $ 1,515 $ 5,210 $ $ 33490 $ 40,799 $ 0,705 $ 1,347 $ 0,290 $ 306,675 100 3700 Downtown Redevelopment $ $ 1,994 $ 1,040 $ 3,700 $ 1,057 $ 150 $ 402 $ 13,014 $ $ 33 $ $ $ 90 $ 595 $ 0,190 $ 443 $ 500 $ $ 2403 $ 033 $ 414 $ $ 1,405 $ 35,700 100 4000 Police Admnista0on $ 31,370 $ 0,307 $ 240 $ 11,100 $ 3,533 $ 2,090 $ 1,421 $ 7,770 $ 3,31 $ 0,043 $ 20,541 $ 304 $ 350 $ 2,327 $ 12,003 $ 2,290 $ 1,739 $ $ 10401 $ 5451 $ 3,707 $ 299 $ 53,149 $ 18],265 100 4100 Police Opea0ons $ - $ 97,343 $ 4,101 $ 105,005 $ 51,412 $ 107,090 $ 22,074 $ 1,092 $ 3,22 $ 1,405 $ - $ $ 4,003 $ 20,010 $ 14,155 $ 9,070 $ 20,907 $ $ 09075 $ 32530 $ 15195 $ 107,020 $ 104,530 $ 98],619 100 4200 Support Services $ $ 02004 $ 2,504 $ 110,553 $ 30,440 $ g,123 $ 14,471 $ 4,777 $ 24 $ 973 $ $ $ 2,050 $ 17,074 $ 19,059 $ 0400 $ 10,202 $ $ 70,904 $ 20,590 $ 9,002 $ 37,914 $ $ 052,607 100 5000 Lbaw Admnista0on $ 3094 $ 0431 $ 1,057 $ 11,040 $ 10,770 $ 405 $ 1,402 $ 47,197 $ 4,52 $ 041 $ 2,419 $ $ 297 $ 1,972 $ 10,052 $ 2,120 $ 1,055 $ $ 03,070 $ 14,202 $ 2,791 $ - $ 29,240 $ 21],038 100 5100 Lbaw Readers Serve ces $ - $ 25000 $ 0,577 $ 40,991 $ 10,742 $ 1,947 $ 5,911 $ 77,001 $ 1,90 $ 450 $ - $ $ 1,240 $ 0,204 $ 27,054 $ 13,705 $ 7,303 $ $ 131,501 $ 12710 $ 10405 $ - $ 390,333 $ 792,700 100 5200 Lbaw Technical Services $ - $ 10,009 $ 2,952 $ 21,091 $ 11,929 $ 1,540 $ 2,505 $ - $ 47 $ 131 $ - $ $ 350 $ 2,304 $ 20,515 $ 272 $ 3,305 $ $ 29,501 $ 3,920 $ 0455 $ - $ 50400 $ 176,090 100 5300 Lbaw Crculadon $ - $ 23,732 $ 0,030 $ 40,041 $ 17,000 $ 3,304 $ 5,000 $ - $ 2,25 $ 242 $ - $ $ 002 $ 4,402 $ 0,401 $ 732 $ 7,053 $ $ 42,020 $ 0,029 $ 450 $ - $ 140,100 $ 325,306 100 5900 Soo al Svcs&Community Events $ $ 249 $ $ $ $ 10 $ 22 $ $ $ 10 $ $ $ 50 $ 332 $ 41 $ 392 $ $ $ 02 $ 30 $ 15 $ $ 101,335 $ 102,588 100 0000 Publi c Works Administa0on $ 23,397 $ 10,200 $ 3,032 $ 34,041 $ 12,020 $ 3,593 $ 4,234 $ 4,390 $ 0,32 $ 3,905 $ 15,317 $ 1,500 $ 795 $ 5,204 $ 13,370 $ 2,290 $ 5,334 $ $ 70,134 $ 35,113 $ 0,049 $ 1,207 $ 143,500 $ 010,061 100 0100 Parks&Grounds $ - $ 19,109 $ 3,049 $ 30,070 $ 23,493 $ 10,241 $ 4,477 $ 5,494 $ 31 $ 299 $ - $ - $ 010 $ 5,440 $ 10,940 $ 4,750 $ 5,053 $ $ 24,002 $ 11,542 $ 10,509 $ 24,000 $ 54,000 $ 269,083 200 0200 Street Maintenance $ $ 14,904 $ 2,002 $ 20,020 $ 9,434 $ 23,390 $ 3,443 $ $ $ 305 $ $ $ 1,051 $ 5,020 $ 10,301 $ 4,052 $ 4,203 $ $ 7,020 $ 0,017 $ 15,521 $ 12,593 $ 00,239 $ 208,037 100 0250 Protect Engineer ng $ 30,173 $ 25,110 $ 5,133 $ 40,101 $ 15,557 $ 15,210 $ 5,930 $ 19,230 $ 5,11 $ 7,350 $ 24,991 $ 730 $ 1,002 $ 0,003 $ 13,909 $ 1,030 $ 7,537 $ $ 09,003 $ 49,070 $ 4,039 $ 1,302 $ 20404 $ 392,226 100 0000 CIP/7ansfers/COn0 ngency $ $ 2,000 $ $ $ $ 135 $ 102 $ $ $ 152 $ $ $ 415 $ 2700 $ 1,190 $ $ $ $ 002 $ 290 $ 759 $ $ $ 8,600 19 200 0000 Gas Tax Fund(Street Dghts&Signals) $ $ 1,777 $ $ $ $ 110 $ 157 $ $ $ 131 $ $ $ 357 $ 2,372 $ 5,457 $ 11,032 $ $ $ 500 $ 254 $ 2,500 $ $ $ 20,800 a 205 0000 Cry Gas Tax Fund $ $ $ $ $ $ 51 $ 20 $ $ $ 50 $ $ $ 150 $ $ 2,913 $ 153 $ $ $ 259 $ 112 $ 47 $ $ $ 3,778 e 220 0000 Electncel Inspect on Fund $ $ 445 $ $ $ $ 29 $ 39 $ $ $ 33 $ $ $ 09 $ 594 $ 320 $ - $ $ $ 147 $ 04 $ 27 $ $ $ 1,795 i 240 0000 Cr mi nal Forteiture Fund $ $ 122 $ $ $ $ 0 $ 11 $ $ $ 9 $ $ $ 24 $ 102 $ $ $ $ $ 40 $ 17 $ 7 $ $ $ 001 200 0000 Urban Forestry Fund $ $ 372 $ $ $ $ 24 $ 33 $ $ $ 27 $ $ $ 75 $ 490 $ 309 $ 51 $ $ $ 123 $ 53 $ 4,005 $ $ $ 6,229 a 300 0000 Bancroft Debt Serve ce Fund $ $ - $ $ $ $ 79 $ 41 $ $ $ 90 $ $ $ 245 $ - $ 739 $ $ $ $ 402 $ 175 $ 2051 $ $ $ 3,821 2 350 0000 GO Oeb[Service FUntl $ $ $ $ $ $ 340 $ 170 $ $ $ 392 $ $ $ 1,072 $ $ 104 $ 34 $ $ $ 1,703 $ 705 $ 310 $ $ $ 5,036 a 400 0000 Faon0es FUntl $ $ 3,295 $ $ $ $ 507 $ 471 $ $ $ 040 $ $ $ 1 792 $ 4,330 $ 2700 $ 05 $ $ $ 2073 $ 2101 $ 519 $ $ $ 19,380 405 0000 Tansportat on Development Tax $ $ 3,130 $ $ $ $ 204 $ 270 $ $ $ 230 $ $ $ 029 $ 4,105 $ 41 $ - $ $ $ 1,035 $ 449 $ 107 $ $ $ 10,370 @ 410 0000 Traff ic Impact Fee $ $ 025 $ $ $ $ 41 $ 55 $ $ $ 40 $ $ $ 120 $ 035 $ 240 $ - $ $ $ 200 $ 90 $ 37 $ $ $ 2,307 d 411 0000 Underground Ut Ity FUntl $ $ 009 $ $ $ $ 40 $ 54 $ $ $ 45 $ $ $ 122 $ 013 $ 02 $ $ $ $ 201 $ 07 $ 30 $ $ $ 2,089 412 0000 Street Maintenance Fee FUntl $ $ 4,513 $ $ $ $ 729 $ 020 $ $ $ 022 $ $ $ 2,301 $ 029 $ 1,313 $ 119 $ 91,071 $ $ 3,093 $ 1,002 $ 007 $ $ $ 108,883 420 0000 Parks Capital Fund $ $ 20,305 $ $ $ $ 4,901 $ 4,001 $ $ 2 $ 5,527 $ $ $ 15,402 $ $ - $ 1,950 $ - $ $ 24027 $ 10709 $ 4401 $ $ $ 100,397 421 0000 Parks Bond Fund $ $ 7,535 $ $ $ $ 491 $ 004 $ $ $ 554 $ $ $ 1,513 $ 10,050 $ $ 51 $ - $ $ 2407 $ 1,079 $ 449 $ $ $ 20,883 425 0000 Parks SDC Fund $ $ 3,743 $ $ $ $ 244 $ 330 $ $ $ 275 $ $ $ 751 $ 4,990 $ 002 $ $ - $ $ 1,235 $ 530 $ 223 $ $ $ 13,197 400 0000 Tansportat on CIP Fund $ $ 10751 $ $ $ $ 2,094 $ 2,390 $ $ 1 $ 3,204 $ $ $ g,143 $ $ $ 732 $ $ $ 14,001 $ 0,300 $ 5,045 $ $ $ 61,860 500 0000 Sanitary Sewer Fund $ $ 33,715 $ 2,500 $ 24,051 $ 0,000 $ 25,705 $ 5,047 $ $ 2 $ 3,902 $ $ $ 11,127 $ 0,095 $ 10,709 $ 3303 $ 3700 07053 $ 120702 $ 29,020 $ 10030 $ 15405 $ 22429 $ 27323 $ 009,912 510 0700 Stomrweter Fund $ $ 17910 $ 2,171 $ 20,351 $ 7,450 $ 12,101 $ 3,420 $ 2,195 $ $ 1,202 $ $ $ 3,509 $ 0,050 $ 12,350 $ 4,500 $ 3,109 111,554 $ $ 11,205 $ 21,231 $ 19470 $ 4,994 $ 15505 $ 280,796 511 0000 Water Dualiry&uanOry Fund $ $ 2,324 $ $ $ $ 151 $ 205 $ $ $ 171 $ $ $ 407 $ 3,102 $ $ $ $ $ 707 $ 333 $ 130 $ $ $ ),659 530 0500 Water Fund $ 22411 $ 37974 $ 4,730 $ 44,401 $ 30,400 $ 20,001 $ 0,777 $ 23,020 $ $ 1,425 $ 14,072 $ $ 3,094 $ 25,091 $ 17,192 $ 13432 $ 0,957 413,375 $ 221705 $ 20401 $ 23470 $ 24,511 $ 42,243 $ 35,390 $1,071,590 531 0000 Water SDC Fund $ - $ 13 $ - $ - $ - $ 1 $ 1 $ - $ $ 1 $ - $ $ 3 $ 17 $ 123 $ $ - $ $ 4 $ 2 $ 1 $ $ $ 165 532 0000 Water ClP Fund $ - $ 157,001 $ - $ - $ - $ 27,094 $ 22,401 $ - $ 15 $ 30,553 $ - $ $ 05,502 $ 430 $ - $ 1,050 $ - $ $ 137,242 $ 59,530 $ 24,771 $ $ $ 506,672 533 0000 Water Debt Service Fund $ $ $ - $ $ $ 774 $ 390 $ $ $ 073 $ $ $ 2,300 $ $ $ 1,050 $ $ $ 3,922 $ 1,701 $ 700 $ $ $ 12,620 000 1500 Recorder/Records-Elec0ons Supervisor $ 054 $ 250 $ $ 510 $ 124 $ 20 $ 02 $ 003 $ 1 $ 140 $ 420 $ $ 0 $ 54 $ 114 $ 22 $ 01 $ $ 421 $ 0 $ 25 $ $ $ 3,620 000 2000 Fin&Into Smcs-Passports&BUSness D censnq $ 790 $ 034 $ 299 $ 1,741 $ 305 $ 77 $ 200 $ 033 $ 2 $ 119 $ 521 $ 70 $ 21 $ 140 $ $ 319 $ 273 $ $ 3470 $ 447 $ 01 $ $ $ 10,032 000 0000 Insurance Fund $ - $ 124 $ - $ - $ - $ 0 $ 11 $ - $ $ 9 $ - $ $ 25 $ 105 $ 123 $ - $ - $ $ 41 $ 10 $ 7 $ $ $ 531 930 0000 Urban Renewal Debt Sem $ - $ $ - $ - $ - $ $ $ - $ - $ $ - $ $ $ $ - $ $ - $ $ $ $ $ $ 940 9000 Urban Renewal Cap Improvements $ - $ 1,1M $ - $ - $ - $ 72 $ 98 $ - $ $ 02 $ - $ $ 223 $ 1,402 $ - $ 1,073 $ - $ $ 300 $ 159 $ 00 $ $ $ 0,731 510 0200 Healthy Streams $ - $ 42 $ $ - $ - $ 3 $ 4 $ - $ $ 3 $ - $ $ 0 $ 50 $ - $ - $ - $ $ 14 $ 0 $ 2 $ $ $ 138 Other Jursdicbons $ - $ - $ 0,317 $ - $ - $ - $ - $ - $ - $ - $ - $ $ - $ - $ - $ - $ - $ $ - $ - $ - $ $ $ 8.317 Grand Total Citywide $ 197,859 $ 689,590 $ 98,722 $ 779,832 $ 282,171 $ 300,093 $ 130,517 $ 266,813 $ 39,07 $ 180,292 $ 129,535 $ 15,809 $ 157,310 $ 178,969 $ 275,387 $ 105,772 $ 122,187 680,052 $ 350,067 $1,039,798 $ 010,687 $ 209,127 $ 260,757 $1,379,078 $8,296,738 Subtotal Indirect I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - - $ - $ - $ - $ - $ - $ - I$ - Subtotal Direct $ 197,859 $ 689,590 $ 98,722 $ 779,832 $ 282,171 $ 300,093 $ 130,517 $ 266,813 $ 39,07 $ 180,292 $ 129,535 $ 15,809 $ 157,310 $ 178,969 $ 275,387 $ 105,772 $ 122,187 680,052 $ 350,067 $1,039,798 $ 010,687 $ 209,127 $ 260,757 $1,379,078 $8,296,738 I 1$ o$ o$ o$ o$ o$ o$ o$ o$ o$ o$ o$ o o$ 1 Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK heck OK Check OK Check OK Check OK Check OK Check OK Check OK Check OK 7&31&2013 Sect on VIII Page 35 of 53 Tigard ICAP Budget 2014 System Load City of Tigard,OR Multiple Overhead Rate Worksheet - Library FY 2013-14 Proposed Budget Overhead Rates (Rate Base=Direct Salaries&Wages) Total Citywide l Dept. Departmental Divisions Rate Overhead Overhead Paid Time Off Admin Time Benefits Library Readers'Services 202.52% 98.24% 32.29% 13.36% 14.29% 44.35% Check O.K. Library Technical Services 174.90% 57.30% 35.21°/0 13.36% 14.29% 54.75% Check O.K. Library Circulation 153.17% 46.78% 34.94% 13.36% 14.29% 43.81% Check O.K. Dept.Average 178.87% 83.50% 21.81% 13.36% 14.29% 45.91% Library Department: Total Department Divisions'Costs Dept. Dept. Direct Expenditures Total Dept. Overhead Unallowable Divisions' Salaries and Total Benefits for all other Divisions' Departmental Divisions Indirect Costs Wages purposes Cost Library Administration $ 394,910 $ 211,986 $ 606,896 $ 606,896 Library Readers'Services $ 800,333 $ 806,987 $ 357,895 $ 583,990 $ 2,549,205 $ 2,549,205 Library Technical Services $ 189,379 $ 307,998 $ 168,617 $ 67,457 $ 733,451 $ 733,451 Library Circulation $ 332,573 $ 695,392 $ 304,636 $ 22,131 $ 1,354,732 $ 1,354,732 Total $ 394,910 $ 1,534,271 $ - $ 1,810,377 $ 831,148 $ 673,578 $ 5,244,284 Citywide, Department,and Division Overhead Allocation Overhead Costs Libary Admin-Personnel Costs $ 344,220 $ 344,220 Library Admin-M&S $ 50,690 $ 50,690 Back Out Citywide Library Admin OH $ (217,038) $ (217,038) Reallocate Citywide Library Admin OH $ 217,038 $ 217,038 J l i Dept. Back Out Reallocate Divi sions' Citywide Libary Admin• I Citywide Citywide Indirect Overhead Personnel Library Admin Library Admin Library Admin Total Divisions Costs Allocation Costs -M&S OH OH Overhead Library Administration $ - $ 217,038 $ - $ - $ (217,038) $ - - $ - $ - Library Readers'Services $ - $ 792,744 $ 141,218 $ 22,595 $ - $ 96,746 -l $ - $ 1,053,304 Library Technical Services $ - $ 176,490 $ 62,886 $ 8,624 I $ - $ 36,924 -I $ - $ 284,925 Library Circulation $ - $ 325,306 $ 140,115 $ 19,471 $ - $ 83,367 - $ - $ 568,260 Total $ - $ 1,511,578 $ 344,220 $ 50,690 $ (217,038) $ 217,038 - $ - $ 1,906,488 Allocate Departmental Indirect Costs Using' Direct FTEs I Direct and Waaes Salaries I Remove Admin Direct Salaries Citywide OH and Wades Department Allocation Data Direct Total Dept. Remove Salaries and Divisions' Direct FTEs Admin Wages Cost Citywide OH Library Administration $ - $ 606,896 _ 1 Library Readers'Services $ 806,987 $2,549,205 _ 12.80 Library Technical Services $ 307,998 $ 733,451 _ 5.70 Library Circulation $ 695,392 $1,354,732 12.70 Total $1,810,377 $5,244,284 31.20 1 0 0 4 7/31/2013 Section IX-Page 36 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Multiple Overhead Rate Worksheet - Police FY 2013-14 Proposed Budget Overhead Rates(Rate Base=Direct Salaries&Wages) Total Citywide Dept. Departmental Divisions Rate Overhead Overhead Paid Time Off Admin Time Benefits Police Operations 122.77% 24.37% 10.92% 19.15% 14.29% 54.04% Check O.K. Support Services 116.21% 18.20% 10.88% 19.15% 14.29% 53.69% Check O.K. Dept.Average 81.72% 13.84% 4.47% 19.15% 14.29% 29.98% Police Department: Total Department Divisions'Costs 1 Dept. Direct Expenditures Total Dept. Dept.Overhead Unallowable Divisions' Salaries and Total Benefits for all other Divisions'Cost Departmental Divisions Indirect Costs Wages purposes Police Administration $ 525,957 $ 190,042 _ $ 715,999 $ 715,999 Police Operations $ 1,007,073 $ 4,052,989 $ 2,190,404 $ 940,369 $ 8,190,835 $ 8,190,835 Support Services $ 493,003 $ 2,486,935 $ 1,335,227 $ 1,123,527 $ 5,438,692 $ 5,438,692 Total $ 525,957 $ 1,690,118 $ - $11,761,603 $ 3,525,631 $ 2,063,896 $ 19,567,205 Citywide, Department,and Division Overhead Allocation Overhead Costs Police Admin-Personnel Costs $ 398,683 $ 398,683 Police Admin-M&S $ 127,274 $ 127,274 Back Out Citywide Police Admin OH $ (187,265) $ (187,265) Reallocate Citywide Police Admin OH $ 187,265 $ 187,265 $ $ $ - Back Out Reallocate Citywide Police Admin• Citywide Citywide Dept.Divisions' Overhead Personnel Police Admin- Police Admin Police Admin Total Divisions Indirect Costs Allocation Costs M&S OH OH Overhead Police Administration $ - $ 187,265 $ - $ - $ (187,265) $ - $ - $ - $ - $ - Police Operations $ - $ 987,619 $ 247,629 $ 78,875.55 $ - $ 116,054 $ - $ - $ - $ 1,430,178 Support Services $ - $ 452,607 $ 151,054 $ 48,398 $ - $ 71,211 $ - $ - $ - $ 723,271 Total $ - $ 1,627,492 $ 398,683 $ 127,274 $ (187,265) $ 187,265 $ - $ - $ - $ 2,153,449 Allocate Departmental Indirect Costs Using' Direct FTEs I Direct Salaries I Remove Admin I Direct Salaries and Wades Citywide OH and Wades Department Allocation Data Direct Salaries and Total Dept. Remove Wages Divisions'Cost Direct FTEs Admin Citywide OH Police Administration $ - $ 715,999 _ 1 Police Operations $ 4,052,989 $ 8,190,835 50.00 Support Services $ 2,486,935 $ 5,438,692 30.50 Total $ 6,539,924 $ 14,345,526 80.50 1 0 0 0 7/31/2013 Section IX-Page 37 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Multiple Overhead Rate Worksheet-Public Works FY 2013-14 Proposed Budget Overhead Rates(Rate Base=Direct Salaries&Wages) Total Citywide Dept. Departmental Divisions Rate Overhead Overhead Paid Time Off Admin Time Benefits Parks&Grounds 220.71% 38 16% 43 80% 31 59% 59 81% 47 36% Check 0 K Street Maintenance _ _ 243.12% 4803% 49 10% 31 59% 5981% 5459% Check OK Project Engineering 221.05% 39 75% 42 62% 31 59% 59 81% 47 29% Check O K Sanitary Sewer Fund 297.48% 109 53% 47 44% 31 59% 59 81% 49 12% Check O K Stormwater Fund 295.87% 95 16% 52 56% 31 59% 59 81% 56 76% Check 0 K VVater Fund 334.66% 143 60% 4790% 31 59% 5981% 51 76% Check OK Healthy Streams 0.00% 0 00% 0 00% 0 00% 0 00% 0 00% Check OK Dept.Average 262.31% 86 28% 34 53% 3159% 59 81% 5011% Public Works Department:Total Department Divisions'Costs I Dept Direct Expenditures Dept Unallowable Divisions' Salaries and Total Benefits for all other Total Dept Overhead Divisions'Cost Departmental Divisions Indirect Costs Wages purposes Public Works Administration $ 1,235,045 $ 390,810 _ $ 1,625,855 $1,625,855 Parks&Grounds $ 245,868 $ 705,184 $ 33_3,943 $ 388,865 $ 1,673,860 $1,673,860 Street Maintenance $ 378,454 $ 433,113 $ 23_6,426 $ 496,674 $ 1,544,667 $2,151,045 Project Engineering $ 432,134 $ 986,773 $ 46_6,653 $ 164,863 $ 2,050,423 $2,050,423 Sanitary Sewer Fund $ 583,343 $ 410,758 $ 201,747 $ 708730 $ 1,904,778 $9,714,969 Stormwater Fund $ 421,864 $ 295,090 $ 167,499 $ 519,648 $ 1,404,101 $3,862,462 VVater Fund $ 1,301,852 $ 746,247 $ 38_6,262 $ 5,532,962 $ 7,967,323 $7,967,323 Healthy Streams $ 7,217 $ - $ - $ 10,000 $ 17,217 $ 17,217 Total $ 1,235,045 t$ 3,761,542 I$ - ,$3,577,165 t$1,792,530 I$ 7,821,942 $ 18,188,224 Citywide,Department,and Division Overhead Allocation Overhead Costs I Public VVorks Admin-Personnel Costs I$ 982,544 $ 982,544 Public VVorks Admin-M&S $ 252,501 $ 252,501 Back Out Citywide PVV Admin OH $ (414,46E $ (414,461) Reallocate Citywide PVV Admin OH $ 414,461 $ 414,461 $ - Dept. Public VVorks Divisions' Citywide Admin- Back Out Reallocate Indirect Overhead Personnel Public VVorks Citywide PVV Citywide PVV Total Divisions Costs Allocation Costs Admin-M&S Admin OH Admin OH Overhead Public Works Administration $ - $ 414,461 $ - $ - $ (414,461) $ - $ - $ - $ - $ - Parks&Grounds $ - $ 269,083 $ 177,404 $ 49,777 $ - $ 81,705 $ - $ - $ - $ 577,968 Street Maintenance $ - $ 208,037 $ 131,916 $ 30,572 $ - $ 50,182 $ - $ - $ - $ 420,706 Project Engineering $ - $ 392,226 $ 236,538 $ 69,653 $ - $ 114,330 $ - $ - $ - $ 812,748 Sanitary Sewer Fund $ - $ 449,912 $ 118,269 $ 28,994 $ - $ 47,592 $ - $ - $ - $ 644,767 Stormwater Fund $ - $ 280,796 $ 100,074 $ 20,829 $ - $ 34,190 $ - $ - $ - $ 435,890 VVater Fund $ - $ 1,071,590 $ 218,343 $ 52,675 $ - $ 86,462 $ - $ - $ - $1,429,071 Total $ - $ 3,086,243 $ 982,544 $ 252,501 $ (414,461) $ 414,461 $ - $ - $ - $4,321,288 Allocate Departmental Indirect Costs Using Direct FTES Direct Salanes I Remove Admin I Direct Salanes and Wages I Citywide OH I and Wages Department Allocation Data Direct Salaries Total Dept Remove Direct FTES Admin I and Wages Divisions'Cost Citywide OH Public Works Administration $ - $ 1,625,855 _ 1 Parks&Grounds $ 705,184 $ 1,673,860 9 75 Street Maintenance $ 433,113 $ 1,544,667 7 25 Project Engineering $ 986,773 $ 2,050,423 13 00 Sanitary Sewer Fund $ 410,758 $ 1,904,778 6 50 Stormwater Fund $ 295,090 $ 1,404,101 5 50 VVater Fund $ 746,247 $ 7,967,323 12 00 Total $ 3,577,165 $ 18,188,224 54.00 1 0 0 0 7/31/2013 Section IX-Page 38 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard,OR Multiple Overhead Rate Worksheet -Community Development FY 2013-14 Proposed Budget Overhead Rates(Rate Base=Direct Salaries&Wages) Total Citywide Dept. Departmental Divisions Rate Overhead Overhead Paid Time Off Admin Time Benefits Budding 145.11% 42 79% 22 02% 2176% 1429% 44 25% CheckOK Development Services 156.79% 53 71% 21 43% 21 76% 14 29% 45 60% Check 0 K Community Planning 146.97% 45 33% 23 31% 21 76% 14 29% 42 28% Check OK Downtown Redevelopment 153.17% 44 69% 22 33% 21 76% 14 29% 50 11% Check 0 K Check O K Dept.Average 148.41% 50 92% 17 44% 21 76% 14 29% 44 00% Community Development Department:Total Department Divisions'Costs Dept I Direct Expenditures Total Dept Divisions' Total Dept OH Unallowable Salaries and for all other Divisions' Indirect Wages Benefits purposes Cost Departmental Divisions Costs Community Development Admin $ 298,972 $ 94,902 $ 393,874 $ 393,874 Building $ 394,359 $ 635,845 $ 281,372 $ 111,325 $1,422,901 $1,422,901 Development Services $ 196,759 $ 322,103 $ 146,880 $ 174,575 $ 840,317 $ 840,317 Community Planning _ $ 364,021 _ $ 676,527 $ 286,016 $ 238,915 $1,565,479 $1,565,479 Downtown Redevelopment $ 42,017 $ 79,897 $ 40,035 $ 21,175 $ 183,124 $ 183,124 Total $ 298,972 I$1,092,058 I$ - $1,714,372 $ 754,303 I$ 545,990 $4,405,695 Citywide,Department,and Division Overhead Allocation Overhead Costs Comm Devl Admin-Personnel Costs)$ 268,817 $ 268,817 Comm Devl Admin-M&S $ 30,155 $ 30,155 Back Out Citywide CD Admin OH $ (85,580) $ (85,580) Reallocate Citywide CD Admin OH $85,580 I $ 85,580 J_i_J $ Dept Comm Devl Divisions' Citywide Admin- Back Out Reallocate Indirect Overhead Personnel Comm Devl Citywide CD Citywide CD Total Divisions Costs Allocation Costs Admin-M&S Admin OH Admin OH Overhead Community Development Admin $ - $ 85,580 $ - $ - $ (85,580) $ - $ - $ - $ - $ - Building $ - $ 272,082 $ 97,073 $ 11,184 $ - $ 31,741 $ - $ - $ - $ 412,079 Development Services $ - $ 172,999 $ 47,292 $ 5,666 $ - $ 16,079 $ - $ - $ - $ 242,036 Community Planning $ - $ 306,675 $ 112,007 $ 11,900 $ - $ 33,772 $ - $ - $ - $ 464,354 Downtown Redevelopment $ - $ 35,704 $ 12,445 $ 1,405 $ - $ 3,988 $ - $ - $ - $ 53,543 Total $ - $ 873,040 $ 268,817 $ 30,155 $ (85,580) $ 85,580 $ - $ - $ - $1,172,012 Allocate Departmental Indirect Costs Using Direct FTEs Dinmoen - and rect Wages Salaes Re Citywide OH eAdmm Direct and Wages Salaes Department Allocation Data Direct Total Dept Remove Salaries and Divisions' Direct FTEs Admin Wages Cost Citywide OH Community Development Admin $ - $ 393,874 1 Building $ 635,845 $1,422,901 7 80 Development Services $ 322,103 $ 840,317 3 80 Community Planning $ 676,527 $1,565,479 9 00 Downtown Redevelopment $ 79,897 $ 183,124 1 00 Total $1,714,372 $4,405,695 21.60 1 0 0 0 7/31/2013 Section IX-Page 39 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Single Overhead Rate Worksheet - Municipal Court FY 2013-14 Proposed Budget Municipal Court Overhead Rates(Rate Base=Direct Salaries&Wages) I offal Citywide Rate Indirect Dept Indirect Paid Time Off Admin Time Benefits 121.07% 44.19% 0.00% 15.28% 14.29% 47.32% �Check O.K. Indirect Direct Total Expenditures Excluded Unallowable Salaries and for all other Total Cost Department Costs Wages Benefits p pur oses Municipal Court $ 143,168 $ 233,480 $ 110,493 $ 40,850 $ 527,991 $527,991 $ - $ 143,168 $ - $ 233,480 $ 110,493 $ 40,850 $ 527,991 Departmental Indirect $ - $ - $ Citywide OH from ICAP $ 103,164 $ 103,164 $ 103,164 $ 103,164 Total Department $ - $ 143,168 $ 103,164 $ 233,480 $ 110,493 $ 40,850 $ 631,155 P.9608 0 18181P,01 I °Eing".71OUZZ 70"8=07.1 U U U U U U U U U U U U U U U EULZ"L LUZ Z,UaLrj LUZ Z LUZ"L LUZ Z ,UE Zo"Z LL7Z,ULLUZ,UE,ULUZ LUZ Z LU„"Z LUL"Z LUZ Z LU„"Z,ULEErj LUZ Z LUZ Z,UZZ Z LULU Z LUE,""j LU,E7.LUZ. = a .01eLil■■ •11■2 • • .Ji.L21.1..” I MP NM MP IP t■e. .. ‘ .imuneeemmen M111 W.f.= 4i..1 M”1 MR.f..1• 1•11”MIP^ MP ILM 4281.i2 Mt. ..1•1”• M.”• • - Ma=LPL. tai■2 •I 7LM •Oaf •:1:1. 1 EZIS MP IP M111 M M. •Oaf MUM.]•LI.f /51f2 ■I,N,E ,,Me PIP Mal k41■2 i...11f.1 NI ■:INZE/ MP IP MEI •&411.2 IM2•I LIYM.M.9 FTSI ILES MOMI ff:1 I MI•Id..HM.1 WA 1 LI MI Filif..11•24.1.M2 MII -l1179M.1 L3.:■.M.IRMil•71 91M.I•11 St M.1 .1 NI ff!/ 1 ntlf.1 al!” E,11 P EMI ...MUM..12 MR/ •1911M.1 WILRISMI MEM] 21. ..1 Mali]KIM .211i.1 ME.IM2 MINIM] ■9MIFKLI MP UM le PM •2118■2 •0 EZ:11 EMI ■:INIFEM Ea. MP IP E .1■2 • Hai .711 aZA. 1 ■:1 1M,,LY..I MP IP aff i...117 EMI aktf..1 L141 BIM]■9■NER:1111iW.I MP IP E142 P M.1 :.•1- 1 HIM] ,M112M.1 •141. 1 =NMI■:%.-11 MP IP •IE■!/■.1i.1 lb Mai] " IP MIL Eaft■.1 k4E”1=if] IMPIPMUM !■1■2 •Ai] V.M.1 • ita P ELM .• MIME. • F11”1 El.”1 ff: ■:IN,IFLRY. ••Me P KEE !... ..1•71f2 M.M.1•1.”1 ■:IMEL.111,1.6■..[J. 11 MP UM&t. .■2 Etif • i2 E.71 MP P EP gig E.7. 1i.1 .f ■:1,N,IFLJ1/. 1 MP IP E EL1■2 .M.”1 • MP IP le •Lai] W.,”1 11. .1 i..1.11f • M:11• 9M 2Y.1 4 EN MP IP n[1 •,113.■.lif LI. A ELI2 ff!.11=.12.... ..1 •Elf.1 ni.1 Wilf.1• WIL1f 'Ma FM MP •2.11■2 .F1 Lig .f ni.1 i.Iff.f al If] MI.M1 ilLY/1.1,AbLa■lLE.3 P 11. LIIIM, 1 Mai M2 MEM EMMA WE 5 .1.7 •1111=.1 .•1. 1.1511i1 MIAMI•Li,JMI•0 MIMI NIMM.1■". I MUM 0 4. .31.9■2 MAMMA • ff: .•1”• "" I if la 4. raMIMI Mt NMI •1111.M.1 MLIS Mali]WE TIM] 17 .1•111 .Naelf Mt I MI REI.Li, 1 NES.i2•011M.1 MILL.f MIAMI :.Y.MIMME711=2i.1 .•111•411tlif Mi”1.72,11■11LL.11,..011.1M1P4.71Y1. LS= Ma1. 1 MIL1f Lettl KM]NIM.f...!”1•1 n!.tM.1. 1• MIL/ 1 .•4”1.111.i.1•PHI Mali] Ma hi 12 0 4. E1171■.1if REMIIM.1 .•11 LLe MIIMMPIN $8,08/0 Zo( (8. %EL 0 LW 0, ab. (bt. peobb Lbs. ,babee ..bb rims I ibb, "Z:re" :■"" " Zr.:.7 == ==. 7L7.°Z 7=r.'°-""" P..d.d 04 M7, 0 PEE. 000O 00U 0, O. O. OOZE OOZE MIL MIL MIL MIL 00E .1 .1 .1 .1 .1 .1 .0'UELZ MI OM OM I °U.° 'EU UU° 'PU"'UD JO P M.Pq O City of Tigard,OR Indirect Cost Model for the FY 2013-14 Budget Year Departmental Indirect Cost Rates-Citywide Allocations FY 2013-14 Proposed Budget Allocation Factor used as base of Indirect Cost Rate 32 Total Allocations for the FY 2013-14 Plan(Using FY 2013-14 Proposed Proposed Total Direct Salaries& Indirect Cost Department Budget) Carry-Forward Costs Wages Rates 100 1400 Municipal Court $ 103,164 $ - $ 103,164 $ 233,480 44.19% 100 3000 Community Development Admin $ 85,580 $ - $ 85,580 NA 230 3100 Building $ 272,082 $ - $ 272,082 $ 635,845 42.79 100 3200 Development Services $ 172,999 $ - $ 172,999 $ 322,103 53.71 100 3300 Community Planning $ 306,675 $ - $ 306,675 $ 676,527 4533 100 3700 Downtown Redevelopment $ 35,704 $ - $ 35,704 $ 79,897 44.69 100 4000 Police Administration $ 187,265 $ - $ 187,265 $ 272,201 68.80 100 4100 Police Operations $ 987,619 $ - $ 987,619 $ 4,052,989 2437 100 4200 Support Services $ 452,607 $ - $ 452,607 $ 2,486,935 1820% 100 5000 Library Administration $ 217,038 $ - $ 217,038 $ 248,592 8731 100 5100 Library Readers'Services $ 792,744 $ - $ 792,744 $ 806,987 9824% 100 5200 Library Technical Services $ 176,490 $ - $ 176,490 $ 307,998 5730 100 5300 Library Circulation $ 325,306 $ - $ 325,306 $ 695,392 46.78 100 5900 Social Svcs&Community Events $ 102,588 $ - $ 102,588 $ - NA 100 6000 Public Works Administration $ 414,461 $ - $ 414,461 $ 675,775 6133 100 6100 Parks&Grounds $ 269,083 $ - $ 269,083 $ 705,184 38.16 200 6200 Street Maintenance $ 208,037 $ - $ 208,037 $ 433,113 48.03 100 6250 Project Engineering $ 392,226 $ - $ 392,226 $ 986,773 39.75 100 0000 CIP/Transfers/Contingency $ 8,640 $ - $ 8,640 $ - NA 200 6800 Gas Tax Fund(Street Lights&Signals) $ 24,804 $ - $ 24,804 $ - NA 205 0000 City Gas Tax Fund $ 3,778 $ - $ 3,778 $ - NA 220 0000 Electrical Inspection Fund $ 1,795 $ - $ 1,795 $ - NA 240 0000 Criminal Forfeiture Fund $ 401 $ - $ 401 $ - NA 260 0000 Urban Forestry Fund $ 6,229 $ - $ 6,229 $ - NA 300 0000 Bancroft Debt Service Fund $ 3,821 $ - $ 3,821 $ - NA 350 0000 GO Debt Service Fund $ 5,036 $ - $ 5,036 $ - NA 400 0000 Facilities Fund $ 19,384 $ - $ _ 19,384 $ - NA 405 0000 Transportation Development Tax $ 10,374 $ - $ 10,374 $ - NA 410 0000 Traffic Impact Fee $ 2,307 $ - $ 2,307 $ - NA 411 0000 Underground Utility Fund $ 2,089 $ - $ 2,089 $ - NA 412 0000 Street Maintenance Fee Fund $ 108,883 $ - $ 108,883 $ - NA 420 0000 Parks Capital Fund $ 100,397 $ - $ 100,397 $ - NA 421 0000 Parks Bond Fund $ 24,883 $ - $ 24,883 $ - NA 425 0000 Parks SDC Fund $ 13,197 $ - $ 13,197 $ - NA 460 0000 Transportation CIP Fund $ 61,864 $ - $ 61,864 $ - NA 500 6600 Sanitary Sewer Fund $ 449,912 $ - $ 449,912 $ 410,758 109.53 510 6700 Stormwater Fund $ 280,796 $ - $ 280,796 $ 295,090 95.16 511 0000 Water Quality/Quantity Fund $ 7,659 $ - $ 7,659 $ - NA 530 6500 Water Fund $ 1,071,590 $ - $ 1,071,590 $ 746,247 143.60% 531 0000 Water SDC Fund $ 165 $ - $ 165 $ - NA 532 0000 Water CIP Fund $ 546,672 $ - $ 546,672 $ - NA 533 0000 Water Debt Service Fund $ 12,620 $ - $ 12,620 $ NA 600 1500 Recorder/Records-Elections Supervisor $ 3,624 $ - $ 3,624 $ 13,269 2731 600 2000 Fin&Info Srvcs-Passports/Business Licensing $ 10,432 $ - $ 10,432 $ 37,611 27.74 660 0000 Insurance Fund $ 531 $ - $ 531 $ - NA 930 0000 Urban Renewal Debt Srvc $ - $ - $ - $ - NA 940 9000 Urban Renewal Cap Improvements $ 4,731 $ - $ 4,731 $ - NA 510 6260 Healthy Streams $ 138 $ - $ 138 $ 71,068 0.19 Other Jurisdictions $ 8,317 $ - $ 8,317 $ - NA All Other $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA -$ - $ - $ $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA $ - $ - $ $ - NA $ - $ - $ - $ - NA 7/31/2013 Section IX-Page 42 of 53 Tigard ICAP Budget 2014-Budget System Load Tota I Allocations for the FY 2013-14 Plan(Using FY 2013-14 Proposed Proposed Total Direct Salaries& Indirect Cost Department Budget) Carry-Forward Costs Wages Rates $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ $ $ $ NA $ - $ - $ - $ - NA $ $ $ $ NA $ - $ - $ _ - $ - NA $ $ $ _ $ NA $ - $ - $ _ - $ - NA $ - $ - $ _ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ - $ - NA $ - $ - $ _ - $ - NA $ - $ - $ - $ - NA $ $ $ $ NA #N/A #N/A #N/A #REF! NA #N/A #N/A #N/A #REF! NA #N/A #N/A #N/A #REF! NA #N/A #N/A #N/A #REF! NA #N/A #N/A #N/A #REF! NA #N/A #N/A #N/A #REF! NA #N/A #N/A #N/A #REF! NA #N/A #N/A #N/A #REF! NA 1 I 1 'TOTAL II #N/A II #N/A II #N/A I I #REF! I I NA 7/31/2013 Section IX-Page 43 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward 100 100 230 100 I 100 1 100 100 100 100 FY 2013-14 Proposed Budget 1400 3000 3100 3200 3300 3700 4000 4100 4200 Community Downtown Municipal Development Developmen Community Redevelopme Police Police Support DEPARTMENT Court Admin Building t Services Planning nt Administration Operations Services 100 0500 Mayor&Council $ - $ - $ 2,241 $ 29,554 $ 45,562 $ - $ 31,376 $ - $ - 600 1000 City Mngmnt-City Manager $ 6,334 $ 4,055 $ 15,539 $ 9,167 $ 17,744 $ 1,994 $ 6,387 $ 97,343 $ 62,004 600 1000 City Mngmnt-Web Services $ - $ 3,295 $ 12,851 $ 7,579 $ 14,828 $ 1,648 $ 246 $ 4,101 $ 2,584 600 1100 Human Resources $ 12,026 $ 7,400 $ 28,861 $ 17,020 $ 33,301 $ 3,700 $ 11,100 $ 185,005 $ 116,553 600 1200 Risk Mngmnt-Insurance Premiums $ 2,696 $ 1,745 $ 7,539 $ 4,255 $ 6,557 $ 1,057 $ 3,533 $ 51,412 $ 30,440 600 1200 Risk Mngmnt-Claims&Misc $ 480 $ 1,791 $ 4,122 $ 5,127 $ 1,341 $ 150 $ 2,696 $ 107,898 $ 9,123 600 1300 Design&Comm-Mail $ 1,487 $ 929 $ 3,600 $ 2,123 $ 4,137 $ 462 $ 1,421 $ 22,874 $ 14,471 600 1300 Design&Comm-Graphics $ 22,286 $ 2,521 $ 507 $ 5,042 $ 28,740 $ 13,614 $ 7,778 $ 1,092 $ 4,777 600 1300 Design&Comm-Copiers $ 406 $ 1,001 $ 4,074 $ 3,847 $ 2,137 $ 9 $ 3,316 $ 3,222 $ 248 600 1500 Recorder/Records-Records Management $ 510 $ 70 $ 83,305 $ 22,385 $ 280 $ 33 $ 6,643 $ 1,465 $ 973 600 1500 Recorder/Records-Council Support $ - $ - $ 1,467 $ 19,348 $ 29,828 $ - $ 20,541 $ - $ - 600 1500 Recorder/Records-Records Requests $ 192 $ 8,922 $ 4,037 $ - $ - $ - $ 384 $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ 261 $ 193 $ 695 $ 411 $ 765 $ 90 $ 350 $ 4,003 $ 2,658 600 2100 Fin Ops-Fin Rprting/Mngmnt $ 1,738 $ 1,280 $ 4,624 $ 2,731 $ 5,087 $ 595 $ 2,327 $ 26,618 $ 17,674 600 2100 Fin Ops-Accounting/GL $ 7,632 $ 8,411 $ 10,750 $ 9,027 $ 10,996 $ 6,196 $ 12,063 $ 14,155 $ 19,859 600 2100 Fin Ops-AP $ 13,262 $ 596 $ 970 $ 511 $ 1,515 $ 443 $ 2,298 $ 9,670 $ 6,486 600 2100 Fin Ops-Payroll $ 1,884 $ 1,159 $ 4,522 $ 2,667 $ 5,218 $ 580 $ 1,739 $ 28,987 $ 18,262 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading _ $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT-Support $ 20,691 $ 37,981 $ 52,417 $ 13,625 $ 33,490 $ 2,483 $ 10,401 $ 89,675 $ 78,984 600 2300 IT- GIS $ 3,384 $ 1,675 $ 6,493 $ 3,830 $ 46,799 $ 833 $ 5,451 $ 32,538 $ 20,596 600 2500 Contracts and Purchasing $ 411 $ 2,555 $ 4,215 $ 653 $ 8,705 $ 414 $ 3,767 $ 15,195 $ 9,002 650 6300 Fleet Maintenance $ - $ _ - $ 1,684 $ 2,177 $ 1,347 $ - $ 299 $ 107,828 $_ 37,914 650 6400 Property Management $ 7,484 $ - $ 17,568 $ 11,922 $ 8,298 $ 1,405 $ 53,149 $ 184,538 $ - Total Allocations for the FY 2013-14 Plan (Using FY 2013-14 Proposed Budget) $ 103,164 $ 85,580 $ 272,082 $ 172,999 $ 306,675 $ 35,704 $ 187,265 $ 987,619 $ 452,607 ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) Carry-Forward $ - $ - $ - $ - $ - $ - $ - I $ - $ - Proposed Costs I$ 103,164 $ 85,580 $ 272,082 $ 172,999 $ 306,675 $ 35,704 $ 187,265 $ 987,619 $ 452,607 7/31/2013 Section VII-Page 44 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward I 100 100 1 100 100 I 100 100 100 200 100 FY 2013-14 Proposed Budget 1 5000 5100 5200 5300 5900 6000 6100 6200 6250 Social Svcs Library Library & Library Readers' Technical Library Community Public Works Parks& Street Project DEPARTMENT Administration Services Services Circulation Events Administration Grounds Maintenance Engineering 100 0500 Mayor&Council I$ 3,694 $ - $ - $ - $ - $ 23,397 $ - $ - $ 38,173 600 1000 City Mngmnt-City Manager 1$ 6,431 $ 25,866 $ 10,609 $ 23,732 $ 249 $ 18,200 $ 19,169 $ 14,984 $ 25,116 600 1000 City Mngmnt-Web Services )$ 1,657 $ 6,577 $ 2,952 $ 6,836 $ - $ 3,632 $ 3,849 $ 2,862 $ 5,133 600 1100 Human Resources _ $ 11,840 $ 46,991 $ 21,091 $ 48,841 $ - $ 34,041 $ 36,076 $ 26,826 $ 48,101 600 1200 Risk Mngmnt-Insurance Premiums $ 10,770 $ 16,742 $ 11,929 $ 17,086 $ - $ 12,628 $ 23,493 $ 9,434 $ 15,557 600 1200 Risk Mngmnt-Claims&Misc $ 485 $ 1,947 $ 1,540 $ 3,304 $ 16 $ 3,593 $ 16,241 $ 23,398 $ 15,210 600 1300 Design&Comm-Mail $ 1,482 $ 5,911 $ 2,565 $ 5,866 $ 22 $ 4,234 $ 4,477 $ 3,443 $ 5,930 600 1300 Design&Comm-Graphics $ 47,197 $ 77,001 $ - $ - $ - $ 4,396 $ 5,494 $ - $ 19,230 600 1300 Design&Comm-Copiers $ 4,526 $ 1,907 $ 477 $ 2,257 $ 0 $ 6,320 $ 319 $ 2 $ 5,119 600 1500 Recorder/Records-Records Management $ 841 $ 456 $ 131 $ 242 $ 18 $ 3,965 $ 299 $ 385 $ 7,356 600 1500 Recorder/Records-Council Support $ 2,419 $ - $ - $ - $ - $ 15,317 $ - $ - $ 24,991 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ 1,500 $ - $ - $ 736 600 2000 Fin&Info Srvcs-Budget/CIP $ 297 $ 1,246 $ 358 $ 662 $ 50 $ 795 $ 818 $ 1,051 $ 1,002 600 2100 Fin Ops-Fin Rprting/Mngmnt $ 1,972 $ 8,284 $ 2,384 $ 4,402 $ 332 $ 5,284 $ 5,440 $ 5,020 $ 6,663 600 2100 Fin Ops-Accounting/GL $ 10,052 $ 27,654 $ 20,515 $ 6,401 $ 41 $ 13,376 $ 16,946 $ 10,381 $ 13,909 600 2100 Fin Ops-AP $ 2,128 $ 13,705 $ 272 $ 732 $ 392 $ 2,298 $ 4,750 $ 4,052 $ 1,038 600 2100 Fin Ops-Payroll $ 1,855 $ 7,363 $ 3,305 $ 7,653 $ - $ 5,334 $ 5,653 $ 4,203 $ 7,537 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading _ _ $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT-Support $ 63,078 $ 131,581 $ 29,501 $ 42,020 $ 82 $ 70,134 $ 24,662 $ 7,026 $ 69,803 600 2300 IT- GIS $ 14,282 $ 12,716 $ 3,926 $ 8,629 $ 36 $ 35,113 $ 11,542 $ 6,617 $ 49,876 600 2500 Contracts and Purchasing 1$ 2,791 $ 10,465 $ 6,455 $ 458 $ 15 $ 6,049 $ 10,569 $ 15,521 I $ 4,039 650 6300 Fleet Maintenance 1$ - ' $ - $ - $ - $ - $ 1,267 $ 24,680 $ 12,593 $ 1,302 650 6400 Property Management I$ 29,240 $ 396,333 $ 58,480 $ 146,186 $ 101,335 $ 143,586 $ 54,606 $ 60,239 $ 26,404 Total Allocations for the FY 2013-14 Plan (Using FY 2013-14 Proposed Budget) $ 217,038 $ 792,744 $ 176,490 $ 325,306 $ 102,588 I $ 414,461 $ 269,083 _ $ 208,037 _ $ 392,226 ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) F Carry-Forward $ - $ - $ - $ - $ - $ - $ - $ - $ - Proposed Costs $ 217,038 $ 792,744 $ 176,490 $ 325,306 $ 102,588 $ 414,461 $ 269,083 $ 208,037 $ 392,226 7/31/2013 Section VII-Page 45 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward I 100 200 205 220 240 260 300 350 400 405 FY 2013-14 Proposed Budget I 0000 6800 0000 0000 0000 0000 0000 0000 0000 0000 Transporta Gas Tax Fund Electrical Criminal Urban GO Debt tion CIP/Transfers/ (Street Lights City Gas Tax Inspection Forfeiture Forestry Bancroft Debt Service Facilities Developme DEPARTMENT Contingency I &Signals) Fund Fund i Fund Fund Service Fund Fund Fund nt Tax 100 0500 Mayor&Council I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager I$ 2,068 $ 1,777 $ - $ 445 $ 122 $ 372 $ - $ - $ 3,295 $ 3,136 600 1000 City Mngmnt-Web Services ,1$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1100 Human Resources $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - - 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ 135 $ 116 $ 51 $ 29 $ 8 $ 24 $ 79 $ 348 $ 567 $ 204 600 1300 Design&Comm-Mail $ 182 $ 157 $ 26 $ 39 $ 11 $ 33 $ 41 $ 178 $ 471 $ 276 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ 1 $ 1 $ 0 $ 0 $ 0 $ 0 $ 0 $ 2 $ 3 $ 1 600 1500 Recorder/Records-Records Management $ 152 $ 131 $ 58 $ 33 $ 9 $ 27 $ 90 $ 392 $ 640 $ 230 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ 415 $ 357 $ 158 $ 89 $ 24 $ 75 $ 245 $ 1,072 $ 1,792 $ 629 600 2100 Fin Ops-Fin Rprting/Mngmnt $ 2,760 $ 2,372 $ - $ 594 $ 162 $ 496 $ - $ - $ 4,330 $ 4,185 600 2100 Fin Ops-Accounting/GL $ 1,190 $ 5,457 $ 2,913 $ 328 $ - $ 369 $ 739 $ 164 $ 2,708 $ 41 600 2100 Fin Ops-AP $ - $ 11,032 $ 153 $ - $ - $ 51 $ - $ 34 $ 85 $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading _ _ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT-Support $ 682 $ 586 $ 259 $ 147 $ 40 $ 123 $ 402 $ 1,763 $ 2,873 $ 1,035 600 2300 IT- GIS $ 296 $ 254 $ 112 $ 64 $ 17 $ 53 $ 175 $ 765 $ 2,101 $ 449 600 2500 Contracts and Purchasing I$ 759 $ 2,566 $ 47 $ 27 $ 7 $ 4,605 $ 2,051 $ 318 $ 519 $ 187 650 6300 Fleet Maintenance I$ _- $ - $ - $ - $ - $ - $ - $ - $ - $ - 650 6400 Property Management I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Allocations for the FY 2013-14 Plan I (Using FY 2013-14 Proposed Budget) $ 8,640 $ 24,804 $ 3,778 $ 1,795 $ 401 $ 6,229 $ 3,821 $ 5,036 $ 19,384 $ 10,374 ss:FY 2013-14 Plan(Based on FY 2011-12 Proposed $ - $ - $ 11-1911$ - $ - $ - $ - $ - $ - $ -,, Proposed Costs $ 8,640 $ 24,804 $ 3,778 $ 1,795 $ 401 $ 6,229 $ 3,821 $ 5,036 $ 19,384 $ 10,374 7/31/2013 Section VII-Page 46 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward I 410 411 412 420 421 425 460 500 510 FY 2013-14 Proposed Budget I 0000 0000 0000 0000 0000 0000 0000 6600 6700 Undergroun Street Traffic d Utility Maintenanc Parks Capital Parks Bond Parks SDC Transportation Sanitary Stormwater DEPARTMENT Impact Fee Fund e Fee Fund Fund Fund Fund CIP Fund Sewer Fund Fund 100 _ 0500 _Mayor&Council I$ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager I$ 625 $ 609 $ 4,513 $ 28,365 $ 7,535 $ 3,743 $ 16,751 $ 33,715 $ 17,918 600 1000 City Mngmnt-Web Services )$ - $ - $ - $ - $ - $ - $ - $ 2,566 $ 2,171 600 1100 Human Resources _ $ - $ - $ - $ - $ - $ - $ - $ 24,051 $ 20,351 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - $ - $ - $ 8,866 $ 7,456 600 1200 Risk Mngmnt-Claims&Misc $ 41 $ 40 $ 729 $ 4,901 $ 491 $ 244 $ 2,894 $ 25,765 $ 12,161 600 1300 Design&Comm-Mail $ 55 $ 54 $ 620 $ 4,061 $ 664 $ 330 $ 2,398 $ 5,847 $ 3,420 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - $ - $ - $ - $ 2,195 600 1300 Design&Comm-Copiers $ 0 $ 0 $ 4 $ 27 $ 3 $ 1 $ 16 $ 20 $ 6 600 1500 Recorder/Records-Records Management $ 46 $ 45 $ 822 $ 5,527 $ 554 $ 275 $ 3,264 $ 3,982 $ 1,282 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ 126 $ 122 $ 2,301 $ 15,482 $ 1,513 $ 751 $ 9,143 $ 11,127 $ 3,569 600 2100 Fin Ops-Fin Rprting/Mngmnt $ 835 $ 813 $ 629 $ - $ 10,058 $ 4,996 $ - $ 6,895 $ 6,050 600 2100 Fin Ops-Accounting/GL $ 246 $ 82 $ 1,313 $ - $ - $ 862 $ - $ 10,709 $ 12,350 600 2100 Fin Ops-AP $ - $ - $ 119 $ 1,958 $ 51 $ - $ 732 $ 3,303 $ 4,580 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - $ - $ - $ 3,768 $ 3,189 600 2200 Utility Billing-Billing $ - $ - $ 91,871 $ - $ - $ - $ - $ 67,653 $ 111,554 600 2200 Utility Billing-Meter Reading _ _ $ - $ - $ - $ - $ - $ - $ - $ 128,762 $ - 600 2300 IT-Support $ 206 $ 201 $ 3,693 $ 24,827 $ 2,487 $ 1,235 $ 14,661 $ 29,028 $ 11,265 600 2300 IT- GIS $ 90 $ 87 $ 1,602 $ 10,769 $ 1,079 $ 536 $ 6,360 $ 18,638 $ 21,231 600 2500 Contracts and Purchasing I$ 37 $ 36 $ 667 $ 4,481 $ 449 $ 223 $ 5,645 $ 15,465 I $ 19,470 650 6300 Fleet Maintenance I$ - $ - $ - $ - $ - $ - $ - $ 22,429 $ 4,994 650 6400 Property Management I$ - $ - $ - $ - $ - $ - $ - $ 27,323 $ 15,585 Total Allocations for the FY 2013-14 Plan I (Using FY 2013-14 Proposed Budget) $ 2,307 $ 2,089 $108,883 $ 100,397 $ 24,883 $ 13,197 $ 61,864 $ 449,912 $ 280,796 ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) F . W Carry-Forward $ - $ - $ - $ - $ - $ $ - $ - $ - Proposed Costs $ 2,307 $ 2,089 $108,883 $ 100,397 $ 24,883 $ 13,197 $ 61,864 $ 449,912 $ 280,796 7/31/2013 Section VII-Page 47 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward I 511 530 531 532 533 600 600 660 930 FY 2013-14 Proposed Budget I 0000 6500 0000 0000 0000 1500 2000 0000 0000 nil&lulu Recorder/Rec Srvcs- I Water ords- Passports/B Urban Quality/Quantity Water CIP Water Debt Elections usiness Insurance Renewal DEPARTMENT Fund Water Fund Water SDC Fund Fund Service Fund Supervisor Licensing Fund i Debt Srvc 100 0500 Mayor&Council 1$ - $ 22,411 $ - $ - $ - $ 654 $ 796 $ - $ - 600 1000 City Mngmnt-City Manager 1$ 2,324 $ 37,974 $ 13 $ 157,001 $ - $ 256 $ 834 $ 124 $ - 600 1000 City Mngmnt-Web Services ,1$ - $ 4,738 $ - $ - $ - $ - $ 299 $ - $ - 600 1100 Human Resources $ - $ 44,401 $ - $ - $ - $ 516 $ 1,741 $ - $ - _ 600 1200 Risk Mngmnt-Insurance Premiums $ - $ 38,488 $ - $ - $ - $ 124 $ 365 $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ 151 $ 28,601 $ 1 $ 27,094 $ 774 $ 20 $ 77 $ 8 $ - 600 1300 Design&Comm-Mail $ 205 $ 6,777 $ 1 $ 22,461 $ 396 $ 62 $ 208 $ 11 $ - 600 1300 Design&Comm-Graphics $ - $ 23,626 $ - $ - $ - $ 683 $ 633 $ - $ - 600 1300 Design&Comm-Copiers $ 1 $ 7 $ 0 $ 151 $ 4 $ 10 $ 28 $ 0 $ - 600 1500 Recorder/Records-Records Management $ 171 $ 1,425 $ 1 $ 30,553 $ 873 $ 140 $ 119 $ 9 $ - 600 1500 Recorder/Records-Council Support $ - $ 14,672 $ - $ - $ - $ 428 $ 521 $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ - $ 78 $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ 467 $ 3,894 $ 3 $ 85,582 $ 2,386 $ 8 $ 21 $ 25 $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ 3,102 $ 25,891 $ 17 $ 430 $ - $ 54 $ 140 $ 165 $ - 600 2100 Fin Ops-Accounting/GL $ - $ 17,192 $ 123 $ - $ - $ 114 $ - $ 123 $ - 600 2100 Fin Ops-AP $ - $ 13,432 $ - $ 1,856 $ 1,856 $ 22 $ 319 $ - $ - 600 2100 Fin Ops-Payroll $ - $ 6,957 $ - $ - $ - $ 81 $ 273 $ - $ - 600 2200 Utility Billing-Billing $ - $ 413,375 $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading _ _ $ - $ 221,705 $ - $ - $ - $ - $ - $ - $ - 600 2300 IT-Support $ 767 $ 20,401 $ 4 $ 137,242 $ 3,922 $ 421 $ 3,470 $ 41 $ - 600 2300 IT- GIS $ 333 $ 23,470 $ 2 $ 59,530 $ 1,701 $ 6 $ 447 $ 18 $ - 600 2500 Contracts and Purchasing 1$ 138 $ 24,511 $ 1 $ 24,771 $ 708 $ 25 $ 61 $ 7 $ - 650 6300 Fleet Maintenance 1$ - $ 42,243 $ _ - $ - $ - $ - $ - $ - $ - 650 6400 Property Management I$ - $ 35,398 $ - $ - $ - $ - $ - $ - $ - Total Allocations for the FY 2013-14 Plan (Using FY 2013-14 Proposed Budget) $ 7,659 $ 1,071,590 $ 165 $ 546,672 $ 12,620 $ 3,624 $ 10,432 $ 531 $ - ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) Carry-Forward $ - $ - $ - $ - $ - $ - Proposed Costs $ 7,659 $ 1,071,590 $ 165 $ 546,672 $ 12,620 $ 3,624 $ 10,432 $ 531 $ - 7/31/2013 Section VII-Page 48 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward I 940 510 FY 2013-14 Proposed Budget I 9000 6260 Urban Renewal Other Cap Healthy Jurisdiction DEPARTMENT Improvements Streams s All Other 100 _ 0500 _Mayor&Council I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager I$ 1,110 $ 42 $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-Web Services /P$ - $ - $ 8,317 $ - $ - $ - $ - $ - $ - $ - 600 1100 Human Resources $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - — 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ 72 $ 3 $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Mail $ 98 $ 4 $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ 0 $ 0 $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management $ 82 $ 3 $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ 223 $ 8 $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ 1,482 $ 56 $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-AP $ 1,073 $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading _ _ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT-Support $ 366 $ 14 $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT- GIS $ 159 $ 6 $ - $ - $ - $ - $ - $ - $ - $ - 600 2500 Contracts and Purchasing i$ 66 $ 2 $ - $ - $ - $ - $ - $ - $ - $ - 650 6300 Fleet Maintenance I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 650 6400 Property Management I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Allocations for the FY 2013-14 Plan I I I I I I (Using FY 2013-14 Proposed Budget) $ 4,731 $ 138 $ 8,317 $ - $ - $ - $ - $ - $ - $ - ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) Carry-Forward $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Proposed Costs $ 4,731 $ 138 $ 8,317 $ - $ - $ - $ - $ - $ - $ - 7/31/2013 Section VII-Page 49 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward FY 2013-14 Proposed Budget DEPARTMENT 100 _ 0500 _Mayor&Council I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-Web Services )$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1100 Human Resources $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - _ 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Mail $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-AP $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading _ _ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT-Support $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT- GIS $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2500 Contracts and Purchasing I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 650 6300 Fleet Maintenance I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 650 6400 Property Management I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Allocations for the FY 2013-14 Plan (Using FY 2013-14 Proposed Budget) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) Carry-Forward $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Proposed Costs $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 7/31/2013 Section VII-Page 50 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward FY 2013-14 Proposed Budget DEPARTM ENT 100 0500 _Mayor&Council $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-Web Services $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1100 Human Resources _ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Mail $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-AP $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading _ _ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT-Support $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT- GIS $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2500 Contracts and Purchasing I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 650 6300 Fleet Maintenance I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 650 6400 Property Management I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Allocations for the FY 2013-14 Plan (Using FY 2013-14 Proposed Budget) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) T Carry-Forward $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Proposed Costs $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 7/31/2013 Section VII-Page 51 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward FY 2013-14 Proposed Budget DEPARTM ENT 100 0500 _Mayor&Council $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-City Manager I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1000 City Mngmnt-Web Services $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1100 Human Resources _ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1200 Risk Mngmnt-Claims&Misc $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Mail $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1300 Design&Comm-Copiers $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Management $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-AP $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2200 Utility Billing-Meter Reading _ _ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT-Support $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2300 IT- GIS $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 600 2500 Contracts and Purchasing I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 650 6300 Fleet Maintenance I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 650 6400 Property Management I$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Total Allocations for the FY 2013-14 Plan (Using FY 2013-14 Proposed Budget) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) T Carry-Forward $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Proposed Costs $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 7/31/2013 Section VII-Page 52 of 53 Tigard ICAP Budget 2014-Budget System Load City of Tigard, OR Indirect Cost Model for the FY 2013-14 Budget Year Carry-Forward FY 2013-14 Proposed Budget DEPARTMENT Total 100 _ 0500 _Mayor&Council I$ - $ - $ - $ - $ - $ - $ - $ - $ 197,859 600 1000 City Mngmnt-City Manager I$ - $ - $ - $ - $ - $ - $ - $ - $ 689,590 600 1000 City Mngmnt-Web Services )$ - $ - $ - $ - $ - $ - $ - $ - $ 98,722 600 1100 Human Resources _ $ - $ - $ - $ - $ - $ - $ - $ - $ 779,832 600 1200 Risk Mngmnt-Insurance Premiums $ - $ - $ - $ - $ - $ - $ - $ - $ 282,171 600 1200 Risk Mngmnt-Claims&Misc $ - $ - $ - $ - $ - $ - $ - $ - $ 304,093 600 1300 Design&Comm-Mail $ - $ - $ - $ - $ - $ - $ - $ - $ 134,517 600 1300 Design&Comm-Graphics $ - $ - $ - $ - $ - $ - $ - $ - $ 266,813 600 1300 Design&Comm-Copiers $ - $ - $ - $ - $ - $ - $ - $ - $ 39,474 600 1500 Recorder/Records-Records Management $ - $ - $ - $ - $ - $ - $ - $ - $ 180,292 600 1500 Recorder/Records-Council Support $ - $ - $ - $ - $ - $ - $ - $ - $ 129,535 600 1500 Recorder/Records-Records Requests $ - $ - $ - $ - $ - $ - $ - $ - $ 15,849 600 2000 Fin&Info Srvcs-Budget/CIP $ - $ - $ - $ - $ - $ - $ - $ - $ 157,310 600 2100 Fin Ops-Fin Rprting/Mngmnt $ - $ - $ - $ - $ - $ - $ - $ - $ 178,969 600 2100 Fin Ops-Accounting/GL $ - $ - $ - $ - $ - $ - $ - $ - $ 275,387 600 2100 Fin Ops-AP $ - $ - $ - $ - $ - $ - $ - $ - $ 105,772 600 2100 Fin Ops-Payroll $ - $ - $ - $ - $ - $ - $ - $ - $ 122,187 600 2200 Utility Billing-Billing $ - $ - $ - $ - $ - $ - $ - $ - $ 684,452 600 2200 Utility Billing-Meter Reading _ _ $ - $ - $ - $ - $ - $ - $ - $ - $ 350,467 600 2300 IT-Support $ - $ - $ - $ - $ - $ - $ - $ - $ 1,039,798 600 2300 IT- GIS $ - $ - $ - $ - $ - $ - $ - $ - $ 414,687 600 2500 Contracts and Purchasing I$ - $ - $ - $ - $ - $ - $ - $ - $ 209,127 650 6300 Fleet Maintenance I$ - $ - $ - $ - $ - $ - $ - $ - $ 260,757 650 6400 Property Management I$ - $ - $ - $ - $ - $ - $ - $ - $ 1,379,078 Total Allocations for the FY 2013-14 Plan (Using FY 2013-14 Proposed Budget) $ - $ - $ - $ - $_ - $ - $ - $ - $ 8,296,738 ;s:FY 2013-14 Plan(Based on FY 2011-12 Proposed Budget) $ - Carry-Forward $ - $ - $ - $ - $ - $ - $ - $ - $ - Proposed Costs $ - $ - $ - $ - $ - $ - $ - $ - I I$ 8,296,738 7/31/2013 Section VII-Page 53 of 53 Tigard ICAP Budget 2014-Budget System Load