If a department needed to update its data after submitting the spreadsheet to the main office, the analyst had to return the original spreadsheet and wait for the department to re-submit its data before finally submitting the updated data in the consolidated document. Question: Assess the impact of this situation on business performance and management decision making. Scenario 2 Simian’s Hardware is a mom-and-pop business in ABA Dhabi. Store space is limited and the rent has doubled over the past five years. The owners, Janis and Miriam, are ender pressure to use every square foot of space as profitably as possible.
The owners have never kept detailed records of stock in inventory or of their sales. As soon as a shipment of goods arrives, the items are immediately placed on store shelves to be sold. Invoices from suppliers are only kept for auditing purposes. When an item is sold, the item number and price are rung up on the cash register. Janis and Miriam use their own Judgment in identifying items that need to be reordered. Many times, however, they are caught short and lose a sale. Questions: What is the business impact of this situation? How could information systems help Janis and Miriam run their business? Data should these systems capture? What reports should the systems produce? What decisions could the systems improve? What Scenario 3 5 Marks (our turpitude company wants to create a data warehouse where management can Obtain a single corporate-wide view of critical sales information to identify best- selling products in specific geographic areas, key customers, and sales trends. Your sales and product information are stored in several different systems: a divisional ales system running on a UNIX server and a corporate sales system running on an IBM mainframe.
Arabic scented perfumes in comparison to stores in Dublin who have less Emirate customers. Also, stores in the I-JAKE might store more conservative clothing compared to stores in Europe. How could information systems help Paris Gallery management implement this new strategy? What pieces of data should these systems collect to help management make merchandising decisions that support this strategy? Scenario 5 Oasis Medical Supplies Corporation sells medical and surgical products and equipment from over 700 different manufacturers to hospitals, health clinics and medical offices.
The company employs 500 people at several locations across the AJAX, including account managers, customer service and support representatives, and Morehouse staff. Employees communicate via traditional telephone voice services, e- mail, instant messaging, and mobile phones. Management is enquiring about Nether the company should adopt a system for unified communications. What factors should be considered? What are the key decisions that have to be made in determining whether to adopt this technology? Use the web, if necessary to find out more about unified communication and its costs.