A trucking company publishes the following rates: Shipment Weight Less than 500 lbs. 500-999 lbs. 1,000-4,999 lbs. 5,880-9,999 lbs. 10,000 lbs. or more Cost per 100 Pounds $20.00 $18.00 $15.50 $14.00 $13.00 DpictureClick here for the Excel Data File Suppose you have 12 shipments to make, each of which weighs 1,090 pounds. The carrier offers to consolidate them into one shipment of 13,080 pounds but will charge an additional $150 (total) to do so. a. Calculate the total cost with or without consolidated shipment charge. (Do not round Intermediate calculations. Round your answers to 2 decimal places.) Answer is complete but not entirely correct. Total cost using individual shipments Total cost using consolidated shipment s $ 20.46 % 1,853.00 X