Product A needs 3 components of B and 2 components of C. Component B on the other hand needs 2 units of component C and E. Component C requires a unit of D, and 3 components of E. Component D on the other hand requires 5 units of E. Lead time is 2 weeks. The company expects to deliver 100 units of A on the 3rd week, 250 units on the 5th week, and 500 units on the 8th week. There is no inventory on hand though there are expected receipts of 100 units of C on the 3rd week, and 250 units of E on the 2nd week. Create the product structure with proper level codes and a gross requirements plan.
Low Level Coded (LLC) product structure tree is following:
Lead times of items are needed to compute time-phased material requirements plan.
However, gross requirements plan for each week's requirement is following:
For 100 units of A in 3rd week,
Item | Parent Item | Usage | Gross Requirement |
A | 100 | ||
B | A | 3 | 300 |
C | A | 2 | 200 |
C | B | 2 | 600 |
D | C | 1 | 200 |
E | B | 2 | 600 |
E | C | 3 | 600 |
E | D | 5 | 1000 |
For 250 units of A in 5th week,
Item | Parent Item | Usage | Gross Requirement |
A | 250 | ||
B | A | 3 | 750 |
C | A | 2 | 500 |
C | B | 2 | 1500 |
D | C | 1 | 500 |
E | B | 2 | 1500 |
E | C | 3 | 1500 |
E | D | 5 | 2500 |
For 500 units of A in 8th week
Item | Parent Item | Usage | Gross Requirement |
A | 500 | ||
B | A | 3 | 1500 |
C | A | 2 | 1000 |
C | B | 2 | 3000 |
D | C | 1 | 1000 |
E | B | 2 | 3000 |
E | C | 3 | 3000 |
E | D | 5 | 5000 |
Product A needs 3 components of B and 2 components of C. Component B on the...
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...
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 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...
The bill of materials and the data from the inventory records for product A are shown in the figure to the right. Assume that the MPS start quantities for A are 100 units in weeks 1, 2, and 7. Derive an MRP plan for the components going into product A using the data in the table below Item Data Category L4L 2 weeks 100 (week 2) 350 L4L 1 week None 215 Lot-sizing rule Lead time Scheduled receipts Beginning inventory...
Question #1 : The product structure tree of a round-top computer desk is given as follows. On-hand inventory information is given in the Table 1 as follows. Level 0 Round-top computer desk (A) Level 1 B(4) C(2) Level 2 E(2) F(3) E(3) D(2) D(1) D(3) Level 3 Table 1: On-hand inventory Item On hand (units) Round-top com r desk 100 48 20 1) Determine number of units of each item required to satisfy a new order of 10 round-top computer...
Show work on excel QM to do this thanks Consider the bill of material for Product "T'h: To make one unit of"T, it needs one unit of"x" and two units of"M. To make one unit of K, it requires 4 units (Corrected) of ". The gross requirements for J are 200 units in week 6 and 250 units in week 8. Use the data given in the following table, develop the MRP tables for each item for an 8-week planning...
Product A is made from components B and C. Item B, in turn, is made from D and E. Item C also is an intermediate item, made from F and H. Finally, intermediate item E is made from H and G. Note that item H has two parents. The following are item lead times: A B D Item Lead Time (weeks) a. What lead time (in weeks) inventories or scheduled receipts?weeks. (Enter your response as an integer.) 4 2 5...
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...