This exercise is a business application that requires writing formulas in Excel.

ExcelExercisel - Excel Sheet (1) - Excel File Home Insert Page Layout Formulas Data Review View OnBase Tell me what you want to do... K24 fc A B D E F G H L M N O Analysis for Performance Tubes 1 Average Inventory Value Total Inventory Carrying Cost Average Per Unit Carrying Per Unit Gross Cost Total Cost Profit Percent Gross Profit 2 Supplier 3 United States 4 South Korea Per Unit Per Unit Per Unit Per Unit Average Shipping Base Shipping Import Import Warehouse Inventory Days Cost Cost Duty % Duty Cost Cost (Units) 4 $ 3.90 $ 0.25 0 120 $ 1.70 $ 0.80 4% 160 $ 1.60 $ 1.10 3% 140 $ 1.35 $ 0.95 6% 100 $ 1.55 $ 0.75 4% 110 $ 1.65 $ 0.85 5% 5 India 6 Russia 7 Malaysia 8 China 9 10 11 12 Assumptions 13 Tubes per Day 14 Selling Price 15 Average Inventory (%) 16 Carrying Cost (%) 17 Units per Year