| 2005-2006 City Budget Comparison |
|
| last updated
6/7/06 |
|
|
| |
|
Budget 2005 |
Actual 2005 Expenditures |
Variance $$ |
Variance % |
Comments |
Actual 2005 Expenditures |
Budget 2006 |
Variance $$ |
Variance % |
Comments |
| Line Item |
Dues |
| 4110 |
Salary/Wages |
1,241,881 |
1,235,902
|
5979.15 |
0% |
|
1,235,902
|
1,302,033 |
66,131.15 |
5% |
|
| 4111 |
Overtime Wages |
2,000 |
3,694 |
-1693.98 |
85% |
|
3,694 |
2,080 |
-1,613.98 |
-44% |
|
| 4118 |
Temporary Wages |
26,199 |
16,909 |
9289.98 |
-35% |
It has been determined that the
percentage remaining in the budget is partially related to the City putting
in temporary wages when funding is designated from the Board Funds. |
16,909 |
27,247 |
10,337.98 |
61% |
Board funds will supplement this
line item. |
| 4100
Total Salary and Wages |
$1,270,080 |
$1,256,505 |
$13,575 |
-1% |
|
$1,256,505 |
$1,331,360 |
$74,855.15 |
6% |
|
| 4120 |
Social Security - 25.7% |
75,617 |
75,712 |
-94.81 |
0% |
|
75,712 |
82,544 |
6,832.19 |
9% |
|
| 4121 |
Medicare - 6% |
17,685 |
17,707 |
-21.93 |
0% |
|
17,707 |
19,305 |
1,598.07 |
9% |
|
| 4130 |
Retirement - 24.3% |
71,486 |
82,047 |
-10560.79 |
15% |
Additional costs were due to
retirement. |
82,047 |
78,247 |
-3,799.79 |
-5% |
2006 doesn’t include costs for
retirement but 2007 will. This amount
should be around $3500 for 2006 |
| 4131 |
Section 125 Administration - .27% |
840 |
785 |
55.00 |
-7% |
|
785 |
875 |
90.00 |
11% |
|
| 4140 |
Workers' Compensation - .32% |
1,000 |
1,120 |
-120.00 |
12% |
|
1,120 |
1,040 |
-80.00 |
-7% |
|
| 4150 |
Group Health Insurance - 40.6% |
125,106 |
122,864 |
2242.50 |
-2% |
|
122,864 |
130,463 |
7,599.50 |
6% |
|
| 4155 |
Group Life Insurance - .52% |
1,620 |
1,719 |
-98.68 |
6% |
|
1,719 |
1,685 |
-33.68 |
-2% |
|
| 4160 |
Work Study |
7,149 |
0 |
7149.00 |
-100% |
|
0 |
|
0.00 |
0% |
|
| 4170 |
Unemployment Insurance - 2.31% |
|
|
|
|
|
7,435 |
7,435.00 |
0% |
|
| 4110
Total Benefits |
$300,503.00 |
$301,952.71 |
-$1,449.71 |
0% |
|
$301,953 |
$321,594 |
$19,641.29 |
7% |
|
| 4211 |
General/Auto Liability |
6,050 |
6,050 |
|
0% |
|
6,050 |
6,832 |
782.00 |
13% |
|
| 4212 |
Boiler Coverage |
850 |
1,400 |
-550.00 |
65% |
|
1,400 |
1,300 |
-100.00 |
-7% |
|
| 4213 |
Fire/Ext Coverage |
13,221 |
16,260 |
-3039.18 |
23% |
|
16,260 |
15,100 |
-1,160.18 |
-7% |
|
| 4214 |
Other Insurance |
50 |
1,610 |
-1560.08 |
3120% |
City was charged an additional
fee for bond insurance in 2005 - Library's portion was $1500 |
1,610 |
160 |
-1,450.08 |
-90% |
Amt already charged for 2006 -
$5.00 |
| 4210
Total Insurances |
$20,171.00 |
$25,320.26 |
-$5,149.26 |
26% |
|
$25,320 |
$23,392 |
-$1,928.26 |
-8% |
|
| 4223 |
Consultant Services |
3,500 |
1,100 |
2400.00 |
-69% |
|
1,100 |
3,500 |
2,400.00 |
218% |
|
| 4225A |
SDLN |
92,185 |
|
92184.90 |
-100% |
|
|
71,933 |
71,933.00 |
0% |
|
| 4225B |
Minitex/OCLC |
|
|
|
|
|
10,309 |
10,309.00 |
0% |
|
| 4225C |
Maintenance Services |
|
|
|
|
|
6,807 |
6,807.00 |
0% |
|
| 4225D |
Other Services |
|
112,568 |
-112567.85 |
0% |
|
112,568 |
3,000 |
-109,567.85 |
-97% |
|
| 4225E |
Programming Services |
|
|
|
|
|
4,500 |
4,500.00 |
0% |
|
| 4220
Total Professional Services/Fees |
$95,684.90 |
$113,667.85 |
-$17,982.95 |
19% |
|
$113,668 |
$100,049 |
-$13,618.85 |
-12% |
|
| 4226 |
Service Other Departments |
13,000 |
12,996 |
4.00 |
0% |
|
12,996 |
13,520 |
524.00 |
4% |
|
| 4226
Total Interdepartmental Charges |
$13,000.00 |
$12,996.00 |
$4.00 |
0% |
|
$12,996 |
$13,520 |
$524.00 |
4% |
|
| 4230 |
Publishing |
750 |
1,476 |
-725.64 |
97% |
|
1,476 |
750 |
-725.64 |
-49% |
|
| 4230
Total Publications |
$750.00 |
$1,475.64 |
-$725.64 |
97% |
|
$1,476 |
$750 |
-$725.64 |
-49% |
|
| 4243 |
Machinery Rental |
|
|
|
|
|
|
|
0.00 |
0% |
|
| 4244 |
Lease/Purchases |
34,500 |
27,019 |
7480.77 |
-22% |
Contracts/Leases projected
$25,488 |
27,019 |
18,369 |
-8,650.23 |
-32% |
Overspent - final Johnson
Controls payment budgeted at $6K and actual cost was $12K - Some invoices for
copier maintenance were improperly paid out of 4244 instead of 4253A
totalling about $700. |
| 4246 |
Parking |
5,400 |
5,211 |
189.00 |
-4% |
|
5,211 |
5,400 |
189.00 |
4% |
|
| 4240
Total Rentals |
$39,900.00 |
$32,230.23 |
$7,669.77 |
-19% |
|
$32,230 |
$23,769 |
-$8,461.23 |
-26% |
|
| 4252 |
Repair Structures |
20,000 |
47,274 |
-27273.90 |
136% |
|
47,274 |
59,900 |
12,626.10 |
27% |
|
| 4253A |
Repair Equipment |
43,082 |
34,489 |
-8287.23 |
19% |
3M Detection System and Service
Contracts were budgeted in capital improvements line item. Budgeted $4,500 and actual cost was $20,511
- due to replacement of security gates - additionally, Johnson Controls was
overspent by $2,400 due to air handler replacement |
52,493 |
24,000 |
-13,493.11 |
-126% |
Amount is off for carpet
replacement $39,900 from 2005 encumbrance. |
| 4253C |
Johnson Controls |
|
16,880 |
|
|
|
|
15,000 |
15,000.00 |
0% |
|
| 4255 |
Repair Water/Sewer |
1,000 |
380 |
620.49 |
-62% |
|
380 |
1,000 |
620.49 |
163% |
|
| 4250 Total
Repair/Maintenance |
64,082 |
$99,023 |
-34940.64 |
55% |
|
$100,147 |
$99,900 |
-246.52 |
0% |
|
| 4261A |
Office Supplies/Library Cards |
61,910 |
22,526 |
39383.80 |
-64% |
Didn't order library cards as
anticipated. Overspent county budget
for office supplies by $1700. Books
and A/V were originally being taken out of materials instead of office supplies. |
22,526 |
11,280 |
30,661.80 |
36% |
Total budgeted for
4261A-D 2006 = $53,188. |
| 4261B |
Printing |
|
|
|
|
|
5,835 |
5,835.00 |
0% |
|
| 4261C |
Books/AV Processing |
|
|
|
|
|
22,573 |
22,573.00 |
0% |
|
| 4261D |
Postage |
|
|
|
|
|
13,500 |
13,500.00 |
0% |
|
| 4262 |
Gasoline, Oil, Fuel |
300 |
58 |
241.85 |
-81% |
|
58 |
500 |
441.85 |
760% |
|
| 4263 |
Clothing, Food |
0 |
130 |
-130.00 |
0% |
|
130 |
|
-130.00 |
-100% |
|
| 4264 |
Janitorial/Chemical |
4,500 |
9,905 |
-5404.93 |
120% |
|
9,905 |
2,250 |
-7,654.93 |
-77% |
|
| 4264A |
Building Supplies |
|
1,069 |
-1068.74 |
0% |
|
1,069 |
2,250 |
1,181.26 |
111% |
|
| 4265 |
Minor Tools |
1,000 |
|
1000.00 |
-100% |
|
|
1,000 |
1,000.00 |
0% |
|
| 4260
Total Supplies/Materials |
$67,710.00 |
$33,688.02 |
$34,021.98 |
-50% |
|
$33,688 |
$59,188 |
$25,499.98 |
76% |
|
| 4270 |
Travel/Training |
12,000 |
5,885 |
6114.84 |
-51% |
|
5,885 |
12,000 |
6,114.84 |
104% |
|
| 4270A |
Education Fund |
|
|
|
|
|
5,000 |
5,000.00 |
0% |
|
| 4270
Total Travel/Training |
$12,000.00 |
$5,885.16 |
$6,114.84 |
-51% |
|
$5,885 |
$17,000 |
$11,114.84 |
189% |
|
| 4281 |
Telephone |
9,500 |
17,242 |
-7741.53 |
81% |
|
17,242 |
16,500 |
-741.53 |
-4% |
|
| 4282 |
Natural Gas |
10,600 |
18,806 |
-8206.07 |
77% |
|
18,806 |
13,500 |
-5,306.07 |
-28% |
|
| 4283 |
Electricity |
55,000 |
51,657 |
3342.77 |
-6% |
|
51,657 |
55,000 |
3,342.77 |
6% |
|
| 4280
Total Utilities |
$75,100.00 |
$87,704.83 |
-$12,604.83 |
17% |
|
$87,705 |
$85,000 |
-$2,704.83 |
-3% |
|
| 4292 |
Dues |
2,200 |
972 |
1228.07 |
-56% |
This was overbudgeted and future
costs are being adjusted. |
972 |
1,500 |
528.07 |
54% |
Amounts
will vary slightly from year to year as we are not sure how many new staff
members will join SDLA, etc. But
consistenly should be about $1000 annually for memberships. Slight variance for memberships we don't
anticipate that may come up through |
| 4294A |
Adult Programming
Materials |
|
|
|
|
|
1,500 |
1,500.00 |
0% |
|
| 4294B |
Youth Programming Materials |
|
|
|
|
|
3,000 |
3,000.00 |
0% |
|
| 4294C |
Other Programming |
|
|
|
|
|
1,500 |
1,500.00 |
0% |
|
| 4294D |
Other Miscellaneous |
15,275 |
9,222 |
6053.14 |
-40% |
|
9,222 |
9,275 |
53.14 |
1% |
|
| 4295 |
Computers and Software |
71,500 |
58,978 |
12521.67 |
-18% |
During
2005, other line items (4261E, 4225A, etc.) were being merged into 4295, so
not all expenses are shown in this line item. |
58,978 |
75,000 |
16,021.67 |
27% |
Seem
to be on track for this year with replacing machines and software as outlined
on replacement schedule. |
| 4296 |
Office Equipment/Furniture |
11,435 |
6,443 |
4992.17 |
-44% |
|
6,443 |
19,556 |
13,113.17 |
204% |
|
| 4290
Other Current Expenses |
$100,410.00 |
$75,614.95 |
$24,795.05 |
-25% |
|
$75,615 |
$111,331 |
$35,716.05 |
47% |
|
| 4341 |
General Materials |
146,500 |
187,921 |
-41421.35 |
28% |
2005
was a trial year of spending on a 12-month cycle. This was unsuccessful because many invoices
were not available by the close of the year. Therefore these invoices for
materials and databases were paid in 2006.
Additionally, during 2005, the BO began paying all materials out of
4341 until expended, then 4342, etc.
This is a way of viewing the materials budget as a whole and not separated
by dept which is handled in the Acquistion system. It would be a duplication of effort and
inefficient to split individual line items by type. |
187,921 |
165,000 |
-22,921.35 |
-12% |
On
track for this year. We are now
utilizing a 10-month spend plan which will allow all invoices to be received
and paid in the current budget year. |
| 4342 |
Ref. Books/SO/Databases |
40,000 |
19,651 |
20348.94 |
-51% |
19,651 |
45,663 |
26,011.94 |
132% |
| 4343 |
Youth Materials |
98,136 |
48,930 |
49205.78 |
-50% |
48,930 |
98,000 |
49,069.78 |
100% |
| 4344 |
Periodicals |
28,000 |
2,628 |
25372.13 |
-91% |
2,628 |
20,809 |
18,181.13 |
692% |
| 4340 |
Sub Total |
|
|
|
|
|
|
$329,472 |
329,472.00 |
0% |
|
| 4350B |
Equipment |
0 |
|
|
|
|
|
0 |
0.00 |
0% |
|
| 4350 |
Sub Total |
|
|
|
|
|
|
0 |
0.00 |
0% |
|
| 4300
Total Capital Outlay |
$312,636.00 |
$259,130.50 |
$53,505.50 |
-17% |
|
$259,131 |
$329,472 |
$70,341.50 |
27% |
|
| 4530 |
Refund or Reimbursement |
0 |
$366 |
-365.51 |
0% |
|
$366 |
|
-365.51 |
-100% |
|
|
|
|
|
|
|
|
|
|
|
|
|
GRAND TOTAL |
2,372,027 |
2,305,559 |
66467.75 |
-3% |
|
2,306,683 |
$2,516,325 |
209,641.97 |
9% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|