Question: **** Show excel formulas for calculations **** I have no idea what the assumptions are as they were not given. I just needed to know

**** Show excel formulas for calculations **** I have no idea what the assumptions are as they were not given. I just needed to know which are the correct formulas to calculate this in excel

**** Show excel formulas for calculations **** I

B C D E F G H 1 J K L M N Analysis for Performance Tubes 1 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 Average Shipping Base Shipping Import Import Warehouse Inventory Inventory Days Cost Cost Duty % Duty Cost Cost (Units) Value 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 China 8 9 10 11 12 Assumptions 13 Tubes per Day 14 Selling Price 15 Average Inventory (%) 16 Carrying Cost (%) 17 Units per Year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!