FINANCIAL JAIL WAGON SERVICE.XLSX

Cost Calculations to Support Jail Wagon Prisoner
Transport Effective
January 1, 2016
Annual
What (FY 15 Actual) Monthly
FY 2015 Actual Costs Org 5115 (Business
Objects) $ 1,668,268 $ 139,022.34
Estimated Equipment Depreciation (1/5 of
$140,000) $ 28,000 $ 2,333.33
Total Actual Cost $ 1,696,268 $ 141,355.67
Capacity:
Maximum Available Seats--(2 vans, 10
seats each; 3 shifts; 350 days per year--
removed 15 service days) 21,000 1,750
Cost Per Seat $ 81 $ 81
Annual Estimated DPS Volume- 2,920 2,920
Estimated Revenue from IGA $ 236,520.00 $ 19,710.00
REVISED FY 2016 Estimate: $ 109,512.00 ($81 x 8 passengers x 169 days)
Calculation Expanation:
MCSO has actual cost data for one fiscal year. That amount is used as the numerator.
Equipment cost is depreciated over 5 years--2 Vans $70,000 each = $140,000 divided by 5
Capacity is used as the denominator.
Revised 12/21/2015
6/28/2020
Suzanne Baier 876-1633

Agency by Sub-Object (R203) - A:CAL
1:32:58 PM
FYE YTD Period: 12
Fund: 255 - DETENTION OPERATIONS
Agency: 507 - SHERIFF F255
Expenditures
JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY MARCH APRIL MAY JUNE
0701 -01 - FULL TIME REGULAR 63,739.95 73,569.57 73,109.28 75,813.07 55,830.65 62,909.44 62,387.67 64,465.13 62,497.08 76,710.94 67,571.79 73,513.28
0701 -05 - HOLIDAY PAY - 202.32 3,413.39 (33.07) 4,583.40 5,481.68 5,732.63 3,517.06 3,216.43 402.33 (114.95) 3,186.96
0701 -06 - VACATION PAY 8,188.91 5,131.56 6,474.32 6,540.16 1,429.59 8,699.35 2,405.47 2,658.27 6,361.13 4,180.99 6,537.87 5,274.43
0701 -08 - ADMINISTRATIVE LEAVE - - 256.32 - - - - - 784.13 196.03 - -
0701 -10 - MILITARY LEAVE - - - 298.80 - - - - - - - -
0701 -11 - SICK LEAVE 1,530.07 1,448.26 1,558.61 3,178.78 2,256.82 133.98 4,492.06 1,628.42 878.98 999.34 1,374.96 2,173.87
0701 - REGULAR PAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0710 -00 - OVERTIME 23,742.86 19,068.92 12,298.04 2,143.19 15,369.94 13,261.27 6,837.93 14,840.09 17,583.85 25,071.64 26,743.94 22,879.08
0750 -00 - FRINGE BENEFITS - - - (72.84) - - - (39.66) - - - (21.48)
0750 -01 - FICA 7,301.88 5,428.08 5,860.94 5,343.24 4,795.59 5,536.60 4,949.59 5,271.00 5,650.19 6,489.88 6,176.11 6,563.84
0750 -02 - MEDICARE TAX 1,707.80 1,269.41 1,370.71 1,249.70 1,121.58 1,294.76 1,157.57 1,232.70 1,321.47 1,517.84 1,444.41 1,535.02
0750 -04 - CORRECTIONS OFFICERS 10,474.18 12,287.55 11,950.42 10,843.25 9,520.83 10,882.17 10,417.11 10,307.42 10,514.70 11,974.24 11,461.68 12,610.66
0750 -10 - CIGNA HEALTH PLAN 9,235.86 15,925.15 16,365.06 16,443.44 13,836.31 13,962.06 13,825.53 14,972.02 14,584.96 16,502.51 15,854.42 16,312.19
0750 -14 - BUS FARE SUBSIDY PLAN 127.11 97.45 104.00 - - - 66.00 16.00 64.00 64.00 - -
0750 - FRINGE BENEFITS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0790 -02 - DIFFERENTIALS 1,375.72 1,369.49 1,503.80 1,444.61 1,073.40 1,210.27 1,225.14 1,250.91 1,271.76 1,732.27 1,613.25 1,653.65
0795 -00 - PERSONAL SERVICES - - (140.90) - - - - - - - - -
0801 -05 - CLEANING & JANITORIAL - - - - 22.18 5.68 6.82 - - - - -
0801 -06 - CLOTHING/UNIFORMS 12,000.00 - - - - - - - - - - -
0801 -18 - OFFICE SUPPLIES - - - 380.76 - 64.32 15.60 394.41 233.31 1,442.51 - -
0801 -20 - SAFETY APPAREL - - - - 1,292.84 780.21 227.98 - - 265.49 552.92 -
0801 -25 - - - - - 46.78 - - - - - - -
0801 - GENERAL SUPPLIES - 0.00 - - - - - - - - - -
0803 -00 - FUEL 4,025.69 5,569.07 6,372.33 5,052.88 3,817.21 4,237.48 2,654.39 2,954.04 3,708.22 3,733.24 4,175.91 4,887.25
0804 -00 - NON-CAPITAL EQUIPMENT - - - - - 8,778.54 - - - - - -
0804 -11 - COMPUTER EQUIPMENT - - - - - - 1,253.48 7,675.68 - - - -
0839 -03 - BASE LEVEL EQ SERVICES 3,445.72 1,890.39 2,789.57 5,823.63 2,434.03 2,215.61 3,498.73 1,922.50 1,586.72 3,542.90 3,590.03 6,641.20
0841 -00 - TRAVEL - - 79.62 - (79.62) - - - - - - -
0930 - VEHICLES & CONSTRUCTION EQ - - - 0.00 - - - - - - - -
Sum: 146,895.75 143,257.22 143,365.51 134,449.60 117,351.53 139,453.42 121,153.70 133,065.99 130,256.93 154,826.15 146,982.34 157,209.95

YTD
812,117.85
29,588.18
63,882.05
1,236.48
298.80
21,654.15
0.00
199,840.75
(133.98)
69,366.94
16,222.97
133,244.21
177,819.51
538.56
0.00
16,724.27
(140.90)
34.68
12,000.00
2,530.91
3,119.44
46.78
0.00
51,187.71
8,778.54
8,929.16
39,381.03
0.00
0.00
1,668,268.09