Please answer the highlighted questions in the first screenshot. Thank you!! :)

. EXPRESS MOVER You are about to begin a summer internship in Logistics working for a company Express Mover that provides packaging 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 as well as 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 as a template for future shipments - just substituting the new bill of lading. This bill of lading - found on worksheet 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: 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. To calculate this surcharge for fragile items of less than 20 lbs. include a surcharge of 25%, for items that are at least 20 lbs. but less than 50 lbs. include an additional surcharge of 30% etc. So if an item costs $10 for packaging and 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. . . o 1. Determine the Packaging and Loading costs in cell packlist!F3. 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. For example - your value will include the box price (from the Box Price row on the boxes worksheet) plus the price based on weight (from the Packing and Loading rows, also on the boxes worksheet). 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) 3. Determine the total Packing & Loading costs for item 1 in cell packlist!H3 - Copy your formula down the column to determine this value for each corresponding item. 4. At the very bottom of the packaging list calculate the total weight of all boxes, the total packaging and loading costs excluding surcharges, total handling fees and total packaging and loading costs. Use appropriate formatting for the corresponding columns. F3 fx A B C D E F G H 1 Packaging List High Packing & Value Loading Costs Handling Surcharge Item# Box Size Weight 131 Total Packing & Loading Costs $ 1 Fragile FALSE FALSE H 4 2 D 11 00 vou wn 3 90 FALSE 4 R 20 3,500 FALSE FALSE A 99 A 12 100 you F 39 9 10 55 FALSE TRUE FALSE FALSE FALSE TRUE 11 9 H 18 10 G 78 12 13 11 118 1,500 12 41 14 15 - JIMI- FALSE FALSE 69 16 13 14 15 105 FALSE 1 64 16 E 35 FALSE FALSE FALSE R 78 17 18 19 F 12 TRUE D 78 TRUE 20 1 67 FALSE E 71 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 F 10 FALSE FALSE FALSE TRUE G 21 22 23 24 25 26 3 E 48 12,650 K FALSE 122 105 D FALSE FALSE H 91 27 28 33 29 119 FALSE FALSE FALSE TRUE 30 A 147 67 31 32 1 135 33 C 52 6,450 32 33 34 35 36 37 38 39 40 34 1 146 1 47 35 36 FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE 148 116 37 K 38 C 13 41 39 H 120 1.10 TDI packlist boxes ship handling H19 vf L | 1 total A B DE F G H J K 1 Boxing Information & Pricing 2 Box Size A D E F G H 1 K R 3 Length (IN) 18 24 18 20 24 24 48 36 36 48 4 Width (IN) 12 18 18 20 18 24 12 36 36 48 5 Height (IN) 12 12 18 20 18 24 12 48 6 60 6 Volume Usage 1.1 1.12 1.15 1.15 1.2 1.12 1.25 1.25 1.1 1.1 7 Box Price $ 1.33 $ 2.32 $ 3.06 $ 3.54 $ 3.57 $ 5.11 $ 3.62 $ 6.92 $ 9.23 $ 6.54 Packing & Loading 8 = 9 100 Lbs $ 6.31 $ 6.31 $ 7.36 $ 7.36 $ 7.36 $ 8.42 $ 10.52 $ 12.62 $ 26.30 $ 26.30 $ 26.30 10 11 Box Summary: 12 A D E F H 1 K R 13 Total Weight (lbs) 14 Total Volume (CF) 15 Recommended Truck Type: 16 Costs to ship: 17 18 Total customer costs: 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 packlist boxes ship handling + C8 fx 4505 A B D E F G 1 Shipping Costs - For Overland Truck 2 Miles: 435 Truck Volume Weight $/mi per Truck 3 Type Truck Description CF Lbs. Base ton Type 4 1 Small 350 1.85 1 5 2 Medium 1,700 20,000 650 1.25 2 6 3 Large 2,380 25,000 850 0.95 3 7 4 Extra Large 4,080 30,000 1,000 0.9 4 8 5 Double 4,505 48,000 1,200 0.8 5 9 6 need more trucks 4,950 55,000 6 10 11 Additional Info: 12 Cubic Inches per Cubic Foot 1,728 13 Lbs. per Ton 2,000 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 packlist boxes ship handling + D11 fx fi B D E F 1 Fragile Additional % Weight Cost 0 25% 20 30% 50 40% 4 B. 000 u wn 75 60% 100 125 100% 125% 150% 7.5% 9 150 10 High Value 11 Insurance 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 packlist boxes ship handling . EXPRESS MOVER You are about to begin a summer internship in Logistics working for a company Express Mover that provides packaging 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 as well as 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 as a template for future shipments - just substituting the new bill of lading. This bill of lading - found on worksheet 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: 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. To calculate this surcharge for fragile items of less than 20 lbs. include a surcharge of 25%, for items that are at least 20 lbs. but less than 50 lbs. include an additional surcharge of 30% etc. So if an item costs $10 for packaging and 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. . . o 1. Determine the Packaging and Loading costs in cell packlist!F3. 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. For example - your value will include the box price (from the Box Price row on the boxes worksheet) plus the price based on weight (from the Packing and Loading rows, also on the boxes worksheet). 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) 3. Determine the total Packing & Loading costs for item 1 in cell packlist!H3 - Copy your formula down the column to determine this value for each corresponding item. 4. At the very bottom of the packaging list calculate the total weight of all boxes, the total packaging and loading costs excluding surcharges, total handling fees and total packaging and loading costs. Use appropriate formatting for the corresponding columns. F3 fx A B C D E F G H 1 Packaging List High Packing & Value Loading Costs Handling Surcharge Item# Box Size Weight 131 Total Packing & Loading Costs $ 1 Fragile FALSE FALSE H 4 2 D 11 00 vou wn 3 90 FALSE 4 R 20 3,500 FALSE FALSE A 99 A 12 100 you F 39 9 10 55 FALSE TRUE FALSE FALSE FALSE TRUE 11 9 H 18 10 G 78 12 13 11 118 1,500 12 41 14 15 - JIMI- FALSE FALSE 69 16 13 14 15 105 FALSE 1 64 16 E 35 FALSE FALSE FALSE R 78 17 18 19 F 12 TRUE D 78 TRUE 20 1 67 FALSE E 71 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 F 10 FALSE FALSE FALSE TRUE G 21 22 23 24 25 26 3 E 48 12,650 K FALSE 122 105 D FALSE FALSE H 91 27 28 33 29 119 FALSE FALSE FALSE TRUE 30 A 147 67 31 32 1 135 33 C 52 6,450 32 33 34 35 36 37 38 39 40 34 1 146 1 47 35 36 FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE 148 116 37 K 38 C 13 41 39 H 120 1.10 TDI packlist boxes ship handling H19 vf L | 1 total A B DE F G H J K 1 Boxing Information & Pricing 2 Box Size A D E F G H 1 K R 3 Length (IN) 18 24 18 20 24 24 48 36 36 48 4 Width (IN) 12 18 18 20 18 24 12 36 36 48 5 Height (IN) 12 12 18 20 18 24 12 48 6 60 6 Volume Usage 1.1 1.12 1.15 1.15 1.2 1.12 1.25 1.25 1.1 1.1 7 Box Price $ 1.33 $ 2.32 $ 3.06 $ 3.54 $ 3.57 $ 5.11 $ 3.62 $ 6.92 $ 9.23 $ 6.54 Packing & Loading 8 = 9 100 Lbs $ 6.31 $ 6.31 $ 7.36 $ 7.36 $ 7.36 $ 8.42 $ 10.52 $ 12.62 $ 26.30 $ 26.30 $ 26.30 10 11 Box Summary: 12 A D E F H 1 K R 13 Total Weight (lbs) 14 Total Volume (CF) 15 Recommended Truck Type: 16 Costs to ship: 17 18 Total customer costs: 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 packlist boxes ship handling + C8 fx 4505 A B D E F G 1 Shipping Costs - For Overland Truck 2 Miles: 435 Truck Volume Weight $/mi per Truck 3 Type Truck Description CF Lbs. Base ton Type 4 1 Small 350 1.85 1 5 2 Medium 1,700 20,000 650 1.25 2 6 3 Large 2,380 25,000 850 0.95 3 7 4 Extra Large 4,080 30,000 1,000 0.9 4 8 5 Double 4,505 48,000 1,200 0.8 5 9 6 need more trucks 4,950 55,000 6 10 11 Additional Info: 12 Cubic Inches per Cubic Foot 1,728 13 Lbs. per Ton 2,000 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 packlist boxes ship handling + D11 fx fi B D E F 1 Fragile Additional % Weight Cost 0 25% 20 30% 50 40% 4 B. 000 u wn 75 60% 100 125 100% 125% 150% 7.5% 9 150 10 High Value 11 Insurance 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 packlist boxes ship handling