Difference between revisions of "ANLY482 AY1516 G1 Team Skulptors - Change Management"
(7 intermediate revisions by the same user not shown) | |||
Line 19: | Line 19: | ||
<!--Sub Navigation--> | <!--Sub Navigation--> | ||
{|style="background-color:#ffffff; color:#000000; font-size:10pt" padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"| | {|style="background-color:#ffffff; color:#000000; font-size:10pt" padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"| | ||
− | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Project Management |<font color="#005ae6"><b>Project Schedule </b></font>]] | + | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Project Management |<font color="#005ae6"><b>Project Schedule </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]] |
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Work Plan |<font color="#005ae6"><b>Work Plan </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]] | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Work Plan |<font color="#005ae6"><b>Work Plan </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]] | ||
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Change Management |<font color="#000a1a"><b>Change Management </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]] | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Change Management |<font color="#000a1a"><b>Change Management </b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]] | ||
|style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Risk Management |<font color="#005ae6"><b>Risk Management</b></font>]] | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Risk Management |<font color="#005ae6"><b>Risk Management</b></font>]] | ||
+ | |||
+ | |style="padding:0.4em; text-align:center; border-top:1px solid #ffffff; border-bottom:1.5px solid #005ae6; " width="10%" | [[ANLY482 AY1516 G1 Team Skulptors - Team Reflection |<font color="#005ae6"><b>Team Reflection</b></font><sup><font style="font-size:80%" color="#ff0000">new!</font></sup>]] | ||
|} | |} | ||
Line 37: | Line 39: | ||
<td rowspan=5 >Cosmetics Brand</td> | <td rowspan=5 >Cosmetics Brand</td> | ||
<td>Vertical lift</td> | <td>Vertical lift</td> | ||
− | <td>Determine the type and quantity of SKUs that should be placed for muti level storage | + | <td>• Determine the type and quantity of SKUs that should be placed for muti level storage<br/>• lift space optimization.</td> |
<td rowspan=5 align="center">NIL</td> | <td rowspan=5 align="center">NIL</td> | ||
<td rowspan=5 align="center">NIL</td> | <td rowspan=5 align="center">NIL</td> | ||
Line 44: | Line 46: | ||
<tr> | <tr> | ||
<td>A,B,C classification</td> | <td>A,B,C classification</td> | ||
− | <td>Development an algorithmn to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).</td> | + | <td>• Development an algorithmn to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Dashboard</td> | <td>Dashboard</td> | ||
− | <td>Develop a dashboard using Tableau for high level visualizatiion of warehouse process.</td> | + | <td>• Develop a dashboard using Tableau for high level visualizatiion of warehouse process.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Warehouse Utilization tool</td> | <td>Warehouse Utilization tool</td> | ||
− | <td>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.</td> | + | <td>• 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.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Application development</td> | <td>Application development</td> | ||
− | <td>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.</td> | + | <td>• 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.</td> |
</tr> | </tr> | ||
<tr><td rowspan=5 align="center">13 Jan</td> | <tr><td rowspan=5 align="center">13 Jan</td> | ||
<td rowspan=5>After Project Proposal</td> | <td rowspan=5>After Project Proposal</td> | ||
− | <td rowspan=5>Medical & Duty Free Products</td> | + | <td rowspan=5><font color="red">Medical & Duty Free Products (Changed)</font></td> |
<td>Vertical lift</td> | <td>Vertical lift</td> | ||
− | <td>Determine the type and quantity of SKUs that should be placed for muti level storage, and the lift space optimization.</td> | + | <td>• Determine the type and quantity of SKUs that should be placed for muti level storage, and the lift space optimization.</td> |
<td align="center">NIL</td> | <td align="center">NIL</td> | ||
<td align="center"><font color="#ff0000">Removed</font></td> | <td align="center"><font color="#ff0000">Removed</font></td> | ||
Line 70: | Line 72: | ||
<tr> | <tr> | ||
<td>A,B,C classification</td> | <td>A,B,C classification</td> | ||
− | <td>Development an algorithm to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).</td> | + | <td>• Development an algorithm to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).</td> |
− | <td align="center">Use preassigned values to sort SKUs into A,B,C classifications.</td> | + | <td align="center">• Use preassigned values to sort SKUs into A,B,C classifications.</td> |
<td align="center"><font color="#ff8000">Modified</font></td> | <td align="center"><font color="#ff8000">Modified</font></td> | ||
<td><font color="#ff8000">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.</font></td> | <td><font color="#ff8000">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.</font></td> | ||
Line 77: | Line 79: | ||
<tr> | <tr> | ||
<td>Dashboard</td> | <td>Dashboard</td> | ||
− | <td>Develop a dashboard using Tableau for high level visualization of warehouse process.</td> | + | <td>• Develop a dashboard using Tableau for high level visualization of warehouse process.</td> |
− | <td>Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualization of warehouse process.</td> | + | <td>• Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualization of warehouse process.</td> |
<td align="center"><font color="#ff8000">Modified</font></td> | <td align="center"><font color="#ff8000">Modified</font></td> | ||
<td><font color="#ff8000">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.</font></td> | <td><font color="#ff8000">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.</font></td> | ||
Line 84: | Line 86: | ||
<tr> | <tr> | ||
<td>Warehouse Utilization tool</td> | <td>Warehouse Utilization tool</td> | ||
− | <td>Based on historical data, help employees understand fill and flow rate of the warehouse.<br/>Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations.</td> | + | <td>• Based on historical data, help employees understand fill and flow rate of the warehouse.<br/>• Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations.</td> |
<td align="center">NIL</td> | <td align="center">NIL</td> | ||
<td align="center"><font color="green">Remain</font></td> | <td align="center"><font color="green">Remain</font></td> | ||
Line 91: | Line 93: | ||
<tr> | <tr> | ||
<td>Application development</td> | <td>Application development</td> | ||
− | <td>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.</td> | + | <td>• 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.</td> |
<td align="center">NIL</td> | <td align="center">NIL</td> | ||
<td align="center"><font color="green">Remain</font></td> | <td align="center"><font color="green">Remain</font></td> | ||
Line 101: | Line 103: | ||
<td rowspan=4>Medical & Duty Free Products</td> | <td rowspan=4>Medical & Duty Free Products</td> | ||
<td>A,B,C classification</td> | <td>A,B,C classification</td> | ||
− | <td>SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).</td> | + | <td>• Use preassigned values to sort SKUs into A,B,C classifications,based on their rate of movement (fast / slow moving).</td> |
− | <td align="center"><font color="#ff8000"> | + | <td>• Use preassigned values to sort SKUs into A,B,C classifications,based on their rate of movement (fast / slow moving). <br/>• Inclusion of top 20 SKUs for visualization.</td> |
− | <td><font color="#ff8000"> | + | <td align="center"><font color="#ff8000">Modified</font></td> |
+ | <td><font color="#ff8000">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. </font></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Dashboard</td> | <td>Dashboard</td> | ||
− | <td> | + | <td>• Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualizatiion of warehouse process.</td> |
− | <td | + | <td align="center">NIL</td> |
− | <td rowspan= | + | <td align="center"><font color="green">Remain</font></td> |
+ | <td align="center">NIL</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>Warehouse Utilization tool</td> | ||
+ | <td>• Based on historical data, help employees understand fill and flow rate of the warehouse.<br/>• Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations.</td> | ||
+ | <td align="center">NIL</td> | ||
+ | <td align="center"><font color="green">Remain</font></td> | ||
+ | <td align="center">NIL</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>Application development</td> | ||
+ | <td>• 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.</td> | ||
+ | <td>• 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.<br/>• Integration of application with client's database.</td> | ||
+ | <td align="center"><font color="#ff8000">Modified</font></td> | ||
+ | <td><font color="#ff8000">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.</font></td> | ||
+ | </tr> | ||
+ | |||
+ | |||
+ | |||
+ | <tr><td rowspan=4 align="center">24 Feb</td> | ||
+ | <td rowspan=4>Before Mid-term</td> | ||
+ | <td rowspan=4>Medical & Duty Free Products</td> | ||
+ | <td>A,B,C classification</td> | ||
+ | <td>Use preassigned values to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).<br/>• Inclusion of top 20 SKUs for visualization.</td> | ||
+ | <td>• Use preassigned values to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).<br/> | ||
+ | • Inclusion of top 20 SKUs for visualization.<br/> | ||
+ | • Inclusion of input authentication for A,B,C classification value input.<br/> | ||
+ | • Inclusion of search feature for SKU.</td> | ||
+ | <td align="center"><font color="#ff8000">Modified</font></td> | ||
+ | <td><font color="#ff8000">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.</font></td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td>Dashboard</td> | ||
+ | <td>• Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualization of warehouse process.</td> | ||
+ | <td>• Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualizatiion of warehouse process.<br/> | ||
+ | • Dashboard to include 3 specific tabs, namely Inbound, Outbound and Warehouse Utilization.<br/> | ||
+ | • Integration of application with client's database. (Shifted from Application development category) | ||
+ | <td align="center"><font color="#ff8000">Modified</font></td> | ||
+ | <td align="center"><font color="#ff8000">The client would like to have a dashboard which have specific pages, to view unique details based on their sub-categories.</font></td> | ||
</tr> | </tr> | ||
+ | |||
<tr> | <tr> | ||
<td>Warehouse Utilization tool</td> | <td>Warehouse Utilization tool</td> | ||
− | <td> | + | <td>• Based on historical data, help employees understand fill and flow rate of the warehouse.<br/> |
+ | • Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations.</td> | ||
+ | <td align="center">NIL</td> | ||
+ | <td align="center"><font color="green">Remain</font></td> | ||
+ | <td align="center">NIL</td> | ||
</tr> | </tr> | ||
+ | |||
<tr> | <tr> | ||
<td>Application development</td> | <td>Application development</td> | ||
− | <td>Develop an application | + | <td>• 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. <br/> |
− | <td align="center"><font color="# | + | • Integration of application with client's database.</td> |
− | <td><font color="#ff8000"> | + | <td>• 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)<br/> |
+ | • Integration of application with client's database. (Shifted to Dashboard category)</td> | ||
+ | <td align="center"><font color="#ff0000">Removed</font></td> | ||
+ | <td><font color="#ff8000">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.</font></td> | ||
+ | </tr> | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | <tr><td rowspan=3 align="center">22 Mar</td> | ||
+ | <td rowspan=3>After Mid-term</td> | ||
+ | <td rowspan=3><font color="red">A Medical Brand(Changed)</font></td> | ||
+ | <td>A,B,C classification</td> | ||
+ | <td>• Use preassigned values to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).<br/> | ||
+ | • Inclusion of top 20 SKUs for visualization.<br/> | ||
+ | • Inclusion of input authentication for A,B,C classification value input.<br/> | ||
+ | • Inclusion of search feature for SKU.</td> | ||
+ | <td>• Use preassigned values to sort SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving).<br/> | ||
+ | • Inclusion of top 20 SKUs for visualization.<br/> | ||
+ | • Inclusion of input auhentication for A,B,C classification value input.<br/> | ||
+ | • Inclusion of search feature for SKU.<br/> | ||
+ | • Inclusion of Treemaps for visualization.</td> | ||
+ | <td align="center"><font color="#ff8000">Modified</font></td> | ||
+ | <td><font color="#ff8000">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.</font></td> | ||
</tr> | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td>Dashboard</td> | ||
+ | <td>• Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualizatiion of warehouse process.<br/> | ||
+ | • Dashboard to include 3 specific tabs, namely Inbound, Outbound and Warehouse Utilization.<br/> | ||
+ | • Integration of application with client's database. (Shifted from Application development category) | ||
+ | <td>• Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualizatiion of warehouse process.<br/> | ||
+ | • Dashboard to include 3 specific tabs, namely Inbound, Outbound and Warehouse Utilization.<br/> | ||
+ | • Integration of application with client's database. (Removed)<br/> | ||
+ | • Dashboard to include analyzation of all transcode in both inbound and outbound data.<br/> | ||
+ | • Inclusion of file upload feature.</td> | ||
+ | <td align="center"><font color="#ff8000">Modified</font></td> | ||
+ | <td align="center"><font color="#ff8000">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.<br/>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.</font></td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td>Warehouse Utilization tool</td> | ||
+ | <td>• Based on historical data, help employees understand fill and flow rate of the warehouse.<br/> | ||
+ | • Based on historical data, determine pick rate of warehouse locations to identify most used and least used locations.</td> | ||
+ | <td align="center">NIL</td> | ||
+ | <td align="center"><font color="green">Remain</font></td> | ||
+ | <td align="center">NIL</td> | ||
+ | </tr> | ||
+ | |||
</table> | </table> | ||
<br/> | <br/> | ||
<!--End of Content--> | <!--End of Content--> |
Latest revision as of 04:30, 16 April 2016
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
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 |