The production manager at Aldershot Manufacturing wishes to develop a materials requirements plan for produc
estimates that the lead time between releasing an order to the shop floor and producing a finished chair is 2 wee
Ques chairs in stock and no safety stock (safety stock is stock held in reserve to meet customer demand if necessary). T
inventory of 60 seats, 40 backs and 80 legs. Scheduled receipts are 50 seats in week 1 and 10 backs in week 1. Th
150 chairs in week 1, 70 in week 3, 175 in week 5, 90 in week 7 and 60 in week 8.
MPS
week 1 2 3 4 5
demands 150 0 70 0 175
Item: Chair overdue week-1 week-2 week-3 week-4
Gross Requirement (GR) 0 150 0 70 0
Scheduled Receipt (SR) 0 0 0 0 0
Projected On Hand (PoH) 260 110 110 40 40
Projected Net Requirement (PNR) 0 0 0 0 0
Planned Order Receipt (PORpt) 0 0 0 0 0
Planned Order Release (PORel) 0 0 0 135 0
Item: Seat overdue week-1 week-2 week-3 week-4
Gross Requirement (GR) 0 0 0 135 0
Scheduled Receipt (SR) 0 50 0 0 0
Projected On Hand (PoH) 60 110 110 0 0
Projected Net Requirement (PNR) 0 0 0 25 0
Planned Order Receipt (PORpt) 0 0 0 25 0
Planned Order Release (PORel) 0 25 0 90 60
Item: Back overdue week-1 week-2 week-3 week-4
Gross Requirement (GR) 0 0 0 135 0
Scheduled Receipt (SR) 0 10 0 0 0
Projected On Hand (PoH) 40 50 50 0 0
Projected Net Requirement (PNR) 0 0 0 85 0
Planned Order Receipt (PORpt) 0 0 0 85 0
Planned Order Release (PORel) 0 85 0 90 60
Item: Legs overdue week-1 week-2 week-3 week-4
Gross Requirement (GR) 0 0 0 540 0
Scheduled Receipt (SR) 0 0 0 0 0
Projected On Hand (PoH) 80 80 80 0 0
Projected Net Requirement (PNR) 0 0 0 460 0
Planned Order Receipt (PORpt) 0 0 0 460 0
Planned Order Release (PORel) 0 460 0 360 240
we can get a summary of all actions (planned order releases) as below.
Item id overdue week-1 week-2 week-3 week-4
1 chair 0 0 0 135 0
2 seat 0 25 0 90 60
3 back 0 85 0 90 60
4 legs 0 460 0 360 240
quirements plan for producing chairs over an 8 week period. She
ng a finished chair is 2 weeks. The company currently has 260
er demand if necessary). The company currently has an
nd 10 backs in week 1. The forecast customer demand is for
6 7 8 item id on hand inventory
0 90 60 chair 260
seat 60
week-5 week-6 week-7 week-8 back 40
leg 80
175 0 90 60
0 0 0 0 incoming inventory (or scheduled receipt)
0 0 0 0 time item quantity
135 0 90 60 week 1 seat 50
135 0 90 60 week 1 back 10
90 60 0 0
week-5 week-6 week-7 week-8
90 60 0 0
0 0 0 0
0 0 0 0
90 60 0 0
90 60 0 0
0 0 0 0
week-5 week-6 week-7 week-8
90 60 0 0
0 0 0 0
0 0 0 0
90 60 0 0
90 60 0 0
0 0 0 0
week-5 week-6 week-7 week-8
360 240 0 0
0 0 0 0
0 0 0 0
360 240 0 0
360 240 0 0
0 0 0 0
week-5 week-6 week-7 week-8
90 60 0 0
0 0 0 0
0 0 0 0
0 0 0 0
