Comprehensive Information System Report: Dine Inn Restaurant Analysis

This report provides a comprehensive analysis of the information system needs of Dine Inn, a restaurant chain with multiple branches. It begins with an executive summary, technical background, and identification of the problem: the restaurant's reliance on traditional filing systems hindering efficient operations. The report proposes solutions using Management Information Systems (MIS), Decision Support Systems (DSS), and Online Analytical Processing (OLAP) to improve overall performance, data accessibility, and decision-making. It details the technical approach, objectives, statement of work, project tasks, schedule, estimated costs, and required equipment and software. The report also outlines the anticipated benefits, such as improved planning, coordination, and cost reduction, along with potential demerits like maintenance requirements and data dependency. The conclusion emphasizes the importance of adopting these information systems for enhanced business operations and the need for ongoing maintenance to ensure effective performance. The report references several books and journals to support its findings.

Information System

Table of Contents
Executive Summary.........................................................................................................................1
Technical Background.....................................................................................................................1
Identification of the Problem......................................................................................................1
Solution Overview of the problem..............................................................................................1
Technical Approach.........................................................................................................................2
Objectives....................................................................................................................................2
Statement of work.......................................................................................................................2
Project Tasks..........................................................................................................................2
Project Schedule.....................................................................................................................2
Estimated Costs......................................................................................................................2
Equipments Required.............................................................................................................2
Supported communication protocols...........................................................................................5
Structure of the Data layout Plan.....................................................................................................6
Anticipated Benefits of Proposed Work..........................................................................................7
Anticipated demerits of Proposed Work..........................................................................................8
CONCLUSION................................................................................................................................8
References........................................................................................................................................9
.........................................................................................................................................................9

Executive Summary
Information System is defined as a software that supports in organization, analysing and
interpretation of data. It is mainly used when a firm is having large amount of data and needs to
be organised in a proper way. It's aim is to convert raw data into useful information which helps
in decision making in an organization (Information system, 2020).
Dine Inn is a restaurant in South Australia operating since five years. It has three
branches in different states which are functioned by the same management. It is known for it's
good quality of product range and mainly checks on it's suppliers that they are supplying high
quality of raw materials before being used. The following discussions are made to support Dine
Inn with an Information system which provides the owner with operational consistency in all it's
branches, improvement of overall performance and optimization in business processes.
Technical Background
Identification of the Problem
The restaurant's business operations make use of traditional filing system which is not
sufficient to manage all the three branches. Only accounting/finance part is managed through MS
Excel. This management system slows down the overall business operations which results in lack
of consistency across all it's branches.
Solution Overview of the problem
So there are many operations which are highly needed by the restaurant to improve such
as overall business operations which includes all the departments of the firm, data arrangements
and accessible to all branches and decision making support. This showcases that currently
restaurant is not performing well because there is no such information system available with
the firm. That is why it is important and beneficial to undertake information system for an
organization.
1

Technical Approach
Objectives
The purpose is to identify type of information systems which can benefit Dine Inn in
those areas where they are lacking. Keeping in mind: all the requirements of hardware, software,
cost and ease in working.
Statement of work
Project Tasks
 MIS: Management Information System Software helps in improving overall performance
which automates and optimises business process.
 DSS: Decision Support System Software helps in decision making process in HR,
finance, supply chain and administration departments.
 OLAP: Online Analytical Processing Software helps in consistency across all branches
related to real time sharing of data and modifications (Bolstad, 2016).
Project Schedule
Each software consists heavy hardware and software requirements which somehow takes time
to set up. Installation process of these three software schedule consumes approximately 2-3 days.
Estimated Costs
MIS Software – Approx Rs.50,000 with license
DSS Software – Approx Rs.800 per user
OLAP Software – Approx Rs.1000 per month
Equipments Required
Hardware Requirements
Server Plans:
2

Minimum Pentium processor for Windows NT or Windows 2000 for AIX and Sun SPARC or
ULTRASPARC for Solaris Operating Environment.
HP PAVILION-RISC for HP-UX (not for OLAP Starter Kit)
AS/400 (V4R4, or Latest versions) Advanced RISC Server
RAM – more than 64 MB or equivalent
Disk space – Maximum 50 MB for the sample and server applications.
PC Client Plans:
Processor: – minimum Pentium processor for the application manager and spreadsheet add-in.
RAM: – minimum 16 MB for application manager and spreadsheet add-in – minimum 32 MB
on Windows 95, Windows 98, Windows NT 4.0 or Windows 2000 (Rainer, an et. al., (2020)).
Disk space: – 24 MB for Application Manager – 45 MB for the Integration Server desktop – 9
MB for Essbase Runtime Client – 16.7 MB for the Spreadsheet Add-in for Excel
Display – Resolution of minimum 640 x 480
API Client Plans:
Processor: –minimum Pentium processor for Windows 95 or 98, Windows NT, or Windows
2000 – RS/6000 for AIX – Sun SPARC or ULTRASPARC for Solaris Operating Environment
RAM: – 16 MB for Windows 95 or 98, Windows NT, or Windows 2000 – minimum 32 MB for
UNIX platforms
Disk space: – 6 MB for all UNIX platforms– 15 MB for 32-bit Essbase API on Windows 95,
Windows 98, Windows NT, or Windows 2000 – 45 MB for the Integration Server Desktop.
Server Plans for the OLAP Integration Server
Processor – minimum Pentium processor for Windows NT or Windows 2000 – Sun SPARC or
ULTRASPARC for Solaris Operating Environment – RS/6000 for AIX
RAM – 64 MB or more
Disk space – 50 MB for the Metadata Catalogue – 32 MB for the server and sample applications
Web Gateway
3

Processor – minimum Pentium for Windows NT or Windows 2000 – Sun SPARC or
ULTRASPARC for Solaris Operating Environment
Disk space– minimum 15 MB (Gholami, an et. al., (2016))
Objects
Processor – minimum Pentium
RAM – at least 32 MB
Disk space – 20 MB
Allocations Manager
Processor – minimum Pentium
RAM – al least 45 MB
Disk space – only for installation 25 MB
Display – Resolution of minimum 800 x 600
Software Requirements
Server Plans for the DataBase2 OLAP Server
Operating System – Windows 2000 or Windows NT 4.0 – AIX 4.3.3 or later – HP-UX 11.0
(not for OLAP Starter Kit) – Solaris Operating Environment 2.6 or 2.7 – OS/400 (V4R4 or later)
Communications – named pipes or TCP/IP
Workstation Client Plans
Operating system – at least Windows 95
Spreadsheet– Excel 97 or Excel 2000 – Lotus 1-2-3 Millennium R9 or R9.1 Communications –
For servers on Windows: TCP/IP or Named Pipes – For servers on UNIX: TCP/IP – For servers
on AS/400: APPC or TCP/IP
API Client Plans
Operating system – OS/390 Version 2 Release 5 or later – at least Windows 95 – AIX 4.3.3 or
later – HP-UX 11.0 – Solaris Operating Environment 2.6 or 2.7
Server Platforms for the DB2 OLAP Integration Server
Operating System – OS/390 Version 2 Release 5 or later – at least Windows NT 4.0 – AIX
4.3.3 or later – HP-UX 11.0 – Solaris Operating Environment 2.6 or 2.7
Communications: TCP/IP (Sanchez & Terlizzi, (2017))
4

Web Gateway
Operating system for the Web server: – Solaris operating Environment 2.6 or 2.7 – Windows
NT Server 4.0 or later
Communications – TCP/IP – Netscape Enterprise Server 3.0 or later -Web server qualified for
Solaris Operating Environment
Microsoft Merchant Server -Web server qualified for at least Windows NT – Netscape
Enterprise Server 3.0 or later – Microsoft Internet Information Server 3.0 for Windows NT or
later
Web browsers – Netscape 3.0 or later -Microsoft Internet Explorer 3.0 or later
Objects
Operating system – minimum Windows 95
Communications – named pipes or TCP/IP
Programming environment: – at least Microsoft Visual Basic 4 – Microsoft Visual C++
Web deployment – ActiveX compatible browser
Allocations Manager
Operating system – minimum Windows 95
Repository Manager – Oracle8 Client – DataBase2 Universal Database Version 6.1 or later
(Abdollahi, Eisenhardt & Chen, (2016))
5

Communication protocols requirements
Operating System Named Pipes TCP/IP Protocol
Windows New Technology
Advanced Interactive
Executive
Solaris Operating
Environment
HP-UX OS
Operating System/390
Structure of the Data layout Plan
6

7

Anticipated Benefits of Proposed Work
Benefits and improvements through Information Systems that Dine Inn can get after
adopting MIS, DSS and OLAP are:
 They facilitates planning
 They minimises information overload
 Encouragement of decentralization
 Encourages coordination
 Easier Control
 They gathers stores, process, retrieves, and disseminates the information
 Time Saving
 Enhances effectiveness
 Improves interpersonal communications
 Competitive advantage
 Cost reduction
 Increment of decision maker satisfactory
 Promotes learning
 Focuses on multidimensional data
 Focuses on calculations
 Flexibility, speed and self-service reporting (Abbasi, Sarker & Chiang, (2016))
Anticipated demerits of Proposed Work
 Sensitive which requires constant maintenance
 Difficult Budgeting
 Traits of outputs depends on status of inputs
 Assumption of relevance
 Transfer of power
8

 Great dependence on IT
 Risky to handle (Pearlson, Saunders, & Galletta, (2019))
CONCLUSION
It is concluded that Dine Inn can adopt these Information Systems for better and fast
performance in all it's three branches. This is an analysed detail report which includes problem,
solution, types of IS, hardware and software requirements, architecture and communication
layout of all IS, data needs, their merits and demerits. Through this, Dine Inn can expand it's
business because the operations can now be easy for the management. Now smooth functioning
can go on in the restaurant but at the same time maintenance is must of these IS software because
without updates they cannot work effectively. So restaurant needs to make sure that everything
could go well if they keep IS up to date.
References
Books and Journals
Abbasi, A., Sarker, S., & Chiang, R. H. (2016). Big data research in information systems:
Toward an inclusive research agenda. Journal of the Association for Information
Systems .17(2). 3.
Abdollahi, H., Eisenhardt, D., & Chen, L. (2016). U.S. Patent No. 9,292,084. Washington, DC:
U.S. Patent and Trademark Office.
Bolstad, P. (2016). GIS fundamentals: A first text on geographic information systems. Eider
(PressMinnesota).
Gholami, R., & et. al., (2016). Information systems solutions for environmental sustainability:
How can we do more?. Journal of the Association for Information Systems .17(8). 2.
Pearlson, K. E., Saunders, C. S., & Galletta, D. F. (2019). Managing and using information
systems: A strategic approach. John Wiley & Sons.
Rainer, R. K., & et. al., (2020). Introduction to information systems. John Wiley & Sons.
Sanchez, O. P., & Terlizzi, M. A. (2017). Cost and time project management success factors for
information systems development projects. International Journal of Project
Management.35(8). 1608-1626.
Online
Information system. 2020. Available through <https://www.britannica.com/topic/information-
system>./
9

10