1. Investigate how to model and optimise the fairness problem based on the data for one weeks load which is provided as an EXCEL spreadsheet in this assessment task. Please note that definition of fairness in your report must be reasonable although fairness is quite subjective.

2. Investigate how to model and optimise the carrier reduction problem.

Optimized Motor Carrier Selection at Westvaco Rate matrix 350 300 350 50 400 75 IRST 1.18 50 LAST 1.27 1.73 35 MRST 1.39 300 50 PSST 1.28 * 9 Carrier: Min charge per truckload: 350 Stop-off charge: 50 St Stops Miles ABCT MA 3 612 PA 190 MI 383 0.79 MN 3 600 1.24 PA 136 IL 570 0.87 Trips Monday Tuesday 1 7 3 1 17 15 Destination EVERETT EPHRATA RIVERVIEW ROSEVILLE HANOVER EFFINGHAM 1.71 1 1.25 0.96 NEST 1.35 1.82 0.95 1.41 2.26 0.90 3.42 1.01 1.13 4.78 14 Wednesday Thursday Friday 5 1 15 15 12 13 4 4 6 4 1 7 1.32 2.00 1.11 1.41 2.57 1.31 1 2 1.89 2.23 1.25 * 2.39 5 pa oo 4 0.87 0.87 5 9 Note: Asterisks (*) indicate carrier does not travel to the destination. Rates in $/mile. 20 20 20 20 20 20 Available Pulls: Commitment: Optimized Motor Carrier Selection at Westvaco Rate matrix 350 300 350 50 400 75 IRST 1.18 50 LAST 1.27 1.73 35 MRST 1.39 300 50 PSST 1.28 * 9 Carrier: Min charge per truckload: 350 Stop-off charge: 50 St Stops Miles ABCT MA 3 612 PA 190 MI 383 0.79 MN 3 600 1.24 PA 136 IL 570 0.87 Trips Monday Tuesday 1 7 3 1 17 15 Destination EVERETT EPHRATA RIVERVIEW ROSEVILLE HANOVER EFFINGHAM 1.71 1 1.25 0.96 NEST 1.35 1.82 0.95 1.41 2.26 0.90 3.42 1.01 1.13 4.78 14 Wednesday Thursday Friday 5 1 15 15 12 13 4 4 6 4 1 7 1.32 2.00 1.11 1.41 2.57 1.31 1 2 1.89 2.23 1.25 * 2.39 5 pa oo 4 0.87 0.87 5 9 Note: Asterisks (*) indicate carrier does not travel to the destination. Rates in $/mile. 20 20 20 20 20 20 Available Pulls: Commitment