1 / 20

PART’s R US Presented BY:

PART’s R US Presented BY:. William Toups Erica Gordon Josh Wilson Eric Williams. Project Sponsor. William Gates President of Part’s R Us partsrus@yahoo.com.

wilson
Download Presentation

PART’s R US Presented BY:

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. PART’s R USPresented BY: William Toups Erica Gordon Josh Wilson Eric Williams

  2. Project Sponsor • William Gates • President of Part’s R Us • partsrus@yahoo.com

  3. Who We AreParts R Us is a Houston based computer parts vendor dedicated to providing computer hardware to local businesses.Hardware parts include: • Motherboards • Hardrive’s • Memory • Power supplies • Modems • Sound cards • Video cards • CPU or processor • Monitors • Keyboards • Mouse • Speakers • CDRom’s / DVD Rom’s • Zip Drives • Network Nic Cards • Cables

  4. Business Problem Parts R Us is in need of a computer based system to keep track of all inventory parts, sales, and provide the inability to generate customer reports, monthly reports and year end reports. Due to the growth of the company the paper based system is outdated and the company is falling behind on customers demands for products.

  5. Proposed Business Solution Develop a new system that will allow employees to perform the following: • Enter new parts into the inventory. • Easily locate stock parts located in company warehouse. • Generate monthly/yearly sales reports for management • Generate reports for end of year tax preparation.

  6. REQUIREMENTS • Forms • Number of Forms - 5 • Number of Reports - 3

  7. Requirements - continued • Hardware • Server • Desktop PC(s) • Printer(s) • High Speed Connection (Internet) • Firewall

  8. Requirements - continued

  9. Form Hierarchy • Customer Form • Customer Data • Inventory Form • Inventory data • Management Form • Customer Reports • Sales Reports

  10. Reports hierarchy • Inventory Report • Part Number>Product>Price • Monthly Sales Report • Part Number>Product>Price> Monthly Total • Yearly Sales Report • Part Number>Product>Price>Yearly Total • Customer Orders Report • Account Number>Customer name>Address>Phone number>Email>Total Sales

  11. Opening Screen • Employee logs in with Username and Password • Employees can reset Password if necessary

  12. Main Menu • Employee options • Enter Customer Information • Enter new Inventory • Management - Run Sales/Customer Reports

  13. Customer Information Form • Update Information for new customers • Add new customers • Delete Customers

  14. Inventory Form • List / Print Specific Hardware Parts • List / Print all Hardware Parts • Enter Inventory

  15. Reports Form • Monthly / Yearly Sales • Customer Individual Sales

  16. Program design

  17. File design

  18. File design

  19. Database design • Database designed for end user (employee) to log in and input pertinent information regarding customer (account number, name, address, phone number, etc.) and information regarding product line (part number, part & price)

  20. Comments Any Questions ???

More Related