WEEK2
qkiii123
ch05_excel_p.157xlsx.xlsxSheet1
| Performance Bicycle Parts | |||||||||||||
| Supplier | Shipping Days | Per Unit Base Cost | Per Unit Shipping Cost | Import Duty % | Per Unit Import Duty Cost | Per Unit Warehouse Cost | Average Inventory (Units) | Average Inventory Value | Total Inventory Carrying Cost | Average Per Unit Carrying Cost | Per Unit Total Cost | Gross Profit | Percent Gross Profit |
| United States | 4 | $3.90 | $0.25 | 0 | |||||||||
| South Korea | 120 | $1.70 | $0.80 | 4% | |||||||||
| India | 160 | $1.60 | $1.10 | 3% | |||||||||
| Russia | 140 | $1.35 | $0.95 | 6% | |||||||||
| Vietnam | 100 | $1.55 | $0.75 | 4% | |||||||||
| China | 110 | $1.65 | $0.85 | 5% | |||||||||
| Assumptions | |||||||||||||
| Tubes Per Day | 400 | ||||||||||||
| Selling Price | $6.50 | ||||||||||||
| Average Inventory | 150% | ||||||||||||
| Carrying Cost | 24% | ||||||||||||
| Units Per Year | 144,000 | ||||||||||||
