| 2006 City Working Budget with End of Year Projections (EOY)<=
/td>
|
| as of =
9-8-06 |
|
|
|
|
|
|
|
| |
|
Budget |
Actual expenses |
Variance |
Variance |
End of Year Credit |
End of Year Debit |
|
| Line Item |
Name |
2,006 |
2006 - 8/17/06 |
$$ |
% |
Comments through 8/17/=
06 |
| =
4110 |
Salary/Wages |
1,302,033 |
735,602 |
566,431 |
56% |
80,325 |
|
Vacancy sav=
ings -
6 positions 11% of salary budget |
| 4111 |
Overtime Wages |
2,080 |
4,748 |
-2,668 |
228% |
|
-1,200 |
anticipated overtime t=
hrough End
of Year (EOY) |
| =
4118 |
Temporary Wages |
27,247 |
21,542 |
5,705 |
79% |
|
0
| =
Add
$26K for temporary wages from Board Funds for a 0 balance |
| 4100
Total Salary and Wages |
$1,331,360
|
$761,891 |
$569,469 |
57% |
80,325 |
-1,200 |
|
| 4120 |
Social Security - 25.7% |
=
82,544 |
45,984 |
36,560 |
56% |
11,246 |
|
Approx=
imate
benefits savings, based on vacancy savings - 80,325* 14% =3D 11245.50 (8/=
06) |
| 4121 |
Medicare - 6% |
19,305 |
10,754 |
8,551 |
56% |
|
|
|
| 4130 |
Retirement - 24.3% |
78,247 |
41,678 |
36,569 |
53% |
|
|
|
| 4131 |
Section 125 Administration - .27% |
875 |
358 |
518 |
41% |
|
|
|
| 4140 |
Workers' Compensation - .32% |
1,040 |
680 |
360 |
65% |
|
|
|
| 4150 |
Group Health Insurance - 40.6% |
130,463 |
71,787 |
58,677 |
55% |
|
|
|
| 4155 |
Group Life Insurance - .52% |
1,685 |
883 |
802 |
52% |
|
|
|
| 4160 |
Work Study |
|
0 |
0 |
0% |
|
|
|
| 4170 |
Unemployment Insurance - 2.31% |
7,435 |
3,868 |
=
3,567 |
52% |
|
|
|
| 4110
Total Benefits |
$321,594 |
$175,991 |
$145,603 |
55% |
11,246 |
0 |
|
| 4211 |
General/Auto Liability |
6=
,832 |
=
12,437 |
-5,605 |
182% |
<=
/td>
|
| =
|
| 4212 |
Boiler Coverage |
1,300 |
1,190 |
110 |
92% |
|
|
|
| 4213 |
Fire/Ext Coverage |
15,100 |
11,598 |
=
3,502 |
77% |
|
|
|
| 4214 |
Other Insurance |
160 |
5 |
155 |
3% |
|
|
|
| 4210
Total Insurances |
$23,392 |
$25,230 |
($1,838) |
108% |
0 |
0 |
|
| 4223 |
Consultant Services |
3=
,500 |
75=
0 |
=
2,750 |
21% |
<=
/td>
|
| Mary
Bushing - Customer Service and Collection Development anticipated at $2K -
amount is within budget |
| 4225A |
SDLN |
71,933 |
25,053 |
46,880 |
35% |
10,000 |
|
|
| 4225B |
Minitex/OCLC |
10,309 |
30,200 |
-19,891 |
293% |
|
-19,891 |
misbudgeted for 2006 -=
should
have been 16K and was budgeted 10K - Actual Cost for 2006 - $30,200 (12,450 going through 8/06=
) - will
over-expend by $19,891 by EOY |
| 4225C |
Maintenance Services |
6,807 |
7,384 |
-577 |
108% |
|
-1,000 |
additional maintenance=
through
year estimated at $1000 |
| 4225D |
Other Services |
3,000 |
8,391 |
-5,391 |
280% |
|
-500=
|
temp
wages for BO out of this line item during ACI vacancy totalling $2933 -
estimate an additional $500 by EOY |
| 4225E |
Programming Services |
4,500 |
870 |
=
3,630 |
19% |
|
|
OBOC Sue Grafton appro=
ximately
$500 remaining (within budget) - expect to zero this line item. |
| 4220
Total Professional Services/Fees |
$100,049 |
$72,648 |
$27,401 |
73% |
10,000 |
-21,391 |
|
| 4226 |
Service Other Departments |
13,520 |
9,016 |
=
4,504 |
67% |
|
|
|
| 4226
Total Interdepartmental Charges |
$13,520 |
$9,0=
16 |
=
$4,504 |
67% |
0 |
0 |
|
| 4230 |
Publishing |
75=
0 |
331 |
419 |
44% |
<=
/td>
|
| expect=
to zero
this line item |
| 4230
Total Publications |
$750 =
|
$3=
31 |
$419 |
44% |
0 |
0 |
|
| 4243 |
Machinery Rental |
|
|
0 |
0% |
<=
/td>
|
| =
|
| 4244 |
Lease/Purchases |
18,369 |
23,995 |
-5,626 |
131% |
|
-5,000 |
pd add't $6K to Johnso=
n's
Control; misapplied approx $3400 pmts which should have gone to 4253A Rep=
air
Equip for copier maint. - F=
inal
Wells Fargo pmt for Johnson's Control contract $12K pd this year, only $6=
K budgeted
originally - (7/06) will continue to have parking, copier, postage lease =
pmts
through end of year - $5K |
| 4246 |
Parking |
5,400 |
4,860 |
540 |
90% |
|
|
|
| 4240
Total Rentals |
$23,769 |
$28,855 |
($5,086) |
121% |
0 |
-5,000 |
|
| 4251 |
Rolling Stock |
$0 <=
/td>
| =
$441 |
-441 |
0% |
<=
/td>
|
| =
|
| 4252 |
Repair Structures |
59,900 |
53,442 |
6,458 |
89% |
|
-40,350 |
See Prioritized List T=
ab |
| 4253A |
Repair Equipment |
24,000 |
15,946 |
=
8,054 |
66% |
|
-11,856 |
total for 4253A-C =3D =
$39,000;
have $4,480 - will have
additional repair work throughout remainder of year estimated at $2000;
budgeted $9856 for self check maint contract |
| 4253C |
Johnson Controls |
15,000 |
19,880 |
-4,880 |
133% |
|
3,925 |
anticipate an addition=
al $1K
expenditure through EOY; contract expired 8-31-06; new contract for remai=
nder
of 2006 is $2925 |
| 4255 |
Repair Water/Sewer |
1,000 |
45 |
955 |
5% |
|
|
|
| 4250
Total Repair/Maintenance |
$99,900 |
$89,754 |
$10,146 |
90% |
|
-48,281 |
|
| 4261=
A |
Office Supplies/Library Cards<=
/td>
| =
11,280 |
10,136 |
1,144 |
90% |
<=
/td>
| -1,500 |
total =
for
4261A-D =3D $53,188; have $28,429 remaining ordered <=
/font>$2985 in library cards - anticipate $1500 additional offi=
ce
supplies by EOY |
| 4261B |
Printing |
5,835 |
6,399 |
-564 |
110% |
|
-500=
|
anticipate an addition=
al $500 in
cost over expended |
| 4261C |
Books/AV Processing |
22,573 |
6,060 |
16,513 |
27% |
10,000 |
|
potential of $10K rema=
ining from
Books/AV materials at EOY |
| 4261D |
Postage |
13,500 |
5,285 |
8,215 |
39% |
|
|
expect to zero this li=
ne item |
| 4262 |
Gasoline, Oil, Fuel |
500 |
957 |
-457 |
191% |
|
-250=
|
anticipate an addition=
al $250
spent through EOY |
| 4263 |
Clothing, Food |
|
291 |
-291 |
0% |
|
|
no additional expendit=
ures
anticipated |
| 4264 |
Janitorial/Chemical |
2,250 |
5,874 |
-3,624 |
261% |
|
-3,000 |
total 4264A =3D $4500;=
overspent
by $3624 add't $3K in overexpenditure by EOY (9/06) |
| 4264A |
Building Supplies |
2,250 |
|
=
2,250 |
0% |
|
|
|
| 4265 |
Minor Tools |
1,000 |
581 |
419 |
58% |
|
|
expect to zero this li=
ne item |
| 4260
Total Supplies/Materials |
$59,188 |
$35,582
|
$23,606
|
60% |
10,000 |
-5,250 |
|
| 4270 |
Travel/Training |
=
12,000 |
7,433 |
4,567 |
62% |
<=
/td>
| -8,200 |
antici=
pate $3500
total for SDLA conference ($2K) and Thinkingahead-library leadership
conference (1500) (within b=
udget)
+ will also have interview/moving costs for open L1 positions -maximum am=
t to
pay out =3D $3200 * 3 =3D $9600; Total =3D 13,100 |
| 4270A |
Education Fund |
5,000 |
|
=
5,000 |
0% |
|
|
anticipate funds remai=
ning - due
to eliminating Kroc Fund and support from Friends of Library - will retain
amount for 2007 with elimination of Kroc |
| 4270
Total Travel/Training |
$17,000 |
$7,433 |
$9,567 |
44% |
0 |
-8,200 |
|
| 4281 |
Telephone |
=
16,500 |
8,826 |
7,674 |
53% |
<=
/td>
|
| =
|
| 4282 |
Natural Gas |
13,500 |
15,514 |
-2,014 |
115% |
|
-3,000 |
natural gas prices inc=
reases;
hoping for supplemental appropriation from city in fall; no guarantee -
estimating an additional $3K in overexpenditure by EOY (7/06) |
| 4283 |
Electricity |
55,000 |
28,866 |
26,134 |
52% |
|
|
expect to zero this li=
ne item |
| 4280
Total Utilities |
$85,000 |
$53,206 |
$31,794 |
63% |
0 |
-3,000 |
|
| 4292 |
Dues |
1=
,500 |
=
884 |
617 |
59% |
<=
/td>
|
| expect=
to zero
this line item |
| 4294A |
Adult Programming
Materials |
1,500 |
1,067 |
433 |
71% |
|
|
total for 4294A-D =3D =
15,275; have
$11,427 remaining (8/06) - expect to zero this line item |
| 4294B |
Youth Programming Materials |
3,000 |
2,106 |
894 |
70% |
|
|
expect to zero this li=
ne item |
| 4294C |
Other Programming |
1,500 |
|
=
1,500 |
0% |
|
|
expect to zero this li=
ne item |
| 4294D |
Other Miscellaneous |
9,275 |
675 |
8,600 |
7% |
5,000 |
|
anticipate funds remaining |
| 4295 |
Computers and Software |
75,000 |
51,679 |
23,321 |
69% |
|
-2,750 |
hand held scanner and =
support
software for Circ (1-1500); 5 barcode scanners (1250) |
| |
|
|
|
|
|
|
|
| 4296 |
Office Equipment/Furniture |
19,556 |
10,800 |
8,756 |
55% |
|
|
|
| 4290
Other Current Expenses |
$111,331 |
$67,211 |
$44,120 |
60% |
5,000 |
-2,750 |
|
| 4320 |
Buidling and Structures |
20,000 |
0 |
20,000 |
0% |
20,000 |
|
$20K for acoustic reme=
diation
project supplemented from 2005 budget (not calculat=
ed
into totals) |
| 4320
Building and Structures |
$20=
,000 |
$0 |
$20,000 |
0% |
20,000 |
20,000 |
|
| 4341 |
General Materials |
165,000 |
170,423 |
-5,423 |
103% |
<=
/td>
|
| total =
for
4241-44 =3D 329,472; have 128,546 remaining (8/06) expect to zero materia=
ls
budget |
| 4342 |
Ref. Books/SO/Databases |
45,663 |
30,503 |
15,160 |
67% |
|
|
expect to zero materia=
ls budget |
| 4343 |
Youth Materials |
98,000 |
0 |
98,000 |
0% |
|
|
expect to zero materia=
ls budget |
| 4344 |
Periodicals |
20,809 |
0 |
20,809 |
0% |
|
|
expect to zero materia=
ls budget |
| 4340 |
Sub Total |
$329,472 |
$200,926 |
$128,546 |
61% |
0 |
0 |
|
| 4350B |
Equipment |
0 |
0 |
0 |
0% |
|
|
|
| 4350 |
Sub Total |
0 <=
/td>
| 0 |
0 |
0% |
|
|
|
| 4300
Total Capital Outlay |
$3=
29,472 |
$200=
,926 |
$128,546 |
61% |
0 |
0 |
|
|
|
|
|
|
|
|
|
0 |
|
116,571 |
-95,072 |
Totals DO NOT include =
$20K for
acoustics project supplemented from 2005 budget |
|
GRAND TOTAL |
$2,516,=
325 |
$1,=
528,074 |
$988,251 |
61% |
|
21,499 |
TOTAL REMAINING AT EN=
D OF YEAR |
|
|
|
|
|
|
|
|
Operational costs: |
$715,079
| $471,856
| |
66% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
------=_NextPart_01C6D33A.9DDBA7E0
Content-Location: file:///C:/F4FCBE36/EOY.prioritization.1131.9.8.06_files/sheet002.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
| Priority
Order of Projects - Facilities and Services |
|
|
|
|
|
| Priorities
are coded in order of importance as 1, 2 or 3. Items coded 1 are anticipated wi=
thin
30 days beginning 9-5-06. I=
tems
coded 2 and 3 are anticipated within 60 and 90 days respectively. |
|
|
|
|
| Priori=
tized
Projects |
updated 9/8/06 |
|
| Pr=
iority |
Line Item |
Name
| Descr=
iption |
Amount |
Comme=
nts |
|
| 1 |
4252
| Repair
Structures |
new
windshield facilities van |
$200 |
|
|
| 1 |
4252
| Repair
Structures |
insulate
NS office |
$500 |
|
|
| 1 |
4295
| Computer/Software |
5 new barcode scanners - |
$1,250 |
|
|
| 1 |
4252
| Repair
Structures |
Paint
front entrance green arches |
$2,550 |
work
began 9/8/06 |
|
| 1 |
4252
| Repair
Structures |
paint
for business office |
$1,000 |
|
|
| 1 |
4252
| Repair
Structures |
paint
by back entrance |
$400 |
|
|
| 2 |
4252
| Repair
Structures |
new
sidewalks |
$8,000 |
Partial
funding; to be combined with CIP for replacement of unsafe sidewalks. Total cost, $18-$20,000 |
|
| 3 |
4252
| Repair
Structures |
light
replacement main area high ceiling |
$1,500 |
|
|
| 3 |
4295
| Computer/Software |
hand
held scanner and support software |
$1,500 |
Service
point equipment |
|
| &nb=
sp; |
|
=
|
Subto=
tal
prioritized projects |
$16,900 |
=
; |
|
| |
|
Total tur=
ned back to
the city after prioritized projects |
$59,040 |
.023% of the overall =
City
Budget |
|
|
|
|
|
|
|
|
| Non-Pr=
ioritized
Projects |
|
|
| Pr=
iority |
Line Item |
Name
| Descr=
iption |
Amount |
Comme=
nts |
|
| Order to be determined |
4252
| Repair
Structures |
upgrade
security cameras |
$12,000 |
Locations: East side of building covering n=
ew
chiller area and rear entrance.
West side of building and alley area. East of front entrance area. (Currently we do not have camera=
s in
any of these locations and have a need for them.) |
|
| Already budgeted in Board Funds |
4252
| Repair
Structures |
new
signage for inside the library |
$0 |
Internal
signage for building has been moved to Board Funds budget and has been
estimated at $3500.
| |
| Order to be determined |
4252
| Repair
Structures |
outside
storage shed |
$1,200 |
Storage
shed needed to store gas and oils including lawn mower, weed eater, press=
ure
washer and other mechanical equipment.&n=
bsp;
Currently these items are being stored in the garage or the main v=
alve
room. Per the Fire departme=
nt, we
are not allowed to have explosive materials stored in the main valve
area. The garage is a work =
area
for Friends of the Library and a storage area for many library items and
shouldn't have gas and oil stored in it. |
|
| Mo=
re info
needed |
4253
| Repair
Equipment |
replace
transformer in facilities office |
$3,000 |
costs
pending to move transformer versus replace |
|
| Order to be determined |
4252
| Repair
Structures |
fix
snow/ice problem on roof ($5-8) |
$8,000 |
The
new design will be a grid or bar system that will hold the ice on the roof
until it melts through the gutter system. Currently there are cones on the=
roof
that are to hold the ice as well, but they are falling off and no longer
holding it, causing dangerously large chunks of ice to fall from the
roof. |
|
| &n=
bsp; |
|
=
|
Subto=
tal
non-prioritized projects |
$24,200 |
=
|
|
| |
|
|
GRAND TOTAL all proje=
cts |
$41,100 |
|
|
| |
|
Total tur=
ned back to
the city after all projects |
$29,840 |
.012% of the overall =
City
Budget |
|
|
|
|
|
|
|
|
|
|
|
|
------=_NextPart_01C6D33A.9DDBA7E0
Content-Location: file:///C:/F4FCBE36/EOY.prioritization.1131.9.8.06_files/filelist.xml
Content-Transfer-Encoding: quoted-printable
Content-Type: text/xml; charset="utf-8"