Analyzing Data for Decision Making: Integrating Spreadsheet Modeling and Database Querying

2016 ◽  
Vol 32 (1) ◽  
pp. 59-66 ◽  
Author(s):  
A. Faye Borthick ◽  
Gary P. Schneider ◽  
Therese R. Viscelli
Keyword(s):  
Decision Making ◽  
Database Systems ◽  
Managerial Accounting ◽  
Database Query ◽  
Accounting Systems ◽  
Credit Score ◽  
Database Querying ◽  
Business Objective ◽  
Data Tables ◽  
Query Expressions

ABSTRACT Although students begin with a spreadsheet to analyze the effect of a change in credit score cutoff on loan performance on sales, they discover that this approach becomes unwieldy as the analysis becomes more complex. As more attributes from more sheets are required, the spreadsheet solution becomes difficult to implement or audit. The case thus motivates students to develop the database skills of importing the spreadsheet data into a database manager, joining tables, and performing the analysis using database querying. The case requires students to think critically to model the business situation in spreadsheet formulas and database query expressions, structure relationships among the attributes across data tables, and manipulate attributes to achieve the business objective. The case is suitable for courses in accounting systems, managerial accounting, decision making, and database systems. Objective questions are provided for assessing students' ability to analyze transaction records using both spreadsheet and database tools.

scholarly journals Cognitive pathways in small businesses decision-making processes

2020 ◽  
Vol 17 (1) ◽  
pp. 350-359
Author(s):  
Carmela Rizza
Keyword(s):  
Decision Making ◽  
Small Businesses ◽  
Crucial Role ◽  
Small Firms ◽  
Balance Sheet ◽  
Managerial Accounting ◽  
Accounting Systems ◽  
Making Sense ◽  
Decision Making Processes ◽  
Limited Diffusion

Research on small firms decision-making processes has stimulated accounting scholars to investigate how peculiarities of these firms could affect the way how they are managed, focusing on the limited diffusion of managerial accounting practices in these contexts. Controversial results on how managerial accounting practices work in small firms, claim for further research that mostly focus on how managerial accounting systems work in the decision-making processes of small firms. In this view, adopting a sociological perspective managerial accounting practices are interpreted as tools for making sense of past decisions and to discover future alternatives through cognitive pathways. Thus, the attention is on learning processes activated through balance sheet analysis in a small firm that was implementing this tool. The main contribution of this paper concerns the crucial role that balance sheet analyses play in supporting the organizational actors to monitor the state of the company and the decision-making processes. The discussion of balance sheet analyses results enabled the owner and his staff to appraise the current situation and pinpoint weaknesses, allowing them to analyse past events with a new lens and activating new knowledge pathways. Case evidence supports theoretical contributions to the decision-making processes of small businesses helping to better understand how managerial accounting practices work to discover future alternatives through cognitive pathways. The paper provides also a practical contribution concerning the crucial role that balance sheet analyses play in small firms.

scholarly journals The use of fuzzy databases and knowledge bases for aiding engineering projects

2013 ◽  
Vol 12 (1) ◽  
pp. 069-076
Author(s):  
Janusz Szelka ◽  
Zbigniew Wrona
Keyword(s):  
Decision Making ◽  
Database Systems ◽  
Knowledge Bases ◽  
Fuzzy Data ◽  
Fuzzy Knowledge Bases ◽  
Decision Making Processes ◽  
Engineering Projects ◽  
Fuzzy Knowledge

The IT tools that are widely used for aiding information and decision-making tasks in engineering activities include classic database systems, and in the case of problems with poorly-recognised structure – systems with knowledge bases. The uniqueness of these categories of systems allows, however, neither to represent the approximate or imprecise nature of available data or knowledge nor to process fuzzy data. Since so far there have been no solutions related to the use of fuzzy databases or fuzzy knowledge bases in engineering projects, it seems necessary to make an attempt to assess the possible employment of these technologies to aid analytical and decision-making processes.

scholarly journals Implementation of management accounting in the system of economic monitoring of activities in the context of globalization

2020 ◽  
Vol 7 (12) ◽  
pp. 97-104
Author(s):  
Д. В. Адамов ◽  
М. А. Юхненко ◽  
Є. Р. Богдяж
Keyword(s):  
Balanced Scorecard ◽  
Management Accounting ◽  
Evolutionary Development ◽  
Accounting System ◽  
Managerial Accounting ◽  
Accounting Systems ◽  
Accounting Information Systems ◽  
The Balanced Scorecard ◽  
Independent Analysis ◽  
Legislative Framework

