Question: Suppose all formulas are correctly entered. The simulation is run for 5 2 periods. Then the total cost value ( cell F 3 ) from

Suppose all formulas are correctly entered. The simulation is run for 52 periods. Then the total cost value (cell F3) from 200 repetitions of the 52-period simulation are captured in the area shown in cells 15 to J205(the label "Sim #" is in cell I5).
To determine the best order quantity, we wish to check how the simulation performs with different order quantities. A two-way data table is set up in cells M5 through R205 with order quantity values set to 40,60,80,100, and 120 as shown in the highlighted area above.
Which of the following statements are true regarding the mean and standard deviations of the 200 repetitions when considering the different order sizes (cells N1 through R2)?
Exactly two answers are correct.
The order quantity of 80 appears to have the lowest standard deviation.
The order quantity of 100 units has a lower standard deviation than the order quantity of 60 units.
The order quantity of 40 units appears to be the least cost order policy on average.
The order quantity of 120 units is more costly than the order quantity of 80 units.
 Suppose all formulas are correctly entered. The simulation is run for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!