Solution.
For unit 1 of round top computer desk = 4 units of B + 2 units of C + 8 units of D + 7 units of E + 3 units of F required as per the diagram given.
Computer desk already available on hand.1
So only 9 units of computer desk is required.
So for 9 units of round up of computer desk = 9 * ( 4 units of B + 2 units of C + 8 units of D + 7 units of E + 3 units of F ) required.
So for 9 units of round up of computer desk = 36 units of B + 18 units of C + 72 units of D + 63 units of E + 27 units of F required /
But below is the availability
B = 8 units
C = 6 units
D = 100 units
E = 48 units
F = 20 units.
Following is the requirement of B.
B = 4*9= 36
On hand inventory = 8
Balance requirement of B = 36 - 8 = 28 units
Following is the requirement of C
C = 2*9 = 18
On hand inventory = 6
Balance requirement of C= 18-6 = 12 units
Balance requirement of D = 0 as D requirement is only 72 units and stock on hand is 100.
Balance requirement of E = 63 - 48 = 15 units
Balance requirement of F = 27 - 20 = 7 units.
The above balance requirement of all the parts need to procured to satisfy a new order of 10 round top computer desks.
Question #1 : The product structure tree of a round-top computer desk is given as follows....
Material Requirements Planning (MRP) Given the product tree diagram and develop a material requirements plan for item D. A 400 unit-delivery of product P is due at the beginning of week 7. Use the worksheet Product Structure Tree Inventory Information P Order Currently Scheduled Lead Item On-Hand Recpt (wk) Time Qty LAL P 100 L4L A A FIxed Q 450 Fixed Q = 600 L4L 0 C 90 100 (wk 2) 80 (wk 2) 2 50 2 C D(2 Beg...
Problem 12-18 Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time for B is three weeks. Sixty units of A are needed at the start of week 8. There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are in production and will be completed by the start of week 2. (Leave no cells...
One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time...
One unit of A is made of one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time of...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is...
One unit of A is made of one unit of B and one unit of C. B is
made of four units of C and one unit each of E and F. C is made of
two units of D and one unit of E. E is made of three units of F.
Item C has a lead time of one week; Items A, B, E, and F have
two-week lead times; and Item D has a lead time of...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is...
Problem 14-5 To simplify data handling to include the receipt of orders that have actually been placed in previous periods, the following six-level scheme can be used. (A number of different techniques are used in practice, but the important issue is to keep track of what is on hand, what is expected to arrive, what is needed, and what size orders should be placed.) One unit of A is made of three units of B, one unit of C, and...
Given the data provided for product structure, component AC101, and the planned orders of parent AB 500 below, use the matrix for AC101 at the bottom to compute gross requirements, projected on hand, net requirements and planned orders. Suggestion: Start by filling out the MRP matrix for AC101 with the data given. AB500 LT=2 AC101 (2) LT=3 Notes: O signifies usage. FOQ = Fixed order quantity. Item On Hand MPS Scheduled Receipts 600: Week 6 Lot Size / Order Policy...