a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. Take into account that on hand there are 40 units of Z, 70 units of A, 100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units of component C in week 4. Lead times are two weeks for Z and B, and one week for the other components. Lot-for-lot ordering will be used for all items. b . Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as 50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are expected to arrive in week 4. Lead times are two weeks for E and C. and one week for the other components. Assume lot-for-lot ordering except for D. where multiples of 40 must be used.

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 12, Problem 5P

a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. Take into account that on hand there are 40 units of Z, 70 units of A, 100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units of component C in week 4. Lead times are two weeks for Z and B, and one week for the other components. Lot-for-lot ordering will be used for all items.

Chapter 12, Problem 5P, a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material , example 1

b. Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as 50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are expected to arrive in week 4. Lead times are two weeks for E and C. and one week for the other components. Assume lot-for-lot ordering except for D. where multiples of 40 must be used.

Chapter 12, Problem 5P, a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material , example 2

a)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component C.

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:

120 units of end item (Z) are required at the beginning of Week 7. It is given that 40 units of Component Z, 100 units of Component B, 70 units of Component A, and 30 units of Component C are available on hand. Scheduled receipt is 20 units of Component C in Week 4. Lead-time is given as 2 weeks for Component Z and Component B and 1 week for other components. Lot size is lot-for-lot.

In addition to the above information, the following diagram is given:

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

Prepare a Material Requirement Plan (MRP) for Component Z:

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

Gross requirement is given as 120 units at the beginning of Week 7.
On-hand inventory is 40 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=120−40=80

80 units are required at the beginning of Week 7. Hence, they need to order for 80 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(40+0−0)+0=40

Prepare a Material Requirement Plan (MRP) for Component A (2):

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

Component Z is the parent item of Component A (2). As the number of Component A is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component A.
On-hand inventory is 70 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=160−70=90

90 units are required at the beginning of Week 5. Hence, they need to order for 90 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(70+90−160)+0=0

Prepare a Material Requirement Plan (MRP) for Component B (4):

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

Component Z is the parent item of Component B (4). As the number of Component B is 4, the planned order release should be multiplied with 4 to determine the gross requirement of Component B.
On-hand inventory is 100 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=320−100=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(100+220−320)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (3) and C (2):

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

Component A (2) is the parent item of Component C (3) and Component B (4) is the parent item of Component C (2). As the number of Component C is 3, the planned order release of Component A should be multiplied with 3 to determine the gross requirement of Component C. The same should be followed for Component C (2) with its parent item B (4).
On-hand inventory is 30 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=440−30=410

410 units are required at the beginning of Week 3. Hence, they need to order for 410 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(30+410−440)+20=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+250−270)+0=0

b)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component D.

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:

95 units of end item (E) are required at the beginning of Week 7. It is given that 5 units of Component E, 50 units of Component B, 80 units of Component D, and 100 units of Component C are available on hand. Scheduled receipt is 30 units of Component C in Week 4. Lead-time is given as 2 weeks for Component E and Component C and 1 week for other components. Lot size is lot-for-lot for all the components except Component D. Lot size for Component C is multiples of 40.

In addition to the above information, the following diagram is given:

Prepare a Material Requirement Plan (MRP) for Component E:

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

Gross requirement is given as 95 units at the beginning of Week 7.
On-hand inventory is 5 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=95−5=90

90 units are required at the beginning of Week 7. Hence, they need to order for 90 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(5+0−0)+0=5

Prepare a Material Requirement Plan (MRP) for Component B (3):

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

Component E is the parent item of Component B (3). As the number of Component B is 3, the planned order release should be multiplied with 3 to determine the gross requirement of Component 3.
On-hand inventory is 50 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=270−50=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(50+220−270)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (2):

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

Component E is the parent item of Component C (2). As the number of Component C is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component C.
On-hand inventory is 100 units. It remains same until Week 3, as there is no demand. Scheduled receipts of 30 units arrived on Week 4. Hence, the on-hand inventory is 130 units on Week 4.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=180−130=50

