Determine material requirements plans for pans N and V and subassembly I as described in Solved Problem 3 for each of the following: a. Assume that there are currently 100 Ns on hand and scheduled receipts of 40 Is and 10 Vs at the beginning of week 3. No Es are on hand: 120 Es are needed at the start of week 5. b. Assume on-hand and scheduled receipts as in part a. Now suppose that 100 Es are needed at the stmt of week 5 and 55 at the start of week 7. Also, use multiples of these order sizes: N, 800; V, 200. Use lot-for-lot ordering for I. C. Using your answer to part b, update the MRP for V, using the following additional information for each of these cases: (1) one week has elapsed (making it the start of week 2), and (2) three weeks have elapsed (making it the start of week 4). The updated master schedule now has an order for 100 units of E in week 9. Your plan should cover weeks 2 through 9 for case 1, and weeks 4 through 11 for case 2. Assume all orders are released and received as planned.

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 12, Problem 11P

Determine material requirements plans for pans N and V and subassembly I as described in Solved Problem 3 for each of the following:

a. Assume that there are currently 100 Ns on hand and scheduled receipts of 40 Is and 10 Vs at the beginning of week 3. No Es are on hand: 120 Es are needed at the start of week 5.

b. Assume on-hand and scheduled receipts as in part a. Now suppose that 100 Es are needed at the stmt of week 5 and 55 at the start of week 7. Also, use multiples of these order sizes: N, 800; V, 200. Use lot-for-lot ordering for I.

C. Using your answer to part b, update the MRP for V, using the following additional information for each of these cases: (1) one week has elapsed (making it the start of week 2), and (2) three weeks have elapsed (making it the start of week 4).

The updated master schedule now has an order for 100 units of E in week 9. Your plan should cover weeks 2 through 9 for case 1, and weeks 4 through 11 for case 2. Assume all orders are released and received as planned.

a)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which is used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of Week 3. 120 units of Component E are needed at the beginning of Week 5.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 1

Prepare master schedule:

Week	1	2	3	4	5	6	7	8
Quantity					120

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 2

It is given that Person X has received an order to deliver 120 units of End item E, which must be shipped at the start of week 5.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 120 units (120-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 120 units in the beginning of week 5. Hence, they need to order for 120 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 3

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units on week 4 (240-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 200 units in the beginning of week 4. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+200−240)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 4

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 700 units on week 3 (800-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100−700+800)+0=0

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 5

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 190 units on week 3 (200-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+190−200)+0=0

b)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of week 3. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 6

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 7

