Innovative+Distribution+Workbook.xlsx - Q1 Using CURRENT(as...

This preview shows page 1 - 4 out of 13 pages.

Todays dateDong Hai Price (Yuan)Exchange RateDong Hai Ship TimeCousinsAG Ship TimeSegmentTimeSegmentYuanInternatinal Transportation Cost per TEUDutiesUS Trans Cost per TEUQ1: Using CURRENT(as in today 2019) exchange rate, what is the INITIAL PURCHASE COST PERtransportation costs).Q2: What is the AVERAGE TIME for an order filling a TEU container to come from Dong Hai SupFrom CousinsAg in Wahoo, Nebraska to IDC's Alliance Fort Worth Distribution Center? Under each companies name below, include the segments of the shipment and the time of thaQ3: Using the CURRENTexchange rate, what is the COST (in US Dollars) to ship a TEU containeDistribution Center?
Cost per unit in DollarsTimeExchange RateCostTotalR UNIT (in US Dollars) paid to Dong Hai Supply? (Do not include pply in Chengdu, China to IDC's Alliance Fort Worth Distribution Center? at segment.er from Dong Hai Supply in Chengdu, China to IDC's Alliance Fort Worth
Common CostsAnnual DemandCarrying RateDong Hai Costs (Chengdu)Per Unit CostsOrdering CostsCousinsAG Costs (Wahoo)Per Unit CostsOrdering CostsCommon Demand FactorsDaily DemandStd Deviation of DemandSafety Stock Z-value 97.7%Dong Hai Leadtime Factors (Chengdu)Std Deviation of LeadtimeCousinsAG Costs (Wahoo)Std Deviation of LeadtimeAverage Replenishment LeadtimeAverage Replenishment Leadtime

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture