Loading...
HomeMy WebLinkAboutFIN 2020-05-28 Item 1C - Handout to be Distributed at Meeting - 2020 1st Quarter Budget Report - Fire Department Forecast Versus BudgetFire's 2020 Forecast vs Budget YTD Actuals Updated May 21st 2020 Jan -April % Budget Regular Salaries & Wages $ 2,650,915 34.6% Extra Labor $ - - Total Overtime $ 110,565 20.7°% Holiday Pay $ - 0.0% TOTAL SALARIES & WAGES $ 2,761,480 32.5% FICA $ 46,772 22.4% Pension - LEOFF $ 138,520 31.0% Pension - PERS $ 11,260 22.0% Industrial Insurance $ 129,282 30.6°% Medical, Dental, Life, Optical $ 551,274 35.6°% VEBA6 RMP $ 9,600 N/A PERSONNEL BENEFITS $ 886,709 33.1% TOTAL SALARY & BENEFITS $ 3,648,189 32.6% Jan -March Office & Operating Supplies $ 29,641 14.3% Small Tools & Minor Equipment $ 26,898 30.8% SUPPLIES & SMALL TOOLS $ 56,539 19.2% Professional Services $ 32,714 40.4% Dispatching Services - Dispatching $ 38,218 17.2% Communication $ 8,620 26.8% Travel $ 468 6.7% Operating Rentals & Leases - Non Fleet $ 1,472 38.7% Operating Rentals & Leases - Fleet $ 162,588 25.0% Insurance (WCIA) $ 173,213 86.6% Public Utility $ 35,354 48.2% Repairs & Maintainance $ 16,121 43.7% Miscellaneous $ 22,517 15.7% SERVICES $ 491,285 33.9% Capital Purchases (Machinery & Equipment) $ 0.0% TOTAL OPERATING EXPENSES $ 547,824 28.2% GRAND TOTAL $ 4,196,013 32.0% Full Year Forecasts Forecast Budget $ 7,908,506 $ 7,666,823 $ 5,508 $ - $ 222,365 $ 534,648 $ 257,000 $ 295,454 $ 8,393,379 $ 8,496,925 $ 150,361 $ 208,956 $ 480,495 $ 446,274 $ 43,360 $ 51,129 $ 353,125 $ 422,619 $ 1,586,015 $ 1,548,497 $ 33,000 $ - $ 2,646,356 $ 2,677,475 $ 11,039,735 $ 11,174,400 $ 173,641 $ 206,877 $ 42,398 $ 87,268 $ 216,039 $ 294,145 $ 126,414 $ 81,000 $ 229,310 $ 221,945 $ 31,840 $ 32,170 $ 2,718 $ 7,000 $ 8,832 $ 3,800 $ 596,155 $ 650,351 $ 173,213 $ 199,922 $ 102,854 $ 73,360 $ 57,521 $ 36,921 $ 148,199 $ 143,874 $ 1,477,055 $ 1,450,343 $ - $ 200,000 $ 1,693,094 $ 1,944,488 $ 12,732,829 $ 13,118,888 Forecasted Variance from Budget Over/(Under) Deviation % $ 241,683 3.2% $ 5,508 - $ (312,283) -58.4% $ (38,454) -13% $ (103,546) -1% $ (58,595) -28% $ 34,221 8% $ (7,769) -15% $ (69,494) -16% $ 37,518 2% $ 33,000 - $ (31,119) -1.2% $ (134,665) -1.2% $ (33,236) -16% $ (44,870) -51% $ (78,106) -27% $ 45,414 56% $ 7,365 3% $ (330) -1% $ (4,282) -61% $ 5,032 132% $ (54,196) -8% $ (26,709) -13% $ 29,494 40% $ 20,600 56% $ 4,325 3% $ 26,712 2% (200,000) -100% $ (251,394) -12.9% $ (386,059) -2.9% 2020 Fire Department Forecasted Expenditures Updated May 21st 2020 January February March April May June July August September October November December E[2020] 2020 Budget Over (Under) Regular Salaries & Wages $676,801 $678,986 $646,658 $648,470 $656,549 $669,154 $639,638 $640,536 $647,874 $648,629 $649,719 $705,4914 $ 7,908,506 $ 7,666,823 $ 241,683 Extra Labor $ - $ - $ - $ - $ - $ - $ 2,358 $ 3,150 $ - $ - $ - $ - $ 5,508 $ - $ 5,508 Min Staffing OT $ 18,120 $ 18,414 $ 17,411 $ 84 $ 1,800 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 76,829 N/A N/A All Other OT $ 19,510 $ 14,373 $ 18,607 $ 4,046 $ 8,000 $ 9,000 $ 12,000 $ 12,000 $ 12,000 $ 12,000 $ 12,000 $ 12,000 $ 145,536 N/A N/A Total Overtime $ 37,630 $ 32,787 $ 36,018 $ 4,130 $ 9,800 $ 12,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 222,365 $ 534,648 $ (312,283) Holiday Pay $ - $ - $ - $ - $ - $ 7,000 $ - $ - $ - $ - $ 250,000 $ - $ 257,000 $ 295,454 $ (38,454) TOTAL SALARIES & WAGES $714,431 $711,773 $682,676 $652,600 $ 666,349 $ 688,154 $ 656,996 $ 658,686 $ 662,874 $ 663,629 $ 914,719 $ 720,494 $ 8,393,379 $ 8,496,925 $ (103,546) FICA $ 12,096 $ 12,027 $ 11,597 $ 11,053 $ 12,671 $ 13,095 $ 12,884 $ 12,870 $ 12,742 $ 12,127 $ 14,429 $ 12,770 $ 150,361 $ 208,956 $ (58,595) Pension - LEOFF $ 34,826 $ 35,008 $ 35,473 $ 33,214 $ 36,468 $ 36,562 $ 36,891 $ 36,301 $ 53,724 $ 32,953 $ 48,739 $ 60,337 $ 480,49S $ 446,274 $ 34,221 Pension - PERS $ 2,964 $ 2,853 $ 2,834 $ 2,610 $ 4,130 $ 4,145 $ 4,670 $ 4,347 $ 3,534 $ 3,478 $ 3,830 $ 3,966 $ 43,360 $ 51,129 $ (7,769) Industrial Insurance $ 32,872 $ 31,437 $ 32,637 $ 32,337 $ 29,441 $ 26,469 $ 27,745 $ 28,697 $ 26,947 $ 26,940 $ 26,417 $ 31,188 $ 353,12S $ 422,619 $ (69,494) Medical, Dental, Life, Optical $ 136,444 $ 138,328 $ 138,251 $ 138,250 $ 136,789 $ 133,273 $ 134,575 $ 133,693 $ 114,559 $ 118,588 $ 131,458 $ 131,805 $ 1,586,015 $ 1,548,497 $ 37,518 VEBA6 RMP $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 33,000 $ - $ - PERSONNEL BENEFITS $ 221,602 $ 222,052 $ 223,192 $ 219,863 $ 221,899 $ 216,545 $ 219,765 $ 218,907 $ 214,505 $ 197,086 $ 227,873 $ 243,067 $ 2,646,356 $ 2,677,475 $ (31,119) TOTAL SALARY & BENEFITS $936,033 $ 933,825 $ 905,868 $ 872,463 $ 888,248 $ 904,698 $ 876,760 $ 877,593 $ 877,378 $ 860,715 $ 1,142,592 $ 963,561 $ 11,039,735 $ 11,174,400 $ (134,665) Office & Operating Supplies $ 11,744 $ 3,778 $ 14,119 $ 6,000 $ 12,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 173,641 $ 206,877 $ (33,236) Small Tools & Minor Equipment $ - $ 4,750 $ 22,148 $ 500 $ 1,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 42,398 $ 87,268 $ (44,870) SUPPLIES & SMALL TOOLS $ 11,744 $ 8,529 $ 36,267 $ 6,500 $ 13,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 216,039 $ 294,145 $ (78,106) Professional Services $ 4,596 $ 11,276 $ 16,842 $ 4,500 $ 17,000 $ 35,000 $ 6,200 $ 6,200 $ 6,200 $ 6,200 $ 6,200 $ 6,200 $ 126,414 $ 81,000 $ 45,414 Dispatching Services - Dispatching $ - $ 38,218 $ - $ 38,218 $ - $ 38,218 $ - $ 38,218 $ - $ 38,218 $ - $ 38,218 $ 229,310 $ 221,945 $ 7,365 Communication $ 3,204 $ 2,770 $ 2,645 $ 2,580 $ 2,580 $ 2,580 $ 2,580 $ 2,580 $ 2,580 $ 2,580 $ 2,580 $ 2,580 $ 31,840 $ 32,170 $ (330) Travel $ 67 $ - $ 400 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 2,718 $ 7,000 $ (4,282) Operating Rentals & Leases - Non Fleet $ 736 $ - $ 736 $ 1,472 $ 736 $ 736 $ 736 $ 736 $ 736 $ 736 $ 736 $ 736 $ 8,832 $ 3,800 $ 5,032 Operating Rentals & Leases - Fleet $ 54,196 $ 54,196 $ 54,196 $ 54,196 $ 54,196 $ 54,196 $ 54,196 $ 54,196 $ 54,196 $ 54,196 $ 54,196 $ 596,155 $ 650,351 $ (54,196) Insurance (WCIA) $ 173,213 $ - $ - $ - $ - $ - $ $ - $ - $ - $ - $ - $ 173,213 $ 199,922 $ (26,709) Public Utility $ 20,164 $ 7,715 $ 7,476 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 102,854 $ 73,360 $ 29,494 Repairs & Maintainance $ 13,259 $ 1,391 $ 1,470 $ 3,000 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 57,521 $ 36,921 $ 20,600 Miscellaneous $ 9,877 $ 7,289 $ 5,351 $ 7,500 $ 7,800 $ 17,174 $ 10,028 $ 9,908 $ 32,126 $ 22,417 $ 10,416 $ 8,313 $ 148,199 $ 143,874 $ 4,325 SERVICES $ 279,312 $ 122,856 $ 89,116 $ 119,216 $ 94,862 $ 160,454 $ 32,094 $ 124,388 $ 108,388 $ 136,897 $ 86,678 $ 122,794 $ 1,477,055 $ 1,450,343 $ 26,712 Capital Purchases (Machinery & Equipment) $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 200,000 $ (200,000) TOTAL OPERATING EXPENSES $ 291,056 $ 131,385 $ 125,382 $ 125,716 $ 107,862 $ 180,454 $ 52,094 $ 144,388 $ 128,388 $ 156,897 $ 106,678 $ 142,794 $ 1,693,094 $ 1,944,488 $ (251,394) GRAND TOTAL $1,227,089 $ 1,065,211 $ 1,031,250 $ 998,179 $ 996,110 $ 1,085,152 $ 928,854 $ 1,021,981 $ 1,005,767 $ 1,017,612 $ 1,249,270 $ 1,106,355 1 $ 12,732,829 $ 13,118,888 $ (386,059)