Question: Please help with formulas for excel sheet A B C D E F. G H J K L M N Analysis for Performance Tubes 1

Please help with formulas for excel sheet A B C D EPlease help with formulas for excel sheet

A B C D E F. G H 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 Cost Per Unit Per Unit Per Unit Per Unit Average Average Shipping Base Shipping Import Import Warehouse Inventory Inventory 2 Supplier Days Cost Duty % Duty Cost Cost (Units) Value 3 United States 4 $ 3.90 $ 0.25 0 4 South Korea 120 $ 1.70 $ 0.80 4% 5 India 160 $ 1.60 $ 1.10 3% 6 Russia 140 $ 1.35 $ 0.95 6% 7 Malaysia 100 $ 1.55 $ 0.75 4% 8 China 110 $ 1.65 $ 0.85 5% 9 10 11 12 Assumptions 13 Tubes per Day 14 Selling Price 15 Average Inventory (%) 16 Carrying Cost (%) 17 Units per Year 18 19

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 Accounting Questions!