Operations Management Evaluate 9.2 Problem 25

profileClay1203
evaluate_9.2_problem_25.xlsx

Sheet1

Table 16.8
Inventory Record Data
Data Category B C D E F G
Lot-sizing rule L4L L4L POQ (P = 2) L4L L4L FOQ = 100
Lead time 2 weeks 3 weeks 3 weeks 6 weeks 1 week 3 weeks
Safety stock 30 10 0 0 0 0
Scheduled receipts 150 (week 2) 50 (week 2) None 400 (week 6) 40 (week 3) None
Beginning Inventory 30 20 60 400 0 0

Sheet2

Sheet3