city of sandwich treasurers' report as of may 31, 2019 · cash cash cash balance as of balance...
TRANSCRIPT
Cash Cash Cash
Balance as of Balance as of Balance as of
5/31/2018 4/30/2019 5/31/2019 Month to Date Changes
Fund Number Fund Description
001 General Fund 1,679,737.54 2,122,521.07 2,295,708.49 173,187.42
010 Capital Equipment Fund 732,375.62 321,567.12 306,774.45 (14,792.67)
020 Impact Fees 283,097.15 233,089.35 238,633.90 5,544.55
035 Fairwinds Blvd Improvement 62,495.05 62,192.37 62,194.63 2.26
100 Audit 0.00 ‐2,610.99 0.00 2,610.99
101 IMRF / FICA ‐30,900.27 154,575.11 0.00 (154,575.11)
102 Police Pension 20,106.22 20,120.80 20,120.82 0.02
103 Tort / Immunity ‐12,597.00 ‐107,423.10 0.00 107,423.10
104 Forestry ‐1,668.05 ‐2,194.32 0.00 2,194.32
105 School Crossing Guard ‐2,726.00 ‐11,717.28 0.00 11,717.28
110 Motor Fuel Tax (MFT) 915,516.48 1,101,893.39 1,118,894.99 17,001.60
120 Drug Abuse 38,597.41 34,604.55 34,766.85 162.30
121 911 Dispatch 92,329.44 84,810.43 0.00 (84,810.43)
122 Vehicle Fleet 11,904.16 5,408.90 0.00 (5,408.90)
130 Tourism 28,824.92 22,348.25 23,576.33 1,228.08
200 School / Park Land Cash 0.00 0.00 0.00 ‐
201 Annexation Deposits 11,000.00 11,000.00 11,000.00 ‐
202 Excavation Deposits 12,000.00 9,000.00 9,000.00 ‐
300 Sewer 67,628.19 ‐86,149.93 ‐36,430.31 49,719.62
350 Sewer Reserve 3,659,951.89 3,677,289.54 3,681,789.54 4,500.00
400 Water 418,272.57 576,837.42 598,189.35 21,351.93
450 Water Reserve 1,344,479.42 1,297,241.00 1,300,491.00 3,250.00
Total 9,330,424.74 9,524,403.68 9,664,710.04 140,306.36
City of Sandwich
Treasurers' Report
As of May 31, 2019
1
Month‐to‐Date Year‐to‐Date Budget
Budget
Remaining
%
Remain
Revenue
Tax Revenue (521,464.15) (521,464.15) (4,611,250.00) (4,089,785.85) 89%
Licenses & Permits (6,761.00) (6,761.00) (56,000.00) (49,239.00) 88%
Intergovernmental ‐ ‐ (157,000.00) (157,000.00) 100%
Charges for Services ‐ ‐ (3,500.00) (3,500.00) 100%
Fines & Forefits (9,821.32) (9,821.32) (91,000.00) (81,178.68) 89%
Interest Income (1,258.59) (1,258.59) (20,000.00) (18,741.41) 0%
Other Income (9,891.50) (9,891.50) (56,000.00) (46,108.50) 82%
Total Revenue (549,196.56) (549,196.56) (4,994,750.00) (4,445,553.44) 89%
Expenditures
Administration Department 201,072.29 201,072.29 1,490,876.00 1,289,803.71 87%
Engineering Department 6,672.34 6,672.34 131,388.00 124,715.66 95%
Street Department 79,079.03 79,079.03 955,106.00 876,026.97 92%
Police Department 322,957.64 322,957.64 2,503,490.00 2,180,532.36 87%
EMA Department 5,012.60 5,012.60 35,075.00 30,062.40 86%
Total Expenditures 614,793.90 614,793.90 5,115,935.00 4,501,141.10 88%
Excess Revenue over Expense (1,163,990.46) (1,163,990.46) (10,110,685.00) (8,946,694.54)
General Operations Fund
General Fund Summary
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019Target % remaining 91.7%
2
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Revenues
Taxes Fund Description
001.0000.01.4000 STATE SALES TAX (132,192.51) (132,192.51) (1,975,000.00) (1,842,807.49) 93%
001.0000.01.4005 STATE INCOME TAX (149,023.89) (149,023.89) (775,000.00) (625,976.11) 81%
001.0000.01.4010 COUNTY TAXES (151,303.21) (151,303.21) (1,102,250.00) (950,946.79) 86%
001.0000.01.4015 ROAD & BRIDGE TAX (3,095.26) (3,095.26) (26,000.00) (22,904.74) 88%
001.0000.01.4020 UTILITY TAXES (61,737.82) (61,737.82) (600,000.00) (538,262.18) 90%
001.0000.01.4025 REPLACEMENT TAXES (15,672.93) (15,672.93) (46,000.00) (30,327.07) 66%
001.0000.01.4035 CHARITABLE GAMES TAX ‐ ‐ (2,000.00) (2,000.00) 100%
001.0000.01.4040 VIDEO GAMING TAX (8,438.53) (8,438.53) (85,000.00) (76,561.47) 90%
Total Tax Revenue (521,464.15) (521,464.15) (4,611,250.00) (4,089,785.85) 89%
Licenses & Permits
001.0000.05.4100 CITY LICENSES (4,396.00) (4,396.00) (36,000.00) (31,604.00) 88%
001.0000.05.4105 BUILDING PERMITS (2,365.00) (2,365.00) (20,000.00) (17,635.00) 88%
Total Licenses & Permits (6,761.00) (6,761.00) (56,000.00) (49,239.00) 88%
Intergovernmental
001.0000.10.4210 STATE GRANTS ‐ ‐ (80,000.00) (80,000.00) 100%
001.0000.10.4211 VIDEO MONITORING GRANT ‐ ‐ (25,000.00) (25,000.00) 100%
001.0000.10.4250 911 FROM COUNTY ‐ ‐ (7,000.00) (7,000.00) 100%
001.0000.10.4255 SRO REIMBURSEMENT ‐ ‐ (45,000.00) (45,000.00) 100%
Total Intergovernmental ‐ ‐ (157,000.00) (157,000.00) 100%
Charges for Services
001.0000.15.4305 SANDWICH FIRE INSP FEES ‐ ‐ (1,000.00) (1,000.00) 100%
001.0000.15.4310 PLANNING/ZONING HEARING FEES ‐ ‐ (2,000.00) (2,000.00) 100%
001.0000.15.4340 MOWING FEES ‐ ‐ (500.00) (500.00) 100%
Total Charges for Services ‐ ‐ (3,500.00) (3,500.00) 100%
Fines & Forefits
001.0000.20.4600 CIRCUIT COURT FINES (1,991.45) (1,991.45) (35,000.00) (33,008.55) 94%
001.0000.20.4606 MUNICIPAL VIOLATIONS ‐ ‐ (2,000.00) (2,000.00) 100%
001.0000.20.4610 E‐CITATIONS (26.00) (26.00) (250.00) (224.00) 90%
001.0000.20.4611 IMPOUND/SEIZURES (3,000.00) (3,000.00) (30,000.00) (27,000.00) 90%
001.0000.20.4612 MISCELLANEOUS PD (238.00) (238.00) (2,500.00) (2,262.00) 90%
001.0000.20.4615 ADJUDICATION VIOLATIONS (4,490.87) (4,490.87) (20,000.00) (15,509.13) 78%
001.0000.20.4616 COLLECTION ADJUDICATION ‐ ‐ (250.00) (250.00) 100%
001.0000.20.4625 ANIMAL CONTROL FINES (75.00) (75.00) (1,000.00) (925.00) 93%
Total Fines & Forefits (9,821.32) (9,821.32) (91,000.00) (81,178.68) 89%
Interest Income
001.0000.25.4675 INTEREST INCOME (1,258.59) (1,258.59) (20,000.00) (18,741.41) 94%
Total Interest Income (1,258.59) (1,258.59) (20,000.00) (18,741.41) 94%
Other Income
001.0000.30.4690 CREDIT CARD SERVICE CHARGE (168.15) (168.15) (1,000.00) (831.85) 83%
001.0000.30.4695 MISCELLANEOUS INCOME (9,286.21) (9,286.21) (50,000.00) (40,713.79) 81%
001.0000.30.4755 REIMBURSEMENT PD OT ‐ ‐ (5,000.00) (5,000.00) 100%
001.0000.30.4790 MISC REIMBURSEMENTS (437.14) (437.14) ‐ 437.14 0%
Total Other Income (9,891.50) (9,891.50) (56,000.00) (46,108.50) 82%
Transfer In
001.0000.35.4850 IFT FROM OTHER FUNDS (239,385.54) (239,385.54) (185,000.00) 54,385.54 ‐29%
Total Transfer In (239,385.54) (239,385.54) (185,000.00) 54,385.54 ‐29%
Total General Fund Revenue (788,582.10) (788,582.10) (5,179,750.00) (4,391,167.90) 85%
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
General Operations Fund
3
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Expenses
Personnel Services
001.0005.50.5001 ELECTED OFFICIALS SALARIES 5,516.66 5,516.66 81,000.00 75,483.34 93%
001.0005.50.5002 PLAN/ZON COMMISSION SALARIES ‐ ‐ 2,000.00 2,000.00 100%
001.0005.50.5003 POLICE COMMISSION SALARIES ‐ ‐ 2,700.00 2,700.00 100%
001.0005.50.5010 SALARIES 21,219.75 21,219.75 76,500.00 55,280.25 72%
001.0005.50.5030 LONGEVITY SALARY ‐ ‐ 2,350.00 2,350.00 100%
001.0005.50.5040 EMPLOYEE INSURANCE BENEFITS 5,536.96 5,536.96 66,000.00 60,463.04 92%
001.0005.50.5045 ACCRUED VACATION/SICK ‐ ‐ 3,500.00 3,500.00 100%
001.0005.50.5055 IMRF ER CONTRIBUTION 1,615.89 1,615.89 5,850.00 4,234.11 72%
001.0005.50.5060 UNEMPLOYMENT INSURANCE ‐ ‐ 550.00 550.00 100%
001.0005.50.5065 WORKMAN'S COMPENSATION INS 545.00 545.00 8,200.00 7,655.00 93%
001.0005.50.5070 FICA MATCH 2,022.61 2,022.61 6,026.00 4,003.39 66%
001.0005.50.5075 OTHER‐INSURANCE BENEFIT 2,404.62 2,404.62 31,000.00 28,595.38 92%
Total Personnel Services 38,861.49 38,861.49 285,676.00 246,814.51 86%
Professional Development
001.0005.55.5100 TRAINING/TRAVEL/MEETING EXP ‐ ‐ 3,000.00 3,000.00 100%
001.0005.55.5105 DUES & MEMBERSHIPS ‐ ‐ 3,000.00 3,000.00 100%
Total Professional Development ‐ ‐ 6,000.00 6,000.00 100%
Utilities
001.0005.60.5200 UTILITIES ‐ ELECTRIC 8,089.04 8,089.04 81,000.00 72,910.96 90%
001.0005.60.5205 UTILITIES ‐ GAS ‐ ‐ 500.00 500.00 100%
001.0005.60.5210 UTILITIES ‐ TELEPHONE 1,093.44 1,093.44 5,500.00 4,406.56 80%
001.0005.60.5215 UTILITIES ‐ CABLE/INTERNET 106.85 106.85 3,000.00 2,893.15 96%
001.0005.60.5220 TRASH REMOVAL 74.00 74.00 875.00 801.00 92%
Total Utilities 9,363.33 9,363.33 90,875.00 81,511.67 90%
Commodities
001.0005.65.5300 OFFICE SUPPLIES 219.73 219.73 4,500.00 4,280.27 95%
001.0005.65.5305 OPERATING/CLEANING SUPPLIES ‐ ‐ 400.00 400.00 100%
001.0005.65.5315 POSTAGE 69.20 69.20 1,250.00 1,180.80 94%
001.0005.65.5320 PRINTING EXPENSE 186.95 186.95 1,000.00 813.05 81%
001.0005.65.5325 PUBLICATIONS ‐ ‐ 250.00 250.00 100%
Total Commodities 475.88 475.88 7,400.00 6,924.12 94%
Outside Services
001.0005.70.5400 ADMINSTRATIVE COSTS ‐ ‐ 500.00 500.00 100%
001.0005.70.5410 AUDIT FEES ‐ ‐ 13,000.00 13,000.00 100%
001.0005.70.5415 ARCH MANAGEMENT 1,000.00 1,000.00 12,000.00 11,000.00 92%
001.0005.70.5420 OUTSIDE CONSULTANT 3,500.00 3,500.00 61,000.00 57,500.00 94%
001.0005.70.5440 JULIE SERVICES ‐ ‐ 2,000.00 2,000.00 100%
001.0005.70.5445 LEGAL SERVICES 8,793.75 8,793.75 75,000.00 66,206.25 88%
001.0005.70.5450 CONTRACTUAL SERVICES 1,074.61 1,074.61 35,000.00 33,925.39 97%
001.0005.70.5465 LIABILITY INSURANCE ‐ ‐ 60,000.00 60,000.00 100%
001.0005.70.5475 COMPUTER MAINT AGRMTS ‐ ‐ 20,000.00 20,000.00 100%
001.0005.70.5480 RENTAL/LEASE AGREEMENTS ‐ ‐ 2,575.00 2,575.00 100%
001.0005.70.5485 LEGAL NOTICES & ADVERTISING 187.50 187.50 3,500.00 3,312.50 95%
001.0005.70.5500 SANDWICH ECONOMIC DEV CORP ‐ ‐ 40,000.00 40,000.00 100%
001.0005.70.5505 SW CABLE & TELE CONSORTIUM 9,841.84 9,841.84 40,000.00 30,158.16 75%
001.0005.70.5575 BUILDING MAINTENANCE 200.00 200.00 64,400.00 64,200.00 100%
Total Outside Services 24,597.70 24,597.70 428,975.00 404,377.30 94%
General Operations Fund
Administration Department
4
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Other Expenses
001.0005.75.5600 ELECTED OFFICIALS‐EXPENSES ‐ ‐ 100.00 100.00 100%
001.0005.75.5602 PLANNING/ZONING EXPENSES 119.67 119.67 800.00 680.33 85%
001.0005.75.5603 POLICE COMMISSION EXPENSES ‐ ‐ 4,000.00 4,000.00 100%
001.0005.75.5605 CONTRIBUTIONS (FLOWERS, ETC) ‐ ‐ 500.00 500.00 100%
001.0005.75.5610 EMPLOYEE RELATIONS ‐ ‐ 2,500.00 2,500.00 100%
001.0005.75.5630 DRAINAGE DISTRICT RE TAXES 2,254.30 2,254.30 5,500.00 3,245.70 59%
001.0005.75.5650 DONATIONS ‐ ‐ 2,500.00 2,500.00 100%
001.0005.75.5660 TASTE OF SANDWICH ‐ ‐ 500.00 500.00 100%
001.0005.75.5690 REFUNDS 1,454.23 1,454.23 1,000.00 (454.23) ‐45%
001.0005.75.5695 MISC EXPENSE ‐ ‐ 25,550.00 25,550.00 100%
Total Other Expenses 3,828.20 3,828.20 42,950.00 39,121.80 91%
Equipment ($5,000 +)
001.0005.85.5805 COMPUTER PGRMS/UPGRADES ‐ ‐ 4,000.00 4,000.00 100%
Total Equipment ‐ ‐ 4,000.00 4,000.00 100%
Transfers to Other Funds
001.0005.97.7000 IFT TRANSFER OUT ‐ ‐ 625,000.00 625,000.00 100%
001.0005.97.7027 IFT TO FUND 100 AUDIT 2,610.99 2,610.99 ‐ (2,610.99) 0%
001.0005.97.7062 IFT TO FUND 103 WORKERS COMP 107,423.10 107,423.10 ‐ (107,423.10) 0%
001.0005.97.7064 IFT TO FUND 104 FORESTRY 2,194.32 2,194.32 ‐ (2,194.32) 0%
001.0005.97.7066 IFT TO FUND 105 SCH XING 11,717.28 11,717.28 ‐ (11,717.28) 0%
Total Transfers to Other Funds 123,945.69 123,945.69 625,000.00 501,054.31 80%
.
Total Administration Department 201,072.29 201,072.29 1,490,876.00 1,289,803.71 87%
5
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Personnel Services
001.0010.50.5010 SALARIES 4,441.60 4,441.60 77,500.00 73,058.40 94%
001.0010.50.5020 OVERTIME @ 1.5 ‐ ‐ 600.00 600.00 100%
001.0010.50.5030 LONGEVITY SALARY ‐ ‐ 1,940.00 1,940.00 100%
001.0010.50.5040 EMPLOYEE INSURANCE BENEFITS 1,123.07 1,123.07 14,000.00 12,876.93 92%
001.0010.50.5045 ACCRUED VACATION/SICK ‐ ‐ 1,250.00 1,250.00 100%
001.0010.50.5055 IMRF ER CONTRIBUTION 313.13 313.13 6,032.00 5,718.87 95%
001.0010.50.5060 UNEMPLOYMENT INS ‐ ‐ 260.00 260.00 100%
001.0010.50.5065 WORKMAN'S COMP INS 121.00 121.00 1,800.00 1,679.00 93%
001.0010.50.5070 FICA MATCH 308.77 308.77 6,456.00 6,147.23 95%
Total Personnel Services 6,307.57 6,307.57 109,838.00 103,530.43 94%
Professional Development
001.0010.55.5100 TRAINING/TRAVEL/MEETING EXP ‐ ‐ 400.00 400.00 100%
001.0010.55.5105 DUES & MEMBERSHIPS ‐ ‐ 200.00 200.00 100%
Total Professional Development ‐ ‐ 600.00 600.00 100%
Utilities
001.0010.60.5210 UTILITIES ‐ TELEPHONE 152.07 152.07 1,800.00 1,647.93 92%
Total Utilities 152.07 152.07 1,800.00 1,647.93 92%
Commodities
001.0010.65.5300 OFFICE SUPPLIES ‐ ‐ 1,400.00 1,400.00 100%
001.0010.65.5310 CLOTHING‐UNIFORMS/SUPPLIES ‐ ‐ 300.00 300.00 100%
001.0010.65.5315 POSTAGE ‐ ‐ 50.00 50.00 100%
001.0010.65.5320 PRINTING EXPENSE ‐ ‐ 200.00 200.00 100%
001.0010.65.5325 PUBLICATIONS 212.70 212.70 2,000.00 1,787.30 89%
001.0010.65.5330 VEHICLE FUEL ‐ ‐ 500.00 500.00 100%
001.0010.65.5340 SAFETY EQUIPMENT ‐ ‐ 100.00 100.00 100%
Total Commodities 212.70 212.70 4,550.00 4,337.30 95%
Outside Services
001.0010.70.5420 OUTSIDE CONSULTANT ‐ ‐ 11,000.00 11,000.00 100%
001.0010.70.5450 CONTRACTUAL SERVICES ‐ ‐ 1,400.00 1,400.00 100%
001.0010.70.5485 LEGAL NOTICES & ADVERTISING ‐ ‐ 100.00 100.00 100%
001.0010.80.5705 OFFICE EQUIPMENT ‐ ‐ 2,000.00 2,000.00 100%
001.0010.80.5710 FIELD EQUIPMENT ‐ ‐ 100.00 100.00 100%
Total Outside Services ‐ ‐ 14,600.00 14,600.00 100%
Total Engineering Department 6,672.34 6,672.34 131,388.00 124,715.66 95%
Engineering Department
6
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Personnel Servicess
001.0015.50.5010 SALARIES 31,134.30 31,134.30 308,350.00 277,215.70 90%
001.0015.50.5015 PART TIME ‐ ‐ 13,500.00 13,500.00 100%
001.0015.50.5020 OVERTIME @ 1.5 235.64 235.64 20,000.00 19,764.36 99%
001.0015.50.5025 OVERTIME @ 2.0 ‐ ‐ 8,000.00 8,000.00 100%
001.0015.50.5030 LONGEVITY SALARY ‐ ‐ 12,420.00 12,420.00 100%
001.0015.50.5040 EMPLOYEE INSURANCE BENEFITS 8,657.64 8,657.64 65,000.00 56,342.36 87%
001.0015.50.5045 ACCRUED VACATION/SICK ‐ ‐ 5,000.00 5,000.00 100%
001.0015.50.5050 OTHER BENEFITS ‐ ‐ 500.00 500.00 100%
001.0015.50.5055 IMRF ER CONTRIBUTION 2,232.38 2,232.38 24,774.00 22,541.62 91%
001.0015.50.5060 UNEMPLOYMENT INS ‐ ‐ 1,300.00 1,300.00 100%
001.0015.50.5065 WORKMAN'S COM PINS 4,504.00 4,504.00 67,000.00 62,496.00 93%
001.0015.50.5070 FICA MATCH 2,310.09 2,310.09 27,592.00 25,281.91 92%
Total Personnel Services 49,074.05 49,074.05 553,436.00 504,361.95 91%
Professional Development
001.0015.55.5100 TRAINING/TRAVEL/MEETING EXP 149.51 149.51 4,000.00 3,850.49 96%
001.0015.55.5110 MEDICAL EXP/IMMUNIZATIONS ‐ ‐ 1,000.00 1,000.00 100%
Total Professional Development 149.51 149.51 5,000.00 4,850.49 97%
Utilities
001.0015.60.5200 UTILITIES ‐ ELECTRIC 139.29 139.29 350.00 210.71 60%
001.0015.60.5205 UTILITIES ‐ GAS 501.69 501.69 5,500.00 4,998.31 91%
001.0015.60.5210 UTILITIES ‐ TELEPHONE 280.30 280.30 3,400.00 3,119.70 92%
001.0015.60.5220 TRASH REMOVAL 96.00 96.00 1,100.00 1,004.00 91%
Total Utilities 1,017.28 1,017.28 10,350.00 9,332.72 90%
Commodities
001.0015.65.5300 OFFICE SUPPLIES ‐ ‐ 350.00 350.00 100%
001.0015.65.5305 OPERATING/CLEANING SUPPLIES 127.61 127.61 10,000.00 9,872.39 99%
001.0015.65.5310 CLOTHING‐UNIFORMS/SUPPLIES 170.89 170.89 4,200.00 4,029.11 96%
001.0015.65.5330 VEHICLE FUEL 936.72 936.72 20,000.00 19,063.28 95%
001.0015.65.5340 SAFETY EQUIPMENT ‐ ‐ 3,000.00 3,000.00 100%
001.0015.65.5350 VEHICLES & EQUIPMENT 19,193.89 19,193.89 18,000.00 (1,193.89) ‐7%
001.0015.65.5360 STREETS 1,229.93 1,229.93 36,000.00 34,770.07 97%
001.0015.65.5365 STREET SALT 6,931.65 6,931.65 33,000.00 26,068.35 79%
001.0015.65.5370 STORM SEWER ‐ ‐ 10,000.00 10,000.00 100%
001.0015.65.5375 BUILDING MAINTENANCE ‐ ‐ 1,000.00 1,000.00 100%
Total Commodities 28,590.69 28,590.69 135,550.00 106,959.31 79%
Outside Services
001.0015.70.5450 CONTRACTUAL SERVICES ‐ ‐ 12,000.00 12,000.00 100%
001.0015.70.5475 COMPUTER MAINT AGREEMENT ‐ ‐ 1,700.00 1,700.00 100%
001.0015.70.5485 LEGAL NOTICES & ADVERTISING ‐ ‐ 1,000.00 1,000.00 100%
001.0015.70.5550 VEHICLES & EQUIPMENT 247.50 247.50 18,000.00 17,752.50 99%
001.0015.70.5560 STREETS ‐ ‐ 36,000.00 36,000.00 100%
001.0015.70.5562 SNOW REMOVAL ‐ ‐ 1,000.00 1,000.00 100%
001.0015.70.5575 BUILDING MAINTENANCE ‐ ‐ 89,000.00 89,000.00 100%
Total Outside Services 247.50 247.50 158,700.00 158,452.50 100%
Other Expenses
001.0015.75.5630 DRAINAGE DISTRICT FEES ‐ ‐ 70.00 70.00 100%
Total Other Expenses ‐ ‐ 70.00 70.00 100%
Equipment
001.0015.80.5710 FIELD EQUIPMENT ‐ ‐ 2,000.00 2,000.00 100%
001.0015.85.5815 PUBLIC WORKS EQUIPMENT ‐ ‐ 40,000.00 40,000.00 100%
Total Equipment Expenses ‐ ‐ 42,000.00 42,000.00 100%
Capital Improvements
001.0015.90.6800 CAPITAL IMPROVEMENTS ‐ ‐ 50,000.00 50,000.00 100%
Total Capital Improvements ‐ ‐ 50,000.00 50,000.00 100%
Total Streets Department 79,079.03 79,079.03 955,106.00 876,026.97 92%
Street Department
7
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Personnel Services
001.0017.50.5012 BASE WAGES‐OTHER DEPARTMENTS 270.12 270.12 30,000.00 29,729.88 99%
001.0017.50.5015 PART TIME ‐ ‐ 3,500.00 3,500.00 100%
001.0017.50.5020 OVERTIME @ 1.5 ‐ ‐ 750.00 750.00 100%
001.0017.50.5030 LONGEVITY SALARY ‐ ‐ 1,190.00 1,190.00 100%
001.0017.50.5042 EMP INS BENEFITS 152.94 152.94 11,000.00 10,847.06 99%
001.0017.50.5045 ACCRUED VACATION/SICK ‐ ‐ 500.00 500.00 100%
001.0017.50.5055 IMRF ER CONTRIBUTION ‐ ‐ 2,288.00 2,288.00 100%
001.0017.50.5070 FICA MATCH 19.78 19.78 2,432.00 2,412.22 99%
Total Personnel Services 442.84 442.84 51,660.00 51,217.16 99%
Professional Development
001.0017.55.5100 TRAINING/TRAVEL/MEETING EXP ‐ ‐ 500.00 500.00 100%
Total Professional Development ‐ ‐ 500.00 500.00 100%
Commodities
001.0017.65.5330 VEHICLE FUEL ‐ ‐ 500.00 500.00 100%
001.0017.65.5345 FORESTRY STOCK 157.94 157.94 1,500.00 1,342.06 89%
001.0017.65.5350 VEHICLES & EQUIPMENT ‐ ‐ 500.00 500.00 100%Total Commodities 157.94 157.94 2,500.00 2,342.06 94%
Outside Services
001.0017.70.5450 CONTRACTUAL SERVICES ‐ ‐ 8,000.00 8,000.00 100%
001.0017.70.5550 VEHICLES & EQUIPMENT ‐ ‐ 2,000.00 2,000.00 100%
Total Outside Services ‐ ‐ 10,000.00 10,000.00 100%
Equipment ($0 ‐ $4,999)
001.0017.80.5715 FIELD EQUIPMENT ‐ ‐ 500.00 500.00 100%Total Equipment ($0 ‐ $4,999) ‐ ‐ 500.00 500.00 100%
Total Forestry Department 600.78 600.78 65,160.00 64,559.22 99%
Personnel Services
001.0020.50.5010 SALARIES 222,913.10 222,913.10 1,354,000.00 1,131,086.90 84%
001.0020.50.5015 PART TIME 3,246.00 3,246.00 25,000.00 21,754.00 87%
001.0020.50.5020 OVERTIME @ 1.5 6,773.30 6,773.30 75,000.00 68,226.70 91%
001.0020.50.5025 HOLIDAY PAY 5,683.95 5,683.95 60,000.00 54,316.05 91%
001.0020.50.5027 COURT TIME SALARIES 880.41 880.41 6,000.00 5,119.59 85%
001.0020.50.5028 SALARIES‐SCHOOL CROSSING GUARD 2,349.00 2,349.00 24,000.00 21,651.00 90%
001.0020.50.5030 LONGEVITY SALARY 910.14 910.14 43,200.00 42,289.86 98%
001.0020.50.5040 EMPLOYEE INSURANCE BENEFITS 25,154.12 25,154.12 322,000.00 296,845.88 92%
001.0020.50.5045 ACCRUED VACATION/SICK ‐ ‐ 101,500.00 101,500.00 100%
001.0020.50.5055 IMRF ER CONTRIBUTION 2,494.79 2,494.79 9,270.00 6,775.21 73%
001.0020.50.5060 UNEMPLOYMENT INS ‐ ‐ 550.00 550.00 100%
001.0020.50.5065 WORKMAN'S COMP INS 6,203.00 6,203.00 92,400.00 86,197.00 93%
001.0020.50.5070 FICA MATCH 18,229.05 18,229.05 36,360.00 18,130.95 50%Total Personnel Services 294,836.86 294,836.86 2,149,280.00 1,854,443.14 86%
Professional Development
001.0020.55.5100 TRAINING/TRAVEL/MEETING EXP 3,111.00 3,111.00 21,000.00 17,889.00 85%
001.0020.55.5105 DUES & MEMBERSHIPS ‐ ‐ 1,650.00 1,650.00 100%
001.0020.55.5110 MEDICAL EXP/IMMUNIZATIONS ‐ ‐ 1,000.00 1,000.00 100%Total Professional Development 3,111.00 3,111.00 23,650.00 20,539.00 87%
Utilities
001.0020.60.5200 UTILITIES ‐ ELECTRIC 319.81 319.81 900.00 580.19 64%
001.0020.60.5205 UTILITIES ‐ GAS 54.23 54.23 1,500.00 1,445.77 96%
001.0020.60.5210 UTILITIES ‐ TELEPHONE 769.01 769.01 12,000.00 11,230.99 94%
001.0020.60.5220 TRASH REMOVAL 78.00 78.00 925.00 847.00 92%Total Utilities 1,221.05 1,221.05 15,325.00 14,103.95 92%
Police Department
Forestry
8
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Commodities
001.0020.65.5300 OFFICE SUPPLIES 62.57 62.57 6,000.00 5,937.43 99%
001.0020.65.5305 OPERATING/CLEANING SUPPLIES 24.94 24.94 5,000.00 4,975.06 100%
001.0020.65.5310 CLOTHING‐UNIFORMS/SUPPLIES 239.94 239.94 18,000.00 17,760.06 99%
001.0020.65.5315 POSTAGE ‐ ‐ 1,300.00 1,300.00 100%
001.0020.65.5320 PRINTING EXPENSE ‐ ‐ 2,000.00 2,000.00 100%
001.0020.65.5325 PUBLICATIONS ‐ ‐ 500.00 500.00 100%
001.0020.65.5330 VEHICLE FUEL 2,110.68 2,110.68 28,000.00 25,889.32 92%
001.0020.65.5335 SUPPLIES ‐ OFFICER ‐ ‐ 1,900.00 1,900.00 100%
001.0020.65.5336 SUPPLIES ‐ INVESTIGATIONS 113.22 113.22 1,000.00 886.78 89%
001.0020.65.5338 SUPPLIES ‐ AMMUNITION ‐ ‐ 3,000.00 3,000.00 100%
001.0020.65.5350 VEHICLES & EQUIPMENT 115.42 115.42 2,000.00 1,884.58 94%Total Commodities 2,666.77 2,666.77 68,700.00 66,033.23 96%
Outside Services
001.0020.70.5445 LEGAL SERVICES 350.00 350.00 7,500.00 7,150.00 95%
001.0020.70.5450 CONTRACTUAL SERVICES 4,934.39 4,934.39 100,525.00 95,590.61 95%
001.0020.70.5475 COMPUTER MAINT AGREEMTS 1,093.52 1,093.52 43,500.00 42,406.48 97%
001.0020.70.5485 LEGAL NOTICES & ADVERTISING ‐ ‐ 300.00 300.00 100%
001.0020.70.5510 INVESTIGATION SERVICES ‐ ‐ 2,000.00 2,000.00 100%
001.0020.70.5550 VEHICLES & EQUIPMENT 2,563.45 2,563.45 15,000.00 12,436.55 83%
001.0020.70.5575 BUILDING MAINTENANCE ‐ ‐ 5,000.00 5,000.00 100%Total Outside Services 8,941.36 8,941.36 173,825.00 164,883.64 95%
Other Expenses
001.0020.75.5610 EMPLOYEE RELATIONS ‐ ‐ 1,500.00 1,500.00 100%
001.0020.75.5632 ADJUDICATION EXP 11,450.00 11,450.00 19,000.00 7,550.00 40%
001.0020.75.5635 CADET EXPENSES ‐ ‐ 1,000.00 1,000.00 100%
001.0020.75.5695 MISC EXPENSE ‐ ‐ 2,500.00 2,500.00 100%
001.0020.75.5721 VIDEO MONITORING PROG EXP ‐ ‐ 8,634.00 8,634.00 100%
001.0020.75.5722 K9 EXPENSES ‐ ‐ 1,000.00 1,000.00 100%Total Other Expenses 11,450.00 11,450.00 33,634.00 22,184.00 66%
Equipment ($0 ‐ $4,999)
001.0020.80.5720 POLICE EQUIPMENT 730.60 730.60 14,076.00 13,345.40 95%Total Equipment ($0 ‐ $4,999) 730.60 730.60 14,076.00 13,345.40 95%
Equipment ($5,000 + )
001.0020.85.5820 POLICE EQUIPMENT ‐ ‐ 25,000.00 25,000.00 100%Total Equipment ($5,000 + ) ‐ ‐ 25,000.00 25,000.00 100%
Total Police Department 322,957.64 322,957.64 2,503,490.00 2,180,532.36 87%
9
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Professional Development
001.0025.55.5105 DUES & MEMBERSHIPS ‐ ‐ 100.00 100.00 100%
Total Professional Development ‐ ‐ 100.00 100.00 100%
Utilities
001.0025.60.5200 UTILITIES ‐ ELECTRIC 36.74 36.74 750.00 713.26 95%
001.0025.60.5210 UTILITIES ‐ TELEPHONE 233.76 233.76 2,500.00 2,266.24 91%
001.0025.60.5215 UTILITIES ‐ CABLE/INTERNET 86.90 86.90 975.00 888.10 91%
Total Utilities 357.40 357.40 4,225.00 3,867.60 92%
Outside Services
001.0025.70.5450 CONTRACTUAL SERVICES 4,215.00 4,215.00 4,500.00 285.00 6%
Total Outside Services 4,215.00 4,215.00 4,500.00 285.00 6%
Other Expenses
001.0025.75.5695 MISC EXPENSE 440.20 440.20 250.00 (190.20) ‐76%
Other Expenses 440.20 440.20 250.00 (190.20) ‐76%
Equipment ($0 ‐ $4,999)
001.0025.80.5725 RADIO EQUIPMENT ‐ ‐ 1,000.00 1,000.00 100%
Total Equipment ($0 ‐ $4,999) ‐ ‐ 1,000.00 1,000.00 100%
Equipment ($5,000 +)
001.0025.85.5830 EQUIPMENT ‐ ‐ 25,000.00 25,000.00 100%
Total Equipment ($5,000 +) ‐ ‐ 25,000.00 25,000.00 100%
Total EMA Department 5,012.60 5,012.60 35,075.00 30,062.40 86%
Total General Fund 615,394.68 615,394.68 5,181,095.00 4,565,700.32 88%
Excess Revenue over Expense (1,403,976.78) (1,403,976.78) (10,360,845.00) (8,956,868.22)
EMA Department
10
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Expenses
010.0000.20.4604 ACQUISITION/MAINTENANCE (405.00) (405.00) ‐ 405.00 0%
Total Fines & Forefits (405.00) (405.00) ‐ 405.00 0%
010.0000.25.4675 INTEREST INCOME (10,226.97) (10,226.97) ‐ 10,226.97 0%
Total Interest Income (10,226.97) (10,226.97) ‐ 10,226.97 0%
010.0000.30.4775 PROCEEDS FROM BOND ISSUE ‐ ‐ (3,000,000.00) (3,000,000.00) 100%
Total Proceeds From Bond Issue ‐ ‐ (3,000,000.00) (3,000,000.00) 100%
010.0000.35.4850 IFT FROM OTHER FUNDS (5,408.90) (5,408.90) (400,000.00) (394,591.10) 99%
Total Transfer In (5,408.90) (5,408.90) (400,000.00) (394,591.10) 99%
010.0000.85.5820 EQUIPMENT 30,833.54 30,833.54 112,000.00 81,166.46 72%Total Equipment ($5,000 +) 30,833.54 30,833.54 112,000.00 81,166.46 72%
010.0000.90.6800 CAPITAL IMPROVEMENTS ‐ ‐ 30,000.00 30,000.00 100%Total Capital Improvements ‐ ‐ 30,000.00 30,000.00 100%
010.0100.90.6800 CAPITAL IMPROVEMENTS ‐ ‐ 100,000.00 100,000.00 100%Total Capital Improvements ‐ ‐ 100,000.00 100,000.00 100%
010.0107.90.6800 CAPITAL IMPROVEMENTS ‐ ‐ 3,200,000.00 3,200,000.00 100%Total Capital Improvements ‐ ‐ 3,200,000.00 3,200,000.00 100%
010.0307.90.6800 CAPITAL IMPROVEMENTS ‐ ‐ 80,000.00 80,000.00 100%Total Capital Improvements ‐ ‐ 80,000.00 80,000.00 100%
Total Capital Equipment / Projects Fund Expenses 14,792.67 14,792.67 122,000.00 107,207.33 88%
Capital Improvements
Proceeds From Bond Issue
IFT From Other Funds
Capital Equipment / Projects Fund
Capital Improvements
Equipment ($5,000 +)
Capital Improvements
Capital Improvements
Fines & Forefits
Interest Income
11
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Revenues
Licenses & Permits
020.0000.05.4190 IMPACT FEES RECEIVED (5,544.55) (5,544.55) (10,000.00) (4,455.45) 45%Total License & Permits (5,544.55) (5,544.55) (10,000.00) (4,455.45) 45%
Total Impact Fee Fund Revenue (5,544.55) (5,544.55) (10,000.00) (4,455.45) 45%
Capital Improvements
020.0000.90.6870 POLICE SERVICES ‐ ‐ 89,104.00 89,104.00 100%Total Capital Improvements ‐ ‐ 89,104.00 89,104.00 100%
Interest Income
035.0000.25.4675 INTEREST INCOME (2.26) (2.26) ‐ 2.26 0%Total Interest Income (2.26) (2.26) ‐ 2.26 0%
IFT From Other Funds
100.0000.35.4850 IFT From Other Funds (2,610.99) (2,610.99) ‐ 2,610.99 0%Total Transfer In (2,610.99) (2,610.99) ‐ 2,610.99 0%
IFT To Other Funds
100.0000.35.4850 IFT From Other Funds 154,575.11 154,575.11 ‐ (154,575.11) 0%Total Transfer Out 154,575.11 154,575.11 ‐ (154,575.11) 0%
102.0000.01.4010 COUNTY TAXES ‐ ‐ (387,518.00) (387,518.00) 100%Total Taxes ‐ ‐ (387,518.00) (387,518.00) 100%
102.0000.25.4675 INTEREST INCOME (0.02) (0.02) ‐ 0.02 0%Total Interest Income (0.02) (0.02) ‐ 0.02 0%
102.0040.98.6870 POLICE PENSION CONTRIBUTION ‐ ‐ 387,518.00 387,518.00 100%Total Police Pension Contribution ‐ ‐ 387,518.00 387,518.00 100%
Total Police Pension (0.02) (0.02) ‐ 0.02
IFT From Other Funds
103.0000.35.4850 IFT From Other Funds (107,423.10) (107,423.10) ‐ 107,423.10 0%Total Transfer In (107,423.10) (107,423.10) ‐ 107,423.10 0%
IFT From Other Funds
104.0000.35.4850 IFT From Other Funds (2,194.32) (2,194.32) ‐ 2,194.32 0%Total Transfer In (2,194.32) (2,194.32) ‐ 2,194.32 0%
Forestry Fund
Fairwinds Blvd Improvement Fund
Audit Fund
Tort / Immunity Fund
Police Pension Fund
Impact Fee Fund
12
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
IFT From Other Funds
105.0000.35.4850 IFT From Other Funds (11,717.28) (11,717.28) ‐ 11,717.28 0%Total Transfer In (11,717.28) (11,717.28) ‐ 11,717.28 0%
IFT Transfer Out
105.0000.35.4850 IFT Transfer Out 84,810.43 84,810.43 ‐ (84,810.43) 0%Total Transfer Out 84,810.43 84,810.43 ‐ (84,810.43) 0%
Revenue
Intergovernmental
110.0000.10.4230 MOTOR FUEL TAX RECEIPTS (16,426.06) (16,426.06) (192,000.00) (175,573.94) 91%Total Intergovernmental (16,426.06) (16,426.06) (192,000.00) (175,573.94) 91%
Interest Income
110.0000.25.4675 INTEREST INCOME (575.54) (575.54) (1,200.00) (624.46) 52%Total Interest Income (575.54) (575.54) (1,200.00) (624.46) 52%
Total Motor Fuel Tax Fund Revenue (17,001.60) (17,001.60) (193,200.00) (176,198.40) 91%
Outside Services
110.0000.70.5485 LEGAL NOTICES & ADVERTISING ‐ ‐ 400.00 400.00 100%Total Outside Services ‐ ‐ 400.00 400.00 100%
Capital Improvements
110.0000.90.6860 STREET IMPROVEMENTS ‐ ‐ 396,000.00 396,000.00 100%Total Capital Improvements ‐ ‐ 396,400.00 396,000.00 100%
Motor Fuel Tax Total (17,001.60) (17,001.60) 203,200.00 220,201.60 108%
Revenue
Fines & Forefits
120.0000.20.4630 TRAFFIC SCHOOL DISTRIBUTION (2.00) (2.00) (20.00) (18.00) 90%
120.0000.20.4635 ALCOHOL PROGRAM DISTRIBUTION (150.00) (150.00) (4,000.00) (3,850.00) 96%
120.0000.20.4640 DRUG PROGRAM DISTRIBUTION ‐ ‐ (5,000.00) (5,000.00) 100%Total Fines & Forefits (152.00) (152.00) (9,020.00) (8,868.00) 98%
Interest Income
120.0000.25.4675 INTEREST INCOME (10.30) (10.30) (50.00) (39.70) 79%Total Interest Income (10.30) (10.30) (50.00) (39.70) 79%
Total Drug Abuse Fund Revenue (162.30) (162.30) (9,070.00) (8,907.70) 98%
IFT From Other Funds
122.0000.35.4850 IFT From Other Funds 5,408.90 5,408.90 ‐ (5,408.90) 0%Total Transfer In 5,408.90 5,408.90 ‐ (5,408.90) 0%
School Crossing Guard Fund
Vehicle Fleet Fund
Motor Fuel Tax Fund
Drug Abuse Fund
13
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Revenue
Taxes
130.0000.01.4030 HOTEL OPERATOR'S OCCUPATION (1,228.08) (1,228.08) (27,000.00) (25,771.92) 95%Total Taxes (1,228.08) (1,228.08) (27,000.00) (25,771.92) 95%
Total Tourism Fund Revenue (1,228.08) (1,228.08) (27,000.00) (25,771.92) 95%
Expenses
Outside Services
130.0000.00.6890 TOURISM BENEFIT ‐ ‐ 2,000.00 2,000.00 100%
130.0000.70.5425 AREA CONV & VISITORS BUREAU ‐ ‐ 20,000.00 20,000.00 100%Total Outside Services ‐ ‐ 22,000.00 22,000.00 100%
Total Tourism Fund Expenses ‐ ‐ 22,000.00 22,000.00 0%
Excess Revenue over Expense (1,228.08) (1,228.08) (5,000.00) (3,771.92)
135.0000.15.4360 LIGHT SHOW TICKET SALES ‐ ‐ (185,000.00) (185,000.00) 100%
135.0000.35.4850 IFT FROM OTHER FUNDS ‐ ‐ (225,000.00) (225,000.00) 100%
135.0000.70.5450 LIGHT SHOW EXPENSES ‐ ‐ 185,000.00 185,000.00 100%
135.0000.75.5695 MISC EXPENSES ‐ ‐ 40,000.00 40,000.00 100%
135.0000.97.7000 IFT TRANSFER OUT ‐ ‐ 185,000.00 185,000.00 100%
Total Holiday Lights ‐ ‐ ‐ ‐ 0%
200.0000.00.5695 MISC EXPENSE 5,000.00 5,000.00 100%
Total School/Parks Land‐Cash ‐ ‐ 5,000.00 5,000.00 100%
Holiday Lights Fund
School / Park Land Cash Fund
Tourism Fund
14
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Revenue
Charges for
Services
300.0000.15.4400 SEWER CHARGES (105,572.88) (105,572.88) (1,050,000.00) (944,427.12) 90%
300.0000.15.4405 SEWER USER FEE ‐ ‐ (50,000.00) (50,000.00) 100%Total Charges for Services (105,572.88) (105,572.88) (1,100,000.00) (994,427.12) 90%
Fines & Forfeits
300.0000.20.4645 SEWER LATE CHARGES (1,335.34) (1,335.34) (15,000.00) (13,664.66) 91%Total Fines & Forfeits (1,335.34) (1,335.34) (15,000.00) (13,664.66) 91%
Other Income
300.0000.30.4690 CREDIT CARD SERVICE CHARGE ‐ ‐ (4,000.00) (4,000.00) 100%
300.0000.30.4695 MISCELLANEOUS INCOME (10.00) (10.00) (1,000.00) (990.00) 99%
300.0000.35.4850 IFT FROM OTHER FUNDS ‐ ‐ (625,550.00) (625,550.00) 100%Total Other Income (10.00) (10.00) (630,550.00) (630,540.00) 100%
Total Sewer Fund Revenue (106,918.22) (106,918.22) (1,745,550.00) (1,638,631.78) 94%
Expenses
Personnal Services
300.0000.50.5010 SALARIES 13,585.85 13,585.85 205,350.00 191,764.15 93%
300.0000.50.5020 OVERTIME @ 1.5 287.07 287.07 5,000.00 4,712.93 94%
300.0000.50.5025 OVERTIME @ 2.0 380.11 380.11 5,000.00 4,619.89 92%
300.0000.50.5030 LONGEVITY SALARY ‐ ‐ 2,980.00 2,980.00 100%
300.0000.50.5040 EMPLOYEE INSURANCE BENEFITS 646.64 646.64 22,000.00 21,353.36 97%
300.0000.50.5045 EMP INS BENEFITS‐OTHER DEPTS ‐ ‐ 3,000.00 3,000.00 100%
300.0000.50.5050 OTHER BENEFITS ‐ ‐ 250.00 250.00 100%
300.0000.50.5055 IMRF ER CONTRIBUTION 1,004.63 1,004.63 15,706.00 14,701.37 94%
300.0000.50.5060 UNEMPLOYMENT INS ‐ ‐ 1,100.00 1,100.00 100%
300.0000.50.5065 WORKMAN'S COMP INS 759.00 759.00 11,300.00 10,541.00 93%
300.0000.50.5070 FICA MATCH 1,052.90 1,052.90 16,766.00 15,713.10 94%Total Personnal Services 17,716.20 17,716.20 288,452.00 270,735.80 94%
300.0000.55.5100 TRAINING/TRAVEL/MEETING EXP 150.00 150.00 3,000.00 2,850.00 95%
300.0000.55.5105 DUES & MEMBERSHIP ‐ ‐ 2,000.00 2,000.00 100%
300.0000.55.5110 MEDICAL EXP/IMMUNIZATION ‐ ‐ 600.00 600.00 100%Total Professional Development 150.00 150.00 5,600.00 5,450.00 97%
Utilities
300.0000.60.5200 UTILITIES ‐ ELECTRIC 4,350.04 4,350.04 67,000.00 62,649.96 94%
300.0000.60.5205 UTILITIES ‐ GAS 539.70 539.70 4,400.00 3,860.30 88%
300.0000.60.5210 UTILITIES ‐ TELEPHONE 412.62 412.62 5,500.00 5,087.38 92%
300.0000.60.5215 UTILITIES ‐ CABLE/INTERNET 85.98 85.98 1,000.00 914.02 91%
300.0000.60.5220 TRASH REMOVAL 84.00 84.00 1,800.00 1,716.00 95%Total Utilities 5,472.34 5,472.34 79,700.00 74,227.66 93%
Sewer Fund
Professional Development
15
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Commodities
300.0000.65.5300 OFFICE SUPPLIES 249.10 249.10 150.00 (99.10) ‐66%
300.0000.65.5305 OPERATING/CLEANING SUPPLIES 63.26 63.26 7,000.00 6,936.74 99%
300.0000.65.5310 CLOTHING‐UNIFORMS/SUPPLIES ‐ ‐ 1,200.00 1,200.00 100%
300.0000.65.5315 POSTAGE 570.87 570.87 3,700.00 3,129.13 85%
300.0000.65.5320 PRINTING EXPENSE ‐ ‐ 2,000.00 2,000.00 100%
300.0000.65.5330 VEHICLE FUEL 613.96 613.96 3,000.00 2,386.04 80%
300.0000.65.5340 SAFETY EQUIPMENT ‐ ‐ 800.00 800.00 100%
300.0000.65.5350 VEHICLES & EQUIPMENT 653.88 653.88 6,000.00 5,346.12 89%
300.0000.65.5355 CHEMICALS‐ SW & WA TREATMENT 778.87 778.87 15,000.00 14,221.13 95%
300.0000.65.5375 BUILDING MAINTENANCE 188.79 188.79 20,000.00 19,811.21 99%
300.0000.65.5380 SEWER ‐ ‐ 400.00 400.00 100%
300.0000.65.5382 MATERIAL ‐ LIFT STAT REPAIRS ‐ ‐ 4,800.00 4,800.00 100%Total Commodities 3,118.73 3,118.73 64,050.00 60,931.27 95%
Outside Services
300.0000.70.5410 AUDIT FEES ‐ ‐ 1,200.00 1,200.00 100%
300.0000.70.5450 CONTRACTUAL SERVICES 6,073.81 6,073.81 280,000.00 273,926.19 98%
300.0000.70.5465 LIABILITY INSURANCE ‐ ‐ 10,000.00 10,000.00 100%
300.0000.70.5475 COMPUTER MAINTE AGREEMTS ‐ ‐ 7,300.00 7,300.00 100%
300.0000.70.5480 RENTAL/LEASE AGREEMENTS ‐ ‐ 1,000.00 1,000.00 100%
300.0000.70.5550 VEHICLES & EQUIPMENT 7,230.00 7,230.00 10,000.00 2,770.00 28%
300.0000.70.5555 TESTING INCLUDING POSTAGE 525.00 525.00 15,000.00 14,475.00 97%
300.0000.70.5575 BUILDING MAINTENANCE ‐ ‐ 15,000.00 15,000.00 100%
300.0000.70.5580 SEWER ‐ ‐ 4,000.00 4,000.00 100%
300.0000.70.5582 LIFT STATIONS ‐ ‐ 12,000.00 12,000.00 100%
300.0000.70.5583 SLUDGE HAULING ‐ ‐ 20,000.00 20,000.00 100%Total Outside Services 13,828.81 13,828.81 375,500.00 361,671.19 96%
Other Expenses
300.0000.75.5615 CREDIT CARD SERVICE CHARGES 220.25 220.25 2,500.00 2,279.75 91%
300.0000.75.5630 DRAINAGE DISTRICT FEES ‐ ‐ 200.00 200.00 100%
300.0000.75.5695 MISC EXPENSE ‐ ‐ 20,500.00 20,500.00 100%Total Other Expenses 220.25 220.25 23,200.00 22,979.75 99%
300.0000.80.5730 EQUIPMENT 16,692.27 16,692.27 3,000.00 (13,692.27) ‐456%Total Equipment ($0 ‐ $4,999) 16,692.27 16,692.27 3,000.00 (13,692.27) ‐456%
Capital Improvements
300.0000.90.6800 CAPITAL IMPROVEMENTS ‐ ‐ 20,000.00 20,000.00 100%Total Capital Improvements ‐ ‐ 20,000.00 20,000.00 100%
Other Operations
300.0000.95.6900 DEBT RETIREMENT ‐ ‐ 560,000.00 560,000.00 100%
300.0000.95.6910 BOND & INT PAYMENT ‐ ‐ 65,550.00 65,550.00 100%Total Other Operations ‐ ‐ 625,550.00 625,550.00 100%
Total Sewer Fund Expenses 57,198.60 57,198.60 1,485,052.00 1,427,853.40 96%
Excess Revenue over Expense (49,719.62) (49,719.62) (260,498.00) (210,778.38)
Equipment ($0 ‐ $4,999)
16
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Revenue
350.0000.05.4195 SEWER INFRASTRUCTURE FEES (1,500.00) (1,500.00) ‐ 1,500.00 0%Total Licences & Permits (1,500.00) (1,500.00) ‐ 1,500.00 0%
350.0000.15.4425 SEWER CONNECTION FEES (3,000.00) (3,000.00) ‐ 3,000.00 0%Total Charges for Services (3,000.00) (3,000.00) ‐ 3,000.00 0%
Total Sewer Reserve / Improvement Fund Revenue (4,500.00) (4,500.00) ‐ 4,500.00 0%
350.0000.97.7000 IFT TRANSFER OUT ‐ ‐ 625,550.00 625,550.00 100%Total Interest Income ‐ ‐ 625,550.00 625,550.00 100%
Total Sewer Reserve / Improvement Fund Expenses ‐ ‐ 625,550.00 625,550.00 100%
Excess Revenue over Expense (4,500.00) (4,500.00) 625,550.00 630,050.00
Transfers
Sewer Reserve / Improvement Fund
Licences & Permits
Charges for Services
17
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
Revenue
400.0000.15.4405 WATER USER FEE ‐ ‐ (50,000.00) (50,000.00) 100%
400.0000.15.4500 WATER SALES (55,032.05) (55,032.05) (540,000.00) (484,967.95) 90%
400.0000.15.4525 WATER SERVICE ‐ NEW HOOK UPS (300.00) (300.00) ‐ 300.00 0%Total Charges for Services (55,332.05) (55,332.05) (590,000.00) (534,667.95) 91%
400.0000.20.4645 WATER LATE CHARGES (687.59) (687.59) (6,000.00) (5,312.41) 89%Total Fines & Forefits (687.59) (687.59) (6,000.00) (5,312.41) 89%
400.0000.30.4695 MISCELLANEOUS INCOME ‐ ‐ ‐ 0%Total Other Income ‐ ‐ ‐ ‐ 0%
Total Water Fund Revenue (56,019.64) (56,019.64) (596,000.00) (539,980.36) 91%
Expenses
400.0000.50.5010 SALARIES 15,479.19 15,479.19 222,000.00 206,520.81 93%
400.0000.50.5020 OVERTIME @ 1.5 348.64 348.64 8,000.00 7,651.36 96%
400.0000.50.5025 OVERTIME @ 2.0 220.81 220.81 6,000.00 5,779.19 96%
400.0000.50.5030 LONGEVITY SALARY ‐ ‐ 9,450.00 9,450.00 100%
400.0000.50.5040 EMPLOYEE INSURANCE BENEFITS 3,311.20 3,311.20 35,000.00 31,688.80 91%
400.0000.50.5045 ACCRUED VACATION/SICK ‐ ‐ 6,650.00 6,650.00 100%
400.0000.50.5055 IMRF EMPLOYER CONTRIBUTION 1,129.31 1,129.31 17,857.00 16,727.69 94%
400.0000.50.5060 UNEMPLOYMENT INS ‐ ‐ 1,000.00 1,000.00 100%
400.0000.50.5065 WORKMAN'S COMP INS 764.00 764.00 11,400.00 10,636.00 93%
400.0000.50.5070 FICA MATCH 1,180.96 1,180.96 18,862.00 17,681.04 94%Total Personnal Services 22,434.11 22,434.11 336,219.00 313,784.89 93%
400.0000.55.5100 TRAINING/TRAVEL/MEETING EXP 510.77 510.77 3,000.00 2,489.23 83%
400.0000.55.5105 DUES & MEMBERSHIP ‐ ‐ 350.00 350.00 100%Total Professional Development 510.77 510.77 3,350.00 2,839.23 85%
400.0000.60.5200 UTILITIES ‐ ELECTRIC 3,601.63 3,601.63 42,000.00 38,398.37 91%
400.0000.60.5205 UTILITIES ‐ GAS 438.08 438.08 6,000.00 5,561.92 93%
400.0000.60.5210 UTILITIES ‐ TELEPHONE 321.67 321.67 4,400.00 4,078.33 93%
400.0000.60.5220 TRASH REMOVAL ‐ ‐ 1,000.00 1,000.00 100%Total Utilities 4,361.38 4,361.38 53,400.00 49,038.62 92%
400.0000.65.5300 OFFICE SUPPLIES ‐ ‐ 500.00 500.00 100%
400.0000.65.5305 OPERATING/CLEANING SUPPLIES 925.76 925.76 500.00 (425.76) ‐85%
400.0000.65.5310 CLOTHING‐UNIFORMS/SUPPLIES ‐ ‐ 1,200.00 1,200.00 100%
400.0000.65.5315 POSTAGE 327.29 327.29 4,500.00 4,172.71 93%
400.0000.65.5320 PRINTING EXPENSE ‐ ‐ 1,500.00 1,500.00 100%
400.0000.65.5325 PUBLICATIONS ‐ ‐ 300.00 300.00 100%
400.0000.65.5330 VEHICLE FUEL 212.99 212.99 1,500.00 1,287.01 86%
400.0000.65.5340 SAFETY EQUIPMENT 34.19 34.19 500.00 465.81 93%
400.0000.65.5350 VEHICLES & EQUIPMENT ‐ ‐ 1,200.00 1,200.00 100%
400.0000.65.5355 CHEMICALS‐ SW & WA TREATMENT 1,299.18 1,299.18 20,000.00 18,700.82 94%
400.0000.65.5360 STREETS 3,148.35 3,148.35 8,000.00 4,851.65 61%
400.0000.65.5375 BUILDING MAINTENANCE 1.42 1.42 1,000.00 998.58 100%
400.0000.65.5385 MATERIAL WATERWORKS REPAIR ‐ ‐ 6,000.00 6,000.00 100%
400.0000.65.5390 MATERIAL ‐ WATERLINE REPAIR 941.89 941.89 40,000.00 39,058.11 98%
400.0000.65.5395 MATERIAL ‐ METERS‐METER REP ‐ ‐ 25,000.00 25,000.00 100%Total Commodities 6,891.07 6,891.07 111,700.00 104,808.93 94%
Water Fund
Charges for Services
Fines & Forefits
Other Income
Personnal Services
Professional Development
Utilities
Commodities
18
Account # Account Description Month‐to‐Date Year‐to‐Date Budget Budget Remaining % Remain
Target % remaining 91.7%
City of Sandwich
Budget vs. Actual
For the 1 months ended May 31, 2019
400.0000.70.5410 AUDIT FEES ‐ ‐ 1,200.00 1,200.00 100%
400.0000.70.5450 CONTRACTUAL SERVICES ‐ ‐ 90,000.00 90,000.00 100%
400.0000.70.5465 LIABILITY INSURANCE ‐ ‐ 10,000.00 10,000.00 100%
400.0000.70.5475 COMPUTER MAINT AGREEMTS ‐ ‐ 4,000.00 4,000.00 100%
400.0000.70.5480 RENTAL/LEASE AGREEMENTS 376.00 376.00 1,000.00 624.00 62%
400.0000.70.5485 LEGAL NOTICES & ADVERTISING ‐ ‐ 2,000.00 2,000.00 100%
400.0000.70.5550 VEHICLES & EQUIPMENT ‐ ‐ 15,000.00 15,000.00 100%
400.0000.70.5555 TESTING INCLUDING POSTAGE ‐ ‐ 1,000.00 1,000.00 100%
400.0000.70.5575 BUILDING MAINTENANCE ‐ ‐ 2,500.00 2,500.00 100%
400.0000.70.5590 MAINTENANCE‐WATERLINES ‐ ‐ 5,000.00 5,000.00 100%Total Outside Services 376.00 376.00 131,700.00 131,324.00 100%
400.0000.75.5615 CREDIT CARD SERVICE CHARGES 94.38 94.38 1,200.00 1,105.62 92%
400.0000.75.5695 MISC EXPENSE ‐ ‐ 250.00 250.00 100%Total Other Expenses 94.38 94.38 1,450.00 1,355.62 93%
400.0000.80.5730 EQUIPMENT ‐ ‐ 5,000.00 5,000.00 100%Total Equipment ($0 ‐ $4,999) ‐ ‐ 5,000.00 5,000.00 100%
400.0000.90.6800 CAPITAL IMPROVEMENTS ‐ ‐ 50,000.00 50,000.00 100%Total Capital Improvements ‐ ‐ 50,000.00 50,000.00 100%
Total Water Fund Expenses 34,667.71 34,667.71 692,819.00 658,151.29 95%
Excess Revenue over Expense (21,351.93) (21,351.93) 96,819.00 118,170.93
Revenue
450.0000.05.4195 WATER INFRASTRUCTURE FEES (750.00) (750.00) ‐ 750.00 0%Total Licenses & Permits (750.00) (750.00) ‐ 750.00 0%
450.0000.15.4525 WATER CONNECTION FEES (2,500.00) (2,500.00) ‐ 2,500.00 0%Total Charges for Services (2,500.00) (2,500.00) ‐ 2,500.00 0%
Total Water Reserve / Improvement Fund Revenues (3,250.00) (3,250.00) ‐ 3,250.00 0%
Capital Improvements
Water Reserve / Improvement Fund
Licenses & Permits
Charges for Services
Outside Services
Other Expenses
Equipment ($0 ‐ $4,999)
19