4) You have just been hired by JB in their transportation logistics department. Your job is to provide dispatching services for independent tnackers who specialize in transporting cars purchased online from the seller to the buyer. At present, there are four cars that need to be picked up and delivered and five trucks in the close vicinity of these cars. The following table summarizes the marginal costs of each truck picking up and delivering each of the cars along with the current number of available car carrying spots on each truck Cr1Car2 Car3Car4 Capacity Truck 1 276 $497 25 5364 2 cas Truck 2 179 $375 $298 $190 1 car Truck 3 150 475 344 $492 car Truck 497163 $285 185 1 car Truck5 305 150 5225 165 2cars JBHunt charges car buyer aflat fee of $600 to pick up and deliver each car and keeps SO% of the profit earned from each of the individual truackers a. Formulate the integer linear programming problem on a spreadsheet and solve it b. What is the optimal profit for JB Hunt? 4) You have just been hired by JB in their transportation logistics department. Your job is to provide dispatching services for independent tnackers who specialize in transporting cars purchased online from the seller to the buyer. At present, there are four cars that need to be picked up and delivered and five trucks in the close vicinity of these cars. The following table summarizes the marginal costs of each truck picking up and delivering each of the cars along with the current number of available car carrying spots on each truck Cr1Car2 Car3Car4 Capacity Truck 1 276 $497 25 5364 2 cas Truck 2 179 $375 $298 $190 1 car Truck 3 150 475 344 $492 car Truck 497163 $285 185 1 car Truck5 305 150 5225 165 2cars JBHunt charges car buyer aflat fee of $600 to pick up and deliver each car and keeps SO% of the profit earned from each of the individual truackers a. Formulate the integer linear programming problem on a spreadsheet and solve it b. What is the optimal profit for JB Hunt