Skip to main content

Manufacturer and Model Management (MX04US02)

Meter Inventory Management User Story

1. Problem Statement

For Meter Manager:

  • Repetitive manual entry of technical specifications for each new meter, leading to inefficient workflows
  • Lack of standardized meter models resulting in inconsistent data entry and potential errors
  • No centralized visibility into meter inventory across manufacturers, models, and conditions
  • Difficulty tracking meter performance and condition trends across different models
  • Inability to analyze procurement patterns and make data-driven vendor decisions
  • Time-consuming process of managing individual meter records without bulk operations

For Meter Supervisor (Device Manager):

  • Limited oversight of meter asset lifecycle and condition distribution
  • Difficulty identifying optimal meter models for specific utility applications
  • Lack of predictive insights for meter replacement planning
  • No standardized approach to evaluate meter model performance across the fleet

Core Problem:

The current meter management system lacks a structured approach to meter model standardization and inventory oversight. This results in inefficient data entry processes, inconsistent meter specifications, limited visibility into fleet performance, and suboptimal procurement decisions due to lack of analytical insights.

2. Who Are the Users Facing the Problem?

Meter Manager:

  • Oversees all metering operations and data collection
  • Manages meter reading schedules aligned with billing cycles
  • Coordinates meter installation, replacement, and maintenance programs
  • Ensures data quality for consumption measurements
  • Implements new metering technologies and reading methods
  • Analyzes consumption data for system efficiency

Meter Supervisor (Device Manager):

  • Manages the utility's meter inventory and specifications
  • Oversees meter testing, calibration, and certification processes
  • Coordinates large-scale meter replacement programs
  • Evaluates new meter technologies for potential adoption
  • Ensures meter compliance with industry standards and regulations
  • Develops meter installation and maintenance procedures

3. Jobs To Be Done

For Meter Manager:

  • When I need to add new meters to the system, But I have to manually enter repetitive technical specifications for each unit, Help me leverage pre-configured meter models with standardized specifications, So that I can reduce data entry time by 80% and eliminate specification errors.
  • When I need to understand my current meter inventory distribution and performance, But I lack visibility into meter conditions and model performance across my fleet, Help me access comprehensive dashboard analytics showing inventory metrics by manufacturer, model, and condition, So that I can make informed decisions about procurement and replacement planning.
  • When I need to evaluate which meter models are performing best in my system, But I don't have comparative analytics across different manufacturers and models, Help me analyze meter condition trends, failure rates, and performance metrics by model, So that I can optimize my procurement strategy and reduce maintenance costs.

For Meter Supervisor (Device Manager):

  • When I need to create new meter model specifications for procurement, But I lack a standardized template system that captures all technical requirements, Help me define comprehensive meter models with all technical specifications and smart meter configurations, So that I can ensure consistent procurement standards and enable bulk meter additions.
  • When I need to track individual meter lifecycle and condition changes, But I don't have visibility into meter age, installation history, and current status, Help me access detailed meter tracking with installation dates, age calculations, and condition monitoring, So that I can proactively manage meter replacement schedules and maintenance needs.

4. Solution

The Meter Inventory Management system provides a comprehensive solution for standardizing meter models and managing meter inventory:

Key Capability Areas:

  1. Inventory Dashboard
    • Real-time metrics showing total manufacturers, models, and meters in system
    • Visual breakdown of meter types (Smart, Photo, Manual) with counts
    • Average meters per model calculation for distribution analysis
    • Growth indicators showing new additions and quarterly trends
  2. Meter Model Management
    • Standardized meter model creation with pre-configured templates
    • Comprehensive technical specifications capture including dimensions, flow rates, and materials
    • Smart meter configuration options for communication types and firmware versions
    • Manufacturer and model name standardization with dropdown selections
  3. Technical Specifications Repository
    • Complete technical parameter capture (dial length, count, max flow, connection size)
    • Physical specifications including weight, dimensions, and materials
    • Accuracy class definitions and IP rating configurations
    • Smart meter features including OTA updates, encryption, and API integration capabilities
  4. Meter Condition Tracking
    • Real-time condition monitoring with Normal, RCNT (Recent), and Faulty classifications
    • Individual meter lifecycle tracking with installation dates and age calculations
    • Device number assignment and status management
    • Condition distribution analytics across all meter models
  5. Manufacturer and Model Analytics
    • Manufacturer performance comparison across total meters and conditions
    • Model-specific performance metrics and failure rate analysis
    • Utility type distribution (Water, Gas, Electricity) across models
    • Created by and creation date tracking for audit purposes
  6. Individual Meter Management
    • Detailed meter records with device numbers and installation dates
    • Age calculation in months from installation date
    • Status tracking (Active, RCNT, Faulty) with visual indicators
    • Action capabilities for viewing, editing, and managing individual meters
  7. Bulk Operations and Filtering
    • Search functionality across model names and manufacturers
    • Filter options by meter type, condition, and manufacturer
    • Bulk meter addition based on pre-configured models
    • Mass status updates and condition changes
  8. Smart Meter Configuration
    • Communication type selection (cellular, RF, etc.)
    • Firmware version tracking and update management
    • Battery life specifications and monitoring
    • Security features including encryption and API integration toggles

