FINAL PROJECT REPORT FOR INVENTORY CONTROL SYSTEM FOR …

[Pages:101]FINAL PROJECT REPORT FOR INVENTORY CONTROL SYSTEM FOR THE

CALCULATION AND ORDERING OF AVAILABLE AND PROCESSED RESOURCES

GROUP 9 SIMANT PUROHIT AKSHAY THIRKATEH BARTLOMIEJ MICZEK ROBERT FAIGAO

December 7, 2012

ACKNOWLEDGEMENTS

We would like to thank Ms. Kimberly Harmon for her professional input, feedback, and support, as well explaining the need required to make our product a successful one. Her experience in the restaurant industry proved fruitful and extensive when it came to the project requirements and development. We all eat at restaurants, but no one realized that the amount of work that chefs do goes beyond simply cooking the meal. We would also like to thank Professor John Bell and his teaching assistant, Munavvar Khan, for their continued guidance and feedback throughout the course of the project.

1

TABLE OF CONTENTS

1 PROJECT OVERVIEW ...................................................................................................................................... 9

1.1 THE PURPOSE OF THE PROJECT ............................................................................................................................9 1.2 GOALS OF THE PROJECT......................................................................................................................................9 1.3 THE DOMAIN ....................................................................................................................................................9 1.4 THE CLIENT....................................................................................................................................................10 1.5 USER OF THE PRODUCT.....................................................................................................................................10 1.6 OBJECTIVES AND SUCCESS CRITERIA OF THE PROJECT...............................................................................................11

2 SYSTEM ARCHITECTURE OVERVIEW (DEVELOPMENT ENVIRONMENT) ........................................................ 12

2.1 FRONT END.................................................................................................................................................12 2.2 BACK END ...................................................................................................................................................12 2.3 BASIC DATABASE RELATIONSHIP DIAGRAM...........................................................................................................13 ................................................................................................................................................................................. 13 2.4 ASSIGNMENT OF RESPONSIBILITIES......................................................................................................................13

3 REQUIREMENTS ANALYSIS .......................................................................................................................... 14

3.1 FUNCTIONAL REQUIREMENTS ............................................................................................................................14 3.2 NON-FUNCTIONAL REQUIREMENTS .....................................................................................................................14 3.3 USE CASE MODEL ............................................................................................................................................17 3.4 USE CASES .....................................................................................................................................................18

3.4.1 Update Resource Database....................................................................................................................18 3.4.2 Check Threshold Use Case......................................................................................................................19 3.4.3 Process Order Use Case..........................................................................................................................20 3.4.4 Add Recipe Use Case ..............................................................................................................................21 3.4.5 Update Recipe Use Case ........................................................................................................................22 3.4.6 Remove Recipe Use Case .......................................................................................................................23 3.4.7 Add Occasion Use Case ..........................................................................................................................24 3.4.8 Update Inventory Use Case....................................................................................................................25 3.4.9 Correct Inventory Use Case ....................................................................................................................26 3.4.10 Add Vendor Use Case.........................................................................................................................27 3.4.11 Remove Vendor Use Case ..................................................................................................................28 3.4.12 Add Ingredients Use Case ..................................................................................................................29 3.5 MULTIPLICITY AND ASSOCIATION DIAGRAMS .........................................................................................................30 3.5.1 Multiplicity Diagram ..............................................................................................................................30 3.5.2 Association Diagram ..............................................................................................................................30 3.6 DYNAMIC MODEL ...........................................................................................................................................31 3.6.1 Update Resource Database Sequence Diagram ....................................................................................31 3.6.2 Add Recipe Sequence Diagram ..............................................................................................................32 3.6.3 Remove Recipe Sequence Diagram........................................................................................................32 3.6.4 Update Recipe Sequence Diagram.........................................................................................................33 3.6.5 Add Vendor Sequence Diagram .............................................................................................................34 3.6.6 Remove Vendor Sequence Diagram.......................................................................................................34 3.6.7 Update Inventory Sequence Diagram ....................................................................................................35 3.6.8 Correct Inventory Sequence Diagram ....................................................................................................36 3.6.9 Add Occasion Sequence Diagram ..........................................................................................................36

2

4 DETAILED SYSTEM DESIGN .......................................................................................................................... 37

4.1 DESIGN GOALS ...............................................................................................................................................37 4.2 SUBSYSTEM DECOMPOSITION............................................................................................................................39 4.3 HARDWARE SOFTWARE MAPPING......................................................................................................................42 4.4 PERSISTENT DATA MANAGEMENT ......................................................................................................................43

