Customer Billing Research Articles

Customer Churn Prediction in Telecommunication Industry. A Data Analysis Techniques Approach

Telecommunications is one of the most dynamic sectors in the market, where the customer base is an important pawn in receive safe revenues, so is important to focus attention is paid to maintaining them with an active status. Migrating customers from one network to another varies among telecommunication companies depending on different factors such as call quality, pricing plan, minute consumption, data, sms facilities, customer billing issues, etc. Determining an effective predictive model helps detect early warning signals when churn occurs and assigns to each customer a score called “churn score” that indicates the likelihood that the individual might migrate to another network over a predefined time period. To this extent, the present paper uses more than 10k customers sample of a telecommunication company and tries to analyse the churn behavior. The aim of the paper is both to test the efficiency and performance of the most commonly used data mining techniques to predict the churn behavior and to underline the main indicators that can be used when conducting such analyses. Knowing the magnitude of the churn phenomenon, the company can prevent the instability that is going to occur by applying a series of measure in order to increase the retention of the current customers.

Impact of Time-of-Use Demand Response Program on Optimal Operation of Afghanistan Real Power System

Like most developing countries, Afghanistan still employs the traditional philosophy of supplying all its load demands whenever they happen. However, to have a reliable and cost-effective system, the new approach proposes to keep the variations of demand at the lowest possible level. The power system infrastructure requires massive capital investment; demand response (DR) is one of the economic options for running the system according to the new scheme. DR has become the intention of many researchers in developed countries. However, very limited works have investigated the employment of appropriate DR programs for developing nations, particularly considering renewable energy sources (RESs). In this paper, as two-stage programming, the effect of the time-of-use demand response (TOU-DR) program on optimal operation of Afghanistan real power system in the presence of RESs and pumped hydropower storage (PHS) system in the day-ahead power market is analyzed. Using the concept of price elasticity, first, an economic model indicating the behaviour of customers involved in TOU-DR program is developed. A genetic algorithm (GA) coded in MATLAB software is used accordingly to schedule energy and reserve so that the total operation cost of the system is minimized. Two simulation cases are considered to verify the effectiveness of the suggested scheme. The first stage programming approach leads case 2 with TOU-DR program to 35 MW (811 MW − 776 MW), $16,235 ($528,825 − $512,590), and 64 MW reductions in the peak load, customer bill and peak to valley distance, respectively compared to case 1 without TOU-DR program. Also, the simulation results for stage 2 show that by employing the TOU-DR program, the system’s total cost can be reduced from $317,880 to $302,750, which indicates a significant reduction in thermal units’ operation cost, import power tariffs and reserve cost.

Analisa Pelanggaran Pemakaian Tenaga Listrik Pada Pelanggan Tegangan Menengah (20 kV) di PT. PLN (persero) UP3 Ternate

Theft of electricity is an activity that harms the country where PLN as a party that distributes electricity has unconsciously lost its main commodity without any reciprocity in the form of payments. To steal electricity is not as difficult as imagined by most people, only by attaching pln cables thieves can freely use electricity, especially if the thief knows the method used by PLN in detecting thieves will be careful in determining how much the shift in bills so as not to be sniffed. Violation of Class III P3 as many as 5 Pln Customer Customers Non-Customers get a Violation of Class IV P4 as much as 1 customer and follow-up bills given on violations of class P1 is a violation that affects the power limit fines given Rp. 59.400 violations of class P2 a violation that affects the energy limit fines given Rp. 2.372,020. violation of class P3 an offence that affects the power limit and is an offence affecting the energy limit the fine given Rp. 11.516,563. PLN Non-customer customers get a violation of class IV P4 fines given to the customer group as much as Rp. 5.348,206.

Analisa Pelanggaran Pemakaian Tenaga Listrik Pada Pelanggan Tegangan Menengah (20 kV) di PT. PLN (persero) UP3 Ternate

