Loading...
HomeMy WebLinkAbout3.A. Transit Budget ~.Pt. CITY OF SHAKOPEE 2007 TRANSIT FUND BUDGET DIVISION: COMMUNITY DEVELOPMENT ACTIVITY: The transit system began operation in September of 1984. As the result of legislation passed in 2001, funding now comes from the Minnesota Vehicle Excise Tax (MVET) , and is passed from the Minnesota Department of Revenue through the Metropolitan Council. Service is comprised of: 1) circulator service, 2) van pools for trips outside of Shakopee and 3) a dial-a-ride service for trips within the City limits. The City contracts with Scott County Transit for circulator and dial-a-ride services and VPSI for van pool services. The City's circulator service connects with service provided by Scott County to the Burnsville Transit Hub. OBJECT DESCRIPTION: Description of line items: Wages & Benefits: Salaries: Share of City Staff. Professional Services: Contracts with transit providers, Le. Scott County Transit and VPSI. Communications: Advertising: Additional advertising to increase ridership in Van Pools, Dial A Ride and the Express route $50,000. Dues/Training/Travel: Dues: Suburban Transit Association $5,000. Capital: CR 16 transit site $580,000, CR 18 transit station phase II $751,000. Transfer out: Transfer to General Fund for general overhead and support. CITY OF SHAKOPEE, MINNESOTA 2007 Budget TRANSIT FUND BUDGET SUMMARY 2004 2005 2006 2007 Actual Actual Budaet Proposed Revenue Property Taxes $ 223 $ - $ - $ - State Grants 810,005 867,648 863,401 799,580 Fares 41,577 57, 131 100,000 152,760 Interest 29,804 30,641 30,000 8,500 Total Revenue 881,609 955,420 993,401 960,840 Expenditures Personal Services 15,022 11,320 17,250 21,640 Supplies & Services 599,325 804,570 843,250 913,820 Capital 13,845 1,331,000 Total Expenditures 614,347 829,735 860,500 2,266,460 Excess of Revenues over Expenditures 267,262 125,685 132,901 (1,305,620) Sale of Property 7,274 Transfer to General Fund (11,200) Excess of Revenues and Other Sources Over Expenditures and Other Uses $ 267,262 $ 132,959 $ 132,901 $ (1,316,820) Fund Balance $ 1,211,339 $ 1,485,530 $ 1,618,431 $ 301,611 Transit 2007 Budget 2142 2143 2144 2146 Object # Description Dial-A-Ride Vanpool Circulator Express Total 6002 Wages FT - Reg. 3,230 6,270 9,500 19,000 6005 Wages aT - Reg. - 6015 Wages PT - Temp - 6122 PERA 200 390 590 1,180 6124 FICA 250 480 730 1 ,460 6135 Health & Life 6145 Dental 6170 Workers Comp - 6180 Compensated Absences - 6190 Retirement Benefit - Total Personnel 3,680 7,140 10,820 21,640 6210 Operating Supplies 250 250 6222 Motor Fuels & Lubricants - 6230 Building. Maintenance - 6240 Equipment Maintenance - 6310 Attorney - 6314 Computer Services - 6315 Building Maintenance 13,500 13,500 6316 Equipment Maintenance - 6324 Transportation 59,510 93,590 226,800 393,040 772,940 6327 Other Prof Services 10,000 20,000 30,000 60,000 6332 Postage, - 6334. Telephone - 6336 Printing/Publishing - 6338 Advertising 10,000 20,000 20,000 50,000 6350 Insurance - 6352 Liability Insurance 5,000 5,000 6360 Utility Service 1,500 1,500 6365 Gas - 6367 Refuse - 6400 Rentals - 6410 LOGIS - 6420 Equipment Rent - 6425 Equipment Rent (IS FUND) - 6430 Building Rent (IS FUND) - 6435 Other Rent - 6472 Conf / School/ Training 600 600 600 1,800 6475 Travel/Subsistence 500 500 500 1,500 6480 Dues 5,100 1,100 1,130 7,330 . 6490 Subscriptions/Publications - Total Supplies & Services 90,710 269,000 460,520 913,820 6740 Capital Expenditures 1,331,000 1,331,000 Total $ 94,390 $ 1,607,140 $ 471,340 $ 2,266,460 R5509BUD LOGIS001 CITY OF SHAKOPEE 10/20/20069:11:19 Fiscal Period: 9 1 06 Budget Report Page - 1 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual . Budget Budget Budget Budget 02140 TRANSIT 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4010 PROPERTY TAX 4011 CURRENT, PROPERTY TAX 606 54 4012 DELINQUENT PROPERTY TAX 1,480- 193- 86- 4015 FISCAL DISPARITIES 69- 29- 4020 MOBIL HOME TAX 1- 4031 EXCESS TAX INCREMENT 0- 4010 PROPERTY TAX 944- 223- 32- 4005 TAXES 944- 223- 32- 4200 LICENSES AND PERMITS 4400 INTERGOVERNMENTAL 4450 STATE GRANTS & AIDS 827,798- 810,005- 867,648- 629,923- 650,000- 799,580- 799,580- 799,580- 4450 STATE GRANTS & AIDS 827,798- 810,005- 867,648- 629,923- 650,000- 799,580- 799,580- 799,580- 4400 INTERGOVERNMENTAL 827,798- 810,005- 867,648- 629,923- 650,000- 799,580- 799,580- 799,580- 4500 CHARGES FOR SERVICE 4670 PUBLIC WORKS 4690 TRANSIT FARES 44,739- 41,577- 57,131~ 31,963- 40,000- 144,890- 152,760- 152,760- 4670 PUBLIC WORKS 44,739- 41,577- 57,131- 31,963- 40,000- 144,890- 152; 760- 152,760- 4500 CHARGES FOR SERVICE 44,739- 41,577- 57,131- 31,963- 40,000- 144,890- 152,760- 152,760- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 29,068- 29,804- 30,641- 17,301- 30,000- 15,000- 8,500- 8,500- 4832 INVESTMENT INCOME 29,068- 29,804- 30,641- 17,301- 30,000- 15,000- 8,500- 8,500- 4830 MISCELLANEOUS 29,068- 29,804- 30,641- 17,301- 30,000- 15,000- 8,500- 8,500- 4960 PROCEEDS FROM DEBT ISSUED 4001 REVENUES 902,549- 881,608- 955,452- 679,187- 720,000- 959,470- 960,840- 960,840- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 5,635 11,889 7,401 8,694 17,500 19,000 19,000 19,000 6002 WAGES 5,635 11,889 7,401 8,694 17,500 19,000 19,000 19,000 R5509BUD LOGIS001 CITY OF SHAKOPEE 10/20/20069:11:19 Fiscal Period: 9 1 06 Budget Report Page - 2 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code I Description Amount Amount Amount Actual Budget Budget Budget Budget 6100 BENEFITS 6122 PERA 312 658 409 502 1,050 1,180 1,180 1,180 6124 FICA 404 842 517 627 1,340 1,460 1,460 1,460 6135 HEALTH 508 1,479 727 887 1,800 6139 POST EMPLOYMENT HEALTH PLAN 21 40 23 27 6140 LlFElL TO 22 58 28 35 6145 DENTAL 23 56 26 34 6100 BENEFITS 1,290 3,133 1,729 2,112 4,190 2,640 2,640 2,640 6001 WAGES & BENEFITS 6,925 15,022 9,130 10,806 21,690 21,640 21,640 21,640 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6210 OFFICE SUPPLIES 56 113 250 250 250 250 6222 MOTOR FUELS & LUBRICANTS 13,544 14,506 30,000 6240 EQUIPMENT MAINTENANCE 44 15,720 6201 SUPPLIES & SERVICES 13,544 14,605 15,720 113 30,250 250 250 250 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 28,000 30 6312 ENGINEERING CONSULTANTS 424 6315 BUILDING MAINT. 1,488 13,500 13,500 6324 TRANSPORTATION 473,421 504,569 554,349 378,669 687,500 667,050 772,940 772,940 6327 OTHER PROF SERVICES 12,501 19,842 65,909 19,034 30,000 60,000 60,000 60,000 6300 PROFESSIONAL SERVICES 485,922 552,411 621,776 398,127 717,500 727,050 846,440 846,440 6330 COMMUNICATIONS 6336 PRINTING/PUBLlSHING 3,287 2,188 398 11 30,000 6338 ADVERTISING 3,910 19,649 17,348 19,D43 20,000 50,000 50,000 50,000 6330 COMMUNICATIONS 7,197 21,837 17,746 19,054 50,000 50,000 50,000 50,000 6350 INSURANCE 6352 LIABILITY 4,217 4,364 4,219 4,473 4,500 5,000 5,000 5,000 6350 INSURANCE 4,217 4,364 4,219 4,473 4,500 5,000 5,000 5,000 6360 UTILITY SERVICE 271 124 500 1,500 1,500 1,500 6362 ELECTRIC 154 284 233 6360 UTILITY SERVICE 271 278 284 233 500 1,500 1,500 1,500 R5509BUD LOGIS001 CITY OF SHAKOPEE 10/20/20069:11:19 Fiscal Period: 9 1 06 Budget Report Page - 3 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget 6400 RENTALS 6470 DUES/TRAININGITRAVEL 6472 CONFERENCElSCHOOLlTRAINING 1,800 1,800 1,800 6475 TRAVEUSUBSISTENCE 227 346 74 1,500 1,500 1,500 6480 DUES 4,780 5,484 5,742 6,046 5,000 7,330 7,330 7,330 6470 DUES/TRAININGITRAVEL 5,007 5,830 5,816 6,046 5,000 10,630 10,630 10,630 6200 SUPPLIES AND SERVICES 516,158 599,325 665,560 428,046 807,750 794,430 913,820 913,820 6500 DEPRECIATION 6600 MISCELLANEOUS 6700 CAPITAL OUTLAY 6710 LAND 580,000 580,000 580,000 6730 BUILDINGS 808 751,000 751,000 751,000 6740 EQUIPMENT 13,845 6700 CAPITAL OUTLAY 808 13,845 1,331,000 1,331,000 1,331,000 6800 DEBT SERVICE 6840 DEBT SERVICE INTEREST 6000 EXPENDITURES 523,891 614,348 688,535 438,852 829,440 2,147,070 2,266,460 2,266,460 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 11,200 11,200 11,200 8052 TRANSFERS OUT 11,200 11,200 11,200 8080 RESIDUAL EQUITY TRANSFERS 8101 PROCEEDS FROM SALE (GAIN/LOSS) 7,274- 8080 RESIDUAL EQUITY TRANSFERS 7,274- 8050 TOTAL TRANSFERS OUT 7,274- 11,200 11,200 11,200 R5509BUD LOGIS001 CITY OF SHAKOPEE 10/20/20069:11:19 Fiscal Period: 9 1 06 Budget Report Page - 4 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget 4000 REVENUES AND EXPENDITURES 378,658- 267,261- 274,191- 240,336- 109,440 1,198,800 1,316,820 1,316,820 02140 TRANSIT 378,658- 267,261- 274,191- 240,336- 109,440 1,198,800 1,316,820 1,316,820 \ 2007 SHAKOPEE TRANSIT SERVICE PLAN - REV 10-23-06 ct::: ""'~ 2007 SHAKOPEE TRANSITSERVICE PLAN - REV 10-23'1)6 BASELINE SERVICE Hours Rate Cost Rides Revenue Net Cost Miles 1 D1AL-A-RIDE Service Costs 1,360.00 $ 41.00 $ 55,760.00 6,250 $ 10,937.50 $ 44,822.50 17,090.00 (3 Months Jan - Mar) Fuel Costs $ 1,250.00 a Maint. Costs $ 2,500.00 Total Dial-A-Ride 1,360.00 $ 59,510.00 6,250 $ 10,937.50 $ 48,572.50 17,090.00 ROUTE 496E & W,496S (1/1/07 - 10/26/07) Service Costs 4,330.00 $ 41.00 $ 177,530.00 10,450 $ 10,450.00 $ 167,080.00 87,250.00 Fuel Costs $ 3,770.00 Maint. Costs $ 6,664.00 Sub- Total Rte 496 4,330.00 $ 187,964.00 10,450 $ 10,450.00 $ 167,080.00 87,250.00 ROUTE 496E & W, 496S (10/27/07 - 12/31/07) Service Costs 870.00 $ 42.23 $ 36,740.10 2,050 $ 2,050.00 Fuel Costs $ 755.00 Maint. Costs $ 1,340.00 Sub- Total Rte 496 870.00 $ 38,835.10 2,050 $ 2,050.00 $ - 0.00 Total Route 496E, W, & S 5,200.00 $ 226,799.10 12,500 $ 12,500.00 $ 214,299.10 87,250.00 VA NPOOL Service Costs 2,030.00 $ 75,385.00 15,250 $ 16,775.00 $ 58,610.00 67,155.00 Fuel Costs $ 14,200.00 Maint. Costs $ 300.00 Other Costs $ 3,700.00 Total Vanpool 2,030.00 $ 93,585.00 15,250 $ 16,775.00 $ 58,610.00 67,155.00 ROUTE 495 Service Costs 660.00 $ 41.00 $ 27,060.00 1,625 $ 1,475.00 , $ 25,585.00 12,800.00 (3 Months Jan - Mar) Fuel Costs $ 250.00 Maint. Costs $ 225.00 Total Route 495 660.00 $ 27,535.00 1,625 $ 1,475.00 $ 25,585.00 12,800.00 TOTAL BASELINE SERVICE 9,250.00 - $ 407,429.10 35,625.00 $. 41,687.50 $ 347,066.60 184,295.00 Page 1 10/27/2006 2007 SHAKOPEE TRANSIT SERVICE PLAN - REV 10-23-06 SERVICE ENHANCEMENTS Hours Rate Cost Rides Revenue Net Cost Miles EXPRESS SERVICE Service Costs 2,500.00 $ 125.00 $ 312,500.00 45,900 $ 111,078.00 $ 201,422.00 93,140.00 (3-15-07 - 12/31/07) Fuel Costs $ 32,000.00 (3 AM Runs, 3 PM Runs) Maint. Costs $ 21,000.00 Total Express Service 2,500.00 $ 365,500.00 45,900 $ 111,078.00 $ 254,422.00 93,140.00 ROUTES 498 Ala (3-15-07 - 10-26-07) Service Costs 1,264.00 $ 41.00 $ 51,824.00 18,960 $ - $ 51,824.00 29,350.00 (10-27-07 - 12-31-07) Service Costs 380.00 $ 42.23 $ 16,047.40 5,700 $ - $ 16,047.40 14,670.00 (6 AM Runs, 6 PM Runs) Fuel Costs $ 2,500.00 $ 2,500.00 Maint. Costs $ 2,250.00 $ 2,250.00 1,644.00 $ 72,621.40 24,660 $ - $ 72,621.40 44,020.00 TOTAL SERVICE ENHANCEMENTS 4,144.00 - 438,121.40 70,560.00 111,078.00 327,043.40 137,160.00 TOTAL 2007 SERVICE COSTS ~ 13,394.00 I - I 845,550.50 I 106,185.00~ 152,765.50 I 674,110.00 I 321,455.00 ~ Page 2 10/27/2006