A B C D E F G H 1 Packaging List High Packing & Value Loading Costs 16.24 Handling Surcharge Total Packing & Loading Costs 2 3 Item# Box Size 1 H Weight 131 Fragile FALSE A B C 1 Fragile Additional % 2 Weight Cost 3 3 0 25% 4 20 30% 5 50 40% 6 75 60% 7 100 100% 8 125 125% 9 150 150% 10 High Value 11 Insurance 7.5% 12 2. Determine the Handling surcharge for items which are fragile and insurance cost for items which have a high value. (Handling surcharge for fragile items + Insurance for high value items) Write an Excel formula in cell packlist!G3 to calculate this value for the corresponding item. Handling surcharge and Insurance values are given on sheet handling. Round these charges to the nearest cent. Copy your formula down the column to determine this value for each corresponding item. For example - (Handling surcharge for fragile items * F3 (the Packing & Loading Cost)) + Insurance (no insurance unless it is a High Value Item) A B C D E F G H 1 Packaging List High Packing & Value Loading Costs 16.24 Handling Surcharge Total Packing & Loading Costs 2 3 Item# Box Size 1 H Weight 131 Fragile FALSE A B C 1 Fragile Additional % 2 Weight Cost 3 3 0 25% 4 20 30% 5 50 40% 6 75 60% 7 100 100% 8 125 125% 9 150 150% 10 High Value 11 Insurance 7.5% 12 2. Determine the Handling surcharge for items which are fragile and insurance cost for items which have a high value. (Handling surcharge for fragile items + Insurance for high value items) Write an Excel formula in cell packlist!G3 to calculate this value for the corresponding item. Handling surcharge and Insurance values are given on sheet handling. Round these charges to the nearest cent. Copy your formula down the column to determine this value for each corresponding item. For example - (Handling surcharge for fragile items * F3 (the Packing & Loading Cost)) + Insurance (no insurance unless it is a High Value Item)