Question

MRP IN MANUFACTURING 1. Each E subassembly is made up of 6 G parts, 20 H parts, and ONE J part. Draw the product structure tree diagram. Using the product structure tree diagram and the information provided below, Completeth e following MRP Report Transaction processing for PART E and PART G ONLY if the following information is provided: ( Do not order more quantity of any resources that are needed to maintain the production)

	E subassembly	G part	H part	J part
Order Lot size	200	250	1000	1200
Lead time	0wk	1wk	2wks	2wks
On hand	200	300	700	700
Safety Stock	100	50	150	400
Scheduled Receipt	1000, 200	500, 900	600	500

Part E	1	2	3	4	5	6
Gross Required	1500	1200	800	1000	900	600
Scheduled Receipt	1000			200
Available
Net Requirement
Planned Order Receipt
Planned Order Released

Part G	1	2	3	4	5	6
Gross Required
Scheduled Receipt	500		900
Available
Net Required
Planned Order Receipt
Planned Order Release

Answer 1

We can solve this question in excel using following formula:

This will give our final solution as :