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:

EBK OPERATIONS MANAGEMENT, Chapter 12, Problem 5P , additional homework tip 1

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

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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

RECEIVING AND STORAGE ASSIGNMENTS- Dietary Mangement (Nursing Home) ASSIGNMENT: Diagram the receiving and storage areas. Use arrows to show the flow of goods as they are received and moved to storage. ASSIGNMENT: In order to accurately understand this area, the intern should work in the receiving area to complete the following assignments and answer the following questions: Inspect the delivery and check it against the purchase Inspect the delivery against the invoice Accept order only if all quantities and quality specifications are met Check perishable items first Check temperatures of refrigerated and frozen items on arrival Look for evidence of thawing or freezer burn Randomly open cases to check contents Complete receiving records Transfer goods to appropriate storage Who checks the packing slip against the invoice? Does the facility ever use “blind” receiving where the receiving clerk checks the order against an invoice where the amounts have been blanked out and the clerk…

Purchasing, Receiving, Storage, and Inventory Instructions- Dietary management in a nursing home in ABQ NM What workers are involved in the purchasing, receiving, storage and inventory process. Complete the table below: Position Description of their job duties Date/ What did they do? Answer the questions below: PURCHASING: 1. Is there a centralized purchasing department for the facility? If yes, observe someone in that department for a half day if possible, if no write N/A 2. What kinds of items are required to go out for formal bid? 3. What about capital purchases? What is the dollar amount at which an item must go on the capital rather than the operating budget? 4. Does the facility participate with a group to cooperatively purchase items? 5. Is there a Prime Vendor? If yes, how often is the contract renegotiated? 6. Is informal or open-market buying used for any items? Which ones? 7. Who orders…

Critical Incident Report- Dietary Mangement Critical incidences involve critical thinking and problem solving techniques. This exercise is the opportunity to analyze and decide on the appropriateness of the action and to determine better ways to solve problems, approach employees and get the job done. This exercise should help in doing it better the next time. As you observe or become more involved in the situations that require problem solving or critical thinking use this exercise to identify the what, who, and when and determine how the actions taken or not taken affected the outcome. You must write up two or more experiences. The summary is to include two parts: 1. Objective data of what occurred and how it occurred: 2. Analysis of what happened and what we could or would have done to make the outcome better.

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:

EBK OPERATIONS MANAGEMENT, Chapter 12, Problem 5P , additional homework tip 1

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

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, Chapter 12, Problem 5P , additional homework tip 1

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

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, Chapter 12, Problem 5P , additional homework tip 1

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

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, Chapter 12, Problem 5P , additional homework tip 1

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

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, Chapter 12, Problem 5P , additional homework tip 1

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

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, Chapter 12, Problem 5P , additional homework tip 1

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

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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:

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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):

EBK OPERATIONS MANAGEMENT, 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