You are about to begin a summer internship in Logistics working for a company Express Mover that provides packa and shipping services to customers moving large amounts of materials from 2,000 pounds (Lbs.) and up. Your employees go onsite to a customer's location - provide the necessary packaging materials (boxes, tape), package the items and then ship them to their new location. Customer charges are based on both the volume and weight of their shipments a some special handling factors. You have created an Excel workbook to estimate the price to a specific customer's shipment. You hope to eventually use this packlist, contains the list of all boxes to be included in the shipment together with information on their individual box sizes and weight. The workbook you have prepared contains four worksheets as follows: template for future shipments- just substituting the new bill of lading. This bill of lading -found on workshee packlist-contains a list of boxes that have been assembled and packed for moving, including the box size (identified by letter code), the box weight (lbs.), whether it is fragile (True/False) and the estimated value if an item is considered to be High Value and requires insurance. This field will be blank for items not considered high value boxes-contains information about each standard box size including its dimensions in inches, its cost to pack& load, if it's less than 100 pounds or 100 pounds or more, and a factor needed for shipping to calculate truck volume needed ship-contains information on volume and weight limits by truck type and the number of miles this shipment will be sent. Also included on this worksheet are some conversion factors that may be needed in your calculations. handling -contains information on cost percentages expected to package fragile items based on the item weight and additional cost percentages for insurance on high value items o To calculate this surcharge for fragile items of less than 20 lbs. include a surcharge of 25%, for items that are at least . . . etc. So if an item costs $10 for packaging and 20 lbs, but less than 50 lbs, include an additional surcharge of 30% loading and is fragile-if it is weighted 45 lbs.-the surcharge would be 30% x $10 or $3 To calculate the value of insurance for high value items multiply the value of the item (in column High value) by the insurance rate. So a $1000 with a 7.5% insurance rate would require a $75 surcharge for insurance You now need to complete the necessary formulas to perform the calculations for your estimate Determine the Packaging and Loading costs in cell packlistlF3 Write an Excel formula to determine the packaging and loading costs for this item based on its box size and weight. This cost should also include the box price but do not include any surcharges for fragile or high value items. Copy the formula down the column to calculate this value for each corresponding item 1. Packaging List High Handling Total Packing & Loading Costs Packing & item# Box Size weight Fragile | Value | Loading Costs | Surcharge 131 FALSE 11 FALSE 90 FALSE 20 FALSE 99 FALSE 12 FALSE 39 TRUE 55 FALSE 18 FALSE 78 FALSE 118 TRUE 41 FALSE 69 FALSE 105 FALSE 64 FALSE 35 FALSE 78 FALSE 12 TRUE 78 TRUE 1 H 3 C 4 R 5 A 6 A 3,500 8 9 H 10 G 1,500 12 E 13 H 14 D 15 16 E 17 R 18 F 19 D 20 67 FALSE 71 FALSE 10 FALSE 3 FALSE 21 E 22F 23 G 24E 25K 26D 27 H 48 TRUE 12,650 122 FALSE 105 FALSE 91 FALSE 28 C33 FALSE packlist boxes ship handling + Boxing Information & Pricing Box Size Length (IN) Width (IN) Height (IN) Volume Usage 18 2418 20 24 2448 36 36 48 18 20 18 24 12 36 36 48 12 12 1.1 18 1.121:23 1.25 1.12 1.15 1.15 1.2 1.1 1.1 133 5 2.32 5 3.06 5 3.54 5 3.57 5 5.11 5 3.62 5 69 S 923 6.54 3.10 9 4.14 5.17S 5.17 $ 6.21 $ 8.28 8.28 $ 15.52 5.7$8.28 s 6.31 6.31 7.36 7.36 5 8.42 10.52 12.62 26.30 26.30 26.30 Bok Pice Packing & Loading