Brunswick

600 Words Nov 8th, 2015 3 Pages
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 –
Open Document