MRP for Products A, F and G

This assignment presents a material requirements planning (MRP) analysis for three interconnected products: A, F, and G. The provided data includes scheduled receipts, safety stock levels, lead times, and order quantities. The solution involves calculating the projected available balance, net requirements, planned order receipts, and planned order releases for each product over a five-week period. The assignment highlights the interdependence of products and the importance of coordinating production schedules to meet demand.

MRP and DRP
1 | P a g e
Supply chain Analytics

MRP and DRP
Contents
Solution-1........................................................................................................................................3
Solution-2........................................................................................................................................4
Bibliography....................................................................................................................................5
Solution-1
2 | P a g e

MRP and DRP
This is the following calculation have been done for MRP record for the product A, product F
and component G which is as follows.
Product A
Time (weeks) 1 2 3 4 5
Gross requirement 5 3 10 15 15
Scheduled receipt 5
Projected available balance 10 10 7 0 0 0
Net requirements 0 0 10 15 15
Planned order receipts 0 0 0 3 15 15
Planned order release 0 0 3 15 15 0
Lead Time (LT)=1wk, Q(lot size)= lot-for-lot; ss (safety stock)=0
Product F
Time (weeks) 1 2 3 4 5
Gross requirement 10 20 25 15 5
Scheduled receipt 15
Projected available balance 15 5 0 0 0 0
Net requirements 0 0 25 15 5
Planned order receipts 0 0 0 25 15 5
Planned order release 25 15 5 0 0
LT=2wk, Q= lot-for-lot; ss=0
Part G
Time (weeks) 1 2 3 4 5
Gross requirement 25 21 35 30 0
Scheduled receipt 20
3 | P a g e
A
G(2) C D HG
F

MRP and DRP
Projected available balance 30 25 24 29 19 19
Net requirements 0 0 11 1 0
Planned order receipts 0 0 20 40 20 0
Planned order release 20 40 20 0 0
LT=1wk, Q= multiple of 20; ss=10
Solution-2
The MRP record for Product A obtained from given condition is shown above, the projected
were achieved as given in excel sheet. The results shows that, For Part A the projected available
balance is required for next two only which 10 and 7, the three week will be carried on by
planned order received. Planned order started from week third week which has 3 items in first
week after that it is 15 and 15 for next two week. The scheduled receipt as given in question
lasted for one week only.
The MRP record for product F indicates that schedule receipt for material is available on second
week; therefore we have to proceed from projected available balance directly. The Projected
available balance is used for first two week; the planned order release comes as zero because
initial reference cell is having text. the planned order release starts from second week and ends in
third week, because it is its lead time is 2 week. Because there is no safety stock in the item, so
rest of the result is given in the second table of excel sheet.
It is clear that part G is related with Product A and product F both; therefore most of the
calculation comes as keeping both of products in mind, projected available balance for Part G is
stared from 30 in week one and lasted for 5th week of this MRP schedule. Because its quantities
are in the lot of 20, therefore, planned release date started from first week and lasted for third
week. For part G the gross requirement is calculated a two times of part A and one time of part F,
and the result comes as 25, 21, 35, 30 and 0 for 5th week. It is visible that safety stock is
depleting in week 3, therefore, order to overcome this safety stock in week 3 week, order
quantity of 20 units is planned in week 1.
Bibliography
4 | P a g e

MRP and DRP
Jacobs, R., 2013, Manufacturing Planning and Control for SCM, 2nd edition ed. New York: Mc
Graw Hill.
Ptak, C, 2013, Orlicky's Material Requirements Planning. third ed, New York: McGraw Hill.
Wilson, G, 2008, Managing Quality. 2nd ed. New York: Routledge.
5 | P a g e