K The demand for subassembly S is 130 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 2 units of V, 1 unit of W, and 1 unit of X. Finally, each unit of U requires 1 unit 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. Click the icon to view the product structure and the time-phased product structure. Click the icon to view the on-hand inventory. Suppose that in addition to 130 units of S, there is also a demand for 20 units of U, which is a component of S. The 20 units of U are needed for maintenance purposes. These units are needed in week 6. Additionally, a new order has been received for 80 units of S due in week 8. Modify the net material requirements plan to reflect these changes. Construct a new net material requirements plan (enter your responses as whole numbers). More Info Item Week 1 2 3 4 5 6 7 8 Lead Time (weeks) S Gross req On hand Net req Order receipt Order release T Gross req The product structure. The time-phased product structure. Level V W T 0 X T(1) U(2) U z 2 V(2) W(1) X(1) Y(1) Z(3) 6 Time in weeks U Print Done On hand Net req Order receipt Order release Gross req On hand Net req Order receipt Order release V Gross req On hand Net req Order receipt 2 1 2 2 More Info Item S On-Hand Inventory Item On-Hand Inventory W 25 T 20 25 U Y 180 V 30 Z 40 Print Done More Info The product structure. The time-phased product structure. Net req Order receipt Order release V Gross req On hand Net req Order receipt Order release W Gross req On hand Net req Order receipt Order release ☐☐ Level V W T ° x Gross req X T(1) U(2) On hand 1 Y U Z Net req 2 V(2) W(1) X(1) Y(1) Z(3) Order receipt Time in weeks Order release Y Gross req On hand Print Done z Net req Order receipt Order release ☐☐ Gross req On hand Net req 1 2 w 2 N More Info Item On-Hand Inventory Item On-Hand Inventory S 20 W T 20 x 25 U 40 Y 180 1 V 30 Z 40 Print Done
K The demand for subassembly S is 130 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 2 units of V, 1 unit of W, and 1 unit of X. Finally, each unit of U requires 1 unit 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. Click the icon to view the product structure and the time-phased product structure. Click the icon to view the on-hand inventory. Suppose that in addition to 130 units of S, there is also a demand for 20 units of U, which is a component of S. The 20 units of U are needed for maintenance purposes. These units are needed in week 6. Additionally, a new order has been received for 80 units of S due in week 8. Modify the net material requirements plan to reflect these changes. Construct a new net material requirements plan (enter your responses as whole numbers). More Info Item Week 1 2 3 4 5 6 7 8 Lead Time (weeks) S Gross req On hand Net req Order receipt Order release T Gross req The product structure. The time-phased product structure. Level V W T 0 X T(1) U(2) U z 2 V(2) W(1) X(1) Y(1) Z(3) 6 Time in weeks U Print Done On hand Net req Order receipt Order release Gross req On hand Net req Order receipt Order release V Gross req On hand Net req Order receipt 2 1 2 2 More Info Item S On-Hand Inventory Item On-Hand Inventory W 25 T 20 25 U Y 180 V 30 Z 40 Print Done More Info The product structure. The time-phased product structure. Net req Order receipt Order release V Gross req On hand Net req Order receipt Order release W Gross req On hand Net req Order receipt Order release ☐☐ Level V W T ° x Gross req X T(1) U(2) On hand 1 Y U Z Net req 2 V(2) W(1) X(1) Y(1) Z(3) Order receipt Time in weeks Order release Y Gross req On hand Print Done z Net req Order receipt Order release ☐☐ Gross req On hand Net req 1 2 w 2 N More Info Item On-Hand Inventory Item On-Hand Inventory S 20 W T 20 x 25 U 40 Y 180 1 V 30 Z 40 Print Done
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Transcribed Image Text:K
The demand for subassembly S is 130 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 2 units of V, 1 unit of W, and 1 unit of X. Finally, each unit of U requires 1 unit 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.
Click the icon to view the product structure and the time-phased product structure.
Click the icon to view the on-hand inventory.
Suppose that in addition to 130 units of S, there is also a demand for 20 units of U, which is a component of S. The 20 units of U are needed for maintenance purposes. These units are needed in week 6. Additionally, a new order has been received for 80 units of S due in week
8. Modify the net material requirements plan to reflect these changes.
Construct a new net material requirements plan (enter your responses as whole numbers).
More Info
Item
Week
1
2
3
4
5
6
7 8
Lead Time
(weeks)
S Gross req
On hand
Net req
Order receipt
Order release
T
Gross req
The product structure.
The time-phased product structure.
Level
V
W
T
0
X
T(1)
U(2)
U
z
2 V(2) W(1) X(1) Y(1) Z(3)
6
Time in weeks
U
Print
Done
On hand
Net req
Order receipt
Order release
Gross req
On hand
Net req
Order receipt
Order release
V
Gross req
On hand
Net req
Order receipt
2
1
2
2
More Info
Item
S
On-Hand
Inventory
Item
On-Hand
Inventory
W
25
T
20
25
U
Y
180
V
30
Z
40
Print
Done
Transcribed Image Text:More Info
The product structure.
The time-phased product structure.
Net req
Order receipt
Order release
V
Gross req
On hand
Net req
Order receipt
Order release
W Gross req
On hand
Net req
Order receipt
Order release ☐☐
Level
V
W
T
°
x
Gross req
X
T(1)
U(2)
On hand
1
Y
U
Z
Net req
2 V(2) W(1) X(1) Y(1) Z(3)
Order receipt
Time in weeks
Order release
Y
Gross req
On hand
Print
Done
z
Net req
Order receipt
Order release ☐☐
Gross req
On hand
Net req
1
2
w
2
N
More Info
Item
On-Hand
Inventory
Item
On-Hand
Inventory
S
20
W
T
20
x
25
U
40
Y
180
1
V
30
Z
40
Print
Done
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.