Assume that Product Z is made of two units of A and four units of B. A is made of three units of C and three of D. D is made of three units of E
Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks.
Fifty seven units of Product Z are required in Period 10. (Assume that there is currently no inventory on hand of any of these items.)
b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.)
Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
Item Z OH = 0 LT = 2 SS = 0 Q = L4L |
Gross requirements | ||||||||||
Scheduled receipts | |||||||||||
Projected available balance | |||||||||||
Net requirements | |||||||||||
Planned order receipts | |||||||||||
Planned order releases | |||||||||||
Item A OH = 0 LT = 1 SS = 0 Q = L4L |
Gross requirements | ||||||||||
Scheduled receipts | |||||||||||
Projected available balance | |||||||||||
Net requirements | |||||||||||
Planned order receipts | |||||||||||
Planned order releases | |||||||||||
Item B OH = 0 LT = 1 SS = 0 Q = L4L |
Gross requirements | ||||||||||
Scheduled receipts | |||||||||||
Projected available balance | |||||||||||
Net requirements | |||||||||||
Planned order receipts | |||||||||||
Planned order releases | |||||||||||
Item C OH = 0 LT = 1 SS = 0 Q = L4L |
Gross requirements | ||||||||||
Scheduled receipts | |||||||||||
Projected available balance | |||||||||||
Net requirements | |||||||||||
Planned order receipts | |||||||||||
Planned order releases | |||||||||||
Item D OH = 0 LT = 1 SS = 0 Q = L4L |
Gross requirements | ||||||||||
Scheduled receipts | |||||||||||
Projected available balance | |||||||||||
Net requirements | |||||||||||
Planned order receipts | |||||||||||
Planned order releases | |||||||||||
Item E OH = 0 LT = 3 SS = 0 Q = L4L |
Gross requirements | ||||||||||
Scheduled receipts | |||||||||||
Projected available balance | |||||||||||
Net requirements | |||||||||||
Planned order receipts | |||||||||||
Planned order releases | |||||||||||
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Item: | Z | Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57 | |
OH = | 0 | Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
LT = | 2 | Projected available balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
SS = | 0 | Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57 | |
Q = | L4L | Planned order receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57 | |
Planned order releases | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57 | 0 | 0 | |||
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Item: | A | Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 114 | 0 | 0 | |
OH = | 0 | Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
LT = | 1 | Projected available balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
SS = | 0 | Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 114 | 0 | 0 | |
Q = | L4L | Planned order receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 114 | 0 | 0 | |
Planned order releases | 0 | 0 | 0 | 0 | 0 | 0 | 114 | 0 | 0 | 0 | |||
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Item: | B | Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 228 | 0 | 0 | |
OH = | 0 | Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
LT = | 1 | Projected available balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
SS = | 10 | Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 228 | 0 | 0 | |
Q = | L4L | Planned order receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 228 | 0 | 0 | |
Planned order releases | 0 | 0 | 0 | 0 | 0 | 0 | 228 | 0 | 0 | 0 | |||
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Item: | C | Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 0 | 0 | |
OH = | 0 | Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
LT = | 1 | Projected available balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
SS = | 0 | Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 0 | 0 | |
Q = | L4L | Planned order receipts | 0 | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 0 | 0 | |
Planned order releases | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 0 | 0 | 0 | |||
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Item: | D | Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 0 | 0 | |
OH = | 0 | Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
LT = | 1 | Projected available balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
SS = | 0 | Net requirements | 0 | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 0 | 0 | |
Q = | L4L | Planned order receipts | 0 | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 0 | 0 | |
Planned order releases | 0 | 0 | 0 | 0 | 0 | 342 | 0 | 0 | 0 | 0 | |||
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Item: | E | Gross requirements | 0 | 0 | 0 | 0 | 0 | 1026 | 0 | 0 | 0 | 0 | |
OH = | 0 | Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
LT = | 3 | Projected available balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
SS = | 0 | Net requirements | 0 | 0 | 0 | 0 | 0 | 1026 | 0 | 0 | 0 | 0 | |
Q = | L4L | Planned order receipts | 0 | 0 | 0 | 0 | 0 | 1026 | 0 | 0 | 0 | 0 | |
Planned order releases | 0 | 0 | 1026 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Assume that Product Z is made of two units of A and four units of B....
Assume that Product Z is made of two units of A and four units of B. A is made of three units of C and four of D. D is made of two units of E. Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Fifty units of Product Z are required in Period 10. (Assume that there...
Assume that Product Z is made of two units of A and three units of B. A is made of four units of C and four of D. D is made of two units of E Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Fifty one units of Product Z are required in Period 10. (Assume that...
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 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 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...
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...
Please help me correct this question. Thanks Problem 9-12 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...