Item A has a gross requirement of 2,400 in week 6. Currently, there are 200 Item A's on hand with a scheduled receipt of 2,100 items in week 3. The lead time for item A is 2 weeks with an order quantity of 900. Complete the MRP record for Item A. Complete the MRP record for Item A (enter your responses as whole numbers). 0 1 2 3 Week Item ALT=2 Quantity: FOQ=900 Gross Requirements 7 4 0 5 6

Item A has a gross requirement of 2,400 in week 6. Currently, there are 200 Item A's on hand with a scheduled receipt of 2,100 items in week 3. The lead time for item A is 2 weeks with an order quantity of 900. Complete the MRP record for Item A. Complete the MRP record for Item A (enter your responses as whole numbers). 0 1 2 3 Week Item ALT=2 Quantity: FOQ=900 Gross Requirements 7 4 0 5 6

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

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 used for Items A, B, and F; lots of size 55, 55, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 160, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 60 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 32 units of A are required in Week 8, use the low-level-coded bill of materials to find the necessary planned order releases for all components
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 used for items A, B, and F; lots of size 50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 150, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in week 2, 50 units of E in week 1, and also 50 units of F in week 1. There are no other scheduled receipts. If 30 units ofA are required in week 8, use the low-level-coded bill-of-materials to find the necessaryplanned-order releases for all components.
Discuss the meaning of MRP terms such as planned order release and the scheduled order receipt.
Which of the following is the planned-order release using an MRP program if the gross requirement is 5,000, inventory on hand is 1,200, and planned receipts are 800?
The planned order receipt for item A is 200 in week 5 and the lead time is 3 weeks. Which week should the planned order release be?
Product A is made from components B, C, and D. Item B is asubassembly that requires two units of C and one unit of E.Item D also is an intermediate item, made from two unitsof F. All other usage quantities are two. Draw the BOM forproduct A.
One unit of A is made of three units of B, one unit of C, and two units of D. B is composedof two units of E and one unit of D. C is made of one unit of B and two units of E. E ismade of one unit of F.Items B, C, E, and F have one-week lead times; A and D have lead times oftwo weeks.Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have onhand(beginning) inventories of 10, 50, and 150, respectively; all other items have zerobeginning inventory. We are scheduled to receive 10 units of A in Week 2, 50 units of Ein Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If30 units of A are required in Week 8, use the low-level-coded bill-of-materials to i nd thenecessary planned order releases for all components.
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 three weeks. Lot-for-lot (L4L) lot sizing is used for Items A, D, and E; lots of size 50, 100, and 50 are used for Items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 15, 55, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 1, 100 units of C in Week 1, and 100 units of D in Week 3; there are no other scheduled receipts.If 50 units of A are required in week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned-order releases for all components. (Leave the cells blank, whenever zero (0) is required.)
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 three weeks. Lot-for-lot (L4L) lot sizing is used for items A, D, and E; lots of sizes 50, 100, and 50 are used for items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 20, 50, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in week 1, 100 units of C in week 1, and 100 units of D in week 3; there are no other scheduled receipts. If 50 units of A are required in week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned-order releases for all components.
Product A is made from components B and C. Item B, inturn, is made from D and E. Item C also is an intermediateitem, made from F and H. Finally, intermediate item E ismade from H and G. Note that item H has two parents. Thefollowing are item lead times:a. What lead time (in weeks) is needed to respond to a cus-tomer order for product A, assuming no existing invento-ries or scheduled receipts?b. What is the customer response time if all purchased items(i.e., D, F, G, and H) are in inventory?c. If you are allowed to keep just one purchased item instock, which one would you choose?
Product A is made from components B and C. Item B, inturn, is made from D and E. Item C also is an intermediateitem, made from F and H. Finally, intermediate item E ismade from H and G. Note that item H has two parents. Thefollowing are item lead times: a. What lead time (in weeks) is needed to respond to a cus-tomer order for product A, assuming no existing invento-ries or scheduled receipts?b. What is the customer response time if all purchased items(i.e., D, F, G, and H) are in inventory?c. If you are allowed to keep just one purchased item instock, which one would you choose?
In a MRP problem, A is a MPS item. Every A requires 2 B’s and 3 C’s. Every B requires 5 C’s. All lead times are two periods. All initial inventory values are 0. Use lot-for-lot method for order quantities for all items. What is the low level code (LLC) for B and C?