* AutoSave Off) H . = CSE 2111 Pre Lab 5 Express Mover Master . Saved to this PC V Search File Home Insert Page Layout Formulas Data Review View Automate Help & Cut Calibri |11 - A" A " ab Wrap Text General Comma#fKk... Currency#In... Paste LB Copy Merge & Center % 2 70 20 Conditional Format as Normal#Nus... Percent#AXI... nsert Delete Fo Format Painter BIULA Formatting Table Clipboard Font Alignment Number Styles Cells B14 : X V fx =(COUNTIF(packlist!$83:$8225, "A")*B3*B4*B5)/ship!$D$12 A B K M N O P Q R S Boxing Information & Pricing Box Size A C D E G H K R Length (IN) 18 24 18 20 24 24 48 36 36 48 GUA W N Width (IN 12 18 18 20 18 24 12 36 36 48 Height (IN) 12 12 18 20 18 24 12 48 60 6 Volume Usage 1.1 1.12 1.15 1.15 1.2 1.12 1.25 1.25 1.1 1.1 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 =100 Lbs $ 6.31 $ 6.31 $ 7.36 $ 8.42 $ 10.52 $ 12.62 $ 26.30 $ 26.30 $ 26.30 10 11 Box Summary: 12 A C D G H K R total 13 Total Weight (Lbs) 1112 2061 1853 2258 1245 2229 1827 2247 1292 1372 14 Total Volume (CF) 22.5 15 Recommended Truck Type: 16 Costs to ship: 17 18 Total customer costs: 19 20 21 22 23 24 26 34 > packlist boxes ship handling + Ready Accessibility: InvestigateX AutoSave ( Off) H - CSE 2111 Pre Lab 5 Express Mover Master . Saved to this PC v Search File Home Insert Page Layout Formulas Data Review View Automate Help & Cu Calibri 11 - A A 29 Wrap Text Accounting Paste [B Copy * E Merge & Center $ % 00 :98 Conditional Forma Format Painter Formatting * Table Clipboard Font Alignment Number F3 vixfx =SUM(HLOOKUP(B3, boxes!$8$2:$K$9, 6, 0)+IF(C3=100, HLOOKUP(B3, boxes!$B A B C D G M N Packaging List Box High Packing & Handling Total Packing & 2 Item# Size Weight Fragile Value Loading Costs Surcharge Loading Costs H 131 FALSE 6.24 $ S 16.24 N N D 11 FALSE 8.23 $ 8.23 C 90 FALSE 6.46 $ 6.46 4 R 20 FALSE 14.82 $ 262.50 277.32 A 99 FALSE 4.43 $ 4.43 6 A 12 FALSE 4.43 $ 4.43 F 39 TRUE 9.78 $ 2.93 12.71 10 8 55 FALSE 22.44 $ 22.44 H 18 FALSE 11.90 $ 11.90 G 78 FALSE 13.39 $ 13.39 118 TRUE 1,500 33.22 $ 145.72 178.94 E FALSE 8.71 $ 8.71 H 9 FALSE 11.90 $ 11.90 D 105 FALSE 10.42 $ 10.42 FALSE 22.44 $ 22.44 E FALSE 8.71 $ 8.71 R 78 FALSE 14.82 $ 14.82 F TRUE 9.78 $ 2.45 2.23 D TRUE 8.23 $ 1.94 13.17 FALSE 22.44 $ 22.44 E 71 FALSE 8.71 $ 8.71 F 10 FALSE 9.78 $ 9.78 G FALSE 13.39 $ 13.39 E TRUE 12,650 8.71 $ 951.36 960.07 K 122 FALSE 35.53 $ 35.53 D 105 FALSE 10.42 $ 10.42 H 91 FALSE 11.90 $ 11.90 C 33 FALSE 6.46 $ 6.46 C 119 FALSE 8.63 $ 3.63 A FALSE 7.64 $ 7.64 67 TRUE 6.46 $ 2.58 9.04 135 FALSE 3.22 $ 33.22 52 TRUE 6,450 6.46 $ 486.33 492.79 36 1461 TRUE 33.27 $ 41.53 74.75 packlist boxes ship handling + Ready Accessibility: InvestigateAutoSave Off 1 1 . . CSE 2111 Pre Lab 5 Express Mover Master . Saved to this PC v File Home Insert Page Layout Formulas Data Review View Automate Help X Cut Calibri 11 - A A E ap Wrap Text Paste LG Copy B E Merge & Center Format Painter Clipboard Font Alignment D12 vi X fx 1728 A B C D E F G H K H Shipping Costs - For Overland Truck 2 Miles: 435 Truck Volume| Weight $/mi per Truck Type Truck Description CF Lbs. Base ton Type 1 Small 350 1.85 2 Medium 1,700 20,000 650 1.25 3 Large 2,380 25,000 850 0.95 4 Extra Large 4,080 30,000 1,000 0.9 5 Double 4,505 48,000 1,200 0.8 LD CO 6 need more trucks 4,950 55,000 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 23 24 25 29 30 31 32 33 34 35 26