The article deals with the problems that arise during the implementation of the concept of modern management accounting for Ukrainian enterprises by introducing new accounting systems and developing approaches to accounting and information generalization of transaction costs in order to effectively manage them in the globalized economy. The existing system of introduction of management accounting at enterprises is examined and the introduction of management accounting on foreign examples is considered, namely the balanced system of indicators, which is already actively used abroad and is just beginning its development in Ukraine. The research of this topic is related to the change of accounting information systems in modern conditions and the need to create a global accounting system, and adjustments are made to management accounting functions. The article compares and defines the distinctive features of accounting, and its composition of financial, tax and management accounting. A clear algorithm for the construction of this system at the enterprise and indicators that must be calculated for a complete and independent analysis of the work of the enterprise are distinguished and described. The ambiguous interpretation of the concept of managerial accounting in the course of its evolutionary development has led to the study of this topic. The article presents a system of metrics that are calculated within the Balanced Scorecard system used by the enterprise. The problems of implementing a balanced scorecard based on the experience of corporations already using the system are also discussed. The lack of legal and legislative framework to stimulate and encourage the introduction of this concept into the practice of management accounting in Ukraine leads to the unsatisfactory functioning of this system. According to the results of the research, the recommendations on the introduction of management accounting in the system of economic monitoring of activity in the conditions of globalization are given.

The Limitations of Financial Reporting on Innovation and Its Value-Relevance for the Investor's Decision-Making Process

2019 ◽  
pp. 390-418
Author(s):  
Francisco Leote ◽  
Ana Damião
Keyword(s):  
Decision Making ◽  
Financial Reporting ◽  
Value Relevance ◽  
Financial Statements ◽  
Individual Characteristics ◽  
Decision Making Process ◽  
Accounting Systems ◽  
Financial Factors ◽  
The Individual ◽  
Industry Sectors

This chapter aims to present some limitations of financial reporting on innovation with an impact on the investor's decision-making process. In order to do so, the authors show how accounting recognizes and measures innovation factors: the intangibles. Based on the literature, the authors discuss how the value relevance of financial reporting on innovation is conditioned by non-financial factors. The impacts of the adoption of IFRSs, the effect of the industry sectors and the effect of the individual characteristics of the different countries on the value relevance of the intangible assets are analyzed. The literature suggests a decrease in the value relevance of financial statements due to the manner in which intangibles are recognized and measured in accounting. However, financial reporting on innovation is value relevant to the investor's decision-making and is conditioned by non-financial factors. Value relevance differs among different industry sectors, between different countries and is conditioned by the accounting systems used in the preparation of the financial information.

suits of operations. The ordres were linked together either by double-entry or by the use of contra-accounts. The plan's double­ entry systems were as follows [CNOF, 1946]: Financial accounting Ordre 1 — Operating accounts (revenues and expenses) (accounting elements seen as causes) Ordre 2 — Balance sheet accounts (assets and liabilities) (effect of transactions on the company's position) Managerial accounting Ordre 3 — Cost accounts and sales accounts (transactions classified as to purpose) Ordre 4 — Imputation or contra-accounts Budgetary accounting Ordre 5 — Budgeted operations Ordre 6 — Budgeted liquidities Ordre 7 and 8 were left open, in case other accounting systems were developed in the future. Ordre 9 was devoted to commit­ ments and transitory accounts, such as purchases and sales in cash, and internal transfers. In financial statements, transitory ac­ counts were to be replaced by the ordre to which they were related (1 or 2), and commitments were to be listed at the end of the balance sheet. Each ordre was further divided into categories, each having its own specific meaning. For example, the categories found in ordre 1 were charges and revenues that are included in the gross profit margin, operating charges and revenues, investment-related charges and revenues, administrative charges, miscellaneous rev­ enues and financial charges. These categories were further grouped to provide the following summary accounts: the gross profit margin, results of operations, net revenue from investments, net administrative charges and financial charges. The classifica­ tion adopted in that ordre was based first on the economic func­ tion of the transactions and second on their nature. Another ex­ ample of the breakdown of an ordre into categories is provided by ordre 2. In the latter, assets were divided, according to their eco­ nomic function in the company and their degree of liquidity, into fixed assets, investments, short-term assets (inventories and short­ term investments), receivables and liquid assets (cash and cash equivalents). Ordre 3 and 4 were devoted to cost accounting, constituting a 287

2014 ◽  
pp. 343-343
Keyword(s):  
Balance Sheet ◽  
Financial Statements ◽  
Profit Margin ◽  
Financial Accounting ◽  
Managerial Accounting ◽  
Accounting Systems ◽  
Fixed Assets ◽  
Net Revenue ◽  
Specific Meaning ◽  
Double Entry

