Question: please answer part b. with Excel, thanks! End item P is composed of three subassemblies: K, L and W. K is assembled using 3 Gs

please answer part b. with Excel, thanks!

End item P is composed of three subassemblies: K, L and W. K is assembled using 3 Gs and 4 Hs; L is made of 2 Ms and 2 Ns; and W is made of 3 Zs. On-hand inventories are 20Ls, 40Gs, and 200 Hs. Scheduled receipts are 10Ks at the start of week 3, 30 Ks at the start of week 6, and 200 Ws at the start of week 3. One hundred Ps will be shipped at the start of week 6, and another 100 at the start of week 7. Lead times are two weeks for subassemblies and one week for components G, H and M. Final assembly of P requires one week. The minimum order size for H is 200 units. For rest of the items, assume lot for lot ordering.

a. Develop a product structure tree

b. Develop MRP tables for K, G and H

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

MRP Partner Work MRP Problem End item P is composed of three subassemblies: K, L, and W. K is assembled using three Gs and four Hs. L is made of two Ms and two Ns. W is made using three Zs. On-hand...

Also the MRP for P and K. MRP Problem End item P is composed of three subassemblies: K, L, and W. K is assembled using three Gs and four Hs. Lis made of two Ms and two Ns. W is made using three Zs....

End item P is composed of three subassemblies: K, L, and W. K is assembled using 3 Gs and 4 Hs; L is made of 2 Ms and 2 Ns; and W is made of 3 Zs. On-hand inventories are 20 Ls, 40 Gs, and 200 Hs....

MRP Problem End item P is composed of three subassemblies: K, L, and W. K is assembled using three Gs and four Hs. Lis made of two Ms and two Ns. W is made using three Zs. On-hand inventories are 20...

MRP Problem End item P is composed of three subassemblies: K, L and W. K is assembled using three Gs and four Hs. L is made of two Ms and two Ns. W is made using three Zs. On-hand inventories are 20...

End item P is composed of three subassemblies: K, L, and W. K is assembled using 3 Gs and 4 Hs; L is made of 2 Ms and 2 Ns; and W is made of 3 Zs. On-hand inventories are 20 Ls, 40 Gs, and 200 Hs....

MRP Problem End item P is composed of three subassemblies: K, L, and W. K is assembled using three Gs and four Hs. L is made of two Ms and two Ns. W is made using three Zs. On-hand inventories are 20...

End item P is composed of three subassemblies: K , L and W . K is assembled using 3 Gs and 4 Hs; L is made of 2 Ms and 2 Ns; and W is made of 3 Zs . On - hand inventories are 2 0 Ls , 4 0 Gs , and 2...

Elmo Inc. is a U.S. corporation with a branch office in foreign country Z. During the current year, Elmo had $340,000 of U.S. source income and $60,000 of foreign source income from Z, on which Elmo...

The three data sets have the same mean and range, but is the variation the same? Prove your answer by computing the standard deviation. Assume the data were obtained from samples. a. 5, 7, 9, 11, 13,...

While technical currency market analysis doesn t focus as much on the analysis of fundamental market forces as does fundamental market analysis, technical analysis does better explain short - run...

Concord Corporation reports operating expenses of $94,800 excluding depreciation expense of $14,800, for 2022. During the year, prepaid expenses decreased $6,300 and accrued expenses payable...