Data Analytics Question

Exercise 14 (p. 63) – An electronics superstore

SimQuick model (50 points)

Part a (25 points): For each scenario in the previous table, run 500 simulations and report the overall mean service level and the estimated total cost.

Part b (10 points): Does this new reorder point (i.e., 25) achieve the desired service level of 90% with order size = 35, 45, 55, 65, and 75? Support your answer using your simulation results.

Part c (10 points): If so, which reorder point scenario would you recommend? Explain.

Part d (5 points): As the order size increases, what happens to the ordering and holding costs?

Your submission should include both a SimQuick Excel file and a Word document. The organization and clarity of the answer may affect the grade received.