It is given that Person X has received an order to deliver 100 units of End item E in the start of week 5 and 55 units of End item E in the start of week 7.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units in week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of Week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 8

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 9

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 540 units on week 3 (640-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 540 units in the beginning of week 3. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100+800−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 10

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 150 units on week 3 (160-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 150 units in the beginning of week 3. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+200−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

c)

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 11

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 12

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 13

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 14

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 15

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 16

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 17

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 18

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 19

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 20

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

2)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Planned order releases from 2^nd and 3^rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4^th week, 800 units of Component N at the start of 5^th week, and 200 units of Component V at the start of 5^th week.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 21

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 22

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 23

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 40 units.
Scheduled receipt is 160 units at the beginning of week 4.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(200+0−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 24

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 260 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+0−0)+800=1,060

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(1,060+0−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 25

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 50 units.
Scheduled receipt is 200 units at the beginning of week 5.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(250+0−110)+0=140

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

The Harvey Motorcycle Company produces three models: the Tiger, a sure-footed dirt bike; the LX2000, a nimble cafe racer; and the Golden, a large interstate tourer. The month's master production schedule calls for the production of 32 Goldens, 31 LX2000s, and 38 Tigers per 10-hour shift. What average cycle time is required for the assembly line to achieve the production quota in 10 hours? 0.099 hours per motorcycle. (Enter your response rounded to three decimal places.) If mixed-model scheduling is used, how many of each model will be produced before the production cycle is repeated? The greatest common divisor of the production requirements is Therefore, the Harvey Motorcycle Company will produce Goldens, LX2000s, and Tigers. (Enter your responses as integers.)

The Harvey Motorcycle Company produces three models: the Tiger, a sure-footed dirt bike; the LX2000, a nimble cafe racer; and the Golden, a large interstate tourer. The month's master production schedule calls for the production of 32 Goldens, 31 LX2000s, and 38 Tigers per 10-hour shift. What average cycle time is required for the assembly line to achieve the production quota in 10 hours? hours per motorcycle. (Enter your response rounded to three decimal places.)

The binding constraints for this problem are the second and third constraints are binding. Min x1 + 2x2 s.t. x1 + x2 ≤ 300 2x1 + x2 ≥ 400 2x1 + 5x2 ≥750 X1, X220 (a) Keeping the second objective function coefficient fixed at 2, over what range can the first objective function coefficient vary before there is a change in the optimal solution point? The first objective coefficient can from a low of to a high of (b) Keeping the first objective function coefficient fixed at 1, over what range can the second objective function coefficient vary before there is a change in the optimal solution point? The second objective coefficient can from a low of to a high of (c) If the objective function becomes Min 1.5x₁ + 2x2, what will be the optimal values of x1 and x2? x1 = X2 = What is the value of the objective function at the minimum? (d) If the objective function becomes Min 7x₁ + 6x2, what constraints will be binding? (Select all that apply.) First Constraint Second Constraint Third Constraint…

Answer 2

Textbook Question

Chapter 12, Problem 11P

Determine material requirements plans for pans N and V and subassembly I as described in Solved Problem 3 for each of the following:

a. Assume that there are currently 100 Ns on hand and scheduled receipts of 40 Is and 10 Vs at the beginning of week 3. No Es are on hand: 120 Es are needed at the start of week 5.

b. Assume on-hand and scheduled receipts as in part a. Now suppose that 100 Es are needed at the stmt of week 5 and 55 at the start of week 7. Also, use multiples of these order sizes: N, 800; V, 200. Use lot-for-lot ordering for I.

C. Using your answer to part b, update the MRP for V, using the following additional information for each of these cases: (1) one week has elapsed (making it the start of week 2), and (2) three weeks have elapsed (making it the start of week 4).

The updated master schedule now has an order for 100 units of E in week 9. Your plan should cover weeks 2 through 9 for case 1, and weeks 4 through 11 for case 2. Assume all orders are released and received as planned.

a)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which is used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of Week 3. 120 units of Component E are needed at the beginning of Week 5.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 1

Prepare master schedule:

Week	1	2	3	4	5	6	7	8
Quantity					120

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 2

It is given that Person X has received an order to deliver 120 units of End item E, which must be shipped at the start of week 5.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 120 units (120-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 120 units in the beginning of week 5. Hence, they need to order for 120 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 3

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units on week 4 (240-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 200 units in the beginning of week 4. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+200−240)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 4

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 700 units on week 3 (800-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100−700+800)+0=0

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 5

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 190 units on week 3 (200-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+190−200)+0=0

b)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of week 3. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 6

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 7

