# Decision Analysis System Modeling Using Spreadsheets Data Research Paper

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from Research Paper:

Decision Analysis System Modeling

"DATA DECISION ANALYSIS SYSTEM MODELING USING SPREADSHEETS"

"Data Decision Analysis System Modeling Using Spreadsheets."

Spreadsheet is one of the most popular software packages on the planet. Daily, million of business people, students and individuals use spreadsheet program to build models to assist in solving decision problems they face on their work activities. Thus, employers generally look for individuals having experience and skills with spreadsheets. Typically, spreadsheets assist in developing varieties of management techniques in modeling environment. More importantly, spreadsheets assist in developing models and make decision within a business environment.

Objective of this paper is to evaluate the use of spreadsheet in data and decision analysis in system modeling.

"Data and Decision Analysis in System Modeling Using Spreadsheets"

Within the last past few decades, million of business people have realized that the most effective method to analyze and evaluate data is to use an electronic spreadsheet. A spreadsheet package is computer software package used to design, analyze data and assist in making an effective decision. In a real accounting world, a spreadsheet is generally useful to show all the costs, taxes, income and other financial data for manager to analyze when making a decision. A spreadsheet is collection of cells that displays values on the computer screen. Typically, an electronic spreadsheet generally organizes data in rows and columns and a user can manipulate data using a formula such as average, sum or maximum. A spreadsheet package is appropriate for building a decision support system. Using a spreadsheet, a user could develop tables and charts from a large data set to assist a decision maker to choose an appropriate option from wide varieties of options. (Ragsdale, 2010).

On the other hand, a computer model is a set of logical assumption and mathematical relationships implemented with a computer to make decision. One of the benefits of electronic spreadsheet is to analyze decision problems using model. The electronic spreadsheet provides the most convenient and effective method to analyze computer models. Presently, most business people would probably rate electronic spreadsheet as the most effective analytical tool apart from using brain. Using a spreadsheet model, (a computer model developed from a spreadsheet), business professionals will be able to analyze alternative decisions and choose the best option for implementation. (Lin, & Nagalingam, 2000).

On the other hand, decision analysis is a systematic and logical way to address a wide variety of problem that involves a decision-making in an uncertain environment. However, making effective decision has become challenging because a business manager will need to collect large volume of data and analyze the data to arrive at an effective decision. Given the large volume of data to analyze to make a business decision, businesses often face a daunting task to analyze data manually. The electronic spreadsheet has become analytical and easy-to-use tool to analyze data to make business decision.

Using electronic spreadsheet, a business manager could develop a model in a less expensive method and this will assist a manager to evaluate the alternatives and choose the best from the alternatives. Using this strategy, a business will be able to avoid a costly mistake when making a business decision. Moreover, a model delivers information to make effective decision on timely basis. A model also assists business managers to examine things that would be impossible to examine in a real world basis. (Ragsdale, 2010).

More benefit derived from a spreadsheet is that it could assist a business manager to analyze data using mathematical and statistical tool readily available in a spreadsheet. Moreover, a spreadsheet assists in displaying data chart and graphs to assist in visual presentation of data analysis. Despite the importance of the spreadsheet to build model, many people are still using the manual method to create and analyze model. Moreover, spreadsheets assist business managers to achieve the following goals:

Reliability: The output that a spreadsheet generates is correct and consistent assisting a business manager to make an effective decision-making.

Auditability: A spreadsheet assists managers to generate different output from the model to verify and understand results.

Modifiability: A well-designed spreadsheet will assist a business manager to make decision in a dynamic environment.

This paper discusses the technique that could be employed to solve problem and making decision using model technique.

Problem-solving Technique using Model

This section discusses the problem solving process to enhance greater understanding on the strategy to employ from mathematical model to assist managers to make effective decision. The first step in the problem-solving process is to identify the problem. Identification of the problem is very critical to save time, effort and money. Identification of the problem involves gathering a lot of information and the strategy will assist in identifying the root cause of the problem.

The next step is to formulate the model that will assist in addressing the problem. However, the formulation of a spreadsheet model is the next, and this need to be implemented accurately to assist in a problem solving process. Thus, the next step is to use model itself to analyze problems to evaluate and generate the solutions. The spreadsheet is particularly useful in analyzing the mathematical model. Using the spreadsheet model, an organization will enjoy the following benefits:

First, a business manager will be able to use spreadsheet model to make a decision on a product mix for most manufacturing companies producing a variety of products. Production of each product will require certain amount of labor and raw materials. In these categories of product, the amount of profits a company will generate varies. Using the optimization model with spreadsheet, a manager of such manufacturing company will be able to make decision on how many of the product category should be manufactured at minimum costs to maximize profits as well as satisfying demand at minimum costs. (Lin, & Nagalingam, 2000).

A spreadsheet model will also assist manufacturer of printed circuit board to determine the drilling order that minimizes the total distance drill must move. It is essential to realize that drills have thousands of holes in them to accommodate various electrical components. To manufacture these drills, there is a need to program a computer to control the drill machine to save costs and time since the process involves the repeating hundred of thousands process to complete each drill. A mathematical optimization model using a spreadsheet will assist a manager to make effective decision on the method to assemble the drilling order to minimize the drill distance to save the drilling time and costs.

