Question: 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

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 Day Two Chicago 29,560 34,000 Atlanta 24,220 26,400 Phoenix 15,000 8,000 Day Three 45,000 20,000 23,450 Day Four 29,560 24,220 15,000 Day Five 34,000 26,400 8,000 Combined 172, 120 121,240 69,450 Rates per CWT Day One Day Two Day Three Day Four Day Five Combined Chicago $110.00 $ 120.00 $ 130.00 $ 145.00 $ 141.00 $ 128.00 Atlanta $ 92.00 $ 97.00 $ 131.00 $ 142.00 $ 152.00 $ 120.00 Phoenix $ 83.00 $ 85.00 $ 103.00 $ 124.00 $ 136.00 $ 107.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? 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 Day Two Chicago 29,560 34,000 Atlanta 24,220 26,400 Phoenix 15,000 8,000 Day Three 45,000 20,000 23,450 Day Four 29,560 24,220 15,000 Day Five 34,000 26,400 8,000 Combined 172, 120 121,240 69,450 Rates per CWT Day One Day Two Day Three Day Four Day Five Combined Chicago $110.00 $ 120.00 $ 130.00 $ 145.00 $ 141.00 $ 128.00 Atlanta $ 92.00 $ 97.00 $ 131.00 $ 142.00 $ 152.00 $ 120.00 Phoenix $ 83.00 $ 85.00 $ 103.00 $ 124.00 $ 136.00 $ 107.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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