50 units are required at the beginning of Week 5. Hence, they need to order for 50 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(130+0−0)+0=130

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(130+50−180)+0=0

Prepare a Material Requirement Plan (MRP) for Component D (2) and D (2):

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

Component B (3) is the parent item of Component D (2) and Component C (2) is the parent item of Component D (2). As the number of Component D is 2, the planned order release of Component B should be multiplied with 2 to determine the gross requirement of Component D. The same should be followed for Component D (2) with its parent item C (2).
On-hand inventory is 80 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=100−80=20

20 units are required at the beginning of Week 3. Hence, they need to order for 40 units (as the lot size is multiples of 40) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(80+40−100)+0=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+440−440)+0=20

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

Doctor E

Considering contemporary challenges in business, analyze a real-world case where a company successfully navigated a major shift in its marketing strategy to adapt to changing market dynamics. Discussion Question and Prompt: Identify the key factors that contributed to the success of their marketing strategy in the face of contemporary issues. How can businesses draw insights from this case to inform their own marketing strategies amid current business challenges?

1) View the video Service Processing at BuyCostumes (10.41 minutes, Ctrl+Click on the link); what are your key takeaways (tie to one or more of the topics discussed in Chapter 3) after watching this video. (viddler.com/embed/a6b7054c) Note: As a rough guideline, please try to keep the written submission to one or two paragraphs. 2) Orkhon Foods makes hand-held pies (among other products). The firm’s weekly sales of hand-held pies over the past seven weeks are given in the table. The firm’s operations manager, Amarjargal, wants to forecast sales for week 8. Weeks Sales of hand-held pies(000s) 1 19 2 18 3 17 4 20 5 18 6 22 7 20 Forecast the week 8 sales using the following approaches: a) Naïve approach b) 5-month moving average c) 3-month weighted moving average using the following weights: 0.50 for week 7, 0.30 for week 6, and 0.20 for week 5. d) Exponential smoothing using a smoothing constant of 0.30, assume a…

Answer 2

Textbook Question

Chapter 12, Problem 5P

a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. Take into account that on hand there are 40 units of Z, 70 units of A, 100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units of component C in week 4. Lead times are two weeks for Z and B, and one week for the other components. Lot-for-lot ordering will be used for all items.

Chapter 12, Problem 5P, a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material , example 1

b. Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as 50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are expected to arrive in week 4. Lead times are two weeks for E and C. and one week for the other components. Assume lot-for-lot ordering except for D. where multiples of 40 must be used.

Chapter 12, Problem 5P, a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material , example 2

a)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component C.

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:

120 units of end item (Z) are required at the beginning of Week 7. It is given that 40 units of Component Z, 100 units of Component B, 70 units of Component A, and 30 units of Component C are available on hand. Scheduled receipt is 20 units of Component C in Week 4. Lead-time is given as 2 weeks for Component Z and Component B and 1 week for other components. Lot size is lot-for-lot.

In addition to the above information, the following diagram is given:

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

Prepare a Material Requirement Plan (MRP) for Component Z:

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

Gross requirement is given as 120 units at the beginning of Week 7.
On-hand inventory is 40 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=120−40=80

80 units are required at the beginning of Week 7. Hence, they need to order for 80 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(40+0−0)+0=40

Prepare a Material Requirement Plan (MRP) for Component A (2):

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

Component Z is the parent item of Component A (2). As the number of Component A is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component A.
On-hand inventory is 70 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=160−70=90

90 units are required at the beginning of Week 5. Hence, they need to order for 90 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(70+90−160)+0=0

Prepare a Material Requirement Plan (MRP) for Component B (4):

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

Component Z is the parent item of Component B (4). As the number of Component B is 4, the planned order release should be multiplied with 4 to determine the gross requirement of Component B.
On-hand inventory is 100 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=320−100=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(100+220−320)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (3) and C (2):

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