It is given that Person X has received an order to deliver 100 units of End item E in the start of week 5 and 55 units of End item E in the start of week 7.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units in week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of Week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 8

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 9

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 540 units on week 3 (640-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 540 units in the beginning of week 3. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100+800−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 10

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 150 units on week 3 (160-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 150 units in the beginning of week 3. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+200−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

c)

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 11

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 12

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 13

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 14

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 15

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 16

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 17

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 18

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 19

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 20

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

2)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Planned order releases from 2^nd and 3^rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4^th week, 800 units of Component N at the start of 5^th week, and 200 units of Component V at the start of 5^th week.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 21

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 22

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 23

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 40 units.
Scheduled receipt is 160 units at the beginning of week 4.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(200+0−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 24

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 260 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+0−0)+800=1,060

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(1,060+0−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 25

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 50 units.
Scheduled receipt is 200 units at the beginning of week 5.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(250+0−110)+0=140

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

The Harvey Motorcycle Company produces three models: the Tiger, a sure-footed dirt bike; the LX2000, a nimble cafe racer; and the Golden, a large interstate tourer. The month's master production schedule calls for the production of 32 Goldens, 31 LX2000s, and 38 Tigers per 10-hour shift. What average cycle time is required for the assembly line to achieve the production quota in 10 hours? 0.099 hours per motorcycle. (Enter your response rounded to three decimal places.) If mixed-model scheduling is used, how many of each model will be produced before the production cycle is repeated? The greatest common divisor of the production requirements is Therefore, the Harvey Motorcycle Company will produce Goldens, LX2000s, and Tigers. (Enter your responses as integers.)

The Harvey Motorcycle Company produces three models: the Tiger, a sure-footed dirt bike; the LX2000, a nimble cafe racer; and the Golden, a large interstate tourer. The month's master production schedule calls for the production of 32 Goldens, 31 LX2000s, and 38 Tigers per 10-hour shift. What average cycle time is required for the assembly line to achieve the production quota in 10 hours? hours per motorcycle. (Enter your response rounded to three decimal places.)

The binding constraints for this problem are the second and third constraints are binding. Min x1 + 2x2 s.t. x1 + x2 ≤ 300 2x1 + x2 ≥ 400 2x1 + 5x2 ≥750 X1, X220 (a) Keeping the second objective function coefficient fixed at 2, over what range can the first objective function coefficient vary before there is a change in the optimal solution point? The first objective coefficient can from a low of to a high of (b) Keeping the first objective function coefficient fixed at 1, over what range can the second objective function coefficient vary before there is a change in the optimal solution point? The second objective coefficient can from a low of to a high of (c) If the objective function becomes Min 1.5x₁ + 2x2, what will be the optimal values of x1 and x2? x1 = X2 = What is the value of the objective function at the minimum? (d) If the objective function becomes Min 7x₁ + 6x2, what constraints will be binding? (Select all that apply.) First Constraint Second Constraint Third Constraint…

Answer 3

Textbook Question

Chapter 12, Problem 11P

Determine material requirements plans for pans N and V and subassembly I as described in Solved Problem 3 for each of the following:

a. Assume that there are currently 100 Ns on hand and scheduled receipts of 40 Is and 10 Vs at the beginning of week 3. No Es are on hand: 120 Es are needed at the start of week 5.

b. Assume on-hand and scheduled receipts as in part a. Now suppose that 100 Es are needed at the stmt of week 5 and 55 at the start of week 7. Also, use multiples of these order sizes: N, 800; V, 200. Use lot-for-lot ordering for I.

C. Using your answer to part b, update the MRP for V, using the following additional information for each of these cases: (1) one week has elapsed (making it the start of week 2), and (2) three weeks have elapsed (making it the start of week 4).

The updated master schedule now has an order for 100 units of E in week 9. Your plan should cover weeks 2 through 9 for case 1, and weeks 4 through 11 for case 2. Assume all orders are released and received as planned.

a)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which is used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of Week 3. 120 units of Component E are needed at the beginning of Week 5.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 1

Prepare master schedule:

Week	1	2	3	4	5	6	7	8
Quantity					120

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 2

It is given that Person X has received an order to deliver 120 units of End item E, which must be shipped at the start of week 5.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 120 units (120-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 120 units in the beginning of week 5. Hence, they need to order for 120 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 3

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units on week 4 (240-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 200 units in the beginning of week 4. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+200−240)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 4

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 700 units on week 3 (800-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100−700+800)+0=0

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 5

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 190 units on week 3 (200-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+190−200)+0=0

b)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of week 3. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 6

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 7

