Restaurant Assistant

1
Restaurant Assistant
CS410 Fall 04 Group 2
2
Restaurant Assistant
Group Members
October 20, 2004
2
3
Outline
Restaurant Assistant

• Industry problems and solutions
• Goals and objectives
• What our system will do and not do
• Pros and cons
• Our competition
• Potential customer feed back
• Current method vs. our method
• Risks/issues and mitigations
• Budget
• Conclusion

October 20, 2004
3
4
Restaurant Assistant
Problem Statement Current restaurant methods
used to monitor expiration dates and inventory
are leading to profit and time loss.
October 20, 2004
4
5
Restaurant Assistant

• Problem Characteristics
• Expiration of food
• Profit loss
• Wasting of food
• Sickness
• Lawsuits
• Health violations
• Fines
• Restaurant shutdown
• Bad reputation

October 20, 2004
5
6
Restaurant Assistant
Solution Statement To develop a user friendly
food preparation monitoring system for the
restaurant industry.
October 20, 2004
6
7
Restaurant Assistant

• Solution Characteristics
• Database driven inventory system
• User friendly interface
• Commercially available hardware
• Bar-coded inventory
• Employee production tracking
• Temperature sensor
• Automatic food expiration warning

October 20, 2004
7
8
Restaurant Assistant

• Restaurant Industry
• Its on the rise
• 12 million employees
• 15 increase in foodservice managers
• Restaurant Industrys Share of Food is 53!!!!

Source http//www.restaurant.org/research/ind_g
lance.cfm
October 20, 2004
8
9
Restaurant Assistant

• We like to eat out
• Americans eat almost 30 of their meals away
  from home
• Eating out is becoming more accepted
• 440.1 billion dollars for restaurants in 2004
• 168.6 billion dollars increase from 1994

Source http//www.restaurant.org/research/ind_g
lance.cfm
October 20, 2004
9
10
Restaurant Assistant

• Goals
• Save restaurant managers time and money
• Implement a user friendly system
• Improve current inventory system
• Inventory reports
• Expired food notifications
• Real time food temperature data
• Provide inventory forecasting

October 20, 2004
10
11
Restaurant Assistant

• Development Objectives
• Develop a user friendly restaurant database
• Implement software interface with database
• Integrate current hardware into the system
• Health inspector approval

October 20, 2004
11
12
Restaurant Assistant

• The Restaurant Assistant will
• Notify managers of current expired food items
  and future expirations
• Display on-hand inventory
• Monitor food temperatures
• Monitor employee production
• Print out of forecasting information

October 20, 2004
12
13
Restaurant Assistant

• The Restaurant Assistant will not
• Eliminate human error
• Eliminate food-borne diseases
• Stop foods from expiring

October 20, 2004
13
14
Restaurant Assistant

• PROS AND CONS
• PROS
• Save restaurants money
• Great way to take the next step in integrating
  technology in the workplace
• Ease of use
• New restaurants have better chance of survival
  during first year
• CONS
• Customer training
• Transitioning to new system
• Initial Cost

14
October 20, 2004
15
Restaurant Assistant
Competition Matrix

See Appendix pg. 2
October 20, 2004
15
16
Restaurant Assistant
See Appendix pg. 17 for market analysis
October 20, 2004
16
17
Restaurant Assistant
Thrown Out And Prepared
October 20, 2004
17
18
Restaurant Assistant
Interview Report
Interview Report
Source Interview Data From All Restaurants
October 20, 2004
18
19
Restaurant Assistant
Who Monitors Expired Food?
Source Interview Data From All Restaurants
October 20, 2004
19
20
Restaurant Assistant
Food Preparation Cycle
Order
Check Delivery
Put into Inventory
Store
Check Resources
Find FIFO
Check Food
Trash
Prepare Food
Serve
Store
Stolen
October 20, 2004
20
21
Restaurant Assistant
Component Diagram
DINING ROOM
Managers office
kitchen
Walk-in-refrigerator
October 20, 2004
21
22
Restaurant Assistant
Restaurant Assistant System Diagram
User I/O
User I/O
User I/O
RA
Wireless Control System
Temperature Control System
October 20, 2004
22
23
Restaurant Assistant
User Interface
October 20, 2004
23
Source http//www.actionsystems.com/?trackcodeb
izcom
24
Restaurant Assistant
Database Cycle
Database
Resources
Products
Employees
Deliveries
LT
LT
LT
LT
LT
LT
Temp. Changes
Inventory
Schedule
October 20, 2004
24
25
Restaurant Assistant

• Technology
• Clear-coated barcode printer
• Barcode scanner
• LCD touch screen
• Temp. Sensor
• Database
• Expiration dates
• Preparation dates
• Employee ID
• Food ID
• Barcode

October 20, 2004
25
See Appendix ?? For more information
26
Restaurant Assistant
October 20, 2004
26
27
Restaurant Assistant
October 20, 2004
27
28
Technical Issues
Restaurant Assistant

• Data redundancy
• Temperature regulations
• Power failure
• Technical support

October 20, 2004
28
29
Management Issues
Restaurant Assistant

• Human mistakes
• Complexity (computer skill)
• Final product is not too costly
• Health regulation

October 20, 2004
29
30
Resource Issues
Restaurant Assistant

• Obtaining our goals in the allowed time
• Limited financing
• Inconsistent methods
• Find test client

October 20, 2004
30
31
Restaurant Assistant
Development Salary Budget
Values based on average salaries in Virginia
Beach, VA as of Fall of 2004. See Appendix pg. 6
for more information
October 20, 2004
31
32
Restaurant Assistant
Development Equipment Budget
Prices based on pricing as of October 19, 2004,
see Appendix pg. 3 for more information.
October 20, 2004
32
33
Restaurant Assistant
Production Budget
See appendix pg. 9 for more detailed information
October 20, 2004
33
34
Restaurant Assistant
Customer Cost
Hardware 4,599.99 Software 1,995.99 Installati
on 404.01 Total Cost 6,999.99
October 20, 2004
34
35
Restaurant Assistant
Break Even Analysis
See Appendix pg. 8 for schedule analysis
October 20, 2004
35
36
Restaurant Assistant
Conclusion

• Identified industry problems and solutions
• Technical components were discussed
• Required resources
• Management methods and organizational structure
• Risks/issues and mitigations
• Improved solutions to the current problems
• Budget

October 20, 2004
36