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?