It is given that Person X has received an order to deliver 100 units of End item E in the start of week 5 and 55 units of End item E in the start of week 7.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units in week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of Week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 8

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 9

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 540 units on week 3 (640-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 540 units in the beginning of week 3. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100+800−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 10

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 150 units on week 3 (160-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 150 units in the beginning of week 3. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+200−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

c)

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 11

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 12

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 13

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 14

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 15

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 16

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 17

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 18

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 19

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 20

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

2)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Planned order releases from 2^nd and 3^rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4^th week, 800 units of Component N at the start of 5^th week, and 200 units of Component V at the start of 5^th week.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 21

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 22

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 23

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 40 units.
Scheduled receipt is 160 units at the beginning of week 4.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(200+0−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 24

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 260 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+0−0)+800=1,060

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(1,060+0−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 25

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 50 units.
Scheduled receipt is 200 units at the beginning of week 5.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(250+0−110)+0=140

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 12, Problem 11P

Determine material requirements plans for pans N and V and subassembly I as described in Solved Problem 3 for each of the following:

a. Assume that there are currently 100 Ns on hand and scheduled receipts of 40 Is and 10 Vs at the beginning of week 3. No Es are on hand: 120 Es are needed at the start of week 5.

b. Assume on-hand and scheduled receipts as in part a. Now suppose that 100 Es are needed at the stmt of week 5 and 55 at the start of week 7. Also, use multiples of these order sizes: N, 800; V, 200. Use lot-for-lot ordering for I.

C. Using your answer to part b, update the MRP for V, using the following additional information for each of these cases: (1) one week has elapsed (making it the start of week 2), and (2) three weeks have elapsed (making it the start of week 4).

The updated master schedule now has an order for 100 units of E in week 9. Your plan should cover weeks 2 through 9 for case 1, and weeks 4 through 11 for case 2. Assume all orders are released and received as planned.

a)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which is used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of Week 3. 120 units of Component E are needed at the beginning of Week 5.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 1

Prepare master schedule:

Week	1	2	3	4	5	6	7	8
Quantity					120

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 2

It is given that Person X has received an order to deliver 120 units of End item E, which must be shipped at the start of week 5.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 120 units (120-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 120 units in the beginning of week 5. Hence, they need to order for 120 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 3

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units on week 4 (240-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 200 units in the beginning of week 4. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+200−240)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 4

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 700 units on week 3 (800-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100−700+800)+0=0

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 5

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 190 units on week 3 (200-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+190−200)+0=0

b)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of week 3. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 6

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 7

It is given that Person X has received an order to deliver 100 units of End item E in the start of week 5 and 55 units of End item E in the start of week 7.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units in week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of Week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 8

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 9

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 540 units on week 3 (640-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 540 units in the beginning of week 3. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100+800−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 10

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 150 units on week 3 (160-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 150 units in the beginning of week 3. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+200−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

c)

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 11

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 12

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 13

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 14

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 15

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 16

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 17

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 18

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 19

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 20

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

2)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Planned order releases from 2^nd and 3^rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4^th week, 800 units of Component N at the start of 5^th week, and 200 units of Component V at the start of 5^th week.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 21

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 22

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 23

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 40 units.
Scheduled receipt is 160 units at the beginning of week 4.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(200+0−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 24

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 260 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+0−0)+800=1,060

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(1,060+0−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 25

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 50 units.
Scheduled receipt is 200 units at the beginning of week 5.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(250+0−110)+0=140

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

a)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which is used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of Week 3. 120 units of Component E are needed at the beginning of Week 5.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 1

Prepare master schedule:

Week	1	2	3	4	5	6	7	8
Quantity					120

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 2

It is given that Person X has received an order to deliver 120 units of End item E, which must be shipped at the start of week 5.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 120 units (120-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 120 units in the beginning of week 5. Hence, they need to order for 120 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 3

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units on week 4 (240-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 200 units in the beginning of week 4. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+200−240)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 4

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 700 units on week 3 (800-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100−700+800)+0=0

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 5

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 190 units on week 3 (200-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+190−200)+0=0

b)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of week 3. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 6

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 7