Theft of electricity is an activity that harms the country where PLN as a party that distributes electricity has unconsciously lost its main commodity without any reciprocity in the form of payments. To steal electricity is not as difficult as imagined by most people, only by attaching pln cables thieves can freely use electricity, especially if the thief knows the method used by PLN in detecting thieves will be careful in determining how much the shift in bills so as not to be sniffed. Violation of Class III P3 as many as 5 Pln Customer Customers Non-Customers get a Violation of Class IV P4 as much as 1 customer and follow-up bills given on violations of class P1 is a violation that affects the power limit fines given Rp. 59.400 violations of class P2 a violation that affects the energy limit fines given Rp. 2.372,020. violation of class P3 an offence that affects the power limit and is an offence affecting the energy limit the fine given Rp. 11.516,563. PLN Non-customer customers get a violation of class IV P4 fines given to the customer group as much as Rp. 5.348,206.

Parking Availability Indicating Application Using Smart QR Scanning

The vehicles are parked in parking lots. These parking lots are found in malls, offices etc. These parking slots are marked on the ground with different size based on vehicles. An Automated Parking System transports vehicles from the entrance to a parking space that is available. Prior to this, car owners must make a reservation for specific parking lot. It takes time for new members to register and have parking assigned to them. An automated parking allotting app is created as well as a hardware implementation for this project. The owner of a car parking lot may sign up and build a parking facility in his area by registering the location and installing a Raspberry Pi with camera, which will automatically update the available parking spaces. The user find available parking slots using app and book a special slot for his or her car. A QR code will be generated, and the customer's bill will be generated based on in-time and out-of-time scanning. This method would be able to save time for car owners as well as and the amount of labor needed to complete the process as a result of this. As a result, this project saves time while also automating the process.

Design and Implementation of Hotel Network Management Information System in the Era of Big Data

The huge growth of social media and consumer generated content on the Internet has inspired the development of so-called big data analysis to understand and solve real-life problems. However, although a few studies have used new data sources to solve the important research problems in the hotel industry, there is no systematic application of big data analysis technology in these studies. The purpose of this study is to explore and demonstrate the utility of big data analysis to better understand important hotel industry issues. The software is used to analyze the big data generated in the hotel reservation module, customer check module and customer bill module in the hotel management system. This paper discusses the dimensions of hotel service quality, evaluates its relative importance, and evaluates the service quality of Furtherance hotel from the perspective of guests. Through the analysis of academic research and hotel operators’ current practice, this paper sorts out and clarifies the problems related to online reviews. Taking advantage of the advantages of user reviews, this paper aims to provide new insights into the determinants of hotel customer satisfaction by distinguishing customers from different linguistic groups. The results show that the return on net assets is 34%, the return on total assets is 26%, the profit margin on sales is 16%, and the asset liability ratio is 21%.

The Velocity of Crisis: How the Pandemic Creates Opportunities for Change.

The Velocity of Crisis: How the Pandemic Creates Opportunities for Change.

PERANCANGAN SISTEM INFORMASI KUNJUNGAN SALES PADA PELANGGAN TOKO AMEERA

The right and appropriate information system is important in managing the company. Ameera Store is a company engaged in the distribution of baby products from various kinds of principles, marketing products on credit and cash to customers. Salesmen who work at the Ameera company have an important role in distributing a product to customers. In each order, the sales and admin records data twice. Customer data and visits can only be seen manually by sales. Therefore, it is necessary to process customer data, visit frequency, order goods and billing. Currently, there is no application for salesmen as reminders on every visit, this raises problems in the form of: frequent interchanges between bills and orders, so that visits are not on target and have an impact on reducing sales value and time effectiveness. Therefore, designing a sales visit information system becomes the basis for managing data. The method used is descriptive analytical method by means of interviews, observation and literature study. For the development of information systems applications using the waterfall methodology and modeling the business process information systems using Data Flow Diagrams (DFD). The research objective is to produce responsive web-based applications in the distribution process. The application of this system will greatly facilitate and benefit more parties, both sellers and buyers. One of the advantages for the seller or sales is that it is more time efficient because you don't have to go to the admin first to find out the schedule of visits that are adjusted to the status of the bill, whether the customer has made a payment or not. Thus, buyers also feel more helpful because sales visits are right on target. The meaning of right on target is a salesperson visiting because it's time for a bill and a new order is made by the customer or buyer.