4.4.1 Persistent Objects ..................................................................................................................................43 4.4.2 Storage Strategy ....................................................................................................................................43 4.5 ACCESS CONTROL AND SECURITY........................................................................................................................44 4.5.1 Access Matrix .........................................................................................................................................44 4.6 GLOBAL SOFTWARE CONTROL ...........................................................................................................................45 4.9 OBJECT DESIGN TRADEOFFS ..............................................................................................................................48 4.10 INTERFACE DOCUMENTATION GUIDELINES ...........................................................................................................49 4.11.1 IngredientPackage:............................................................................................................................51 4.11.2 MiscPackage:.....................................................................................................................................51 4.11.3 RecipePackage:..................................................................................................................................52 4.12 CLASS INTERFACES...........................................................................................................................................53 4.12.1 Class Ingredient .................................................................................................................................54 4.12.2 Class AddIngredient...........................................................................................................................54 4.12.3 Class Recipe .......................................................................................................................................55 4.12.4 Class Vendor ......................................................................................................................................56 4.12.5 Class Prediction..................................................................................................................................57 4.12.6 Class AddRecipe.................................................................................................................................57 4.12.7 Class RemoveRecipe ..........................................................................................................................58 4.12.8 Class UpdateRecipe ...........................................................................................................................58 4.12.9 Class Updates ....................................................................................................................................59 4.12.10 Class Occasion ...................................................................................................................................60 4.12.11 Class Orders .......................................................................................................................................60

5 TESTING....................................................................................................................................................... 61

5.1 FEATURES TO BE TESTED/NOT TO BE TESTED .........................................................................................................61 5.1.1 Features to be tested .............................................................................................................................61 5.1.2 Features not to be tested .......................................................................................................................62

5.2 PASS/FAIL CRITERIA.........................................................................................................................................63 5.3 APPROACH.....................................................................................................................................................63 5.4 SUSPENSION AND RESUMPTION..........................................................................................................................64

5.4.1 Suspension .............................................................................................................................................64 5.4.2 Resumption ............................................................................................................................................64 5.5 TESTING MATERIALS (HARDWARE/SOFTWARE REQUIREMENTS) ................................................................................65 5.5.1 Software requirements ..........................................................................................................................65 5.6 TEST CASES....................................................................................................................................................66 5.6.1 Test case 1: Testing the Add Recipe Interface and its functioning .........................................................66

5.6.1.1 Test case specifications for Test case 1: Testing the Add Recipe Interface and its functioning .................... 66 5.6.1.2 Preliminary test results for test case 1.......................................................................................................... 69 5.6.2 Test case 2: Logging in to the system ....................................................................................................70 5.6.2.1 Test case specifications for Test case 2: Logging in to the system ................................................................ 70 5.6.2.2 Preliminary test results for test case 2.......................................................................................................... 70 5.6.3 Test Case 3: Testing the Add Ingredient Interface of the system ...........................................................71 5.6.3.1 Test case specifications for Test case 3: Testing the Add Ingredient Interface of the system ...................... 71 5.6.3.2 Preliminary test results for test case 3.......................................................................................................... 74

3

5.6.4 Test Case 4: Testing the Add vendor Interface of the system ................................................................75 5.6.4.1 Test case specification for test case 4: Testing the Add vendor Interface of the system.............................. 75 5.6.4.2 Preliminary Test Results for test case 4 ........................................................................................................ 77

5.6.5 Test Case 5: Check Threshold Interface..................................................................................................78 5.6.5.1 Test case specification for test Case 5: Check Threshold Interface............................................................... 78 5.6.5.2 Preliminary Test Reports for test case 5 ....................................................................................................... 79

5.6.6 Test Case 6: Testing the Update after sales interface............................................................................80 5.6.6.1 Test case specification for test Case 6: Testing the update after sales interface.......................................... 80 5.6.6.2 Preliminary test results for test case 6.......................................................................................................... 81

5.6.7 Test Case 7: Testing the Update After receiving interface .....................................................................82 5.6.7.1 Test case specification for Test case 7: Testing the update after receiving interface ................................... 82 5.6.7.2 Preliminary Test Results for test case 7 ........................................................................................................ 83

5.7 COMPONENT INSPECTION .................................................................................................................................84 5.7.1 Inspection of Check Threshold ...............................................................................................................84 5.7.1.1 Overview ....................................................................................................................................................... 84 5.7.1.2 Preparation ................................................................................................................................................... 84 5.7.1.3 Inspection Meeting ....................................................................................................................................... 84 5.7.1.4 Rework .......................................................................................................................................................... 84 5.7.1.5 Follow up....................................................................................................................................................... 85 5.7.2 Inspection of Add Vendor.......................................................................................................................85 5.7.2.1 Overview ....................................................................................................................................................... 85 5.7.2.2 Preparation ................................................................................................................................................... 85 5.7.2.3 Inspection Meeting ....................................................................................................................................... 85 5.7.2.4 Rework .......................................................................................................................................................... 85 5.7.2.5 Follow up....................................................................................................................................................... 85

