0 H N N Homework #5 - OMGT 6213 - Fall 2021 Fill out the DRP schedule for the distributors and manufacturer. Note the safety stock, lead-time, order quantity, and production timing information Note 1: The distributor for Home Depot must order 1,200 minimum and in multiples of 1,200. Note 2: The distributor for Lowe's Hardware must order 300 minimum and in multiples of 300. Note 3: In all cases, remember that the goal is to carry as little inventory as possible, while still meeting the safety stock goal and fulfilling demand Once you complete this DRP schedule, log into Blackboard and answer the questions in the HW#5 test manager no later than 11:50 pm, Friday, Nov. 19 Demand: TOTAL Week 1 1,000 2,800 Week 2 800 4,000 Forecast from Home Depot H1 Forecast from Lowe's Week 3 1,400 2,100 Week 4 1,600 2,700 Week 5 1,200 2,400 Week 6 1,000 2,000 Week 7 800 2,000 Week 8 1,000 2,000 Week 9 1,500 2,900 Week 10 2.200 5,000 Distributor for Home Depot Safety Stock= 1.200 Current 1 1 LT (W)= 2 3 Order Quantity 6 = 1200 7 2 4 5 8 9 10 2,400 0 Forecasted Demand Scheduled receipts (product in-transit) Planned Receipts Projected On-Hand Ending Planned Orders 700 0 0 0 Distributor for Lowe's 300 Safety Stock= 1,500 Current 1 LT (W) 1 3 Order Quantity 6 22 2 4 5 7 8 9 9 10 1,500 Forecasted Demand 2 Scheduled receipts (product in-transit) 2. Planned Receipts Projected On-Hand Ending 27 Planned Orders 29 29 Manufacturer 3,000 0 Current 1 2 3 3 4 5 6 7 8 9 10 Forecasted Demand from Distribution 31 Warehouses 32 Projected On-Hand Ending 33 Projected Manufacturing Amount (can produce weekly) 34 300 27 1 2 3 4 5 6 7 8 9 10 - Manufacturer Current Forecasted Demand from Distribution 3. Warehouses Projected On-Hand Ending Projected Manufacturing Amount (can only produce bi-weekly) NOTE: The manufacturer will start building in Week 1 in all cases. 300