How do I solve question#16 a. b. c. d. e. using the tables provided? please show answer using excel thank you

ITEM NUMBER DESCRIPTION LESS-THAN TRUCKLOAD MINIMUM WEIGHT, LB TRUCKLOAD 4745-00 100 70 20,000 4800 00 4800-01 85 55 24,000 4800-02 70 55 24,000 485000 60 35 40,000 4860-00 traveling bags, Gloves, Head Visors or Mats, cloth, printed with advertising, prepaid, in boxes Calendars, prepaid: Cloth, in packages; or steel, celluloid covered, in boxes Paper or pulpboard, in packages Catalogs, prepaid; or Catalog Parts or Sections, paper, prepaid; in packages Circulars, Books, Booklets, Leaflets, Pamphlets, Sheets or Price Lists Printed entirely on newsprint Not printed entirely on newsprint Displays, consisting of brick or tile facings, roofing, shingles, siding or tile; mounted on panels, prepaid, in boxes or crates Displays, dummy articles, such as imitation butter squares, fruits, vegetables or meats, prepaid, in boxes or crates Displays, Figures or Images, rubber, NOI, other than foam rubber, prepaid, in boxes or crates 60 486001 4860-02 35 30,000 77.5 55 24,000 4920-00 70 55 24,000 4960-00 100 70 20,000 4980-00 100 70 20,000 AQ refers to Any Quantity. Source: Adapted from Southern Motor Carriers' PC FastClass Software. ton. Transportation cost from the eastern mines is $3 per ton. What is the value of $17 per ton and in the East is $15 per transportation from the western mines? 15. Shipments for a certain product originate at point X and are to be sent to points Y and Z. Y is an intermediate point to X and Z. The rate to Y is $1.20 per cwt., but due to competitive conditions at Z, the rate to Z is $1.00 per cwt. Apply the principle of blan- keting back, and explain how it eliminates rate discrimination. 16. Using Tables 6-4, 6-5, and 6-6, determine the freight charges for the following shipments: a. A 2,500-lb shipment of paper place mats with printed advertising moving from New York to Los Angeles. b. A 150-lb shipment of rubber displays for advertising purposes moving from New York to Providence, RI. C. A 27,000-lb shipment of emery cloth in packages moving from Louisville, Kentucky, to Chicago, Illinois. Note: For any product classification number below 50, use 50 in Table 6-6. d. A 30,000-lb shipment of cat accessories at a density of 10 lb per cubic foot moving between Louisville, Kentucky, and Chicago, Illinois. e. A 24,000-lb shipment of advertising circulars not printed on newsprint moving between Louisville, Kentucky, and Chicago, Illinois. A rate discount of 40 percent is offered Chapter 6 Transport Fundamentals 217 Table 6-6 Selected Class Truck Rates in $ per cwt. by Classification Number and Weight- Break Quantity in lb for Shipments from Louisville, Kentucky, to Chicago, Illinois MCA $75.40 CLASS 1,000 2 2,000 25,000 > 10,000 220,000 2 30,000 > 40,000 500 165.39 132.31 99.26 82.70 59.51 54.44 28.67 28.67 28.67 400 139.03 111.22 83.43 69.51 50.03 24.10 24.10 24.10 300 45.76 36.68 110.26 88.21 66.17 55.13 19.11 19.11 19.11 250 39.68 34.50 76.70 57.54 31.56 16.62 95.88 79.10 16.62 39.55 39.55 200 63.28 16.62 13.71 47.47 28.46 26.04 13.71 175 69.51 55.61 41.72 13.71 12.05 34.76 25.01 22.88 12.05 12.05 150 62.32 49.86 37.40 31.16 22.43 20.51 10.80 10.80 10.80 125 42.19 26.37 18.98 17.36 52.73 52.34 9.14 9.14 9.14 110 40.27 31.65 30.21 28.77 25.17 18.11 16.57 8.73 8.73 8.73 100 47.94 17.25 15.78 8.31 38.35 36.43 5.69 4.37 23.97 22.77 92.5 45.54 27.33 16.39 14.99 7.89 5.41 4.15 85 42.19 33.75 25.32 21.09 15.18 7.31 5.01 3.85 77.5 39.79 13.89 13.10 19.90 6.90 4.72 31.83 29.91 3.63 23.88 22.44 70 14.32 13.46 37.39 18.70 12.31 6.48 4.44 65 35.48 28.38 21.29 3.41 3.23 12.77 11.68 6.15 4.21 17.74 17.02 60 34.04 27.23 20.43 12.25 11.20 5.90 4.04 3.10 55 32.60 26.08 19.56 16.30 11.73 10.73 5.65 3.87 2.97 50 31.16 24.93 18.70 15.58 11.21 10.26 5.40 3.70 2.84 MC = minimum charge in $ Source: Southern Motor Carriers' CZAR-LITE software. Table 6-4 National Motor Freight Classification for Selected Products ITEM LESS-THAN TRUCKLOAD MINIMUM WEIGHT, LB NUMBER TRUCKLOAD 1070-00 55 55 35 35 50,000 36,000 1090-00 2010-00 55 35 40,000 2030-00 55 40 30,000 2055-00 55 37.5 36,000 2070-00 DESCRIPTION ABRASIVES GROUP: Alundum, Corundum, Emery or other Natural or Synthetic Abrasive Material, consisting chiefly of aluminum oxide or silicon carbide: Crude or lump, LTL, in bags, barrels or boxes: TL, loose or in packages Flour or grain, in packages Refuse, including broken wheels, wheel stubs or wheel grindings, in packages; also TL, loose Wheels, pulp grinding, on skids or in boxes or crates Cloth or Paper, abrasive, including Emery Cloth or Paper or Sandpaper, in packages Accessories or Furniture, cat or dog, in boxes and having a density on pounds per cubic foot of: Less than 1 1 but less than 2 2 but less than 4 4 but less than 6 6 but less than 8 8 but less than 10 10 but less than 12 12 but less than 15 15 or greater ADVERTISING GROUP: Advertising Matter, NOI, prepaid, in packages Cloth or oilcloth Paper or paperboard, other corrugated or fluted Almanacs, prepaid, in packages AQ AQ 2070-01 2070-02 2070-03 2070-04 2070-05 2070-06 2070-07 2070-08 2070-09 400 300 250 150 125 100 92.5 85 70 400 300 250 100 85 70 65 55 40 AQ 12,000 15,000 18,000 20,000 26,000 36,000 85 55 24,000 4660-01 4660-02 70 40 30,000 4740-00 77.5 55 24,000 931 Table 6-5 Nondiscounted, Less-Than-Truckload Rates for Class 100 Product Moving From New York City, NY, to Selected Zip Sectional Centers ZIP LOCATION MIN. 1,000 2 2,000 25,000 > 10,000 220,000 2 30,000 > 40,000 500 165.39 132.31 99.26 82.70 59.51 54.44 28.67 28.67 28.67 400 139.03 111.22 83.43 69.51 50.03 24.10 24.10 24.10 300 45.76 36.68 110.26 88.21 66.17 55.13 19.11 19.11 19.11 250 39.68 34.50 76.70 57.54 31.56 16.62 95.88 79.10 16.62 39.55 39.55 200 63.28 16.62 13.71 47.47 28.46 26.04 13.71 175 69.51 55.61 41.72 13.71 12.05 34.76 25.01 22.88 12.05 12.05 150 62.32 49.86 37.40 31.16 22.43 20.51 10.80 10.80 10.80 125 42.19 26.37 18.98 17.36 52.73 52.34 9.14 9.14 9.14 110 40.27 31.65 30.21 28.77 25.17 18.11 16.57 8.73 8.73 8.73 100 47.94 17.25 15.78 8.31 38.35 36.43 5.69 4.37 23.97 22.77 92.5 45.54 27.33 16.39 14.99 7.89 5.41 4.15 85 42.19 33.75 25.32 21.09 15.18 7.31 5.01 3.85 77.5 39.79 13.89 13.10 19.90 6.90 4.72 31.83 29.91 3.63 23.88 22.44 70 14.32 13.46 37.39 18.70 12.31 6.48 4.44 65 35.48 28.38 21.29 3.41 3.23 12.77 11.68 6.15 4.21 17.74 17.02 60 34.04 27.23 20.43 12.25 11.20 5.90 4.04 3.10 55 32.60 26.08 19.56 16.30 11.73 10.73 5.65 3.87 2.97 50 31.16 24.93 18.70 15.58 11.21 10.26 5.40 3.70 2.84 MC = minimum charge in $ Source: Southern Motor Carriers' CZAR-LITE software. Table 6-4 National Motor Freight Classification for Selected Products ITEM LESS-THAN TRUCKLOAD MINIMUM WEIGHT, LB NUMBER TRUCKLOAD 1070-00 55 55 35 35 50,000 36,000 1090-00 2010-00 55 35 40,000 2030-00 55 40 30,000 2055-00 55 37.5 36,000 2070-00 DESCRIPTION ABRASIVES GROUP: Alundum, Corundum, Emery or other Natural or Synthetic Abrasive Material, consisting chiefly of aluminum oxide or silicon carbide: Crude or lump, LTL, in bags, barrels or boxes: TL, loose or in packages Flour or grain, in packages Refuse, including broken wheels, wheel stubs or wheel grindings, in packages; also TL, loose Wheels, pulp grinding, on skids or in boxes or crates Cloth or Paper, abrasive, including Emery Cloth or Paper or Sandpaper, in packages Accessories or Furniture, cat or dog, in boxes and having a density on pounds per cubic foot of: Less than 1 1 but less than 2 2 but less than 4 4 but less than 6 6 but less than 8 8 but less than 10 10 but less than 12 12 but less than 15 15 or greater ADVERTISING GROUP: Advertising Matter, NOI, prepaid, in packages Cloth or oilcloth Paper or paperboard, other corrugated or fluted Almanacs, prepaid, in packages AQ AQ 2070-01 2070-02 2070-03 2070-04 2070-05 2070-06 2070-07 2070-08 2070-09 400 300 250 150 125 100 92.5 85 70 400 300 250 100 85 70 65 55 40 AQ 12,000 15,000 18,000 20,000 26,000 36,000 85 55 24,000 4660-01 4660-02 70 40 30,000 4740-00 77.5 55 24,000 931 Table 6-5 Nondiscounted, Less-Than-Truckload Rates for Class 100 Product Moving From New York City, NY, to Selected Zip Sectional Centers ZIP LOCATION MIN.