6 CONCLUSION: .............................................................................................................................................. 86 7 PROCESS IMPROVEMENT: ........................................................................................................................... 87 8 FUTURE DEVELOPMENT............................................................................................................................... 88 9 BIBILIOGRAPHIC REFERENCES:..................................................................................................................... 89 10 GLOSSARY ................................................................................................................................................... 90 11 APPENDIX.................................................................................................................................................... 91

11.1 TEST RESULTS FOR TEST CASE 1.........................................................................................................................91 11.2 TEST RESULTS FOR TEST CASE 2..........................................................................................................................93 11.3 TEST RESULTS FOR TEST CASE 3 ..........................................................................................................................94 11.4 TEST RESULTS FOR TEST CASE 4 ..........................................................................................................................97

4

LIST OF FIGURES

FIGURE 1: FRONT END.......................................................................................................................................................12 FIGURE 2: BACK END.........................................................................................................................................................12 FIGURE 3: RESPONSIBILITIES ...............................................................................................................................................13 FIGURE 4: USE CASE MODEL ..............................................................................................................................................17 FIGURE 5: MULTIPLICITY DIAGRAM ......................................................................................................................................30 FIGURE 6: ASSOCIATION DIAGRAM ......................................................................................................................................30 FIGURE 7: UPDATE RESOURCE DATABASE SEQUENCE DIAGRAM ................................................................................................31 FIGURE 8: ADD RECIPE SEQUENCE DIAGRAM .........................................................................................................................32 FIGURE 9: REMOVE RECIPE SEQUENCE DIAGRAM ...................................................................................................................32 FIGURE 10: UPDATE RECIPE SEQUENCE DIAGRAM ..................................................................................................................33 FIGURE 11: ADD VENDOR SEQUENCE DIAGRAM.....................................................................................................................34 FIGURE 12: REMOVE VENDOR SEQUENCE DIAGRAM ...............................................................................................................34 FIGURE 13: UPDATE INVENTORY SEQUENCE DIAGRAM ............................................................................................................35 FIGURE 14: CORRECT INVENTORY SEQUENCE DIAGRAM...........................................................................................................36 FIGURE 15: ADD OCCASION SEQUENCE DIAGRAM ..................................................................................................................36 FIGURE 16: SUBSYSTEM DECOMPOSITION.............................................................................................................................39 FIGURE 17: DEPLOYMENT DIAGRAM ....................................................................................................................................42 FIGURE 18: SERVICES DIAGRAM ..........................................................................................................................................47 FIGURE 19: ATTRIBUTES NAMING CONVENTION.....................................................................................................................49 FIGURE 20: PACKAGES DIAGRAM ........................................................................................................................................51 FIGURE 21: OVERALL CLASS DIAGRAM .................................................................................................................................53 FIGURE 22: CLASS INGREDIENT ...........................................................................................................................................54 FIGURE 23: CLASS ADDINGREDIENTS....................................................................................................................................54 FIGURE 24 : CLASS RECIPE .................................................................................................................................................55 FIGURE 25: CLASS VENDOR ................................................................................................................................................56 FIGURE 26: CLASS PREDICTION ...........................................................................................................................................57 FIGURE 27: CLASS ADDRECIPE ............................................................................................................................................57 FIGURE 28: CLASS REMOVERECIPE ......................................................................................................................................58 FIGURE 29: CLASS UPDATERECIPE .......................................................................................................................................58 FIGURE 30: CLASS UPDATES ...............................................................................................................................................59 FIGURE 31: CLASS OCCASION .............................................................................................................................................60 FIGURE 32: CLASS ORDERS.................................................................................................................................................60

5

LIST OF TABLES

