Submitted by: Submitted by alinaboatright
Views: 25
Words: 468
Pages: 2
Category: Business and Industry
Date Submitted: 03/29/2015 03:07 PM
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...