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.

Formulate a Distribution Requirement Planning (DRP) spreadsheet to determine flow of at the Shenzhen warehouse, San Bernadino fulfillment center and Newark fulfillment center.

Week 9 San Bernadino Fulfillment Center Demand 1 5753 2 7069 3 7559 4 7349 5 5807 6 6390 7 5164 8 7455 10 6968 6795 Week 1 Newark Fulfillment Center Demand 2 5917 3 3409 4 3951 5 3785 6 5504 7 5366 8 4017 9 4727 10 3928 4466 Week 9 San Bernadino Fulfillment Center Demand 1 5753 2 7069 3 7559 4 7349 5 5807 6 6390 7 5164 8 7455 10 6968 6795 Week 1 Newark Fulfillment Center Demand 2 5917 3 3409 4 3951 5 3785 6 5504 7 5366 8 4017 9 4727 10 3928 4466