# Problem Solving & Spreadsheet Modeling

Better Essays
2313 Words
Grammar
Plagiarism
Writing
Score
Strayer university | Problem Solving & Spreadsheet Modeling | CIS331 | 12/16/2012 |

This paper talks about the problem solving process along with examples, as well as one of more commonly used modeling and analytical techniques, i.e. spreadsheet modeling. It also talks about its dependency, its uses, disadvantages and well as explores ways to better this very new, but powerful technique. |

Modeling is the process of creating a simpliﬁed representation of real life problems and representing them in an organized fashion in order to understand a particular problem. These models can take many forms such as mental, visual, mathematical or electronic spreadsheets to name a few. Their uses can be seen in almost every field of our daily lives such as businesses, governments, human resources, science and engineering, and medicine etc. Their primary function is to gain insight into a specific problem and after getting a clear understanding of the topic, one can easily approach it from different directions with possible solutions. This paper discusses this process in detail, starting with gaining insight into a specific problem by using a problem solving model, and then moves on to how it applies to spreadsheet modeling. It also discusses different aspects of electronic spreadsheet engineering, its uses and caveats, as well as its dependency in the business world these days.
Before creating any models, visual, mathematical or spreadsheets, one has to start with the problem solving process. The problem solving process consists of six stages that can be followed to solve almost any problem. These stages or steps are employed and are repeated multiple times, not necessarily in the same order, to obtain an efficient and refined solution to a particular problem.
The first of these stages is exploration of a “mess”. “A mess is a morass of unsettling symptoms, causes, data, pressures, shortfalls, and opportunities” (Baker & Powell, p.18). One of the key

References: Baker, Kenneth R.; Powell, Stephen G. (2010-10-08). Management Science: The Art of Modeling with Spreadsheets, 3rd Edition. John Wiley &amp; Sons, Inc. Kindle Edition. Garger, John. “The Advantages of Upgrading Your Business ' Software”. Bright Hub. Nov 8th, 2010. Accessed Dec. 12th, 2012. &lt;http://www.brighthub.com/computing/hardware/articles/43180.aspx&gt; Graves, Sherry. “The Importance Of Excel In The Workplace”. SparkNET. Sept. 10, 2007. Accessed on Dec.12th, 2012. &lt;http://ezinearticles.com/?The-Importance-Of-Excel-In-The-Workplace&amp;id=724646&gt;

## You May Also Find These Documents Helpful

• Good Essays

When dealing with large amounts of information that you will need to conduct business a spreadsheet may be an inferior choice. The choice of many users is to use spreadsheet applications when possible to store and house their data. This stems from the understanding of the systems. Most users understand the basic concepts behind spreadsheet applications and can manipulate their way through these systems with ease compared to using a database system. What many people don’t understand is how easy it is to retrieve their data later on if they would have used a database system.…

• 817 Words
• 4 Pages
Good Essays
• Good Essays

Although Microsoft Excel is an acceptable platform for business, there are disadvantages to the program. When developing Microsoft Excel into a file, depending on the size, program execution may…

• 745 Words
• 3 Pages
Good Essays
• Satisfactory Essays

An Excel system is very useful in the business world allowing many tasks to be overcome more effortlessly. One advantage is calculations enabling issues to be solved with few errors when dealing with placement of numbers and topic in there needed category; along with number placement there is also so many tools and formulas that make finding an answer so much easier, instead of inputting the mathematical calculations for hours on a piece of paper or entering a formula over and over again an excel system allows this process to be done all at once cutting down on redundancy and error.…

• 483 Words
• 2 Pages
Satisfactory Essays
• Better Essays

In this paper the writer will seek to respond to the questions designated for both scenarios. This paper will list typical fields for each type of data. Provide an example of two relationships that you need to track. This paper will also answer the questions of: Do you need a database system? If not, can Excel® handle the data and the output? What are the advantages and disadvantages? Would you use a personal database or an enterprise database? Explain your answer. Would a decision support system (DSS) be helpful? Explain your answer.…

• 1392 Words
• 6 Pages
Better Essays
• Better Essays

Sam and Sonia would like you to produce a spreadsheet model that would empower them to reserve product details and prices and when new products become available they can simply add them onto the list. They would also like the spreadsheet model to store customer details and enables them to form and print invoices for placed orders.…

• 2504 Words
• 8 Pages
Better Essays
• Good Essays

The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing…

• 355 Words
• 2 Pages
Good Essays
• Satisfactory Essays

References: Taylor III, Bernard W. (2011). Introduction to Management Science. Upper Saddle River, NJ: Prentice Hall…

• 328 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

Use a problem-solving process to identify a problem, gather information, list and consider options, consider advantages and disadvantages, choose and implement a solution, and evaluate the effectiveness of the solution.…

• 1720 Words
• 7 Pages
Satisfactory Essays
• Satisfactory Essays

The City of Highlands Ranch, Colorado, wishes to organize its campaign contributions records in a more strategic format. The city council is considering an executive information system that can show them overall views of the contribution information as well as give them the ability to access more detailed information. You have been hired to make recommendations about what reports should be available for the executive information system reporting.…

• 381 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

This paper is one of the last compulsory elements of the program Business Mathematics and Informatics at the VU University Amsterdam. The objective of this subject is to demonstrate the student 's ability to describe a problem in a clear manner for the benefit of an expert manager. This is accomplished by doing a literature research and to apply this research to a practical situation.…

• 15333 Words
• 62 Pages
Powerful Essays
• Good Essays

The fund-basis financial statements of Jefferson county have completed for the year 2012 and appear in the first tab of the excel spreadsheet provided with this exercise. The following information is also available:…

• 471 Words
• 2 Pages
Good Essays
• Powerful Essays

model: defining a problem, developing a model, developing a solution, testing the solution, analyzing the economic…

• 1947 Words
• 13 Pages
Powerful Essays
• Good Essays

I declare that this assignment is my individual work. I have not worked collaboratively nor have I copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person.…

• 2830 Words
• 14 Pages
Good Essays
• Good Essays

* It uses spreadsheet application where each elements or data values are distributed in cells.…

• 1013 Words
• 5 Pages
Good Essays
• Powerful Essays

Since 1940’s, computers have emerged and entered most fields of human activity as tools storage and processing of information. A computer is a data processing machine or, in other words a machine for the manipulate of symbols. These symbols represent information of various kinds like a number or a name. A computer is not an independent problem solver. However, the speed with which it can retrieve and manipulate large volume of data aid in problem solving process.…

• 3829 Words
• 16 Pages
Powerful Essays