Difference between revisions of "ANLY482 AY1516 G1 Team Skulptors - Change Management"
Jump to navigation
Jump to search
Line 32: | Line 32: | ||
<table rules="all" width="98%" cellpadding="6" cellspacing="3" style="margin: 1em auto 1em auto; font-weight: normal; border-style: solid; align: center; border:1"> | <table rules="all" width="98%" cellpadding="6" cellspacing="3" style="margin: 1em auto 1em auto; font-weight: normal; border-style: solid; align: center; border:1"> | ||
<tr style="background-color:#E1F4FF;"><th colspan=8>Sponsor Requirement Change Log</th></tr> | <tr style="background-color:#E1F4FF;"><th colspan=8>Sponsor Requirement Change Log</th></tr> | ||
− | <tr style="background-color:#E1F4FF;"><th width="5%">Date</th><th width="5%">Milestones</th><th width="5%">Dataset</th><th width="5%">Feature</th><th width=" | + | <tr style="background-color:#E1F4FF;"><th width="5%">Date</th><th width="5%">Milestones</th><th width="5%">Dataset</th><th width="5%">Feature</th><th width="25%">Feature Requirement (Before)</th><th width="25%">Feature Requirement (After)</th><th width="5%">Status</th><th width="25%">Status Description</th></tr> |
<tr><td rowspan=5 align="center">06 Jan</td> | <tr><td rowspan=5 align="center">06 Jan</td> | ||
<td rowspan=5 >Before Project Proposal</td> | <td rowspan=5 >Before Project Proposal</td> | ||
Line 64: | Line 64: | ||
<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"><font color="#ff0000">Removed</font></td> | <td align="center"><font color="#ff0000">Removed</font></td> | ||
<td><font color="#ff0000">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.</font></td> | <td><font color="#ff0000">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.</font></td> | ||
Line 69: | Line 70: | ||
<tr> | <tr> | ||
<td>A,B,C classification</td> | <td>A,B,C classification</td> | ||
− | <td>Development an | + | <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"><font color="#ff8000"> | + | <td align="center">Use preassigned values to sort SKUs into A,B,C classifications.</td> |
− | <td><font color="#ff8000"> | + | <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> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Dashboard</td> | <td>Dashboard</td> | ||
− | <td>Develop a dashboard using Tableau for high level | + | <td>Develop a dashboard using Tableau for high level visualization of warehouse process.</td> |
− | <td align="center"><font color="#ff8000"> | + | <td>Develop a dashboard using d3.js, SAS Enterprise Miner and JMP for high level visualization of warehouse process.</td> |
− | <td><font color="#ff8000"> | + | <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> | ||
</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 | + | <td align="center">NIL</td> |
− | <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.</td> |
+ | <td align="center">NIL</td> | ||
+ | <td align="center"><font color="green">Remain</font></td> | ||
+ | <td align="center">NIL</td> | ||
</tr> | </tr> | ||
Line 101: | Line 108: | ||
<td>Dashboard</td> | <td>Dashboard</td> | ||
<td>Utilization of SAS Enterprise miner for data analytics and d3.js for data visualization and </td> | <td>Utilization of SAS Enterprise miner for data analytics and d3.js for data visualization and </td> | ||
− | <td rowspan=2 align="center">Remain</td> | + | <td rowspan=2 align="center"><font color="green">Remain</font></td> |
<td rowspan=2 align="center">-</td> | <td rowspan=2 align="center">-</td> | ||
</tr> | </tr> |
Revision as of 03:09, 16 April 2016
HOME | ABOUT US | PROJECT OVERVIEW | DATA ANALYSIS new! | PROJECT MANAGEMENT | DOCUMENTATION |
Project Schedule | Work Plan new! | Change Management new! | Risk Management |
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, and the 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 | 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 | SKUs into A,B,C classifications, based on their rate of movement (fast / slow moving). | Changed | To include top 20 SKUs visualization. Client's rationale was that even with the classification of SKUs, there is a high probablty to have hundreds of categorical "A" SKUs, hence, he would also like to know the top best beforming SKUs. | |
Dashboard | Utilization of SAS Enterprise miner for data analytics and d3.js for data visualization and | Remain | - | ||||
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. | Changed | Client is looking into the possibility of linking the team's application with its onsite database. This would eliminate the need for frequent upload of data as this data will be pulled in from the client's inhouse WMS. |