Simulation/Statistical Analysis

Statistical data, results and calculations, and 2D/3D simulation
Software ARENA, OpQuest, Simulink, or related

Needed: (1) Relative Importance Index (2) Calculations supporting how to better streamline each process such that loss of time is

reduced & cost is lowered; (3) ARENA simulation.
No essay required – Explanation of result & conclusion. Info must be conclusive, and recommendation to better streamline processes

based on level of severity, process improvement is a must, statistical data study and explanations must be submitted; simulation

must run, at the end of study.

Loss time Loss time
Rating (W) Respondent 1: Time (mo’s) Respondent 2: Mng’t (Rating) Respondent 3: Skill level Respondent 4: Speed

of task Respodent ?: Cost Impact Time (wks) ΣW AVRG RATING
5 4 2 5 4 $262,500.00 12.5 3.8
5 4 2 5 4 3.8
3 2 2 5 2 2.8
3 1 1 1 1 $7,350.00 3 1.0
4 3 5 5 5 $21,840.00 2 4.5
3 2 2 2 2 $2,400.00 2 2.0
5 1 2 5 5 $20,160.00 3 3.3
4 1 2 2 2 $27,342.00 2.17 1.8
5 3 3 3 3 $20,160.00 3 3.0
5 2 2 5 5 $29,200.00 4.34 3.5
4 1 1 5 1 $14,600.00 2 2.0
3 1 1 1 2 $797.65 0.43 1.3
3 3 1 1 3 2.0
3 3 1 1 5 $7,812.50 12.5 2.5
3 2 2 2 2 $4,500.00 1 2.0
3 3 1 1 1 $16,000.00 16 1.5
2 2 3 3 3 $8,000.00 8 2.8
5 3 1 1 1 $18,200.00 13 1.5
5 1 1 5 5 $40,320.00 3 2.8
4 1 2 2 2 $547.40 0.33 1.8
4 3 1 5 5 $10,199.00 8.7 3.5
5 4 1 4 4 $23,940.00 15.2 3.1
3 2 1 4 4 $8,700.00 8.7 2.8
3 2 1 5 5 3.3
4 1 1 5 5 $3,417.75 2.17 3.0
3 1 1 5 5 $17,400.00 8.7 3.0
3 2 3 3 3 $5,327.00 8.7 2.8
2 3 5 5 5 $7,757.40 13.04 4.5
1 1 2 2 1 $725.73 0.715 1.5
1 1 1 1 1 $3,628.63 0.715 1.0
1 1 1 1 1 $3,628.63 0.715 1.0
2 1 1 1 1 $15,225.00 3 0.7
2 1 1 1 1 $25,375.00 5 1.2
3 2 1 1 1 $21,822.50 4.3 1.3
1 1 1 1 1 $10,000.00 2 1.0
1 1 2 1 1 $5,000.00 2 1.3
1 1 1 1 1 1.0
1 1 1 1 1 $1,015.00 1 1.0
2 1 1 1 1 $2,500.00 1 1.0
3 1 1 1 1 1.0
2 1 2 5 5 3.3
3 1 3 5 5 3.5
1 2 2 2 5 2.8
2 3 1 1 1 1.5
2 3 2 2 3 2.5
3 2 1 1 1 1.3
3 2 1 1 1 1.3
2 1 2 3 1 1.8
1 1 2 1 2 1.5
1 1 1 1 5 2.0

$667,391.18
Median 2
|>>> 2,900
Essential info is above 2900. High Impact

SEVERITY INDEX:
COUNTIF((J3:J52), “5”)/COUNTA(J3:J52 )