Component A (2) is the parent item of Component C (3) and Component B (4) is the parent item of Component C (2). As the number of Component C is 3, the planned order release of Component A should be multiplied with 3 to determine the gross requirement of Component C. The same should be followed for Component C (2) with its parent item B (4).
On-hand inventory is 30 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=440−30=410

410 units are required at the beginning of Week 3. Hence, they need to order for 410 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(30+410−440)+20=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+250−270)+0=0

b)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component D.

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:

95 units of end item (E) are required at the beginning of Week 7. It is given that 5 units of Component E, 50 units of Component B, 80 units of Component D, and 100 units of Component C are available on hand. Scheduled receipt is 30 units of Component C in Week 4. Lead-time is given as 2 weeks for Component E and Component C and 1 week for other components. Lot size is lot-for-lot for all the components except Component D. Lot size for Component C is multiples of 40.

In addition to the above information, the following diagram is given:

Prepare a Material Requirement Plan (MRP) for Component E:

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

Gross requirement is given as 95 units at the beginning of Week 7.
On-hand inventory is 5 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=95−5=90

90 units are required at the beginning of Week 7. Hence, they need to order for 90 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(5+0−0)+0=5

Prepare a Material Requirement Plan (MRP) for Component B (3):

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

Component E is the parent item of Component B (3). As the number of Component B is 3, the planned order release should be multiplied with 3 to determine the gross requirement of Component 3.
On-hand inventory is 50 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=270−50=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(50+220−270)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (2):

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

Component E is the parent item of Component C (2). As the number of Component C is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component C.
On-hand inventory is 100 units. It remains same until Week 3, as there is no demand. Scheduled receipts of 30 units arrived on Week 4. Hence, the on-hand inventory is 130 units on Week 4.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=180−130=50

50 units are required at the beginning of Week 5. Hence, they need to order for 50 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(130+0−0)+0=130

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(130+50−180)+0=0

Prepare a Material Requirement Plan (MRP) for Component D (2) and D (2):

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

Component B (3) is the parent item of Component D (2) and Component C (2) is the parent item of Component D (2). As the number of Component D is 2, the planned order release of Component B should be multiplied with 2 to determine the gross requirement of Component D. The same should be followed for Component D (2) with its parent item C (2).
On-hand inventory is 80 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=100−80=20

20 units are required at the beginning of Week 3. Hence, they need to order for 40 units (as the lot size is multiples of 40) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(80+40−100)+0=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+440−440)+0=20

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 3

Textbook Question

Chapter 12, Problem 5P

a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. Take into account that on hand there are 40 units of Z, 70 units of A, 100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units of component C in week 4. Lead times are two weeks for Z and B, and one week for the other components. Lot-for-lot ordering will be used for all items.

Chapter 12, Problem 5P, a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material , example 1

b. Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as 50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are expected to arrive in week 4. Lead times are two weeks for E and C. and one week for the other components. Assume lot-for-lot ordering except for D. where multiples of 40 must be used.

Chapter 12, Problem 5P, a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material , example 2

a)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component C.

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:

120 units of end item (Z) are required at the beginning of Week 7. It is given that 40 units of Component Z, 100 units of Component B, 70 units of Component A, and 30 units of Component C are available on hand. Scheduled receipt is 20 units of Component C in Week 4. Lead-time is given as 2 weeks for Component Z and Component B and 1 week for other components. Lot size is lot-for-lot.

In addition to the above information, the following diagram is given:

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

Prepare a Material Requirement Plan (MRP) for Component Z:

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

Gross requirement is given as 120 units at the beginning of Week 7.
On-hand inventory is 40 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=120−40=80

80 units are required at the beginning of Week 7. Hence, they need to order for 80 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(40+0−0)+0=40

Prepare a Material Requirement Plan (MRP) for Component A (2):

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

Component Z is the parent item of Component A (2). As the number of Component A is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component A.
On-hand inventory is 70 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=160−70=90

90 units are required at the beginning of Week 5. Hence, they need to order for 90 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(70+90−160)+0=0

Prepare a Material Requirement Plan (MRP) for Component B (4):

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