5. Major Steps Involved

For Meter Manager using the Meter Inventory Management feature:

  1. Access Inventory Dashboard
    • Navigate to the Metering module in SMART360
    • Select "Meter Inventory Management" from the navigation menu
    • View dashboard showing 7 manufacturers, 7 models, 7,890 total meters, and 1,127 average meters per model
    • Review growth indicators showing +2 new manufacturers this quarter and +3 models added this month
  2. Review Meter Model Distribution
    • Examine meter type breakdown showing Smart (3), Photo (2), and Manual (2) models
    • Use search bar to find specific models by manufacturer or model name
    • Apply filters to view specific meter types or manufacturers
    • Review table showing all models with their specifications and current inventory
  3. Analyze Meter Conditions
    • Review condition distribution across models (Normal, RCNT, Faulty counts)
    • Identify models with high faulty percentages for replacement prioritization
    • Compare condition performance across different manufacturers
    • Use condition data to inform procurement and maintenance decisions
  4. Access Individual Meter Details
    • Click on a specific meter model (e.g., "E-Series Ultrasonic" by Badger)
    • View comprehensive model information including technical specifications
    • Review meter statistics showing 650 total meters with condition breakdown
    • Access individual meter list showing 8 meters with their device numbers, installation dates, and current status
  5. Track Meter Performance
    • Monitor individual meter age calculations (e.g., 28 months, 27 months)
    • Review installation dates and track meter lifecycle progression
    • Identify meters approaching replacement age or showing performance issues
    • Use action buttons to view detailed meter information or make updates

For Meter Supervisor creating new meter models:

  1. Initiate Model Creation
    • Click "Add New Meter Model" button from the inventory dashboard
    • Access the meter model creation form with General Information and Technical Specifications sections
  2. Configure General Information
    • Select manufacturer from dropdown or add new manufacturer using "+" button
    • Enter model name in the required field
    • Select meter type from dropdown (Smart, Photo, Manual)
    • Enter optional make code for model identification
    • Select supported utilities by checking Water, Electricity, and/or Gas checkboxes
  3. Enter Technical Specifications
    • Input dial length in millimeters, dial count, and maximum flow rate (m³/h)
    • Select connection size from dropdown and enter weight in kilograms
    • Select accuracy class from dropdown options
    • Enter physical dimensions: length, width, and height in millimeters
    • Describe material composition in text field (e.g., "Brass body, polymer register")
    • Select IP rating from dropdown for environmental protection classification
  4. Configure Smart Meter Features (if meter type is Smart)
    • Select communication type from dropdown (cellular, RF, LoRaWAN, etc.)
    • Enter firmware version information
    • Specify battery life expectancy in years
    • Toggle smart features: "Supports OTA Firmware Updates", "Encryption Enabled", "Enable API Integration"
  5. Save and Activate Model
    • Review all entered specifications for accuracy
    • Click "Save Meter Model" to create the standardized model
    • New model becomes available for bulk meter additions and inventory management
    • Model appears in inventory dashboard with initial zero meter count

6. Flow Diagram

graph TD
    A[Access Inventory Dashboard] --> B{User Action?}
    
    B -->|View Models| C[Review Model List]
    B -->|Create Model| D[Add New Meter Model]
    B -->|Search/Filter| E[Apply Search Criteria]
    B -->|View Details| F[Access Model Details]
    
    C --> G[Analyze Condition Distribution]
    E --> C
    
    D --> H[Configure General Information]
    H --> I[Enter Technical Specifications]
    I --> J{Smart Meter?}
    J -->|Yes| K[Configure Smart Features]
    J -->|No| L[Review and Save]
    K --> L
    L --> M[Save Meter Model]
    M --> N[Return to Dashboard]
    
    F --> O[View Model Statistics]
    O --> P[Access Individual Meters]
    P --> Q[Track Meter Conditions]
    Q --> R{Action Required?}
    R -->|Yes| S[Update Meter Status]
    R -->|No| T[Continue Monitoring]
    
    G --> U[Make Procurement Decisions]
    S --> V[Document Changes]
    T --> W[Regular Performance Review]
    
    N --> A
    U --> A
    V --> A
    W --> A

