Answer 7 Operations Management Problem with Attached Excel Templates
i23homeworkhelpq21
ch14.xlsxChapter 14
| Excel Templates to accompany Operations Management, Twelfth Edition | |
| created by Lee Tangedahl | |
| Copyright ©2015 McGraw-Hill Education. All rights reserved. | |
| Chapter Fourteen - JIT and Lean Operations | |
| Templates: | Level Capacity Loading |
| Examples: | Example 2a |
| Example 2b | |
| Solved Problems: | Solved Problem 2 |
| See Instructions template for complete instructions. | |
Level Capacity Loading
| Level Capacity Loading | ||||||
| <Back | ||||||
| Product | Quantity | Units per Cycle | Units Short | |||
| A | 7 | 1 | 0 | |||
| B | 16 | 3 | 0 | |||
| C | 5 | 1 | 0 | |||
| D | ||||||
| E | ||||||
| Number of Cycles | 5 | |||||
| Cycle | 1 | 2 | 3 | 4 | 5 | |
| Pattern | A(1) B(3) C(1) | A(2) B(3) C(1) | A(1) B(4) C(1) | A(2) B(3) C(1) | A(1) B(3) C(1) | |
| Extra | A | B | A | |||
| A | 0 | 1 | 0 | 1 | 0 | 2 |
| B | 0 | 0 | 1 | 0 | 0 | 1 |
| C | 0 | 0 | 0 | 0 | 0 | 0 |
| D | 0 | 0 | 0 | 0 | 0 | 0 |
| E | 0 | 0 | 0 | 0 | 0 | 0 |
Example 2a
| Level Capacity Loading | ||||||
| <Back | ||||||
| Product | Quantity | Units per Cycle | Units Short | |||
| A | 7 | 1 | 0 | |||
| B | 16 | 3 | 0 | |||
| C | 5 | 1 | 0 | |||
| D | ||||||
| E | ||||||
| Number of Cycles | 5 | |||||
| Cycle | 1 | 2 | 3 | 4 | 5 | |
| Pattern | A(1) B(3) C(1) | A(2) B(3) C(1) | A(1) B(4) C(1) | A(2) B(3) C(1) | A(1) B(3) C(1) | |
| Extra | A | B | A | |||
| A | 0 | 1 | 0 | 1 | 0 | 2 |
| B | 0 | 0 | 1 | 0 | 0 | 1 |
| C | 0 | 0 | 0 | 0 | 0 | 0 |
| D | 0 | 0 | 0 | 0 | 0 | 0 |
| E | 0 | 0 | 0 | 0 | 0 | 0 |
Example 2b
| Level Capacity Loading | ||||||
| <Back | ||||||
| Product | Quantity | Units per Cycle | Units Short | |||
| A | 8 | 1 | 0 | |||
| B | 16 | 3 | 0 | |||
| C | 5 | 1 | 0 | |||
| D | ||||||
| E | ||||||
| Number of Cycles | 5 | |||||
| Cycle | 1 | 2 | 3 | 4 | 5 | |
| Pattern | A(2) B(3) C(1) | A(1) B(3) C(1) | A(2) B(4) C(1) | A(1) B(3) C(1) | A(2) B(3) C(1) | |
| Extra | A | A B | A | |||
| A | 1 | 0 | 1 | 0 | 1 | 3 |
| B | 0 | 0 | 1 | 0 | 0 | 1 |
| C | 0 | 0 | 0 | 0 | 0 | 0 |
| D | 0 | 0 | 0 | 0 | 0 | 0 |
| E | 0 | 0 | 0 | 0 | 0 | 0 |
Solved Problem 2
| Level Capacity Loading | ||||||
| <Back | ||||||
| Product | Quantity | Units per Cycle | Units Short | |||
| A | 4 | 1 | 0 | |||
| B | 8 | 2 | 0 | |||
| C | 6 | 2 | 0 | |||
| D | 3 | 1 | 0 | |||
| E | ||||||
| Number of Cycles | 3 | |||||
| Cycle | 1 | 2 | 3 | 4 | 5 | |
| Pattern | A(1) B(3) C(2) D(1) | A(1) B(3) C(2) D(1) | A(2) B(2) C(2) D(1) | |||
| Extra | B | B | A | |||
| A | 0 | 0 | 1 | 0 | 0 | 1 |
| B | 1 | 1 | 0 | 0 | 0 | 2 |
| C | 0 | 0 | 0 | 0 | 0 | 0 |
| D | 0 | 0 | 0 | 0 | 0 | 0 |
| E | 0 | 0 | 0 | 0 | 0 | 0 |
Clear
Clear
Clear
Clear
Clear
Clear
Clear
Clear
