Please show work and excel work.

Question 3: (5 points) Service Management Bulb Replacement Problem: Lighting on exit ramp 167 on I-55 consists of a cluster of 3 bulbs. Safety regulations require that it must be immediately replaced whenever a bulb fails. The cost of the bulb is $450 per unit. The cost of making the trip to replace one or more bulbs is $900 (independent of the number of bulbs replaced). Based on past experience, a bulb's life is described by the following probability distribution. Use only the random numbers provided. The highway department wants to investigate two possible alternative policies- i) replace a bulb when it fails, or ii) replace all bulbs whenever one or more bulbs fail - no matter when that bulb was installed. Simulate the system (alternative-1 for 25 months and alternative- 2 for 25 months). A) Which policy the department should use. B) What is the optimum monthly average cost of operating the system? C) Can you suggest yet third alternative policy which may be worthwhile investigating? Alternative 1: Replace only bulb that fails (Use these Random Numbers in sequence) Alternative 2: Replace all three bulbs when one fails (Use these Random Numbers in sequence) Question 3: (5 points) Service Management Bulb Replacement Problem: Lighting on exit ramp 167 on I-55 consists of a cluster of 3 bulbs. Safety regulations require that it must be immediately replaced whenever a bulb fails. The cost of the bulb is $450 per unit. The cost of making the trip to replace one or more bulbs is $900 (independent of the number of bulbs replaced). Based on past experience, a bulb's life is described by the following probability distribution. Use only the random numbers provided. The highway department wants to investigate two possible alternative policies- i) replace a bulb when it fails, or ii) replace all bulbs whenever one or more bulbs fail - no matter when that bulb was installed. Simulate the system (alternative-1 for 25 months and alternative- 2 for 25 months). A) Which policy the department should use. B) What is the optimum monthly average cost of operating the system? C) Can you suggest yet third alternative policy which may be worthwhile investigating? Alternative 1: Replace only bulb that fails (Use these Random Numbers in sequence) Alternative 2: Replace all three bulbs when one fails (Use these Random Numbers in sequence)