Difference between revisions of "ANLY482 AY2017-18T2 Group03 Project Management"

From Analytics Practicum
Jump to navigation Jump to search
 
(13 intermediate revisions by 3 users not shown)
Line 8: Line 8:
 
{|style="background-color:#ffffff; color:#000000; width="100%" cellspacing="0" cellpadding="10" border="0" |
 
{|style="background-color:#ffffff; color:#000000; width="100%" cellspacing="0" cellpadding="10" border="0" |
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="10%" |[[ANLY482_AY2017-18T2_Group03 |<font color="#FFFFFF" size=2><b>HOME</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="10%" |[[ANLY482_AY2017-18T2_Group03 |<font color="#FFFFFF" size=3><b>HOME</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="13%" |[[ANLY482_AY2017-18T2_Group03 About Us|<font color="#FFFFFF" size=2><b>ABOUT US</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="13%" |[[ANLY482_AY2017-18T2_Group03 About Us|<font color="#FFFFFF" size=3><b>ABOUT US</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="20%" |[[ANLY482_AY2017-18T2_Group03 Project Overview |<font color="#FFFFFF" size=2><b>PROJECT OVERVIEW</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="15%" |[[ANLY482_AY2017-18T2_Group03 Project Overview |<font color="#FFFFFF" size=3><b>PROJECT OVERVIEW</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="18%" |[[ANLY482_AY2017-18T2_Group03 Data Analysis |<font color="#FFFFFF" size=2><b>DATA ANALYSIS </b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="18%" |[[ANLY482_AY2017-18T2_Group03 Data Analysis |<font color="#FFFFFF" size=3><b>DATA ANALYSIS </b></font>]]
  
|style="font-size:88%; border-left:1px solid #149de7; border-right:1px solid #149de7; text-align:center; border-bottom:1px solid #149de7; border-top:1px solid #149de7;" width="22%" |[[ANLY482_AY2017-18T2_Group03 Project Management |<font color="#149de7" size=2><b>PROJECT MANAGEMENT</b></font>]]
+
|style="font-size:88%; border-left:1px solid #149de7; border-right:1px solid #149de7; text-align:center; border-bottom:1px solid #149de7; border-top:1px solid #149de7;" width="15%" |[[ANLY482_AY2017-18T2_Group03 Project Management |<font color="#149de7" size=3><b>PROJECT MANAGEMENT</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="17%" |[[ANLY482_AY2017-18T2_Group03 Documentation | <font color="#FFFFFF" size=2><b>DOCUMENTATION</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="17%" |[[ANLY482_AY2017-18T2_Group03 Documentation | <font color="#FFFFFF" size=3><b>DOCUMENTATION</b></font>]]
 +
 
 +
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#149de7; " width="17%" |[[ANLY482_AY2017-18_Term_2 | <font color="#FFFFFF" size=3><b>MAIN PAGE</b></font>]]
 
|}  
 
|}  
 
</center>
 
</center>
 
<!--End of Navigation Bar-->
 
<!--End of Navigation Bar-->
 +
 +
<!---------------START of sub menu ---------------------->
 +
{| style="background-color:#ffffff; margin: 3px auto 0 auto" width="55%"
 +
|-
 +
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="150px"| [[ANLY482_AY2017-18T2_Group03 Project Management Old| <span style="color:#149de7">Previous</span>]]
 +
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
 +
 +
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #149de7" width="150px"| [[ANLY482_AY2017-18T2_Group03 Project Management| <span style="color:#149de7">Current</span>]]
 +
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
 +
|}
 +
<!---------------END of sub menu ---------------------->
  
 
==<div style=" background: #e2f5ff; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #149de7 solid 32px;"><font color="#149de7"><strong>Project Management</strong></font></div>==
 
==<div style=" background: #e2f5ff; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #149de7 solid 32px;"><font color="#149de7"><strong>Project Management</strong></font></div>==
[[Image:AY2017-18T2 Group03 Project Management Timeline.png|center|1000px|]]
+
[[Image:AY2017-18T2 Group03 Project Management Gantt Chart.png|center|1000px|]]
 +
==<div style=" background: #e2f5ff; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #149de7 solid 32px;"><font color="#149de7"><strong>Change Management</strong></font></div>==
 +
 
 +
<!--Content Start-->
 +
<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 width="5%">Date</th><th width="5%">Milestone</th><th width="5%">Dataset</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 align="center">20th Jan</td>
 +
<td >Post Project Proposal</td>
 +
<td  >
 +
All data were given in excel format
 +
* AMS Handling In Report
 +
* AMS Handling Out Report
 +
* Headcount Report
 +
* orderStatusSummaryReport
 +
* stdInboundOrderReport
 +
</td>
 +
<td>
 +
• Find a way to calculate the amount of workers and total overtime hours needed in order to satisfy the order requirement for any day.<br/>
 +
</td>
 +
<td>As there was no way for them to provide us with information on the time taken taken to complete each task, we would have no way to come up with the model to derive the number of workers required for the amount of workload provided. On top of that, they were unable to provide us with the number of hours worked for each worker and which day the worker actually worked, making it almost impossible to link their individual performance to actual work completed.
 +
</td>
 +
<td>
 +
* Discuss with sponsor immediately to see if they can provide us with a new data set in order to carry on with the project.
 +
* <b>Russell</b> to follow up.
 +
</td>
 +
<td>Complete as of 26th January</td>
 +
</tr>
 +
 
 +
<tr>
 +
<td align="center">31st Jan</td>
 +
<td>Post Project Proposal</td>
 +
<td> All data were given in excel format
 +
* Molex Outbound Report 2015, 2016 and 2017 (3 files)
 +
* Molex Inbound Report 2015, 2016 and 2017 (3 files)
 +
</td>
 +
<td> • Find a way to calculate the amount of workers and total overtime hours needed in order to satisfy the order requirement for any day.<br/> </td>
 +
<td>
 +
* ABC Analysis
 +
* Seasonality Analysis
 +
* Inventory Performance analysis
 +
* Popular Product Analysis
 +
</td>
 +
<td>
 +
* Feature has been confirmed after meeting with professor on 31st January 2017.
 +
* We were advised to explore the data further and to ask for more information so that we can find a way to tie the inbound movements to the outbound movements</td>
 +
<td> NIL </td>
 +
</tr>
 +
 
 +
<tr>
 +
<td align="center">14th Feb</td>
 +
<td>Post Project Proposal</td>
 +
<td> All data were given in excel format
 +
* Inbound Report from October 2016 to December 2017
 +
* Outbound Report from October 2016 to December 2017
 +
</td>
 +
<td>
 +
* ABC Analysis
 +
* Seasonality Analysis
 +
* Inventory Performance Analysis
 +
* Market Basket Analysis
 +
<br/></td>
 +
<td>
 +
* Same types of analysis
 +
* Instead of 2015 to 2017, rescope to October 2016 to December 2017 because the company shifted warehouse in September 2016
 +
</td>
 +
<td>
 +
* Feature has been confirmed after meeting with professor on 14th February 2017.
 +
* Advised to look at data from October 2016 only because of the shifting of warehouse and changes in internal systems which resulted in the dataset to be different before and after October 2016.
 +
</td>
 +
<td> NIL </td>
 +
</tr>
  
==<div style=" background: #e2f5ff; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #149de7 solid 32px;"><font color="#149de7"><strong>Change Management</strong></font></div>==
+
</table>
 +
<br/>
 +
<!--End of Content-->

Latest revision as of 16:43, 22 February 2018

AY2017-18T2 Group03 Team Logo.png


HOME ABOUT US PROJECT OVERVIEW DATA ANALYSIS PROJECT MANAGEMENT DOCUMENTATION MAIN PAGE
Previous Current

Project Management

AY2017-18T2 Group03 Project Management Gantt Chart.png

Change Management

Sponsor Requirement Change Log
DateMilestoneDatasetFeature Requirement (Before)Feature Requirement (After)StatusStatus Description
20th Jan Post Project Proposal

All data were given in excel format

  • AMS Handling In Report
  • AMS Handling Out Report
  • Headcount Report
  • orderStatusSummaryReport
  • stdInboundOrderReport

• Find a way to calculate the amount of workers and total overtime hours needed in order to satisfy the order requirement for any day.

As there was no way for them to provide us with information on the time taken taken to complete each task, we would have no way to come up with the model to derive the number of workers required for the amount of workload provided. On top of that, they were unable to provide us with the number of hours worked for each worker and which day the worker actually worked, making it almost impossible to link their individual performance to actual work completed.
  • Discuss with sponsor immediately to see if they can provide us with a new data set in order to carry on with the project.
  • Russell to follow up.
Complete as of 26th January
31st Jan Post Project Proposal All data were given in excel format
  • Molex Outbound Report 2015, 2016 and 2017 (3 files)
  • Molex Inbound Report 2015, 2016 and 2017 (3 files)
• Find a way to calculate the amount of workers and total overtime hours needed in order to satisfy the order requirement for any day.
  • ABC Analysis
  • Seasonality Analysis
  • Inventory Performance analysis
  • Popular Product Analysis
  • Feature has been confirmed after meeting with professor on 31st January 2017.
  • We were advised to explore the data further and to ask for more information so that we can find a way to tie the inbound movements to the outbound movements
NIL
14th Feb Post Project Proposal All data were given in excel format
  • Inbound Report from October 2016 to December 2017
  • Outbound Report from October 2016 to December 2017
  • ABC Analysis
  • Seasonality Analysis
  • Inventory Performance Analysis
  • Market Basket Analysis

  • Same types of analysis
  • Instead of 2015 to 2017, rescope to October 2016 to December 2017 because the company shifted warehouse in September 2016
  • Feature has been confirmed after meeting with professor on 14th February 2017.
  • Advised to look at data from October 2016 only because of the shifting of warehouse and changes in internal systems which resulted in the dataset to be different before and after October 2016.
NIL