Excel Templates to accompany Operations Management, Eleventh Edition
created by Lee Tangedahl
Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved.
Supplement to Chapter Fourteen – Maintenance
Templates: Expected Number of Breakdowns (B)
(B) – includes Basic template
See Instructions template for complete instructions.
Expected Number of Breakdowns Basic
<Back
Number 0 1 2 3 4 5 6
Probability 0.2 0.3 0.4 0.1
Cost 1000
Basic Template: You can simply copy the basic template below and paste into another worksheet.
^Top
Expected Number of Breakdowns
Number 0 1 2 3 4 5 6
Probability 0.2 0.3 0.4 0.1
Cost 1000
Clear
Lecture Suggestions – Supplement to Chapter 15
<Back
Example 1: Expected Number of Breakdowns
2. Clear worksheet (press Clear and confirm with OK).
3. Enter probability distribution for 0, 1, 2, and 3 breakdowns: .2, .3, .4, and .1
4. Enter cost per breakdown: 1000
5. The template computes the Expected Number of Breakdowns = 1.4 and
the Expected Cost = 1,400.
Expected Number of Breakdowns
<Back
Number 0 1 2 3 4 5 6
Probability 0.2 0.3 0.4 0.1
Clear
Supplement to Chapter 14 – Problems 1-2 Note: This worksheet displays results only, you must copy the shaded
<Back area into the corresponding template to make additional calculations.
1. Expected Number of Breakdowns
2. Expected Number of Breakdowns
Number 0 1 2 3 4
Probability 0.1 0.3 0.3 0.2 0.1
Number 0 1 2 3 4