Restaurant Assistant CS 410 Fall 2004 Group

Restaurant Assistant CS 410 – Fall 2004 Group 2

Restaurant Assistant Group Members 15 December 2004 2

Restaurant Assistant Outline Industry problems and solutions RA design Possible risks Project plans/brief Milestones and deliverables Project budget Resource plan Staffing plan 15 December 2004 3

Restaurant Assistant Problem Statement Current restaurant methods used to monitor expiration dates and inventory are leading to profit and time loss. 15 December 2004 4

Restaurant Assistant Problem Characteristics Profit Efficient use of food inventory Expired food is thrown out Sick customers exposed to food-born illnesses Health standard inspections Fines Reputation Time Checking inventory that is needed Monitoring inventory conditions Keeping up with HAND WRITTEN reports 15 December 2004 5

Restaurant Assistant Thrown Out And Prepared 15 December 2004 * Names of restaurants have been disclosed See SBIR page 48 6

Restaurant Assistant Ideal Food Preparation Cycle Inspect Inventory Place Order Inspect Delivery Put In Inventory • Low inventory • Damaged items • Expired items • Received items not ordered Prepare Food Inventory • Didn’t inspect food tags for expired items Cook Food Poorly cooked item • Didn’t discard bad food items • Didn’t receive some items ordered • Didn’t write down reports for expired items / food temperatures • Didn’t rotate inventory FIFO • Prepared food in unsanitary conditions • Didn’t update inventory report Supplier can’t fill your order • Didn’t follow recipe correctly • Didn’t write down report on who made which prepared items 15 December 2004 Serve Food See SBIR pages 7 -11 Perfect Cycle Current Method 7

Restaurant Assistant Current Delivery Process Check Inventory Reorder Deliveries No Yes Suppliers Delivery Put Together Physical Reports Incorrect 15 December 2004 Check Delivery Correct Manager Vendors 8

Restaurant Assistant Current Food Preparation Process FIFO Good Raw Food Inventory Delivery Check Temperature Prepared Food Items Prepared Food Inventory Bad Trash Physical Reports 15 December 2004 Manager Employees 9

Restaurant Assistant Current Serving Process Raw Food Inventory Prepared Food Inventory Expire Yes Cooked Food No No Yes Served Food Trash Manager Employees Physical Reports 15 December 2004 10

Restaurant Assistant Current Food Preparation Cycle Check Inv. FIFO Good Raw Food Inventory Reorder Deliveries No Check Temperature Prepared Food Items Yes Bad Suppliers Prepared Food Inventory Cooked Food Expire Yes Delivery Put Together Trash Physical Reports Incorrect Check Delivery 15 December 2004 Correct No Served Food Manager Employees Vendors 11

Restaurant Assistant Solution Statement To develop a user-friendly monitoring system for the restaurant industry that will increase profit, decrease health inspection ratifications, and increase time for managers. 15 December 2004 12

Restaurant Assistant Goals/Objectives Have more accurate forecasting Improve Profit Identify expired food Prevent lawsuits Avoid health violations Eliminate Citations Maintain good reputation Save restaurant managers time Monitor their inventory Eliminate their written reports 15 December 2004 See SBIR page 6 13

Restaurant Assistant Ideal RA Method Inspect Inventory Place Order Notifies manager when inventory items are low and their shelf life Inspect Delivery Reports are generated with items that are: Put In Inventory PDA/Barcodes used to update inventory • Damaged Prepare Food Reports for manager each day on: • Temp. readings for food items • Not ordered Cook Food Serve Food Reports for each employee on what they made • Shelf life for items • Not received Perfect Cycle RA Method 15 December 2004 See SBIR pages 7 -11 14

Restaurant Assistant Solution Characteristics The Restaurant Assistant will not: Eliminate manager’s issues with their supplier Eliminate incorrect rotating of inventory Eliminate expired food to the trash Eliminate unsanitary conditions 15 December 2004 15

Restaurant Assistant Hard Resources Software Database Graphical User Interface (GUI) Drivers Hardware Integration Drivers Wireless barcode scanners Point of Sale (POS) touch screens Temperature sensors Personal Digital Assistant (PDA) 15 December 2004 See SBIR page 61 16

Restaurant Assistant Database Cycle Database Employees Resources Temp. Changes 15 December 2004 Deliveries LT LT Products LT LT LT Inventory LT Schedule 17

Restaurant Assistant GUI 15 December 2004 See SBIR pages 57 -60 18

Restaurant Assistant RA Delivery Process 1 Check Inventory Reorder Deliveries No Yes Suppliers Delivery Put Together Computerized Reports Incorrect Check Delivery Correct 2 15 December 2004 See SBIR page 11 Manager Vendors Our System 19

