Question: Please show steps in excel 6. Consider the product structure diagram given in Figure 8-3. Assume that the MPS for the end item for weeks

Please show steps in excel
6. Consider the product structure diagram given in Figure 8-3. Assume that the MPS for the end item for weeks 10 through 17 is Assume that lot-for-lot scheduling is used throughout. Also assume that there is no entering inventory in period 10 and no scheduled receipts. a. Determine the planned order release for component A. b. Determine the planned order release for component B. c. Determine the planned order release for component C. (Hint: Note that C is required for both A and B.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