More importantly, a spreadsheet will assist a business manager to make decision on routing and logistics. Typically, many retail stores have warehouses around the country, and they are required to supply each warehouse with merchandise. Generally, there is a fluctuation on the amount of product in each store. Thus, the company will need to ship merchandise to each store and transport the merchandise from one location to the other. A business manager will be able to save large amount of money using the mathematical model to arrive at a least costly method to transport the goods from one location to the other. Using the spreadsheet tool, a business manager will be able to determine the shortest route to transport the goods from one location to the other. A company will be able to save time costs using this technique.

Additionally, spreadsheet could be used for financial planning. Typically, an electronic spreadsheet has become a convenient and excellent tool for financial and business planning. With inclusion of more powerful features such as financial, and statistical functions, which include Solver, Goal Seek, Solver, Pivot Table, and Data Table, spreadsheets are continuously being used for Monte-Carlo stimulation and optimization analysis to address a complex business challenges. More importantly, business managers are continuously using spreadsheet as their Enterprise Resource Planning (ERP)" system to make an informed decision.

This paper uses the capital budgeting example to show the method spreadsheet could assist a business manager to make business decision. Capital budgeting is an investment decision making that assists a business manager to make decision whether to pursue a project or not. (Evans, 2010). Using a hypothetical data, the paper has been able demonstrate how the spreadsheet could assist a business manager to make an investment decision. A company with initial investment of \$55,000 is intending to determine whether to investment…[continue]

## Cite This Research Paper:

"Decision Analysis System Modeling Using Spreadsheets Data" (2013, March 08) Retrieved October 25, 2016, from http://www.paperdue.com/essay/decision-analysis-system-modeling-using-86539

"Decision Analysis System Modeling Using Spreadsheets Data" 08 March 2013. Web.25 October. 2016. <http://www.paperdue.com/essay/decision-analysis-system-modeling-using-86539>

"Decision Analysis System Modeling Using Spreadsheets Data", 08 March 2013, Accessed.25 October. 2016, http://www.paperdue.com/essay/decision-analysis-system-modeling-using-86539

#### Other Documents Pertaining To This Topic

• ##### Decision Analysis System Computers Have Brought a

Decision Analysis System Computers have brought a great change in our lives. A software program called spreadsheet turns the computer screen into a paper sheet one is working on. This program saves time by reducing the errors and repetitions of calculations. It is commonly used in physics labs in order to save time by getting accurate results and accumulating proper data in labs. Spreadsheets have traditionally been used by accountants

• ##### Systems Media Table Comparison System Uses Word

Systems Media Table: Comparison System Uses Word processor The main purpose of this program is to construct sentences of the perceived information and manipulate paragraphs to form a word document. The program uses a display format 'what-you-see-is-what-you-get' to enhance the quality of the expected hardcopy. WordPerfect and Microsoft Word are mostly superseded by both organization and personal computers to perform functions such as word formatting, letter processing and some simple designing. Accordingly, it is the

• ##### Delphi Study Influence of Environmental Sustainability Initiatives...

Delphi Study: Influence of Environmental Sustainability Initiatives on Information Systems Table of Contents (first draft) Green IT Current Methods and Solutions Green IT and energy costs Green It and Email Systems Green IT and ICT Green IT and ESS Green IT and TPS Green IT and DSS Green IT and other support systems Green IT and GHG reduction Green IT and the Government Sector Green IT and the Corporate Sector Future Prospects of Green IT in the software industry The paper focuses on how the

• ##### NC System This Study Focuses on the

NC system This study focuses on the rise and significance STEP-NC as the most efficient model to transfer knowledge and communication on different CAD and CAM structures to improve the product design and overall project management. The paper will be divided into six chapters: 1) Introduction chapter which will include the statement of the problem, significance of the problem, purpose and scope of the study, the relevant definitions, the assumptions

• ##### Marketing and Information Systems

Role of Information Systems in Marketing The objective of this study is to examine the role of information systems in marketing in terms of the information that is necessary for decision making. Additionally this work will examine the role of IS for this function within the organization and the benefits of IS for the functional users at the operational level, the use of data at all levels of the organization and

• ##### City of Alexandria Time Series Data

City of Alexandria -- Time Series Data Tufte (2001) and other ambassadors of the visual display of data have shown us how easily it is to understand complex data when it is graphically represented in ways that our minds are designed to understand. Tufte argues that "experience with the analysis of data…is essential for achieving precision and grace in the presence of statistics, .but even textbook of graphical design are silent

• ##### Management and Decision Sciences From

76). As automation increasingly assumes the more mundane and routine aspects of work of all types, Drucker was visionary in his assessment of how decisions would be made in the years to come. "In the future," said Drucker, "it was possible that all employment would be managerial in nature, and we would then have progressed from a society of labor to a society of management" (Witzel, p. 76). The