Material Requirements Planning Part 4

Anonymous

Question Description

Utilizing the Step-by-Step MRP Calculation Process, students will solve the following MRP problem given: Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. Product C is made of two units of F and two of E. Product A has a lead-time of one week. Products B, C and E have lead-times of two weeks. Products D and F have a lead-time of three weeks.

a. Show the bill of material (product structure tree). b. If 100 units of A are required in week 10, develop the MRP planning schedule, specifying when items are to be ordered and received. There are currently no units of inventory on hand.

Tutor Answer

Harsh V
School: University of Virginia

here is attached file of your assignment which is in excel format

B (2)
D (3)

E (2)

A (1)

B (2)

C (4)
E (2)

F (2)

E (2)

MRP
Indented Bill of Materials
Item name

Level

A
B
D
E
C
E
F

0
1
2
2
1
2
2

Distinct items

1
2
3
2
4
2
2

A
B
D
E
C
E
F

6

A
Week 0
Gross requirements
Scheduled receipts
On Hand Inventory
NET POQ Req
Planned receipts
Planned orders

B
Week 0
Gross requirements
Scheduled receipts
On Hand Inventory
NET POQ Req
Planned receipts
Planned orders

C
Week 0
Gross requirements
...

flag Report DMCA
Review

Anonymous
I was on a very tight deadline but thanks to Studypool I was able to deliver my assignment on time.

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors