Please explain, I'm so lost!

Determine the Packaging and Loading costs in cell packlist! F3. a) 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) b) 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) c) 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 d) 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. e) In cell boxes! B13, summarize total weight for all size A boxes. Write the formula so that it can be copied across the row for each corresponding box size. These formulas should automatically update if any of the individual weights are updated on the packaging list. Again format your values in a consistent manner to the data on sheet packlist www w fx F3 G A C B D E Packaging List 1 Handling Total Packing & High Packing & Item# Box Size Loading Costs Value Surcharge 2 Weight Fragile Loading Costs 131 3 1 H FALSE FALSE 4 2 11 90 FALSE 3 C 4 R 20 FALSE 3,500 FALSE 7 99 6 A 12 FALSE 9 7 39 TRUE 55 FALSE 10 FALSE 11 9 H 18 G 12 10 78 FALSE 118 13 11 TRUE 1,500 E 14 12 41 FALSE 15 13 H 69 FALSE D 16 14 105 FALSE 17 15 | 64 FALSE 35 FALSE 18 16 E FALSE 19 17 78 10 11 TRUE packlist boxes ship handling fx H19 J A B G H E L Boxing Information & Pricing 1 Box Size E H 2 A C G R Length (IN) Width (IN) 18 24 18 20 24 24 48 36 36 48 12 18 18 20 18 24 12 36 36 48 4 Height (IN) 12 12 18 20 18 24 12 48 60 6 5 Volume Usage 1.1 1.12 1.15 1.15 1.2 1.12 1.25 1.25 1.1 1.1 2.32$ 3.06 $ $ $ $ $ $ Price 1.33 3.54 3.57 5.11 3.62 6.92 9.23 6.54 7 Packing & Loading 5.17$ 4.14 $ 5.17$ $15.52$ $ $ $ $ $ = 100 Lbs 10 x Summary: 11 total 12 D F 13 Total Weight (Lbs) 14 Total Volume (CF) 15 Recommended Truck Type: 16 Costs to ship: 17 18 Total customer costs: packlist boxes ship handling + fx 4505 8 A C E Shipping Costs - For Overland Truck 1 2 Miles: 435 $/mi per Truck Truck Volume Weight Truck Description 3 ton Lbs. CF Base 1 Small 4 350 1.85 1 2 Medium 650 20,000 5 1,700 1.25 2 3 Large 850 2,380 25,000 6 0.95 4 Extra Large 1,000 0.9 7 4,080 30,000 4 5 Double 4,505 48,000 1,200 0.8 6 need more trucks 6 4,950 55,000 10 Additional Info: 11 Cubic Inches per Cubic Foot 1,728 12 Lbs. per Ton 2,000 13 11 packlist boxes ship handling X fx D11 A B Fragile 1 Additional % Cost Weight 2 3 0 25% 30% 4 20 50 5 40% 60% 6 75 100 7 100% 8 125 125% 150% 150 10 High Value 11 Insurance 7.5% 12 handling packlist boxes ship Determine the Packaging and Loading costs in cell packlist! F3. a) 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) b) 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) c) 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 d) 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. e) In cell boxes! B13, summarize total weight for all size A boxes. Write the formula so that it can be copied across the row for each corresponding box size. These formulas should automatically update if any of the individual weights are updated on the packaging list. Again format your values in a consistent manner to the data on sheet packlist www w fx F3 G A C B D E Packaging List 1 Handling Total Packing & High Packing & Item# Box Size Loading Costs Value Surcharge 2 Weight Fragile Loading Costs 131 3 1 H FALSE FALSE 4 2 11 90 FALSE 3 C 4 R 20 FALSE 3,500 FALSE 7 99 6 A 12 FALSE 9 7 39 TRUE 55 FALSE 10 FALSE 11 9 H 18 G 12 10 78 FALSE 118 13 11 TRUE 1,500 E 14 12 41 FALSE 15 13 H 69 FALSE D 16 14 105 FALSE 17 15 | 64 FALSE 35 FALSE 18 16 E FALSE 19 17 78 10 11 TRUE packlist boxes ship handling fx H19 J A B G H E L Boxing Information & Pricing 1 Box Size E H 2 A C G R Length (IN) Width (IN) 18 24 18 20 24 24 48 36 36 48 12 18 18 20 18 24 12 36 36 48 4 Height (IN) 12 12 18 20 18 24 12 48 60 6 5 Volume Usage 1.1 1.12 1.15 1.15 1.2 1.12 1.25 1.25 1.1 1.1 2.32$ 3.06 $ $ $ $ $ $ Price 1.33 3.54 3.57 5.11 3.62 6.92 9.23 6.54 7 Packing & Loading 5.17$ 4.14 $ 5.17$ $15.52$ $ $ $ $ $ = 100 Lbs 10 x Summary: 11 total 12 D F 13 Total Weight (Lbs) 14 Total Volume (CF) 15 Recommended Truck Type: 16 Costs to ship: 17 18 Total customer costs: packlist boxes ship handling + fx 4505 8 A C E Shipping Costs - For Overland Truck 1 2 Miles: 435 $/mi per Truck Truck Volume Weight Truck Description 3 ton Lbs. CF Base 1 Small 4 350 1.85 1 2 Medium 650 20,000 5 1,700 1.25 2 3 Large 850 2,380 25,000 6 0.95 4 Extra Large 1,000 0.9 7 4,080 30,000 4 5 Double 4,505 48,000 1,200 0.8 6 need more trucks 6 4,950 55,000 10 Additional Info: 11 Cubic Inches per Cubic Foot 1,728 12 Lbs. per Ton 2,000 13 11 packlist boxes ship handling X fx D11 A B Fragile 1 Additional % Cost Weight 2 3 0 25% 30% 4 20 50 5 40% 60% 6 75 100 7 100% 8 125 125% 150% 150 10 High Value 11 Insurance 7.5% 12 handling packlist boxes ship