Component Z is the parent item of Component B (4). As the number of Component B is 4, the planned order release should be multiplied with 4 to determine the gross requirement of Component B.
On-hand inventory is 100 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=320−100=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(100+220−320)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (3) and C (2):

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

Component A (2) is the parent item of Component C (3) and Component B (4) is the parent item of Component C (2). As the number of Component C is 3, the planned order release of Component A should be multiplied with 3 to determine the gross requirement of Component C. The same should be followed for Component C (2) with its parent item B (4).
On-hand inventory is 30 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=440−30=410

410 units are required at the beginning of Week 3. Hence, they need to order for 410 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(30+410−440)+20=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+250−270)+0=0

b)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component D.

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:

95 units of end item (E) are required at the beginning of Week 7. It is given that 5 units of Component E, 50 units of Component B, 80 units of Component D, and 100 units of Component C are available on hand. Scheduled receipt is 30 units of Component C in Week 4. Lead-time is given as 2 weeks for Component E and Component C and 1 week for other components. Lot size is lot-for-lot for all the components except Component D. Lot size for Component C is multiples of 40.

In addition to the above information, the following diagram is given:

Prepare a Material Requirement Plan (MRP) for Component E:

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

Gross requirement is given as 95 units at the beginning of Week 7.
On-hand inventory is 5 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=95−5=90

90 units are required at the beginning of Week 7. Hence, they need to order for 90 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(5+0−0)+0=5

Prepare a Material Requirement Plan (MRP) for Component B (3):

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

Component E is the parent item of Component B (3). As the number of Component B is 3, the planned order release should be multiplied with 3 to determine the gross requirement of Component 3.
On-hand inventory is 50 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=270−50=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(50+220−270)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (2):

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

Component E is the parent item of Component C (2). As the number of Component C is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component C.
On-hand inventory is 100 units. It remains same until Week 3, as there is no demand. Scheduled receipts of 30 units arrived on Week 4. Hence, the on-hand inventory is 130 units on Week 4.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=180−130=50

50 units are required at the beginning of Week 5. Hence, they need to order for 50 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(130+0−0)+0=130

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(130+50−180)+0=0

Prepare a Material Requirement Plan (MRP) for Component D (2) and D (2):

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

Component B (3) is the parent item of Component D (2) and Component C (2) is the parent item of Component D (2). As the number of Component D is 2, the planned order release of Component B should be multiplied with 2 to determine the gross requirement of Component D. The same should be followed for Component D (2) with its parent item C (2).
On-hand inventory is 80 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=100−80=20

20 units are required at the beginning of Week 3. Hence, they need to order for 40 units (as the lot size is multiples of 40) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(80+40−100)+0=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+440−440)+0=20

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 5P

a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. Take into account that on hand there are 40 units of Z, 70 units of A, 100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units of component C in week 4. Lead times are two weeks for Z and B, and one week for the other components. Lot-for-lot ordering will be used for all items.

Chapter 12, Problem 5P, a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material , example 1

b. Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as 50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are expected to arrive in week 4. Lead times are two weeks for E and C. and one week for the other components. Assume lot-for-lot ordering except for D. where multiples of 40 must be used.

Chapter 12, Problem 5P, a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material , example 2

a)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component C.

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:

120 units of end item (Z) are required at the beginning of Week 7. It is given that 40 units of Component Z, 100 units of Component B, 70 units of Component A, and 30 units of Component C are available on hand. Scheduled receipt is 20 units of Component C in Week 4. Lead-time is given as 2 weeks for Component Z and Component B and 1 week for other components. Lot size is lot-for-lot.

In addition to the above information, the following diagram is given:

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

Prepare a Material Requirement Plan (MRP) for Component Z:

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

Gross requirement is given as 120 units at the beginning of Week 7.
On-hand inventory is 40 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=120−40=80

80 units are required at the beginning of Week 7. Hence, they need to order for 80 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(40+0−0)+0=40

Prepare a Material Requirement Plan (MRP) for Component A (2):

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

