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 si

Comments Off on 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 si

  

Milestones to be Completed:

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.

· Update your group’s data file (Excel file assigned to your group) by editing/revising/summarizing/displaying your analysis within one of the available worksheets provided

· 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. Precedence Diagram

· Complete the construction of the precedence diagram based on the data provided in your group’s data file.

· Submit a “rough”/“draft” (sketch) or “finished” version of the precedence diagram via eConestoga’s submission link 

· Acceptable file types include (Word, PDF, .DRWG (CAD), Visio, Excel, PPT, etc. or a hand-sketch + photo/scan is OK at this point. 

· Label the file as “Precedence Diagram_Group(###)”

3. 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 tool must 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. HINT: it may be useful to link your TAKT time result to your workstation calculation and line balancing table in order to observe various scenarios for determining the amount of workstations your factory will need based on how you design/establish the “available time” for your production facility.

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 begin the 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 CAN NOT complete this part until you have completed steps 1, 2, and 3, from above. i.e. 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. 

I will have added an Excel data file using that Excel. You have answer the questions using data. You have to use the 3 empty excel sheets in the same excel file to fill answer.

Group5.xlsx

5 Year Forecast

iPhone Demand Forecast

Units (Sales) Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Fiscal Year 2024 Fiscal Year 2025 Fiscal Year 2026 Fiscal Year 2027 Fiscal Year 2028 232520.84895823096 267628.81478620076 271554 295801.02414246777 389394.85593982862 363276.67070878192 351349.58280685451 358987.89717119629 444903.64025815175 409556.33027709374 457539.0710974359 420634.40753004584 512241.46933323314 548518.46992067876 480030.78400609759 538587.01186217554 700896.83229419228 683509.15269009827 717789.81859643175 679850.22827892494

Units (Sales)

iPhone Parts List

iPhone Bill of Material

Part Description
Quantity per iPhone

Rear case (base)
1

Lightning connector assembly
1

TS1 (0.8 mm) Pentalobe screws
15

Speaker assembly
1

Power Button
1

Power & Volume flex cable assembly
1

Wifi antenna assembly
1

Blue tooth antenna & PCBA assembly
1

metal bracket
5

Taptic engine (vibrations & sensory motor)
1

Side buttons assembly (Mute switch and volume control)
1

Rear facing camera assembly (includes flex cable)
1

Front facing & infrared camera assembly (includes flex cable)
1

SIM card tray and ejection mechanism/assembly
1

Logic board PCBA_1
1

Logic Board PCBA_2
1

LCD screen
1

Digitizer Plate
1

microphone and speaker assembly
1

Battery
1

Charging Coil
1

double-sided adhesive strips
3

Waterproofing gaskets
1

Precedence & Cycle Times

iPhone Production Standards

Element ID
Work Element Decription
Precedence

A
Fixture and Secure the rear case (base)

B
Install the Lightning plug connector assembly into the rear case (base)
A

C
Affix (fasten) the lightning connector assembly; 4 screws
B

D
Install the Power Button
A

E
Install 3 side buttons (Mute switch and volume controlS)
C,D

F
Install the Power & Volume button flex cable assembly
E

G
Prepare the Wifi antenna assy
E,F

H
Install and fasten Blue tooth antenna PCBA assy
G

J
Secure/affix wifi and Bluetooth assemblies with metal bracket
G,H

K
install the taptic engine (vibrations & sensory motor) and secure the metal bracket
F

L
connect the side buttons to the power & volume flex cable
F

M
secure the button and cable assembly with 2 metal brackets and screws
K,L,J

N
Install the rear facing camera assembly (includes flex cable)
M

O
Install the front facing & infrared camera assembly (includes flex cable)
M

P
Install upper speaker assembly
M

Q
Quality check! Ensure proper fastening & function of the side buttons, toggle, Power, Vibration)
N,O,P

R
Prepare the SIM card tray and ejection mechanism/assembly

S
Install Logic board PCBA_1
Q

T
install Logic Board PCBA_2
Q

U
Connect the rear facing camera flex cable to PCBA_1
S

V
Connect the front facing camera with infrared camera assembly and IR flex cable to PCBA_2
T

W
Connect the power switch/volume flex cable to PCBA_1
S

X
Secure all cable connections with fasteners
U,V,W

Y
LCD screen & digitizer assembly is prepared by removing protective foils and attaching LCD to the digitizer via 4 screws

Z
Attach and Secure (with 2 screws) the home button assembly within the LCD screen frame (hole provided).

AA
Install front facing camera’s flex cable assembly
V,Y,Z

BB
Install microphone and bottom speaker assembly and secure with metal bracket + 3 screws
AA

CC
Battery & Charging coil assembly is prepared by applying double-sided adhesive strip to both the battery assembly and the charging coil assembly.

DD
Install (adhere) the charging coil onto the battery pack
CC

EE
Adhere the battery/coil assembly into the case (base) by press/hold allowing the adhesive to settle.
DD

FF
Connect the LCD screen to the logic boards_PCBA_1/2 & secure with metal plates (2 plates) (6 screws)
Z, BB, EE

GG
Connect the home button flex cable to the logic board_PCBA
FF

HH
insert waterproofing gaskets
GG

JJ
Press/insert SIM card tray into side location of base/case
HH,X

KK
Snap-press together the base/case and LCD assembly to become an enclosed/finished assembly
JJ, R

LL
Secure the overall assembly with 2 screws in the lower end of the base/case assembly
KK

MM
Power up and test/inspect functionality of: screen touch activation, sounds, antennas, location services, swiping & setting of app preferences, battery health, cameras, utilities, and calling (send/receive), 360 Visual Check
LL

OO
Place phone into the fibreboard crate for transit to packaging depot (3rd party packager)
MM

Historical Performance

iPhone “Actual” Production Data (Historical/Demonstrated Performance)

Work Element Cycle Times Demonstrated (Seconds)

iPhone Work Order ID
A
B
C
D
E
F
G
H
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
BB
CC
DD
EE
FF
GG
HH
JJ
KK
LL
MM
OO

AA56
5.39
9.05
8.96
5.15
5.44
11.60
12.97
20.82
23.68
9.17
43.66
5.45
10.18
5.59
6.95
6.19
27.88
19.09
21.64
5.69
3.22
2.92
22.67
30.30
13.44
11.38
35.83
22.36
5.76
7.95
41.63
7.65
10.58
6.89
5.51
10.75
60.90
4.93

AA67
5.53
9.09
8.90
5.12
5.41
11.54
13.05
20.84
23.61
9.00
43.70
5.37
10.21
5.69
7.20
6.20
27.81
19.01
21.73
5.60
3.04
2.92
22.70
30.29
13.32
11.37
35.77
22.52
5.93
7.95
41.69
7.46
10.71
6.87
5.40
10.76
60.88
4.93

AA70
5.32
9.13
9.13
5.10
5.46
11.56
13.10
20.93
23.65
9.11
43.71
5.28
10.21
5.44
6.57
6.21
27.84
19.05
21.74
5.42
3.16
2.89
22.68
30.29
13.42
11.40
35.68
22.57
5.69
7.96
41.62
7.59
10.65
6.90
5.66
10.81
60.89
4.95

AB17
5.37
8.98
9.08
5.14
5.46
11.57
13.10
20.87
23.69
9.01
43.74
5.30
10.20
5.68
6.94
6.17
27.88
19.04
21.67
5.44
3.27
2.90
22.74
30.29
13.42
11.45
35.70
22.71
5.58
7.96
41.66
7.60
10.64
6.88
5.58
10.81
60.90
4.93

AC16
5.51
9.03
9.05
5.15
5.27
11.52
13.05
20.83
23.59
9.18
43.67
5.43
10.20
5.46
6.82
6.23
27.87
19.02
21.43
5.53
3.17
2.94
22.69
30.28
13.28
11.36
35.61
22.48
5.36
7.95
41.59
7.50
10.62
6.90
5.63
10.82
60.84
4.94

AC98
5.52
8.98
8.89
5.13
5.34
11.54
13.00
20.79
23.52
9.15
43.69
5.35
10.20
5.55
6.80
6.17
27.87
19.01
21.58
5.42
3.32
2.91
22.73
30.28
13.54
11.41
35.82
22.61
5.82
7.95
41.59
7.52
10.59
6.90
5.54
10.80
60.88
4.94

AD50
5.50
9.05
8.77
5.13
5.47
11.61
13.18
20.85
23.57
9.04
43.80
5.37
10.23
5.54
6.80
6.17
27.77
19.01
21.51
5.70
3.32
2.84
22.67
30.30
13.60
11.49
35.60
22.24
5.51
7.95
41.62
7.46
10.58
6.92
5.48
10.74
60.89
4.92

AD55
5.46
9.12
8.94
5.15
5.45
11.62
12.98
20.78
23.56
9.17
43.85
5.35
10.21
5.55
6.88
6.19
27.89
19.08
21.51
5.55
3.29
2.93
22.67
30.31
13.47
11.25
35.65
22.65
5.78
7.96
41.59
7.45
10.67
6.90
5.49
10.70
60.89
4.93

AD82
5.32
8.98
8.75
5.14
5.41
11.59
13.11
20.86
23.72
9.14
43.90
5.52
10.22
5.55
6.72
6.21
27.84
19.02
21.55
5.50
3.34
2.91
22.69
30.30
13.27
11.34
35.71
22.68
5.65
7.96
41.66
7.58
10.53
6.89
5.53
10.92
60.89
4.95

AE15
5.37
8.94
8.97
5.12
5.36
11.59
12.97
20.84
23.78
9.28
43.80
5.51
10.22
5.48
6.77
6.22
27.86
19.11
21.60
5.33
3.37
2.93
22.72
30.31
13.41
11.46
35.92
22.70
5.76
7.96
41.69
7.66
10.51
6.89
5.72
10.81
60.86
4.91

AE44
5.39
9.05
9.07
5.11
5.31
11.64
13.13
20.80
23.58
9.17
43.67
5.43
10.22
5.59
6.

The post 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 si first appeared on Tutorie.

Get 30% off your orders today

X
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!