Please help me how to solve this problem for computation and solution.

You are a transportation planner in McDuffy Logistics Services; your manager has just handed you a customer shipments file with 82 customer orders, you have to plan the loads to meet the customer required delivery dates (RDD). You are given information on the rates per 100km for both TL and LTL in the different lanes, North, South, East and West; you are also provided with weight and capacity limitations of TL, there are no limitations on LTL. You are to analyze the customer orders and decide the optimum use of TL and LTL and provide your manager with the load plan for all trips and the total cost for the transportation of the 82 customer orders. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 1 & Customer ID & Destination & Pallets & \begin{tabular}{c} Average \\ Pallet Weight \\ (lbs) \end{tabular} & \begin{tabular}{c} Required \\ Delivery Date \\ (RDD) \end{tabular} & & \\ \hline 2 & 100001 & Lethbridge & 4 & 1191 & 11/23/2023 & & \\ \hline 3 & 100003 & Edmonton & 1 & 1506 & 11/22/2023 & & \\ \hline 4 & 100003 & Vancouver & 6 & 1035 & 11/22/2023 & & \\ \hline 5 & 100007 & Vancouver & 12 & 1218 & 11/22/2023 & & \\ \hline 6 & 100012 & Regina & 5 & 982 & 11/20/2023 & & \\ \hline 7 & 100017 & Vancouver & 3 & 891 & 11/18/2023 & & \\ \hline 8 & 100021 & Vancouver & 6 & 1125 & 11/19/2023 & & \\ \hline 9 & 100022 & Red Deer & 4 & 856 & 11/22/2023 & & \\ \hline 10 & 100025 & Red Deer & 3 & 1543 & 11/23/2023 & & \\ \hline 11 & 100027 & Vancouver & 4 & 1977 & 11/21/2023 & & \\ \hline 12 & 100029 & Lethbridge & 3 & 1002 & 11/22/2023 & & \\ \hline 13 & 100029 & Lethbridge & 3 & 1107 & 11/18/2023 & & \\ \hline 14 & 100032 & Edmonton & 1 & 831 & 11/21/2023 & & \\ \hline 15 & 100034 & Lethbridge & 6 & 1273 & 11/18/2023 & & \\ \hline 16 & 100036 & Regina & 5 & 933 & 11/23/2023 & & \\ \hline 17 & 100039 & Vancouver & 3 & 861 & 11/22/2023 & & \\ \hline 18 & 100040 & Vancouver & 1 & 1151 & 11/18/2023 & & \\ \hline 19 & 100044 & Red Deer & 3 & 1700 & 11/23/2023 & & \\ \hline 20 & 100044 & Vancouver & 4 & 1035 & 11/23/2023 & & \\ \hline 21 & 100046 & Regina & 1 & 1800 & 11/23/2023 & & \\ \hline 22 & 100046 & Vancouver & 3 & 1555 & 11/19/2023 & & \\ \hline & > & \multicolumn{2}{|c|}{ Customer Shipments } & \multicolumn{2}{|c|}{ Student Solution } & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 38 & 100086 & Red Deer & 2 & 1426 & 11/21/2023 & & \\ \hline 39 & 100094 & Red Deer & 2 & 1131 & 11/20/2023 & & \\ \hline 40 & 100095 & Edmonton & 5 & 1895 & 11/20/2023 & & \\ \hline 41 & 100105 & Red Deer & 3 & 1868 & 11/21/2023 & & \\ \hline 42 & 100106 & Regina & 1 & 1234 & 11/18/2023 & & \\ \hline 43 & 100114 & Edmonton & 6 & 1221 & 11/18/2023 & & \\ \hline 44 & 100116 & Vancouver & 1 & 1170 & 11/18/2023 & & \\ \hline 45 & 100120 & Edmonton & 2 & 1006 & 11/21/2023 & & \\ \hline 46 & 100124 & Vancouver & 6 & 1611 & 11/21/2023 & & \\ \hline 47 & 100126 & Edmonton & 4 & 1943 & 11/22/2023 & & \\ \hline 48 & 100127 & Vancouver & 2 & 1996 & 11/19/2023 & & \\ \hline 49 & 100131 & Lethbridge & 5 & 1651 & 11/20/2023 & & \\ \hline 50 & 100132 & Vancouver & 4 & 844 & 11/19/2023 & & \\ \hline 51 & 100133 & Lethbridge & 3 & 1838 & 11/21/2023 & & \\ \hline 52 & 100139 & Edmonton & 2 & 1244 & 11/20/2023 & & \\ \hline 53 & 100142 & Vancouver & 1 & 1472 & 11/20/2023 & & \\ \hline 54 & 100143 & Edmonton & 4 & 1379 & 11/18/2023 & & \\ \hline 55 & 100146 & Edmonton & 3 & 1646 & 11/22/2023 & & \\ \hline 56 & 100146 & Edmonton & 4 & 1706 & 11/20/2023 & & \\ \hline 57 & 100146 & Regina & 2 & 821 & 11/20/2023 & & \\ \hline 58 & 100147 & Edmonton & 2 & 1261 & 11/22/2023 & & \\ \hline 59 & 100150 & Vancouver & 4 & 1774 & 11/23/2023 & & \\ \hline 60 & 100156 & Regina & 4 & 1675 & 11/18/2023 & & \\ \hline 61 & 100156 & Vancouver & 4 & 1876 & 11/19/2023 & & \\ \hline 3 & & \multicolumn{2}{|c|}{ Customer Shipments } & \multicolumn{2}{|c|}{ Student Solution } & \multicolumn{2}{|l|}{+} \\ \hline \end{tabular}