IS480 Team wiki: 2010T1 Cowabunga
-Welcome to our IS480 wiki page-
- 1 Cowabunga Team Formation
- 2 Company Background and Formation
- 3 Proposed Solution (Scope)
- 3.1 Introduction of Warehouse Optimization & Resource Management System (WORMS)
- 3.2 Topology Diagram
- 3.3 To-Be Work Flow Diagram
- 3.4 1st Layer: Resource Management Business Layer
- 3.5 2nd Layer: Warehouse Optimization Business Layer
- 3.6 Database Design
- 3.7 Technical Aspect of Solution
- 4 Project Management
- 4.1 Project Overview
- 4.2 Detail Breakdown of IS480 Project
- 4.3 Project Meeting Minutes
- 4.4 IS480 Poster
- 4.5 IS480 Algorithm Video
- 4.6 Final Wiki
- 4.7 Assumptions
- 4.8 Risks Involved and Mitigation Strategies
- 4.9 Resources and Reference
- 4.10 Teams Learning Expectations
Cowabunga Team Formation
"Cowabunga!" is a term oftenly use to express surprise, amazement and euphoria.
As the term suggests, our team aims to bring out the true essence of how both IT Intelligence with Business process can bring forth new and suprising ideas. We hope to be able to create something impactful for our clients. As our client's current business process is very manual, we hope that we would be able to surprise them at how our system could aid them and last but not least, amaze them beyond what they expect IT can do.
As a team, "Cowabunga" also represent the fun we hope to have through this FYP - IS480 along with our dedication to provide the best for our sponsors.
In our team logo at the top right corner of the page, you will notice a worm. This represent the inventory system that we are creating that forms , Warehouse Optimization and Resource Management System (W.O.R.M.S).
Team Members (Roles and Responsibilities)
|Project Manager/Liaison Officer||Loh Chong Ghee (Jackson)||
|Business Subject Matter Expert||Ng Kiang Pin||
|Business Analyst||Danny Seow Liang Cong||
|System Analyst||Mohamed Saiful Bin MOHAMED NAJAIB||
|IT Subject Matter Expert||Seetoh Yong Chuen (Lex)||
|Design Architect||Bevan Tan Junming||
|Client/Sponsor||Chee Song Frozen Food Pte Ltd|
|Contact Person||Ms Tan, Manager|
Company Background and Formation
Introduction of Company (Client/Sponsor)
Chee Song Frozen Food Ptd Ltd is a 14 years experienced whole-seller company in Singapore. Being a wholesaler in the frozen food industry, Chee Song is position at the heart of the entire supply chain.
The company has two main stakeholders, namely the suppliers and retailers. Inventory products such as frozen chicken stocks, muttons as well as beef are ordered from the suppliers on a daily/ weekly basis (dependent on products). Different suppliers offers different product range, and their product varies in prices on a daily basis.
The extensive product range and large quantity of orders, plus limited warehouse space, much consideration are taken before finally placing order quantities with the suppliers.
The second major stakeholders of the supply chain would be the retailers. The retailers are the revenue spot of the company, they order from Chee Song wholesaler on a daily basis. The orders are sent to the retailers to complete the full process transaction.
Key Objective and Motivation
Our main role is to understand the current business practice and process of the company, after-which analysis and determine the key issues and root causes of the current process.
Finally, implementing a IT solution that align with their business requirements, while addressing the root causes and delivering the key objective. The key objective set for us by our client is to find a solution that will provide them with greater inventory control and improve the operation efficiency of Chee Song.
Key Objective: Provide greater inventory control and improve the operation of Chee Song.
Situated in Jalan Masjid is the main distribution center. Once the orders are properly assembled, they will be distributed by the company trucks to the various retailers (customers). As inventory in the distribution center is running low, they will send daily request form to the two warehouses to restock the distribution center. Ensuring that there is always sufficient inventory.
There is another two main warehouses that are situated within 5 minutes drive away from the distribution center. This two warehouses stores all the frozen inventory. Each day new containers from the suppliers will arrive and restock the warehouses. Due to the current implementation, there are many issues and high probability of overstocking the warehouses that results in extra expenditure as inventory has to be sent back to the suppliers and kept in the warehouses.
The flow of the process is as followed:
- 1) New orders are made by the boss to individual suppliers
- 2) The suppliers will deliver inventory on stated date to the warehouse
- 3) Retailers will make their daily orders
- 4) The distribution center will consolidate orders and send request form to warehouse
- 5) Warehouse will pack the request order and trucks will arrive to pick them up
- 6) Distribution truck will be sent from the distribution center to individual retailers
Root Cause Issues and Problems
1) Lack of Real-Time Information
Problem Description: One of the key issue is the lack of real-time information such as current quantity in the warehouse, the boss have to contact the admin stuff to retrieve current stock information for individual products. The admin staff subsequently request for updates from the warehouse personnel. This rally of information is time consuming and have a long lag time.
Solution: Our proposed solution must remove the rally of information by allowing real time data to be presented to the users as and when they request. It serves to aid the boss in making better business decision.
Business Impact: Reduce the long processing time, Reduce probability of error propagation.
2) Lack of Data Analytics to Support Business Decision Making
Problem Description: One of the key issue is the lack of intelligent analysis that will enable them to make forecast and planning of their inventory stock products. The current business processes are heavily reliant on manual paper recording. Currently, the boss relies heavily on his instinct, business experience to make decision such as the total quantity of product to restock everyday.
The lack of real time information coupled with no proper data structure result in many decisions that cause overstocking issue. Because the products are frozen and perishable, they must be kept in frozen storage space. That means that overstocked products are turn away back to their suppliers to be stored at their warehouse. The ‘loan’ of storage space is extremely expensive and drive the overall cost of operations.
Solution: Through historical data and transaction of products inflow and outflow, our proposed solution will provide understandable statistics and charts to aid the company boss in making better business decision. Based on the business requirements and current practice of the company, algorithms will be designed to filter and provide information such as “Seasonal Trends”, “Product/Demand Balancing” and “Optimal Product Level to Order”.
Business Impact: Reduce overall holding cost, Improve business decision
3) No Proper Structure or Warehouse Planning Aid
Problem Description: Currently, there have been a serious lack of warehouse planning in the company. The storage planning of the warehouse does not follow a proper structure. The inventory are often stored based on connivence. Every product does not have a designated area.
Furthermore, the warehouse is run be a few key personnel that has been with the company for some time now. Only the few key personnel knows where each inventory is kept, immediate replacement is almost impossible as it would require a lot of orientation to the inventory position. This also means that the store-man may have information such as expiry date or, which products are AVA-approved and which are AVA-Pending, that are not made known to anyone else in the company. Thus the boss does not have inventory control
Solution: Our proposed IT system would provide a digital mapping of the entire warehouse with each individual batch of products being shown on the overview board. The easy graphical overview would allow any new user to locate specific inventory without difficulty. Thus removing the dependency on key personnel that may be crippling in events where they are removed from the company.
Business Impact: Improved shared information, Improve inventory control, Reduced processing time
Proposed Solution (Scope)
Introduction of Warehouse Optimization & Resource Management System (WORMS)
After analyzing the workflow of the company and the key issues experienced. Our team recommend the implementation of ‘Warehouse Optimization and Resource Management System’. The customized system will supports two key business tier, namely; the Resource Management business layer and the Warehouse Optimization business layer.
1. The Resource Management System - allows Chee Song to track each transaction of inflow and outflow of their products from their warehouses, also provides current inventory tracking and status alert. Another important module is the support of business analytics where intelligent graphs, charts and statistics will be populated to aid business decision making for restocking inventory.
2. Warehouse Optimization - a smart and intelligent recommendation of warehouse optimization for Chee Song. Our team will be utilizing matching algorithm to facilitate optimization and maximization of proper address and product assignment.
Our main deliverables to our client is to finally able to develop a warehouse optimization and resource management system that will enable them to solve the root cause that they are facing with the current business processes.
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 two main layers for proposed IT system: Resource Management Business Layer, Warehouse Optimization layer.
- The Proprietor (boss)
- Warehouse Personnel
- Distribution Center Agent
- Admin Staff Agent
To-Be Work Flow Diagram
1st Layer: Resource Management Business Layer
2nd Layer: Warehouse Optimization Business Layer
Technical Aspect of Solution
- Oracle 10g Lite Database
- Apache Tomcat Webserver
- Web Browser (Internet Explorer 8 and Modzilla Firefox 3 with relevant plugins)
- Adobe Flash Plugin Version 10,1,53,64
- Java Runtime Environment Version 6 Update 14
- Adobe Flash Plugin Version 10,1,53,64
Application Development Support
- JDK Update 20 with documentations
- IDE (Either OR / Choose One Yet to be decided)
- Eclipse Ganymede(3.4) or Galileo (3.5)
- Eclipse Ganymede(3.4) or Galileo (3.5)
- Notepad ++
- Adobe SDK (AIR, Flash, Flex) with Flash Builder
Documentation Development Support
- Microsoft Office 2007
- UML Modeling
Document Sharing Support
- Windows Live
- Microsoft Outlook
- Server: Apache
- Client: Tortoise
- Server: Apache
Detail Breakdown of IS480 Project
Project Meeting Minutes
IS480 Algorithm Video
- The sponsor will be providing the necessary hardware requirement for the implementation of our software based on a certain budget.
- Software will be customize from scratch based on sponsor’s requirements
- Risk exposure is minimal as team has identified the required hardware that builds on client existing infrastructure.
Risks Involved and Mitigation Strategies
|Risk Description||Level||Mitigation Strategy||Current Status of Risk||Remarks|
|Newly identified exceptions that require time for analysis and addition to development to ensure that these exceptions are handled properly. This will cause delay in schedule as time is needed to figure out the best way to handle the exceptions.||5||
|Methodologies pre-defined for the translation of certain business requirements may be too challenging and undoable due to team’s limited knowledge on the technology.||5||
|Group Members are caught up with other commitments and assignment/project submissions, thus is unable to deliver work on time.||4||
|Group member have problems with the coding and is unable to continue, thus unable to deliver the project on time.||4||
|Client responses are slow, which result in delay in data collection necessary for certain modules. Clients may respond slow as they do not fully understand what form of data we require.||4||
|Sudden changes requested by client which will cause a delay in the project deadline.||5||
||Risk Remains||Changes are still expected along the way. As such we have to make sure that mitigation is carried out to reduce the impact of the changes.|
|Unavailability of group members resulting in short handedness and miscommunication.||2||
||Risk Remains||Mitigation still necessary as project is still ongoing.|
|Loss of business documents and data collected.||1||
||Risk Remains||It is still highly important to ensure that backups are done daily and that all members are to store their daily work in the svn to prevent detrimental effects of reworking due to loss of work documents and codes in the case of any scenario.|
|The difficulty/severity of bugs is underestimated which might delay the project progress.||3||
||Risk level reduced.
|Code review is done every meeting. UAT testing is also conducted constantly after completion of each module to identify exceptions and bugs.|
|Graphic User Interface is not user friendly for the clients might have constant changes which will delay the project.||1||
||Risk level reduced.
|Have conducted UAT constantly with our clients and received feedback that the user interface is friendly and comfortable for use.
Will also be creating a user manual for the clients when the software is completed.
|Unable to communicate with warehouse personnel due to language barrier.||1||
||Risk level reduced.
|Mitigation still necessary as project is still ongoing. Communication with the Warehouse Personnel is still required. However, all important business requirements have been gathered and confirmed already, thus remaining communication is mostly on acceptance of the software and thus will not lead to high impact due to changes to the business requirements.|
|Team is unfamiliar with Adobe flex which might cause delays in project development.||3||
||Risk mitigated and removed.||Members have picked up the necessary basics of flex.|
|Team might not meet the industry requirements and government standards for meat processing and cold storage.||3||
||Risk mitigated and removed.||Team has read up on the AVA regulations and is clear about the regulations.
Have verified all algorithms and methods with client that they do not infringe the regulations.
|Lack of deep knowledge of warehousing operations practices.||3||
||Risk mitigated and removed.||Have had many meetings with the clients and also did a lot of research on warehouse operations. Team is currently updated with the necessary knowledge on warehousing for our project. This is removed because we have had sufficient analysis on the warehouse before getting down to the development phase. This prevents the need for changes during development phase due to misunderstanding of the operations.|
Resources and Reference
|Resources||Reasons for resources/Alternative Resources|
|Client Side||Router/Switch, preferably with wireless capability||• Their current wired connection has already been maxed out.
• Server in placed needs to have internet connection or at least be connected to their local area network.
|Dedicated Server/Machine to deploy our developed solution||• If not possible, use Ms Tan PC, since it is always on and connected.|
|Our Side||Dedicated Server/Machine to develop our solution just like the client’s.||• This allows us to carry out testing of our solution
• To function as the SVN location to allow easy sharing of work files, documentations and schedules.
|Client Time||2 Hours on ad-hoc Basic as and when required.||• To clarify development doubts.|
• To analyze the warehouse process more closely.
|Supervisor Time||Fortnightly 30-60 mins per meeting||• To seek advice, clarify deliverables doubts, and to be sure that we are on the right track|
|Training Time||1 week or 7 Days/Lesson or less||• As some of our members are unfamiliar with the development tools(Adobe Flex and Flash), there is a need for us to spend some time to pick up the necessary and sufficient skills required for the development. This ensures to get everyone involved in part of the development and also to expose everyone to newer development platforms through the project.|
Training Materials Required for Development
and any other online tutorials that we come across during our research.
Teams Learning Expectations
Learning Outcomes to be Acheived
Given the scale of this project, the team hopes to achieve the following learning outcomes from the project:
- To conduct feasibility studies on an existing business through analysis and design to make appropriate recommendations
- To learn more about the best practice and industry knowledge of warehouse management and supply chain management.
- To make appropriate recommendations and to create ideal solutions based on client’s requirements to automation of an existing manual business process.
- To learn team management required to deliver our project management and software lifecycle
- To learn how to bridge the gaps between user requirements and what the client’s business really needs.
- To pick up new knowledge that build on our foundations of programming like Adobe Flex.
- To learn how to translate and manage real-world project for a client, by addressing their companies root cause.
- To challenge the team and hardness the concepts that we learn in class into a real world business scenario.
- To convert business decisions into mathematical formulas (algorithms) to help in providing recommendations given the constraints.
- To convince our client of the need to progress and upgrade system as companies with slightly experienced workers tend to be resistant to changes and the use of computers.
- To analyze possible impacts caused by the changes made to the business processes and how to mitigate the negative impacts.
- To learn how to manage effort needed for the various proposed ideas and how to rescope it to fit project and client's requirements.