-Siddhartha Pilla

Project Title:

Identify and optimize ways to improve the overall revenue across products and regions was signed on the 24th of January 2023


The purpose of the project is to identify and optimize ways to improve the overall revenue across products and regions. Also, to provide with necessary day to day metrics to monitor and take data-based decisions at the depot level.

1. Project and Data Description

The initial sample data set provided consisted of two versions: Cumulative data at service level and Individual Ticket sales data from TIM machines. Data was collected through TIM (Ticket Issuing Machine) and was periodically synced with the server after completion of service (i.e. bus/product leaving from origin point, reach destination and come back to the origin).  

The data sample was collected over a span of one month (June 2022), including customer wise ticket data including current stop, destination stop, transaction value, type of ticket, bus, travel and other bus/journey related markers.

2. Current Analysis/Methodology and next course of action 

 The team tried to demonstrate the metrics to identify the non-profitable services by creating an adjacency matrix of individual services to the finest level. We establish and study the relationship between these metrics and profitability at various levels/cuts of the data. Next, we identify/create break-even points for these metrics using cost data for decision making at multiple levels. We provide them with an action matrix to identify the gaps and suggested course of action. The next step in the project is to collect data across regions for a longer time span from the organization to build a better model.

3. Interaction with the organization

During the course of the project, the TSRTC team has interacted with the research teams via virtual interactions (zoom calls), TSRTC team location visits (Head-office, Bus depots) and field visits. Monthly interactions are scheduled to update the client regarding the progress and take feedback on the progress. TSRTC team has shown interest to provide us with more data to carry further analysis and provide them with a more elaborate solution.