0.7%. (515). $. Repair and Maintenance Supplies ..... $1,885 paid to McGrath Refrigeration for annual HVAC maintenance c
CUTPL Financial Summary (Dec 2014) Bank Summary First Farmers Bank & Trust First National Bank of Monterey First Farmers Bank & Trust First Farmers Bank & Trust First Farmers Bank & Trust
Bank Number
Ending Balance
5 7 8 9 10
$ 43,304 $ 694,858 $ ‐ $ 3,537 $ 15,833
TOTAL ALL BANKS
$ 757,532
$ 536,551 $ 479,391
$ 57,160 $ 509,123
Ending Balance 8.1 $ 317,428
$ 40,000 $ (13,844)
$ 53,844 $ ‐
##
$ 78,486
$ 199,000 $ 199,000
$ ‐
##
$ 100,002
$99,500+
$ 40,000 $ 30,715
$ 9,285 $ ‐
##
$ 103,347
$100,000+
2014 Appropriation
Funds Operating Fund LIRF Debt Services Rainy Day Gift and Grant Funds2 3 Misc TOTAL ALL FUNDS
Operating Fund
YTD
Unexpended Balance
Disbursemnts1
YTD Receipts1
$ 196,049
Target 6 months operation $100,000+
$ 13,732
$ 11,287
##
$ 157,967
$100,000+
$ 28,318
$ 28,399
##
$ 303
zero+
$ 737,313
$ 744,858
Dec Projection
Dec
Difference
YTD
$ 757,532
%
YTD Projection
%
Difference
RECEIPTS Tax Receipts Other Receipts
$ 141,653 $ 150,570 $ (8,917) $ 476,223 $ 843 $ 1,033 $ (190) $ 32,900 TOTAL RECEIPTS $ 142,496 $ 151,604 $ (9,107) $ 509,123
93.5% 6.5% 100.0%
$ 478,838 $ 15,000 $ 493,838
97.0% 3.0% 100.0%
$ (2,615) $ 17,900 $ 15,285
EXPENDITURES Personal Services Supplies Other Services and Charges Capital Outlays
$ 27,859 $ 488 $ 6,244 $ 3,230 TOTAL EXPENDITURES $ 37,821
$ 24,606 $ 725 $ 6,838 $ 2,800 $ 34,969
$ 3,252 $ (237) $ (594) $ 430 $ 2,851
$ 329,169 $ 6,876 $ 102,672 $ 40,674 $ 479,391
Adjustments (see Notes page)
$ (24,972)
ENDING BALANCE
$ 317,428
Material Expenditures
$ 3,104
$ 2,675
$ 429
$ 42,216
68.7% 1.4% 21.4% 8.5% 100.0%
$ 318,050 $ 8,700 $ 108,826 $ 37,320 $ 472,897
67.3% 1.8% 23.0% 7.9% 100.0%
$ 308,660 8.8%
$ 40,955
$ 11,119 $ (1,824) $ (6,154) $ 3,354 $ 6,495 $ 8,768
8.7%
$ 1,261
Financial Targets Operating Fund (number of months balance is sufficient to cover) Materials Expenditures (YTD as percent of Operating Expenditures) Personal Services (YTD as percent of Operating Expenditures)4
6 mos. operation Jan & Jul 1st 4
8.1
7.5% minimum by end of year
8.8%
67.5% maximum
68.7%
Notes Transfers YTD between Operating Fund bank accounts
$ 525,000.00
Notes: 1
Does not include transfers within funds
2
Includes all Gift & Grant Funds (500‐599 in Chart of Accounts)
3 Includes Levy Excess (010), Payroll (200), PLAC (800) and Pass‐Through (810) 4
Transfers to LIRF are excluded in calculation
1/17/2015 3:49 PM
Page 1 of 4
CUTPL 2014 Operating Fund: Working Budget 2014 Operating Fund
Dec
◄
YTD
%
YTD Projection
58.2%
$ 293,654 $ 60 $ 132,494 $ 33,422 $ 16,773 $ 2,435 $ 3,300 $ 6,400 $ 2,700 $ 2,600 $ ‐ $ 493,838
Dec Projection
Difference
$ 126,271 $ 30 $ 11,041 $ 2,785 $ 9,225 $ 1,218 $ 275 $ 533 $ 225 $ ‐ $ ‐ $ 151,604
$ (6,266) $ (3) $ 0 $ 0 $ (2,130) $ (519) $ (173) $ 62 $ (80) $ ‐ $ ‐ $ (9,107)
Dec Projection
Difference
$ 3,496 $ 15,473 $ 5,638 $ 1,451 $ 1,334 $ 2,645 $ 83 $ 125 $ 24,606
$ ‐ $ 1,045 $ 2,207 $ 80 $ 0 $ 2,335 $ (83) $ (125) $ 3,252
$ 250 $ 292 $ ‐ $ 183 $ 725
$ (81) $ (69) $ ‐ $ (87) $ (237)
$ 2,429 $ 2,985 $ ‐ $ 1,462 $ 6,876
0.5%
$ 620 $ 83 $ 218 $ 250 $ ‐ $ ‐ $ ‐ $ 33 $ 35 $ 17 $ 17 $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 3,878 $ 3,545 $ 233 $ 100
$ (415) $ 16,752 $ (83) $ ‐ $ (46) $ 2,979 $ (250) $ 480 $ ‐ $ ‐ $ ‐ $ 5,667 $ ‐ $ 7,033 $ (15) $ 322 $ (19) $ 270 $ (17) $ 75 $ (17) $ 75 $ ‐ $ ‐ $ ‐ $ 9,448 $ ‐ $ 1,599 $ ‐ $ 7,162 $ ‐ $ 687 $ (827) ◄ $ 40,381 $ (895) ◄ $ 36,598 $ (9) $ 2,756 $ 77 $ 1,027
3.5%
%
Difference
◄
see Notes
RECEIPTS General Property Taxes Financial Institution Tax CAGIT Certified Shares CAGIT PTRC Auto and Aircraft Excise Tax CVET Photocopy Fees Fines & Fees Interest Earned Refunds / Reimbursements Miscellaneous
$ 120,006 $ 27 $ 11,041 $ 2,785 $ 7,095 $ 699 $ 102 $ 596 $ 145 $ ‐ $ ‐ TOTAL RECEIPTS $ 142,496
2014 Operating Fund
Dec
◄ $ 296,151 $ 57 $ 132,495 $ 33,423 ◄ $ 12,699 ◄ $ 1,399 $ 2,943 $ 6,669 $ 1,966 $ 20,826 $ 496 ◄ $ 509,123 ◄
YTD
0.0% 26.0% 6.6% 2.5% 0.3% 0.6% 1.3% 0.4% 4.1% 0.1% 100.0%
%
YTD Projection
59.5% 0.0% 26.8% 6.8% 3.4% 0.5% 0.7% 1.3% 0.5% 0.5% 0.0% 100.0%
%
$ 2,497 $ (3) $ 1 $ 1 $ (4,074) $ (1,036) $ (357) $ 269 $ (734) $ 18,226 $ 496 $ 15,285 Difference
◄ 10
◄ 11 ◄ 12
◄ ◄7 ◄ ◄
see Notes
EXPENDITURES 100 PERSONAL SERVICES Salary of Librarian Salary of Assistants Employee Benefits
$ 3,496 $ 16,518 $ 7,845 FICA (Employer's Share) $ 1,531 PERF (Employer's Share) $ 1,334 Group Insurance (Employer's Share) $ 4,980 Unemployment Compensation $ ‐ Education Reimbursement $ ‐ TOTAL PERSONAL SERVICES $ 27,859
200 SUPPLIES Office Supplies Operating Supplies Repair and Maintenance Supplies Other Supplies
$ 169 $ 222 $ ‐ $ 97 TOTAL SUPPLIES $ 488
◄ ◄
◄
◄
$ 45,361 $ 218,121 $ 65,687 $ 20,142 $ 16,829 $ 28,716 $ ‐ $ ‐ $ 329,169
9.5% 45.5% 13.7% 4.2% 3.5% 6.0% 0.0% 0.0% 68.7%
0.6% 0.0% 0.3% 1.4%
$ 45,361 $ 203,893 $ 68,796 $ 19,068 $ 17,083 $ 30,145 $ 1,000 $ 1,500 $ 318,050
9.6% 43.1% 14.5% 4.0% 3.6% 6.4% 0.2% 0.3% 67.3%
$ 3,000 $ 3,500 $ ‐ $ 2,200 $ 8,700
0.6%
$ 19,293 $ 1,000 $ 3,091 $ 750 $ 1,000 $ 5,135 $ 7,497 $ 400 $ 420 $ 200 $ 200 $ ‐ $ 10,550 $ 1,550 $ 8,000 $ 1,000 $ 42,000 $ 38,000 $ 2,800 $ 1,200
4.1%
0.7% 0.0% 0.5% 1.8%
$ ‐ $ 14,228 ◄ $ (3,109) ◄ $ 1,074 $ (254) $ (1,429) 2, 20 $ (1,000) $ (1,500) $ 11,119 ◄ 1, 14 $ (571) $ (515) $ ‐ $ (738) $ (1,824)
300 OTHER SERVICES AND CHGS Professional Services Legal Payroll E‐Rate Filing Computer Support Computer DB &Software (Materials) Computer DB &Software (Other) Debt Collection Misc Professional Services
Printing and Advertising Advertising and Publication of Notices Other Printing
Insurance Official Bonds Property‐Liability Worker's Compensation
Utilities Gas & Electricity Water Waste Disposal Services
1/17/2015 3:49 PM
$ 205 $ ‐ $ 172 $ ‐ $ ‐ $ ‐ $ ‐ $ 18 $ 16 $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 3,051 $ 2,649 $ 224 $ 177
0.0% 0.6% 0.1% 0.0% 1.2% 1.5% 0.1% 0.1% 0.0% 0.0% 0.0% 2.0% 0.3% 1.5% 0.1% 8.4% 7.6% 0.6% 0.2%
0.2% 0.7% 0.2% 0.2% 1.1% 1.6% 0.1% 0.1% 0.0% 0.0% 0.0% 2.2% 0.3% 1.7% 0.2% 8.9% 8.0% 0.6% 0.3%
$ (2,542) $ (1,000) $ (112) $ (270) $ (1,000) $ 532 $ (464) $ (78) $ (150) $ (125) $ (125) $ ‐ $ (1,102) $ 49 $ (838) $ (313) $ (1,619) $ (1,402) $ (44) $ (173)
5, 19 3, 18
13 9
Page 2 of 4
CUTPL 2014 Operating Fund: Working Budget 2014 Operating Fund
Dec
Repairs and Maintenance
$ 2,650 $ 2,567 Cleaning Service Misc $ ‐ Elevator (Service Contract) $ ‐ Elevator Misc $ ‐ Fire Monitoring $ ‐ HVAC (Service Contract) $ ‐ HVAC Misc $ ‐ Pest Control $ 50 Snow Removal $ ‐ Misc R&M Building $ 12 Misc R&M Equipment $ 21 Rentals $ ‐ Dues $ ‐ Communication and Transportation $ 339 Telephone $ 202 Postage $ ‐ Travel Expense $ 137 Professional Meetings $ ‐ Internet Access $ ‐ Misc Comm and Trans $ ‐ TOTAL OTHER SVCS AND CHGS $ 6,244 Cleaning Service (Interior)
400 CAPITAL OUTLAYS Furniture & Equipment Books Periodicals
Dec Projection
Difference
◄
YTD
$ 1,642 $ 1,050 $ ‐ $ ‐ $ 83 $ ‐ $ ‐ $ 83 $ 50 $ 100 $ 250 $ 25 $ 4 $ ‐ $ 678 $ 242 $ 30 $ 100 $ 125 $ 181 $ ‐ $ 6,838
$ 1,008 ◄ $ 28,097 $ 1,517 ◄ $ 14,450 $ ‐ $ ‐ $ ‐ $ 779 $ (83) $ 2,101 $ ‐ $ 1,153 $ ‐ $ 1,886 $ (83) $ 739 $ ‐ $ 1,295 $ (100) $ 2,615 $ (238) $ 2,933 $ (4) $ 147 $ (4) $ 20 $ ‐ $ 921 $ (339) $ 6,979 $ (40) $ 2,641 $ (30) $ 196 $ 37 $ 1,053 $ (125) $ 1,095 $ (181) $ 1,993 $ ‐ $ ‐ $ (594) $ 102,672
$ 125 $ 1,750 $ 50 $ ‐ $ ‐ $ 50 $ 875 $ 875 $ ‐ $ 2,800
$ 1 $ (26) $ 96 $ ‐ $ 146 $ (50) $ 360 $ 360 $ ‐ $ 430
% 5.9% 3.0% 0.0% 0.2% 0.4% 0.2% 0.4% 0.2% 0.3% 0.5% 0.6% 0.0% 0.0% 0.2% 1.5% 0.6% 0.0% 0.2% 0.2% 0.4% 0.0% 21.4%
$ 4,125 $ 20,482 $ 3,979 $ 2,751 $ 937 $ 291 $ 12,088 $ 11,861 $ 227 $ 40,674
0.9%
TOTAL EXPENDITURES $ 37,821 $ 34,969 $ 2,851 ◄ $ 479,391
100.0%
$ 126 $ 1,724 $ 146 EBSCO $ ‐ Newspapers $ 146 Misc Periodicals $ ‐ Nonprinted Materials $ 1,235 CDs/DVDs/Audiobooks $ 1,235 Misc Nonprinted Materials $ ‐ TOTAL CAPITAL OUTLAYS $ 3,230
Dec
Dec Projection
Difference
Beginning Balance plus Receipts minus Expenditures Adjustments (see Notes Page for details) ENDING BALANCE
$ 237,702 $ 142,496 $ (37,821) $ (24,950) $ 317,428
$ 216,976 $ 151,604 $ (34,969) $ (24,950) $ 308,660
$ 20,727 $ (9,107) $ (2,851) $ ‐ $ 8,768
◄ $ 312,669 ◄ $ 509,123 ◄ $ (479,391) $ (24,972) ◄ $ 317,428
Material Expenditures
$ 3,104
$ 2,675 $ 429
$ 42,216
BALANCE
Flag Criteria ◄ favorable ◄ unfavorable
1/17/2015 3:49 PM
◄
4.3% 0.8% 0.6% 0.2% 0.1% 2.5% 2.5% 0.0% 8.5%
YTD
YTD Projection
$ 27,739 $ 12,600 $ 2,800 $ 775 $ 1,000 $ 778 $ 1,886 $ 1,000 $ 1,000 $ 2,600 $ 3,000 $ 300 $ 50 $ 610 $ 8,384 $ 2,900 $ 360 $ 1,200 $ 1,500 $ 2,174 $ 250 $ 108,826
Percent Amount
$ 500 10% $ 750
5.9% 2.7% 0.6% 0.2% 0.2% 0.2% 0.4% 0.2% 0.2% 0.5% 0.6% 0.1% 0.0% 0.1% 1.8% 0.6% 0.1% 0.3% 0.3% 0.5% 0.1% 23.0%
$ 1,500 $ 21,000 $ 4,320 $ 3,000 $ 720 $ 600 $ 10,500 $ 10,500 $ ‐ $ 37,320
0.3%
$ 472,897
100.0%
4.4% 0.9% 0.6% 0.2% 0.1% 2.2% 2.2% 0.0% 7.9%
YTD Projection
8.8%
$ 40,955
Difference
◄
see Notes
$ 358 $ 1,850 21 $ (2,800) ◄ $ 4 $ 1,101 6 $ 375 $ (1) 17 $ (261) 8 $ 295 4 $ 15 $ (67) 16 $ (153) $ (30) $ 311 $ (1,405) $ (259) $ (164) $ (147) $ (405) $ (181) $ (250) $ (6,154) ◄ $ 2,625 ◄ 15 $ (518) $ (341) $ (249) $ 217 $ (309) $ 1,588 $ 1,361 $ 227 $ 3,354 ◄ $ 6,495 ◄ w/o LIRF Difference
$ 312,669 $ 493,838 $ (472,897) $ (24,950) $ 308,660
Current Month Minimum
%
◄
see Notes
$ ‐ $ 15,285 ◄ $ (6,495) ◄ w/o LIRF $ (22) 22 $ 8,768 ◄ 8.7%
$ 1,261
YTD Minimum Percent Amount
see Notes
$ 2,000 15% $ 3,000
* *
Page 3 of 4
Notes for CUTPL 2014 Working Budget * Difference is at least $500 ($2000 YTD) AND greater than 10% (15%) from the Projection, OR difference is at least $750 ($3000 YTD) regardless of % # January 1 3 pay periods 2 $4807 paid to Anthem for January & February; errors in bill still to be corrected 3 $2522 paid to CompuTrain 4 $395 paid to Arrow for termite treatment in 2013 February 5 BookWhere ($454) projected for March, World Vital Records ($500) projected for April 6 $1981 paid to Thyssenkrupp for elevator repairs made in 2013 March 7 $17,862 reimbursed by Bank of New York for Bond O&R expenses paid from Operating Fund April 8 $610 paid to McGrath Refrigeration to replace stuck valve actuator $10,563 paid to Korsen Fire & Security to install fire alarm system (from LIRF) 9 Property‐Liability Insurance ($8000) projected for April not paid; lower cost policy (~$7000) being processed Payment Error: 11 Invoices totaling $3515.06 paid twice; credits and refunds will be made in future months Revised February Register of Claims, expenditures were overstated by $886 May $99,500 paid to Bank of New York from Debt Services Fund $2,668.25 in Credits and Refunds applied from April's double payment errors June 10 $176,145 Property Tax distribution to Operating Fund ($8,763 higher than projection based on Auditor's report) 11 $5,604 Excise Tax distribution to Operating Fund ($1,943 lower than projection based on Auditor's report) 12 $700 CVET distribution to Operating Fund ($518 lower than projection based on Auditor's report) 13 $1599 paid to Miller NorCen Insurance for Director's and Officers' annual coverage Finney CD ($2188.29 principal & interest) redeemed and deposited into FFBT Savings account July 14 3 pay periods August 15 $2,460.85 paid for computer equipment $2,931 paid (50% downpayment) to Custom Awning for rolling shutters in Carnegie Room from General Gift Fund September 16 $675 paid to Bennett's Contracting for new water heater & installation 17 $1,885 paid to McGrath Refrigeration for annual HVAC maintenance contract 18 $2,482 paid to Symantec & Microsoft for backup software & other licenses October $3718 annual distribution received from MCCF, deposited into General Gift Fund 19 $1500 paid to Overdrive for eBook service $4333 paid to Chester, Inc for HP Proliant server and components November does not include Transfer to LIRF $800 paid to Zehner for cleaning drainage tile in courtyard from Rainy Day Fund $15,520 paid to Osborn Construction for materials from Rainy Day Fund 20 No November payment ($2100+) to Anthem for group health insurance. Paid in December. December 21 $1445 paid to Culver Cleaning for annual deep cleaning 22 $24,950 transferred from Operating Fund to LIRF (shown in adjustments, not Operating Fund expenditures because it distorts spending & ratios) $99,500 paid to Bank of New York from Debt Services Fund $4,050 paid to Osborn Construction to remove awning (sail) from Rainy Day Fund $6,011 paid to Osborn Construction to install vinyl soffit on east and west overhang from Rainy Day Fund
1/17/2015 3:49 PM
Page 4 of 4