Laserfiche WebLink
EXHIBIT A: Sample Department Budget Spreadsheet <br /> -'. r�,� Clty�bf�lyCily Fund 46 W�a pbrl{•"' r� � ..;..�:��.. <br /> � � <br /> ��. �"�„ 2d121312Q79-140peratlng Budget �": r y bd� 381 Wip ��t9�atar dh{t� a <br /> ,E�cpen, �r.e�Budgat,,l�"istiflca6o�s;'.SINGCE%CCTIVI?'Y �'f� 'fj . �372 Was a .x� ���� . � <br /> EX�ENDITURES y <br /> Object Descriptionl Actual Year-End 2012-13 2013-74 <br /> Code Justification 2010-11 Estimate % Request % Request % <br /> 41030vertime $32,168 $35,000 9% $46,560 33% $46,560 0% <br /> Required to co�er the cost of holiday shift work pay as stipulated by the MOU with Operating Engineers as calculated. The <br /> .. . . _ . . .. . . .. . . . . .. .. <br /> Holiday Co�erage: 4 operatore '$80.00/hr ` i2 �. � ����. <br /> hr shift * 9 holidays . 34560 '��. 34560 <br /> Sick Leaee Co�erege: $80.00/hr * 120 hours � 9600'. ����� 9600 <br /> � Shoreline Sampling $80.00/hr • 30 hrs I 240Q �� � ���. 2400 <br /> 4212 Communications $1,949 $3,397 � 74% $2,270 -33% $2,340 3% <br /> To pay for cell phones and call charges. Call charges were not budgeted pre�ously. Radio repair and replacement will be paid <br /> ---- ._... . . . . _ _.... _ ... ._.... <br /> Call Charges 2gi.gg'. 250 257.5 265.225 <br /> Cell Phone 2@$75'12months 1586.58 1800 � 1854 1909.62 <br /> Cell Phone Replacement (2 at $100) and <br /> Bluetooth (2 at $60) 8021 320 160 165 <br /> Radio Repair and Replacement 0 1027.4 0 0 <br /> 4220 Other Contractural Services $2,485,064 $2,544,822 2% $2,876,405 13% $3,291,530 74% <br /> For contractural sereices, as listed below: <br /> Annual Wastewater fees to South San <br /> Francisco (9% increase per fiscal year) 220936.69 240820.992 262494.881 2861 i9.421 <br /> Bioassay Testing - One Tme 46129.31 0 0 0 <br /> Drinking Water Filtration Stations (replacing <br /> Alhambra bolttled water from 08/09 and prior) 6846.99 3065.92 300 330 <br /> Miscellaneous Other Services 4000 1000 0 0 <br /> Rat Abatement, costs being paid out of P&EM <br /> going forward 7110.72 8000 0 0 <br /> San Mateo County Hazmat 0 2870 3157'. �.. 3472.7 <br /> SCADA Contractural �� �� 3733 3337.2 3437.316 ��.. 3540.43548 � <br /> . Sludge hauling and disposal tees to RPI . � . ��. ���. <br /> Synagro (contract expires in 11/12; assuming � � <br /> increase of 25°/a beginning Jan 2012) '� <br /> 224458.47 215727.97 � 226514.369 260491.524 <br /> Wastewater fees to the City/County of San . �� ��� � <br /> Francisco ($345,000 bi-monthly in 10/i t with a . <br /> 15% increase each fiscal year) 1977848.61 2070000 2380500 2737575 <br /> 4231 Safety Gear $3,369 $3,292 -2% $4,585 39% $4,420 -4%a <br /> S:\Clients\External�Daly City\ITSvc-Daily City IFAS project 2012 . docx 9 <br /> 081911 <br />