StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Solution to a Real World Problem - Assignment Example

Cite this document
Summary
Solution to a Real World Problem Instructor Institution Date Solution to a Real World Problem Problem Stated Formulation Investa Inc. is a company which offers financial services to both local and international investors. The company provides its clients with consultancy services on financial markets and various companies in which they would invest…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER95% of users find it useful
Solution to a Real World Problem
Read Text Preview

Extract of sample "Solution to a Real World Problem"

Solution to a Real World Problem Solution to a Real World Problem Problem d Formulation Investa Inc. isa company which offers financial services to both local and international investors. The company provides its clients with consultancy services on financial markets and various companies in which they would invest. The customer relations officer of the company has noted that there an increase in customer complaints about the effectiveness of the services of the help desk. An investigation by an outsourced group of IT specialists revealed that the application of relational or database oriented spreadsheets by the help desk staff has some limitations.

It is these limitations that have caused inefficiencies in the retrieval of financial information by the help desk staff as required by clients. The problem with the database model at the help desk has led to a recommendation by the IT specialists for a calculation oriented spreadsheet model. The arguments that the IT specialists and their recommendations have caused the need to determine the effectiveness of a calculation oriented spreadsheet to enhance informed decision making by the company executives.

Assumptions and Model Structures The application of database oriented spreadsheets at the help desk is assumed to be the major cause of the increasing complaints from the clients. Additionally, it is assumed that the investigation that the outsourced group of IT specialized way focused on the problem that the company was facing. Furthermore the recommendation for a calculation oriented spreadsheet is assumed not to be a complete replacement of the database oriented spreadsheets that are already in use at the company’s help desk.

This is because database oriented spreadsheets provides tools for effective management of a large number of variables (Fulford, 2009). In record management, variables are usually spread over large volumes and diverse records. In this regard database oriented databases are effective and commonly used in organizations for the retrieval and use of information (Caine & Robson, 2007). However, the company will also require a calculation oriented spreadsheet model because of the nature of information that the help desk staff are mandated to provide to the clients depending on requests.

The difference between the two model structures and their application within the company is assumed to be the cause of the problem which the company is facing. Analysis of Results Calculation oriented spreadsheet model requires fewer inputs in information retrieval (Fulford, 2009). This makes this model effective in increasing the efficiency in data retrieval by the help desk staff. The accuracy of calculation oriented spreadsheet model is improved by the cells that are dedicated to specific data (Caine & Robson, 2007).

Moreover, calculation oriented spreadsheet model eliminates errors in data update (Fulford, 2009). On the other hand, database oriented spreadsheet model has dedicated tabs which prevents confusion in dealing with many variables and large volumes of information (Caine & Robson, 2007). The analysis of these results show that Investa Inc. requires to adopt and implement a calculation oriented spreadsheet model within its help desk. This could promote the efficiency with which the help desk staff will retrieve and provide financial information to clients.

Additionally, the calculation oriented spreadsheet model will ensure that the information that clients are offered is free of error and updated. Nonetheless, the database oriented spreadsheet model is equally important for the organization. This is due to the fact that the company is rapidly growing and as a result the volume of information and the number of data retrieve variables in increasing. This means that the help desk staff requires this model of spreadsheets to effectively execute their duties.

Therefore accurate tradeoffs are required in coming up with a solution to the problem which the company is facing. For example the company will consider introducing a calculation oriented database for its benefits and implement it in customer in conjunction with the database oriented model. Conclusions and Interpretation of Solution In order to benefit from the advantages of both the database and calculation oriented spreadsheet models, it is recommended that the company implements the later and retains the former.

This means that both models of spreadsheets are to be installed to the computer systems at the help desk. In this sense, the help desk staff will be able employ these database models to improve the efficiency and accuracy with which customer care services are provided. The calculation based spreadsheet model will promote the speed and accuracy at which financial information is retrieved by the help desk staff. This will promote the provision of adequate, relevant and timely information to clients and as a result avoid complaints.

