HomeMy WebLinkAboutRES2026-003 Professional Computer Solutions - Utility SystemSponsored by: Sorensen
CITY OF SEWARD, ALASKA
RESOLUTION 2026-003
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SEWARD, ALASKA,
AUTHORIZING THE CITY MANAGER TO ENTER INTO A SOFTWARE LICENSING
AND IMPLEMENTATION AGREEMENT WITH PROFESSIONAL COMPUTER
SOLUTIONS, LLC FOR ENTERPRISE UTILITY SOFTWARE FOR THE ELECTRIC
DEPARTMENT IN THE AMOUNT OF $305,592 AND APPROPRIATING FUNDS
WHEREAS, the City of Seward Electric Department currently utilizes multiple independent
software systems for billing, accounting, payroll, and inventory management, including NorthStar
and Fishbowl, resulting in duplicated data entry, fragmented workflows, and limited system
integration; and
WHEREAS, the Electric Department is actively working to modernize operations, improve
efficiency, and transition to the Uniform System of Accounts (USoA), which requires a utility -
focused enterprise system capable of supporting regulatory compliance, detailed reporting, and
capital asset accounting; and
WHEREAS, Professional Computer Solutions LLC (PCS) has submitted a proposal for a fully
integrated enterprise utility software platform specifically designed for public utilities,
consolidating billing, financials, payroll, inventory, work orders, workflow management, customer
engagement tools, reporting, and analytics into a single unified system; and
WHEREAS, the PCS enterprise solution will replace NorthStar (billing) and Fishbowl (inventory
management), reducing the number of software systems maintained by the City while improving
data accuracy, system reliability, cybersecurity, and staff efficiency; and
WHEREAS, the PCS platform supports integration with advanced utility functions, including
AMI and meter data management, customer portals, mobile workforce tools, workflow approvals,
document imaging, and comprehensive reporting and analytics, positioning the Electric
Department for long-term operational and technological sustainability; and
WHEREAS, the PCS proposal includes a one-time software licensing fee of $36,656.00, a one-
time implementation and setup fee of $268,936.00 covering an estimated six- to seven -month
transition period, and an annual maintenance and support fee of $63,746.00, which will replace
the combined annual maintenance and support costs currently paid for the three existing systems;
and
WHEREAS, PCS brings over forty years of experience serving municipal and cooperative utilities
nationwide and offers a utility -focused implementation approach, ongoing training, and dedicated
support designed to ensure a successful transition with minimal disruption to operations; and
CITY OF SEWARD, ALASKA
RESOLUTION 2026-003
Page 2 of 2
WHEREAS, consolidating the City's utility software into a single enterprise platform is expected
to streamline workflows, reduce long-term operating costs, improve customer service capabilities,
enhance reporting transparency, and better support future growth and regulatory requirements.
NOW, THEREFORE, B E IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
SEWARD, ALASKA:
Section 1. The City Council hereby authorizes the City Manager to enter into a software licensing,
implementation, and support agreement with Professional Computer Solutions, LLC (PCS) for
enterprise utility software for the City of Seward Electric Department.
Section 2. Funding in the amount of $305,592.00 for a one-time software licensing fee of
$36,656.00 and a one-time implementation and setup cost of $268,936.00, is hereby appropriated
in the Electric Enterprise Fund Reserves 15000-0000-3400 to the 15000-3001-7022 Software and
Subscription Expense Account.
Section 3. The City Council further approves an ongoing annual maintenance and support fee of
$63,746.00, which will replace existing annual fees for NorthStar, and Fishbowl software systems.
Section 4. This resolution shall take effect immediately upon adoption.
APPROVED BY THE CITY COUNCIL OF THE CITY OF SEWARD, ALASKA THIS 12TH
DAY OF JANUARY 2026.
c7t w t mcCtxw
Sue McClure, Mayor
AYES: Barnwell, Crites, Warner, Osenga, Calhoon, Draper, McClure
NOES: None
ABSENT: None
ABSTAIN: None
ATTEST:
Kris Peck
City Clerk
City Council Agenda Statement
Meeting Date: January 12, 2026
To: City Council
Through: Kat Sorensen, City Manager
From: Taylor Crocker, Electric Operations Supervisor
Subject: Resolution 2025-003: Authorizing the City Manager to Enter into a Software
Licensing and Implementation Agreement with Professional Computer
Solutions, LLC For Enterprise Utility Software for the Electric Department
in the Amount of $305,592 and Appropriating Funds
Background and justification:
The City of Seward Electric Department currently relies on multiple independent software systems
to manage core utility functions, including billing (NorthStar), accounting and payroll (and
inventory management (Fishbowl). While each system functions independently, the lack of
integration requires duplicate data entry, manual reconciliation, and additional staff time to
maintain accuracy across platforms. This fragmented approach increases operational risk, limits
reporting capabilities, and creates inefficiencies that grow as the utility expands and modernizes.
As part of its long-term strategy, the Electric Department is transitioning to the Uniform System
of Accounts (USoA) and modernizing business processes to improve transparency, regulatory
compliance, financial reporting, and asset management. Successfully completing this transition
requires an enterprise -level utility system designed specifically for public power utilities that can
integrate billing, financials, payroll, inventory, work orders, workflows, customer engagement,
and reporting into a single unified platform.
Professional Computer Solutions LLC (PCS) submitted a comprehensive proposal for an
enterprise utility software solution tailored to municipal and cooperative utilities. The PCS
platform consolidates multiple utility functions into one system, eliminating the need for separate
billing, accounting, payroll, and inventory software. In addition to replacing the City's existing
systems, the PCS solution provides enhanced customer portals, workflow automation, document
imaging, mobile workforce tools, advanced reporting and analytics, and direct support for USoA
compliance.
The PCS proposal includes a one-time software licensing fee of $36,656.00 and a one-time
implementation and setup fee of $268,936.00, covering an estimated six- to seven -month
transition period that includes discovery, data conversion, configuration, training, testing, and go -
live support. The ongoing annual maintenance and support fee of $63,746.00 will replace the
combined annual fees currently paid for NorthStar and Fishbowl, resulting in a consolidated and
more predictable long-term cost structure.
Implementing a single, fully integrated enterprise system will streamline operations, reduce long-
term operating risk, improve data accuracy, enhance customer service capabilities, and better
position the Electric Department to meet future regulatory, reporting, and technology needs. This
investment supports operational efficiency, financial transparency, cybersecurity best practices,
and long-term sustainability for the City's electric utility.
Comprehensive and Strategic Plan Consistency Information
This legislation is consistent with (citation listed):
Comprehensive Plan:
Strategic Plan:
Other:
Total amount of funds listed in this legislation: $ 305,592.00
This legislation (✓):
Creates revenue in the amount of:
Creates expenditure in amount of:
Creates a savings in the amount of: $
Has no fiscal impact
Funds are (✓):
Budgeted Line item(s): 15000- 3001-7022
X
X
Not budgeted
Not applicable
$ 305,592.00
Fund Balance Information
Affected Fund (✓):
General
Boat Harbor
Motor Pool
Available Fund Balance
SMIC
Parking
Other
X
Yes
x
Electric
Water
Attorney Signature:
Not applicable Comments:
Wastewater
Healthcare
Note: amounts are unaudited
Finance Director Signature:
Attorney Review
Administration Recommendation
X
Adopt Resolution
Other:
Professional
Computer
Solutions
The City of Seward, Alaska
Utility Enterprise Software Proposal
November 25, 2025
Confidentiality Statement
Professional Computer Solutions, LLC (PCS) holds this document to be proprietary and
requires that all readers hold the information it contains in strict confidence. The material is
provided to assist in evaluating our solution as it pertains to meeting your business needs.
No other use is permitted without prior written approval from PCS.
Table of Contents
A. Executive Summary 3
B. Company Profile 5
C. Solution Description 6
D. Implementation Approach 18
E. Training & Support 25
F. Pricing 27
G. Value -Added Service 35
The City of Seward, Alaska pg. 2
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
A. Executive Summary
On behalf of Professional Computer Solutions, LLC (PCS), thank you for the opportunity to
present this proposal outlining a fully integrated software solution for The City of Seward, Alaska
(Seward). Seward is actively modernizing its utility operations, financial structure, and
technology environment, including its transition to the Uniform System of Accounts (USOA), and
is seeking a platform that supports efficiency, transparency, and long-term growth.
PCS proposes a unified enterprise system designed specifically for public utilities. Our platform
brings together billing, financials, customer engagement, meter data management, GIS, staking,
operations management, and mobile workforce tools within a single environment. This fully
integrated approach addresses Seward's current challenges with system fragmentation and
supports a more accurate, efficient, and data -driven operation across all departments.
Our proposed solution is designed to support the operational needs and long-term strategic
goals identified by Seward. Based on the information provided to PCS and our ongoing
discussions, the PCS platform aligns closely with your current environment and future
expectations in the following areas:
■ Integration of multiple utility services into a unified system
■ Support for the Uniform System of Accounts (USOA)
■ Streamlined operations and workflows
■ Enhanced customer engagement tools
■ Comprehensive reporting and analytics
PCS stands apart from other vendors in several keyways:
■ Utility -Focused Expertise: With more than 160 utility clients nationwide, our team
understands the unique operational, regulatory, and customer -services challenges faced
by public utilities.
■ Tailored Implementation: Rather than offering "canned" configurations, our approach is
hands-on and collaborative. We work closely with your team to design a system that
mirrors your processes.
■ Superior Support Model: Our support teams are known for their responsiveness, deep
product knowledge, and long-term client partnerships.
Implementation Approach & Timeline Highlights
PCS follows a proven, collaborative implementation methodology:
■ Discovery & Planning: Joint process review and blueprint development
■ Configuration & Integration: Tailored system setup with third -party integrations
■ Training & Testing: Hands-on training and user acceptance testing
■ Go -Live & Support: Seamless transition with on -site and remote support
The City of Seward, Alaska pg. 3
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Company Qualifications & Relevant Experience
PCS has been delivering enterprise utility solutions for over 40 years. Our team of 175
professionals brings decades of combined experience in software development, project
management, and customer support. Our client base includes municipal and cooperative utilities
across the U.S., many of whom have partnered with us for decades.
Conclusion
We appreciate the opportunity to present this proposal to Seward. Our team is confident that our
experience, integrated technology suite, and client -first philosophy make us a strong partner for
Seward's next chapter. We look forward to the possibility of working together to implement a
solution that not only meets Seward's current goals but also supports operational resilience,
community service, and future modernization efforts.
Warm Regards,
Angela K. Miller
PCS General Manager
(0) 712.263.3106
(C) 712.269.1836
(E) angie.miller@pcs-csa.com
Blair. Patnaude
Regional Business Developer
(0) 712.263.3106
(C) 712.267.6565
(E) blair.patnaude@pcs-csa.com
Nate Houston
Business Development Manager
(0) 712.263.3106
(C) 712.269.7704
(E) nate.houston@pcs-csa.com
The City of Seward, Alaska pg. 4
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
B. Company Profile
Company Structure and Background
Professional Computer Solutions (PCS) was founded in 1982 in Harlan, Iowa and later
relocated to Denison, Iowa as the organization expanded. What began as a focused provider of
financial and customer information systems has grown into a comprehensive technology partner
serving utilities across the United States. As utility needs have evolved, our solutions and
expertise have grown alongside them.
In 2019, PCS became part of the Central Service Association (CSA) family, an organization
established in 1937 and operated without profit for the benefit of public utilities across the
Southeast. PCS functions as a wholly owned subsidiary within the CSA enterprise, sharing the
same client -first philosophy, commitment to service, and long-term partnership approach.
Together, PCS and CSA bring more than 130 years of combined utility experience.
Today, the combined organization provides software and services to over 170 utilities, ranging
from small municipal systems to large organizations serving more than fifty thousand
customers. Our client base includes municipal utilities, public power districts (PPDs), public
utility districts (PUDs), rural electric cooperatives, and investor -owned utilities. The services
managed through our platforms span electric, water, sewer, gas, broadband, sanitation,
stormwater, and a variety of other revenue streams.
With over 180 employees across PCS and CSA and more than 50 utility -specific products and
services, our organization delivers the stability, depth of resources, and long-term support
required for modern utility operations. Our teams specialize in application implementation,
customer support, software development, IT services, and hosted environments, ensuring that
each utility has access to the capacity and expertise needed throughout the life of the
partnership.
Corporate Values / Mission
The PCS mission statement is "to assist clients in their success by providing high -quality
solutions". For nearly forty years, our team has fulfilled that commitment, offering robust
technology paired with unmatched service and support. Our goal extends beyond meeting
expectations; we strive to exceed them. While many providers offer a canned application, PCS'
approach is hands-on and collaborative. We work closely with each utility to review existing
processes, design an implementation plan, and ensure confidence that the project will be
completed on time and within budget. Simply put, our expertise, skill set, and support
infrastructure provide assurance of a smooth, successful implementation.
The City of Seward, Alaska pg. 5
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
C. Solution Description
Utilit-e Solutions Suite
PCS provides a complete source for financial, customer utility billing, meter data management,
engineering information systems, hosting, networking, communications, hardware and software,
statement mailing services, consulting and a wide range of professional services. The PCS
organization is truly a "one source resource" for information technology within the utility industry.
PCS core solutions include:
• Utilit-e Insight: Financial Information System
• Utilit-e Connect: Customer Information System and Billing
• Utilit-e Online: Customer & Employee Portal
• Utilit-e Central: Application Hosting
• PCS Interface Engine: Interface engine to third parties
• Orbit MDM: Meter Data Management
• UtiliSuite GIS: UtiliTrak, UtiliCom, UtiliStake, UtiliView
• OMS/IVR: Outage Management System
Additional products and services shown below are available on an ala-carte basis and are listed
here to provide you with an overview of the complete range of services. A summary of each
solution is included.
Utilit-e Insight: Financial Information System
Utilit-e Insight is a powerful accounting and financial information
management solution written specifically for the utility industry.
Utilit-e Insight brings a new dimension to fund accounting and
activity -based cost accounting, where transactions are integrated
throughout the modules and entries are automatically posted
where appropriate, forcing funds to be balanced. Insight includes
the following modules:
[Uti112)
Financial Accounting
• Accounts Payable
• Accounts Receivable
• Capital Credits
• Cash Manager
• Employee Portal
• Employee Requisitions
• Employee Time Entry
• Fixed Assets
• General Ledger
• Inventory
• Plant Assets
• Project Costing
• Purchasing
• Payroll
• Point of Sale
• Transportation
• Unclaimed Property
• Work Orders
The City of Seward, Alaska
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Workflow Group
The Workflow Group provides a centralized, automated approval system that streamlines
operational processes across departments. This suite enables utilities to route, review, and
approve requests electronically, reducing paper -based processes, improving transparency, and
ensuring compliance with internal policies. Workflows are intuitive, configurable, and fully
integrated with PCS applications, allowing staff to track progress, receive notifications, and
manage approvals directly from their My Work dashboard. The Workflow Group enhances
efficiency, standardizes utility -wide processes, and supports timely, accurate decision -making.
The Employee Work Group contains the following modules:
Requisitions
• Submit electronic requests to procure inventory or non -inventory items
• Track approval history and status throughout the workflow lifecycle
• Receive automated email notifications to keep requesters and approvers informed
• View pending and assigned tasks directly in My Work
• Automatically generate a purchase order once the requisition is approved
AP Invoice Approval
• Route vendor invoices electronically through a structured approval workflow
• Upload supporting documentation for verification and audit purposes
• Utilize electronic routing to ensure timely review and approval
• Import approved invoices directly into an AP voucher batch for seamless processing
• Process payments via checks or ACH once approval is finalized
General Workflow
• Configure utility -defined workflows tailored to internal processes
Streamline operations with electronic routing, tracking, and automated approvals
• Build customizable forms and fields to match your utility's unique requirements
• Attach notes, documents, and supporting files for complete documentation
• Manage a wide variety of processes, such as IT requests, HR forms, travel requests,
and more
• Access all pending approvals and tasks through the My Work dashboard
The City of Seward, Alaska pg. 7
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Employee Work Group
This comprehensive suite combines essential modules like Employee Portal, Time Entry,
Request Changes, Notifications, and Time Off Requests. Employees can access everything
they need — from submitting timecards to requesting vacation days, all within a user-friendly
portal. This streamlines daily tasks, improves communication, and empowers your employees to
be more productive and engaged.
The Employee Work Group contains the following modules:
Employee Portal:
• Provides employees the ability to access company announcements,
• View real-time payroll information,
• Manage personal details, and update deductions, benefits, and direct deposit
preferences.
• Access paystubs and notification settings.
Employee Time Entry:
• Customizable templates,
• Daily or weekly entry options
• Seamless integration with the Employee Portal and My Work features.
Employee Request Changes:
• Allow employees to easily request updates to their personal information and deductions.
• streamlined process features electronic routing and tracking for approvals.
• Accessible directly from the Employee Portal.
Employee Notifications:
• Employees can subscribe to receive notifications on:
• Their payroll status, including record updates, paycheck processing, and direct deposit
confirmations.
• Employees can track changes to their personal information, pay rate, deductions, and
expenses.
Employee Time -Off Requests:
• Allows employees to electronically submit requests for time off, with
• Clear tracking and email notifications for both employees and managers.
• Employees can view their request history, remaining time off balances, and approved
schedules within the Employee Portal.
• Simplifies communication, ensures efficient approvals, and offers a convenient way to
view time off on the SID Calendar.
The City of Seward, Alaska pg. 8
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Utilit-e Connect: Customer Information System and Billing
Utilit-e Connect is an all -encompassing customer information
(CIS) / billing application capable of accommodating the needs of
large and small utilities. Connect provides the capability to bill for
a myriad of services including electric, water, sewer, propane,
long distance telephone, internet, cable, trash, and security lights.
Connect includes the following modules:
Ltitilit—econnecj
Customer Billing & CIS
• Agency Payment
• Device Management
• PCS Interface
• Batch Processor
• Integrated Messaging
• Prepay
• Billing
• Location Management
• Service Orders
• Cashiering
• Mobile Service Orders
• Service Order Dispatch
• Customer Service
• Monthly Processing
• Statement Generation
• Credit & Collection
• Outage Call Handling
• Web Customer Service
Mobile Service Orders:
Mobile Service Orders (MSO) app provides real-time access to service orders, allowing crews to
receive new requests, update data (with automatic completion or review options), and view
service locations on a map for optimized route planning. Throughout the day, crews can refresh
to receive new orders, capture images in the field, and transmit data back to the office even with
intermittent connectivity. This app runs on Android, iOS, and Windows devices, offering
flexibility for your crews to use tablets, laptops, or phones.
Utilit-e Online: Customer & Employee Portal
Web -based and mobile solutions are becoming more common all
the time. It's fast, convenient, secure and empowers the user by
providing access to information from almost anywhere at any
time. Customers can view account information and transact
business. Employees can view payroll information and enter
timesheets. All of this is available 24 hours a day, 365 days per
year. Online modules include:
• Customer Web Portal
• Employee Time Entry
• Mobile Customer Access
• Employee Web Portal
The City of Seward, Alaska
[Lidice?)
Customer &
Employee Portal
pg. 9
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Document Images with Scan Now
Scan Now simplifies document capture by allowing users to scan directly within the PCS
application. No more saving, transferring, or uploading — simply scan and index the image in
one seamless step. This integrated solution empowers utilities to create a secure image
database tailored to their specific needs, with user -defined image types, indexes, and security
controls.
Scan Now is available today on the following screens:
Insight:
AP — Vendor Inquiry
AP — Voucher Entry
AP — Workflow Voucher Review
AR — Customer Inquiry
CC — Member Inquiry
CM — Bank Account Reconciliation
FA — Asset Maintenance
GL — Journal Entry
IN — Material Item
IN — Assembly Unit
PO — Req to PO review
PO — Quotes
PO — Receipts
PA — Asset Inquiry
PR — Employee Maintenance
TR — unit inquiry
WO — Maintenance
Images Screen — All Modules
Connect:
- Account Images
- Extensions
- Service Order History
Service Order Wizard
- Service Order Tracking
Springboard:
- Requisitions
- AP Invoice Workflow
Time -Off Requests
- General Workflow
- Web CS
o Account Images
o Extensions
o Service Order
History
o Service Order
Tracking
Utilit-e Central: Application Hosting
PCS provides a world -class hosting service for all applications,
plus several IT solutions. The hosting center provides applications
from a remote server then distributes these applications to the
utility over a high-speed connection such as the Internet or secure
connection. These applications then operate from a browser or
other connection. Solutions include:
• Hosting Services
• Managed IT Services
• Disaster Recovery Services
• Cyber Security Assessments
• IT Consulting
• Anti -Virus
• PCS Cloud Backups
• Hardware Support Services
• 2 Factor Authentication
• Hardware Sales
Uri/ t— CenYralm
Application Hosting
The City of Seward, Alaska pg. 10
Professional Computer Solutions, LLC
Reshaping the Future
of Utility Technology
PCS Interface Engine:
PCS applications are uniquely designed to be
part of an "Open System" and integrate with the
"best of breed" third -party applications. As an
open system vendor, PCS is participating in the
national MultiSpeak effort sponsored by
Cooperative Research Network (CRN). The
MultiSpeak specification has become the
integration standard for many vendors in the
utility market.
This effort allows the greatest flexibility for the
utility to select solutions that work best for the
utility and the utility customer. The specification
is focused toward solutions related to the utility
industry and include accounting, billing,
AMR/AMI, meter data management, mapping,
staking, engineering, outage, work management
and other utility vendors.
afi* IVR
Bar Coding
Staking
Hostingai
The Smart
Utility
Enterprise
Engineering Work
Management
Analysis Custo_mer
Empowerment
GIS
Outa- ge
All these efforts are focused on initiatives incorporating flexibility, technology, and integration.
This benefits the utility by:
• Setting the standard on how applications will integrate
• Reducing the time and cost to implement utility applications
• Allowing the utility to select the best solution for the utility
• Ability to implement and integrate new technology
• Providing a full enterprise of solutions for the utility
The result of this effort is a solution suite offering an extensive range of features and benefits. At
the same time setting the standard on integration which ultimately lowers the cost and time to
implement for the utility.
Interfaces include flat files, direct API calls, and MultiSpeak web services. PCS' preferred
method of communication is via MultiSpeak web services. Utilizing these calls allows for and
facilitates sharing data in real time in both directions with a third -party application.
The City of Seward, Alaska pg. 11
Professional Computer Solutions, LLC
Reshaping the Future
of Utility Technology
Following are standard PCS methods based off the MultiSpeak specifications. These can be
used for a wide variety of functions. MultiSpeak has defined these functions to be used in AMI,
MDM, IVR, GIS, OMS and work management solutions.
PCS MultiSpeak Calls
Calls To PCS (Hosted
by PCS)
GetMethods
GetMeterByAM RType
GetServiceLocationByServiceStatus
PingURL
GetMeterByAccountNumber
GetServiceLocationByServiceType
GetAllCustomers
GetMeterByCustlD
GetServiceLocationByShutOffDate
GetAllMeters
GetMeterByMeterNo
CommitPaymentTransaction
GetAllServiceLocations
GetMeterByServLoc
ProcessPaymentTransaction
GetConvenienceFees
GetPayableltemsList
CDStateChangedNotification
GetCustomersByCustlD
GetServiceLocationByAccountNumber
CDStatesChangedNotification
GetCustomersByDBAName
GetServiceLocationByCustlD
ModifyCBDataForCustomer
GetCustomerByMeterld
GetServiceLocationByGridLocation
ReadingChangedNotification
GetCustomerByMeterNo
GetServiceLocationByMeterNo
StakedWorkOrderNotification
GetCustomersByName
GetServiceLocationByPhaseCode
GetAllMaterialltems
GetDomain Members
GetServiceLocationByServLoc
GetAllMaterialManagementAssemblies
GetDomainNames
PCS MultiSpeak Calls
Calls From PCS (Hosted by 3rd Party)
GetMethods
GetReadingByMeterNumberFormattedBlock
InitiateDisconnectedStatus
PingURL
GetReadingsByMeterNo
CancelDisconnectedStatus
GetAMRSupportedMeters
InitiateMeterReadByMeterNumber
InitiateUsageMonitoring
GetDomainMembers
IsAMRMeter
CancelUsageMonitoring
GetDomainNames
MeterAddNotification
GetCDMeterState
GetHistoryLogByMeterNo
MeterChangedNotification
GetCDSupportedMeters
GetHistoryLogsByDate
MeterRemoveNotification
InitiateCDStateRequest
GetLatestReadingsByMeterNo
ServiceLocationChangedNotification
InitateConnectDisconnect
WorkOrderChangedNotification
The City of Seward, Alaska
pg. 12
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Reporting Solution
PCS provides unparalleled access to data within the PCS solutions. This allows the utility to
utilize three separate tools for accessing data and they include:
1. Access and use PCS standard reports
2. PCS Microsoft Excel -based solution called Business Intelligence
3. PCS next generation report and visualization tool called Power Search.
PCS Standard Reports
PCS Utilit-e Solutions Suite provides hundreds of standard reports. PCS knows, however,
each utility and each individual within a utility has specific reports assisting in accomplishing the
everyday tasks at hand. One of the primary report development tools is Crystal Reports. Crystal
Reports is one of the best and most well-known reporting tools in the marketplace today.
PCS tracks standard reports created in Crystal Reports by PCS internally with the solution. If
the utility would add a report, the system can track standard reports and user generated reports
so the two do not get inter -dispersed. System Manager module controls the delivery and
access to reports generated in Crystal Reports within the PCS applications. A variety of
methods are available to securely manage reports outside the applications. PCS has over 400
accounting reports and more than 300 billing reports generated in Crystal Reports.
Most standard reports generated in Crystal Reports have the ability to filter the report based on
data available on the report. Examples include filtering by a financial period, work order, rate
codes, etc. As filters are applied, they can be saved as templates for future use without having
to reenter the filter. A great time saver for a user looking to find specific data within a report.
Business Intelligence Based on Excel
The PCS Business Intelligence solution based on Microsoft Excel, is bringing reporting, charting
and analysis to a new level by providing unique decision level tools to the end user. Team
members from across the enterprise can access and drill into graphs, charts, and tables as
information is presented from within and outside the walls of the utility.
PCS offers an inventory of Excel
workbooks that delivers a wide variety
of data directly into Excel for use by
the end user. Excel is the leading data
analysis tool.
By delivering information into Excel
workbook datasets, personnel are
enabled to use data from PCS
applications efficiently for many
diverse purposes. The workbooks also
include a variety of business
intelligence reports.
Crystal Utilities
Statement of Revenues, Expenses and Changes in Net Position
Total Income
Total Expense
Net Income (Loss)
Operating Income
3cerating Expense
20e rating Profit Margin
Internet on Long Term Debt
times Interest Earned .[TIER)
Doe rating Tmes Interest Earned {DTI ER)
Inte rest on Long Term Debt as a percentage of Revenue
Cost of Power
Gross Profit Margin
Grass Profit Percentage
Cost of Power as a Percentage of Operating Income
Operating Profit Margin as a Percentage of Operat,ng Income
Debt Servire Coverage
operating Debt 5ervlce Coverage
2013-05 2019-05 2915-05
5,244,738.26
5,326,673.58
(21,435.32)
5,173,745 96
5.306.312.25
(132.566.29)
371,492.60
0.78
0.64
3%
3,296,610.57
1,877,155.59
36%
64%
-3%
0 85
0.78
5,614 609 45
5,373 349 51
241,259.94
5,430 299 66
5,353 673 43
76,626 23
370,764.05
1.65
121
7%
3,415,790.81
2,014,508.85
37%
63%
1%
1.34
1._3
6,355,245.32
5,741,767.39
613,477.93
6,076,731. 10
5.719.438.85
357,292. 25
356,305. 54
2.72
200
6%
3.792378.42
2.284.352.62
38%
62%
6%
81
1.47
Through this strategy, utility staff is empowered to create custom reports, analyze data for
purposes such as budgeting and share data directly with other applications used by the utility.
Microsoft Access can also be used to query the data.
The City of Seward, Alaska
pg. 13
Professional Computer Solutions, LLC
Reshaping the Future
of Utility Technology
Revenue Trend
02 02 03 04 05 06 07 08 CO 10 11 12
Usage Trend
Revenue Code 30sc,phui
1 - NON ACRES
1 10-STREETLIGHTS
3-LRG COMMERCIAL
4-AG RELATED
5- CHRl1CH &SCHOOL
1'
Rate Description
10- REGULAR 5
10A- REGUL14I
SUB -SHBI RAC
VL01 - MERCURY VAPOR LIGHT
VL02- 100 WATT
VL03- 175 WATT
Register Type
KW
KWH
PCS Power Search
PCS has released a query and report tool called
ability to search through the database based on
This could include an invoice, work order, range
Power Search. Power Search unleashes the
user criteria to extract that certain piece of data.
of dollars amounts and many more.
Once the user selects the file or query, they then
is displayed on the screen for the user to export
Like Crystal Reports solution and BI, the Power
share queries for future use as well.
select the field(s) to search on, the results set
to CSV or open on the screen to view the data.
Search screen allows the user to save and
No more need for special reports, let Power Search find the data for you.
Look what Kelly
from Kittitas
PUD in
Washington is
saying: III
attended the
webinar about
the new Power
Search feature,
and I am SO
excited! You
guys nailed it,
seriously, and I
so appreciate
you and your
staff for adding
this."
Power Search View- Inventory Balances
Actions v
Conditions
Field
Operator
and Quantity On Hand v is greater than or equal to
Group By
Fund ID v
Asset Account v
f-]
[-]
Totals
Quantity On Hand v 5um
Value On Hand v sum
5um
Fund ID 1 Quantity On Hand Value On Hand
--�t Atttun7 1560 93601.020000 242,5' 53
Fund ID 1 Total 93,601.000000 242,461.53
Fund ID 2 Quantity On Hand Value On Hand
sset 6cccunr 156C
2.90S.5.2000_ 55.35-.5_
Fund ID 2 Total 2,908.500000 55,154.50
Value
5
]f-]
f-]
Total 56,509.500000 297,316.03
Show 19 . entries
Asset Account Item ID Description Item Status Item Type
f�]
Search
Group
Quantity on
Allow Negative Hand Average Cost Value on Hand
Clear
BIBB a s.
Clear
Close
0. 1560
q 1560
q 1560
Q 1560
Q 1560
ANCH006
AR5T402
ARSTELB
5END445
BETHEAI
CHANCE ANC... A 51 IS
ARRESTOR W... A 51 0 36.000000
10KV ELBOW ., A 51 el 14.060000
BENDS 4" -45... A 51 0 50.900000
BETHEA BRA... A 51 12
10.900000 21.28500000
36 79250000
65.94735714
43.16200000
16.900000 27.77812500
212.85
1324 53
923.27
2156.10
444.45
The City of Seward, Alaska pg. 14
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Additional Solutions as shown in E&O Proposal
Orbit MDM: Meter Data Management
The growth of automated metering infrastructure (AMI) has MDM
created tremendous opportunities within the utility world, but
it has also created an abundance of sometimes 5) Meter Data
overwhelming and often unusable data. Orbit MDM offers Management
data storage for interval meter readings from a wide array of
AMI vendors. It also offers reading validation, editing and
estimating for anomalies like missed and out -of -range readings, and more. The base MDM
system also provides billing determinates, including time -of -use and coincident peak information
to Utilit-e Connect CIS for accurate and up to date billing information.
In addition, Orbit MDM provides advanced analytics that include time -of -use reports, editable
midnight register reports, vacant meters with usage, meters with usage not assigned to
accounts, daily reads by meter vendor, customer and location usage summaries. The advanced
analytics option also offers meter audit reports like hi/low consumption anomalies, meter rating
exceeded, multiple day bad meter reads, anomaly summary charts and more.
• MDM Basic
• Advanced Analytics
UtiliSuite: GIS and Mapping Solutions
UtiliSuite is the suite of GIS solutions for utilities and
consists of four components: UtiliTrak®, UtiliCom
UtiliStake and UtiliGo. UtiliTrak and UtiliCom are standalone applications that enable a utility to
map and model its network infrastructure whereas UtiliStake is an add -on application to UtiliTrak
that enables a utility to integrate its staking process within a GIS environment. UtiliGo is a
standalone application that takes data from UtiliTrak and enables a utility to view its maps on a
mobile device or browser. A short overview of each module includes:
tgi UtiliSuite
1. UtiliTrak
UtiliTrak serves as the data warehouse for a utility's
network infrastructure by storing in one location the
data required for utilities to keep track of their
infrastructure while providing the necessary
interfaces by which that data is available for use by other applications.
CO UtiliTrak
2. UtiliCom
As a GIS-based application UtiliCom maps and
models the physical characteristics of a utility's
telecom network concentrating on the following
categories:
• Fiber optic network
• Inside plant
UtiliCom integrates with UtiliTrak so a utility with both applications can view its network
models from UtiliTrak alongside its network model for telecom.
CO UtiliCom
The City of Seward, Alaska
pg. 15
Professional Computer Solutions, LLC
3. UtiliStake
UtiliStake integrates a utility's staking process within
UtiliTrak and keeps the network models in UtiliTrak up
to date through the daily work process as staking jobs
are stepped through their defined life cycle and
completed. UtiliStake also integrates with work management systems, so construction unit
data maintained in a utility's work management system is available in UtiliStake.
Reshaping the Future
of Utility Technology
J UtiliStake
4. UtiliGo
UtiliGo provides utility -wide access to information about
a utility's network infrastructure for both field and office
personnel with an intuitive and easy -to -use mobile app
for field personnel and browser access for office
personnel.
NUS UtiliGo
5. Outage Management System (OMS) & Integrated Voice Response (IVR)
OMS provides simple ease -of -use and ease -of -implementation to track and map outages for
both electric and fiber services. Integration with AMI and IVR enables automatic
identification of new outages and the ability to recognize the continued existence of nested
outages which improves outage visibility and workflow.
Professional Services
In today's highly specialized and ever -changing world of information technology, utilities do not
always have the experts on staff, or the time, to handle the variety of hardware and software
issues, problems or questions that arise. PCS offer solutions designed specifically to fit these
needs. The group provides professional services that are available in — but are not limited to —
the following areas:
Network Design Cost Studies
System Hosting
Disaster Recovery Plans
Security Consulting
Computer Infrastructure Support
Custom Programming
Technical Support
Custom Reporting
Training / Retraining
Network Support
Hardware Configuration and Setup
Business Process Management
Coordination of Equipment
Hardware Sales
In addition to hosting services, PCS and CSA sell a wide variety of hardware from companies
like IBM, Dell, Epson, HP, Scan Corp., and more to our utilities. This value-added service is
often the least expensive and most efficient way to purchase computers, printers, scanners,
network hardware and more.
The City of Seward, Alaska
pg. 16
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
PCS Approach to Configuration & Customization
The PCS Utilit-e Solutions Suite features and functionalities is designed with a vast array of
individual utility configuration capabilities. The solutions are designed where features and
functionalities can be turned on or off according to the utility's needs. Not only may they be
turned on or off, but there are also many configurable options providing each utility with great
flexibility in the use of the application while minimizing customized programming.
While PCS has strong utility knowledge, PCS understands our role as professional consultants.
Therefore, PCS does not dictate business practices to clients and understands that on occasion
there may be need to develop custom solutions. PCS is willing and able to customize a solution.
To avoid difficulties when delivering new releases and updates, PCS builds customizations into
the core application code with policy settings to manage custom code.
Development Architecture
PCS has been developing software solutions for utilities since 1981. Over the last 40+ years
there have been four major migrations. Starting with RPG to Progress on Unix, next Progress
character to graphical, Progress DB to MS SQL, Progress 4GL to MS.Net and now the
migration to the web -based solutions on Bootstrap. These solutions will be the PCS foundation
for many years to come. The web -based solutions will serve as effective products for clients, a
great investment for PCS and efficient tools for employees.
PCS core solutions are based on Microsoft SQL server, C# & VB.Net, technologies based on
web solutions and reporting solutions based on Crystal Reports, SQL Reporting Services and
Excel. Primary reporting functionality utilizes PCS developed PowerSearch for both standard
reports and ad hoc end user reporting.
Security
Security of the data and systems is of utmost importance. PCS undergoes an annual SOC 2
Type 1 Audit. During the audit a penetration test is performed. PCS uses third party auditing to
verify that we are meeting current industry cyber security standards. PCS also uses a third party
to perform external penetration testing on a quarterly basis.
PCS maintains an Information Security Program detailing roles, information handling and
access rights. PCS also maintains an Incident Response Plan and uses industry standard
processes and procedures. PCS requires multi -factor authentication for all PCS staff as well as
all clients accessing the PCS hosting center.
The City of Seward, Alaska pg. 17
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
D. Implementation Approach
PCS Implementation Methodology
Conversion and live implementation of the Utilit-e Solutions Suite is only the beginning of an
on -going relationship. PCS doesn't just want to be the utility's vendor of choice but wants to be
the utility's chosen "partner". As a partner, PCS is committed for the long term.
The described Implementation/Management Approach is designed to provide the utility with the
highest quality solution. PCS as a company, as well as, each of its staff members prides
themselves on delivering high quality effective tools and solutions to the utility. Processes and
oversights throughout, not only the installation, but also the on -going partnership with the utility
are constantly designed, reviewed and approved to meet these goals and standards.
Discovery
The Discovery is an onsite visit where the PCS implementation team travels to the utility and
conducts a thorough needs analysis. From these in-depth discussions, a scope document is
developed. This document will detail areas and topics discussed which require either change in
the utility's current policies or procedures or modifications to the application itself. It also
includes the implementation timeline and training schedule as discussed.
Throughout the process of developing this scope document, the implementation team is in
continual contact with the utility's staff to clarify interpretations of requirements. The completed
scope document is presented to the utility for review. Often a task may be presented with more
than one resolution. The utility can then decide which tasks and/or alternatives best fit the
utility's environment.
Utility personnel requirements: At least one or two people need to participate in the entire
discovery dialog. Functional area specialists need to participate in respective area
discussions. The project manager and application owner (roles described in Project
Management section immediately following) are the minimum required attendees. In
addition, the primary users in each functional area are also important participants. Some
users may be involved throughout the entire discovery discussions while others may be
involved for just their select areas of specialty.
Project Management
Project management truly begins prior to the Discovery but shifts into high gear upon receiving
the utility's scope approval in accordance with the Discovery blueprint. The PCS installation
project manager along with the utility's project manager defines the timeline and milestones of
the installation. Throughout the installation the PCS project manager monitors and manages the
defined tasks and reports the progress to the utility. This process assures the project is staying
on course by identifying scope creep and providing an avenue to voice concerns.
The project manager is the primary contact and coordinator with the utility staff from the point of
starting the Discovery process and continuing throughout the entire installation — conversion,
testing, training, going live and on -going support. Once the installation is complete, the project
manager continues to be the primary support person for the utility.
For each application (Utilit-e Connect, Utilit-e Insight, Utilit-e Online) PCS provides a specific
contact person for each utility. As stated, the primary support person is involved throughout the
The City of Seward, Alaska pg. 18
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
actual installation. Each primary support person is backed up by a secondary support person
who in turn is backed up by the entire application support team. Each team is comprised of
individuals who have personally experienced the implementation process and have significant
knowledge of the PCS applications. A support call to PCS does not go into a support queue but
rather goes to the primary or secondary support person. This team is dedicated to responding
within a four-hour period with most support calls/emails being addressed in a shorter timeframe,
if not immediately.
Utility personnel requirements: A project manager and application owner needs to be
designated by the utility. This may be one person or multiple people. The project manager is
defined as the person who will be the primary contact person or liaison with PCS. This
individual will also coordinate the utility's staff schedules for training and other system
installation efforts. This activity spans the entire duration of the installation and continues
throughout the relationship between the utility and PCS.
Many decisions and considerations will need to be evaluated throughout the installation. The
application owner is the primary vested decision maker. Typically, this is an individual at the
management level who is responsible for the majority of the users and the associated
processes, procedures and information managed by the respective application. This
individual may not be able to make every decision related to the installation but will be able
to identify who needs to be involved in decisions and facilitate involving those appropriate
individuals and thus get the decision made.
Conversion
The utility will need to extract the data from its current application and provide said data in the
formats as requested by PCS. Should the utility not have the skill set to do this effort, or simply
desires PCS to take a more active role in this process that is also a workable solution. The
utility's staff will also need to work with PCS in conversion data verification.
PCS has developed standard conversion tools for converting core data. Utilit-e Insight
conversion includes general ledger accounts and monthly balances for current and prior year;
accounts payable vendors and addresses; fixed assets and current balances; accounts
receivable other customers and addresses; inventory items and current quantity and balances;
payroll employees; open work orders/projects. Utilit-e Connect conversion includes accounts,
applicants, addresses, locations, services, and meters. Other optional data conversion, such as
detail history, budget, ACH, landlords and messages, is converted as needed based on the
utility's business requirements.
In the additional areas, whether data is converted manually, or it is automated is based on the
volume and integrity of the existing data. In the past, some utilities have elected to manually
enter data for which they either have a low volume or their existing data needs some cleanup
work that would be easiest to address as a part of the conversion effort. When converting detail
history, commonly, thirteen months of data is converted but more history can be converted if
desired.
Utility personnel requirements: Typically, this requires one or two utility staff. An individual
with the technical capabilities to create the data export routines and an individual
knowledgeable of all the data in the system and how it relates. This may be the same or
various individuals.
The City of Seward, Alaska pg. 19
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Design and Analysis/Programming/Testing & Acceptance Testing
Design and analysis/programming/testing is primarily a responsibility of PCS. These are the
efforts required if the utility desires any application modifications. Acceptance testing is primarily
the responsibility of the utility. Throughout the installation, PCS will provide the utility with
opportunities to test the system to ensure the end result meets the utility's needs. Some of this
testing is incorporated into the training classes. Other areas may require special testing efforts.
The utility will also be an integral part of the conversion data verification process.
PCS employs standard quality assurance testing methodologies. Programming modification
testing includes code review, unit testing and systems regression testing as deemed necessary.
Implementation testing includes using the application during all phases of training with
recalculations of areas such as billing calculations.
The training is designed to simulate a month's worth of activity and provides the utility
opportunity to test and confirm the converted data, application setup and any programming
modifications that may have been made. This testing and confirmation process enables the
utility to confirm the application is functioning as discussed and understood. If anything is
identified that does not conform to the utility's expectations, the issues are discussed and
resolutions determined as how to proceed.
For customer statements and other client customer sensitive areas, statistical sampling
methodologies are used to attain a very high level of assurance. For example, as a part of each
Utilit-e Connect installation, PCS conducts quality assurance testing of the bill calculations and
statements. A statistical random sampling is selected, and the bills are each manually
recalculated, and the statement presentation verified. This testing is done jointly between PCS
and the utility staff. Two separate groups of PCS testers are engaged in this effort. One group is
the application support/deployment team. These testers are outside of the primary deployment
team for the installation to ensure that an additional level of scrutiny is reviewing the converted
data, bill calculations, application setup and statement presentation. Under that same premise,
the second PCS group involved in the testing is outside of the application support/deployment
team. This group of testers provides the aspect of looking at the end product, or in this case the
statement, more through the eyes of the end customer. The third group involved in the testing is
the utility staff. The scrutiny provided in the test by the utility staff is that of ensuring nothing was
misunderstood in the requirements as conveyed between the utility and PCS as to what the end
result is to be. This three -pronged approach provides a multi -faceted net to identify any
unwanted outcomes.
Determining the specific extent and nature of the test plan including parallel processing is a part
of the Discovery process of an installation, as well as, the definition/design process of every
product development project.
Utility personnel requirements: The project manager and/or functional area specialists
perform acceptance testing to ensure the solution meets the desired end result.
The City of Seward, Alaska pg. 20
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Training
PCS provides intensive and thorough training classes. The training is designed to equip the
users with knowledge and confidence prior to implementing their new Utilit-e Solutions Suite.
Throughout the partnership, PCS offers on -going training classes. Various classes are designed
for beginners, refresher training, advanced training, as well as, training on new features.
End -user training on the application software is accomplished in a variety of ways. Initial training
at the time of implementation is normally done face-to-face either at the client's office or at the
PCS training facility. Each application includes a standard number of training hours, which can
be tailored to suit the client's needs.
Refresher training is offered remotely via the Internet or in PCS's classroom facility. A list of the
training classes is available to clients on the PCS website at www.pcs-csa.com. Special
requests for training are handled on an individual basis as needed at the client's office, remotely
or at the PCS training facility. Regional training classes are also offered when the needs of
multiple utilities dictate.
The PCS trainers, in conjunction with the project managers from both the utility and PCS,
conduct on -going analysis of the trainee's comprehension and understanding of what is being
trained. This is accomplished via classroom observation, training quizzes or tests, monitoring of
practice sessions, and role playing. When it is identified that an individual user or group of users
are struggling, the project managers discuss the best approach to get the individuals to the point
they need to be. This may be the scheduling of additional group training classes or providing
one-on-one training either by PCS or a mentor from the utility.
For initial installation training, all end users are involved. The amount of training varies based on
job function. For example, the customer service representatives and billing clerks will be
involved in more training than others. Training can be conducted at PCS, at the client site or
remotely via the Internet or a combination thereof. Supplemental training or on -going training is
primarily conducted remotely via the Internet but can also be done at the client site or at PCS as
needed. When training is onsite, the utility is responsible for providing a training area and
sufficient number of workstations.
Utility personnel requirements: A minimum of two to four individuals need to be trained on
the entire application. Others will be trained in respective areas as job functions dictate. To
help ensure the quality of training and retention of information by the trainees, trainees need
dedicated time for classes and interruptions should be kept at a minimum. PCS provides
"hands-on" training. The training is done using the utility's data.
Following is a list of training classes/topics covered in the Utilit-e Connect training.
Utilit-e Connect Training Class Topics
Service Orders
Cashiering
Readings
Billing / Adjustments / Deposits
Delinquency
Meters
Inquiry
Month End / Balancing
The City of Seward, Alaska pg. 21
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Following is a list of training classes/topics covered in the Utilit-e Insight training.
r Utilit-e Insight Training Class Topics
System Manager
Accounts Payable
Accounts Receivable Other
Budgeting
Cash Manager
General Ledger
Fixed Assets
Inventory
Payroll & Time Entry
Purchase Orders
Live Date/Implementation
PCS provides onsite support during live implementation. The purpose of live implementation is
to ensure the successful utilization of the application. The deployment team is onsite to guide
the users through the first real life encounters of various situations, as well as, to assist and
resolve any unexpected items that may arise.
For a typical installation of the size and type comparable to the utility, the Billing/CIS installation
team will have one to two people onsite one or two weeks during the initial live month. For the
accounting/FIS implementation, typically three to four weeks of one to two people onsite. The
number of days onsite and which weeks are discussed are determined in the Discovery
process. Factors taken into consideration in these discussions include when and how often the
utility bills, how many users there are, volume of various activities, any utility specific
complexities and the overall comfort level and preference of the utility. Common activities for
onsite support include the first live bill production, first payroll check processing, month end and
the first days of being live.
When the installation team is not onsite, the PCS team can access the utility's systems remotely
and determine the user's need and assist them as required. By using the Internet and virtual
private network (VPN), PCS can connect to the utility's server and/or user's workstations. So, if
a user experiences a problem at a particular point in the application, PCS can access the
workstation and see exactly what the user is seeing to determine the problem and provide
resolution. Similarly, PCS can establish control of the workstation or server and correct the
problem in real time.
At all times whether onsite or remote, the PCS installation team has the support of the entire
PCS team if and as needed to assist. If at any time throughout the install, the utility or PCS sees
a need for additional onsite support adjustments can be made as needed.
Utility personnel requirements: All staff interacting with the application.
The City of Seward, Alaska pg. 22
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Post Installation Training
In addition to the pre -live training, an onsite follow up training trip is conducted two to four
months after going live. The purpose of this training is to review areas now in use and go into
deeper explanations of these areas as the users are ready to explore. This session is also
designed to address specific topics or procedures identified throughout the implementation
process that may need further fine tuning.
Utility personnel requirements: All staff interacting with the application.
On -going Partnership & Client Satisfaction
As stated above, the on -going partnership and relationship with each and every client is very
important to PCS as a company, as well as, to the individual employees of PCS. Each member
of the PCS team takes pride and ownership in working with and assisting all clients. The PCS
support structure enables the utility to build a close relationship with its installation project
managers which directly rolls into the on -going support role. Your calls and questions will be
directed to the individuals with whom you are familiar, with backup support from a full
complement of PCS support team members as needs dictate. Additionally, PCS will make
periodic onsite visits to understand both the management and users' current needs, as well as,
how PCS can provide further service and assistance.
Timeline
Following is a chart depicting a proposed installation timeline for Utilit-e Insight & Utilit-e
Connect. Upon signing of the Master Software Licensing and Service Agreement and related
work orders, the following charts depict the steps and potential timelines.
Utilit-e Insight
(Financials)
Month
1
Month
2
Month
3
Month
4
Month
5
Month
6
Month
7
Discovery isit
Work Order Signing
Develop Project Plan
Project Management
Conversion
Design & Analysis
IIIII
Programming
Testing
Training
Live Date
Implementation
Typical timeline for the Utilit-e Insight implementation is 5 to 7 months.
The City of Seward, Alaska pg. 23
Professional Computer Solutions, LLC
Reshaping the Future
of Utility Technology
Utilit-e Connect
(CIS/Billin•)
Discovery Visit
Month
1
Month
2
Month
3
Month
4
Month
5
Month
6
Month
7
Month
8
Work Order Signing
Develop Project Plan
Project Management
Conversion
Design & Analysis
Pro. rammin•
Testing
Training
Live Date
Implementation
Typical timeline for the Utilit-e Connect implementation is 7 to 8 months.
PCS Implementation Team
A project manager will be assigned to the Seward Utilit-e Connect installation. This individual is
not only a product specialist but also highly versed in the utility industry as it relates to the
applications. PCS installation/support team has an average tenure of fifteen years which
provides the team a wealth of experience and knowledge working with utilities.
The project manager is the primary contact and coordinator with the utility staff from the point of
starting the Discovery process and continuing throughout the entire installation — conversion,
testing, training, going live and on -going support. Once the installation is complete, the project
manager continues to be the primary support person for the utility.
PCS provides a specific contact person for each utility. As stated, the primary support person is
involved throughout the actual installation. Each primary support person is backed up by a
secondary support person who in turn is backed up by the entire application support team. Each
team is comprised of individuals who have personally experienced the implementation process
and have significant knowledge of the PCS applications. A support call to PCS does not go into
a support queue, but rather goes to the primary or secondary support person. This team is
dedicated to call the utility back within a four-hour period with most support calls/emails being
addressed in a shorter timeframe, if not immediately.
The specific project manager for the installation is assigned when the contract is signed. The
determination of which project manager is assigned to the install is based on a combination of
factors including the needs and overall background of the utility including the future desired
direction the utility is taking. PCS matches up the needs of the utility to the background and
experience of the various installation project managers on staff to form the best fit for success.
The City of Seward, Alaska pg. 24
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
E. Training & Support
Training
End -user training on the application software is accomplished in a variety of ways. Initial training
at the time of implementation is normally done face-to-face either at the client's office or at the
PCS training facility. Refresher training is offered remotely via the Internet or in PCS's
classroom facility. Special requests for training are handled on an individual basis as needed at
the client's office or at the PCS training facility. Regional training classes are also offered when
the needs of multiple utilities dictate. In addition, PCS offers various webinars on a regular basis
throughout the year.
Training/Test Environment
In addition to the process described above in the PCS Implementation Methodology, the
standard implementation includes a production and test or training database on the production
server running the production release. Some utilities elect (and this is encouraged by PCS) to
also implement a test server housing a test database. This environment is updated with the
newest release allowing the users to review in advance prior to putting the release into
production.
Documentation & Help System
The website includes a wealth of information related to products, services, meetings,
registration for webinars and news events. Included on the website is a comprehensive client
area where a user can find documentation, release notes, access to previous webinars, and
product related information.
PCS is currently in design/development of a new comprehensive help system that will provide
access to documentation, how to videos, FAQ's and release notes. Content specific help will be
available directly from the current screen as well as access to the full help suite from any
screen. In addition, the help system will provide access to webinar information and registration,
newsletter access and remote support link. These components are available today, but the new
system will focus on ease of use and accessibility for the end user.
Support Services
Support services consist of analysis of systems to determine causes of reported problems,
telephone and e-mail response to questions in application use, and troubleshooting. These
support services are provided on an unlimited hours basis during regular business hours
(7:30AM to 6:OOPM Central Time Monday through Friday). It is PCS policy that all client calls
will be responded to within four business hours. PCS also provides 24 x 7 emergency support.
Support services also included — at minimal additional cost:
1) Scheduled training classes at PCS offices or remotely via the Internet*
2) Annual PCS User Group Meeting
3) Any regional meetings that PCS may schedule periodically.
*Classes offered related to third party software are offered at an additional charge.
The City of Seward, Alaska pg. 25
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Through technology resources in place today, it is possible for PCS support staff to access the
utility's systems remotely and determine the user's need and assist them as required. By using
the Internet and virtual private network (VPN), PCS can connect to the utility's server and/or
user's workstations. So, if a user experiences a problem at a particular point in the application,
PCS can access the workstation and see exactly what the user is seeing to determine the
problem and resolution. Similarly, PCS can establish control of the workstation or server and
correct the problem in real time.
Network Support Services
PCS offers network, hardware and third -party application support services. These services are
intended to assist client IT staff as needed. It is provided at discounted prepaid rates.
Updates/Upgrades
Updates/upgrades are normally provided annually. Software patches are provided as needed.
Enhancements are prioritized by PCS management based on many factors. Clients have
substantial input on those decisions. The enhancements made to each application are a part of
the on -going development of the Utilit-e Solutions Suite and are driven by several factors.
PCS has product "roadmaps" for each application, which incorporate numerous lists of ideas.
This roadmap is used as the guideline for future development. Ideas are derived from current
clients, prospective clients, the market in general, the utility industry, and PCS' innovative ideas.
The timing of when an item is developed is a decision PCS makes based on these same factors
plus the availability of PCS resources — both development budget and staff. Application changes
required by Federal, state or regulatory bodies are provided as needed.
Releases are programmed, tested and available for deployment on a monthly basis.
Deployment of releases are scheduled between the utility staff and its primary support person.
Generally, utilities do not get every release, but each release is available to them as needs
dictate. The PCS team installs the release on the scheduled date outside of the utility's normal
business hours.
Development in process that will be available in upcoming releases is conveyed in the PCS
newsletters. Once a release is completed, the release notes are provided from the Help menu
within the application.
User Group
PCS clients are encouraged to share their views on how PCS can better serve them. Annual
User Group meetings, webinars, and training classes via the Internet and/or at PCS allow PCS
clients to come together for training, review new software, share ideas on software
enhancements, and discuss future products. User letters and the PCS website offer clients
news of the industry and provide information on PCS product direction and future product
development. PCS also conducts periodic regional meetings hosted at various locations
throughout the country.
The City of Seward, Alaska pg. 26
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
F. Pricing
The following lists the licenses, labor to install, and hosting services comprising the components
included in this proposal.
Initial Licenses
PCS licenses that will be provided by this solution:
• Utilit-e System Manager
o Manage users, security, menu options, etc.
o Automatically included with Connect & Insight
o Batch Processor
• Utilit-e Connect modules to include:
o Billing Services for:
• Electric, Gas, Water, Wastewater, Fiber and other fixed related fees (non -
metered)
• Possible other miscellaneous charges
o Customer Service
• Manage locations, accounts and applicants
o Statement Generation & Printing statements:
• Statement Generation
o Cashiering
• Manages receipt of customer payments to the utility. Payments
originating from walk-ins, drive through, drop box, mail, customer portal,
additional methods are available.
o Integrated Messaging
• Send texts/emails for events such as bill generated, payment posted, past due
• Twilio
o Billing
• Interface to meter reading system — AMI system(s) and/or MDM
• Ability to manually enter reading data
o Credit and Collection
o Budget Billing and Deposit Tracking
o Device Management and Location Management
o Monthly Processing
o Service Orders (electronic and/or paper)
o Application Setup
o AMI Integration
o Document Images with Scan Now
• Utilit-e Insight modules to include:
o Accounts Payable
o Accounts Receivable
o Cash Manager (bank reconciliation)
o Fixed Assets
o General Ledger (w/ budgeting)
o Project Costing
o Purchasing
o Payroll
The City of Seward, Alaska pg. 27
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
o Work Orders
o Employee Work Group
o Workflow Group
o Document Images with Scan Now
• Utilit-e Online
o Customer Portal website (hosted by PCS)
o Mobile Customer Access (MCA) — mobile app
o View account, payments, usage, statements, debt recovery balance, etc.
o Make a payment via Payment Service Network (PSN)
o PCS Notify (SMS Text)
• MultiSpeak AMI Interface testing with third -parties MDM, GIS, OMS, IVR
o PCS provides several automated methods to integrate with third -party solutions
such as metering, mapping and outage. During the Discovery process, PCS will
determine how or if PCS will be communicating to any other solution besides AMI
& GIS.
• Utilit-e Central: Hosting services for billing, financials, and MDM (included in E&O
quote).
Professional Services
PCS will provide specific professional services to ensure smooth installation. These services will
be billed as listed below and outlined in the final Discovery document. These services include:
• Discovery — Initial overview of the utility's business requirements
• Design — Determining unique business requirements and development
• Setup & App Testing — Setup of system and testing of applications
• Training — Onsite training
• Live Implementation — PCS team onsite during initial live run
• Conversion of Data — Importing of data into PCS solution
PCS has included conversion services. Conversion data varies from each utility, and it is difficult
to provide even a range of hours. Conversion can be better defined during the Discovery
process. A rough estimate for conversion typically runs from 150 to 200 hours, which is what is
included in this quote. Hours above 180 would be billable to the utility. Another option would be
to manually enter the data into the system.
The City of Seward, Alaska pg. 28
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Hosting Services
PCS is quoting to host the solution. Included in the quote is:
• Initial setup of the server including testing from utility
• Server hardware, management, security, hourly backup, disaster recovery backup.
• Monthly hosting of billing application, financial application, and Customer Portal.
• Application users are billed at $45 per month
o User fee includes Windows, Terminal Server and database CALs
■ NOTE: The hosting service requires a high-speed Internet connection, or
connection to a local area network with high-speed Internet access, will
be required at each workstation or payment center.
o Multi -Factor Authentication (MFA) is also a requirement of our solutions. MFA is
included with each application user.
o For those users at the utility who are not core application users, but rather time -
entry only users, MFA is still required. These users will be billed to the utility at
$3.50 per user, per month.
o Authentication methods include: mobile push, Token Generator, or Yubikey.
Hardware devices are additional one-time costs.
The City of Seward, Alaska pg. 29
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Proposal Pricing
The following pages provide pricing for the requested software solutions. Annual Maintenance
and support is prorated based on the month of go -live, this chart assumes an entire year.
The 2025/2026 retail rate for professional service hours is $172 per hour. Support hours are
calculated at $172 per hour. Cumulatively, license costs have been reduced by 15%.
TO City of Seward, AK
Taylor Crocker
490 Adams St. Seward, AK 99664
Quote
Quote NO : 112625
DATE : November 26, 2025
EXPIRATION DATE : January 31, 2026
Prepared By
Requested By
Quote Description
Nate Houston
Taylor Crocker
PCS Enterprise Suite
v1.0
SH
DESCRIPTION
Hours
One -Time
License
One -Time
Dollars
Annual
Maint/5upport
60
Utilit-e Connect (Billing/CIS)
$ 13,250.00
$ 12,970.00
Professional Services
690
$ 118,680.00
Conversion
250
$ 43,000.00
60
Utilit-e Insight (Financials)
$ 10,500.00
$ 12,420.00
Professional Services
300
$ 51,600.00
Conversion
100
$ 17,200.00
20
Utilit-e Online (Customer Portal/Phone App)
$ 5,525.00
$ 4,545.00
Professional Services
30
$ 5,160.00
Utilit-e Central (Application Hosting for Connect E Insight)
$ 1,650.00
$ 5,220.00
Central User Fee ($45 /user I month)
17
$ 9,180.00
12
Mobile Service Orders
$ 2,100.00
$ 2,484.00
Professional Services
16
$ 2,752.00
10
Multispeak AMI Interface
$ 1,300.00
$ 1,980.00
Professional Services
40
$ 6,880.00
30
Employee Work Group (Portal, Time Entry, Time Off, Notifications, Changes, Notify)
$ 5,000.00
$ 7,183.00
Professional Services
65
$ 11,180.00
20
Workflow Group (General, Requisitions, AP Invoice)
$ 2,500.00
$ 4,520.00
Professional Services
60
$ 10,320.00
12
Document Images w/ Scan Now
$ 1,300.00
$ 2,904.00
Professional Services
12
$ 2,064.00
PSN Credit Card @ e-Check Payment Gateway
$ 100.00
$ 340.00
`DUO MFA is a requirement of the application_ Additional fees for this service may apply_
*Conversion hours are an estimate based on experience. Yon will be billed as incurred foractuat
`Travel and ou t of pocket expenses biked as :rimmed.
Totals:
1563
$ 43,125.00
$ 268,936.00
$ 63,746.00
15%License Discount (applicable if contract signed prior to1f31f2b)
$ (6,469.00)
Discounted Totals:
$36,656.00
$268,936.00
$ 63,746.00
This Quote is submitted under the terms and conditions of the current Software Licensing and Services Agreement.
Pricing does not include possible travel and out-of-pocket costs. This offer is valid until 1/31/26. If not accepted within
this time period, adjustments may be required. To accept this Quote please notify PCS by e-mail, mail or telephone.
Thank You For Your Consideration Of This Quote
The City of Seward, Alaska
pg. 30
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Additional Note:
Credit Card & e-Check Payment Gateway
Currently, Payment Service Network (PSN) provides the payment gateway to process credit
cards and e-Checks. The utility would sign up directly with PSN, then PCS uses the PSN
Gateway to process all credit cards and e-Checks.
PSN fees include (subject to change by PSN):
o One-time setup fee of $99.
o $19.95 monthly maintenance fee.
o $100 annual security compliance fee (not billed until Dec 1st).
o PSN can provide a fee structure for handling credit cards and e-Checks.
o PSN also negotiates with the utility how "Convenience" fees could be assessed.
If the utility will be processing credit cards in the office in a face-to-face manner with the utility
customer, the utility will need to purchase an EMV certified terminal for handling the credit card.
PSN sells several models and the one-time cost for the terminal typically runs between $300-
$500. PSN provides several methods to make payment including cashiering, mobile, web portal,
IVR, Kiosk, payment terminals, bank bill pay, quick pay and others. For this quote, PCS is
proposing to start with cashiering, web portal and mobile app.
PCS is also in the process of integrating with another payment gateway provider. This
option is likely to be available in 2026.
Software & Hardware Platform
PCS is providing two separate hardware environments for consideration. PCS has a service for
hosting called Utilit-e Central. This reference means the application resides at the PCS hosting
center in Denison, IA and not located at the utility. The second section, In-house Hardware
Solution, provides the minimum specifications for an in-house solution. PCS will facilitate either
option.
Hosting
Utilit-e Central (hosting) is an innovative method of delivering software applications via the
Internet. In today's business arena, it is imperative to stay up to date with all aspects of the
computer system's hardware and software. This has become a major budget item for most
utilities. As the utility of tomorrow expands their product and service offerings, they have a real
need to stay on top of the tools needed to accommodate these changes. This would normally
mean constant updating of computer servers along with a continual upgrade of software
applications. Both require a substantial investment in equipment, licenses and personnel.
Utilit-e Central provides a method of software delivery eliminating many of the headaches and
expenses that go along with maintaining a proper computer server. Companies subscribing to
Utilit-e Central use the applications, which can range from customer relations management
applications to payroll processing software. Utilit-e Central houses all applications and data at
a central facility where PCS manages backups and environmental control, disaster recovery,
and professional management of hardware and communications. Utilit-e Central was awarded
the Internet Initiative Company of the Year by the Software and Information Technology
Association of Iowa in past years.
The City of Seward, Alaska pg. 31
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
PCS hosts applications for over 65 organizations. This includes 40 Utilit-e Connect (CIS)
solutions. The customer portal, Utilit-e Online, is hosted within Utilit-e Central for all PCS
clients including those that have Connect implemented in an in-house deployment.
PCS also offers local network support to our clients. This includes installation and maintenance
of Firewalls, Wireless Access Points, Network Switches, Routers, Anti -Virus software, Multi -
Factor Authentication, and general network management.
PCS Utilit-e Central hosting includes a variety of benefits:
Server Hardware — Latest technology servers and server -related software are provided.
Server hardware and related software are designed to more than adequately meet utility
requirements for speed and storage. Hardware maintenance provided by the hardware
manufacturer is included. Please note, hardware and software used to access the hosted
servers from the utility office(s) is not included.
Computer Operators — PCS is staffed with trained IT professionals during normal work
week, and they remain on call during weekends and holidays. These capable professionals
and monitoring systems continually monitor servers and related hardware to identify
indications of irregularity within the system and quickly and effectively make modifications
with as little interruption as possible to the utility's computer operation.
Technical Support — PCS and CSA's experienced staff, including DELL, Microsoft, IBM,
VmWare, SonicWall and CISCO certified technicians, provides ongoing server support at no
additional cost. Technical support of other hardware and software at a utility's office(s) is not
included in hosting services.
File Backup Processing — PCS will coordinate the backup of utility data and safely store the
data in a retrievable form to assure minimal disruption in the event of a system failure. The
data integrity is checked, and the backups are encrypted for security. The data is also
routinely stored in an offsite secured storage facility.
Disaster Recovery — PCS provides an automated daily disaster recovery backup copy to a
backup data center provided by PCS parent company CSA. This adds additional data
protection for the utility in the case the PCS data center is involved in a disaster, adversity or
failure. This service is provided as part of the base service for each utility in the hosting
center and includes both the application and database systems.
Uninterruptible Power — PCS maintains an uninterruptible power supply (UPS) system
including extended generation through a backup generator.
Physical Security — Hosted server hardware and data is housed in PCS's headquarters
which is secured, located in a reinforced concrete vault, restricted access within the building,
etc.
Business Recovery — Clients utilizing hosting services have immediate access to spare
hosted server hardware in the event of a local system failure. Hosted clients also benefit from
CSA and PCS internal business recovery planning.
The City of Seward, Alaska pg. 32
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Also included — Overhead expenses that would normally be incurred by a utility to employ a
service organization for such expenses as insurance, employee benefits, facility usage,
utilities.... and more.
Utilit-e Central enables the utility to focus on serving utility customers versus managing
technology. As stated before, the utility staff can serve customers as opposed to managing
software applications, servers and databases. Even if the utility has an IT staff, using Utilit-e
Central hosting services enables the in-house IT staff to solve core in-house IT issues and
manage the overall utility enterprise.
In -House Hardware Solution
Requirements for the in-house hardware solution include:
• Existing local workstations are present and meet the requirements of the systems.
• All devices are networked in both Local Area (LAN) and Wide Area Network (WAN)
configuration, with computer/network malware protection in place.
• High-speed Internet connection is in place for support purposes. If the application is
located at the utility, PCS will require access to the system servers to perform routine
system updates and support.
• Firewall compatible with PCS firewalls.
Following are the default specifications PCS starts with. Each client is reviewed at the start of
migration discussions. Changes are made, as needed, depending on virtual environment or
physical hardware.
Application server
- Windows Server OS 2019 or 2022
2-4 CPU's
16 GB memory
Drives
o C — System (250 GB)
o D — Data (500 GB)
Install all printers and necessary drivers
Terminal services
Database server
Windows Server OS 2019 or 2022
SQL Server 2017, 2019, or 2022
o PCS or client can install
4 CPU's
16 GB Memory
Drives:
o C — System (250 GB)
o D — Data (500 GB)
o E — Logs (500 GB)
o S — Backups (500 GB)
The City of Seward, Alaska pg. 33
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
Both servers
- Accessible by VPN
- Local `pcssupport' admin accounts
- If in a virtual environment, Memory/CPU Hot Add enabled, Thin Provisioned
PCS recommends these options.
After PCS has access to new servers (timeframe 2-4 weeks)
1. PCS installs programs
2. PCS installs support software
3. PCS copies over System Manager and Insight databases to new server
4. PCS starts Connect conversion to Dataserver
a. Works through data issues
5. Server is handed over to support team for testing
a. Response time
b. Printers
c. 3' party interfaces
d. Internet configuration for PSN payments
6. Schedule live date
7. Upon live date — utility will need to move data files
a. Individual progress folders to /my documents/pcs
b. EXT, logging, batch processor, ACH files
c. This list is defined during testing efforts on what all clients use
8. Users will use new RDP connection live date
a. Will have to set default printer
b. Cashiering receipt printer
c. My Favorites for new directory pathing
HDD -
The City of Seward, Alaska pg. 34
Professional Computer Solutions, LLC Reshaping the Future
of Utility Technology
G. Value -Added Service
At Professional Computer Solutions (PCS), we go beyond software implementation to deliver
comprehensive value-added services that empower utilities to operate more efficiently, adapt to
evolving industry demands, and maximize return on investment. PCS offerings include:
Business Process Optimization Consulting
PCS provides expert consulting to help utilities streamline and modernize their operational
workflows. This practice is leveraged in multiple products across our software suite. Leveraging
deep industry knowledge and hands-on experience, our staff assess current processes, identify
inefficiencies, and recommend tailored improvements that align with best practices and
regulatory requirements. Whether optimizing billing cycles, financial reporting, or outage
response, PCS ensures your utility operates at peak performance.
Staff Augmentation Options
To support your team during critical projects or resource gaps, PCS offers flexible staff
augmentation services. Our experienced professionals can integrate seamlessly with your
internal teams, providing specialized expertise in areas such as system configuration, data
migration, training, and ongoing support. This ensures continuity, accelerates project timelines,
and reduces the burden on internal resources.
PCS does not have a service to provide staff to the utility. PCS staff will however, support your
team — new and/or temporary hires — to overcome any challenges that may arise.
Utility Best Practices Guidance
PCS brings decades of experience working exclusively with utilities, enabling us to offer
actionable guidance rooted in industry best practices. From regulatory compliance to customer
engagement strategies, we help utilities adopt proven methodologies that enhance service
delivery, improve customer satisfaction, and ensure long-term sustainability.
Advanced Analytics and Al Capabilities
PCS solutions incorporate advanced analytics and Al -driven insights to help utilities make
smarter, data -informed decisions. PCS enables predictive maintenance, consumption
forecasting, anomaly detection, and customer behavior analysis through integrated tools and
dashboards. Today, this can be found within our Meter Data Management software. In the
future we plan to incorporate these Al -driven insights into our billing software and across
multiple applications. These capabilities empower utilities to proactively manage assets, reduce
operational costs, and enhance reliability.
Mobile Workforce Solutions
PCS supports modern utility operations with robust mobile workforce solutions. Field personnel
can access real-time data, manage service orders, and report issues directly from mobile
devices, improving response times, reducing paperwork, and enhancing service quality. PCS
mobility goes beyond a core set of tools like Mobile Service Orders. The entire PCS suite of
software is accessible anytime, anywhere, and to anyone — with the proper credentials.
The City of Seward, Alaska pg. 35