answer asap please

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 Amarillo 30,000 Del Rio 19,500 Houston 45,000 Day Two 28,000 25,000 50,000 Day Three 31,000 22,600 35,000 Combined 89,000 67,100 130,000 Rates per CWT Amarillo Del Rio Houston Day One Day Two Day Three Combined $ 110.00 $ 121.00 $ 105.00 $ 100.00 $ 125.00 $ 132.00 $ 115.00 $ 126.00 $ 90.00 $ 100.00 $ 102.00 $ 92.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. 1. What analysis would you perform and why? 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