Group Collaboration Draft
Q1. Using the current exchange rate, what is the initial purchase cost per unit (in US dollars) paid to Dong Hai Supply? (Do not include transportation costs)
547 Yuan x $0.14646 = $80.11
Q2. What is the average time for an order filling a TEU container to come from Dong Hai Supply in Chengdu, China to IDC’s Alliance Fort Worth Distribution Center? From CousinsAg in Wahoo, Nebraska to IDC’s Alliance Fort Worth Distribution Center?
15 + 1 + + 4 + 16 + 3 + 4 = 43 days to receive a TEU from Dong Hai Supply
10 + 5 = 15 days to receive a TEU from CousinsAg
Q3. Using the current exchange rate, what is the cost (in US dollars) to ship a TEU container from Dong Hai Supply in Chengdu, China to IDC’s Alliance Fort Worth Distribution Center?
12,414.5 x 0.14646 + 325 + 2250 = $4,393.23 to ship a TEU from Dong Hai to Fort Worth
Q4. What is the economic order quantity (use unit price only, do not include transportation costs) if we purchase everything from CousinsAg? From Dong Hai Supply?
CousinsAg price = square root [(2*21500*105) / (0.322*$85)] = 406 units
Dong Hai Supply = square root [(2*21500*182) / (0.322*$80.11)] = 551 units
Q5. How many units of safety stock will we need to hold if we purchase everything from Dong Hai Supply? From CousinsAg?
Dong Hai Supply safety stock = 59 units/day x 43 days lead time = 2,537 units
CousinsAg safety stock = 59 units/day x 15 days lead time = 885 units
Q6. Inventory carrying costs are based on the value of the product at the time it is held in inventory. What is the in-transit carrying cost per unit (in dollars and cents) if we purchase everything from Dong Hai Supply? From CousinsAg?
Dong Hai supply carrying cost = $80.11 x 0.322 = $25.80
CousinsAg carrying cost = $85 x 0.322 = $27.37
Q7. What average inventory level (in units) will we hold at the IDC’s Alliance Fort Worth Distribution Center if we purchase everything from Doug Hai Supply? (Be sure to consider both safety stock and cycle stock) From
547 Yuan x $0.14646 = $80.11
Q2. What is the average time for an order filling a TEU container to come from Dong Hai Supply in Chengdu, China to IDC’s Alliance Fort Worth Distribution Center? From CousinsAg in Wahoo, Nebraska to IDC’s Alliance Fort Worth Distribution Center?
15 + 1 + + 4 + 16 + 3 + 4 = 43 days to receive a TEU from Dong Hai Supply
10 + 5 = 15 days to receive a TEU from CousinsAg
Q3. Using the current exchange rate, what is the cost (in US dollars) to ship a TEU container from Dong Hai Supply in Chengdu, China to IDC’s Alliance Fort Worth Distribution Center?
12,414.5 x 0.14646 + 325 + 2250 = $4,393.23 to ship a TEU from Dong Hai to Fort Worth
Q4. What is the economic order quantity (use unit price only, do not include transportation costs) if we purchase everything from CousinsAg? From Dong Hai Supply?
CousinsAg price = square root [(2*21500*105) / (0.322*$85)] = 406 units
Dong Hai Supply = square root [(2*21500*182) / (0.322*$80.11)] = 551 units
Q5. How many units of safety stock will we need to hold if we purchase everything from Dong Hai Supply? From CousinsAg?
Dong Hai Supply safety stock = 59 units/day x 43 days lead time = 2,537 units
CousinsAg safety stock = 59 units/day x 15 days lead time = 885 units
Q6. Inventory carrying costs are based on the value of the product at the time it is held in inventory. What is the in-transit carrying cost per unit (in dollars and cents) if we purchase everything from Dong Hai Supply? From CousinsAg?
Dong Hai supply carrying cost = $80.11 x 0.322 = $25.80
CousinsAg carrying cost = $85 x 0.322 = $27.37
Q7. What average inventory level (in units) will we hold at the IDC’s Alliance Fort Worth Distribution Center if we purchase everything from Doug Hai Supply? (Be sure to consider both safety stock and cycle stock) From