TABLE 1: UPDATE RESOURCE DATABASE ________________________________________________________________ 19 TABLE 2: CHECK THRESHOLD USE CASE _________________________________________________________________ 19 TABLE 3: PROCESS ORDER USE CASE ___________________________________________________________________ 20 TABLE 4: ADD RECIPE USE CASE ______________________________________________________________________ 21 TABLE 5:UPDATE RECIPE USE CASE____________________________________________________________________ 22 TABLE 6:REMOVE RECIPE USE CASE ___________________________________________________________________ 23 TABLE 7: ADD OCCASION USE CASE ___________________________________________________________________ 24 TABLE 8: UPDATE INVENTORY USE CASE ________________________________________________________________ 25 TABLE 9: CORRECT INVENTORY USE CASE________________________________________________________________ 26 TABLE 10: ADD VENDOR USE CASE____________________________________________________________________ 27 TABLE 11: REMOVE VENDOR USE CASE _________________________________________________________________ 29 TABLE 12: ADD INGREDIENTS USE CASE ________________________________________________________________ 29 TABLE 13: SUBSYSTEM DESCRIPTION___________________________________________________________________ 41 TABLE 14: ACCESS MATRIX _________________________________________________________________________ 44 TABLE 15: EXCEPTION CASES ________________________________________________________________________ 46 TABLE 16: FEATURES TO BE TESTED ____________________________________________________________________ 62 TABLE 17: FEATURES NOT TO BE TESTED ________________________________________________________________ 62 TABLE 18: TEST CASE SPECIFICATIONS FOR TEST CASE 1: TESTING THE ADD RECIPE INTERFACE AND ITS FUNCTIONING_____________ 68 TABLE 19: PRELIMINARY TEST RESULTS FOR TEST CASE 1 ______________________________________________________ 69 TABLE 20: TEST CASE SPECIFICATIONS FOR TEST CASE 2: LOGGING IN TO THE SYSTEM __________________________________ 70 TABLE 21: PRELIMINARY TEST RESULTS FOR TEST CASE 2 ______________________________________________________ 70 TABLE 22: TEST CASE SPECIFICATIONS FOR TEST CASE 3 ______________________________________________________ 73 TABLE 23: PRELIMINARY TEST RESULTS FOR TEST CASE 3 ______________________________________________________ 74 TABLE 24: TEST CASE SPECIFICATION FOR TEST CASE 4: TESTING THE ADD VENDOR INTERFACE OF THE SYSTEM _________________ 76 TABLE 25: PRELIMINARY TEST RESULTS FOR TEST CASE 4 _____________________________________________________ 77 TABLE 26: TEST CASE SPECIFICATION FOR TEST CASE 5 _______________________________________________________ 78 TABLE 27: PRELIMINARY TEST REPORTS FOR TEST CASE 5 _____________________________________________________ 79 TABLE 28: TEST CASE SPECIFICATION FOR TEST CASE 6: TESTING THE UPDATE AFTER SALES INTERFACE _______________________ 81 TABLE 29: PRELIMINARY TEST RESULTS FOR TEST CASE 6 ______________________________________________________ 81 TABLE 30: TEST CASE SPECIFICATION FOR TEST CASE 7: TESTING THE UPDATE AFTER RECEIVING INTERFACE ____________________ 83 TABLE 31: PRELIMINARY TEST RESULTS FOR TEST CASE 7 _____________________________________________________ 83

6

EXECUTIVE SUMMARY

At the end of their day, chefs and managers in the restaurant industry spend a couple of hours counting inventory and placing orders for the following week. The Restaurant Inventory Control System is designed to not only assist in this problem, but also automate many of the tedious tasks associated with it. The system keeps track of current inventory levels for recipes at the ingredient level, predicts how much inventory is needed for the upcoming week, and generates order forms to that can be automatically sent to vendors. After meeting with a chef for Guckenheimer, an on-site corporate restaurant management company, we were very easily able to pinpoint issues in the maintenance of resource requirement lists. To keep track of their inventory levels, staff had to calculate a list of groceries utilized during a course of time, calculate and analyze the requirements for the future, and place their next order to multiple vendors if needed. This process takes up a lot of time and human effort, and is also prone to human error. The same chef used to be the head chef at Vintage 338, a privately owned Chicago wine bar, where they had the same issues. It became our goal to develop a program that can be used by both large corporations as well as small businesses. This meant the system had to provide an efficient and simple user interface that at the same time is capable of more precise changes and inputs. The system had to also be accurate and reliable in terms of the database design. Since all of the data and data objects are stored in a database, it was imperative that these requirements were met. The basic functionality underlying the system is as follows: chefs can add recipes to the database, which are then broken down to their ingredient level. These ingredients are then tracked by the system and updated with each sale of certain items. Should they reach a predetermined threshold level, the manager is notified and given the option to place an order with the respective vendor. Through the use of a prediction algorithm, the system uses data such as previous sales, future dining events, and special requests to determine order quantities. The manager has control over all factors associated with the system, should they require a change. Certain functional requirements that were brought up during our case study by the chefs included allowing the user to be able to create, delete, and update recipes, ingredients, and vendors as these changed frequently. They also stated that the system must include mechanisms for the manager to approve any outgoing orders in case manual changes needed to be made, as well as allow changes to be made to inventory levels in case of an error.

7

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download