City of San Juan Bautista
Asset Depreciation Schedule
Source: City of San Juan Bautista Depreciation Expense 7/1/2005 - 6/30/2006
Department Asset # Description Yr. Aq'd Useful Life Cost Beg. Accum. Depreciation Current Depreciation Total Depreciation
100 General 43 Community Hall 12/31/1930 40 30,000 30,000 0 30,000
34 Fire Station #1 12/31/1950 40 44,800 44,800 0 44,800
38 City Maintenance Building 12/31/1950 40 30,000 30,000 0 30,000
167 Fire #2 12/31/1950 0 2,500 0 0 0
63 Library Building 12/31/1955 40 300,000 300,000 0 300,000
32 City Hall 12/31/1957 40 85,000 85,000 0 85,000
168 Verutti Park 12/31/1970 0 5,290 0 0 0
169 Ball Park 12/31/1977 0 8,640 0 0 0
170 Library 12/31/1978 0 4,680 0 0 0
158 Lang Ct - Lang to end 12/31/1985 25 3,482 2,716 139 2,855
159 Lang St - Lang Ct to end 12/31/1985 25 3,482 2,716 139 2,855
160 Lang St - Stephens to Lang Ct 12/31/1985 25 5,222 4,073 209 4,282
161 Lang St - Washington to Stephens 12/31/1985 25 4,352 3,394 174 3,568
162 Via Padre - 1st to end 12/31/1986 25 6,945 5,140 278 5,418
163 Via Serra - 1st to end 12/31/1986 25 11,200 8,288 448 8,736
88 Improvements 7/1/1988 15 24,690 24,690 0 24,690
91 Fire truck 7/1/1993 5 69,936 69,936 0 69,936
41 Office equipment 12/31/1993 5 27,253 27,253 0 27,253
164 Fire Station #2 12/31/1995 40 65,000 15,438 1,625 17,063
89 Asset purchase 6/30/1997 5 10,348 10,348 0 10,348
90 Fire plan expansion 6/30/1997 5 2,088 2,088 0 2,088
92 Asset purchase 6/30/1998 5 2,784 2,784 0 2,784
93 Asset purchase 6/30/1998 5 5,709 5,709 0 5,709
87 Office equipment 7/24/1998 5 1,920 1,920 0 1,920
96 Library lighting repair 12/14/1998 7 1,460 1,374 86 1,460
86 Fund balance software 12/21/1998 5 9,707 9,707 0 9,707
94 Improvements - Council Chambers 1/11/1999 7 3,020 2,804 216 3,020
97 Tractor/Backhoe 3/30/1999 5 31,455 31,455 0 31,455
95 Bus shelter 4/13/1999 15 4,552 1,896 303 2,199
102 Financial software package 7/1/1999 5 7,060 7,060 0 7,060
101 2 computers & 1 monitor 8/15/1999 5 1,565 1,565 0 1,565
105 Tractor upgrades Backhoe 8/15/1999 5 7,161 7,161 0 7,161
107 Air compressor - Fire Dept 8/15/1999 5 7,900 7,900 0 7,900
104 County communication equipment 9/15/1999 5 2,985 2,986 -1 2,985
111 Computer, software, card reader 11/15/1999 5 5,975 5,975 0 5,975
103 Picnic tables 12/15/1999 7 4,310 3,438 616 4,054
99 Copier 12/31/1999 5 7,474 7,474 0 7,474
166 Community Hall 12/31/1999 0 1,500 0 0 0
98 Table, platform, cabinets - City Hall 1/15/2000 7 4,500 3,536 643 4,179
112 Computer, monitor, printer 2/15/2000 5 4,128 4,128 0 4,128
113 Server & monitor 2/15/2000 5 3,478 3,478 0 3,478
114 3 computers/monitors 2/15/2000 5 6,763 6,763 0 6,763
115 Ethernet hub 2/15/2000 5 1,483 1,483 0 1,483
117 Fund balance software 8/1/2000 5 1,797 1,767 30 1,797
116 Sheriff's car 9/15/2000 5 35,293 34,117 1,176 35,293
120 Fund balance software 11/16/2000 5 1,709 1,567 142 1,709
119 Mobile vision video 12/18/2000 5 4,799 4,319 480 4,799
121 Alco sensor 12/18/2000 5 740 666 74 740
122 Notebook computer 12/18/2000 5 4,161 3,745 416 4,161
118 Office equipment 4/13/2001 5 1,942 1,650 292 1,942
124 Computer 7/15/2001 5 856 685 171 856
125 Breathing air fill station 8/15/2001 5 3,025 2,370 605 2,975
123 South valley trailersyear trailer 9/15/2001 5 1,576 1,437 139 1,576
127 Fire rescue vehicle 1/15/2002 5 42,069 29,449 8,414 37,863
126 Traffic signal station 6/15/2002 7 5,329 2,347 761 3,108
137 Fire rescue equipment 7/15/2002 5 7,746 4,647 1,549 6,196
129 Sound system 8/15/2002 5 2,373 1,385 475 1,860
130 Limitimer system 9/15/2002 5 735 417 147 564
132 Projector & laptop 9/15/2002 5 3,954 2,241 791 3,032
134 County communication equipment 9/15/2002 5 2,985 1,692 597 2,289
135 Video cameras 10/15/2002 5 4,292 2,360 858 3,218
128 Storage container 11/15/2002 15 2,198 391 147 538
131 Laptop computer 3/15/2003 5 1,054 492 211 703
133 Concrete saw 3/15/2003 5 1,553 725 311 1,036
136 Defibrillator 6/15/2003 5 2,967 1,236 593 1,829
138 Fire dept software 9/16/2003 5 1,085 380 217 597
139 Breathing air compressor 9/30/2003 5 11,282 3,948 2,256 6,204
140 Thermal imaging camera 10/3/2003 5 12,227 4,279 2,445 6,724
151 Boots & gloves 10/7/2003 5 1,358 476 272 748
152 Outfit accessories 10/16/2003 5 1,530 536 306 842
141 Portable radios 10/17/2003 5 10,938 3,646 2,188 5,834
142 Dell computer 10/22/2003 5 775 258 155 413
143 6000 PSI cascade cylinder 10/27/2003 5 3,039 1,013 608 1,621
144 Honda generator 10/29/2003 5 1,984 662 397 1,059
145 Breathing apparatus 11/17/2003 5 14,321 4,535 2,864 7,399
146 Vehicle extraction equipment 11/18/2003 5 29,344 9,292 5,869 15,161
147 Trail blazers 11/21/2003 5 960 304 192 496
154 Bio systems posicheck 11/24/2003 5 6,971 2,207 1,394 3,601
155 Awahnee St, Donner - 1 St 12/31/2003 25 25,600 1,536 1,024 2,560
156 Donner St - Awahnee - 1 St 12/31/2003 25 12,800 768 512 1,280
157 Donner St - Awahnee - 2nd 12/31/2003 25 12,800 768 512 1,280
153 Equipment on 9161 1/1/2004 5 3,245 974 649 1,623
148 Turnout coats & pants 1/22/2004 5 17,750 5,029 3,550 8,579
149 22 spare air cylinders 1/30/2004 5 10,056 2,849 2,011 4,860
150 Valve assembly 3/17/2004 5 4,719 1,180 944 2,124
84 Capital lease mower 4/30/2004 5 8,366 1,952 1,673 3,625
106 Generator 8/26/2004 5 2,000 333 400 733
100 City yard doors 9/23/2004 5 2,193 329 439 768
110 1993 GMC pu 9/28/2004 5 4,603 690 921 1,611
109 1998 Chevy pu yellow 11/30/2004 5 3,975 464 795 1,259
108 New engine 3/31/2005 5 272,986 13,649 54,597 68,246
173 Diamond fire and rescue equipment 10/26/2005 5 24,718 0 3,296 3,296
175 Advantage procurement equipment 3/22/2006 5 2,582 0 129 129
Subtotal 100 1,509,157 948,238 113,869 1,062,107
  Less dispositions and exchanges 114,226 76,726 0 88,865
