SALES ANALYSIS OF PREPAID MOBILE RECHARGES
Shivangnee Sharma
Student, University of Petroleum & Energy Studies
Dehradun, India sharma.shivangnee@gmail.com Karanpal Singh
Student, University of Petroleum & Energy Studies
Dehradun, India palsinghk@gmail.com Abstract
Over a period of time, the power of analytics is helping in decision making for industries. Business potential of an industry can be accessed by the means of the data generated by the industry itself. Sales analysis reports are essential aspect for illustrating this power of analytics. The reports generated are of paramount importance to the industry for sustaining in the market.
This research paper is a discussion about an analysis done on a small retailer, linked …show more content…
With the evolution of mobile phones, there has
been a surprising up gradation in the field of network communications. Network Providing companies had enhanced their services and connectivity to larger extent. There are more than 13 network providers in India including Idea Cellular, Bharti Airtel, Vodafone, BSNL etc. [1]
Network provider, provide the facility for a customer to connect either on a postpaid or prepaid connection through a Subscriber Identification Module (SIM).
1.1 Postpaid Connections Vs Prepaid Connections
The word ‘post’ means after and ‘paid’ means payment, i.e. paying after using the network services whereas, the word ‘pre’ means before i.e. paying before using the network services. Postpaid connections are generally recommended for people with a secured income. There is no limit to use the mobile network services, if the customer exceeds the plan limit, then the bill on a monthly basis is generated accordingly, on the other hand, in a prepaid connection as the service is availed in advanced by the user for a limited period of time. If the time limit exceeds or the credit expires then the access to requested service is denied by the mobile network providers. Customer has the choice to top up their credit according to their usage to continue the services …show more content…
Monday(s), Tuesday(s) and Wednesday(s) as compared to the rest of the days. These figures are on a monthly basis. Also, on Monday(s) the sale is maximum the reason being as it is a starting day of a week.
Table 1: Sum of monthly sales with corresponding days
Days Monday Tuesday Wednesday Thursday Friday Saturday
Sales (in INR) 120797 119321 119549 94474 91515 25857
I.
6. Outcomes
• 37.57% students prefer Airtel as a network provider which means approximately 2500 students rely on this network provider. On interacting, majority of the students were from Uttar Pradesh, Delhi-NCR, Punjab and Madhya Pradesh. Plus on further investigating, these students prefer to commute via trains, and as per TRAI’s Quality of Service (QoS) report released in second quarter of 2012, Airtel offers coverage on approximately 95% of rail routes. [3]
• Within Airtel recharge pack of Rs.50 is mostly done. Considering the tariff plan chart for prepaid connection available on official site of Airtel, the top-up
Shivangnee Sharma
Student, University of Petroleum & Energy Studies
Dehradun, India sharma.shivangnee@gmail.com Karanpal Singh
Student, University of Petroleum & Energy Studies
Dehradun, India palsinghk@gmail.com Abstract
Over a period of time, the power of analytics is helping in decision making for industries. Business potential of an industry can be accessed by the means of the data generated by the industry itself. Sales analysis reports are essential aspect for illustrating this power of analytics. The reports generated are of paramount importance to the industry for sustaining in the market.
This research paper is a discussion about an analysis done on a small retailer, linked …show more content…
With the evolution of mobile phones, there has
been a surprising up gradation in the field of network communications. Network Providing companies had enhanced their services and connectivity to larger extent. There are more than 13 network providers in India including Idea Cellular, Bharti Airtel, Vodafone, BSNL etc. [1]
Network provider, provide the facility for a customer to connect either on a postpaid or prepaid connection through a Subscriber Identification Module (SIM).
1.1 Postpaid Connections Vs Prepaid Connections
The word ‘post’ means after and ‘paid’ means payment, i.e. paying after using the network services whereas, the word ‘pre’ means before i.e. paying before using the network services. Postpaid connections are generally recommended for people with a secured income. There is no limit to use the mobile network services, if the customer exceeds the plan limit, then the bill on a monthly basis is generated accordingly, on the other hand, in a prepaid connection as the service is availed in advanced by the user for a limited period of time. If the time limit exceeds or the credit expires then the access to requested service is denied by the mobile network providers. Customer has the choice to top up their credit according to their usage to continue the services …show more content…
Monday(s), Tuesday(s) and Wednesday(s) as compared to the rest of the days. These figures are on a monthly basis. Also, on Monday(s) the sale is maximum the reason being as it is a starting day of a week.
Table 1: Sum of monthly sales with corresponding days
Days Monday Tuesday Wednesday Thursday Friday Saturday
Sales (in INR) 120797 119321 119549 94474 91515 25857
I.
6. Outcomes
• 37.57% students prefer Airtel as a network provider which means approximately 2500 students rely on this network provider. On interacting, majority of the students were from Uttar Pradesh, Delhi-NCR, Punjab and Madhya Pradesh. Plus on further investigating, these students prefer to commute via trains, and as per TRAI’s Quality of Service (QoS) report released in second quarter of 2012, Airtel offers coverage on approximately 95% of rail routes. [3]
• Within Airtel recharge pack of Rs.50 is mostly done. Considering the tariff plan chart for prepaid connection available on official site of Airtel, the top-up