PART A Question 1: [10 marks] Discuss how MIS can be used in the following functional areas to provide competitive advantage, 1. Human Resource Section 2. Finance Section 3. Supply chain section, and 4. Manufacturing section Question 2: [10 marks] Discuss the different choices of software accusation for a business organization. Also discuss the pros and cons of each of them 2 Question 3: [10 marks] A super market chain wants to find out which of the following items are bought by customers in combination with the other products. The transaction details are provided in table 1. Provide answer to them assuming minimum support = 60% and minimum confidence = 80%. Transaction Id Items 1 2 3 4 5 Bread, Milk Bread, Diaper, Ginger Beer, Eggs Milk, Diaper, Coke, Ginger Beer Bread, Milk, Diaper, Ginger Beer Bread, Milk, Diaper, Coke Table 1 Question 4: [10 marks] A company wants to profile its customer into two groups based on number of orders and total cost. The customer data is shown in table 2. Group the customers based on K-means clustering algorithm. Consider k=2. Question 5: Question 6: Customer A B C D Demand Order Small Medium Large 3 Number of Orders 10 20 40 50 50 42 34 Table 2 [10 marks] Discuss the components of DSS with the help of a diagram and briefly explain each of the components Total cost [10 marks] A grocer wants to solve a problem of how much pastry to order every day. His profit depend on the demand that can be low, moderate or high. Values of profit per day (in BND) for those situations are as shown in the table. The probability of the demands are also provided. Help the grocer to make a decision. Low (0.3 probability) Moderate (0.5 probability) $100 $100 $300 $400 50 52 44 High (0.2 probability) 50 WH 52 54 Question 7: a) Explain the role of a feasibility study within MIS developments. b) List eight ways to gain competitive advantage for a business organization. [10 marks] (2 marks) (8 marks) [10 marks] Why are organizations trying to integrate their business processes? What are the four key enterprise applications for organization-wide process integration? Question 8: 4 PART B Case study: Information System for Kimball's Restaurant in Brunei A waiter takes an order at a table, and then enters it online via one of the six terminals located in the restaurant dining room. The order is routed to a printer in the appropriate preparation area: the cold. item printer if it is a salad, the hot-item printer if it is a hot sandwich etc. A customer's meal check- listing (bill) the items ordered and the respective prices are automatically generated. This ordering system eliminates the old three carbon-copy guest check system as well as any problems caused by a waiter's handwriting. When the kitchen runs out of a food item, the cooks send out an 'out of stock' message, which will be displayed on the dining room terminals when waiters try to order that item. This gives the waiters faster feedback, enabling them to give better service to the customers. Other system features aid management in the planning and control of their restaurant business. The system provides up-to-the- minute information on the food items ordered and breaks out percentages showing sales of each item versus total sales. This helps management plan menus according to customers' tastes. The system also compares the weekly sales totals versus food costs, allowing planning for tighter cost controls. In addition, whenever an order is voided, the reasons for the void are keyed in. This may help later in management decisions, especially if the voids consistently related to food or service. Acceptance of the system by the users is exceptionally high since the waiters and waitresses were involved in the selection and design process. All potential users were asked to give their impressions and ideas about the various systems available before one was chosen. Question: Discuss in detail what would make the system a more complete MIS rather than just doing transaction processing. [20 marks]