Problem 21-9 Semans is a manufacturer that produces bracket assemblies. Demand f
ID: 371300 • Letter: P
Question
Problem 21-9 Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 128 units. The following is the BOM in indented form ITEM USAGE DESCRIPTION Bracket assembly Wall board Hanger subassembly Hanger casting Ceramic knob Rivet head screw Metal tong Plastic cap Below is a table indicating current inventory levels Item Inventory 26 17 69 17 196 145 1,220 95 b. What are the net requirements of each item in the MPS? (Leave no cells blank be certain to enter 0" wherever required.) Net RequirementsExplanation / Answer
Item
Usage
For 128 unit of X
Inventory available
Net Required
X
1
128
26
102
=D2-E2
A
5
640
17
493
=D3-E2*C3-E3
B
2
256
69
135
=D4-C4*E2-E4
C
5
640
17
493
=D5-C5*E2-E5
D
4
512
196
74
=F4*2-E6
E
2
256
145
0
=IF((F4*1-E7)<0,0,(F4*1-E7))
F
15
1920
1220
259
=F5*3-E8
G
5
640
95
398
=F5*1-E9
Item
Usage
For 128 unit of X
Inventory available
Net Required
X
1
128
26
102
=D2-E2
A
5
640
17
493
=D3-E2*C3-E3
B
2
256
69
135
=D4-C4*E2-E4
C
5
640
17
493
=D5-C5*E2-E5
D
4
512
196
74
=F4*2-E6
E
2
256
145
0
=IF((F4*1-E7)<0,0,(F4*1-E7))
F
15
1920
1220
259
=F5*3-E8
G
5
640
95
398
=F5*1-E9
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.