Net for 100 1,394,931 871,512 113,869 973,242
151 Law Enforcement 165 Sheriff patrol car 3/31/2005 5 27,456 1,373 5,491 6,864
Subtotal 151 27,456 1,373 5,491 6,864
  Less dispositions and exchanges 0 0 0 0
Net for 151 27,456 1,373 5,491 6,864
200 Gas Tax 171 1993 GMC pu 9/28/2004 5 347 52 69 121
172 1998 Chevy pu yellow 11/30/2004 5 300 35 60 95
Subtotal 200 647 87 129 216
  Less dispositions and exchanges 0 0 0 0
Net for 200 647 87 129 216
800 Water 7 City reservoir cell tower site 12/31/1909 0 3,750 0 0 0
10 Spring site 12/31/1912 0 3,506 0 0 0
1 Reservoir 12/31/1930 40 260,000 260,000 0 260,000
9 Well sites 12/31/1963 0 3,829 0 0 0
27 Wells 2/9/1983 50 116,410 52,301 2,328 54,629
62 Hydrants 12/31/1985 10 7,480 7,480 0 7,480
79 Lang street main 12/31/1985 40 56,100 27,349 1,403 28,752
80 Via serravia padre main 12/31/1986 40 22,440 10,379 561 10,940
3 Miscellaneous 12/31/1991 5 5,895 5,895 0 5,895
5 Chorine feeder 11/30/1992 5 613 613 0 613
8 Gate valves 6/1/1996 20 28,000 14,000 1,400 15,400
15 Lift station pump 7/31/1997 5 5,846 5,846 0 5,846
14 98 Dodge 4/29/1998 5 1,817 1,817 0 1,817
11 Water main repair 11/27/1998 15 2,654 1,165 177 1,342
17 Lift pump 1/21/1999 10 19,579 12,726 1,958 14,684
20 Fund balance software 1/1/2000 10 1,669 918 167 1,085
21 Fund balance software 8/15/2000 10 417 206 42 248
23 Reservoir fence 4/1/2001 10 3,428 1,457 343 1,800
22 Pump house improve & well #2 5/1/2001 15 3,590 997 239 1,236
24 Motor - well #3 1/17/2002 7 3,368 1,684 481 2,165
25 New pump well #3 2/12/2002 7 17,726 8,652 2,532 11,184
28 Well #1 water main improvements 5/21/2002 5 2,290 1,412 458 1,870
73 Wharf hydrant reservoir 3/24/2003 5 2,826 1,177 565 1,742
72 Pump motor well #2 6/21/2003 7 5,549 2,247 793 3,040
26 Pump motor well #2 8/21/2003 7 5,926 1,341 847 2,188
81 Awahanee/Donner main 12/31/2003 40 64,570 2,421 1,614 4,035
82 Hydrants 12/31/2003 10 15,000 2,250 1,500 3,750
83 Well #1 water main improvements 12/31/2003 50 75,000 2,250 1,500 3,750
18 1993 GMC pu 9/28/2004 5 1,042 156 208 364
29 Well #1 refurbishment 10/28/2004 5 76,111 10,148 15,222 25,370
19 1998 Chevy pu yellow 11/30/2004 5 900 105 180 285
178 Maggiora bros drilling inc equip 5/24/2006 5 5,370 0 90 90
176 Agee electric 5/25/2006 5 995 0 17 17
177 Epic internatin equipment 5/25/2006 5 1,435 0 24 24
Subtotal 800 825,131 436,992 34,649 471,641
  Less dispositions and exchanges 1,942 261 0 649
