Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
3.2 - 3.4 HRSR 12-03-2012
11/30/2012 9:31 AM DIRECT PAYABLES DEPARTMENT PAYMENT REGISTER PAGE: 1 VENDOR SET: 01 CITY OF ELK RIVER ITEMS PRINTED: PAID ONLY PACKET: 01359 12/3/12 HRA mt ITEM 1 3.2 FUND 910 HRA DEPARTMENT: 6100 Housing & Redevelopment BANK: HRA VENDOR NAME ITEM # G/L ACCOUNT NAME DESCRIPTION CHECK# AMOUNT 01-16112 ANNIE DECKERT I-120312 910-4-6100-4319 REIMB MTG EXP 001776 13.04 01-17440 CITY OF ELK RIVER I-120312 910-4-6100-4101 REIMB SALARIES - OCT/NOV 001777 8,025.41 01-17440 CITY OF ELK RIVER I-120312 910-4-6100-4104 REIMS SALARIES - OCT/NOV 001777 581.84 01-17440 CITY OF ELK RIVER I-120312 910-4-6100-4105 REIMS SALARIES - OCT/NOV 001777 332.12 01-17440 CITY OF ELK RIVER I-120312 910-4-6100-4107 REIMS SALARIES - OCT/NOV 001777 78.47 01-17440 CITY OF ELK RIVER I-120312 910-4-6100-4108 REIMS SALARIES - OCT/NOV 001777 1,192.80 01-17440 CITY OF ELK RIVER I-120312. 910-4-6100-4319 DT TASK FORCE MTG EXP 001777 62.93 01-24965 MAXFIELD RESEARCH, INC I-14914 910-4-6100-4319 COMP HSING NEEDS ANALYSIS 001778 15,000.00 01-24965 MAXFIELD RESEARCH, INC I-14965 910-4-6100-4319 COMP HSING NEEDS ANALYSIS 001778 180.00 DEPARTMENT 6100 Housing & Redevelopmen TOTAL: 25,466.61 FUND 910 HRA TOTAL: 25,466.61 REPORT GRA TOTAL: 25,466.61 11-27-2012 04:31 PM CITY OF ELK RIVER PAGE: 17 II 3°3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 910-HRA FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY HRA 324,500.00 0.00 157,643.71 48.58 166,856.29 TOTAL REVENUES 324,500.00 0.00 157,643.71 48.58 166,856.29 EXPENDITURE SUMMARY Economic Development Housing & Redevelopment 373,450.00 19,171.29 292,250.63 78.26 81,199.37 TOTAL Economic Development 373,450.00 19,171.29 292,250.63 78.26 81,199.37 TOTAL EXPENDITURES 373,450.00 19,171.29 292,250.63 78.26 81,199.37 REVENUES OVER/(UNDER) EXPENDITURES ( 48,950.00) ) 19,171.29) ( 134,606.92) 85,656.92 11-27-2012 04:31 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 910-HRA 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE HRA Taxes 910-3-0000-3111 Current Ad Valorem Taxes 277,950.00 0.00 152,438.67 54.84 125,511.33 TOTAL Taxes 277,950.00 0.00 152,438.67 54.84 125,511.33 Intergovernmental Rev 910-3-0000-3312 Federal grant 0.00 0.00 0.00 0.00 0.00 910-3-0000-3322 MV Credit 0.00 0.00 54.95 0.00 ( 54.95) TOTAL Intergovernmental Rev 0.00 0.00 54.95 0.00 ( 54.95) Charges for Services 910-3-0000-3475 Building Rent 0.00 0.00 0.00 0.00 0.00 TOTAL Charges for Services 0.00 0.00 0.00 0.00 0.00 Other Revenue 910-3-0000-3621 Interest Income 6,900.00 0.00 3,847.52 55.76 3,052.48 910-3-0000-3625 Refunds & Reimbursements 0.00 0.00 1,302.57 0.00 ( 1,302.57) 910-3-0000-3629 Miscellaneous Revenue 0.00 0.00 0.00 0.00 0.00 TOTAL Other Revenue 6,900.00 0.00 5,150.09 74.64 1,749.91 Other Financing Sources 910-3-0000-3910 Sale of Assets 0.00 0.00 0.00 0.00 0.00 910-3-0000-3917 Capital Lease 0.00 0.00 0.00 0.00 0.00 TOTAL Other Financing Sources 0.00 0.00 0.00 0.00 0.00 Transfers In 910-3-0000-3921 Transfers 0.00 0.00 0.00 0.00 0.00 910-3-0000-3947 Transfer - TIF 39,650.00 0.00 0.00 0.00 39,650.00 TOTAL Transfers In 39,650.00 0.00 0.00 0.00 39,650.00 TOTAL HRA 324,500.00 0.00 157,643.71 48.58 166,856.29 TOTAL REVENUE 324,500.00 0.00 157,643.71 48.58 166,856.29 11-27-2012 04:31 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 910-HRA Economic Development 91.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 51,050.00 13,970.03 36,984.79 72.45 14,065.21 910-4-6100-4102 Overtime Pay 0.00 0.00 0.00 0.00 0.00 910-4-6100-4103 Part-time Pay 0.00 0.00 0.00 0.00 0.00 910-4-6100-4104 PERA 3,700.00 1,012.83 2,817.99 76.16 882.01 910-4-6100-4105 FICA 3,150.00 803.67 2,223.48 70.59 926.52 910-4-6100-4107 Medicare 750.00 190.35 527.14 70.29 222.86 910-4-6100-4108 Insurance 7,200.00 1,791.16 5,373.47 74.63 1,826.53 910-4-6100-4109 Workers Comp 350.00 102.75 315.50 90.14 34.50 TOTAL Personal Services 66,200.00 17,870.79 48,242.37 72.87 17,957.63 Supplies 910-4-6100-4201 Office Supplies 0.00 62.93 62.93 0.00 ( 62.93) TOTAL Supplies 0.00 62.93 62.93 0.00 ( 62.93) Other Services & Charges 910-4-6100-4304 Legal Fees 10,000.00 0.00 1,584.00 15.84 8,416.00 910-4-6100-4319 Other Professional Services 90,000.00 199.82 12,497.63 13.89 77,502.37 910-4-6100-4321 Telephone 0.00 0.00 0.00 0.00 0.00 910-4-6100-4322 Postage 500.00 0.00 214.01 42.80 285.99 910-4-6100-4331 Travel, Conferences & Schools 0.00 0.00 0.00 0.00 0.00 910-4-6100-4349 Advertising/Marketing 2,500.00 285.50 623.37 24.93 1,876.63 910-4-6100-4359 Publishing 16,000.00 67.50 165.00 1.03 15,835.00 910-4-6100-4361 Insurance 1,500.00 0.00 1,310.50 87.37 189.50 910-4-6100-4389 Utilities 0.00 0.00 132.63 0.00 ( 132.63) 910-4-6100-4401 Bldg Repair/Maint Services 5,000.00 0.00 6,431.38 128.63 ( 1,431.38) 910-4-6100-4409 Contractual Services 0.00 684.75 28,356.50 0.00 ( 28,356.50) 910-4-6100-4433 Dues & Subscriptions 0.00 0.00 0.00 0.00 0.00 910-4-6100-4437 Taxes & Licenses 0.00 0.00 0.00 0.00 0.00 910-4-6100-4440 Miscellaneous 0.00 0.00 0.00 0.00 0.00 TOTAL Other Services & Charges 125,500.00 1,237.57 51,315.02 40.89 74,184.98 Capital Outlay 910-4-6100-4510 Land 0.00 0.00 0.00 0.00 0.00 910-4-6100-4530 Improvement Project Contract 163,250.00 0.00 174,130.31 106.66 ( 10,880.31) TOTAL Capital Outlay 163,250.00 0.00 174,130.31 106.66 ( 10,880.31) Debt Service 910-4-6100-4601 Principal 0.00 0.00 0.00 0.00 0.00 910-4-6100-4611 Interest 0.00 0.00 0.00 0.00 0.00 TOTAL Debt Service 0.00 0.00 0.00 0.00 0.00 Transfers Out 910-4-6100-4720 Transfers 0.00 0.00 0.00 0.00 0.00 910-4-6100-4721 Transfer-General Fund 15,000.00 0.00 15,000.00 100.00 0.00 910-4-6100-4725 Transfer-Capital Outlay Resery 0.00 0.00 0.00 0.00 0.00 910-4-6100-4735 Transfer-EDA 3,500.00 0.00 3,500.00 100.00 0.00 TOTAL Transfers Out 18,500.00 0.00 18,500.00 100.00 0.00 11-27-2012 04:31 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2012 910-HRA Economic Development 91.67% OF YEAR COMP. Housing & Redevelopment CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE TOTAL Housing & Redevelopment 373,450.00 19,171.29 292,250.63 78.26 81,199.37 TOTAL Economic Development 373,450.00 19,171.29 292,250.63 78.26 81,199.37 TOTAL EXPENDITURES 373,450.00 19,171.29 292,250.63 78.26 81,199.37 REVENUES OVER/(UNDER) EXPENDITURES ( 48,950.00) ( 19,171.29) ( 134,606.92) 85,656.92 ITEM # 3.4 11-27-2012 04:31 PM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: NOVEMBER 30TH, 2012 910-HRA ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 910-1010 Cash - HRA 731,468.04 910-1070 Taxes Receivable 0.00 910-1150 Accounts Receivable 0.00 910-1190 Notes Receivable 400,000.00 910-1310 Due From Other Funds 259,200.57 910-1550 Prepaid Expenses 0.00 910-1620 Building For Resale 0.00 1,390,668.61 TOTAL ASSETS 1,390,668.61 LIABILITIES 910-2020 A/P - HRA 0.00 910-2040 Salaries Payable 0.00 910-2070 Due To Other Funds 0.00 910-2220 Deferred Revenue 0.00 TOTAL LIABILITIES 0.00 EQUITY 910-2400 Fund Balance 1,525,275.53 TOTAL BEGINNING EQUITY 1,525,275.53 TOTAL REVENUE 157,643.71 TOTAL EXPENSES 292,250.63 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 134,606.92) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 1,390,668.61 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 1,390,668.61