FINAL 2012-2014 DISTRICT ATTORNEY OFFICE WORKLOAD ANALYSIS DA Office Adams Ashland Barron Bayfield Brown Buffalo Burnett Calumet Chippewa Clark Columbia Crawford Dane Dodge Door Douglas Dunn Eau Claire Florence Fond du Lac Forest Grant Green Green Lake Iowa Iron Jackson Jefferson Juneau Kenosha Kewaunee La Crosse Lafayette Langlade Lincoln Manitowoc Marathon Marinette Marquette Milwaukee Monroe Oconto Oneida Outagamie Ozaukee Pepin Pierce Polk Portage Price Racine Richland Rock Rusk Saint Croix Sauk Sawyer Shaw/Men 7/20/16 GPRFunded FTE Positions* 1.20 2.00 3.00 1.00 12.00 1.00 1.25 2.00 5.00 2.00 4.75 1.00 26.85 4.00 2.00 3.50 3.00 8.00 0.50 5.00 1.00 2.00 2.00 1.50 1.75 1.00 2.00 5.30 2.50 15.00 1.50 8.00 1.00 1.50 2.00 5.00 8.50 2.50 1.00 87.00 3.00 2.00 2.50 9.00 3.00 0.80 2.50 3.00 4.00 1.00 18.00 1.80 14.00 1.50 6.00 5.00 2.00 3.00 7/20/16 Program Revenue7/20/16 Additional Estimated Funded FTE Total FTE FTE Total FTE Positions* Positions* Needed Needed 1.20 1.36 2.56 2.00 0.87 2.87 3.00 3.22 6.22 1.00 0.90 1.90 1.00 13.00 11.46 24.46 1.00 0.61 1.61 1.25 1.95 3.20 2.00 1.01 3.01 5.00 1.49 6.49 2.00 0.56 2.56 4.75 3.32 8.07 1.00 -0.25 0.75 3.00 29.85 3.21 33.06 4.00 2.12 6.12 2.00 0.71 2.71 3.50 3.07 6.57 3.00 2.93 5.93 1.00 9.00 4.46 13.46 0.50 0.39 0.89 2.00 7.00 5.44 12.44 1.00 1.91 2.91 2.00 2.09 4.09 2.00 0.99 2.99 1.50 0.67 2.17 1.75 0.98 2.73 1.00 -0.27 0.73 2.00 1.62 3.62 5.30 1.83 7.13 2.50 0.67 3.17 1.00 16.00 7.16 23.16 1.50 -0.14 1.36 8.00 4.95 12.95 1.00 0.26 1.26 1.50 1.99 3.49 2.00 1.44 3.44 5.00 2.73 7.73 2.50 11.00 3.60 14.60 0.10 2.60 0.49 3.09 1.00 0.49 1.49 33.50 120.50 -21.80 98.70 3.00 3.15 6.15 2.00 0.94 2.94 2.50 1.55 4.05 9.00 8.83 17.83 3.00 1.66 4.66 0.80 -0.18 0.62 2.50 0.67 3.17 3.00 2.84 5.84 4.00 3.93 7.93 1.00 0.09 1.09 18.00 11.23 29.23 1.80 -0.10 1.70 14.00 2.57 16.57 1.50 0.52 2.02 6.00 1.05 7.05 0.80 5.80 1.36 7.16 2.00 1.10 3.10 3.00 2.19 5.19 Additional Additional FTE FTE Needed Needed as a % as a % of of 7/20/16 GPR- 7/20/16 Total Funded FTE FTE 113.33% 113.33% 43.50% 43.50% 107.33% 107.33% 90.00% 90.00% 95.50% 88.15% 61.00% 61.00% 156.00% 156.00% 50.50% 50.50% 29.80% 29.80% 28.00% 28.00% 69.89% 69.89% -25.00% -25.00% 11.96% 10.75% 53.00% 53.00% 35.50% 35.50% 87.71% 87.71% 97.67% 97.67% 55.75% 49.56% 78.00% 78.00% 108.80% 77.71% 191.00% 191.00% 104.50% 104.50% 49.50% 49.50% 44.67% 44.67% 56.00% 56.00% -27.00% -27.00% 81.00% 81.00% 34.53% 34.53% 26.80% 26.80% 47.73% 44.75% -9.33% -9.33% 61.88% 61.88% 26.00% 26.00% 132.67% 132.67% 72.00% 72.00% 54.60% 54.60% 42.35% 32.73% 19.60% 18.85% 49.00% 49.00% -25.06% -18.09% 105.00% 105.00% 47.00% 47.00% 62.00% 62.00% 98.11% 98.11% 55.33% 55.33% -22.50% -22.50% 26.80% 26.80% 94.67% 94.67% 98.25% 98.25% 9.00% 9.00% 62.39% 62.39% -5.56% -5.56% 18.36% 18.36% 34.67% 34.67% 17.50% 17.50% 27.20% 23.45% 55.00% 55.00% 73.00% 73.00% GPR-Funded FTE as a % of Estimated Total FTE Needed 46.88% 69.69% 48.23% 52.63% 49.06% 62.11% 39.06% 66.45% 77.04% 78.13% 58.86% 133.33% 81.22% 65.36% 73.80% 53.27% 50.59% 59.44% 56.18% 40.19% 34.36% 48.90% 66.89% 69.12% 64.10% 136.99% 55.25% 74.33% 78.86% 64.77% 110.29% 61.78% 79.37% 42.98% 58.14% 64.68% 58.22% 80.91% 67.11% 88.15% 48.78% 68.03% 61.73% 50.48% 64.38% 129.03% 78.86% 51.37% 50.44% 91.74% 61.58% 105.88% 84.49% 74.26% 85.11% 69.83% 64.52% 57.80% Total FTE as a % of Estimated Total FTE Needed 46.88% 69.69% 48.23% 52.63% 53.15% 62.11% 39.06% 66.45% 77.04% 78.13% 58.86% 133.33% 90.29% 65.36% 73.80% 53.27% 50.59% 66.86% 56.18% 56.27% 34.36% 48.90% 66.89% 69.12% 64.10% 136.99% 55.25% 74.33% 78.86% 69.08% 110.29% 61.78% 79.37% 42.98% 58.14% 64.68% 75.34% 84.14% 67.11% 122.09% 48.78% 68.03% 61.73% 50.48% 64.38% 129.03% 78.86% 51.37% 50.44% 91.74% 61.58% 105.88% 84.49% 74.26% 85.11% 81.01% 64.52% 57.80% DA Office Sheboygan Taylor Trempealeau Vernon Vilas Walworth Washburn Washington Waukesha Waupaca Waushara Winnebago Wood TOTALS 7/20/16 GPRFunded FTE Positions* 7.50 1.00 2.00 2.00 2.00 5.00 1.25 5.00 14.50 3.50 2.00 10.00 4.00 382.95 7/20/16 Program Revenue7/20/16 Additional Estimated Funded FTE Total FTE FTE Total FTE Positions* Positions* Needed Needed 7.50 4.08 11.58 1.00 0.41 1.41 2.00 1.13 3.13 2.00 -0.09 1.91 2.00 1.17 3.17 5.00 2.46 7.46 1.25 0.96 2.21 5.00 4.08 9.08 2.00 16.50 7.68 24.18 3.50 1.36 4.86 2.00 1.16 3.16 10.00 5.97 15.97 4.00 5.40 9.40 46.90 429.85 139.66 Additional Additional FTE FTE Needed Needed as a % as a % of of 7/20/16 GPR- 7/20/16 Total Funded FTE FTE 54.40% 54.40% 41.00% 41.00% 56.50% 56.50% -4.50% -4.50% 58.50% 58.50% 49.20% 49.20% 76.80% 76.80% 81.60% 81.60% 52.97% 46.55% 38.86% 38.86% 58.00% 58.00% 59.70% 59.70% 135.00% 135.00% GPR-Funded FTE as a % of Estimated Total FTE Needed 64.77% 70.92% 63.90% 104.71% 63.09% 67.02% 56.56% 55.07% 59.97% 72.02% 63.29% 62.62% 42.55% 569.51 *Modifications: 1) The 0.5 GPR FTE in Washburn (0.25 FTE) that also serves Burnett (0.25 FTE) is divided by the FTE shown in parentheses. 2) In Milwaukee, the total FTE used is 120.50 rather than 121.50 due to the following factor: a) the 1.0 FTE DNA position serves the entire state; so, showing it as a Milwaukee position distorts the data. 3) In Brown the total FTE used is 13.00 rather than 14.00 due to the following factor: a) the 1.0 ADA FTE sex predator position in Brown is excluded because it also serves approximately 20 other DA offices. 4) In Fond du Lac the total FTE used is 7.00 rather than 8.00 because the Title IV-E CHIPS/TPR positoin has no funding. 5) In Outagamie the total FTE used is 9.00 rather than 10.00 because the VAWA positoin has no funding. 6) The weighted time estimate for CHIPS cases was changed from 2.61 hours to 6.0 hours effective in the 2004-06 study, based on a 7/04 WDAA Executive Board recommendation. 7) CHIPS extensions include permanency plan review petitions filed under s. 48.365 beginning with data for 2006. 8) Immunization cases filed by DA Offices under s. 48.13(13) are included with CHIPS cases beginning with data for 2006. 9) WDAA Executive Board authorized the following changes to the weighted time estimates beginning with the 2007-09 caseload study: a) Increase the "reviewing case referrals that are not prosecuted" from 35 to 100 hours per year, thereby reducing hours available per prosecutor to handle individual cases to 1162 per year. b) Weighted time estimate for Class A and First Degree Reckless homicides changed from 100 hours each to 160 hours each. c) Weighted time estimate for "All other Homicides" changed from 50 to 80 hours each. d) The weighted time estimate for misdemeanors changed from 2.17 hours each to 2.91 hours each. e) The weighted time estimate for criminal traffic changed from 1.68 hours each to 2.91 hours each. f) Weighted time estimate for juvenile delinquency changed from 3.32 hours each to 3.44 hours each. Total FTE as a % of Estimated Total FTE Needed 64.77% 70.92% 63.90% 104.71% 63.09% 67.02% 56.56% 55.07% 68.24% 72.02% 63.29% 62.62% 42.55%