Component Z is the parent item of Component A (2). As the number of Component A is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component A.
On-hand inventory is 70 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=160−70=90

90 units are required at the beginning of Week 5. Hence, they need to order for 90 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(70+90−160)+0=0

Prepare a Material Requirement Plan (MRP) for Component B (4):

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

Component Z is the parent item of Component B (4). As the number of Component B is 4, the planned order release should be multiplied with 4 to determine the gross requirement of Component B.
On-hand inventory is 100 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=320−100=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(100+220−320)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (3) and C (2):

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

Component A (2) is the parent item of Component C (3) and Component B (4) is the parent item of Component C (2). As the number of Component C is 3, the planned order release of Component A should be multiplied with 3 to determine the gross requirement of Component C. The same should be followed for Component C (2) with its parent item B (4).
On-hand inventory is 30 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=440−30=410

410 units are required at the beginning of Week 3. Hence, they need to order for 410 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(30+410−440)+20=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+250−270)+0=0

b)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component D.

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:

95 units of end item (E) are required at the beginning of Week 7. It is given that 5 units of Component E, 50 units of Component B, 80 units of Component D, and 100 units of Component C are available on hand. Scheduled receipt is 30 units of Component C in Week 4. Lead-time is given as 2 weeks for Component E and Component C and 1 week for other components. Lot size is lot-for-lot for all the components except Component D. Lot size for Component C is multiples of 40.

In addition to the above information, the following diagram is given:

Prepare a Material Requirement Plan (MRP) for Component E:

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

Gross requirement is given as 95 units at the beginning of Week 7.
On-hand inventory is 5 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=95−5=90

90 units are required at the beginning of Week 7. Hence, they need to order for 90 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(5+0−0)+0=5

Prepare a Material Requirement Plan (MRP) for Component B (3):

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

Component E is the parent item of Component B (3). As the number of Component B is 3, the planned order release should be multiplied with 3 to determine the gross requirement of Component 3.
On-hand inventory is 50 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=270−50=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(50+220−270)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (2):

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

Component E is the parent item of Component C (2). As the number of Component C is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component C.
On-hand inventory is 100 units. It remains same until Week 3, as there is no demand. Scheduled receipts of 30 units arrived on Week 4. Hence, the on-hand inventory is 130 units on Week 4.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=180−130=50

50 units are required at the beginning of Week 5. Hence, they need to order for 50 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(130+0−0)+0=130

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(130+50−180)+0=0

Prepare a Material Requirement Plan (MRP) for Component D (2) and D (2):

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

Component B (3) is the parent item of Component D (2) and Component C (2) is the parent item of Component D (2). As the number of Component D is 2, the planned order release of Component B should be multiplied with 2 to determine the gross requirement of Component D. The same should be followed for Component D (2) with its parent item C (2).
On-hand inventory is 80 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=100−80=20

20 units are required at the beginning of Week 3. Hence, they need to order for 40 units (as the lot size is multiples of 40) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(80+40−100)+0=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+440−440)+0=20

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 requirements plan for Component C.

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:

120 units of end item (Z) are required at the beginning of Week 7. It is given that 40 units of Component Z, 100 units of Component B, 70 units of Component A, and 30 units of Component C are available on hand. Scheduled receipt is 20 units of Component C in Week 4. Lead-time is given as 2 weeks for Component Z and Component B and 1 week for other components. Lot size is lot-for-lot.

In addition to the above information, the following diagram is given:

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

Prepare a Material Requirement Plan (MRP) for Component Z:

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

Gross requirement is given as 120 units at the beginning of Week 7.
On-hand inventory is 40 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=120−40=80

80 units are required at the beginning of Week 7. Hence, they need to order for 80 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(40+0−0)+0=40

Prepare a Material Requirement Plan (MRP) for Component A (2):

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

Component Z is the parent item of Component A (2). As the number of Component A is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component A.
On-hand inventory is 70 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=160−70=90

