Durango Fire Protection District March 2019 Financial Report Comments
Balance Sheet General
- Comparative balance sheet is shown for March 31, 2019; February 28, 2019; and March 31, 2018
Analysis of Cash Position
Return on Cash Balances
Revenues Ambulance
Accounts Receivable Ambulance
Expenditures General Salary costs
Equipment
Cash Current liabilities Actual quick assets
3/31/2018 3/31/2019 3,851,853 4,162,498 (905,044) (989,338) $ 2,946,809 $ 3,173,160
Cash committed for capital projects (Stations 5) Fund Balance - General Fund
$ 200,000 $ 5,119,487
Cash committed for capital projects (Stations 2) Cash committed for other capital expenditures Fund Balance - Capital Projects Fund
$ 1,428,273 $ 5,320,706 $ 6,748,979
Fund Balance - Total
$ 11,868,466
COLOTRUST - Annual YTD yield
- Revenues through March are $127,500 above budget and $172,000 more than 2018. - Average Daily Revenue through March is $11,139, as compared to 2018 YE average of $10,274.
- Billed receivables equal 103 days of revenues, down 8 days from February. - Ambulance billing write-off % through March is 57%, as compared to 57% for 2018.
- At the end of March we are at 25% of payroll budget, 27% of 2019 pay periods have been expended.
- The value of land, buildings, and equipment is reflected at depreciated value on 12/31/2017.
Excess of Revenues Over Expenditures - At the end of March revenues exceed expenditures by
Notes
2.58%
- Contractuals and write offs are estimated at 47%. - Wittman collection fees are at 7% of amount collected.
Page 1 of 9
$ 1,171,479
Durango Fire Protection District General Fund Balance Sheet At March 31, 2019
ASSETS Current Assets Checking/Savings Cash Petty Cash Cash - Checking Flexible Benefits GA Health and Benefit Certificates of Deposit ColoTrust Total Cash Other Current Assets Unbilled Ambulance Revenues A/R - Ambulance Due from Capital Projects Fund Due from Contracting Parties Cash with County Treasurer Other Allowances Prepaids Total Other Current Assets Total Current Assets Capital Assets, net TOTAL ASSETS LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable Prepaid from Contracting Parties Other Current Liabilities Total Current Liabilities Long-Term Liabilities Capital Lease Payable
3/31/2019
2/28/2019
3/31/2018
250 1,577,058 (548) (383,195) 1,006,682 1,651,606 3,851,853
250 687,868 (548) (319,026) 1,006,682 1,647,997 3,023,224
250 1,604,782 279 (49,613) 992,983 1,613,817 4,162,498
1,145,655 356,058 119,856 406,164 22,052 (203,419) 326,311 2,172,678 6,024,532 6,266,151 12,290,683
1,115,749 90,910 1,307,725 19,466 (224,577) 553,682 2,862,955 5,886,179 6,266,151 12,152,330
1,059,881 121,311 454,597 205,735 (338,465) 200,164 1,703,224 5,865,722 6,843,474 12,709,196
246,689 -
226,638 -
89,662 -
658,355
557,390
899,677
905,044
784,027
989,338
-
-
905,044
784,027
989,338
6,266,151 200,000
6,266,151 200,000
6,843,474 200,000
3,748,008 1,171,479 11,385,638
3,477,560 1,424,591 11,368,302
3,442,299 1,234,084 11,719,857
12,290,683
12,152,330
12,709,196
-
Total Liabilities Equity Invested in Capital Assets Committed for Capital Projects Unreserved Undesignated Fund Balance Excess of Revenues over Expenditures, Net Total Equity TOTAL LIABILITIES & EQUITY
Page 2 of 9
Total Revenues
Total Other Revenues
Other Revenues Ambulance Income IFT Transport Income Prevention Fees Special Events Fees Wildland Fires Grants Interest Miscellaneous Income Williams Field Contract
Total Capital Funding
Long Term Capital Replacement Funding Current Year Obligation City of Durango
Total Local Government Operations Funding
Local Government Funding Operations City of Durango DFPD Property Taxes DFPD SO Taxes DFPD Tribal Payment DFPD Other Property Taxes
Durango Fire Protection District General Fund Statement of Revenues Budget and Actual For the Three Months Ended March 31, 2019
14,499,002
4,282,700
3,500,000 259,200 75,000 300,000 6,000 45,000 46,500 51,000
-
-
10,216,302
4,568,791 4,632,511 920,000 45,000 50,000
Original Budget
14,499,002
4,282,700
3,500,000 259,200 75,000 300,000 6,000 45,000 46,500 51,000
-
-
10,216,302
4,568,791 4,632,511 920,000 45,000 50,000
Amended Budget
Page 3 of 9
1,176,368
350,660
323,818 19,712 3,511 3,609 10 -
-
-
825,707
378,883 388,300 58,524 -
Actual March
4,263,076
1,151,226
1,002,533 93,412 19,848 13,943 21,491 -
-
-
3,111,850
1,136,650 1,734,219 240,981 -
Actual YTD
(10,235,926)
(3,131,474)
(2,497,467) (165,788) (55,152) (300,000) (6,000) (31,057) (25,009) (51,000)
-
-
(7,104,452)
(3,432,141) (2,898,292) (679,019) (45,000) (50,000)
Favorable (Unfavorable)
29%
27%
29% 36% 26% 0% 0% 0% 31% 46% 0%
0%
0%
30%
25% 37% 26% 0% 0%
Budget %
1,306,597
430,500
297,450 5,147 75,314 2,326 82 50,182
-
-
876,097
375,434 433,990 66,672 -
2018 March
4,204,014
975,466
830,536 11,555 1,076 75,364 6,470 283 50,182
-
-
3,228,548
1,126,303 1,869,572 232,183 491
2018 YTD
Administration Office of the Chief Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other/Pension Totals Operations Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other Totals Total Administration
Durango Fire Protection District General Fund Expenditures Budget and Actual For the Three Months Ended March 31, 2019
419,488 120,708 363,530 282,200 17,000 19,850 162,215 1,384,991 176,752 49,678 226,430 1,611,421
176,752 49,678 226,430 1,611,421
Amended Budget
419,488 120,708 363,530 282,200 17,000 19,850 162,215 1,384,991
Original Budget
Page 4 of 9
20,395 4,526 24,922 124,676
54,820 13,029 19,325 12,224 217 139 99,755
Actual March
47,589 12,542 60,131 355,916
128,020 36,012 83,227 40,484 6,935 1,107 295,786
Actual YTD
129,163 37,136 166,299 1,255,505
291,468 84,696 280,303 241,716 10,065 18,743 162,215 1,089,205
Favorable (Unfavorable) %
27% 22%
27% 25%
31% 30% 23% 14% 41% 6% 0% 0% 21% 19,528 4,519 24,047 138,175
51,072 12,427 32,560 15,670 340 2,058 114,128
2018 March
45,167 11,912 57,079 364,527
112,085 32,443 90,207 54,517 10,323 7,873 307,448
2018 YTD
Fire Fighting Salary Salary - Single resource Benefits Purchased professional services Purchased property services Other purchased services Single resource purchased services Supplies Capital outlay Other Totals Fire Prevention Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other Totals Fire Training Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other Totals
Durango Fire Protection District General Fund Expenditures Budget and Actual For the Three Months Ended March 31, 2019
2,892,206 212,180 901,871 22,000 15,000 750 25,000 280,500 4,349,507 405,389 129,245 2,800 13,000 550,434 333,497 96,287 56,500 30,400 28,900 545,584
405,389 129,245 2,800 13,000 550,434 333,497 96,287 56,500 30,400 28,900 545,584
Amended Budget
2,892,206 212,180 901,871 22,000 15,000 750 25,000 280,500 4,349,507
Original Budget
Page 5 of 9
28,453 7,431 13,207 1,038 377 50,507
40,661 9,999 949 51,609
308,531 70,619 760 426 4,490 384,826
Actual March
73,695 22,548 20,892 6,038 1,873 125,045
94,141 28,145 50 1,726 124,062
748,821 206,408 1,309 3,691 426 16,352 977,006
Actual YTD
259,802 73,739 35,608 24,362 27,027 420,539
311,248 101,100 2,750 11,274 426,372
2,143,385 212,180 695,463 20,691 11,309 324 25,000 264,148 3,372,501
Favorable (Unfavorable) %
23%
22% 23% 37% 0% 20% 6% 0%
23%
23% 22% 0% 0% 2% 13% 0%
22%
26% 0% 23% 6% 25% 57% 0% 6% 0%
37,781 8,747 2,284 6,157 691 55,659
39,015 10,124 100 501 49,740
264,558 1,276 69,102 3,493 404 12,625 351,459
2018 March
87,794 23,256 11,002 7,489 3,330 132,871
90,616 27,089 320 819 118,844
613,048 44,492 192,500 4,555 3,413 23,580 81,226 962,815
2018 YTD
Fire Communications Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other Totals Fire Repair Services Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other Totals EMS Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay CMS contractual agreements Bad debts Totals
Durango Fire Protection District General Fund Expenditures Budget and Actual For the Three Months Ended March 31, 2019
500 14,700 90,500 31,000 136,700 219,220 66,912 150,000 400 10,700 447,232 2,475,994 731,268 201,000 6,000 27,550 141,950 1,302,000 365,362 5,251,124
219,220 66,912 150,000 400 10,700 447,232 2,475,994 731,268 201,000 6,000 27,550 141,950 1,302,000 365,362 5,251,124
Amended Budget
500 14,700 90,500 31,000 136,700
Original Budget 208 208
Page 6 of 9
267,454 60,149 12,918 389 5,919 120,460 32,382 499,672
25,295 6,072 5,076 602 37,044
Actual March
638,783 170,432 36,787 3,539 1,668 23,234 384,236 103,289 1,361,969
59,021 17,531 20,260 2,862 99,674
2,424 100 2,524
Actual YTD
1,837,211 560,836 164,213 2,461 25,882 118,716 917,764 262,073 3,889,155
160,199 49,381 129,740 400 7,838 347,558
500 12,276 90,400 31,000 134,176
Favorable (Unfavorable) %
26% 23% 18% 59% 6% 16% 0% 30% 28% 26%
22%
27% 26% 0% 14% 0% 27% 0%
2%
0% 16% 0% 0% 0%
213,355 55,612 12,208 282 733 10,510 148,631 29,745 471,076
25,158 6,287 10,178 961 42,585
208 19,553 19,761
2018 March
524,120 154,060 36,028 282 733 24,721 402,898 83,054 1,225,896
58,458 16,673 24,160 1,966 101,257
2,424 19,653 109 22,185
2018 YTD
1,200,000 14,499,002
Transfer to Capital Projects Fund
Total Expenditures -
14,499,002
1,200,000
1,200,000
13,299,002
164,000 43,000 207,000 200,000
Amended Budget
17,336
1,159,031
-
17,336
1,159,031
9,227 1,262 10,489 -
Actual March
1,171,479
3,091,597
-
1,171,479
3,091,597
41,181 4,220 45,401 -
Actual YTD
(1,228,521)
11,407,405
1,200,000
(28,521)
10,207,405
122,819 38,780 161,599 200,000
Favorable (Unfavorable)
Page 7 of 9
Purchased Prof Service: Legal, audit, emp wellness program, emp. assistance program, training costs, class fees, outside repairs, EMS billing, Purchased Prop Service: Utilities, phones, cell phones, insurance, software licenses, rental, repairs and maintenance, Other Purch Service: Dues and memberships, postage, freight, advertising, printing, copying, travel and training per diem, dispatch fees, Supplies: Uniforms, office supplies, fuel, general and safety supplies, publications, small tools, cleaning, kitchen and garage supplies
-
1,200,000
Excess (Deficit) of Revenues Over Expenditures
Net Income
13,299,002
164,000 43,000 207,000 200,000
Original Budget
Total Operating Expenditures
Fire Stations and Buildings Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other Totals Contingency
Durango Fire Protection District General Fund Expenditures Budget and Actual For the Three Months Ended March 31, 2019 %
0%
23%
22%
25% 0% 10% 0%
166,408
1,140,190
-
166,408
1,140,190
10,810 925 11,735 -
2018 March
1,234,084
2,969,931
-
1,234,084
2,969,931
38,186 3,351 41,536 -
2018 YTD
13,299,002
200,000
7,134,726 2,095,969 643,530 631,900 194,400 568,900 1,829,577 13,099,002
Orginial Budget
13,299,002
200,000
7,134,726 2,095,969 643,530 631,900 194,400 568,900 1,829,577 13,099,002
Amended Budget
1,159,031
-
745,609 171,826 45,450 27,496 2,070 13,739 152,842 1,159,031
Actual March
3,091,597
-
1,790,069 493,617 142,214 111,580 15,217 51,374 487,525 3,091,597
Actual YTD
10,207,405
200,000
5,344,657 1,602,352 501,316 520,320 179,183 517,526 1,342,052 10,007,405
Favorable (Unfavorable)
Page 8 of 9
Purchased Prof Service: Legal, audit, emp wellness program, emp. assistance program, training costs, class fees, outside repairs, EMS billing, Purchased Prop Service: Utilities, phones, cell phones, insurance, software licenses, rental, repairs and maintenance, Other Purch Service: Dues and memberships, postage, freight, advertising, printing, copying, travel and training per diem, dispatch fees, Supplies: Uniforms, office supplies, fuel, general and safety supplies, publications, small tools, cleaning, kitchen and garage supplies
Total Expenditures
Contingency
All Activities and All Functions Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other/EMS Adjustments Totals
Durango Fire and Rescue Authority General Fund Expenditures - Totals by Object For the Three Months Ended March 31, 2019 %
23%
0%
25% 24% 22% 18% 8% 9% 0% 27% 24%
1,140,190
-
651,744 166,820 50,545 37,551 26,883 28,272 178,376 1,140,190
2018 March
2,969,931
-
1,575,780 457,933 141,792 122,981 62,098 123,395 485,952 2,969,931
2018 YTD
Durango Fire Protection District Capital Projects Fund Balance Sheet At March 31, 2019 3/31/2019 ASSETS Current Assets Checking/Savings ColoTrust Total Checking/Savings Other Current Assets Due from General Fund Total Other Current Assets
6,878,674 6,878,674 -
Total Current Assets
6,878,674
TOTAL ASSETS
6,878,674
LIABILITIES & EQUITY Liabilities Current Liabilities Payable to General Fund Total Current Liabilities
356,058 356,058
Total Liabilities Equity Committed for Capital Projects Total Equity
356,058 6,748,979 6,748,979
TOTAL LIABILITIES & EQUITY
7,105,037
Durango Fire Protection District Capital Projects Fund Statement of Revenues Budget and Actual For the Three Months Ended March 31, 2019 Original Budget Income/Expenses Income Transfer from General Fund Capital Contribution from City of Durango Development fees Capital Grants Sale of assets Interest Total Income Expense Capital equipment Training site construction expense Station 3 construction expense Total Expenses Net Income
Amended Budget
Actual March
Actual YTD
Favorable (Unfavorable)
Budget %
1,200,000 272,052 100,000 135,000 100,000 1,807,052
1,200,000 272,052 100,000 100,000 1,672,052
22,671 2,396 15,030 40,097
68,013 8,111 43,765 119,889
(1,200,000) (204,039) (91,889) (56,235) (1,552,163)
0% 25% 8%
2,020,000 150,000 2,800,000 4,970,000
2,020,000 150,000 2,800,000 4,970,000
266,461 266,461
495,188 495,188
(2,020,000) (150,000) (2,304,812) (4,474,812)
0% 0% 0% 10%
(3,162,948)
(3,297,948)
(226,364)
(375,299)
2,922,649
11%
Page 9 of 9
0% 0% 7%