Distribution Requirement Planning (DRP) (10 points) Otto-Van Co. manufactures LCD screens, in Shenzhen China. The product is distributed from a warehouse in Shenzhen through fulfillment centers in San Bernardino, CA and Newark, NJ for the U.S. market. The demand planner for the company is in the process of working requirements for the following 10 weeks. He is given the following data. Shenzhen warehouse: There are currently (week 0) 25000 units on hand. . The order quantity equals 25000 units. Safety stock is equal to 5000 units. Lead time to get the LCDs from factory is 1 week. San Bernadino fulfillment center: There are currently (week 0) 15000 units on hand. The shipment order quantity equals 10000 units. . Safety stock is equal to 2000 units. Shipment lead time to get the LCDs from Shenzhen warehouse is 1 week. Newark fulfillment center: There are currently (week 0) 14000 units on hand. . The shipment order quantity equals 8000 units. Safety stock is equal to 1000 units. Shipment lead time to get the LCDs from Shenzhen warehouse is 1 week. The table below shows the forecasted units (period usage) for the next 10 weeks. San Bernadino Fulfillment Center Demand 1 5750 2 2069 3 7559 4 7149 Wech 5 5807 6 6390 7 5164 8 7455 10 6964 6795 Week Newark Fulfillment Center Demand 1 4466 2 5917 4 3951 6 5504 7 5366 3409 9 4727 10 3928 3785 4011 Formulate a Distribution Requirement Planning (DRP) spreadsheet to determine flow of at the Shenzhen warehouse, San Bernadino fulfillment center and Newark fulfillment center. Distribution Requirement Planning (DRP) (10 points) Otto-Van Co. manufactures LCD screens, in Shenzhen China. The product is distributed from a warehouse in Shenzhen through fulfillment centers in San Bernardino, CA and Newark, NJ for the U.S. market. The demand planner for the company is in the process of working requirements for the following 10 weeks. He is given the following data. Shenzhen warehouse: There are currently (week 0) 25000 units on hand. . The order quantity equals 25000 units. Safety stock is equal to 5000 units. Lead time to get the LCDs from factory is 1 week. San Bernadino fulfillment center: There are currently (week 0) 15000 units on hand. The shipment order quantity equals 10000 units. . Safety stock is equal to 2000 units. Shipment lead time to get the LCDs from Shenzhen warehouse is 1 week. Newark fulfillment center: There are currently (week 0) 14000 units on hand. . The shipment order quantity equals 8000 units. Safety stock is equal to 1000 units. Shipment lead time to get the LCDs from Shenzhen warehouse is 1 week. The table below shows the forecasted units (period usage) for the next 10 weeks. San Bernadino Fulfillment Center Demand 1 5750 2 2069 3 7559 4 7149 Wech 5 5807 6 6390 7 5164 8 7455 10 6964 6795 Week Newark Fulfillment Center Demand 1 4466 2 5917 4 3951 6 5504 7 5366 3409 9 4727 10 3928 3785 4011 Formulate a Distribution Requirement Planning (DRP) spreadsheet to determine flow of at the Shenzhen warehouse, San Bernadino fulfillment center and Newark fulfillment center