The retention of the database oriented spreadsheet model will help the help desk staff to manage large amount of information with efficiency and provide it to the clients as they require. References Caine, D. J., & Robson, A. J. (2007). Spreadsheet modelling: Guidelines for model development. Management Decision, 31(1), 38-38 Fulford, J. (2009). Designing spreadsheet models: Can you afford to be wrong? Accountancy Ireland, 29(5), 18-19

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Solution to a Real World Problem Assignment Example | Topics and Well Written Essays - 750 words”, n.d.)
Solution to a Real World Problem Assignment Example | Topics and Well Written Essays - 750 words. Retrieved from https://studentshare.org/information-technology/1454273-solution-to-a-real-world-problem
(Solution to a Real World Problem Assignment Example | Topics and Well Written Essays - 750 Words)
Solution to a Real World Problem Assignment Example | Topics and Well Written Essays - 750 Words. https://studentshare.org/information-technology/1454273-solution-to-a-real-world-problem.
“Solution to a Real World Problem Assignment Example | Topics and Well Written Essays - 750 Words”, n.d. https://studentshare.org/information-technology/1454273-solution-to-a-real-world-problem.
  • Cited: 0 times

CHECK THESE SAMPLES OF Solution to a Real World Problem

Statistics

Because there are 50 numbers, we can divide these numbers into groups of 10 (5 groups).... Next we subtract the lowest number from the highest number (76 — 16 = 60).... After this, we will divide the difference by the number of groups that we came up with (60 / 5 = 12).... hellip; Once we get the class width (12), we add it to the lowest number in order to get the lowest class limit (16 + 12 = 28)....
1 Pages (250 words) Math Problem

The Effects of Air Pollution

If you will delve more into the details pertaining to the start of this particular problem, you will find out that it has been taking place for thousands of years.... With an increase in the carbon dioxide, this problem is getting worse and it is thought that the start of the real problem was during the industrial revolution.... Knowing when the entire problem started is not as important as knowing more about its causes and impacts....
5 Pages (1250 words) Essay

Mathematics Assignment

… 1 m3 = 100 cm3 = 0.... 6 tonnesThen, divide both sides by 1010 Cubic cms = 0.... 86 tonnes(b) What volume of soil weighs 3 kg1 ton = 1000 kgThen,0.... 6 tonnes = 860 kg = 1 m3So,1 m3 = 860 kgMultiply both sides by 3/8603/860 m3 = (3*860) / 860 kg0.... 035 m3 = 3 kg14.... If 10 men take 3 days to complete a task(a) How long will it take 6 men to complete the task 10*3 = 6*x30/6 = x = 5(b) If the task is to be completed in two days how many men are required10*3 = x*2X = 30/2 = 1515....
4 Pages (1000 words) Math Problem

Cloud Computing Based Solutions for Letting Agency

This case study "Cloud Computing Based Solutions for Letting Agency" demonstrates a cloud-based solution to a company titled 'Letting Agency' that sells/purchases property.... This causes a problem that even the employees cannot access the system from any public network.... In order to solve the problem, the Agency decided to implement a web services solution based on distributed and cloud computing.... nbsp; In the world of computers, networking, and the internet, the utilization of resources (hardware, applications, and data) from diverse locations over the internet is becoming significant and the concept or technology is known to be as 'Cloud Computing'....
7 Pages (1750 words) Case Study

Negative Consequences of Air Pollution

Identify the problem.... Identify up to three issues related to this problem, and provide Harvard references for the texts you have found which discuss each issue (you may have one source which discusses multiple issues).... Identify two solutions which have been implemented in your chosen region in response to your identified problem, and provide Harvard references for the texts you have found which discuss each solution (you may have one source which discusses multiple solutions)....
4 Pages (1000 words) Outline

Improving the Success Rate of Third Grade Students in Solving Math Word Problems

The aim of the paper "Improving the Success Rate of Third Grade Students in Solving Math Word Problems" is to examine the purpose statement and on the basis of the provided background data provide own understanding and solution to before mentioned issue.... he students are not meeting grade-level expectations for mathematics word problem solving and the school is in need of implementing and enforcing new math word problem strategies to increase the achievement of students in this highly tested area....
9 Pages (2250 words) Assignment

Problems and Control of Air Pollution

This is not just a mere problem, but it includes more specific, detailed, and prompt responses to the future sustainability of the planet earth and its environment.... In addition, the problem of air pollution is getting worst.... Air pollution, therefore, is not just an ordinary issue or problem.... ust like any other form of environmental problem, air pollution has significant effects.... This report "Problems and Control of Air Pollution" discusses air pollution that is so pervasive in the modern world....
5 Pages (1250 words) Report

A Real Solution to the Immigration Problem

This term paper "a real Solution to the Immigration Problem" presents the subject of immigration and it will develop the study with the attempt to explain how immigration is a social problem.... ccording to Carl (45-52), immigration is a social problem because of how it creates tensions and misunderstandings in society.... Though this problem is more attributed to the failure of immigrants to assimilate and become part of the resident culture than their presence in the country....
16 Pages (4000 words) Term Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us