The URL can be used to link to this page

Home My WebLink AboutITEM IV-C-7 EQUIPMENT RENTAL DtViSION MtSS10N StATEMENT The mission of the Equipment Rental Division is to provide all City departments with a safe and reliable fleet, and the fleet support services that each department needs to perform its mission. . DEPARTMENT OVERVIEW. Equipment Rental is responsibie for maintenance, service, acquisition and disposition of the. City's vehide/equipment fleet. Central Stores is a component of Equipment,Rentat and is ' responsible for procuring, storing, and distributing supplies and materiel for many City _ operations. Central Stores also maintains the City's fuel storage and access system. 2009 & 2010 ACCOMPLISHMENTS o Upgraded the central lift to improve equipment rental shop efficiency . • Completed VHF radio rystem upgrade for daily and emergency communication . e Completed the installation of CarteGraph for Fleet and Central Stores m Implemented idle reduction ideas to all division - , - • Began converting vehicle emergenty lighting to LED to reduce fuel usage 2011 & 2012 OBJECTIVES Continue to improve fleet fuel economy . ~ l.ook for ways to extend vehicte life above industry standard ~ Look at innovative and emerging technologies in fleet operations to reduce citywide fleet - , costs • . ~Continue to expancl the use of CarteGraph in Equipment Rental and Central Stores ~ Continue devetoping an overall level of service / customer service plart for Equipment Rental and Central Stores . 1 EQUIPMENT RENTAL FUND , 2011-2012 WORKING CAPITAL BUDGET 2008 2009 2010 • 2011 2012 ltem . Actual Actual Adj BudRet Budget Budget Operattng Budget Operating Revenue - ~ 348.500 Fuel Sales $ 552,958 $ 575,107 $ 500,000 $ 605,200 $ 635,500 , 365.100 lnterfund Equipment Rentat 1,384.111 1,371,014 900,300 981,700 . 1.030.800 365.400 Interfund Building Rental 151,500 0 0 0 0 Tota4 Operating Revenue • 2,088.569 1,946,121 . 1,400,300 1,586,900 T,666,300 Operating; Expense 548:000.10 Salaries and Wages (473.214) . (458,476) (366.600) (391,900) (397,640) 548.000.20 Personnel Benefits (168,199) (151,242) ' (132,975) (146,660) (162,850) 548.00030 Supplies (995,337) (697.639) (1,207;100) (966,200) (996.200) 548.000.40 Services & CharAes (493.019) . (420.976) (533.800) (543,700) (547,900) 548.000.51 lnterAovemmentel Services 0 0 0 0 0 548.000.90 Interfund Payments for Services (31,731) (211,590) (185,500) (233,500) (213,700) 548.680.01 Depreciation & Amortization (886 074) (1 034 255) (850,000) (1,042,000) (1;042,000) . Total Operating Expenses (3,047,574) (2,974,180) (3,275,975) (3,323,960) (3.360,290) . Operating Income (Loss) (959,005) ' (1,028,059) (1,875,675) (1,737,060) (1,693.990) Non Operating Revenue (Exp) 361.100 Investment Income 155,221 42,406 35,000 91000 10,000 369.900 Miscellaneous Revenue (Expense) 9,182 11,621 0 0 • 0 395.900 Gain on Sale of Fixed Assets 385 (12 790) 0 0 0 Total Non Oper. Rev (Exp) 164,788 41237 35,000 9,000" 10.000 Net Income (Loss) (794,217) (986,822) (1,840,675) . (1,728,060) (1,683.990) Add/Dedud ltems Not Affecting WoricinA Capital (W/C) 548.100.01 Depreciation & Amortization 886,074 1,034,255 850,000 1,042,000 1.042,000 548.681.02 Non Cash Gain/Loss 0 0 0 0 0 Net ViJ/CFrom Operations 91,857 47,434 (990,675) (686.060) (641.490) Other Resources and Uses Budget Resources Other Than Operattons . 365.110 Vehtcle Reptacemen# Revenue 1,101,336 1.053,072 996.800 1,231,200 1,292.700 365.600 Inc in Contributions-Other funds 0 61,445 0 0 0 396.108 Non Cash Contribution ' 157,567 0 0 0 0 397:100 Transfer In 720.600 204.100 65,000 0 104,250 399.000 Otfier Sources 4,423 3,027 0 0 0 • Total Resources , 1,983,926 1,321,638 1.061.800 1,231.200 1,396,950 Uses Other Than Operafions ' 590.100. Other Uses (153,087) (18,249) 0 0 0 597.100.55 transfer Out (7,000) (7,000) (22,400) (507.000) (7.000) 590.100:64 Inc in Fixed Assets-Equipment (1,223,810) (1.962,600) (450.000) (1.721,120) (417.730) ,590.100.65 Incin Fixed Assets-Construdion 0 (193 435) (33.000) . (310,000)_ (350,000) Tota! Uses (1 383 897) (2181.284) (505.400) " (2.538.120) - (Z74.730) Net Change in WJC 691886`, f812 2121 (434 275) (1.992.980)-- -(19.7701 Beginning W/C 1/1 5,412,256- 61104,142 12 1, 2 4,857,654 2,864,674 . Ending W/C 12/31 6,104,142 5.291 930 4 857 654 24864674 2844 904 Net.Change in W/C 691-886 fR122121 _ f434=_2751 _(1,992_980)- (19,770) Note: 2010 Adjusted Budget for Fixed Assets- Construction reduced in Working Capital Statement to reflect expenses being moved to 2011 & 2012, E/Bud 07-08/08 PUBUC WORKS/EQ_RENT/11-12-SS550.XLS (Working Capital) 9/2/2010 10:32 AM '2 . glWkSheetOw -nt Budget, Flex Worksheet:by Objp'4, Equipment Rental Fundi Page: 76 0910212010 ,:49AM • City of Aub► . 550 EQUIPMENT RENTAL - Title/Object 2009 Actua/s 2010 AdJ 9udget 2010 YTD Actuals 2011 2012 00 CAFR ONLY - 05 NET INCREASE RESTRICTED CASH . 18,250.00 0:00 6,100:00- 0.00 0,00 06 WORKING CAPITAL 5,291,930.00 " 4,857,650.00 5,631,200.00 2,864,670.00 2,844,900.00 Total CAFR ONLY 5,310,180,00 4,857,650.00 5,625,100.00 2,864,670.00 2,844,900.00 10 SALARIES & WAGES 11 REGULAR SALARIES & WAGES 457,240.00 330,400:00 198,220.00 355,700.00 361,490.00 12 OVERTIME 1,240.00 7,200.00 280.00 4,200.00 4,200.00 13 OTHER WAGES 0.00 29,000.00 0.00 32,000.00 32,000:00 Total SALARIES & WAGES 458,480.00 366,600.00 198,500.00 391,900.00 397,640.00 20 PERSONNEL BENEFITS 21 F.I.C:A 32,400.00 128,980.00 14,700.00 25,970.00 26,410.00 22 UNIFORMS 1,380.00 4,000.00 650.00 6,000.00 6,000.00 23 PENSIONS 30,220.00 0.00 10,510.00 18,890.00 19,200.00 24 INDUSTRIAL INSURANCE 6,160;00 0.00 3,930.00 7,570.00 7,580.00 25 MEDICAL & LIFE INSURANCE 78,070:00 0.00 41,830.00 88,230.00. 103,660.00 28 UNEMPLOYMENT CLAIMS 0:00 0.00 9,460,00 0.00 0.00 Total PERSONNEL BENEFITS 148,230.00 132,980.00 81,080.00 146,660.00 762,850.00 30 SUPPLIES 31 OFFICE & OPERATING SUPPLIES 197,750.00 324,000.00 94,420.00 249,000.00 249,000.00 32 Title Not Found 459,310.00 754,900.00 332,900.00 610,000.00 640,000.00 35 SMALL TOOLS AND EQUIPMENT 40,590.00 128,200.00 33,720.00 107,200.00 • 107,200.00 Total SUPPLIES 697,650.00 1,207,100.00 461,040.00 966,200.00 996,200.00 40 OTHER SERVICES.& CHARGES ' • 41. PROFESSIONAI: SERVICES 2,780.00 7,700.00 3,770.00 9,400.00 9,400.00 42 GOMMUNICATION. 940.00 2,600.00 250.00 1,200.00 1,200.00 43 TRAVEL 760.00 500:00 210.00 1,000.00 1,000.00 45 OPERATING RENTALS & LEASES 24,910.00 34,000.00 14,440.00 74,000.00 74,000.00 46 INSURANCE 193,280.00 209,600.00 119,140:00 211,300.00 215;500.00 48 REPAIRS.& MAINTENANCE . 174,000.00 265,600.00 100,770.00 229,000.00 229,000:00 49 MISCELLANEOUS 24,320.00 13,800.00 10,530.00 17,800.00 17,800.00 Total OTHER SERVICES & CHARGES 420,990.00 533,800.00 249,110.00 543,700:00 547,900.00 50 INTERGOVERNMENTAUINTERFUND ' 55 OPERATING TRANSFER$ OUT 7;000.00 22;400.00 22,400.00 507,000.00 7,000.00 Total INTERGOVERNMENTALlINTERFUND 7,000.00 22,400.00 22,400.00 507,000.00 7,000.00 60 CAPITAL OUTLAY 64 MACFiINERY & EQUIPMENT 1,962,600.00 450,000.00 45;730.00 1,589,120.00 417,730.00 65 CONSTRUCTION PROJECTS 193,440.00 33,000:00 860.00 0.00 0.00 Total CAPITAL OUTLAY 2,156;040.00 483,000:00 46;590.00 1;589,120.00 417,730!00 90 INTERFUND PAYMENTS FOR SERVICES - 93 EQUIPMENT RENTAL CHARGE-FUEL 3,880:00 3,100.00 2,180.00 2,600.00 2,700.00 97 INTERFUND PRINTING SERVICES 9,000:00 1,700:00 - 1,140:00 3,900.00 3,900.00 • 98 INTERFUND FACILITIES 175,700!00 163;700:00 109,140.00 193,400:00 172,900:00 W • . Paqe:16 - 1 09/02/2010 10:49AM City of Auburn . 550 EQUIPMENT RENTAL Title/Object 2009 Actua/s 2010 Adj Budget 2010 YTD Actuals 2011 2012 99 INTERFUND1SiSERVICES. 23,000.00 17,000.00 11,340.00 33,600100 34,200.00 Total INTERFUND'PAYIVIENTS FOR SERVICES 211,580.00 185;500.00 123,800,00 233,500.00. 213,700.00 Total EQUIPMENI" RENTAL 9,410,150.00 7,789,030.00 6,807;620.00 7,242,750:00 5,587,920.00 P . . °age:17 , glwksheetC ,t Budget Flex Worksheet by Object: L_.jpment Rentaf Administration Page: ~ 0813012010 2:56PM Clty of Auburn. - 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT 100 EQUIPMENT RENTAL. Tlde/ObJect 2009 Actuals 2010 AdJ Budget 2010 YTD Actuals 2011 2012 10 SALARIES & WAGES • 11"REGULAR SALARIES & WAGES 84;130:00 27,100.00 17,030.00 60;590:00 63,260.00 12 OVERTIME 140.00 1,200.00 0.00 1,200.00 1,200.00 13 OTHER' WAGES 0.00 4,000.00 0.00 7,000.00 7,000:00 TOt11' SALARIES & WAGES 84,270.00 32,300.00 17,030.00 68,790.00 71,460.00 20 PERSONNEL BENEFITS • 21 F:I:C.A 6,030:00 10,900.00 1,250:00 4,180.00 4,390.00 22 UNIFORMS. 380.00 . 0.00 470:00 6,000.00 6;000:00 23 PENSIONS ~ 5,930.00 0.00 890:00 3;220.00 3;360:00 24 INDUSTRIAL:INSURANCE 760.00 0.00 40.00 180.00 190:00 25 MEDICAL & LIFE INSl1RANCE 11,130.00 0:00 2,360.00 9,780.00 11,820.00 ' Tot11. . PERSONNEL BENEFITS 24,230.00 10,900.00 5,010.00 23,370.00 25,760.00 30 SUPPLIES 31 OFFICE & OPERATING SUPPLIES 19,390.00 36,000.00 8,060.00 36,000.00 36,000.00 35 SMALL TOOLS AND EQUIPMENT 8,790.00 5,700.00 3,170.00 27,200.00 27,200.00 . Total SUPPLIES 28,180.00 41,700.00 11,230:00 - 63;200.00 63,200:00 40 OTHER SERVICES & CHARGES 41 PROFESSIONAL SERVICES 2,270.00 1,600:00 3;520:00 6;400.00 66400.00 42 COMMUNICATION 940.00 2,600:00 230.00• 1,200.00 ' 1;200.00 43 TRAVEL 760.00 500:00 210.00 1,000.00 1,000.00 46 INSURANCE 193,280.00 209,600:00 119,140.00 211,300.00 215,500.00 48 REPAIRS & MAINTENANCE 10,210.00 8,000:00 ' 280.00 8,000.00 8,000.00 •49 MISCELIANEOUS 19,130.00 8,300:00 8;160:00 16,800:00 16;800.00 Total OTHER SERVICES & CHARGES 226,590.00 230,600:00 131,540.00 244,700:00 248,900.00 90 INTERFUND PAYMENTS FOR SERVICES 97 INTERFUND P.RINTING SERVICES 9,000.00 1,700.00 990.00 3,900.00 3,900.00 98 INTERFUND FAGILITIES 175,700.00 163,700.00 95,490.00 193,400.00 172,900.00 99 INTERFUND IS SERVICES 23,000:00 17,000.00 9,920.00 331600.00 34,200.00 Total INTERFUND PAYMENTS FOR SERVICES 207,700.00 ' 182,400.00 106,400.00 ' 230;900:00 211;000.00 . Total EQUIPMENT RENTAL 570,970.00 497,900.00 271;210.00 630,960.00 620;320.00 CA i 'Pana• 1 glWrkSheet.rpt EquipmentRental Administration Page: 1 08/3012010 2:5613M City of Auburn • Account Number 2009. Acfua/s 2010 AdJ Budget 2010 YTD Actuals 2011 2012 550 EQIiIPMENT RENTAL 00 EQUIPMENT RENTAL ' 548 PUBUC WORKS EQUIPMENT 548.100 EQUIPMENT RENTAL 548.100.11 REGULAR SALARIES & WAGES 84,130.00 27,100.00 17,030.00 . 60,590.00 63,260.00 548.100.12 OVERTIME & OTHER'WAGES 140.00 1,200.00 0.00 1,200.00 1,200.00 , 548.100.13 OTHER WAGES 0.00 4,000.00 0.00 7,000.00 7,000.00 Total SALARIES & WAGES 84,270.00 32,300.00 17,030.00 68,790.00 71;460.00 548.100.21, F.I.C.A. , 6,030.00 10,900.00 1,250.00 4,190:00 4,390.00 548.100.22 UNIFORMS & CLOTHING • 380:00 0.00 470:00 6,000.00 6,000.00 548.100.23 RENSIONS 5,930.00 0.00 890.00 3,220.00 3,360:00 548.100.24 INDUSTRIAL INSURANCE 760.00 0:00 40.00 180.00 190.00 548.100.25 MEDICAL & LIFE INSURANCE 11,130.00 0.00 2,360:00 9,780.00 11,820:00 Total PERSONNEL BENEFITS 24,230.00 10,900.00 5,010.00 23,370.00 25,760.00 548.100.31 OFFICE & OPERATING SUPPLIES 19;390:00 36,000:00 8,060:00 361000:00 36,000.00 548.100.35 SMALL TOOLS & MINOR EQUIPMENT 8,790.00 5,700.00 3,170.00 27,200.00 27;200.00 Total SUPPLIES 28,180.00 41,700.00 11,230:00 63,200.00 63,200:00 548,100.41 PROFESSIONAL SERVICES 2,270.00 1,600.00 3,520.00 6;400.00 6;400.00 _ 548.100.42 COMMUNICATION 940:00 2;600.00 230.00 1,200.00 1,200.00 598.100.43 TRAVEL 760!00 500.00 210.00 1,000.00 1,000.00 548.100.46 INSURANCE 193;280.00 209,600.00 119,140.00 211,300.00 215;500.00 548.100.48 REPAIRS & MAINTENANCE 10,210.00 8;000,00 280.00 8,000.00 8,000.00 548.100.49 MISCELLANEOUS 19,130.00 8,300.00 8,160.00 16,800.00 16,800.00 TOtal OTHER SERVICES & CHARGES 226,580.00 230,600.00 131,540.00 244;700.00 248;900.00 548.100.97 INTERFI'1ND PRINTING SERVICES 9,000.00 1,700.00 990.00 3,900.00 3,900.00 548.100:98 INTERFUND FACIUTIES ` 175,700.00 1.63,700.00 95,490.00 193;400:00 172,900.00 548.100.99 OTHER.INTERFUND SERVICES/CHGS 23,000.00 17,000:00 9,920.00 33,600.00. 34,200.00 ~ Page: 1 glWrkSheet.r►-' Equipment Rental P -rninistration !Page:- 2 08/3012010 56PM City, of AL A • Account Number 2009 Actuals 2010 Adj Budget 2010 1?D Actuals 2011 2012 Tot81 INTERFUND PAYMENTS FOR SERVICES 207,700.00 182;400.00 106,400,00 230,900.00 211,000.00 Tota) EQUIPMENT RENTAL 570,970.00 497,900.00 271,210.00 630;960.00 620,320.00 • , Total PUBLIC WORKS EQUIPMENT 570;970.00 497,900.00 271;210.00 630,960:00 620;320.00 , Total EQUIPMENT RENTAL 570,970.00 497,900.00 271,210.00 630,960.00 620,320.00 Total' EQUIPMENT RENTAL 570,970.00 497,900.00 271,210.00 630,960.00 620,320.00 Grand Total 570;970.00. 497,900.00 271,210.00 630,960:00 620,320.00 - . • . i . _j ' Page: 2 Budget Detail Report Page: 1 0813012010 2:57PM City of Auburn 550 EQUIPMENT RENTAL ~ 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT 548.100 EQUIPMENT RENTAL 548.100.10 SALARIES & WAGES r-..r~.,.....~.._T.~_.._._ ,548 100.1.2: OUERTIME &_OTHERWio►GES _ _ . _ _ _ _ . . . _ - - - - . - - - - - 2010 2011 2012 1 Administration Overtime 1,200.00 1 Administration Overtime 1,200.00 1 Administration Overtime 1,200.00 • Line Items Total 1,200.00 Line Items Total 1,200.00 Line Items Total 1,200.00 . Change in Budget 0.0011 Change fn Budget ' 0.00 548.100.13 OTHER_WAGES ~ . - - - - - _ - - - - 2010 2019 2012 1 Temporary Help, Office Support 4,000.00 1 Temporary Help, Office Support 4,000.00 1 Temporary Help, Office Support 7,000.00 Line Items Total 4,000.00 2 Moved from 550.00.548.150.12 3,000.00 Line Items Total 7,000.00 Line Items Total 7,000.00 Change in Budget 3,000.001. Change in Budget 0.00 548.100.20 PERSONNEL BENEFITS ,.._~_;.,...~.,_.T-,~__~_-._._~.~r~._,..r_-~--T-- - - - - - _ . - - _ - - - 548.100:22 UNIFORMS 8 CLOTHING - - _ _ _ _ _ _ - - - - - - - . - - - - - - ~ 2010 2011 2012 1 Moved from 550.00.150.22 1,000.00 1 Uniforms & Personal Safety Equipment 6,000.00 Line Items Total 0.00 Z Moved from 550.00.548.680.22 3,000.00 L1ne Items Total 6,000.00 3 Increase in Uniforms & Personai Safety 2,000.00 Equipment Costs - Line Items Total 6,000.00 Change in Budget 6,000.00 Change in Budget 0.00 548.100.30 SUPPLIES - - - - - - - - ~ - _ _ - - - - - _ _ _ - - ,---.._.,0-..-,- O---F--~~.___8 -T~------__PLIES 548.10:31 FICE OPERATING SUP - - - _ - - - - . - _ - _ _ _ . - - - . . _ . _ - - - _ - - - 2010 ~ 2011 2012 1 Office Supplies , 1,500.00 1 Office Supplies 1,500.00 1 Office Supplies ~ 1,500.00 2 Equipment Rental Shop Supplies 34,500.00 2 Equipment Rental Shop Supplies 34,500.00 2 Equipment Rental Shop Supplies 34,500.00 ~ Line Items Total 36,000.00 Line Items Total 36,000.00 Line Items Total 36,000.00 Change in Budget 0.00 Change in Budget 0.00 '548.100.35 SMALL TOOLSB MINOR EQUIPMENT - - - - - - - - - _ . 2010 2011 2012 ~ 1 ER/Central Stores Office Upgrades 5,700.00 1 ER/Central Stores Fumiture, Shelving ect. 5,700.00 1 ER/Central Stores Fumiture, Shelving ect. 5,700.00 Line Items Total 5,700.00 2 Moved from 550.00.548.150.35 Label as 10,000,00 2 Minor equipment 10,000.00 Minor equipment 3 Shared Shop Tools 10,000.00 3 Moved from 550.00.548.680.35 Label as 4,000.00 4 Mitchell Annual Software Update 1,500.00 Shared Shop Tools 4 Moved from 550.00.548.680.35 Label as 1,500.00 Line Items Total 27,200.00 Mitchell Annual Software Update 5 Increase in Shared shop tools to cover 6,000.00 programmed tool replacement ' ' Line Items Total 27,200.00 Oo . Page: 1 Budget f il Report Page: 2 0813012010 &57PM City o, ,uburn 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT 54$.100 EQUIPMENT RENTAL ~ 548,100.30 SUPPLIES ~ a _ 2010 2017 2012 ~ Change In Budget 21,500.00 Change In Budget 0.00 548.100.40 OTHER SERVICES & CHARGES A0 _-n-OFE~--~--_r. T._..__~.__ 548u1 4&1?y fP~RSSIONAL . _ _ ~ _ . w „ . . _ . . , . . . . . _ . ~ 2010 2011 2012 1 State AudiBng Fee 1,600.00 1 State Auditing Fee 1,900.00 1 State Auditing Fee 1,900.00 . Line Items Total 1,600.00 2 Waste Disposal Moved from 2,000.00 2 Waste Oil & Anti-fteeze Disposal 2,000.00 550.00.548.680.41/ Waste oil and anti 3 Bank Charges 2,500:00 freeze Line Items Total 3 Bank Charges 2,500.00 6,400.00 L(ne Items Total 6,400.00 ~ Change In Budget 4,800.00 Change In Budget 0.00 2010 2011 2012 1 General System Costs 2,600.00 1 General System Costs 1,200.00 1 General System Costs 1,200.00 Line Items Total 2,600.00 Line Items Total 1,200.00 Line Items Total 1,200.00 . Change In Budget -1,400.00 Change In Budget 0.00 _ 548 100?43+` TRAVEL~: ~ , _ - r _ - - , ~ r-1-- - . 2010 - --'-----~W _ 2011 - 2012 1 Educatfon and Training 500.00 1 Education and Training 500.00 1 Education and Training . 1,000.00 Line Items Total 500.00 2 Increase Education and Training for 500.00 Line items Total 1,000.00 possible green fleet vehicles . Line Items Total 1,000.00 • Change In Budget 500.00 Change In Budget 0.00 ~ ~ a , u..... . a L.~___,_..,..;_.._ ~ ' . . . - ~,-K , > .ti , t_~ . 2010 2011 2012 1 Insurance 209,600.00 1 Insurance 211,300.00 1 Insurance 215,500.00 Line Items Total 209,600.00 Llne Items Total 211,300.00 Line Items.Total 215,500.00 Change In Budget 1,700.00 Change In Budget 4,200.00 W8 '~1;OOy48t 'REP`AIRS ~tiMTA~INTENA~NCE ,,.._~.-_~.,...n,.,k. .~.a..~.b_._.2_.._...._. • ~ r ...:.~._._..,._..._..----.,___.:..~._.....~~_..._.._~._....a......~.....~_-..~._,___....~.._.....~.... . . 1 .i 2010 2011 2012 1 Vehicle Cleaning Services 8,000.00 1 Vehicle Cleaning Services 8,000.00 1 Vehicle Cleaning Services 8,000.00 Line Items Total 8,000.00 Line Items Total 81000.00 Line Items Total 8,000.00 Change In Budget 0-0011 Change In Budget 0.00 ~.-T-.v-. . ~-•.t _ - _ - 548.10,0.49~~. ~MISCE~Lli4NE0US~ _ . _ _ _ ~ _ _ _ . _ . - • . . _ . . 2010 ~ 2011 2012 m . ~ Page: 2 ~ tsudget Uetail Keport rage: s 08/3012010 2:57PM City of Auburn 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT 548.100 EQUIPMENT RENTAL 548.100.40 OTHER SERVICES & CHARGES 548100:49 `•MISCELLANEOUST ~ _ _ ---T--- - - - - _ _ - - - - , - - - - - - - - - - . - - - . - - - - - - _ _ - - - - - - - - - • ' 2010 2011 2012 1 Laundry Service (coveralls, towels, rags) 4,200.00 1 Laundry Senrice (coveralls, towels, rags) 4,200.00 1 Laundry Service (coveralls, towels, rags) 4,200.00 2 State Purchasing Fee 2,000.00 2 State Purchasing Fee 4,000.00 2 State Purchasing Fee 4,000.00 3 Pacific NW Fleet Administrators 100.00 3 Pacific NW Fleet Administrators 100.00 3 Pacific NW Fleet Administrators 100.00 4 National Assoc of Fleet Administrators 500.00 4 National Assoc of Fleet Administrators 500.00 4 National Assoc of Fleet Administrators 500.00 5 Tralning and Skill Building Workshops 1,000.00 5 Mechanics Trafning and Certification 1,000.00 5 Mechanics Tra(ning & Certification 2,000.00 6 Diesel Fuel Users Tax 2,500.00 6 Diesei Fuel Users Teu 2,500.00 6 Diesel Fuel Users Tax • 2,500.00 7 State Underground Tank Fee 500.00 7 State Underground Tank Fee 500.00 7 State Underground Tank Fee 500.00 8 Fleet Management Conferences 1,000.00 8 Fleet Management Conferences 1,000.00 8 Fleet Management Conferences 1,000.00 9 April Mayor D/C . -3,500.00 9 Moved from 550.00.548.680.49 Label as 1,000.00 9 Increase Mechanics Training for Altemative 2,000.00 Line Items Total 8,300.00 Mechanics Training and Certification fuel veh(cles • 10 increase Mechanics training for ARemative 2,000.00 Line Items Total 16,800.00 fuel vehicles Line Items Total . 16,800.00 Change In Budget 8,500.00 Change In Budget 0.00 548.100.90 INTERFUND PAYMENTS FOR SERVICES - - - - - - - - 548:100.97 1NTERFUND PRINTING SERVICES 2010 2011 2012 1 Multimedia Services 1,700.00 1 Multimedla Services 3,900.00 1 Multimedia Services 3,900.00 Line Items Total 1,700.00 Line Items Total 3,900.00 Line Items Total 3,900.00 Change In Budget 2,200,00 Change in Budget 0.00 ~ - - - - 548.100:98 . INTERF,UND FACILITIES 2010 2011 2012 1 Facilities Services 163,700.00 1 Facilities Services 193,400.00 1 Facilftles Services 172,900.00 Line Items Total 163,700.00 Line Items Total 193,400.00 Line Items Total 172,900.00 Change In Budget 29,700.00 Change In Budget ' -20,500.00 - - - 548:100.99 OTHER INTERFUND SERVICES/CHGS _ 20101- - _ _ _ . 2011 - - 2012 ' 1 IS Services , 17,000.00 1 IS Services 33,600.00 1 IS Services 34,200.00 Line Items Total 17,000.00 Line Items Total . 33,600.00 Line Items Total 34,200.00 Change In Budget 16,600.00 Change In Budget 600.00 Total Line Items 459,900.00 Total Line Items 553,000.00 Total Line Items 537,300.00 Total Change In Budget 93,100.00 Total Change In Budget -15,700.00 ~ C) • Page: 3 glWkSheet0l._ ~ Budget Flex Worksheefi by Objec, zjuipment'Rental-Finance ~age: 08130/2010 2:57PM City of'Auburn , z . . '550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT . 110 ADMIN GENERAL COST Tltle/ObJect ' 2009 Actuals 2010 Adj Budget 2010 YTD'Actuals 2011 2012 70 SALARIESA WAGES • ' 11 REGULAR $ALARIES & WAGES 90,910.00 45,700.00 26,930.00 43,270,00 44,000.00 12 OVERTIME 20.00 0.00 0.00 0.00 0.00 - Total SALARIES & WAGES 90,930.00 45,700.00 26,930:00 43,270.00 44,000.00 ' 20 PERSONNEL BENEFITS ' . 21 F.I.C.A 6,640.00 20,700.00 1,980.00 3,100.00 ' 3,160.00 23 PENSIONS 5,530.00 0.00 1,420.00 2,300.00 2,340.00 . 24 INDUSTRIAL INSURANCE 280:00 0.00 90.00 160.00 • 160.00 25 MEDICAL,&.L'IFE'INSURANCE . 14,060.00 0.00 4,970.00 9,670.00 11,250.00 ~ 28 UNEMPLOYMENT CCAIMS • -0:00 0.00 9,460.00 0.00 0.00 TOtdl PERSONNEL.BENEFIT,S 26,590.00 20,700:00 17;920.00 15,230.00 16,910.00 30 SUPPLIES Total SUPPLIES 0.00 0.00 0.00 0.00 0,00 40 OTHER SERVICES & CHARGES ' '1'p{al OTHER SERVICES & CHARGES 0.00 • 0.00 0.00 0.00 0.00 90 INTERFUND PAYMENTS FOR SERVICES TOtal INTERFUND PAYMENTS FOR SERVICES • 0.00 0.00 0.00 0.00 0.00 - Total ADMIN GENERAL GOST 117,440:00 66,400.00 44,850.00 58,500.00 60,910.00 ~ . ~ - . Paae: 1 glwrksheet.rpt Equipment Rental=Finance Page: 1 0813012010 2:58PM City of Auburn ` Account Number, 2009Actusls 2010;Adj;Budgef 2010 YTD Acfua/s 2011 2012 550 EQUIPMENT RENTAL . . 00 EQUIPMENT RENT'AL 548 PUBLIC WORKS EQl'JIPMENT . . 548:110 ADMIN GENERAL COST 548:110.11 REGULAR SALARIES & WAGES 90;910:00 45,700:00 26,930.00 43,270.00 44,000.00 . 548.110.12 OVERTIME & OTHER'WAGES 20.00 0.00' 0.00 0.00 0.00 Total SALARIES & WAGES 90,930.00 45,700.00 26,930.00 43,270,00 44,000.00 548.110.21 F.I.C.A. 6,640.00 20,700:00 1,980:00 3;100.00 3,160.00 548.110.23 PENSIONS 5,530.00 0.00 1,420.00 2,300.00 2,340:00 548.110.24 INDUSTRIAL INSURANCE 280.00 0.00 90.00 160:00 160,00 548.110.25 MEDICAL & LIFE INSURANCE 14,060.00 0.00 4,970.00 9,670:00 11,250.00 548.110:28 UNEMPLOYMENT CLAIMS 0.00 0.00 9,460.00 0:00 . 0.00 Total PERSONNEL BENEFITS 26,510.00 20,700.00 17,920.00 15,230.00 16,910.00 Total SUPPLIES 0.00 0.00 0:00 , 0:00 0:00 Total OTHER SERVICES & CHARGES 0.00 0.00 0.00 0:00 0.00 . TOtal INTERFUND PAYMENTS FOR SERVICES 0.00 0.00 0.00 0.00 0:00 Total ADMIN GENERAL COST 117,440.00 66,400.00 ' 4400.00 58;500.00 60,910.00 Total PUBUC WORKS;EQUIPMENT 117,440.00 66,400:00 44,850.00 58500.00 60,910.00 • Total EQUIPMENT RENTAI: 117,440.00 66,400:00 44,850.00 ' 58;500.00 ' 60,910:00 Total EQUIPMENT RENTAL 117;440:00 66,400:00 44,850.00 58,500.00 60,910.00 Grand Total 1.17,440.00 66,400.00 44,850.00 58,500.00 • 60,910:00 N Page: 1 .glwksheetoi,, c- Budget Flex VUorksheet by Objecfi: ,iipment'RentaF-Bldg Maint . ?age: ~ 0813012010 2:59PM City of Auburn . ' 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT , 150 BUILDING MAINTENANCE T/de/ObJect 2009 Actuals 2010,Adj Budget ' 2010 Actuals 2011 2092 10 SALARIES & WAGES • 11 REGULAR SALARIES & WAGES 26,970.00 0.00 0.00 0.00 0.00 12 OVERTIME 0.00 3,000.00 0.00 0.00 0.00 Total SALARIES & WAGES 261-970:00 3,000:00 0.00 0.00 0.00 20 PERSONNEL BENEFITS 21 'F.I:C:A 1,780.00 500.00 0.00 0.00 0.00 22 UNIFORMS . 0.00 1;000.00 0.00 0.00 0.00 23 PENSI,ONS 1,940.00 0.00 0.00 0:00 ' 0.00 24 INDUSTRIAL INSURANGE 30.00 0:00 0:00 0.00 0.00 25 MEDIGAL & IIFE iNSURANCE 2,340:00 0.00 0.00 0:00 0:00 Total PERSONNEL BENEFITS 61090:00 1,500.00 0.00. 0.00 0.00 30 SUPPLIES 31 OFFICE:& OPERATING SUPPLIES 2,990.00 13,000.00 2,600.00 13,000.00 13,000.00 35 SMALL TOOLS AND EQUIPMENT 1,160.00 20,000.00 9,580.00 10,000.00 10,000.00 Total SUPPLIES 4,150.00 33,000.00 12,180.00 23,000.00 23,000.00 40 OTHER SERVICES & CHARGES 41, :P.ROFESSIONAL SERVICES , 200.00 3,000.00 0:00 3,000:00 3,000:00 48 ,REPAIRS:& MAINI'ENANCE 18;600.00 40,600.00 5,030;00 21,000:00 21,000100. 49 ~MISCELLANEOUS . 480:00 3,500:00 2,070:00 , 0:00 0:00 TOtal! 'OTHER-SERVICES & CHARGES 19,280.00 471100.00 7,100:00 24,000.00 24,000;00 . Total BUILDING MAINTENANCE 56,490.00 84,600.00 19,280.00 47,000.00 47,000.00 , . W _ - ' 'PanP• 1 glWrkSheet.rpt Equipment Rental -Bldg Main# Page: ~ 08130/2010 2:59PM C1tyof Auburn Account Number 2009,Actuals 2010 A"dJ Budget 2010 Actuals 2011 2012 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT 548:150 BUILDING MAINTENANCE 548.150.11 REGULAR SALARIES & WAGES 26,970.00 0.00 0.00 0.00 0.00 548.150.12 OVERTIME 0.00 3,000.00 . 0.00 0.00 . 0.00 TOtal SALARIES & WAGES 26,970.00 31000.00 0.00 0.00 0.00 548.150.21. F.I.C:A 1,780.00_ 500.00 0.00 0.00 0.00 548.150.22 UNIFORMS • 0.00 1,000.00 0.00 0.00 0.00 548.150.23 PENSIONS 1,940.00 0.00 0.00 0.00 0,00 548.150.24 INDUSTRIAL INSURANCE 30:00 0.00 0.00 0.00 0.00 _ 548.150.25 MEDICAL & LIFE INSURANCE 2,340.00 0.00 0.00 0.00 0.00 Total PERSONNEL.BENEFITS 6,090.00 1,500:00 0.00 0.00 0.00 548.150.31 OFFICE & OPERATING SUPPLIES 2,990.00 13,000.00 2,600.00 13,000.00 13,000.00 - 548.150.35 .SMALL TOOLS & MINOR EQUIPMENT 1,160.00 20,000.00 9,580.00 10,000.00 10,000.00 Total SUPPLIES 4,150.00 33,000.00 12,180.00 23,000.00 23,000:00 548.150:41 PROFESSIONAL SERVICES 200.00 3,000.00 0.00 31000:00 3,000.00 548.150.48 REPAIRS & MAINTENANCE 181600:00 40,600:00 5,030:00 21,000.00 21,000.00 548.150.49 MISCELLANEOUS 480:00 3,500:00 2,070.00 0:00 0:00 'rptal OTHER SERVICES & CHARGES 19;280:00 ' 47,100.00 7,100:00 24,000:00 24,000.00 Total BUILDING MAINTENANCE 56,490.00 84,600.00 19,280.00 47,000.00 47,000.00 Total PUBLIC WORKS EQUIPMENT 56,490:00 84,600.00 19;280.00 47,000.00 47,000.00 Total EQUIPMENT.RENTAL 56;490.00 84,600.00 79,280:00 47,000.00 47;000:00 ~ . Page: 1 . Budget C ;I Report Page: 1 08130/2010 2:59PM City of wuburn . 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT 548.150 BUILDING MAINTENANCE 548.150.10 SALARIES 8 WAGES - 5'48:~150:'1~2 _ 'ONERTIMEc ~ ~.1e..._Ld..• ~ t _1_~ . --~~__~___A 2010 2011 2012 1 Facility Overtime 3,000.00 1 Facility Overttme 3,000.00 Une Items Total 3,000.00 2 Moved to 550.00.548.100.13 -3,000.00 • Line Items Total 0.00 ~ Line Items Total 0.00 ~ . Change In Budget -3,000.00 Change In Budget 0.00 548.150.20 PERSONNEL BENEFITS _ _ . - _ _ . - ~ - - . . . 548?'1,b0:22~ UNIF.ORMS~ ' _ - - - 2010 2011 2012 1 Uniforms ~ . 1,000.00 1 UniPorms 1,000.00 ~ Line Items Total 1,000.00 2 Moved to 550.00.548.100.22 -1,000.00 Line Items Total 0.00 Line Items Total 0.00 ' Change In Budget -1,000.00 Change In Budget 0.00 548.150.30 SUPPLIES 548 150:~3A_~(OFFICE,BYOPE~RA~T_I'NG1fSUPPL' IES : 2010 ~ 2011 2012 1 Building/Grounds Maintenance Supplies 13,000.00 1 Building/Grounds Maintenance Supplies 13,000.00 1 Build(ng/Grounds Maintenance Supplies 13,000.00 • Line Items Total 13,000.00 Line Items Total 13,000.00 Line Items Total 13,000.00 Change In Budget 0.00 Change in Budget 0.00 548150°35! "SMALL_TO~OLS>i&~ININOR~iEQUIPMENT _ . . 2010 2011 . 2012 ~ 1 Faciliry Upgrades to Minor Equipment 20,000.00 1 Faciliry Upgrades to Minor Equipment 20,000.00 1 Facility Upgrades to Minor Equipment 20,000.00 Line Items Total 20,000.00 ~ Z Moved to 550.00.548.100.35 -10,000.00 2 Moved to 550.00.548.100.35 -10,000.00 ~ Line Items Total 10,000.00 Line Items Total 10,000.00 Change In Budget -10,000.00 ~ Change in Budget 0.00 548.150.40 . OTHER SERVICES & CHAR6ES '548.1;50:49'_____IPROFESSIONAL SER~UICESI~ ~ . - - - _ _ ~ _ - - _ _ - - - - 2010 2071 2012 1 Special Waste Disposal 3,000.00 1 Special Waste Disposal 3,000.00 1 Special Waste Disposal 3,000.00 Line Items Total 3,000.00 Line Items Total 3,000.00 Line Items Total 3,000.00 Change In Budget 0.00- Change In Budget 0.00 ~.,_-,i .•-_..7._..._.~._~,__ -r q-~__ ..3.7_- t f _ . . . _ . . . . . . . . . . , . . . . . 548k150448 __~REPAIRS)f&IMAINTENANCE~---_- ' : . -F-_; - 2010 2011 ~ 2012 ~ 1 M& O Building Repairs & Maintenance 40,000.00 1 M& O Building Repairs & Maintenance 20,000.00 1 AA & O" Building Repairs & Maintenance 20,000.00 2 ERR Shop Lift Equip Inspection 600.00 2 ERR Shop Lift Equip Inspectlon 1,000.00 2 ERR Shop Lift Equlp Inspection. 1,000.00 Line Items Total 40,600.00 ' Line Items Total 21,000.00 Line items Total 21,000.00 Change In Budget -19,600.00 Change in Budget 0.00 ~ cn . ' . Page: 1 . tsuaget uetan Keport raye: A 0813012010 2:59PM . City of Auburn 550 EQUIPMENT RENTAL. . 00 EQU.IPMENT RENTAL 548 PUBLIC WORKS'EQUIPMENT . ~ ~ 548.150 BUILDING MAINTENANCE . '548.150.40 OTHER SERVICES & CHARGES ' r - <-•--.-~.-.*r-.-s-~ .~7 ..r;l` `:v~`:-y~.E'-' ..t' i_-r -_f t x .'y'_"~ t_!.:.T ..r~. ~r<-:4{~`'"(}`- 'i 548.1I50.49: i h_~_ ~ a. _~._~....,,..L..n .a.~...d..e._ ~.../a..~..~_.`l'~ ....~.....i.L~~.,...,. . _.r__wti..._ ....ww _ ~ s..• )......{L,~.t u_ vti:. r. . _.v...._is_..n-. _ _sL:;,. r_v-'.~.iu~~ati,.~.r. ~ } _ . _ _ 2010 u .:L2011 2012 1 April Mayor D/C 3;500:00. Line Items Total 3,500:00 Lineltems Total - 0:00: ~ Line Items Total 0.00 Change, ini Budget -3,500.00 Change in Budget 0:00 Total Line Items 84,100.00 . Total I.ine Items ' 47,000.00 Total Line Items 47;000:00 - Total Change in Budget -37,100.00 Total Change in Budget 0.00 ~ Page: 2 glWkSheetOL. _.i Budget Flex Worksheef by ObJect: aipment Rental- Operations 'age: 1 0813012010 3:OOPM . City of'Auburn 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBUC WORKS EQUIPMENT 680 OPERATIONS . Tifle/Object 2009 Actua/s 2010 Adj Budget 2010 YTD Actuals 2011 2012 00 'CAFR ONLY 01 DEPRECIATION 1,034,260.00 850,000.00 605,320.00 1,042,000.00 1,042,000.00 Total: CAFR ONLY 1,034,260.00 850,000.00 605,320.00 1,042,000.00 1,042,000.00 10 SALARIES & WAGES 11 REGULAR SALARIES & WAGES 255,230.00 257,600.00 154,260.00 251,840.00 254,180.00 12 OVERTIME " 1,080.00 3,000.00 280.00 3,000.00 3,000.00 ~ 13 OTHER WAGES 0.00 25,000.00 0.00 25,000.00 25,000.00 Total. SALARIES & WAGES 256;310.00' 285,600.00 154,540:00 279,840.00 282,180.00 ' 20 PERSONNEL BENEFITS 21 F.I:C.A 17,950.00 96,880.00 11,470.00 18,680.00 18,860.00 22 UNIFORMS 1,000.00 3,000.00 180.00 0.00 0.00 23 PENSIONS 16,820.00 , 0.00 8,200.00 13,370.00 13,500.00 24 INDUSTRIAL INSURANCE 5,090.00 0.00 3,800.00 7,230:00 7,230.00 25 MEDICAL & LIFE INSURANCE 50,540.00 0.00 34,500.00 68,780.00 • 80,590.00 Total PERSONNEL BENEFITS 91,400.00 99,880.00 58,150.00 108,060.00 120,180.00 30 SUPPLIES 31 OFFICE & ORERATING SUPPUES 175,370.00 275,000.00 81,610:00 200,000.00 200,000.00 32 Title Not Fo.und " 459,310.00 754,900:00 332,900.00 810;000.00 640,000.00 35 SMACL TOOL:S AND EQUIPMENT 30,640.00 102,500:00. 20;830:00 70;000:00 70,000:00 , Total SUPPLIES 665;320.00 1,132,400.00 435,340.00 880,000:00 910;000.00 40 OTHER SERVICES & CHARGES 41 PROFESSIONALSERVICES , 310.00 3,100.00 210.00 0.00 0.00 45 OPERATING RENTALS & LEASES 24,910.00 34,006:00 14,440.00 74,000.00 74,000.00 48 REPAIRS & MAINTENANCE 145,190.00 217,000.0 1 0 90,040.00. 200,000.00 200,000.00 49 MISCELLANEOUS 4,710.00 2,000.00 0.00 1,000.00 1,000:00 Total OTHER SERVICES 8 CHARGES 175,120.00 256,100:00 104,690.00 275,000.00 275,000.00 50 I NTERGOVERNMENTAUI NTERFUND Total INTERGOVERNMENTAUINTERFUND 0.00 0:00 0.00 0.00 0.00 90 INTERFUND PAYMENTS FOR SERVICES 93 EQUIPMENT RENTAL CHARGE-FUEL 3,880.00 3,100.00 1,930.00 2;600:00 2,700.00 TOtal INTERFUND PAYMENTS FOR SERVICES 3,880.00 3,100.00 1,930.00 2,600.00 2,700.00 TOtal OPERATIONS 2,226,290.00 2,627,080.00 1,359,970.00 2,587,500.00 2,632,060:00 v ' ~ . Paae: 1 . glWrkSheet.rpt Equipmenfi Rental- Operations Page: 1 08/3012010 3:OOPM City of Auburn . Account Number 2009. Actuals 2010 Adj Budget 2010 YTD Actuals 2011 2012 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC V110RKS EQUIPMENT 548.680 OPERATIONS 548.680.01 DEPRECIATION 1,034,260:00 850,000.00 605,320.00 1,042,000.00 1,042,000.00 Total CAFR ONLY 1,034,260.00 850,000:00 605,320.00 1,042,000.00 1,042,000.00 548.880.11 REGULAR SALARIES & WAGES 255,230.00 257,600.00 154;260.00 251,840.00 254,180.00 548.680.12 OVERTIME & OTHER WAGES 1,080.00 3,000:00 280.00 3,000:00 3,000:00 548.680.13 OTHER WAGES 0.00 25,000.00 0.00 ' 25,000.00 25,000.00 - Total SALARIES & WAGES 256,310.00 285,600.00 154,540.00 279;840:00 282,180.00 548.680.21 F.I.C.A. 17,950.00 96;880.00 11,470.00, 18,680:00 18,860.00 548.680.22 UNIFORMS & CLOTHING 1,000.00 3,000.00 180:00 0.00 0.00 548.680.23 PENSIONS 16;820:00 0:00 8,200:00 13;370.00 13,500.00 548.680.24 INDUSTRIAL INSURANCE 5;090.00 0.00 3,800:00 7,230.00 7,230.00 548.680.25 MEDICAL & LIFE INSURANCE 50;540.00 0:00 34,500.00 68,780:00 80,590.00 . Total PERSONNEL BENEFITS 91,400.00 99,880.00 58,150.00 108,060.00 120,180,00 548.680.31 OFFICE & OPERATING SUPPLIES 175;370.00 275,000.00 81,610:00 200;000.00 200,000.00 548.680.32 FUEL ' 4591;310:00 754,900:00 332,900:00 610;000,00 640,000:00 548.680.35 SMALL TOOLS & MINOR EQUIPMENT 30,640.00 102,500:00- 20;830:00 70;000:00 70;000.00 Total SUPPLIES 665,320.00 1,132,400.00 435,340.00 880,000.00 910,000.00 548.680.41 PROFESSIONAL SERVICES 310.00 3,100.00 210:00 0:00 0.00 548.680.45 OPERATING RENTALS & LEASES 24,910.00 341000:00 94,440.00 74,000.00 74,000.00 548.680.48 • REPAIRS & MAINTENANCE 145;190.00 217;000:00 90;040.00 200,000.00 200,000.00 548.680.49 MISCEL'I:ANEOUS 4,710.00 2,000.00 0.00 - 1,000.00 7,000.00 Total OTHER SERVIGES`& CHARGES 175;120.00 256,100:00 104,690.00 275,000:00 -275;000.00 0o Page: . 1 gnn►rkSheet.r►-• EquipmentlRenta~ '11perations oage: 2 08130/2010 JOPM Cify of AL , Accounf Number 2009 Acfua/s 2010 AdJ,Budget, 2010'YTD Actuals 2011 2012 Total INTERGOVERNMENTAUINTERFUND • 0s00 ' 0:00 0.00 0.00 0.00 548.680193 INTERFUND SUPPLIES 3;880:00 3;'100:00: 1,930.00 2,600.00 ' . 2,700.00 ' Total INTERFUND PAYMENTS FOR SERVICES 3,880:00 3,100:00 1,930.00 2,600.00 2,700.00 Total OPERATIONS 2;226,290:00 2,627,080:00: 1;359,970.00 2,587,500.00 2,632,060.00 Total PUBLIC WORKS EQUIPMENT 2,226,290.00 2,627,080.00 1,359,970.00 2,587,500.00 2,632;060.00 Total. EQUIPMENT RENTAL 2,226,290:00 2,627,080.00 1,359,970.00 2,587,500.00 2,632,060.00 TOtal EQUIPMENT RENTAL 2;226;290.00 2,627,080.00 -1,359,970.00 2,587,500.00 2,632,060.00 Grand Total 2,226,290.00 2,627,080.00 1,359,970.00 2,587,500.00 • 2,632,060.00 cc Page: 2 ; , . , Budget Detail Report Page: 1 08/3012010 3:OOPM City of Auburn 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL ~ 548 PUBLIC WORKS EQUIPMENT 548.680 OPERATIONS 548.680.00 CAFR ONLY ~ A_.._ rION~ `548 680t0~ EPRECIAT:_ _ 2010~ 2011 2012 1 Original Budget 850,000.00 1 Depreciation 1,042,000.00 1 Depreciation. 1,042,000.00 • Line Items Total 850,000.00 Line Items Total 1,042,000.00 Line Items Total 1,042,000.00 ~ Change In Budget 192,000.00 Change In Budgat 0.00 548.680.10 SALARIES 8 WAGES - - - - - - - - _ . - - ~ - _ ~-.-o---; ~ - - - - - . 548:68.0:12. (OVERTIMEiB`~OTHER~WAGES---.__._~.----------------------~--__.._..---------...------_----- 2010 2011 2072 1 Shop Overtime • 3,000.00 1 Shop Overtime 3,000.00 1 Shop Overtime 3,000.00 . Line Items Total 3,000.00 Line Items Total 3,000.00 ~ Line Items Total 3,000.00 Change In Budget 0.0011 Change In Budget 0.00 ----O-T-HE-- R' --A- --GES---__ '548':680.13! W; ---------~-----__._..._._.._.~----_.~...._-------------~..._-~~---__.____------------I--- - 2010 2011 ' 2012 1 Shop Temporary Help 25,000.00 1 Shop Temporary Help 25,000.00 1 Shop Temporary Help 25,000.00 ' . Line Items Total 25,000.00 Line Items Total 25,000.00 Line Items Total 25,000.00 Change In Budget 0.00 Change In Budget • 0.00 548.680.20 PERSONNEL BENEFITS ~ - - - - _ . . - - - - - . _ - - - - - - - - _ - - - _ _ _ _ _ _ - - - - - 548 680_22 !UNIFORMS~&'CLOTHING_ 2010 _ ~ - - - - 2011 2012 1 Uniforms . 3,000.00 1 Uniforms 3,000.00 1 Uniforms 3,000.00 Line Items Total 3,000.00 2 Moved to 550.00.548.100.22 -3,000.00 2 Moved to 550.00.548.100.22 -3,000.00 Line Items Total 0.00 Line Items Total 0.00 Change In Budget -3,000.00 Change In Budget 0.00 548.680.30 SUPPLIES , - - _ ~ _ . _ - - _ - - - - _ - _ . _ _ . _ _ - , 548:680_31! __OFFICE~8~JOPERATING SU_PPLIES ~ 2010 2011 2012 1 Vehicle Repair Parts and Supplies ~ 275,000.00 1 Vehicle Repair Parts and Supplies 200,000.00 1 Vehicle Repair Parts and Supplies 200,000.00 , Line Items Total 275,000.00 Line Items Total 200,000.00 Une Items Total 200,000.00 . Change In Budget -75,00020 Change In Budget 0.00. - _ _ 2010 2011 2012 1 Fuellnventory 504,900.00 1 Fuelinventory 610,000.00 1 Fuellnventory 640,000.00 2 Fuel Inventory Contingency 250,000.00 _ Line Items Total 610,000.00 - Line Items Total 640,000.00 3 BA# 4 Mid biennial correction -400,000.00 Line Items Total 354,900.00 Change In Budget 255,100.0011. Change In Budget 30,000.00 `548:680:35; ~ `SMALL T00 "S~4IMINMEQUIPMENT - - - "N ~ Page: 1 ~ Budget C il Report Page: 2 0813012010 .,:OOPM Clty ob _ .jburn 550 EQUIPMENT RENTAL. . . . 00 EQUIPMENT RENTAL . ~ 548 PUBLIC WORKS. EQUIPMENT ~ 548.680 OPERATIONS ~ 548.680.30 SUPPLIES 548 680'35 SM'~AL~T~OQLS'~IMINO,~RIEQU.IPMENT 2010 - 2011 2012 1 Shared Shop Tools 4,000.00 1 Shared Shop Tools 4,000.00 1 Minor Equipment 70,000.00 2 Mitchell Annual Software Update 1,500.00 2 Mitchell Annual Software Update 1,500.00 Line Items Total 70,000.00 3 Minor Equfpment 97,000.00 3 Minor Equipment 70,000.00 ' Line Items Total 102,500.00 4 Moved to 550.00.548.100.350 Shared Shop -4,000.00 Tools 5, Moved to 550.00.548.100.35 Mitchell -1,500.00 Annual Software Update Line Items Total 70,000:00 Change In Budget -32,500.00 Change In Budget 0.00 548.680.40 OTHER SERVICES & CHARGES .-....,-~...ifi""'_,.g'T, _ .____.`_r_~__ _.__--e-____......._ __-.r_._,__._. 2010 ~ 2011 2012 1 Waste Disposal 3,100,00 1 Waste Disposal 3,100.00 ~ Line Items Total 3,100.00 2 Move to 550.00.548.100.41 -3,100.00 Line Items Total 0.00 ~ Line Items Total 0.00 Change In Budget -3,100.00 Change In Budget 0.00 _--z- - - 548t680?~45 ~OPER~4TING)IRENT~ALSy&,LE~i~\SES1 . 2010 2011 ~ 2012 1 Leased Vehicles 34,000.00 1 Leased VehiGes -PD 34,000.00 1 Leased Vehicles - PD 34,000.00 Line Items Total 34,000.00 2 Leased Equipment ~ 40,000.00 2 Leased Equipment 40,000.00 Llne Item's Total 74,000.00 Line Items Total 74,000.00 Change In Budget 40,000.00 Change In Budget 0.00 , Y ---.~---.T ~..L,._✓_.~-. 548:680:,48~~ ' ~REPAIRS!(&'_MAI_ NTENANCEi _ - 2010 2011 2012 1 Out of Shop Vehicie Repairs 217,000.00 1 Out of Shop Vehicle Repairs 200,000.00 1 Out of Shop Vehicle Repairs 200,000.00 Line Items Total 217,000.00 Line Items Total 200,000.00 • Line Items Total 200,000.00 Change In Budget . -17,000.0011 Change In Budget 0.00 `548 680N49; iMISCEL{ LANEOUS 2010 2011 2012 1 MechanicTraining & Certiflcations 1,000.00 1 MechanicTraining &'Certifications 1,000.00 1 NewVehicle License Fees 1,000.00 2 New Vehicle License Fees 1,000.00 2 New Vehicle License Fees 1,000.00 Line Items Total 1,000.00 Line Items Total 2,000.00 3 Moved to 550.00.548.100.49 Mechanics -1,000.00 Training & Certifications Line Items Total 1,000.00 ~ Change In Budget -1,000.00 Change In Budget 0.00 548.680.90 INTERFUND PAYMENTS FOR SERVICES ~ , _ 5 8 680:~93) (IN RFl1ND~~$.UPP~LIES) N - ~ ~ Page: 2 magevuetau rceport 08/3012010 3:OOPM City of Auburn 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 548 PUBLIC WORKS EQUIPMENT 548.680 OPERATIONS 548.680.90 INTERFUND PAYMENTS FOR SERVICES 7 77 }l . , : i,:, , 2-. 3_ t r 7 548 680~93 .:!INT+ERFUND S~UPPL E3 _ < < : r.: $ :...,x.,,. , t~ ....a,. ~ .e..._.~ ~,_...~~-<._-~+s..~_~....r ....:....~-..:...........-:.:«~._r~.......a. :`t:_...~:.c:::s~r .o...i'.tel.x:::..__o.... _._,_._.__E~ us ~..~~.:c=..~-s....:. 2010 ' 2011 ~uyt 2012 1 Interfund Rental-Fuel 3,100.00' 1 Interfund Rental-Fuel 2,600:00 1 Intertund Rental-Fuel 2,700.00 Line ltems Total 3,100.00 Une Items Total 2,600.00 Line Items Total 21700:00 Change in Budget -500.00 Ghange in Budget 100.00 Total Line Items 1,872;600.00 Totaltine ltems 2,227,600.00 _ TotaliLine Items 2,257,700:00 Total Change in Budget 355,000.00 Total:Change in Budget 30,100:00 N A1 - - Page: 3 gnNksheetob° -t Budget Flex Worksheet by Objec`- 9quipment Rental - Other page: s 0910212010 .53AM City of Aubu. 550 EQUIPMENT. RENTAL . 7itleLObject 2009 Actuals 2010 AdJ Budget 2010 Actuals 2011 2012 00 CAFR ONCY 01 CONTRA DEPRECIATION 1,034,260.00- 850,000.00- 605,320.00- 1,042,000.00- 1,042,000.00- 05 NET INCREASE RESTRICTED CASH 18,250.00 . 0:00 6,100.00- 0.00 • 0.00 06 WORKING CAPITAL 5,291,930:00 4,857,650.00 5,631,200.00 2,864;670.00 2,844,900.00 Total CAFR ONLY 4,275,920.00 4,007,850.00 5,619,780.00 1,822,670.00 1,802,900.00 ' 10 SALARIES & WAGES. . TOtal SALARIES & WAGES 0.00 0.00 0.00 • 0.00 0.00 20 PERSONNEL BENEFITS . . TOtal PERSONNEL BENEFITS 0.001. 0.00 0:00 0.00 0.00 40 OTHER SERVICES & CHARGE& Total OTHER SERVICES &,CHARGES , 0.00 0.00 0.00 0.00 . 0.00 50 INTERGOVERNMENTAUINTERFUND ' 55 OPERATINGTRANSFERS OIiT 7,000.00 22,400.00- 22,400.00 507,000.00 7,000.00 Total INTERGOVERNMENTAUINTERFUND 7,000.00 22,400.00 22,400.00 507,000.00 7,000:00 60 CAPITAL OU'fLAY 64 MACHINERY:&;EQUIPMENT 1,962;600.00 ' 450,000.00 45,730.00 1,589,120.00 417,730.00 65 CONSTRUCTION PROJEGTS 193,440.00 33,000.00 ' 860.00 0.00 0.00. TOtal CAPITAL OUTLAY 2,156,040.00 483,000.00 46,590.00 1,589,120.00 417,730.00 90 INTERFUND PAYMENTS FOR SERVICES Total• INTERFUND PAYMENTS FOR SERVICES 0.00 0.00 0.00 0.00 0.00 • Total EQUIPMENT RENTAL 6,438,980.00 4,513,050.00 5,088,770.00 3,918,790.00 2,227,630.00 . N . W _ Paqe: 8 glWrkSheet.rpt Equipment Rental - Other Page: 1 09102/2010 10:52AM City of Auburn Account Number 2009 Actuals 2010 AdJ Budget 2010 Actua/s 2011 . 2012 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL • 548 PIiBLIC WORKS EQUIPMENT . 548.681 CONTRA DEPRECIATION 548.681.01 CONTRA DEPREGIATION' 1,034,260.00- 850,000.00- 605,320.00- 1,042,000.00- 1,042,000.00- Total CAFR ONLY 1,034,260.00= 850,000.00- 605,320.00- 1,042,ooo.o0- 1,042,000.00- Total OTHER SERVICES & CHARGES 0.00 0.00 0.00 0.00 0.00 TOt81 CONTRA DEPRECIATION 1,034,260.00- 850,000.00- 605,320.00- 1,042,000.00- 1,042,000.00- _ Total PUBLIC WORKS EQUIPMENT 1,034,260.00- 850,000.00- 605,320:00- 1,042,000.00- 1,042,000.00- 590 CAPITAL OUTLAY 580.100 CAPITAL EXPENDITURES . 590,100.05 NET INCREASE RESTRICTED ASSETS 18,250.00 0.00 6,100.00- 0.00 0.00 590.100.06 ENDING WORKING CAPITAL 5,291,930.00 4;857,650.00 5,631,200.00 2,864,870.00 2,844,900.00 Total CAFR ONLY 5,310,180.00 4,857,650.00 5,625,100.00 2,864,670.00 2,844,900.00 Total SALARIES & WAGES 0.00 0.00 0.00 0.00 0.00 TOtal PERSONNEL BENEFITS 0.00 0.00 0.00 0.00 0.00 590.100.64 MACIiINERY & EQUIPIVIENT 1,962,600.00 450,000.00 45,730.00 1,589,120.00 417,730.00 590.100.65 CONSTRUCTION PROJECTS 193,440.00 33,000.00 860.00 0.00 0.00 Tptal CAPITAL OUTLAY 2,156,040.00 483,000.00 46,590.00 1;589,120.00 417,730.00 TOtal INTERFUND PAYMENTS FOR SERVICES 0.00 0.00 0.00 0.00 0.00 TOtal CAPITAL EXPENpITUREB 7,466,220.00 5,340,650.00 5,671;690:00 4,453,790.00 3262,630.00 ,~''~p, . Page: 1 glWrkSheef.rr& Equipmenfi Rer"' - Other ~ Page: 2 0910212010 52AM City of. Ai n. ~ . . Account.Number 2009 Actua/s 2010 AdJ Budget 2010 Actua/s 2099 2012 Total CAPITAL OUTLAY 7;466,220.00 5;340,650:00 5,671,690.00 4,453,790.00 3,262,630.00 597 OTHER FINANCING ' 597.100 OPERATING TRANSFER OUT 597.100.55 OPERATING TRANSFERS OUT 7,000.00 22,400.00 22,400.00 507,000.00 7,000.00 , Total INTERGOVERNMENTAUINTERFUND ' 7,000.00 .22,400.00 22,400.00 507,000.00 7,000.00 Total OPERATING TRANSFER OUT 7,000.00 22,400.00 22,400.00 507,000.00 7,000.00 TOtal OTHER.FINANCING ' 7,000.00 22,400.00 22,400.00 507,000.00 7,000.00 Total EQUIPMENT RENTAL ' 6,438;960.00 4,513,050.00 5,088,770.00 3,918,790.00 2,227,630.00 TOtal EQUIPMENT RENTAL ..6,438,960.00 4,513,050.00 5,088,770.00 3,918,790:00 2,227,630:00 Grand Total 6,438,960.00 4,513,050.00 5,088,770.00 3,918,790.00 2,227,630.00 ` Page: 2 . J , - Budget Detail' Report Page: 1 0910212010 10:54AM . City of Auburn 550 EQUIP,MENT REN7AL 00 EQUIPMENT RENTAL 548 PUBLIC'WORKS EQUIPMENT 548.681 CONTRA DEPRECIATION. 548.681.00 CAFR ONLY _ ri •--T='.-- ,.r'.., - .7 - - - 1 - r r~ ~ 548'681p07 ~CONTRADEP,RECI TAION 3 a..... ; < . 1~ 2~010 Ju 2011 2012 1 Original Budget -850,000.00 1 Depreciation --1,042,000:00 1 Depreciation -1,042,000.00 ' Line.ltems Total -850,000.00 Line ItemsTotal _1,0421000:00 Line Items Total 71,042,000:00 Change in Budget =192;000:00 Change in Budget 0:00 Total Line ltems -850,000.00 Total Line ltems -1,0420000.00 • Total Line Items -1,042,000.00 ToWI Change in Budget -192,000.00 , Total Change in Budget 0.00 - N . Page: 1 Budget [ il Report Page: 1 09102/2010 4:55AM City ot Huburn 550 EQUIPMENT RENTAL 00 EQUIPMENT RENTAL 590 CAPITAL OUTLAY 590.100 CAPITAL EXPENDITURES - 590.100.00 CAFR ONLY ' rt-r-,-q- _-•-+--•--.-•-..-..--r.•~.-n-^r••+s•.-< 7-__ T.~_....~._.._......._._......-._._._._.w. . _ 590 100 ~06. . _ ENDING~ WORKING,CAPITAL'____ - - - . - - , _ - - _ _ _ . - - - - 2010 2011 2012 1 Original Budget Ending Working Capital 3,173,056.00 1 Estimated Ending Working Capital . 2,864,674.00 1 Estimated Ending Working Capital 2,844,904.00 2 BA# 4 Mid biennial correction -713,775.00 Line Items Total 2,864,674.00 Line Items Total 2,844,904.00 3 BA# 5 Adjust W!C 128,500.00 4 BA# 6 Adjust W/C 1,952,873.00 . 5 BA# 7- Adjust Ending Working Capital 317,000.00 Line Items Total 4,857,654.00 Change in Budget -1,992,980.00 . Change in Budget -19,770.00 590.100.60 CAPITAL OUTLAY 580 100`64 MACHINERY &fQUIPMENT ' . . 2010 2011 2012 1 Utility Truck-4x4 (#6303E) 25,300.00 1 Sewer 6304D 3/4 ton truck 37,663.00 1 Mayor 6101G Town & Country Van 41,376.00 2 314 Ton Heavy Duty Tn.ick (06304D) 37,700.00 2 Sewer 6305D Vactor Combination unit . • 333,984.00 2 Street 6402D Dump truck 58,580.00 3 Flusher Truck w/tank (#6408B) 88,300.00 3 Sewer 6301 D N Van 274,242.00 3 Street 6413C 1/2 ton truck 28,495.00 4 Utility Truck (#6413C) 27,500.00 4 Street 6426C Asphalt Patcher 164,167.00 4 Water 6510A 1/2 ton truck 21,419.00 5 Dump Truck (#6425C) 88,800.00 5 Street 6472B Air Compressor 19,037.00 5 Water 6515C 3/4 ton truck 39,395.00 6 Compressor (#6472B) 18,700.00 6 Street 6428D Asphalt Kettle 46,648.00 6 Parks 6770B Chipper 38,886.00 8 Utility Servioe Truck (#6506D) 39,400.00 7 Water 6549A Vactor 292,034.00, 7 Police P095A Crown Victoria 29,206.00 9 3/4 Ton Service Truck (#6515C) 43,400.00 8 Water 6516C F550 W/ service body 46,739.00 8 Police P031 D Crown Victoria 29,205.00 10 Dump Truck (#6505B) 91,700,00 9 Water 6517C F550 W/ service body 46,739.00 9 Police P054B Chevy Tahoe . 37,304.00 11 Lazer Mower (#6524E) 10,300.00 10 Water 6507E Express cargo van 28,174.00 10 Police P056A Express Cargo Van 37,245.00 12 Air Compressor (#6570C) 17,200.00 11 Parks 6703A Trensit bus 83,600.00 11 Police P070A Crown Victoria 29,169.00 13 10 PI-Battery Operated Utility vehicle 23,000.00 12 Parks 67596 Tilt trailer • 9,177.00 12 Police P071A Crown Victoria 29,449.00 14 10 PI-MWI CDL Vehicle 65,000.00 13 Police P018D Crown Victoria 29,404.00 Line Items Total 417,729.00 15 Police Unit (#P070A) 30,000.00 14 Police P034G Crowm Vctoria 27,229.00 • 16 Police Unit (#P071A) 30,000.00 15 Police P039E Crown Vctoria 28,164.00 17 Police Unit (#P014A) 30,000.00 16 Police P048C Crown Victoria 31,119.00 18 Police Unit (#P015A) 30,000.00 17 Police P060C Kia Sportage . 21,773.00 19 Police Unit (#P031 D) 30,000.00 18 Police P100C Jeep Liberty 22,447.00 20 Police Unft (#P034G) 30,000.00 19 Water 6570C Air compressor 17,575.00 . 21 BA# 5 CF Sander & Deicer 12,900.00 20 Police P014A Crown Victoria ' 29,206.00 22 BA# 6 Reduce Budget -319,200.00 . Lfne Items Total 1,589,121.00 Line Items Total 450,000.00 Change in Budget 9,139,121.00 Change in Budget -1,171,392.00 _ - $90.100:65._ C.ONST_RUC-,TION~,PROJECTiS_ 2010 2011 2012 1 Construction proJects 550,000.00 2 BA# 6 Reduce Budget -200,000.00 Line Items Total 0.00 Line Items Total 0.00 N , Page: 1 ~ . tsuaget uetaii rceporE 09/02/2010 -10:55AM . City, of Auburn 550 EQUIPIIflENT RENTAL 00 ' EQUIPMENT'RENTAL ' 590 ~ CAPITAL OUTLAY . 590.100 CAPITAL EXPENDITURES 590.100.60 CAPITAL OUTLAY .v. -•--r-'--`-..-.- -..--r_a-~.. .^,xr•, -f .'._t,..-. ~n.: .,..:-.F,sF~f '.i . :.t;'-. f.:.. ~ 7" .v j.." ra-•-~--,-~• . ,s . . .7 ~'~"7~ s r t;_3._," TM'.--,a.• ~ _ . ~ r ~ .<<'.,,.:: , -e.n ..:.k~ ~,Fe tti.r2;i:S r f.i> ;s1 :n.;s .;;~,t'_ 590'1'00~.,65~ ~CONSTRUCTIONPROJECTS ~r~,. °:,-.,r { ` ~ '1 u~ , ~'~{_~',~..~_v~~.~~.~_x~;.,~_u__._-.~.~.a.~...~__~,~~..,•,~,..~,~~.~,.,~~;::.;~:.,,~.~~,~~.,~~.~..`,..~~. ,..,:::,~;..~,,..~:w:~.,,~.~ ~_,.~..~.._~....s....d.1~.~.u.:1.A~....~..,~..~_._.._.~~_~:.~...~....~_a~..w,,....~,.~~,.~~..~...~,,.~.~~,..~..... ~.~.~y~ ' - . - - - - 2010 2011 2012 3 BA# 7-Reduce construction projects per =317,000:00 2011=2016 CFP . ' Line ltems_Total 33;000:00 ~ Change irrBudget -33,000.00 Change in Budget 0.00' • Page: 2 Budget C il.Report Pa9e: s 09102/2010 ,:55AM City o. _.Aburn 550 EQUIPAAENT RENTAL 00 EQUIPMENT RENTAL 597 OTHER FINANCING ' . 597.100 OPERATINGTRANSFER OUT 597:1.00.50 I NTERGOVERNMENTAUINTERFUND ~ - ' --«~-~~t'~ X~.-; ~97.~'100.55 -,OP ~ ~..~.....~...[1.....s....l:L,,.~~s.~.s.~_..C......~~~~`~,-T~~.._._~ ..._~_~_c.~~,_...~a..!..:.~s.::w.....~........_f~ ..:.lx..:u...i...,...... _..m~..~:.~':..u:.._,....~:s..,3~.....-' - .....`~c.._.,,.....,..L'~..._...ai.a'~+F,:~ :i....;~.la.:..:~_.. =.....~".~;u,.a:ca ,;.,.FY • :.~2010 2011 ' 2012 1 Transfer to GF for Facility Grounds Maint. 7,000.00 1 Transfer to GF for Facility Grounds Maint. 7,000.00 1 Transfer to GF for Facility Grounds Maint. 71000;00 Contrad Contract Contract • 2 BA# STransfer to fund 501 15,400:00 2 Transfer Out to Generai Fund Intetfund 500,000.00 Line Items Total 7;000.00 Line Items Total 22,400.00 Loan . ' Line Items Total 507,000.00 Change in Budget 484,600.00 Change in Budget -500,000.00 Total Line Items 5,363,054.00 Total Line Items 4,960;795.00 Total Line Items 3,269;633.00 Total Change in Budget -402,258.00 Total Change In Budget -1,691,162.00 N . , Page: 3 (incl w/ Gen Muni Bldgs) CAPITAL FACILITIES PLAN PROJECTS AND FINANCING EQUIPMENT RENTAL , 2011 2012 2013 2014 2015 2016 , Total • _ _ Gapacitv Proiects: . 1- Vehicle Maintenance Bay • Capital Costs 250,000 250,000 - - - - 500,000 Funding Sources: = Equip. Rental Fund 250,000 _ 250,000 - - - - 500,000 2 M&O Vehicle Bay & Storage . Capital Costs 60,000 100,000 - - - - 160,000 Funding Sources: Equip Rental Fund 60,000 100,000 - - - - 160,000 ' SUMMARY: CAPITAL COSTS . Gapacity Projects 310,000 350,000 - - - - 660,000 Non-CapacityProjects - - - - - - ' Total Costs 310;000 350,000 - - - 660,000 FUNDING SOURCES: , Equip. Rental Fund 310,000 350,000 660,000 'Grants (Fed,State,Locaq - - - - - - - Other - - - - - - - - Total Funding 310,000 350,000 - - - - 660,000 , 30 ' ' EQUIPMENT REYVTAL FUND (550) ` Capital Faciirdes Plan . , Six Year Capital Facilities Plan, 2011-2016 Enterprise Funds Project Title: Equipment Rental Vehicle Maintenance Bay ' Projecf No: cp0710 . Project Type; Project Manager: Description:, Add additional vehicie bay at Equipment Rental sho"p for heavy equipment and large vehicles to improve efficiency and remoVe choke points. Adding a large vehicle bay with a maintenance pit wiil enable us to perform inspections and maintenance on more than one large vehicle at a time, and while loaded with product, ie.. sand, water, debris, sewage..CurrenUy several hours of work have to be undone and then repeated due to our limitations. Not only is fhis counterproductive, but it can be catastrophic dUring critical operations. Progress Summary: Future Impact on Operating Budget: None gudget: 2010 YTD Actual 2011 10 Budget . Budget Expenditures Budget Balance Adopted Budget - . Budget Amendments ' Adjusted Budget - - - ' Activity: . (Preyious 2 Yrs) 2010 YE 2011 Year End Funding Sources: Prtor to 2070 Estimate 2011 Budget 2012 Bud et Proeet Totat Unrestricted Equip. Renfal Revenue - - 250,000 250,000 250,000 . Grants (Fed,Stafe.Local) - - - . Other - - - - " Total Funding Sources: - - 250,000 250,000 250,000 Capital Expenditures: Design - - 25,000 - 25,000 Right of Way - - - - ' Construction - - 225,000 250,000 225,000 Total Expenditures: - 250,000 250,000 250,000 Forecasted Project Cost: Total 2013 2014 2015 2016 2011-2016 Funding Sources: - Unresfrfcted Equip. Rental Revenue - - - 500,000 , Grants (Fed, State, Loca/) - - - - ' Other - - ' ' . Total Funding Sources: - - - - 500500 Capital Expenditures: • Design - - - - 25.000 Right of Way ' ~ • 475,000 Construction - - - Totai Expenditures: - - - 500.000 , .31 • , EQUIPMENT RENTAL FUND (550) Capital Facilities Plan Six Year Capital Facilities Plan, 20114016 Enterpr_ise Funds Project Tffle: Mainfenance and Operations Vehicle Bay and Stotage Project No: cp0711 ' - Project Type: Project Manager: Description: Add three irisulated vehicle bays for Vactor storage to provide year-round protection. These vehicles hold large quantities of water on board at all times enabling them to be immediately dispatched in the event of an emergency. This requires them to be protected from . freezing temperatures: Draining their large tanks each day would cause a dispatch delay while refilling, thaf could result in exfraordinary damage to public and private property in an emergency situation. Enclose exosting bays to provide necessary weather protection for streef sweepers, sanding, and; snow plow equipment. Construct storage shed to facilifate removal of portable containers; improving space utilization and traffic flovir thoughout M&O. Progress Summary: Future Impact on Operating Budget: None Budget- 2010 YTD Actual 2011 10 Budget Budget Expenditures Budget Balance Adopted Budget - Budget Amendments - Adjusted Budget - - - - Activity: (Previous 2 Yrs) 2010 YE 2011 Year End Funding Sources: Prior to 2010 _ Estimate 2011 Bud et 2012 Bud et Pro ect Total Unresfricted Equip. Rental Revenue - 40,000 60,000 100,000 100,000 Grants (Fed State,Local) - - - - - Other - Total Funding Sources: - 40,000 60,000 100,000 100,00_0 Capita( Expenditures: Design - - - - - Righ't otWay - - - - - Construction - 40,000 60,000 100,000 100,000 Total Expenditures: - 40,000 60,000 100,000 1001000 . Forecasted' Project Cost: Total 2013 . 2014 2015 2016 2011-2016 Funding Sources: Unrestricted Equip. Renta! Revenue - - - - 160,000 - - - - Grants (Fed, State, Local) Other - - - - - Total Funding Sources: - - - - 160,000 Gapltal Expenditures: Design Right of Way Construction • - - 160,000 Total Expenditures: - - - - 160,000 32