preview

Brunswick

Satisfactory Essays

Week 5 Case Study: Brunswick Exercise Brandon Johnson GSCM-520-16900 Professor Robert Tedeschi October 3rd, 2015 Brunswick Exercise: ANALYTICS EXERCISE: An MRP Explosion – Brunswick Motors Engine Assembly Master Schedule Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Demand | 15 | 5 | 7 | 10 | | 15 | 20 | 10 | | 8 | 2 | 16 | Gear Box Requirements Week: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Gross Requirements | 15 | 5 | 7 | 10 | 0 | 15 | 20 | 10 | 0 | 8 | 2 | 16 | Scheduled Receipts | 17 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Projected Available Balance | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Net Requirements | 0 | 0 | 5 | 10 | 0 | 15 | 20 | 10 | 0 | 8 | 2 | 16 | Planned Order …show more content…

9 | 10 | 11 | 12 | Demand | 15 | 5 | 7 | 10 | | 15 | 20 | 10 | | 8 | 2 | 16 | Gear Box Requirements Week: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Gross Requirements | 15 | 5 | 7 | 10 | 0 | 15 | 20 | 10 | 0 | 8 | 2 | 16 | Scheduled Receipts | 17 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Projected Available Balance | 2 | 2 | 10 | 0 | 0 | 30 | 10 | 0 | 0 | 18 | 16 | 0 | Net Requirements | 0 | 0 | 5 | 0 | 0 | 15 | 0 | 0 | 0 | 8 | 0 | 0 | Planned Order Receipt | 0 | 0 | 15 | 0 | 0 | 45 | 0 | 0 | 0 | 26 | 0 | 0 | Planned Order Release | 0 | 15 | 0 | 0 | 45 | 0 | 0 | 0 | 26 | 0 | 0 | 0 | Input Shaft Requirements Week: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Gross Requirements | 30 | 10 | 14 | 20 | 0 | 30 | 40 | 20 | 0 | 16 | 4 | 32 | Scheduled Receipts | 40 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Projected Available Balance | 10 | 22 | 38 | 18 | 18 | 78 | 38 | 18 | 2 | 38 | 34 | 2 | Net Requirements | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 14 | 0 | 0 | Planned Order Receipt | 0 | 0 | 30 | 0 | 0 | 90 | 0 | 0 | 0 | 52 | 0 | 0 | Planned Order Release | 0 | 30 | 0 | 0 | 90 | 0 | 0 | 0 | 52 | 0 | 0 | 0 | Wk 9 - 8 110 180 60 20 + 180 Wk 6 – 8 50 60 – 72 52 52 36 32 – 180 Wk 3/6/10 – 28 – 80 – 78 – 270 Wk 3/6/10 – 316 – 45 – 45 –

Get Access