Brown and Brown Electronics manufactures a line of digital audiotape (DAT) players. While there are differences among the various products, there are a number of common parts within each player. The bill of materials, showing the number of each item required, lead times and the current inventory on hand for the parts and components, follows: Demand of products A \& B and demand of spares components are shown below: Prepare a MRP schedu/e to satisfy demand

Question

Brown and Brown Electronics manufactures a line of digital audiotape (DAT) players. While there are differences among the various products, there are a number of common parts within each player. The bill of materials, showing the number of each item required, lead times and the current inventory on hand for the parts and components, follows: Demand of products A \& B and demand of spares components are shown below: Prepare a MRP schedu/e to satisfy demand

Answer

MRP Schedule for Brown and Brown Electronics

WeekPartGross RequirementsNet RequirementsPlanned Order ReceiptsPlanned Order ReleasesEnding Inventory
7A500470 (500 – 30)4704700
7B400350 (400 – 50)3503500
7C(1)500 x 2 = 1000970 (1000 – 30)1000100070
7D(2)400 x 2 = 800725 (800 – 75)725725320
7C(2)400 x 2 = 800750 (800 – 50)80080080
7E(2)400 x 2 = 800750 (800 – 50)80080050
7F(2)400 x 2 = 800750 (800 – 50)800800150
7G(2)400 x 2 = 800750 (800 – 50)800800100
7F(2)400 x 2 = 800750 (800 – 50)800800150
7F(2)400 x 2 = 800750 (800 – 50)800800150
7G(2)400 x 2 = 800750 (800 – 50)800800100
7I(2)400 x 2 = 800750 (800 – 50)80080050
7H(1)400350 (400 – 50)3503500
7I(2)400 x 2 = 800750 (800 – 50)80080050
7I(2)400 x 2 = 800750 (800 – 50)80080050
7H(1)400350 (400 – 50)3503500
9ANoneNoneNoneNone470
9BNoneNoneNoneNone350
9C(1)None40 (70 – 30)NoneNone40
9D(2)NoneNoneNoneNone320
9C(2)None30 (80 – 50)NoneNone30
9E(2)NoneNoneNoneNone0
9F(2)NoneNoneNoneNone0
9G(2)NoneNoneNoneNone0
9F(2)NoneNoneNoneNone50
9F(2)NoneNoneNoneNone50
9G(2)NoneNoneNoneNone0

Leave a Comment