It is given that Person X has received an order to deliver 100 units of End item E in the start of week 5 and 55 units of End item E in the start of week 7.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units in week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of Week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 8

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 9

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 540 units on week 3 (640-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 540 units in the beginning of week 3. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100+800−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 10

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 150 units on week 3 (160-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 150 units in the beginning of week 3. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+200−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

c)

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 11

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 12

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 13

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 14

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 15

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 16

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 17

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 18

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 19

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 20

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

2)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Planned order releases from 2^nd and 3^rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4^th week, 800 units of Component N at the start of 5^th week, and 200 units of Component V at the start of 5^th week.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 21

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 22

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 23

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 40 units.
Scheduled receipt is 160 units at the beginning of week 4.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(200+0−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 24

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 260 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+0−0)+800=1,060

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(1,060+0−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 25

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 50 units.
Scheduled receipt is 200 units at the beginning of week 5.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(250+0−110)+0=140

Answer 8

a)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which is used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of Week 3. 120 units of Component E are needed at the beginning of Week 5.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 1

Prepare master schedule:

Week	1	2	3	4	5	6	7	8
Quantity					120

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 2

It is given that Person X has received an order to deliver 120 units of End item E, which must be shipped at the start of week 5.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 120 units (120-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 120 units in the beginning of week 5. Hence, they need to order for 120 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 3

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units on week 4 (240-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 200 units in the beginning of week 4. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+200−240)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 4

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 700 units on week 3 (800-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100−700+800)+0=0

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 5

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 190 units on week 3 (200-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+190−200)+0=0

Answer 9

a)

Expert Solution

Answer 10

a)

Expert Solution

Answer 11

Expert Solution

Answer 12

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which is used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Answer 13

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of Week 3. 120 units of Component E are needed at the beginning of Week 5.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 1

Prepare master schedule:

Week	1	2	3	4	5	6	7	8
Quantity					120

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 2

It is given that Person X has received an order to deliver 120 units of End item E, which must be shipped at the start of week 5.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 120 units (120-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 120 units in the beginning of week 5. Hence, they need to order for 120 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 3

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units on week 4 (240-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 200 units in the beginning of week 4. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+200−240)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 4

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 700 units on week 3 (800-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100−700+800)+0=0

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 5

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 190 units on week 3 (200-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 0 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+190−200)+0=0

Answer 14

b)

Expert Solution

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of week 3. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 6

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 7

It is given that Person X has received an order to deliver 100 units of End item E in the start of week 5 and 55 units of End item E in the start of week 7.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units in week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of Week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 8

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 9

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 540 units on week 3 (640-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 540 units in the beginning of week 3. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100+800−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 10

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 150 units on week 3 (160-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 150 units in the beginning of week 3. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+200−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

Answer 15

b)

Expert Solution

Answer 16

b)

Expert Solution

Answer 17

Expert Solution

Answer 18

Summary Introduction

To prepare A Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Answer 19

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of week 3. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 6

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 7

It is given that Person X has received an order to deliver 100 units of End item E in the start of week 5 and 55 units of End item E in the start of week 7.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units in week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of Week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 8

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 9

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 540 units on week 3 (640-100).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 540 units in the beginning of week 3. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(100+800−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 10

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 10 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 150 units on week 3 (160-10).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 150 units in the beginning of week 3. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(10+200−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

Answer 20

c)

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 11

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 12

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 13

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 14

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 15

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 16

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 17

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 18

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 19

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 20

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

2)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Planned order releases from 2^nd and 3^rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4^th week, 800 units of Component N at the start of 5^th week, and 200 units of Component V at the start of 5^th week.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 21

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 22

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 23

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 40 units.
Scheduled receipt is 160 units at the beginning of week 4.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(200+0−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 24

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 260 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+0−0)+800=1,060

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(1,060+0−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 25

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 50 units.
Scheduled receipt is 200 units at the beginning of week 5.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(250+0−110)+0=140

Answer 21

c)

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 11

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 12

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 13

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 14

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 15

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

