Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
Exhibit MSD 31C - Basis for Stormwater Input Values in Exhibit MSD 18
Please see yellow highlighted numbers on the following 3 tabs for the basis of the values input into the model, as described in question 8 of the Second Discovery Request dated March 19, 2018. ENGINEERING DEPARTMENT REGULATORY STORMWATER STAFF POSITIONS FULL TIME EQUIVALENT (FTE) COSTS Stormwater Fund 5110 5120 OMCI and 5120 DIVISION UNIT 2 cent Regulatory FTE 10 cent O&M FTE Capital FTE Title Midpoint Salary Storm Salary Cost Regulatory ‐ 5110 Non‐ Regulatory ‐ 5120 Capital‐ Spread Capital Project cost account?‐5120 DEC Stormwater 1 0 0 Environmental Specialist 82,550 82,550$ 82,550$ ‐$ ‐$ 1 0 0 Division Inspector 76,750 76,750$ 76,750$ ‐$ ‐$ 2 1 0 Industrial Waste Investigator 58,500 175,500$ 117,000$ 58,500$ ‐$ 1 0 0 Office Associate 42,213 42,213$ 42,213$ ‐$ ‐$ Regulatory Affairs 1 0 0 Civil Engineer 82,550 82,550$ 82,550$ ‐$ ‐$ Emergency Response 0.5 0 0 Industrial Waste Investigator 58,500 29,250$ 29,250$ ‐$ ‐$ Lab 0.5 0 0 Chemist 76,750 38,375$ 38,375$ ‐$ ‐$ 0.5 0 0 Lab Tech 54,450 27,225$ 27,225$ ‐$ ‐$ Pretreatment 0.5 0 0 Industrial Waste Tech 45,783 22,892$ 22,892$ ‐$ ‐$ Subtotal 8 1 0 9 FTE 577,305$ 518,805$ 58,500$ ‐$ Total Planning Planning 0.1 0.2 0.3 Principal Engineer 103,450 31,035$ 10,345$ 20,690$ 31,035$ 0 0.5 0.5 Assistant Engineer 71,500 35,750$ ‐$ 35,750$ 35,750$ 0 0 0.5 Civil Engineer 82,550 ‐$ ‐$ ‐$ 41,275$ 0.4 0.6 1 Senior Civil Engineer 95,750 95,750$ 38,300$ 57,450$ 95,750$ GIS 3.75 0.5 1 Cartographic/CADD Tech Sr 54,610 232,093$ 204,788$ 27,305$ 54,610$ No Dev Rev 1 0 0 Principal Engineer 103,450 103,450$ 103,450$ ‐$ ‐$ 2 0 0 Senior Civil Engineer 95,750 191,500$ 191,500$ ‐$ ‐$ 4.5 0 0 Civil Engineer 82,550 371,475$ 371,475$ ‐$ ‐$ Permits 0.25 0 0 Permit Supervisor 66,700 16,675$ 16,675$ ‐$ ‐$ 2 0 0.5 Office Associate 42,213 84,426$ 84,426$ ‐$ 21,107$ No 1.5 0 0 Office Assistant 39,076 58,614$ 58,614$ ‐$ ‐$ No CIP 0 0 0.4 Senior Civil Engineer 95,750 ‐$ ‐$ ‐$ 38,300$ No 0 0 0 Division Inspector 76,750 ‐$ ‐$ ‐$ ‐$ 0 0 0.6 Graphic Asst./Office Associate 42,213 ‐$ ‐$ ‐$ 25,328$ No Subtotal 15.5 1.8 4.8 22.1 FTE 1,220,768$ 1,079,573$ 141,195$ 343,154$ Total Design Capital Projects 0 0 0.5 Principal Engineer 103,450 ‐$ ‐$ ‐$ 51,725$ 0 0 1.5 Senior Civil Engineer 95,750 ‐$ ‐$ ‐$ 143,625$ Project Design 0 0.5 0.1 Principal Engineer 103,450 51,725$ ‐$ 51,725$ 10,345$ 0 2.6 0.4 Civil Engineer 82,550 214,630$ ‐$ 214,630$ 33,020$ 0 0.5 0 Resident Inspector 62,500 31,250$ ‐$ 31,250$ ‐$ 0 3.5 0 Construction Inspector Sr 54,610 191,135$ ‐$ 191,135$ ‐$ 0 1.3 0.3 Cartographic/CADD Tech Sr 54,610 70,993$ ‐$ 70,993$ 16,383$ 0 0.3 0.2 Specifications Associate 45,783 13,735$ ‐$ 13,735$ 9,157$ No 0 0.7 0 Office Associate 42,213 29,549$ ‐$ 29,549$ ‐$ No ROW/Survey 0 0.2 1.8 ROW Agent 66,700 13,340$ ‐$ 13,340$ 120,060$ 0 0.5 0 Engineering Specialist 82,550 41,275$ ‐$ 41,275$ ‐$ 0 0.5 0.8 Surveyor 66,700 33,350$ ‐$ 33,350$ 53,360$ 0 0.5 0.8 Surveyor Assistant 45,783 22,892$ ‐$ 22,892$ 36,626$ 0 0.5 0.8 Cartographic/CADD Tech Sr 54,610 27,305$ ‐$ 27,305$ 43,688$ 0 0.5 0.8 Section Head 54,450 27,225$ ‐$ 27,225$ 43,560$ Subtotal 0 12.1 8 20.1 FTE 768,404$ ‐$ 768,404$ 561,549$ Total CM Capital 0 0 0 Principal Engineer 103,450 ‐$ ‐$ ‐$ ‐$ 0 0 0.5 Senior Civil Engineer 95,750 ‐$ ‐$ ‐$ 47,875$ 0 0 0.9 Civil Engineer 82,550 ‐$ ‐$ ‐$ 74,295$ 0 0 1.8 Division Inspector 76,750 ‐$ ‐$ ‐$ 138,150$ 0 0 2.7 Resident Inspector 62,500 ‐$ ‐$ ‐$ 168,750$ 0 0 0.5 Cartographic/CADD Tech Sr 54,610 ‐$ ‐$ ‐$ 27,305$ 0 2 7.2 Construction Inspector Sr 54,610 109,220$ ‐$ 109,220$ 393,192$ Admin 0 0 0.3 Admin Support Supv 58,500 ‐$ ‐$ ‐$ 17,550$ No 0 0 1.4 Office Associate 42,213 ‐$ ‐$ ‐$ 59,098$ No 0 0 0 Office Assistant 39,076 ‐$ ‐$ ‐$ ‐$ No Development 0.66 0 0 Construction Supv 88,500 58,410$ 58,410$ ‐$ ‐$ 0.75 0 0 Assistant Engineer 71,500 53,625$ 53,625$ ‐$ ‐$ 0.66 0 0 Division Inspector 76,750 50,655$ 50,655$ ‐$ ‐$ 1.36 0 0 Resident Inspector 62,500 85,000$ 85,000$ ‐$ ‐$ 0.66 0 0 Construction Inspector Sr 54,610 36,043$ 36,043$ ‐$ ‐$ 10 0 1 Const Inspector 49,888 498,880$ 498,880$ ‐$ 49,888$ Subtotal: 14.09 2 16.3 32.39 FTE 891,833$ 782,613$ 109,220$ 976,103$ Total Grand Total: 37.59 16.9 29.1 83.59 FTE 3,458,308$ 45% 20% 35% Direct Labor 2,380,990$ 1,077,319$ 1,880,807$ Overhead 2,946,713$ 1,333,289$ 2,555,076$ Labor + Overhead 5,327,702$ 2,410,608$ 4,435,882$ Interfund Labor 3,904,868$ Charged to Proj Interfund Labor 531,014$ Manual Entry ch Overhead Rate from 2018 Rate Proposal 123.76% Engineering Unsegmented OH Rate 135.85% N:\ACCTBUDGET\Rate Model\FY18 Impervious Rate Proposal\Discovery Requests\March 19 2018\Q8 Analysis supporting inputs 3/29/2018 at 7:53 AM ENGINEERING DEPARTMENT REGULATORY STORMWATER STAFF POSITIONS FULL TIME EQUIVALENT (FTE) COSTS O&M w/IR NEW CIP $30M Revenue, $15M Construction DIVISION UNIT Regulatory FTE Non‐Reg FTE Capital FTE Title Midpoint Salary Storm Salary Cost Regulatory Non‐ Regulatory Capital* Project TC cost account? DEC Stormwater 1 0 0 Environmental Specialist 81,550 81,550$ 81,550$ ‐$ ‐$ 1 0 0 Division Inspector 75,850 75,850$ 75,850$ ‐$ ‐$ 2 1 0 Industrial Waste Investigator 57,800 173,400$ 115,600$ 57,800$ ‐$ 1 0 0 Office Associate 41,711 41,711$ 41,711$ ‐$ ‐$ Regulatory Affairs 1 0 0 Civil Engineer 81,550 81,550$ 81,550$ ‐$ ‐$ Emergency Response 0.5 0 0 Industrial Waste Investigator 57,800 28,900$ 28,900$ ‐$ ‐$ Lab 0.5 0 0 Chemist 75,850 37,925$ 37,925$ ‐$ ‐$ 0.5 0 0 Lab Tech 53,800 26,900$ 26,900$ ‐$ ‐$ Pretreatment 0.5 0 0 Industrial Waste Tech 45,239 22,620$ 22,620$ ‐$ ‐$ Subtotal 8 1 0 9 FTE 570,406$ 512,606$ 57,800$ ‐$ Total Add GSA equal 1 FTE to CIP Planning Planning 0.1 0.2 0.3 Principal Engineer 102,200 30,660$ 10,220$ 20,440$ 30,660$ 0 0.5 1 Assistant Engineer 70,650 35,325$ ‐$ 35,325$ 70,650$ 0.4 0.6 2 Civil Engineer 81,550 81,550$ 32,620$ 48,930$ 163,100$ GIS 3.75 0.5 1 Cartographic/CADD Tech Sr 53,961 229,334$ 202,354$ 26,981$ 53,961$ No Dev Rev 1 0 0 Principal Engineer 102,200 102,200$ 102,200$ ‐$ ‐$ 2 0 0 Senior Civil Engineer 94,600 189,200$ 189,200$ ‐$ ‐$ 4.5 0 0 Civil Engineer 81,550 366,975$ 366,975$ ‐$ ‐$ Permits 0.25 0 0 Permit Supervisor 65,900 16,475$ 16,475$ ‐$ ‐$ 2 0 0.5 Office Associate 41,711 83,422$ 83,422$ ‐$ 20,856$ No 1.5 0 0 Office Assistant 38,618 57,927$ 57,927$ ‐$ ‐$ CIP 0 0 0.4 Senior Civil Engineer 94,600 ‐$ ‐$ ‐$ 37,840$ No 0 0 0 Division Inspector 75,850 ‐$ ‐$ ‐$ ‐$ 0 0 0.6 Graphic Asst./Office Associate 41,711 ‐$ ‐$ ‐$ 25,027$ No Subtotal 15.5 1.8 5.8 23.1 FTE 1,193,068$ 1,061,393$ 131,676$ 402,093$ Total Design Capital Projects 0 0 1 Principal Engineer 102,200 ‐$ ‐$ ‐$ 102,200$ 0 0 4 Civil Engineer 81,550 ‐$ ‐$ ‐$ 326,200$ Project Design 0 0.5 0.4 Principal Engineer 102,200 51,100$ ‐$ 51,100$ 40,880$ 0 2.6 1.8 Civil Engineer 81,550 212,030$ ‐$ 212,030$ 146,790$ 0 0.5 0 Resident Inspector 61,750 30,875$ ‐$ 30,875$ ‐$ 0 3.5 0 Construction Inspector Sr 53,961 188,864$ ‐$ 188,864$ ‐$ 0 1.3 1.1 Cartographic/CADD Tech Sr 53,961 70,149$ ‐$ 70,149$ 59,357$ 0 0.3 0.6 Specifications Associate 45,239 13,572$ ‐$ 13,572$ 27,143$ no 0 0.7 0 Office Associate 41,711 29,198$ ‐$ 29,198$ ‐$ no ROW/Survey 0 0.2 4 ROW Agent 65,900 13,180$ ‐$ 13,180$ 263,600$ 0 0.5 0.6 Engineering Specialist 70,650 35,325$ ‐$ 35,325$ 42,390$ 0 0.5 0.3 Surveyor 65,900 32,950$ ‐$ 32,950$ 19,770$ 0 0.5 1.1 Surveyor Assistant 45,239 22,620$ ‐$ 22,620$ 49,763$ 0 0.5 0.3 Cartographic/CADD Tech Sr 53,961 26,981$ ‐$ 26,981$ 16,188$ 0 0.5 0.3 Section Head 53,800 26,900$ ‐$ 26,900$ 16,140$ Subtotal 0 12.1 15.5 27.6 FTE 753,742$ ‐$ 753,742$ 1,110,422$ Total add 1 Program Manager (overhead) CM Capital 0 0 0 Principal Engineer 102,200 ‐$ ‐$ ‐$ ‐$ 0 0 0 Senior Civil Engineer 94,600 ‐$ ‐$ ‐$ ‐$ 0 0 1 Civil Engineer 81,550 ‐$ ‐$ ‐$ 81,550$ 0 0 3 Division Inspector 75,850 ‐$ ‐$ ‐$ 227,550$ 0 0 3 Resident Inspector 61,750 ‐$ ‐$ ‐$ 185,250$ 0 0 0.5 Cartographic/CADD Tech Sr 53,961 ‐$ ‐$ ‐$ 26,981$ 0 2 11 Const Inspector Sr 53,961 107,922$ ‐$ 107,922$ 593,571$ Admin 0 0 2 Admin Support Supv 57,800 ‐$ ‐$ ‐$ 115,600$ no 0 0 1.5 Office Associate 41,711 ‐$ ‐$ ‐$ 62,567$ no 0 0 0 Office Assistant 38,618 ‐$ ‐$ ‐$ ‐$ no Development 0.66 0 0 Construction Supv 87,750 57,915$ 57,915$ ‐$ ‐$ 0.75 0 0 Assistant Engineer 70,650 52,988$ 52,988$ ‐$ ‐$ 0.66 0 0 Division Inspector 75,850 50,061$ 50,061$ ‐$ ‐$ 1.36 0 0 Resident Inspector 61,750 83,980$ 83,980$ ‐$ ‐$ 0.66 0 0 Const Inspector Sr 53,961 35,614$ 35,614$ ‐$ ‐$ 10 0 1 Const Inspector 49,295 492,950$ 492,950$ ‐$ 49,295$ Subtotal: 14.09 2 23 39.09 FTE 881,430$ 773,508$ 107,922$ 1,342,363$ Total Grand Total: 37.59 16.9 44.3 98.79 FTE 3,398,646$ 38% 17% 45% Direct Labor 2,347,506$ 1,051,140$ 2,854,878$ Overhead 2,905,273$ 1,300,890$ 3,878,351$ Labor + Overhead 5,252,779$ 2,352,030$ 6,733,229$ Interfund Labor 5,924,280$ Charged to Projects Interfund Labor 808,949$ Manual Entry charged to 5120 Overhead Rate from 2018 Rate Proposal 123.76% Engineering Unsegmented OH Rate 135.85% Uses Overhead Rate of 177.79%Row Labels Count of FTESum of SalarySum of Overhead Sum of Total ExpenseGrand Glaize Yard 16 1,009,164 1,794,226 2,803,390Collections System Technician 11 639,038 1,136,168 1,775,206Engineer2 165,100 293,537 458,637Heavy Equipment Operator1 71,989 127,991 199,980Team Lead I 2 133,037 236,531 369,567Mintert Yard 17 1,072,729 1,907,240 2,979,969Bricklayer 1 71,989 127,991 199,980Collections System Technician 12 697,133 1,239,456 1,936,589Engineer2 165,100 293,537 458,637Heavy Equipment Operator1 71,989 127,991 199,980Team Lead I 1 66,518 118,265 184,784Sulphur Yard 28 1,704,160 3,029,882 4,734,042Bricklayer 1 71,989 127,991 199,980Collections System Technician 22 1,278,077 2,272,336 3,550,412Engineer1 82,550 146,768 229,318Heavy Equipment Operator1 71,989 127,991 199,980Team Lead I 3 199,555 354,796 554,351FY19 SW Opertations Labor Budget 3,786,052 6,731,349 10,517,402FY18 SW Operations Labor Budget‐3,882,028‐4,187,156‐8,069,184Variance‐95,976 2,544,193 2,448,2185120 5130 Total 5120 51301,436,153.25$ 4,187,415.39$ Labor 3,786,052$ 1,345,492$ 2,440,561$ 36% 64% Overhead 6,731,349$ 2,392,194$ 4,339,155$ Equipment 1,916,917$ 681,236$ 1,235,681$ Supplies 1,131,356$ 402,062$ 729,293$ FY20 FY21Salaries 3.07% 2.99%Overhead 3.07% 2.99%Equipment 2.00% 2.00%Supplies 2.00% 2.00%Dec FY18 YTD WO Split FY19 Ops SW Budget (using Dec FY18 WO Split)Future Year Inflation %