Given the following problem. Include the data of 40 days

Prob1bSol.xlsx Download Prob1bSol.xlsx

1. Compute Coecient of Variation (C.V.) for orders arrived.

The potential answers are:

A: 0.64.

B: 0.

C: 0.66.

D: 0.65.

E: 0.75.

2. Compute the average inventory.

The potential answers are:

A: 1.38 units.

B: 1.5 units.

C: 1.1 units.

D: 0 units.

E: 1.4 units.

3 . Compute the average flow time. Suppose throughput is equal to orders completed.

The potential answers are:

A: 0.6 days.

B: 0.61 days.

C: 0.67 days.

D: 0.53 days.

E: 0.59 days.

4. Compute average utilization of Station 1. The potential answers are:

A: 0.46.

B: 0.

C: 0.37.

D: 0.55.

E: 0.32.

5. Compute the daily capacity of station 1. Suppose throughput is equal to orders completed.

The potential answers are:

A: 6.48 units.

B: 5.04 units.

C: 5.35 units.

D: 8.26 units.

E: 0 units.

A42 f A B D E F G Day Arrivals 33 32 2 2 mm Station 1 0.31 0.6 Station 3 0.53 0.31 AWN Completed 3 1 34 33 6 35 34 1 0.48 Station 2 0.29 0.2 0.26 0.32 0.12 0.1 1 5 36 35 3 3 0.65 0.23 36 1 0.46 0.15 0.31 37 38 2 37 2 0.28 1 38 4 0.62 4 39 40 13 4 5 % 3 8 9 9 123 4999 39 1 0.23 0.11 0 0.15 0.02 0.72 0.4 0 2 NO 41 40 1 42 43 44 45 46 47 48 ooo 49 Prob1b Sol + Ready A42 f A B D E F G Day Arrivals 33 32 2 2 mm Station 1 0.31 0.6 Station 3 0.53 0.31 AWN Completed 3 1 34 33 6 35 34 1 0.48 Station 2 0.29 0.2 0.26 0.32 0.12 0.1 1 5 36 35 3 3 0.65 0.23 36 1 0.46 0.15 0.31 37 38 2 37 2 0.28 1 38 4 0.62 4 39 40 13 4 5 % 3 8 9 9 123 4999 39 1 0.23 0.11 0 0.15 0.02 0.72 0.4 0 2 NO 41 40 1 42 43 44 45 46 47 48 ooo 49 Prob1b Sol + Ready