90 units are required at the beginning of Week 5. Hence, they need to order for 90 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(70+90−160)+0=0

Prepare a Material Requirement Plan (MRP) for Component B (4):

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

Component Z is the parent item of Component B (4). As the number of Component B is 4, the planned order release should be multiplied with 4 to determine the gross requirement of Component B.
On-hand inventory is 100 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=320−100=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(100+220−320)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (3) and C (2):

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

Component A (2) is the parent item of Component C (3) and Component B (4) is the parent item of Component C (2). As the number of Component C is 3, the planned order release of Component A should be multiplied with 3 to determine the gross requirement of Component C. The same should be followed for Component C (2) with its parent item B (4).
On-hand inventory is 30 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=440−30=410

410 units are required at the beginning of Week 3. Hence, they need to order for 410 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(30+410−440)+20=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+250−270)+0=0

b)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component D.

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:

95 units of end item (E) are required at the beginning of Week 7. It is given that 5 units of Component E, 50 units of Component B, 80 units of Component D, and 100 units of Component C are available on hand. Scheduled receipt is 30 units of Component C in Week 4. Lead-time is given as 2 weeks for Component E and Component C and 1 week for other components. Lot size is lot-for-lot for all the components except Component D. Lot size for Component C is multiples of 40.

In addition to the above information, the following diagram is given:

Prepare a Material Requirement Plan (MRP) for Component E:

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

Gross requirement is given as 95 units at the beginning of Week 7.
On-hand inventory is 5 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=95−5=90

90 units are required at the beginning of Week 7. Hence, they need to order for 90 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(5+0−0)+0=5

Prepare a Material Requirement Plan (MRP) for Component B (3):

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

Component E is the parent item of Component B (3). As the number of Component B is 3, the planned order release should be multiplied with 3 to determine the gross requirement of Component 3.
On-hand inventory is 50 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=270−50=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(50+220−270)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (2):

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

Component E is the parent item of Component C (2). As the number of Component C is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component C.
On-hand inventory is 100 units. It remains same until Week 3, as there is no demand. Scheduled receipts of 30 units arrived on Week 4. Hence, the on-hand inventory is 130 units on Week 4.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=180−130=50

50 units are required at the beginning of Week 5. Hence, they need to order for 50 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(130+0−0)+0=130

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(130+50−180)+0=0

Prepare a Material Requirement Plan (MRP) for Component D (2) and D (2):

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

Component B (3) is the parent item of Component D (2) and Component C (2) is the parent item of Component D (2). As the number of Component D is 2, the planned order release of Component B should be multiplied with 2 to determine the gross requirement of Component D. The same should be followed for Component D (2) with its parent item C (2).
On-hand inventory is 80 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=100−80=20

20 units are required at the beginning of Week 3. Hence, they need to order for 40 units (as the lot size is multiples of 40) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(80+40−100)+0=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+440−440)+0=20

Answer 8

a)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component C.

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:

120 units of end item (Z) are required at the beginning of Week 7. It is given that 40 units of Component Z, 100 units of Component B, 70 units of Component A, and 30 units of Component C are available on hand. Scheduled receipt is 20 units of Component C in Week 4. Lead-time is given as 2 weeks for Component Z and Component B and 1 week for other components. Lot size is lot-for-lot.

In addition to the above information, the following diagram is given:

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

Prepare a Material Requirement Plan (MRP) for Component Z:

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

Gross requirement is given as 120 units at the beginning of Week 7.
On-hand inventory is 40 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=120−40=80

80 units are required at the beginning of Week 7. Hence, they need to order for 80 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(40+0−0)+0=40

Prepare a Material Requirement Plan (MRP) for Component A (2):

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

Component Z is the parent item of Component A (2). As the number of Component A is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component A.
On-hand inventory is 70 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=160−70=90

90 units are required at the beginning of Week 5. Hence, they need to order for 90 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(70+90−160)+0=0

Prepare a Material Requirement Plan (MRP) for Component B (4):

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