Net for 800 823,189 436,731 34,649 470,992
850 Sewer 6 Waste water treatment plant 12/31/1978 0 3,000 0 0 0
71 Land 12/31/1979 0 10,698 0 0 0
76 Lang street main 12/31/1985 40 21,660 10,560 542 11,102
77 Lang st 500' forchline 12/31/1985 40 4,760 2,321 119 2,440
85 Lang ct lift station 12/31/1985 20 25,000 24,375 625 25,000
78 via serravia padre main 12/31/1986 40 9,542 4,414 239 4,653
61 Sewer treatment plant 9/1/1989 40 1,317,307 557,878 32,933 590,811
33 Flow meter 9/1/1993 5 2,201 2,201 0 2,201
35 Waste water pump repair 12/31/1994 5 3,696 3,696 0 3,696
37 Pump repair 3/8/1995 5 5,130 5,130 0 5,130
70 Sewer expansion 8/1/1995 40 834,064 206,779 20,852 227,631
29 Lift pump 6/30/1997 10 10,902 9,811 1,090 10,901
42 Rebuild pump 10/9/1997 5 2,525 2,525 0 2,525
40 98 Dodge 4/29/1998 5 5,450 5,450 0 5,450
44 Sewer repair allsop 7/1/1998 5 4,329 4,329 0 4,329
47 Office equipment 7/24/1998 5 960 960 0 960
45 Levee plt lft stn 10/1/1998 5 2,801 2,801 0 2,801
46 Flow meter bkwash 6/16/1999 5 1,102 1,102 0 1,102
64 Electrical panel lift station 9/21/1999 15 1,264 429 84 513
50 Pump for lift station sj hwy 10/31/1999 7 6,177 5,055 882 5,937
51 Fund balance software 1/1/2000 10 4,108 2,260 411 2,671
69 Nitrification upgrade 1/1/2000 30 156,031 28,606 5,201 33,807
48 2 portable composite samplers 1/12/2000 5 2,189 2,189 0 2,189
49 Pump model #4SE4524L 2/1/2000 7 3,385 2,620 484 3,104
74 Fund balance software %share 8/1/2000 10 995 490 100 590
53 Rebuild pumps lang st lift station 11/1/2000 5 2,417 2,255 162 2,417
54 Tripod 2/15/2001 10 1,966 852 197 1,049
52 Rehab electrical drive aerators 5/1/2001 5 10,334 8,612 1,722 10,334
65 Filter rebuild 6/30/2001 10 11,379 4,552 1,138 5,690
67 Sewer plant fence 7/5/2001 10 3,092 1,237 309 1,546
56 Filter rebuild 7/31/2001 10 1,891 583 189 772
66 Aerator pond 1 9/1/2001 5 1,397 1,071 279 1,350
55 Plant improvement 12/31/2001 10 1,363 641 136 777
57 Concrete walkway 2/1/2002 10 912 311 91 402
68 Gravity influent screen 4/30/2002 5 1,427 903 285 1,188
58 Breaker 1/10/2003 5 2,362 1,181 472 1,653
59 Breaker 1/10/2003 5 1,514 757 303 1,060
2 Awahanee detention pond 12/31/2003 0 45,000 0 0 0
12 12" corrugated pipe 12/31/2003 40 9,270 348 232 580
13 24" corrugated pipe 12/31/2003 40 40,886 1,533 1,022 2,555
16 36" corrugated pipe 12/31/2033 40 48,157 1,806 1,204 3,010
36 Awahanee lift station 12/31/2003 20 35,000 2,625 1,750 4,375
75 Awahanee/donner main 12/31/2003 40 29,057 1,089 726 1,815
4 Sewer inspection system 5/11/2004 7 67,065 11,178 9,581 20,759
60 Pump - lift station #3 6/30/2004 10 8,945 970 895 1,865
30 1993 GMC pu 9/28/2004 5 2,692 404 538 942
31 1998 Chevy pu yellow 11/30/2004 5 2,325 271 465 736
174 Reclassed fixed assets 51979 3/31/2006 5 8,166 0 1,633 1,633
Subtotal 850 2,775,893 929,160 86,891 1,016,051
  Less dispositions and exchanges 7,241 2,064 0 3,151
Net for 850 2,768,652 927,096 86,891 1,012,900
Subtotal 5,138,284 2,315,850 241,029 2,556,879
  Less dispositions and exchanges 123,409 79,051 0 92,665
Grand totals 5,014,875 2,236,799 241,029 2,464,214