Loading...
3.3. EDSR 09-08-2003 REVENUE/EXPENDITURE REPORT ITEM 7 3.3. ' AUGUST 31, 2003 Date: 09/02/03 Time: 11:03am CITY OF ELK RIVER Page: 2 For the Period: 01/01/03 to 08/31/03 Original Budget Amended Budget YTD Actual CURB MTH Encumbered YTD Unenc. Balance % Bud ill, 920 EDA es TAXES 3111 Current Ad Valorem Taxes 209,750.00 209,750.00 100,636.83 3.42 0.00 109,113.17 48.0 TAXES 209,750.00 209,750.00 100,636.83 3.42 0.00 109,113.17 48.0 INTERGOVERNMENTAL REVENUE 3342 Other Local Grants 0.00 0.00 5,000.00 0.00 0.00 -5,000.00 0.0 INTERGOVERNMENTAL REVENUE 0.00 0.00 5,000.00 0.00 0.00 -5,000.00 0.0 OTHER REVENUE 3621 Interest Income 3,000.00 3,000.00 1,258.92 0.00 0.00 1,741.08 42.0 OTHER REVENUE 3,000.00 3,000.00 1,258.92 0.00 0.00 1,741.08 42.0 TRANSFERS IN 1 3949 Transfer-HRA 3,500.00 3,500.00 3,500.00 3,500.00 0.00 0.00 100.0 TRANSFERS IN 3,500.00 3,500.00 3,500.00 3,500.00 0.00 0.00 100.0 Dept: 620.623 BUSINESS INCUBATOR OTHER REVENUE 3629 Miscellaneous Revenue 12,000.00 12,000.00 7,407.10 1,133.50 0.00 4,592.90 61.7 OTHER REVENUE 12,000.00 12,000.00 7,407.10 1,133.50 0.00 4,592.90 61.7 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 7,407.10 1,133.50 0.00 27,492.90 21.2 Revenues 251,150.00 251,150.00 117,802.85 4,636.92 0.00 133,347.15 46.9 Expenditures Dept: 620.621 ECONOMIC DEVELOPMENT PERSONAL SERVICES 4101 Regular Pay 72,600.00 72,600.00 37,492.18 18,050.89 0.00 35,107.82 51.6 4103 Part-time Pay 12,600.00 12,600.00 7,315.35 3,046.14 0.00 5,284.65 58.1 4104 PERE 4,400.00 4,400.00 2,235.08 998.21 0.00 2,164.92 50.8 4105 FICA 5,300.00 5,300.00 2,648.54 1,157.17 0.00 2,651.46 50.0 4107 Medicare 1,250.00 1,250.00 619.25 270.55 0.00 630.75 49.5 4108 Insurance 7,750.00 7,750.00 5,503.32 2,630.87 0.00 2,246.68 71.0 4109 Workers Comp 250.00 250.00 194.25 0.00 0.00 55.75 77.7 PERSONAL SERVICES 104,150.00 104,150.00 56,007.97 26,153.83 0.00 48,142.03 53.8 SUPPLIES 4201 Office Supplies 1,950.00 1,950.00 1,333.65 277.47 0.00 616.35 68.4 4212 Fuels & Lubs 150.00 150.00 20.55 0.00 0.00 129.45 13.7 SUPPLIES 2,100.00 2,100.00 1,354.20 277.47 0.00 745.80 64.5 OTHER SERVICES & CHARGES 4304 Legal Fees 1,750.00 1,750.00 -20.35 474.45 0.00 1,770.35 -1.2 4319 Other Professional Services 11,500.00 11,500.00 5,612.50 900.00 0.00 5,887.50 48.8 4321 Telephone 200.00 200.00 37.52 7.51 0.00 162.48 18.8 4322 Postage 1,500.00 1,500.00 532.56 314.53 0.00 967.44 35.5 4331 Travel, Conferences & Schools 8,650.00 8,650.00 5,835.69 144.26 0.00 2,814.31 67.5 4349 Advertising/Marketing 48,200.00 48,200.00 29,763:02 1,160.00 0.00 18,436.98 61.7 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 4 ues & Subscriptions 1,600.00 1,600.00 1,985.00 0.00 0.00 -385.00 124.1 scellaneous 11,000.00 11,000.00 6,020.00 0.00 0.00 4,980.00 54.7 OTHER SERVICES & CHARGES 85,900.00 85,900.00 49,945.09 3,000.75 0.00 35,954.91 58.1 TRANSFERS OUT 4721 Transfer-General Fund 5,000.00 5,000.00 5,000.00 5,000.00 0.00 0.00 100.0 REVENUE/EXPENDITURE REPORT AUGUST 31, 2003 Date: 09/02/03 Time: 11:03am CITY OF ELK RIVER Page: 3 For the Period: 01/01/03 to 08/31/03 Original Budget Amended Budget YTD Actual CURB MTH Encumbered YTD Unenc. Balance % Bud 920 EDA E itures Dept: 620.621 ECONOMIC DEVELOPMENT TRANSFERS OUT TRANSFERS OUT 5,000.00 5,000.00 5,000.00 5,000.00 0.00 0.00 100.0 ECONOMIC DEVELOPMENT 197,150.00 197,150.00 112,307.26 34,432.05 0.00 84,842.74 57.0 Dept: 620.623 BUSINESS INCUBATOR SUPPLIES 4219 Operating Supplies 1,000.00 1,000.00 30.84 2.12 0.00 969.16 3.1 SUPPLIES 1,000.00 1,000.00 30.84 2.12 0.00 969.16 3.1 OTHER SERVICES & CHARGES 4319 Other Professional Services 13,000.00 13,000.00 8,000.00 1,000.00 0.00 5,000.00 61.5 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 10,873.84 1,278.73 0.00 9,526.16 53.3 OTHER SERVICES & CHARGES 33,900.00 33,900.00 18,873.84 2,278.73 0.00 15,026.16 55.7 BUSINESS INCUBATOR 34,900.00 34,900.00 18,904.68 2,280.85 0.00 15,995.32 54.2 Expenditures 232,050.00 232,050.00 131,211.94 36,712.90 - 0.00 100,838.06 56.5 Net Effect for EDA 19,100.00 19,100.00 -13,409.09 -32,075.98 0.00 32,509.09 -70.2 Change in Fund Balance: -13,409.09 • Grand Total Net Effect: 29,600.00 29,600.00 -17,725.19 -52,274.77 0.00 47,325.19 59.9 REVENUE/EXPENDITURE REPORT AUGUST 31, 2003 Date: 09/02/03 Time: 11:03am CITY OF ELK RIVER Page: 1 For the Period: 01/01/03 to 08/31/03 Original Budget Amended Budget YTD Actual CURB MTH Encumbered YTD Unenc. Balance % Bud 9EDA DTED LOAN •e21 s OTHER REVENUE 3621 Interest Income 0.00 0.00 333.33 333.33 0.00 -333.33 0.0 OTHER REVENUE 0.00 0.00 333.33 333.33 0.00 -333.33 0.0 TRANSFERS IN 3921 Transfers 0.00 0.00 200,000.00 0.00 0.00 -200,000.00 0.0 TRANSFERS IN 0.00 0.00 200,000.00 0.00 0.00 -200,000.00 0.0 Revenues 0.00 0.00 200,333.33 333.33 0.00 -200,333.33 0.0 Net Effect for EDA DTED LOAN 0.00 0.00 200,333.33 333.33 0.00 -200,333.33 0.0 Change in Fund Balance: 200,333.33 Grand Total Net Effect: 0.00 0.00 200,333.33 333.33 0.00 -200,333.33 0.0 • • REVENUE/EXPENDITURE DETAIL REPORT MONTH ENDED AUGUST 31, 2003 Date: 09/02/03 Time: 11:06am CITY OF ELK RIVER Page: 3 For the Period: 08/01/03 to 08/31/03 Original Budget Amended Budget YTD Actual MTD Actual Encumbered MTD Unenc. Balance % Bud 920 EDA es TAXES 3111 Current Ad Valorem Taxes 08/12/2003 CR Ref ID: IN-LIEU TAX RENT Rcd From: SHERBURNE COUNTY 3.42 Drawer: 1 Type: TAXES 46640 Current Ad Valorem Taxes 0.00 0.00 100,636.83 3.42 0.00 -100,636.83 0.0 TAXES 0.00 0.00 100,636.83 3.42 0.00 -100,636.83 0.0 TRANSFERS IN 3949 Transfer-HRA 08/12/2003 CR Ref ID: TRANSFER Rcd From: CITY OF ELK RIVER 3,500.00 Drawer: 1 Type: MISC 46623 Transfer-HRA 0.00 0.00 3,500.00 3,500.00 0.00 -3,500.00 0.0 TRANSFERS IN 0.00 0.00 3,500.00 3,500.00 0.00 -3,500.00 0.0 Dept: 620.623 BUSINESS INCUBATOR OTHER REVENUE 3629 Miscellaneous Revenue 08/04/2003 CR Ref ID: AUG PMT Rcd From: KNOLEDGENETICA 566.75 Drawer: 1 Type: BUSIN 46557 08/28/2003 CR Ref ID: SEPT Rcd From: KNOWLEDGENETICA 566.75 Drawer: 1 Type: BUSIN 46820 Miscellaneous Revenue 0.00 0.00 7,407.10 1,133.50 0.00 -7,407.10 0.0 OTHER REVENUE 0.00 0.00 7,407.10 1,133.50 0.00 -7,407.10 0.0 BUSINESS INCUBATOR 0.00 0.00 7,407.10 1,133.50 0.00 -7,407.10 0.0 1110 Revenues 0.00 0.00 111,543.93 4,636.92 0.00 -111,543.93 0.0 Expenditures Dept: 620.621 ECONOMIC DEVELOPMENT PERSONAL SERVICES 4101 Regular Pay 08/11/2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 18,050.89 INV#: VENDOR#: 1744 30965 Regular Pay 0.00 0.00 37,492.18 18,050.89 0.00 -37,492.18 0.0 4103 Part-time Pay 08/11/2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 1,246.14 INV#: VENDOR#: 1744 30965 08/11/2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 1,800.00 INV#: VENDOR#: 1744 30965 Part-time Pay 0.00 0.00 7,315.35 3,046.14 0.00 -7,315.35 0.0 4104 PERA 08/11/2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 998.21 INV#: VENDOR#: 1744 30965 PERA 0.00 0.00 2,235.08 998.21 0.00 -2,235.08 0.0 4105 FICA 08/11/2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 1,045.57 INV#: VENDOR#: 1744 30965 08/11/2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 111.60 INV#: VENDOR#: 1744 30965 FICA 0.00 0.00 2,648.54 1,157.17 0.00 -2,648.54 0.0 4107 Medicare 08/11/2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 244.45 INV#: VENDOR#: 1744 30965 08/11/2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 26.10 INV#: VENDOR#: 1744 30965 Medicare 0.00 0.00 619.25 270.55 0.00 -619.25 0.0 4 surance /2003 AP ELK RIVER/CITY OF// MAY-JULY REIMBURSEMENTS 2,630.87 INV#: VENDOR#: 1744 30965 Insurance 0.00 0.00 5,503.32 2,630.87 0.00 -5,503.32 0.0 REVENUE/EXPENDITURE DETAIL REPORT w MONTH ENDED AUGUST 31, 2003 Date: 09/02/03 Time: 11:06am CITY OF ELK RIVER Page: 4 For the Period: 08/01/03 to 08/31/03 Original Budget Amended Budget YTD Actual MTD Actual Encumbered MTD Unenc. Balance o Bud 111111 920 EDA itures Dept: 620.621 ECONOMIC DEVELOPMENT PERSONAL SERVICES PERSONAL SERVICES 0.00 0.00 55,813.72 26,153.83 0.00 -55,813.72 0.0 SUPPLIES 4201 Office Supplies 08/11/2003 AP ELK RIVER PRINTING & VENTURE BUSINESS CARDS 45.80 INV#: 017687 VENDOR#: 1776 30992 08/11/2003 AP PRINTING SYSTEMS A/P CHECK BLANKS 186.15 INV#: 22781 VENDOR#: 3020 31090 08/11/2003 AP S & T OFFICE PRODUCTS INC MISC. OFFICE SUPPLIES 8.94 INV#: VENDOR#: 3152 31104 08/25/2003 AP ELK RIVER/CITY OF// SALES TAX REIMBURSEMENT 12.10 INV#: VENDOR#: 1744 31208 08/25/2003 AP S & T OFFICE PRODUCTS INC OFFICE SUPPLIES 24.48 INV#: VENDOR#: 3152 31303 Office Supplies 0.00 0.00 1,333.65 277.47 0.00 -1,333.65 0.0 SUPPLIES 0.00 0.00 1,333.65 277.47 0.00 -1,333.65 0.0 OTHER SERVICES & CHARGES 4304 Legal Fees 08/11/2003 AP GRAY,PLANT,MOOTY,MOOTY,BENNETT JUNE LEGAL FEES 474.45 INV#: VENDOR#: 2036 30999 Legal Fees 0.00 0.00 -20.35 474.45 0.00 20.35 0.0 4319 Other Professional Services 08/25/2003 AP EHLERS & ASSOCIATES INC INDUSTRIAL PARK PROJ CONS FEES 900.00 INV#: 21115 VENDOR#: 1728 31203 Other Professional Services 0.00 0.00 5,612.50 900.00 0.00 -5,612.50 0.0 4321 Telephone 08/25/2003 AP U S LINK MONTHLY LONG DISTANCE CHARGES 7.51 INV#: VENDOR#: 3514 31323 • Telephone 0.00 0.00 37.52 7.51 0.00 -37.52 0.0 4322 Postage 08/04/2003 AP UNITED STATES POSTAL SERVICE POSTAGE FOR METER 283.53 INV#: VENDOR#: 3533 30885 08/11/2003 AP TWIN LAKES MESSENGER SERV INC MESSENGER SERVICE 31.00 INV#: 19047 VENDOR#: 3495 31122 Postage 0.00 0.00 532.56 314.53 0.00 -532.56 0.0 4331 Travel, Conferences & Schools 08/11/2003 AP ELK RIVER AREA CHAMBER OF COM JULY MEETING 26.00 INV#: VENDOR#: 1735 30960 08/11/2003 AP ELK RIVER FORD SENSOR 11.52 INV#: VENDOR#: 1760 30972 08/11/2003 AP HALL/HEIDI// MILEAGE/BEVERAGES/TREATS/MEALS 39.93 INV#: VENDOR#: 2082 31007 08/25/2003 AP HALL/HEIDI// REGISTRATION FEE/MILEAGE 60.96 INV#: VENDOR#: 2082 31239 08/25/2003 AP WAYNE'S AUTO PARTS REPAIR PARTS 5.85 INV#: VENDOR#: 3609 31333 Travel, Conferences & Schools 0.00 0.00 5,835.69 144.26 0.00 -5,835.69 0.0 4349 Advertising/Marketing 08/11/2003 AP PORTER/M C// MTI PROGRAM RELEASE-MARKETING 1,160.00 INV#: VENDOR#: 2999 31084 Advertising/Marketing 0.00 0.00 29,763.02 1,160.00 0.00 -29,763.02 0.0 OTHER SERVICES & CHARGES 0.00 0.00 41,760.94 3,000.75 0.00 -41,760.94 0.0 TRANSFERS OUT 4721 Transfer-General Fund 08/11/2003 AP ELK RIVER/CITY OF// TRANSFER 5,000.00 INV#: VENDOR#: 1744 30964 Transfer-General Fund 0.00 0.00 5,000.00 5,000.00 0.00 -5,000.00 0.0 TRANSFERS OUT 0.00 0.00 5,000.00 5,000.00 0.00 -5,000.00 0.0 III, ECONOMIC DEVELOPMENT 0.00 0.00 103,908.31 34,432.05 0.00 -103,908.31 0.0 Dept: 620.623 BUSINESS INCUBATOR SUPPLIES 4219 Operating Supplies 08/11/2003 AP HALL/HEIDI// MILEAGE/BEVERAGES/TREATS/MEALS 2.12 INV#: VENDOR#: 2082 31007 REVENUE/EXPENDITURE DETAIL REPORT MONTH ENDED AUGUST 31, 2003 Date: 09/02/03 Time: 11:06am CITY OF ELK RIVER Page: 5 For the Period: 08/01/03 to 08/31/03 Original Budget Amended Budget YTD Actual MTD Actual Encumbered MTD Unenc. Balance % Bud 920 EDA 1111/litures Dept: 620.623 BUSINESS INCUBATOR SUPPLIES 4219 Operating Supplies Operating Supplies 0.00 0.00 30.84 2.12 0.00 -30.84 0.0 SUPPLIES 0.00 0.00 30.84 2.12 0.00 -30.84 0.0 OTHER SERVICES & CHARGES 4319 Other Professional Services 08/11/2003 AP GENESIS BUSINESS CENTERS LTD MO RETAINER-BUSINESS INCUBATOR 1,000.00 INV#: VENDOR#: 1982 30988 Other Professional Services 0.00 0.00 8,000.00 1,000.00 0.00 -8,000.00 0.0 4412 Building Rent 08/11/2003 AP HICKMAN/LARRY// AUGUST BSNS INCUBATOR RENT 1,278.73 INV#: VENDOR#: 2135 31020 Building Rent 0.00 0.00 10,873.84 1,278.73 0.00 -10,873.84 0.0 OTHER SERVICES & CHARGES 0.00 0.00 18,873.84 2,278.73 0.00 -18,873.84 0.0 BUSINESS INCUBATOR 0.00 0.00 18,904.68 2,280.85 0.00 -18,904.68 0.0 Expenditures 0.00 0.00 122,812.99 36,712.90 0.00 -122,812.99 0.0 Net Effect for EDA 0.00 0.00 -11,269.06 -32,075.98 0.00 11,269.06 0.0 • 1 S