IS480 Team wiki: 2010T1 Cowabunga Scope

From IS480
Jump to navigation Jump to search

Introduction of Warehouse Optimization & Resource Management System

After analyzing the workflow and the key issues experienced. Our team recommend the implementation of ‘Warehouse Optimization and Resource Management System’ (WORMS). The customized system will supports two business tier; the Resource Management business layer and the Warehouse Optimization business layer.

1. The Resource Management System - This layer provide Chee Song with a greater inventory control. Resource Management Layer, supports by the following main modules: 1) Supplier Management Module, 2) Inventory Tracking Module, 3) Reporting Module, 4) Inventory Business Analytics and Forecasting Module.

2. Warehouse Optimization - This layer provide the maximize and optimize the use of the warehouse space. This layer is essentially answering the important decision when dealing with new products: “Where to place this product to optimize and maximum my warehouse space.”

A successful warehouse planning is made when all warehouse space is utilize (pack to the brim) and each product is at the best optimal position based on product’s parameters 1) Turn over rate, 2) Sensitivity. 3) Proximity of similar type of product (Chicken, Beef, Mutton) and 4) AVA status product.

Business analytics and forecast will provide greater view of warehouse utilization and optimization if different products are overstock or purchase. This layer is supported by the following module: 1) Warehouse Addressing Allocation Module, 2) Warehouse Utilization Module, 2) Inventory Optimization Module, 3) Warehouse Utilization Forecast and Simulation Module

Project Topology

The following diagram is a topology of our project, highlighting the different areas as well as the key users that will be using our proposed IT solution. There are three main layers for proposed IT system, namely; Database/Backend Layer, Resource Management Business Layer and Warehouse Optimization layer.

1st Layer: The Backend Database Layer

The foundation of the entire project, the backend layer provides the core support that our software will be working on. Current manual records and information must be plotted into a proper data structure. A proper data structure will be designed and data migration from manual records to our records will be a key stage in our project. Being a web-enabled software, we will also need a proper web-based server to host our software. This may come in a form of dedicated server.

Key consideration would be done to address the following issue: Firewall/Port Configuration, Backup Plan, Multi-party transaction plan, Load Balancing/Clustering Plans.

2nd Layer: Resources Management Business Layer

The resource management layer will allow the company to manage suppliers and the flow of their inventory in the warehouse. The layer consist of the 4 following modules:

a. Suppliers Management Module:

Functionality 1: Suppliers Information Management:
Manages the suppliers information, by allowing the users to store relevant information such as type of brands carry, price of ordering, lead time for delivery, also include overstocking ‘loaning’ price per day.

Functionality 2: Product Catalogue Management:
Manages the supplier’s product range that they carry, including price quotation. The prices varies base on demand basis, this functionalities allows tracking of suppliers product offering with their determined prices and fluctuation over the different ordering time period.

b. Inventory Tracking Module:
a. New Order Form
Manages creation of new order form (from suppliers). This order form is keyed into the system by the boss when a new order is placed. Information recorded are:
1) Supplier

2) Category (Beef, Mutton, Chicken, etc)

3) Type (Wing, Heart, Thigh, etc)

4) Country

5) Brand Name 

6) Quantity Ordered (Carton)
7) Per Carton Weight (KG *May be different in weight)

8) Unit Price Per Kg

9) Total Amount (Calculated)

10) Ordered By

b. Inventory Arrival Form
Once inventory arrive at the warehouse, the warehouse personnel will keep track of each inventory line that is introduced into the warehouse. Each product will need to be updated with the actual quantity delivered, total weight of the entire batch as well as the AVA-status of the product.
Information recorded are:
1) Supplier

2) Category (Beef, Mutton, Chicken, etc)

3) Type (Wing, Heart, Thigh, etc)

4) Country

5) Brand Name 

6) Quantity Ordered (Carton)

7 )Quantity Arrived (Carton)

8) Quantity Did Not Arrive (Optional)

9) Per Carton Weight (KG *May be different in weight)

10) Total Weight

11) Unit Price Per Kg

12) AVA-Status

13) Total Amount (Calculated)

14) Ordered By