Week 1 Case Study Professor Rene Ryman Case Problems – Chapter 1 – Question 1, parts a through d 1. A. How did Pine Valley Furniture go about developing its information systems? Why do you think the company chose this option? What other options were available? Pine Valley started small with the owner Alex Schuster just taking orders from customers for his custom furniture. Eventually each department had its own system, but they were still separate databases.
The system has evolved into an automated system supported by in-house information system staff. I feel the company chose this option because they wanted to have their own in-house IS staff to maintain their own system. They could have outsourced the creation and support of their current system but they see the value in being self sufficient. B. One option available to Pine Valley Furniture was an enterprise-wide system. What features does an enterprise-wide system, such as SAP, provide?
What is the primary advantage of an enterprise-wide system? An enterprise-wide system provides a single database as a repository for companies to centralize the management and availability of company data. The primary advantage of the enterprise-wide system is that it can be maintained at one location and supported from that location. The data is consistent and it costs less to support. C. Pine Valley Furniture will be hiring two systems analysts next month. Your task is to develop a job advertisement for these positions.
Locate several Web sites and/or newspapers that have job advertisements for systems analysts. What skills are required? Required skills for Systems Analysts: Must be able to make program modifications Must be able to consolidate multiple databases into one Must be able to train support staff on new system Stay abreast of compliance rules and regulations D. What types of information systems are currently utilized at Pine Valley Furniture? Provide an example of each. Two primary information systems used at Pine Valley Furniture are for accounting and financial.
As an example of each there would be a system for paying suppliers and contractors to run the furniture business. For all bills paid out of the general operating account a system needs to be in place to keep track of invoices, purchase orders and printing checks. Likewise a system is used to maintain payroll data. To pay the employees a system is needed to maintain hourly data and salary data. Along with whatever benefits are offered to employees. This system would keep all of the records, process the payroll and print payroll checks.