Stat
The total number of employees is dependent on the number of machines needed. The number of employees is . (the number of Machine A) + .(the number of Machine B) + - (the number of Machine C). The number of each type of machine needed is the total amount of time required on each machine divided by The time required on each machine is equal to the time per part on each machine times the The value (s) of is/are randomly generated using Excel's =NORM INV functionality Type integers or decimals.) X Simulation Results Machine A Machine B Machine C Total Employees X Needed Needed Needed Needed Standard Deviation Data 3.43 3.22 3.19 3.08 12 34 11.50 15.66 14 65 3.69 3.35 3.26 3.05 11.70 16.26 14 90 3.43 3.39 3.22 3.15 12.26 11 75 15 59 15.02 Part Type Machine A Machine B Machine C 3.22 3.37 3.01 3.19 11.39 12.33 14 51 15.62 0. 15 0.12 0.15 3.81 3.59 3.44 3.21 13.28 12 53 16 90 15.93 0.15 0. 12 0.15 3.37 320 3.14 3.03 12.18 11.32 15 43 14.43 0.1 0.15 0.25 3.50 2.90 3.27 2.75 12.63 10 34 16.02 13 16 0.15 0.15 0.25 3 39 3.00 3.13 2.77 12.13 10.87 15.39 13.75 0. 15 0.15 0.5 3.55 3.43 3.27 3.14 12.49 12.05 15.90 15.34 0.15 0.15 3.43 3.31 3.11 3.06 12 08 11.64 15.35 14.82 3.27 3 07 3.01 2.95 11.52 10.84 14.66 13.85 3.24 3.61 3.04 3.43 11.67 12.74 14 81 16.25 3.50 3.44 3.19 3.23 12.45 15.80 15.38 3.64 3.46 3.41 3.21 13.36 12 28 16.89 15.61 Print Done 3.47 3.85 3.24 3.46 12.09 13.10 15 45 16 76 3,72 3.45 3.44 3.19 13.57 12.31 17.15 15.63 3.16 3.30 2.95 3.11 11.18 11 90 14.23 15 10 3.41 3.36 3.16 3.06 12.30 11.83 15.59 15.04 3.25 3.22 2.96 3.01 11.55 1.73 14.65 14.85 Inswer Help me solve this Teach me Get more help - 3.58 3.17 3.32 2.88 12.57 11.08 16.02 14 10 2.94 3.52 2.68 3.18 10.28 12.44 13.09 15.79 3.27 3.36 3.18 3.19 11.94 12.11 15.17 15.39 3.68 3.21 3.39 2.99 13.22 11.35 16.75 14 45 3.03 3.66 2.79 3.29 10.71 12.80 13.62 16.28 3.50 3.12 3.22 2.91 12.31 11.07 15.67 14 09