1 / 20

Modernizing Inventory Control for Stave & Hoop: A Proposal for Enhanced Efficiency

The proposed inventory control system for Stave & Hoop aims to replace the outdated manual processes with an automated, user-friendly solution. Key features include sales reporting, trend analysis, and integration with vendor deals, which enhance inventory accuracy and efficiency. The system will utilize Wasp technology for scanning and tracking, streamline receiving processes, and offer training support. With a projected break-even point of 3.6 years and an estimated benefit of $14,000 over five years, this upgrade is both economically viable and necessary for improved operations.

tam
Download Presentation

Modernizing Inventory Control for Stave & Hoop: A Proposal for Enhanced Efficiency

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Stave & Hoop Bottle Shop Inventory Control System S.N.S. Systems Riley Schiefelbein, Jason Nicol, Austin Schwai

  2. 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

  3. 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

  4. Benefits of Proposed System • Proposed system: • Provide trend analysis • Daily, weekly, monthly, yearly • Manage vendor information • Incoming price notification • Scannable Inventory

  5. Technical Feasibility • System components • Wasp Point of Sale Starter Kit • Price scanner • Register • Receipt printer • Product scanning software*

  6. 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

  7. Economic Feasibility • Breakdown of one time costs

  8. Economic Feasibility • B.E.P • 3.6 years • Total value of benefits • $14,000 after 5 years

  9. Economic Feasibility • Total cost • Approximately $10,000 • Recurring costs • Approximately $250 a year • Benefits • Reduces labor costs • Improved efficiency

  10. Legal Feasibility • Updating an outdated system • No foreseeable legal issues • Client is established and responsible • Our system is not responsible for ID verification

  11. System Development • Anticipated schedule – about 6 months • Gantt Chart

  12. System Development - DFD • Level - O

  13. System Development - ERD

  14. System Development - Mock Database

  15. System Development - Dialogue Diagram

  16. System Development - Interface

  17. System Development - Interface

  18. Testing & Implementation • During development – ongoing beta testing • “Out with the old, in with the new” • Parallel – “paper now” is exclusive from digital later

  19. 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

  20. Closing Remarks • The proposed inventory system will greatly benefit Stave & Hoop • Better time utilization • More accurate • Relatively inexpensive • Easy implementation

More Related