Transcript IRP Presentation - ECpE Senior Design

Project May07-14: Restaurant Automation
April 24, 2007
Project Team Information

Client
–

Team:
–
–
–
–
–

Senior Design
Chris Ford
Sean McVeigh (Project Manager)
Obioma Ohia
Nichole Taylor
Anthony VanSant
Advisor:
–
Dr. Manimaran
Agenda








Problem Objective
Requirements
Assumptions and Limitations
Design
Testing
Resources and Schedule
Closure Material
Summary
Project Objective

To prove that it is possible to increase the efficiency
and customer service in a restaurant.
Central Computer
Handheld
Kitchen Display
Database
Acknowledgement

Academic Advisor
–

Dr. Manimaran
Electrical and Computer Engineering
Department
Definitions

eBox
–

MySQL
–

Emulates a handheld device
Database software
Windows CE
–
Operating system used on handheld devices
Intended Users/Uses

Users
–
–
–
–

Servers
Cooks
Managers
Customers
Uses
–
–
–
–
To take orders
Order payment
Ability for cook to view orders
Ability to create and modify menus
Assumptions and Limitations

Assumptions
–
–
–

Central Computer would have a static IP address
Inputs into the system would be valid
No security threats
Limitations
–
–
The lack of programming skills of the group
The cost of the items for the project
Expected Final Product

Handheld ordering software
–
–

Central computer software
–

Holds the menu, orders and transactions
Database software
–

Main communications
Database
–

Ordering
Complete transactions
Menu creation and edit
Kitchen Display
–
Displays orders
Operating Environment

Used and stored in an
indoor, dry environment
–
Operating Temperature

~50 °F - 80 °F
Courtesy of http://www.seattle-city.com/earth-ocean-restaurant.php
Design Objectives

Develop a database
–



Use MySQL
Develop kitchen software
Develop a central computer server
Develop handheld software
Design Constraints

Handheld
–
–

Central computer server
–
–

User interface
Communications
User interfaces
Minimal wireless communications
Kitchen
–
–
User interface
Communications
Central Computer - Software

Central hub of communications
–
–
–
Redirects traffic
Updates database
Notifies either kitchen or handheld of current
orders
Central Computer - Software
Incoming
Data
Where
from?
Handheld
Kitchen
Display
Get Menu
What
Requested?
Send Order
Order Done
Get the menu
from the
database
Transaction
Update database
and forward order to
Kitchen Display
Update the
database and
notify the Handheld
Update
database
What
Requested?
Get current
orders
Retrieve current
orders from
database
Central Computer - Software
Handheld - Software

Inputs
–
–
–
–
–
–

Outputs
–

Order number
Seat number
Menu item
Order done
Payment type
Payment amount
Order matrix
Steps for taking an order
Handheld - Software




Startup/update function
Create order function
Edit order function
Payment function
Handheld - Communication



Handheld to central
computer server
Credit card reader to
handheld
Handheld to printer
Handheld
Central
Computer
Credit Card
Reader
Printer
Handheld - Hardware




ICOP Technology eBox-II
USB Wireless card
Credit card reader
Bluetooth printing
Kitchen - Software

Java Application
–

Receives orders from
central computer and
displays them on kitchen
display.
Main
Program
Input
Server
Order
Process
Kitchen
Data
Communication
–
User-confirmation of
completed order sends
message to Central
Computer with order
number and IP address of
handheld from which order
came.
Kitchen GUI
Send Data
Kitchen - Software
Database - Software

MySQL database with GUI
–
Purpose

–
Used to keep track of order history and inventory
GUI

Ability to modify and add menu items
Database - Software
Pictures of Whole System
Server
Manager
Software
Handheld
Kitchen
Display
Testing

Communication
–
–

