Kindly, post a screenshot of your Lengo code and excel interface solution , STEP by STEP please.

ASAP

Lingo*

Each student is asked to formulate the LP program, provide a Lingo code (compact from), an Excel interface, and an optimal solution. A road transport company has 4 trucks to transport equipment needed to drill a series of wells in the Sahel. Here is the maximum tonnage of freight that each truck can carry. Truck 1 2 3 Maximal tonnage 2 3 6 7 4 The items to be transported were grouped in 7 containers. Below the weight in tons and the priority of routing for each container. Priority is indicated with a number, the larger the number the higher the priority. Container 1 2 3 4 5 6 7 Weight (t) 3 4 1 2 3 4 Priority 5 2 7 4 3 8 3 Find an optimal way to allocate the containers to the trucks so that the first convoy of the 4 trucks will bring to the field containers with the maximum sum of priorities