MANAGEMENT SCIENCE DECISION ANALYSIS SIMULATION MODEL USING

MANAGEMENT SCIENCE: DECISION ANALYSIS (SIMULATION MODEL)

USING SAMPLING DATA FROM EXCEL

6. Every time a machine breaks down at the Dynaco Manufacturing Company (Problem 3). either 1, 2, or 3 hours are required to fix it, according o the following probability distribution: a. Simulate the repair time for 20 weeks and then compute the average weekly repair time. b. If the random numbers that are used to simulate breakdowns per week are also used to simulate repair time per breakdown, will the results be affected in any way? Explain. c. li it costs $50 per hour to repair a machine when it breaks down (including lost productivity), determine the average weekly breakdown cost. d. The Dynaco Company is considering a preventive maintenance program that would alter the probabilities of machine breakdonwns per week as shown in the following table: preventive maintenance program is 150. Using simulation, determine whether the company should institute the preventive maintenance program.

Solution

I am solving the part a and part b for this problem, please post multiple problem to get the remaining solution. Thanks

We first need to develop the probability distribution machine repair time

Machine 1 average repair time = 46 hours

Machine 2 average repair time = 40 hours

Machine 3 average repair time = 40 hours

Machine 4 average repair time = 40 hours

Machine 5 average repair time = 38 hours

Average weekly repair time = (46 + 40 + 40 + 40 + 38)/20 = 10.3 Hour per machine/Week

b) If the same random numbers that are used to simulate breakdowns per week are also used to simulate
repair time per breakdown:

then the time takne for various machines will be

Machine 1 average repair time = 34 hours

Machine 2 average repair time = 34 hours

Machine 3 average repair time = 42 hours

Machine 4 average repair time = 36 hours

Machine 5 average repair time = 36 hours

Average weekly repair time = (34 + 34 + 42 + 36 + 36)/20 = 9.1 Hour per machine/Week

Difference between time = 10.3 - 9.1 = 1.2 hour per machine/week

Repair Time (hr)	Probability	Cumulative Distribution	Range
1	0.30	0.30	0-29
2	0.50	0.80	30-79
3	0.20	1.00	80-99