Answer 22

c)

1)

Expert Solution

Answer 23

Expert Solution

Answer 24

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Answer 25

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 11

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 12

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 13

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 14

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 15

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

Answer 26

1)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 16

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 17

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 18

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 19

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 20

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

Answer 27

1)

Expert Solution

Answer 28

1)

Expert Solution

Answer 29

Expert Solution

Answer 30

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Answer 31

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 16

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 17

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 18

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 0 units.
Scheduled receipt is 40 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(40+160−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 19

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 100 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
Projected on hand inventory for week 4 is 260 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(900+0−640)+0=260

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+800−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 20

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 0 units.
Scheduled receipt is 210 units at the beginning of week 3.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
Projected on hand inventory for week 4 is 50 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(210+0−160)+0=50

Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(50+200−110)+0=140

Answer 32

2)

Expert Solution

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Planned order releases from 2^nd and 3^rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4^th week, 800 units of Component N at the start of 5^th week, and 200 units of Component V at the start of 5^th week.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 21

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 22

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 23

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 40 units.
Scheduled receipt is 160 units at the beginning of week 4.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(200+0−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 24

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 260 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+0−0)+800=1,060

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(1,060+0−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 25

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 50 units.
Scheduled receipt is 200 units at the beginning of week 5.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(250+0−110)+0=140

Answer 33

2)

Expert Solution

Answer 34

2)

Expert Solution

Answer 35

Expert Solution

Answer 36

Summary Introduction

To prepare: Material requirement plan for the given information.

Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).

Answer 37

Explanation of Solution

Given information:

On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.

Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.

Planned order releases from 2^nd and 3^rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4^th week, 800 units of Component N at the start of 5^th week, and 200 units of Component V at the start of 5^th week.

Product structure tree:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 21

Develop a material requirement planning for End item E:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 22

It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
Beginning inventory is given as 0 units.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.

Develop a material requirement planning for Component I (2):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 23

End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
Beginning inventory is given as 40 units.
Scheduled receipt is 160 units at the beginning of week 4.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 0 units. Calculation is as follows:

Projected on hand for Week 5={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(200+0−200)+0=0

Develop a material requirement planning for Component N (4):

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 24

Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
Beginning inventory is given as 260 units.
Scheduled receipt is 800 units at the beginning of week 3
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:

Projected on hand for Week 4={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(260+0−0)+800=1,060

Projected on hand inventory for week 6 is 620 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(1,060+0−440)+0=620

Develop a material requirement planning for Component V:

Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 12, Problem 11P , additional homework tip 25

Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
Beginning inventory is given as 50 units.
Scheduled receipt is 200 units at the beginning of week 5.
Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
Planned order release is the order given by the company and planned order receipts is the order received by the firm.
Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
Projected on hand inventory for week 6 is 140 units. Calculation is as follows:

Projected on hand for Week 6={(Projected on-hand+Planned order receipt−Gross requirement)+Scheduled receipt}=(250+0−110)+0=140

Answer 38

Ch. 12.11 - What is ERP?Ch. 12.11 - What are the three main reasons firms adopt ERP?Ch. 12.11 - What are some hidden costs of ERP?Ch. 12.11 - How does ERP fit with e-commerce and supply chain...Ch. 12 - Contrast independent and dependent demand.Ch. 12 - When is MRP appropriate?Ch. 12 - Briefly define or explain each of these terms: a....Ch. 12 - Prob. 4DRQ Ch. 12 - Prob. 5DRQ Ch. 12 - What is meant by the term safety time?

Concept explainers

Videos

Explanation of Solution

Explanation of Solution

Explanation of Solution

Explanation of Solution

Explanation of Solution

Want to see more full solutions like this?

Chapter 12 Solutions

Additional Business Textbook Solutions