1.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)