Suppose a product must go through a sequential assembly line made up of ?ve operations. The time it takes to complete each operation is normally distributed with a mean of 180 seconds and standard deviation of 5 seconds.
a. Build a spreadsheet model for this problem that computes the time this sequential assembly line would take in making a product. Attach an Excel file with a simulation model implemented by Analytic Solver Platform. Use the following simulation options:
•Trials per simulation: 1,000 simulation
•Simulation to Run: 1
•Simulation random seed: 2014
•Sampling method: Monte Carlo
•Radom Number Streams: Single Stream for all Uncertain Variables
•Value to Display: 1Correlations: Check Use Correlations
•Random Number generator: CMRG
b. What is the probability that all five operations will be completed in 900 seconds?
c. What is the minimum assembly time that 98% of assemblies can be completed in time?