Homework #$6-$ OMGT $6213-$ Fall $2023$

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, December $2$

Week Week Week Week Week Week Week Week Week Week

Demand: $12345678910$ TOTAL

Forecast from Home Depot $1,0008001,4001,6001,2001,0008001,0001,5002,200$

Forecast from Lowe's $2,8004,0002,1002,7002,4002,0002,0002,0002,9005,000$

Distributor for Home Depot Safety Stock$=1,200$ LT $($w$)=2$ Order Quantity $=1200$

Current $12345678910$

Forecasted Demand $1,000800$

Scheduled receipts $($product in$-$transit$)2,4000$

Planned Receipts $--$

Projected On$-$Hand Ending $7001,400600$

Planned Orders $--00$

Distributor for Lowe's Safety Stock$=1,500$ LT $($w$)=1$ Order Quantity $300$

Current $12345678910$

Forecasted Demand $2,8004,000$

Scheduled receipts $($product in$-$transit$)1,500-$

Planned Receipts $--$

Projected On$-$Hand Ending $3,0001,300(2,700)$

Planned Orders $-3,0000$

Manufacturer

Current $12345678910$

"Forecasted Demand from Distribution

Warehouses" $1,400800$

Projected On$-$Hand Ending $300$

Projected Manufacturing Amount $($can produce weekly$)1,2001,200$

Manufacturer

Current $12345678910$

"Forecasted Demand from Distribution

Warehouses"

Projected On$-$Hand Ending $300$

Projected Manufacturing Amount $($can only produce bi$-$weekly$)$

NOTE: The manufacturer will start building in Week $1$ in all cases.