Reference no: EM133735221
System Development Methodologies
Case Study Analysis
Assessment Details
For this assessment, you are required to analyse, investigate and document system requirements for an ERP system in Auburn Winery Company (AWC). Based on your analysis of the case situation and using different modelling techniques, you will be required to produce a report that discusses the development of business information systems requirements for efficiency and cost effectiveness. This assessment will gauge the understanding based on the knowledge gained in the preceding weeks. You may make any assumption that you think is relevant to this project. The following tasks are mandatory requirements in your report.
Write a business case for an ERP system in AWC
Perform feasibility study, SWOT analysis and draw Mind Map
Identify and analyse Stakeholders.
Prepare Interview Questions and collect and Analyse Requirements in Agile Methodology.
Convert requirements into models including functional decomposition diagram (FDD), context diagram and data flow diagram (DFD).
Case Study Details
Auburn Winery Company (AWC) is a reputed wine manufacturing company based in South Australia. These are the operating entities within the Auburn Wine Company (AWC);
A head office in Adelaide housing the Finance/Accounting, Human Resources and Procurement divisions;
A glass bottle plant that makes bottles used by AWC to bottle its own wines and also sells bottles to other wine companies in Australia. It is located in Adelaide;
A large warehouse in Adelaide;
An office in Sydney housing the Sales and Marketing division;
3 wineries (located in the Barossa Valley, in Renmark and in Clare, all of which are in South Australia and within 200 km of Adelaide);
A restaurant in the Barossa Valley
Structurally the company has a Board of Directors comprised of a Chairman and 4 other Directors. The senior management of the company consists of the General Manager (CEO), the Chief Financial Officer (CFO), the Chief Information Officer (CIO) and the Heads of Marketing & Sales, Procurement (which includes production) and Human Resources. AWC has a workforce of more than 460 permanent staff and, in busy months it also employs 250- 300 casual workers. The IT department has a staff of 35 of whom all are University or TAFE IT graduates and four of the IT staff have had some direct experience working with SAP systems. The CIO previously worked for a company that implemented a SAP system and he held a senior managerial role during this implementation. Many of the accountants and engineers employed by AWC also have good IT skills that are relevant to their jobs.
The Current Information Systems
The Information Systems to support the companies are out of date. There is an integrated financial accounting system called DataAction that the company uses in its Adelaide headquarters but this system does not support marketing and sales. Raw materials inventory for the glass bottling plant is tracked through a Peartree Module that never got converted over to DataAction but the Vendor payments are handled through the accounting system. The Procurement division has a computer system that runs a proprietary SCM (Supply Chain Management) system that is not integrated to any other system. The Sales and Marketing office in Sydney also has a separate computer system that runs a proprietary logistics program that helps it with the shipping of wine to the overseas distribution centres and another application that is used to provide basic IT support for its sales and marketing activities. Each winery has its own network of PC connected through a server to the internet. Production data is stored on separate databases in each winery and this data is regular transmitted to the headquarters in Adelaide where it is consolidated into the company's main database. Production planning at each winery and inventory control is done largely on Excel spreadsheets. There is no automation for production and bottling operations. DataAction is also used for internal accounting, and billing and invoicing of customers. DataAction also is used to calculate payrolls and other worker entitlements. Its ability to handle international sales is very questionable.
Requirements of a New Information Systems
In short, the company wants an ERP system that can expand with the business and replace most, if not all the legacy systems currently in place. They also want a system that can grow and expand as the business grows and be up-to-date with information and communication technology (ICT). They want access to the system worldwide by all distribution centres and they want data about customers available to all centres throughout the world at any given time.
They want accurate currency conversion and the ability to meet external regulatory (legal) and reporting requirements. The company sees a big advantage in having the production and bottling operations integrated with sales so that accurate information about product availability is also accessible by all operating concerns. All company salespersons and representatives will be issued with iPhones and iPads and therefore an adequate mobile infrastructure is required.
AWC management wants to be able to take full advantage of all e-commerce possibilities to improve and expand their business. Their current website which is used to enable customers - usually low volume customers - to purchase their wine must be integrated into the new ERP system and expanded to allow up-to-date e-commerce including web auctions.
The Directors of the company have noted that wines are frequently a topic of conversation on Social Media. They are keen to incorporate tools within the new system that will enable the company to develop this potential market. They are also keen to apply advanced Business Intelligence technologies to drive the business.
Guidelines
Title Page - Clearly set out the title of your assessment, your name, your student ID, the unit name, the unit code and the name of the lecturer. There must be no graphics or pictures of any kind on the title page.
Executive Summary - Provide 'No more than one page' of summary.
Table of Contents - Auto-generated using the word processor.
Introduction - This section should introduce the general aims, backgrounds of the organisation, and areas/issues you will discuss in the report.
Body - Discuss your findings in detail, where appropriate, headings and sub-headings should be included with the logical progression of your report from one idea to the next.
Do not use the word 'Body' as a heading - identify words that relate to your report for the heading.
Body of your report should:
Write a business case for an ERP system in AWC
Perform feasibility study, SWOT analysis and draw Mind Map
Identify and analyse Stakeholders
Prepare Interview Questions, Collect and Analyse Requirements in Agile Methodology.
Convert requirements into models including functional decomposition diagram (FDD) and context diagram and data flow diagram. You have to draw functional decomposition diagram (FDD) for the entire ERP System. But you will draw context diagram and data flow diagram (DFD) only for one module. You may choose any module such as Sales and Marketing, Finance, HR, Payroll, Procurement and Inventory and Production Planning for your context diagram and DFD.
Conclusion - In this section, you need to summarise your work and findings. You should introduce no new points in your conclusion.
References - This is a list of all the books and articles you have cited in your assessment. Use APA referencing style for your in-text citations as well as your list of references.