Durango Fire Protection District March 2014 Financial Report Comments
Balance Sheet General
- Comparative balance sheet is shown for March 31, 2014; February 28, 2014 ; and March 31, 2013
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/2014 8,123,151 (829,310) $ 7,293,841 $
Cash reserved for capital projects (impact fees)
$
Cash Available for Operating and Capital Expenditures Fund Balance
$ 7,093,841 $ 8,558,055
COLOTRUST - Annual YTD yield
0.12%
- Revenues through March are $5,200 below budget and $23,200 more than 2013. - Average Daily Revenue through March is $6,064, as compared to 2013 YE average of $6,108.
- Unbilled receivables equal 12 days of revenues, up 1 day from February. - Billed receivables equal 83 days of revenues, up 7 days from February. - Ambulance billing write-off % through March is 40%, as compared to 46% for 2013.
- At the end of March we are at 23% of payroll budget, 23% of 2014 pay periods have been expended.
- The value of contributed equipment is reflected at depreciated value on 12/31/2013.
Excess of Revenues Over Expenditures - At the end of March revenues exceed expenditures by
Notes
200,000
- Contractuals and write offs are estimated at 45%. - PRISM collection fees are at 7% of amount collected.
Page 1 of 8
$
244,549
3/31/2013 4,772,656 (605,193) 4,167,462
Durango Fire Protection District Balance Sheet At February 28, 2014
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 Contracting Parties Cash with County Treasurer Other Allowances Prepaids Total Other Current Assets Total Current Assets Equipment 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
31-Mar-14
28-Feb-14
31-Mar-13
250 2,746,091 1,053 105,724 882,480 4,387,553 8,123,151
250 2,306,773 2,244 134,695 882,341 4,387,124 7,713,427
800 1,111,999 (3,370) 32,050 255,254 3,375,922 4,772,656
75,769 504,165 183,362 567,290 (221,779) 155,407 1,264,214 9,387,365 10,580,484 19,967,848
63,295 448,537 823,818 560,653 (210,398) 152,383 1,838,289 9,551,716 10,580,484 20,132,200
124,378 286,246 153,859 220,550 (177,024) 127,749 735,757 5,508,413 6,920,250 12,428,663
55,146 -
114,481 -
(156) -
774,164
800,266
605,349
829,310
914,747
605,193
-
-
829,310
914,747
605,193
10,580,484 200,000
10,580,484 200,000
6,920,250 200,000
8,113,505 244,549 19,138,538
8,113,505 323,463 19,217,452
4,660,786 42,434 11,823,470
19,967,848
20,132,200
12,428,663
-
Total Liabilities Equity Invested in Capital Assets Restricted for Capital Projects Unreserved Undesignated Fund Balance Excess of Revenues over Expenditures, Net Total Equity TOTAL LIABILITIES & EQUITY
Page 2 of 8
Durango Fire Protection District Statement of Revenues Budget and Actual For the Three Months Ended March 31, 2014 Original Budget Local Government Funding Operations City of Durango Animas Fire Protection District Hermosa Cliff Fire Protection District DFPD Property Taxes DFPD SO Taxes DFPD Tribal Payment Total Local Government Operations Funding Volunteer Pension Funding Animas Fire Protection District Hermosa Cliff Fire Protection District State Match Total Volunteer Pension Funding Long Term Capital Replacement Funding Current Year Obligation City of Durango Animas Fire Protection District Hermosa Cliff Fire Protection District Total Capital Funding Other Revenues Ambulance Income Prevention Fees Special Events Fees Wildland Fires Grants Interest Miscellaneous Income Williams Field Contract Total Other Revenues Total Revenues
Amended Budget
Actual March
Actual YTD
Favorable (Unfavorable)
2,975,153 3,077,757 345,000 100,000
2,975,153 3,077,757 345,000 100,000
223,346 166,812 21,555 -
670,038 1,076,213 78,745 -
(2,305,115) -
6,497,910
6,497,910
411,714
1,824,996
(4,672,914)
38,552
38,552
-
-
(38,552)
38,552
38,552
-
-
272,052 -
272,052 -
22,671 -
272,052
272,052
2,204,000 55,000 2,500 175,000 410,406 12,000 87,930 46,000
-
Budget %
23%
2013 March
2013 YTD
35% 23% 0%
237,314 249,464 51,620 -
711,942 748,391 154,859 -
28%
538,397
1,615,192
0%
-
-
(38,552)
0%
-
-
68,013 -
45,342 -
25%
-
-
22,671
68,013
(204,039)
25%
-
-
2,204,000 55,000 2,500 175,000 410,406 12,000 87,930 46,000
198,177 2,854 568 2,120 -
545,805 8,073 1,692 48,262 -
(1,658,195) (46,927) (2,500) (175,000) (410,406) (10,308) (39,668) (46,000)
25% 15% 0% 0% 0% 14% 55% 0%
186,777 3,088 34,419 554 7,577 -
522,635 7,286 107,531 2,180 62,905 43,686
2,992,836
2,992,836
203,719
603,832
(2,389,004)
20%
232,416
746,223
9,801,350
9,801,350
638,103
2,496,841
(7,304,509)
25%
770,813
2,361,415
Page 3 of 8
-
Durango Fire Protection District Expenditures Budget and Actual For the Three Months Ended March 31, 2014 Original Budget 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
Amended Budget
Actual March
Actual YTD
Favorable (Unfavorable)
2013 March
%
2013 YTD
379,102 122,345 182,300 198,812 14,300 12,000 20,000 171,352 1,100,211
379,102 122,345 182,300 198,812 14,300 12,000 20,000 171,352 1,100,211
28,328 10,675 15,815 13,968 433 653 10,753 80,626
86,169 31,302 71,167 61,723 10,224 2,697 29,187 292,470
292,933 91,043 111,133 137,089 4,076 9,303 (9,187) 171,352 807,741
23% 26% 39% 31% 71% 22% 146% 0% 27%
27,835 9,689 18,881 14,558 509 587 72,060
83,438 29,056 29,340 54,084 7,263 1,725 4,880 209,785
93,151 28,198 121,349 1,221,560
93,151 28,198 121,349 1,221,560
7,165 2,170 9,335 89,961
21,496 6,641 28,137 320,607
71,655 21,557 93,212 900,953
23% 24%
6,957 2,262 9,219 81,278
20,870 6,786 27,657 237,442
Page 4 of 8
23% 26%
Durango Fire Protection District Expenditures Budget and Actual For the Three Months Ended March 31, 2014 Original Budget 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
Amended Budget
Actual March
Actual YTD
Favorable (Unfavorable)
2013 March
%
2,410,814 118,450 804,166 15,000 10,600 550 12,700 119,000 132,000 3,623,280
2,410,814 118,450 804,166 15,000 10,600 550 12,700 119,000 132,000 3,623,280
151,411 59,943 902 17,984 230,239
490,366 184,609 1,803 5,274 45,829 727,882
1,920,448 118,450 619,557 13,197 5,326 550 12,700 73,171 132,000 2,895,398
20% 0% 23% 12% 50% 0% 0% 39% 0%
271,502 96,145 2,000 11,200 3,000 383,847
271,502 96,145 2,000 11,200 3,000 383,847
20,755 7,989 250 701 29,696
62,071 23,806 290 1,291 87,458
209,431 72,339 1,710 9,909 3,000 296,389
23% 25% 100%
268,250 96,144 65,000 1,000 31,500 19,150 481,044
268,250 96,144 65,000 1,000 31,500 19,150 481,044
20,405 7,911 329 803 985 30,433
61,050 23,654 7,764 83 3,652 3,729 99,933
207,200 72,490 57,236 917 27,848 15,421 381,111
23% 25% 12% 8% 12% 19%
Page 5 of 8
20%
15% 12% 0% 23%
21%
2013 YTD
166,710 609 63,535 450 662 1,331 3,509 236,807
498,907 1,147 189,763 1,350 7,255 3,525 13,239 44,851 760,035
20,100 7,931 1,166 133 29,328
58,987 23,608 1,406 1,046 85,046
21,560 7,824 8,545 5,684 1,831 45,445
63,010 23,662 24,339 13,720 7,795 132,525
Durango Fire Protection District Expenditures Budget and Actual For the Three Months Ended March 31, 2014 Original Budget 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 Bad debts Totals
Amended Budget
Actual March
Actual YTD
Favorable (Unfavorable)
2,500 11,800 67,300 3,000 30,000 114,600
2,500 11,800 67,300 3,000 30,000 114,600
709 11,065 11,774
3,576 12,381 15,957
2,500 8,224 54,919 3,000 30,000 98,643
193,502 70,276 200 107,000 450 20,808 392,236
193,502 70,276 200 107,000 450 20,808 392,236
14,824 6,049 3,512 310 24,696
44,473 17,820 554 27,216 2,806 92,869
149,029 52,456 (354) 79,784 450 18,002 299,367
1,712,518 606,530 169,800 9,200 2,000 119,665 30,000 991,800 3,641,513
1,712,518 606,530 169,800 9,200 2,000 119,665 30,000 991,800 3,641,513
137,898 50,962 12,173 3,987 83,566 288,587
431,811 153,350 36,585 1,032 542 22,040 216,630 861,989
Page 6 of 8
1,280,707 453,180 133,215 8,168 1,458 97,625 30,000 775,170 2,779,524
2013 March
%
2013 YTD
655 13,112 13,767
1,862 14,312 16,174
24%
14,452 5,729 11,517 1,395 33,092
43,356 17,187 11 31,999 4,984 97,537
25% 25% 22% 11% 27% 18% 0% 22% 24%
135,633 48,407 11,165 1,228 7 8,836 2,626 67,202 275,105
409,937 145,104 33,257 2,675 21 31,841 3,421 200,061 826,318
0% 30% 18% 0% 0% 14% 23% 25% 277% 25% 0% 13%
Durango Fire Protection District Expenditures Budget and Actual For the Three Months Ended March 31, 2014 Original Budget Fire Stations and Buildings Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other Totals Contingency Total Expenditures
Excess (Deficit) of Revenues Over Expenditures
Amended Budget
Actual March
Actual YTD
Favorable (Unfavorable)
139,700 10,900 20,000 170,600 50,000
139,700 10,900 20,000 170,600 50,000
11,406 225 11,632 -
40,830 2,066 2,700 45,596 -
98,870 8,834 17,300 125,004 50,000
10,078,680
10,078,680
717,017
2,252,291
7,826,389
244,549
521,879
(277,330)
(277,330)
(78,914)
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
Page 7 of 8
2013 March
%
29% 19% 14% 27%
22%
2013 YTD
12,352 1,205 13,556 -
35,082 3,109 3,850 42,041 -
728,379
2,197,118
42,434
164,298
Durango Fire and Rescue Authority Expenditures - Totals by Object For the Three Months Ended March 31, 2014 Orginial Budget All Activities and All Functions Salary Benefits Purchased professional services Purchased property services Other purchased services Supplies Capital outlay Other/EMS Adjustments Totals Contingency Total Expenditures
Amended Budget
5,447,289 1,823,804 434,800 478,112 130,800 315,723 235,000 1,163,152 10,028,680
5,447,289 1,823,804 434,800 478,112 130,800 315,723 235,000 1,163,152 10,028,680
50,000
50,000
10,078,680
10,078,680
Actual March
Actual YTD
380,788 145,698 29,219 29,596 12,551 24,846 10,753 83,566 717,017 717,017
Favorable (Unfavorable)
1,197,437 441,183 117,874 139,733 27,090 80,458 31,887 216,630 2,252,291 2,252,291
4,249,852 1,382,621 316,926 338,379 103,710 235,265 203,113 946,522 7,776,389
22% 24% 27% 29% 21% 25% 14% 19% 22%
50,000
0%
7,826,389
22%
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
Page 8 of 8
2013 March
%
2013 YTD
393,856 145,378 39,042 28,620 34,161 17,495 2,626 67,202 728,379 728,379
1,179,651 435,165 88,297 97,874 75,328 63,739 57,002 200,061 2,197,118 2,197,118