Problem 4. You have been asked to replace the regular dispatcher who is out sick. Your company is located in Denton, TX and ships to three different customers on a regular basis. Depending on the volume shipped (CWT) and distance, your carrier assigns different rates. During the last 10 months, your firm has averaged the following orders and rates: Volumes in lbs Day One Chicago 29,560 Atlanta 24,220 Phoenix 15,000 Day Two 34,000 26,400 8,000 Rates per CWT Day One Chicago Atlanta Phoenix Day Three 45,000 20,000 23,450 Day Three Day Two $120.00 $ 130.00 $ $110.00 $ 92.00 $ 97.00 $ 131.00 $ $83.00 $ 85.00 $ 103.00 $ Day Four 1. What analysis would you perform and why? 29,560 24,220 15,000 Day Four Day Five 34,000 26,400 8,000 Day Five 145.00 $ 142.00 $ 124.00 $ Combined 172,120 121,240 69,450 Combined 128.00 120.00 107.00 141.00 $ 152.00 $ 136.00 $ Note: all rates are expressed in dollars per CWT. You need to convert the weight to CWT and determine the total cost. Distance has been previously factored into the rate per CWT. 2. What are the results of your analysis (show calculations to support)? 3. What would you recommend to your firm? Your customer? What actions could your firm and customer take to implement these recommendations