Analyzing a Potential Warranty Call Center Budget Overrun: Using Database Queries to Solve Business Problems

2005 ◽  
Vol 19 (1) ◽  
pp. 97-111 ◽  
Author(s):  
A. Faye Borthick ◽  
Donald R. Jones
Keyword(s):  
Call Center ◽  
Personal Computers ◽  
Database Queries ◽  
Transaction Data ◽  
Database Querying ◽  
Microsoft Access ◽  
Business Operations ◽  
Level Data ◽  
Warranty Service ◽  
A Company

In this case, students develop and use database queries to analyze possible causes of a potential budget overrun for telephone warranty service for a company that sells personal computers (PCs). Students query a Microsoft Access® database with tables for sales of PCs, estimates for technician time, employees, technician costs, and service minutes provided. The queries illustrate those that accountants could prepare to analyze transaction-level data to develop insights about business operations. Query-based approaches to analyzing transaction data are likely to become more common as businesses take advantage of the wealth of data available to them for solving business problems and exploiting emerging opportunities. This case is appropriate for students with rudimentary database querying proficiency, e.g., at the level developed by Borthick et al.'s (2001) case on assuring compliance for responses to website referrals.

Creating a Business Process Diagram and Database Queries to Detect Billing Errors and Analyze Calling Patterns for Cell Phone Service

2007 ◽  
Vol 21 (1) ◽  
pp. 107-122 ◽  
Author(s):  
A. Faye Borthick ◽  
Donald R. Jones
Keyword(s):  
Business Process ◽  
Cell Phone ◽  
Accounting Systems ◽  
Database Queries ◽  
Database Querying ◽  
Microsoft Access ◽  
Business Operations ◽  
Level Data ◽  
Trading Partners ◽  
Phone Service

In this case, students develop a business process diagram to understand the business situation and create database queries to detect billing discrepancies and manage costs for corporate cell phone service. Using a database query tool or audit software, students query a database with tables for call details, invoices, invoice details, plan rates, and users on plan. The queries are representative of those that accountants could develop to analyze transaction-level data to detect errors and develop insights about business operations. Query-based approaches to analyzing transaction data can enable businesses to make sense of their operations and ensure that they and their trading partners comply with their mutual agreements. The case is appropriate for students with rudimentary database querying proficiency, e.g., at the level developed by Borthick et al.'s (2001) case on assuring compliance for responses to website referrals. No auditing expertise is needed. The case is appropriate for database analysis in accounting systems courses, compliance auditing in auditing courses, and cost analysis in managerial courses. The database is supplied in the form of a Microsoft Access® database.

scholarly journals PERANCANGAN SISTEM INFORMASI DATABASE PEMBELIAN DAN PENJUALAN PRODUK PADA SHAVIRA PANCAKE BANDA ACEH

2020 ◽  
Vol 5 (2) ◽  
pp. 193-199
Author(s):  
Furqaan Putra ◽  
Rudy Fachruddin
Keyword(s):  
Data Collection ◽  
Qualitative Method ◽  
Application System ◽  
Transaction Data ◽  
Microsoft Access ◽  
Long Time ◽  
Speed Up ◽  
Manual Recording ◽  
A Company ◽  
Banda Aceh

Purchase and sales are things which often heard in a company. The use of manual recording results in a number of problems in the company. Seeing the results of purchases, sales and transaction data manually would take a long time. This study aims to design a database of purchases and sales information systems to help employees manage purchase and sale transactions easier, therefore reducing errors and speed up the proccess of transaction calculations. The system designed in this study uses Microsoft Access. This study uses descriptive qualitative method, data collection techniques was done by conducting interviews, observations, and literature studies carried out directly with the owner of the company. This study produces an application system that would ease future corporate activities.

What's Happening to Profits at Cazenovia Creations?

2013 ◽  
Vol 8 (1) ◽  
pp. 24-29 ◽  
Author(s):  
Margaret Garnsey ◽  
Andrea Hotaling
Keyword(s):  
Financial Analysis ◽  
Financial Statements ◽  
Internal Controls ◽  
Net Income ◽  
Database Query ◽  
Microsoft Access ◽  
Level Data ◽  
Query Tool ◽  
Transaction Level