7. Business Rules

General Rules:

  1. All meter models must have a unique combination of manufacturer and model name within the system
  2. Manufacturer field is mandatory and must be selected from existing manufacturers or added as new
  3. Model name field is mandatory and cannot exceed 50 characters
  4. Meter type must be selected from predefined options: Smart, Photo, or Manual
  5. At least one supported utility (Water, Electricity, Gas) must be selected for each model
  6. Created by and created on fields are automatically populated with current user and timestamp
  7. All meter models default to Active status upon creation
  8. Make code field is optional and limited to 20 characters for internal reference

Technical Specifications Rules:

  1. Dial length must be entered in millimeters and accept only positive numeric values
  2. Dial count must be a positive integer representing the number of dials on the meter
  3. Max flow rate must be entered in m³/h (cubic meters per hour) and accept decimal values
  4. Connection size must be selected from standard pipe sizes (1/2", 3/4", 1", 1.5", 2", etc.)
  5. Weight must be entered in kilograms and accept decimal values up to two decimal places
  6. Accuracy class must be selected from standard classifications (Class A ±2%, Class B ±5%, etc.)
  7. Physical dimensions (length, width, height) must be entered in millimeters as positive integers
  8. Material field is free text with a 200-character limit for describing meter construction
  9. IP rating must be selected from standard ratings (IP54, IP65, IP68, etc.) defining environmental protection

Smart Meter Configuration Rules:

  1. Smart Meter Configuration section only appears when meter type is selected as "Smart"
  2. Communication type must be selected from available options (Cellular, RF, LoRaWAN, Wi-Fi, etc.)
  3. Firmware version field accepts alphanumeric input up to 20 characters (e.g., "1.2.3", "v2.1.5")
  4. Battery life must be entered in years as a positive number with one decimal place precision
  5. Smart meter feature toggles (OTA Updates, Encryption, API Integration) default to disabled
  6. Enabling API Integration requires encryption to be enabled for security compliance
  7. OTA firmware update capability is recommended for all smart meters for remote maintenance

Meter Statistics and Condition Rules:

  1. Total meters in system is calculated as sum of all individual meters assigned to the model
  2. Meter conditions are classified as: Normal (functioning properly), RCNT (recently flagged for attention), Faulty (requires repair/replacement)
  3. Condition counts must equal the total meters count for each model (Normal + RCNT + Faulty = Total)
  4. Individual meter age is calculated in months from installation date to current date
  5. Meter numbers must follow utility naming convention (e.g., "WM001234" for water meters)
  6. Device numbers are unique identifiers assigned during meter installation and cannot be duplicated
  7. Installation date cannot be future dated and must be in YYYY-MM-DD format
  8. Meter status (Active, RCNT, Faulty) can be updated individually but must align with model condition counts

Dashboard Metrics Rules:

  1. Total manufacturers count includes only manufacturers with at least one active meter model
  2. Total models count includes all created models regardless of active/inactive status
  3. Total meters count is the sum of all individual meters across all models in the system
  4. Average meters per model is calculated as total meters divided by total models, rounded to nearest whole number
  5. Growth indicators (+2 new this quarter, +3 added this month) are based on model creation dates
  6. Meter type breakdown (Smart, Photo, Manual) counts models, not individual meters
  7. Filter counts update dynamically based on applied search and filter criteria

Access and Security Rules:

  1. Only users with Meter Manager or Meter Supervisor roles can create or edit meter models
  2. Individual meter details can be viewed by Meter Readers and Field Technicians for operational purposes
  3. Bulk operations require Meter Manager role authorization
  4. Meter model deletion is restricted if any individual meters are assigned to the model
  5. Historical meter data must be preserved even when models are archived or deactivated
  6. All meter model changes must be logged with user identification and timestamp for audit purposes

Data Validation Rules:

  1. All mandatory fields must be completed before meter model can be saved
  2. Numeric fields must validate for appropriate data type and range constraints
  3. Dropdown selections must be from predefined valid options only
  4. Text fields must not contain special characters that could cause system issues
  5. Duplicate model names under the same manufacturer trigger validation error
  6. Technical specifications must be within realistic ranges for utility meters
  7. Smart meter configurations must pass compatibility validation before saving

8. Sample Data

Dashboard Metrics:

  • Total Manufacturers: 7
  • Total Models: 7
  • Total Meters: 7,890
  • Average Meters per Model: 1,127
  • Growth Indicators: +2 new this quarter, +3 added this month
  • Meter Type Distribution: Smart (3), Photo (2), Manual (2)

Meter Model Examples:

  1. Kamstrup MULTICAL 603
    • Type: Smart
    • Total Meters: 1,250
    • Conditions: Normal (1,180), RCNT (45), Faulty (25)
    • Utility: Water
    • Created by: John Smith on 2024-01-15
    • Status: Active
  2. Sensus iPERL
    • Type: Smart
    • Total Meters: 890
    • Conditions: Normal (850), RCNT (30), Faulty (10)
    • Utility: Water
    • Created by: Sarah Johnson on 2024-01-20
    • Status: Active
  3. Badger E-Series Ultrasonic
    • Type: Photo
    • Total Meters: 650
    • Conditions: Normal (600), RCNT (35), Faulty (15)
    • Utility: Water
    • Created by: Emily Davis on 2024-02-10
    • Status: Active

Technical Specifications Sample (E-Series Ultrasonic):

  • Manufacturer: Badger
  • Model Name: E-Series Ultrasonic
  • Make Code: KC603
  • Meter Type: Photo
  • Dial Length: 165 mm
  • Dial Count: 8
  • Max Flow: 3.5 m³/h
  • Connection Size: 3/4"
  • Weight: 1.2 kg
  • Accuracy: Class A (±2%)
  • Dimensions: 190 × 105 × 95 mm
  • Material: Brass body, polymer register
  • IP Rating: IP68

Individual Meter Records (E-Series Ultrasonic model):

  1. Meter No: WM001234, Device: DEV-KS-001234, Installed: 2023-01-15, Age: 28 months, Status: Active
  2. Meter No: WM001235, Device: DEV-KS-001235, Installed: 2023-01-20, Age: 28 months, Status: Active
  3. Meter No: WM001236, Device: DEV-KS-001236, Installed: 2023-02-01, Age: 28 months, Status: RCNT
  4. Meter No: WM001237, Device: DEV-KS-001237, Installed: 2023-02-10, Age: 27 months, Status: Active
  5. Meter No: WM001238, Device: DEV-KS-001238, Installed: 2023-02-15, Age: 27 months, Status: Faulty

9. Acceptance Criteria

  1. The system must display accurate dashboard metrics showing total manufacturers, models, meters, and average meters per model
  2. The system must provide visual categorization of meter models by type (Smart, Photo, Manual) with accurate counts
  3. The system must support creating new meter models with all required general information fields
  4. The system must validate that manufacturer and model name combinations are unique within the system
  5. The system must require at least one supported utility selection (Water, Electricity, Gas) for each model
  6. The system must capture comprehensive technical specifications including dimensions, flow rates, and materials
  7. The system must show Smart Meter Configuration section only when meter type is selected as Smart
  8. The system must validate that all numeric fields accept appropriate data types and ranges
  9. The system must automatically populate created by and created on fields with current user and timestamp
  10. The system must display real-time meter condition statistics (Normal, RCNT, Faulty) for each model
  11. The system must calculate individual meter age in months from installation date to current date
  12. The system must provide search functionality across manufacturer and model names
  13. The system must support filtering by meter type, manufacturer, and condition status
  14. The system must display individual meter details including device numbers, installation dates, and current status
  15. The system must prevent deletion of meter models that have assigned individual meters
  16. The system must maintain accurate condition count totals that equal the sum of Normal + RCNT + Faulty meters
  17. The system must support bulk operations for managing multiple meter records
  18. The system must log all meter model changes with user identification and timestamp for audit purposes
  19. The system must validate smart meter configurations for compatibility before saving
  20. The system must display growth indicators showing new manufacturers and models added by time period

10. Process Changes

Current Process

New Process

Impact

Manual entry of technical specifications for each individual meter added to system

Create standardized meter models once, then bulk assign meters based on pre-configured models

80% reduction in data entry time; elimination of specification inconsistencies

No visibility into meter inventory distribution across manufacturers and models

Comprehensive dashboard showing manufacturer, model, and condition analytics with real-time updates

100% visibility into fleet composition enabling data-driven procurement decisions

Reactive approach to meter replacement based on individual failure reports

Proactive replacement planning using condition analytics and age tracking across models

40% improvement in planned vs. reactive maintenance ratio

Limited ability to compare meter performance across different manufacturers

Detailed condition and performance tracking by manufacturer and model with comparative analytics

Enable vendor performance evaluation leading to 25% improvement in procurement ROI

Manual tracking of individual meter installation dates and lifecycle information

Automated age calculation and lifecycle tracking with condition monitoring integration

Complete meter asset lifecycle visibility reducing manual tracking effort by 90%

Inconsistent meter specifications leading to procurement and installation errors

Standardized technical specifications repository with validation rules

95% reduction in specification-related errors and installation issues

Time-consuming search for specific meter information across multiple systems

Unified search and filter capabilities across all meter models and individual units

70% reduction in time spent locating meter information

Limited insight into smart meter configuration and feature utilization

Comprehensive smart meter feature tracking with configuration management

Enable optimization of smart meter investments and feature utilization analysis

11. Impact from Solving This Problem

Metric

Improvement Impact

Data Entry Efficiency

80% reduction in time required to add new meters through standardized model templates

Specification Accuracy

95% reduction in meter specification errors through validated model configurations

Inventory Visibility

100% real-time visibility into meter distribution by manufacturer, model, and condition

Procurement Decision Quality

60% improvement in vendor selection decisions through comparative performance analytics

Maintenance Planning Efficiency

40% shift from reactive to proactive maintenance through condition trend analysis

Asset Lifecycle Management

90% reduction in manual tracking effort through automated age calculation and condition monitoring

Search and Information Access

70% reduction in time spent locating specific meter information through unified search capabilities

Compliance and Audit Readiness

100% audit trail capability with automated logging of all model changes and meter assignments

Smart Meter Optimization

50% improvement in smart meter feature utilization through configuration tracking and management

Overall Operational Efficiency

45% improvement in meter management processes through standardization and automation

12. User Behavior Tracking

Event

Properties

Metrics

Insights

Dashboard_View

user_id, session_duration, metrics_viewed

Dashboard access frequency, Time spent reviewing metrics

How frequently are managers monitoring inventory metrics?

Model_Create

user_id, manufacturer, meter_type, creation_duration, smart_features_enabled

Models created per period, Average creation time, Feature adoption rates

Which meter types and features are being standardized most?

Model_Search

search_term, results_count, selected_model, user_id

Search effectiveness, Common search patterns

How are users finding specific meter models?

Model_Filter

filter_type, filter_value, results_count, user_id

Filter usage patterns, Most common filter combinations

What criteria are most important for model selection?

Model_View

model_id, user_id, view_duration, sections_accessed

Model popularity, Detail consumption patterns

Which models are being reviewed most frequently?

Individual_Meter_Access

model_id, meter_count_viewed, condition_analysis, user_id

Individual meter tracking usage, Condition monitoring frequency

How deeply are managers analyzing individual meter performance?

Condition_Analysis

model_id, condition_type_focused, analysis_duration, user_id

Condition monitoring patterns, Alert response times

Which condition types receive the most attention?

Technical_Specs_Update

model_id, field_updated, old_value, new_value, user_id

Specification change frequency, Most updated fields

Which technical specifications require the most maintenance?

Smart_Config_Enable

model_id, feature_enabled, user_id, timestamp

Smart feature adoption, Configuration trends

Which smart meter features are being utilized most?

Bulk_Operations

operation_type, record_count, user_id, success_rate

Bulk operation usage, Efficiency gains

How effectively are bulk operations improving workflow efficiency?

Performance_Compare

models_compared, comparison_duration, decision_outcome, user_id

Comparative analysis usage, Decision patterns

Which models are being compared for procurement decisions?

Export_Data

export_type, model_selection, user_id, timestamp

Data export patterns, Reporting needs

What meter data is being shared outside the system?

Questions answered by tracking:

  1. What is the correlation between meter model standardization and reduction in data entry errors?
  2. Which manufacturers and meter types are preferred based on model creation and usage patterns?
  3. How effectively are managers using condition analytics to drive maintenance decisions?
  4. What is the adoption rate of smart meter features and which configurations are most valuable?
  5. How does inventory visibility impact procurement timing and vendor negotiation outcomes?
  6. Which technical specifications require the most updates and why?
  7. What is the relationship between model complexity and user adoption rates?
  8. How are bulk operations improving operational efficiency across different user roles?
Back to top