Component Z is the parent item of Component B (4). As the number of Component B is 4, the planned order release should be multiplied with 4 to determine the gross requirement of Component B.
On-hand inventory is 100 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=320−100=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(100+220−320)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (3) and C (2):

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

Component A (2) is the parent item of Component C (3) and Component B (4) is the parent item of Component C (2). As the number of Component C is 3, the planned order release of Component A should be multiplied with 3 to determine the gross requirement of Component C. The same should be followed for Component C (2) with its parent item B (4).
On-hand inventory is 30 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=440−30=410

410 units are required at the beginning of Week 3. Hence, they need to order for 410 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(30+410−440)+20=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+250−270)+0=0

Answer 9

a)

Expert Solution

Answer 10

a)

Expert Solution

Answer 11

Expert Solution

Answer 12

Summary Introduction

To prepare: A material requirements plan for Component C.

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 13

Explanation of Solution

Given information:

120 units of end item (Z) are required at the beginning of Week 7. It is given that 40 units of Component Z, 100 units of Component B, 70 units of Component A, and 30 units of Component C are available on hand. Scheduled receipt is 20 units of Component C in Week 4. Lead-time is given as 2 weeks for Component Z and Component B and 1 week for other components. Lot size is lot-for-lot.

In addition to the above information, the following diagram is given:

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

Prepare a Material Requirement Plan (MRP) for Component Z:

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

Gross requirement is given as 120 units at the beginning of Week 7.
On-hand inventory is 40 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=120−40=80

80 units are required at the beginning of Week 7. Hence, they need to order for 80 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(40+0−0)+0=40

Prepare a Material Requirement Plan (MRP) for Component A (2):

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

Component Z is the parent item of Component A (2). As the number of Component A is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component A.
On-hand inventory is 70 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=160−70=90

90 units are required at the beginning of Week 5. Hence, they need to order for 90 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(70+90−160)+0=0

Prepare a Material Requirement Plan (MRP) for Component B (4):

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

Component Z is the parent item of Component B (4). As the number of Component B is 4, the planned order release should be multiplied with 4 to determine the gross requirement of Component B.
On-hand inventory is 100 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=320−100=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(100+220−320)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (3) and C (2):

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

Component A (2) is the parent item of Component C (3) and Component B (4) is the parent item of Component C (2). As the number of Component C is 3, the planned order release of Component A should be multiplied with 3 to determine the gross requirement of Component C. The same should be followed for Component C (2) with its parent item B (4).
On-hand inventory is 30 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=440−30=410

410 units are required at the beginning of Week 3. Hence, they need to order for 410 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(30+410−440)+20=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+250−270)+0=0

Answer 14

b)

Expert Solution

Summary Introduction

To prepare: A material requirements plan for Component D.

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:

95 units of end item (E) are required at the beginning of Week 7. It is given that 5 units of Component E, 50 units of Component B, 80 units of Component D, and 100 units of Component C are available on hand. Scheduled receipt is 30 units of Component C in Week 4. Lead-time is given as 2 weeks for Component E and Component C and 1 week for other components. Lot size is lot-for-lot for all the components except Component D. Lot size for Component C is multiples of 40.

In addition to the above information, the following diagram is given:

Prepare a Material Requirement Plan (MRP) for Component E:

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

Gross requirement is given as 95 units at the beginning of Week 7.
On-hand inventory is 5 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=95−5=90

90 units are required at the beginning of Week 7. Hence, they need to order for 90 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(5+0−0)+0=5

Prepare a Material Requirement Plan (MRP) for Component B (3):

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

Component E is the parent item of Component B (3). As the number of Component B is 3, the planned order release should be multiplied with 3 to determine the gross requirement of Component 3.
On-hand inventory is 50 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=270−50=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(50+220−270)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (2):

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

Component E is the parent item of Component C (2). As the number of Component C is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component C.
On-hand inventory is 100 units. It remains same until Week 3, as there is no demand. Scheduled receipts of 30 units arrived on Week 4. Hence, the on-hand inventory is 130 units on Week 4.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=180−130=50