scholarly journals The Effect of the Change in the Balance Sheet Law in 2014-2018 on Management of Companies in Poland

2019 ◽  
Vol 10 (4) ◽  
pp. 14
Author(s):  
Jolanta Chluska
Keyword(s):  
Decision Making ◽  
Financial Reporting ◽  
Balance Sheet ◽  
Accounting System ◽  
Accounting Systems ◽  
Economic Decisions ◽  
Accounting Principles ◽  
Decision Making Processes ◽  
Business Entities ◽  
Internal Accounting

Polish business entities operate based on accounting principles in accordance with the Accounting Act and the accounting policy established by the directors of the entities. Changes in the balance sheet law have a significant effect on the internal accounting principles applied in companies. In the last three years, Polish accounting regulations have been adapted to the solutions used in the European Union.The aim of the paper is to analyse information aspects of accounting, including financial reporting in Poland in the decision-making processes of internal recipients, taking into account the changes in legal regulations.The research method was the analysis of the literature and legal acts, and a practical example.Changes in legislation influence the accounting policies defined by the managers of business entities. Companies can simplify their accounting principles including those concerning reporting. However, the simplifications should not adversely affect the economic decisions of the entity's manager and the recipients of the financial statements.The lack of accurate financial data from the accounting system may adversely affect the decision-making of the unit's manager in management processes. As it results from the analysis of the literature of the subject and the accounting systems of small enterprises, financial information from accounting is necessary for effective business management. Therefore, managers apply simplifications in accounting quite carefully.

Design and Implementation of the Universal Database Query Middleware Based on Web Services

2013 ◽  
Vol 411-414 ◽  
pp. 572-575
Author(s):  
Gang Ding ◽  
Hong Min Nie ◽  
Ying Zhe Liu
Keyword(s):  
Web Services ◽  
Integration Method ◽  
Database Systems ◽  
Database Integration ◽  
Query Interface ◽  
Database Query ◽  
Database Access ◽  
Design And Implementation ◽  
Data Source ◽  
The Difference

Nowadays, a variety of database systems coexist and the application softwares access and operation for database is often custom-written, which can lead to more complicated cross-database access. Through analysis of the operational process of the database middleware, adding the generic database query middleware eQueryMW which can shield the difference of the data source to the traditional three-tier architecture as the middleware level can realize the access of relational heterogeneity database, providing a unified database query interface and cross-database integration method for the users.

Heterogeneous placement optimization for database query processing

2017 ◽  
Vol 59 (3) ◽  
Author(s):  
Tomas Karnagel ◽  
Dirk Habich
Keyword(s):  
Query Processing ◽  
Database Systems ◽  
Improve Performance ◽  
Database Query ◽  
Placement Decisions ◽  
Placement Optimization ◽  
Database Query Processing ◽  
The Given

AbstractComputing hardware is constantly evolving and database systems need to adapt to ongoing hardware changes to improve performance. The current hardware trend is heterogeneity, where multiple computing units like CPUs and GPUs are used together in one system. In this paper, we summarize our efforts to use hardware heterogeneity efficiently for query processing. We discuss different approaches of execution and investigate heterogeneous placement in detail by showing, how to automatically determine operator placement decisions according to the given hardware environment and query properties.

SYSTEMIC CONDITIONS OF EFFICIENCY AND DURABILITY OF ROAD TRANSPORT ENTERPRISES

2018 ◽  
Vol 73 ◽  
pp. 69-78
Author(s):  
Andrzej Letkiewicz ◽  
Michał Suchanek
Keyword(s):  
Decision Making ◽  
Road Transport ◽  
Management Systems ◽  
Accounting Systems ◽  
Record Keeping ◽  
Input And Output ◽  
Decision Making System ◽  
Decision Making Processes ◽  
Formal Strategy ◽  
Basic Input

The basic condition for the proper configuration of inputs and outputs in a transport company is the ability to optimise, build, and implement a strategy based on carefully selected components of the information and decision-making system, capable of taking into account the different optimisation criteria for each level and of gathering and generating information useful in the process of developing a strategy. Within this system, IT tools that increase the efficiency of the technical dimension of decision-making processes are useful. For Polish road transport companies, economically speaking, the basic input and output record-keeping systems are accounting systems, used by nearly 89% of the surveyed entities. In the operational context, 58% of the entities declare using resource management systems. Nearly 18% of the companies possess a formal strategy.

Sign in / Sign up

Export Citation Format

Share Document