Restaurant Assistant RA Food Preparation Process FIFO Good 3 Delivery Check Temperature Raw Food Inventory 5 Prepared Food Items Bad Prepared Food Inventory 4 Trash Computerized Reports 15 December 2004 See SBIR pages 11 -12 Employees Our System 20

Restaurant Assistant RA Serving Process Raw Food Inventory 7 Prepared Food Inventory 6 Expire Yes Cooked Food No No 8 Yes Served Food Trash Employees Computerized Reports 15 December 2004 See SBIR pages 12 -13 Our System 21

Restaurant Assistant RA Method 1 Check Inv. FIFO Good 3 Reorder Deliveries No Raw Food Inventory Check Temperature 5 Prepared Food Items Yes Bad 7 Prepared Food Inventory 4 Suppliers 6 Expire Yes Delivery Put Together Trash Cooked Food Computerized Reports Incorrect Check Delivery Yes Served Food Correct No 8 Manager Employees Vendors 2 15 December 2004 No Our System See SBIR page 14 22

Restaurant Assistant Interview Report Avoid Fines Benefit Lawsuits Benefit Health Inspections Avoid Restaurant Shutdown Would Buy the RA System Source: Interview Data From All Restaurants 15 December 2004 See SBIR page 45 23

Restaurant Assistant Interview data 15 December 2004 Source: SBIR page 51 24

Restaurant Assistant Competition Matrix 15 December 2004 See SBIR page 49 25

Restaurant Assistant Risk Management Plan Risk Detail 1 Customers avoiding a change in methodology 2 Delayed FDA approval 3 Invalid user input 4 Power outages causing data loss 5 Insufficient finances 6 Customers not familiar with technology 7 Problems integrating software drivers with hardware 8 Hardware Failure 9 Not being able to obtain hardware when needed 10 Delayed development schedule 15 December 2004 3 1 7 See SBIR pages 71 -74 9 2 6 10 4 5 8 26

Restaurant Assistant Management Plan Use a mixed organizational structure Monitor financial factors to insure budget is met. Keep a close relationship with the customers to insure their needs are met. Market strategy needs to be thought out and executed to allow for high yielding profits Communication Methods Weekly meetings to forecast our development cycle Discussion board and cell phones 15 December 2004 See SBIR pages 32 -34 27

Restaurant Assistant Evaluation Plan – Using Team Software TSP Develop a strategy Plan the tasks Insure requirements are met Design based on requirements Implement the design Test the functionality Incorporate customer feedback Postmortem 15 December 2004 See SBIR pages 35 -39 28

Restaurant Assistant Marketing Plan 15 December 2004 See SBIR page 46 29

Restaurant Assistant Initial Target Applebee’s APPB (NASDAQ NM ) Showed the most interest 1, 585 locations in 49 states 100 or more new restaurants opening each year 1400 more potential locations estimated 75 % franchised , 25% company owned 15 December 2004 See SBIR pages 54, 56 30

Restaurant Assistant Deployment Plan Applebee’s Locations 15 December 2004 31

Restaurant Assistant Deployment Plan Applebee’s Locations 15 December 2004 32

Restaurant Assistant Funding Plan Obtain Small Business Innovation Research funding from National Science Foundation TOPIC: Information-Based Technologies (IT) SUBTOPIC: Applications, Data Mining and Management SBIR Funding Proposal Goal: $850, 000 Phase 1: $100, 000 Phase 2: $750, 000 15 December 2004 See SBIR page 70 33

Restaurant Assistant Phase 0: Milestones and Deliverables Determine project - 9 September 2004 Major functional component diagram Prove feasibility – 20 October 2004 Work breakdown structure Competition matrix Establish project plan – 17 November 2004 Gantt charts Create SBIR proposal – 15 December 2004 Management plan Evaluation plan Develop website – 15 December 2004 Solution description Team member pages Research documents 15 December 2004 See SBIR page 82 for Gantt chart 34

Restaurant Assistant Phase 1: Milestones and Deliverables Revise Phase 0 plans – 24 January 2005 Revised major functional component diagram Create Phase 1 related documentation – 21 March 2005 Constructed user manual Consult legal advisors – 28 March 2005 Plan for obtaining a patent Create prototype – 6 May 2005 Document of system specifications Assembled prototype Revise SBIR for second phase grant – 6 May 2005 Documented second phase of grant proposal Revise web content – 6 May 2005 Updated solution description 15 December 2004 See SBIR pages 82 -83 See SBIR page 83 for Gantt chart 35

Restaurant Assistant Phase 2: Milestones and Deliverables Setup workplace – 13 June 2005 Office Attain legal documentation – 15 August 2005 Patent forms Construct marketing team – 16 September 2005 Acquire beta testers and customers – 12 September 2005 Construct a supported hardware list – 24 August 2005 List of supported hardware Develop software – 12 September 2005 Functional implementation Setup and monitor beta test – 2 February 2006 User reports Bug reports 15 December 2004 See SBIR pages 83 -89 for Gantt charts 36

