18-198219 IGA MARICOPA COUNTY AQD FINAL BUDGET.PDF

Maricopa County Air Quality Department
Travel Reduction Program
ADEQ18-198219
FY 2019 Budget Costs and Hours By Task
CONTRACTOR - MCAQD/TRP (TRP ADEQ)
Period: July 1, 2018 - June 30, 2019 Hours by Personnel & Task
Raw Direct 1 2
Labor Travel Reduction Training & Total Total
Personnel Position Hourly Rate Program Assistance Hours Cost
Barrera,Crystal L Admin/Operations Specialist $17.64 1,044.00 1,044.00 $18,416.00
Calderon,Jonathan Intern $13.00 507.00 507.00 $6,591.00
Cody,Maria F Air Quality Division Manager $42.22 568.00 568.00 $23,981.00
Cummings,Phillip M Air Quality Planning Supv $36.81 1,044.00 1,044.00 $38,430.00
Fowler,Joel E Office Assistant Specialized $16.88 1,044.00 1,044.00 $17,623.00
Jannett,Ernest J Admin/Operations Specialist $24.37 1,044.00 1,044.00 $25,442.00
Martinez,Sylvia Arredondo Office Assistant Specialized $21.96 1,044.00 1,044.00 $22,926.00
Moeller,Gregory A Admin/Operations Specialist $22.85 1,044.00 1,044.00 $23,855.00
Starr,Sheila J Office Assistant Specialized $21.64 1,044.00 1,044.00 $22,592.00
Weston-Smith,Kristen M Admin/Operations Specialist $18.70 1,044.00 1,044.00 $19,523.00
Wheatley,Michele Lee Management Assistant $18.96 1,044.00 1,044.00 $19,794.00
Wohlbrandt,Morgan B Office Assistant Specialized $14.08 1,044.00 1,044.00 $14,700.00
[ vacant ] [ Air Quality Planner ] $36.81 780.00 780.00 $28,712.00
Appelo,Regan C Grant/Contract Coordinator $25.63 522.00 522.00 $13,379.00
Hourly Cost $295,964.00
Total Hours 12,817.00 12,817.00
Total Hourly Cost $295,964.00 $295,964.00
Fringe Benefit 45.28% $134,021.00 $134,021.00
Total Labor with Fringe $429,985.00 $429,985.00
REIMBURSABLE EXPENSES Expenses by Task Total
Description Task 1 Cost
Supplies $7,500.00 $7,500.00
Non-Capital Equipment and software $5,000.00 $5,000.00
Services $107,928.00 $107,928.00
Total Reimbursable Expenses $120,428.00 $120,428.00
SUBCONTRACTOR - RPTA/Valley Metro TRASUB Task 2
Period: July 1, 2018 - June 30, 2019 Training & Total Total
Personnel Hourly Rate Assistance Hours Cost
Coomer, Dawn (Project Manager) $48.40 271.44 271.44 $13,137.70
Day, Suzanne $33.48 361.92 361.92 $12,117.08
Duarte, Lillian $33.48 361.92 361.92 $12,117.08
Reid, Jeff $24.79 271.44 271.44 $6,729.00
Subtotal $44,100.86
Total Hours 1,266.72 1,266.72
Total Hourly Subcontractors Cost $44,100.86 $44,100.86
Fringe Benefit 59.54% $26,257.65 $26,257.65
Overhead 60.34% $26,610.46 $26,610.46
Consultants (Other) $12,500.00 $12,500.00
Reimbursable Expense (Meetings & Mileage) $13,750.00 $13,750.00
Reimbursable Expense (Postage/Print/Misc.) $26,781.03 $26,781.03
Total Subcontractor Expenses $150,000.00 $150,000.00
GRAND TOTAL Total Costs by Task
Period: July 1, 2018 - June 30, 2019 Task 1 Task 2
Description Travel Reduction Training & Total
Program Assistance Cost
Total Labor with Fringe $429,985.00 $429,985.00
Reimbursable Expenses $120,428.00 $120,428.00
Overhead 31.30% $172,279.00 $172,279.00
Subcontractor (RPTA/Valley Metro) $150,000.00 $150,000.00
TOTAL $722,692.00 $150,000.00 $872,692.00