A two-stage optimization framework for scheduling of responsive loads in smart distribution system

The implementation of demand response (DR) in distribution system extends several benefits to customers and distribution system operator (DSO) by altering the consumption pattern of responsive loads. However, the acceptability of any DR program is possible only if it can benefit both the stakeholders. Therefore, an appropriate strategy for scheduling of responsive loads is required to address the interest of both customers and DSO. In this regard, this study proposes a two-stage optimization method for scheduling of responsive loads in distribution system. In the first stage, scheduling of responsive loads is performed to minimize electricity cost of customers present in the distribution system. In the second stage, a multi-objective optimization is implemented to improve network’s reliability and economic benefit of DSO. The second stage objectives are to simultaneously minimize energy not supplied (ENS) and maximize profit of DSO. The second stage is implemented with constraint of customer cost obtained from first stage. The constraint imply that the customer bill should not exceed the payments obtained from stage one. The ∊-constraint method is adopted to solve the multi-objective problem of second stage and trade-off solution is obtained utilizing fuzzy satisfying technique. The proposed two-stage mechanism is implemented on 33-bus distribution system and a comparative analysis for different scenarios is presented to highlight the efficacy of proposed methodology. Results highlight that the proposed approach reduces customer’s electricity bill by 5.52%, ENS by 8.81% and increases profit of DSO by 9.89% respectively as compared to the scenario when DR is not considered.

Rancang Bangun Sistem Informasi Geografis Pelanggan Unit Jasa Pengelolaan Sampah pada BUMDesa Catu Krewo Sedana

Badan Usaha Milik Desa (BUMDesa) Catu Kwero Sedana is BUMDesa located in Pecatu village, South Kuta District, Badung-Bali Regency. The waste handling mechanism carried out by the waste management service unit at the BUMDesa Catu Kwero Sedana is the collection of garbage to residents' houses or businesses in the village of Pecatu. BUMDesa focuses on the quality of services provided to its customers. Until now there are still complaints from customers, especially new customers and prospective customers, related to the start of service and / or registration as new customers. The problem that often occurs is the difficulty of finding the location of garbage collection at the customer's site. If the customer registers himself through a contribution collector who is collecting customer bills, the employee in charge of transporting waste is sometimes constrained to find the customer's location. In addition, related to the amount of tariffs that will be charged to customers. Employees of garbage transport who do not know the size of the contribution rates of customers will find it difficult to provide the range of tariffs that will be charged to customers according to the rules stated in the regulations of Pecatu village. To overcome these problems, it is necessary to have a system that can provide information to employees of garbage transport regarding the position / location of garbage collection of each customer, the amount of tariff in accordance with applicable regulations, and recapitulation of payment of customer contributions. This information system can be developed based on websites with a geographic information system (GIS) model by utilizing the Application Programming Interface (API) maps owned by Google. The application of GIS to waste management has been extensively investigated and shows positive results

The impact and mitigation of ICMP based economic denial of sustainability attack in cloud computing environment using software defined network

High availability in network services is a crucial requirement for quality of experience. Denial of Service (DoS) and Distribute Denial of Service (DDoS) attacks are under contemplation by many researchers across the globe because these attacks directly target services availability. For this reason, cloud providers use the auto-scaling feature in Cloud Computing Environments (CCE), in which cloud resources scale dynamically on demand. DoS/DDoS attacks on CCE, using auto-scaling, do not deny services but cause high resource usage and substantial financial damages that become an Economic Denial of Sustainability (EDOS) attack. One of the DoS/DDoS attacks, resulting EDOS attack is the Internet Control Messaging Protocol (ICMP) flooding attack. In this paper, a novel technique, ICMP detection and mitigation model (EDOS-IDM) is proposed that can detect and mitigate Volumetric and Normal Behavioral ICMP traffic attacks. The results from the proposed technique are compared with the Normal Behavioral ICMP traffic attack because it causes least resource usage among all the mitigation techniques. According to our study, there is no such technique that can handle normal behavioral ICMP traffic attack. The technique is practically tested and evaluated on OpenStack production Cloud Environment test bed. According to the results, the technique is proved to save extra resource consumption and customer's bills in a cloud computing environment.

