Using the information pUsing the information provided in the Excel file Ch05Ex01 and displayed in Figure 5.23, create a spreadsheet to analyze the replacement tube cost structure for six potential suppliers. Per unit import duty cost equals the import duty rate multiplied by the sum of per unit base cost and the per unit shipping cost. The per unit warehouse cost is the sum of the per unit base cost and the per unit shipping cost and the per unit import duty cost. The per unit total cost is the sum of the per unit warehouse cost and the average per unit carrying cost.rovided in the Excel file Ch05Ex01 and displayed in Figure 5.23, create a spreadsheet to analyze the replacement tube cost structure for six potential suppliers. Per unit import duty cost equals the import duty rate multiplied by the sum of per unit base cost and the per unit shipping cost. The per unit warehouse cost is the sum of the per unit base cost and the per unit shipping cost and the per unit import duty cost. The per unit total cost is the sum of the per unit warehouse cost and the average per unit carrying