Restaurant Assistant Phase 3: Milestones and Deliverables Initiate Advertising – 1 June 2007 Updated website Pamphlets Establish corporate relationship Setup Customer Service Facility Phone support Onsite support Ship Product to Customers Physical solution 15 December 2004 See SBIR pages 89 -91 See SBIR pages 90 -91 for Gantt charts 37

Restaurant Assistant Project Budget PHASE 1 Employment Costs $ 87, 161 Development Resources $ 8, 387 Resources per Unit $ 4, 195 Total Phase 1 Budget $ 99, 743 PHASE 2 Employment Costs $ 315, 923 Development Resources $ Resources (100 Units) $ 419, 500 Total Phase 2 Budget $ 743, 810 8, 387 PHASE 3 Employment Costs 15 December 2004 $ 716, 059 See SBIR pages 61 -67 38

Restaurant Assistant Resource Plan - Per Unit Part # of units Cost Database Server 1 $ 600. 00 Database Management Software 1 $ 595. 00 Workstation 1 $ 940. 00 1 per walkin $ 325. 00 1 $ 425. 00 1 per walkin $ 120. 00 Laser Printer 1 $ 150. 00 Barcode Printer 1 $ 340. 00 LCD touch screen, wireless 1 $ 700. 00 Standalone scanner Handheld Scanner Temperature sensor Total Production Cost 15 December 2004 See SBIR pages 63 -64 $4, 195. 00 39

Restaurant Assistant Resource Plan - Development Hardware Costs Price (each) Amt. Total Price Computer Workstations $ 941. 00 5 $4, 705. 00 Network Color Laser Printer $ 280. 00 1 $ 280. 00 Total Hardware Costs $4, 985. 00 Software Costs Microsoft. NET Professional $ 504. 00 3 $1, 512. 00 Adobe CS Suite $ 890. 00 1 $ 890. 00 Microsoft Office Professional $ 200. 00 5 $1, 000. 00 Total Software Costs Total Costs 15 December 2004 $3, 402. 00 $8, 387. 00 See SBIR pages 61 -62 40

Restaurant Assistant Staffing Plan – Phase 1 PHASE 1 Salary (Yearly) Employment Duration (Days) Title Needed Software Engineer 2 $ 68, 569 25 $ 14, 285 Network Engineer/Lead Software Engineer 1 $ 87, 572 30 $ 10, 947 Computer Graphics Specialist 1 $ 41, 561 5 $ 866 Project Manager 1 $ 102, 099 85 $ 36, 160 40% Overhead $ 24, 903 Total Employee Budget $ 87, 161 15 December 2004 See SBIR page 65 -67 Cost of Employment 41

Restaurant Assistant Staffing Plan – Phase 2 PHASE 2 Title Needed Software Engineer 2 $ 68, 569 80 $ 45, 713 Network Engineer/Lead Software Engineer 1 $ 87, 572 110 $ 40, 137 Computer Graphics Specialist 1 $ 41, 561 10 $ 1, 732 Project Manager 1 $ 102, 099 240 $ 102, 099 Technical Writer 1 $ 58, 903 20 $ 4, 909 Quality Assurance Manager 1 $ 53, 926 110 $ 24, 716 Marketing Manager 1 $ 62, 410 150 $ 39, 006 40% Overhead $ 103, 325 Total Employee Budget $ 315, 923 15 December 2004 Salary (Yearly) Employment Duration (Days) See SBIR page 65 -67 Cost of Employment 42

Restaurant Assistant Staffing Plan – Phase 3 PHASE 3 Salary (Yearly) Employment Duration Title Needed Software Engineer 2 $ 68, 569 Annual $ 137, 138 Network Engineer/Lead Software Engineer 1 $ 87, 572 Annual $ 87, 572 Computer Graphics Specialist 1 $ 41, 561 Annual $ 41, 561 Project Manager 1 $ 102, 099 Annual $ 102, 099 Technical Writer 1 $ 58, 903 Annual $ 58, 903 Quality Assurance Manager 1 $ 53, 926 Annual $ 53, 926 Marketing Manager 1 $ 62, 410 Annual $ 62, 410 Technical Support 5 $ 28, 800 Annual $ 144, 000 40% Overhead $ 162, 588 Total Employee Budget $ 713, 059 15 December 2004 See SBIR page 65 -67 Cost of Employment 43

Restaurant Assistant Break-Even Analysis 3 Units Needed To Break Even Units To Be Sold (weekly) See SBIR pages 68 -69 10 Break Event Time (months) 15 December 2004 40 8 44

Restaurant Assistant Conclusion Industry problems and solutions RA design Possible risks Project plans/brief Milestones and deliverables Project budget Resource plan Staffing plan 15 December 2004 45