Cost-Reflective Residential Electricity Tariff Design: Synthesis of research findings on the impacts on customer bills, adoption of distributed energy resources and pollution

Cost-Reflective Residential Electricity Tariff Design: Synthesis of research findings on the impacts on customer bills, adoption of distributed energy resources and pollution

Corporate Communications Are Key to Success During a Pandemic.

Corporate Communications Are Key to Success During a Pandemic.

Magnitude and Distribution of Electricity and Water Subsidies for Households with Private Connections in Addis Ababa, Ethiopia

This paper presents the first detailed analysis of the combined effects of increasing block tariff (IBT) structures for both electricity and water in an urban area of a developing country. In Addis Ababa, an IBT has been used to calculate households’ monthly bills for electricity and water services. This study estimates the magnitude of combined water and electricity subsidies received by households with private connections to both the electricity grid and the piped network water in 2016, and it evaluates the distribution of these subsidies among wealth groups. Customer billing data supplied by utility companies are matched with socioeconomic information collected through a household survey. Results show that the combined subsidies are large. The average household receives a subsidy of USD 26 per month, about 6% of household income. The findings also show that both electricity and water subsidies under the IBT disproportionately accrue to richer households. The poorest quintile receives 12% of the total subsidies for electricity and water services, while the richest quintile receives 31%. The IBT used in the water sector performed worse in terms of targeting of subsidies to poor households than the IBT used in the electricity sector.

A techno-economic evaluation of the impact of electric vehicles diffusion on Italian customer billing tariffs

The sales of electric vehicles (EV) are recently experiencing an exponential growth. There is scientific evidence that EVs, in their lifecycle, generate a lower amount of greenhouse gases emissions and local pollution with respect to ICE ones. However, a fast EVs diffusion will increase the load on the power system in a still unclear manner. It is recognized that EV charging is a power intensive operation and that dumb charging strategies will increase security problems for grid management. This will likely happen at the end of business, when a huge quantity of EVs gets connected at the domestic socket at the same time, thus contributing to the ramp up needs from thermal generators to cope with the increasing slope in the “duck curve” at sunset. The presented model estimates the burden that different EV penetration scenarios will have on Italian power system in a short term (2025). This is evaluated in terms of energy flows and load profiles for the charging operations. A behavioural analysis of EV charging operations and a thorough investigation of Italian electricity tariff allows to calculate the economic impact of a base and a strategically regulated scenario. In the regulated scenario, featuring a regulatory toolbox to steer EVs diffusion efficiently, the impact on the power system is mitigated even in case of a larger EV penetration.

Minimization of Global Adjustment Charges for Large Electricity Customers Using Energy Storage—Canadian Market Case Study

Recently, the interest in utilizing energy storage systems (ESSs), particularly batteries, has increased. ESSs are employed for several enhancement tasks in power systems on both the operation and planning scales. On the operation side, ESSs play a main role in offering several ancillary services. In the context of planning, ESSs are used for asset upgrade deferral among other grid applications. This work employs a battery energy storage system (BESS) to minimize the electricity bill charges associated with global adjustment for large consumers in the jurisdiction of Ontario, Canada. An optimization formulation for sizing and scheduling the BESS, to minimize the utility charges and gain profits from other revenue streams, such as energy price arbitrage (EPA), was developed and implemented. The results show the economic feasibility of the developed algorithm to minimize the annual bills of real customers and gain profits. A sensitivity analysis was also carried out to show the potential of the proposed method in providing significant benefits and gains for customers.

Service quality dimensions of ride-sourcing services in Indian context

