Bad View Help Normal sto save Followed Hy... Data Review Formulas Explanatory ... Check Cell Insert General Page Layout Home 25 Wrap Text 400 11 A A Conditional Format as Calculation Formatting Table $ % 9 X Cut Calibri Styles A. Merge & Center este Ib Copy Format Painter BIU Number 5 Alignment V w Font U T Clipboard S R =N12/100 E16 M 20 N o P Q Product characteristics and services needed A B 0 D 500 M5C E F G H 1 J L 1000 2000 5000 10000 20000 30000 40000 MIM M2M MSM M10M M2OM M30M M40M Question Total CLASS MIN. L5C Weight, Discount, Fuel sur. To door White glove Ibs % charge, % delivery, $ delivery, $ 1000 0 10 0 Ol # Class # 1 55 0 0 500 2 10 5000 50 110 O O 0 3 250 200 0 10 400 300 4 0 175 0 150 40 10 250 Task Calculate the total charges for products of the given classes and weghts, including surcharges, using the given rate table on the left 5 0 77 900 10 0 0 6 700 77 0 150 70 10 7 85 7500 50 10 100 0 8 85 9500 50 10 100 0 7 200 8 175 9 150 10 125 11 110 12 100 13 92 9 55 43000 85 10 0 172.2 172.2 172.2 172.2 1100.7 524.1 482.3 377.3 309.3 241 114.4 114.4 248.1 193.3 139.7 114.4 882.92 420.4 386.9 228 665.18 316.8 291.5 228 186.9 145.6 106.5 92.79 92.79 92.79 556.29 264.9 243.8 190.7 156.3 121.888.94 74.26 74.26 74.26 447.43 213.1 196.1 153.4 125.7 97.96 72.34 66.79 61.23 61.23 391.29 186.3 171.5 134.1 110 85.67 63.26 61.18 59.19 59.19 346.84 160.4 147.6 115.5 94.66 73.74 55.11 52.21 48.12 43.69 295.88 134.5 123.8 96.81 79.35 61.82 46.34 40.17 39.12 37.02 262.02 119.1 109.6 85.72 70.27 54.75 43.84 37.22 33.46 31.12 240.59 109.4 100.6 78.73 64.54 50.28 42.28 34.45 31.33 29.98 224.55 102.1 93.94 73.48 60.24 46.93 39.46 32.15 30.33 28.33 213.26 94.78 87.22 68.24 55.94 43.57 36.64 30.72 29.17 26.79 201.23 87.49 80.51 62.99 51.63 40.23 33.83 28.83 25.42 23.22 186.34 81.02 74.55 58.32 47.81 37.25 31.32 27.45 24.01 20.94 182.76 76.15 70.08 54.81 44.95 35.01 29.44 25.98 22.76 19.92 173.06 72.11 66.35 51.91 42.54 33.14 27.87 24.14 20.93 18.64 166.72 68.05 62.62 48.99 40.15 31.28 26.3 21.32 19.12 17.36 158.58 63.2 58.16 45.49 37.29 29.05 24.42 19.78 17.28 16.06 O 10 92 1700 50 10 100 0 14 85 15 77 16 70 17 65 18 60 19 55 11 (bonus) any any any any any any formula It is possible to create a universal formula, albeit it a very complex one, that will calcualte the rates for any combination of weights, class Question #11 requires advanced analytical (spreadsheet modeling) and Excel skills. Attempt it only if you have them. Question 11 is worth 100 points. When ready, simply email me your spreadsheet. Your formula for this question should provide correct answers for the previous 10 questions simply when copied and pasted in those cells without any changes to the formula. You can create additional columns in the spreadsheet if it helps but you cannot make changes within the rate table. 20 50 21 991.44 122 23 24 25 26 27 28 29 30 31 32 33 34