Case Study Related to Inventory Management, Demand and Supply planning, Logistics

(Look at the attachment for full question)

Objective:

1.   Route supply effectively to avoid low stock or stock out

2.   Find fastest way to balance shipping back to Ocean mode and reasoning                   

Assumptions:            

1. Pallet size is 2160           

2.   Shipping minimums is 1 pallet        

3.   Current target DOS is 21 days           

4. PO ETD is fixed                        

5. Transit times: Air = 1 wk transit and Ocean = 6 wks transit

Answer:

1.   Fill in "PO ETA" row   your PO Supply ETA. (When you want to   the good to arrived based the shipping parameter)

2.   Color code qty planned by AIR vs. OCEAN

3.   You can add additional columns/rows if needed to illustrate results