Please show Excel Formula's

B 1 Selecting Transportation Modes for China Imports 2 3 Desired cycle service level 4 Holding cost 5 6 Transportation Options 7 Air freight 8 Shipping cost/ kg. $ 9 10 Mean lead time (weeks) 11 SD of lead time (weeks) 12 Ordering cost per order S= $ 13 14 Product Characteristics 15 Smartphones 16 Mean weekly demand 17 SD of weekly demand 18 Weight/unit (kg.) 19 Cost/ unit 20 Annual demand D= 21 Unit holding cost H= 22 23 Total Costs for Smartphones 24 25 Optimal batch size EOQ= 26 Order quantity per batch 27 Cycle inventory 28 Safety inventory 29 Transit inventory 30 Total inventory 31 Annual holding cost 32 Annual ordering cost 33 Annual shipping cost 34 Total Costs 35 36 Total Cost for Decorative Hardware 37 38 Optimal batch size 39 Order quantity per batch 40 Cycle inventory 41 Safety inventory 42 Transit inventory 43 Total inventory 44 Annual holding cost 45 Annual ordering cost 46 Annual shipping cost Total Costs 47 48 Minimum shipping quantity (kg.) 98% 25% Ocean shipping 10 Shipping cost / container 50 Container size (Maximum kg.) 1 Mean lead time (weeks) 0.2 SD of lead time (weeks) 500 Ordering cost per order S= Decorative hardware 1,000 Mean weekly demand 400 SD of weekly demand 0.1 Weight / unit (kg.) 300 Cost/ unit 52,000 Annual demand D= 75 Unit holding cost H= Ocean Shipping $ $ Air freight Air freight 918 2,904 Ocean Shipping 6,636 31,416 $ $ D 1,200 15,000 9 3 1,200 EOQ info 5,000 1,000 1 $ $ EOQ calculation 20 260,000 EOQ info 5 EO