Share
Explore BrainMass

Construct a net material requirements plan

The demand for subassembly S is 100 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 1 unit of V, 2 units of W, and 1 unit of X. Finally, each unit of U requires 2 units of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make V, 3 weeks to make W, 1 week to make X, 2 weeks to make Y, and 1 week to make Z. Using this information, construct a net material requirements plan using the following on-hand inventory

Item On-hand inventory

S 20
T 20
U 40
V 30
W 30
X 25
Y 240
Z 40

Attachments

Solution Preview

Find the solution in attched excel sheet.
-First draw the Bill of materials and understand the hierarchy of items
-Make material requirements plans ...

Solution Summary

Shows how to construct a net material requirements plan using the on-hand inventory

$2.19