Romilos Restaurant Pedro Gonzalez Introduction Family owned ItalianGreek

Romilos Restaurant Pedro Gonzalez

Introduction Family owned Italian/Greek Restaurant is located in Severna Park, MD Robinson Crossing Shopping Center

Introduction Restaurant specializes in Mediterranean specialties Dine-In and Carryout restaurant The restaurant can seat roughly 200 people Employees totals to about 20 Established since 1994, by Kyriacos Kakoullis and Nick Monoshiotis

Introduction Employees (Severs-8, Hosts/Busser-4, Bartender-3, Cooks-4, Dishwasher-1) Attract many carryout customers Hours Sun-Thurs(11 a. m. -10 p. m. ) FRI-SAT (11 a. m. -11 p. m. )

Problem Customers orders were occasionally loss due to unorganized paper based system. There is no customer database to maximize efficiency. Customer database could establish a better customer connection (such as greeting by name or have previous orders stored) since they will be stored in the database. Currently inventory losses and inefficiencies are hurting the business. Losing inventory can cause many problems, one being loss in revenue, another could be decrease in customer service

Problem Financial reports are not accurate enough to truly gauge performance. Romilos staff and business partners (maintenance, shipping, etc. ) information is not filed in a way that can be found quickly. Sorting through paper files is a waste of valuable time. A database query would be much more efficient.

Requirements Analysis Romilos user request is summarized as following: Romilos needs to develop a structure that allows for a constant development of updates that will result in instantaneous flow of data and be able to produce invoices for the employees, store critical information, print receipts, and create reports. Romilos would like to be able to create customer information storage that will store addresses, e-mails, and phone numbers that will send coupons to customers' address and daily special deals though their e-mail. This will ultimately improve customer relationships and attract more business to the restaurant.

Business Process Flow The customer identifies the required information to contact Romilos. Customer finds further information regarding menu items by calling or coming into Romilos. Customer makes an order for dine-in or carryout. Romilos does not offer delivery. An employee at Romilos handwrites the order either through the phone or in-person. The order is prepared for the customer. The employee will then calculate the total cost for the customer by hand. Payment receipt is stored in customer file cabinets. Employees’ information, payroll information, and supplier’s contact information is put way in separate file cabinets. The sales report is generated by gathering the sales and different payments methods and manually entering in excel.

Proposed Feature RDBS featuring: Avoid the possibility of lost transactions by providing an organized way of processing customers’ orders Faster transactions from improved dataflow Maintain a customer database for improved customer relations Finical reports that are synchronized with the point of sales system that will provide managers an accurate way to gauge the company’s performance Provide the company with a way to keep track of inventory to cut down inventory loss Provide managers with a database of all the staff and business partners so that information can easily be found Management system that keeps track of employee’s information, schedules, and employee accounts payable

System Description Allow Employees at each level to have little to full access to improve business processes. Managers will be able to check the real time inventory levels of foods and beverages. Database will store employee information, payroll information, & supplier information Database will save customers’ order and suppliers’ order to keep track and generate reports when needed.

Economic Feasibility Tangible Benefits are: § An increase in productivity § Automated resource position § Real time delivery and food preparation update § Efficient way to create sales reports § Efficient way to create budget reports § Keeps Customers information for quick processing

Economic Feasibility Intangible Benefits are: § Competitive edge § Enhanced Accounts Management § Provides detailed overview § Enhance demand planning

Financial Summary Salaries/Wages table Project Manager $2, 500 Database architect $2, 400 Programmer $2, 400 Total Salary and Wages $7, 300 Operational Cost table (recurring cost) Hosting $1, 000 Maintenance* $3, 000 Electricity $1, 300 Internet Provider $310 Total Recurring costs $5, 610 Development table Salaries and Wages $7, 300 Design $3, 000 Training $200 Equipment $2, 300 Total Nonrecurring costs $12, 800 Benefits Increased Efficiency $18, 200 (50*7)* 52 weeks in a year Increased Customer $27, 300 ($75*7)*52 weeks in a year Paperless System $5, 000

Break Even Analysis

Payback Analysis

Project Plan

Organizational Feasibility The proper training is crucial for success System will handle day to day managerial routines and a customer ordering system instead of the traditional pen and paper Long-standing work procedures will not be totally reversed but will be processed faster with the new system Project timing and scheduling are reliant on a few milestones, which are: 1. the software for the database and POS 2. installation of wiring throughout the building 3. training employees and management 4. Implementation of system

Technical Analysis Actual Planning of the Database; A meeting with the owner going over alternatives. Meet Owners expectation. Compatibility issues Designated IT company would be needed for maintenance after implementation.

Recommendation In order for to keep their current market share, Romilos must: be competitive with bigger restaurant chains create more traffic for their restaurant Important for Romilos to adopt a sophisticated restaurant database system that would allow the employees and managers to provide a better customer service and simpler process flows According to the feasibility analysis, the RDBS is technically, operational, and economically feasible. The payment period of the project is over in one year, which is an acceptable time Based on the analysis provided, the project team recommends starting the database as soon as possible.