Loading...
HomeMy WebLinkAbout2004 APTA 004 CURRENT & CAPIT AL BUDGETS .AJAX PICKERING. AUTH 0 R ITV .TA As Submitted to the APTA Board of Management May 25,2004. I APTA 2004 CUIdENT & CAPITAL BUDGETS CURRENT Summaries Administration Maintenance Go Transit Service Conventional Special Services Transitional Costs Additional Requirements CAPITAL Summary Administration Maintenance Conventional Special Services Transitional Costs TABLE OF CONTENTS DEPT.# 2910 2920 2925 2930 2940 2945 2947 2910 2920 2930 2940 2945 PAGE NO. 1 4 10 16 19 23 26 27 30 31 33 35 37 39 Revenues: Bus Fare & Other Estimated GST Rebate A Total Revenues Expenditures: APTA CORE Add. Requirements Sub-Total AJAX PICKERING TRANSIT AUTHORITY FINANCIAL OVERVIEW 2004 BUDGET 2003 INCREASE BUDGET (DECREASE) ($3,364,840) ($818,500) (130,000) ($3,364,840) ($948,500) $8,184,156 123,070 $8,307,226 $1,526,591 (90,559) $1,436,032 Transitional $143,385 Excess Expenditures Over Revenue B Total Expenditures $8,450,611 C Total Current (A + B) $5,085,771 CAPITAL: Core $2,225,000 Transitional 509,230 Total Capital $2,734,230 Less: Ontario Transit Renewal Sub. (619,998) D Net Capital $2,114,232 Total Request (C+D) $7,200,003 Percentage Change - Current and Capital Ajax Ajax's Share Current Ajax's Share Transitional Ajax's Share Capital Total Contribution Pickering Pickering's Share Current Pickering's Share Transitional Pickering's Share Capital Total Contribution TOTAL ($143,385) 170,849 $1,463,496 9.62% Percentage Change Percentage Chanae 16.01% -100.00% 8.40% 11.29% -100.00% 8.40% 8.no" The capital for each municipality is net of the Provincial subsidy and Is cost shared equally between both parties. Comments * The 2004 costs associated with the Transitional Budget have been moved to the appropriate APT A cost centres to better facilitate reporting requirements. Assumes All of APT A Capital Cost Shared 50%. 2002 - APTA Operational Exps. Cost Shared 57.47% Pickering & 42.53% Ajax. 2003 - APTA Operational Exps. Cost Shared 56.94% Pickering & 43.06% Ajax. 2004 - APT A Operational Exps. Cost Shared 55.92% Pickering & 44.08% Ajax. $514,996 $169,925 (84,230) $85,695 91,997 $177,692 $692,688 Municipal Cost Sharina Summary 2003 INCREASE ~ DECREASE $2,128,191 $340,627 61,742 (61,742) 1.057.116 88846 $3,247,049 $367,731 $2,814,195 $317,754 81,643 (81,643) 1.057,116 88846 $3,952.954 $324 957 $7200003 ~ The above information reflects the deletions made at the May 25, 2004 APT A Board of Management meeting. ( Land $65k and Pontoon Boat $30k ). 1 APT A 2004 Current Budget APT A 2003 2003 INCREASE ACTUAL BUDGET (DECREASE) EXPENDITURES 1100 Salaries & Wages $5,071,656 $4,765,539 $441,314 $5,206,853 9.26% 1200 Overtime $183,388 $131,781 $8,448 $140,229 6.41% 1400 Employer Contributions $1,199,947 $1,021,250 $454,580 $1,475,830 44.51 % 1900 Uniforms $47,009 $54,365 ($505) $53,860 -0.93% 2110 Travel $6,181 $3,800 $1,370 $5,170 36.05% 2122 Courier $9,595 $16,200 ($7,500) $8,700 -46.30% 2131 Cellular Phones & Pagers $63,197 $70,950 $4,035 $74,985 5.69% 2195 Charter Subsidies $0 $25,000 $0 $25,000 0.00% 2210 Advertising $9,714 $7,500 $1,500 $9,000 20.00% 2220 Subscription & Publications $805 $500 $500 $1,000 100.00% 2340 Seminars & Education $22,860 $34,265 ($15,110) $19,155 -44.10% 2370 Insurance Premium $193,704 $175,800 $41,700 $217,500 23.72% 2371 Ins. Deductible $2,443 $10,000 $5,000 $15,000 50.00% 2392 Consulting & Professional $123,705 $61,900 ($21,500) $40,400 -34.73% 2394 Recpt, Prom & Sp Events $12,126 $10,550 $1,500 $12,050 14.22% 2395 Memberships $9,770 $10,000 ($4,800) $5,200 -48.00% 2396 Photo, Mapping, Printing $23,078 $38,300 $10,700 $49,000 27.94% 2399 Outside Agency Serv $0 $0 $7,000 $7,000 0.00% 2440 Snow Removal $58,490 $33,500 $26,500 $60,000 79.10% 2435 Build Repairs & Mtce $73,882 $46,036 $1,464 $47,500 3.18% 2457 Veh - Repairs & Maintenance $687,740 $444,400 $61,370 $505,770 13.81% 2458 Contract Labour $0 $0 $0 $0 0.00% 2458 Contract Labour $8,601 $44,000 $0 $44,000 0.00% 2459 Contracted Mechanical $148,211 $126,250 ($3,000) $123,250 -2.38% 2460 Vehicle Licences $22,390 $22,100 $4,900 $27,000 22.17% 2478 Misc Equip Repairs $709 $2,900 $1,400 $4,300 48.28% 2478 Contracted Maintenance $11,910 $23,100 $8,150 $31,250 35.28% 2635 Building Rentals $84,595 $84,595 $0 $84,595 0.00% 2657 Rental Vehicle $20,333 $30,000 ($10,000) $20,000 -33.33% 2815 Leased Vehicles $134 $0 $0 $0 0.00% 2819 Bank, Admin. Charges $9,059 $10,000 $0 $10,000 0.00% 5300 Stationery & Office Supplies $17,257 $14,000 $3,200 $17,200 22.86% 5301 Printing Supplies $4,614 $3,100 $0 $3,100 0.00% 5305 Water Purifies Coffee Supplies $4,264 $4,500 $0 $4,500 0.00% 5510 Utilities - Water $2,380 $3,000 $180 $3,180 6.00% 5520 Utilities - Gas $31,356 $45,000 ($3,000) $42,000 -6.67% 5530 Utilities - Hydro $34,670 $44,000 $6,160 $50,160 14.00% 5900 Gas, Oil Tires $695,384 $631,450 $254,560 $886,010 40.31 % 5901 Contracted Fuel $194,884 $161,000 $45,600 $206,600 28.32% 5902 Misc Equip & Tools (under $8,837 $4,500 $1,500 $6,000 33.33% 5903 Shop Supplies $82,573 $45,000 $15,700 $60,700 34.89% 5905 Furniture & Equipment $28,256 $47,410 ($21,010) $26,400 -44.32% 5910 Property Taxes $0 $0 $68,300 $68,300 0.00% 1----- 5910 Signage ( APT A ) $12,359 $20,000 ($20,000) $0 -100.00% -- 2 APT A i 2004 Current Budget APTA Run Date : 5f7/200412:28 PM R rtN Cu IB d I e ame: rren UQae 2003 2003 INCREASE % CHANGE ACTUAL BUDGET (DECREASE) 2004 VS. 2003 5915 Commission/General $0 $0 $13,000 $13,000 0.00% Options $0 $123,070 ($90,559\ $32,511 -73.58% Total EXPENDITURES $9,222,071 $8,450,611 $1,292,647 $9,743,258 15.30% REVENUES 9940 Advertising ($281,990) ($277,500) ($23,720) ($301,220) 8.55% 9950 Go Transit Service ($74,016) $0 ($220,OOO) ($220,OOO) 0.00% 9950 POS Revenue ($474,759) ($250,OOO) ($233,485) ($483,485) 93.39% 9950 Farebox - Conventional ($1,116,607) ($1,150,000) $76,000 ($1,074,OOO) -6.61 % 9950 Farebox - Special Services ($71,239) ($46,800) ($11,860) ($58,660) 25.34% 9950 Fare Integration Revenue ($1,002,603) ($950,000) ($101,575) ($1,051,575) 10.69% 9950 School Board Revenue ($693,226) ($600,000) ($85,OOO) ($685,000) 14.17% 9950 NSF Fees ($20) $0 $0 $0 0.00% 9950 Commission Fees $12,955 $600 ($600) $0 -100.00% 9952 Local Charters ($38,816) ($36,140) $1,140 ($35,000) -3.15% 9952 Charters - DC / UOIT ($124,350) $0 ($200,000) ($200,000) 0.00% 9960 Commissions / General ($3,220) ($4,000) $0 ($4,OOO) 0.00% 9990 Interest Revenue ($7,898) $0 ($8,000) ($8,000) 0.00% 9990 Camp Revenue ($63,118) ($51,000) ($11,400) ($62,400) 22.35% 9990 Misc. Maintenance Income ($53,033) $0 $0 $0 0.00% Total REVENUES ($3,991,939) ($3,364,840) ($818,500\ ($4,183,340) 24.33% Net $5,230,132 $5,085,771 $474,147 $5,559,918 9.32% 3 APT A 2004 to 2006 THREE YEAR Current Budget Summary 2910 Administration EXPENDITURES ~--~----- _n______----~-~---------------- 1100 Salaries & Wages 1200 Overtime 1400 Employer Contributions___- 2110Travel 2122 Courier 2131 Cellular Phones & Pagers ----~~ 2195 Charter Subsidies 2210 Advertising- u- 2220 Subscription & Publications 2340 Seminars & Education 2370 Insurance Premium 2371 Ins. Deductible 2392 Consulti~_Q~_~rofessional 2394 Recpt, Prom & Sp Events - ----- - - 2395 Memberships 2396 Photo, Mapping, Printing ---------- -------------------------- 2399 Outside Agency Se_rv-- 2478 Contracted Maintenance 2819 Bank, Admin. Charges -------- ------ - 5300 Stationery & Office Supplies 5301 Printing Supplies - - 5305 Water Purifies Coffee Supplies 5905 Furniture & Equipment - _5910 Property Taxes --------- --______n___- - -------------- ------- ------ -------- ------ ------ ----- ------------- -_u- ------ ----- - ------- --- ------ --- --------------- ----------- REVENUES -----______n_- --- - -- ------- 9940 Advertising -- -- - - ---~------- 9960 Commissions I General -----______n__- _n______------ _n- - - --------- 9990 Interest Revenue ------------ ---------------- n- Net 5 Run Date: SflI2004 12:28 PM Report Name: Three Year Budget Summary 20051 2006 BUDGET BUDGET ----------_u_____n__~ $555,616 $572,181 $2,000 $2,000 $153,210 $155,410 ~§~~4êl---_~5,379 $8,831! $9,052 ----------- --------:T----- $76,110j $78,013 __j2§,}..I5í $26,009 --- ~~J~_5 ---- $9,363 $1,015 $1,040 $8,780 $9,000 - $21L91Q __~~23,358 _____$15,2_?_? - $15,606 $91,0071 $42,032 ~__jJ_2,2}J_~ $12,536 $5,278 $5,41Q $49,7351 --.. $50,978 $7,105: $7,283 --_.$37,719 $38,512 $1 0, 150___~J~404 $17,458 11},894 $3,147 $3,226 ~,568 __$4,682 $406 $416 ----------- $69325 $71 058 $1 3865841 $1 370 842 -- $1 044976 APT A 2004 Current Budget 2910 Administration Run Date: 5/7/200412:28 PM C B Re rt Name: urrent udaet 2003 2003 INCREASE % CHANGE ACTUAL BUDGET (DECREASE) 2004 VS. 2003 EXPENDITURES 1100 Salaries & Wages $350,338 $504,921 $34,386 $539,307 6.81% 1200 Overtime $126 $2,000 $0 $2,000 0.00% 1400 Employer Contributions $144,413 $123,765 $27,470 $151,235 22.20% 2110 Travel $6,181 $3,800 $1,370 $5,170 36.05% 2122 Courier $9,595 $16,200 ($7,500) . $8,700 -46.30% 2131 Cellular Phones & Pagers $63,197 $44,350 $30,635 $74,985 69.08% 2195 Charter Subsidies $0 $25,000 $0 $25,000 0.00% 2210 Advertising $9,714 $7,500 $1,500 $9,000 20.00% 2220 Subscription & Publications $805 $500 $500 $1,000 100.00% 2340 Seminars & Education $17,542 $23,065 ($14,415) $8,650 -62.50% 2370 Insurance Premium $193,704 $175,800 $38,890 $214,690 22.12% 2371 Ins. Deductible $2,443 $10,000 $5,000 $15,000 50.00% 2392 Consulting & Professional $75,507 $13,400 $27,000 $40,400 201.49% 2394 Recpt, Prom & Sp Events $12,126 $10,550 $1,500 $12,050 14.22% 2395 Memberships $5,064 $5,000 $200 $5,200 4.00% 2396 Photo, Mapping, Printing $23,078 $23,300 $25,700 $49,000 110.30% 2399 Outside Agency Serv $0 $0 $7,000 $7,000 0.00% 2478 Contracted Maintenance $11,910 $23,100 $8,150 $31,250 35.28% 2819 Bank, Admin. Charges $9,059 $10,000 $0 $10,000 0.00% 5300 Stationery & Office Supplies $17,257 $14,000 $3,200 $17,200 22.86% 5301 Printing Supplies $4,614 $3,100 $0 $3,100 0.00% 5305 Water Purifies Coffee Supplies $4,264 $4,500 $0 $4,500 0.00% 5905 Furniture & Equipment $3,671 $3,620 ($3,220) $400 -88.95% 5910 Property Taxes $0 $0 $68,300 $68,300 0.00% Total EXPENDITURES $964,609 $1,047,471 $255,666 $1,303,137 24.41 % REVENUES 9940 Advertising ($281,990) ($277,500) ($23,720) ($301,220) 8.55% 9960 Commissions I General ($3,220) ($4,000) $0 ($4,000) 0.00% 9990 Interest Revenue ($7,898) $0 ($8,000) ($8,000) 0.00% Total REVENUES ($293,108) ($281,500) ($31'720~ 11.27% - Net $671,501 $765,971 $223,946 $989,917 29.24% 4 APTA 2004 Background Information Run Date: 51712004 12:27 PM Reoort Name: Backaround Info. with Totals 2004 BUDGET 2910 Administration Expenses 2910.1100.0001 Salaries & Wages-FIT <-> Base Salaries and Wages Total 2910.1100.0001 Salaries & Wages-FIT 2910.1100.0002 Salaries & Wages-PIT <-> Wages <-> Vacation Coverage <-> Sick Coverage <-> Part Time Vacation @ 6% <-> Part Time Payment in Lieu of Benefits ($2.66/hr) Total 2910.1100.0002 Salaries & Wages-PIT 2910.1200.0001 Overtime - FIT <-> Office Staff TotaI2910.1200.0001 Overtime - FIT 2910.1400.0000 Employer Contributions <-> This item includes mandatory deductions (CPP., EI., EHT., ) and employer provided benefits such as dental and optical, includes full OMERS contribution. Total 2910.1400.0000 Employer Contributions 2910.2110.0000 Travel <-> Travel allowance Total 2910.2110.0000 Travel 2910.2122.0000 Courier Services <-> Secur-Cor (Delivery of Bank Deposits) ($625 x 12 mos) <-> Purolator (Miscellaneous Courier charges) <-> Postage Total 2910.2122.0000 Courier Services 2910.2131.0000 Telephone <-> Charges for 15 lines (APTA-East & West) <-> Cellular (12) ($1,000 per mo.) <-> Long Distance Charges <-> Telephone and line charges <-> Contracted Repairs / Service -- Bell & Telcorp <-> Data Link (APTA to Ajax Town Hall) ($550/mo) <-> T-1 Link (APTA to Pickering Civic) ($1 ,448/mo + taxes) Total 2910.2131.0000 Telephone 2910.2195.0000 CHARTER SUBSIDIES <-> Charter Subsidies Total 2910.2195.0000 CHARTER SUBSIDIES 2910.2210.0000 Advertising <-> To provide brochure advertisement ($700 x 8) <-> Radio Advertising (Newspaper/Ajax Homeweek & service announcements) ($500 x 6) Total 2910.2210.0000 Advertising 2910.2220.0000 Subscript'n & Publicat'n <-> Reference Material <-> Training Manuals Total 2910.2220.0000 Subscript'n & Publicat'n 6 $510,500 $510,500 $20,034 $3,390 $1,849 $1,516 $2,018 $28,807 $2,000 $2,000 $151,235 $151,235 $5,170 $5,170 $7,500 $600 $600 $8,700 $15,000 $12,000 $2,000 $12,185 $7,200 $6,600 $20,000 $74,985 $25,000 $25,000 $6,000 $3,000 $9,000 $500 $500 $1,000 APTA 2004 Background Information 2910 Administration Run Date: 5f71200412:27 PM ReDOrt Name: Backaround Info. with Totals 2004 BUDGET 2910.2340.0000 Education & Training <-> Computer Training (4 x $300) <-> Exceptional Assistant x 1 @ $350 <-> First Aid and Diploma Courses ( 2 persons @ $350 ea. ) <-> Marketing Course <-> C. U. T. A. Spring Conference (2) Newfoundland - June/04 <-> C.U.T.A. Winter Conference (2) Montreal Nov/04 <-> Deleted - C.U.T.A. Winter Conference (2) Montreal Nov/04 <-> O.C.T.A. Seminar - Spring <-> Deleted - O.C.I.A. Seminar - Spring <-> Board of Management Training <-> Deleted - Board of Management Training <-> Management Training <-> Deleted - Management Training <-> Diploma Courses <-> Deleted - Diploma Courses Total 2910.2340.0000 Education & Training $1,200 $350 $700 $400 $6,000 $3,250 ($3,250) $3,000 ($3,000) $500 ($500) $500 ($500) $1,000 ($1,000) $8,650 2910.2370.0000 Insurance Premiums <-> Conventional Vehicles <-> Specialized Services Vehicles <-> Admin. (Building) <-> Increase to reflect anticipated market conditions (12%) <-> NEW -- Environmental Policy <-> Less GO Transit Storage Insurance (Refer to Acct. #2925) Total 2910.2370.0000 Insurance Premiums $172,200 $14,400 $6,100 $23,300 $1,500 ($2,810) $214,690 2910.2371.0000 Insurance - Direct Pymt <-> Deductible Total 2910.2371.0000 Insurance - Direct Pymt $15,000 $15,000 2910.2392.0001 Consulting & Professional <-> Recruitment Fees (2 ads) <-> Warren Sheppell Employee Wellness ($450/mo.) <-> Consulting - Telephone System <-> Consulting - Route & Service Review - Phase 1 <-> Deferred to 2005 - Consulting - Route & Service Review - Phase 1 TotaI2910.2392.0001 Consulting & Professional 2910.2392.0002 Consulting & Professional-- Legal <-> Audit Fees <-> Legal Fees - Labour Consultation/Representation <-> New -- Legal Fees - Contract Negotiations Total 2910.2392.0002 Consulting & Professional -- Legal 2910.2394.0001 Spec Events/Photo/Prom <-> Transit Planning <-> Regional Coordination <-> Community Events <-> Driver Awards <-> Pins/Hats $5,000 $5,400 $3,500 $50,000 ($50,000) $13,900 $6,500 $10,000 $10,000 $26,500 $200 $500 $1,350 $2,500 $650 7 APTA 2004 Background Information Run Date: 5/7/2004 12:27 PM ReDar! Name: Backaround Info. with Totals 2004 BUDGET 2910 Administration <-> <-> <-> <-> Driver Day-Timers Incentive Awards Advisory Committee P/R ($125 x 1 mtg) Plaques Customer Handouts - Magnets, mousepads, bus pass holders TotaI2910.2394.0001 Spec Events/Photo/Prom <-> 2910.2394.0002 Meetings/Receptions <-> Transit Business Meetings <-> Christmas Driver Appreciation <-> Staff/Driver Meetings TotaI2910.2394.0002 Meetings/Receptions 2910.2395.0000 Memberships <-> Canadian Urban Transit Association Member Fees <-> Canadian Heritage Foundation Total 2910.2395.0000 Memberships 2910.2396.0000 Mapping, Printing <-> Print Annual Report <-> Bus Pass Printing <-> Interior Bus Sign Printing <-> Bus Tickets <-> Bus Transfers ($650 x 8) <-> Specialized Services Promotional Brochure <-> Route Schedules ($600 x 6) <-> Re-Print Transit Route Maps / Schedules Total 2910.2396.0000 Mapping, Printing 2910.2399.0000 Outside Agency <-> New -- Web-Site Maintenance Total 2910.2399.0000 Outside Agency 2910.2478.0002 Contracted Maintenance <-> Coin Counter & Roller Maintenance <-> Photocopy, Fax, Emergency Repairs <-> Radio Licence Renewal <-> Trapeze Maintenance Contract - Payable @ $8,800IYr. <-> Software Annual Licence Fees (Oracle @ $1,500, Novell @ $5,500) <-> Alarm Service Doors ($419/6 mos) <-> Extended Warranty & Computer Repairs <-> Telcorps Maintenance Agreement ($975/yr + tax) <-> Warranty for the SOL and Scheduler Servers (Nov 19, 2004 - Nov 19, 2005) TotaI2910.2478.0002 Contracted Maintenance 2910.2819.0000 Bank, Admin Charges <-> Service charges ($612/mo), On-line Support - $1 ,818/yr, Merchant Fees ($45/mo), Wire transfer of funds, etc Total 2910.2819.0000 Bank, Admin Charges 2910.5300.0000 Stationary & Office Supp <-> General Stationery & Office Supplies <-> Coin Wrappers 8 $650 $2,000 $150 $300 $500 $8,800 $1,000 $1,750 $500 $3,250 $5,100 $100 $5,200 $2,500 $9,000 $300 $6,500 $6,000 $1,000 $3,700 $20,000 $49,000 $7,000 $7,000 $2,500 $2,600 $1,800 $8,800 $7,000 $900 $2,500 $1,100 $4,050 $31,250 $10,000 $10,000 $6,000 $2,500 APTA 2004 Background Information 2910 Administration Run Date: 5nt20O412:27 PM Reoort Name: Backaround Info. with Totals 2004 BUDGET <-> <-> Computer Related Supplies Laminating Supplies Miscellaneous Supplies Security F. O. B. Total 2910.5300.0000 Stationary & Office Supp $4,500 $1,000 $3,000 $200 $17,200 <-> <-> 2910.5301.0000 PRINTING SUPPLIES <-> Lease for Photocopier -- 110 Westney <-> Works Centre Photocopier Total 2910.5301.0000 PRINTING SUPPLIES $1,800 $1,300 $3,100 2910.5305.0000 Water Purifier/Coffee <-> Including Filter Inspection Total 2910.5305.0000 Water Purifier/Coffee $4,500 $4,500 2910.5905.0002 Office Equip < $7,500 <-> Standard Ergonomic Chairs ($400 ea.) <-> Recabling Existing Computers <-> Deferred to 2005 Total 2910.5905.0002 Office Equip < $7,500 $400 $7,000 ($7,000) $400 2910.5910.0000 Property Taxes <-> NEW - Property Taxes (110 Westney Facility) Total 2910.5910.0000 Property Taxes Total. $68,300 $68,300 $1,303,137 Total Expenses Revenue $1,303,137 2910.9940.0000 Advertising Revenue <-> Advertising Revenue on Buses (DPI) ($13,885/mo) <-> Advertising Space Revenue on Shelters (Pattison Ajax: $58,500) (Viacom Pickering: $50,000) <-> Advertising Space Revenue on Benches (COA) (Ajax - 68 units: $1,275/mo) (Pickering - 60 units: $900/mo) ($166,620) ($108,500) ($26,100) Total 2910.9940.0000 Advertising Revenue ($301,220) ($4,000) ($4,000) 2910.9960.0000 Commissions/General <-> Ajax Plaza Total 2910.9960.0000 Commissions/General 2910.9990.0001 Interest Revenue <-> Bank Interest based on 2003 Actuals Total 2910.9990.0001 Interest Revenue Total. ($8,000) ($8,000) ($313,220) Total Revenues Net Expenses ($313,220) $989,917 9 APTA 2004 Current Budget 2920 Maintenance Run Date: 5f7/200412:28 PM R N C Bd e rt ame: urrent uaaet 2003 2003 INCREASE % CHANGE ACTUAL BUDGET (DECREASE) 2004 VS. 2003 EXPENDITURES 1100 Salaries & Wages $723,475 $677,559 $102,246 $779,805 15.09% 1200 Overtime $52,649 $22,500 $5,000 $27,500 22.22% 1400 Employer Contributions $164,526 $171,980 $65,575 $237,555 38.13% 1900 Uniforms $13,496 $9,875 $2,995 $12,870 30.33% 2340 Seminars & Education $175 $500 $1,155 $1,655 231.00% 2440 Snow Removal $0 $0 $0 $0 0.00% 2435 Build Repairs & Mtce $73,882 $46,036 $1,464 $47,500 3.18% 2457 Veh - Repairs & Maintenance $687,740 $444,400 $61,370 $505,770 13.81% 2458 Contract Labour $8,601 $44,000 $0 $44,000 0.00% 2459 Contracted Mechanical $148,211 $126,250 ($3,000) $123,250 -2.38% 2460 Vehicle Licences $22,390 $22,100 $4,900 $27,000 22.17% 2478 Misc Equip Repairs $709 $2,900 $1,400 $4,300 48.28% 2635 Building Rentals $84,595 $84,595 $0 $84,595 0.00% 2815 Leased Vehicles $134 $0 $0 $0 0.00% 5510 Utilities - Water $2,380 $3,000 $180 $3,180 6.00% 5520 Utilities - Gas $31,356 $45,000 ($3,000) $42,000 -6.67% 5530 Utilities - Hydro $34,670 $44,000 $6,160 $50,160 14.00% 5900 Gas, Oil Tires $695,384 $631,450 $98,560 $730,010 15.61% 5901 Contracted Fuel $194,884 $161,000 $45,600 $206,600 28.32% 5902 Misc Equip & Tools (under $8,837 $4,500 $1,500 $6,000 33.33% 5903 Shop Supplies $82,573 $45,000 $15,700 $60,700 34.89% 5905 Furniture & Equipment $22,681 $35,000 ($9,OOO) $26,000 -25.71 % Total EXPENDITURES $3,053,350 $2,621,645 $398,805 $3,020,450 15.21% REVENUES 9950 Go Transit Service ($74,016) $0 $0 $0 0.00% 9990 Misc. Maintenance Income ($5,933) $0 $0 $0 0.00% Total REVENUES ($79,948) $0 $0 $0 0.00% $398,805~ Net $2,973,402 $2,621,645 15.21% I ncrease in Salaries and Wages is partially due to the transfer of the Parts and Inventory position, which was budgeted in 2003 under Additional Requirements. ~.__.. ~. 10 APT A 2004 to 2006 THREE YEAR Current Budget Summary Run Date: 5/7/200412:28 PM 2920 Maintenance ~-~----- - --------- - -----------~ Report Name: Three Year Budget Summary 2005 BUDGET I 2006 BUDGET EXPENDITURES - ---------- ----------------._--- 1100 Salaries & Wages -.-- --- 1200 Overtime - ---- ---~-- -~- 1400 Employer Contributions 1900 Uniforms -----~----~-- 2340 Seminars & Education 2435 Build Repairs & Mtce 2457 Veh - Repairs & Maintenance ---- -- 2458 Contract labour 2459 Contracted Mechanical --~------- -- 2460 Vehicle Licences ----------- 2478 Misc Equip Repairs 2635 Building Rentals 5510 Utilities - Water 5520 Utilities - Gas 5530 Utilities - HldEo 5900 Gas, Oil Tires 5901 Contracted Fuel 5902 Misc Equip & Tools (under $500) 5903 Shop Supplies 5905 Furniture & Equipment -- ----~---- - ------------- --- - ---~-- --------- $802,975 __$~?_6,777 ___l~?~~QO $27,500 $241,125 $244,730 $13,063 $13,390 $1,680 $1,722 $48,213 $49,419 - - _~_?1~,-?_56 $526,087 $44,660 $45,IZl $128,099 $128,227 _~7,405 ---- $28,090 -~,t~§?1 $4,474 $85,864 $88,011 $3,228 $3,309 $42,630 ~43,696 __~Q,912 $52,185 - $740,960 $759,484 -----~.?~~:~~~I $2~:~~:~ $61 ,61 ~ $63,151 $2639Of~ $27 050 $3 079 7251 $3 154 262 $3 154 262 .-------- --~------------- ----- -----------~ --------- Net 11 APTA 2004 Background Information Run Date: 5/7/2004 12:27 PM Reoort Name: Backaround Info. with Totals 2004 BUDGET 2920 Maintenance Expenses 2920.1100.0001 Salaries & Wages-FIT <-> Base Salaries and Wages <-> Shift Premium based on .60/hr (12,168 hrs) <-> Tool Allowance in accordance with contract, @ $350 per year per licensed mechanic Total 2920.1100.0001 Salaries & Wages-FIT 2920.1100.0002 Salaries & Wages-PIT <-> Wages (Includes Vacation & Sick Coverage) <-> Part Time Vacation @ 6% <-> Part Time Payment in Lieu of Benefits ($2.66/hr) <-> Summer Student Total 2920.1100.0002 Salaries & Wages-PIT 2920.1200.0001 Overtime - FfT <-> Mechanics <-> Service Persons TotaI2920.1200.0001 Overtime - FfT 2920.1400.0000 Employer Contributions <-> This item includes mandatory deductions (CPP., EI., EHT.,) and employer provided benefits such as dental and optical, includes full OMERS contribution. TotaI2920.1400.0000 Employer Contributions 2920.1900.0000 Uniforms <-> The following costs are as per the collective agreement - 5 Full time Mechanics @ $375 ea. <-> 1 Part time Mechanic <-> 5 Full time Service Persons <-> 2 Part Time Service Persons <-> Cleaning of Uniforms ($11 O/week) <-> Safety Shoes ($175 x 13 persons) Total 2920.1900.0000 Uniforms 2920.2340.0000 Education & Training <-> New Technology Training - new engines, electrical, computer, etc <-> First Aid Training ($385 x 3 persons) Total 2920.2340.0000 Education & Training 2920.2435.0001 Building Repairs & Maint <-> Plumbing, heat/air system repairs, pest control, supplies and contracts, fire rescue, safety checks, sprinkler, hoist inspection, Ontario Hydro inspection, structural repair, mat rental, AlC repairs, Grass cutting, Snow Removal Total 2920.2435.0001 Building Repairs & Maint 2920.2435.0002 Janitorial <-> Based on $833/mo (Incl. Cleaning of Ajax Plaza) Total 2920.2435.0002 Janitorial 2920.2457.0001 Parts - Admin Veh <-> Regular maintenance of 5 vehicles & 2 service trucks & 1 sweeper <-> Tires ($175 per tire) x 12 tires Total 2920.2457.0001 Parts - Admin Veh 2920.2457.0002 Parts - Conventional 12 $618,410 $7,300 $2,1 00 $627,810 $126,907 $8,001 $10,645 $6,442 $151,995 $18,500 $9,000 $27,500 $237,555 $237,555 $1,875 $375 $1,875 $750 $5,720 $2,275 $12,870 $500 $1,155 $1,655 $37,500 $37,500 $10,000 $10,000 $5,500 $2,200 $7,700 APTA 2004 Background Information Run Date: 5171200412:27 PM Reoort Name: Backaround Info. with Totals 2004 BUDGET 2920 Maintenance <-> <-> <-> Includes inventory parts & direct charges - 51 buses @ $8,470 Tires (purchase, retread) Bus Washer - General Maintenance Total 2920.2457.0002 Parts - Conventional 2920.2457.0003 Parts - Special Services <-> 14 Buses @ $1,650 <-> Tires @ $215 per tire TotaI2920.2457.0003 Parts - Special Services 2920.2458.0002 Con Lab - Conventional <-> Labour charge based on $55!hr. (690 hrs) Pickering Operations Centre <-> Emission Testing Total 2920.2458.0002 Con Lab - Conventional 2920.2459.0001 Con Mech - Admin Veh <-> Mufflers, AlC, compressor, etc. - 6 vehicles @ $300 ea. Emission Testing (Ajax) Total 2920.2459.0001 Con Mech - Admin Veh 2920.2459.0002 Con Mech - Conventional <-> Towing, breakdowns, AlC, seat repairs, tire disposal! repair <-> Rust proofing Program <-> Decals for APTA Fleet ($300 per bus x 10 buses) <-> Deferred to 2005 Total 2920.2459.0002 Con Mech - Conventional 2920.2459.0003 Con Mech-Special Services <-> Towing, breakdowns, AlC, seat repairs, differentials <-> Rust proofing @ $175 per vehicle Total 2920.2459.0003 Con Mech-Special Services 2920.2460.0000 Vehicle Licences <-> Vehicles Licensing, Ministry of Environmental Charges <-> Licensing, Mechanics Total 2920.2460.0000 Vehicle Licences 2920.2478.0001 Misc Equip Repairs <-> Farebox Locks and Hardware <-> Two Way Radio Maintenance (Program 65 radios @ $40 ea.) <-> Recalibration - Tapley Metre, Torque Wrench, Beaumonk Brake Tester Total 2920.2478.0001 Misc Equip Repairs 2920.2635.0001 Lease Space (POS) 2920.2635.0002 Lease Space (Pickering) <-> Operations Centre utilities, office and bus storage costs for central core TotaI2920.2635.0002 Lease Space (Pickering) 2920.5510.0000 Utilities - Water <-> Provision -- Water Supply for ~PTA-East Facility (reflects 6% increase) . Total 2920.5510.0000 Utilities - Water 2920.5520.0000 Utilities - Heating <-> Reflects 20% increase over 2003 Total 2920.5520.0000 Utilities - Heating 2920.5530.0000 Utilities - Hydro <-> Reflects 14% increase over 2003 (Includes Plaza Terminal) 13 $431,970 $35,000 $2,000 $468,970 $23,100 $6,000 $29,100 $38,000 $6,000 $44,000 $5,800 $5,800 $70,000 $20,000 $3,000 ($3,000) $90,000 $25,000 $2,450 $27,450 $26,000 $1,000 $27,000 $300 $3,000 $1,000 $4,300 $84,595 $84,595 $3,180 $3,180 $42,000 $42,000 $50,160 APTA 2004 Background Information Run Date: 5/7/200412:27 PM ReDor! Name: Backaround Info. with Totals 2004 BUDGET 2920 Maintenance Total 2920.5530.0000 Utilities - Hydro 2920.5900.0001 Fuel/Lube - Admin Veh <-> Oil Consumption <-> Unleaded Gas Consumption (5+2+1 vehicles) Total 2920.5900.0001 Fuel/Lube - Admin Veh 2920.5900.0002 Fuel/Lube-Conventional <-> Oil Consumption <-> Diesel Consumption (39 buses) <-> Fuel Consumption - Flag Vehicles (3) Total 2920.5900.0002 Fuel/Lube-Conventional 2920.5900.0003 Fuel/Lube-Special Service <-> Oil Consumption <-> Fuel Consumption - 11 buses Total 2920.5900.0003 Fuel/Lube-Special Service 2920.5901.0002 Contr Fuel-Conventional <-> Oil Consumption <-> Diesel Consumption (11 buses-Pickering) Total 2920.5901.0002 Contr Fuel-Conventional 2920.5902.0000 Small Hand Powered Tools <-> Miscellaneous small tools & worn replacements Total 2920.5902.0000 Small Hand Powered Tools 2920.5903.0000 Shop Supplies <-> Shop Supplies, not included in inventory <-> Lubricants (wlwasher, anti-freeze, gear lube, etc.) Total 2920.5903.0000 Shop Supplies 2920.5905.0001 Furn & Fixtures <$7,500 2920.5905.0003 Plant Equipment <$7,500 <-> Ultra Sonic Parts Cleaner <-> Large Deep Sockets 1 5/16"-2 3/16" <-> Band Saw <-> Welding Curtain <-> Bearing Splitter - 2 sections <-> Hollow Punch Socket <-> Unibits 4 Diff <.> Flushing sewers and pump oil intercepts <-> Box & Pan Brake & Shear <-> Hand Shear <-> AlC Crimping Tool <-> Slip Roll <-> Hardware Assortment <-> Armature Growler <-> Lathe <-> Metric Tap & Die Set <-> King Pin Press <-> Overhead Exhaust Vents <.> (Reduced) 14 $50,160 $200 $3,000 $3,200 $10,800 $622,200 $21,000 $654,000 $810 $72,000 $72,810 $5,400 $201,200 $206,600 $6,000 $6,000 $45,000 $15,700 $60,700 $4,000 $1,100 $1,500 $450 $1,200 $75 $200 $7,000 $1,300 $450 $2,000 $665 $1,260 $600 $5,500 $1,200 $5,000 $2,500 ($10,000) 2920 Maintenance APT A 2004 Background Information Run Date: 5nt200412:27 PM Reoort Name: Backaround Info. with Totals 2004 BUDGET Total Expenses Revenue Total Revenues Net Expenses Total 2920.5905.0003 Plant Equipment <$7,500 Total. $26,000 $3,020,450 $3,020,450 $3,020,450 15 APTA 2004 Current Budget 2003 ACTUAL 2003 INCREASE BUDGET (DECREASE) 2925 Go Transit Service EXPENDITURES 2370 Insurance Premium $0 $0 $2,810 $2,810 0.00% 5900 Gas, Oil Tires $0 $0 $156.000 $156,000 0.00% Total EXPENDITURES $0 $0 $158,810 $158,810 0.00% REVENUES 9950 Go Transit Service $0 $0 0.00% Total REVENUES $0 $0 0.00% Net $0 $0 0.00% APT A has entered into a contract with GO Transit for the following services: bus storage, cleaning and fueling. 16 2925 Go Transit Service EXPENDITURES 2370 Insurance Premium 5900 Gas, Oil Tires REVENUES 9950 Go Transit Service Net APTA 2004 to 2006 THREE YEAR Current Budget Summary Total EXPENDITURES Total REVENUES 17 Run Date: 5[71200412:28 PM Report Name: Three Year Budget Summary 2005 BUDGET 2006 BUDGET $2,852 $158340 $161 192 $2,923 $162299 $165222 APTA 2004 Background Information 2925 Go Transit Service Run Date: 5nt2004 12:27 PM Reoort Name: Backaround Info. with Totals 2004 BUDGET Expenses 2925.2370.0000 Insurance <-> Additional premium charged to provide insurance coverage for the storage of GO Transit buses $2,810 Total 2925.2370.0000 Insurance $2,810 2925.5900.0000 Fuel <-> Fuel & Oil Consumption - ($13,OOO/mo.) TotaI2925.5900.0000 Fuel Total. $156,000 $156,000 $158,810 Total Expenses Revenue $158,810 2925.9950.0000 Revenue <-> GO Bus service & storage ($18,500/mo) Total 2925.9950.0000 Revenue Total. ($220,000) ($220,000) ($220,000) Total Revenues Net Expenses ($220,000) ($61,190) 18 APT A 2004 Current Budget 2930 Conventional Run Date: 5/7/200412:28 PM Re r1 Name: Current Budaet 2003 2003 INCREASE % CHANGE ACTUAL BUDGET (DECREASE) 2004 VS. 2003 EXPENDITURES 1100 Salaries & Wages $3,508,325 $3,051,756 $319,382 $3,371,138 10.47% 1200 Overtime $116,831 $102,281 $3,448 $105,729 3.37% 1400 Employer Contributions $796,598 $607,645 $327,550 $935,195 53.90% 1900 Uniforms $25,726 $36,320 $1,430 $37,750 3.94% 2340 Seminars & Education $477 $5,700 $150 $5,850 2.63% 2395 Memberships $4,294 $4,600 ($4,600) $0 -100.00% 2440 Snow Removal $58,490 $33,500 $26,500 $60,000 79.10% 5905 Furniture & Equipment $0 $0 $0 $0 0.00% 5915 Commission/General $0 $0 $13,000 $13,000 0.00% Total EXPENDITURES $4,510,741 $3,841,802 $686,860 $4,528,662 17.88% REVENUES 9950 POS Revenue ($475,248) ($250,000) ($233,485) ($483,485) 93.39% 9950 Farebox - Conventional ($1,116,607) ($1,150,000) $76,000 ($1,074,000) -6.61 % 9950 Fare Integration Revenue ($1,002,603) ($950,000) ($101,575) ($1,051,575) 10.69% 9950 School Board Revenue ($693,226) ($600,000) ($85,000) ($685,000) 14.17% 9950 NSF Fees ($20) $0 $0 $0 0.00% 9950 Commission Fees $12,955 $600 ($600) $0 -100.00% 9952 Local Charters ($38,816) ($35,340) $340 ($35,000) -0.96% 9952 Charters - DC / UOIT ($124,350) $0 ($200,000) ($200,000) 0.00% 9990 Camp Revenue ($63,118) ($51,000) ($11,400) ($62,400) 22.35% 9990 Misc. Maintenance Income ($47,100) $0 $0 $0 0.00% Total REVENUES ($3,548,133) ($3,035,740) {$555. 720~ 18.31% Net $962,608 $806,062 $131,140 $937,202 16.27% Increases in Salaries and Wages are due to the following: provision for additional dollars for vacation and sick coverage; pay in lieu of benefits and annualization / transfer of the Inspector position. ---- 19 APT A 2004 to 2006 THREE YEAR Current Budget Summary Run Date: Snt200412:28 PM 2930 Conventional EXPENDITURES ~ ~~~ ~ ~------~----------------- - 1100 Salaries & Wages -- ~ 1200 Overtime ~~OO Employer Contrib~tions 1900 Uniforms 2340 Seminars & Education 2440 Snow Removal _n_~- n 5915 Commission/General ~-~--- ~n__~_- Report Name: Three Year Budget Summary 2005 BUDGET 2006 BUDGET ------------- --~ $3,468,864 $3,56~§M).Q8 $105,730 ___$105,730 $948,070 $958, 7~9 -~___~~8,3J.._6 $39,274 $5,938 --_u- $6,086 $60,900 $62,423 $13195 $13525 $4641 013 $4755426 ~ --~-------- _n__- -- ~ _n- ~-- REVENUES 9950 POS Revenue --~------- -----------~----u- 9950 Farebox - Conventional 9950 Fare Integration Revenue ------- -- 9950 School Board Revenue 9950 Commission Fees 9952 Local Charters 9952 Charters - DC / UOIT ----------------- 9990 Camp Revenue -----~- -- --- un- -------- - ---- ---______m_____- ------- ------ Net $995681! $1 018961 ~O APTA 2004 Background Information 2930 Conventional Run Date: 5/7/2004 12:27 PM Reoort Name: Backaround Info. with Totals 2004 BUDGET Expenses 2930.1100.0001 Salaries & Wages-FIT <-> Base Salaries and Wages <-> Shift Premium based on .60/hr (38,220 hrs) <-> Hours Reallocated from Part Time Employment Total 2930.1100.0001 Salaries & Wages-FIT $2,007,630 $22,940 $87,526 $2,118,096 2930.1100.0002 Salaries & Wages-PIT <-> Wages <-> Vacation Coverage <-> Sick Coverage <-> Provision for Add'i Service (Charters) <-> Coverage Wages - FT Defensive Driving Training (1 day x 44 drivers) <-> Coverage Wages - PT Defensive Driving (1 day x 34 drivers) <-> Follow-up Refresher (4 hrs x 20 drivers) <-> New Casual Hires -- Training ( 10 days x 20 drivers) <-> "B" Licence Upgrade Wages (2 days x 1 employee) <-> Part Time Vacation @ 6% <-> Part Time Payment In Lieu of Benefits (2.66/hr) <-> Hours Formerly provided through Part Time Employment <-> Reallocated to Full Time Total 2930.1100.0002 Salaries & Wages-PIT $776,991 $166,054 $101,934 $16,474 $8,584 $4,376 $1,683 $22,891 $337 $65,960 $87,758 $87,526 ($87,526) $1,253,042 2930.1200.0001 Overtime - FfT <-> Inspectors <-> Full Time Drivers TotaI2930.1200.0001 Overtime - FfT $4,500 $49,384 $53,884 2930.1200.0002 Overtime - PIT <-> Overtime Total 2930.1200.0002 Overtime - PIT $51,845 $51,845 2930.1400.0000 Employer Contributions <-> This item includes mandatory deductions (CPP., EI., EHT., ) and employer provided benefits such as dental and optical, includes full OMERS contribution. Total 2930.1400.0000 Employer Contributions $935,195 $935,195 2930.1900.0000 Uniforms <-> The following costs are as per the collective agreement -- 42 FT & 29 PT Operators @ $400 ea. <-> 31 Casual Operators @ $150 ea. <-> Safety Shoe Replacement (Avg. 20 @ $140 ea) <-> 3 Inspectors @ $300 ea. <-> Corporate Promotional Wear <-> Reduced $28,400 Total 2930.1900.0000 Uniforms $4,650 $2,800 $900 $2,500 ($1,500) $37,750 2930.2340.0000 Education & Training <-> Transit Supervision Levell, II, III x 1 Inspector <-> First Aid & Diploma Courses (3 @ $350 ea) <-> Bus Route Scheduling - 1 Inspector Total 2930.2340.0000 Education & Training $2,400 $1,050 $2,400 $5,850 21 APTA 2004 Background Information Run Date: 5171200412:27 PM Recort Name: Backaround Info. with Totals 2004 BUDGET 2930 Conventional 2930.2440.0000 APTA Snow Removal <-> APTA - Snow Removal-- Contracted - Shelters & Bus Stops Total 2930.2440.0000 APTA Snow Removal 2930.5915.0000 Commission/General <-> Paid to Points-of-Sale - based on 5% of Total Sales Total 2930.5915.0000 Commission/General Total. Total Expenses Revenue 2930.9950.0001 POS Revenue <-> Monthly Passes - (Co-Fare/AduIUStudenUSenior) & Multi-RidesfTickets (Co-Fare, Adult, Student, Child) Total 2930.9950.0001 POS Revenue 2930.9950.0002 Farebox Revenue <-> Cash Fare - Co-Fare, Adult, Student, Senior, Child TotaI2930.9950.0002 Farebox Revenue 2930.9950.0003 Fare Integration Revenue <-> GO Transit Fare Integration TotaI2930.9950.0003 Fare Integration Revenue 2930.9950.0004 School Board Revenue <-> Student Busing-Revenue based on mthly pass rate of $37 per mth for 10 mths. Total 2930.9950.0004 School Board Revenue 2930.9950.0006 COMM. ON CONSIGN. SALES 2930.9952.0001 Charter Revenue <-> Claremont Service <-> Sav-A-Centre <-> Local Charters Total 2930.9952.0001 Charter Revenue 2930.9952.0003 DURHAM COLLEGE UOIT <-> Based on Core Service (3 buses x 8 hrs @ $60/hr) to DC/UOIT x 8 months Total 2930.9952.0003 DURHAM COLLEGE UOIT 2930.9990.0002 CAMP REVENUE <-> March Break <-> Summer Camps (Municipal) <-> Swim Service Total 2930.9990.0002 CAMP REVENUE Total. Total Revenues Net Expenses 22 $60,000 $60,000 $13,000 $13,000 $4,528,662 $4,528,662 ($483,485) ($483,485) ($1,074,OOO) ($1,074,OOO) ($1 ,051 ,575} ($1 ,051 ,575} ($685,OOO) ($685,000) ($10,OOO) ($5,OOO) ($20,OOO) ($35,OOO) ($200,OOO) ($200,OOO) ($2,400) ($55,000) ($5,OOO) ($62,400) ($3,591,460) ($3,591,460) $937,202 2940 Special Services EXPENDITURES 1100 Salaries & Wages 1200 Overtime 1400 Employer Contributions 1900 Uniforms 2340 Seminars & Education 2395 Memberships 2657 Rental Vehicle 5905 Furniture & Equipment Total EXPENDITURES REVENUES 9950 POS Revenue 9950 Farebox - Special Services 9952 Local Charters Total REVENUES Net APT A 2004 Current Budget 2003 ACTUAL $474,973 $13,782 $94,410 $2,837 $0 $412 $20,333 $0 $606,748 2003 INCREASE BUDGET (DECREASE) $516,758 $5,000 $117,860 $3,220 $0 $400 $30,000 $0 $673,238 ($155) $0 $33,985 $20 $3,000 ($400) ($10,000) $0 $26,450 $516,603 $5,000 $151,845 $3,240 $3,000 $0 $20,000 $0 $699,688 $535,998 23 $625,638 2004 VS. 2003 -0.03% 0.00% 28.84% 0.62% 0.00% -100.00% -33.33% 0.00% 3.93% 0.00% 25.34% -100.00% 23.24% 2.46% 2940 Special Services EXPENDITURES ~------------ - 1100 Salaries & Wages --~~ -- 1200 Overtime ---~~-~~ - - 1400 Employer Contributions 1900 Uniforms 2340 Seminars & Education 2657 Rental Vehicle APT A 2004 to 2006 THREE YEAR Current Budget Summary Run Date: 5/7/200412:28 PM Report Name: Three Year Budget Summary --- ~----- ~~ ~~- ----~---~--- ~--~--- REVENUES -~- -- 9950 Farebox - Special Services Net -~~- --- -~ -------~--- - --~-~------- -----~-----~~- ~ Total REVENUES -~-- -- 24 2005 BUDGET ~~7,~9} _~5&QQ_- ~ $154,315 $3,289 $3,045 $20 300 $723 252 $663712 2006 BUDGET $548,578 $5,000 $156,869 - ~3,371 ~___~3,121 $20 808 $737 738 -- $676 709 APTA 2004 Background Information 2940 Special Services Run Date: 51712004 12:41 PM Report Name: Backaround Info. with Totals 2004 BUDGET Expenses 2940.1100.0001 Salaries & Wages-FIT <-> Base Salaries and Wages <-> Shift Premium based on .60/hr Total 2940.1100.0001 Salaries & Wages-Frr 2940.1100.0002 Salaries & Wages-Prr <-> Wages <-> Vacation Coverage <-> Sick Coverage <-> New Hires - Training Wages (1 driver x 10 days) <-> Part Time Vacation @ 6% <-> Add'i coverage evenings & weekends <-> Coverage Wages for Defensive Driving Training (1 day x 6 drivers) <-> FOllow-up Refresher (4 hrs x 2 drivers) <-> Sensitivity Training (1 day x 6 drivers + 2 Dispatchers) <-> Part Time Payment in Lieu of Benefits ($2.661hr) Total 2940.1100.0002 Salaries & Wages-PIT 2940.1200.0001 Overtime - FIT <-> Overtime Provision TotaI2940.1200.0001 Overtime - FIT 2940.1400.0000 Employer Contributions <-> This item includes mandatory deductions ( CPP., EI., EHT., ) and employer provided benefits such as dental and optical, includes full OMERS contribution. Total 2940.1400.0000 Employer Contributions 2940.1900.0000 Uniforms <-> The following costs are as per the collective agreement-6 Full time Operators @ $400 <-> 6 Safety Shoe replacements @ $140 ea. Total 2940.1900.0000 Uniforms 2940.2340.0000 Seminars & Education <-> Sensitivity Training (1 day x 20 Operators) Total 2940.2340.0000 Seminars & Education 2940.2657.0000 Contracted Taxi Service <-> Contracted Evening & Weekend Accessible Taxis (Including Sunday service) Total 2940.2657.0000 Contracted Taxi Service Total. Total Expenses Revenue 2940.9950.0002 Farebox Revenue <-> Local Fare @ $1.90 <-> Out-of-Boundary Fare @ $3.80 Total 2940.9950.0002 Farebox Revenue Total. Total Revenues Net Expenses 25 $364,875 $1,500 $366,375 $65,224 $34,133 $15,715 $1,564 $7,908 $12,582 $1,010 $168 $1,403 $10,521 $150,228 $5,000 $5,000 $151,845 $151,845 $2,400 $840 $3,240 $3,000 $3,000 $20,000 $20,000 $699,688 $699,688 ($52,860) ($5,800) ($58,660) ($58,660) ($58,660) $641,028 APT A 2004 Current Budget 2945 Transitional Costs 2003 2003 INCREASE ACTUAL BUDGET (DECREASE) EXPENDITURES 1100 Salaries & Wages $14,545 $14,545 1900 Uniforms $4,950 $4,950 2131 Cellular Phones & Pagers $0 $26,600 2340 Seminars & Education $4,667 $5,000 2392 Consulting & Professional $48,198 $48,500 2396 Photo, Mapping, Printing $0 $15,000 2458 Contract Labour $0 $0 5905 Fumiture & Equipment $1,904 $8,790 5910 Signage (APTA) $12,359 $20,000 Total EXPENDITURES $86,624 $143,385 Net $86,624 $143,385 Last year's 2003 APTA Budget included a Transitional Budget Section. The 2004 costs associated with the Transitional Budget have been moved to the appropriate APT A cost centres to better facilitate reporting requirements. - -- ---- -- 26 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% 0.00% -100.00% -100.00% -100.00% -100.00% 2947 Additional Requirements EXPENDITURES Options ------ -- -- --.- Net Total EXPENDITURES APTA 2004 Current Budget 2003 ACTUAL $0 $0 $01 2003 INCREASE BUDGET! (DECREASE) I ------ $123,070 $123,070, I $123,070~ 27 $32,511 $32,511 $32,511 2004 VS. 2003 -73.58% -73.58% -73.58% APT A 2004 to 2006 THREE YEAR Current Budget Summary 2947 Additional Requirements EXPENDITURES ------ - ---------~---___-__m-- Options --- - ------- ---------- --------------- Net 28 Run Date: Sf1I200412:28 PM Report Name: Three Year Budget Summary 2005 BUDGET $146931 $146931 $146931 2006 BUDGET $177 684 $177 684 $177 684 APT A 2004 Background Information 2947 Additional Requirements Run Date: 5f712004 12:27 PM Reoort Name: Backaround Info. with Totals 2004 BUDGET Expenses 2947.0001.0000 Option 1 <-> Meet New Demand - Residential Growth - North Altona - Rush Hour service is provided to/from the GO Station Monday through Friday 5:45am to 9:00am & 4:30pm to 7:30pm. July 1, 2004 Start Date. <-> Recovery - Conventional - Fares (50% RlC ratio) $33,312 Total 2947.0001.0000 Option 1 ($16,656) $16,656 2947.0002.0000 Option 2 <-> Additional Clerk / Typist Part Time Hours Total 2947.0002.0000 Option 2 $15,855 $15,855 2947.0003.0000 Option 3 <-> New Position-FT Slip Clerk/Customer Service Support (April 1, 2004 Start Date) <-> Deferred to 2005 $26,458 ($26,458) Total 2947.0003.0000 Option 3 2947.0004.0000 Option 4 <-> New Position - Full Time Shop FloorlYard Clean-up Person (April 1, 2004 Start Date) <-> Deferred to 2005 $27,660 ($27,660) Total 2947.0004.0000 Option 4 2947.0005.0000 Option 5 <-> New Position - Full Time Mechanic (April 1, 2004 Start Date) <-> Deferred to 2005 $34,960 ($34,960) Total 2947.0005.0000 Option 5 Total. $32,511 Total Expenses Revenue $32,511 Total Revenues Net Expenses $32,511 29 APTA 2004 CAPITAL BUDGET Expenditure Summary 2005 ~ Administration $ 12,000 $ 147,925 $ 50,000 $ $ 209,925 Maintenance 103,000 407,000 125,000 635,000 Conventional 1,930,000 1,540,000 4,119,000 7,904,340 15,493,340 Special Services 180,000 300,000 275,000 755,000 Transitional Costs 509,230 425,000 2,084,000 3,018,230 $ 734,230 $ 2,819.925 $ 6,653,000 $ 7~ $ 20,111.04115 Financina SUmmary 2004 2 Municipal Contribution - Pickering $ 1,057,116 $ 1,145,962 $ 2,640,001 $ 3,307,630 $ 8,150,709 Municipal Contribution - Ajax 1,057,116 1,145,962 2,640,001 3,084,710 7,927.789 Ontario Transit Renewal Subsidy 619,998 528,001 1,372,998 1,512,000 4,032,997 Total $ 21734,230 $ 2.819,925 $ 6,653,000 $ 7,904,340 $ 20,111,495 -- ------ 30 APTA 2003 - 2006 CAPITAL BUDGET EXPENDITURES 6157 Vehicles $0 $0 $50,000 $0 6173 Furniture & Fixtures $12,000 $10,400 $0 $0 6176 Office Machines and Equipment $0 $137,525 $0 $0 Total EXPENDITURES $12,000 $147,925 $50,000 $0 REVENUES 1600 Municipal Contribution - Pickering ($6,000) ($73,963) ($25,000) $0 1601 Municipal Contribution - Ajax ($6,000) ($73,962) ($25,000) $0 Total REVENUES ($12,000) ($147,925) ($50,000) $0 Run Date: 51712004 12:32 PM Report Name: Dept Capital 2003-2006 2005 2006 BUDGET BUDGE 2910 Administration 31 2004 Capital Expenditures Background Information 2910 Administration Run Date 5f712004 1238 PM Report Name: Captial Proj - Exp. 2004 2004 Budget 6157 Vehicles Deferred 04-2910-001-01 Vehicles <-> Replacement Van - Inspectors <-> Deferred to 2005 Total 04-2910-001-01 Vehicles Total Deferred Total 6157 Vehicles $50,000 ($50,000) $0 $0 $0 6173 Furniture & Fixtures Furniture & Fixtures 04-2910-002-01 Furniture & Fixtures <-> Work Station - Parts & Inventory Supervisor Total 04-2910-002-01 Furniture & Fixtures 04-2910-002-02 Furniture & Fixtures <-> Work Station - 1 Inspector Total 04-2910-002-02 Furniture & Fixtures Total Furniture & Fixtures Total 6173 Furniture & Fixtures $5,200 $5,200 6176 Office Machines and Equipment Office Machines & Equipment 04-2910-003-01 Office Machines & Equipment <-> Coin Wrapping Equipment Replacement Total 04-2910-003-01 Office Machines & Equipment 04-2910-003-02 Office Machines & Equipment <-> Replacement - 4 computers Total 04-2910-003-02 Office Machines & Equipment 04-2910-003-03 Office Machines & Equipment <-> Telephone Automatic Call Distribution Total 04-2910-003-03 Office Machines & Equipment 04-2910-003-04 Office Machines & Equipment <-> Bus Route Scheduling Program Total 04-2910-003-04 Office Machines & Equipment Total Office Machines & Equipment Total 6176 Office Machines and Equipment $5,200 $5,200 $10,400 $10,400 $35,000 $35,000 $12,000 $12,000 $15,525 $15,525 $75,000 $75,000 $137,525 $137,525 ,)ì;: APTA 2003 - 2006 CAPITAL BUDGET EXPENDITURES 6157 Vehicles $65,000 $0 $0 $0 6181 Other Fixed Assets $38,000 $407,000 $125,000 $0 Total EXPENDITURES $103,000 $407,000 $125,000 $0 REVENUES 1600 Municipal Contribution - Pickering ($51,500) ($203,500) ($62,500) $0 1601 Municipal Contribution - Ajax ($51,500) ($203,500) ($62,500) $0 Total REVENUES ($103,000) ($407,000) ($125,000) $0 Run Date: 51712004 12:32 PM Report Name: Dept Capital 2003-2006 2005 2006 BUDGET BUDGE 2920 Maintenance 33 2004 Capital Expenditures Background Information 2920 Maintenance Run Date: 5/7/2004 12:37 PM Report Name: Captial Proj - Exp. 2004 6181 Other Fixed Assets Other Fixed Assets 04-2920-005-01 Other Fixed Assets <-> Street Signage & Concrete Pads TotaI04-2920-005-01 Other Fixed Assets I 04-2920-005-02 Other Fixed Assets <-> Replacement HVAC Roof AlC & Heating Unit Total 04-2920-005-02 Other Fixed Assets 04-2920-005-03 Other Fixed Assets <-> Replacement - Drivethrough Bus Washing System Total 04-2920-005-03 Other Fixed Assets I 04-2920-005-04 Other Fixed Assets <-> Replace Overhead Lights in Garage Total 04-2920-005-04 Other Fixed Assets 04-2920-005-05 Other Fixed Assets <-> Power Supply for Fuel System Total 04-2920-005-05 Other Fixed Assets 04-2920-005-06 Other Fixed Assets <-> Emergency power supply for critical office systems Total 04-2920-005-06 Other Fixed Assets 04-2920-005-07 Other Fixed Assets <-> Install Fence - Southern Property Exposure - to prevent vandalism Total 04-2920-005-07 Other Fixed Assets 04-2920-005-08 Other Fixed Assets <-> Replacement - Garage Doors Total 04-2920-005-08 Other Fixed Assets 04-2920-005-09 Other Fixed Assets <-> Replace Bus Parts Inventory System Total 04-2920-005-09 Other Fixed Assets 04-2920-005-10 Other Fixed Assets <-> Replace disintegrating concrete/replace front hoist pistons Total 04-2920-005-10 Other Fixed Assets Total Other Fixed Assets Total 6181 Other Fixed Assets 2004 Budge $10,000 $10,000 $40,000 $40,000 $140,000 $140,000 $15,000 $15,000 $6,000 $6,000 $6,000 $6,000 $30,000 $30,000 $75,000 $75,000 $30,000 $30,000 $55,000 $55,000 $407,000 $407,000 $407,000 ,1 Ii APTA 2003 - 2006 CAPITAL BUDGET 2003 BUDGET Run Date: 5/25/2004 11 :39 AM Report Name: Dept Capital 2003-2006 2005 2006 BUDGET BUDGE 2930 Conventional EXPENDITURES 6157 Vehicles $1,930,000 $1,540,000 $4,119,000 $7,904,340 Total EXPENDITURES $1,930,000 $1,540,000 $4,119,000 $7,904,340 REVENUES 1600 Municipal Contribution - Pickering ($685,O01) ($556,OOO) ($1,373,001) ($3,307,630) 1601 Municipal Contribution - Ajax ($685,O01) ($556,001) ($1,373,O01) ($3,084,71 O) 1602 Ontario Transit Renewal Subsidy ($559,998) ($427,999) ($1,372,998) ($1,512,000) Total REVENUES ($1,930,OOO) ($1,540,000) ($4,119,OOO) ($7,9O4,340) 35 2004 Capital Expenditures Background Information 2930 Conventional Run Date 5/25/2004 12:00 PM Report Name: Captial Pro - Exp 2004 6157 Vehicles Vehicles 04-2930-001-01 Vehicles <-> Replacement - 1985 Orion 1 Bus # 2040 Total 04-2930-001-01 Vehicles 04-2930-001-02 Vehicles <-> Replacement - 1986 Orion 1 Bus # 2039 Total 04-2930-001-02 Vehicles 04-2930-001-05 Vehicles <-> Mid-life Bus Refurbishing - 1992 Orion V Bus # 2018 Total 04-2930-001-05 Vehicles 04-2930-001-06 Vehicles <-> Mid-life Bus Refurbishing - 1992 Orion V Bus # 2017 Total 04-2930-001-06 Vehicles 04-2930-001-07 Vehicles <-> Mid-life bus Refurbishing - 1992 Orion V Bus # 2016 Total 04-2930-001-07 Vehicles 04-2930-001-09 Vehicles <-> Lower Panel Body Replacement - Snow Damage Total 04-2930-001-09 Vehicles 04-2930-001-14 Vehicles <-> Replace 10 Drivers' Seats Total 04-2930-001-14 Vehicles 04-2930-001-15 Vehicles <-> 4 Transmission & 4 Engine Rebuilds Total 04-2930-001-15 Vehicles 04-2930-001-16 Vehicles <-> Urgent Body Repairs 6 vehicles @ $10,000 ea Total 04-2930-001-16 Vehicles Total Vehicles Deleted 04-2930-001-12 Vehicles <-> Deferred to 2004 by the APT A Board -- 24' Pontoon Boat - Waterfront Trail Link - Frenchman's Bay. Referred to PicKering Operations Department for Interim Action. (2002 budget estimate) <-> Deleted by the APTA Board of Management - May 25,2004. Total 04-2930-001-12 Vehicles Total Deleted Total 6157 Vehicles Total Expenditures ,) t; 2004 Budget $567,000 $567,000 $567,000 $567,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $10,000 $10,000 $26,000 $26,000 $160,000 $160,000 $60,000 $60,000 $1,540,000 $30,000 ($30,000) $0 $0 $1,540,000 $1,540,000 APTA 2003 - 2006 CAPITAL BUDGET 2003 BUDGET Run Date: 5f112004 12:32 PM Report Name: Dept Capital 2003-2006 2005 2006 BUDGET BUDGE 2940 Special Services EXPENDITURES 6157 Vehicles Total EXPENDITURES $180,000 $180,000 $300,000 $275,000 $0 $300,000 $275,000 $0 ($99,999) ($137,500) $0 ($99,999) ($137,500) $0 ($100,002) $0 $0 ($300,000) ($275,000) $0 REVENUES 1600 Municipal Contribution - Pickering 1601 Municipal Contribution - Ajax 1602 Ontario Transit Renewal Subsidy Total REVENUES ($60,000) ($60,000) ($60,000) ($180,000) 37 2004 Capital Expenditures Background Information 2940 Special Services 2004 Budge 6157 Vehicles Vehicles 04-2940-001-01 Vehicles <-> Replacement - 1995 Ford CTV # 9009 Total 04-2940-001-01 Vehicles $100,000 $100,000 04-2940-001-02 Vehicles <-> Replacement - 1995 ELF 125 # 9007 Total 04-2940-001-02 Vehicles $100,000 $100,000 04-2940-001-04 Vehicles <-> Replacement - 1997 Ford CTV # 9006 Total 04-2940-001-04 Vehicles Total Vehicles Total 6157 Vehicles $100,000 $100,000 $300,000 $300,000 38 APT A 2003 - 2006 CAPITAL BUDGET EXPENDITURES 6157 Vehicles $17,500 $325,000 $0 $0 6173 Furniture & Fixtures $0 $0 $0 $0 6176 Office Machines and Equipment $0 $0 $0 $0 6181 Other Fixed Assets $491,730 $100,000 $2,084,000 $0 Total EXPENDITURES $509,230 $425,000 $2,084,000 $0 REVENUES 1600 Municipal Contribution - Pickering ($254,615) ($212,500) ($1,042,000) $0 1601 Municipal Contribution - Ajax ($254,615) ($212,500) ($1,042,000) $0 Total REVENUES ($509,230) ($425,000) ($2,084,000) $0 Run Date: 5/25/2004 11 :39 AM Report Name: Dept Capital 2003-2006 2005 2006 BUDGET BUDGE 2945 Transitional Costs 39 2004 Capital Expenditures Background Information 2945 Transitional Costs Run Date 5/25/200411 :59 AM Report Name Captial Proj - Exp. 2004 2004 Budge 6157 Vehicles Vehicles 04-2945-001-02 Vehicles Total 04-2945-001-02 Vehicles Total Vehicles $325,000 $325,000 $325,000 <-> Upgrade Electronic Fareboxes Deferred 04-2945-001-03 Vehicles <-> Deferred from 2003 -- Merger -- Coin Vault / Download Equipment- Pickering (100%) <-> Deferred to 2006 $32,000 Total 04-2945-001-03 Vehicles ($32,000) $0 04-2945-001-04 Vehicles <-> Deferred from 2003 -- Initial Rollout - Smartcard units (10,000 cards @ $8 ea.) (excl. Spec. Serv.) <-> Deferred to 2006 $80,000 Total 04-2945-001-04 Vehicles ($80,000) $0 04-2945-001-05 Vehicles <-> Deferred from 2003 -- Specialized Services Smartcard units (11 units + 1 spare @ $7,000/unit) <-> Derferred to 2006 $84,000 Total 04-2945-001-05 Vehicles ($84,000) $0 04-2945-001-06 Vehicles <-> Deferred from 2003 -- Parts Inventory related to Maintenance of Automated Fareboxes <-> Deferred to 2006 $75,000 Total 04-2945-001-06 Vehicles! I ($75,000) $0 04-2945-001-07 Vehicles <-> Deferred from 2003 -- Merger - Fareboxes - Pickering (100%) 25 + 1 spare, New fareboxes + mobile vault assembly + data probe system <-> Deferred from 2003 -- Merger - Farebox upgrade - Ajax (100%) 25 + 1 spare, (incl flags), reconditioned Units Inc. shipping, taxes, installation <-> Deferred to 2006 $727,130 $536,210 Total ($1,263,340) $0 $0 $325,000 Total 04-2945-001-07 Vehicles Total Deferred Total 6157 Vehicles ì t 2004 Capital Expenditures Background Information 2945 Transitional Costs Run Date: 5/25/2004 11 :59 AM Report Name: Captial Proj - Exp. 2004 6181 Other Fixed Assets Other Fixed Assets 04-2945-005-04 Other Fixed Assets <-> Portable Office Unit <-> Reduced Total 04-2945-005-04 Other Fixed Assets Total Other Fixed Assets Deleted 04-2945-005-03 Other Fixed Assets <-> land Aquisition - Additional Funds Required <-> Deleted by the APT A Board of Management - May 25,2004. Total 04-2945-005-03 Other Fixed Assets Total Deleted Deferred 04-2945-005-01 Other Fixed Assets <-> Deferred from 2003 -- Building Expansion <-> Deferred to 2005 TotaI04-2945-005-01 Other Fixed Assets 04-2945-005-02 Other Fixed Assets <-> Deferred from 2003 -- Building Expansion - Ajax Facility <-> Deferred to 2005 Total 04-2945-005-02 Other Fixed Assets Total Deferred I Total 6181 Other Fixed Assets xe Total Expenditures 1 t 2004 Budge $375,000 ($275,000) $100,000 $100,000 $65,000 ($65,000) $0 $0 $1,495,000 ($1,495,000) $0 $589,000 ($589,000) $0 $0 $100,000