ABSTRACT In this case, students assume the role of an accounting professional asked by a client to investigate why net income is not as strong as expected. The students must first analyze a set of financial statements to identify areas of possible concern. After determining the areas to investigate, the students use a database query tool to see if they can determine causes by examining transaction level data. Finally, the students are asked to professionally communicate their findings and recommendations to their client. The case provides students with experience in using query-based approaches to answering business questions. It is appropriate for students with basic query and financial analysis skills and knowledge of internal controls. A Microsoft Access database with transaction details for the final seven months of the current year as well as financial statements for the current and prior year are provided.

scholarly journals A procedure for the introduction of leanness into a company

2021 ◽  
Author(s):  
Davorin Cimermančič ◽  
Janez Kušar ◽  
Tomaž Berlec
Keyword(s):  
Negative Impact ◽  
General Procedure ◽  
Portfolio Analysis ◽  
The Other ◽  
Business Operations ◽  
Step Procedure ◽  
The One ◽  
A Company

AbstractChanging a traditional company into a lean one is a very complex and time-consuming process that needs to be addressed in an appropriate way, otherwise the project of introduction of leanness into a company may fail on the one hand and even have a negative impact on business operations of the company on the other. When introducing a change, a step-by-step procedure leading to a progress may be of great help. The paper outlines a general procedure of leanness, an important part of which is a lean agent. A portfolio analysis is also used as a measure of leanness or as an indicator of the desired direction. The applied working methods were mainly active workshops and interviews with employees. The procedure has been tested on an example of a Slovene company; first, the existing situation is outlined, then the leanness steps taken according to the procedure and the final result after the first transition of the procedure.

Knowledge Sharing in Project Environments

2021 ◽  
Vol 12 (1) ◽  
pp. 1-17
Author(s):  
Zinga Novais ◽  
Jorge Vareda Gomes ◽  
Mário José Batista Romão
Keyword(s):  
Project Management ◽  
Knowledge Sharing ◽  
Project Managers ◽  
Project Team ◽  
Team Members ◽  
Business Operations ◽  
Successful Execution ◽  
Management Project ◽  
A Company

Projects have been increasingly used in the implementation of organizations' business operations. Knowledge sharing has been considered essential in project environment; therefore, the integration of knowledge management within project management becomes crucial for project success. The objective of this research is to study how knowledge sharing is integrated within the context of a project, and what is the perception of project team members about it. A case study was carried out in a company within the financial sector, focused on a project team of the entity. The results revealed that project managers, other professionals in project management, and the organization itself are very much aware of the importance of knowledge sharing. The results also emphasized that, regardless of the lack of incentives by top management, project team members consider that knowledge sharing highly contributes for a successful execution of projects.

scholarly journals Using the Mathematical Model on Precision Marketing with Online Transaction Data Computing

2021 ◽  
Vol 2021 ◽  
pp. 1-7
Author(s):  
Jun Wu ◽  
Li Shi ◽  
Guangshu Xu ◽  
Yu-Hsi Yuan ◽  
Sang-Bing Tsai ◽  
...  
Keyword(s):  
Mathematical Model ◽  
Performance Comparison ◽  
Marketing Strategies ◽  
Transaction Data ◽  
Recommendation Algorithms ◽  
Decision Making System ◽  
Data Source ◽  
The Mathematical Model ◽  
A Company ◽  
Real World Problems

In this paper, a decision-making system for precision marketing is presented to deal with real-world problems based on real e-business data collected in a company in Beijing. During the data preprocessing, the authors conducted a cleaning course to make sure the data to be analyzed in the latter part of the paper were credential. Based on the processed data, the authors analyzed consumer purchasing behaviors using three classic recommendation algorithms and made a performance comparison of the three algorithms. At the end of this paper, the authors proposed a series of precision marketing strategies which had been adopted by the data source company and had been proved to be effective in improving the performance.

