Bsop 330 Week 5 Lab

Alina Boatright

Amore100036@yahoo.com

Alina Boatright

Amore100036@yahoo.com

bsop 330 week 5 lab

Professor Agrawal

bsop 330 week 5 lab

Professor Agrawal

BSOP330 Master Planning, Week 5 Problems

Problem 1

MASTER PRODUCTION SCHEDULE

MAKE-TO-STOCK

WEEKS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |

FORECAST | 300 | 100 | 10 | 120 | 30 | 260 | 300 | 50 | 400 |

BOOKED ORDERS | 50 | | 40 | 80 | 10 | | 50 | 50 | |

MPS DUE | | 250 | | 250 | | 500 | | 250 | |

MPS RELEASED | 500 | | 250 | | 750 | | | | |

PABBEGINPAB 500 | 200(500-300) | 350(200+250-100) | 340(350-10) | 470(340+250-120) | 440(470-30) | 680(440+500-260) | 380(680-300) | 580(380+250-50) | 180(580-400) |

ATP | 450(500-50) | 210(250-40) | 130(210-80) | 240(250-10) | | 200(250-50) | 150(200-50) | 250 | |

Beginning PAB prior to week number one is 500.

Lead-time for MPS releases is one week.

All MPS releases must be in lot sizes of 250 or multiples of 250.

REQUIRED:

Complete the MPS due line and the MPS released line.

Complete the PAB line. (On-Hand)

Complete the ATP line. (Available to Promise)

BSOP Master Planning, Week 5 Assignment

Problem 2

Make-to-Stock MPS

WEEKS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |

FORECAST | 100 | 50 | 30 | 70 | 10 | 20 | 25 | 10 | 20 | 50 |

BOOKEDORDERS | | | 20 | | 20 | 5 | 10 | 30 | 10 | 20 |

MPSDUE | | 200 | | | | | | | | |

MPSRELEASED | 200 | | | | | | | | | |

POH ORPAB200 | 100200-100 | 250100+200-50 | 220250-30 | 150220-70 | 140150-10 | 120140-20 | 95120-25 | 8595-10 | 6585-20 | 1565-50 |

ATP | 200 | 180200-20 | | 160180-20 | 155160-5 | 145155-10 | 115145-30 | 105115-10 | 85105-20 | |

Beginning on-hand inventory prior to week one is 200 units.

Lead-time for MPS planned orders is one week.

All MPS releases must be in lot sizes of 200 or multiples of 200.

REQUIRED:

Complete the MPS due and MPS planned lines.

Calculate the new projected on-hand...