Warehouse Management System: SDLC Document

[Pages:17]Prepared for: Dr. Thom Luce MIS 400 course

Warehouse Management System: SDLC Document

Order Receiving

Prepared by: Brandon Barkley, Bryan Platek, John Petro, and Aaron Linder

November 11, 2011

Warehouse Management System: SDLC Document

Order Receiving

Table of Contents

Current State Analysis..................................................................................................................... 2

System Overview ...................................................................................................................................... 2 As-Is Use Case Diagram ........................................................................................................................... 4 As-Is Process Flows .................................................................................................................................. 5 Known Issues List..................................................................................................................................... 6

Requirements Definition ................................................................................................................. 7

To-Be Use Case Diagram ......................................................................................................................... 7 To-Be Process Flows ................................................................................................................................ 8 Risk Assessment ....................................................................................................................................... 9

Application Design ........................................................................................................................... 10

Functional Design Write-up.................................................................................................................... 10 Site Map .................................................................................................................................................. 11 Screen Prototypes.................................................................................................................................... 12 Database Design (ERD) .......................................................................................................................... 16

1|Page

Warehouse Management System: SDLC Document

Order Receiving

Current State Analysis

System Overview

The client for the project is interested in receiving an upgrade for their warehouse management system. The mission of the project is to modernize, increase efficiency and reduce errors that take place in their supply chain system. Currently the clients are using a fax based system to send and receive orders. This system is crucial to the company because they need it to receive parts that are required in their product. The company is looking to modernize this system and move their records into a database. Their reason for wanting to do this is because currently they are experiencing manual errors caused by employees. They would like for us to increase processing speed, reduce errors and create more standardization.

The warehouse management system within the company is broken down into three different divisions. The first division is order placement (OP) which is where they will create orders, receive missing orders, reorder missing orders and send orders to be recorded. This division is used mostly at their assembly plant that is used to build vehicles. The clients would like this system to be able to order multiple products in multiple quantities as a single order. They currently have been having issues with order fulfillment and would like the ability to list previous orders that were either damaged or missing with the capacity to reorder them along with other items that have not been recently purchased. They would also like to be able to review order totals and have the power to edit their line items.

The second division in their warehouse management system is order fulfillment (OF). In this division they receive order information from order placement and store it on their data base. After that the products are placed onto pallets and then are identified by their RFID tags. Finally as the pallets are shipped out an Advanced Shipping Notice (ASN) is then sent to the third division. In this area of the warehouse management system they would like the ability to view received orders and to be able to pack multiple orders on a single pallet. They would like to be able to do this because they follow the business accounting rule of first in first out (FIFO) for their inventory. The clients also need to be able to have more control over what pallets are being shipped and the details of the order. They stress that the order fulfillment division must follow what they call the Pack Three rule. This means that for every shipment they must pack at least three line items into a pallet and at least three pallets to a shipment.

The final division of our client's warehouse management system is order receiving (OR). This division is used for receiving orders of parts for their automobiles. They will simulate the delivery of the products by using a RFID scanner. This information is then entered into the data

2|Page

Warehouse Management System: SDLC Document

Order Receiving base and will update the order placement division on the status of the order that was placed. In this area of the warehouse system the clients would like to have the capability of using the RFID to update current statuses at the shipping dock. They would also like the RFID to be able to show if an order is missing or damaged. The issues that our client has been experiencing are causing them to slow down their business and become less efficient. When we are done with the project we will have resolved most of their issues by modernizing their technology. This technology will help aid them in being more organized and efficient through the use of the databases we created. It will also help resolve the manual errors that are occurring within the company because of the massive paper trail their current fax based system is causing. Our goal for this project is to resolve all the issues surrounding the current system while at the same time improving the functionality of our clients company.

3|Page

Warehouse Management System: SDLC Document

Order Receiving

As-Is Use Case Diagram

Place New Order

Fax Invioce to Supplier

Fufill Orders from OP

Purchaser (Order Placement)

Reorder Missing/Damaged Items

Send Order to Warehouse

Supplier (Order Fulfillment)

Fax Missing/Damaged Items Notification

Review Shipment Contents

Recieve Order

Warehouse (Order Receiving)

4|Page

Warehouse Management System: SDLC Document

Order Receiving

As-Is Process Flows

Purchasing

Ready to order item(s)

Fulfillment

Receiving

Order Faxed

Order Recieved Order Processed

Refax Order of Missing/Damaged

Are supply quantities sufficient for

order?

[[no]] Order Pending

[[yes]]

Order Packaged

Receive Shipment Notice

Order Shipped Send Shipment Notice

Order Recieved Review Content of Order

Do the received

items match

the invoice?

Notify of Damaged or Missing Items

[[no]] [[yes]]

Order Complete

5|Page

Warehouse Management System: SDLC Document

Order Receiving

Known Issues List

Outdated technology o Current fax based management system is cumbersome and is inefficient Often responsible for causing manual errors and slow processing speeds Lacks the ability of error control and ability to detect delays on parts All data and information is saved on paper, there is so much paper it has become more difficult to store it, organize or track files

Lack of a centralized information system that automatically inputs and updates order information in database

Inability to list ordered items that never got fulfilled and reorder them with other new items Inability to review the total of an order or change quantities or remove items from an order Lack of the ability to review data about previous shipments that have been moved on to OR There is no way to review shipments and their contents or confirm status of the LineItems

6|Page

Warehouse Management System: SDLC Document

Order Receiving

Requirements Definition

To-Be Use Case Diagram

Purchaser (Order Placement)

Reorder Missing/ Damaged Items

Create Order

Send Order Status Update

Enter into database/ update statuses

Review Shipment Contents

Scan RFID's

Warehouse (Order Receiving)

Send Order

Recieve Order Ship Product & ASN

Fulfill Order

Ship Order to Warehouse

Supplier (Order Fulfillment)

7|Page

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

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

Google Online Preview   Download