Cs507 Assignment No 4 Solution 2013 Nba

CS507 - Information Systems Assignment No. 2 Solution and Discussion Spring 2017 Due Date: May 27, 2017 

Assignment No.2

Graded

Semester Spring 2017
Information System– CS507

Total Marks: 20

Due Date:26/05/2017

Instructions:

Please read the following instructions carefully before solving & submitting assignment:

  1. 1.     The assignment will not be accepted after due date.
  2. 2.     Zero marks will be awarded to the assignment that does not open or the file is corrupt.
  3. 3.     The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.
  4. 4.     Don not send or attach Excel file.
  5. 5.     Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet).
  6. 6.     Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file.

For any query about the assignment, contact only at CS507@vu.edu.pk

Do not post queries related to assignment on MDB.

GOOD LUCK

Assignment Statement

 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.

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)

                                                                                                ___The end___

 

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.

0 thoughts on “Cs507 Assignment No 4 Solution 2013 Nba

Leave a Reply

Your email address will not be published. Required fields are marked *