Verify packets sent and received
Verify packets processed properly
Software/GUI
–
Verify software interacted properly with user input
Actual Personal Hours
Personnel Name Task 1
Chris Ford
2.50
Sean McVeigh
7.03
Obioma Ohia
5.50
Nichole Taylor
6.00
Anthony VanSant
0.25
Total 21.28
Task 2
4.00
2.43
16.00
15.00
1.25
38.68
Task 3
15.00
11.47
12.50
14.00
3.22
56.19
Task 4
94.50
109.15
40.50
41.00
116.61
401.76
Task 5
10.00
23.64
35.00
37.00
15.90
121.54
Task 6
0.00
0.00
0.00
0.00
0.00
0.00
Task 1 – Problem Definition
Task 2 – Technology Considerations and Selections
Task 3 – End Product Design
Task 4 – End Product Prototype Implementation
Task 5 – End-Product Testing
Task 6 – End-Product Documentation
Task 7 – End-Product Demonstration
Task 8 – Project Reporting
Task 7
4.00
1.00
5.00
5.00
2.00
17.00
Task 8
55.50
79.82
32.50
44.00
23.38
235.20
Total
185.50
234.54
147.00
162.00
162.61
891.65
Actual Financial Requirement
Item
W/O Labor With Labor
Parts and Materials:
b.
ICOP Technology eBox-II
c.
Magtek Mini USB Credit Card Reader
d.
U.S. Robotics Wireless MAXg 802.11g USB 2.0 Adapter
e.
Bluetooth Printer Adapter
g.
Print Project Poster
h.
Dell Dimension GX270
i.
Linksys BEFW11S4 Wireless Router
Subtotal
Software:
a.
Microsoft Windows CE .NET 5.0
b.
Microsoft Visual Studio Pro w/MSDN Pro
Free
$53.70
$45.95
$79.99
$55.00
Free
Free
$234.64
Free
$53.70
$45.95
$79.99
$55.00
Free
Free
$234.64
Free
Free
Free
Free
$234.64
$1,947.75
$2,462.67
$1,543.50
$1,701.00
$1,707.41
$9,362.33
$9,596.97
Subtotal
Labor at $10.50 per hour:
a.
Ford, Chris
b.
McVeigh, Sean
c.
Ohia, Obioma
d.
Taylor, Nichole
e.
VanSant, Anthony
Subtotal
Total
Schedule of Work
Closure Material




Project Evaluation
Commercialization / Additional Work
Lessons Learned
Risk Management
Project Evaluation
Milestones
Relative Importance
Evaluation Score
Resultant Score
Task 1: Problem definition
15%
100%
15%
Task 2: Technology considerations and selection
5%
100%
5%
Task 3: End-product design
10%
100%
10%
Task 4: Prototype implementation
20%
75%
15%
Task 5: End-product testing
15%
95%
14.25%
Task 6: End-product documentation
10%
100%
10%
Task 7: Project demonstration
10%
55%
5.5%
Task 8: Project reporting
15%
100%
15%
Total
Previously defined passing score = 80%
100%
89.75%
Project Evaluation (cont.)
Handheld Software Components
Status
Taking order
Fully Met
Payment function
Fully Met
Editing an order
Fully Met
Communicating
Partially Met
Kitchen Software Components
Status
Receive order
Fully Met
Order completion communication
Fully Met
Display orders
Fully Met
Communicating
Fully Met
Get orders when starting up
Manager Software
Exceeded Expectations
Status
Create menu
Fully Met
Edit menu
Fully Met
Database
Create database to hold orders,
menus, and transactions
Central Computer Software
Status
Fully Met
Status
Send menus
Fully Met
Forward order to kitchen
Fully Met
Forward order to database
Fully Met
Forward order completion to
database
Fully Met
Forward order completion to
handheld
Fully Met
Send current orders to handheld
Fully Met
Send current orders to kitchen
Fully Met
Forward transaction completion to
database
Fully Met
Project Evaluation (cont.)
System Demonstration
Status
Independent software working
Fully Met
Basic system demo
Fully Met
Kitchen to central server function
Fully Met
Handheld to central server function
Partially Met
Central Server to database function
Fully Met
Manager software function
Fully Met
Whole system integration
Partially Met
Commercialization / Additional Work

Commercialization
–

Proof of concept so this was not explored
Recommendation for Additional Work
–
–
–
–
–
Increase the functionality of the manager software
Add error checking to the central computer software
Add security to the communications
Port the handheld software to a handheld device
Develop a handheld device that would incorporate
everything required for the handheld
Lessons Learned

What went well:
–
–
–

Central computer and
Kitchen display interaction
work
Individual programs work
separately
Central server works
What did not go well:
–
–
Integration of GUIs
Communications
integrations

Knowledge gained:
–
–
–

Java network programming
Database building
Java-MySQL interaction
programming
What would we change:
–
–
–
Start programming in
November
Start with GUI program
instead of text based
Program for eBox right
away
Risk and Risk Management

Anticipated risk:
–

Unanticipated encountered risk:
–

Difficulties with programming languages
Course work was higher than expected
Resultant changes for unanticipated risk:
–
Changing of the project definition
Summary


To prove that it is possible to increase the efficiency and
customer service in a restaurant.
Handheld device
–
–
–

Database
–

Holds the menus and transactions
Kitchen
–

place orders
receive payments
print receipts
Shows the current orders
Central Computer
–
Redirects traffic and updates the database
Questions