stave & hoop bottle shop
DESCRIPTION
Stave & Hoop Bottle Shop. Inventory Control System S.N.S. Systems Riley Schiefelbein, Jason Nicol, Austin Schwai . Stave and Hoop Background. Current inventory system: Outdated Manual pricing No automation Inventory checked annually Receiving inventory is time consuming and inefficient - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/1.jpg)
Stave & Hoop Bottle ShopInventory Control System
S . N . S . S y s t e m sR i l e y S c h i e f e l b e i n , J a s o n N i c o l , A u s t i n S c h w a i
![Page 2: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/2.jpg)
Stave and Hoop Background Current inventory system:
Outdated Manual pricing No automation Inventory checked annually Receiving inventory is time consuming and inefficient
(as a result) On-hand inventory lacks accuracy Annual inventory counts are time consuming
![Page 3: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/3.jpg)
Benefits of Proposed System Proposed system:
Provide sales reports▪ Daily, weekly, monthly, yearly
Suggested markup price calculator 10% random inventory check (monthly) Integration with monthly vendor deals
▪ Compare past and present deals
![Page 4: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/4.jpg)
Benefits of Proposed System
Proposed system: Provide trend analysis
▪ Daily, weekly, monthly, yearly Manage vendor information Incoming price notification Scannable Inventory
![Page 5: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/5.jpg)
Technical Feasibility
System components Wasp Point of Sale Starter Kit
▪ Price scanner▪ Register▪ Receipt printer▪ Product scanning software*
![Page 6: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/6.jpg)
Technical Feasibility
System components Customized desktop computer
▪ Windows Vista – Business Edition▪ 20 inch LCD monitor
Additional Wasp pre-printed labels S.N.S. Systems customized business
software
![Page 7: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/7.jpg)
Economic Feasibility
Expense Additional Information Total Cost
Labor 390 hours * $20.00 an hour $7,800Desktop Computer 1 TB HDD, 4GB RAM, 3.0gHz Dual Core
processor $600
Monitor Compact 20” viewing area $150Windows Vista Business
64-bit edition $150
Wasp POS USB Starter Kit
Software, scanner, drawer $1,000
Wasp pre-printed labels
1000 1”x 2” labels $150
Total $9850
Breakdown of one time costs
![Page 8: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/8.jpg)
Economic Feasibility
B.E.P 3.6 years
Total value of benefits $14,000 after
5 years0 1 2 3 4 5 6
$- $2,000 $4,000 $6,000 $8,000
$10,000 $12,000 $14,000 $16,000
Break-Even Anal-ysis
Benefit Cost
Years
![Page 9: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/9.jpg)
Economic Feasibility
Total cost Approximately $10,000
Recurring costs Approximately $250 a year
Benefits Reduces labor costs Improved efficiency
![Page 10: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/10.jpg)
Legal Feasibility
Updating an outdated system No foreseeable legal issues Client is established and responsible Our system is not responsible for ID
verification
![Page 11: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/11.jpg)
ID Task Name Start Finish DurationMay 2009 Jun 2009 Jul 2009 Aug 2009 Sep 2009 Oct 2009
5/3 5/10 5/17 5/24 5/31 6/7 6/14 6/21 6/28 7/5 7/12 7/19 7/26 8/2 8/9 8/16 8/23 8/30 9/6 9/13 9/20 9/27 10/4 10/11 10/18
1 3w5/21/20095/1/2009Gather Information
2 2w6/4/20095/22/2009Report Layout
3 5w6/25/20095/22/2009GUI Design
4 6w8/6/20096/26/2009Purchase Database Design
5 6w8/6/20096/26/2009Vendor Database Design
6 7w9/24/20098/7/2009Programming
7 4w10/22/20099/25/2009Testing
8 3w10/15/20099/25/2009User Documentation
9 1w10/29/200910/23/2009Installation
System Development
Anticipated schedule – about 6 months Gantt Chart
![Page 12: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/12.jpg)
System Development - DFD
Level - O
![Page 13: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/13.jpg)
System Development - ERD
![Page 14: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/14.jpg)
System Development - Mock Database
![Page 15: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/15.jpg)
System Development - Dialogue Diagram
![Page 16: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/16.jpg)
System Development - Interface
![Page 17: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/17.jpg)
System Development - Interface
![Page 18: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/18.jpg)
Testing & Implementation During development – ongoing beta
testing “Out with the old, in with the new” Parallel – “paper now” is exclusive
from digital later
![Page 19: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/19.jpg)
User Training and Support About one week for training
User will be provided with detailed documentation
Phone support will be available Each employee will be given a
walkthrough
![Page 20: Stave & Hoop Bottle Shop](https://reader031.vdocuments.us/reader031/viewer/2022020308/56816974550346895de15057/html5/thumbnails/20.jpg)
Closing Remarks
The proposed inventory system will greatly benefit Stave & Hoop Better time utilization More accurate Relatively inexpensive Easy implementation