Loading...
HomeMy WebLinkAboutFIN 2020-07-27 Item 1B - Handout to be Distributed at Meeting - Fire Department 6-Month Financial ReportTukwila Fire Department 6 Month Budget and Forecast Report Contents '�'uKWi'LA • 2020 Forecast vs Budget • 2020 Overtime Report Dollars and Hours • 2020 Revenues • Goals for the year Fire io2o Forecast vs Budget i4( mom � of, • Department projected to be within Original 2020 Adopted Budget • Operational Changes in Overtime have been main cost savings • Reduced costs for minimum staffing • Reduced overtime costs for training and other activities • First six months averaging $22K/month in overtime, • Concerns -July projected at $50K/month - increase in Sick Leave • Salaries/Benefits overbudget- pipeline, academy & retirements • Supplies below budget due to budget scrub • Covid-19 Financial Savings have been accounted for in O/T & Supplies • Additional Savings — Capital/Knox Box (shown) & Fleet (not shown) Fire Zo2o Forecast vs Budget Fire's 2020 Forecast vs Budget Updated July 21nd 2020 Regular Salaries & Wages Extra Labor Total Overtime YTD Actuals Jan -June % Budget $ 3,970,602 51.8% $ 136,582 25.5% Holiday Pay $ 2,641 0.9% TOTAL SALARIES & WAGES $ 4,109,825 48.4% FICA Pension - LEOFF Pension - PERS Industrial Insurance Medical, Dental, Life, Optical VEBA6 RMP $ 69,450 33.2% $ 275,201 61.7% $ 16,414 32.1% $ 217,851 51.5% $ 827,771 53.5% $ 15,000 N/A PERSONNEL BENEFITS $ 1,421,687 53.1% TOTAL SALARY & BENEFITS $ 5,531,512 49.5% Office & Operating Supplies $ 48,465 23.4% Small Tools & Minor Equipment $ 29,232 33.5% SUPPLIES&SMALL TOOLS $ 77,697 26.4% Professional Services $ 49,534 61.2% Dispatching Services - Dispatching $ 76,437 34.4% Communication $ 14,375 44.7% Travel $ 468 6.7% Operating Rentals & Leases - Non Fleet $ 3,680 96.8% Operating Rentals & Leases - Fleet $ 135,490 20.8% Insurance (WCIA) $ 173,213 86.6% Public Utility $ 47,049 64.1% Repairs & Maintainance $ 19,869 53.8% Miscellaneous $ 32,363 22.5% SERVICES $ 552,477 38.1% Capital Purchases (Machinery & Equipment) $ 5,495 2.7% TOTAL OPERATING EXPENSES $ 635,669 32.7% GRANDTOTAL $ 6,167,181 47.0% Adjusted_ Full Year Forecasts Forecasted Variance from Budget Forecast Printed Budget Over/(Under) Deviation % C19BudgetAdj Adjusted Budget $ 7,855,952 $ 7,666,823 $ 189,129 2.5% $ $ 7,666,823 $ 5,508 $ - $ 5,508 - $ $ - $ 286,582 $ 534,64 $ (248,066) -46.4% $ (150,000) $ 384,648 $ 252,641 $ 295,454 $ $ (42,813) (96,242) -14% -1% $ $ - (150,000) $ $ 295,454 8,346,925 $ 8,400,683 $ 8,496,925 $ 146,360 $ 208,95 $ (62,596) -30% $ $ 208,956 $ 541,001 $ 446,274 $ 94,727 21% $ $ 446,274 $ 39,943 $ 51,12 $ (11,186) -22% $ $ 51,129 $ 383,813 $ 422,61 $ (38,806) -9% $ $ 422,619 $ 1,583,490 $ 1,548,497 $ 34,993 2% $ $ 1,548,497 $ 33,000 $ $ 33,000 - $ $ - $ 2,727,606 $ 2,677,475 $ 50,131 1.9% $ $ 2,677,475 $ 11,128,289 $ 11,174,40 $ (46,111) -0.4% $ (150,000) $ 11,024,400 Adjustments Adjustments $ 174,465 $ 206,87 $ (32,412) -16% $ (25,000) $ 181,877 $ 43,232 $ 87,26 $ (44,036) -50% $ (36,000) $ 51,268 $ 217,697 $ 294,14 $ (76,448) -26% $ (61,000) $ 233,145 $ 118,534 $ 81,000 $ 37,534 46% $ (4,000) $ 77,000 $ 229,310 $ 221,945 $ 7,365 3% $ $ 221,945 $ 32,435 $ 32,17 $ 265 1% $ $ 32,170 $ 2,218 $ 7,00 $ (4,782) -68% $ (7,000) $ - $ 8,832 $ 3,800 $ 5,032 132% $ $ 3,800 $ 650,351 $ 650,35 $ - 0% $ $ 650,351 $ 173,213 $ 199,92 $ (26,709) -13% $ $ 199,922 $ 99,549 $ 73,360 $ 26,189 36% $ $ 73,360 $ 53,469 $ 36,921 $ 16,548 45% $ $ 36,921 $ 131,571 $ 143,87 $ (12,303) -9% $ (14,500) $ 129,374 $ 1,499,482 $ 1,450,34 $ 49,139 3% $ (25,500) $ 1,424,843 $ 5,495 $ 200,00 $ (194,506) -97% $ - $ 200,000 $ 1,722,673 $ 1,944,488 $ (221,815) -11.4% $ (86,500) $ 1,857,988 $ 12,850,962 $ 13,118,888 $ (267,926) -2.0% $ (236,500) $ 12,882,388 Adj Budget Variance Over/(Under) Deviation $ 189,129 2.5% $ 5,508 - $ (98,066) -25.5% $ (42,813) -14% $ 53,758 1% $ (62,596) -30% $ 94,727 21% $ (11,186) -22% $ (38,806) -9% $ 34,993 2% $ 33,000 - $ 50,131 1.9% $ 103,889 0.9% $ (7,412) -4% $ (8,036) -16% $ (15,448) -7% $ 41,534 54% $ 7,365 3% $ 265 1% $ 2,218 - $ 5,032 132% $ - 0% $ (26,709) -13% $ 26,189 36% $ 16,548 45% $ 2,197 2% $ 74,639 5% $ (194,506) -97% $ (135,315) -7.3% $ 31,426 T�Kwi'�A Report by Jake Berry Fire zo2o 1Sr & Z"d Ort Overtime i Dollars FD 2020 Overtime ($) Overtime Project Name -T January L February March April May June - YTD Total % Total $/hr ACADEMY AID RUN $ $ 2,537 215 $ 478 $ 3,015 2% $ 86.76 $ 272 $ 487 0% $ 62.90 AIRPAK MAINTENANCE/SCBA $ 408 $ 833 $ 680 $ 1,922 1% $ 68.04 CALLBACK $ 436 $ 277 $ 713 1% $ 79.23 CITY MEETING $ 945 $ 79 $ 1,024 1% $ 74.47 CONTRACTOR BILLABLE OT $ 2,024 $ 1,557 $ 3,063 $ 688 $ 1,162 $ 8,495 6% $ 78.66 DEPARTMENT MEETING $ 3,853 $ 178 $ 396 $ 436 $ 238 $ 5,101 4% $ 77.00 EXPLORERS $ 248 $ 248 0% $ 70.82 FIRE INVESTIGATION $ 352 $ 1,629 $ 1,123 $ 857 $ 1,031 $ 988 $ 5,980 4% $ 102.65 FIRE PREVENTION OT $ 3,608 $ 2,744 $ 6,352 5% $ 92.74 INSTRUCTOR $ 527 $ 1,066 $ 136 $ 1,729 1% $ 72.79 INSTRUCTOR - CBT $ 1,380 $ 1,380 1% $ 58.72 INSTRUCTOR - JATC $ 226 $ 1,467 $ 1,694 1% $ 61.59 INSTRUCTOR - RESCUE $ 1,048 $ 1,048 1% $ 89.16 INSTRUCTOR - TRUCK ACADEMY $ 527 $ 2,856 $ 3,383 2% $ 65.06 JATC $ 230 $ 879 $ 1,108 1% $ 48.18 MINIMUM STAFFING -'A' SHIFT $ 9,849 $ 11,909 $ 11,326 $ 2,825 $ 35,909 26% $ 64.91 MINIMUM STAFFING -'B' SHIFT $ 2,903 $ 6,323 $ 4,431 $ 900 $ 1,467 $ 16,025 12% $ 65.14 MINIMUM STAFFING -'C' SHIFT $ 5,368 $ 182 $ 1,654 $ 84 $ 102 $ 7,389 5% $ 76.77 Overtime $ 8,015 $ 8,015 6% $ 75.80 PHONE CALL OT $ 32 $ 100 $ 44 $ 176 0% $ 78.16 PROGRAM/EQUIPMENT SUPPORT $ 34 $ 34 0% $ 68.04 PUBLIC SAFETY BOND $ 399 $ 2,162 $ 889 $ 34 $ 1,115 $ 602 $ 5,201 4% $ 70.76 PUBLIC SAFETY COMMITTEE MEETING $ 293 $ 293 0% $ 58.56 SHIFT EXTENSION (CALL) $ 361 $ 295 $ 139 $ 333 $ 270 $ 207 $ 1,606 1% $ 63.60 SHIFT EXTENSION (REPORT) $ 165 $ 129 $ 167 $ 29 $ 490 0% $ 65.35 SPECIAL ASSIGNMENT $ 86 $ 842 $ 929 1% $ 64.04 SPECIAL COMMITTEE MEETING $ 277 $ 158 $ 172 $ 607 0% $ 65.67 STARFIRE EVENTS/STANDBY $ 1,377 $ 670 $ 2,047 1% $ 85.30 TRAINING $ 2,122 $ 261 $ 1,645 $ 2,894 $ 6,922 5% $ 59.67 Total w/PA Codes No PA Code $ $ 36,984 646 $ $ 30,997 1,791 $ $ 34,349 1,668 $ $ 2,076 2,055 $ $ 7,718 287 $ $ 17,198 813 $ $ 129,322 7,259 95% 5% Total Overtime $ 37,630 $ 32,787 $ 36,018 $ 4,130 $ 8,005 $ 18,011 $ 136,582 100% T�Kwi'�A i Highlights from chart Minimum Staffing 59,323 Fire Prevention 61352 Fire Investigations 51980 Pub Safe Bond 51201 Training 61922 Chart Grand Total $136,582 Report by Jake Berry Fire 2020 1st & 2nd Qrt Overtime i Hours FD 2020 Overtime (Hours) Overtime Project Name -� January February - March - April - May June YTD Total ACADEMY AID RUN 28 7 35 8 28 9 14 4 4 AIRPAK MAINTENANCE/SCBA 6 12 10 CALLBACK 6 4 CITY MEETING 13 1 CONTRACTOR BILLABLE OT 28 20 36 8 16 108 DEPARTMENT MEETING 51 2 5 6 3 66 EXPLORERS 4 4 FIRE INVESTIGATION 4 16 11 9 10 9 58 FIRE PREVENTION OT 39 30 69 INSTRUCTOR 9 13 2 24 INSTRUCTOR - CBT 24 24 INSTRUCTOR - JATC 4 24 28 INSTRUCTOR - RESCUE 12 12 INSTRUCTOR - TRUCK ACADEMY 9 43 52 JATC 5 18 23 MINIMUM STAFFING -'A' SHIFT 150 188 168 48 553 MINIMUM STAFFING -'B' SHIFT 43 96 72 12 24 246 MINIMUM STAFFING -'C' SHIFT 67 3 24 1 2 96 Overtime 106 106 PHONE CALL OT 1 1 1 2 PROGRAM/EQUIPMENT SUPPORT 1 1 PUBLIC SAFETY BOND 6 31 13 1 16 9 74 PUBLIC SAFETY COMMITTEE MEETING 5 5 SHIFT EXTENSION (CALL) 6 5 2 5 5 4 25 SHIFT EXTENSION (REPORT) 3 2 3 1 8 SPECIAL ASSIGNMENT 2 13 15 SPECIAL COMMITTEE MEETING 4 3 3 9 STARFIRE EVENTS/STANDBY 16 8 24 TRAINING 1 35 1 41 1 1 30 148 116 Total Overtime (w/PA) 518 442 476 26 114 264 1,839 T�Kwi'�A Highlights from chart Minimum Staffing 895 hrs Fire Prevention 69 hrs Fire Investigations 58 hrs Pub Safe Bond 74 hrs Training 116 hrs Chart Grand Total 1,839 hrs Report by Jake Berry Fire 2020 1st & 2nd Quarter Revenues ACCT TITLE Total 6 Months FIRE INSPECTIONS -FMO $ 44,213 FIRE PROTECT/EMERG COST RECOVERY $ 13,295 FIRE PROTECTION SERVICES $ 3,165 FIRE REINSPECTION FEE $ 300 KING COUNTY FIRE TRAINING $ 405 OTHER NON -BUS LIC/PERMITS-TECH FEE FIRE $ 3ffi4 FALSE ALARMS-FMO $ 11150 $ 66?392 'T�uKwi'LA Report by Jake Berry Goals For The Year (provisos) �.. 1. 2019 Annual report - RCW 35A.92.030 - Completed � p p 2. Quarterly reports —1St and 2nd completed 3. Mid -year report —This report completes this line 4. Third -party consultant budget and management practices - RFP in process 5. Additional revenues —False Alarm Billing, Ambulance Contract, Fire Marshall Office updated fees 6. To remain within the 2020 adopted budget- On target