Difference between revisions of "ANLY482 AY1516 G1 Team Skulptors - Change Management"

From Analytics Practicum
Jump to navigation Jump to search
Line 115: Line 115:
 
<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.<b/>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>

Revision as of 03:18, 16 April 2016

Skulptors-Logo.png

Skulptors-HomeIcon.png   HOME Skulptors-AboutIcon.png   ABOUT US Skulptors-OverviewIcon.png   PROJECT OVERVIEW Skulptors-DataIcon.png   DATA ANALYSIS new! Skulptors-ProjMgmtIcon.png   PROJECT MANAGEMENT Skulptors-DocIcon.png   DOCUMENTATION
Project Schedule Work Plan new! Change Management new! Risk Management


Sponsor Requirement Change Log
DateMilestonesDatasetFeatureFeature Requirement (Before)Feature Requirement (After)StatusStatus 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 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.
Modfied 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.