Loading...
HomeMy WebLinkAboutInsurance Premium Split between Departments 2012 Blue Cross/Blue Shield Insurance Premium Split Between Departments 2012 1595.75-Dep 581.05-IndBuilding EmployeeTotalStormTotalTotal AdmnFinancePoliceInspectionsStreetsParksCobraShareGeneralWaterSewerSewerUtilitiesPremium January 3,359.711,676.0712,175.621,943.63239.37320.491,162.103,198.0224,075.011,704.261,105.85219.033,029.1427,104.15 February 3,359.711,676.0712,175.621,943.63239.37320.491,162.103,198.0224,075.011,704.261,105.85219.033,029.1427,104.15 March3,359.711,676.0712,175.621,943.63239.37320.491,162.103,198.0224,075.011,704.261,105.85219.033,029.1427,104.15 April3,359.711,676.0712,175.621,943.63239.37320.491,162.103,198.0224,075.011,704.261,105.85219.033,029.1427,104.15 May3,359.711,676.0714,952.241,882.97239.37320.491,162.103,601.3627,194.311,704.261,105.85219.033,029.1430,223.45 June3,359.711,676.0710,787.301,882.97239.37320.491,162.102,979.0522,407.061,704.261,105.85219.033,029.1425,436.20 July2,665.551,676.0712,175.622,715.96239.37320.491,162.103,186.4924,141.651,634.841,036.43219.032,890.3027,031.95 August2,665.551,676.0712,175.62-92.18239.37320.495,242.152,990.5825,217.651,634.841,036.43219.032,890.3028,107.95 September2,665.561,676.0712,175.621,388.31239.37320.49-1,347.002,990.5820,109.001,634.841,036.43219.032,890.3022,999.30 October2,665.561,676.0712,175.621,388.31239.37320.491,700.102,990.5823,156.101,634.841,036.43219.032,890.3026,046.40 November2,665.561,676.0712,175.621,388.31239.37320.491,700.102,990.5823,156.101,634.841,036.43219.032,890.3026,046.40 December2,665.561,676.0712,175.621,388.31239.37320.491,700.102,990.5823,156.101,634.841,036.43219.032,890.3026,046.40 YTD Totals36,151.6020,112.84147,495.7419,717.482,872.443,845.8817,130.1537,511.88284,838.0120,034.6012,853.682,628.3635,516.64320,354.65 Judy TER ShrJulie H.ER Shr Jennifer 75% Finance1,196.811,041.2350% Admn797.88694.1592% Admn1,468.091,277.25 10% Water159.58138.8340% BI638.30555.328% Parks127.66111.06 10% Sewer159.58138.835% Water79.7969.421,595.751,388.31 5% St Sew79.7969.425% Sewer79.7969.42EE Shr207.44 1,595.751,388.311,595.751,388.311,388.31 EE Shr207.44EE Shr207.44 1,388.311,388.31 MarkER ShrJeffER ShrAndyER Shr 8% Streets127.66111.068% Streets46.4842.778% Sts46.4842.77 7% Parks111.7097.177% Parks40.6737.427% Parks40.6737.42 50% Water797.88694.1750% Water290.53267.2850% Water290.53267.28 30% Sewer478.73416.4930% Sewer174.32160.3730% Sewer174.32160.37 5% St Sew79.7969.425% St Sew29.0426.735% St Sew29.0426.73 1,595.751,388.31581.05534.57581.05534.57 EE Shr207.44EE Shr46.48EE Shr46.48 1,388.31534.57534.57 Betty Dental100.27Jim Single Dental Family Health as of May 1st EE Shr14.98City Share39.61 115.25OPEB Allocation 2010EE Share3.44 Water1,6185.97%Single Dental43.05 Sewer1,0673.94% Storm2180.80%City Share1288.04 General24,20189.29%EE Share192.47 27,104100.00%Family Health1480.50 EE Share195.9197.9545 11.59 14,952.24 2013 Family1622.50.185300.16251322.34 Single589.50.13579.5825 Dental Family115.250.18521.32125 Single43.050.1355.81175 Combined Family1737.750.185321.483857.81 Single632.550.13585.391024.73 Lincoln Mutual Insurance Premium Split Between Departments 2012 BuildingEmployee AdmnFinancePoliceInspectionsStreetsParksShare January39.9342.37165.0023.094.805.52112.00 February39.9342.37165.0023.094.805.52112.00 March39.9342.37165.0023.094.805.52112.00 April39.9342.37165.0023.094.805.52112.00 May39.9342.37165.0023.094.805.52112.00 June39.9342.37214.5023.094.805.52112.00 July39.9342.37132.0018.364.805.52112.00 August31.6842.37165.004.734.805.52112.00 September31.6842.37165.0016.504.805.52112.00 October31.6842.37165.0016.504.805.52112.00 November31.6842.37165.0016.504.805.52170.85 December31.6842.37165.0016.504.805.52123.77 YTD Totals437.91508.441,996.50227.6357.6066.241,414.62 JudyJenniferJulie H. 75% Fin.12.3792% Admn15.1850% Admn8.25 10% Water1.658% Parks1.3240% BI6.59 10% Sewer1.6516.505% Water0.83 5% St Sew0.835% Sewer0.83 16.50Andy16.50 8% Sts1.08 Andy7% Parks0.95 8% Sts1.0850% Water6.75 7% Parks0.9530% Sewer4.05 50% Water6.755% St Sew0.68 30% Sewer4.0513.50 5% St Sew0.67 13.50 Lincoln Mutual Insurance Premium Split Between Departments 2012 TotalStormTotalTotal GeneralWaterSewerSewerUtilitiesPremium 392.7132.4820.483.8356.79449.50 392.7132.4820.483.8356.79449.50 392.7132.4820.483.8356.79449.50 392.7132.4820.483.8356.79449.50 392.7132.4820.483.8356.79449.50 442.2132.4820.483.8356.79499.00 354.9832.4820.483.8356.79411.77 366.1031.6519.653.8355.13421.23 377.8731.6519.653.8355.13433.00 377.8731.6519.653.8355.13433.00 436.7231.6519.653.8355.13491.85 389.6431.6519.653.8355.13444.77 0.00 4,708.94385.61241.6145.96673.185,382.12 JeffMark 8% Streets1.328% Streets1.32 7% Parks1.157% Parks1.15 50% Water8.2550% Water8.25 30% Sewer4.9530% Sewer4.95 5% St Sew0.835% St Sew0.83 16.5016.50 DSailer@primetherapeutics.com Assurant Benefits Insurance Premium Split Between Departments 2012 Building AdmnFinancePoliceInspectionsStreetsParks January106.49155.01405.5258.319.1610.49 February106.49155.01405.5258.319.1610.49 March106.49155.01405.5258.319.1610.49 April106.49155.01405.5258.3112.3413.27 May106.49-113.02405.5258.3110.7511.88 June106.49101.76405.5258.3110.7511.88 July106.49101.76405.5258.3110.7511.88 August111.38166.97472.0459.2211.0112.46 September107.28110.16416.4758.4710.8112.00 October November December YTD Total964.09987.673727.15525.8693.89104.84 Judy T.Jennifer PJulie H. 75% Fin.$ 25.84$ 1.61 92% Admn$ 29.14$ 3.16 50% Admn 10% Water$ 3.45$ 0.21 8% Parks$ 2.53$ 0.28 40% BI 10% Sewer$ 3.45$ 0.21$ 31.67$ 3.44 5% Water 5% St Sew$ 1.72$ 0.11 5% Sewer $ 34.46$ 2.14 Andy 8% Sts$ 3.86$ 0.20 Andy7% Parks$ 3.39$ 0.18 Jeff 8% Sts$ 1.59 50% Water$ 24.19$ 1.26 8% Streets 7% Parks$ 1.39 30% Sewer$ 14.51$ 0.75 7% Parks 50% Water$ 9.96 5% St Sew$ 2.42$ 0.13 50% Water 30% Sewer$ 5.98$ 48.37$ 2.51 30% Sewer 5% St Sew$ 1.00 5% St Sew $ 19.92 693.98 0 Assurant Benefits Insurance Premium Split Between Departments 2012 TotalStormTotalTotal GeneralWaterSewerSewerUtilitiesPremium 744.9862.4139.497.42109.32854.3 744.9862.4139.497.42109.32854.3 744.9862.4139.497.42109.32854.3 750.9482.3351.459.42143.20894.14 479.9372.3745.478.42126.26606.19 694.7172.3745.478.42126.26820.97 694.7172.3745.478.42126.26820.97 833.0874.4346.848.73130.00963.08 715.1972.8745.798.49127.15842.34 00.000 00.000 00.000 6403.5633.97398.9674.161107.097510.59 $ 17.38$ 0.94 $ 13.91$ 0.75 $ 1.74$ 0.09 $ 1.74$ 0.09 $ 34.77$ 1.88 $ 2.88 Mark $ 2.52 8% Streets$ 2.48 $ 18.02 7% Parks$ 2.17 $ 10.81 50% Water$ 15.51 $ 1.80 30% Sewer$ 9.30 $ 36.03 5% St Sew$ 1.55 $ 31.01 Reliance Standard Life Insurance Premium Split Between Departments 2012 Building Total AdmnFinancePoliceInspectionsStreetsParksGeneralWater January78.1284.28307.1442.778.279.1529.6855.63 February78.1284.28307.1442.778.279.1529.6855.63 March78.1284.28307.1442.778.279.1529.6855.63 April78.1284.28307.1442.778.279.1529.6855.63 May78.1284.28307.1442.778.279.1529.6855.63 June78.1284.28373.542.778.279.1596.0455.63 July78.1284.28226.7542.778.279.1449.2955.63 August65.4184.28295.0925.438.279.10487.5854.36 September65.4184.28295.09-7.168.279.10454.9954.36 October65.4184.28295.0925.438.279.10487.5854.36 November65.4184.28295.0925.438.279.10487.5854.36 December65.4184.28295.0925.438.279.10487.5854.36 YTD Total873.891011.363611.4393.9599.24109.26099.04661.21 Judy T.Jennifer PJulie H. 75% Fin.$ 18.90$ 1.61 92% Admn$ 21.31$ 3.16 50% Admn$ 12.71$ 0.94 10% Water$ 2.52$ 0.21 8% Parks$ 1.85$ 0.28 40% BI$ 10.18$ 0.75 10% Sewer$ 2.52$ 0.21$ 23.16$ 3.44 5% Water$ 1.27$ 0.09 5% St Sew$ 1.26$ 0.11 5% Sewer$ 1.27$ 0.09 $ 25.20$ 2.14 Andy$ 25.43$ 1.88 8% Sts$ 3.14$ 0.20 Andy7% Parks$ 2.75$ 0.18 Jeff 8% Sts$ 1.22 50% Water$ 19.66$ 1.26 8% Streets$ 2.10 Mark 7% Parks$ 1.07 30% Sewer$ 11.79$ 0.75 7% Parks$ 1.84 8% Streets 50% Water$ 7.65 5% St Sew$ 1.97$ 0.13 50% Water$ 13.18 7% Parks 30% Sewer$ 4.59$ 39.31$ 2.51 30% Sewer$ 7.91 50% Water 5% St Sew$ 0.77 5% St Sew$ 1.32 30% Sewer $ 15.30$ 26.35 5% St Sew Reliance Standard Life Insurance Premium Split Between Departments 2012 StormTotalTotal SewerSewerUtilitiesPremium 34.886.4596.96626.64 34.886.4596.96626.64 34.886.4596.96626.64 34.886.4596.96626.64 34.886.4596.96626.64 34.886.4596.96693 34.886.4596.96546.25 33.616.4594.42582 33.616.4594.42549.41 33.616.4594.42582 33.616.4594.42582 33.616.4594.42582 412.2177.41150.827249.86 $ 1.81 $ 1.59 $ 11.35 $ 6.80 $ 1.13 $ 22.68