Problem
You decide to run a test to determine the mean time between failures. During the test, you start with 50 operational machines on your production line producing widgets. You record breakdowns during a 120-hour observation period in which three of the machines broke down. One at 40 hours into the test, one at 50 hours into the test, and the 3rd failure comes at 75 hours.
Use Excel and the data you collected to calculate the MTBF of your machines. Analyze your results and place them on the spreadsheet.
Calculate the Expected Breakdown Maintenance Costs.