ANLY482 AY1516 G1 Team Skulptors - Change Management
Jump to navigation
Jump to search
 HOME
|
 ABOUT US
|
 PROJECT OVERVIEW
|
 DATA ANALYSIS new!
|
 PROJECT MANAGEMENT
|
 DOCUMENTATION
|
| Project Schedule new! | Work Plan new! | Change Management new! | Risk Management | Team Reflectionnew! |
| Sponsor Requirement Change Log | |||||||
|---|---|---|---|---|---|---|---|
| Date | Milestones | Dataset | Feature | Feature Requirement (Before) | Feature Requirement (After) | Status | Status Description |
| 06 Jan | Before Project Proposal | Cosmetics Brand | Vertical lift | • Determine the type and quantity of SKUs that should be placed for muti level storage • lift space optimization. |
NIL | NIL | NIL |
| A,B,C classification | • Development an algorithmn to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving). | ||||||
| Dashboard | • Develop a dashboard using Tableau for high level visualizatiion of warehouse process. | ||||||
| Warehouse Utilization tool | • To help employees understand fill and flow rate of the warehouse based on historical data, and also, determine pick rate of warehouse locations and identify most used and least used locations. | ||||||
| Application development | • Develop an application for long term sustainability use. This will allow client to continue analyzing new data via a uploading feature, even if the the project is over. | ||||||
| 13 Jan | After Project Proposal | Medical & Duty Free Products (Changed) | Vertical lift | • Determine the type and quantity of SKUs that should be placed for muti level storage, and the lift space optimization. | NIL | Removed | Client wished to change focus too analysis on inbound and outbound data. Concerns was that number of shelves, stories and size of lift have not yet been finalized in the new warehouse. |
| A,B,C classification | • Development an algorithm to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving). | • Use preassigned values to sort SKUs into A,B,C classifications. | Modified | Client wants control over changing the A,B,C classification values as he does not want to waste time asking help from his developers to change the logic of the algorithm. | |||
| Dashboard | • Develop a dashboard using Tableau for high level visualization of warehouse process. | • Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualization of warehouse process. | Modified | Client felt that Tableau was expensive and under the advice of Prof. Kam, the team suggest the use of d3.js, JMP and SAS Enterprise Miner to the client. D3.js will be used as it allows flexibility and customization of application by client. JMP and SAS Enterprise in this case, will be used to gain more in-depth analysis. These cannot be attained by Tableau. | |||
| Warehouse Utilization tool | • Based on historical data, help employees understand fill and flow rate of the warehouse. • Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations. |
NIL | Remain | NIL | |||
| Application development | • Develop an application to integrate with the dashboard. This will allow employees to be able to view the dashboard from various devices like mobile phones. | NIL | Remain | NIL | |||
| 29 Jan | After Project Proposal | Medical & Duty Free Products | A,B,C classification | • Use preassigned values to sort SKUs into A,B,C classifications,based on their rate of movement (fast / slow moving). | • Use preassigned values to sort SKUs into A,B,C classifications,based on their rate of movement (fast / slow moving). • Inclusion of top 20 SKUs for visualization. |
Modified | The client's rationale of including the top 20 SKUs for visualization was because he understands that despite the classification of SKUs, there is still a high probability to have hundreds of categorical "A" SKUs. He would thus like to identify the top best performing SKUs. |
| Dashboard | • Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualizatiion of warehouse process. | NIL | Remain | NIL | |||
| Warehouse Utilization tool | • Based on historical data, help employees understand fill and flow rate of the warehouse. • Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations. |
NIL | Remain | NIL | |||
| Application development | • Develop an application to integrate with the dashboard. This will allow employees to be able to view the dasboard from various devices like mobile phones. | • Develop an application to integrate with the dashboard. This will allow employees to be able to view the dasboard from various devices like mobile phones. • Integration of application with client's database. |
Modified | As the client is looking into the possibility of eliminating the need for frequent upload of data, they would like to explore the possibility of integrating the team's application with the company's database to allow data to be pulled from the client's inhouse WMS. | |||
| 24 Feb | Before Mid-term | Medical & Duty Free Products | A,B,C classification | Use preassigned values to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving). • Inclusion of top 20 SKUs for visualization. |
• Use preassigned values to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving). • Inclusion of top 20 SKUs for visualization. |
Modified | Client would like the team to include some form of authentication for the input fields to ensure that employees will know the correct input format. In addtion, they have requested a search bar to allow them to quickly find out the category of a particular SKU. |
| Dashboard | • Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualization of warehouse process. | • Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualizatiion of warehouse process. • Dashboard to include 3 specific tabs, namely Inbound, Outbound and Warehouse Utilization. | Modified | The client would like to have a dashboard which have specific pages, to view unique details based on their sub-categories. | |||
| Warehouse Utilization tool | • Based on historical data, help employees understand fill and flow rate of the warehouse. • Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations. |
NIL | Remain | NIL | |||
| Application development | • Develop an application to integrate with the dashboard. This will allow employees to be able to view the dashboard from various devices like mobile phones. • Integration of application with client's database. |
• Develop an application to integrate with the dashboard. This will allow employees to be able to view the dashboard from various devices like mobile phones. (Removed) • Integration of application with client's database. (Shifted to Dashboard category) |
Removed | The client felt that it would be a better option to just integrate the dashboard with the company's database, instead of having an application that comes along with it. This is because they are worried that the maintainence of the application might pose as a problem for them once the project ends. | |||
| 22 Mar | After Mid-term | A Medical Brand(Changed) | A,B,C classification | • Use preassigned values to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving). • Inclusion of top 20 SKUs for visualization. |
• Use preassigned values to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving). • Inclusion of top 20 SKUs for visualization. |
Modified | On the advise of Prof. Kam, the team taught the clients on the usage of tree maps, and managed to convince them to implement a treemap. The treemap will be used to depict the A,B,C classification on the dashboard, on top of the intial A,B,C column classification. |
| Dashboard | • Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualizatiion of warehouse process. • Dashboard to include 3 specific tabs, namely Inbound, Outbound and Warehouse Utilization. | • Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualizatiion of warehouse process. • Dashboard to include 3 specific tabs, namely Inbound, Outbound and Warehouse Utilization. |
Modified | The integration together with the client's database was removed due to project time constraint. This will be replaced with a file upload feature on the dashboard to allow the clients to upload warehouse data and view the analyze on the dashboard. Client wanted to include trans code analyzation as they would like to find out amount of inbound SKUs which are returned to suppliers, and the outbound SKUs which are rejected from customers. |
|||
| Warehouse Utilization tool | • Based on historical data, help employees understand fill and flow rate of the warehouse. • Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations. |
NIL | Remain | NIL | |||
