Memorandum
Date June 20, 2013
To Boston Region Metropolitan Planning Organization
From Paul Regan, Chairman
Administration and Finance Committee
Re Recommendation to approve the SFY2014 CTPS Operating Budget
The Administration and Finance Committee met on June 6, 2013, to discuss the SFY2014 CTPS Draft Operating Budget.
Karl Quackenbush, Executive Director, presented the following materials to the Committee:
a. CTPS Funding by Source
b. SFY2014 CTPS Draft Operating Budget
c. Memorandum - Draft Operating Budget by line-item
d. Proposed Five-Year Plan (FY2014-2018) for Computer Resources Development
The SFY2014 CTPS Draft Operating Budget totals $5,795,930, and supports 58 professional positions, 1 intern, 4 temporary full-time staff assigned to special projects, and approximately 15 part-time temporary staff, assigned to data collection efforts, depending upon need. This budget represents a decrease of $131,470 from the approved SFY2013 level of $5,927,400. SFY2013 is projected to end the year at $5,458,750, due to vacancies and lower expenditures on various indirect line-items.
A thorough presentation of the operating budget and computer plan was provided to the Administration and Finance Committee by Executive Director Quackenbush and Deputy Executive Director Robin Mannion.
Having conducted a satisfactory review of the SFY2014 CTPS Draft Operating Budget, the Administration and Finance Committee unanimously recommends approval of said budget to the Boston Region Metropolitan Planning Organization.
Client | ContractNumber | Description | Contract Budget | Contract Direct Costs | Contract Salary and Overhead | Contract Start Date | Contract End Date | SFY14 Salary & Overhead | SFY14 Direct Costs | SFY14 Total |
---|---|---|---|---|---|---|---|---|---|---|
MPO | 596 | FY2014 3C - PL | $2,621,900 | $37,500 | $2,584,400 | Oct-12 | Sep-13 | $646,100 | $28,000 | $674,100 |
MPO | 684 | FY2014 3C - Section 5303 | $1,248,565 | $32,000 | $1,216,565 | Oct-12 | Sep-13 | $306,520 | $25,300 | $331,820 |
MPO | 5XX | FY2014 3C - PL | $2,888,473 | $57,500 | $2,830,973 | Oct-13 | Sep-14 | $2,123,230 | $27,500 | $2,150,730 |
MPO | 6XX | FY2014 3C - Section 5303 | $1,248,565 | $32,000 | $1,216,565 | Oct-13 | Sep-14 | $919,550 | $7,000 | $926,550 |
MPO Subtotal: | $3,995,400 | $87,800 | $4,083,200 | |||||||
MassDOT | 685 | FY2013 MassDOT/MBTA Section 5303 | $256,120 | $6,000 | $250,120 | Oct-12 | Sep-13 | $65,000 | $4,200 | $69,200 |
MassDOT | 6XX | FY2014 MassDOT/MBTA Section 5303 | $256,120 | $6,000 | $250,120 | Oct-13 | Sep-14 | $187,590 | $2,500 | $190,090 |
MassDOT | 591 | SPR Projects | $498,000 | $43,000 | $455,000 | Apr-13 | Mar-14 | $341,250 | $42,000 | $383,250 |
MassDOT | 5xx | SPR Projects | $462,000 | $7,000 | $455,000 | Apr-14 | Mar-15 | $113,750 | $1,000 | $114,750 |
MassDOT | 706 | MassDOT Title VI | $247,730 | $2,000 | $245,730 | Apr-11 | Dec-13 | $46,000 | $0 | $46,000 |
MassDOT | xxx | MassDOT Title VI | $50,000 | $0 | $50,000 | Dec-13 | Dec-14 | $50,000 | $0 | $50,000 |
MassDOT | 705 | South Coast Rail | $40,000 | $0 | $40,000 | Mar-10 | Jun-13 | $5,000 | $0 | $5,000 |
MassDOT | 707 | Green Line SIP Mitigation | $80,000 | $0 | $80,000 | Aug-11 | Dec-13 | $3,700 | $0 | $3,700 |
MassDOT/FRA | 711 | South Station Expansion | $350,000 | $0 | $350,000 | Jul-12 | Jun-15 | $111,500 | $0 | $111,500 |
MassDOT | 712 | Route 79 Transportation Study - Eval Alter. | $60,000 | $0 | $60,000 | Nov-12 | Dec-13 | $20,000 | $0 | $20,000 |
MassDOT | 713 | I-93/I-95 Woburn | $157,000 | $1,800 | $155,200 | Apr-13 | May-14 | $85,000 | $0 | $85,000 |
MassDOT | 716 | Roadway Inventory Support | $259,750 | $0 | $259,750 | Sep-12 | Jun-14 | $130,000 | $0 | $130,000 |
MassDOT Subtotal: | $1,158,790 | $49,700 | $1,208,490 | |||||||
MBTA | 396 | Rider Oversight Committee Support | $24,500 | $0 | $24,500 | Apr-13 | Mar-17 | $6,125 | $0 | $6,125 |
MBTA | xxx | FY2014 NTD - Purchased & Direct Service | $121,492 | $750 | $120,742 | Jul-13 | Dec-14 | $114,750 | $750 | $115,500 |
MBTA | 389 | FY2013 NTD - Purchased Services | $21,578 | $750 | $20,828 | Jul-12 | Dec-13 | $1,250 | $0 | $1,250 |
MBTA | 387 | FY2013 NTD - Directly Operated Services | $95,900 | $730 | $95,170 | Jul-12 | Dec-13 | $2,000 | $0 | $2,000 |
MBTA | 397 | Bus Data Collection VIII | $450,000 | $510 | $449,490 | Apr-13 | Mar-16 | $149,830 | $170 | $150,000 |
MBTA | xxx | MBTA 2013/2014 Title VI | $135,270 | $500 | $135,770 | Apr-13 | Apr-14 | $120,865 | $500 | $121,365 |
MBTA | 392 | Green Line New Starts Analysis | $191,747 | $0 | $191,747 | Dec-12 | Dec-13 | $80,000 | $0 | $80,000 |
MBTA Subtotal: | $474,820 | $1,420 | $476,240 | |||||||
Massport | 380 | Massport Technical Assistance | $150,000 | $0 | $150,000 | Aug-11 | Jun-14 | $23,000 | $0 | $23,000 |
MAPC/Newton | xxx | Needham Corridor Study | $10,000 | $0 | $10,000 | Jun-13 | Dec-13 | $5,000 | $0 | $5,000 |
Other Subtotal: | $28,000 | $0 | $28,000 | |||||||
TOTAL | $5,657,010 | $138,920 | $5,795,930 |
Item | Requested FY2013 Budget | Projected FY2013 | Requested FY2014 Budget | Acct No. |
---|---|---|---|---|
Annual Direct Salaries | $2,982,800 | $2,798,230 | $2,865,400 | n/a |
Other Direct Expenses | $63,700 | $28,500 | $138,920 | n/a |
General Office Equipment | $0 | $0 | $0 | 540502 |
Data Processing Equipment | $10,000 | $10,000 | $6,000 | 540503 |
Consultants | $0 | $0 | $0 | 540904 |
Printing | $0 | $0 | $0 | 541204 |
Travel & Transportation | $26,900 | $13,500 | $38,920 | 541302 |
Other | $26,800 | $5,000 | $94,000 | 541602 |
Annual Indirect Expenses | $2,880,900 | $2,632,024 | $2,791,610 | n/a |
Indirect Timesheet Costs | $1,545,400 | $1,445,201 | $1,588,700 | n/a |
Fringe Benefits | $829,200 | $761,873 | $811,300 | 12702 |
Admin Salaries | $716,200 | $683,328 | $777,400 | 12703 |
Employee Insurance | $216,200 | $200,800 | $185,700 | n/a |
Medical | $95,000 | $96,000 | $97,000 | 600301 |
Workman's Comp | $1,000 | $1,000 | $1,000 | 600302 |
Unemployment | $15,000 | $11,000 | $11,000 | 600303 |
Medicare / FICA | $50,800 | $51,300 | $52,700 | 600304 |
Long-Term Disability | $37,400 | $26,500 | $7,000 | 600305 |
Med. Sec. Trust | $5,000 | $5,000 | $5,000 | 600307 |
Short-Term Disability | $12,000 | $10,000 | $12,000 | 600315 |
Employee Benefits & Other | $111,000 | $79,500 | $90,500 | n/a |
Tuition Assistance | $3,000 | $0 | $3,000 | 600310 |
Recruitment | $8,000 | $3,000 | $3,000 | 600311 |
Training | $25,000 | $7,500 | $12,000 | 600312 |
Transit Subsidy | $75,000 | $69,000 | $72,500 | 600313 |
Supplies | $45,500 | $40,500 | $40,000 | n/a |
General Office | $12,500 | $12,500 | $12,500 | 600402 |
Data Processing | $30,000 | $25,000 | $25,000 | 600403 |
Design & Graphics | $3,000 | $3,000 | $2,500 | 600404 |
Equip (Buy, Lease, Maint) | $191,700 | $163,200 | $164,700 | n/a |
General Office | $6,000 | $3,500 | $3,500 | 600502 |
Data Processing | $25,000 | $18,000 | $13,500 | 600503 |
Graphics | $300 | $300 | $300 | 600504 |
General Equip. Lease | $1,100 | $1,100 | $1,100 | 600509 |
General Equip. Maint. | $2,000 | $500 | $500 | 600512 |
Data Proc. HW & SW Contr. | $156,000 | $139,600 | $144,500 | 600513 |
Graphics Equip. Maint. | $300 | $100 | $300 | 600514 |
Data Proc. Equip. Repairs | $1,000 | $100 | $1,000 | 600517 |
Premises | $329,000 | $325,000 | $325,500 | n/a |
Office Maint. & Repair | $5,000 | $3,000 | $3,000 | 600603 |
Office Rent | $321,000 | $321,000 | $321,000 | 600604 |
Misc. Premises | $3,000 | $1,000 | $1,500 | 600606 |
Communications | $71,300 | $65,600 | $61,500 | n/a |
Telephone | $14,000 | $13,100 | $13,500 | 600802 |
Postage | $7,000 | $5,000 | $5,000 | 600804 |
Advertising | $11,300 | $8,500 | $4,000 | 600805 |
Internet | $39,000 | $39,000 | $39,000 | 600806 |
Professional Services | $15,000 | $3,200 | $6,500 | n/a |
Professional Services | $10,000 | $2,000 | $4,500 | 600903 |
Temporary Help | $5,000 | $1,200 | $2,000 | 600912 |
Meetings & Conferences | $3,000 | $500 | $1,500 | n/a |
In-State Meetings & Conferences | $3,000 | $500 | $1,500 | 601004 |
Professional Fees | $5,800 | $4,600 | $5,000 | n/a |
Memberships | $1,000 | $1,000 | $1,000 | 601102 |
Subscriptions | $3,800 | $3,400 | $3,500 | 601103 |
Publications | $1,000 | $200 | $500 | 601104 |
Reproduction | $41,200 | $22,700 | $27,000 | n/a |
Photocopy (lease, per copy cost, maint.) | $16,200 | $16,200 | $19,000 | 601203 |
Printing (external vendor) | $25,000 | $6,500 | $8,000 | 601204 |
Travel & Transportation | $6,500 | $3,500 | $3,500 | n/a |
Travel | $6,000 | $3,200 | $3,000 | 601302 |
Transportation (couriers, ship.) | $500 | $300 | $500 | 601306 |
Other Costs | $5,000 | $1,900 | $2,000 | n/a |
Misc. & Petty Cash | $5,000 | $1,900 | $2,000 | 601602 |
Other Overhead | $294,300 | $275,823 | $289,510 | n/a |
MAPC "Pass On" Cost | $294,300 | $275,823 | $289,510 | 800000 |
Total Annual Costs | $5,927,400 | $5,458,754 | $5,795,930 | n/a |
Overhead Rate | 96.58% | 94.06% | 97.42% | n/a |