Loading...
HomeMy WebLinkAbout4.E. Equipment Rental Charge Schedule C E G I L M 0 P Q L},E. 1 IS Rent for 2006 Est. Replace. I 2 Cost @ 2005 ----- 3 PW Cost Salvage 4% Rental Year Remaining RENTAL 4 Number DescriDtion Dept. New/Used Value 10% Term Acauired Years RATE 5 A B C E F H I J K 6 305 1998 Ford Ranger ENGIN 17,665 1,500 23,231 10 1998 3 2,323 7 301 1999 Ford Ranger ENGIN 17,104 1,500 22,446 10 1999 4 2,245 8 303 2001 S10 4X4 ENGIN 19,000 1,500 25,100 10 2001 6 2,510 9 306 2001 S10 4X4 ENGIN 19,000 1,500 25,100 10 2001 6 2,510 10 302 2002 GMC Sonoma 4X4 ENGIN 18,000 1,500 23,700 10 2002 7 2,370 11 304 2005 Chev Colorado ENGIN 19,000 1,500 25,100 10 2005 10 2,510 12 TOTAL ENGIN 109,769 144,677 14,468 13 9521 1974 Mack fire trk Fire 105,955 4,000 366,843 25 1974 -6 14 9522 1985 Hend. Fire trk Fire 164,350 4,000 489,050 20 1985 0 15 9510 1986 Spartan fire rescue Fire 156,465 4,000 465,394 20 1986 1 23,270 16 9560 1988 Mack fire tanker Fire 107,735 4,000 319,206 20 1988 3 15,960 17 9572 1990 Ford 1T 4x4 + grass pak Fire 31,066 2,500 47,205 15 1990 0 3,147 18 9511 1991 Chev Step Van Fire 35,000 3,000 102,000 20 1991 6 5,100 19 9523 1992 Fire pumper Fire 227,676 4,000 679,027 20 1992 7 33,951 20 9580 1994 Simon Duplex - Aerial (Mack) Fire 548,776 100,000 1,546,328 20 1994 9 77,316 21 9570 1996 Chev Pickup Fire 37,722 1,500 51,310 10 1996 1 5,131 22 9520 1998 Pierce Pumper Fire 340,227 10,000 1,010,681 20 1998 13 50,534 23 9524 1998 Pierce Pumper Fire 340,227 10,000 1,010,681 20 1998 13 50,534 24 9593 Ice Angel Air Boat & Trailer , Fire 50,541 3,000 98,082 10 1999 4 .9,808 25 9591 1999 Dodge 4X4 Fire 31,712 2,000 42,397 10 1999 4 4,240 26 9592 2000 Ranger Fire 22,000 1,500 29,300 10 2000 5 2,930 27 9590 2003 Dodge Ram 4X4 Fire 19,000 2,000 24,600 10 2003 8 2,460 28 2004 Zodiac Boat Motor & Trailer Fire 11 ,409 - 28,523 15 2005 15 1,902 29 2005 Telesquirt Fire 700,000 25,000 2,075,000 20 2005 20 103.750 30 2005 Pumper Fire 400,000 5,000 1,195,000 20 2005 20 59,750 31 2004 Equipment Truck Fire 210.000 8,000 622,000 20 2005 20 31,100 32 TOTAL FIRE 3,539,860 10,202,626 480,883 33 188 1988 GMC 3500 - 1T PU 4x4 + Equip Gov Bldg 15,600 3,000 18,840 10 1988 -7 754 34 TOTAL GOV BLDG 15,600 18,840 754 35 202 1994 Chev 3/4T Suburban 4X4 Insp't 8,000 1,500 7,460 3 2003 1 2,487 36 200 1998 Ford Ranger Insp't 17,631 1,500 23,183 10 1998 3 2,318 37 201 2000 Ford Ranger Insp't 17,100 1,500 22,440 10 2000 5 2,244 38 012 2001 Ford Crown Vic Insp't 3,000 1,500 1,860 3 2005 3 620 39 204 2001 Chev S10 4X4 Insp't 19,000 1,500 25,100 10 2001 6 2,510 40 206 2002 GMC Sonoma 4X4 Insp't 18,000 1,500 23,700 10 2002 7 2,370 41 TOTAL INSP 82.731 103,743 12,549 42 114 1993 Chev C3500 1.5T Park 25,799 2,500 33,618 10 1993 -2 1,345 43 139-2 1994 Turf Sweeper - Toro 5400 Park 11,467 1,000 17,347 15 1994 4 1,156 44 133 1997 Toro Groundmaster 580D Park 57,539 5,000 75,554 10 1997 2 7,555 45 145 1998 GMC Sierra Truck Park 36,039 2,500 47,955 10 1998 3 4,795 46 157 1990 Ford Super Duty W /Bucket Park 25,187 1,500 28,725 5 1999 -1 1,149 47 122 2000 ISU Garbage Truck Park 55,000 5,000 72,000 10 1999 4 7,200 48 129 2000 Toro 580D Mower Park 59,853 5,000 78,794 10 2000 5 7,879 49 161 2001 Ford F350 - 1 Ton w/Plow Park 22,790 2,500 29,406 10 2001 6 2,941 50 154 2004 Melroe S-185 Hi-Flow Park 25,000 18,000 8,000 1 2003 -1 8,000 51 135 2004 JD 1445 Mower Park 15,705 1,000 20,987 10 2004 9 2,099 52 111 2002 Sterling Acteera w/Hooklift Sys Park 102,735 4,000 160,376 15 200.1 11 10,692 53 134 2005 JD 5425 Tractor Park 36,985 32,517 6,687 1.5 2005 1.5 4,458 54 143P 2002 Graco Stripper/DriverlTrailer Park 12,120 800 16,168 10 2002 7 1,617 55 163 2002 Ford F350 4X4 W/Plow Park 25,295 2,500 32,913 10 2002 7 3,291 56 152 2004 JD 1445 Mower Park 18,~69 1,000 24,997 10 2004 9 2,500 57 131 2003 JD 4710 Tractor 4wd w/cab Park 25,234 22,000 4,748 1.5 2003 -0.5 3,165 58 166 2005 Bobcat S300 Loader w/SB & Fork~ ,Park 30,000 26,/500 4,700 1 2005 1 4,700 59 132M 2004 LandPride Mower Park 11,620 - 16,268 10 2004 9 1,627 60 132 2004 JD 5420 Tractor Park 37,000 34,000 5,220 1.5 2004 0.5 3,480 61 165 2004 Ford F350 4x4 w/plow Park 29,000 2,500 38,100 10 2004 9 3,810 62 2005 leaf vacuum Park 30,000 - 48,000 15 2005 15 3,200 63 TOTAL PARK 692,937 770,563 86,660 64 011 2001 Ford Crown Vie Admin 3.000 1,500 1,860 3 2005 3 620 65 TOTAL ADMIN 3,000 1,860 620 66 970 1997 Ford Contour Police 3,000 1,500 1,860 3 2005 3 620 67 994 1999 Chev Malibu Police - _~?75 1,500 9,630 5 2002 2 1,926 68 015 2001 Ford Taurus Police JJ ,235 1,500 11,982 5 2002 2 2,396 69 033 2003 Impala Police :1..7,500 1,500 19,500 5 2003 3 3,900 70 021 2003 Ford Crown Vie Police 33,000 1,500 36,780 4 2002 1 9.195 71 022 2003 Ford Crown Vic Police 33}000 1,500 36,780 4 2002 1 9,195 72 023 2003 Ford Crown Vie Police 33,gOO 1,500 36,780 4 2002 1 9.195 73 031 2003 Ford Crown Vie Police 30.900 1,500 33,300 4 2003 2 8,325 74 032 2003 Ford Crown Vie Police 30,000 1,500 33,300 4 2003 2 8,325 75 041 2004 Ford Crown Vic Police 32,000 1,500 35,620 41 2004 3 8,905 76 ",,~- Police 32,000 1,500 35,620 4 2004 ., . .n AU 8,905 77 043 2004 Ford Crown Vic Police 32,000 1,500 35,620 4i 2004 3 8,905 C E G I L M 0 P Q R S 1 IS Rent for 2006 Est. Replace. 2 Cost @ 2005 ANNUAL 3 PW Cost Salvage 4% Rental Year Remaining RENTAL 4 Number DescriDtion DeDt. New/Used Value 10% Term ACQuired Years RATE 5 A B C E F H I J K 78 044 2004 Ford Crown Vic Police 32,000 1,500 35,620 4 2004 3 8,905 79 054 2005 Ford Crown Vic - Gray Police 32,000 1,500 35,620 4 2005 4 8.905 80 051 2005 Ford Crown Vic Police 32,000 1,500 35,620 4 2005 4 8,905 81 055 2005 Ford Crown Vic Police 32,000 1,500 35,620 4 2005 4 8,905 82 053 2005 Ford Crown Vic Police 32,000 1,500 35,620 4 2005 4 8,905 83 052 2005 Ford Crown Vic Police 32,000 1,500 35,620 4 2005 4 8,905 84 056 2005 Chev Impala Police 16,500 1,500 18,300 5 2005 5 3,660 85 057 2005 Ford F350 4X4 Crew Cab Police 36,500 3,000 55,400 15 2005 15 3,693 86 TOTAL POLICE 541,010 540,492 133,222 87 160 1989 CAT#140G Road Grader Street 128,521 20,000 185,634 15 1989 -1 7,425 88 119 1990 Loader - Case Street 88,616 15,000 126,786 15 1990 0 8,452 89 156 1991 Chev S10 Street 9,571 1,500 11 ,899 10 1991 -4 476 90 ??? 108 1992 Ford LN 8000 dump trk & equip Street 65,348 4,000 100,556 15 1992 2 6,704 91 121 1992 Loader - Case 621 Street 90,428 15,000 129,685 15 1992 2 8,646 92 123 1993 Alley Grader - Gehl747B Street 50,295 5,000 85,531 20 1993 8 4,277 93 103 1993 IHC 2554 Dump Street 70,809 4,000 109,294 15 1993 3 7,286 94 304 1994 Chev S10 PU Street 10,231 1,500 12,824 10 1994 -1 513 95 104 1995 Ford LN 8000 Dump Truck Street 72,203 4,000 111,525 15 1995 5 7,435 96 142 1996 Buthling Asphalt Roller Street 16,071 2,000 23,713 15 1995 5 1,581 97 106 1998 Ford Single axle Dump Truck Street 62,547 4,000 96,075 15 1997 7 6,405 98 107 1998 Ford Single axle Dump Truck Street 62,547 4,000 96,075 15 1997 7 6,405 99 155 19981 Ton Chev Pickup with plow Street 24,840 2,000 32,776 10 1998 3 3,278 100 117 1998 GMC 3500 HD 2x4 Trk w/box Street 36,039 2,500 47,955 10 1998 3 4,795 101 105 2000 Sterling Dump Trk Street 90,000 4,000 140,000 15 2000 10 9,333 102 102 2000 Sterling Dump Trk Street 90,000 4,000 140,000 15 2000 10 9,333 103 159 2000 Inti 4700 LP Paving Trk Street 88,000 4,000 136,800 15 2000 10 9.120 104 125 2000 GMC 3500 4x4 W/Plow & Lift Street 31,000 2,500 40,900 10 2000 5 4,090 105 130 2000 Bandit Brush Chipper 250XP Street 24,770 2,000 32,678 10 2000 5 3,268 106 013 2001 Ford Crown Vie - Ok Blue Street 3,000 1,500 1,860 3 2005 3 620 107 109 2001 Sterling Dump Street 95,000 4,000 148,000 15 2001 11 9,867 108 118 2001 Tenco TE 172 LM Snow Blower Street 66,468 8,000 90,373 12 2001 8 7,531 109 120 2002 Case 6210 Loader W /plow & wing Street 136,000 15,000 202,600 15 2002 12 13,507 110 101 2002 Sterling L8500 Street 100,900 4,000 157,440 15 2002 12 10,496 111 164 2003 Ford F3504X4 w/plow Street 29,000 2,500 38,100 10 2003 8 3,810 112 110 2004 Sterling Dump Truck Street 106,900 4,000 167,040 15 2003 13 11,136 113 108 2004 Sterling Dump Truck Street 106,900 4,000 167,040 15 2003 13 11,136 114 2005 Ford F550 - Sign Truck Street 66,000 3,000 102,600 15 2005 15 6,840 115 2005 Sterling L8500 Street 115,000 4,000 180,000 15 2005 15 12,000 116 TOTAL STREET 1,937,004 2,915,759 195,765 117 700 Ice Resurfacer Rec Fund 45,000 2,000 61,000 10 1995 0 6,100 118 702 1992 GMC Sonoma P/U Rec Fund 10,834 1,000 14,168 10 1992 -3 567 Rec Fund . - 3,000 1,500 1,860 3 2004 2 620 119 2000 Ford Crown Vic 120 870 1987 Chev Suburban (squad) Rec Fund 4,000 1,500 3,300 5 2005 5 660 121 701 2001 Ford Windstar 3dr LX Minivan Rec Fund' 19,533 1,500 25,846 10 2001 6 2,585 122 TOTAL REC. 82,367 106,174 10,531 123 GRAND TOTAL 7,004,277 14,804,734 0 935,451 ISFUND.XLSEquip 05List-06Budget 8/25/20059:10 AM ""... R5509BUD LOGIS001 CITY OF SHAKO PEE 8/16/2005 14:50:25 Fiscal Period: 6 / 05 Budget Report Page - 3 Level Of Rollup 7 2002 2003 2004 6/30/2005 2005 2006 2006 2006 Actual Actual Actual yto Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget BUdget Budget Budget 4570 COMMUNITY DEVELOPMENT 37,481- 57,236- 52,875- 31,987- 40,000- 58,000- 58,000- 58,000- 4600 ENGINEERING 4620 ENGINEERING FEE 747,009- 944,489- 931,326- 293,457- 600,000- 600,000- 600,000- 600,000- 4630 ENGINEERING GRADE FEE 61,282- 127,656- 225,822- 96,398- 100,000- 100,000- 100,000- 100,000- 4600 ENGINEERING 808,291- 1,072,144- 1,157,148- 389,855- 700,000- 700,000- 700,000- 700,000- 4640 PUBLIC SAFETY FEES 4642 POLICE SERVICES 84,045- 86,620- 53,675- 37,115- 88,000- 60,000- 60,000- 60,000- 4643 VALLEY FAIR 29,089- 31,998- 35,194- 36,829- 35,000- 35,000- 35,000- 35,000- 4655 POUND FINES & FEES 3,600- 4,230- 4,610- 1,090- 4,500- 3,000- 3,000- 3,000- 4660 FIRE SERVICES 68,285- 53,585- 67,127- 3,190- 55,000- 67,000- 67,000- 67,000- 4640 PUBLIC SAFETY FEES 185,019- 176,432- 160,607- 78,224- 182,500- 165,000- 165,000- 165,000- 4670 PUBLIC WORKS 4678 PUBLIC WORKS RENTAL 249- 334- 4680 MISC PUBLIC WORKS 18,383- 5,175- 7,169- 3,390- 6,000- 6,000- 6,000- 6,000- 4684 SIGNS 18,360- 12,960- 6,210- 4,590- 14,000- 8,000- 8,000- 8,000- 4670 PUBLIC WORKS 36,743- 18,384- 13,713- 7,980- 20,000- 14,000- 14,000- 14,000- 4750 REFUSE 4751 REFUSE CHARGES 10,399- 9,616- 10,003- 12,000- 11,000- 11,000- 11,000- 4750 REFUSE 10,399- 9,616- 10,003- 12,000- 11,000- 11,000- 11,000- 4760 RECREATION FEES 4812 VENDING CONCESSION COMMISSION 74- 4760 RECREATION FEES 74- 4500 CHARGES FOR SERVICE 1,243,535- 1,491,614- 1,574,649- 593,535- 1,119,200- 1,087,660- 1,087,660- 1,087,660- 4820 FINES & FORFEITS 4821 FINES & FORFEITS 253,348- 232,975- 249,642- 115,884- 260,000- 267,000- 267,000- 267,000- 4822 FINES & FORFEITS - SJPA 6,613- 6,121- 6,121 4820 FINES & FORFEITS 253,348- 239,588- 255,763- 109,763- 260,000- 267,000- 267,000- 267,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 232,614- 222,061- 136,758- 38,949 200,000- 150,000- 150,000- 150,000- 4832 INVESTMENT INCOME 232,614- 222,061- 136,758- 38,949 200,000- 150,000- 150,000- 150,000- 4840 RENTS 11,926- 3,842- 1,876- 191- 1,000- 1,000- 1,000- R5509BUD LOGIS001 CITY OF SHAKOPEE 8/16/2005 14:50:25 Fiscal Period: 6 / 05 Budget Report Page - 4 Level Of Rollup 7 2002 2003 2004 6/30/2005 2005 2006 2006 2006 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 4843 COMMISSIONS 649- 378- 4845 CONTRIBUTIONS 500- 4,000- 4850 MISCELLANEOUS 50,754- 8,381- 34,805- 13,637- 50,000- 50,000- 50,000- 50,000- 4852 INSURANCE DIVIDENDS/FEES 36,870- 4855 SALE OF ASSETS 9,644- -- 4850 MISCELLANEOUS 60,398- 45,251- 34,805- 13,637- 50,000- 50,000- 50,000- 50,000- 4830 MISCELLANEOUS 304,938- 271,653- 174,088- 20,743 250,000- 201,000- 201,000- 201,000- 4960 PROCEEDS FROM DEBT ISSUED 4001 REVENUES 11,056,124- 12,753,317- 12,887,186- 7,013,403- 12,745,810- 14,101,750- 14,101,750- 14,101,750- 4000 REVENUES AND EXPENDITURES 11,056,124- 12,753,317- 12,887,186- 7,013;403- 12,745,810- 14,101,750- 14,101,750- 14,101,750- -- 01000 GENERAL FUND 11,056,124- 12,753,317- 12,887,186- 7,013,403- 12,745,810- 14,101,750- 14,101,750- 14,101,750- f'!.c<< .