scholarly journals Impacts of Location on Bank Call Center Services: The Case of Turkey

2012 ◽  
Vol 7 (2) ◽  
pp. 77-88 ◽  
Author(s):  
Ahmet Hakan Özkan
Keyword(s):  
Service Quality ◽  
Call Center ◽  
Call Centers ◽  
Stress Factors ◽  
Large Cities ◽  
Service Companies ◽  
Stress Levels ◽  
A Company ◽  
Practical Implications

Abstract Purpose - The CRM sector represents the quality of a company. The quality of a company might be evaluated by taking the services of a call center as a measure by the customers, because CRM is the most interactive point of the operations of all companies. Call centers represent companies with 24/7 service. Companies have to search for ways to increase the quality of their service and CRM. Call center companies started to move to Anatolia in response to government incentives. The purpose of this study was to examine the results of this change. Design/methodology/approach - Bank call centers in large cities and Anatolian bank call centers are compared. SERVQUAL is used to compare the service quality of the call centers. 100 questionnaires are used to evaluate the services of the bank call centers and 100 customers are interviewed. The banks with Anatolian call centers and the banks without Anatolian call centers are compared to each other by using the results of the interviews and questionnaires. Findings - The service quality of the call center of the banks with Anatolian call centers seems to be higher than those without them. Practical implications - The reason for the better performance of Anatolian bank call centers can be explained by using some observations. These reasons can be taken into account by CRM companies to provide better service. Originality/value - This paper is proof of that CRM agents are affected by stress factors and their environment. Therefore, stress levels have to be decreased for employees for better service. Selecting a good location is the most important step in diminishing stress levels.

scholarly journals Implementasi Perencanaan Strategis SI/TI Pada PT. Prima Teknologi

2021 ◽  
Vol 3 (2) ◽  
pp. 352-264
Author(s):  
Rahmad Firdaus ◽  
Januar Al Amien
Keyword(s):  
Project Management ◽  
Business Strategy ◽  
Management Strategy ◽  
Study Data ◽  
It Management ◽  
Business Operations ◽  
Strategic Goals ◽  
It Application ◽  
The Impact ◽  
A Company

The use of IS / IT in a company is one of the keys to success in achieving the company's vision, mission and goals. PT. XYZ is a company that has not fully implemented the use of IS / IT to help its business operations, namely in terms of business project management. As time goes by, the impact of the use of IS / IT has not been implemented yet, it is evidenced by the number of project works that experience delays within a certain period of time. In this study, data were obtained from observations, interviews and analysis of company documents. This research refers to the Ward and Peppard method. The results of this study are in the form of a blueprint or description of business strategy, IS / IT management strategy and IT application to achieve corporate strategic goals.

scholarly journals Customer segmentation using bisecting k-means algorithm based on recency, frequency, and monetary (RFM) model

2019 ◽  
Vol 8 (2) ◽  
pp. 78-83
Author(s):  
Novianti Puspitasari ◽  
Joan Angelina Widians ◽  
Noval Bayu Setiawan
Keyword(s):  
Customer Loyalty ◽  
Customer Segmentation ◽  
Number Of Clusters ◽  
Transaction Data ◽  
Model Based ◽  
Silhouette Coefficient ◽  
Rfm Model ◽  
A Company ◽  
Coefficient Method

Information on customer loyalty characteristics in a company is needed to improve service to customers. A customer segmentation model based on transaction data can provide this information. This study used parameters from the recency, frequency, and monetary (RFM) model in determining customer segmentation and bisecting k-means algorithm to determine the number of clusters. The dataset used 588 sales transactions for PT Dinar Energi Utama in 2017. The clusters formed by the bisecting k-means and k-means algorithm were tested using the silhouette coefficient method. The bisecting k-means algorithm can form the best customer segmentation into three groups, namely Occasional, Typical, and Gold, with a silhouette coefficient of 0.58132.

Sign in / Sign up

Export Citation Format

Share Document