H19 > c w B D E G H Boxing Information & Pricing 2 Box Size A D F G H 1 K R 3 Length (IN) 18 24 18 20 24 24 48 36 36 48 Width (IN) 12 18 18 20 18 24 12 36 36 48 5 Height (IN) 12 12 18 20 18 24 12 48 60 6 6 Volume Usage 1.1 1.12 1.15 1.15 12 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 S 6.54 Packing & Loading B = 100 Lbs $ 6.31 $ 6.31 $ 7.36 $7.36 $ 8.42 $ 10.52 $ 12.62 $ 26.30 S 26.30 $ 26.30 10 11 Box Summary: 12 D E F G H R 13 Total Weight (lbs) 14 Total Volume (CF) 15 Recommended Truck Type: 16 Costs to ship: 17 18 Total customer cost 19 20 21 22 total 5. In cell boxes!B13, summarize total weight for all size A boxes. Write the formula so that it can be copled 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 6. In cell boxes1814 calculate the volume in cubic feet (CF) that will be required on the truck for all size A boxes. Remember that box sizes are given above in inches. This formula should work when copied across the row for each corresponding box size, and if the number of boxes for each size box varles Format decimals to match figure below For example - count the number of size A boxes and then multiply that number for the box dimensions in the above column. Then, divide that value by the conversion to cubic ft-located on the ship worksheet 00 B D E F G Packaging List Box High Packing & Handling 1 Item# Size Weight Fragile Value Loading Costs Surcharge 1 H 131 FALSE $ 16.24 $ 1.25$ 2 D 11 FALSE $ 8.23 $ 0.25 3 90 FALSE $ 6.46 $ 0.60 4 R 20 FALSE 3,500 $ 14.82 $ 0.30 7 5 A 99 FALSE $ 4.43 $ 0.60 8 6 A 12 FALSE $ 4.43 $ 0.25 9 7 F 39 TRUE $ 9.78$ 0.30 10 8 1 55 FALSE $ 22.44 $ 0.40 11 9 H 18 FALSE $ 11.90 $ 0.25 12 10 G 78 FALSE $ 13.39 $ 0.60 13 11 118 TRUE 1,500$ 33.22 $ 1.00 14 12. E 41 FALSE $ 8.71 $ 0.30 15 13 H 69 FALSE $ 11.90$ 0.40 16 14 D 105 FALSE $ 10.42 $ 1.00 17 15 1 64 FALSE $ 22.44 18 0.40 16 35 FALSE 5 8.71 $ 19 0.30 17 R 78 FALSE $ 14.82 $ 20 0.60 18 12 TRUE $ 9.785 21 19 0.25 D 78 TRUE s 8.235 22 0.60 20 1 67 FALSE $ 22.445 0.40 21 E 21 FALSE $ 24 8.71 22 F $ 0.40 10 FALSE $ 225 9.785 23 G 0.25 3 FALSE $ 26 24 13.395 0.25 E 45 TRUE 12,6505 27 8.715 25 K 0.30 122 FALSE $ 35.535 28 26 D 1.00 105 FALSE 5 10.425 1.00 pacist boxes handling shi H19 > c w B D E G H Boxing Information & Pricing 2 Box Size A D F G H 1 K R 3 Length (IN) 18 24 18 20 24 24 48 36 36 48 Width (IN) 12 18 18 20 18 24 12 36 36 48 5 Height (IN) 12 12 18 20 18 24 12 48 60 6 6 Volume Usage 1.1 1.12 1.15 1.15 12 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 S 6.54 Packing & Loading B = 100 Lbs $ 6.31 $ 6.31 $ 7.36 $7.36 $ 8.42 $ 10.52 $ 12.62 $ 26.30 S 26.30 $ 26.30 10 11 Box Summary: 12 D E F G H R 13 Total Weight (lbs) 14 Total Volume (CF) 15 Recommended Truck Type: 16 Costs to ship: 17 18 Total customer cost 19 20 21 22 total 5. In cell boxes!B13, summarize total weight for all size A boxes. Write the formula so that it can be copled 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 6. In cell boxes1814 calculate the volume in cubic feet (CF) that will be required on the truck for all size A boxes. Remember that box sizes are given above in inches. This formula should work when copied across the row for each corresponding box size, and if the number of boxes for each size box varles Format decimals to match figure below For example - count the number of size A boxes and then multiply that number for the box dimensions in the above column. Then, divide that value by the conversion to cubic ft-located on the ship worksheet 00 B D E F G Packaging List Box High Packing & Handling 1 Item# Size Weight Fragile Value Loading Costs Surcharge 1 H 131 FALSE $ 16.24 $ 1.25$ 2 D 11 FALSE $ 8.23 $ 0.25 3 90 FALSE $ 6.46 $ 0.60 4 R 20 FALSE 3,500 $ 14.82 $ 0.30 7 5 A 99 FALSE $ 4.43 $ 0.60 8 6 A 12 FALSE $ 4.43 $ 0.25 9 7 F 39 TRUE $ 9.78$ 0.30 10 8 1 55 FALSE $ 22.44 $ 0.40 11 9 H 18 FALSE $ 11.90 $ 0.25 12 10 G 78 FALSE $ 13.39 $ 0.60 13 11 118 TRUE 1,500$ 33.22 $ 1.00 14 12. E 41 FALSE $ 8.71 $ 0.30 15 13 H 69 FALSE $ 11.90$ 0.40 16 14 D 105 FALSE $ 10.42 $ 1.00 17 15 1 64 FALSE $ 22.44 18 0.40 16 35 FALSE 5 8.71 $ 19 0.30 17 R 78 FALSE $ 14.82 $ 20 0.60 18 12 TRUE $ 9.785 21 19 0.25 D 78 TRUE s 8.235 22 0.60 20 1 67 FALSE $ 22.445 0.40 21 E 21 FALSE $ 24 8.71 22 F $ 0.40 10 FALSE $ 225 9.785 23 G 0.25 3 FALSE $ 26 24 13.395 0.25 E 45 TRUE 12,6505 27 8.715 25 K 0.30 122 FALSE $ 35.535 28 26 D 1.00 105 FALSE 5 10.425 1.00 pacist boxes handling shi