You as the Systems Analyst have practiced analyzing business cases and will now produce documentation that may lead to a viable project. You will
also be asked to start the process of transforming those business requirements into more detailed system requirements, describe what the new
system must do to provide the needed value to the business.
This assignment is considered a “Business Case.” An outline is provided to help get you started. You can search online and refer to Chapter 1 for
additional details and appropriate ROI formulas or costs. You may create additional details or constraints to define your work.
Review the scenario presented. You will be as asked to analyze the situation, develop a proposed system solution, perform an analysis based on
the information presented, and develop a method to gather more information to validate your requirements.
Assignment Instructions and Requirements
Mystic Brewery is a local start-up company formed by two brothers and partners, Jake and Pete. Each has their own brewing equipment and they
have recently purchased a small building that was once a car sales/body shop to combine their previous disparate businesses into one
microbrewery. They have converted part of the back-mechanic area into a brewing station and the front sales and reception desk into a small
taproom. There is no food service. There is ample space inside that can be used for expanded capacity or growth. The space includes access to a
fenced back car lot accessible by garage doors that they hope to convert into an outdoor entertainment area.
Each brother has previously worked inventory, sales, and costs on his own. They have different styles and personalities. Jake likes experimental
and higher ABV beers and has invested in a small capacity canning line hoping to expand their capacity to distribute to local restaurants.
Pete is more practical and down to earth, preferring a classic American lager; he’s recently invested in a meat smoker and hopes to expand the
back-car lot to include family friendly entertainment…potentially with food service. Pete thinks that the company would benefit from growlers and
refills of their beers.
They currently have no Internet connection. There are two computers with Windows 7 and Microsoft Office. Emails have been accessed via cell
phone. Inventory and sales receipts are hand-written on old-fashioned paper forms with carbon copy, and the data is entered later into an Excel file
on one of the computers in each store every night. At the end of every night, the Excel file is copied onto a flash drive and transferred to the second
store computer as backup.
They need a real database, updated operating systems, inventory and supply tracking, and potentially a Point of Sale/credit card processing system.
There is currently no web or social media presence. All business has been generated through word of mouth and previous clients.
What they do have is a high-quality beer and a passion for growth.
Keep in mind that your clients are not particularly technically minded; avoid highly technical jargon and be direct with all statements and questions.
Documentation and Paper Process
You are writing a descriptive paper. Use the outline provided to get you started. The process steps are described in the paragraphs below; make
sure you address each element. You are free to add additional appendices or information as needed. Remember this is a preliminary proposal! You
will be developing a method to further gather additional requirements to determine the feasibility study. Your content must be organized as explained
below and all parts of the assignment must be written in your own words. Please refer to the assignment requirements, which includes a title and
reference page as well as formatting specifications in APA style.
Paragraph 1: Give more detail to articulate the problem.
Paragraph 2: Propose at least two potential types of information system solutions to solve the problem.
They may be similar but must have at least one component that is different – and you must identify what kind of Information System or Systems you
Executive Information Systems (ESS)
Decision Support Systems (DSS)
Management Information Systems (MIS)
Transaction Processing Systems (TPS)
Artificial Intelligence and Expert Systems
Cost-Benefit Analysis/ROI (for BOTH alternatives)
Provide one-time purchase costs (hardware and/or software), including quantity, brands, and dollar amounts.
Provide ongoing costs (services), including vendor and dollar amount per month or year.
Include the direct URL for any cost listed.
Paragraph: Explain your ROI findings in paragraph form.
HINT: It is important to explore alternatives to help in decision making. You will want to provide cost benefit analysis for BOTH possible alternatives.
Paragraph: Choose a solution! Write a paragraph that is meant to convince the client that your solution is in his/her best interests.
Explain how project success will be measured (this must be more than simply stating the project is complete). How will be validated?
Write a statement explaining of both the tangible and intangible benefits of the project.
Provide an approximate timeline for the project, including and at least three discreet milestones that measure progress.