Question

1. Develop an MRP record for six periods using the following information: period 1 2 3...

1. Develop an MRP record for six periods using the following information:

period

1

2

3

4

5

6

gross requirements

20

20

40

30

30

27

scheduled receipts

50

projected available balance

2

planned order receipt

planned order release

Lead time = 1 period, lot size = 50 units, safety stock = 0 units, current inventory (prior to period 1) = 2 units, scheduled receipts = 50 units in period 1.

What is the ending value of the projected available balance (in period 6)?

2.

Develop an MRP record for six periods using the following information:

period

1

2

3

4

5

6

gross requirements

20

20

40

30

30

38

scheduled receipts

50

projected available balance

2

planned order receipt

planned order release

Lead time = 1 period, lot size = 50 units, safety stock = 15 units, current inventory (prior to period 1) = 2 units, scheduled receipts = 50 units in period 1. (Notice that the safety stock is 15 units)

What is the ending value of the projected available balance (in period 6)?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Q1)

Q2)

Add a comment
Know the answer?
Add Answer to:
1. Develop an MRP record for six periods using the following information: period 1 2 3...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. 1 Complete the following MRP matrix for item A. Then answer the questions that follow....

    1. 1 Complete the following MRP matrix for item A. Then answer the questions that follow. When are planned orders scheduled to be released? (Hint: it's the last row of the matrix). Item:  A                    LLC: 1 Period Lot size:  Mult 50       LT:   2 1 2 3 4 5 6 7 8 Gross Requirements 10 15 25 75 60 85 45 60 Scheduled Receipts Projected on Hand         | 50 Net Requirements Planned Order Receipts Planned Order Releases A. Periods 2 through 6 B....

  • Complete the MRP record for a bicycle seat. MRP Record Part Name: Seat Lead time =...

    Complete the MRP record for a bicycle seat. MRP Record Part Name: Seat Lead time = 1 week On-hand = 40 Safety stock = 20 Order quantity: FOQ = 100 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Gross requirements 70 50 80 80 70 60 80 80 Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases

  • One unit of A is made of three units of B, one unit of C, and...

    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 tw...

    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...

  • In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order...

    In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time is one week. (Leave no cells blank - be certain to enter "0" wherever required.) WEEK NUMBER ITEM J 0 1 2 3 4 5 Gross requirements 75 50 70 On hand 40 Net requirements Planned order receipt Planned order release Period 1 2 3 4 5 Item J OH = 40...

  • Fill in the blanks In the following MRP planning schedule for Item J, indicate the correct...

    Fill in the blanks In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time is one week. (Leave no cells blank - be certain to enter "0" wherever required.) WEEK NUMBER 0 4 50 5 70 75 40 ITEM J Gross requirements On hand Net requirements Planned order receipt Planned order release 75 50 70 Period Gross requirements Item J Scheduled receipts...

  • Material Requirements Planning (MRP) Given the product tree diagram and develop a material requirements plan for...

    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...

  • Download HW 15 (Excel download) and perform the necessary MRP calculations. Then enter selected v...

    Download HW 15 (Excel download) and perform the necessary MRP calculations. Then enter selected values below. What is the Parent's Net Requirements for Period 5? What is the Parent's Net Requirements for Period 8? What is the Parent's Planned Order Receipts for Period 6? What is Part 1's Net Requirements for Period 8? What is the Part 1's Net Requirements for Period 5? What is the Part 1's Planned Order Release for Period 5? What is Part 2's Gross Requirements...

  • Download HW 15 (Excel download) and perform the necessary MRP calculations. Then enter selected values below....

    Download HW 15 (Excel download) and perform the necessary MRP calculations. Then enter selected values below. What is the Parent's Net Requirements for Period 5? What is the Parent's Net Requirements for Period 8? What is the Parent's Planned Order Receipts for Period 6? What is Part 1's Net Requirements for Period 8? What is the Part 1's Net Requirements for Period 5? What is the Part 1's Planned Order Release for Period 5? What is Part 2's Gross Requirements...

  • MRP /ERP IN M 1) Each E subassembly is made up of two (2) G parts, four (5) H part, and One J par...

    MRP /ERP IN M 1) Each E subassembly is made up of two (2) G parts, four (5) H part, and One J part Draw the product structure tree diagram. the information provided below, complete the following MRP Record Transaction Processing for Part E and Part G only if the following information is provided (Do not order more quantity of any resources that is needed to maintain the production) sing the product structure free diagram and Subassembly Part Part Part...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT