Excel Templates to accompany Operations Management, Eleventh Edition
created by Lee Tangedahl
Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved.
Chapter Fourteen – JIT and Lean Operations
Templates: Level Capacity Loading
Lecture Suggestions
Example 2b
See Instructions template for complete instructions.
Level Capacity Loading
<Back
Product Quantity Units per Cycle Units Short
A 7 1 0
B16 3 0
C 5 1 0
D
E
Clear
Lecture Suggestions – Chapter 15
<Back
Example 1: Level Capacity Loading
1. Select the Example 1 worksheet
3. Enter Quantities for A, B, and C: 7, 16, 5
4. Determine Number of Cycles, first note that there is no value that will divide into each quantity and
yield an integer. Following are some choices:
5. Enter Units per Cycle for A, B, and C: 1, 3, 1 (largest integer in 5 cycles).
6. Distribute Units Short: A in cycle 2 and 4, C in cycle 3.
7. If the requirement for A is raised to 8 units, and you decide you stay with 5 cycles, you might
distribute the units short something like A in cycles 1, 3, and 5 and B in 3. However it might be
better to go to 4 cycles.
2. Clear worksheet (press Clear and confirm with OK).
Level Capacity Loading
<Back
Product Quantity Units per Cycle Units Short
A 7 1 0
B16 3 0
Clear
D
Level Capacity Loading
<Back
Product Quantity Units per Cycle Units Short
A 8 1 0
B16 3 0
Number of Cycles 5
Clear
D
Level Capacity Loading
<Back
Product Quantity Units per Cycle Units Short
A 4 1 0
B 8 2 0
Number of Cycles 3
Cycle 1 2 3 4 5
Clear
C 6 2 0
D 3 1 0
Chapter 14 – Problems 4-6 Note: This worksheet displays results only, you must copy the shaded
<Back area into the corresponding template to make additional calculations.
4. Level Capacity Loading
Product Quantity Units per Cycle Units Short
A21 7 0
Number of Cycles 3
Cycle 1 2 3 4
Pattern A(7) B(4) C(1) D(5) A(7) B(4) C(1) D(5) A(7) B(4) C(1) D(5)
Extra
5. Level Capacity Loading
Product Quantity Units per Cycle Units Short
A22 5 0
B12 3 0
D18 4 0
Number of Cycles 4
Cycle 1 2 3 4 5
Level Capacity Loading
Product Quantity Units per Cycle Units Short
A22 11 0
B12 6 0
B12 4 0
D15 5 0
C 4 2 0
D18 9 0
E 8 4 0
Number of Cycles 2
Cycle 1 2 3 4 5
6. Level Capacity Loading
Product Quantity Units per Cycle Units Short
A 9 1 0
B 8 1 0
C 5 1 0
D 6 1 0
Cycle 1 2 3 4 5