Question 1: (20 points) Create a stochastic model in Excel for an assembly operation. The assembly operation has been ti
Posted: Mon Jun 06, 2022 1:29 pm
Question 1: (20 points) Create a stochastic model in Excel for an assembly operation. The assembly operation has been timed and takes an average of 15 minutes. The time variation is normally distributed with a standard deviation of 1.5 minutes. Create and plot a histogram with CDF. With the current operation, what fraction of the assemblies are completed in less than 17 minutes? Consider at least 200 but not more than 1000 production cycles.