Loading...
3.3. EDSR 07-14-2003 REVENUE/EXPENDITURE REPORT JUNE 30, 2003 Date: 07/08/03 Time: 11:05am CITY OF ELK RIVER Page: 2 For the Period: 01/01/03 to 06/30/03 Original Budget Amended Budget YTD Actual CURR MTH Encumbered YTD Unenc. Balance % Bud ° 920 EDA es 3111 Current Ad Valorem Taxes 209,750.00 209,750.00 -0.01 0.00 0.00 209,750.01 0.0 TAXES 209,750.00 209,750.00 -0.01 0.00 0.00 209,750.01 0.0 INTERGOVERNMENTAL REVENUE 3342 Other Local Grants 0.00 0.00 5,000.00 5,000.00 0.00 -5,000.00 0.0 INTERGOVERNMENTAL REVENUE 0.00 0.00 5,000.00 5,000.00 0.00 -5,000.00 0.0 OTHER REVENUE 3621 Interest Income 3,000.00 3,000.00 1,058.48 110.80 0.00 1,941.52 35.3 OTHER REVENUE 3,000.00 3,000.00 1,058.48 110.80 0.00 1,941.52 35.3 TRANSFERS IN 3949 Transfer-HRA. 3,500.00 3,500.00 0.00 0.00 0.00 3,500.00 0.0 TRANSFERS IN 3,500.00 3,500.00 0.00 0.00 0.00 3,500.00 0.0 Dept: 620.623 BUSINESS INCUBATOR OTHER REVENUE 3629 Miscellaneous Revenue 12,000.00 12,000.00 5,767.25 1,433.50 0.00 6,232.75 48.1 OTHER REVENUE 12,000.00 12,000.00 5,767.25 1,433.50 0.00 6,232.75 48.1 TRANSFERS IN 3921 Transfers 22,900.00 22,900.00 0.00 0.00 0.00 22,900.00 0.0 TRANSFERS IN 22,900.00 22,900.00 0.00 0.00 0.00 22,900.00 0.0 • BUSINESS INCUBATOR 34,900.00 34,900.00 5,767.25 1,433.50 0.00 29,132.75 16.5 Revenues 251,150.00 251,150.00 11,825.72 6,544.30 0.00 239,324.28 4.7 Expenditures Dept: 620.621 ECONOMIC DEVELOPMENT PERSONAL SERVICES 4101 Regular Pay 72,600.00 72,600.00 19,441.29 0.00 0.00 53,158.71 26.8 4103 Part-time Pay 12,600.00 12,600.00 4,269.21 0.00 0.00 8,330.79 33.9 4104 PERA 4,400.00 4,400.00 1,236.87 0.00 0.00 3,163.13 28.1 4105 FICA 5,300.00 5,300.00 1,491.37 0.00 0.00 3,808.63 28.1 4107 Medicare 1,250.00 1,250.00 348.70 0.00 0.00 901.30 27.9 4108 Insurance 7,750.00 7,750.00 2,872.45 0.00 0.00 4,877.55 37.1 4109 Workers Comp 250.00 250.00 194.25 64.75 0.00 55.75 77.7 PERSONAL SERVICES 104,150.00 104,150.00 29,854.14 64.75 0.00 74,295.86 28.7 SUPPLIES 4201 Office Supplies 1,950.00 1,950.00 654.57 45.54 0.00 1,295.43 33.6 4212 Fuels & Lubs 150.00 150.00 20.55 5.65 0.00 129.45 13.7 SUPPLIES 2,100.00 2,100.00 675.12 51.19 0.00 1,424.88 32.1 OTHER SERVICES & CHARGES 4304 Legal Fees 1,750.00 1,750.00 -494.80 0.00 0.00 2,244.80 -28.3 4319 Other Professional Services 11,500.00 11,500.00 4,448.95 39.34 0.00 7,051.05 38.7 4321 Telephone 200.00 200.00 24.14 7.02 0.00 175.86 12.1 4322 Postage 1,500.00 1,500.00 218.03 0.00 0.00 1,281.97 14.5 4331 Travel, Conferences & Schools 8,650.00 8,650.00 5,335.60 0.00 0.00 3,314.40 61.7 4349 Advertising/Marketing 48,200.00 48,200.00 25,603.02 7,063.96 0.00 22,596.98 53.1 4359 Publishing 1,000.00 1,000.00 111.15 0.00 0.00 888.85 11.1 4361 Insurance 500.00 500.00 68.00 0.00 0.00 432.00 13.6 4433 Dues & Subscriptions 1,600.00 1,600.00 1,690.00 197.00 0.00 -90.00 105.6 49iscellaneous 11,000.00 11,000.00 6,020.00 0.00 0.00 4,980.00 54.7 lilli OTHER SERVICES & CHARGES 85,900.00 85,900.00 43,024.09 7,307.32 0.00 42,875.91 50.1 TRANSFERS OUT 4721 Transfer-General Fund 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 REVENUE/EXPENDITURE REPORT JUNE 30, 2003 Date: 07/08/03 Time: 11:05am CITY OF ELK RIVER Page: 3 For the Period: 01/01/03 to 06/30/03 Original Budget Amended Budget YTD Actual CURR MTH Encumbered YTD Unenc. Balance % Bud 920 EDA E tures ept: 620.621 ECONOMIC DEVELOPMENT TRANSFERS OUT TRANSFERS OUT 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 ECONOMIC DEVELOPMENT 197,150.00 197,150.00 73,553.35 7,423.26 0.00 123,596.65 37.3 Dept: 620.623 BUSINESS INCUBATOR SUPPLIES 4219 Operating Supplies 1,000.00 1,000.00 307.96 0.00 0.00 692.04 30.8 SUPPLIES 1,000.00 1,000.00 307.96 0.00 0.00 692.04 30.8 OTHER SERVICES & CHARGES 4319 Other Professional Services 13,000.00 13,000.00 6,000.00 1,000.00 0.00 7,000.00 46.2 4405 Cleaning Services 500.00 500.00 0.00 0.00 0.00 500.00 0.0 4412 Building Rent 20,400.00 20,400.00 8,316.38 1,278.73 0.00 12,083.62 40.8 OTHER SERVICES & CHARGES • 33,900.00 33,900.00 14,316.38 2,278.73 0.00 19,583.62 42.2 BUSINESS INCUBATOR 34,900.00 34,900.00 14,624.34 2,278.73 0.00 20,275.66 41.9 Expenditures 232,050.00 232,050.00 88,177.69 9,701.99 0.00 143,872.31 38.0 Net Effect for EDA 19,100.00 19,100.00 -76,351.97 -3,157.69 0.00 95,451.97 -399.7 Change in Fund Balance: -76,351.97 iGrand Total Net Effect: 29,600.00 29,600.00 190,602.10 -76,090.89 0.00 220,202.10 -643.9 REVENUE/EXPENDITURE DETAIL REPORT MONTH ENDED JUNE 30, 2003 Date: 07/08/03 Time: 11:06am CITY OF ELK RIVER Page: 2 For the Period: 06/01/03 to 06/30/03 Original Budget Amended Budget YTD Actual MTD Actual Encumbered MTD Unenc. Balance o Bud 920 EDA s INr GOVERNMENTAL REVENUE 3342 Other Local Grants 06/25/2003 CR Ref ID: IND PARK TECH SPAT GRA Rcd From: INITIATIVE FOUNDATIO 5,000.00 Drawer: 1 Type: MISC 46102 Other Local Grants 0.00 0.00 5,000.00 5,000.00 0.00 -5,000.00 0.0 INTERGOVERNMENTAL REVENUE 0.00 0.00 5,000.00 5,000.00 0.00 -5,000.00 0.0 OTHER REVENUE 3621 Interest Income 06/30/2003 GJ BANK OF ELK RIVER INTEREST - JUNE 110.80 Interest Income 0.00 0.00 1,058.48 110.80 0.00 -1,058.48 0.0 OTHER REVENUE 0.00 0.00 1,058.48 110.80 0.00 -1,058.48 0.0 Dept: 620.623 BUSINESS INCUBATOR OTHER REVENUE 3629 Miscellaneous Revenue 06/02/2003 CR Ref ID: JUNE AND JULY Rcd From: KNOWLEDGENETICA 1,133.50 Drawer: 1 Type: BUSIN 45844 06/20/2003 CR Ref ID: JUNE PMT Rcd From: VERTICAL PUBLISHING 300.00 Drawer: 1 Type: BUSIN 46042 Miscellaneous Revenue 0.00 0.00 5,767.25 1,433.50 0.00 -5,767.25 0.0 OTHER REVENUE 0.00 0.00 5,767.25 1,433.50 0.00 -5,767.25 0.0 BUSINESS INCUBATOR 0.00 0.00 5,767.25 1,433.50 0.00 -5,767.25 0.0 41) Revenues 0.00 0.00 11,825.73 6,544.30 0.00 -11,825.73 0.0 Expenditures Dept: 620.621 ECONOMIC DEVELOPMENT PERSONAL SERVICES 4109 Workers Comp 06/23/2003 AP LEAGUE OF MN CITITES INS TRUST WORKER'S COMP INSURANCE PREM 64.75 INV#: VENDOR#: 2380 30252 Workers Comp 0.00 0.00 194.25 64.75 0.00 -194.25 0.0 PERSONAL SERVICES 0.00 0.00 194.25 64.75 0.00 -194.25 0.0 SUPPLIES 4201 Office Supplies 06/23/2003 AP S & T OFFICE PRODUCTS INC MISC OFFICE SUPPLIES 15.92 INV#: VENDOR#: 3152 30187 06/23/2003 AP ANCHOR PAPER COMPANY COPY PAPER 29.62 INV#: 45810901 VENDOR#: 1052 30029 Office Supplies 0.00 0.00 654.57 45.54 0.00 -654.57 0.0 4212 Fuels & Lubs 06/09/2003 AP BEAUDRY OIL CO UNLEADED GAS 5.65 INV#: VENDOR#: 1166 29858 Fuels & Lubs 0.00 0.00 20.55 5.65 0.00 -20.55 0.0 SUPPLIES 0.00 0.00 675.12 51.19 0.00 -675.12 0.0 OTHER SERVICES & CHARGES 4319 Other Professional Services 06/23/2003 AP EHLERS & ASSOCIATES INC INDUSTRIAL PARK PROJECT FEES 487.50 INV#: 20892 VENDOR#: 1728 30239 06/24/2003 CR Ref ID: REIMBURSE ENGIN FEES Rcd From: ELK RIVER -448.16 Drawer: 1 Type: MISC 46083 all Other Professional Services 0.00 0.00 4,448.95 39.34 0.00 -4,448.95 0.0 43u Telephone 06/23/2003 AP U S LINK MONTHLY LONG DISTANCE CHARGES 7.02 INV#: VENDOR#: 3514 30210 Telephone 0.00 0.00 24.14 7.02 0.00 -24.14 0.0 REVENUE/EXPENDITURE DETAIL REPORT MONTH ENDED JUNE 30, 2003 Date: 07/08/03 Time: 11:06am CITY OF ELK RIVER Page: 3 For the Period: 06/01/03 to 06/30/03 Original Budget Amended Budget YTD Actual MTD Actual Encumbered MTD Unenc. Balance 0 Bud Ill, 920 EDA itures Dept: 620.621 ECONOMIC DEVELOPMENT OTHER SERVICES & CHARGES 4349 Advertising/Marketing 06/09/2003 AP MILLER DESIGN/TZH4MY// SPORTECH INVITE 450.00 INV#: 060203-6 VENDOR#: 2566 29949 06/09/2003 AP MILLER DESIGN/TAMMY// PHOTOGRAPHY-SPORTECH 515.00 INV#: 060203-3 VENDOR#: 2566 29950 06/09/2003 AP MILLER DESIGN/TAMMY// MN REAL EST JRNL AD-JOINT AD 750.00 INV#: 060203-7 VENDOR#: 2566 29951 06/09/2003 AP MILLER DESIGN/TAMMY// MN REAL EST JRNL-APRIL 28 1,705.00 INV#: 060303-4 VENDOR#: 2566 29952 06/09/2003 AP MILLER DESIGN/TAMMY// BSNS JRNL AD-MAY 16 1,890.00 INV#: 060203-2 VENDOR#: 2566 29953 06/09/2003 AP MILLER DESIGN/TAMMY// NEWSLETTER DESOGN/PROD 903.96 INV#: 060203-5 VENDOR#: 2566 30005 06/23/2003 AP PORTER/M C// MARKETING 850.00 INV#: VENDOR#: 2999 30172 Advertising/Marketing 0.00 0.00 25,603.02 7,063.96 0.00 -25,603.02 0.0 4433 Dues & Subscriptions 06/23/2003 AP DOWNTOWN IDEA EXCHANGE SUBSCRIPTION 197.00 INV#: VENDOR#: 1673 30097 Dues & Subscriptions 0.00 0.00 1,690.00 197.00 0.00 -1,690.00 0.0 OTHER SERVICES & CHARGES . 0.00 0.00 31,766.11 7,307.32 0.00 -31,766.11 0.0 ECONOMIC DEVELOPMENT 0.00 0.00 32,635.48 7,423.26 0.00 -32,635.48 0.0 Dept: 620.623 BUSINESS INCUBATOR OTHER SERVICES & CHARGES 4319 Other Professional Services 06/09/2003 AP GENESIS BUSINESS CENTERS LTD MO RETAINER-BSNS INCUBATOR 1,000.00 INV#: VENDOR#: 1982 29934 Other Professional Services 0.00 0.00 6,000.00 1,000.00 0.00 -6,000.00 0.0 4412 Building Rent 119/2003 AP HICKMAN/LARRY// JUNE BSNS INCUBATOR RENT 1,278.73 INV#: VENDOR#: 2135 29918 Building Rent 0.00 0.00 8,316.38 1,278.73 0.00 -8,316.38 0.0 OTHER SERVICES & CHARGES 0.00 0.00 14,316.38 2,278.73 0.00 -14,316.38 0.0 BUSINESS INCUBATOR 0.00 0.00 14,316.38 2,278.73 0.00 -14,316.38 0.0 Expenditures 0.00 0.00 46,951.86 9,701.99 0.00 -46,951.86 0.0 Net Effect for EDA 0.00 0.00 -35,126.13 -3,157.69 0.00 35,126.13 0.0 Grand Total Net Effect: 0.00 0.00 -133,535.60 -76,090.89 0.00 133,535.60 0.0 •