CS507 - Information Systems Assignment No. 2 Solution and Discussion Spring 2017 Due Date: May 27, 2017
Semester Spring 2017
Total Marks: 20
Please read the following instructions carefully before solving & submitting assignment:
For any query about the assignment, contact only at CS507@vu.edu.pk
Do not post queries related to assignment on MDB.
By using What-If Analysis tool in Excel, you can use several different sets of values in
one or more formulas to explore all the various results. What-If Analysis allows you to try out different values (scenarios) for formulas.
A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view different results.
Scenarios are managed with the Scenario Manager wizard from the What-If Analysis group on the Data tab.
Suppose you own a Computer store and have 200 computers in storage. You sell a certain % for the highest price of 1000Rs and a certain % for the lower price of 500Rs. If you sell 60% for the highest price, cell E11 calculates a total profit of 60 * 1000 + 40 * 500 = 160000.
What if you sell 70% for the highest price? And what if you sell 80% for the highest price? Or even 90%? Each different percentage is a different scenario.
Q No 1:
You are required to add 4 scenarios 60%, 70%, 80% and 90% by using Scenario Manager. After adding scenarios, take screenshot of the scenario manager and paste it here. (Marks = 10)
Q No 2:
Take screenshot of scenario summary showing all the scenarios that you have added to the scenario manager and paste it here. (Marks = 10)
http://vujannat.ning.com/ Best Website To Help Students OF VUhttp://vujannat.ning.com/ Best Website To Help Students OF VU
Question 1: What are the organization, management and technology dimensions of information systems? [3 marks]Answer:An information system represents a combination of management, organization, andtechnology elements. The management dimension of information system involvesleadership, strategy, and management behavior. The technology dimension consists of computer hardware, software, data management technology, andnetworking/telecommunication technology (including the internet). The Organizationdimension of information system involves the organization’s hierarchy, functionalspecialties, business processes, culture, political interest groups.Question 2: Describe some of the major changes that information systems are bringing toorganizations. [3 marks]Answer:The flattening of organizations is probably one that students will cite, particularly withthe concern over downsizing. The parallel increase in information and in the decisionpower of line workers (empowerment), and their corresponding increase in work satisfaction, is often missed in media reports of downsizing. The flexibility of organizations in operations, for example, custom manufacturing and in linking customersand suppliers (thus reducing order time) are some of the major changesQuestion 3: Describe the two factors that explain why organizations adopt informationsystems. [4 marks]Answer:• Customers now prefer to execute transaction in an electronic environment throughonline-trading. Also the establishment of customer services centers has also removed theinconvenience to access vendor’s physical locations.• Due to absence of physical contact, companies are curious to keep a soft touch in anefficient manner. This requires keeping a customer-wise online track of pastcorrespondence and transactions.