PurposeThis paper aims to identify the dimensions of service quality in the case of ride-sourcing services in Indian context.Design/methodology/approachThe service quality dimensions of ride-sourcing services are identified using an exploratory factor analysis (EFA). Further, the reliability and validity of the factors are established through confirmatory factor analysis (CFA) using AMOS.FindingsThe service quality dimensions of ride-sourcing services are identified: comfort, internal environment, safety and personnel, mobile convenience and reliability, mobile system efficiency and availability, mobile customer service and billing and mobile security and privacy.Research limitations/implicationsThe various dimensions are identified to measure service quality of ride-sourcing services in India. So, these dimensions can be tested for ride-sourcing services of countries having similar culture as India.Practical implicationsThe proposed dimensions can be used as a diagnostic tool to identify and compare important criteria for service quality of ride-sourcing services.Originality/valueMost relevant studies about dimensions of service quality for ride-sourcing services do not have stable factor structure. The dimensions identified include the traditional taxi service quality and mobile app service quality, which are not covered in current literature.

Benefits and costs of a utility-ownership business model for residential rooftop solar photovoltaics

The rapid growth of rooftop solar photovoltaic systems can pose a number of financial challenges for electric utility shareholders and their customers. One potential pathway to resolving these perceived challenges involves allowing utilities to own and operate rooftop solar systems. However, the financial benefits and costs of this business model are not well understood. Here we model the financial performance of a large-scale utility-owned residential rooftop solar programme. Over a 20 yr period, the programme increases shareholder earnings by 2–5% relative to a no-solar scenario, compared to a 2% earnings loss when an equivalent amount of rooftop solar is instead owned by non-utility parties. Such a programme could therefore be attractive from the perspective of utility investors. The impacts on utility customers, however, are more mixed, with average bills of non-solar customers increasing by 1–3% compared to the no-solar scenario, similar to the 2% increase under traditional, non-utility-ownership structures. Utility ownership of rooftop solar can potentially align utility financial interests with solar photovoltaic uptake, but the economic implications are not well understood. Now, G. Barbose and A. Satchwell evaluate the potential benefits of this model for utility shareholders and customers and show viability.

PERANCANGAN SISTEM INFORMASI PENJADWALAN KUNJUNGAN SALES PADA TOKO AMEERA

The right and appropriate information system is important in managing the company. Ameera Store is a company engaged in the distribution of baby products from various kinds of principles, marketing products on credit and cash to customers. Salesmen who work at the Ameera company have an important role in distributing a product to customers. In each order, the sales and admin records data twice. Customer data and visits can only be seen manually by sales. Therefore, it is necessary to process customer data, visit frequency, order goods and billing. Currently there is no application for salesmen to remind you of every scheduled visit, this raises problems in the form of: frequent interchanges between bills and orders, so that visits are not on target and have an impact on decreasing sales value and time effectiveness. Therefore, designing an information system for scheduling sales visits becomes the basis for managing data. The method used is descriptive analytical method by means of interviews, observation and literature study. For the development of information systems applications using the waterfall methodology and modeling the business process information systems using Data Flow Diagrams (DFD). The research objective is to produce responsive web-based applications in the distribution process. The application of this system will greatly facilitate and benefit more parties, both sellers and buyers

The Effects of Tip Recommendations on Customer Tipping, Satisfaction, Repatronage, and Spending

A field experiment involving 94,571 orders from 24,637 customers of an app-based laundry pick-up, cleaning, and delivery service examined the effects of various randomly assigned tip recommendations on consumers’ tip amounts, satisfaction ratings, frequency of return, and bill size. We find that tip recommendations affect tip amounts, but not customer satisfaction, patronage frequency, or bill size, which implies that neither the processes underlying the tip-recommendation effects on tipping nor consumer tipping itself affect these other consumer outcomes. From a practical perspective, these results and conclusions inform efforts to increase or decrease tipping. Recommending larger tip amounts, at least within the $2–$10 or 5%–25% ranges studied here, appears to be a safe means of increasing the amounts customers leave. More generally, altering customers’ tipping behavior will not itself adversely affect those customers’ subsequent satisfaction, repatronage, or spending, as long as the means used to alter tipping do not directly affect these other outcomes. This paper was accepted by John List, behavioral economics.