Inv_B_3_9037804B003_2023-07-18 — File 23-1847

Hazen and Sawyer 24 Federal Street, 5th Floor Boston, MA 02110 • [phone removed] Job no hazenandsawyer.com July 18, 2023 Ms. Debbie Cheng Project Manager City of Somerville 1 Franey Road Somerville, MA 02145 Re: Asset Management Program (FY24) P.O. 20236992/20236993 Project Invoice No. 9037804B003 Dear Ms. Cheng: Enclosed please find our revised Invoice No. 9037804B003 and Progress Report for professional services rendered on the above-referenced project for work completed from June 1 through June 30, 2023. Please feel free to contact this office if you have any questions or require additional information. Very Truly Yours, Charles Wilson, PE Project Manager Attachments

Active Purchase Order Summary From To Period 6/1/2023 6/30/2023 Estimated Breakdown of Work for Funding Allocation Work Category P.O. # Budget Total Period Spent Spent to Date Remaining Sewer 20236993 100,000.00 $ 12,000.00 $ 46,160.23 $ 53,839.77 $ IAM 20236992 57,802.00 $ 6,794.75 $ 26,041.33 $ 31,760.67 $ 157,802.00 $ 18,794.75 $ 72,201.56 $ 85,600.44 $ Note: Remainder of scoped budget to be fulfilled by additional P.O.'s after 7/1/23 fiscal year changeover Approved - DC 8/14/23 $18,794.75 Total A: PO #20236993 - $12,000 Sewer Ent B: PO #20240493 - $6,794.75 IAM PO #20240493

July 18, 2023 Project No: 90378-04B Invoice No: 9037804B003 Ms. Debbie Cheng Project Manager City of Somerville 1 Franey Road Somerville, MA 02145 Project 90378-04B Somerville - Asset Management Program (FY24) Professional Services from June 1, 2023 to June 30, 2023 Task 100 Project Management QA/QC Professional Personnel Hours Rate Amount VICE PRESIDENT Nagel, Ryan 1.50 96.26 144.39 ASSOCIATE VICE PRESIDENT Wilson, Charles 7.00 91.49 640.43 SENIOR ASSOCIATE Driscoll, Madeleine 2.00 79.45 158.90 Totals 10.50 943.72 Total Labor 3.0624 times 943.72 2,890.05 Total this Task $2,890.05 Task 300 Standardized Risk Framework and Scoring Methodology Professional Personnel Hours Rate Amount ASSOCIATE VICE PRESIDENT Wilson, Charles 1.00 91.49 91.49 SENIOR ASSOCIATE Driscoll, Madeleine 1.00 79.45 79.45 Totals 2.00 170.94 Total Labor 3.0624 times 170.94 523.49 Total this Task $523.49 Task 500 Asset Information Strategy Professional Personnel Hours Rate Amount SENIOR ASSOCIATE Driscoll, Madeleine 3.00 79.45 238.35 Purves, Amy 6.00 79.45 476.70 Totals 9.00 715.05 Total Labor 3.0624 times 715.05 2,189.77 Total this Task $2,189.77 Task 600 Asset Inventory and Registry Improvements Hazen and Sawyer 24 Federal Street, Floor 5 Boston, MA 02110 • [phone removed] INVOICE Please remit to: Hazen and Sawyer • 77 Newbridge Road • Hicksville, NY 11801• Tax ID 13-2904652

Project 90378-04B Somerville - Asset Management Program (F Invoice 9037804B003 Professional Personnel Hours Rate Amount ENGINEER Luchay, Micah 4.00 40.13 160.52 Martin, Mitchell 5.00 40.13 200.65 Totals 9.00 361.17 Total Labor 3.0624 times 361.17 1,106.05 Total this Task $1,106.05 Task 700 GIS Training Professional Personnel Hours Rate Amount SENIOR ASSOCIATE MacDonald, James 4.00 79.45 317.80 ENGINEER Gaylord, Mackenzie 1.00 40.13 40.13 Totals 5.00 357.93 Total Labor 3.0624 times 357.93 1,096.12 Total this Task $1,096.12 Task 800 CMMS Selection Support Professional Personnel Hours Rate Amount VICE PRESIDENT Nagel, Ryan 1.50 96.26 144.39 ASSOCIATE VICE PRESIDENT Wilson, Charles 15.00 91.49 1,372.35 SENIOR ASSOCIATE Dalton, Michael Russ 7.00 79.45 556.15 Driscoll, Madeleine 4.00 79.45 317.80 Purves, Amy 7.50 79.45 595.88 PRINCIPAL ENGINEER Agrawal, Benjamin 3.00 43.45 130.35 ENGINEER Martin, Mitchell 11.75 40.13 471.53 Totals 49.75 3,588.45 Total Labor 3.0624 times 3,588.45 10,989.27 Total this Task $10,989.27 Billing Limits Current Prior To-Date Total Billings 18,794.75 53,406.81 72,201.56 Limit 463,532.00 Remaining 391,330.44 Total this Invoice $18,794.75 Page 2 Please remit to: Hazen and Sawyer • 77 Newbridge Road • Hicksville, NY 11801• Tax ID 13-2904652

Project Name: Project Number: Asset Management Program (FY24) P.O. 20236992, 20236993 H&S Project No. 90378-04B Project Period: Today's Date: 6/1/2023 - 6/30/2023 July 17, 2023 Progress This Period: Items For Resolution: Next Milestone(s) or End Product: None CMMS RFP/Q Variances: As of June 30, 2023 the estimated project completion is 16%. Budget 1. Coordination of team resources, meetings (Task 1.0) 2. Advanced collection/conveyance GIS schema work (Task 6.0) 3. Performed GIS Training (Task 7.0) 4. Conducted Requirements Gathering/BP meetings and began demonstration prep for CMMS (Task 8.0) 5. Submitted draft Asset Information Strategy TM (Task 5.0) 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Task 8 Task 9 Percent Billed Budget Status by Task