Exhibit_B_-_Fee_Proposal_Workbook.xlsx

This is a Fee Proposal Workbook for the City of Pasadena Water and Power's Advanced Metering Infrastructure (AMI) System and Installation Services RFP. The workbook serves as the pricing template for proposers to submit detailed cost estimates across three primary components: SaaS AMI FAN (Frequency Access Network), Water Metering, and Installation Services. The SaaS AMI FAN component requests pricing for infrastructure materials including collectors/routers, repeaters, network installation, and handheld programming devices, as well as 38,174 water endpoints and electric meters across multiple configurations (1S through 16S ratings totaling approximately 68,090 meters), along with associated consumables such as meter locking rings and seals. The Water Metering component requests pricing for various lid types, AMI-ready meters ranging from 3/4 inch to 8 inch sizes (totaling approximately 26,703 units), AMI retrofit registers across multiple sizes, and remote disconnect metering devices. Installation Services component includes pricing for electric meter replacements across all configurations, water meter replacements and retrofits, and price adders for GPS coordinate collection, service line material identification, lid replacement, and box replacement in varying ground conditions. Proposers are instructed to populate quantity, unit price, extended price, annual escalation rates, model names/numbers, lead times, and comments for each line item.

The workbook establishes that extended prices for professional services including project management, systems integration, training, and travel and expenses must be provided as fixed fees inclusive of all design, oversight, and quality assurance activities, while travel and expenses are to be given as not-to-exceed limits. Ongoing fees must be quoted as the full annual cost of service, and annual escalation rates must be provided for both capital and ongoing line items, with notation if pricing is held for specific periods or tied to an index. Proposers are responsible for verification of accuracy of all calculations and may add line items to accurately reflect their proposals without expanding the scope beyond RFP requirements. The workbook includes a Summary Pricing worksheet that consolidates total upfront capital costs and annual operating and maintenance (O&M) costs for each component. All pricing must be representative of requirements marked as "Current Base" or "Partially Comply" by proposers, and purchase of items is noted as tentative based on the anticipated project schedule, with Pasadena Water and Power reserving the right to modify timeline and outlay at its discretion.