HERE IS THE LINK TO THE EXCEL FILE: https://www.mediafire.com/file/px2vt1z781oh6cj/Group_5_%25281%2529_%25282%2529.xlsx/file

1. Data analysis for the historical performance data
   • Descriptive statistics are to be summarized for each of the work elements (A thru OO)
   • Consider the use of a box-plot, or a simple data summary of your choice to compare mean, median, standard deviation (variances to the standards provided), etc.
   • Provide a summary statement about what you have found/determined about Foxconn's historical data, and what you plan to do about the results ... if anything... why?

2.TAKT Time Calculation

• Establish a TAKT time calculator tool (formula) within one of the available worksheets provided within your group's data (Excel) file
• The TAKT time calculator toolmust be able to calculate TAKT time based on all the necessary input variables that make up "available time", and "customer demand"
• The TAKT time calculator tool must be able to re-calculate TAKT time by changing any one or multiple input variables.

4.Evidence that a workstation design (Line Balancing) table has been started

• The line balancing table must be started within one of your available worksheets of the Excel file provided to your group folder in the sharepoint. The goal here is to simply beginthe process of line balancing for the design and plan of the workstations needed for your factory.
• This table does not have to be complete yet, but evidence must be shown that this table is setup, ready, and must show progress has been made. Please aim to have 3 to you're your workstation assignments completed.
• HINT: . you need to decide which cycle times you will be working with, and you need to be confident with what TAKT time you'll be working towards.

5.Provide a small/simple project plan that lists the next/remaining steps (activities) that your group will be working on and completing over the next 7 to 8 weeks so that there is a clear path to successful completion of this project prior to the due date and presentation date.

• Use Excel or MS Project to list (itemize) the remaining activities planned to be completed for this project (see & review the original project instructions for detail)
• Identify "who" will be responsible for completing each listed activity
• Identify "by when" that person will be aiming to complete the listed activity
• Ensure the plan shows clearly that all remaining activities have an assigned/delegated person(s) (group member) and that the pertinent activities are targeted to be completed prior to the week of presentation and due date for the project.