450 likes | 592 Views
Restaurant Assistant. CS410 – 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
E N D
Restaurant Assistant CS410 – 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 December2004 3
Restaurant Assistant Problem Statement Current restaurant methods used to monitor expiration dates and inventory are leading to profit and time loss. 15 December2004 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 * Names of restaurants have been disclosed See SBIR page 48 15 December 2004 6
Restaurant Assistant Ideal Food Preparation Cycle Inspect Inventory Inspect Delivery Put In Inventory Prepare Food Place Order Inventory Cook Food Serve Food • Low inventory • Expired items • Damaged items • Received items not ordered • Didn’t receive some items ordered • Didn’t inspect food tags for expired items • Didn’t discard bad food items • Didn’t write down reports for expired items / food temperatures Poorly cooked item Supplier can’t fill your order • Didn’t rotate inventory FIFO • Didn’t update inventory report • Prepared food in unsanitary conditions • Didn’t follow recipe correctly • Didn’t write down report on who made which prepared items Perfect Cycle Current Method See SBIR pages 7-11 15 December 2004 7
Restaurant Assistant Current Delivery Process Check Inv. Inventory Reorder Deliveries No Yes Suppliers Delivery Put Together Physical Reports Manager Check Delivery Vendors Incorrect Correct 15 December 2004 8
Restaurant Assistant Current Food Preparation Process FIFO Good Raw Food Inventory Delivery Check Temperature Prepared Food Items Prepared Food Inventory Bad Trash Manager Physical Reports Employees 15 December 2004 9
Restaurant Assistant Current Serving Process Raw Food Inventory Prepared Food Inventory Expire Yes No Cooked Food 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 Prepared Food Inventory Yes Bad Cooked Food Suppliers Expire Yes No Delivery Put Together Trash Served Food Physical Reports Manager Check Delivery Employees Incorrect Correct Vendors 15 December 2004 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 See SBIR page 6 15 December 2004 13
Restaurant Assistant Ideal RA Method Inspect Inventory Inspect Delivery Put In Inventory Prepare Food Place Order Inventory Cook Food Serve Food Notifies manager when inventory items are low and their shelf life • Reports are generated with items that are: • Damaged • Not ordered • Not received PDA/Barcodes used to update inventory • Reports for manager each day on: • Temp. readings for food items • Shelf life for items Reports for each employee on what they made Perfect Cycle RA Method See SBIR pages 7-11 15 December 2004 14
Restaurant Assistant • Solution Characteristics • The Restaurant Assistant will not: • Eliminate manager’s issueswith theirsupplier • Eliminate incorrect rotating of inventory • Eliminate expired food to the trash • Eliminate unsanitary conditions 15 December 2004 15
Restaurant Assistant • HardResources • 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) See SBIR page 61 15 December 2004 16
Restaurant Assistant Database Cycle Database Employees Resources Products Deliveries LT LT LT LT LT LT Temp. Changes Inventory Schedule 15 December 2004 17
Restaurant Assistant GUI See SBIR pages 57-60 15 December 2004 18
Restaurant Assistant RA Delivery Process 1 Check Inv. Inventory Reorder Deliveries No Yes Suppliers Delivery Put Together Computerized Reports Manager Check Delivery Incorrect Correct Vendors Our System 2 See SBIR page 11 15 December 2004 19
Restaurant Assistant RA Food Preparation Process FIFO Good 3 Raw Food Inventory Delivery Check Temperature 5 Prepared Food Items Prepared Food Inventory Bad 4 Trash Employees Computerized Reports Our System See SBIR pages 11-12 15 December 2004 20
Restaurant Assistant RA Serving Process Raw Food Inventory 7 Prepared Food Inventory 6 Expire Yes No Cooked Food No 8 Yes Served Food Trash Employees Computerized Reports Our System See SBIR pages 12-13 15 December 2004 21
Restaurant Assistant RA Method 1 Check Inv. FIFO Good 3 Raw Food Inventory 7 Reorder Deliveries No Check Temperature 5 Prepared Food Items Prepared Food Inventory Yes Bad 4 Suppliers 6 Expire Yes No Cooked Food No Delivery Put Together Trash 8 Computerized Reports Yes Manager Check Delivery Served Food Employees Incorrect Correct Vendors 2 Our System See SBIR page 14 15 December 2004 22
Restaurant Assistant Interview Report Interview Report Avoid Fines Benefit Lawsuits Benefit Health Inspections Avoid Restaurant Shutdown Would Buy the RA System Source: Interview Data From All Restaurants See SBIR page 45 15 December 2004 23
Restaurant Assistant Interview data 15 December 2004 24 Source: SBIR page 51
Restaurant Assistant Competition Matrix See SBIR page 49 15 December 2004 25
Restaurant Assistant Risk Management Plan See SBIR pages 71-74 15 December 2004 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 See SBIR pages 32-34 15 December 2004 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 See SBIR pages 35-39 15 December 2004 28
Restaurant Assistant Marketing Plan See SBIR page 46 15 December 2004 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 See SBIR pages 54,56 15 December 2004 30
Restaurant Assistant Deployment Plan Applebee’s Locations 15 December 2004 31
Restaurant Assistant Deployment Plan Applebee’sLocations 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 See SBIR page 70 15 December 2004 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 See SBIR page 82 See SBIR page 82 for Gantt chart 15 December 2004 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 See SBIR pages 82-83 See SBIR page 83 for Gantt chart 15 December 2004 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 See SBIR pages 83-89 See SBIR pages 83-89 for Gantt charts 15 December 2004 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 See SBIR pages 89-91 See SBIR pages 90-91 for Gantt charts 15 December 2004 37
Restaurant Assistant Project Budget See SBIR pages 61-67 15 December 2004 38
Restaurant Assistant Resource Plan - Per Unit See SBIR pages 63-64 15 December 2004 39
Restaurant Assistant Resource Plan - Development See SBIR pages 61-62 15 December 2004 40
Restaurant Assistant Staffing Plan – Phase 1 See SBIR page 65-67 15 December 2004 41
Restaurant Assistant Staffing Plan – Phase 2 See SBIR page 65-67 15 December 2004 42
Restaurant Assistant Staffing Plan – Phase 3 See SBIR page 65-67 15 December 2004 43
Restaurant Assistant Break-Even Analysis See SBIR pages 68-69 15 December 2004 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 December2004 45