Rapid City Public Library Budget Comparison Report
2001-2002  Final Projected Variance $ Projected Variance $ Projected Variance $ Comments
Line Item Object Description Previous 1999 2000 2001 2001 Actual Variance % Diff. 2003 2003 2004 2005 2006 % 2007 % 2008 % If over 5% increase, include justification
4110 Salary/Wages 605,515 706,524 752,015 750,440.00 #REF! #REF! 1,078,987 1,052,705 1,132,696 1,191,431 1,281,003 8% 89,572 1,332,243 4% 51,240 1,396,224 5% 63,981 Calculated at a 5% salary increase per year; plus .5 Circ staffing ($13,000) and .5 YS staffing ($17,000) = $30,000 1 FTE
4111 Overtime Wages 4,000 3,000 4,000 1,500.00 #REF! #REF! 1,500 5,215 2,000 2,000 2,000 0% 0 (2,000) 0
4118 Temporary Wages 59,854 53,787 123,448 130,997.00 #REF! #REF! 28,736 35,825 0 26,199 27,509 5% 1,310 28,337 3% 828 29,470 4% 1,133
4100 Total Salary and Wages 669,369 ######## ######## ######## #REF! #REF! ######## ######## ######## $1,219,630 $1,310,512 7% $90,882 ######## 4% 50,068 ######## 5% 65,114
4120 Social Security 41,563 47,140 50,621 53,598.00 #REF! #REF! 68,772 66,083 70,351 75,617 81,252 7% 5,635 -100% (81,252) #DIV/0! 0
4121 Medicare 9,720 11,004 11,839 12,541.00 #REF! #REF! 16,084 15,455 16,453 17,685 19,002 7% 1,317 -100% (19,002) #DIV/0! 0
4130 Retirement 30,591 35,324 36,740 37,330.00 #REF! #REF! 64,739 58,263 67,962 71,486 76,860 8% 5,374 -100% (76,860) #DIV/0! 0
4131 Section 125 Administration 195 195 203 214.51 #REF! #REF! 250 319 250 840 1,000 19% 160 -100% (1,000) #DIV/0! 0
4140 Workers' Compensation 4,320 1,728 1,901 1,539.29 #REF! #REF! 1,350 457 3,398 1,000 1,000 0% 0 -100% (1,000) #DIV/0! 0
4150 Group Health Insurance 64,192 66,894 55,120 64,908.00 #REF! #REF! 87,307 90,447 146,863 125,106 134,505 8% 9,399 -100% (134,505) #DIV/0! 0
4155 Group Life Insurance 870 939 977 1,318.06 #REF! #REF! 1,618 1,572 1,200 1,620 1,800 11% 180 -100% (1,800) #DIV/0! 0
4160 Work Study 1,000 3,000 1,500 408.66 #REF! #REF! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0
4170 Unemployment Insurance 0 0 3,591 3,591.00 #REF! #REF! 4,437 6,796 7,149 7,686 8% 537 -100% (7,686) #DIV/0! 0
4110 Total Benefits 152,451 ######## ######## ######## #REF! #REF! $244,557 $232,596 $313,273 $300,503 $323,105 8% $22,602 $336,029 4% 12,924 $352,143 5% 16,114  Calculated at a 5% increase per year; plus Circ and YS staffing
4211 General/Auto Liability 4,150 3,150 500 411.00 #REF! #REF! 625 4,643 2,075 6,050 4,500 -26% (1,550) -100% (4,500) #DIV/0! 0
4212 Boiler Coverage 100 100 250 798.00 #REF! #REF! 950 840 1,500 850 1,300 53% 450 -100% (1,300) #DIV/0! 0
4213 Fire/Ext Coverage 3,350 3,350 2,000 1,835.00 #REF! #REF! 3,125 10,170 3,360 13,221 15,100 14% 1,879 -100% (15,100) #DIV/0! 0
4214 Other Insurance 10 10 10 763.17 #REF! #REF! 975 45 100 50 160 220% 110 -100% (160) #DIV/0! 0 City Finance; Liability, Employee; 
4210 Total Insurances $7,610.00 $6,610.00 $2,760.00 $3,807.17 #REF! #REF! $5,675 $15,699 $7,035 $20,171 $21,060 4% $889 $0 -100% (21,060) $0 #DIV/0! 0 Final figures from Finance
4223 Consultant Services 0 0 2,000 3,560.48 #REF! #REF! 3,500 8,205 3,500 3,500 5,500 57% 2,000 -100% (5,500) #DIV/0! 0 marketing consultant - one-time cost for 2006, $2,000
4225A SDLN 46,700 52,510 54,085 49,545.50 #REF! #REF! 65,000 58,433 58,612 65,141 66,996 3% 1,855 73,695 10% 6,699 81,065 10% 7,370
4225B Minitex/OCLC 28,000 24,000 15,000 7,371.97 #REF! #REF! 15,000 14,110 15,000 14,504 27,280 88% 12,776 29,275 7% 1,995 31,535 8% 2,260 2006 increased by $10,680 due to direct export costs from Minitex for OCLC records
4225C Maintenance Services 6,000 7,500 7,725 9,174.00 #REF! #REF! 2,000 2,000 6,807 3,742 -45% (3,065) -100% (3,742) #DIV/0! 0
4225D Other Services 158 1,000 2,800 4,667.25 #REF! #REF! 2,000 12,451 2,000 3,000 3,000 0% 0 -100% (3,000) #DIV/0! 0 Contracted services, Smart Center rental, etc.
4225E Programming Services 0 0 1,500 1,575.24 #REF! #REF! 0 2,000 4,500 125% 2,500 6,000 33% 1,500 6,000 0% 0 This item is being increased to reflect increased use of outside program presenters, including author presentations and character programs.
4220 Total Professional Services/Fees 80,858 ######## ######## ######## #REF! #REF! $87,500 $93,199 $81,112 $94,952 $111,018 17% $16,066 $108,970 -2% (2,048) $118,600 9% 9,630
4226 Service Other Departments 8,185 8,500 10,445 10,445.00 #REF! #REF! 11,781 11,796 12,370 13,000 13,650 5% 650 13,650 0% 0 13,650 0% 0
4226 Total Interdepartmental Charges 8,185 $8,500.00 ######## ######## #REF! #REF! $11,781 ######## $12,370 $13,000 $13,650 5% $650 $13,650 0% 0 $13,650 0% 0 Final figures from Finance
4230 Publishing 2,900 3,000 3,100 2,713.50 #REF! #REF! 500 1,562 500 750 750 0% 0 -100% (750) #DIV/0! 0
4230 Total Publications 2,900 $3,000.00 $3,100.00 $2,713.50 #REF! #REF! $500 $1,561.97 $500 $750 $750 0% $0 $0 -100% (750) $0 #DIV/0! 0
4243 Machinery Rental 1,200 1,215 1,250 0.00 #REF! #REF! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0
4244 Lease/Purchases 11,900 11,900 15,750 18,509.91 #REF! #REF! 20,912 25,541 22,500 34,500 18,369 -47% (16,131) 18,369 0% 0 18,369 0% 0 Color copy was leased instead of purchased 
4246 Parking #REF! 4,536 5,184 5,200 5,400 5,600 4% 200 5,400 -4% (200) 5,400 0% 0 Increased parking costs with new lease
4240 Total Rentals 13,100 ######## ######## ######## #REF! #REF! $25,448 $30,725 $27,700 $39,900 $23,969 -40% ($15,931) $23,769 -1% (200) $23,769 0% 0
4252 Repair Structures 15,000 15,000 15,000 13,512.92 #REF! #REF! 10,000 34,370 15,000 20,000 74,000 270% 54,000 36,280 -51% (37,720) 48,500 34% 12,220 Update HVAC - Phase II carpet - update ceilings -- all are one-time costs; also include the YS office remodel
4253A Repair Equipment 13,745 9,000 13,000 13,104.74 #REF! #REF! 17,450 16,940 20,500 23,000 37,500 63% 14,500 41,500 11% 4,000 41,500 0% 0 Equipment maintenance and service agreements
4253C Johnson Controls 10,500.00 11,742.00 (1,242.00) -12% 11,742 11,742.00 20,082 15,000 -25% (5,082) 15,000 0% 0 15,000 0% 0
4255 Repair Water/Sewer 700 850 500 818.50 #REF! #REF! 1,000 453 1,000 1,000 1,000 0% 0 1,000 0% 0 1,000 0% 0
4250 Total Repair/Maintenance 39,945 ######## ######## ######## #REF! #REF! $28,450 $63,505 $48,242 $64,082 $127,500 99% $63,418 $93,780 -26% (33,720) $106,000 13% 12,220
4261A Office Supplies/Library Cards 5,050 5,000 5,000 5,577.31 #REF! #REF! 6,000 6,994 9,967 11,000 11,500 5% 500 -100% (11,500) #DIV/0! 0 Library Card increases
4261B Printing 3,000 4,000 4,120 3,620.13 #REF! #REF! 4,500 5,704 8,000 8,000 5,835 -27% (2,165) 6,010 3% 175 6,190 3% 180
4261C Books/AV Processing 12,200 12,200 7,000 8,068.02 #REF! #REF! 13,000 15,537 23,000 29,710 22,573 -24% (7,137) 22,573 0% 0 22,573 0% 0
4261D Postage 18,000 18,000 17,000 16,661.31 #REF! #REF! 18,000 21,588 11,600 13,200 13,500 2% 300 20,000 48% 6,500 20,000 0% 0 Per month increases: Postage $1,000, Bulk mailing $150; Courier ILL Services $1,000 annual 
4262 Gasoline, Oil, Fuel 300 500 67% 200 -100% (500) #DIV/0! 0 Increased gasoline prices; fuel for city car, lawn mower & misc equip.
4264 Janitorial/Chemical 4,200 4,500 4,635 4,477.17 #REF! #REF! 7,425 6,700 7,000 4,500 7,500 67% 3,000 4,500 -40% (3,000) 4,500 0% 0 Snow removal equipment
4265 Minor Tools 150 150 75 0.00 #REF! #REF! 0 500 1,000 1,000 0% 0 1,000 0% 0 1,000 0% 0
4260 Total Supplies/Materials 42,600 ######## ######## ######## #REF! #REF! $48,925 $56,522 $60,067 $67,710 $62,408 -8% ($5,302) $54,083 -13% (8,325) $54,263 0% 180
4270 Travel/Training 8,000 9,000 9,000 15,249.34 #REF! #REF! 12,000 12,608 12,000 12,000 17,000 42% 5,000 22,200 31% 5,200 22,200 0% 0 Educational Policy - $5000 Friends + $5,000 City 
4270 Total Travel/Training 8,000 $9,000.00 $9,000.00 ######## #REF! #REF! $12,000 $12,608 $12,000 $12,000 $17,000 42% $5,000 $22,200 31% 5,200 $22,200 0% 0
4281 Telephone 7,500 8,500 7,700 8,478.67 #REF! #REF! 12,000 8,492 12,000 9,500 16,500 74% 7,000 -100% (16,500) #DIV/0! 0 FiberCom internet service
4282 Natural Gas 7,000 7,000 6,500 9,345.65 #REF! #REF! 13,375 9,747 13,375 10,600 13,500 27% 2,900 -100% (13,500) #DIV/0! 0 Mimimal changes
4283 Electricity 30,783 30,783 28,355 30,146.35 #REF! #REF! 49,621 56,773 49,621 55,000 55,000 0% 0 -100% (55,000) #DIV/0! 0 No increases forseen at this time
4280 Total Utilities 45,283 ######## ######## ######## #REF! #REF! $74,996 $75,012 $74,996 $75,100 $85,000 13% $9,900 $0 -100% (85,000) $0 #DIV/0! 0
4292 Dues 850 900 925 1,333.50 #REF! #REF! 1,400 2,130 1,400 2,200 2,500 14% 300 -100% (2,500) #DIV/0! 0 Increased costs of professional memberships.
4294A General Adult Programming Mat. 1,500 1,500 2,500 1,589.84 #REF! #REF! 2,300 4,009 2,300 3,000 1,000 -67% (2,000) 1,000 0% 0 1,000 0% 0 This reduction is to allow the creation of 4294C
4294B Youth Programming Mat. 1,500 1,500 4,500 3,623.62 #REF! #REF! 4,500 4,487 4,000 3,000 3,000 0% 0 3,000 0% 0 3,000 0% 0
4294C Other Programming 0 1,000 100% 1,000 2,000 100% 1,000 3,000 50% 1,000 This is a new line item to allow differentiation between Adult programming put together by reference, and other miscellaneous programming such as OBOC.
4294D Other Miscellaneous 3,625 4,000 8,900 14,472.60 #REF! #REF! 9,275 52,007 9,275 9,275 9,553 3% 278 5,305 -44% (4,248) 5,465 3% 160 3%  inflationary costs
4295 Computers and Software 71,500 98,000 37% 26,500 123,000 26% 25,000 146,500 19% 23,500 Self Service and RFID upgrade, in addition to equipment replacement schedule
4295 Office Equipment/Furniture 11,435 21,460 88% 10,025 23,460 9% 2,000 25,460 9% 2,000 5 and 10 year replacement cycle
4290 Other Current Expenses 79,916 ######## ######## ######## #REF! #REF! $17,475 $62,633 $16,975 $100,410 $136,513 36% $36,103 $157,765 16% 21,252 $184,425 17% 26,660
4341 General Materials $120,266 #REF! 146,500 #DIV/0! 0 #DIV/0! 0
4342 Ref. Books/SO/Databases $31,018 #REF! 40,000 #DIV/0! 0 #DIV/0! 0
4343 Youth Materials $98,137 #REF! 98,136 #DIV/0! 0 #DIV/0! 0
4344 Periodicals $17,631 #REF! 28,000 $20,998 (7,002) $22,118 5% 1,120 $22,848 3% 730
4340 Sub Total  $0 $0.00 $0.00 #REF! #REF! #REF! $267,052 #REF! $312,636 $327,330 5% $14,694 $342,715 5% 15,385 $358,823 5% 16,108 National average for city population served
4350A Furniture 0 5,769 3,050 8,964.68 #REF! #REF! 5,000 35,590.00 6,000 0 0 0 0 #DIV/0! 0
4350B Equipment 6,000 53,630 51,900 39,866.87 #REF! #REF! 74,900 6,309.00 70,000 0 5,280 5,280 8,000 2,720 -100% (8,000) Carpet extractor
4350 Sub Total 54,950.00 48,831.55 #REF! #REF! 79,900 $41,899 76,000 0 5,280 $5,280 8,000 2,720 0 -100% (8,000)
4300 Total Capital Outlay 6,000 ######## ######## ######## #REF! #REF! #REF! $308,951 #REF! $312,636 $332,610 6% $19,974 $350,715 5% 18,105 $358,823 2% 8,108
GRAND TOTAL 1,248,426 ######## #REF! #REF! #REF! #REF! #REF! ######## #REF! $2,320,844 $2,565,095 11% $244,251 ######## -2% ($43,554) ######## 5% $138,026
######## Set aside from 2000salaries
Set aside from 2000 Salaries #REF! Total Auxiliary Funds Supplement for  #VALUE! #VALUE!
54,032 Salary/Wages  #VALUE! #VALUE!
13,508 Benefits #VALUE! #VALUE!
25,008 Temp. Pages,LA #VALUE! #VALUE!
######## Total #VALUE! #VALUE!
2,151,153 2,301,734 7.00% 150,581
L/Budgets/City/2005 Comparisons