Objectives

The primary objective of this tender is to acquire a Tariff Modelling Tool that enables TCTA to efficiently and accurately calculate tariff receivables related to water infrastructure projects. The tool aims to replace manual, error-prone Excel templates, ensuring consistency, automation, and enhanced financial analysis capabilities for project cost recovery and debt management.

Scope

The scope of work includes the development or provision of a Tariff Modelling Solution that is compatible with TCTA’s existing systems and architecture. The solution should be cloud-based, on-premise, or SaaS, and must support the calculation of tariffs, interest income, present value, debt balances, and other financial metrics over a 20-year period. It should also facilitate scenario analysis, manual data uploads, and audit documentation. The project covers system implementation, integration, training, support, and maintenance.

Technical Requirements

• Solution architecture must specify operating system, database type (RDBMS or not), infrastructure prerequisites, backups, disaster recovery, and installation prerequisites.
• The system should support integration with TCTA’s systems such as Treasury Management, Financial Management, Supply Chain Management, and Human Capital Management via APIs.
• The solution must automate key calculations including tariff receivables, interest income, present value, debt balances, and short-term funding.
• Advanced financial functions such as scenario modelling, sensitivity analysis, and goal seek are required.
• The system should reduce manual effort by aligning with existing Excel models and logic, allowing for easy updates and customization.
• Support for uploading supporting documents and audit trails is necessary.
• Implementation should include all prerequisites, backups, disaster recovery strategies, and documentation.

Skills Requirements

• Proven experience in developing or implementing financial modelling solutions, particularly in tariff or project finance contexts.
• Technical expertise in system architecture, database management, and system integration, especially with Microsoft Windows Server environments and relevant APIs.
• Capability to provide training and comprehensive documentation to TCTA staff.
• Support and maintenance skills, including remote, telephonic, or on-site assistance, incident reporting, and software updates.
• Ability to customize the system to meet specific project requirements, including unique operational models like AMD operations.
• Understanding of financial principles related to debt management, interest calculations, and scenario analysis.