Loading...
4.4 HRSR 06-06-2016 5-06-2016 03:08 PM CITY OF ELK RIVER Item 4.4 PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 910-HRA FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY HRA 304,750.00 373.48 4,430.21 1.45 300,319.79 TOTAL REVENUES 304,750.00 373.48 4,430.21 1.45 300,319.79 EXPENDITURE SUMMARY Economic Development Housing & Redevelopment 304,750.00 ( 24,388.69) 8,680.70 2.85 296,069.30 TOTAL Economic Development 304,750.00 ( 24,388.69) 8,680.70 2.85 296,069.30 TOTAL EXPENDITURES 304,750.00 ( 24,388.69) 8,680.70 2.85 296,069.30 REVENUES OVER/(UNDER) EXPENDITURES 0.00 24,762.17 ( 4,250.49) 4,250.49 5-06-2016 03:08 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 910-HRA 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE HRA Taxes 910-3-0000-3111 Property Taxes 300,250.00 0.00 1.00 0.00 300,249.00 TOTAL Taxes 300,250.00 0.00 1.00 0.00 300,249.00 Intergovernmental Rev Charges for Services 910-3-0000-3414 Development Fee 0.00 0.00 2,000.00 0.00 ( 2,000.00) TOTAL Charges for Services 0.00 0.00 2,000.00 0.00 ( 2,000.00) Other Revenue 910-3-0000-3621 Interest Income 4,500.00 373.48 2,429.21 53.98 2,070.79 TOTAL Other Revenue 4,500.00 373.48 2,429.21 53.98 2,070.79 Other Financing Sources Transfers In TOTAL HRA 304,750.00 373.48 4,430.21 1.45 300,319.79 TOTAL REVENUE 304,750.00 373.48 4,430.21 1.45 300,319.79 5-06-2016 03:08 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 910-HRA Economic Development 33.33% OF YEAR COMP. Housing & Redevelopment CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 910-4-6100-4101 Regular Pay 56,100.00 0.00 7,609.44 13.56 48,490.56 910-4-6100-4104 PERA 4,200.00 0.00 634.12 15.10 3,565.88 910-4-6100-4105 FICA 3,500.00 0.00 524.21 14.98 2,975.79 910-4-6100-4107 Medicare 800.00 0.00 122.60 15.33 677.40 910-4-6100-4108 Insurance 7,250.00 0.00 1,192.81 16.45 6,057.19 910-4-6100-4109 Workers Comp 300.00 71.75 143.50 47.83 156.50 TOTAL Personal Services 72,150.00 71.75 10,226.68 14.17 61,923.32 Supplies 910-4-6100-4201 Office Supplies 0.00 49.10 49.10 0.00 ( 49.10) 910-4-6100-4212 Fuels & Lubes 1,400.00 0.00 0.00 0.00 1,400.00 TOTAL Supplies 1,400.00 49.10 49.10 3.51 1,350.90 Other Services & Charges 910-4-6100-4304 Legal Fees 10,000.00 0.00 31.00 0.31 9,969.00 910-4-6100-4319 Other Professional Services 20,450.00 0.00 0.00 0.00 20,450.00 910-4-6100-4322 Postage 7,000.00 0.00 5.96 0.09 6,994.04 910-4-6100-4331 Travel, Conferences & Schools 4,500.00 142.46 142.46 3.17 4,357.54 910-4-6100-4349 Advertising/Marketing 6,000.00 0.00 2,850.00 47.50 3,150.00 910-4-6100-4359 Publishing 5,000.00 0.00 0.00 0.00 5,000.00 910-4-6100-4409 Contractual Services 150,000.00 ( 24,652.00) ( 4,861.00) 3.24- 154,861.00 910-4-6100-4433 Dues & Subscriptions 0.00 0.00 236.50 0.00 ( 236.50) TOTAL Other Services & Charges 202,950.00 ( 24,509.54) ( 1,595.08) 0.79- 204,545.08 Capital Outlay Debt Service Transfers Out 910-4-6100-4721 Transfer-General Fund 24,750.00 0.00 0.00 0.00 24,750.00 910-4-6100-4735 Transfer-EDA 3,500.00 0.00 0.00 0.00 3,500.00 TOTAL Transfers Out 28,250.00 0.00 0.00 0.00 28,250.00 TOTAL Housing & Redevelopment 304,750.00 ( 24,388.69) 8,680.70 2.85 296,069.30 TOTAL Economic Development 304,750.00 ( 24,388.69) 8,680.70 2.85 296,069.30 TOTAL EXPENDITURES 304,750.00 ( 24,388.69) 8,680.70 2.85 296,069.30 REVENUES OVER/(UNDER) EXPENDITURES 0.00 24,762.17 ( 4,250.49) 4,250.49 6-02-2016 08:31 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2016 910-HRA FINANCIAL SUMMARY 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY HRA 304,750.00 310.46 5,111.89 1.68 299,638.11 TOTAL REVENUES 304,750.00 310.46 5,111.89 1.68 299,638.11 EXPENDITURE SUMMARY Economic Development Housing & Redevelopment 304,750.00 15,130.18 23,810.88 7.81 280,939.12 TOTAL Economic Development 304,750.00 15,130.18 23,810.88 7.81 280,939.12 TOTAL EXPENDITURES 304,750.00 15,130.18 23,810.88 7.81 280,939.12 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 14,819.72) ( 18,698.99) 18,698.99 6-02-2016 08:31 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2016 910-HRA 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE HRA Taxes 910-3-0000-3111 Property Taxes 300,250.00 0.00 1.00 0.00 300,249.00 TOTAL Taxes 300,250.00 0.00 1.00 0.00 300,249.00 Intergovernmental Rev Charges for Services 910-3-0000-3414 Development Fee 0.00 0.00 2,000.00 0.00 ( 2,000.00) TOTAL Charges for Services 0.00 0.00 2,000.00 0.00 ( 2,000.00) Other Revenue 910-3-0000-3621 Interest Income 4,500.00 310.46 3,110.89 69.13 1,389.11 TOTAL Other Revenue 4,500.00 310.46 3,110.89 69.13 1,389.11 Other Financing Sources Transfers In TOTAL HRA 304,750.00 310.46 5,111.89 1.68 299,638.11 TOTAL REVENUE 304,750.00 310.46 5,111.89 1.68 299,638.11 6-02-2016 08:31 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2016 910-HRA Economic Development 41.67% OF YEAR COMP. Housing & Redevelopment CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 910-4-6100-4101 Regular Pay 56,100.00 8,454.94 16,064.38 28.64 40,035.62 910-4-6100-4104 PERA 4,200.00 634.12 1,268.24 30.20 2,931.76 910-4-6100-4105 FICA 3,500.00 524.21 1,048.42 29.95 2,451.58 910-4-6100-4107 Medicare 800.00 122.60 245.20 30.65 554.80 910-4-6100-4108 Insurance 7,250.00 1,192.81 2,385.62 32.91 4,864.38 910-4-6100-4109 Workers Comp 300.00 0.00 143.50 47.83 156.50 TOTAL Personal Services 72,150.00 10,928.68 21,155.36 29.32 50,994.64 Supplies 910-4-6100-4201 Office Supplies 0.00 0.00 49.10 0.00 ( 49.10) 910-4-6100-4212 Fuels & Lubes 1,400.00 0.00 0.00 0.00 1,400.00 TOTAL Supplies 1,400.00 0.00 49.10 3.51 1,350.90 Other Services & Charges 910-4-6100-4304 Legal Fees 10,000.00 0.00 31.00 0.31 9,969.00 910-4-6100-4319 Other Professional Services 20,450.00 0.00 0.00 0.00 20,450.00 910-4-6100-4322 Postage 7,000.00 0.00 5.96 0.09 6,994.04 910-4-6100-4331 Travel, Conferences & Schools 4,500.00 0.00 142.46 3.17 4,357.54 910-4-6100-4349 Advertising/Marketing 6,000.00 326.50 3,176.50 52.94 2,823.50 910-4-6100-4359 Publishing 5,000.00 125.00 125.00 2.50 4,875.00 910-4-6100-4409 Contractual Services 150,000.00 3,750.00 ( 1,111.00) 0.74- 151,111.00 910-4-6100-4433 Dues & Subscriptions 0.00 0.00 236.50 0.00 ( 236.50) TOTAL Other Services & Charges 202,950.00 4,201.50 2,606.42 1.28 200,343.58 Capital Outlay Debt Service Transfers Out 910-4-6100-4721 Transfer-General Fund 24,750.00 0.00 0.00 0.00 24,750.00 910-4-6100-4735 Transfer-EDA 3,500.00 0.00 0.00 0.00 3,500.00 TOTAL Transfers Out 28,250.00 0.00 0.00 0.00 28,250.00 TOTAL Housing & Redevelopment 304,750.00 15,130.18 23,810.88 7.81 280,939.12 TOTAL Economic Development 304,750.00 15,130.18 23,810.88 7.81 280,939.12 TOTAL EXPENDITURES 304,750.00 15,130.18 23,810.88 7.81 280,939.12 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 14,819.72) ( 18,698.99) 18,698.99