Optimization Inventory

profilehwterminator
AD680PS4Data.xlsx

Data

Vietnam Japan Mexico Ohio
Poduction Yield 90% 100% 90% 95%
Salvage Revenue $2.40 $2.40 $2.40 $2.40
Sales Revenue $32.00 $32.00 $32.00 $32.00
Demand Forecast 3000 3000 3000 3000
Forecast CV 37.5% 30.0% 22.5% 12.5%
Lead Time (Weeks) 40 35 25 15
Gross Product Cost $12.00 $14.00 $14.00 $17.00
Net Product Cost $13.33 $14.00 $15.56 $17.89