Revenue Management Module

Automated revenue shares for thousands of third parties

Project Summary

Custom development of an revenue management module for as extension of an existing ERP system.

ClientLicence Trader
IndustryMedia
Project SetupFixed Price, Hybrid Development Mode
SkillsRequirements Management, Solution Design, Development Coordination
Project ManagementMichael Friedrich
Duration6 months

Project Details

  • Development of a revenue management module for the automatic distribution of licensor shares in complex revenue distribution models of the media industry.
  • Development for a major German license trading company.
  • Management of the project from Requirements Analysis to closure of Development Phase.
  • Hand over of development outcome for Go Live Phase.

Responsibilities during project phases

Phase 1

Requirements Analysis

Management of requirements coordination of all included stakeholders.

Collection of all standard and special cases for royalty calculation.

Phase 2

Solution Design

Specification of functional stories, steering of the estimation process with the development team, development of time schedules.

Phase 3

Development Coordination

Management of the development team, provisioning of iterations, management of quality assurance & end user tests, hand over for Go Live phase.

Challenges

  • Huge complexity of royalties due to minimum guarantees, location- and right-specific shares, deductible costs, cross-recoupments.
  • System must verify data quality provided by several departments and ensure data correction in case of data quality issues.
  • Processes must fit into the reporting cycles for Controlling and be synced with accounting and invoicing processes
  • Transformation of multi-currency revenues to accounting currency revenue shares

Solution

The solution included a fully custom development of an automated revenue management module based on the existing ERP system.

  • Automatic royalty share calculation for thousands of titles and third parties
  • Coverage of all cases of royalty shares including share dependencies, deductible costs, cross-recoupment
  • Securing of data consistence through Data Quality Checks and Data Quality Improvement Tasks
  • Interfaces for revenue shares to SAP and of exchange rates of banking system