Efficient Electronic Inventory System for Venetian Marble & Granite

1. Inventory Group Marcus Jameson, Evan Sheline, Jeff Stine, Michael Breitweiser, Spencer Hill Dr. Giolma – Advisor Tony Franckowiac - Sponsor

2. Venetian Marble and Granite is a local manufacturer of countertops for residential and commercial building projects. • Each piece is designed and manufactured to custom specifications. • Their largest division molds synthetic marble countertops. Introduction

3. Venetian wanted: • a way to mark each piece during production for tracking. • a computer database which stored info for each piece: • dimensions • color • location • a way to identify a piece easily on the production floor and during delivery truck loading. • notes • stage in production • work order number Problem Description

4. Official constraint statement from charter drafted in the fall: “The solution is constrained by the budget and should be able to withstand any conditions encountered in the manufacturing process.” Constraints

5. Provide a maintainable electronic database for all inventory • According to the capabilities of the chosen database, it will contain information in the problem description Constraints – Project Objectives

6. Supply a means to track all pieces through manufacturing, storage, and delivery. • Each piece will have a unique identifier linking it to the electronic database which is installed as early as possible in manufacturing Constraints – Project Objectives

7. 4 design elements • New work order numbering scheme • Adhesive Labels • Clipboard check in/out stations • Access database Final Design

8. New numbering scheme • _ _ - _ _ _ _ • First two digits correspond to year • Last four correspond to the number of work orders that year • Ex: “10-0148” year 2010, 148th order Final Design – New Numbering Scheme

9. Paper work order  Stickers on each piece • The same basic information from the old work orders will be on the new labels. Final Design - Labels

10. Final Design - Labels

11. Clipboard stations will now be used as check in/check out points • Sheets will be collected at the end of the day to update the database. Final Design – Clipboard Stations

12. The database consists of several parts: • Tables, which store the raw data. • Forms, which present the information in an easy-to-read fashion. • Reports, which show only relevant information for a specific task and are based on a query. Final Design – Access Database

13. Final Design – Access Database Form

14. Average Weight Report for a given date range. • Work Order Summary for a given work order. Final Design – Access Database Reports

15. Prototypes were brought to Venetian • Database system • Stickers • User Manual • Clipboard • Feedback was collected • Revisions were made • Final product reached Testing

16. Looking back at the criteria for the project: • The database stores all necessary information and then some. • It is capable of tracking multiple work orders and multi-piece work orders. • Feedback from David suggests the system is much simpler to use than the current Q&A software. • The new work order numbering scheme provides a unique and logical identifier linking a piece to the database. • Access is much more maintainable than the outdated software Venetian currently uses. Evaluation

17. Main objectives have been accomplished. • Only small adjustments in the workers’ routines. • Effective and efficient for Venetian’s needs. • Under budget. • We recommend Venetian expand the database. • With production expansion, integrate barcodes. Conclusion

18. Source: http://www.flickr.com/photos/doberagi/1404539812/ Questions?

19. We would like to thank: Faculty Advisor: Dr. Giolma Senior Design Professor: Dr. Nickels Contacts at Venetian: Tony Franckowiac David Allen