15. Use a spreadsheet program to develop the MRP records for parts A and B from the...
Question:
15. Use a spreadsheet program to develop the MRP records for parts A and B from the following product structure. Use the data from the following table:
a. What are the planned orders for item B?
b. On an unlucky day (it must have been the 13th), the planner for part A found that the inventory was wrong by 13 units. Instead of 63, there were only 55 on hand. What happens to the planned orders for part B?
c. Use the spreadsheet model to generate a 10-period material plan for parts A and B. Assume that the 63 units of inventory for A were correct. Suppose that in period 1, actual demand for part A was 60 units instead of 50. Regenerate the spreadsheet for periods 2 through 11. What changes occur in the material plans for parts A and B?
Step by Step Answer:
Manufacturing Planning And Control For Supply Chain Management The CPIM Reference
ISBN: 9781265138516
3rd Edition
Authors: F. Robert Jacobs, William Lee Berry, D. Clay Whybark, Thomas E. Vollmann