50 units are required at the beginning of Week 5. Hence, they need to order for 50 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(130+0−0)+0=130

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(130+50−180)+0=0

Prepare a Material Requirement Plan (MRP) for Component D (2) and D (2):

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

Component B (3) is the parent item of Component D (2) and Component C (2) is the parent item of Component D (2). As the number of Component D is 2, the planned order release of Component B should be multiplied with 2 to determine the gross requirement of Component D. The same should be followed for Component D (2) with its parent item C (2).
On-hand inventory is 80 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=100−80=20

20 units are required at the beginning of Week 3. Hence, they need to order for 40 units (as the lot size is multiples of 40) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(80+40−100)+0=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+440−440)+0=20

Answer 15

b)

Expert Solution

Answer 16

b)

Expert Solution

Answer 17

Expert Solution

Answer 18

Summary Introduction

To prepare: A material requirements plan for Component D.

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:

95 units of end item (E) are required at the beginning of Week 7. It is given that 5 units of Component E, 50 units of Component B, 80 units of Component D, and 100 units of Component C are available on hand. Scheduled receipt is 30 units of Component C in Week 4. Lead-time is given as 2 weeks for Component E and Component C and 1 week for other components. Lot size is lot-for-lot for all the components except Component D. Lot size for Component C is multiples of 40.

In addition to the above information, the following diagram is given:

Prepare a Material Requirement Plan (MRP) for Component E:

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

Gross requirement is given as 95 units at the beginning of Week 7.
On-hand inventory is 5 units. It remains same until Week 6, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=95−5=90

90 units are required at the beginning of Week 7. Hence, they need to order for 90 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand=(Projected on-hand of Week 6+Planned order receipt of Week 6−Gross requirement of Week 6)+Scheduled receipt of current week=(5+0−0)+0=5

Prepare a Material Requirement Plan (MRP) for Component B (3):

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

Component E is the parent item of Component B (3). As the number of Component B is 3, the planned order release should be multiplied with 3 to determine the gross requirement of Component 3.
On-hand inventory is 50 units. It remains same until Week 4, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=270−50=220

220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(50+220−270)+0=0

Prepare a Material Requirement Plan (MRP) for Component C (2):

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

Component E is the parent item of Component C (2). As the number of Component C is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component C.
On-hand inventory is 100 units. It remains same until Week 3, as there is no demand. Scheduled receipts of 30 units arrived on Week 4. Hence, the on-hand inventory is 130 units on Week 4.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=180−130=50

50 units are required at the beginning of Week 5. Hence, they need to order for 50 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(130+0−0)+0=130

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 6}=(Projected on-hand of Week 5+Planned order receipt of Week 5−Gross requirement of Week 5)+Scheduled receipt of current week=(130+50−180)+0=0

Prepare a Material Requirement Plan (MRP) for Component D (2) and D (2):

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

Component B (3) is the parent item of Component D (2) and Component C (2) is the parent item of Component D (2). As the number of Component D is 2, the planned order release of Component B should be multiplied with 2 to determine the gross requirement of Component D. The same should be followed for Component D (2) with its parent item C (2).
On-hand inventory is 80 units. It remains same until Week 3, as there is no demand.
Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.

Net requirement=Gross requirement−On-hand units of previous week=100−80=20

20 units are required at the beginning of Week 3. Hence, they need to order for 40 units (as the lot size is multiples of 40) on previous week (as the lead-time is 1 week), which means on Week 2.
Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 4}=(Projected on-hand of Week 3+Planned order receipt of Week 3−Gross requirement of Week 3)+Scheduled receipt of current week=(80+40−100)+0=20

Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.

Projected on-hand on Week 5}=(Projected on-hand of Week 4+Planned order receipt of Week 4−Gross requirement of Week 4)+Scheduled receipt of current week=(20+440−440)+0=20

Answer 20

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

Want to see more full solutions like this?

Chapter 12 Solutions

Additional Business Textbook Solutions