Question

1. Consider the necessary information for an MRP application provided On hand Lead Time 24 32 80 2) E(3 C(2 Requirements include 125 units (80 firm orders and 45 forecast)。亿in week 10 plus the follo wing spares 10 23 17 20 25 Develop the MRP table for this problem. 2) Consider the dynamic demand of an end item following the MRP explosion ess. Time Demand 50 30 20 80 100 The order cost (setup) per order is S125. Inventory carrying charge is assumed to be $1 per unit per time period. Find out the dynamic lot sizes for this problem by using a) Silver-Meal Method b) LUC method c) PPB method d) Solve the problem optimally by using the Wagner Within algorithm. e) Compare and contrast the total cost of the obtained solutions.

Answer 1

1.

The MRP table is shown below

10 125 16 17 Item Z 18 OH 40 19LT2 20 SS 0 Period Gross requirement Spare Projected avalable balance Net requirements Planned order receipts Planned order relea 0 85 85 0 85 se 23 24 Item A 25 OH 24 26 LT= 3 27 SS 0 Gross requirement Spare Projected avalable balance Net requirements Planned order receipts Planned order elease 170 23 23 24 24 24 24 23 169 169 0 24 24 24 23 169 29 30 31 Item B 32 OH 32 33 LT 2 Gross requirement Spare Projected avalable balance Net requirements Planned order receipts Planned order relea 170 17 32 32 32 32 0 32 32 32 17 17 17 155 155 35 | Q = L4L se 155 Sheet542 (2) Sheet726 Sheet727 Sheet725 Sheet728 Sheet729 Sensitivity Report 49 +130%

10 37 38 Item 39OH 18 40 LT=1 41 SS0 Period Gross requirement Spare Projected avalable balance Net requirements Planned order receipts Planned order release 338 310 18 18 18 18 320 320 310 310 310 320 43 Gross requirement Spare Projected avalable balance Net requirements Planned order receipts Planned order release 620 20 20 580 580 45 Item D 46 OH 60 47 LT3 20 20 20 20 0 0 580 51 52 Item 53 OH 35 54 LT 2 Gross requirement Spare Projected avalable balance Net requirements Planned order receipts Planned order release 507 25 25 497 497 0 0 35 0 0 25 0 35 35 35 25 25 25 25 56 Q L4L 497 0 0 Sheets42 (2) Sheet726 Sheet727 Sheet725 Sheet728 Sheet729 Sensitivity Report 49. +130%